0

I want to merge the 4 tables df.geo, df.educations, df.caracteristiques, df.groupes.age with my main table df.estimation.all by left join at the same time. I want to use the merge function.

Here,my code when I did it step by step I got duplicated columns

df1 <- merge(df.estimations.all, df.geo, by.x="Geo_id",by.y="ID")

df2 <- merge(df1, df.caracteristiques, by.x="caracteristique_id",by.y="ID")

df3 <- merge(df2, df.education, by.x="education_id",by.y="ID")

df4 <- merge(df3, df.groupes.ages, by.x="groupe_age_id",by.y="ID")
neuron
  • 1,775
  • 1
  • 11
  • 24
p1077092
  • 1
  • 2
  • Does [this](https://stackoverflow.com/questions/8091303/simultaneously-merge-multiple-data-frames-in-a-list) help? – tauft Nov 30 '21 at 04:18

0 Answers0