Data Manipulation (SQL/Python) Interview Questions

Showing 91–120 of 446 results

• Capital OneMedium·Data Scientist
  Calculate Longest Transaction Streak for Each User

  This question evaluates proficiency in data manipulation and time-series sequence analysis, specifically measuring the longest run of consecutive successful transactions per user from transactional logs.

  Data Manipulation (SQL/Python)Technical Screen
• Capital OneEasy·Data Scientist
  Clean and Merge Housing Data

  This question tests the ability to clean messy housing datasets, handle inconsistent data types, and perform efficient left-joins with external reference data.

  Data Manipulation (SQL/Python)OnsitePandasData CleaningSQL
• Capital OneMedium·Data Scientist
  Compute Customer Spend and Engineer Features for 2023

  This question evaluates proficiency in SQL-based temporal aggregation and Python feature engineering on transactional datasets, including computing monthly spend summaries and engineering category-level spending features.

  Data Manipulation (SQL/Python)Onsite
• Capital OneMedium·Data Scientist
  Determine Country with Most 'Sunny' Days

  This question evaluates proficiency in data aggregation, grouping, and filtering to summarize categorical time-series records using SQL or equivalent Python data-manipulation tools, and it belongs to the Data Manipulation domain with an emphasis on practical application of query and aggregation techniques.

  Data Manipulation (SQL/Python)Onsite
• Capital OneMedium·Data Scientist
  Find top category per region in Aug 2025

  This question evaluates proficiency in SQL data manipulation skills such as joining related tables, aggregating revenue, filtering by date and status, and implementing deterministic tie-breaking for categories.

  Data Manipulation (SQL/Python)Online Assessment
• Capital OneMedium·Data Scientist
  Fix dash dates and aggregate watch time

  This question evaluates data-cleaning and aggregation competencies, focusing on handling nonstandard missing-date markers, forward-filling in spreadsheets, correct date-range filtering, pivot-table summarization, and concise pandas grouping and aggregation.

  Data Manipulation (SQL/Python)Online Assessment
• Capital OneMedium·Data Scientist
  Impute missing values without leakage

  This question evaluates proficiency in data imputation, strict train/validation leakage prevention, temporal per-user propagation rules, and categorical aggregation for model-ready features.

  Data Manipulation (SQL/Python)HR Screen
• Capital OneMedium·Data Scientist
  Merge CSVs and build revenue pivot with pandas

  This question evaluates proficiency in data manipulation and ETL using pandas, covering robust file I/O, join/merge semantics, null/coalescing behavior, date parsing, aggregation, and pivoting.

  Data Manipulation (SQL/Python)Online Assessment
• Capital OneMedium·Data Scientist
  Merge ad CSVs and compute CTR

  This question evaluates SQL data manipulation competencies such as cleaning and merging CSVs, forward-filling missing dates, correct multi-table joins without duplication, use of window functions, time-windowed aggregations, and computation of click-through rate (CTR).

  Data Manipulation (SQL/Python)Online Assessment
• Capital OneMedium·Data Scientist
  Merge seven tables into one clean DataFrame

  This question evaluates proficiency with pandas-based data manipulation, including multi-table joins, aggregations, dtype enforcement, denormalization, and verification of row/column integrity within the Data Manipulation (SQL/Python) domain for a Data Scientist role.

  Data Manipulation (SQL/Python)HR Screen
• Capital OneMedium·Data Scientist
  Reconcile ledgers with SQL/Python and late events

  This question evaluates a candidate's ability to implement data reconciliation and ETL engineering skills, including SQL window functions and joins, time-based FX rate lookups, matching logic for late-arriving events, idempotent daily pipeline design with deterministic keys and exactly-once semantics, and basic statistical charting in Python.

  Data Manipulation (SQL/Python)Technical Screen
• Capital OneMedium·Data Scientist
  Write SQL for lowest price with ratings

  This question evaluates SQL data-manipulation skills including aggregation, conditional filtering, NULL handling, grouping, and deterministic ordering, and sits in the Data Manipulation (SQL/Python) domain with an emphasis on practical application of query writing rather than purely conceptual design.

  Data Manipulation (SQL/Python)Technical Screen
• Capital OneMedium·Data Scientist
  Write SQL for theme-park revenue and visits

  This question evaluates SQL data-manipulation and analytical skills, including joins, aggregations, date-range filtering, handling multiple ticket ownership, and edge cases like zero counts when computing revenue and visit metrics.

  Data Manipulation (SQL/Python)Onsite
• Capital OneMedium·Data Scientist
  Write SQL to compute campaign net revenue

  This question evaluates SQL-based data manipulation and analytics skills, including aggregation, deduplication, date-range filtering, revenue and cost calculations, and selection logic for prioritizing additional donors.

  Data Manipulation (SQL/Python)Onsite
• Capital OneMedium·Data Scientist
  Write SQL to find top net-revenue products

  This question evaluates proficiency in SQL data manipulation, including joins, aggregations, date-window filtering, handling returns and net-revenue calculations, plus the use of analytic/window functions for per-category ranking and tie-breaking.

  Data Manipulation (SQL/Python)Technical Screen
