python之无法通过 Pandas 将 Excel 字段导入 Python之索引越界错误

我不确定发生了什么，但我的代码今天可以运行，但不会。我有一个项目的 Excel 电子表格，我想单独导入并放入列表中。但是，我收到“IndexError:索引 8 超出尺寸为 8 的轴 0 的边界”错误，Google 搜索尚未为我解决此问题。任何帮助表示赞赏。我的 Excel 工作表中有以下字段:id、funding_end、keywords、pi、summaryurl、htmlabstract、abstract、project_num、title。不确定我错过了什么......

import pandas as pd 
 
dataset = pd.read_excel('new_ahrq_projects_current.xlsx',encoding="ISO-8859-1") 
df = pd.DataFrame(dataset) 
cols = [0,1,2,3,4,5,6,7,8] 
df = df[df.columns[cols]] 
 
tt = df['funding_end'] = df['funding_end'].astype(str) 
tt = df.funding_end.tolist() 
for t in tt: 
   allenddates.append(t) 
 
bb = df['keywords'] = df['keywords'].astype(str) 
bb = df.keywords.tolist() 
for b in bb: 
   allkeywords.append(b) 
 
uu = df['pi'] = df['pi'].astype(str) 
uu = df.pi.tolist() 
for u in uu: 
   allpis.append(u) 
 
vv = df['summaryurl'] = df['summaryurl'].astype(str) 
vv = df.summaryurl.tolist() 
for v in vv: 
   allsummaryurls.append(v) 
 
ww = df['htmlabstract'] = df['htmlabstract'].astype(str) 
ww = df.htmlabstract.tolist() 
for w in ww: 
   allhtmlabstracts.append(w)  
 
xx = df['abstract'] = df['abstract'].astype(str) 
xx = df.abstract.tolist() 
for x in xx: 
   allabstracts.append(x)  
 
yy = df['project_num'] = df['project_num'].astype(str) 
yy = df.project_num.tolist() 
for y in yy: 
   allprojectnums.append(y)     
 
zz = df['title'] = df['title'].astype(str) 
zz = df.title.tolist() 
 
for z in zz: 
   alltitles.append(z)  

请您参考如下方法:

"IndexError: index 8 is out of bounds for axis 0 with size 8"

cols = [0,1,2,3,4,5,6,7,8] 

应该是 cols = [0,1,2,3,4,5,6,7]。

我认为你有 8 列，但你的列有 9 列索引。