def transform_resource(self, source, target):
if isinstance(self.__resource, str):
self.__resource = source.package.get_resource(self.__resource)
self.__resource.infer(only_sample=True)
view1 = source.to_petl()
view2 = self.__resource.to_petl()
target.data = petl.annex(view1, view2)
for field in self.__resource.schema.fields:
target.schema.fields.append(field.to_copy())
def transform_resource(self, resource):
target = resource
source = self.get("resource")
if isinstance(source, str):
source = target.package.get_resource(source)
source.infer()
view1 = target.to_petl()
view2 = source.to_petl()
for field in source.schema.fields:
target.schema.fields.append(field.to_copy())
resource.data = petl.annex(view1, view2)
# annex
table1 = (('foo', 'bar'),
('A', 9),
('C', 2),
('F', 1))
table2 = (('foo', 'baz'),
('B', 3),
('D', 10))
from petl import annex, look
look(table1)
look(table2)
table3 = annex(table1, table2)
look(table3)
# progress
from petl import dummytable, progress, tocsv
d = dummytable(100500)
p = progress(d, 10000)
tocsv(p, 'output.csv')
# clock
from petl import dummytable, clock, convert, progress, tocsv
t1 = dummytable(100000)
# annex
table1 = (('foo', 'bar'),
('A', 9),
('C', 2),
('F', 1))
table2 = (('foo', 'baz'),
('B', 3),
('D', 10))
from petl import annex, look
look(table1)
look(table2)
table3 = annex(table1, table2)
look(table3)
# progress
from petl import dummytable, progress, tocsv
d = dummytable(100500)
p = progress(d, 10000)
tocsv(p, 'output.csv')
# clock
from petl import dummytable, clock, convert, progress, tocsv
t1 = dummytable(100000)
table2 = etl.skipcomments(table1, '##')
table2
# annex()
#########
import petl as etl
table1 = [['foo', 'bar'],
['A', 9],
['C', 2],
['F', 1]]
table2 = [['foo', 'baz'],
['B', 3],
['D', 10]]
table3 = etl.annex(table1, table2)
table3
# addrownumbers()
#################
import petl as etl
table1 = [['foo', 'bar'],
['A', 9],
['C', 2],
['F', 1]]
table2 = etl.addrownumbers(table1)
table2
