Faster ways to calculate frequencies and cast from long to wide

by

You could just use the table command:

table(data$id,data$week)

    1 2 3
  1 2 1 1
  2 0 0 1

If “id” and “week” are the only columns in your data frame, you can simply use:

table(data)
#    week
# id  1 2 3
#   1 2 1 1
#   2 0 0 1

More Related Contents:

  1. Group by multiple columns and sum other multiple columns
  2. Aggregate a dataframe on a given column and display another column
  3. Aggregate a data frame based on unordered pairs of columns
  4. Compute mean and standard deviation by group for multiple variables in a data.frame
  5. Returning first row of group
  6. Get the means of sub groups of means in R
  7. R use ddply or aggregate
  8. Convert an upper to lower triangle matrix in r [duplicate]
  9. summarizing multiple variables in group by
  10. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  11. Aggregating by unique identifier and concatenating related values into a string [duplicate]
  12. Convert data from long format to wide format with multiple measure columns
  13. Add count of unique / distinct values by group to the original data
  14. dcast warning: ‘Aggregation function missing: defaulting to length’
  15. Select the top N values by group
  16. Fastest way to add rows for missing time steps?
  17. Applying a function to every row of a table using dplyr?
  18. Aggregate multiple columns at once [duplicate]
  19. aggregate methods treat missing values (NA) differently
  20. Is there a R function that applies a function to each pair of columns?
  21. Group integer vector into consecutive runs
  22. Create columns from factors and count [duplicate]
  23. Joining aggregated values back to the original data frame [duplicate]
  24. Object not found error with ddply inside a function
  25. R: Split unbalanced list in data.frame column
  26. R: Reshaping Multiple Columns from Long to Wide
  27. Can dcast be used without an aggregate function? [duplicate]
  28. Replace missing values (NA) in one data set with values from another where columns match
  29. Can `ddply` (or similar) do a sliding window?
  30. How can I count the number of NAs per group?

Leave a Comment