Re: [Tutor] table to dictionary and then analysis

2012-05-22 Thread questions anon
thanks for all of the responses, has been really helpful On Fri, May 18, 2012 at 8:54 PM, Russel Winder rus...@winder.org.uk wrote: On Thu, 2012-05-17 at 19:35 +1000, Steven D'Aprano wrote: On Thu, May 17, 2012 at 08:27:07AM +0100, Russel Winder wrote: Should we be promoting use of the

Re: [Tutor] table to dictionary and then analysis

2012-05-18 Thread Russel Winder
On Thu, 2012-05-17 at 19:35 +1000, Steven D'Aprano wrote: On Thu, May 17, 2012 at 08:27:07AM +0100, Russel Winder wrote: Should we be promoting use of the format method in strings rather than the % operator? % is deprecated now. It most certainly is not. There are no plans to

Re: [Tutor] table to dictionary and then analysis

2012-05-17 Thread Russel Winder
On Wed, 2012-05-16 at 12:57 -0400, Joel Goldstick wrote: [...] I think the OP is just learning and this thread may have gotten of track. I didn't realize discussion of immediate side issues and alternatives, and allowing people to exchange information was OT in this mailing list. Also of course,

Re: [Tutor] table to dictionary and then analysis

2012-05-17 Thread Russel Winder
On Wed, 2012-05-16 at 16:03 +0100, Alan Gauld wrote: [...] I agree, but in this case SQL seemed like the most likely fit of the ones I knew. however: Which raises the point that the best design of a given problem in a given context is the one that is most comprehensible to the people directly

Re: [Tutor] table to dictionary and then analysis

2012-05-17 Thread Alan Gauld
On 17/05/12 08:39, Russel Winder wrote: Interesting, or not, the Big Data people are rapidly realizing that data mining and SQL are mutually incompatible. After many years working with big data mining teams/apps my considered opinion is use SAS or one of its peers! It costs money but it

Re: [Tutor] table to dictionary and then analysis

2012-05-17 Thread Steven D'Aprano
On Thu, May 17, 2012 at 08:27:07AM +0100, Russel Winder wrote: Should we be promoting use of the format method in strings rather than the % operator? % is deprecated now. It most certainly is not. There are no plans to deprecate the string % operator any time in the foreseeable future. It

Re: [Tutor] table to dictionary and then analysis

2012-05-17 Thread bob gailer
On 5/17/2012 3:27 AM, Russel Winder wrote: Should we be promoting use of the format method in strings rather than the % operator? % is deprecated now. I for one do not like seeing % deprecated. Why? It is not broken, and IMHO the easiest to use of all formatting options. -- Bob Gailer

Re: [Tutor] table to dictionary and then analysis

2012-05-17 Thread Mark Lawrence
On 17/05/2012 10:35, Steven D'Aprano wrote: On Thu, May 17, 2012 at 08:27:07AM +0100, Russel Winder wrote: Should we be promoting use of the format method in strings rather than the % operator? % is deprecated now. It most certainly is not. There are no plans to deprecate the string %

Re: [Tutor] table to dictionary and then analysis

2012-05-16 Thread Russel Winder
On Tue, 2012-05-15 at 19:14 +0100, Alan Gauld wrote: On 15/05/12 10:36, Russel Winder wrote: ...queries passed over it then year a database it the right thing -- though I would probably choose a non-SQL database. As a matter of interest why? Because there are alternatives that need to be

Re: [Tutor] table to dictionary and then analysis

2012-05-16 Thread Alan Gauld
On 16/05/12 12:27, Russel Winder wrote: As a matter of interest why? Because there are alternatives that need to be investigated on a per problem basis for the best database. I agree, but in this case SQL seemed like the most likely fit of the ones I knew. however: SQL

Re: [Tutor] table to dictionary and then analysis

2012-05-16 Thread Joel Goldstick
On Wed, May 16, 2012 at 11:03 AM, Alan Gauld alan.ga...@btinternet.com wrote: On 16/05/12 12:27, Russel Winder wrote: As a matter of interest why? Because there are alternatives that need to be investigated on a per problem basis for the best database. I agree, but in this case SQL

Re: [Tutor] table to dictionary and then analysis

2012-05-15 Thread questions anon
Thanks Bob, sql does appear to be very simple although I cannot get the queries to work. Can you suggest a site that has examples for what I am trying to do. I have done some googling but it has not been successful so far. On Tue, May 15, 2012 at 1:38 PM, bob gailer bgai...@gmail.com wrote:

Re: [Tutor] table to dictionary and then analysis

2012-05-15 Thread Alan Gauld
On 15/05/12 07:12, questions anon wrote: Thanks Bob, sql does appear to be very simple although I cannot get the queries to work. Can you suggest a site that has examples for what I am trying to do. I have done some googling but it has not been successful so far. You can try my tutorial topic

Re: [Tutor] table to dictionary and then analysis

2012-05-15 Thread Russel Winder
On Mon, 2012-05-14 at 23:38 -0400, bob gailer wrote: [...] I would set up a SQLite database with a table of 4 numeric columns: year, month, rainfall, firearea Use SQL to select the desired date range and do the max and avg calculations: select year, avg(firearea), max(rainfall) from table

Re: [Tutor] table to dictionary and then analysis

2012-05-15 Thread Alan Gauld
On 15/05/12 10:36, Russel Winder wrote: ...queries passed over it then year a database it the right thing -- though I would probably choose a non-SQL database. As a matter of interest why? And what kind of alternative would you use? It seems to me that SQL is ideally suited(*) to this type of

[Tutor] table to dictionary and then analysis

2012-05-14 Thread questions anon
I am completely new to dictionaries and I am not even sure if this is what I need to use. I have a text file that I would like to run summary stats on particular months, years and climate indices (in this case the climate indices are rainfall and fire area, so not actualy climate indices at all).

Re: [Tutor] table to dictionary and then analysis

2012-05-14 Thread bob gailer
On 5/14/2012 10:16 PM, questions anon wrote: I am completely new to dictionaries and I am not even sure if this is what I need to use. I have a text file that I would like to run summary stats on particular months, years and climate indices (in this case the climate indices are rainfall and