回答編集履歴
1
サンプルコードが間違っており、Xを分割していたのでZで分割するように修正
test
CHANGED
@@ -60,38 +60,38 @@
|
|
60
60
|
|
61
61
|
|
62
62
|
|
63
|
-
#
|
63
|
+
# Z を 0~50 の範囲で 5 刻みで分割
|
64
64
|
|
65
|
-
df['Range'] = pd.cut(x=df['
|
65
|
+
df['Range'] = pd.cut(x=df['Z'], bins=np.arange(0,55,5))
|
66
66
|
|
67
67
|
# カウントデータを縦軸を範囲、横軸をTypeとしてpovotテーブルで表示
|
68
68
|
|
69
|
-
result = pd.pivot_table(df, columns='Type', index='Range', values='
|
69
|
+
result = pd.pivot_table(df, columns='Type', index='Range', values='Z', aggfunc='count')
|
70
70
|
|
71
71
|
print(result)
|
72
72
|
|
73
73
|
# Type A B C D E F G H I J
|
74
74
|
|
75
|
-
# Range
|
75
|
+
# Range
|
76
76
|
|
77
|
-
# (0, 5]
|
77
|
+
# (0, 5] 16 13 6 7 6 7 8 5 9 9
|
78
78
|
|
79
|
-
# (5, 10]
|
79
|
+
# (5, 10] 6 12 8 14 12 11 9 13 8 7
|
80
80
|
|
81
|
-
# (10, 15]
|
81
|
+
# (10, 15] 12 10 8 10 12 8 7 12 11 11
|
82
82
|
|
83
|
-
# (15, 20]
|
83
|
+
# (15, 20] 12 18 14 6 7 11 7 10 9 15
|
84
84
|
|
85
|
-
# (20, 25] 5
|
85
|
+
# (20, 25] 15 11 9 12 7 11 6 12 6 14
|
86
86
|
|
87
|
-
# (25, 30]
|
87
|
+
# (25, 30] 7 10 4 14 7 5 12 12 9 14
|
88
88
|
|
89
|
-
# (30, 35] 5
|
89
|
+
# (30, 35] 15 15 8 5 8 9 11 4 10 12
|
90
90
|
|
91
|
-
# (35, 40]
|
91
|
+
# (35, 40] 7 13 15 9 9 9 6 12 11 10
|
92
92
|
|
93
|
-
# (40, 45]
|
93
|
+
# (40, 45] 11 6 14 3 11 10 6 11 11 9
|
94
94
|
|
95
|
-
# (45, 50] 5
|
95
|
+
# (45, 50] 15 18 9 11 12 15 8 10 9 15
|
96
96
|
|
97
97
|
```
|