Median house price in each cityCodingGiven a list of house sales with a city and a price, return the median price for each city. Group the prices by city in a dictionary, sort each group, and take the middle value…
Last asked Sep 2026
#data manipulation
- Find super hosts from listing and review rulesCodingGiven host data with their listings, ratings and reviews, return the hosts who qualify as super hosts under several rules that must all hold, such as a minimum number of listings…Last asked Sep 2026
Reconcile bank account balances across two datasetsCoding1. From a list of balance records for bank accounts, return the latest balance of an account, in the output format the tests expect. 2. A second dataset is added. Reconcile the…Last asked Aug 2026
Time-series manipulation with pandas groupbyCodingGiven a pandas DataFrame of timestamped records, answer questions with groupby: aggregate per group and time period, resample, and compute rolling or cumulative values. Explain…Last asked Aug 2025
Total covered time per session from overlapping clipsCodingA dataset lists driving-log clips with a set id, a run id, a start time and an end time. Clips within a set can overlap. For each set, compute the total time covered by its clips…Last asked Jul 2025