回答編集履歴
1
サンプルコードが間違っており、Xを分割していたのでＺで分割するように修正
answer
CHANGED
|
@@ -29,21 +29,21 @@
|
|
|
29
29
|
# 3 A 7.169748 0.063047 451.124719
|
|
30
30
|
# 4 J 33.558887 97.523463 97.186348
|
|
31
31
|
|
|
32
|
-
#
|
|
32
|
+
# Z を 0～50 の範囲で 5 刻みで分割
|
|
33
|
-
df['Range'] = pd.cut(x=df['
|
|
33
|
+
df['Range'] = pd.cut(x=df['Z'], bins=np.arange(0,55,5))
|
|
34
34
|
# カウントデータを縦軸を範囲、横軸をTypeとしてpovotテーブルで表示
|
|
35
|
-
result = pd.pivot_table(df, columns='Type', index='Range', values='
|
|
35
|
+
result = pd.pivot_table(df, columns='Type', index='Range', values='Z', aggfunc='count')
|
|
36
36
|
print(result)
|
|
37
37
|
# Type A B C D E F G H I J
|
|
38
|
-
# Range
|
|
38
|
+
# Range
|
|
39
|
-
# (0, 5]
|
|
39
|
+
# (0, 5] 16 13 6 7 6 7 8 5 9 9
|
|
40
|
-
# (5, 10]
|
|
40
|
+
# (5, 10] 6 12 8 14 12 11 9 13 8 7
|
|
41
|
-
# (10, 15]
|
|
41
|
+
# (10, 15] 12 10 8 10 12 8 7 12 11 11
|
|
42
|
-
# (15, 20]
|
|
42
|
+
# (15, 20] 12 18 14 6 7 11 7 10 9 15
|
|
43
|
+
# (20, 25] 15 11 9 12 7 11 6 12 6 14
|
|
44
|
+
# (25, 30] 7 10 4 14 7 5 12 12 9 14
|
|
45
|
+
# (30, 35] 15 15 8 5 8 9 11 4 10 12
|
|
46
|
+
# (35, 40] 7 13 15 9 9 9 6 12 11 10
|
|
43
|
-
# (
|
|
47
|
+
# (40, 45] 11 6 14 3 11 10 6 11 11 9
|
|
44
|
-
# (25, 30] 46 59 51 36 57 54 40 50 44 63
|
|
45
|
-
# (30, 35] 56 48 27 36 58 51 45 55 44 57
|
|
46
|
-
# (35, 40] 49 48 42 54 51 60 46 51 53 59
|
|
47
|
-
# (40, 45] 49 46 61 44 47 51 42 50 43 50
|
|
48
|
-
# (45, 50]
|
|
48
|
+
# (45, 50] 15 18 9 11 12 15 8 10 9 15
|
|
49
49
|
```
|