回答編集履歴
1
answer
CHANGED
|
@@ -13,10 +13,11 @@
|
|
|
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
|
|
22
23
|
# 1 2023-01-01 B 100 NaN
|