Data cleaning · Data Alchemy

Data cleaning

Hello guys I got an csv file consisting of name ,father name,address these columns and I want to take unique combination of name and father name I have tried phonetic algorithm like sound x but still their are many duplicate for example the name is rahul and father name is karan but their is another entry such as rahul and father name karanh so this is duplicate but due to spelling mistakes it is identified as unique, please provide any possible solution to this problem

11 comments