Pandas 按组分组并选择每个组中的最新数据

import pandas as pd

df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie', 'Alice', 'Bob'],
    'Score': [80, 90, 70, 95, 85],
    'Date': ['2021-01-01', '2021-01-01', '2021-01-01', '2021-01-02', '2021-01-02']
})

       Name  Score        Date
0     Alice     80  2021-01-01
1       Bob     90  2021-01-01
2   Charlie     70  2021-01-01
3     Alice     95  2021-01-02
4       Bob     85  2021-01-02

df_sorted = df.sort_values('Date').groupby('Name').apply(lambda x: x.iloc[-1])

           Name  Score        Date
Name                             
Alice     Alice     95  2021-01-02
Bob         Bob     85  2021-01-02
Charlie  Charlie     70  2021-01-01

df_sorted = df.sort_values('Date')

df_grouped = df_sorted.groupby('Name')

df_latest = df_grouped.apply(lambda x: x.iloc[-1])