I am trying to read a CSV file using local_csv() in Research:
data = local_csv('/Users/Desktop/FRED-DGS3MO.csv', date_column='Date')
Repeated attempts failed with errors:
IOErrorTraceback (most recent call last)
in ()
----> 1 data = local_csv('/Users/Desktop/FRED-DGS3MO.csv', date_column='Date')
2 data.head()/build/src/qexec_repo/qexec/research/api.py in local_csv(path,
symbol_column, date_column, use_date_column_as_index, timezone,
symbol_reference_date, *read_csv_kwargs)
286 symbol_reference_date=symbol_reference_date,
287 symbols_function=symbols,
--> 288 *read_csv_kwargs
289 )
290/build/src/qexec_repo/qexec/research/api.pyc in inner_local_csv(path,
symbol_column, date_column, use_date_column_as_index, timezone,
symbol_reference_date, symbols_function, **read_csv_kwargs)
823 if not realpath.startswith(NOTEBOOKDATA_DIR):
824 raise IOError(
--> 825 "Cannot open file {path}.".format(path=path)
826 )
827IOError: Cannot open file /Users/Desktop/FRED-DGS3MO.csv.
CSV data in 2 columns:
Date, Value
2017-08-31, 1.01
2017-08-30, 1.03
2017-08-29, 1.03
2017-08-28, 0.98
2017-08-25, 1.03
2017-08-24, 1.02
Not sure what I have missed.. please help?
Thanks,
Karl