Nowadays, the credit card has become a primary way customer pay for purchases, and financial transactions have taken placed with digital formats. Since the finance industry issues the cards to make more profits with interest rates, customer churn analysis is one of the most important and challenging tasks to them. In this project, customer’s attributes are visualized not only to find the pattern of credit card holder’s churn but also to suggest ways to improve customer retention rates.
The final project will be mainly focused on credit card user analysis to identify the pattern of churn. The data acquired from Kaggle and the dataset will be cleaned with the R and Python. The data provides different aspects of users such as age, salary, marital status, credit card limit, etc., and these variables will be utilized to distinguish customer churn and customer retention. After the exploratory data analysis, the correlation between churn and different aspects will be visualized to find the relationship between user attributes and churn. The project will draw conclusions to provide insights to finance businesses to keep credit card users.
Data collected from Kaggle: https://www.kaggle.com/sakshigoyal7/credit-card-customers .
| Column Name | Description |
|---|---|
| Attrition_Flag | If the account is closed then 1 else 0 |
| Customer_Age | Customer's Age in Years |
| Gender | M - male, F - female |
| Dependent_count | Number of dependents |
| Education Level | Educational Qualification of the account holder |
| Marital_Status | Married, Single, Divorced, Unknown |
| Income_Category | Annual Income Category |
| Card_Category | Type of Card |
| Months_on_book | Period of relationship with bank |
| Total_Relationship_Count | Total # of products held by the customer |
| Months_Inactive_12_mon | # of months inactive in the last 12 months |
| Contacts_Count_12_mon | # of contacts in the last 12 months |
| Credit_Limit | Credit Limit on the Credit Card |
| Total_Revolving_Bal | Total Revolving Balance on the Credit Card |
| Avg_Open_To_Buy | Open to Buy Credit Line |
| Total_Amt_Chng_Q4_Q1 | Change in Transaction Amount (Q4 over Q1) |
| Total_Trans_Amt | Total Transaction Amount |
| Total_Trans_Ct | Total Transaction Count |
| Total_Ct_Chng_Q4_Q1 | Change in Transcation Count |
| Avg_Utilization_Ratio | Average Card Utilization Ratio |