Project Title: Cleaning and Standardization of Database
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 firstname.lastname@example.org.
Add a comment