我會根據日期保留最近的劇集。例如,對于s001,我會保留 2022-04-05 的記錄,因為它比另一個更新
import pandas as pd
import datetime
record = ['s001', 's002', 's003', 's002', 's004', 's003',
's004', 's001', 's004', 's003', 's002', 's005']
base = datetime.date.today()
date_list = [base - datetime.timedelta(days=x) for x in range(len(record))]
df = pd.DataFrame({
"id": record,
"date_visited": date_list
})
print(df.sort_values('id'))
uj5u.com熱心網友回復:
df.sort_values('date_visited').drop_duplicates(['id'], keep='last')
看這里和這里
轉載請註明出處,本文鏈接:https://www.uj5u.com/qiye/456070.html
上一篇:用字典修改資料框列
