df.loc[df.filter(like='col_id').eq(5).all(1),['property_8','property_25000']].assign(id=5)