1from __future__ import division, print_function, absolute_import 2 3 4# fromtext() 5############ 6 7import petl as etl 8# setup example file 9text = 'a,1\nb,2\nc,2\n' 10with open('example.txt', 'w') as f: 11 f.write(text) 12 13table1 = etl.fromtext('example.txt') 14table1 15# post-process, e.g., with capture() 16table2 = table1.capture('lines', '(.*),(.*)$', ['foo', 'bar']) 17table2 18 19 20# totext() 21########## 22 23import petl as etl 24table1 = [['foo', 'bar'], 25 ['a', 1], 26 ['b', 2], 27 ['c', 2]] 28prologue = '''{| class="wikitable" 29|- 30! foo 31! bar 32''' 33template = '''|- 34| {foo} 35| {bar} 36''' 37epilogue = '|}' 38etl.totext(table1, 'example.txt', template, prologue, epilogue) 39# see what we did 40print(open('example.txt').read()) 41