Split column at delimiter in data frame [duplicate]

by

@Taesung Shin is right, but then just some more magic to make it into a data.frame.
I added a “x|y” line to avoid ambiguities:

df <- data.frame(ID=11:13, FOO=c('a|b','b|c','x|y'))
foo <- data.frame(do.call('rbind', strsplit(as.character(df$FOO),'|',fixed=TRUE)))

Or, if you want to replace the columns in the existing data.frame:

within(df, FOO<-data.frame(do.call('rbind', strsplit(as.character(FOO), '|', fixed=TRUE))))

Which produces:

  ID FOO.X1 FOO.X2
1 11      a      b
2 12      b      c
3 13      x      y

More Related Contents:

  1. Dynamically select data frame columns using $ and a character value
  2. Simultaneously merge multiple data.frames in a list
  3. Count number of rows within each group
  4. Drop unused factor levels in a subsetted data frame
  5. count number of rows in a data frame in R based on group [duplicate]
  6. Dictionary style replace multiple items
  7. How to plot all the columns of a data frame in R
  8. Select rows with min value by group
  9. Shifting non-NA cells to the left
  10. Omit rows containing specific column of NA
  11. Repeat rows of a data.frame N times
  12. For each row in an R dataframe
  13. How to add a cumulative column to an R dataframe using dplyr?
  14. Get last row of each group in R [duplicate]
  15. Same function over multiple data frames in R
  16. Create empty data frame with column names by assigning a string vector? [duplicate]
  17. Dataframe create new column based on other columns
  18. What is about the first column in R’s dataset mtcars?
  19. Last Observation Carried Forward In a data frame? [duplicate]
  20. finding close match from data frame 1 in data fame 2
  21. Combine several data frames in the global environment by row (rbind)
  22. What is difference between dataframe and list in R?
  23. Define dimensions of an empty dataframe
  24. Merge overlapping ranges into unique groups, in dataframe
  25. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  26. Count unique values for every column
  27. Numbers as column names of data frames
  28. Divide each value by the sum of values by group
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment