a = (('foo', 'bar', 'baz'), ('A', 1, True), ('C', 7, False), ('B', 2, False), ('C', 9, True)) b = (('bar', 'foo', 'baz'), (2, 'B', False), (9, 'A', False), (3, 'B', True), (9, 'C', True)) from petl import recordcomplement, look look(a) look(b) aminusb = recordcomplement(a, b) look(aminusb) bminusa = recordcomplement(b, a) look(bminusa) # diff a = [['foo', 'bar', 'baz'], ['A', 1, True], ['C', 7, False], ['B', 2, False], ['C', 9, True]] b = [['x', 'y', 'z'], ['B', 2, False], ['A', 9, False], ['B', 3, True],
# recordcomplement() #################### import petl as etl a = [['foo', 'bar', 'baz'], ['A', 1, True], ['C', 7, False], ['B', 2, False], ['C', 9, True]] b = [['bar', 'foo', 'baz'], [2, 'B', False], [9, 'A', False], [3, 'B', True], [9, 'C', True]] aminusb = etl.recordcomplement(a, b) aminusb bminusa = etl.recordcomplement(b, a) bminusa # diff() ######## import petl as etl a = [['foo', 'bar', 'baz'], ['A', 1, True], ['C', 7, False], ['B', 2, False], ['C', 9, True]] b = [['x', 'y', 'z'],
['C', 9, True]] aminusb = etl.complement(a, b) aminusb bminusa = etl.complement(b, a) bminusa # recordcomplement() #################### import petl as etl a = [['foo', 'bar', 'baz'], ['A', 1, True], ['C', 7, False], ['B', 2, False], ['C', 9, True]] b = [['bar', 'foo', 'baz'], [2, 'B', False], [9, 'A', False], [3, 'B', True], [9, 'C', True]] aminusb = etl.recordcomplement(a, b) aminusb bminusa = etl.recordcomplement(b, a) bminusa # diff() ######## import petl as etl a = [['foo', 'bar', 'baz'], ['A', 1, True], ['C', 7, False], ['B', 2, False], ['C', 9, True]] b = [['x', 'y', 'z'], ['B', 2, False], ['A', 9, False], ['B', 3, True], ['C', 9, True]] added, subtracted = etl.diff(a, b) # rows in b not in a