How to separate comma separated values in R in a new row?

by

You could try cSplit from my “splitstackshape” package:

library(splitstackshape)
cSplit(as.data.table(mydf)[, col2 := gsub("[][\"]", "", col2)], 
       "col2", ",", "long")
#    col1 col2
# 1:    a    1
# 2:    a    2
# 3:    a    3
# 4:    b    1
# 5:    b    2
# 6:    c    4

Of course, I’m highly partial to cSplit, but you can also use “dplyr” and unnest from “tidyr”:

library(dplyr)
library(tidyr)

mydf %>%
  mutate(col2 = strsplit(gsub("[][\"]", "", col2), ",")) %>%
  unnest(col2)

Or just with “data.table”:

library(data.table)
as.data.table(mydf)[, list(
  col2 = unlist(strsplit(gsub("[][\"]", "", col2), ","))), 
  by = col1]

More Related Contents:

  1. How to increase the size of points in legend of ggplot2? [duplicate]
  2. Convert a data frame to a data.table without copy
  3. Creating a named list from two vectors (names, values)
  4. suppress console output in r markdown, but keep plot
  5. Asymmetric expansion of ggplot axis limits
  6. Add row in each group using dplyr and add_row()
  7. How to adjust facet size manually
  8. R: why kable doesn’t print inside a for loop?
  9. How to add shaded confidence intervals to line plot with specified values
  10. as.Date(as.POSIXct()) gives the wrong date?
  11. Convert scientific notation to numeric, preserving decimals
  12. How do I close unused connections after read_html in R
  13. list of masked functions in R
  14. Using R convert data.frame to simple vector
  15. different colors for each bar in stacked bar graph – base graphics
  16. consolidating data frames in R
  17. How to calculate adjacency matrices in R
  18. Removing Unused Factors from a Facet in ggplot2
  19. R programming: cache the inverse of a matrix
  20. R: How to split a data frame into training, validation, and test sets?
  21. Match legend text color in geom_text to symbol [duplicate]
  22. find all functions (including private) in a package
  23. Difference between r-base and r-recommended packages
  24. Create a time interval of 15 minutes from minutely data in R?
  25. Rcpp function check if missing value
  26. What is the first column in R’s mtcars dataset?
  27. Multiply columns in a data frame by a vector
  28. R – What algorithm does geom_density() use and how to extract points/equation of curves?
  29. Fill option for fread
  30. Give name to list variable

Leave a Comment