Re: [Tutor] summary stats grouped by month year

2012-05-08 Thread questions anon
excellent thank you for the warning, I will look into dictionaries alot more carefully now. I have some simple questions that I would like to ask straight away but will try and figure a few things out on my own first. Thanks again!! On Wed, May 9, 2012 at 11:16 AM, Andre' Walker-Loud wrote: > de

Re: [Tutor] summary stats grouped by month year

2012-05-08 Thread Andre' Walker-Loud
dear anonymous questioner, > Excellent, thank you so much. I don't understand all the steps at this stage > so I will need some time to go through it carefully but it works perfectly. > Thanks again! words of caution - you will notice that the way I constructed the data file - I assumed what th

Re: [Tutor] summary stats grouped by month year

2012-05-08 Thread questions anon
Excellent, thank you so much. I don't understand all the steps at this stage so I will need some time to go through it carefully but it works perfectly. Thanks again! On Tue, May 8, 2012 at 4:41 PM, Andre' Walker-Loud wrote: > Hello anonymous questioner, > > first comment - you may want to look i

Re: [Tutor] summary stats grouped by month year

2012-05-08 Thread शंतनू
On Tue, May 8, 2012 at 12:46 PM, शंतनू wrote: > Python generally comes with support for sqlite3. > > you can store your date in to sqlite db and then try running sql query > for finding of the details. data not date. > > select year, sum(MeanRain) where year='1972' group by year; > select month,

Re: [Tutor] summary stats grouped by month year

2012-05-08 Thread शंतनू
Python generally comes with support for sqlite3. you can store your date in to sqlite db and then try running sql query for finding of the details. select year, sum(MeanRain) where year='1972' group by year; select month, sum(MeanRain) where month='Jan' group by month; ** Not sure regarding the

Re: [Tutor] summary stats grouped by month year

2012-05-07 Thread Andre' Walker-Loud
Hello anonymous questioner, first comment - you may want to look into hdf5 data structures http://www.hdfgroup.org/HDF5/ and the python tools to play with them pytables - http://www.pytables.org/moin h5py - http://code.google.com/p/h5py/ I have personally used pytables more - but not for any g

[Tutor] summary stats grouped by month year

2012-05-07 Thread questions anon
I would like to calculate summary statistics of rainfall based on year and month. I have the data in a text file (although could put in any format if it helps) extending over approx 40 years: YEAR MONTHMeanRain 1972 Jan12.7083199 1972 Feb14.17007142 1972 Mar14.5659302 1972 Apr1.