Occupancy revenue per host PRO

pandasmediumgroupbyagg

The full problem statement is available to Pro members.

preloaded fixtures

import pandas as pd
import numpy as np

listings = pd.DataFrame({
    "listing_id": [1, 2, 3, 4, 5, 6, 7, 8, 9],
    "host": ["Mika", "Mika", "Kenji", "Kenji", "Aria", "Aria", "Lou", "Lou", "Sam"],
    "city": ["SF", "SF", "Tokyo", "Tokyo", "SF", "Tokyo", "Paris", "Paris", "Berlin"],
    "price": [120, 65, 200, 80, 150, 35, 110, 55, 90],
    "nights_booked": [5, 1, 5, 0, 2, 4, 7, 0, 0],
})

This is a Pro problem

“Occupancy revenue per host” is part of the Pro problem set. Upgrade to unlock the harder half of every track — SQL, Python and pandas.

Upgrade to Pro

The first problems in each track stay free.