python分组聚合显示全部列_按Python中词典的聚合列表分组

只是为了证明，有时候python可以很好地在：In [11]: from collections import Counter

from itertools import groupby

In [12]: data = [{"startDate": 123, "endDate": 456, "campaignName": "abc", "campaignCfid": 789, "budgetImpressions": 10}, {"startDate": 123, "endDate": 456, "campaignName": "abc", "campaignCfid": 789, "budgetImpressions": 50}, {"startDate": 456, "endDate": 789, "campaignName": "def", "campaignCfid": 123, "budgetImpressions": 80}]

In [13]: g = groupby(data, lambda x: x.pop('campaignName'))

In [14]: d = {}

for campaign, campaign_data in g:

c = Counter()

for row in campaign_data: c.update(row)

d[campaign] = c # if you want a dict rather than Counter, return dict(c) here

In [15]: d

Out[15]:

{'abc': Counter({'campaignCfid': 1578, 'endDate': 912, 'startDate': 246, 'budgetImpressions': 60}),

'def': Counter({'endDate': 789, 'startDate': 456, 'campaignCfid': 123, 'budgetImpressions': 80})}

如果您已经有了这个列表/dict集合，那么将它提升为数据帧实际上没有意义，使用纯python通常会更便宜。