PERF: MultiIndex slicing by lukemanley · Pull Request #46040 · pandas-dev/pandas (original) (raw)

import numpy as np
import pandas as pd

lev0 = pd.date_range("2000-01-01", "2020-12-31", freq="D")
lev1 = np.arange(10000)
mi = pd.MultiIndex.from_product([lev0, lev1])

df = pd.DataFrame({"A": 1.0}, index=mi)

%timeit df.loc["2010-12-31": "2015-12-31"]

132 ms ± 3.43 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)     <- main
571 µs ± 4.25 µs per loop (mean ± std. dev. of 7 runs, 1,000 loops each)  <- PR