This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Both @T_Willins' and @jrgo's solutions are good, but you might want to re-think how you're defining the ID. In your specific case, what if Danielle Warner and Robert Ponting join the list. A better key in this case would be to concatenate the entire first and names.
Another point to consider is nicknames. If Drew Flintoff joins, is this the same person as Andrew Flintoff? To handle these cases you might want to consider normalizing the first names using a nickname list like
Replace the nick name in your input with the formal name
In any case because of the enormous duplication in first and last names, i.e. Ahmad Khan, John Jones, Wang Zhang Wei, basing an unique ID on someone's name leads to an enormous effort to weed out false positive and negative matches. Try to include another metric(age, address, etc) if you have it.