I want to merge two different tables in R but it doesn’t work with merge, it exceeds 10GB, what can I do about it
The names of the tables and the information in them are different
Table 1 shows humans and their proteins
Table 2 shows chimpanzees and their proteins
I want to combine these 2 tables and get a table with a total of 4 columns
the codes I tried:
a <- table 1
b <- table 2 ## human and chimpanzee information in table 2
c <- table 3
d <- merge(a,b , by.x = 13 , by.y = 1)
x <- d %>%
select(c(1,15))
h <- merge(c,b , by.x = 9 , by.y = 2)
z <- h %>%
select(c(1,11))
z1 <- unique(z)
x1 <- unique(x)
p <- merge(x1,z1)
x1
z1
I tried merging and I tried cbind cods
merge
cbind
New contributor
user25354006 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2