How to strsplit different number of strings in certain column by do function

by

You’re having troubles because strsplit() returns a list which we then need to apply as.data.frame.list() to each element to get it into the proper format that dplyr requires. Even then it would still require a bit more work to get usable results. Long story short, it doesn’t seem like a suitable operation for do().

I think you might be better off using separate() from tidyr. It can easily be used with dplyr functions and chains. It’s not clear whether you want to keep the first column since your ldply result for df2 does not have it, so I left it off.

library(tidyr)
separate(df[-1], name, 1:3, " ", extra = "merge")
#      1    2    3
# 1 jake <NA> <NA>
# 2 jane jane <NA>
# 3 john john john

You could also use cSplit. It is also very efficient since it relies on data.table

library(splitstackshape)
cSplit(df[-1], "name", " ")
#    name_1 name_2 name_3
# 1:   jake     NA     NA
# 2:   jane   jane     NA
# 3:   john   john   john

Or more specifically

setnames(df2 <- cSplit(df[-1], "name", " "), names(df2), as.character(1:3))
df2
#       1    2    3
# 1: jake   NA   NA
# 2: jane jane   NA
# 3: john john john

More Related Contents:

  1. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  2. How to select the rows with maximum values in each group with dplyr? [duplicate]
  3. How to create a lag variable within each group?
  4. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  5. Unique rows, considering two columns, in R, without order
  6. Applying a function to every row of a table using dplyr?
  7. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  8. dplyr: “Error in n(): function should not be called directly”
  9. Count number of rows by group using dplyr
  10. Change value of variable with dplyr
  11. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  12. Summarizing multiple columns with dplyr? [duplicate]
  13. Relative frequencies / proportions with dplyr
  14. standard evaluation in dplyr: summarise a variable given as a character string
  15. Use variable names in functions of dplyr
  16. Create new variables with mutate_at while keeping the original ones
  17. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  18. Finding percentage in a sub-group using group_by and summarise
  19. Make a group_indices based on several columns
  20. Using spread with duplicate identifiers for rows
  21. filter for complete cases in data.frame using dplyr (case-wise deletion)
  22. filter function in dplyr errors: object ‘name’ not found
  23. Create a ranking variable with dplyr?
  24. How to pass dynamic column names in dplyr into custom function?
  25. R – Group by variable and then assign a unique ID [duplicate]
  26. R sum a variable by two groups [duplicate]
  27. Join two data frames in R based on closest timestamp
  28. data.table row-wise sum, mean, min, max like dplyr?
  29. Update/Replace Values in Dataframe with Tidyverse Join
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment