Display weighted mean by group in the data.frame

by

If we use mutate, then we can avoid the left_join

library(dplyr)
df %>%
   group_by(education) %>% 
   mutate(weighted_income = weighted.mean(income, weight))
#    obs income education weight weighted_income
#  <int>  <int>    <fctr>  <int>           <dbl>
#1     1   1000         A     10        1166.667
#2     2   2000         B      1        1583.333
#3     3   1500         B      5        1583.333
#4     4   2000         A      2        1166.667

More Related Contents:

  1. Summarizing multiple columns with dplyr? [duplicate]
  2. Relative frequencies / proportions with dplyr
  3. How to add texture to fill colors in ggplot2
  4. Cleaning up factor levels (collapsing multiple levels/labels)
  5. Split a large dataframe into a list of data frames based on common value in column
  6. Save a plot in an object
  7. How to cbind or rbind different lengths vectors without repeating the elements of the shorter vectors?
  8. lapply vs for loop – Performance R
  9. YAML current date in rmarkdown
  10. Convert UNIX epoch to Date object
  11. Create new variables with mutate_at while keeping the original ones
  12. R: use magrittr pipe operator in self written package
  13. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  14. How to index a vector sequence within a vector sequence
  15. Counting number of instances of a condition per row R [duplicate]
  16. Find value corresponding to maximum in other column [duplicate]
  17. Split delimited single value character vector
  18. R split numeric vector at position
  19. Creating a Plot Window of a Particular Size
  20. R: invalid multibyte string [duplicate]
  21. Reordering factor gives different results, depending on which packages are loaded
  22. Join two data frames in R based on closest timestamp
  23. How to load data quickly into R?
  24. Sum of two Columns of Data Frame with NA Values
  25. R: what’s the proper way to overwrite a function from a package?
  26. Extract the coefficients for the best tuning parameters of a glmnet model in caret
  27. Create parametric R markdown documentation?
  28. Convert all data frame character columns to factors
  29. Reading text file with multiple space as delimiter in R
  30. How to use data.table within functions and loops?

Leave a Comment