Just wanted to thank the Posters for the help!
Thanks.
Lee G.
--
http://mail.python.org/mailman/listinfo/python-list
On Thu, 2007-08-02 at 00:38 -0300, Gabriel Genellina wrote:
I'd start with:
select column, count(column), min(column), max(column)
from table
group by column
order by count(column) desc
What's the point of including min(column) and max(column)? They're
always going to be equal to column.
On Aug 2, 12:21 pm, goldtech [EMAIL PROTECTED] wrote:
In Python 2.1 are there any tools to take a column from a DB and do a
frequency analysis - a breakdown of the values for this column?
Possibly a histogram or a table saying out of 500 records I have one
hundred and two 301 ninety-eight 212
En Thu, 02 Aug 2007 09:28:46 -0300, Carsten Haese [EMAIL PROTECTED]
escribió:
On Thu, 2007-08-02 at 00:38 -0300, Gabriel Genellina wrote:
select column, count(column), min(column), max(column)
from table
group by column
order by count(column) desc
What's the point of including
In Python 2.1 are there any tools to take a column from a DB and do a
frequency analysis - a breakdown of the values for this column?
Possibly a histogram or a table saying out of 500 records I have one
hundred and two 301 ninety-eight 212 values and three-hundred
410?
Is SQL the way to for
On Aug 1, 9:21 pm, goldtech [EMAIL PROTECTED] wrote:
In Python 2.1 are there any tools to take a column from a DB and do a
frequency analysis - a breakdown of the values for this column?
Possibly a histogram or a table saying out of 500 records I have one
hundred and two 301 ninety-eight 212
En Wed, 01 Aug 2007 23:21:53 -0300, goldtech [EMAIL PROTECTED]
escribió:
In Python 2.1 are there any tools to take a column from a DB and do a
frequency analysis - a breakdown of the values for this column?
Possibly a histogram or a table saying out of 500 records I have one
hundred and