Keep only date part when using pandas.to_datetime

Simple Solution:

df['date_only'] = df['date_time_column'].dt.date

While I upvoted EdChum's answer, which is the most direct answer to the question the OP posed, it does not really solve the performance problem (it still relies on python datetime objects, and hence any operation on them will be not vectorized - that is, it will be slow).

A better performing alternative is:

df['dates'].dt.floor('d')

Strictly speaking, it does not "keep only date part", since it just sets the time to 00:00:00. But it does work as desired by the OP when, for instance:

• printing to screen
• saving to csv
• using the column to groupby

... and it is much more efficient, since the operation is vectorized.

EDIT: in fact, the answer the OP's would have preferred is probably "recent versions of pandas do not write the time to csv if it is 00:00:00 for all observations".

Pandas v0.13+: Use to_csv with date_format parameter

Avoid, where possible, converting your datetime64[ns] series to an object dtype series of datetime.date objects. The latter, often constructed using pd.Series.dt.date, is stored as an array of pointers and is inefficient relative to a pure NumPy-based series.

Since your concern is format when writing to CSV, just use the date_format parameter of to_csv. For example:

df.to_csv(filename, date_format='%Y-%m-%d')

See Python's strftime directives for formatting conventions.

This is a simple way to extract the date:

import pandas as pdd='2015-01-08 22:44:09' date=pd.to_datetime(d).date()print(date)

Pandas DatetimeIndex and Series have a method called normalize that does exactly what you want.

You can read more about it in this answer.

It can be used as ser.dt.normalize()

df['Column'] = df['Column'].dt.strftime('%m/%d/%Y')

This will give you just the dates and NO TIME at your desired format. You can change format according to your need '%m/%d/%Y'. It will change the data type of the column to 'object'.

If you want just the dates and DO NOT want time in YYYY-MM-DD format use :

df['Column'] = pd.to_datetime(df['Column']).dt.date

The datatype will be 'object'.

For 'datetime64' datatype, use:

df['Column'] = pd.to_datetime(df['Column']).dt.normalize()

Just giving a more up to date answer in case someone sees this old post.

Adding "utc=False" when converting to datetime will remove the timezone component and keep only the date in a datetime64[ns] data type.

pd.to_datetime(df['Date'], utc=False)

You will be able to save it in excel without getting the error "ValueError: Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel."

Converting to datetime64[D]:

df.dates.values.astype('M8[D]')

Though re-assigning that to a DataFrame col will revert it back to [ns].

If you wanted actual datetime.date:

dt = pd.DatetimeIndex(df.dates)dates = np.array([datetime.date(*date_tuple) for date_tuple in zip(dt.year, dt.month, dt.day)])

I wanted to be able to change the type for a set of columns in a data frame and then remove the time keeping the day. round(), floor(), ceil() all work

df[date_columns] = df[date_columns].apply(pd.to_datetime)df[date_columns] = df[date_columns].apply(lambda t: t.dt.floor('d'))

On tables of >1000000 rows I've found that these are both fast, with floor just slightly faster:

df['mydate'] = df.index.floor('d')

or

df['mydate'] = df.index.normalize()

If your index has timezones and you don't want those in the result, do:

df['mydate'] = df.index.tz_localize(None).floor('d')

df.index.date is many times slower; to_datetime() is even worse. Both have the further disadvantage that the results cannot be saved to an hdf store as it does not support type datetime.date.

Note that I've used the index as the date source here; if your source is another column, you would need to add .dt, e.g. df.mycol.dt.floor('d')

This worked for me on UTC Timestamp (2020-08-19T09:12:57.945888)

for di, i in enumerate(df['YourColumnName']):df['YourColumnName'][di] = pd.Timestamp(i)

If the column is not already in datetime format:

df['DTformat'] = pd.to_datetime(df['col'])

Once it's in datetime format you can convert the entire column to date only like this:

df['DateOnly'] = df['DTformat'].apply(lambda x: x.date())