0

i have 2 dataframe I have to concatenate them by checking two conditions

they must have the same id and id1

first dataframe

index     id     id1    name       sexe      age
0         30     AA     momo        M         21
1         31     AA     soso        M         25
2         32     AA     momo        M         18
3         30     BB     LOLO        M         20
4         31     BB     toto        F         20

second dataframe

index     id     id1    note      
0         30     AA      18
1         31     AA      20
2         32     AA      11
3         30     BB       0
4         31    BB       0

Ihave to check if they have the same id1 and id

final dataframe

index     id     id1    name       sexe      age      note
0         30     AA     momo        M         21       18
1         31     AA     soso        M         25       20 
2         32     AA     momo        M         18       11
3         30     BB     LOLO        M         20        0
4         31     BB     toto        F         20        0

id is not unique how can i do that ,i find a duplication problem if i convert id1 to index

MoMo
  • 107
  • 5

0 Answers0