Stack Overflow
Stack Overflow

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
1 answer

Return text values from range that match text values from list?

I'm trying to create a report that will match the "type" of activity with specific activity items using a list of possible activity types. I would like to return those that match in another column/table. In my example, I should have 7 "type a" and 4…
mjl
  • 40
  • 5
0
votes
1 answer

Finding multiple values in two different dataframes. Python/Pandas

I have two data frames, df1 (8852 X 16) and df2 (302 X 4). In df2 the columns are poc_fristname, poc_lastname, phone, and email. in df1 it has all of these columns plus many other columns to it. I am trying to match multiple values from df2 to df1…
Astro_raf
  • 57
  • 5
0
votes
1 answer

How can i increase the URL length

On OSRM I try to match 500 locations by url, but get the error below: Request-URI Too Long The requested URL's length exceeds the capacity limit for this server. Apache/2.4.52 (Ubuntu) Server at 127.0.1.1 Port 80
bachgri
  • 1
  • 2
0
votes
2 answers

How can I write a script to remove whole rows if a cell in a column matches a value in another in google sheets?

Been very frustrating to figure this out. Lets say I have 5 columns in google sheets and there's 10,000 data points in column B, while column E only has 500 and each column has random strings of numbers (i.e. b2=46, b3=75, e2=177, e3=1, and so on).…
Nick Vrv
  • 1
0
votes
1 answer

Find matching score of products in a big string Python

I have this big string with products and some data: big_string ="""Supply and installation of extraction unit type OZEO FLAT AUTO 2 or similar of dimensions 500 mm x 460 mm x 185 mm ideal for installation in false ceiling of collective housing with…
Dani98
  • 11
  • 4
0
votes
4 answers

match between two array of objects javascript

I'm building an api to add orders for a store, in the function I receive identity attributes (clientId...) and an array of the order as so: order = [{packageId,quantity},...] I then get the prices of the packages from to DB the get the latest price…
Firas SCMP
  • 461
  • 4
  • 18
0
votes
1 answer

How do I group together string rows with partial matching strings and then sum them together?

Artist Points Notorious BIG 34 Notorious BIG feat. blah blah 42 2pac 20 Dr.Dre feat. 2pac 30 I would like to group and sum by Artist for a table to look like so: Artist Points Notorious BIG 76 2pac 50
Leon Hei
  • 31
  • 2
0
votes
0 answers

r - Estimate clustered standard errors for CBPS propensity scores

I'm using the package CBPS in R. How might I get clustered standard errors (SEs) for the propensity score coefficients? This question asks about robust SEs for treatment effects using CBPS, and not for the propensity score coefficients. Any help…
Smriti Ganapathi
  • 1
0
votes
2 answers

How to use regular expression in loop to extract only names in a sentence?

I'm trying to exctract names enclosed in square brackets and which appear only after a substring. In the example sentence shown below, the substring is "[A]." "This is [A].[Alpha] and this is [A].[Beta] and this is [A].[Charlie] and so on" I'm…
Preetham CS
  • 41
  • 6
0
votes
1 answer

Find First Non-Blank Cell With Data and Return Value on Separate Tab

I am trying to figure out a formula to find the first non blank cell with data on a separate tab from where I need the value returned. I've tried the following formula but no luck: =INDEX(Sheet2!H:H,MATCH(1,Sheet2!A:A=Sheet1!A3)*Sheet2!H:H<>"",0) On…
Mabel
  • 41
  • 3
0
votes
1 answer

Using MatchIt to match on percentiles of propensity scores while exact matching

I'm using MatchIt to perform time-varying propensity score matching. I estimate propensity scores and do nearest neighbour matching on those, as well as exact matching on a few variables (some which are used in the estimation of propensity scores,…
shiny_boson
  • 3
  • 2
0
votes
1 answer

VBA Matching two table

I have two tables like figure. If tables have same values, second table's column index should be same with first table. I need a vba code which fills second table's matching index column.
Taha Er
  • 1
  • 1
0
votes
0 answers

How to highlight MULTIPLE matching sequences of words in two strings in Python?

I'm using the code below to highlight a single matching sequence. (Just copy-paste it in a new Colab notebook, it'll work perfectly. import textwrap from nltk.tokenize import word_tokenize from nltk.tokenize.treebank import…
Mystic
  • 143
  • 9
0
votes
0 answers

How can I implement text classification for the purpose of matching using GPT-3?

I have tried fine tuning a GPT-3 model for the purpose of text classification to classify whether two names match such as 'William Jonathan' and 'William J' and the label would be yes/no, yes indicating that two names are matching and no indicating…
hhalaweh
  • 1
0
votes
1 answer

Compare one column in database x to another column in database y and return a database z containing high likely matches

I want to take a list of Customer names and compare them to an internal database to find a high likely match and return a customer code So I would receive a list of customers like this: Cx Name Chicken C. Water Gmbh Computer ldt Food,…
NomNonYon
  • 87
  • 6
1 2 3
…
99 100