task_six_co2.py

import pandas as pd
import xlrd

report_table = pd.read_csv("week_1_output.csv") #this would normally be reading an excel file, but this is just for testing purposes
fields = ['Room #', 'Highest Problematic CO2', 'Lowest Problematic CO2', 'Mean Problematic CO2', 'Median Problematic CO2']

for room in report_table.index:
    for i in range(0, len(fields)):
        print(fields[i] + ": " + str(report_table[fields[i]][room]))