Question: Use the attached Audiobooks file (audible_uncleaned.csv) that contains data scraped from the Audible website. Please use the data to answer the following: 1. What makes
Use the attached Audiobooks file (audible_uncleaned.csv) that contains data scraped from the Audible website. Please use the data to answer the following:
1. What makes this dataset dirty? (3 pts)
2. Can you answer following business questions from this dataset? (5 pts)
a. Year with most audible audio books
b. Number of audiobooks with the high rating (5.0), low rating (less than or equal to 2.0)
c. Longest audiobook
d. Shortest audiobook
e. Distribution of audiobooks by year
3. Approach to make this a clean dataset. Submit clean file (name your file as audiobooks_clean_yourname.xlsx) (2 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
