Pandas Interview Questions
GroupBy, merges, reshaping, window logic and the DataFrame patterns that come up in interviews. All 343 are original problems with instant in-browser grading — pick one and start solving free.
Easy Pandas questions 116
- Above-Average Campuses
- Adjacent Open Parking Spots
- Asset Labels With a Three-Digit Code
- Average Listening Sessions per Listener
- Average Nightly Rate Earned per Room
- Average Reviewer Tenure per Grant
- Average Workout Duration per Treadmill
- Best Recorded Time per Runner
- Big-Spender Diners
- Books Missing a Record
- Build a Savory-and-Sweet Combo
- Busiest Reading Circles
- Can Three Beams Form a Bracket
- Chefs Who Tasted Their Own Dish
- Chess Club Standings
- Class Attendance for Every Member and Class
- Classifying Bracing Frames
- Clean-Rated Audiobooks Aired in March
- Closest Mileposts on a Trail
- Counting Package Registries
- Coupon Redemption Rate
- Couriers per Depot
- Course Fee per Campus
- Course of Each Learner's First Enrollment
- Daily Distinct Buyers and Couriers
- Daily Distinct Gym Visitors
- Days the Reservoir Rose
- Distinct Languages Spoken by Each Guide
- Distinct Vehicle Types Parked per Day
- Drivers With Low or No Tips
- Each Author's Home Library
- Each Member's First Gym Visit
- Edition Catalogue Report
- Email Campaign Open Rate
- Enrollments in Missing Courses
- Espresso Drinkers Who Skip Matcha
- Every Debate Pairing in the Tournament
- Extract Email Domains and Count Users
- Find Duplicate Customers by Normalized Email
- Flagged Support Messages
- Flip the Winning Side
- Format the Conference Badge Label
- Frequent Host-Guest Pairs
- Garages With No Free Spaces
- Gluten-Free Vegan Menu Items
- Gyms With Membership Growth in 2023
- High-Balance Loyalty Members
- Highest Unique Queue Ticket
- Keep the Earliest Newsletter Signup
- Library Entries Without a Checkout
- Listeners Who Beat Their Own Average
- Lookup Reservoir Levels
- Lyft Drivers at Salary Extremes
- Members Active in Two Quarters
- Members Who Outscore Their Team Leader
- Members Who Qualify for Loyalty Points
- Members Who Qualify for Loyalty Points (List)
- Members With Both Plans
- Mentees per Mentor
- Menu Item Totals Across Tickets
- Monthly Stream Activity Above the Royalty Floor
- Most Recent 2022 Backup
- Most Recent Check-In per Locker
- Next-Day Order Confirmations
- Notable National Parks
- Overlong Support Messages
- Pallets With a Well-Formed Tracking Code
- Pivot Store Sales by Quarter
- Players Not Recruited by Coach #4
- Players Whose Coach Left the Roster
- Podcast Episodes Missing a Transcript
- Podcast Search Relevance and Weak-Hit Rate
- Poll Participation Rate
- Poorly Received Recipes
- Popular Titles Borrowed in a Month
- Rank the App Leaderboard
- Readable Book Due Dates
- Readers Who Never Checked Out a Book
- Recommendable Trails
- Recruiters Who Never Staffed Helix
- Repeat Gate Entries Within a Day
- Replies per Help-Desk Ticket
- Same-Day Ticket Resolution Rate
- Show Each Book's Shelf Code
- Sites per Region
- Soil Moisture Classification per Greenhouse
- Students and Their Dorm Rooms
- Subscriber Count per Channel
- Supplier With the Most Deliveries
- Support Ticket Resolution Histogram
- Threads Flagged Yesterday
- Tidy Track Plays by Month
- Tidy Up Author Names
- Times Each Chef Appears on the Menu
- Tools Borrowed Only in Spring
- Top Bakery Showdown
- Top Earning Market Stall
- Top-Day Revenue Gap Between Two Branches
- Total Pages Read per Library Member
- Total Parcel Weight per Courier
- Total Parking Minutes per Vehicle
- Total Spend per Diner
- Total Stored Capacity Per Cold Room
- Tutors Idle Through 2023
- Unfold Shift Readings
- Uninterrupted Study Sessions
- Units Dispensed per Drink
- Usernames Chosen More Than Once
- Valid Internal Handles
- Valid Message Routing Keys
- Valid Relay Teams Across Three Clubs
- Vehicles Flagged for Recall
- Volunteer Appreciation Reward
- Volunteers With All Three Certifications
- Weighted Average Rating
- Well-Attended Fitness Sessions
Medium Pandas questions 157
- 7-Day Rolling Signup Average
- Accounts Streaming From Two Devices at Once
- Agent Resolution Rate
- Agents With a Dominant Contact Channel
- Airbnb Popularity Bucket Pricing
- Amazon Unique Shipments per Month
- Apply Publisher Promotions to Book Prices
- Average Compensation by Title and Gender
- Average Workout Length Before and After Joining
- Banner With the Best Click-Through
- Billboard Pairs Enclosing Land
- Blocks of Occupied Parking Bays
- Book Suggestions from Reading Buddies
- Borrows per Patron in 2023
- Branches With Above-Average Water Flow
- Breakthrough Third Session
- Bucket Daily Rainfall
- Busiest Scan Hour per Warehouse Zone
- Busiest Subway Station
- Captain of the Biggest Squad
- Carry Forward the Thermostat Setting
- Chess Club Ladder Standings
- Chess Club Standings
- City with Most Amenities
- Class Reservations and Waitlist Counts
- Classify Category Nodes
- Classifying Departments in an Org Chart
- Closest Pair of Sensor Stations
- Coffee Cupping Leaderboard
- Collaborator Pairs With No Shared Collaborator
- Combined Device Feature Flags
- Committed Gym Members
- Count Bottles and Cans Across Pallets
- Count Overlapping Room Bookings
- Count Workshops per Room and Track
- Courses Booked Heavily in Two Consecutive Years
- Cumulative Downloads per Platform
- Daily Net Inventory Movement
- Daily Warranty Approval Rate
- Debate League Standings and Divisions
- Debut Harvest of Each Wine
- Divisive Hiking Trails
- DoorDash Average Earnings per Weekday
- Each Athlete's Best Event
- Each Reader's Favourite Genre
- Each Reader's Three Latest Loans
- Eligible Trade-In Payouts
- Esports Ladder Standings by Split
- EV Charging Spend per Vehicle
- Everyone Under the Squadron Commander
- Facebook Heart-Reacted Posts
- Festival Category Wins
- First Sign-Ins by Day
- Flagging Patterns in Request Lines
- Fully Certified Staff
- Genres Whose Tracks Echo the Genre Initial
- Grant Applicants Who Cleared Review
- Group Tenants by Shared Rent
- Hackathon Favorite With the Most Weighted Picks
- Heaviest Parcel Shipped Each Day
- Hide Trial Tickets for Paying Members
- How Often Each Host Was a Guest
- Ingredients Frequently Used Together
- Interleave Volunteers by Shift Type
- Last Crate Loaded on the Delivery Van
- Latest Booking per Room
- Lead Climber on Each Route
- Leaderboard Shake-Up
- Listener Engagement Profile on a Music Service
- Listening Mix by Membership Tier
- Longest Gap Between Library Visits
- Longest Run of Open Parking Bays
- Longest Support Sessions per Channel
- Lopsided Recipes
- Loyalty Tier of Each Subscriber
- Match Counts Between Chess Players
- Member Count per Club
- Members Lifting Heavier Over Time
- Members Who Booked Yoga and Spin but Not Boxing
- Members Who Held a Pass but Never Checked In
- Members With a Quick Repeat Borrow
- Mentors With At Least Five Mentees
- Mid-Chain Mentors
- Middle-Tier Workshop Topics
- Minimum Donation Tier That Fits Each Venue
- Monthly Ad Performance by Region
- Monthly Shipments and Returns by Region
- Most Connected Co-Author
- Most Versatile Studios
- Most-Voted Book of the Month
- Mutual Translation Routes
- Net Payouts After Agency Fee
- Net Product Launches Year-over-Year
- Net Profit per Trading Card
- Next-Day Return Rate at a Climbing Gym
- Odd and Even Page Counts per Shelving Day
- Overworked Hospital Staff
- Peak Visitor Day for Each Trail
- Percentile Standing of Each Runner
- Pick the Best Courier for Each Delivery Zone
- Pivot Sales by Region and Quarter
- Plan Price on a Given Date
- Podcast Pairs Sharing the Most Subscribers
- Prime-Time Gym Regulars
- Promotion-Track Baristas
- Quietly Rented Board Games
- Resample Daily Metrics to Monthly
- Resolve Sensor Threshold Checks
- Riders per Ferry I
- Running Total of Donations per Donor
- Running Wallet Balance
- Salary vs Department Average
- Same-Day Rate on First Tickets
- Same-Day Repair Rate by Logged Date
- Saturday Donation Totals
- Saturday Sales by Loyalty Tier
- Scouts Who Earned Every Badge
- Second Most Expensive Book Price
- Second-Priciest Listing per Neighborhood
- Seven-Day Ridership Trend
- Shoppers With Multiple Products in a Day
- Shrinking Insurance Policies
- Solar Panels Generating More Per Sun-Hour
- Spot a Gym Check-in Spike
- Standout Clinics
- Steadily Climbing Athletes
- Streaming Subscribers on a Hot Streak
- Subscribers With Two Streams Within Five Days
- Support Tickets Grouped Into 4-Hour Shifts
- Swap Adjacent Relay Lanes
- Tasting Score Spread
- Third Fastest Marathon Time
- Three-Day Rolling Average of Solar Output
- Three-Flower Bouquet Costs
- Tickets Filed on Weekends vs Weekdays
- Tickets Mentioning Key Words
- Tickets That Eventually Closed
- Tight Collaborations
- Top 10 Songs with Deduplication
- Top Earning Dish per Diner
- Top Issue Tags in a Support Queue
- Top Marketing Channel by Season
- Top Percentile Return Rates by Region
- Top Reviewer and Best Episode
- Top Solar Installer per Panel Technology
- Top-Streamed Track in Each Genre
- Total Machine Run-Time in Days
- Triple Consecutive Sensor Codes
- Tuition Collected by Each Tutor
- Two Lists, Sorted Apart
- Unassigned Locker Numbers
- Verified References on Each Order
- Volunteers Who Fell Short of Their Pledge
- Wallet Balances After Transfers
- Warehouses Stocking Heavy Items Too Thinly
- Water Meters Over the Monthly Cap
- YouTube Most-Flagged Videos (Approved Only)
Hard Pandas questions 70
- Always Mid-Pack Bakers
- Annual Energy Output Growth by Panel Model
- Attendees By Track
- Auto-Tagging Support Tickets
- Bake-Off Division Champions
- Branch Energy Spend vs Chain Average
- Closed Loops in a Book-Swap Club
- Collaboration Reach of Each Researcher
- Compatible Carpool Pairs
- Confirmed or Waitlisted Webinar Seats
- Creators With Year-Over-Year Growth
- Daily Failed-Delivery Rate
- Daily Spend by Payment Channel
- Desk Cohesion Across Trading Sessions
- Devices With the Longest Run of Daily Check-ins
- Distinction Apprentices
- Distribution of Tickets Closed per Shift
- Driver Churn Year-over-Year
- Every Saturday's Donation Total
- Filling a Shipping Container
- Folder Tree Depth, Descendants and Rolled-Up Size
- Genres Commonly Heard by the Same Listeners
- How Many Veteran and Rookie Pilots Fit the Payroll
- Idle Forklift Shifts
- Itemize the Largest Repair Ticket
- Library Checkouts by Weekday and Genre
- Longest On-Crew Relay Streak
- Longest On-Time Streak
- Longest Steady Thermostat Streak
- Machines on a Repeating Maintenance Rotation
- Machines With Quick Back-to-Back Runs
- Malformed Mesh Node Addresses
- Median Reading From a Frequency Table
- Median-Priced Listing in Each Neighborhood
- Merge Overlapping Room Bookings
- Missing Lesson Steps
- Monthly Retention via Self-Merge
- Most-Mentioned Features in Reviews
- Next-Day Workout Retention
- Normalize Ingredient Names to Title Case
- Peak Concurrency and Total Overlap of Maintenance Windows
- Pivot Sensor Readings Into One Row Per Device
- Popular Exhibit-to-Exhibit Routes
- Rainwater Held by a Skyline
- Recipe Suggestions From Connections
- Render Node Utilisation
- Render the Polynomial Filter
- Research Lab Reporting Chain Under the Director
- Riders per Ferry II
- Roll Up Sunny and Rainy Streaks
- Rolling Z-Score Outlier Detection
- Same Opponent for First and Last Match of a Day
- Second Most Recent Service per Vehicle
- Shifts Above the Warehouse Average
- Solar Installer Monthly Activity (2021)
- Solar Installer Three-Month Rolling Averages (2021)
- Solar Installer Working Percentage (2021)
- Stations With a Warming Streak
- Suggest Study Partners
- Sustained Busy Days at the Toll Plaza
- Title-Case Recipe Names With Hyphens
- Top Three Food Trucks Per City
- Top Three Sellers per Warehouse
- Trailing Three-Month Sales, Excluding the Latest Month
- Trial Users Who Became Buyers
- Uber Revenue Loss from Cancellations
- Unpivot Sensor Readings Into Tall Format
- Was the Second Supply a Preferred Vendor?
- Which Veteran and Rookie Pilots Fit the Payroll
- Yearly Billboard Revenue per Panel