similarpanda

A module to check for differences between pandas Dataframes, and generate a report in Excel format.

This is helpful in a workplace setting, where you might need to check between different versions of an Excel file.

Inputs (to create the object)

• new: DataFrame
• old: DataFrame
• key_column: A reference to a common DataFrame column. If omitted, the data will be matched on the row position.

Returns:

• A similarpanda object
• Use similarpanda.output_excel() to generate an Excel report.

Note:

• Tabular data must contain unique column names.
• Only checks cell values. Formulae, formatting ets is disregarded.

Includes a helper Jupyer notebook, which supports in loading of tabular data:

• From specified named tables within named Excel files
• From the clipboard