回答編集履歴

1

2023/01/09 03:25

投稿

melian
melian

スコア19825

test CHANGED
@@ -20,9 +20,9 @@
20
20
 
21
21
  #
22
22
  cols = ['mbr_no', 'Return_num', 'sales_num']
23
- dfx = df[cols].drop_duplicates().query('Return_num/sales_num >= 0.5')
23
+ dfx = df.drop_duplicates(subset=cols).query('Return_num/sales_num >= 0.5')
24
24
  print(dfx)
25
25
 
26
- # mbr_no Return_num sales_num
26
+ # mbr_no goods_name Return_num sales_num
27
- # 8 1024 10 15
27
+ # 8 1024 ○○○ 10 15
28
28
  ```