Splitting a dataframe string column into multiple different columns [duplicate]

by

A very direct way is to just use read.table on your character vector:

> read.table(text = text, sep = ".", colClasses = "character")
   V1 V2  V3  V4
1   F US CLE V13
2   F US CA6 U13
3   F US CA6 U13
4   F US CA6 U13
5   F US CA6 U13
6   F US CA6 U13
7   F US CA6 U13
8   F US CA6 U13
9   F US  DL U13
10  F US  DL U13
11  F US  DL U13
12  F US  DL Z13
13  F US  DL Z13

colClasses needs to be specified, otherwise F gets converted to FALSE (which is something I need to fix in “splitstackshape”, otherwise I would have recommended that 🙂 )

Update (> a year later)…

Alternatively, you can use my cSplit function, like this:

cSplit(as.data.table(text), "text", ".")
#     text_1 text_2 text_3 text_4
#  1:      F     US    CLE    V13
#  2:      F     US    CA6    U13
#  3:      F     US    CA6    U13
#  4:      F     US    CA6    U13
#  5:      F     US    CA6    U13
#  6:      F     US    CA6    U13
#  7:      F     US    CA6    U13
#  8:      F     US    CA6    U13
#  9:      F     US     DL    U13
# 10:      F     US     DL    U13
# 11:      F     US     DL    U13
# 12:      F     US     DL    Z13
# 13:      F     US     DL    Z13

Or, separate from “tidyr”, like this:

library(dplyr)
library(tidyr)

as.data.frame(text) %>% separate(text, into = paste("V", 1:4, sep = "_"))
#    V_1 V_2 V_3 V_4
# 1    F  US CLE V13
# 2    F  US CA6 U13
# 3    F  US CA6 U13
# 4    F  US CA6 U13
# 5    F  US CA6 U13
# 6    F  US CA6 U13
# 7    F  US CA6 U13
# 8    F  US CA6 U13
# 9    F  US  DL U13
# 10   F  US  DL U13
# 11   F  US  DL U13
# 12   F  US  DL Z13
# 13   F  US  DL Z13

More Related Contents:

  1. Split data frame string column into multiple columns
  2. How to split a data frame?
  3. Split a large dataframe into a list of data frames based on common value in column
  4. Calculate the mean of every 13 rows in data frame
  5. Split dataframe into multiple output files
  6. Split data.frame by value
  7. Splitting a string into new rows in R [duplicate]
  8. Splitting a large data frame into smaller segments
  9. Split Data Frame into Rows of Fixed Size
  10. Split up a dataframe by number of rows
  11. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  12. Split a column by group [duplicate]
  13. Select the row with the maximum value in each group
  14. Extracting specific columns from a data frame
  15. Find indices of duplicated rows [duplicate]
  16. How to drop columns by name in a data frame
  17. Rename multiple columns by names
  18. Call apply-like function on each row of dataframe with multiple arguments from each row
  19. Converting a data frame to xts
  20. Interpolate NA values in a data frame with na.approx
  21. How to subset data in R without losing NA rows?
  22. How to delete columns that contain ONLY NAs?
  23. Using grep to help subset a data frame
  24. How to sort a data frame by date
  25. Randomly insert NAs into dataframe proportionaly
  26. R: Split unbalanced list in data.frame column
  27. Should I use a data.frame or a matrix?
  28. Apply a ggplot-function per group with dplyr and set title per group
  29. Undefined columns selected when subsetting data frame
  30. Data.frame Merge and Selection of values which are common in 2 Data.frames

Leave a Comment