Solution 12.1

Perform the following steps to complete the activity:

1. For this activity, you will need the pandas and numpy libraries. Load them in the first cell of the notebook:

   import pandas as pd
   import numpy as np

2. Read in the household_power_consumption.csv data from the Datasets directory and list the first few rows:

   data_fn = 'household_power_consumption.csv'
   household_electricity = \
       pd.read_csv('../datasets/' + data_fn, 
       sep = ';',
       low_memory = False)
   household_electricity.head()

This generates the following:

Figure 15.62 – The household_power_consumption.csv data

3. You should inspect the data types of the columns and further investigate whether there are non-numeric values. If so, correct them by converting them to NA values and then filling them by interpolation:

   Household_electricity.dtypes

This generates the following...