R semicolon delimited a column into rows

by

Here is a base R solution. Split the PolId field using strplit and for each such split field cbind it with the corresponding Description. This gives a list of matrices which we rbind together. Finally set the column names.

out <- do.call(rbind, Map(cbind, strsplit(DF$PolId, ";"), DF$Description))
colnames(out) <- colnames(DF)

giving:

> out
      PolId    Description
 [1,] "ABC123" "TEST1"    
 [2,] "ABC456" "TEST1"    
 [3,] "ABC789" "TEST1"    
 [4,] "ABC123" "TEST1"    
 [5,] "ABC456" "TEST1"    
 [6,] "ABC789" "TEST1"    
 [7,] "ABC123" "TEST1"    
 [8,] "ABC456" "TEST1"    
 [9,] "ABC789" "TEST1"    
[10,] "AAA123" "TEST1"    
[11,] "AAA123" "TEST2"    
[12,] "ABB123" "TEST3"    
[13,] "ABC123" "TEST3"    
[14,] "ABB123" "TEST3"    
[15,] "ABC123" "TEST3"

Note: We used this as the input:

DF <-
structure(list(PolId = c("ABC123;ABC456;ABC789;", "ABC123;ABC456;ABC789;", 
"ABC123;ABC456;ABC789;", "AAA123;", "AAA123;", "ABB123;ABC123;", 
"ABB123;ABC123;"), Description = c("TEST1", "TEST1", "TEST1", 
"TEST1", "TEST2", "TEST3", "TEST3")), .Names = c("PolId", "Description"
), class = "data.frame", row.names = c(NA, -7L))

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 a large dataframe into a list of data frames based on common value in column
  6. Split string column to create new binary columns
  7. Calculate the mean of every 13 rows in data frame
  8. Splitting a dataframe string column into multiple different columns [duplicate]
  9. Convert column with pipe delimited data into dummy variables [duplicate]
  10. Split date-time column into Date and time variables
  11. Splitting a continuous variable into equal sized groups
  12. Split dataframe into multiple output files
  13. Split data.frame by value
  14. First entry from string split
  15. How subset a data frame by a factor and repeat a plot for each subset?
  16. Splitting a file name into name,extension
  17. Splitting a string into new rows in R [duplicate]
  18. Splitting a large data frame into smaller segments
  19. How does cut with breaks work in R
  20. Split Data Frame into Rows of Fixed Size
  21. What is the algorithm behind R core’s `split` function?
  22. Emulate split() with dplyr group_by: return a list of data frames
  23. R split numeric vector at position
  24. Split a column of concatenated comma-delimited data and recode output as factors
  25. R strsplit with multiple unordered split arguments?
  26. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  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