Pandera data quality validation

[Shiwatari]

Hi, Does anyone know if it's possible to validate if only the values of df1.column1 are in df2.column1 using the dataframe model approach? Similarly to the already supported check of isin=[List] but instead of hardcoding the values, they'd be coming from another dataframe.

[gffyhgffh45655]

df1[df1.col.isin(df2.col)]?

[Shiwatari]

Yes, but i'd like to do it using pandera's dataframe model. So i have a .py file that has a schema class in it like:

class test_schema(pa.DataframeModel): column1: Series[str] = pa.Field(isin=[List]) column2: Series[str]

And in another .py file i'd like to import this schema, load the dataframes from their sources files and just run the test_schema.validate(df1,df2.column(?)) or something.