Re: frequency analysis of a DB column

2007-08-04 Thread goldtech
Just wanted to thank the Posters for the help! Thanks. Lee G. -- http://mail.python.org/mailman/listinfo/python-list

Re: frequency analysis of a DB column

2007-08-02 Thread Carsten Haese
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.

Re: frequency analysis of a DB column

2007-08-02 Thread John Machin
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

Re: frequency analysis of a DB column

2007-08-02 Thread Gabriel Genellina
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

frequency analysis of a DB column

2007-08-01 Thread goldtech
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

Re: frequency analysis of a DB column

2007-08-01 Thread Paul McGuire
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

Re: frequency analysis of a DB column

2007-08-01 Thread Gabriel Genellina
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