Split data.frame based on levels of a factor into new data.frames

by

I think that split does exactly what you want.

Notice that X is a list of data frames, as seen by str:

X <- split(df, df$g)
str(X)

If you want individual object with the group g names you could assign the elements of X from split to objects of those names, though this seems like extra work when you can just index the data frames from the list split creates.

#I used lapply just to drop the third column g which is no longer needed.
Y <- lapply(seq_along(X), function(x) as.data.frame(X[[x]])[, 1:2]) 

#Assign the dataframes in the list Y to individual objects
A <- Y[[1]]
B <- Y[[2]]
C <- Y[[3]]
D <- Y[[4]]
E <- Y[[5]]

#Or use lapply with assign to assign each piece to an object all at once
lapply(seq_along(Y), function(x) {
    assign(c("A", "B", "C", "D", "E")[x], Y[[x]], envir=.GlobalEnv)
    }
)

Edit Or even better than using lapply to assign to the global environment use list2env:

names(Y) <- c("A", "B", "C", "D", "E")
list2env(Y, envir = .GlobalEnv)
A

More Related Contents:

  1. Reshaping data.frame from wide to long format
  2. How to sum a variable by group
  3. How do I make a list of data frames?
  4. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  5. Sort (order) data frame rows by multiple columns
  6. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  7. Numbering rows within groups in a data frame
  8. Split data frame string column into multiple columns
  9. Calculate the mean by group
  10. Select the row with the maximum value in each group
  11. Filter data.frame rows by a logical condition
  12. Count number of rows within each group
  13. Quickly reading very large tables as dataframes
  14. Remove rows with all or some NAs (missing values) in data.frame
  15. Subset data frame based on number of rows per group
  16. Pass a data.frame column name to a function
  17. Drop data frame columns by name
  18. Why is it not advisable to use attach() in R, and what should I use instead?
  19. Create an empty data.frame
  20. How to plot all the columns of a data frame in R
  21. Sample random rows in dataframe
  22. Extracting specific columns from a data frame
  23. Subset / filter rows in a data frame based on a condition in a column
  24. How does one reorder columns in a data frame?
  25. Rename multiple columns by names
  26. Combine two or more columns in a dataframe into a new column with a new name
  27. Convert a dataframe to a vector (by rows)
  28. Should I use a data.frame or a matrix?
  29. Re-ordering factor levels in data frame [duplicate]
  30. Convert list to data frame while keeping list-element names

Leave a Comment