Samar and I got back and started to work on the .CSV files that Mr. Navkal sent us and the one at the library.
Our Goal was to:
import pandas as pd # 2016 EnergyUsage2016 = pd.read_csv("2016 Q1Q4 - Electrical.csv") print("2016") sumOfEnergyUsage2016 = EnergyUsage2016.sum() print(sumOfEnergyUsage2016) print() print() HS2016kWh = EnergyUsage2016['HS Main (kWh)'].sum() + EnergyUsage2016['HS DHB Plugload (kWh)'].sum() + \ EnergyUsage2016['HS DL Lighting (kWh)'].sum() + EnergyUsage2016['HS-Kitchen Emergency (kWh)'].sum() + \ EnergyUsage2016['HS DG Gym (kWh)'].sum() + EnergyUsage2016['HS M1 Chillers (kWh)'].sum() + \ EnergyUsage2016['HS CC (kWh)'].sum() CollinsCenter2016 = EnergyUsage2016['HS CC (kWh)'].sum() PercentUsage2016 = CollinsCenter2016/HS2016kWh * 100 print("Energy used in 2016 by AHS was " + str(HS2016kWh) + " kWh.") print("Energy used in 2016 by the Collins center was " + str(CollinsCenter2016) + " kWh.") print("The Collins Center contributed " + str(PercentUsage2016) + "% of AHS's total energy consumption in 2016.") print() print() print() print() # 2017 EnergyUsage2017 = pd.read_csv("2017 Q1Q4 - Electrical Energy Daily.csv") print("2017") sumOfEnergyUsage2017 = EnergyUsage2017.sum() print(sumOfEnergyUsage2017) print() print() HS2017kWh = EnergyUsage2017['HS Main (kWh)'].sum() + EnergyUsage2017['HS DHB Plugload (kWh)'].sum() + \ EnergyUsage2017['HS DL Lighting (kWh)'].sum() + EnergyUsage2017['HS-Kitchen Emergency (kWh)'].sum() + \ EnergyUsage2017['HS DG Gym (kWh)'].sum() + EnergyUsage2017['HS PBA AHU1- 4 (KWh)'].sum() + \ EnergyUsage2017['HS M1 Chillers (kWh)'].sum() + EnergyUsage2017['HS CC (kWh)'].sum() + \ EnergyUsage2017['HS Gas (100 Cu Ft)'].sum() * 29 CollinsCenter2017 = EnergyUsage2017['HS CC (kWh)'].sum() PercentUsage2017 = CollinsCenter2017/HS2017kWh * 100 print("The amount of energy used in 2017 by AHS was " + str(HS2017kWh) + " kWh.") print("The amount of energy used in 2017 by the Collins center was " + str(CollinsCenter2017) + " kWh.") print("The Collins Center contributed " + str(float(PercentUsage2017)) + "% of AHS's total energy consumption in 2017.") This was the output /Users/ayushzenith/PycharmProjects/Energize1/venv/bin/python /Users/ayushzenith/PycharmProjects/Energize1/venv/playground.py 2016 HS Main (kWh) 1705498.00 HS DL Lighting (kWh) 425014.40 HS-Kitchen Emergency (kWh) 384582.40 HS DHB Plugload (kWh) 146111.61 HS DG Gym (kWh) 377604.80 HS M1 Chillers (kWh) 37243.27 HS CC (kWh) 309461.50 dtype: float64 Energy used in 2016 by AHS was 3385515.98 kWh. Energy used in 2016 by the Collins center was 309461.5 kWh. The Collins Center contributed 9.14074846576267% of AHS's total energy consumption in 2016. 2017 HS Main (kWh) 1573257.000 HS DHB Plugload (kWh) 142503.700 HS DL Lighting (kWh) 382167.700 HS-Kitchen Emergency (kWh) 387982.600 HS DG Gym (kWh) 343008.500 HS PBA AHU1- 4 (KWh) 10360.216 HS M1 Chillers (kWh) 36628.880 HS CC (kWh) 276071.900 HS Gas (100 Cu Ft) 7546.000 dtype: float64 The amount of energy used in 2017 by AHS was 3370814.496 kWh. The amount of energy used in 2017 by the Collins center was 276071.9 kWh. The Collins Center contributed 8.190065051862174% of AHS's total energy consumption in 2017. Process finished with exit code 0
0 Comments
Leave a Reply. |
AuthorHi! My name is Ayush Zenith! I am currently a senior at Andover High School. I have been part of the Energize Andover Program since June, 2017 (8th grade). I have since been working on improving my knowledge in programming and working on writing better applications in order to save and conserve resources in buildings... Archives
November 2020
Categories |