Data Clean Up and Entry of an existing database of Indian adresses

1. Expected freelancers of Indian origin only, who have a decent knowledge of the cities in India.\r\n2. We have a database with contact information of certain people, stored in the Address column.\r\n3. In the address column: each row has the Street, City and PIN code information for every unique identity. We expect:\r\n a) Street, City and PIN to be entered in separate columns.\r\n b) The PIN is missing in a number of cases. Look up the correct PIN code, with the help of the mentioned locality, city and enter it in the corresponding column.\r\n c) In a few cases the address is incomplete. Mark them so.\r\n d) Correct the spelling mistakes for locality (if need be) and city names. \r\n\r\nPlease find a sample in the attached file.