How to merge all data frames of Global Environment with characters in R?

Question

I have 48 data frames in my global environment, and I would like to merge them accordingly to column 1 (of each one). All data frames have only 1 column and are in this style:

df1 <- data.frame("Genes" = c("EGF", "FGF", "IGF"))

df2 <- data.frame("Genes" = c("Myo6", "NRP2", "P23"))

I tried converting them into a list, but then, what I wanted to merge was level 2 of each one so it turned complicated.

Expected final result:

df3 <- data.frame("Genes" = c("EGF", "FGF", "IGF", "Myo6", "NRP2", "P23"))

If anyone could help, it'd be wonderful Thanks

akrun · Accepted Answer · 2020-05-18T23:02:02.447

1

Here, is one option with mget to load all the object with names that start with 'ZEB' followed by digits into a list, unlist the list and create the data.frame

out <- data.frame(Genes = unlist(unname(mget(ls(pattern = '^ZEB[1-2]')))))

edited May 18 '20 at 23:02

answered May 18 '20 at 22:28

akrun

874,273
37
540
662

The problem, then, is that every data frame has a different name (not like just differing on numbers like df1, df2, df3...) – Nuno Ramalho May 18 '20 at 22:47
@NunoRamalho is there any patterns? – akrun May 18 '20 at 22:48
@NunoRamalho updated the post – akrun May 18 '20 at 22:50
for example, "ZEB1_common_30genes_all_datasets", "ZEB1_MARY_JOHN_positive", "ZEB2_common_60genes_all_datasets", and so on... the pattern is the "ZEB1" or "ZEB2", always. – Nuno Ramalho May 18 '20 at 22:51
@NunoRamalho if you check my update that should cover – akrun May 18 '20 at 22:51
This error appears ---- Error in names(i1)[i1] : invalid subscript type 'list' while runing the ```lst1 <- mget(names(i1)[i1])````code – Nuno Ramalho May 18 '20 at 22:56
@NunoRamalho I also changed the initial code. Please check that – akrun May 18 '20 at 22:57
1

Thank you! You saved me – Nuno Ramalho May 18 '20 at 23:01

How to merge all data frames of Global Environment with characters in R?

1 Answers1