How do you take duplicate rows and change them iteratively?
Given this hypothetical table which lists year repeating 12 times, how do you conditionally change it so that each year is now a date for each Student (iterating through the months)?
This is the beginning table:
| Student | Date | Grade |
|---|---|---|
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Walton | 2018 | .77 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
| Sam | 2018 | .86 |
End table:
| Store | Date | Grade |
|---|---|---|
| Walton | 2018-01-01 | .77 |
| Walton | 2018-02-01 | .77 |
| Walton | 2018-03-01 | .77 |
| Walton | 2018-04-01 | .77 |
| Walton | 2018-05-01 | .77 |
| Walton | 2018-06-01 | .77 |
| Walton | 2018-07-01 | .77 |
| Walton | 2018-08-01 | .77 |
| Walton | 2018-09-01 | .77 |
| Walton | 2018-10-01 | .77 |
| Walton | 2018-11-01 | .77 |
| Walton | 2018-12-01 | .77 |
| Sam | 2018-01-01 | .86 |
| Sam | 2018-02-01 | .86 |
| Sam | 2018-03-01 | .86 |
| Sam | 2018-04-01 | .86 |
| Sam | 2018-05-01 | .86 |
| Sam | 2018-06-01 | .86 |
| Sam | 2018-07-01 | .86 |
| Sam | 2018-08-01 | .86 |
| Sam | 2018-09-01 | .86 |
| Sam | 2018-10-01 | .86 |
| Sam | 2018-11-01 | .86 |
| Sam | 2018-12-01 | .86 |
Have attempted function using case_when which did not work. Sorry if this has already been asked.