In the above function, I used .rename method to rename the lng column to lon. In the original, dirty function, a new column was created… — In the above function, I used .rename method to rename the lng column to lon. In the original, dirty function, a new column was created and the old one was dropped which was unnecessary. Comprehension and knowledge application is more important to me now than ever before. …

How to deal with possible duplicate entries in your data set? How to work around the problem of duplicates using SQL? Let me guide you… — How to deal with possible duplicate entries in your data set? How to work around the problem of duplicates using SQL? Let me guide you through some of the techniques I have been using as a Data Analyst to identify, avoid and remove duplicates from any type of data set.