Questions tagged [matching]

For questions related to pattern matching, using character sequences or tree structures. In contrast to pattern recognition, the match described here usually has to be exact.

2735 questions
0
votes
0 answers

How to fix Key Error of variable not found in index? Python

I am trying to fuzzy match two different datasets based on the name column in python. I am getting an error code that the name is not found in the index. The name variable is a column in both datasets. Can anyone provide me with any suggestions to…
0
votes
0 answers

matching strings of two different dataframes

I have two dataframes: df1 contains static data information like the ISIN and the Asset Type of an instrument; df2 contains time series for the same instruments and its columns are named with the ISINs df1 is like this: while df2 is like…
CristinaK
  • 23
  • 3
0
votes
0 answers

how to partially match between 2 columns in R

I'm having trouble finding out if values partially match between 2 columns in different tables so i could update values accordingly. The problem is trying to match a longer value with smaller value and having multiple prefix values. I don't want to…
Redesfist
  • 11
  • 4
0
votes
1 answer

A More Efficient Way to Compare CSV Columns and Adding to a certain row on Second CSV (Python)

So i'm new to python, I want to discover it's potential and get more knowledge about what I can do with it. I did this code to compare CSVs, basically what it does you provide it 2 CSVs, CSV1 that has some id column and a column with values that you…
Varqas
  • 17
  • 4
0
votes
0 answers

Roommate with matchingR package in R

In a one-sided matching problem (so called roommate problem) I would like find all possible stable matchings. I found the package matchingR, and there seems to be an error. Hence, I now have two questions. Here is an example. Suppose that we have 6…
Avocado
  • 70
  • 8
0
votes
0 answers

How can I improve my GCN model for graph matching/entity alignment

I'm currently trying to create a very basic graph matching/ entity alignment model but the results are really not good on the train set and even worse on the test set. I also tried to add dropout to improve my results but they became even worse So I…
Miliia
  • 83
  • 1
  • 3
0
votes
0 answers

Matching with matchit with flexible exact argument

I have some simple data of housing sales, divided into a control and a treatment group. I would like to get a matched control group that is similar to the treatment group on some characteristics (size of the house, age, number of rooms) using the…
SCW16
  • 403
  • 2
  • 4
  • 10
0
votes
1 answer

Propensity Score Matching for Diff-in-diff with panel data

I am trying to use MatchIt to perform Propensity Score Matching (PSM) for my panel data which contains following a group of participants (participant_uuid) from 12 months before treatment to 12 months after treatment, i.e. we have complete 24…
0
votes
0 answers

knnMatch gives different results if change the place of query and trained images

Im using knnMatch of opencv C++ for matching 2 images, called img1 and img2. I thought the results of matching img1 with img2 and matching img2 with img1 must be the same, but my codes showed that they are different. In my test, img1 is larger than…
0
votes
0 answers

Matching resolution and extent of rasters, what is the best practice?

after several errors I finally managed to match my raster data but now I have a more or less general question. I`m still quite new and would like to understand what´s happening with my data. I have two sets of data->meteorological (MD) and…
Sepp
  • 11
  • 2
0
votes
0 answers

Matching SIFT Features on 3 Images using OpenCV Python

The goal is to match 3 images using Python and OpenCV. Is there an approach how to do this? Currently, I am matching 1->2 and 2->3 using SIFT and the following code: img1 = cv2.imread('picture1.jpg', cv2.IMREAD_GRAYSCALE) img2 =…
YCLin
  • 1
  • 1
0
votes
0 answers

Fuzzy matching with bespoke function gives incorrect length of the output

In the code below, I have a function called correct_admin_names that takes in main_data, shapefile_data, and the variable they have in common, var_by. The goal of this function is to correct the variable they have in common in main_data by matching…
Mohamed Yusuf
  • 390
  • 1
  • 11
0
votes
1 answer

Excel columns, how to organize two columns based on a 3rd column which has their email address?

I am new to Excel. I've been searching for hours for an answer to this, but I've yet to find a tutorial to follow. I think what I want is fairly simple. I have 1 worksheet that looks like this: employee_workday_id email f349822220Z32 …
JeffGallant
  • 409
  • 2
  • 6
  • 17
0
votes
0 answers

Query to aggregate rows based on strings similarity

I want to aggregate a dataset based on string field and how similar values are. For example, the following table will show some values: ID Name 0231 Ebrahim Talaq 45621 Ebrahm Talaq 32134 Ebrahim Talaq L.L.C 5431234 Martin Cole The…
Ebrahim Talaq
  • 169
  • 1
  • 11
0
votes
0 answers

Propensity Score Matching with exact matching on some covariates and nearest neighbor matching on rest

Here is my sample: `structure(list(BB.ID = c("AX729354 Corp", "BK164389 Corp", "ZR655698 Corp", "AX729353 Corp", "AZ495660 Corp"), Name = c("ABESM 2 09/27/27", "ABESM 2 ¼ 03/29/29", "ABESM 1 03/26/28", "ABESM 1 ½ 06/27/24",…