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