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 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 format method

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 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 % operat

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 919-636-

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 m

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 wor

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 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-16 Thread Joel Goldstick
On Wed, May 16, 2012 at 11:03 AM, Alan Gauld 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 seemed like the

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 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

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

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 tab

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 o

Re: [Tutor] table to dictionary and then analysis

2012-05-14 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 wrote: > On 5/14/2012 10:1

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 fir