Solution 14.1

Perform the following steps to complete the activity:

1. Open a new Jupyter notebook file. Import pandas and dateutil.parser into your notebook:

   import pandas as pd
   from dateutil.parser import parse

2. Define the path for the dataset and read the data:

   # Defining the paths of the files
   filePath = '/content/drive/MyDrive/Packt_Colab/pandas_chapter11/chapter11/AirQualityUCI.csv'
   # Reading the text files
   data = pd.read_csv(filePath,delimiter=";")
   data.head()

You should get the following output:

Figure 15.81 – Placeholder

3. Drop the unwanted columns, as follows:

   data = data.drop(['Unnamed: 15','Unnamed: 16'],axis=1)
   data.head()

You should get an output as follows:

Figure 15.82 – Placeholder

data.shape

You should get the following output:

(9471, 15)

4. Remove the NA values:

   data = data.dropna()
   data.shape

You should get the following...