[Tutor] summary stats grouped by month year

questions anon questions.anon at gmail.com
Tue May 8 08:07:15 CEST 2012

I would like to calculate summary statistics of rainfall based on year and
I have the data in a text file (although could put in any format if it
helps) extending over approx 40 years:
YEAR MONTH    MeanRain
1972 Jan    12.7083199
1972 Feb    14.17007142
1972 Mar    14.5659302
1972 Apr    1.508517302
1972 May    2.780009889
1972 Jun    1.609619287
1972 Jul    0.138150181
1972 Aug    0.214346148
1972 Sep    1.322102228

I would like to be able to calculate the total rain annually:

YEAR   Annualrainfall
1972    400
1973    300
1974    350
2011     400

and also the monthly mean rainfall for all years:

YEAR  MonthlyMeanRain
Jan      13
Feb      15
Mar       8
Dec       13

Is this something I can easily do?
I have started by simply importing the text file but data is not
represented as time so that is probably my first problem and then I am not
sure how to group them by month/year.


Any feedback will be greatly appreciated.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20120508/6680a904/attachment.html>

More information about the Tutor mailing list