好的，我认为最简单的方法是
TimedeltaIndex从浮点数构造a并将其添加到以下标量日期时间中
1900,1,1：
In [85]:import datetime as dtimport pandas as pddf = pd.Dataframe({'date':[42580.3333333333, 10023]})dfOut[85]:date0 42580.3333331 10023.000000In [86]:df['real_date'] = pd.TimedeltaIndex(df['date'], unit='d') + dt.datetime(1900,1,1)dfOut[86]:date real_date0 42580.333333 2016-07-31 07:59:59.9712001 10023.000000 1927-06-12 00:00:00.000000好的，似乎Excel的日期有点奇怪，谢谢@ayhan：
In [89]:df['real_date'] = pd.TimedeltaIndex(df['date'], unit='d') + dt.datetime(1899, 12, 30)dfOut[89]:date real_date0 42580.333333 2016-07-29 07:59:59.9712001 10023.000000 1927-06-10 00:00:00.000000
