how merge 2 column and seperate them by ,?

Question

I wanna merge the following columns

output:

score 1 · Accepted Answer · answered Jul 29 '19 at 15:22

1

We can use paste

with(df1, paste(p, t, sep=","))

Or with unite

library(dplyr)
unite(df1, m, p, t, sep=",")

answered Jul 29 '19 at 15:22

akrun

how we can separate a column with 4,3 entries to 2 columns ? opposite of my question! – Jul 29 '19 at 15:42
1

@user9272398. You can use `separate(df1, m, c('p', 't'), sep=",")` – akrun Jul 29 '19 at 15:45

score 1 · Answer 2 · answered Jul 29 '19 at 15:25

1

Akrun's solution is excellent but I also like to do it with data.table if you're are using this package.

library(data.table)
dt <- as.data.table(dt)
dt <- dt[, m := paste0(p, ",", t)][,c(3)]

Output :

     m
1: 1,2
2: 3,4
3: 2,5

answered Jul 29 '19 at 15:25

Gainz

2 Answers2