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 ; ;