• CCharacter.AIMedium·Data Scientist
  Write SQL for character safety and engagement metrics

  This question evaluates proficiency in SQL-based data manipulation and analytics, specifically aggregations, joins, date-based grouping, ratio calculations, and windowed moving averages to compute safety and engagement metrics.

  Data Manipulation (SQL/Python)Technical Screen
• ChimeMedium·Data Scientist
  Analyze Acquisition Channels for User Value and Retention

  This question evaluates proficiency in SQL/Python data manipulation and analytics, testing aggregation, cohort and retention analysis, ranking, joins and window-function usage along with interpretation of user-level revenue metrics.

  Data Manipulation (SQL/Python)Technical Screen
• ChimeMedium·Data Scientist
  Define and Analyze Early Engagement

  Define an early user activation metric for a fintech platform, write a SQL query to measure monthly cohort activation rates across acquisition channels, and account for lifecycle maturity bias.

  Data Manipulation (SQL/Python)Technical Screensqlcohort-analysisfintech
• ChimeMedium·Data Scientist
  Write SQL for noisy A/B launch metrics

  This question evaluates SQL-based data manipulation and experimental analytics skills, including attribution of earliest exposures, censoring crossovers, session-based bot qualification, time-windowed conversion and revenue calculations, and exclusion of outage periods in PostgreSQL.

  Data Manipulation (SQL/Python)Technical Screen
• ChimeMedium·Data Scientist
  Write rolling-window SQL over weekly cohorts

  This question evaluates proficiency with SQL window functions and CTEs for time-based cohort aggregation, including rolling ROWS-based sums, LAG-based week-over-week percent change, DENSE_RANK ranking, and handling first- and second-purchase calculations.

  Data Manipulation (SQL/Python)Technical Screen
• CircleMedium·Software Engineer
  Write PostgreSQL updates with date filters

  This question evaluates competency in PostgreSQL data manipulation, covering updates with correct timestamp handling, upserts with conflict resolution, date-range selection using timestamptz, and index design plus performance analysis with EXPLAIN ANALYZE.

  Data Manipulation (SQL/Python)Online Assessment
• CClickhouseMedium·Data Engineer
  Answer SQL And Data Warehouse Fundamentals For A Data Engineering Interview

  This problem tests foundational knowledge of SQL set operations, performance optimization techniques for join operations, and the architectural principles behind building scalable data warehouses.

  Data Manipulation (SQL/Python)Technical ScreenSQLData WarehousingWindow Functions
• CCloudTrucksMedium·Data Scientist
  Calculate Average Rate and Cumulative Jobs by State

  This question evaluates competency in relational data manipulation and analytical SQL concepts—including joins, aggregation with DISTINCT counts, per-date averaging, rolling cumulative counts, and handling numeric edge cases—within the Data Manipulation (SQL/Python) domain for a data scientist role.

  Data Manipulation (SQL/Python)Technical Screen
• CoinbaseMedium·Data Scientist
  Compute adoption, latency, and cross-region transactions

  This question evaluates proficiency in SQL-based data manipulation and analytics, including calculating cohort adoption and transaction rates, performing date arithmetic for time-to-first-transaction, identifying cross-region transactions, and computing distributional percentiles.

  Data Manipulation (SQL/Python)Onsite
• CoinbaseMedium·Software Engineer
  Compute delivery metrics and top-K queries

  Compute delivery metrics and top-K queries evaluates SQL or pandas logic, joins, grouping, window functions, null handling, edge cases, and validation in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

  Data Manipulation (SQL/Python)Onsite
• CoinbaseMedium·Software Engineer
  Implement filters and cursor pagination

  This question evaluates a candidate's ability to design and implement cursor-based pagination, conjunctive per-field filtering, stable sort key selection, API surface design, and complexity analysis for a database-backed transaction query module.

  Data Manipulation (SQL/Python)Onsite
• CoinbaseMedium·Data Scientist
  Write SQL and Python for funnels/retention

  This question evaluates SQL and Python data-manipulation skills, including event-to-session joins, temporal window filtering, deduplication, JSON metadata handling, and computation of funnel and retention metrics like daily unique users and conversion rates.

  Data Manipulation (SQL/Python)HR Screen
• CoinbaseMedium·Data Scientist
  Write SQL: sum values ≤ each row’s value

  This question evaluates proficiency in SQL aggregation, query optimization, and handling duplicate values when computing cumulative sums across rows. It is commonly asked to assess practical ability in the Data Manipulation (SQL/Python) domain to design scalable, efficient queries and demonstrates a focus on practical application of query-design and optimization rather than purely conceptual theory.

  Data Manipulation (SQL/Python)Onsite
• ConfluentMedium·Data Scientist
  Determine Tutorial Completion Rate by Variant in 7 Days

  This question evaluates a candidate's competency in data manipulation and event-based analytics, focusing on skills such as joining user and event tables, aggregating event data, and computing cohort completion metrics by variant.

  Data Manipulation (SQL/Python)Onsite
• CoupangMedium·Data Scientist
  Monthly Cohort Retention

  This question tests the ability to transform raw user activity logs into a cohort retention matrix by calculating the time elapsed between a user's first interaction and subsequent activity.

  Data Manipulation (SQL/Python)Technical ScreenSQLRetentionCohort Analysis