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 noncoding interview questions that force you to think at a high level.

Mentioned Resources!
Second Channel:    / techtrekbykeithgalli  
Regex Cheat Sheet: https://cheatography.com/davechild/ch...
Probability text book: https://www.amazon.com/dp/188652923X/...

Here are the questions that we complete (in order)

~~ Coding ~~
1. Finding Updated Records: https://platform.stratascratch.com/co...
2. Number of Bathrooms and Bedrooms: https://platform.stratascratch.com/co...
3. Counting Instances in Text: https://platform.stratascratch.com/co...
4. Customer Revenue in March: https://platform.stratascratch.com/co...
5. Monthly Percentage Difference: https://platform.stratascratch.com/co...
6. Premium vs Freemium: https://platform.stratascratch.com/co...

~~ NonCoding ~~
1. Credit Card Activity: https://platform.stratascratch.com/te...
2. Outliers Detection: https://platform.stratascratch.com/te...
3. Probability of Having a Sister: https://platform.stratascratch.com/te...
4. Uber Black Rides: https://platform.stratascratch.com/te...
5. Terabyte of Data: https://platform.stratascratch.com/te...

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 NonCoding #1 (Visa, Easy) Credit Card Activity
01:13:33 NonCoding #2 (IBM, Easy) Outliers Detection
01:16:46 NonCoding #3 (Google, Medium) Probability of Having a Sister
01:27:19 NonCoding #4 (Uber, Medium) Uber Black Rides
01:36:57 NonCoding #5 (Capital One, Hard) Terabyte of Data
01:46:41 Video Conclusion & Recap


Follow me on social media!
Instagram |   / keithgalli  
Twitter |   / keithgalli  
TikTok |   / keithgalli  


If you are curious to learn how I make my tutorials, check out this video:    • How to Make a High Quality Tutorial V...  

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    / @keithgalli  
Patreon   / 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