Split a column into multiple binary dummy columns [duplicate]

by

We can use mtabulate from qdapTools after splitting (strsplit(..) the ‘features’ column.

library(qdapTools)
cbind(sampledf[1],mtabulate(strsplit(as.character(sampledf$features), ':')))
#  vin f1 f2 f3 f4 f5
#1  v1  1  1  1  0  0
#2  v2  0  1  0  1  1
#3  v3  1  0  0  1  1

Or we can use cSplit_e from library(splitstackshape)

library(splitstackshape)
df1 <- cSplit_e(sampledf, 'features', ':', type="character", fill=0, drop=TRUE)
names(df1) <-  sub('.*_', '', names(df1))

Or using base R methods, we split as before, set the names of the list elements from the strsplit with ‘vin’ column, convert to a key/value columns ‘data.frame’ using stack, get the table, transpose and cbind with the first column of ‘sampledf’.

cbind(sampledf[1],  
 t(table(stack(setNames(strsplit(as.character(sampledf$features), ':'), 
              sampledf$vin)))))

More Related Contents:

  1. Count number of rows within each group
  2. Drop unused factor levels in a subsetted data frame
  3. Why is it not advisable to use attach() in R, and what should I use instead?
  4. Create an empty data.frame
  5. Create a group number for each consecutive sequence
  6. Subset data frame based on multiple conditions [duplicate]
  7. R – Concatenate two dataframes?
  8. Remove columns with zero values from a dataframe
  9. How to convert dataframe into time series?
  10. Merge unequal dataframes and replace missing rows with 0
  11. What can R do about a messy data format?
  12. Removing display of row names from data frame
  13. How to delete rows from a data.frame, based on an external list, using R?
  14. Return a data frame from function
  15. Split one row into multiple rows [duplicate]
  16. Converting a list of data frames into individual data frames in R [duplicate]
  17. Shift values in single column of dataframe up
  18. Last Observation Carried Forward In a data frame? [duplicate]
  19. finding close match from data frame 1 in data fame 2
  20. Combine several data frames in the global environment by row (rbind)
  21. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  22. Extract text after “/” in a data frame column
  23. use multiple columns as variables with sapply
  24. Deleting specific rows from a data frame
  25. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  26. Count number of non-NA values for every column in a dataframe [duplicate]
  27. Undefined columns selected when subsetting data frame
  28. How to create a new variable in a data.frame based on a condition?
  29. Data.frame Merge and Selection of values which are common in 2 Data.frames
  30. Interpolating timeseries

Leave a Comment