Python Match 2 data frames by name where one is full name and other first name initial and last name

Question

I'm trying to merge 2 dataframes by name where one column is name + last name and the other only first name initial + last name.

Example:

df1:

    name
John Doe

df2:

  name
J. Doe

you can use `fuzzywuzzy` and use his fucntion : https://stackoverflow.com/a/56315491/18938956 — DataSciRookie, May 02 '22 at 08:44

score 1 · Accepted Answer · answered May 02 '22 at 08:44

You can use a regex to change the format of df1['name'] and feed this to merge:

df1.merge(df2,
          left_on=df1['name'].str.replace(r'^(.)\w+', r'\1.', regex=True),
          right_on='name'
         )

NB. check the documentation of merge for more parameters to format the output, in particular suffixes to customize the column names.

output:

     name    name_x  name_y
0  J. Doe  John Doe  J. Doe

example input:

df1 = pd.DataFrame({'name': ['John Doe']})
df2 = pd.DataFrame({'name': ['J. Doe']})

Thanks! That helped. I was trying to do this for the last couple of days. The expected output was J. Doe. — Omar B, May 02 '22 at 08:59

1 Answers1