Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1. df<-data.frame(city=as.character("Boston","Boston","Boston","Boston","Boston","Boston","Boston","Boston","Boston","Boston"),
  2. a.Boston=c(rep(8,3),rep(6,4),9,5,7),
  3. a.Hartford=c(rep(6,3),rep(2,4),1,5,0),
  4. a.Denver=c(rep(8,3),rep(9,4),3,8,9),
  5. b.Boston_0=c(rep(8,3),rep(9,4),3,8,9),
  6. b.Boston_1=c(rep(8,3),rep(9,4),3,8,9),
  7. b.Boston_2=c(rep(8,3),rep(9,4),3,8,9),
  8. b.Boston_3=c(rep(8,3),rep(9,4),3,8,9),
  9. b.Boston_4=c(rep(8,3),rep(9,4),3,8,9),
  10. b.Boston_5=c(rep(8,3),rep(9,4),3,8,9),
  11. b.Boston_6=c(rep(8,3),rep(9,4),3,8,9),
  12. b.Boston_7=c(rep(8,3),rep(9,4),3,8,9),
  13. b.Boston_8=c(rep(8,3),rep(9,4),3,8,9),
  14. b.Boston_9=c(rep(8,3),rep(9,4),3,8,9),
  15. b.Boston_10=c(rep(8,3),rep(9,4),3,8,9),
  16. b.Boston_11=c(rep(8,3),rep(9,4),3,8,9),
  17. b.Boston_12=c(rep(8,3),rep(9,4),3,8,9),
  18. b.Denver_0=c(rep(6,3),rep(2,4),1,5,0),
  19. b.Denver_1=c(rep(6,3),rep(2,4),1,5,0),
  20. b.Denver_2=c(rep(6,3),rep(2,4),1,5,0),
  21. b.Denver_3=c(rep(6,3),rep(2,4),1,5,0),
  22. b.Denver_4=c(rep(6,3),rep(2,4),1,5,0),
  23. b.Denver_5=c(rep(6,3),rep(2,4),1,5,0),
  24. b.Denver_6=c(rep(6,3),rep(2,4),1,5,0),
  25. b.Denver_7=c(rep(6,3),rep(2,4),1,5,0),
  26. b.Denver_8=c(rep(6,3),rep(2,4),1,5,0),
  27. b.Denver_9=c(rep(6,3),rep(2,4),1,5,0),
  28. b.Denver_10=c(rep(6,3),rep(2,4),1,5,0),
  29. b.Denver_11=c(rep(6,3),rep(2,4),1,5,0),
  30. b.Denver_12=c(rep(6,3),rep(2,4),1,5,0))
  31.  
  32. i1 <- 0:12
  33. for(i in seq_along(i1)) {
  34. assign(paste0("df", i),
  35. value = df[, setdiff(names(df),
  36. c("city",
  37. grep(paste("_", 0:i1[i],collapse="|", sep=""),
  38. colnames(df), value = TRUE)))])
  39. }
  40.  
  41. *df2*
  42.  
  43. a.Boston a.Hartford a.Denver b.Boston_2 b.Boston_3 b.Boston_4 b.Boston_5 b.Boston_6 b.Boston_7 b.Boston_8
  44. 1 8 6 8 8 8 8 8 8 8 8
  45. 2 8 6 8 8 8 8 8 8 8 8
  46. b.Boston_9 b.Denver_2 b.Denver_3 b.Denver_4 b.Denver_5 b.Denver_6 b.Denver_7 b.Denver_8 b.Denver_9
  47. 1 8 6 6 6 6 6 6 6 6
  48. 2 8 6 6 6 6 6 6 6 6
  49.  
  50. a.Boston a.Hartford a.Denver b.Boston_9 b.Denver_9
  51. 1 8 6 8 8 6
  52. 2 8 6 8 8 6
  53.  
  54. a.Boston a.Hartford a.Denver b.Boston_9 b.Boston_10 b.Boston_11 b.Boston_12 b.Denver_9 b.Denver_10
  55. 1 8 6 8 8 8 8 8 6 6
  56. 2 8 6 8 8 8 8 8 6 6
  57. b.Denver_11 b.Denver_12
  58. 1 6 6
  59. 2 6 6
  60.  
  61. a.Boston a.Hartford a.Denver b.Boston_10 b.Boston_11 b.Boston_12 b.Denver_10 b.Denver_11 b.Denver_12
  62. 1 8 6 8 8 8 8 6 6 6
  63. 2 8 6 8 8 8 8 6 6 6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement