本文共 928 字,大约阅读时间需要 3 分钟。
(一)直接点题
利用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().Tprint(df4)
df1 df2 df3
------------------------------------------------------------------------------------------------------------------------------------------------------------
df3.drop_duplicates() df3.drop_duplicates() .T
------------------------------------------------------------------------------------------------------------------------------------------------------------
df3.drop_duplicates() .T.drop_duplicates() df3.drop_duplicates() .T.drop_duplicates().T
转载地址:http://mdwsi.baihongyu.com/