Untitled

d.index=d.time
d = d.drop(columns = ['time'])

table = pd.read_excel(r'table2.xlsx')

table.Date = pd.to_datetime(table.Date, format='%d.%m.%Y')


d['defect'] = 'no info'
d['weighted'] = 'Порожний'


d = d.sort_index()

for i, r in table.iterrows():
    
    if i == 0:
        d['defect'] = r.defect
        #data_dw1['defect'] = r.defect
    else:
        if ('1175-48950-2018' in list(r)):
            d.loc[(d.index > r.Date), 'defect'] = 'Выщербина с ползуном'
            #data_dw1.loc[(data_dw1.index > r.Date), 'defect'] = 'Выщербина с ползуном'
        else:
            d.loc[(d.index > r.Date), 'defect'] = r.defect
            #data_dw1.loc[(data_dw1.index > r.Date), 'defect'] = r.defect
            #break;
        
    if r.f != 'Порожний':
        d.loc[(d.index > r.Date), 'weighted'] = r.f
        #data_dw1.loc[(data_dw1.index > r.Date), 'weighted'] = r.f        
        
    print(i, r.defect, r.Date, d.loc[(d.index > r.Date)].shape[0])