Cleaning and Standardization of Database

Post By admin

Project Title: Cleaning and Standardization of Database

Project Description:
We have an Excel sheet full of information. The problem is, the information is not uniform.
There are lots of mistakes in the sheet that have to be fixed:

* There are different ways in which countries and cities appear.
i.e.: Venezuela was introduced as Vzla, Ven, Vz, etc,
We need this to be uniform

* Telephone numbers may or may not include their area code. Once again, we need this to be uniform.

* Data such as birthdays are located in the wrong column.

Would you be able yo help us out? Please reply!

For similar work requirements feel free to email us on

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin

Add a comment