Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- data = read.csv(text="Email foo.final bar.final
- abc@foo.com 100 200
- cde@foo.com 101 201
- xyz@foo.com 102 202
- zzz@foo.com 103 103", header=T, sep="" )
- a = gather(data, key, Grade, -Email)
- Email key Grade
- 1 abc@foo.com foo.final 100
- 2 cde@foo.com foo.final 101
- 3 xyz@foo.com foo.final 102
- 4 zzz@foo.com foo.final 103
- 5 abc@foo.com bar.final 200
- 6 cde@foo.com bar.final 201
- 7 xyz@foo.com bar.final 202
- 8 zzz@foo.com bar.final 103
- key Grade
- 1 Email abc@foo.com
- 2 Email cde@foo.com
- 3 Email xyz@foo.com
- 4 Email zzz@foo.com
- 5 foo.final 100
- 6 foo.final 101
- 7 foo.final 102
- 8 foo.final 103
- 9 bar.final 200
- 10 bar.final 201
- 11 bar.final 202
- 12 bar.final 103
- f2 <- f1 %>%
- gather(key = Assignment, value = Grade, COURSE.final:EXAM.final) %>%
- select(-email)
Add Comment
Please, Sign In to add comment