python_8.2_表格拼接

#表的纵向拼接

import pandas as pd
df1 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data12.xlsx",sheet_name = "Sheet1")
df2 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data12.xlsx",sheet_name = "Sheet2")
df3 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data12.xlsx",sheet_name = "Sheet3")
df1 = df1.set_index("编号")
df2 = df2.set_index("编号")
df1

df2

pd.concat([df1,df2])

 

#因为合并后编号作为索引值看着很不舒服，所以就设置成原始的索引，忽略掉编号

pd.concat([df1,df2],ignore_index = True)

#重复值的处理和前面一样，直接用drop_duplicates()即可

df3 = pd.concat([df1,df2],ignore_index = True).drop_duplicates()
df3

df3.to_excel(ex