R transpose and group by

by

This can be achieved using dcast() from the data.table package:

library(data.table)
dcast(DT, Client ~ rowid(Client, prefix = "Smoke "), value.var = "Smoke")
#   Client Smoke 1 Smoke 2 Smoke 3
#1:     21       Y       Y       Y

Data

DT <- fread("Client   Smoke
            0021     Y
            0021     Y
            0021     Y")

More Related Contents:

  1. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  2. Transpose / reshape dataframe without “timevar” from long to wide format
  3. Mean per group in a data.frame [duplicate]
  4. Count number of rows within each group
  5. Faster ways to calculate frequencies and cast from long to wide
  6. Aggregating by unique identifier and concatenating related values into a string [duplicate]
  7. Extract row corresponding to minimum value of a variable by group
  8. Group by multiple columns and sum other multiple columns
  9. Add count of unique / distinct values by group to the original data
  10. Select the first and last row by group in a data frame
  11. Select the top N values by group
  12. Summarizing by subgroup percentage in R
  13. Aggregate multiple columns at once [duplicate]
  14. Aggregate a dataframe on a given column and display another column
  15. Aggregate a data frame based on unordered pairs of columns
  16. Compute mean and standard deviation by group for multiple variables in a data.frame
  17. aggregate methods treat missing values (NA) differently
  18. Group integer vector into consecutive runs
  19. Returning first row of group
  20. Transposing a dataframe maintaining the first column as heading
  21. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  22. Aggregate data in R
  23. aggregate() puts multiple output columns in a matrix instead
  24. data.frame Group By column [duplicate]
  25. R group by aggregate
  26. R use ddply or aggregate
  27. How to transpose a dataframe in tidyverse?
  28. Aggregate by week in R
  29. Aggregating all unique values of each column of data frame
  30. How can I count the number of NAs per group?

Leave a Comment