3. Duplicate & Missing data

Dropping Duplicate data

tracks = billboard[["year", "artist", "track", "time"]] # Create the new DataFrame

print(tracks.info())

tracks_no_duplicates = tracks.drop_duplicates() # Drop the duplicates: tracks_no_duplicates

print(tracks_no_duplicates.info())

Filling Missing data

oz_mean = airquality.Ozone.mean() # Calculate the mean of the Ozone column

airquality['Ozone'] = airquality.Ozone.fillna(oz_mean) # Replace all the missing values in the Ozone column with the mean

print(airquality.info())