How to union 2 columns in R

Question

I have two tables and I need to union 2 columns in 1. Each column from a different table. I'd like to create a new table with column z where I will have every value from x & y with dublicates. Can you guys help me with that?

id x 
1  p
2  e
3  p 


id y
1  e
2 
3  e

Can you please include the expected output (in data form) given these two tables? — r2evans, May 08 '21 at 17:17
I'd like to have one table z with all the vaules -> p,e,p,e,e etc. I need to count how many is vaule 'e' vs 'p' — Angelo, May 08 '21 at 17:33
If you want to count occurrences, how about `table(c(df1$x, df2$y))`? — r2evans, May 08 '21 at 18:10

TarJae · Answer 1 · 2021-05-08T18:16:52.717

2

Are you looking for such a solution: here is an example step by step:

table1 <- tibble(id = c(1,2,3),
                 x= c("p", "e", "p"))
table1

table2 <- tibble(id = c(1,2,3),
                 x= c("e", NA, "e"))
table2

table3 <- bind_rows(table1, table2)
table3$z <- table3$x
table3 <- table3[,3]
table3

Output:

  z    
  <chr>
1 p    
2 e    
3 p    
4 e    
5 NA   
6 e

edited May 08 '21 at 18:16

answered May 08 '21 at 18:11

TarJae

72,363
6
19
66

Doesn't really work ;/ I have already some data in those 2 column are the same but columns' names are different – Angelo May 09 '21 at 10:36

score 2 · Answer 2 · answered May 08 '21 at 18:11

2

We can also use rbindlist

library(data.table)
rbindlist(list(table1, table2))

answered May 08 '21 at 18:11

akrun

874,273
37
540
662

score 1 · Answer 3 · answered May 08 '21 at 20:47

1

A base R option

> list2DF(Map(c, df1, df2))
  id    x
1  1    p
2  2    e
3  3    p
4  1    e
5  2 <NA>
6  3    e

answered May 08 '21 at 20:47

ThomasIsCoding

96,636
9
24
81

How to union 2 columns in R

3 Answers3