datacompy 1.0.0b3

Dataframe comparisons in Python

DataComPy

DataComPy is a package to compare two DataFrames (or tables) such as Pandas, Spark, Polars, and even Snowflake. Originally it was created to be something of a replacement for SAS's PROC COMPARE for Pandas DataFrames with some more functionality than just Pandas.DataFrame.equals(Pandas.DataFrame) (in that it prints out some stats, and lets you tweak how accurate matches have to be). Supported types include:

• Pandas
• Polars
• Spark
• Snowflake

[!IMPORTANT] datacompy is progressing towards a v1 release. During this transition, a support/0.19.x branch will be maintained solely for v0.19.x users. This branch will only receive dependency updates and critical bug fixes; no new features will be added. All new feature development should target the v1 branches (develop and eventually main).

Quick Installation

pip install datacompy

or

conda install datacompy

Installing extras

If you would like to use Spark or any other backends please make sure you install via extras:

pip install datacompy[spark]
pip install datacompy[snowflake]

Supported backends

• Pandas: (See documentation)
• Spark: (See documentation)
• Polars: (See documentation)
• Snowflake/Snowpark: (See documentation)

Contributors

We welcome and appreciate your contributions! Before we can accept any contributions, we ask that you please be sure to sign the Contributor License Agreement (CLA).

This project adheres to the Open Source Code of Conduct. By participating, you are expected to honor this code.

Roadmap

Roadmap details can be found here