pandas convert string to date (the string time is B.E year)

user_11695177 0
Viewed 39

I have a data frame in which a column contains a date having time represent in B.E year format:

   date
28-01-2562
29-01-2562
30-01-2562
31-01-2562

I tried using pd.to_datetime but its give me an error:

  pd.to_datetime(df['date'])

This is the error I got:

  Out of bounds nanosecond timestamp: 2562-01-30 00:00:00
pandas dataframe python
1 Answers

You can convert values to daily periods:

df['date'] = df['date'].apply(pd.Period)
print (df)
         date
0  2562-01-28
1  2562-01-29
2  2562-01-30
3  2562-01-31
user_29010020
Related