{ "cells": [ { "cell_type": "markdown", "id": "44bdc086", "metadata": { "toc": true }, "source": [ "
\n", " | clients_above_50 | \n", "
---|---|
0 | \n", "3078 | \n", "
\n", " | gender | \n", "percent_distribution | \n", "
---|---|---|
0 | \n", "M | \n", "47.1 | \n", "
1 | \n", "F | \n", "52.9 | \n", "
\n", " |
---|
\n", " | age_group | \n", "marital_status | \n", "income_category | \n", "churn_rate_percent | \n", "avg_total_product_count | \n", "min_amt_chng_q4_q1 | \n", "client_count | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "11 - 30 | \n", "Single | \n", "Less than $40K | \n", "0.0 | \n", "4 | \n", "0.299 | \n", "69 | \n", "
1 | \n", "11 - 30 | \n", "Married | \n", "Less than $40K | \n", "0.0 | \n", "4 | \n", "0.549 | \n", "36 | \n", "
2 | \n", "11 - 30 | \n", "Single | \n", "$40K - $60K | \n", "0.0 | \n", "4 | \n", "0.331 | \n", "29 | \n", "
3 | \n", "11 - 30 | \n", "Single | \n", "Unknown | \n", "0.0 | \n", "4 | \n", "0.391 | \n", "27 | \n", "
4 | \n", "11 - 30 | \n", "Divorced | \n", "Less than $40K | \n", "0.0 | \n", "5 | \n", "0.632 | \n", "16 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
111 | \n", "61 - 120 | \n", "Single | \n", "$120K + | \n", "0.0 | \n", "5 | \n", "0.564 | \n", "2 | \n", "
112 | \n", "61 - 120 | \n", "Married | \n", "$120K + | \n", "0.0 | \n", "4 | \n", "0.424 | \n", "2 | \n", "
113 | \n", "61 - 120 | \n", "Divorced | \n", "Unknown | \n", "0.0 | \n", "4 | \n", "0.808 | \n", "2 | \n", "
114 | \n", "61 - 120 | \n", "Unknown | \n", "$80K - $120K | \n", "0.0 | \n", "6 | \n", "0.722 | \n", "2 | \n", "
115 | \n", "61 - 120 | \n", "Unknown | \n", "Unknown | \n", "0.0 | \n", "4 | \n", "0.628 | \n", "2 | \n", "
116 rows × 7 columns
\n", "\n", " | income_category | \n", "percent_of_male_blue_card_holders | \n", "
---|---|---|
0 | \n", "$40K - $60K | \n", "16.49 | \n", "
\n", " | clientnum | \n", "
---|---|
0 | \n", "713989233 | \n", "
1 | \n", "713982108 | \n", "
\n", " | marital_status | \n", "client_with_2nd_highest_trans_amt | \n", "
---|---|---|
0 | \n", "Divorced | \n", "716894658 | \n", "
1 | \n", "Married | \n", "717642633 | \n", "
2 | \n", "Single | \n", "716004258 | \n", "
3 | \n", "Unknown | \n", "719848008 | \n", "
\n", " | clientnum | \n", "attrition_flag | \n", "dependent_count | \n", "card_category | \n", "months_on_book | \n", "months_inactive_12_mon | \n", "contacts_count_12_mon | \n", "credit_limit | \n", "avg_open_to_buy | \n", "avg_utilization_ratio | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "806160108 | \n", "Existing Customer | \n", "1 | \n", "Blue | \n", "56 | \n", "2 | \n", "3 | \n", "3193.0 | \n", "676.0 | \n", "0.788 | \n", "
1 | \n", "804424383 | \n", "Existing Customer | \n", "1 | \n", "Blue | \n", "56 | \n", "3 | \n", "2 | \n", "10215.0 | \n", "9205.0 | \n", "0.099 | \n", "
2 | \n", "708300483 | \n", "Attrited Customer | \n", "0 | \n", "Blue | \n", "56 | \n", "4 | \n", "3 | \n", "7882.0 | \n", "7277.0 | \n", "0.077 | \n", "
\n", " | clientnum | \n", "customer_age | \n", "gender | \n", "education_level | \n", "marital_status | \n", "income_category | \n", "
---|---|---|---|---|---|---|
0 | \n", "708082083 | \n", "45 | \n", "F | \n", "High School | \n", "Married | \n", "Less than $40K | \n", "
1 | \n", "708083283 | \n", "58 | \n", "M | \n", "Unknown | \n", "Single | \n", "$40K - $60K | \n", "
2 | \n", "708084558 | \n", "46 | \n", "M | \n", "Doctorate | \n", "Divorced | \n", "$80K - $120K | \n", "
\n", " | clientnum | \n", "total_relationship_count | \n", "total_revolving_bal | \n", "total_amt_chng_q4_q1 | \n", "total_trans_amt | \n", "total_ct_chng_q4_q1 | \n", "total_trans_ct | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "828343083 | \n", "3 | \n", "1793.0 | \n", "0.803 | \n", "3646 | \n", "0.659 | \n", "68 | \n", "
1 | \n", "828298908 | \n", "4 | \n", "2035.0 | \n", "0.613 | \n", "1770 | \n", "0.741 | \n", "47 | \n", "
2 | \n", "828294933 | \n", "3 | \n", "2437.0 | \n", "0.765 | \n", "2519 | \n", "0.565 | \n", "36 | \n", "
\n", " | clientnum | \n", "dependent_count | \n", "months_on_book | \n", "months_inactive_12_mon | \n", "contacts_count_12_mon | \n", "credit_limit | \n", "avg_open_to_buy | \n", "avg_utilization_ratio | \n", "
---|---|---|---|---|---|---|---|---|
count | \n", "1.012700e+04 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "
mean | \n", "7.391776e+08 | \n", "2.346203 | \n", "35.928409 | \n", "2.341167 | \n", "2.455317 | \n", "8631.953698 | \n", "7469.139637 | \n", "0.274894 | \n", "
std | \n", "3.690378e+07 | \n", "1.298908 | \n", "7.986416 | \n", "1.010622 | \n", "1.106225 | \n", "9088.776650 | \n", "9090.685324 | \n", "0.275691 | \n", "
min | \n", "7.080821e+08 | \n", "0.000000 | \n", "13.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1438.300000 | \n", "3.000000 | \n", "0.000000 | \n", "
25% | \n", "7.130368e+08 | \n", "1.000000 | \n", "31.000000 | \n", "2.000000 | \n", "2.000000 | \n", "2555.000000 | \n", "1324.500000 | \n", "0.023000 | \n", "
50% | \n", "7.179264e+08 | \n", "2.000000 | \n", "36.000000 | \n", "2.000000 | \n", "2.000000 | \n", "4549.000000 | \n", "3474.000000 | \n", "0.176000 | \n", "
75% | \n", "7.731435e+08 | \n", "3.000000 | \n", "40.000000 | \n", "3.000000 | \n", "3.000000 | \n", "11067.500000 | \n", "9859.000000 | \n", "0.503000 | \n", "
max | \n", "8.283431e+08 | \n", "5.000000 | \n", "56.000000 | \n", "6.000000 | \n", "6.000000 | \n", "34516.000000 | \n", "34516.000000 | \n", "0.999000 | \n", "
\n", " | Variable | \n", "Lower Limit | \n", "Upper Limit | \n", "
---|---|---|---|
0 | \n", "clientnum | \n", "NaN | \n", "NaN | \n", "
1 | \n", "attrition_flag | \n", "NaN | \n", "NaN | \n", "
2 | \n", "dependent_count | \n", "-2.000 | \n", "6.000 | \n", "
3 | \n", "card_category | \n", "NaN | \n", "NaN | \n", "
4 | \n", "months_on_book | \n", "17.500 | \n", "53.500 | \n", "
5 | \n", "months_inactive_12_mon | \n", "0.500 | \n", "4.500 | \n", "
6 | \n", "contacts_count_12_mon | \n", "0.500 | \n", "4.500 | \n", "
7 | \n", "credit_limit | \n", "-10213.750 | \n", "23836.250 | \n", "
8 | \n", "avg_open_to_buy | \n", "-11477.250 | \n", "22660.750 | \n", "
9 | \n", "avg_utilization_ratio | \n", "-0.697 | \n", "1.223 | \n", "
\n", " | Variable | \n", "Number of unique values | \n", "Values | \n", "
---|---|---|---|
0 | \n", "clientnum | \n", "10127 | \n", "[806160108, 804424383, 708300483, 808284783, 7... | \n", "
1 | \n", "attrition_flag | \n", "2 | \n", "[Existing Customer, Attrited Customer] | \n", "
2 | \n", "dependent_count | \n", "6 | \n", "[1, 0, 2, 3, 4, 5] | \n", "
3 | \n", "card_category | \n", "4 | \n", "[Blue, Silver, Gold, Platinum] | \n", "
4 | \n", "months_on_book | \n", "44 | \n", "[56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 46, 4... | \n", "
5 | \n", "months_inactive_12_mon | \n", "7 | \n", "[2, 3, 4, 0, 1, 6, 5] | \n", "
6 | \n", "contacts_count_12_mon | \n", "7 | \n", "[3, 2, 0, 1, 4, 5, 6] | \n", "
7 | \n", "credit_limit | \n", "6205 | \n", "[3193.0, 10215.0, 7882.0, 1438.3, 13860.0, 300... | \n", "
8 | \n", "avg_open_to_buy | \n", "6813 | \n", "[676.0, 9205.0, 7277.0, 1438.3, 12208.0, 489.0... | \n", "
9 | \n", "avg_utilization_ratio | \n", "964 | \n", "[0.788, 0.099, 0.077, 0.0, 0.119, 0.837, 0.679... | \n", "
\n", " | clientnum | \n", "customer_age | \n", "
---|---|---|
count | \n", "1.012700e+04 | \n", "10127.000000 | \n", "
mean | \n", "7.391776e+08 | \n", "46.325960 | \n", "
std | \n", "3.690378e+07 | \n", "8.016814 | \n", "
min | \n", "7.080821e+08 | \n", "26.000000 | \n", "
25% | \n", "7.130368e+08 | \n", "41.000000 | \n", "
50% | \n", "7.179264e+08 | \n", "46.000000 | \n", "
75% | \n", "7.731435e+08 | \n", "52.000000 | \n", "
max | \n", "8.283431e+08 | \n", "73.000000 | \n", "
\n", " | Variable | \n", "No of unique values | \n", "Values | \n", "
---|---|---|---|
0 | \n", "clientnum | \n", "10127 | \n", "[708082083, 708083283, 708084558, 708085458, 7... | \n", "
1 | \n", "customer_age | \n", "45 | \n", "[45, 58, 46, 34, 49, 43, 32, 37, 55, 52, 47, 5... | \n", "
2 | \n", "gender | \n", "2 | \n", "[F, M] | \n", "
3 | \n", "education_level | \n", "7 | \n", "[High School, Unknown, Doctorate, Uneducated, ... | \n", "
4 | \n", "marital_status | \n", "4 | \n", "[Married, Single, Divorced, Unknown] | \n", "
5 | \n", "income_category | \n", "6 | \n", "[Less than $40K, $40K - $60K, $80K - $120K, Un... | \n", "
\n", " | clientnum | \n", "total_relationship_count | \n", "total_revolving_bal | \n", "total_amt_chng_q4_q1 | \n", "total_trans_amt | \n", "total_ct_chng_q4_q1 | \n", "total_trans_ct | \n", "
---|---|---|---|---|---|---|---|
count | \n", "1.012700e+04 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "
mean | \n", "7.391776e+08 | \n", "3.812580 | \n", "1162.814061 | \n", "0.759941 | \n", "4404.086304 | \n", "0.712222 | \n", "64.858695 | \n", "
std | \n", "3.690378e+07 | \n", "1.554408 | \n", "814.987335 | \n", "0.219207 | \n", "3397.129254 | \n", "0.238086 | \n", "23.472570 | \n", "
min | \n", "7.080821e+08 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "510.000000 | \n", "0.000000 | \n", "10.000000 | \n", "
25% | \n", "7.130368e+08 | \n", "3.000000 | \n", "359.000000 | \n", "0.631000 | \n", "2155.500000 | \n", "0.582000 | \n", "45.000000 | \n", "
50% | \n", "7.179264e+08 | \n", "4.000000 | \n", "1276.000000 | \n", "0.736000 | \n", "3899.000000 | \n", "0.702000 | \n", "67.000000 | \n", "
75% | \n", "7.731435e+08 | \n", "5.000000 | \n", "1784.000000 | \n", "0.859000 | \n", "4741.000000 | \n", "0.818000 | \n", "81.000000 | \n", "
max | \n", "8.283431e+08 | \n", "6.000000 | \n", "2517.000000 | \n", "3.397000 | \n", "18484.000000 | \n", "3.714000 | \n", "139.000000 | \n", "
\n", " | Variable | \n", "No of unique values | \n", "Values | \n", "
---|---|---|---|
0 | \n", "clientnum | \n", "10127 | \n", "[828343083, 828298908, 828294933, 828291858, 8... | \n", "
1 | \n", "total_relationship_count | \n", "6 | \n", "[3, 4, 6, 5, 1, 2] | \n", "
2 | \n", "total_revolving_bal | \n", "1974 | \n", "[1793, 2035, 2437, 1821, 659, 765, 848, 1387, ... | \n", "
3 | \n", "total_amt_chng_q4_q1 | \n", "1158 | \n", "[0.803, 0.613, 0.765, 0.63, 0.938, 0.644, 0.76... | \n", "
4 | \n", "total_trans_amt | \n", "5033 | \n", "[3646, 1770, 2519, 2381, 3756, 4053, 1408, 426... | \n", "
5 | \n", "total_ct_chng_q4_q1 | \n", "830 | \n", "[0.659, 0.741, 0.565, 0.481, 0.842, 0.692, 1.0... | \n", "
6 | \n", "total_trans_ct | \n", "126 | \n", "[68, 47, 36, 40, 70, 66, 23, 92, 84, 33, 39, 4... | \n", "
\n", " | months_on_book | \n", "credit_limit | \n", "avg_open_to_buy | \n", "avg_utilization_ratio | \n", "customer_age | \n", "total_revolving_bal | \n", "total_amt_chng_q4_q1 | \n", "total_trans_amt | \n", "total_ct_chng_q4_q1 | \n", "total_trans_ct | \n", "
---|---|---|---|---|---|---|---|---|---|---|
count | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "10127.000000 | \n", "
mean | \n", "35.928409 | \n", "8631.953698 | \n", "7469.139637 | \n", "0.274894 | \n", "46.325960 | \n", "1162.814061 | \n", "0.759941 | \n", "4404.086304 | \n", "0.712222 | \n", "64.858695 | \n", "
std | \n", "7.986416 | \n", "9088.776650 | \n", "9090.685324 | \n", "0.275691 | \n", "8.016814 | \n", "814.987335 | \n", "0.219207 | \n", "3397.129254 | \n", "0.238086 | \n", "23.472570 | \n", "
min | \n", "13.000000 | \n", "1438.300000 | \n", "3.000000 | \n", "0.000000 | \n", "26.000000 | \n", "0.000000 | \n", "0.000000 | \n", "510.000000 | \n", "0.000000 | \n", "10.000000 | \n", "
25% | \n", "31.000000 | \n", "2555.000000 | \n", "1324.500000 | \n", "0.023000 | \n", "41.000000 | \n", "359.000000 | \n", "0.631000 | \n", "2155.500000 | \n", "0.582000 | \n", "45.000000 | \n", "
50% | \n", "36.000000 | \n", "4549.000000 | \n", "3474.000000 | \n", "0.176000 | \n", "46.000000 | \n", "1276.000000 | \n", "0.736000 | \n", "3899.000000 | \n", "0.702000 | \n", "67.000000 | \n", "
75% | \n", "40.000000 | \n", "11067.500000 | \n", "9859.000000 | \n", "0.503000 | \n", "52.000000 | \n", "1784.000000 | \n", "0.859000 | \n", "4741.000000 | \n", "0.818000 | \n", "81.000000 | \n", "
max | \n", "56.000000 | \n", "34516.000000 | \n", "34516.000000 | \n", "0.999000 | \n", "73.000000 | \n", "2517.000000 | \n", "3.397000 | \n", "18484.000000 | \n", "3.714000 | \n", "139.000000 | \n", "
\n", " | dependent_count | \n", "months_on_book | \n", "months_inactive_12_mon | \n", "contacts_count_12_mon | \n", "credit_limit | \n", "avg_open_to_buy | \n", "avg_utilization_ratio | \n", "customer_age | \n", "total_relationship_count | \n", "total_revolving_bal | \n", "total_amt_chng_q4_q1 | \n", "total_trans_amt | \n", "total_ct_chng_q4_q1 | \n", "total_trans_ct | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
dependent_count | \n", "1.000000 | \n", "-0.103062 | \n", "-0.010768 | \n", "-0.040505 | \n", "0.068065 | \n", "0.068291 | \n", "-0.037135 | \n", "-0.122254 | \n", "-0.039076 | \n", "-0.002688 | \n", "-0.035439 | \n", "0.025046 | \n", "0.011087 | \n", "0.049912 | \n", "
months_on_book | \n", "-0.103062 | \n", "1.000000 | \n", "0.074164 | \n", "-0.010774 | \n", "0.007507 | \n", "0.006732 | \n", "-0.007541 | \n", "0.788912 | \n", "-0.009203 | \n", "0.008623 | \n", "-0.048959 | \n", "-0.038591 | \n", "-0.014072 | \n", "-0.049819 | \n", "
months_inactive_12_mon | \n", "-0.010768 | \n", "0.074164 | \n", "1.000000 | \n", "0.029493 | \n", "-0.020394 | \n", "-0.016605 | \n", "-0.007503 | \n", "0.054361 | \n", "-0.003675 | \n", "-0.042210 | \n", "-0.032247 | \n", "-0.036982 | \n", "-0.038989 | \n", "-0.042787 | \n", "
contacts_count_12_mon | \n", "-0.040505 | \n", "-0.010774 | \n", "0.029493 | \n", "1.000000 | \n", "0.020817 | \n", "0.025646 | \n", "-0.055471 | \n", "-0.018452 | \n", "0.055203 | \n", "-0.053913 | \n", "-0.024445 | \n", "-0.112774 | \n", "-0.094997 | \n", "-0.152213 | \n", "
credit_limit | \n", "0.068065 | \n", "0.007507 | \n", "-0.020394 | \n", "0.020817 | \n", "1.000000 | \n", "0.995981 | \n", "-0.482965 | \n", "0.002476 | \n", "-0.071386 | \n", "0.042493 | \n", "0.012813 | \n", "0.171730 | \n", "-0.002020 | \n", "0.075927 | \n", "
avg_open_to_buy | \n", "0.068291 | \n", "0.006732 | \n", "-0.016605 | \n", "0.025646 | \n", "0.995981 | \n", "1.000000 | \n", "-0.538808 | \n", "0.001151 | \n", "-0.072601 | \n", "-0.047167 | \n", "0.007595 | \n", "0.165923 | \n", "-0.010076 | \n", "0.070885 | \n", "
avg_utilization_ratio | \n", "-0.037135 | \n", "-0.007541 | \n", "-0.007503 | \n", "-0.055471 | \n", "-0.482965 | \n", "-0.538808 | \n", "1.000000 | \n", "0.007114 | \n", "0.067663 | \n", "0.624022 | \n", "0.035235 | \n", "-0.083034 | \n", "0.074143 | \n", "0.002838 | \n", "
customer_age | \n", "-0.122254 | \n", "0.788912 | \n", "0.054361 | \n", "-0.018452 | \n", "0.002476 | \n", "0.001151 | \n", "0.007114 | \n", "1.000000 | \n", "-0.010931 | \n", "0.014780 | \n", "-0.062042 | \n", "-0.046446 | \n", "-0.012143 | \n", "-0.067097 | \n", "
total_relationship_count | \n", "-0.039076 | \n", "-0.009203 | \n", "-0.003675 | \n", "0.055203 | \n", "-0.071386 | \n", "-0.072601 | \n", "0.067663 | \n", "-0.010931 | \n", "1.000000 | \n", "0.013726 | \n", "0.050119 | \n", "-0.347229 | \n", "0.040831 | \n", "-0.241891 | \n", "
total_revolving_bal | \n", "-0.002688 | \n", "0.008623 | \n", "-0.042210 | \n", "-0.053913 | \n", "0.042493 | \n", "-0.047167 | \n", "0.624022 | \n", "0.014780 | \n", "0.013726 | \n", "1.000000 | \n", "0.058174 | \n", "0.064370 | \n", "0.089861 | \n", "0.056060 | \n", "
total_amt_chng_q4_q1 | \n", "-0.035439 | \n", "-0.048959 | \n", "-0.032247 | \n", "-0.024445 | \n", "0.012813 | \n", "0.007595 | \n", "0.035235 | \n", "-0.062042 | \n", "0.050119 | \n", "0.058174 | \n", "1.000000 | \n", "0.039678 | \n", "0.384189 | \n", "0.005469 | \n", "
total_trans_amt | \n", "0.025046 | \n", "-0.038591 | \n", "-0.036982 | \n", "-0.112774 | \n", "0.171730 | \n", "0.165923 | \n", "-0.083034 | \n", "-0.046446 | \n", "-0.347229 | \n", "0.064370 | \n", "0.039678 | \n", "1.000000 | \n", "0.085581 | \n", "0.807192 | \n", "
total_ct_chng_q4_q1 | \n", "0.011087 | \n", "-0.014072 | \n", "-0.038989 | \n", "-0.094997 | \n", "-0.002020 | \n", "-0.010076 | \n", "0.074143 | \n", "-0.012143 | \n", "0.040831 | \n", "0.089861 | \n", "0.384189 | \n", "0.085581 | \n", "1.000000 | \n", "0.112324 | \n", "
total_trans_ct | \n", "0.049912 | \n", "-0.049819 | \n", "-0.042787 | \n", "-0.152213 | \n", "0.075927 | \n", "0.070885 | \n", "0.002838 | \n", "-0.067097 | \n", "-0.241891 | \n", "0.056060 | \n", "0.005469 | \n", "0.807192 | \n", "0.112324 | \n", "1.000000 | \n", "
\n", " | card_category | \n", "total_customer_count | \n", "churned_count | \n", "overall_churn_rate_pct | \n", "category_churn_rate_pct | \n", "category_retention_ratio | \n", "
---|---|---|---|---|---|---|
0 | \n", "Blue | \n", "9436 | \n", "1519 | \n", "15.00 | \n", "16.1 | \n", "6.2 | \n", "
3 | \n", "Silver | \n", "555 | \n", "82 | \n", "0.81 | \n", "14.8 | \n", "6.8 | \n", "
1 | \n", "Gold | \n", "116 | \n", "21 | \n", "0.21 | \n", "18.1 | \n", "5.5 | \n", "
2 | \n", "Platinum | \n", "20 | \n", "5 | \n", "0.05 | \n", "25.0 | \n", "4.0 | \n", "