StringComparison

>>> df = pd.DataFrame(
...     {"File": ["file1", "file10", "file2", "File1", "File10", "File2"]}
... )
>>> table = session.read_pandas(df, table_name="Example")
>>> cube = session.create_cube(table)
>>> l, m = cube.levels, cube.measures

>>> l["File"].ordering = tt.Ordering(
...     string_comparison=tt.StringComparison(digits="lexicographic"),
... )
>>> cube.query(m["contributors.COUNT"], levels=[l["File"]]).index.tolist()
['File1', 'File10', 'File2', 'file1', 'file10', 'file2']

>>> l["File"].ordering = tt.Ordering(
...     string_comparison=tt.StringComparison(digits="numeric"),
... )
>>> cube.query(m["contributors.COUNT"], levels=[l["File"]]).index.tolist()
['File1', 'File2', 'File10', 'file1', 'file2', 'file10']

>>> l["File"].ordering = tt.Ordering(
...     string_comparison=tt.StringComparison(case="sensitive"),
... )
>>> cube.query(m["contributors.COUNT"], levels=[l["File"]]).index.tolist()
['File1', 'File10', 'File2', 'file1', 'file10', 'file2']

>>> l["File"].ordering = tt.Ordering(
...     string_comparison=tt.StringComparison(case="insensitive"),
... )
>>> l["File"].ordering.string_comparison.case
'insensitive'
>>> cube.query(m["contributors.COUNT"], levels=[l["File"]]).index.tolist()
['File1', 'file1', 'File10', 'file10', 'File2', 'file2']