这篇文章主要为大家详细介绍了python加载excel报错解决方法,具有一定的参考价值，感兴趣的小伙伴们可以参考一下
from pandas import series, dataframe
import pandas as pd
import numpy as np
import os
import sys
reload(sys)
sys.setdefultencoding(‘utf-8’)
file1=pd.read_excel(‘f:/dataanalysis/statistics/pelicanstores.xlsx’)
python 加载excel报错：
indexerror: list index out of range
原因是pelicanstores.xlsx 的格式有问题，有未显示的多余列。
用excle打开文件pelicanstores.xlsx, 把内容复制到一个新的excel-pelicanstoresnew即可以。
file1=pd.read_excel(‘f:/dataanalysis/statistics/pelicanstoresnew.xlsx’)
file1
out[54]:
customer type of customer items net sales method of payment gender 0 1 regular 1 39.50 discover male
1 2 promotional 1 102.40 proprietary card female
2 3 regular 1 22.50 proprietary card female
3 4 promotional 5 100.40 proprietary card female
4 5 regular 2 54.00 mastercard female
5 6 regular 1 44.50 mastercard female
6 7 promotional 2 78.00 proprietary card female
[100 rows x 8 columns]
in [55]:
以上就是python加载excel报错解决方法的详细内容，更多请关注 第一php社区 其它相关文章！