A package for the matching of company names
Project description
Name matching
Name matching is a Python package for the matching of company names. This package has been developed to match the names of companies from different databases together to allow them to be merged. The package has a number of options to determine how exact the matches should be and also for the selection of different name matching algorithms.
For a more in-depth discussion of the name matching package please see the company name matching medium post
Installation
The package can be installed via PiPy:
pip install name_matching
Alternatively you could install the package by downloading the repo, navigating to the folder and run the setup in pip locally
pip install .
Usage
To see example usage of the package you can use the notebook folder. An example of the usage is also given below
import pandas as pd
from name_matching.name_matcher import NameMatcher
# define a dataset with bank names
df_companies_a = pd.DataFrame({'Company name': [
'Industrial and Commercial Bank of China Limited',
'China Construction Bank',
'Agricultural Bank of China',
'Bank of China',
'JPMorgan Chase',
'Mitsubishi UFJ Financial Group',
'Bank of America',
'HSBC',
'BNP Paribas',
'Crédit Agricole']})
# alter each of the bank names a bit to test the matching
df_companies_b = pd.DataFrame({'name': [
'Bank of China Limited',
'Mitsubishi Financial Group',
'Construction Bank China',
'Agricultural Bank',
'Bank of Amerika',
'BNP Parisbas',
'JP Morgan Chase',
'HSCB',
'Industrial and Commercial Bank of China',
'Credite Agricole']})
# initialise the name matcher
matcher = NameMatcher(number_of_matches=1,
legal_suffixes=True,
common_words=False,
top_n=50,
verbose=True)
# adjust the distance metrics to use
matcher.set_distance_metrics(['bag', 'typo', 'refined_soundex'])
# load the data to which the names should be matched
matcher.load_and_process_master_data(column='Company name',
df_matching_data=df_companies_a,
transform=True)
# perform the name matching on the data you want matched
matches = matcher.match_names(to_be_matched=df_companies_b,
column_matching='name')
# combine the datasets based on the matches
combined = pd.merge(df_companies_a, matches, how='left', left_index=True, right_on='match_index')
combined = pd.merge(combined, df_companies_b, how='left', left_index=True, right_index=True)
Contributing
All contributions are welcome. For more substantial changes, please open an issue first to discuss what you would like to change.
License
The code is licensed under the MIT/X license an extended version of the licence: MIT
Thanks
Thanks to the work of implementing name matching algorithms done in the Abydos package. These form the basis of the name matching algorithms used in this package.
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
Built Distribution
Hashes for name_matching-0.8.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 07559410ddb4c125da9bc4835bf25941e35e52b34f1c81380bc7570daea96c2c |
|
MD5 | 921ec1d2bb2146aadde89a6ad90e6e15 |
|
BLAKE2b-256 | a583db697a4206d1570a3e2c763d0c5ecd809aa4851e4b8c3e1e9a2aa38de60a |