Question: Clean and prepare the data. 5. Look carefully at the daily_average_balance column. 6. Did you find a data outlier? 7. One customer's balance appears very
Clean and prepare the data. 5. Look carefully at the daily_average_balance column. 6. Did you find a data outlier? 7. One customer's balance appears very high and never changes (even though there were five transactions). Something seems very strange here. 8. Make a note of the details about the customer. 9. Next, look at the transaction_date_time column. Can you find one date that doesn't belong here? Hint- this data is for one month. 10. Make sure that it is on the top row and click on "Remove Rows"->Top row. 11. Now, you should have 99 unique transactions. 12. Click the "Close & Apply" button in the top left corner.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
