Question
The following information has been collected through a survey from 10 bank's customers that are organized in a data table format as below: ID Gender
The following information has been collected through a survey from 10 bank's customers that are organized in a data table format as below:
ID | Gender | Date of Birth | Income | Loan | Loan Type | Marital Status | Kids |
1 | M | 12/5/1970 | $50,200 | $5,000 | Mortgage | Single | Y |
2 | M | 15 Jan, 1975 | $60,500 | $0 | Married | Yes | |
3 | Male | 1/13/1979 | -$65,000 | $1,000 | Student Loan | Sing. | No |
4 | F | 1/1/1912 | Car Loan | Married | Don't Know | ||
5 | F | 15/1/1975 | $60,500 | $0 | Y | ||
6 | M | 9/10/1942 | NA | $55,000 | Mortgage | M | N |
7 | M | 2/27/1856 | $300,000 | $50,000 | Don't Know | S | Y |
8 | Female | 4/4/1980 | $55,000 | $0 | Mor. | Single | N |
9 | M | 16/16/1999 | $35,000 | $20.000 | Line of Credit | S | NO |
10 | F | 14/08/1973 | $95,000 | $33,000 | Mortg. | Married | NO |
Required:
- Identify with a brief explanation the possible error, if applicable, in each raw dataset
- Prepare the data (cleansing) in a table presented below (fill up the table using as many rows as required and ignore other rows)
- Explain how the data should be preprocessed (data wrangling)
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