Interview Prep

The Python Interview Room

Company-style Python problems from analyst, data science, data engineering, ML and software loops: pandas, core Python, engineering, statistics and machine learning. Write it in a real editor, run it to see what your code makes, and once it passes the hidden tests, compare it with a worked answer.

Start here
Spotify logoWeeks at Number OneSpotify·easy·Filtering·+20 XPStart practising →

Question library

30 questions
Prepping for
QuestionTopicsDifficultyXPStatus
Spotify logo
Weeks at Number One
Spotify
easy+20 XPNot started
Spotify logoWeeks at Number OneSpotifypandasFilteringgroupby+1easy+20 XPNot started
LinkedIn logo
The Salary Gap
LinkedIn
easy+20 XPNot started
LinkedIn logoThe Salary GapLinkedInpandasmergegroupby+1easy+20 XPNot started
Apple logo
Average Price by Category
Apple
easy+20 XPNot started
Apple logoAverage Price by CategoryAppleCore PythonDictionaries+1easy+20 XPNot started
Meta logo
The Chattiest Pair
Meta
easy+20 XPNot started
Meta logoThe Chattiest PairMetaCore PythonDictionaries+1easy+20 XPNot started
Google logo
The Rate-Limited Logger
Google
easy+20 XPNot started
Google logoThe Rate-Limited LoggerGoogleEngineeringClasses+1easy+20 XPNot started
Spotify logo
Do Longer Tracks Get Skipped?
Spotify
easy+20 XPNot started
Spotify logoDo Longer Tracks Get Skipped?SpotifyStatisticsCorrelation+1easy+20 XPNot started
Stripe logo
Score the Fraud Model
Stripe
easy+20 XPNot started
Stripe logoScore the Fraud ModelStripeMLMetrics+1easy+20 XPNot started
Amazon logo
Month-over-Month Revenue
Amazon
medium+35 XPNot started
Amazon logoMonth-over-Month RevenueAmazonpandasDatesgroupby+1medium+35 XPNot started
Amazon logo
Back Within a Week
Amazon
medium+35 XPNot started
Amazon logoBack Within a WeekAmazonpandasDatesdiff+1medium+35 XPNot started
Meta logo
Average Session Length
Meta
medium+35 XPNot started
Meta logoAverage Session LengthMetapandasDatesmerge+1medium+35 XPNot started
Microsoft logo
Premium vs Freemium
Microsoft
medium+35 XPNot started
Microsoft logoPremium vs FreemiumMicrosoftpandasmergepivot_table+1medium+35 XPNot started
Airbnb logo
Host Popularity Tiers
Airbnb
medium+35 XPNot started
Airbnb logoHost Popularity TiersAirbnbpandasgroupbypd.cut+1medium+35 XPNot started
Uber logo
Clean the Trip Log
Uber
medium+35 XPNot started
Uber logoClean the Trip LogUberpandasCleaning+2medium+35 XPNot started
Amazon logo
The Most Searched Words
Amazon
medium+35 XPNot started
Amazon logoThe Most Searched WordsAmazonCore PythonCounterHeaps+1medium+35 XPNot started
Uber logo
Flatten the Trip Payload
Uber
medium+35 XPNot started
Uber logoFlatten the Trip PayloadUberCore PythonRecursion+2medium+35 XPNot started
Netflix logo
Minutes Actually Watched
Netflix
medium+35 XPNot started
Netflix logoMinutes Actually WatchedNetflixCore PythonIntervals+1medium+35 XPNot started
Snapchat logo
The Longest Snapstreak
Snapchat
medium+35 XPNot started
Snapchat logoThe Longest SnapstreakSnapchatCore PythonDatesSetsmedium+35 XPNot started
Stripe logo
Which Language to Serve
Stripe
medium+35 XPNot started
Stripe logoWhich Language to ServeStripeEngineeringParsing+1medium+35 XPNot started
Dropbox logo
Find the Duplicate Files
Dropbox
medium+35 XPNot started
Dropbox logoFind the Duplicate FilesDropboxEngineeringHashing+1medium+35 XPNot started
Microsoft logo
A Cache That Forgets
Microsoft
medium+35 XPNot started
Microsoft logoA Cache That ForgetsMicrosoftEngineeringClasses+2medium+35 XPNot started
Pinterest logo
Sessionize the Clickstream
Pinterest
medium+35 XPNot started
Pinterest logoSessionize the ClickstreamPinterestEngineeringSorting+2medium+35 XPNot started
LinkedIn logo
The Slow Endpoints
LinkedIn
medium+35 XPNot started
LinkedIn logoThe Slow EndpointsLinkedInEngineeringParsingLogs+1medium+35 XPNot started
Uber logo
Did the New Checkout Win?
Uber
medium+35 XPNot started
Uber logoDid the New Checkout Win?UberStatisticsA/B testing+1medium+35 XPNot started
Meta logo
Pick in Proportion
Meta
medium+35 XPNot started
Meta logoPick in ProportionMetaStatisticsSampling+2medium+35 XPNot started
Meta logo
Popularity Percentage
Meta
hard+50 XPNot started
Meta logoPopularity PercentageMetapandasconcatnunique+1hard+50 XPNot started
DoorDash logo
Rolling Order Volume
DoorDash
hard+50 XPNot started
DoorDash logoRolling Order VolumeDoorDashpandasDatesreindex+1hard+50 XPNot started
Google logo
Windows That Hit the Target
Google
hard+50 XPNot started
Google logoWindows That Hit the TargetGoogleCore PythonPrefix sums+1hard+50 XPNot started
Airbnb logo
Paginate the Search Results
Airbnb
hard+50 XPNot started
Airbnb logoPaginate the Search ResultsAirbnbEngineeringListsSets+1hard+50 XPNot started
TikTok logo
AUC by Hand
TikTok
hard+50 XPNot started
TikTok logoAUC by HandTikTokMLMetricsRanking+1hard+50 XPNot started
Lyft logo
Cluster the Pickups
Lyft
hard+50 XPNot started
Lyft logoCluster the PickupsLyftMLClusteringk-means+1hard+50 XPNot started
Interview record

Your practice record

0of 30

Choose a focus

Five kinds of Python round, practised one at a time.

A stronger answer

  1. 1Write it in PythonA real editor, with the data or the signature ready.
  2. 2Run the hidden testsEdge cases and a scale test, as an interviewer would.
  3. 3Compare the worked answerOne way to solve it, once yours passes.
QueryCase

Learn data skills by solving mysteries. Detective games with real courses behind them.

Product

  • Home
  • About
  • Pricing

Departments

  • SQL
  • Excel
  • Python

Resources

  • SQL Cheat Sheet
  • SQL Interview Questions
  • Excel Cheat Sheet
  • Python Cheat Sheet
  • Python Interview Questions
  • Data Roles Explained
  • Blog

Company

  • Contact Us
  • Privacy Policy
  • Terms of Service

© 2026 QueryCase. All rights reserved.