Hi all! I'm really new to R and learning the basics. I've been practising with dplyr but came to a roadblock and would really appreciate the help.
So I have a dataset with columns ranging from "year", "eweek", "type of dengue" and "number" and I want to organize them just by "year", "month", "number".
The first challenge here is that each week there are 2 rows (because of 2 type of dengue rows) so I am thinking of adding the values of "number" together for each week.
The second challenge is to summarize the weeks into months.
(A sample picture of the data frame is attached for easier reference.)
Any kind folks can direct me to the best way to approach these problems? It seems a little complex for a newbie like me but would really like to learn.
Thank you in advance!