(一)直接点题
利用drop_duplicates()与转置矩阵的做法
drop_duplicates()是删除重复行
(二) 代码即图片说明
df1 = pd.DataFrame({'name':['张三','李四','王五','张三'],'age':[18,19,20,18]})
df2 = pd.DataFrame({'name':['张三','李四','王五','张三'],'id':[300,260,280,300]})
df3 = pd.concat([df1,df2],axis=1) #concat无how
# print(df1)
# print(df2)
# print(df3)
# print(df3.drop_duplicates())
# print(df3.drop_duplicates().T)
# print(df3.drop_duplicates().T.drop_duplicates())
df4 = df3.drop_duplicates().T.drop_duplicates().T
print(df4)
df1 df2 df3
------------------------------------------------------------------------------------------------------------------------------------------------------------
df3.drop_duplicates() df3.drop_duplicates() .T
------------------------------------------------------------------------------------------------------------------------------------------------------------
df3.drop_duplicates() .T.drop_duplicates() df3.drop_duplicates() .T.drop_duplicates().T