Split data.frame by value

by

You could find which values of the indexing vector equal “a”, then create a grouping variable based on that and then use split.

df[,1] == "a"
# [1]  TRUE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE  TRUE
#[13] FALSE FALSE
cumsum(df[,1] == "a")
# [1] 1 1 1 1 2 2 2 2 2 2 2 3 3 3
split(df, cumsum(df[,1] == "a"))
#$`1`
#  var1 var2
#1    a    1
#2    1    2
#3    2    3
#4    3    4
#
#$`2`
#   var1 var2
#5     a    5
#6     1    6
#7     2    7
#8     3    8
#9     4    9
#10    5   10
#11    6   11
#
#$`3`
#   var1 var2
#12    a   12
#13    1   13
#14    2   14

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. Splitting a dataframe string column into multiple different columns [duplicate]
  6. Split dataframe into multiple output files
  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. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  14. Filtering a data frame on a vector [duplicate]
  15. How to replace NA values in a table for selected columns
  16. Selecting multiple odd or even columns/rows for dataframe
  17. Deleting reversed duplicates with R
  18. Convert data.frame column to a vector?
  19. Add new row to dataframe, at specific row-index, not appended?
  20. Remove columns from dataframe where some of values are NA
  21. Check whether values in one data frame column exist in a second data frame
  22. How do you remove columns from a data.frame?
  23. How does cut with breaks work in R
  24. What is the algorithm behind R core’s `split` function?
  25. R strsplit with multiple unordered split arguments?
  26. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  27. Numbers as column names of data frames
  28. R divide data into groups
  29. Divide each value by the sum of values by group
  30. Convert all data frame character columns to factors

Leave a Comment