Instructions

In this compulsory task, you will need the following libraries:

fuzzywuzzy

chardet

Within this task folder, you will find a Jupyter Notebook named

data$\_$cleaning$\_$example.jpynb$.$ Work through this notebook before moving on to

the compulsory task.

Compulsory Task $1$

In this compulsory task, you will clean the country column and parse the

"date$\_$measured" column in the store$\_$income$\_$data$\_$task.csv file. Use the examples

given in data$\_$cleaning$\_$example.ipynb to guide you.

Complete the following in store$\_$income$\_$task.ipynb:

Load store$\_$income$\_$data$\_$task.csv$.$

Take a look at all the unique values in the "country" column. Then, convert

the column entries to lowercase and remove any trailing white spaces.

Clean up the "country" column so that there are three distinct countries.

Create a new column called in the DataFrame that is a copy of

the "date$\_$measured" column but instead shows a number that represents

the number of days ago that it was measured. Note that the current date

can be obtained using datetime.date.today$().$