使用Python将列表中的重复JSON键值对组合在一起

Joliet 发表于 Dev

123

朱丽叶

我已经从REST API中读取并过滤了所需的数据，如下所示：

 [[key,value] for groups in results for group in groups['results'] for key,value in group.items() if key in ['utc_offset','country','city','state','name','link','lat','lon']]

我的输出：

[['utc_offset', -14400000],
['country', 'CA'],
['city', 'Toronto'],
['link', 'https://www.meetup.com/slashdot-3/'],
['lon', -79.44000244140625],
['name', 'The Toronto Slashdot Meetup Group'],
['state', 'ON'],
['lat', 43.7599983215332],
['utc_offset', -14400000],
['country', 'CA'],
['city', 'Toronto'],
['link', 'https://www.meetup.com/webcentric/'],
['lon', -79.44000244140625],
['name', 'The Greater Toronto Web Centric Meetup Group'],
['state', 'ON'],
['lat', 43.7599983215332],
['utc_offset', -14400000],
['country', 'CA'],
['city', 'Toronto'],
['link', 'https://www.meetup.com/php-27/'],
['lon', -79.37999725341797],
['name', 'The Toronto PHP Meetup Group'],
['state', 'ON'],
.
.
.
]]

我正在尝试将重复键分组，以便可以将它们建模为Django的数据对象：

[['utc_offset', -14400000],['country', 'CA'],['city', 'Toronto'],['link', 'https://www.meetup.com/slashdot-3/'],['lon', -79.44000244140625],['name', 'The Toronto Slashdot Meetup Group'],['state', 'ON'],['lat', 43.7599983215332]]

我已经试过了：

[zip(range(8),[key,value]) for groups in results for group in groups['results'] for key,value in group.items() if key in ['utc_offset','country','city','state','name','link','lat','lon']]

但是我的输出是这样的：

<zip object at 0x00000228D3C2F388>
<zip object at 0x00000228D3C2F388>
<zip object at 0x00000228D3C2F388>
<zip object at 0x00000228D3C2F388>
<zip object at 0x00000228D3C2F388>
<zip object at 0x00000228D3C2F3C8>
<zip object at 0x00000228D3C2F3C8>
<zip object at 0x00000228D3C2F3C8>
<zip object at 0x00000228D3C2F3C8>
<zip object at 0x00000228D3C2F388>
 .
 .
 .
 # twice the amount of the records I already have

因此，这几乎不是答案，因此任何帮助都会很棒。谢谢！

编辑我想要的输出将像这样

[['utc_offset', value],['country',value],['city',value],['link',value],['lon',value],['name',value],['state',value],['lat',value]]

暗星

我认为这就是您所追求的（我仍然不确定100％您希望我对每个结果块做什么）：

l = [['utc_offset', -14400000],
['country', 'CA'],
['city', 'Toronto'],
['link', 'https://www.meetup.com/slashdot-3/'],
['lon', -79.44000244140625],
['name', 'The Toronto Slashdot Meetup Group'],
['state', 'ON'],
['lat', 43.7599983215332],
['utc_offset', -14400000],
['country', 'CA'],
['city', 'Toronto'],
['link', 'https://www.meetup.com/webcentric/'],
['lon', -79.44000244140625],
['name', 'The Greater Toronto Web Centric Meetup Group'],
['state', 'ON'],
['lat', 43.7599983215332],
['utc_offset', -14400000],
['country', 'CA'],
['city', 'Toronto'],
['link', 'https://www.meetup.com/php-27/'],
['lon', -79.37999725341797],
['name', 'The Toronto PHP Meetup Group'],
['state', 'ON']]

result = []

tmp = []

for item in l:
    if item[0] == 'lat':
        tmp.append(item)
        result.append(tmp)
        tmp = []
    else:
        tmp.append(item)

print(result)

结果是：

[
    [
        ['utc_offset', -14400000], 
        ['country', 'CA'], 
        ['city', 'Toronto'], 
        ['link', 'https://www.meetup.com/slashdot-3/'], 
        ['lon', -79.44000244140625], 
        ['name', 'The Toronto Slashdot Meetup Group'], 
        ['state', 'ON'], 
        ['lat', 43.7599983215332]
    ], 
    [
        ['utc_offset', -14400000], 
        ['country', 'CA'], 
        ['city', 'Toronto'], 
        ['link', 'https://www.meetup.com/webcentric/'], 
        ['lon', -79.44000244140625], 
        ['name', 'The Greater Toronto Web Centric Meetup Group'], 
        ['state', 'ON'], 
        ['lat', 43.7599983215332]
    ]
]

utc_offsetto的每个块lat都放入其自己的列表中。如果您需要其他格式的文件，请告诉我。

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。