回答編集履歴
1
test
CHANGED
@@ -20,9 +20,9 @@
|
|
20
20
|
|
21
21
|
#
|
22
22
|
cols = ['mbr_no', 'Return_num', 'sales_num']
|
23
|
-
dfx = df
|
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
|
```
|