python pandas csv getitem_Python调用pandas 读csv档时出现了错误

错误如下

UnicodeDecodeError Traceback (most recent call last)

in ()

1 df = pd.read_table("city.csv",

----> 2 encoding="utf-8",)

C:\123\lib\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, 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, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skipfooter, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)

644 skip_blank_lines=skip_blank_lines)

645

--> 646 return _read(filepath_or_buffer, kwds)

647

648 parser_f.__name__ = name

C:\123\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds)

387

388 # Create the parser.

--> 389 parser = TextFileReader(filepath_or_buffer, **kwds)

390

391 if (nrows is not None) and (chunksize is not None):

C:\123\lib\site-packages\pandas\io\parsers.py in __init__(self, f, engine, **kwds)

728 self.options['has_index_names'] = kwds['has_index_names']

729

--> 730 self._make_engine(self.engine)

731

732 def close(self):

C:\123\lib\site-packages\pandas\io\parsers.py in _make_engine(self, engine)

921 def _make_engine(self, engine='c'):

922 if engine == 'c':

--> 923 self._engine = CParserWrapper(self.f, **self.options)

924 else:

925 if engine == 'python':

C:\123\lib\site-packages\pandas\io\parsers.py in __init__(self, src, **kwds)

1388 kwds['allow_leading_cols'] = self.index_col is not False

1389

-> 1390 self._reader = _parser.TextReader(src, **kwds)

1391

1392 # XXX

pandas\parser.pyx in pandas.parser.TextReader.__cinit__ (pandas\parser.c:6086)()

pandas\parser.pyx in pandas.parser.TextReader._get_header (pandas\parser.c:9266)()

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xca in position 0: invalid continuation byte

代码如下

import pandas as pd

df = pd.read_table("city.csv",

encoding="utf8",)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值