回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<pre><code>UG=[
{"group_member":"myGroup1","user_name":"tom"},
{"group_member":"myGroup2","user_name":"wilson"},
{"group_member":"myGroup1","user_name":"kevin"},
{"group_member":"myGroup2","user_name":"donna"},
{"group_member":"myGroup3","user_name":"john"},
{"group_member":"myGroup1","user_name":"steve"},
{"group_member":"myGroup2","user_name":"jose"},
{"group_member":"myGroup3","user_name":"jags"}]
PG=[
{"group_member":"myGroup1","device_name":"device1"},
{"group_member":"myGroup1","device_name":"device2"},
{"group_member":"myGroup2","device_name":"device1"},
{"group_member":"myGroup1","device_name":"device2"},
{"group_member":"myGroup1","device_name":"device3"},
{"group_member":"myGroup3","device_name":"device1"}]
DG=[
{"device_name":"device1","server":"server1"},
{"device_name":"device2","server":"server2"},
{"device_name":"device3","server":"server3"},
{"device_name":"device4","server":"server4"},
{"device_name":"device5","server":"server5"},
{"device_name":"device6","server":"server6"}
]
</code></pre>
<p>我需要比较这些列表并准备一个字典列表,条件如下</p>
<pre><code>UG[i]['group_member'] == PG[j]['group_member'] && PG[j]['device_name'] == UG[k]['device_name']
</code></pre>
<p>这是我的实现</p>
<pre><code># output array
output=[]
for i in DG:
for j in PG:
if i["device_name"] == j["device_name"]:
for k in UG:
if k["group_member"] == j["group_member"]:
output.append({"user_name":k["user_name"],"group_member":k["group_member"],"device_name":j["device_name"],"server":i["server"]})
for m in output:
print m
</code></pre>
<p>期望输出===========</p>
<pre><code>[
{'server': 'server1', 'user_name': 'tom', 'group_member': 'myGroup1', 'device_name': 'device1'},
{'server': 'server1', 'user_name': 'kevin', 'group_member': 'myGroup1', 'device_name': 'device1'},
{'server': 'server1', 'user_name': 'steve', 'group_member': 'myGroup1', 'device_name': 'device1'},
{'server': 'server1', 'user_name': 'wilson', 'group_member': 'myGroup2', 'device_name': 'device1'}
{'server': 'server1', 'user_name': 'donna', 'group_member': 'myGroup2', 'device_name': 'device1'},
{'server': 'server1', 'user_name': 'jose', 'group_member': 'myGroup2', 'device_name': 'device1'},
{'server': 'server1', 'user_name': 'john', 'group_member': 'myGroup3', 'device_name': 'device1'},
{'server': 'server1', 'user_name': 'jags', 'group_member': 'myGroup3', 'device_name': 'device1'},
{'server': 'server2', 'user_name': 'tom', 'group_member': 'myGroup1', 'device_name': 'device2'},
{'server': 'server2', 'user_name': 'kevin', 'group_member': 'myGroup1', 'device_name': 'device2'},
{'server': 'server2', 'user_name': 'steve', 'group_member': 'myGroup1', 'device_name': 'device2'},
{'server': 'server2', 'user_name': 'tom', 'group_member': 'myGroup1', 'device_name': 'device2'},
{'server': 'server2', 'user_name': 'kevin', 'group_member': 'myGroup1', 'device_name': 'device2'},
{'server': 'server2', 'user_name': 'steve', 'group_member': 'myGroup1', 'device_name': 'device2'},
{'server': 'server3', 'user_name':'tom', 'group_member': 'myGroup1', 'device_name': 'device3'},
{'server': 'server3', 'user_name': 'kevin', 'group_member': 'myGroup1', 'device_name': 'device3'},
{'server': 'server3', 'user_name': 'steve', 'group_member': 'myGroup1', 'device_name': 'device3'}
]
</code></pre>
<p>如何改进我的实施</p>