Skip to content

Instantly share code, notes, and snippets.

@toyeiei

toyeiei/excel_pivot_table.R

Created August 15, 2019 07:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save toyeiei/aee30d998c9f7ed0db072fe5e6704d9b to your computer and use it in GitHub Desktop.
Save toyeiei/aee30d998c9f7ed0db072fe5e6704d9b to your computer and use it in GitHub Desktop.
Download ZIP
R4Excel - pivot table in R
Raw
excel_pivot_table.R
## count gender i.e. number of male and female students
df %>%
count(gender)
## count grouped gender and nationality
df %>%
count(gender, nationality)
## compute average age by gender group i.e. male age vs. female age
df %>%
group_by(gender) %>%
summarise(avg_age = mean(age))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment