frameon.analyze_join_keys#

analyze_join_keys(left_df: DataFrame, right_df: DataFrame, on: str | List[str] = None, left_on: str | List[str] = None, right_on: str | List[str] = None, short_result: bool = True, only_coverage: bool = False, how: Literal['all', 'inner', 'left', 'right', 'outer'] = 'all') None[source]#

Analyzes key relationship and coverage between two DataFrames. Prints a formatted summary of the results and returns detailed metrics.

Parameters:#

left_dfpd.DataFrame

Left DataFrame for analysis

right_dfpd.DataFrame

Right DataFrame for analysis

onstr or list, optional

Column name(s) present in both DataFrames (like pd.merge)

left_onstr or list, optional

Column name(s) in left DataFrame (like pd.merge)

right_onstr or list, optional

Column name(s) in right DataFrame (like pd.merge)

short_resultbool, optional

Whether to show short result

only_coverage: bool, default False

Whether to show only coverage between tables

howstr

Join type to show in short result. Can be one of ‘all’, ‘inner’, ‘left’, ‘right’, ‘outer’.

Returns:#

None