How to Load and Manipulate Astronauts CSV Data in Python Pandas

Watch the first video, the trailer to Apollo 11. (The second longer video is optional.) It’s awe inspiring. Also notice the gleam in Buzz Aldrin’s eyes, humble but confident.

Pandas stands for “Python Data Analysis Library ”. According to the Wikipedia page, pandas is a software library written for the python programming language for data manipulation and analysis. In particular, it offers data structures and operations for manipulating numerical tables and time series. It is free software released under the three-clause BSD license. The name is derived from the term “panel data”, an econometrics term for data sets that include observations over multiple time periods for the same individuals.

In tutorial we will load the “astronauts.csv” into Pandas in Google Colab and perform some data filtering and sorting. Goto Colab, create a new note book and give it a name:

Google Colab Google Colab

Copy and paste these 4 lines of python code into the first cell of your Colab notebook Make sure that you have the exact linebreak as seen below. Now delete and retype the two " " of line 2url = . This is because if you keep the original " formatting it will give you error. Execute and run.

import pandas as pd
url = “"
df = pd.read_csv(url)

Google Colab

What these statements say is that import the python pandas library into our notebook with an abbreviation pd. The second line assigns to the variable url the string containing the link the excel file astronauts.csv . The third line uses pandas (pd) to read the astronauts.csv data into a df (data frame) so we can manipulate the data. The fourth line check to see if everything works correctly. df.head() by default will display the first five rows in the data frame. Notice that the indexing starts with row 0. Btw check out Buzz Aldrin. He went to MIT 😃!

Again make sure you delete and retype the two " " in line 2 url = … Otherwise the original formatting will give you an error like this:

Google Colab

Once you load the data into your notebook with pandas you can sort and filter the date like Microsoft Excel or Google Sheet and a lot more. Think of pandas as Excel or Sheet on steroid!

For this lab:

  1. Watch the 3 videos I posted in Canvas starting with “1 - Pandas Intro”.
  2. Repeate all of the step in the 3 videos except for the first step in the first cell. We just did that here. You can also skip the next two steps about using delimiter or typing df to get the whole thing. This is because these two steps are redundant.
  3. What college did “John H. Glenn Jr. " go to? What is his home town? Use python pandas to filter and select “Name”.
  4. According to this database, how many astronauts is “Retired”? Use python pandas to filter and count “Retired”.
  5. Answer the math question (2 points) below. Include your calculation in your Colab notebook.
  6. Create a shareable link to your notebook. Make sure it is public, and submit that link to Canvas.

Math question (2 points): If the Apollo 11 has a speed of 25,000 mph (miles per hour) how long does it take to get to the Moon. Give your answer in day and hour format. Show your calculation in your Colab notebook.

Google Colab

Make sure to save your notebook regularly. Here is an example of the next two steps you should have in your notebook. Notice I used Canva to draw the arrow and text:

Google Colab