裂了！这pandas出了啥问题

Question

今天本想转换个数据格式，却遇到了这个问题，希望能者为小生解惑
报错如下：
C:\ruanjian\pycharm\pythonProject2\venv\Scripts\python.exe C:/ruanjian/pycharm/pythonProject2/main.py
jio.help() is provided to search how to use jio functions.
Traceback (most recent call last):
File "C:/ruanjian/pycharm/pythonProject2/main.py", line 4, in
res = pd.read_csv(r'C:\Users\HH\Desktop\abcdefg.csv')
File "C:\ruanjian\pycharm\pythonProject2\venv\lib\site-packages\pandas\util_decorators.py", line 311, in wrapper
return func(*args, **kwargs)
File "C:\ruanjian\pycharm\pythonProject2\venv\lib\site-packages\pandas\io\parsers\readers.py", line 586, in read_csv
return _read(filepath_or_buffer, kwds)
File "C:\ruanjian\pycharm\pythonProject2\venv\lib\site-packages\pandas\io\parsers\readers.py", line 482, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "C:\ruanjian\pycharm\pythonProject2\venv\lib\site-packages\pandas\io\parsers\readers.py", line 811, in init
self._engine = self._make_engine(self.engine)
File "C:\ruanjian\pycharm\pythonProject2\venv\lib\site-packages\pandas\io\parsers\readers.py", line 1040, in _make_engine
return mapping[engine](self.f, **self.options) # type: ignore[call-arg]
File "C:\ruanjian\pycharm\pythonProject2\venv\lib\site-packages\pandas\io\parsers\c_parser_wrapper.py", line 69, in init
self._reader = parsers.TextReader(self.handles.handle, **kwds)
File "pandas_libs\parsers.pyx", line 542, in pandas._libs.parsers.TextReader.cinit
File "pandas_libs\parsers.pyx", line 642, in pandas._libs.parsers.TextReader._get_header
File "pandas_libs\parsers.pyx", line 843, in pandas._libs.parsers.TextReader._tokenize_rows
File "pandas_libs\parsers.pyx", line 1917, in pandas._libs.parsers.raise_parser_error
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xb1 in position 34: invalid start byte

进程已结束,退出代码1

Answer 1

你读取abcdefg.csv文件用的编码不对
pd.read_csv中用encoding参数设置下读取文件所用的编码
encoding参数设置gbk或者utf-8

res = pd.read_csv(r'C:\Users\HH\Desktop\abcdefg.csv',encoding='gbk')

或者

res = pd.read_csv(r'C:\Users\HH\Desktop\abcdefg.csv',encoding='utf-8')

如有帮助，请点击我的回答下方的【采纳该答案】按钮帮忙采纳下，谢谢!