Solving Real-World Data Science Interview Questions! (with Python Pandas)

Visit https://brilliant.org/KeithGalli/ to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription

In this video we solve a series of Data Science Interview questions on Stratascratch. We start with easy problems using Python Pandas and then progressively get more difficult. At the end of the video we do five non-coding interview questions that force you to think at a high level.

Mentioned Resources!
Second Channel: https://www.youtube.com/c/techtrekbykeithgalli
Regex Cheat Sheet: https://cheatography.com/davechild/cheat-sheets/regular-expressions/
Probability text book: https://www.amazon.com/dp/188652923X/ref=cm_sw_em_r_mt_dp_3JSVKBY80FQ3EEDGSRD6

Here are the questions that we complete (in order)

~~ Coding ~~
1. Finding Updated Records: https://platform.stratascratch.com/coding/10299-finding-updated-records?code_type=2&via=keith
2. Number of Bathrooms and Bedrooms: https://platform.stratascratch.com/coding/9622-number-of-bathrooms-and-bedrooms?code_type=2&via=keith
3. Counting Instances in Text: https://platform.stratascratch.com/coding/9814-counting-instances-in-text?code_type=2&via=keith
4. Customer Revenue in March: https://platform.stratascratch.com/coding/9782-customer-revenue-in-march?code_type=2&via=keith
5. Monthly Percentage Difference: https://platform.stratascratch.com/coding/10319-monthly-percentage-difference?code_type=2&via=keith
6. Premium vs Freemium: https://platform.stratascratch.com/coding/10300-premium-vs-freemium?code_type=2&via=keith

~~ Non-Coding ~~
1. Credit Card Activity: https://platform.stratascratch.com/technical/2342-credit-card-activity?via=keith
2. Outliers Detection: https://platform.stratascratch.com/technical/2372-outliers-detection?via=keith
3. Probability of Having a Sister: https://platform.stratascratch.com/technical/2368-probability-of-having-a-sister?via=keith
4. Uber Black Rides: https://platform.stratascratch.com/technical/2305-uber-black-rides?via=keith
5. Terabyte of Data: https://platform.stratascratch.com/technical/2364-terabyte-of-data?via=keith

The skills that we work on in this video include:
- Python Pandas
- Groupby & Aggregate DataFrames
- Use regexes to analyze text
- Datetime objects in Pandas
- Filtering by Conditionals
- Applying a lambda function to a data frame

If you have any questions, let me know in the comments!

If you enjoyed this video, make sure to throw it a like & subscribe for all future content :)

-------------------------
Video Timeline!
0:00 - Intro & Video Overview
0:46 - Check out this Video’s Sponsor, Brilliant!
3:10 - Coding #1 (Microsoft, Easy) - Finding Updated Records
10:36 - Coding #2 (Airbnb, Easy) - Number of Bathrooms and Bedrooms
16:38 - Coding #3 (Google, Medium) - Counting Instances in Text
28:23 - Coding #4 (Meta/Facebook, Medium) - Customer Revenue in March
36:51 - Coding #5 (Amazon, Hard) - Monthly Percentage Difference
56:38 - Coding #6 (Microsoft, Hard) - Premium vs Freemium
01:10:28 - Non-Coding #1 (Visa, Easy) - Credit Card Activity
01:13:33 - Non-Coding #2 (IBM, Easy) - Outliers Detection
01:16:46 - Non-Coding #3 (Google, Medium) - Probability of Having a Sister
01:27:19 - Non-Coding #4 (Uber, Medium) - Uber Black Rides
01:36:57 - Non-Coding #5 (Capital One, Hard) - Terabyte of Data
01:46:41 - Video Conclusion & Recap

-------------------------
Follow me on social media!
Instagram | https://www.instagram.com/keithgalli/
Twitter | https://twitter.com/keithgalli
TikTok | https://tiktok.com/@keithgalli

-------------------------
If you are curious to learn how I make my tutorials, check out this video: https://youtu.be/LEO4igyXbLs

Practice your Python Pandas data science skills with problems on StrataScratch!
https://stratascratch.com/?via=keith

Join the Python Army to get access to perks!
YouTube - https://www.youtube.com/channel/UCq6XkhO5SZ66N04IcPbqNcw/join
Patreon - https://www.patreon.com/keithgalli

*I use affiliate links on the products that I recommend. I may earn a purchase commission or a referral bonus from the usage of these links.

This video was Sponsored by Brilliant