Untitled

children_pivot = data.pivot_table(index = ['children'], \
                                columns = ['debt'], \
                                values = 'purpose', aggfunc='count')

children_pivot['rate'] = children_pivot[1] / children_pivot[0] * 100
children_pivot