擅长:python、mysql、java
<p>这是一种方法。你知道吗</p>
<p><strong>例如:</strong></p>
<pre><code>my_dict = {
'N': [
{'DATE': 2019, 'VALUE': 1},
{'DATE': 2018, 'VALUE': 2}
],
'LT': [
{'DATE': 2019, 'VALUE': 40},
{'DATE': 2001, 'VALUE': 50}
]
}
my_dict_transformed = {}
for k, v in my_dict.items():
for i in v:
if i["DATE"] not in my_dict_transformed:
my_dict_transformed[i["DATE"]] = {'DATE': i["DATE"]}
my_dict_transformed[i["DATE"]].update(dict((i,"NULL") for i in my_dict.keys()))
my_dict_transformed[i["DATE"]][k] = i.pop('VALUE')
print(list(my_dict_transformed.values()))
</code></pre>
<p><strong>输出:</strong></p>
<pre><code>[{'DATE': 2001, 'LT': 50},
{'DATE': 2018, 'N': 2},
{'DATE': 2019, 'LT': 40, 'N': 1}]
</code></pre>