How to convert python dataframe timestamp to datetime format

Question

I have a dataframe with date information in one column.

The date visually appears in the dataframe in this format: 2019-11-24

but when you print the type it shows up as:

Timestamp('2019-11-24 00:00:00')

I'd like to convert each value in the dataframe to a format like this:

24-Nov

or

7-Nov

for single digit days.

I've tried using various datetime and strptime commands to convert but I am getting errors.

YOLO · Accepted Answer · 2020-01-07 16:29:49Z

2

Here's a way to do:

df = pd.DataFrame({'date': ["2014-10-23","2016-09-08"]}) 

df['date_new'] = pd.to_datetime(df['date'])

df['date_new'] = df['date_new'].dt.strftime("%d-%b")

         date      date_new
0  2014-10-23      23-Oct
1  2016-09-08      08-Sept

answered Jan 7, 2020 at 16:29

YOLO

22k5 gold badges25 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

How to convert python dataframe timestamp to datetime format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related