Python utility to reconcile Pandas DataFrames
Project description
reconciler
reconciler
is a python package to reconcile tabular data with various reconciliation services, such as
Wikidata, working similarly to what OpenRefine
does, but entirely within Python, using Pandas.
Quickstart
You can install the latest version of reconciler from PyPI with:
pip install reconciler
Then to use it:
from reconciler import reconcile
import pandas as pd
# A DataFrame with a column you want to reconcile.
test_df = pd.DataFrame(
{
"City": ["Rio de Janeiro", "São Paulo", "São Paulo", "Natal"],
}
)
# Reconcile against type city (Q515), getting the best match for each item.
reconciled = reconcile(test_df["City"], type_id="Q515")
The resulting dataframe would look like this:
id | match | name | score | type | type_id | input_value |
---|---|---|---|---|---|---|
Q8678 | True | Rio de Janeiro | 100 | city | Q515 | Rio de Janeiro |
Q174 | True | São Paulo | 100 | city | Q515 | São Paulo |
Q131620 | True | Natal | 100 | municipality of Brazil | Q3184121 | Natal |
In case you want to ensure the results are cities from Brazil, you can specify the has_property argument with a specific property-value pair:
# Reconcile against type city (Q515) and items have the country (P17) property equals to Brazil (Q155)
reconciled = reconcile(test_df["City"], type_id="Q515", has_property=("P17", "Q155"))
Check out the documentation for more advanced usage and to learn how to contribute.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
reconciler-0.1.3.tar.gz
(5.4 kB
view hashes)
Built Distribution
Close
Hashes for reconciler-0.1.3-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 86ef8beb8e63a2a52a078277acba883ff3be83ea6ff7a4045608b4b96ac9fbe9 |
|
MD5 | 1a806b91a8fbd47befa2603b9722fff8 |
|
BLAKE2b-256 | 6e3de9d00289f138b2be2c1ab46f6af10877e22c684cd58f9ea872cad6b0516d |