产生摘要（“枢轴”？）表

在python方面，您可以使用itertools魔术来重新排列数据：

data = [('Apple',      'Coles',      1.50),        ('Apple',      'Woolworths', 1.60),        ('Apple',      'IGA',        1.70),        ('Banana',     'Coles',      0.50),        ('Banana',     'Woolworths', 0.60),        ('Banana',     'IGA',        0.70),        ('Cherry',     'Coles',      5.00),        ('Date',       'Coles',      2.00),        ('Date',       'Woolworths', 2.10),        ('Elderberry', 'IGA',        10.00)]from itertools import groupby, islicefrom operator import itemgetterfrom collections import defaultdictstores = sorted(set(row[1] for row in data))# probably splitting this up in multiple lines would be more readablepivot = ((fruit, defaultdict(lambda: None, (islice(d, 1, None) for d in data))) for fruit, data in groupby(sorted(data), itemgetter(0)))print 'Fruit'.ljust(12), 't'.join(stores)for fruit, prices in pivot:    print fruit.ljust(12), 't'.join(str(prices[s]) for s in stores)

输出：

Fruit        Coles      IGA     WoolwApple        1.5        1.7     1.6Banana       0.5        0.7     0.6Cherry       5.0        None    NoneDate         2.0        None    2.1Elderberry   None       10.0    None