Error with sampleData_NPM_1

[pauladkisson]

In sampleData_NPM_1, I get an error in step three when I try to read the raw data:

Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 567, in <module>
    main(input_parameters=input_parameters)
    ~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 563, in main
    raise e
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 557, in main
    readRawData(input_parameters)
    ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 541, in readRawData
    execute_import_doric(filepath, storesList, flag, op)
    ~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 460, in execute_import_doric
    raise Exception('More than one Doric csv file present at the location')
Exception: More than one Doric csv file present at the location

I tracked it down to readTevTsq.py, line 99, in which the following code:

df = pd.read_csv(path[i], index_col=False, dtype=float)

Raises the following error:

Traceback (most recent call last):
  File "pandas/_libs/parsers.pyx", line 1161, in pandas._libs.parsers.TextReader._convert_tokens
TypeError: Cannot cast array data from dtype('O') to dtype('float64') according to the rule 'safe'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 576, in <module>
    main(input_parameters=input_parameters)
    ~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 572, in main
    raise e
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 566, in main
    readRawData(input_parameters)
    ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 533, in readRawData
    flag = check_doric(filepath)
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 104, in check_doric
    raise(e)
  File "/Users/pauladkisson/Documents/CatalystNeuro/Guppy/GuPPy/src/guppy/readTevTsq.py", line 102, in check_doric
    df = pd.read_csv(path[i], index_col=False, dtype=float)
  File "/opt/anaconda3/envs/guppy_env/lib/python3.13/site-packages/pandas/io/parsers/readers.py", line 1026, in read_csv
    return _read(filepath_or_buffer, kwds)
  File "/opt/anaconda3/envs/guppy_env/lib/python3.13/site-packages/pandas/io/parsers/readers.py", line 626, in _read
    return parser.read(nrows)
           ~~~~~~~~~~~^^^^^^^
  File "/opt/anaconda3/envs/guppy_env/lib/python3.13/site-packages/pandas/io/parsers/readers.py", line 1923, in read
    ) = self._engine.read(  # type: ignore[attr-defined]
        ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        nrows
        ^^^^^
    )
    ^
  File "/opt/anaconda3/envs/guppy_env/lib/python3.13/site-packages/pandas/io/parsers/c_parser_wrapper.py", line 234, in read
    chunks = self._reader.read_low_memory(nrows)
  File "pandas/_libs/parsers.pyx", line 838, in pandas._libs.parsers.TextReader.read_low_memory
  File "pandas/_libs/parsers.pyx", line 921, in pandas._libs.parsers.TextReader._read_rows
  File "pandas/_libs/parsers.pyx", line 1066, in pandas._libs.parsers.TextReader._convert_column_data
  File "pandas/_libs/parsers.pyx", line 1167, in pandas._libs.parsers.TextReader._convert_tokens
ValueError: could not convert string to float: 'pinknoise'

Originally posted by @pauladkisson in #153 (comment)