Examining the dataset
Throughout this course, you'll be analyzing a dataset of traffic stops in Rhode Island that was collected by the Stanford Open Policing Project.
Before beginning your analysis, it's important that you familiarize yourself with the dataset. In this exercise, you'll read the dataset into pandas, examine the first few rows, and then count the number of missing values.
This exercise is part of the course
Analyzing Police Activity with pandas
Exercise instructions
- Import
pandas
using the aliaspd
. - Read the file
police.csv
into a DataFrame namedri
. - Examine the first 5 rows of the DataFrame (known as the "head").
- Count the number of missing values in each column: Use
.isnull()
to check which DataFrame elements are missing, and then take the.sum()
to count the number ofTrue
values in each column.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import the pandas library as pd
import ____ as ____
# Read 'police.csv' into a DataFrame named ri
ri = pd.____(____)
# Examine the head of the DataFrame
print(ri.____)
# Count the number of missing values in each column
print(ri.isnull().____)