Data Exploration and Cleaning Exercise

Photo by DATAIDEA

Don’t Miss Any Updates!

Before we continue, we have a humble request, to be among the first to hear about future updates of the course materials, simply enter your email below, follow us on (formally Twitter), or subscribe to our YouTube channel.

1. Load demo.xlsx dataset

# your solution

2. Rename the columns as suggested below

   Old name	New name
   Age	age
   Gender	gender
   Marital Status	marital_status
   Address	address
   Income	income
   Income Category	income_category
   Job Category	job_category

# your solution

3. Display all the columns in the dataset

# your solution

4. Display some basic statistics about the numeric variables in the dataset

# your solution

5. Display some basic statistics about the categorical variables in the dataset

# your solution

6. What are the unique observations under gender?

# your solution

7. Can you fix any problems observed under the gender, give brief explanations why and how

# your solution

8. How many observations have ‘no answer’ for marital status?

# your solution

9. Write some piece of code to return only numeric variables from the dataset

# your solution

10. Are there any missing values in the dataset?

# your solution

11. Are there any outliers in the income variable?

# your solution

12. Investigate the relationship between age and income

# your solution

13. How many people earn more than 300 units?

# your solution

14. What data type is the marital status?

# your solution

15. Create dummy variables for gender

# your solution

END

What’s on your mind? Put it in the comments!