1、pandas数据读取输出

数据读取函数图例

实例：多sheet的excel读取与保存

import pandas as pd
writer = pd.ExcelWriter(r'C:\Users\xyy\Desktop\city_id_io9xlsx',engine='openpyxl')
io = pd.io.excel.ExcelFile(r'C:\Users\xyy\Desktop\city_id.xlsx')
print(io.sheet_names) #查看sheet列表
#多sheet循环读取并保存
num = 1
for i in io.sheet_names:
    data = pd.read_excel(io,sheet_name=i,index=False)
    print('sheet: '+i)
    print(data.head())
    data.to_excel(writer,sheet_name=i,index=False)
    print('sheet',i,'导出成功！',num,r'/',len(io.sheet_names))
    num = num + 1
writer.save()
writer.close()
io.close()

runfile('C:/Users/xyy/.spyder-py3/temp.py', wdir='C:/Users/xyy/.spyder-py3')
['a', 'b']
sheet: a
   id name
0   1   济南
1   2   贵阳
2   3   黔南
3   4  六盘水
4   5   南昌
sheet a 导出成功！ 1 / 2
sheet: b
   id
0   1
1   2
2   3
3   4
4   5
sheet b 导出成功！ 2 / 2