Before you turn this problem in, make sure everything runs as expected. First, restart the kernel (in the menubar, select Kernel$\rightarrow$Restart) and then run all cells (in the menubar, select Cell$\rightarrow$Run All).

Make sure you fill in any place that says YOUR CODE HERE or "YOUR ANSWER HERE", as well as your name and collaborators below:

In [ ]:
NAME = ""
COLLABORATORS = ""
In [ ]:
import os
import os.path
import pandas as pd

datadir = "publicdata"
In [ ]:
babybyname = pd.read_csv(os.path.join(datadir, "babybyyear.csv"))
female1 = pd.read_csv(os.path.join(datadir, "female1.csv"))
male1 = pd.read_csv(os.path.join(datadir, "male1.csv"))
temps = pd.read_csv(os.path.join(datadir, "madison_temp.csv"))
temps2 = pd.read_csv(os.path.join(datadir, "temps2.csv"))
In [ ]:
column_labels = ['I', 'J', '1', '2', '3']
row_labels = ['A', 'B', 'C']
dataset = [[ 'A.I', 'A.J', 'A.1', 'A.2', 'A.3' ],
           [ 'B.I', 'B.J', 'B.1', 'B.2', 'B.3' ],
           [ 'C.I', 'C.J', 'C.1', 'C.2', 'C.3' ]]
example2 = pd.DataFrame(dataset, columns=column_labels, index=row_labels)
example1 = example2.drop('J', axis=1)
In [ ]:
temps2
In [ ]:
example1
In [ ]:
example1.T
In [ ]:
example1.T.T
In [ ]:
example1.index = ['A', 'B', 'C']
example1
In [ ]: