How to Remove Time Components When Using pandas.to_datetime?

Remove Time Component When Using pandas.to_datetime

When parsing dates using pandas.to_datetime, pandas assigns a default datetime64[ns] dtype, even if the dates represent only days. This can result in unwanted time components being appended to the dates when writing to CSV.

To overcome this, consider using .dt to access solely the date component:

df['just_date'] = df['dates'].dt.date

This approach returns datetime.date objects with an object dtype. Alternatively, you can normalize the dates to maintain the datetime64 dtype while suppressing the time component:

df['normalised_date'] = df['dates'].dt.normalize()

This sets the time component to midnight but displays only the date value.

The above is the detailed content of How to Remove Time Components When Using pandas.to_datetime?. For more information, please follow other related articles on the PHP Chinese website!