回答編集履歴
1
test
CHANGED
@@ -13,9 +13,10 @@
|
|
13
13
|
|
14
14
|
#
|
15
15
|
dfa = df.set_index(['DATE', 'グループ'])
|
16
|
-
dfb = df.
|
16
|
+
dfb = df.set_index([df['DATE'] + pd.DateOffset(years=1), 'グループ'])
|
17
|
-
dfa = dfa.assign(YoY = dfa['値'] / dfb).reset_index()
|
17
|
+
dfa = dfa.assign(YoY = dfa['値'] / dfb['値']).reset_index()
|
18
18
|
print(dfa)
|
19
|
+
|
19
20
|
|
20
21
|
# DATE グループ 値 YoY
|
21
22
|
# 0 2023-01-01 A 100 NaN
|