I have a df with a column:
The column datatype is an object.
I am trying to change it to a datatype date.
This is what I’ve tried:
df['column'] = pd.to_datetime(df['column']).dt.strftime(%d-%b')
This is the error I receive:
pandas._libs.tslibs.np_datetime.OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 1-12-01 00:00:00
Would really appreciate you help 🙏
You can use:
df['date'] = pd.to_datetime(df['column'], format='%b-%d').dt.strftime('%m/%d/22')
NB. you must hardcode the year as it is undefined in your original data and pandas will by default use 1970.
column date 0 Dec-01 12/01/22