Guest User

Untitled

a guest
Jun 19th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. dat<-data.frame(
  2. ID=c(100,101,101,101,102,103),
  3. DEGREE=c("BA","BA","MS","PHD","BA","BA"),
  4. YEAR=c(1980,1990, 1992, 1996, 2000, 2004))
  5.  
  6. > dat
  7. ID DEGREE YEAR
  8. 100 BA 1980
  9. 101 BA 1990
  10. 101 MS 1992
  11. 101 PHD 1996
  12. 102 BA 2000
  13. 103 BA 2004
  14.  
  15. ID DEGREE_1 DEGREE_2 DEGREE_3 YEAR_DEGREE_1 YEAR_DEGREE_2 YEAR_DEGREE_3
  16. 100 BA 1980
  17. 101 BA MS PHD 1990 1992 1996
  18. 102 BA 2000
  19. 103 BA 2004
  20.  
  21. dat$DEGREE<-as.character(dat$DEGREE)
  22. dat %>% group_by(ID) %>%
  23. mutate(DegreeNum = paste("Degree", row_number(), sep = "_"))%>%
  24. mutate(DegreeYear = paste("YearDegree", row_number(), sep = "_"))%>%
  25. spread(DegreeNum, DEGREE, fill = "")%>%
  26. spread(DegreeYear,YEAR,fill="")%>%
  27. as.data.frame()
  28.  
  29. ID Degree_1 Degree_2 Degree_3 YearDegree_1 YearDegree_2 YearDegree_3
  30. 100 BA 1980
  31. 101 PHD 1996
  32. 101 MS 1992
  33. 101 BA 1990
  34. 102 BA 2000
  35. 103 BA 2004
Add Comment
Please, Sign In to add comment