MySQL Forums
Forum List  »  General

Counting occurences of data falling betwen a series of limits (buckets)
Posted by: Peter Dzwig
Date: October 13, 2011 11:08AM

This ought to be trivial but...

I have a dataset in a MySQL DB which is about 30 rows wide and some 500+ rows deep - and this is a prototype of a much larger DB.

Think something like this:

Col_1 Col_2 Col_3 Col_4......
500+ rows

the data in (let's say) Col_2 is scattered between certain limits (say 1 to 9.5). What I want to do is create a number of buckets, let's say of width 0.01, and count up the number of values in Col_2 falling into each bucket.

The limits and the width of the buckets and hence the number of buckets need to be variable (other datasets have different ranges for Col_2)

The output should ideally be a table looking like:


Bucket_1 | Count_1
Bucket_2 | Count_2
Bucket_last | Count_last

at this point no other data needs to appear in the new table.

FWIW the output data will be ultimately become a csv file for plotting.

It may just be getting late...

Thanks for any help that you can give,


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.