import pandas as pd

FILE = '2018 Q1Q2 - AHS CO2 (0800-1530).csv'

high_co2_rooms = []


def print_results():
    print("Now listing the %s rooms with average CO2 levels above 1000 ppm:\n" % len(high_co2_rooms))

    for room in high_co2_rooms:
        print(room[0] + '   -   ' + room[1])


try:
    df = pd.read_csv(FILE)

    df['Unnamed: 0'] = pd.to_datetime(df['Unnamed: 0'], format='%m/%d/%Y %H:%M')
    df = df[df['Unnamed: 0'].dt.weekday < 5]

    firstCol = True

    for series in df:
        series = df[series]
        if firstCol:
            firstCol = False
            continue

        if series.mean() > 1000:
            high_co2_rooms.append([series.name, str("%.2f ppm" % series.mean())])

    print_results()

except KeyboardInterrupt:
    print_results()

import pandas as pd

FILE = '2018 Q1Q2 - AHS Temperature.csv'

high_temp_rooms = []

df = pd.read_csv(FILE, skipfooter=3, engine='python')
df['Unnamed: 0'] = pd.to_datetime(df['Unnamed: 0'], format='%Y-%m-%d %H:%M:%S')

df = df[(df['Unnamed: 0'].dt.month == 6) & (df['Unnamed: 0'].dt.weekday < 5) & (df['Unnamed: 0'].dt.hour >= 8) & (
        df['Unnamed: 0'].dt.hour <= 15)]

avgTemps = df.mean()
avgTemps = avgTemps[avgTemps > 75]

print('There are ' + str(len(avgTemps)) + ' rooms with a temperature problem: \n\n')
print(avgTemps)

import pandas as pd

NIGHT_PATH_2016 = '2016 Q1Q4 - Electrical Nightly (2300-0400).csv'
PATH_2016 = '2016 Q1Q4 - Electrical(24 Hrs).csv'
NIGHT_PATH_2017 = '2017 Q1Q4 - Electrical Energy & Gas Nightly (2300 - 0400).csv'
PATH_2017 = '2017 Q1Q4 - Electrical Energy (24 hrs).csv'

MAIN_COL = 'HS Main (kWh)'
CC_COL = 'HS CC (kWh)'

PRICE_PER_KWH = 0.16

COLS_TO_USE = [MAIN_COL, CC_COL]


def read_csv(path):
    return pd.read_csv(path, skiprows=[0], skipfooter=3, engine='python', usecols=COLS_TO_USE)


def night_vs_day(year, elec_night, elec):
    print('In the year ' + str(year) + ', the Collins Center used:\nAbout ' + str(
        round(elec, 2)) + ' kWh of energy a day\nAbout ' + str(
        round(elec_night, 2)) + ' kWh of energy between 11:00PM and' + ' 4:00AM\nAbout ' + str(
        round(elec - elec_night, 2)) + ' more kWh of energy throughout the entire day than at night\n')


def year_result(big_year, big_val, small_year, small_val, night):
    if night:
        print('In the year ' + str(big_year) + ' the Collins Center used about ' + str(round(
            big_val - small_val, 2)) + ' kWh more energy at night than in the year ' + str(small_year))
    else:
        print('In the year ' + str(big_year) + ' the Collins Center used about ' + str(round(
            big_val - small_val, 2)) + ' kWh more energy throughout the day than in the year ' + str(small_year))


def year_vs_year(year1, elec_night1, elec1, year2, elec_night2, elec2):
    if elec1 > elec2:
        year_result(year1, elec1, year2, elec2, False)
    else:
        year_result(year2, elec2, year1, elec1, False)
    if elec_night1 > elec_night2:
        year_result(year1, elec1, year2, elec2, True)
    else:
        year_result(year2, elec2, year1, elec1, True)


def price_result(big_year, big_val, small_year, small_val, night):
    if night:
        print('In the year ' + str(big_year) + ' the Collins Center\'s energy cost about $' + str(
            round(big_val, 2)) + ', about $' + str(round(big_val - small_val, 2)) + ' more than in the year ' + str(
            small_year) + ', which cost about $' + str(round(small_val, 2)) + ', at night')
    else:
        print('In the year ' + str(big_year) + ' the Collins Center\'s energy cost about $' + str(
            round(big_val, 2)) + ', about $' + str(round(big_val - small_val, 2)) + ' more than in the year ' + str(
            small_year) + ', which cost about $' + str(round(small_val, 2)) + ', throughout the day')


def compare_price(year1, elec1, year2, elec2, night):
    if elec1 > elec2:
        price_result(year1, elec1, year2, elec2, night)
    else:
        price_result(year2, elec2, year1, elec1, night)


def part_of_main(year, elec, main):
    print('In the year ' + str(year) + ', the Collins Center used ' + str(
        round(elec, 2)) + ' kWh in total out of the ' + str(round(main, 2)) + ' kWh that the school used in total')


def percent_of_main(year, elec, main):
    percent = elec * 100 / main
    print(("In the year {0}, the Collins Center used ${1} of energy in total, {2}\u0025 of the total cost of " +
           "energy in AHS, ${3}").format(year, round(elec, 2), round(percent, 2), round(main, 2)))


##################2016##################
df_night_2016 = read_csv(NIGHT_PATH_2016)
df_2016 = read_csv(PATH_2016)

electricity_night_cc_2016 = df_night_2016[CC_COL].sum()
electricity_cc_2016 = df_2016[CC_COL].sum()

ahs_electricity_2016 = df_2016[MAIN_COL].sum()

night_price_cc_2016 = electricity_night_cc_2016 * PRICE_PER_KWH
price_cc_2016 = electricity_cc_2016 * PRICE_PER_KWH

price_ahs_2016 = ahs_electricity_2016 * PRICE_PER_KWH

##################2017##################
df_night_2017 = read_csv(NIGHT_PATH_2017)
df_2017 = read_csv(PATH_2017)

electricity_night_cc_2017 = df_night_2017[CC_COL].sum()
electricity_cc_2017 = df_2017[CC_COL].sum()

ahs_electricity_2017 = df_2017[MAIN_COL].sum()

night_price_cc_2017 = electricity_night_cc_2017 * PRICE_PER_KWH
price_cc_2017 = electricity_cc_2017 * PRICE_PER_KWH

price_ahs_2017 = ahs_electricity_2017 * PRICE_PER_KWH

##################RESULTS##################
night_vs_day(2016, electricity_night_cc_2016, electricity_cc_2016)
night_vs_day(2017, electricity_night_cc_2017, electricity_cc_2017)

year_vs_year(2016, electricity_night_cc_2016, electricity_cc_2016, 2017, electricity_night_cc_2017, electricity_cc_2017)

print('\n')

compare_price(2016, night_price_cc_2016, 2017, night_price_cc_2017, True)
compare_price(2016, price_cc_2016, 2017, price_cc_2017, False)

print('\n')

part_of_main(2016, electricity_cc_2017, ahs_electricity_2017)

print('\n')

percent_of_main(2016, price_cc_2016, price_ahs_2016)
percent_of_main(2017, price_cc_2017, price_ahs_2017)