How to automatically decide the max number of quantiles when using qcut given a number in pandas?

Asked Mar 30 '19 at 02:32

Active Mar 30 '19 at 02:32

Viewed 91 times

Goal: I want to find cut values with max equal bins using qcut given a q value. But I have to try one by one to find it. Here is the details:

max_bin = 12

pd.qcut([0,1,1,2,3,3,4,4,5,6,7],q=max_bin)

It would raised ValueError: Bin edges must be unique.Then I try 11 it works.

Hope: Set a function that can automatically find max bins given a q values.

asked Mar 30 '19 at 02:32

Jack

https://stackoverflow.com/questions/20158597/how-to-qcut-with-non-unique-bin-edges – user3483203 Mar 30 '19 at 02:36
@user3483203 this is not what I want. – Jack Mar 30 '19 at 02:42
What do you mean by "max" bins? – gmds Mar 30 '19 at 04:39
@gmds In my example, assumed 12 could work but it can't. So I have to try 11 to test .If failed, then 10, 9 ,8… until it doesn't raise error. The value which doesn't get error is max. – Jack Mar 30 '19 at 05:48

0 Answers0