10. Data Analytics with pandas and NumPy

Activity 24: Data Analysis to Find the Outliers in Pay versus the Salary Report in the UK Statistics Dataset

Solution

1. You begin with a new Jupyter Notebook.
2. Copy the UK Statistics dataset file into a specific folder where you will be performing this activity.
3. Import the necessary data visualization packages, which include pandas as pds, matplotlib as plt, and seaborn as sns:

   import pandas as pd
   import matplotlib.pyplot as plt
   %matplotlib inline
   import seaborn as sns
   # Set up seaborn dark grid
   sns.set()

4. Choose a variable to store DataFrame and place the UKStatistics.csv file within the folder of your Jupyter Notebook. In this case, it would be as follows:

   statistics_df = pd.read_csv('UKStatistics.csv')

5. Now, to display the dataset, we will be calling the statistics_df variable, and .head() will show us the output of the entire dataset:

   statistics_df.head()

   The output will be as follows:

   Figure 10.54: Dataset output...