python pandas读取excle并保存代码示例
import pandas as pd
import os
os.chdir(r"C:\Users\ZT\Desktop")
# date = pd.read_excel(r"无标题.xlsx",sheet_name='Sheet1')[['作者','点击量','PC收录','M收录']]
date = pd.read_excel(r"无标题.xlsx",sheet_name='Sheet1')
# result = date.pivot_table('作者',index=['点击量','PC收录','M收录'],columns='标题',aggfunc='count',margins=True)
result = date.pivot_table(['点击量','PC收录','M收录'],index=['作者'],aggfunc='sum',margins=True)
# result.to_excel(r'结果.xlsx',index=True,sheet_name='演出汇总')
# result.to_excel(r'结果.xlsx',index=True,sheet_name='景区汇总')
# 上面是保存一个sheet表,下面是保存多个sheet表
with pd.ExcelWriter(r'结果.xlsx') as writer:
result.to_excel(writer,sheet_name='演出汇总')
result.to_excel(writer,sheet_name='景区汇总')