I want to use Pandas to calculate the average of three values over three separate months in a dataset which lists the year, month and value of interest in three different columns. Normally, I would just use pandas.loc and isin() and panads.groupby functions to do this, but one of the seasons I want to analyze is December-January-February which will go across two separate years of data (i.e. Dec. 2000, Jan. 2001, Feb. 2001). Wondering if anyone has any suggestions on how to deal with this type of thing. 2000 1 5 2000 2 6 2000 3 8 2000 4 10 2000 5 9 2000 6 11 2000 7 13 2000 8 6 2000 9 8 2000 10 7 2000 11 7 2000 12 4 2001 1 3 2001 2 5 (i.e. In this situation, Jan. and Feb. 2000 would be ignored, averages would be MAM: 9, JJA: 10, SON: 7.33, DJF: 4) Continue reading...
