Cof Sale

Coffee Sales


In [1]:
import os

In [17]:
opsale = open('/home/wcmckee/github/lcacoffee/salebyhour.json', 'r')

In [18]:
oprdz = opsale.read()

In [19]:
opsale.close()

In [22]:
#opstrp = oprdz.strip('\r')

In [ ]:


In [23]:
oprdz


Out[23]:
'[\r\n  {\r\n    "Day ($) incl. tax":"Sun",\r\n    "Date":" 11 Jan 2015",\r\n    "0":"- -",\r\n    "1":"- -",\r\n    "2":"- -",\r\n    "3":"- -",\r\n    "4":"- -",\r\n    "5":"- -",\r\n    "6":"- -",\r\n    "7":"- -",\r\n    "8":"- -",\r\n    "9":"- -",\r\n    "10":"- -",\r\n    "11":"- -",\r\n    "12":"4 (1)",\r\n    "13":"- -",\r\n    "14":"12 (30)",\r\n    "15":"0 (9)",\r\n    "16":"8 (9)",\r\n    "17":"0 (3)",\r\n    "18":"- -",\r\n    "19":"- -",\r\n    "20":"- -",\r\n    "21":"- -",\r\n    "22":"- -",\r\n    "23":"- -",\r\n    "FIELD27":""\r\n  },\r\n  {\r\n    "Day ($) incl. tax":"Mon",\r\n    "Date":" 12 Jan 2015",\r\n    "0":"- -",\r\n    "1":"- -",\r\n    "2":"- -",\r\n    "3":"- -",\r\n    "4":"- -",\r\n    "5":"- -",\r\n    "6":"- -",\r\n    "7":"8 (9)",\r\n    "8":"44 (123)",\r\n    "9":"40 (31)",\r\n    "10":"20 (118)",\r\n    "11":"4 (13)",\r\n    "12":"12 (34)",\r\n    "13":"8 (52)",\r\n    "14":"4 (33)",\r\n    "15":"12 (46)",\r\n    "16":"0 (1)",\r\n    "17":"- -",\r\n    "18":"- -",\r\n    "19":"- -",\r\n    "20":"- -",\r\n    "21":"- -",\r\n    "22":"- -",\r\n    "23":"- -",\r\n    "FIELD27":""\r\n  },\r\n  {\r\n    "Day ($) incl. tax":"Tue",\r\n    "Date":" 13 Jan 2015",\r\n    "0":"- -",\r\n    "1":"- -",\r\n    "2":"- -",\r\n    "3":"- -",\r\n    "4":"- -",\r\n    "5":"- -",\r\n    "6":"- -",\r\n    "7":"4 (17)",\r\n    "8":"24 (109)",\r\n    "9":"0 (23)",\r\n    "10":"32 (101)",\r\n    "11":"8 (25)",\r\n    "12":"16 (43)",\r\n    "13":"12 (55)",\r\n    "14":"12 (43)",\r\n    "15":"20 (100)",\r\n    "16":"4 (3)",\r\n    "17":"- -",\r\n    "18":"- -",\r\n    "19":"- -",\r\n    "20":"- -",\r\n    "21":"- -",\r\n    "22":"- -",\r\n    "23":"- -",\r\n    "FIELD27":""\r\n  },\r\n  {\r\n    "Day ($) incl. tax":"Wed",\r\n    "Date":" 14 Jan 2015",\r\n    "0":"- -",\r\n    "1":"- -",\r\n    "2":"- -",\r\n    "3":"- -",\r\n    "4":"- -",\r\n    "5":"- -",\r\n    "6":"- -",\r\n    "7":"4 (19)",\r\n    "8":"20 (132)",\r\n    "9":"8 (24)",\r\n    "10":"32 (133)",\r\n    "11":"12 (39)",\r\n    "12":"16 (36)",\r\n    "13":"56 (64)",\r\n    "14":"44 (38)",\r\n    "15":"52 (83)",\r\n    "16":"- -",\r\n    "17":"- -",\r\n    "18":"- -",\r\n    "19":"- -",\r\n    "20":"- -",\r\n    "21":"- -",\r\n    "22":"- -",\r\n    "23":"- -",\r\n    "FIELD27":""\r\n  },\r\n  {\r\n    "Day ($) incl. tax":"Thu",\r\n    "Date":" 15 Jan 2015",\r\n    "0":"- -",\r\n    "1":"- -",\r\n    "2":"- -",\r\n    "3":"- -",\r\n    "4":"- -",\r\n    "5":"- -",\r\n    "6":"- -",\r\n    "7":"8 (20)",\r\n    "8":"68 (115)",\r\n    "9":"20 (25)",\r\n    "10":"132 (136)",\r\n    "11":"40 (40)",\r\n    "12":"36 (50)",\r\n    "13":"52 (55)",\r\n    "14":"32 (49)",\r\n    "15":"72 (103)",\r\n    "16":"4 (6)",\r\n    "17":"- -",\r\n    "18":"- -",\r\n    "19":"- -",\r\n    "20":"- -",\r\n    "21":"- -",\r\n    "22":"- -",\r\n    "23":"- -",\r\n    "FIELD27":""\r\n  },\r\n  {\r\n    "Day ($) incl. tax":"Fri",\r\n    "Date":" 16 Jan 2015",\r\n    "0":"- -",\r\n    "1":"- -",\r\n    "2":"- -",\r\n    "3":"- -",\r\n    "4":"- -",\r\n    "5":"- -",\r\n    "6":"- -",\r\n    "7":"12 (21)",\r\n    "8":"104 (128)",\r\n    "9":"8 (15)",\r\n    "10":"112 (131)",\r\n    "11":"28 (41)",\r\n    "12":"40 (54)",\r\n    "13":"40 (76)",\r\n    "14":"28 (64)",\r\n    "15":"92 (102)",\r\n    "16":"- -",\r\n    "17":"- -",\r\n    "18":"- -",\r\n    "19":"- -",\r\n    "20":"- -",\r\n    "21":"- -",\r\n    "22":"- -",\r\n    "23":"- -",\r\n    "FIELD27":""\r\n  }\r\n]'

In [14]:


In [14]:


In [ ]: