On Mar 6, 7:44 pm, John Nagle <[EMAIL PROTECTED]> wrote:
> vedranp wrote:
> > I would like to avoid the step of taking data out from database in
> > order to process it.
>
> You can probably do this entirely within SQL. Most SQL databases,
> including MySQL, will let you put the result of a SE
vedranp wrote:
> I would like to avoid the step of taking data out from database in
> order to process it.
You can probably do this entirely within SQL. Most SQL databases,
including MySQL, will let you put the result of a SELECT into a new
table.
John Nagle
On Mar 6, 10:28 am, vedranp <[EMAIL PROTECTED]> wrote:
> So, group by DATE, COUNTRY, ZIP and CITY and sum (or do some
You are s close. Look up itertools.groupby
Don't forget to sort your data first.
http://aspn.activestate.com/ASPN/search?query=groupby&x=0&y=0§ion=PYTHONCKBK&type=Subsection