I have a dataframe structured like this:
ID; Rating; Date
123; 4; 01.01.2020
234; 3; 01.01.2020
323; 5; 01.01.2020
434; 2; 02.01.2020
523; 4; 02.01.2020
634; 3; 03.01.2020
....
Now I want to take the mean for each Date and have a dataframe structured like this:
Average_Rating; Date
4 ; 01.01.2020
3 ; 02.01.2020
3 ; 03.01.2020
...
Does someone have an idea on how to do this most efficiently in R?
Thanks alot!
A tried to do it with lubridate and regular expressions but I'm getting stuck. I not even sure if thats the right way to do it. I'm still an R noob...
