回答編集履歴
1
Update
test
CHANGED
@@ -3,7 +3,7 @@
|
|
3
3
|
dfg['過去TOP率'] = \
|
4
4
|
dfg.assign(v = dfg['売上順位'].where(dfg['売上順位'] == 1, 0))\
|
5
5
|
.groupby('index', sort=False, group_keys=False)\
|
6
|
-
.apply(lambda x: x.sort_values('date')['v'].cumsum().shift()/range(
|
6
|
+
.apply(lambda x: x.sort_values('date')['v'].cumsum().shift()/range(len(x)))\
|
7
7
|
.fillna(0)
|
8
8
|
df = dfg.set_index('index').rename_axis(None, axis=0)
|
9
9
|
print(df)
|