擅长:python、mysql、java
<p>另一种方法是使用<a href="https://docs.python.org/3/library/collections.html#collections.defaultdict" rel="nofollow noreferrer">defaultdict</a>和<a href="https://docs.python.org/3/library/ast.html#ast.literal_eval" rel="nofollow noreferrer">ast literal eval</a>:</p>
<pre><code>from collections import defaultdict
import ast
d = defaultdict(list)
#iterate through the Data column and append to dictionary for each key
for ent in df.Data:
for entry in ast.literal_eval(ent):
for k, v in entry.items():
d[k].append(v)
#concat to ClientToken column
pd.concat([df.ClientToken,pd.DataFrame(d)],axis=1)
ClientToken summaryId duration startTime
0 7a9ee887-8a09-ff9592e08245 4814223456 952 1587442919
1 bac49563-2cf0-cb08e69daa48 4814239586 132 1587443876
</code></pre>