#表的纵向拼接
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()
d