Challenge #343: Average App Cost

[AYXAcademy]

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.

[peter_gb]

Hmm I think I've followed the steps as described but my answer is off - $69.69 vs the given solution of 69.273 - can anyone point out what I've done wrong?

Spoiler

 

[patrick_digan]

Spoiler

[Kenda]

Spoiler

Getting a bit of a different answer than the one given

[harrame]

I'm also getting a different answer from the provided solution.

Spoiler

There are two ways I can see to approach the final answer. One, you do a unique on the parsed name of the product, and one without the unique. I got $69.69 and $68.99, respectively.

[Luke_C]

Spoiler

Different than solution but consistent with everyone else's answer

[AkimasaKajitani]

My solution.

I also reached a different result.

Spoiler

[binuacs]

Spoiler

[RolandSchubert]

Spoiler

Different result ... as all others

[balajilolla1]

Spoiler

Solution Attached