Premium problem60. Tuple-Index a MultiIndex with .loc

Medium Locked

Build a MultiIndex from date and ticker, then select the row identified by date == "2020-01-01" and ticker == "GOOGL", restricted to the columns from open through close inclusive (in their original column order).

Input

         date ticker  open  close
0  2020-01-01   AAPL    95    100
1  2020-01-01  GOOGL   190    200
2  2020-01-02   AAPL    99    101

Output

open     190
close    200
Name: (2020-01-01, GOOGL), dtype: int64

Premium problem

This one's part of Premium. Unlock the full Pandas track plus every other premium problem on the site.

Implement solve(...)