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:
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).
4. Link to SJC¶
Refine your search in the last question to only show the URL to SJC’s website.
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.