how to convert a column with string datetime to datetime format

Question

i want to convert a column with string date '19 Desember 2022' for example (the month name is in Indonesian), to supported datetime format without translating it, how do i do that?

already tried this one df_train['date'] = pd.to_datetime(df_train['date'], format='%d %B %Y') but got error time data '19 Desember 2022' does not match format '%d %B %Y' (match)

incase if anyone want to see the row image

no in bahasa(indonesian language) Desember is December, thats what am asking for, how to make it datetime format without have to translate it to english — abbym
– abbym, Commented Jan 5, 2023 at 18:44
then replace in your data replace Desember to December then apply time formate — Hackaholic
– Hackaholic, Commented Jan 5, 2023 at 18:48

Michael S. · Accepted Answer · 2023-01-05 18:58:14Z

1

Try using dateparser

import dateparser
df_train = pd.DataFrame(['19 Desember 2022', '20 Desember 2022', '21 Desember 2022', '22 Desember 2022'], columns = ['date'])
df_train['date'] = [dateparser.parse(x) for x in df_train['date']]
df_train

Output:

    date
0   2022-12-19
1   2022-12-20
2   2022-12-21
3   2022-12-22

answered Jan 5, 2023 at 18:58

Michael S.

3,1485 gold badges21 silver badges37 bronze badges

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

Comments

Jason Baker · Accepted Answer · 2023-01-05 18:55:05Z

0

Pandas doesn't recognize bahasa(indonesian language) Try replacing the spelling of December (as pointed out you can use a one liner and create a new column):

df_train["formatted_date"] = pd.to_datetime(df_train["date"].str.replace("Desember", "December"), format="%d %B %Y")
print(df_train)

Output:

  user_type              date formatted_date
0   Anggota  19 Desember 2022     2022-12-19
1   Anggota  19 Desember 2022     2022-12-19
2   Anggota  19 Desember 2022     2022-12-19
3   Anggota  19 Desember 2022     2022-12-19
4   Anggota  19 Desember 2022     2022-12-19

edited Jan 5, 2023 at 18:55

answered Jan 5, 2023 at 18:46

Jason Baker

3,7262 gold badges14 silver badges18 bronze badges

4 Comments

Michael S. Over a year ago

Or just as a one-liner: df_train['date'] = pd.to_datetime(df_train['date'].str.replace('Desember', 'December'), format='%d %B %Y')

abbym Over a year ago

is there anyway to keep the month "Desember" ? id like to keep it in Indonesian without have to translate the month format

Jason Baker Over a year ago

no I don't think you can

Hackaholic Over a year ago

Add a new column with the replace

Collectives™ on Stack Overflow

how to convert a column with string datetime to datetime format

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related