Links

Lists

Latest Updates

Ruby On Rails List
Python list
Advanced Java
The JavaScript List
Apache Users
Full Disclosure
Linux Security

Search the archives!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

frequency analysis of a DB column


  • From: goldtech at worldpost.com (goldtech)
  • Subject: frequency analysis of a DB column
  • Date: Wed, 01 Aug 2007 19:21:53 -0700

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 this?

Of course there'd be 1000's of values....

I'm not asking about connecting to the DB, just tools to collate and
tally this sort of thing.

Thanks,
Lee G.