利用pandas创建excel文档
初始数据
import pandas as pd
pop = {'Nevada':{2001:2.4,2002:2.9},'Ohio':{2000:1.5,2001:1.7,2002:3.6}}
frame1 = pd.DataFrame(pop)
frame1
结果如下:
Nevada | Ohio | |
---|---|---|
2001 | 2.4 | 1.7 |
2002 | 2.9 | 3.6 |
2000 | NaN | 1.5 |
索引列命名:
frame1.index.name = 'year'
frame1
year | Nevada | Ohio |
---|---|---|
2001 | 2.4 | 1.7 |
2002 | 2.9 | 3.6 |
2000 | NaN | 1.5 |
保存为excel表格
frame1.to_excel(r'D:/python/learn/indexTest.xlsx',sheet_name='sheet1')
多sheet存储 :
再创建一个DataFrame
frame2 = pd.DataFrame(pop).T
利用pandas库中的ExcelWriter方法创建包含多个sheet的xlsx文件:
with pd.ExcelWriter(r'D:/python/learn/indexTest1.xlsx') as writer:
frame1.to_excel(writer,sheet_name = 'frame1')
frame2.to_excel(writer,sheet_name = 'frame2')