How do I use the aggregate function to mean|count|sum up multiple columns in R?

by

Try

library(dplyr)
library(tidyr)

df %>%
  gather(key, value, -Gender) %>%
  group_by(Gender) %>%
  summarise(Count = n(), Percentage_Count = n() / nrow(.), 
            Total_Donation = sum(value),
            Percentage_Donation = sum(value) / sum(.$value), 
            Mean_Donation = mean(value))

Which gives:

# A tibble: 2 x 6
#  Gender Count Percentage_Count Total_Donation Percentage_Donation Mean_Donation
#  <fctr> <int>            <dbl>          <int>               <dbl>         <dbl>
#1      F     9              0.5         124500           0.5071283      13833.33
#2      M     9              0.5         121000           0.4928717      13444.44

More Related Contents:

  1. How do I make a list of data frames?
  2. Include levels of zero count in result of table()
  3. Reshape multiple value columns to wide format
  4. Rotating and spacing axis labels in ggplot2
  5. Expand ranges defined by “from” and “to” columns
  6. Combine two or more columns in a dataframe into a new column with a new name
  7. Can you pass-by-reference in R?
  8. dplyr: “Error in n(): function should not be called directly”
  9. What exactly is copy-on-modify semantics in R, and where is the canonical source?
  10. How to swap values between two columns
  11. Define and apply custom bins on a dataframe
  12. How to perform join over date ranges using data.table?
  13. Animated sorted bar chart with bars overtaking each other
  14. Creating grouped bar-plot of multi-column data in R
  15. detach all packages while working in R
  16. Assigning Dates to Fiscal Year
  17. Find the n most common values in a vector [duplicate]
  18. What is the meaning of the dollar sign “$” in R function()?
  19. Set NA to 0 in R
  20. Case-insensitive search of a list in R
  21. Directly creating dummy variable set in a sparse matrix in R
  22. Error: package or namespace load failed for ‘tidyverse’ in loadNamespace
  23. Create frequency tables for multiple factor columns in R
  24. R function not returning values
  25. Reason behind speed of fread in data.table package in R
  26. What does the R function `poly` really do?
  27. Identifying where value changes in R data.frame column
  28. Double clustered standard errors for panel data
  29. Shiny – observe() triggered by dynamicaly generated inputs
  30. Create a Vector of All Days Between Two Dates

Leave a Comment