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

Your music analyst now has two datasets with complementary information.

The first dataset contains information about bands, and their associated data. However, instead of names, it refers to countries by their IDs. Here are the first three rows:

| artist            | country | plays | genre | fans | 
|-------------------|---------|-------|-------|------| 
| The Beatles       | 1       | 150   | rock  | 50   | 
| Pink Floyd        | 1       | 10000 | rock  | 1500 | 
| Metallica         | 2       | 500   | metal | 50   | 




The second is a simple mapping between the ID of a country and its name.


| country_id | name    | 
|------------|---------| 
| 1          | UK      | 
| 2          | US      | 
| 3          | Egypt   | 
| 4          | Finland | 

Can you help your music analyst find the sum of plays per country name?


This challenge expects you to merge two DataFrames containing country information and band information.

Course Introduction

Selection / Filters

Grouping

Dates Manipulation

Apply / Map

Merge/Concat

Quizzes: Assorted Topics

Conclusion

Challenge 1: Basic Merge [Countries & Bands] (Trivial)

Problem definition