dedupe is a library that uses machine learning to perform de-duplication and entity resolution quickly on structured data.

dedupe will help you:

• remove duplicate entries from a spreadsheet of names and addresses
• link a list with customer information to another with order history, even without unique customer id's
• take a database of campaign contributions and figure out which ones were made by the same person, even if the names were entered slightly differently for each record

dedupe takes in human training data and comes up with the best rules for your dataset to quickly and automatically find similar records, even with very large databases.

• Documentation: http://dedupe.rtfd.org/
• Repository: https://github.com/datamade/dedupe
• Issues: https://github.com/datamade/dedupe/issues
• Examples: https://github.com/datamade/dedupe-examples
• IRC channel, #dedupe on irc.freenode.net

Command line tool for de-duplicating and linking CSV files. Read about it on Source Knight-Mozilla OpenNews.

###Spreadsheet Deduper Web interface for de-duplicating spreadsheets with up to 10,000 rows. Read about it on the DataMade blog.

If you only want to use dedupe, install it this way:

pip install "numpy>=1.6"
pip install dedupe

Dedupe requires numpy, which can be complicated to install. If you are installing numpy for the first time, follow these instructions. You'll need to version 1.6 of numpy or higher.

git clone git://github.com/datamade/dedupe.git
cd dedupe
pip install "numpy>=1.6"
for python 2.7
pip install -r requirements.txt
# OR for python 2.6
pip install -r py26_requirements.txt
python setup.py develop

Before installing, you may need to set the following environmental variables from the command line

export CFLAGS=-Qunused-arguments 
export CPPFLAGS=-Qunused-arguments

With default configurations, dedupe cannot do parallel processing on Mac OS X. For more information and for instructions on how to enable this, refer to the wiki.

Unit tests of core dedupe functions

nosetests

Using Deduplication

python tests/canonical_test.py

Using Record Linkage

python tests/canonical_test_matching.py

• Forest Gregg
• Derek Eder

Dedupe is based on Mikhail Yuryevich Bilenko's Ph.D. dissertation: Learnable Similarity Functions and their Application to Record Linkage and Clustering.

If something is not behaving intuitively, it is a bug, and should be reported. Report it here

• Fork the project.
• Make your feature addition or bug fix.
• Send us a pull request. Bonus points for topic branches.

Copyright (c) 2014 Forest Gregg and Derek Eder. Released under the MIT License.

Third-party copyright in this distribution is noted where applicable.

If you use Dedupe in an academic work, please give this citation:

Gregg, Forest, and Derek Eder. 2014. Dedupe. https://github.com/datamade/dedupe.