Pandas: New Date Variable From Datetime Variable

Question

I have a large dataset with a datetime variable "CHECKIN_DATE_TIME" and would like to create a new variable that is just the date sans the time. The "CHECKIN_DATE_TIME" is formatted as such 2020-02-01 11:13:17.000. I want the new variable to be formatted like 2020-02-01.

I'm referencing the following for help https://www.programiz.com/python-programming/datetime/strptime but when I write my code, I'm getting attribute errors: "Traceback(most recent call last)" and "DataFrame' object has no attribute 'strptime'"

import datetime
NOTES_TAT=NOTES_TAT.strptime(CHECKIN_DATE_TIME,"%d %B, %Y")

What is the type of NOTES_TAT? Seems a pandas dataframe? give an example of this dataframe (say NOTES_TAT.head()) — Itamar Katz
– Itamar Katz, Commented Apr 2, 2020 at 21:07

Scott Boston · Accepted Answer · 2020-04-02 21:07:02Z

2

You are using pandas dataframe. Try,

NOTES_TAT['CHECKIN_DATE_TIME'].dt.strftime('%d %B, %Y')

answered Apr 2, 2020 at 21:07

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

s3dev · Accepted Answer · 2020-04-02 21:19:47Z

1

You can access the datetime wrapper via the .dt DataFrame accessor. To get just the date, use the .date property at the end.

Example:

import pandas as pd

# Build a sample DataFrame
df = pd.DataFrame({'checkin': '2020-02-01 11:13:17.000'}, index=[0])
df['checkin'] = pd.to_datetime(df['checkin'])

# Create the date column using the `date` property.
df['date'] = df['checkin'].dt.date
# For a formatted date:
df['date'] = df['checkin'].dt.strftime('%d %B, %Y')

Output 1:

              checkin        date
0 2020-02-01 11:13:17  2020-02-01

Output 2:

              checkin               date
0 2020-02-01 11:13:17  01 February, 2020

edited Apr 2, 2020 at 21:19

answered Apr 2, 2020 at 21:09

s3dev

9,8713 gold badges34 silver badges49 bronze badges

2 Comments

Raven Over a year ago

Thanks @S3DEV So I'm still getting the same error when I run: df['date'] = df['checkin'].dt.strftime('%d %B, %Y'). The datatype for Checkin_date_time is 'object'. Do I need to change the datatype for Checkin_date_time?

Raven Over a year ago

Disregard, i reformatted the Checkin_date_time variable to datetime using this code:NOTES_TAT_v1['Date'] = pd.to_datetime(NOTES_TAT_v1['CHECKIN_DATE_TIME'], infer_datetime_format=True)

Collectives™ on Stack Overflow

Pandas: New Date Variable From Datetime Variable

2 Answers 2

Comments

Example:

Output 1:

Output 2:

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Example:

Output 1:

Output 2:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related