import pandas as pd
# CSVファイルの読み込み
data = pd.read_csv('file_out.csv', encoding='cp932')
# Excel形式で出力
data.to_excel('excel-data.xlsx', encoding='utf-8')
print('CSV > Excel変換完了')
このプログラムを実行すると以下のようなエラーが発生しました。
Traceback (most recent call last):
File "ssh_test_6.py", line 40, in <module>
data = pd.read_csv('file_out.csv')
File "C:Users\0003563AppDataLocalProgramsPythonPython38-32libsite-packagespandasioparsers.py", line 685, in parser_f
return _read(filepath_or_buffer, kwds)
File "C:Users\0003563AppDataLocalProgramsPythonPython38-32libsite-packagespandasioparsers.py", line 463, in _read
data = parser.read(nrows)
File "C:Users\0003563AppDataLocalProgramsPythonPython38-32libsite-packagespandasioparsers.py", line 1154, in read
ret = self._engine.read(nrows)
File "C:Users\0003563AppDataLocalProgramsPythonPython38-32libsite-packagespandasioparsers.py", line 2059, in read
data = self._reader.read(nrows)
File "pandas/_libs/parsers.pyx", line 881, in pandas._libs.parsers.TextReader.read
File "pandas/_libs/parsers.pyx", line 896, in pandas._libs.parsers.TextReader._read_low_memory
File "pandas/_libs/parsers.pyx", line 950, in pandas._libs.parsers.TextReader._read_rows
File "pandas/_libs/parsers.pyx", line 937, in pandas._libs.parsers.TextReader._tokenize_rows
File "pandas/_libs/parsers.pyx", line 2132, in pandas._libs.parsers.raise_parser_error
pandas.errors.ParserError: Error tokenizing data. C error: Expected 10 fields in line 19, saw 49
# CSVファイルの読み込み
col_names = ['c{0:02d}'.format(i) for i in range(100)]
data = pd.read_csv('file_out.csv', encoding="shift-jis", names = col_names)
エンコーディングの「sift-jis」は以下でも問題ないです。
data = pd.read_csv('file_out.csv', encoding='cp932', names = col_names)
コメント