CODEWITHSUNDEEP
pythonpandasdataframe
Toeffe
Toeffe

Reputation: 25

How do I convert this date from a string to datetime in Pandas?

I am trying to extract datetime from a string in a pandas dataframe. 'Date' below is in string (DK-locale)

Message date DateConverted
blabla 9. okt. 2021 11.41 NaT
blabla 9. okt. 2021 11.38 NaT
blabla 9. okt. 2021 11.01 NaT

My cell in jupyter trying to convert looks like this:

import pandas as pd

df = pd.read_csv("messages.csv", sep=",")
df['DateConverted'] = pd.to_datetime(df['Date'], errors='coerce' ,format='%d. %b. %Y %I.%M'

I've tried a few variations on the format, but nothing yields results. Does anyone know what I'm missing?

Upvotes: 0

Views: 100

Answers (1)

Nikolaos Chatzis
Nikolaos Chatzis

Reputation: 1979

You can try:

>>> import locale
>>> locale.setlocale(locale.LC_ALL, 'da_DK')
'da_DK'
>>>
>>> df['DateConverted'] = pd.to_datetime(df['date'], format='%d. %b. %Y %I.%M')
>>>
>>> df
  Message                date       DateConverted
0  blabla  9. okt. 2021 11.41 2021-10-09 11:41:00
1  blabla  9. okt. 2021 11.38 2021-10-09 11:38:00
2  blabla  9. okt. 2021 11.01 2021-10-09 11:01:00
>>>
>>> df.dtypes
Message                  object
date                     object
DateConverted    datetime64[ns]
dtype: object

Upvotes: 2

Related Questions