There's a statement that I usually include in all of my code that assures I know where my starting directory is localed:
os.chdir(os.path.abspath(os.path.dirname(__file__)))
I thought that I had added that, but didn't so IT's loading the file in, but still not happy, now getting
Error:
Traceback (most recent call last):
File ".../Projects/T-Z/T/TryStuff/src/ticks.py", line 9, in <module>
'id', 'rdate', 'rtype', 'hist', 'scan'], usecols=[0, 1, 2, 3, 4])
File ".../Projects/T-Z/T/TryStuff/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 697, in parser_f
return _read(filepath_or_buffer, kwds)
File ".../Projects/T-Z/T/TryStuff/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 430, in _read
data = parser.read(nrows)
File ".../Projects/T-Z/T/TryStuff/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 1134, in read
ret = self._engine.read(nrows)
File ".../Projects/T-Z/T/TryStuff/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 1990, in read
data = self._reader.read(nrows)
File "pandas/_libs/parsers.pyx", line 899, in pandas._libs.parsers.TextReader.read
File "pandas/_libs/parsers.pyx", line 914, in pandas._libs.parsers.TextReader._read_low_memory
File "pandas/_libs/parsers.pyx", line 991, in pandas._libs.parsers.TextReader._read_rows
File "pandas/_libs/parsers.pyx", line 1050, in pandas._libs.parsers.TextReader._convert_column_data
pandas.errors.ParserError: Too many columns specified: expected 5 and found 1
Which I'm sure I can figure out, I just need to get a time slot to do that. Should be a simple fix
I have 32 Gig of memory, so don't know why It shows low_memory