How to merge 10 DF with the same names of columns?

tidyverse
1

Hi community
Im want merge 10 DF that have the sames order and names columns. The idea is merge by columns in a DF.

Im use merge but in want make all data frames for the same time. Because merge make for 2 DF each time.

dfull<- merge(df1, df2, all = TRUE)

d1<- structure(list(GNUMBER = c("G20559", "G23416", "G23417", "G23417A", 
"G23417B", "G23418", "G23489", "G50896", "G50897", "G50898"), 
    ORIGEN = structure(c(4L, 4L, 4L, 4L, 4L, 4L, 4L, 4L, 4L, 
    4L), levels = c("ARG", "BOL", "COL", "CRI", "ECU", "GTM", 
    "HND", "MEX", "PER", "SLV"), class = "factor"), DI_LATITUD = c(9.56, 
    9.82, 9.82, 9.82, 9.82, 9.87, 9.87, 10.11, 10.17, 9.82), 
    DI_LONGITUD = c(-84.05, -84.12, -84.12, -84.12, -84.12, -84.12, 
    -84.12, -84.17, -84.39, -84.06), DI_ALTURA = c("1171", "1750", 
    "1750", "1750", "1750", "1560", "1560", "1510", "1610", "1540"
    ), DI_ALTURA_NEW = c(897, 1613, 1613, 1613, 1613, 1677, 1677, 
    1681, 1661, 1609), DIF_LONGITUD = c(0.03, 0, 0, 0, 0, 0, 
    0, 0, 0.01, 0.01), DIF_LATITUD = c(0.37, 0, 0, 0, 0, 0, 0, 
    0.01, 0, 0)), row.names = c(329L, 365L, 366L, 367L, 368L, 
369L, 540L, 1380L, 1381L, 1382L), class = "data.frame")

d2<-structure(list(GNUMBER = c("G 7253B", "G21113", "G21115", "G21116", 
"G21117", "G21118", "G22303", "G22304", "G22304A", "G22304B"), 
    ORIGEN = structure(c(3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 
    3L), levels = c("ARG", "BOL", "COL", "CRI", "ECU", "GTM", 
    "HND", "MEX", "PER", "SLV"), class = "factor"), DI_LATITUD = c(2.68, 
    4.49, 4.54, 4.99, 4.66, 5, 4.57, 4.49, 4.49, 4.49), DI_LONGITUD = c(-75.99, 
    -73.94, -73.93, -73.54, -74.39, -73.54, -73.9, -73.94, -73.94, 
    -73.94), DI_ALTURA = c("1560", "1900", "1800", "1600", "1560", 
    "1900", "1900", "1750", "1750", "1750"), DI_ALTURA_NEW = c(1666, 
    1928, 2226, 1649, 1510, 1615, 2073, 1928, 1928, 1928), DIF_LONGITUD = c(0.01, 
    0.01, 0.01, 0.01, 0.01, 0.01, 0.02, 0.01, 0.01, 0.01), DIF_LATITUD = c(0.01, 
    0.01, 0.01, 0.03, 0.01, 0.02, 0.04, 0.01, 0.01, 0.01)), row.names = c(6L, 
330L, 331L, 332L, 333L, 334L, 346L, 347L, 348L, 349L), class = "data.frame")

d3<-structure(list(GNUMBER = c("G 7225", "G 7225A", "G19504", "G19504A", 
"G19575", "G19603", "G19605", "G19605A", "G19605B", "G19605C"
), ORIGEN = structure(c(9L, 9L, 9L, 9L, 9L, 9L, 9L, 9L, 9L, 9L
), levels = c("ARG", "BOL", "COL", "CRI", "ECU", "GTM", "HND", 
"MEX", "PER", "SLV"), class = "factor"), DI_LATITUD = c(-13.67, 
-13.67, -6.54, -6.54, -6.37, -6.27, -6.27, -6.27, -6.27, -6.27
), DI_LONGITUD = c(-72.89, -72.89, -78.69, -78.69, -78.75, -78.52, 
-78.52, -78.52, -78.52, -78.52), DI_ALTURA = c("2300", "2300", 
"2140", "2140", "2000", "1850", "1850", "1850", "1850", "1850"
), DI_ALTURA_NEW = c(3024, 3024, 2242, 2242, 2393, 1500, 1500, 
1500, 1500, 1500), GEN_LATITUD = c(-13.67, -13.67, -6.53, -6.53, 
-6.37, -6.27, -6.27, -6.27, -6.27, -6.27), GEN_LONGITUD = c(-72.88, 
-72.88, -78.68, -78.68, -78.75, -78.52, -78.52, -78.52, -78.52, 
-78.52), GEN_ALTURA = c(2300, 2300, 2140, 2140, 2000, 1850, 1850, 
1850, 1850, 1850), ID_MG.y = c(6, 7, 481, 482, 483, 484, 485, 
486, 487, 488), DI_TOTAL_COORD = c("-72.89_-13.67", "-72.89_-13.67", 
"-78.69_-6.54", "-78.69_-6.54", "-78.75_-6.37", "-78.52_-6.27", 
"-78.52_-6.27", "-78.52_-6.27", "-78.52_-6.27", "-78.52_-6.27"
), GEN_TOTAL_COORD = c("-72.88_-13.67", "-72.88_-13.67", "-78.68_-6.53", 
"-78.68_-6.53", "-78.75_-6.37", "-78.52_-6.27", "-78.52_-6.27", 
"-78.52_-6.27", "-78.52_-6.27", "-78.52_-6.27"), FINAL_LONGITUD = c("different", 
"different", "different", "different", "same", "same", "same", 
"same", "same", "same"), FINAL_LATITUD = c("same", "same", "different", 
"different", "same", "same", "same", "same", "same", "same"), 
    FINAL_TOTAL_COORD = c("different", "different", "different", 
    "different", "same", "same", "same", "same", "same", "same"
    ), DIF_LONGITUD = c(0.01, 0.01, 0.01, 0.01, 0, 0, 0, 0, 0, 
    0), DIF_LATITUD = c(0, 0, 0.01, 0.01, 0, 0, 0, 0, 0, 0)), row.names = c(4L, 
5L, 287L, 288L, 289L, 290L, 291L, 292L, 293L, 294L), class = "data.frame")

Tnks!

2

Would dplyr::bind_rows(d1, d2, d3) work?

1 Like
3

Work very well! :muscle: Is the things that I need.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.