首页 > 解决方案 > 如何在 jupyter notebook 中读取 csv 文件?

问题描述

有人可以帮我解决这个错误吗?基本上我想在 jupiter notebook 中读取一个 csv 文件,但我无法跨越这个障碍。


将熊猫导入为 pd fifa = pd.read_csv('C:/Users/Puneeth/players_15.csv', encoding = 'utf-16') fifa.head()

UnicodeDecodeError Traceback(最近一次调用最后)~\AppData\Local\Temp/ipykernel_8644/3094556301.py in 1 import pandas as pd ----> 2 mpg = pd.read_csv('C:/Users/Puneeth/players_15.csv ', 编码 = 'utf-16') 3 mpg.head()

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas\util_decorators.py in wrapper(*args, **kwargs) 309 stacklevel=stacklevel, 310 ) --> 311 return func(*args, **kwargs) 312 313 返回包装器

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas\io\parsers\readers.py in read_csv(filepath_or_buffer,sep,delimiter,header,names,index_col,usecols,squeeze ,前缀,mangle_dupe_cols,dtype,引擎,转换器,true_values,false_values,skipinitialspace,skirows,skipfooter,nrows,na_values,keep_default_na,na_filter,详细,skip_blank_lines,parse_dates,infer_datetime_format,keep_date_col,date_parser,dayfirst,cache_dates,迭代器,块大小,压缩, 千位, 十进制, 换行符, 引号字符, 引用, 双引号, 转义字符, 注释, 编码, encoding_errors, 方言, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options) 584 kwds.update(kwds_defaults) 585 --> 586 返回_read(filepath_or_buffer,kwds)587 588

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas\io\parsers\readers.py in _read(filepath_or_buffer, kwds) 480 481 # 创建解析器。--> 482 parser = TextFileReader(filepath_or_buffer, **kwds) 483 484 如果是块大小或迭代器:

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas\io\parsers\readers.py in init (self, f, engine, **kwds) 809 self.options[ "has_index_names"] = kwds["has_index_names"] 810 --> 811 self._engine = self._make_engine(self.engine) 812 813 def close(self):

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas\io\parsers\readers.py in _make_engine(self, engine) 1038 ) 1039 # error: Too many arguments for " ParserBase" -> 1040 return mapping[engine](self.f, **self.options) # type: ignore[call-arg] 1041 1042 def _failover_to_python(self):

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas\io\parsers\c_parser_wrapper.py init (self, src, **kwds) 67 kwds["dtype"] = ensure_dtype_objs(kwds.get("dtype", None)) 68 尝试:---> 69 self._reader = parsers.TextReader(self.handles.handle, **kwds) 70 例外:71 self.handles.close ()

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas_libs\parsers.pyx 在 pandas._libs.parsers.TextReader 中。初始化()

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas_libs\parsers.pyx 在 pandas._libs.parsers.TextReader._get_header()

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas_libs\parsers.pyx 在 pandas._libs.parsers.TextReader._tokenize_rows()

c:\users\puneeth\appdata\local\programs\python\python39\lib\site-packages\pandas_libs\parsers.pyx 在 pandas._libs.parsers.raise_parser_error()

UnicodeDecodeError:“utf-16-le”编解码器无法解码位置 72-73 中的字节:非法编码

标签: jupyter-notebook

解决方案


推荐阅读