Analyze some Data

1. Title : Data Cleansing and 1. This project scope is to match locations to the appropriate coordinates for the country of India. 2. We have a locations csv file with all the coordinates for the country of India extracted from [login to view URL] 3. Problems with the Location file a. The quality of latitude and longitude is not consistent ranging from 2 digits to 7 digits b. One location can be found with multiple GeoNames Outcome 1. We want the location file to have no duplicates (There might be locations with similar name but in different regions. We intend to capture all of these locations details). 2. Every location needs to be verified against google maps or another trusted third party for each geoname entry in the locations file. 3. We want a final locations file that is consistent and verified. We have the attached the locations file in CSV format