Split comma-separated strings in a column into separate rows

by

Several alternatives:

1) two ways with data.table:

library(data.table)
# method 1 (preferred)
setDT(v)[, lapply(.SD, function(x) unlist(tstrsplit(x, ",", fixed=TRUE))), by = AB
         ][!is.na(director)]
# method 2
setDT(v)[, strsplit(as.character(director), ",", fixed=TRUE), by = .(AB, director)
         ][,.(director = V1, AB)]

2) a dplyr / tidyr combination:

library(dplyr)
library(tidyr)
v %>% 
  mutate(director = strsplit(as.character(director), ",")) %>%
  unnest(director)

3) with tidyr only: With tidyr 0.5.0 (and later), you can also just use separate_rows:

separate_rows(v, director, sep = ",")

You can use the convert = TRUE parameter to automatically convert numbers into numeric columns.

4) with base R:

# if 'director' is a character-column:
stack(setNames(strsplit(df$director,','), df$AB))

# if 'director' is a factor-column:
stack(setNames(strsplit(as.character(df$director),','), df$AB))

More Related Contents:

  1. Split data frame string column into multiple columns
  2. How to split a data frame?
  3. Concatenate a vector of strings/character
  4. How to remove all whitespace from a string?
  5. Test if characters are in a string
  6. R split string by symbol
  7. Split a string every 5 characters
  8. Split a string column into several dummy variables
  9. Reshaping data.frame from wide to long format
  10. Order discrete x scale by frequency/value
  11. Why is `[` better than `subset`?
  12. Convert continuous numeric values to discrete categories defined by intervals
  13. Count number of rows per group and add result to original data frame
  14. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  15. How to use a variable to specify column name in ggplot
  16. Selecting data frame rows based on partial string match in a column
  17. Determine path of the executing script
  18. How to split data into training/testing sets using sample function
  19. Reshape multiple value columns to wide format
  20. How to generate permutations or combinations of object in R?
  21. Numeric comparison difficulty in R
  22. Remove duplicated rows
  23. Combine two or more columns in a dataframe into a new column with a new name
  24. How to split a string into substrings of a given length? [duplicate]
  25. How to plot a function curve in R
  26. dplyr: inner_join with a partial string match
  27. Index values from a matrix using row, col indices
  28. Display exact value of a variable in R
  29. R split numeric vector at position
  30. Raw text strings for file paths in R

Leave a Comment