In [4]:
import numpy as np
import pandas as pd

In [2]:
# JSON

import json
from pprint import pprint

with open('') as data_file:
    data = json.load(data_file)
    
pprint(data)


---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-2-ac019862888e> in <module>()
      2 from pprint import pprint
      3 
----> 4 with open('') as data_file:
      5     data = json.load(data_file)
      6 

FileNotFoundError: [Errno 2] No such file or directory: ''

In [13]:
# Utilities CSV

data = pd.read_csv('C:/Users/rafael/Documents/drive-download-20161125T183443Z/Keila_utilities_comma.csv')
data


Out[13]:
Date DomesticWater_m3 WarmTapWater_m3 DistrictHeating_kWh Electricity_of_cooling_machines_kWh Total_Electricity_kWh
0 1.10.2016 0:00 0.00 0.00 120.0 78.0 285.0
1 1.10.2016 1:00 0.00 0.00 130.0 78.0 279.0
2 1.10.2016 2:00 0.00 0.00 130.0 78.0 282.0
3 1.10.2016 3:00 0.00 0.00 150.0 78.0 282.0
4 1.10.2016 4:00 0.00 0.00 160.0 81.0 281.0
5 1.10.2016 5:00 0.00 0.00 160.0 78.0 283.0
6 1.10.2016 6:00 0.00 0.00 160.0 78.0 283.0
7 1.10.2016 7:00 0.00 0.00 180.0 78.0 300.0
8 1.10.2016 8:00 0.01 0.01 260.0 81.0 339.0
9 1.10.2016 9:00 0.02 0.02 240.0 78.0 349.0
10 1.10.2016 10:00 0.01 0.01 230.0 78.0 346.0
11 1.10.2016 11:00 0.01 0.01 210.0 81.0 340.0
12 1.10.2016 12:00 0.00 0.00 200.0 78.0 340.0
13 1.10.2016 13:00 0.01 0.01 190.0 78.0 342.0
14 1.10.2016 14:00 0.00 0.00 170.0 78.0 343.0
15 1.10.2016 15:00 0.01 0.01 170.0 81.0 343.0
16 1.10.2016 16:00 0.00 0.00 150.0 78.0 332.0
17 1.10.2016 17:00 0.00 0.00 140.0 78.0 319.0
18 1.10.2016 18:00 0.00 0.00 120.0 78.0 292.0
19 1.10.2016 19:00 0.00 0.00 180.0 81.0 290.0
20 1.10.2016 20:00 0.00 0.00 190.0 78.0 290.0
21 1.10.2016 21:00 0.00 0.00 200.0 78.0 293.0
22 1.10.2016 22:00 0.00 0.00 210.0 78.0 290.0
23 1.10.2016 23:00 0.00 0.00 210.0 75.0 291.0
24 2.10.2016 0:00 0.00 0.00 210.0 78.0 286.0
25 2.10.2016 1:00 0.00 0.00 220.0 78.0 279.0
26 2.10.2016 2:00 0.00 0.00 220.0 81.0 280.0
27 2.10.2016 3:00 0.00 0.00 230.0 78.0 281.0
28 2.10.2016 4:00 0.00 0.00 260.0 78.0 281.0
29 2.10.2016 5:00 0.00 0.00 260.0 78.0 282.0
... ... ... ... ... ... ...
1269 22.11.2016 20:00 0.02 0.02 350.0 0.0 355.0
1270 22.11.2016 21:00 0.00 0.00 280.0 3.0 330.0
1271 22.11.2016 22:00 0.00 0.00 340.0 0.0 286.0
1272 22.11.2016 23:00 0.00 0.00 310.0 0.0 282.0
1273 23.11.2016 0:00 0.00 0.00 340.0 0.0 282.0
1274 23.11.2016 1:00 0.00 0.00 330.0 0.0 280.0
1275 23.11.2016 2:00 0.00 0.00 330.0 0.0 278.0
1276 23.11.2016 3:00 0.00 0.00 330.0 0.0 279.0
1277 23.11.2016 4:00 0.00 0.00 320.0 3.0 277.0
1278 23.11.2016 5:00 0.00 0.00 370.0 0.0 289.0
1279 23.11.2016 6:00 0.08 0.08 450.0 0.0 369.0
1280 23.11.2016 7:00 0.06 0.06 510.0 0.0 460.0
1281 23.11.2016 8:00 0.69 0.69 550.0 0.0 505.0
1282 23.11.2016 9:00 0.15 0.15 600.0 0.0 550.0
1283 23.11.2016 10:00 0.47 0.47 600.0 0.0 616.0
1284 23.11.2016 11:00 0.27 0.27 610.0 0.0 601.0
1285 23.11.2016 12:00 0.24 0.24 570.0 3.0 610.0
1286 23.11.2016 13:00 0.29 0.29 560.0 0.0 644.0
1287 23.11.2016 14:00 1.41 1.41 650.0 0.0 621.0
1288 23.11.2016 15:00 1.15 1.15 690.0 0.0 591.0
1289 23.11.2016 16:00 0.13 0.13 620.0 0.0 568.0
1290 23.11.2016 17:00 0.05 0.05 570.0 0.0 497.0
1291 23.11.2016 18:00 0.01 0.01 450.0 0.0 426.0
1292 23.11.2016 19:00 0.01 0.01 420.0 0.0 387.0
1293 23.11.2016 20:00 0.00 0.00 300.0 3.0 354.0
1294 23.11.2016 21:00 0.00 0.00 300.0 0.0 333.0
1295 23.11.2016 22:00 0.00 0.00 310.0 0.0 301.0
1296 23.11.2016 23:00 0.00 0.00 300.0 0.0 293.0
1297 24.11.2016 0:00 0.00 0.00 310.0 0.0 285.0
1298 NaN NaN NaN NaN NaN NaN

1299 rows × 6 columns


In [14]:
# 1 prompt: arrange meeting?
# 2 meeting time
# 3 number of people
# 4 before the meeting time automatic reminder to all participants to confirm their presence
# 5 if less than original number of people then an alternate meeting room be suggested 



# Preassign a room based on reservation (at the time the reservation is done).
# features of the room: room number, max occupancy
# features of occupants: names

list_of_attendents = ['A', 'B', 'C', 'D', 'E', 'F', 'G']
room = {'1':15, '2':8, '3':4}
time = 12.00

#  "Send push notification to participants" (first message sent immediately, second sent one hour earlier)
#  Notification is public
def notification(time, list_of_attendents):
    #So the attendands in the list_of_attendents should be a class, that has a variable int occupiedRoom, and it this case you should go through them in a loop and compare that they are in the room time and return a new list of those.    return list_of_actual_attendees

# "If not identified participants, sends a request to the organizer (host) to ask about the number of attending participants" 
# 20-min prior to start of the reservation, checks the amount of participants and their location.


# Assigns a new room that optimizes the room size,


# distance of participants from the room,


# and expected energy consumption.


# Send push notification of the reserved room to the participants/host.


  File "<ipython-input-14-c6035b38576a>", line 19
    def notification(time, list_of_attendents)
                                              ^
SyntaxError: invalid syntax

In [ ]: