Split a column of concatenated comma-delimited data and recode output as factors

by

A long time later, I finally got around to creating a package (“splitstackshape”) that deals with this kind of data in an efficient manner. So, for the convenience of others (and some self-promotion, of course) here’s a compact solution.

The relevant function for this problem is cSplit_e.

First, the default settings, which retains the original column and uses NA as the fill:

library(splitstackshape)
cSplit_e(data, "V1")
#           V1 V1_1 V1_2 V1_3 V1_4 V1_5
# 1    1, 2, 3    1    1    1   NA   NA
# 2    1, 2, 4    1    1   NA    1   NA
# 3 2, 3, 4, 5   NA    1    1    1    1
# 4    1, 3, 4    1   NA    1    1   NA
# 5    1, 3, 5    1   NA    1   NA    1
# 6 2, 3, 4, 5   NA    1    1    1    1

Second, with dropping the original column and using 0 as the fill.

cSplit_e(data, "V1", drop = TRUE, fill = 0)
#   V1_1 V1_2 V1_3 V1_4 V1_5
# 1    1    1    1    0    0
# 2    1    1    0    1    0
# 3    0    1    1    1    1
# 4    1    0    1    1    0
# 5    1    0    1    0    1
# 6    0    1    1    1    1

More Related Contents:

  1. Split comma-separated strings in a column into separate rows
  2. Split data frame string column into multiple columns
  3. How to split a data frame?
  4. How to split data into training/testing sets using sample function
  5. Split string column to create new binary columns
  6. Calculate the mean of every 13 rows in data frame
  7. Split character column into several binary (0/1) columns
  8. Split date-time column into Date and time variables
  9. Splitting a continuous variable into equal sized groups
  10. Split dataframe into multiple output files
  11. Split data.frame by value
  12. First entry from string split
  13. How subset a data frame by a factor and repeat a plot for each subset?
  14. Splitting a string into new rows in R [duplicate]
  15. R semicolon delimited a column into rows
  16. Splitting a large data frame into smaller segments
  17. How does cut with breaks work in R
  18. Split Data Frame into Rows of Fixed Size
  19. What is the algorithm behind R core’s `split` function?
  20. Split up a dataframe by number of rows
  21. Emulate split() with dplyr group_by: return a list of data frames
  22. R split numeric vector at position
  23. R split string by symbol
  24. R strsplit with multiple unordered split arguments?
  25. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  26. Apply a ggplot-function per group with dplyr and set title per group
  27. Split a string every 5 characters
  28. R divide data into groups
  29. Split a column by group [duplicate]
  30. Split a string column into several dummy variables

Leave a Comment