Create columns from factors and count [duplicate]

by

You only need to make some slight modification to your code. You should use .(Name) instead of c("Name"):

ddply(df1, .(Name), summarise,
      Score_1 = sum(Score == 1),
      Score_2 = sum(Score == 2),
      Score_3 = sum(Score == 3))

gives:

  Name Score_1 Score_2 Score_3
1  Ben       1       1       0
2 John       1       1       1

Other possibilities include:

1. table(df1) as @alexis_laz mentioned in the comments, this gives:

> table(df1)
       Score
Name   1 2 3
  Ben  1 1 0
  John 1 1 1

2. The dcast function of the reshape2 package (or data.table which has the same dcast function):

library(reshape2) # or library(data.table)
dcast(df1, Name ~ paste0("Score_", Score), fun.aggregate = length)

gives:

  Name Score_1 Score_2 Score_3
1  Ben       1       1       0
2 John       1       1       1

More Related Contents:

  1. Faster ways to calculate frequencies and cast from long to wide
  2. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  3. Why does summarize or mutate not work with group_by when I load `plyr` after `dplyr`?
  4. How to select the rows with maximum values in each group with dplyr? [duplicate]
  5. Group by multiple columns and sum other multiple columns
  6. How to create a lag variable within each group?
  7. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  8. Unique rows, considering two columns, in R, without order
  9. Remove group from data.frame if at least one group member meets condition
  10. Idiomatic R code for partitioning a vector by an index and performing an operation on that partition
  11. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  12. dplyr: “Error in n(): function should not be called directly”
  13. Aggregate a dataframe on a given column and display another column
  14. Aggregate a data frame based on unordered pairs of columns
  15. What does the dot mean in R – personal preference, naming convention or more?
  16. Count number of rows by group using dplyr
  17. How to strsplit different number of strings in certain column by do function
  18. Is there a R function that applies a function to each pair of columns?
  19. Change value of variable with dplyr
  20. How to get top n companies from a data frame in decreasing order
  21. Split Data Frame into Rows of Fixed Size
  22. R: Split unbalanced list in data.frame column
  23. Get the means of sub groups of means in R
  24. meaning of ddply error: ‘names’ attribute [9] must be the same length as the vector [1]
  25. Standard error bars using stat_summary
  26. Replace missing values (NA) in one data set with values from another where columns match
  27. R use ddply or aggregate
  28. ddply for sum by group in R
  29. Can `ddply` (or similar) do a sliding window?
  30. R – Faster Way to Calculate Rolling Statistics Over a Variable Interval

Leave a Comment