I am trying to merge two data set by their unique string variables. However, these two datasets do not share the same format for their string value.
For example,
Data set 1:
Year | CEO NAME | FIRM NAME |
1995 | Jonny Dan | AAA Company |
1995 | Tommy Z | BBB Company |
1995 | Jacky Young | Ccc Company |
1995 | Bill Morgan | ddd Company |
Data set 2:
Year | CEO NAME | FIRM NAME |
1995 | Jonh Daniel | AAA |
1995 | Tom Zeus | BBB Firm |
1995 | JACKY YOUNG | Ccc Corporation |
1995 | William Morgan | DDD Company |
So if I want to merge these two data set by CEO name and Firm name. How should I write the code?
Thanks in advance
0 Response to Regarding use Matchit to fuzzy merge two different data set
Post a Comment