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])