Sample n random rows per group in a dataframe

by

In versions of dplyr 0.3 and later, this works just fine:

df %>% group_by(color) %>% sample_n(size = 3)

Old versions of dplyr (version <= 0.2)

I set out to answer this using dplyr, assuming that this would work:

df %.% group_by(color) %.% sample_n(size = 3)

But it turns out that in 0.2 the sample_n.grouped_df S3 method exists but isn’t registered in the NAMESPACE file, so it’s never dispatched. Instead, I had to do this:

df %.% group_by(color) %.% dplyr:::sample_n.grouped_df(size = 3)
Source: local data frame [12 x 3]
Groups: color

            X1         X2  color
8   0.66152710 -0.7767473   blue
1  -0.70293752 -0.2372700   blue
2  -0.46691793 -0.4382669   blue
32 -0.47547565 -1.0179842   pink
31 -0.15254540 -0.6149726   pink
39  0.08135292 -0.2141423   pink
15  0.47721644 -1.5033192    red
16  1.26160230  1.1202527    red
12 -2.18431919  0.2370912    red
24  0.10493757  1.4065835 yellow
21 -0.03950873 -1.1582658 yellow
28 -2.15872261 -1.5499822 yellow

Presumably this will be fixed in a future update.

More Related Contents:

  1. Sample random rows in dataframe
  2. Take random sample by group
  3. Reshaping data.frame from wide to long format
  4. Quickly reading very large tables as dataframes
  5. Combine two data frames by rows (rbind) when they have different sets of columns
  6. Counting unique / distinct values by group in a data frame
  7. How to combine multiple conditions to subset a data-frame using “OR”?
  8. cbind a dataframe with an empty dataframe – cbind.fill?
  9. Split a large dataframe into a list of data frames based on common value in column
  10. Splitting a dataframe string column into multiple different columns [duplicate]
  11. Convert data.frame column format from character to factor
  12. How to convert a table to a data frame
  13. R Apply() function on specific dataframe columns
  14. Changing Column Names in a List of Data Frames in R
  15. Subset of rows containing NA (missing) values in a chosen column of a data frame
  16. rbind dataframes with a different column name
  17. Converting two columns of a data frame to a named vector
  18. Collapsing data frame by selecting one row per group
  19. Creating a new variable from a lookup table
  20. Practical limits of R data frame
  21. R: Assign variable labels of data frame columns
  22. rbind data frames based on a common pattern in data frame name
  23. Select last non-NA value in a row, by row
  24. Join two data frames in R based on closest timestamp
  25. How to append a whole dataframe to a CSV in R
  26. Undefined columns selected when subsetting data frame
  27. Difference between `names(df[1])
  28. How to create a new variable in a data.frame based on a condition?
  29. Data.frame Merge and Selection of values which are common in 2 Data.frames
  30. Interpolating timeseries

Leave a Comment