python - 在python中从excel中查找连续值的开始索引和最后一行索引

Question

我有一个 excel 数据列表，我正在尝试索引第一个和最后一个连续数字所具有的行，因为我需要与该行关联的其他 2 个列的索引。现在我的列表索引超出范围。[在此处输入图片描述][1 ]

import xlsxwriter
import xlrd
import sys

workbook = xlrd.open_workbook('3speedtest2.xlsx')
worksheet = workbook.sheet_by_name('Sheet1')


count = 0
rowcount = 1
firstindex = 1
lastindex = 1
"""
for i in range(0,3):
    print("pap")
"""

while count<999999999:
    print(count)
    list=[]
    firstindex = lastindex
    list.append(firstindex)
    
    if str(worksheet.cell(rowcount,28)) == -1:
        sys.exit()
    
    if str(worksheet.cell(rowcount, 28)) == str(worksheet.cell(rowcount+1,28)):
        print (str(worksheet.cell(rowcount, 28)))
   
    else:
       print (str(worksheet.cell(rowcount, 28)))
       print ("new number")
    
       lastindex=rowcount
       list.append(lastindex)
    
    rowcount+=1
    count+=1

print (list) 

标签： pythonexcelpandasxlrd