Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2015
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. Type Age count1 count2
  2. A 35 1 1
  3. A 35 3 1
  4. A 45 2 3
  5. B 45 2 1
  6. B 45 4 5
  7.  
  8. Type Age count1 count2
  9. A 35 4 2
  10. A 45 2 3
  11. B 45 6 6
  12.  
  13. typedup = duplicated(df$Type)
  14. bothdup = duplicated(df[(typedup == TRUE),]$Age)
  15.  
  16. tapply(c(df$count1, df$count2), c(df$Age, df$Type), sum)
  17.  
  18. library(dplyr)
  19. df1 %>%
  20. group_by(Type, Age) %>%
  21. summarise_each(funs(sum))
  22. # Type Age count1 count2
  23. #1 A 35 4 2
  24. #2 A 45 2 3
  25. #3 B 45 6 6
  26.  
  27. aggregate(.~Type+Age, df1, FUN=sum)
  28. # Type Age count1 count2
  29. #1 A 35 4 2
  30. #2 A 45 2 3
  31. #3 B 45 6 6
  32.  
  33. library(data.table)
  34. setDT(df1)[, lapply(.SD, sum), .(Type, Age)]
  35. # Type Age count1 count2
  36. #1: A 35 4 2
  37. #2: A 45 2 3
  38. #3: B 45 6 6
  39.  
  40. sqldf("select
  41. Type,Age,
  42. sum(count1) as sum_count1,
  43. sum(count2) as sum_count2
  44. from
  45. df
  46. group by
  47. Type,Age
  48. ")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement