首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >Pandas无法读取excel编码

Pandas无法读取excel编码
EN

Stack Overflow用户
提问于 2018-08-29 06:15:53
回答 2查看 6.5K关注 0票数 1

我正在尝试将一个excel文件导入到Pandas中。我正在使用df=pd.read_excel(file_path),但它一直给我带来这个错误:

代码语言:javascript
复制
*** No CODEPAGE record, no encoding_override: will use 'ascii'
*** No CODEPAGE record, no encoding_override: will use 'ascii'
Traceback (most recent call last):
  File "/Users/santanna_santanna/PycharmProjects/KlooksExplore/FindCos/FindCos_Functions.py", line 5468, in <module>
    adjust_sheet(y1,y2,y3)
  File "/Users/santanna_santanna/PycharmProjects/KlooksExplore/FindCos/FindCos_Functions.py", line 5130, in adjust_sheet
    y1=pd.read_excel(y1)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/pandas/util/_decorators.py", line 118, in wrapper
    return func(*args, **kwargs)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/pandas/io/excel.py", line 230, in read_excel
    io = ExcelFile(io, engine=engine)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/pandas/io/excel.py", line 294, in __init__
    self.book = xlrd.open_workbook(self._io)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/__init__.py", line 162, in open_workbook
    ragged_rows=ragged_rows,
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/book.py", line 119, in open_workbook_xls
    bk.get_sheets()
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/book.py", line 719, in get_sheets
    self.get_sheet(sheetno)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/book.py", line 710, in get_sheet
    sh.read(self)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/sheet.py", line 815, in read
    strg = unpack_string(data, 6, bk.encoding or bk.derive_encoding(), lenlen=2)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/biffh.py", line 249, in unpack_string
    return unicode(data[pos:pos+nchars], encoding)
  File "/Users/santanna_santanna/anaconda3/lib/python3.6/site-packages/xlrd/timemachine.py", line 30, in <lambda>
    unicode = lambda b, enc: b.decode(enc)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 1: ordinal not in range(128)

我尝试导入的文件是this one。是编码问题还是文件中的某些字符导致了这种情况?解决这个问题的方法是什么?

EN

回答 2

Stack Overflow用户

发布于 2018-08-29 06:20:32

代码语言:javascript
复制
pd.read_excel('data.csv' encoding='utf-8')
票数 2
EN

Stack Overflow用户

发布于 2018-08-29 06:55:09

@天体生物学家给出了一个很好的提示

由于我不想进入补丁的麻烦,我找到的解决方法是在open Office中打开文件并将其另存为Excel 97文件。终于奏效了

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/52066916

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档