I want to add a “Week” column to my dataset. This week column runs from week 1 – week 5. I want to add this to a long data set (12) rows.
Is there a way I can code to make this function reoccurring to the entire data set to it looks like:
| ID | Week | Distance |
|---|---|---|
| Name 1 | Week 1 | 1000 |
| Name 1 | Week 2 | 1500 |
| Name 1 | Week 3 | 1100 |
| Name 1 | Week 4 | 900 |
| Name 1 | Week 5 | 1400 |
| Name 2 | Week 1 | 1300 |
| Name 2 | Week 2 | 1050 |
| Name 2 | Week 3 | 1500 |
| Name 2 | Week 4 | 1190 |
| Name 2 | Week 5 | 950 |
| Name 3 | Week 1 | 1350 |
| Name 3 | Week 2 | 1200 |
I have tried doing:
df %>% mutate(week = c(1:5))
However, I come up with this error:
week must be size 12 or 1, not 5.