回答編集履歴

Update

2022/06/22 02:21

投稿

スコア19825

test CHANGED Viewed

@@ -1,19 +1,18 @@
 ```python
-df_per = df.groupby('Type').apply(lambda x:
+df_per = df.groupby('Type')\
-             pd.Series([len(x.query('-30 <= Score1 < 30'))/len(x),
+           .apply(lambda x: len(x.query('-30 <= Score1 < 30 and 55 <= Score2 < 100'))/len(x))\
-                        len(x.query('55 <= Score2 < 100'))/len(x)],
+           .to_frame('ratio')
-                       index=['-30 <= Score1 < 30', '55 <= Score2 < 100']))
 print(df_per)
 #
-      -30 <= Score1 < 30  55 <= Score2 < 100
+      ratio
-Type
+Type
-CB                  0.56                0.30
+CB     0.18
-CU                  0.65                0.34
+CU     0.14
-FF                  0.60                0.25
+FF     0.20
-SI                  0.57                0.25
+SI     0.19
-SL                  0.58                0.31
+SL     0.20
-SP                  0.59                0.28
+SP     0.18
 ```