def get_offices(): serviceID = bottle.request.query.serviceid data_table = petl.fromcsv(DATA_FILE) if serviceID: data = petl.facet(data_table, 'ServiceID')[serviceID] data = [item[2:] for item in data] headers = data.pop(0) return json.dumps({"headers": headers, "data": data}) return
look(table3) # facet table1 = [['foo', 'bar', 'baz'], ['a', 4, 9.3], ['a', 2, 88.2], ['b', 1, 23.3], ['c', 8, 42.0], ['d', 7, 100.9], ['c', 2]] from petl import facet, look look(table1) foo = facet(table1, 'foo') foo.keys() look(foo['a']) look(foo['c']) # selectre table1 = (('foo', 'bar', 'baz'), ('aa', 4, 9.3), ('aaa', 2, 88.2), ('b', 1, 23.3), ('ccc', 8, 42.0), ('bb', 7, 100.9), ('c', 2))
table1 = [['foo', 'bar', 'baz'], ['aa', 4, 9.3], ['aaa', 2, 88.2], ['b', 1, 23.3], ['ccc', 8, 42.0], ['bb', 7, 100.9], ['c', 2]] table2 = etl.selectre(table1, 'foo', '[ab]{2}') table2 # selectusingcontext() ###################### import petl as etl table1 = [['foo', 'bar'], ['A', 1], ['B', 4], ['C', 5], ['D', 9]] def query(prv, cur, nxt): return ((prv is not None and (cur.bar - prv.bar) < 2) or (nxt is not None and (nxt.bar - cur.bar) < 2)) table2 = etl.selectusingcontext(table1, query) table2 # facet() ######### import petl as etl table1 = [['foo', 'bar', 'baz'], ['a', 4, 9.3], ['a', 2, 88.2], ['b', 1, 23.3], ['c', 8, 42.0], ['d', 7, 100.9], ['c', 2]] foo = etl.facet(table1, 'foo') sorted(foo.keys()) foo['a'] foo['c']
table1 = [['foo', 'bar'], ['A', 1], ['B', 4], ['C', 5], ['D', 9]] def query(prv, cur, nxt): return ((prv is not None and (cur.bar - prv.bar) < 2) or (nxt is not None and (nxt.bar - cur.bar) < 2)) table2 = etl.selectusingcontext(table1, query) table2 # facet() ######### import petl as etl table1 = [['foo', 'bar', 'baz'], ['a', 4, 9.3], ['a', 2, 88.2], ['b', 1, 23.3], ['c', 8, 42.0], ['d', 7, 100.9], ['c', 2]] foo = etl.facet(table1, 'foo') sorted(foo.keys()) foo['a'] foo['c']