"Name" column comparison

  dataframe, pandas, python

For example, I have a dataframe, called df_1, and one of the columns are "Name". For example, I want to compare my first dataframe with the second dataframe, called df_2, which also has "Name" column. But there is one problem that I encounter. For example, one of the entries in the df_1, is "Jessica Hillary Smith", but on df_2, the entry would be "Jessica Hillary". I know they are the same person, but I can’t extract the data from df_1 if the name on df_1 is not the same as the name on df_2, while I know they are the same person. What should I do? (Imagine there are tons of data that is similar to that, not only one entry that has this problem)

Source: Python Questions

LEAVE A COMMENT