python合并多个excel-创新互联

import pandas as pd

#合并多个excel的第一个子表
df=pd.read_excel(r"C:\Users\Administrator\Desktop\20210430-0630.xlsx",sheet_name=0)
df1=pd.read_excel(r"C:\Users\Administrator\Desktop\202107-09.xlsx",sheet_name=0)
df2=pd.read_excel(r"C:\Users\Administrator\Desktop\202110-12.xlsx",sheet_name=0)
df3=pd.read_excel(r"C:\Users\Administrator\Desktop\202201-03.xlsx",sheet_name=0)
df4=pd.read_excel(r"C:\Users\Administrator\Desktop\202204.xlsx",sheet_name=0)
df00=df.append(df1).append(df2).append(df3).append(df4)
df00.to_excel(r"C:\Users\Administrator\Desktop\20210430-20220429.xlsx","汇总表",index=0)

#合并同一EXCEL的多个子表
df=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=0)
df1=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=1)
df2=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=2)
df3=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=3)
df4=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=4)
df5=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=5)
df6=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=6)
df00=df.append(df1).append(df2).append(df3).append(df4).append(df5).append(df6)
df00.to_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测1.xlsx","总表")

你是否还在寻找稳定的海外服务器提供商？创新互联www.cdcxhl.cn海外机房具备T级流量清洗系统配攻击溯源，准确流量调度确保服务器高可用性，企业级服务器适合批量采购，新人活动首月15元起，快前往官网查看详情吧