The ultimate guide to data analytics interviews using Pandas. Strengthen your skills with advanced concepts and practice with real-world interview questions. Developed by FAANG engineers.

In this course, you will face a number of challenges across different concepts, all with the data analytics library Pandas.

This course is mainly to refresh your knowledge, as well as help you understand more advanced concepts. By solving multiple challenges, you will surely strengthen your skills and it will help you ace your interview involving Pandas.

You will cover many topics such as: grouping, filtering, date manipulation, and more. By the time you finish this course, you will have the confidence you need to land your dream job.

Data Analytics Interview Prep Using Pandas

# 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.

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

Course Introduction

Selection / Filters

Grouping

Dates Manipulation

Apply / Map

Merge/Concat

Quizzes: Assorted Topics

Conclusion

Challenge 4: Sales (Medium)

Problem definition