Challenge 4: Sales (Medium)
This challenge expects you to apply a function over every cell in a Dataframe.
We'll cover the following
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:
- Clean the dataset sales values in each cell to remove the
k
suffix, and replace it with the value in thousands (example:1k
-->1000
). - 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.