cswork / 公司打开练习工作台

按题目类别 · Capital One

Capital One 数据处理（SQL/Python） 面试题

Capital One 数据处理（SQL/Python）类面试准备：23 道面试题，来自候选人真实面试。在 CSWork 阅读、练习、模拟。

面试题
23
最近更新
2026-07-23

面试题 23

在工作台筛选
  1. 编程Find Lowest Prices for Highly Rated Categories中等
  2. 编程Write SQL to compute campaign net revenue中等
  3. 编程Merge CSVs and build revenue pivot with pandas中等
  4. 编程Find top category per region in Aug 2025中等
  5. 编程Reconcile ledgers with SQL/Python and late events中等
  6. 编程Write SQL for theme-park revenue and visits中等
  7. 编程Identify country with highest sunny-day probability中等
  8. 编程Merge four CSVs locally, robustly and efficiently中等
  9. 编程Write SQL for lowest price with ratings中等
  10. 编程Write SQL to find top net-revenue products中等
  11. 编程Audit flight data quality from metadata中等
  12. 编程Impute missing values without leakage中等
  13. 编程Merge seven tables into one clean DataFrame中等
  14. 编程Write SQL to quantify outage revenue loss中等
  15. 编程Design a reproducible data pipeline for modeling中等
  16. 编程Impute, join, and upsert using SQL and Python中等
  17. 编程Fix dash dates and aggregate watch time中等
  18. 编程Write one SQL for exam scores aggregation中等
  19. 编程Merge ad CSVs and compute CTR中等
  20. 编程Aggregate exam scores with NULL handling中等
  21. 编程Compute Customer Spend and Engineer Features for 2023中等
  22. 编程Calculate Longest Transaction Streak for Each User中等
  23. 编程Determine Country with Most 'Sunny' Days中等