Skip to content

All company names, logos, and trademarks are the property of their respective owners. Their use is for identification purposes only and does not imply endorsement.

LDS Data Scientist Interview Prep 7575 Curated Python Problems

A 6-round simulator of the modern DS onsite: SQL screen, SQL analytics, A/B testing & experiment analysis, pandas coding, statistical reasoning, and an ML feature-engineering capstone. Seventy-five problems across SQL and Python on 15 production-grade schemas — including a dedicated A/B testing round with Welch's t-test, chi-square, ANOVA, and CUPED, drilled the way interviewers actually ask it.

Problems included in LDS Data Scientist Interview Prep 75

  1. Active Search Campaigns by Budget
  2. Verified High-Balance Checking Accounts
  3. Active Verified Users by Income
  4. Active PPO Plans With Prescription Coverage
  5. High-Value Direct Bookings
  6. Gold-Tier Business Customers
  7. Prime Members With Card Payment
  8. Active Sellers With High Rating
  9. Active Users in Target Countries
  10. High-Rated Titles with Reviews
  11. Campaigns Launched in Last 30 Days
  12. Recent Filled Trades Last 30 Days
  13. Rank Accounts by Balance Within Account Type
  14. Rank Providers by Claim Volume
  15. Properties Above Average Revenue
  16. Monthly Order Volume Trend
  17. Daily Revenue Running Total
  18. Daily Platform Revenue Running Total
  19. Daily Platform Fee Running Total
  20. Users With Both Inquiries and Tours
  21. Seller Performance Scorecard
  22. Customer 360 Summary
  23. Creative Type A/B Test — CTR by Variant
  24. Plan Tier A/B Test — Watch Engagement by Variant
  25. Post Visibility A/B Test — Reaction Rate by Variant
  26. Fulfillment Channel A/B Test — Order Completion by Variant
  27. A/B Significance Sanity Check (Z-score)
  28. Sample-Size Adequacy Check for A/B Test
  29. A/B Mean Comparison: Image vs Video CTR (t-test)
  30. A/B Proportion Test: Fulfillment Conversion (chi-square)
  31. Multi-arm A/B: Watch Time by Plan Tier (ANOVA)
  32. CUPED-Style Covariate Adjustment for Variance Reduction
  33. Active Advertiser Profiles
  34. Verified Customer Profiles
  35. Active User Profiles
  36. Line Items With Procedure Details
  37. Payments with Booking Channel
  38. Total Freight Cost by Carrier
  39. Total Revenue by Cuisine Type
  40. Rank Drivers by Trip Count
  41. Standardize Payment Brands to Categories
  42. Price Change From Previous Event
  43. 7-Day Moving Average Order Value
  44. Invoice With Payment Details
  45. Campaign Budget Descriptive Stats
  46. Account Balance Descriptive Statistics
  47. Portfolio Value Descriptive Stats by Strategy
  48. Claim Amount Descriptive Stats by Place of Service
  49. Nightly Rate Descriptive Stats
  50. Shipment Freight Quartile Bucketing
  51. Restaurant Revenue Quartile Bucketing
  52. Driver Earnings Quartile Bucketing
  53. Merchant Charge Volume Quartile
  54. Usage vs Satisfaction Correlation
  55. Watch Time vs Rating Correlation
  56. Two-Sample t-Test: Card vs Wallet Charge Amounts
  57. Chi-Square Test: Payment Method vs Order Completion
  58. Bootstrap 95% Confidence Interval for Mean Invoice Amount
  59. Campaign Spend Quartile Bucketing
  60. Transaction Amount Quartile Bucketing
  61. Trade Amount Quartile Bucketing
  62. Claim Amount Quartile Bucketing
  63. Reservation Value Quartile Bucketing
  64. Time-Based Order Features
  65. Time-Based Order Features
  66. Time-Based Trip Features
  67. Merchant Feature Matrix
  68. Listing Feature Matrix
  69. Customer Feature Matrix
  70. Organization Feature Matrix
  71. Campaign ROAS by Attribution Model
  72. Customer Portfolio Health Scorecard
  73. Linear Regression: List Price ~ Area + Beds + Baths
  74. Train/Test R² Evaluation: Customer Lifetime Value
  75. Precision / Recall / F1: Claim Denial Predictions