E
How do you feel like this?import pandas as pd
df1 = pd.DataFrame([["Jack","Male","USA",20,"mucsician","rock","movie"],
["Mary","Female","Canada","game",24,"unemployed","None"],
["Marco",25,"Italy","designer","fashion","tennis","None"],
["Isabel","Female","France",24,"shopping","actress","None"]])
df2 = pd.DataFrame([["Jack","Male","USA",20,"mucsician"],
["Mary","Female","Canada",24,"unemployed"],
["Marco","None","Italy",25,"designer"],
["Isabel","Female","France",24,"actress"]])
ret = pd.concat([df2, df1], axis=1).apply(lambda d: d.drop_duplicates().reset_index(drop=True), axis=1)
print(ret)
0 1 2 3 4 5 6
0 Jack Male USA 20 mucsician rock movie
1 Mary Female Canada 24 unemployed game None
2 Marco None Italy 25 designer fashion tennis
3 Isabel Female France 24 actress shopping None