# %%
import numpy as np
import pandas as pd
# %%
df = pd.read_excel('./data/demo_04.xlsx')
df.head()
# %% [markdown]
# # 数据偏移
# %%
# 1.shift函数
# periods, 偏移数目
# freq, 时间频率,Y,Q,M,D,H,T/min,S
# axis, 轴,0为行,1为列
# fill_value, 填充空值
# %%
# 日期是连续的
# df['上期销量'] = df['销量'].shift(periods=1)
# df['销量增长率'] = (df['销量'] - df['上期销量'])/df['上期销量']
# df['销量增长率'] = df['销量增长率'].apply(
# lambda x: np.nan if pd.isnull(x) else '{:.2%}'.format(x))
# df.head()
# %%
# 日期是不连续的,设置时间序列字段为行索引
df = df.set_index('日期')
df['上期销量'] = df['销量'].shift(periods=1, freq='D'