Convert from float to datetime in Python

Question

I have a dataframe which datatype is float64 and I want to change it to datetime 64. But the result is return to only one day : 1970-01-01 no matter which method I use. Any help please

df.product_first_sold_date = [41245,0, 37659.0,40487.0,41701.0,40649.0]
dt.cv = pd.to_datetime(df.product_first_sold_date)
dt.cv
dt.cv2 = df.product_first_sold_date.apply(lambda x: datetime.fromtimestamp(x).strftime('%m-%d-%Y') if x==x else None)
dt.cv2

@QuangHoang: as I check in excel , the expected date for 41245 is 2012-12-02 — Suzie
– Suzie, Commented Jun 5, 2020 at 4:54

Shijith · Accepted Answer · 2020-06-05 05:00:26Z

4

I believe you re dealing with Excel date type which is the number of days since ~~1900-01-01~~, as @Dishin pointed out 1899-12-30

# sample data:
df = pd.DataFrame({'date':[41245,37659,40487]})

# convert - adjust 1900-01-01 to the correct day
df['date'] = pd.to_timedelta(df.date, unit='D') + pd.to_datetime('1899-12-30')

Output:

        date
0 2012-12-02
1 2003-02-07
2 2010-11-05

edited Jun 5, 2020 at 5:00

Shijith

4,9322 gold badges23 silver badges38 bronze badges

answered Jun 5, 2020 at 4:43

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

2 Comments

Dishin Goyani Over a year ago

I think OLE start from "30 December 1899"

Dishin Goyani Over a year ago

So 41245 is suppose to be "2012-12-02"

Collectives™ on Stack Overflow

Convert from float to datetime in Python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related