Python Pandas Dataframe:每个人最近第二天的值

import pandas as pd

# 创建一个示例Dataframe
data = {'Name': ['Alice', 'Bob', 'Charlie', 'Alice', 'Bob', 'Charlie'],
        'Date': ['2022-01-01', '2022-01-01', '2022-01-01', '2022-01-02', '2022-01-02', '2022-01-02'],
        'Value': [10, 20, 30, 40, 50, 60]}
df = pd.DataFrame(data)

# 将日期列转换为日期类型
df['Date'] = pd.to_datetime(df['Date'])

# 按照日期列排序
df = df.sort_values('Date')

# 按照人员名称分组
grouped = df.groupby('Name')

# 将每个人员的值向后移动一天
df['Previous Day Value'] = grouped['Value'].shift(1)

# 查看结果
print(df.head())

      Name       Date  Value  Previous Day Value
0    Alice 2022-01-01     10                 NaN
1      Bob 2022-01-01     20                 NaN
2  Charlie 2022-01-01     30                 NaN
3    Alice 2022-01-02     40                10.0
4      Bob 2022-01-02     50                20.0