Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Blocking Error #1204

Open
mmyhill opened this issue Aug 26, 2024 · 0 comments
Open

Blocking Error #1204

mmyhill opened this issue Aug 26, 2024 · 0 comments

Comments

@mmyhill
Copy link

mmyhill commented Aug 26, 2024

Hi there,

We have been trying to use dedupe to clean a large dataset of company names gathered from job postings. Before loading the list of unique company names into a modified version of mysql_example.py, we standardize them by removing punctuation and spaces, converting to lowercase, and removing common substrings like "corporate."

For an example of what records we seek to block together, as well as the cleaning process:
Screenshot 2024-08-26 at 10 41 09 AM

Note that while "Tmobile" and "T-Mobile, US" should be labelled as the same company (as should "Target" and "target13"), "Amazon Herb Company" should be blocked separately from "Amazon Corporate LLC Pvt Ltd", "Amazon Corporation", and "Amazon Corp Seattle."

No matter what we do, we always run into "BlockingError: No records have been blocked together. Is the data you are trying to match like the data you trained on? If so, try adding more training data." It is unclear whether this is caused by an error in the original mysql_example.py, our modifications to it, or the training stage, but we have tried this on numerous datasets of company names (of various sizes, levels of duplication, etc.) and gotten the same result. Here is the full stack trace:
Screenshot 2024-08-26 at 2 25 45 PM

We also have data on the industry NAICS code (at the 2 digit and 3 digit level) and location (at the state, county, and city level) for each posting observation if either of those things could be helpful.

Linked in this Google Drive folder is the modified mysql_example files we have been working with, as well as a sample of the data.

Any help or suggestions are GREATLY appreciated!

@dedupeio dedupeio deleted a comment from aquatinta Sep 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants
@mmyhill and others