我认为你需要将频率更改为月初频率
- MS
- 参见偏移别名
:
import pandas as pd
fwd_df = pd.DataFrame(
{
"Dubai m1": {
pd.Timestamp("2016-08-01 00:00:00"): 3,
pd.Timestamp("2016-07-01 00:00:00"): 2,
pd.Timestamp("2016-09-01 00:00:00"): 4,
pd.Timestamp("2016-06-01 00:00:00"): 1,
}
}
)
print(fwd_df["Dubai m1"])
# 2016-06-01 1
# 2016-07-01 2
# 2016-08-01 3
# 2016-09-01 4
# Name: Dubai m1, dtype: int64
print(fwd_df["Dubai m1"].shift(1, freq="MS"))
# 2016-07-01 1
# 2016-08-01 2
# 2016-09-01 3
# 2016-10-01 4
# Freq: MS, Name: Dubai m1, dtype: int64