read_excel有'utf-8' codec can't decode byte 0xb9 in position 0: invalid start byte
时间: 2023-08-28 08:20:35 浏览: 56
这个报错是因为在使用`read_excel`函数时,传入的文件编码不匹配导致的。根据引用的经验,你可以尝试使用不同的编码方式来打开Excel文件,直到找到匹配的编码为止。比如,你可以尝试使用`gbk`编码来打开文件,例如:`pd.read_excel('filename.xlsx', encoding='gbk')`。这样做可以解决编码不匹配导致的问题。请注意,具体的编码方式可能因文件而异,你需要根据实际情况进行尝试。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [UnicodeDecodeError: ‘utf-8‘ codec can‘t decode byte 0xb2 in position 8: invalid start byte解决...](https://blog.csdn.net/weixin_44688529/article/details/125078924)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
- *2* [UnicodeDecodeError: ‘utf-8‘ codec can‘t decode byte 0xb0 in position 0: invalid start byte](https://blog.csdn.net/qq_45861670/article/details/123885773)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]