Just wanted to thank the Posters for the help!
Thanks.
Lee G.
--
http://mail.python.org/mailman/listinfo/python-list
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-e
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 incl
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 col
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-ei
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
