Questions tagged [name-matching]

22 questions
20
votes
5 answers

Matching records based on Person Name

Are there any tools or methods that can be used for matching by a person's name between two different data sources? The systems have no other common information and the names have been entered differently in many cases. Examples of non-exact…
Even Mien
  • 44,393
  • 43
  • 115
  • 119
7
votes
2 answers

Name Matching in python

We have a third party 'tool' which finds similar names and assigns a similarity score between two names. I am supposed to mimic the tool's behavior as closely as possible. After searching over internet, gave a shot at distance method.Used fuzzywuzzy…
Soumya
  • 885
  • 3
  • 14
  • 29
5
votes
1 answer

Cosine Similarity between columns of two dataframes of differing lengths?

I have text column in df1 and text column in df2. The length of df2 will be different to that of length of df1. I want to calculare cosine similarity for every entry in df1[text] against every entry in df2[text] and give a score for every…
3
votes
2 answers

Human Name lookup / translation

I am working on a requirement to match people from different databases. One tricky problem is variance in names like Bob - Robert, Jim - James, Lizzy - Elizabeth etc across databases. Is there a lookup/translation available for this kind of a…
Gnana
  • 573
  • 2
  • 6
  • 14
2
votes
1 answer

What robust algorithm implementation can I use to perform phrase similarity with two inputs?

This is the problem: I have two columns in my matadata database "field name" and "field description" I need to check if the "field description" is actually a description and not some sort of transformation of the "field name" [Edit] I need to avoid…
2
votes
6 answers

How to handle elements ID when using jQuery and ASP.NET user controls

I have some user controls in ASP.NET that I am using as simply HTML, that is, without any code-behind. I one control I have an element with a fixed ID and I am pointing it with some jQuery client scripts. For example:
Lorenzo
  • 29,081
  • 49
  • 125
  • 222
2
votes
2 answers

Make suggestions based off of person's name

So I've searched fuzzy searching, the Levenshtein Distance Algorithm and I'm not sure if either are a true fit for what I'm doing. Please let me know your thoughts, if any... How can I take a user's full name, and generate a list of similar names? I…
Mark
  • 21
  • 1
2
votes
1 answer

Correlate vectors whose colnames match the values of two variables in each row in r dataframe

I have this dataframe in r (link) (Example rows and columns below) FocalID Mother Adelaide Asimov Austen Brazzaville Lusaka Kinshasa Adelaide HalfEar 0 0.0380 0.0417 0.0366 0.0278 0.0385 Asimov Lusaka 0.0380 0 …
2
votes
1 answer

Name matching dictionary for finding first and last name variants

I have an application that will store and track visitors. These visitors are created in the system by schedulers(users) as needed when they set up a visit. The problem is that most of the time the only important unique identifiers of a visitor are…
maple_shaft
  • 10,435
  • 6
  • 46
  • 74
2
votes
1 answer

Name-matching against table with alternative spellings

I have a table with alternative spellings of country names: Use name, Alt1, Alt2, Alt3, Alt4 [...] Bahamas, "Bahamas, The" Bolivia Bosnia and Herzegovina, Bosnia & Herzegovina [...] (Some countries have 0 alternative spellings, other up to 4.) …
dani
  • 4,880
  • 8
  • 55
  • 95
2
votes
1 answer

Text matching names in java

I've a sports application where the captain can register his team for a tournament. There can be multiple tournaments in an year and each tournament requires registration. Now, I want to support the below in registration process If a Player has…
Aravind Yarram
  • 78,777
  • 46
  • 231
  • 327
1
vote
0 answers

Perhaps a bug of using the three-dot argument in R 3.6.3

It seems to me a bug for using ... to pass function arugments in R 3.6.3. Specifically, the named arguments will try to partial match the arguments in ..., not exact match. Here's an example: func1 <- function(varname, ...) { cat(varname,…
Sam Cao
  • 21
  • 1
1
vote
1 answer

NAME MATCHING. Running a sparse_dot_topn function is giving me Warning: Kernel Restarted?

I am trying to match our company names to a government's database of company names using cosine similarity via the awesome_cossim_top. So, I convert my ngrams tf-idf into a CSR matrix and run it through the function. It does not run and restarts my…
1
vote
1 answer

Match partial file name to full file name

I have file list named in the following way csv_files<-list.files(path, pattern =‘.csv’) 1001_2017_01_02#19_30_24.csv 1002_2018_03_01#20_30_54.csv... Format is essentially: id _year_month_day#hour_min_sec.csv. I have striped the ID and date from…
e.matt
  • 836
  • 1
  • 5
  • 12
0
votes
0 answers

Fuzzy Matching player names in R

In R, I have two dataframes, one with full names and one with abbreviated names, I want to dplyr join them to see which one has a flag. However, it is very hard to get matched names, even when I match last names, there are same last names. I'm…
1
2