Python3去除重复时间方法详解

from datetime import datetime
<p>times = [
datetime(2023, 10, 1, 12, 0),
datetime(2023, 10, 1, 12, 0),  # 重复
datetime(2023, 10, 2, 14, 30),
datetime(2023, 10, 1, 12, 0),  # 重复
]</p><p>unique_times = list(set(times))
print(sorted(unique_times))  # 推荐排序后查看结果</p>

import pandas as pd
from datetime import datetime
<p>df = pd.DataFrame({
'timestamp': [
datetime(2023, 10, 1, 12, 0),
datetime(2023, 10, 1, 12, 0),
datetime(2023, 10, 2, 14, 30),
],
'value': [100, 100, 200]
})</p><p>df_clean = df.drop_duplicates(subset=['timestamp'])
print(df_clean)</p>

# 将 datetime 截断到秒级
def truncate_to_second(dt):
    return dt.replace(microsecond=0)
<p>times_with_ms = [
datetime(2023, 10, 1, 12, 0, 0, 123456),
datetime(2023, 10, 1, 12, 0, 0, 789000),
datetime(2023, 10, 2, 14, 30),
]</p><p>truncated = [truncate_to_second(t) for t in times_with_ms]
unique_truncated = list(set(truncated))
print(sorted(unique_truncated))</p>