Поиск в тексте, запись, открытие файла

with open('raspak.xls') as f:
    lines = f.readlines()
    
name = 1
name = str(name)
f_out = 'step_' + name + '.xls'
f = open(f_out, 'w')
name = int(name)
name = name + 1
 
title = [ i.strip() for i in lines[0].split('\t') ]
print(title)
indexes = []
for i in title:
    indexes.append(title.index(i))
print(indexes)
    
for line in lines[:2]:
    l = [i.strip() for i in line.split('\t')]
 
    tmp = []
    for i in l:
        tmp.append(i)
    print(tmp)
    output_data = '\t'.join(tmp)   
    f.write(output_data + '\n')
     
 
for line in lines[2:]:
    l = [ i.strip() for i in line.split('\t') ]
    #print(l)
         
    tmp1 =[]
    if l[1] != '1':
        for i in indexes:
            tmp1.append(l[i])
        print(tmp1)
    else:
        break
    f.write('\t'.join(tmp1) + '\n')
f.close()

with open('raspak.xls') as f:
    lines = f.readlines()
    d = len(lines)
    print(d)
  
name = 1    
while True:
    name = str(name)
    f_out = 'step_' + name + '.xls'
    f = open(f_out, 'w')
    name = int(name)
    name = name + 1
 
    title = [ i.strip() for i in lines[0].split('\t') ]
    print(title)
    indexes = []
    for i in title:
        indexes.append(title.index(i))
        print(indexes)
    
    for line in lines[:2]:
        l = [i.strip() for i in line.split('\t')]
 
        tmp = []
        for i in l:
            tmp.append(i)
        print(tmp)
        output_data = '\t'.join(tmp)   
        f.write(output_data + '\n')
     
 
    for line in lines[2:]:
         l = [ i.strip() for i in line.split('\t') ]
         print(l)
         
         tmp1 =[]
         if l[1] == '1':
             continue
         else:
             for i in indexes:
                 tmp1.append(l[i])
         #print(tmp1)
     #else:
         #break
         f.write('\t'.join(tmp1) + '\n')
    if not lines:
        break
    
f.close()

from itertools import groupby
from xlrd import open_workbook
 
wb = open_workbook('text.xlsx')
ws = wb.sheet_by_index(0)
 
row_gen = ws.get_rows()
header = next(row_gen)
 
for k, g in groupby(enumerate(row_gen), key=lambda args: args[0]-args[1][1].value):
    print(header)
    for x in [x[1] for x in g]:
        print(x)
    print()