how to group by list ranges of value in python pandas

Question

I have following dataframe

name,value
a,100
b,200
c,150
d,300
e,400
f,200
g,100

i have list of ranges like [0-100,100-200,more than 200]

based on this i have to take count of records in above dataframe.

i need output like

category,count
0-100,2
100-200,3
mor than 200,3

If I'm not here to close as duplicate, these keep getting answered — cs95, Jan 16 '18 at 12:01

score 8 · Accepted Answer · answered Jan 16 '18 at 12:00

8

Use groupby + cut:

bins = [-1, 100, 200, np.inf]
labels=['0-100','100-200','more than 200']
df=df.groupby(pd.cut(df['value'], bins=bins, labels=labels)).size().reset_index(name='count')
print (df)
           value  count
0          0-100      2
1        100-200      3
2  more than 200      2

answered Jan 16 '18 at 12:00

jezrael

822,522
95
1,334
1,252

raise ValueError('Bin labels must be one fewer than ' ValueError: Bin labels must be one fewer than the number of bin edges – Sai Rajesh Jan 16 '18 at 12:19
i am getting above error – Sai Rajesh Jan 16 '18 at 12:19
bins = [-1, 1000000, 5000000, 20000000, np.inf] labels = ['0-1000000', '1000000-5000000', '5000000-20000000' 'more than 20000000']df = data.groupby(pd.cut(data['amount'], bins=bins, labels=labels)).size().reset_index(name='count') – Sai Rajesh Jan 16 '18 at 12:20
There is typo in `labels = ['0-1000000', '1000000-5000000', '5000000-20000000', 'more than 20000000']`, you forget last `,` – jezrael Jan 16 '18 at 12:23
oh sorry..thank you so much:) – Sai Rajesh Jan 16 '18 at 12:24
1

Hmmm, in my opinion very hard finding error, because unclear error. You are welcome! – jezrael Jan 16 '18 at 12:24
here how to take that column sum instead of count for records?? – Sai Rajesh Jan 16 '18 at 13:36
2

Use `df=df.groupby(pd.cut(df['value'], bins=bins, labels=labels))['value'].sum().reset_index(name='sum')` – jezrael Jan 16 '18 at 13:39

how to group by list ranges of value in python pandas

1 Answers1

Linked