[ Python 常見問題 ] Pandas - Binning column with python pandas

 Source From Here

Question
I have a DataFrame column with numeric values:

view plaincopy to clipboardprint?

1. import pandas as pd  
2.   
3. df = pd.DataFrame([[46.5], [44.2], [100.0], [42.12]], columns=['percentage'])  

I want to see the column as bin counts:

view plaincopy to clipboardprint?

1. bins = [0, 1, 5, 10, 25, 50, 100]  

How can I get the result as bins with their value counts?

HowTo
You can leverage API pandas.cut to bin the target column:


Then you can leverage another API DataFrame.groupby to calculate the count:


Or:

view plaincopy to clipboardprint?

1. df['binned'].value_counts()  

Output:

view plaincopy to clipboardprint?

1. 25-50     3  
2. 50-100    1  
3. 10-25     0  
4. 5-10      0  
5. 1-5       0  
6. 0-10      0  
7. Name: binned, dtype: int64