import pandas as pdimport osimport openpyxlfrom pandas import read_csvpath=r"F:\***\***\***\***"#文件路径pathDir = os.listdir(path)for f in pathDir:data = pd.read_csv(os.path.join(path, f))#data = read_csv(f)file_name = os.path.basename(f)file_name2 = file_name.split('.')[0]#data.to_excel('test.xlsx')data.to_excel(r"F:\***\***\***\****\%s.xlsx" % file_name2,encoding='utf_8_sig')print('ok')
如果openpyxl报错,则安装包。