datacompy
Our great sponsors
datacompy | diffable-sql | |
---|---|---|
4 | 1 | |
382 | 0 | |
8.9% | - | |
7.4 | 4.5 | |
6 days ago | 11 months ago | |
Python | Python | |
Apache License 2.0 | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
datacompy
- How to Check 2 SQL Tables Are the Same
-
Comparing 2 CSV files
datacompy is a package to compare 2 pandas dataframes
- Performing Data Tests on External Data/Complex Data Quality Checks
-
Best Practice When Comparing Data Across Two SQL Servers in Python
https://github.com/capitalone/datacompy will allow you to compare two tables/dataframes against one another, and see detailed results on the difference.
diffable-sql
-
How to Check 2 SQL Tables Are the Same
Slightly related: I recently needed to compare several large databases for schema differences. The output from `pg_dump` isn't very diff-friendly, so I built this[1].
1. https://github.com/orf/diffable-sql
What are some alternatives?
koalas - Koalas: pandas API on Apache Spark
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. 😊
data-science-ipython-notebooks - Data science Python notebooks: Deep learning (TensorFlow, Theano, Caffe, Keras), scikit-learn, Kaggle, big data (Spark, Hadoop MapReduce, HDFS), matplotlib, pandas, NumPy, SciPy, Python essentials, AWS, and various command lines.
merkle-tree-solidity - JS - Solidity sha3 merkle tree bridge. Generate proofs in JS; verify in Solidity.
data-diff - Compare tables within or across databases
dbt-audit-helper - Useful macros when performing data audits
blog
visualiza - A general-purpose dynamic data visualizer.
popmon - Monitor the stability of a Pandas or Spark dataframe ⚙︎
handy_sql_queries