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-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] hello~

2012-05-15 Thread Prasad, Ramit
>as you can see i only use some of the command. it doesnt produce an error >message tho.. just repeats "return Error("%s I couldn't find %s >anywhere", user.name.title(), name.title())" Your problem might be is indenting of the else. It is indenting to be a for...else loop. Which means that if

Re: [Tutor] extracting lines between patterns.

2012-05-15 Thread Prasad, Ramit
> Friends, >Could someone please give some hint on how to extract lines between two >patterns in a file. I use the re module to compile my patterns but not able to >figure out how i can use these patterns to extract the lines lying in between. Not sure exactly what you want but something like th

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