实证匹配技巧：公司名称中英文对照匹配案例

一、案例背景

- 根据已知的公司名称中英文对照表，与符合条件的公司中英文名称匹配



- 36分钟讲解视频


二、部分code

```Python

import pandas as pd

import numpy as np

import warnings

warnings.filterwarnings("ignore")

f_name = pd.read_stata("f_name.dta")

p_name = pd.read_stata("p_name.dta")

t_name = pd.read_stata("tax_name.dta")

p_name = p_name.replace({'':np.nan}).dropna()

match1 = pd.merge(left=f_name, right=p_name,

                 left_on="n_f", right_on="n_p",

                 how="right")

match1.dropna()

f_name["f_ori"] = f_name["n_f"]

p_name["p_ori"] = p_name["n_p"]

f_name["n_f"] = f_name["n_f"].str.lower()

p_name["n_p"] = p_name["n_p"].str.lower()

del_str = ["co", "corporation", "corp",

          "imp", "import",

          "exp", "export",

          "trading", "trade",

          "&", "and",

          "ltd",

          "'", "\"", ".", ",", "/", "-", " "]

for i in del_str:

   f_name["n_f"] = f_name["n_f"].str.replace(i, "")

   p_name["n_p"] = p_name["n_p"].str.replace(i, "")

……

```