>>> df = pd.DataFrame(
... columns=["Continent", "Country", "Currency", "Price"],
... data=[
... ("Europe", "France", "EUR", 200.0),
... ("Europe", "Germany", "EUR", 150.0),
... ("Europe", "United Kingdom", "GBP", 120.0),
... ("America", "United states", "USD", 240.0),
... ("America", "Mexico", "MXN", 270.0),
... ],
... )
>>> table = session.read_pandas(
... df,
... keys={"Continent", "Country", "Currency"},
... table_name="Prices",
... )
>>> result = table.query(filter=table["Price"] >= 200)
>>> result.set_index(list(table.keys)).sort_index()
Price
Continent Country Currency
America Mexico MXN 270.0
United states USD 240.0
Europe France EUR 200.0
