Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. summarise
  2.  
  3. dta = structure(list(PHHWT14 = c(530, 457, 416, 497, 395, 480, 383,
  4. 420, 499, 424, 504, 497, 449, 406, 492, 470, 418, 407, 403, 362,
  5. 393, 368, 423, 448, 511, 511, 423, 470, 453, 429, 439, 425, 431,
  6. 443, 480, 452, 472, 406, 460, 436, 574, 456, 399, 476, 423, 501,
  7. 399, 459, 396, 409, 423, 399, 383, 433, 436, 413, 403, 414, 410,
  8. 337, 472, 448, 487, 442, 475, 410, 478, 483, 374, 414, 514, 422,
  9. 409, 455, 464, 362, 461, 356, 464, 456, 494, 348, 464, 432, 398,
  10. 426, 418, 429, 516, 363, 455, 413, 388, 508, 381, 439, 330, 385,
  11. 393, 454), SEX = structure(c(2L, 1L, 2L, 2L, 1L, 2L, 2L, 1L,
  12. 2L, 2L, 2L, 1L, 2L, 1L, 2L, 2L, 2L, 1L, 2L, 2L, 2L, 2L, 2L, 2L,
  13. 2L, 2L, 1L, 2L, 2L, 2L, 2L, 2L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L,
  14. 2L, 2L, 2L, 2L, 1L, 2L, 2L, 2L, 1L, 2L, 2L, 1L, 2L, 2L, 2L, 1L,
  15. 2L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 1L, 2L, 2L, 1L, 2L, 2L, 1L,
  16. 2L, 2L, 2L, 1L, 2L, 2L, 2L, 2L, 2L, 1L, 2L, 2L, 1L, 2L, 1L, 2L,
  17. 2L, 2L, 2L, 2L, 1L, 2L, 1L, 2L, 1L, 2L, 1L, 2L), .Label = c("Female", "Male"), class = "factor")), row.names = c(NA, 100L), class = "data.frame", .Names = c("PHHWT14", "SEX"))
  18.  
  19. xtabs(PHHWT14 ~ SEX, dta)
  20.  
  21. SEX
  22. Female Male
  23. 10115 33490
  24.  
  25. dta %>%
  26. group_by(SEX) %>%
  27. summarise(n())
  28.  
  29. dta %>%
  30. group_by(SEX) %>%
  31. summarise_each(funs(sum))
  32. ## Source: local data frame [2 x 2]
  33. ##
  34. ## SEX PHHWT14
  35. ## 1 Female 10115
  36. ## 2 Male 33490
  37.  
  38. dta %>% group_by(SEX) %>%
  39. summarise(sum(PHHWT14))
  40.  
  41. # SEX sum(PHHWT14)
  42. # 1 Female 10115
  43. # 2 Male 33490
  44.  
  45. library(dplyr)
  46. set.seed(1234)
  47. df <- iris
  48. df[,"weights"] <- rnorm(nrow(df),1,0.1 ) # generate randomized weights
  49. head(df)
  50.  
  51. df %>%
  52. group_by(Species) %>%
  53. summarise_each(funs(sum(. * weights , na.rm = TRUE), # Weighted Sum
  54. weighted.mean(.,w = weights, na.rm = TRUE))) -> agg.df # Weighted Mean
  55.  
  56. agg.df
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement