final class atoti.NaturalOrder
Ascending or descending natural order.Example
>>> df = pd.DataFrame(
... {
... "Date": ["2021-05-19", "2021-05-20"],
... "Product": ["TV", "Smartphone"],
... "Quantity": [12, 18],
... }
... )
>>> table = session.read_pandas(df, table_name="Sales")
>>> cube = session.create_cube(table)
>>> l, m = cube.levels, cube.measures
>>> l["Date"].order == tt.NaturalOrder()
True
>>> cube.query(m["Quantity.SUM"], levels=[l["Date"]])
Quantity.SUM
Date
2021-05-19 12
2021-05-20 18
>>> l["Date"].order = tt.NaturalOrder(ascending=False)
>>> cube.query(m["Quantity.SUM"], levels=[l["Date"]])
Quantity.SUM
Date
2021-05-20 18
2021-05-19 12