[SciPy-user] scikits.timeseries : Problem using tsfromtxt with converter
Dharhas Pothina
Dharhas.Pothina at twdb.state.tx.us
Thu Jul 16 09:08:07 EDT 2009
Hi,
I have data in the following format:
Date, 28.898 -95.334
09/01/2008 00:00, 0mm
09/01/2008 01:00, 0mm
09/01/2008 02:00, 0mm
...
If I read it using
data = ts.tsfromtxt(file,skiprows=1,datecols=(0),delimiter=',',freq = 'H')
It reads in correctly but the data is read in as strings with the 'mm'. ie
timeseries(
[[ 0mm]
[ 0mm]
...,
[ 0mm]],
dates =
[01-Sep-2008 00:00 ... 01-Jun-2009 23:00],
freq = H)
I want to remove the 'mm' and read the data as floats. I tried using a converter:
conv = {1: lambda s: s.split('m')[0]}
data = ts.tsfromtxt(file,skiprows=1,datecols=(0),delimiter=',',freq = 'H',converters=conv)
but then I get an error which seems to have something to do with the date converter that was working in the earlier command:
/usr/lib64/python2.5/site-packages/scikits.timeseries-0.91.1-py2.5-linux-x86_64.egg/scikits/timeseries/extras.pyc in tsfromtxt(fname, dtype, freq, comments, delimiter, skiprows, converters, dateconverter, missing, missing_values, usecols, datecols, names, excludelist, deletechars, case_sensitive, unpack, loose, asrecarray)
433 if len(dateinfo) == 1:
434 dateinfo = np.array(dateinfo[0], copy=False, ndmin=1)
--> 435 dates = date_array([dateconv(args) for args in dateinfo],
436 freq=freq, autosort=False)
437 else:
UnboundLocalError: local variable 'dateconv' referenced before assignment
What am I doing wrong?
thanks
- dharhas
More information about the SciPy-User
mailing list