Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task 1 : Import the raw data ( CC _ Default.csv ) into your Jupyter notebook. 1 . 1 Check if the data is loaded
Task :
Import the raw data CCDefault.csv into your Jupyter notebook.
Check if the data is loaded correctly by printing a few observations. Check the total number of observations and variables.
Provide the descriptive statistics and manipulate data.
a Check for missing values if any.
b Plot the univariate distribution Atleast plots
c Convert the relevant variables such as payment variables PayPay and customer related variables to categorical variables as appropriate.
Find the variables that are correlated and the variables that might help in finding the defaulters next month using a few plots. The plots should provide insights on the following:
a The independent variable that should help identify those who will default from the next months credit card payment
b The relation between dependent and independent variables
c The correlations among the variables, etc.
Provide your insights into the variables and their relationship based on your analysis in Task in a markdown cell in your Jupyter notebook.
ID A numerical value assigned to each credit card customer
LIMITBAL The remaining credit a customer can use
SEX male ; female
EDUCATION graduate school ; university ; high school ; others ; unknown ; unknown
MARRIAGE unknown married single others
AGE A customers age in years
PAY Repayment status in September : or less: Paid duly ; or greater payment was delayed
PAY Repayment status in August or less: Paid duly ; or greater payment was delayed
PAY Repayment status in July or less: Paid duly ; or greater payment was delayed
PAY Repayment status in June or less: Paid duly ; or greater payment was delayed
PAY Repayment status in May or less: Paid duly ; or greater payment was delayed
PAY Repayment status in April or less: Paid duly ; or greater payment was delayed
BILLAMT The amount in the bill statement for September in NT dollar
BILLAMT The amount in the bill statement for August in NT dollar
BILLAMT The amount in the bill statement for July in NT dollar
BILLAMT The amount in the bill statement for June in NT dollar
BILLAMT The amount in the bill statement for May in NT dollar
BILLAMT The amount in the bill statement for April in NT dollar
PAYAMT The amount paid in NT dollar in September
PAYAMT The amount paid in NT dollar in August
PAYAMT The amount paid in NT dollar in July
PAYAMT The amount paid in NT dollar in June
PAYAMT The amount paid in NT dollar in May
PAYAMT The amount paid in NT dollar in April
default.payment.next.month Shows customers who defaulted on their payments on the following month: yes no
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started