Lab: Managing Data#

In this lab you’ll practice manipulating data in table form using Pandas.

Part 1: Airport Data#

There are so many datasets to choose from! In this part you’ll use an open source dataset that tracks all the airports (large and small) and helicopter pads in the world. Run the next cell to download the dataset into your Labs directory:

[ ]:
!wget https://davidmegginson.github.io/ourairports-data/airports.csv

1. Load airports.csv#

The last cell downloaded a file called airports.csv. Load it into a DataFrame and display the data.

[ ]:

2. US Airports#

Filter and show only the airports in the United States.

[ ]:

3. Look for SJC#

Filter and show only the row for Norman Y. Mineta San Jose International Airport (SJC).

[ ]:

5. Find the Lowest Elevation of Any Airport#

[ ]:

6. Lowest Airport#

Use the expression in the last question to show all data on the lowest airport.

[ ]:

7. Median Elevation#

Calculate the median elevation of all airports.

[ ]:

8. Plot a Histogram#

Plot a histogram of all of the airport elevations.

[ ]: