Guest User

Untitled

a guest
Feb 25th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. # am qsec vs am gear carb
  2. # 1: 1 17.36000 0.5384615 1 4.384615 2.923077
  3. # 2: 1 17.02000 1.0000000 1 4.000000 2.000000
  4. # 3: 0 18.18316 0.3684211 0 3.210526 2.736842
  5. # 4: 0 17.82000 0.0000000 0 3.000000 3.000000
  6.  
  7. # variable 0 1
  8. # 1: qsec 18.1831579 17.3600000
  9. # 2: qsec 17.8200000 17.0200000
  10. # 3: vs 0.3684211 0.5384615
  11. # 4: vs 0.0000000 1.0000000
  12. # 5: am 0.0000000 1.0000000
  13. # <snip>
  14.  
  15. library(data.table)
  16. data = setDT(mtcars[7:11])
  17.  
  18. # data in
  19. tdat = data[, lapply(.SD, function(y){
  20. unlist(lapply(c(mean, median), function(f) f(y) ))
  21. }),
  22. by="am", .SDcols=seq_along(data)
  23. ]
  24.  
  25.  
  26. # data out
  27. m = melt(tdat, id.vars="am")
  28. m[, r:=duplicated(interaction(am, variable))+0L]
  29. dcast(m, variable + r ~ am, value.var = "value")[, r:=NULL][]
  30.  
  31. dcast( melt(tdat, id.var=1), variable~am, value.var='value')
  32. #Aggregate function missing, defaulting to 'length'
  33. # variable 0 1
  34. #1: qsec 2 2
  35. #2: vs 2 2
  36. #3: am 2 2
  37. #4: gear 2 2
  38. #5: carb 2 2
Add Comment
Please, Sign In to add comment