MultiIndex for Columns with SchemaModel

[ap--]

Hello everyone 😃

I searched a bit and couldn't find a solution so far, is there a way to use the SchemaModel class syntax to define a schema for a dataframe using a column MultiIndex?

Cheers,
Andreas

[cosmicBboy]

hey @ap-- not sure if you able to find this, but the syntax for MultiIndex columns can be found here: https://pandera.readthedocs.io/en/stable/dataframe_schemas.html#multiindex-columns

[philipjusher]

hi. Firstly thanks for everyone work on pandera its ace!.
Second. I think the original post mentions the class-based API. https://pandera.readthedocs.io/en/latest/schema_models.html
I am also interested in wondering if the multiindex-columns is supported with the class-based api.

Hope you can help :)

[brrm]

Using eg. pa.Field(alias=('level1', 'level2')) should do the trick.

[philipjusher]

That's a good idea. Sadly I have moved on from those ideas but its good to know there is something else to explore.

[n-splv]

@brrm thanks, it works indeed.
@cosmicBboy maybe it's worth documenting it on the class api page?

[cosmicBboy]

Feel free to update the docstring!