I am trying to merge data from two separate footballing websites together. In both databases, each datapoint is a football player and certain stats about them. However, the IDs used to identify a specific player is not the same in the two databases. I have thought of linking them by their name of course, but there are a lot of players who don't have the exact same name in both databases.
Currently, my best attempt is to use a birthdate-variable along with something like last name or nationality to do the merge by. However, I was wondering if anyone has any smart method for a situation like this with two databases with several shared variables (name, birthdate, club, height, preferred_foot) but small discrepancies in how they are measured / recorded for some players.
I can provide examples of variables and how they differ it that is needed.