len(data.fillna({'avg_bill': 'Цена бокала пива'}) .query("middle_avg_bill.isna() \ and middle_coffee_cup.isna() \ and not avg_bill.isna() \ and not avg_bill.str.contains('Цена бокала пива')") )