Guest User

Untitled

a guest
Jun 25th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. function person
  2. 1 hr 1
  3. 2 sls 5
  4. 3 mktg 3
  5. 4 qlt 7
  6. 5 rev 5
  7.  
  8. Person function
  9. 1 1 hr
  10. 2 8 sls & mktg
  11. 3 7 qlt
  12. 4 5 rev
  13.  
  14. library(dplyr)
  15.  
  16. dat <- data.frame(func = c("hr", "sls", "mktg", "qlt", "rev"),
  17. person = c(1, 5, 3, 7, 5))
  18.  
  19. dat %>%
  20. mutate(func = func %>% as.factor() %>% as.character(),
  21. func = ifelse(func %in% c("sls", "mktg"), "sls & mktg", func)) %>%
  22. group_by(func) %>%
  23. summarize(Person = sum(person))
  24.  
  25. # A tibble: 4 x 2
  26. func Person
  27. <chr> <dbl>
  28. 1 hr 1
  29. 2 qlt 7
  30. 3 rev 5
  31. 4 sls & mktg 8
  32.  
  33. merg <- c("sls", "mktg")
  34. dat$func[dat$func %in% merg] <- paste(merg, collapse = " & ")
  35. aggregate(person ~ func, dat, sum)
  36. func person
  37. 1 hr 1
  38. 2 qlt 7
  39. 3 rev 5
  40. 4 sls & mktg 8
  41.  
  42. dat <- data.frame(
  43. func = c("hr", "sls", "mktg", "qlt", "rev"),
  44. person = c(1, 5, 3, 7, 5),
  45. stringsAsFactors = FALSE
  46. )
Add Comment
Please, Sign In to add comment