Airbnb Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Aggregate User Activity, Fit Regression, Interpret Coefficients
user_metrics +----------+------------+---------+--------+-----------+ | user_id | activity_dt| variant | clicks | purchases | +----------+-----------...
Compute C/T metrics from bookings and visits
Given two tables, compute control vs treatment (C/T) metrics, apply 24‑hour attribution, and generate a daily plot. Treat “today” as 2025‑09‑01; use t...
Compute browsing metrics in Python from logs
Given event logs, write idiomatic Pandas to compute segment-level metrics and a funnel. Data schema: events(event_id, ts_utc, guest_id, device in {des...
Build panel in SQL; run causal regression
Assume today is 2025-09-01 (UTC). Schema and small samples: users(user_id INT, country STRING, signup_date DATE, platform STRING) Sample: user_id | co...
Review a geospatial Python module
You receive a Python module that processes geospatial datasets (CSV/GeoJSON) to compute distances, cluster nearby points, and write summaries. Perform...