Jupyter Notebook において pandas でcsvが読み込めない。

Question

import pandas as pd
data = pd.read_csv("noheader.csv")

LookupError Traceback (most recent call last)
<ipython-input-1-920278ee7773> in <module>
1 import pandas as pd
----> 2 data = pd.read_csv("noheader.csv")

/usr/lib/python3.6/site-packages/pandas/io/parsers.py in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)
700 skip_blank_lines=skip_blank_lines)
701
--> 702 return _read(filepath_or_buffer, kwds)
703
704 parser_f.name = name

/usr/lib/python3.6/site-packages/pandas/io/parsers.py in _read(filepath_or_buffer, kwds)
427
428 # Create the parser.
--> 429 parser = TextFileReader(filepath_or_buffer, **kwds)
430
431 if chunksize or iterator:

/usr/lib/python3.6/site-packages/pandas/io/parsers.py in init(self, f, engine, **kwds)
893 self.options['has_index_names'] = kwds['has_index_names']
894
--> 895 self._make_engine(self.engine)
896
897 def close(self):

/usr/lib/python3.6/site-packages/pandas/io/parsers.py in _make_engine(self, engine)
1120 def _make_engine(self, engine='c'):
1121 if engine == 'c':
-> 1122 self._engine = CParserWrapper(self.f, **self.options)
1123 else:
1124 if engine == 'python':

/usr/lib/python3.6/site-packages/pandas/io/parsers.py in init(self, src, **kwds)
1851 kwds['usecols'] = self.usecols
1852
-> 1853 self._reader = parsers.TextReader(src, **kwds)
1854 self.unnamed_cols = self._reader.unnamed_cols
1855

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.cinit()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._setup_parser_source()

LookupError: unknown encoding: mbcs

このようなエラーが出ました。改善策教えてください。

Comments

[meg_]

"noheader.csv"のエンコーディングは何ですか？

[python-syosinns]

一応UTF-8になってるとおもいます。　数字とアルファベットしか入っていません

[meg_]

UTF-8で保存し直してみてください。

Answer 1

import pandas as pd
bank = pd.read_csv('noheader.csv', engine = "python", sep = ';')

engine = "python"

を入れることで読み込みました。

C言語で読んでたみたいですね