Aggregate data set by year (year is the column name and the years are in the rows of the table)

Hi Scott, welcome!

You could do something like this


your_dataframe %>% 
    group_by(Year) %>% 
    summarise(Rainfall = sum(Rainfall))

If you need more specific help please provide a minimal REPRoducible EXample (reprex). A reprex makes it much easier for others to understand your issue and figure out how to help.

If you've never heard of a reprex before, you might want to start by reading this FAQ: