给定以下数据帧:
import numpy as np
df = pd.DataFrame({'price': np.random.random_integers(0, high=100, size=100)})
ranges = [0,10,20,30,40,50,60,70,80,90,100]
df.groupby(pd.cut(df.price, ranges)).count()
输出:
price
price
(0, 10] 9
(10, 20] 11
(20, 30] 11
(30, 40] 9
(40, 50] 16
(50, 60] 7
(60, 70] 10
(70, 80] 9
(80, 90] 14
(90, 100] 4
我该如何 reset_index
并将列名更改为 bins
和 counts
?谢谢。
bins counts
0 (0, 10] 9
1 (10, 20] 11
2 (20, 30] 11
3 (30, 40] 9
4 (40, 50] 16
5 (50, 60] 7
6 (60, 70] 10
7 (70, 80] 9
8 (80, 90] 14
9 (90, 100] 4