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 [ ]:
Content source: wcmckee/lcacoffee
Similar notebooks: