Repeat each row of data.frame the number of times specified in a column

by

Here’s one solution:

df.expanded <- df[rep(row.names(df), df$freq), 1:2]

Result:

    var1 var2
1      a    d
2      b    e
2.1    b    e
3      c    f
3.1    c    f
3.2    c    f

More Related Contents:

  1. Subset data frame based on number of rows per group
  2. Drop data frame columns by name
  3. Convert data.frame columns from factors to characters
  4. R Reshape data frame from long to wide format? [duplicate]
  5. Select the first row by group
  6. Calculate the mean of every 13 rows in data frame
  7. Select the first and last row by group in a data frame
  8. Calculate row means on subset of columns
  9. How does one reorder columns in a data frame?
  10. Update data frame via function doesn’t work
  11. R spreading multiple columns with tidyr [duplicate]
  12. Create a data.frame where a column is a list
  13. Take random sample by group
  14. How do I delete rows in a data frame?
  15. Replacing values from a column using a condition in R
  16. Split data.frame by value
  17. Convert data.frame column to a vector?
  18. Add new row to dataframe, at specific row-index, not appended?
  19. Growing a data.frame in a memory-efficient manner
  20. Remove columns from dataframe where some of values are NA
  21. Splitting a data.frame by a variable [duplicate]
  22. Check whether values in one data frame column exist in a second data frame
  23. How do you remove columns from a data.frame?
  24. Unlist a data frame by rows, not columns
  25. Using lapply to apply a function over list of data frames and saving output to files with different names
  26. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  27. Row-wise sum of values grouped by columns with same name
  28. Divide each value by the sum of values by group
  29. Convert all data frame character columns to factors
  30. What you can do with a data.frame that you can’t with a data.table?

Leave a Comment