A solution to last week’s challenge can be found here.
Do you have to work with messy data?
The provided dataset is Messy with a capital M. For this challenge, calculate the average cost of an app (Application Fee and Cost) based on the 10 most expensive apps.
Guidelines:
- You must use the values of the creator whose last name starts with S.
- Calculate the cost of each app (application fee + cost).
- Round up the cost of each app; for example, if an app costs $67.03, round up to $68.
- Determine the cost at X.99; for example, if an app costs $68, the final cost will be $67.99.
- Then you will calculate the average cost based on the 10 most expensive apps.
Start by cleaning the messy dataset.
Thank you for your comments. This Weekly Challenge was updated.
