Challenge 4: Sales (Medium)

This challenge expects you to apply a function over every cell in a Dataframe.

Problem definition

US Sales UK Sales Egypt Sales
The Beatles 10k 20k 5k
Black Sabbath 3k 15k 3k

Given a new dataset that maps bands to how much sales they’ve made in different markets, you are required to do the following tasks:

  1. Clean the dataset sales values in each cell to remove the k suffix, and replace it with the value in thousands (example: 1k --> 1000).
  2. Return the maximum sales amount that each market had from any band.

Level up your interview prep. Join Educative to access 70+ hands-on prep courses.