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)Use the attached Audiobooks file (audible_uncleaned.csv) that contains data scraped from the

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 General Management Questions!