CODEWITHSUNDEEP
pythonpandasdatetimetimestampstrptime
BusterTheFatCat
BusterTheFatCat

Reputation: 57

How to convert python dataframe timestamp to datetime format

I have a dataframe with date information in one column.

enter image description here

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.

Upvotes: 0

Views: 2967

Answers (1)

YOLO
YOLO

Reputation: 21709

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

Upvotes: 2

Related Questions