I am using Pandas to read a Sas dataset using read_sas
There is a datetime variable in the SAS dataset, which appears in Pandas as:
1.775376e+09
Once I convert it to str
the date is:
1775376002.0
The corresponding date in SAS (not in my Pandas dataset) appears to be a DATETIME21.2
04APR2016:08:00:02.00
I tried to convert it using
pd.to_datetime(df.mysasdate,format='%d%m%Y%H%M%S')
with no success
TypeError: 'float' object is unsliceable
Any ideas?
Thanks!
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…