In [1]:
import pandas as pd
import datetime as dt
from io import StringIO
In [2]:
x = '''
"day","lon","lat"
1,-85.6274819865272,15.7646163992594
2,-85.5692877454028,15.7641985987015
3,-85.5094791764111,15.7622887663688
4,-85.4483447087322,15.7589891159789
5,-85.3861730691902,15.7544022103013
6,-85.3232532673483,15.7486309909442
'''
In [9]:
# parser to convert integer yeardays to datetimes in 2015
def parse(day):
date = dt.datetime(2015,1,1,0,0) + dt.timedelta(days=(int(day)-1))
return date
In [10]:
df = pd.read_csv(StringIO(x.strip()),parse_dates=True, date_parser=parse, index_col=0)
In [ ]: