Conversion of integer values into days in pandas

Question

How do I convert the datatype of a column from integer to timedelta days format? I tried doing it but got the following error.

new_monthly5['APPROVED LEAVES'] = new_monthly5['APPROVED 
LEAVES']+timedelta(days=1)

TypeError: unsupported operand type(s) for +: 'numpy.ndarray' and 'Timedelta'

Also, I tried it another way but still it didn't work.

pd.to_timedelta(new_monthly5['APPROVED LEAVES'], unit='D')

Does this answer your question? [Convert integer series to timedelta in pandas](https://stackoverflow.com/questions/34519536/convert-integer-series-to-timedelta-in-pandas) — Yulian, Feb 20 '21 at 18:46
It is in the dataframe format but currently the picture is not getting posted. — Hammad Malick, Feb 20 '21 at 19:56

score 1 · Answer 1 · answered Feb 20 '21 at 21:40

1

"Timedelta" or "Timedelta days" are not type formats. You need to convert your column to "datetime" first. Then you can use datetime.timedelta command to add or substract time. Use pd.to_datetime with unit='s' if the integer data are unix time.

answered Feb 20 '21 at 21:40

Ehsan YazdanBakhsh

11
2

Can not convert it into date time as the column contains integer values. – Hammad Malick Feb 21 '21 at 06:01

Conversion of integer values into days in pandas

1 Answers1