Split character column into several binary (0/1) columns

by

You can try cSplit_e from my “splitstackshape” package:

library(splitstackshape)
a <- c("a,b,c", "a,b", "a,b,c,d")
cSplit_e(as.data.table(a), "a", ",", type = "character", fill = 0)
#          a a_a a_b a_c a_d
# 1:   a,b,c   1   1   1   0
# 2:     a,b   1   1   0   0
# 3: a,b,c,d   1   1   1   1
cSplit_e(as.data.table(a), "a", ",", type = "character", fill = 0, drop = TRUE)
#    a_a a_b a_c a_d
# 1:   1   1   1   0
# 2:   1   1   0   0
# 3:   1   1   1   1

There’s also mtabulate from “qdapTools”:

library(qdapTools)
mtabulate(strsplit(a, ","))
#   a b c d
# 1 1 1 1 0
# 2 1 1 0 0
# 3 1 1 1 1

A very direct base R approach is to use table along with stack and strsplit:

table(rev(stack(setNames(strsplit(a, ",", TRUE), seq_along(a)))))
#    values
# ind a b c d
#   1 1 1 1 0
#   2 1 1 0 0
#   3 1 1 1 1

More Related Contents:

  1. Split comma-separated strings in a column into separate rows
  2. How to split a data frame?
  3. How to split data into training/testing sets using sample function
  4. Split a large dataframe into a list of data frames based on common value in column
  5. Split string column to create new binary columns
  6. Calculate the mean of every 13 rows in data frame
  7. Splitting a dataframe string column into multiple different columns [duplicate]
  8. Split dataframe into multiple output files
  9. Split data.frame by value
  10. First entry from string split
  11. How subset a data frame by a factor and repeat a plot for each subset?
  12. Splitting a file name into name,extension
  13. Splitting a string into new rows in R [duplicate]
  14. R semicolon delimited a column into rows
  15. Splitting a large data frame into smaller segments
  16. How does cut with breaks work in R
  17. Split Data Frame into Rows of Fixed Size
  18. What is the algorithm behind R core’s `split` function?
  19. Split up a dataframe by number of rows
  20. Emulate split() with dplyr group_by: return a list of data frames
  21. R split numeric vector at position
  22. Split a column of concatenated comma-delimited data and recode output as factors
  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