R Reshape DATE Data

Asked Feb 24 '23 at 15:52

Active Feb 24 '23 at 15:52

Viewed 19 times

HAVE = data.frame('STUDENT'= c(1,2,3,4),
'1/1/2019' = c(1, NA, 8, 4),
'2/1/2019' = c(1, 3, NA, 6),    1   3       6
'1/15/2020' = c(NA, 7, NA, 10))

WANT = data.frame('STUDENT' = c(1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4),
'DATE' = c(43466, 43497, 43845, 43466, 43497, 43845, 43466, 43497, 43845, 43466, 43497, 43845),
'SCORE' = c(1, 1, NA, NA, 3, 7, 8, NA, NA, 4, 6, 10))

I have a data file for in it the COL names are DATES and I wish to reshape from 'HAVE' to 'WANT' where the values inside are 'SCORE'

asked Feb 24 '23 at 15:52

bvowe

3,004
3
16
33

1

`pivot_longer(HAVE, -STUDENT, names_to = "DATE")` – Maël Feb 24 '23 at 15:54
@bvowe Your `HAVE` have some typos. Can you correct it – akrun Feb 24 '23 at 16:49
Try `HAVE %>% pivot_longer(cols = -STUDENT, names_to = 'DATE', values_to = 'SCORE') %>% mutate(DATE = as.numeric(mdy(DATE)))` – akrun Feb 24 '23 at 16:57
1

Feel free to set the other as duplicate – Maël Feb 24 '23 at 17:10

R Reshape DATE Data

0 Answers0