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 Learn data science with projects & tutorials on Datacamp! https://datacamp.pxf.io/c/3588040/1012793/13294 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