Blog

20
Sep

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 info@datacleaningservices.com.

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin

Add a comment