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 Python 5050 Curated Python Problems

A 5-stage pandas progression from boolean indexing through groupby + rolling windows to staff-level multi-table scorecards, structured across 15 production-grade schemas — payments, lodging, streaming, social — so the same pattern repeats across different domains until it sticks. The Python companion to LDS SQL 50.

Problems included in LDS Python 50

  1. Active Advertiser Profiles
  2. High-Value Approved Claims
  3. Active Property Profiles
  4. Delivered Delivery Orders
  5. Captured USD Charges
  6. Large Single-Family Homes
  7. Delivered Ship Orders
  8. Enterprise Active Organizations
  9. Active Auto-Renewing Subscriptions
  10. Active Business Customers
  11. Campaigns with Advertiser Names
  12. Transactions With Account Type
  13. Positions With Security Names
  14. Reservations with Guest Names
  15. Orders With Customer Names
  16. Deliveries With Courier Info
  17. Trips With Rider Names
  18. Refunds With Charge Details
  19. Order Items With Product Details
  20. Plans Without Subscriptions
  21. Total Trade Volume by Security
  22. Average Satisfaction by Channel
  23. Impression Stats by Country and Device
  24. Compute Occupancy Rate
  25. Rank Accounts by Balance Within Type
  26. Running Total Revenue Per Merchant
  27. Daily Session Change
  28. 7-Day Moving Average Order Value
  29. Rank Drivers by Trip Count
  30. Order Value Quartile Bucketing
  31. Provider Claims Performance Summary
  32. Pivot Usage Quantities by Org and Metric
  33. Classify Campaigns by Budget Tier
  34. Loan Risk Classification
  35. Listing Competitiveness Score
  36. Cost Per Kg and Cost Per M3
  37. Account Age in Days
  38. Normalize Payment Amounts to USD
  39. Clean and Enrich User Portfolio Data
  40. Pivot Order Counts by Status and Fulfillment
  41. Monthly Usage Volume by Metric
  42. Post Engagement Score
  43. Campaign Performance Scorecard
  44. Full Customer Portfolio Report
  45. Full-Funnel Booking Report
  46. Warehouse Throughput Analysis
  47. Merchant Health Scorecard
  48. End-to-End Order Report
  49. Customer Success Dashboard
  50. Customer Health Classification