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))
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']
