PROJECT №1

def cat_income(income):
    try:
        if 0 <= income <= 30000:
            return 'E'
        elif 30001 <= income <= 50000:
            return 'D'
        elif 50001 <= income <= 100000:
            return 'C'
        elif 100001 <= income <= 150000:
            return 'C1'
        elif 150001 <= income <= 200000:
            return 'C2'
        elif 200001 <= income <= 1000000:
            return 'B'
        elif income >= 1000001:
            return 'A'
    except:
        pass
data['total_income_category_2'] = data['total_income'].apply(cat_income)
deb_total_income = data.groupby('total_income_category_2')['debt'].agg(['count',
                                                                      'sum',
                                                                      'mean'
                                                                     ])
deb_total_income['mean'] = deb_total_income['mean'].apply('{:.2%}'.format)
deb_total_income = deb_total_income.rename(columns={'count':'Заемщики',
                                 'sum':'Дебиторы',
                                 'mean':'Процент_дебиторов'
                                })
deb_total_income.sort_values(by='Процент_дебиторов', ascending=False)