Data Analytics Interview Prep Using Pandas

Home>

Courses>

Beginner

44 Lessons

2h 30min

Certificate of Completion

AI-POWERED

Mock Interview

Explanations

AI-POWERED

Mock Interview

Explanations

This course includes

26 Playgrounds

20 Challenges

9 Quizzes

This course includes

26 Playgrounds

20 Challenges

9 Quizzes

Course Overview

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 yo...Show More

Course Content

Course Introduction

What Should You Expect from This Course?

Datasets

Selection / Filters

Introducing Selection & Filters in Pandas

Basic Filtering

Challenge: Multiple Filters Filtering by a List/String Filters Challenge: String Filters Challenge: Combining Filter Types Final Quiz Summary & Other Concepts

Grouping

Introduction to Grouping

Challenge 1: Sum of Plays per Country (Trivial)

Challenge 2: Sum of Plays per Country + Genre (Trivial)Challenge 3: Countries with >1000 Plays (Easy)Challenge 4: Plays-to-Fans Ratio (Medium)

Challenge 5: Multiple Aggregations (Difficult)Final Quiz Summary & Other Concepts

Dates Manipulation

Introduction to Dates Manipulation

Challenge 1: Count of Dates in Month (Trivial)Challenge 2: Count within Date Range (Trivial)Challenge 3: Generate Dates (Easy)Challenge 4: Grouping/Resampling By Month (Difficult)Final Quiz Summary & Other Concepts

Apply / Map

Introduction to Using Apply/Map in Pandas

Challenge 1: Mapping Countries to Continents (Trivial)

Challenge 2: Band Initials (Trivial)Challenge 3: Is the Band Popular? (More Complex Function) (Easy)Challenge 4: Sales (Medium)Final Quiz Summary & Other Concepts

Merge/Concat

7 Lessons

Quizzes: Assorted Topics

4 Lessons

Conclusion

1 Lesson

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Souvik Kundu

Front-end Developer

Eric Downs

Musician/Entrepeneur

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!