1. Learn
    2. /
  2. Courses
    3. /
  3. Cleaning Data in Python

Exercise

Finding consistency

In this exercise and throughout this chapter, you'll be working with the airlines DataFrame which contains survey responses on the San Francisco Airport from airline customers.

The DataFrame contains flight metadata such as the airline, the destination, waiting times as well as answers to key questions regarding cleanliness, safety, and satisfaction. Another DataFrame named categories was created, containing all correct possible values for the survey columns.

In this exercise, you will use both of these DataFrames to find survey answers with inconsistent values, and drop them, effectively performing an outer and inner join on both these DataFrames as seen in the video exercise. The pandas package has been imported as pd, and the airlines and categories DataFrames are in your environment.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Print the categories DataFrame and take a close look at all possible correct categories of the survey columns.
  • Print the unique values of the survey columns in airlines using the .unique() method.