(pandas)dataframe合并、插入列、导出
#并集合并,根据“姓名”列取两表所有列数据
df=pd.merge(df,df1,on="姓名",how="outer")
#交集合并,根据“姓名”列取两表有相同列名的数据
df=pd.merge(df,df1,on="姓名",how="inner")
#插入列,在第二列插入"年龄"列
df.insert(1,"年龄",[123,23,56,89])
#单表导出
df.to_excel("单表导出.xls",index=False)
#多表导出
with pd.ExcelWriter('多表导出.xls') as writer:
df1.to_excel(writer, sheet_name='Sheet_name_1',index=False)
df2.to_excel(writer, sheet_name='Sheet_name_2',index=False)
#追加导出
with pd.ExcelWriter('output.xlsx',mode='a') as writer:
df3.to_excel(writer, sheet_name='Sheet_name_3',index=False)