In [1]:

    

import sys
sys.version_info


    

    
Out[1]:





sys.version_info(major=3, minor=4, micro=2, releaselevel='final', serial=0)

In [2]:

    

import petl as etl
etl.__version__


    

    
Out[2]:





'1.0.6'

In [3]:

    

tbl1 = [['foo', 'bar'],
        ['a b c', 1],
        ['d e f', 2],
        [None, 3]]


    

In [4]:

    

tbl2 = etl.wrap(tbl1).replace('foo', None, '  ').split('foo', ' ', ['x', 'y', 'z']).replaceall('', None)
tbl2


    

    
Out[4]:







bar
x
y
z




1
a
b
c


2
d
e
f


3
None
None
None

In [ ]: