playerid_lookup("tatis", "fernando", fuzzy=True) returns duplicate rows for Fernando Tatis

[dhmistry3]

The chadwick name for tatis and his father are the same, so when doing the merge it ends up duplicating the rows for both, so ends up with a couple duplicate rows.

[mhmills]

Note that this issue only occurs when fuzzy=True and the name searched is not an exact match. Like you said, it looks like this is an issue with the merge in get_closest_names(), which is called in search() when there are 0 exact matches and fuzzy is True. There are no exact matches for your search because it is Tatís (with the accented í) and not Tatis, which is what you searched. The same bug appears if you were to search "Valdimi Guerrero" with fuzzy=True, which would result in duplicate rows for Vladimir Guerrero Jr and Sr. However if you search playerid_lookup("tatís", "fernando", fuzzy=True), you would get the expected result.