import pandas as pd
a = ['a','b','c']
b = [1,2,3]
dit = {'char':a, 'num':b}
file_path = r'./output.xlsx'
writer = pd.ExcelWriter(file_path)
df = pd.DataFrame(dit)
#columns参数用于指定生成的excel中列的顺序
df.to_excel(writer, columns=['char','num'], index=False,encoding='utf-8',sheet_name='Sheet')
writer.save()
#生成csv文件
df.to_csv(r'./1.csv',columns=['char','num'],index=False,sep=',')
pandas 生成excel 和 csv
最新推荐文章于 2024-05-09 08:24:02 发布