24 python pandas保存中文以及合并等操作

# -*- coding: utf-8 -*-
import pandas as pd
#中文读
cans = pd.read_excel('1.xlsx',encoding="gbk")

out_can = cans.iloc[0].to_frame().reset_index()

for i in range(len(cans)-1):
    can2 = cans.iloc[i]
    df2= can2.to_frame().reset_index()
    #第一种合并，取了一行
    out_can = out_can.merge(df2)
#转置一下
df3 = out_can.T
#中文写
df3.to_csv('111.csv',index=False,encoding="gbk")

#俩张表合并
pd.merge(pd.merge(pd.merge(pd.merge(pd.merge(df11,df12,how='outer'),df13,how='outer'),df14,how='outer'),df15,how='outer'),df16,how='outer')