Data Cleaning

- 작성자: radhikatandon
Data Cleaning
Data Cleaning

In the project sample, the data in the base file "UncleanData.xlsx" needed to be cleaned. The data was unclean on 3 fronts 1) The rows were present together for each area but the area name was mentioned only once. It needed to be replicated 2) The Street name contained special characters that needed to weeded out along with proper case correction. 3) The comments contained HTML entities making them unreadable I cleaned the data using basic excel skills such as formulas, as well as, VB functions to clean special characters and HTML entities

image of username radhikatandon Flag of India Ghaziabad, India

내 소개

I am a data entry professional with excellent skills on Microsoft Excel, Word, Powerpoint and also with Google equivalents of these. In addition to this, I am an avid consumer of web content and like to browse and research web for various things. One of the areas of interests that I carry is to use web for researching information on consumer goods in order to compare them. Can write well researched articles. Complex web scraping work, and converting scanned text images to Word documents, are also among things that I can do with confidence. Please check my portfolio. I like producing quality work and possess excellent attention to details. I learn fast and like to work and re-work until my customers are happy with the results. I have good written and spoken English and cleared IELTS exams with overall band score of 6.5 (Listening : 6.0, Reading : 5.5, Writing : 6.5 and Speaking : 7.5) I look forward to speaking with you to understand your data entry and web research requirements.

$10 USD/시간

신규 프리랜서!

태그