one column csv import error

[krajcsi]

When the csv or clipboard data include only a single column, separator is not found correctly (which is actually missing in those cases). This comes from the pd.read_csv() function where parameter sep=None. Alternative solution also should automatically detect the format of the csv files.

[krajcsi]

see the issue in pandas-dev/pandas#53035

consider using https://github.com/alan-turing-institute/CleverCSV instead (although at the moment, clevercsv cannot handle io.StringIO() )

Unfortunately, with a test file, clevercsv cannot read single column csv file:

  File "/home/attila/Programs/CogStat_venv_py310/lib/python3.10/site-packages/clevercsv/wrappers.py", line 337, in read_dataframe
    csv_dialect = dialect.to_csv_dialect()
  File "/home/attila/Programs/CogStat_venv_py310/lib/python3.10/site-packages/clevercsv/dialect.py", line 118, in to_csv_dialect
    return dialect()
  File "/usr/lib/python3.10/csv.py", line 45, in __init__
    self._validate()
  File "/usr/lib/python3.10/csv.py", line 52, in _validate
    raise Error(str(e))
_csv.Error: "delimiter" must be a 1-character string