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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!