提问人:Chitwan 提问时间:7/12/2023 最后编辑:Chitwan 更新时间:7/13/2023 访问量:38
在Excel中使用模糊查找进行字符串匹配
String Match using Fuzzy Lookup in Excel
问:
我正在尝试使用模糊查找来匹配如下所示的表的两列中的两个字符串。 表1 表2
| Column A | Column B |
| -------- | -------- |
| Flower.com | Flower |
| Flower.com | snacks |
| Flower.com | food |
When I apply Fuzzy lookup to the above tables I get false positive. In the sense I get a similarity score of 0.987 for all three rows.
Table1 Table2
| Column A | Column B | Similarity Score |
| -------- | -------- | ---------------|
| Flower.com | Flower | 0.987 |
| Flower.com | snacks | 0.987 |
| Flower.com | food | 0.987 |
Which is not making any sense. I have tried applying threshold between 0 to 0.8 but the similarity score remains same. Why is that so? I want it to look like below
Table1 Table2
| Column A | Column B | Similarity Score |
| -------- | -------- | ---------------|
| Flower.com | Flower | 0.987 |
| Flower.com | snacks | 0 |
| Flower.com | food | 0.0 |
Is there another way to match the two strings in excel?
I have tried fuzzy lookup addin provided by Excel
答: 暂无答案
评论