擅长:python、mysql、java
<p>我试过用这个</p>
<pre><code>data= [{'id': 'abc001',
'demo': [{'Answer': '1', 'QID': 'AB001'},
{'Answer': '6', 'QID': 'AB023'},
{'Answer': '3', 'QID': 'AB004'},
{'Answer': '3', 'QID': 'AB006'}]},
{'id': 'abc002',
'demo': [{'Answer': '1', 'QID': 'AB001'},
{'Answer': '6', 'QID': 'AB002'},
{'Answer': '3', 'QID': 'AB003'},
{'Answer': '3', 'QID': 'AB006'}]},
{'id': 'abc003',
'demo': [{'Answer': '1', 'QID': 'AB001'},
{'Answer': '6', 'QID': 'AB002'},
{'Answer': '3', 'QID': 'AB004'},
{'Answer': '3', 'QID': 'AB005'}]}]
id_to_key = {
'AB001': 'gender',
'AB002': 'edu',
'AB003': 'qual',
'AB004': 'area',
'AB005': 'sal',
'AB006': 'living',
'AB023': 'job'
}
import pprint
result = []
for item in data:
d = {'id': item['id']}
dd = {}
for question in item['demo']:
dd[id_to_key[question['QID']]] = question['Answer']
d['demo'] = dd
result.append(d)
pprint.pprint(result)
</code></pre>