Guest User

Untitled

a guest
Jun 25th, 2018
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. data = read.csv(text="Email foo.final bar.final
  2. abc@foo.com 100 200
  3. cde@foo.com 101 201
  4. xyz@foo.com 102 202
  5. zzz@foo.com 103 103", header=T, sep="" )
  6.  
  7. a = gather(data, key, Grade, -Email)
  8.  
  9. Email key Grade
  10. 1 abc@foo.com foo.final 100
  11. 2 cde@foo.com foo.final 101
  12. 3 xyz@foo.com foo.final 102
  13. 4 zzz@foo.com foo.final 103
  14. 5 abc@foo.com bar.final 200
  15. 6 cde@foo.com bar.final 201
  16. 7 xyz@foo.com bar.final 202
  17. 8 zzz@foo.com bar.final 103
  18.  
  19. key Grade
  20. 1 Email abc@foo.com
  21. 2 Email cde@foo.com
  22. 3 Email xyz@foo.com
  23. 4 Email zzz@foo.com
  24. 5 foo.final 100
  25. 6 foo.final 101
  26. 7 foo.final 102
  27. 8 foo.final 103
  28. 9 bar.final 200
  29. 10 bar.final 201
  30. 11 bar.final 202
  31. 12 bar.final 103
  32.  
  33. f2 <- f1 %>%
  34. gather(key = Assignment, value = Grade, COURSE.final:EXAM.final) %>%
  35. select(-email)
Add Comment
Please, Sign In to add comment