To not miss a post like this, sign up for my newsletter to learn computational biology and bioinformatics.
The problem df<- data.frame(id = c(1,2,3), value = c('x,y', 'z,w', 'a')) df #> id value #> 1 1 x,y #> 2 2 z,w #> 3 3 a we want to put x,y in the first row into two rows:
1, x
1, y
and put z,w into two rows too.
solution with R There is a neat function separate_rows that does exactly this in tidyr package: