Dummify character column and find unique values [duplicate]

by

I’d use splitstackshape and mtabulate from qdapTools packages to get this as a one liner,
i.e.

library(splitstackshape)
library(qdapTools)

mtabulate(as.data.frame(t(cSplit(test, 'col', sep = ';', 'wide'))))
#   a cc ff rr e
#V1 1  1  1  1 0
#V2 1  1  0  1 1

It can also be full splitstackshape as @A5C1D2H2I1M1N2O1R2T1 mentions in comments,

cSplit_e(test, "col", ";", mode = "binary", type = "character", fill = 0)

More Related Contents:

  1. How to force R to use a specified factor level as reference in a regression?
  2. Creating dummy variables in R data.table
  3. Split a string column into several dummy variables
  4. How can I find compound words, removing spaces between them and replace them in my corpus?
  5. Faster ways to calculate frequencies and cast from long to wide
  6. How can I remove all duplicates so that NONE are left in a data frame?
  7. strptime, as.POSIXct and as.Date return unexpected NA
  8. How to delete a row by reference in data.table?
  9. How to replace NA with mean by group / subset?
  10. How to remove outliers from a dataset
  11. Remove NA values from a vector
  12. Omit rows containing specific column of NA
  13. Alignment of numbers on the individual bars
  14. Replace values in a vector based on another vector
  15. Sort a data.table fast by Ascending/Descending order
  16. Join R data.tables where key values are not exactly equal–combine rows with closest times
  17. ggplot2: Adding secondary transformed x-axis on top of plot
  18. Reasons that ggplot2 legend does not appear [duplicate]
  19. How to convert integer into categorical data in R?
  20. set ggplot plots to have same x-axis width and same space between dot plot rows
  21. lapply-ing with the “$” function
  22. How to change the first row to be the header in R?
  23. Insert a logo in upper right corner of R markdown pdf document
  24. How to replace NA (missing values) in a data frame with neighbouring values
  25. Stop lapply from printing to console
  26. R how can I calculate difference between rows in a data frame
  27. Preserve proportion of graphs using grid.arrange
  28. Process substitution
  29. adding x and y axis labels in ggplot2
  30. Display HTML file in Shiny App

Leave a Comment