[Gretl-users] Merging data frames with different number of rows without repeated ID

Dear Gretl community *, * I have two datasets A and B. Both A and B have different variables but with common variable i.e. ID. I want to merge these two data sets using ID as the common variable as given below : data set C. Thanking you in advanceI would be thankful for providing the solution. Note: A : Household data and B members data. Dhanasekaran K Merging data frames with different number of rows <https://community.rstudio.com/t/merging-data-frames-with-different-number... <https://community.rstudio.com/c/tidyverse/6>data set:A *ID* *x1* *x2* *x3* 1 50 2 1 2 60 5 3 3 30 6 5 4 20 9 6 5 90 7 9 data set:B *ID* *x4* *x5* 1 5 male 1 4 female 1 3 male 2 2 male 2 5 female 3 6 male 3 1 female 3 8 female 4 2 male 5 3 female 5 10 male merged data set: C ID x1 x2 x3 x4.1 x4.2 x4.3 x5.1 x5.2 x5.3 1 50 2 1 5 4 3 male female male 2 60 5 3 2 5 NA male female NA 3 30 6 5 6 1 8 male female female 4 20 9 6 2 NA NA male NA NA 5 90 7 9 3 10 NA female male NA