python - Pandas:时间戳转换为 YYYY-MM-DD

Question

我不断得到这些结果:

0   2019-02-28 19:24:18.101586+00:00
1   2019-03-01 08:33:15.668978+00:00
[...]
Name: created, dtype: datetime64[ns, UTC]

但是，我的目标是获得这些结果:

0   2019-02-28
1   2019-03-01

你看出我做错了什么了吗？

# Load data
def load_ticket_data():
    df = pd.read_csv(
        'wolfsburg/tickets_ticket.csv',
        usecols=['created', 'start_at'],
        parse_dates=['created', 'start_at'],
    )
    return df

tickets = load_ticket_data()
test = pd.to_datetime(tickets['created'], format='%y/%m/%d')
print(test)

Answer 1

如果需要没有时间的日期时间，请使用 Series.dt.tz_localize与 Series.dt.floor :

tickets['created'] = tickets['created'].dt.tz_localize(None).dt.floor('d')
print (tickets)
     created
0 2019-02-28
1 2019-03-01

print (tickets.dtypes)
created    datetime64[ns]
dtype: object