Python Name lookup

kohiladevi31

kohiladevi31

Posted on November 11, 2019

Python Name lookup

I have firstname,lastname,Middlename,fullname in a dataframe. I have a list of 500 titles like MR,MR.,DDS,D.d.d,MD,m.d., So I have to identify whether these titles are present in firstname or last name and full name, if they are, I have to drop it. Please help me with this.Thanks

Full_name First_Name Middle_name Last_Name
Ramesh DDS., kumar, Ramesh kumar DDS.
Suresh DDS, Kumar, G Suresh G Kumar DDS
Anjali DDS, devi, Anjali devi DDS
Aruna DDS, Kumari, G. Aruna G. Kumari DDS
Christin DDS, Selva, G. Christin G. Christin DDS
Rathana DDS, Kumari, Rathana Kumari DDS
JOhn DDS, peter, R JOHN C DDS R Kumar DDS
Raj DDS, Kumar, Raj Jothi DDS
Siva DDS, Jothi, Siva Nathan DDS
Senthil DDS, Nathan, Senthi dev DDS
Prasath DDS, dev, Prasath Kumar DDS
anil, Kumar C DDS, Anil Kumar
varun DDS, Dhavan S, varun Dhavan DDS
Vinoth, Kanna C DDS, Vinoth Kanna
DDS joshi, mani H, Joshi DDS Mani
DDS kamal, kanna H, Kamal DDS Kanna

💖 💪 🙅 🚩
kohiladevi31
kohiladevi31

Posted on November 11, 2019

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

Python Name lookup
lookupforstringinpandas Python Name lookup

November 11, 2019