atoti.NaturalOrder#
- 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