0

i have a dataframe with :

name ; ind_id ; location 
JAMES BRON ; FR6667 ; French
JAMES BAZD ; FR7266 ; ENGLISH
BROZ DAVID ; EN6766 ; ENGLISH
ALAN ;       ; FRENCH

and i have

FirstName ; LastName ; id 
JAMES  ;  BRON ; FR6667
JAMES ; BAZD  ; FR7266

i want to have (merge two dataframe on ind_id et id : we start with the first dataframe and if we find the same ind_id in the second we merge the row of second dataframe on first datframe ) :

name ; ind_id ; location    ; FirstName ; LastName
JAMES BRON ; FR6667 ; French ; JAMES ; BRON
JAMES BAZD ; FR7266 ; ENGLISH ; JAMES ; BAZD 
BROZ DAVID ; EN6766 ; ENGLISH ;     ;
ALAN ;       ; FRENCH ;        ; 

0 Answers0