擅长:python、mysql、java
<p>下面是一种使用<a href="https://pandas.pydata.org/" rel="nofollow noreferrer">^{<cd1>}</a>库的方法:</p>
<pre><code>import pandas as pd
from pandas.io.json import json_normalize
d1 = json_normalize(d1['result'])
d2 = json_normalize(d2['result'])
# merge the data
lst = d1.merge(d2, left_on='number', right_on='task').drop('task', axis=1)
# converting time to same units (seconds)
lst['time_secs'] = lst['time_left'].str.split().apply(lambda x: int(x[0])*60 if 'min' in x else int(x[0]))
# sort, select cols and convert to dictionary
lst = lst.sort_values('time_secs', ascending=True)[['number','month','time_left']].to_dict(orient='records')
[{'number': '0010041', 'month': 'January', 'time_left': '20 sec'},
{'number': '0010042', 'month': 'March', 'time_left': '6 min'}]
</code></pre>