children_data = clients_data.loc[:, ['children', 'debt']]

def children_count(_count):
    if _count == 0:
        return 'нет детей'
    if _count == 1:
        return 'один ребёнок'
    if _count == 2:
        return 'два ребёнка'
    return 'многодетный'

def is_debt(debt):
    if debt == 0:
        return 'no_debt'
    return 'in_debt'

children_data['children_count'] = children_data['children'].apply(children_count)
children_data['debt'] = children_data['debt'].apply(is_debt)
children_pivot = children_data.pivot_table(index='children_count', columns='debt', aggfunc='count')

children_pivot['debt_percent'] = children_pivot['children', 'in_debt'] / (children_pivot['children', 'in_debt'] +
                                                                        children_pivot['children', 'no_debt'])

print(children_pivot.sort_values(by='debt_percent'))

family_data = clients_data.merge(family_status_dict, on='family_status_id', how='left')
family_data = family_data.loc[:, ['family_status', 'debt']]
family_data['debt'] = family_data['debt'].apply(is_debt)
print(family_data['debt'].value_counts())

family_pivot = family_data.pivot_table(index='family_status', columns='debt', aggfunc='count')
print(family_pivot)