Challenge 4: Sales (Medium)
Explore methods to clean sales figures by removing non-numeric suffixes and convert values to integers using Pandas applymap. Learn to identify the maximum sales per market by applying the max function across columns for effective data analysis.
We'll cover the following...
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 ...