pandas convert datetime to date code example

Example 1: convert column in pandas to datetime

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

Example 2: convert date time to date pandas

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

Example 3: pandas datetime show only date

# Changing object type column to datetime
df['date_col'] = pd.to_datetime(df.date_col)

# Creating new column with just the date
df['new_date_col'] = df['date_col'].dt.date

Example 4: convert a number column into datetime pandas

# convert the 'Date' column to datetime format
df['Date']= pd.to_datetime(df['Date'])
 
# Check the format of 'Date' column
df.info()

Example 5: pandas convert series of datetime to date

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