#!/usr/bin/env python3
def left_round(s):
    l = str(s).split('.')
    if len(l) > 1: return float(l[0] + '.' + l[1][:1])
    else: return float(l[0]+'.0')
    
def fileToDict(fname,delim=None,endline='\n'):
    with open(fname,encoding='cp1251') as f:
        lines = f.read().split(endline)
    lst = []
    for line in lines:
        tmp = [i.strip() for i in line.split(delim) if i.strip()]
        lst.append(tmp)
    out = [[] for i in range(len(lst[0]))]
    for i in lst:
           for j in range(len(i)):
               out[j].append(i[j])
    d = {}
    for i in out:
        d[i[0]] = [float(j) for j in i[1:]]
    return d
  
d1 = fileToDict('2.csv',';')
t  = [left_round(i) for i in d1['t']]
files = ['text_%d.csv' % i for i in range(1,3)]#тут сама поставь
for f_in in files:
    f_out = f_in.replace('text','out')
    d = fileToDict(f_in,';')
    Ttt = [left_round(i) for i in d['Ttt']]
    for i in t:
        if i in Ttt:
            N = t.index(i)
            Bm = int(d1['Bm'][N])
            if Bm > 0:
                hdr = ['№','t','Bm']
                for i in range(1,Bm + 1): hdr.append('X_%d' %i)
                for i in range(1,Bm + 1): hdr.append('Z_%d' %i)
                data = []
                data.append(str(int(d1['№'][N])))
                for i in hdr[1:]:
                    data.append(str(d1[i][N]))
                f = open(f_out,'w',encoding='cp1251')
                f.write(';'.join(hdr) + '\n')
                f.write(';'.join(data) + '\n')
                f.close()    

 d1 = fileToDict('2.csv',';')
print(d1.keys())

 #!/usr/bin/env python3
import xlrd
import glob
xls_files = glob.glob('text_*.xls')
print (xls_files)
    
def xls2dict(fname):
    book=xlrd.open_workbook(fname)
    sheet=book.sheet_by_index(0)
    cols=sheet.ncols
    d  = {}
    for col in range(cols):
        l = [i.value for i in sheet.col_slice(col)]
        if l[0]: d[l[0]] = l[1:]
    return d
  
d = xls2dict('2.xls')
print(d.keys())