Untitled
unknown
plain_text
7 months ago
1.0 kB
1
Indexable
Never
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])