This Record Linkage Toolkit is a library to link records in or between data sources. The package provides most of the tools needed for record linkage. The package contains indexing methods, functions to compare records and classifiers. The package is developed for research and linking of small or medium sized files.
This project is inspired by the Freely Extensible Biomedical Record Linkage (FEBRL) project, which is a great project. This project has one big difference, it uses pandas
and numpy
for data handling and computations. The use of pandas
, a flexible and powerful data analysis and manipulation library for Python, makes the record linkage process much easier and faster. A lot of built-in pandas
methods can be used to integrate your record linkage directly into existing data manipulation projects.
One of the aims of this project is to make an extensible record linkage framework. It is easy to include your own indexing algorithms, comparison/similarity measures and classifiers.
Import the recordlinkage
module with all important tools for record linkage and import the data manipulation framework pandas.
import recordlinkage
import pandas
For examples, you try to link two datasets with personal information like name, sex and date of birth. Load these datasets into a pandas DataFrame
.
df_a = pandas.DataFrame(YOUR_FIRST_DATASET)
df_b = pandas.DataFrame(YOUR_SECOND_DATASET)
Comparing all record can be computationally intensive. Therefore, we make smart set of candidate links with one of the built-in indexing techniques like blocking. Only records pairs that agree on the surname are included.
index = recordlinkage.Pairs(df_a, df_b)
candidate_links = index.block('surname')
For each candidate link, compare the pair of records with the Compare class and the available comparison/similarity functions.
compare = recordlinkage.Compare(candidate_links, df_a, df_b)
compare.string('name', 'name', method='jarowinkler', threshold=0.85)
compare.exact('sex', 'gender')
compare.exact('dob', 'date_of_birth')
compare.string('streetname', 'streetname', method='damerau_levenshtein', threshold=0.7)
compare.exact('place', 'placename')
compare.exact('haircolor', 'haircolor', missing_value=9)
# The comparison vectors
compare.vectors
This record linkage package contains several classification alogirthms. Plenty of the algorithms need trainings data (supervised learning) while others are unsupervised. An example of supervised learning:
true_linkage = pandas.Series(YOUR_GOLDEN_DATA, index=pandas.MultiIndex(YOUR_MULTI_INDEX))
logrg = recordlinkage.LogisticRegressionClassifier()
logrg.learn(compare.vectors[true_linkage.index], true_linkage)
logrg.predict(compare.vectors)
and an example of unsupervised learning (the well known ECM-algorithm):
ecm = recordlinkage.BernoulliEMClassifier()
ecm.learn(compare.vectors)
The main features of the recordlinkage package are:
- Clean and standardise data
- Make pairs of records with several indexing methods such as blocking and sorted neighbourhood indexing
- Compare records with a large number of comparison and similarity functions (including the jaro-winkler and levenshtein metrics)
- Several classifications algorithms, both supervised and unsupervised algorithms.
The most recent documentation can be found at recordlinkage.readthedocs.org.
The following packages are required. You probably have it already ;)
The following packages are recommanded
- jellyfish: Needed for approximate string comparison. Version 0.5.0 or higher.
Install the package with pip
pip install recordlinkage
The license for this record linkage tool is GPLv3.
Stuck on your record linkage code or problem? Any other questions? Don't hestitate to send me an email (jonathandebruinhome@gmail.com).