擅长:python、mysql、java
<p>在IIUC中,以下各项应起作用:</p>
<p><strong>输入</strong></p>
<pre><code>df = pd.DataFrame({'col1':[1], 'col2':2, 'nested_column':'[{"institution":"some_institution","startMonth":1,"startYear":2563,"course":"any","id":1111,"formation":"any","endMonth":12,"endYear":2556,"status":"complete"}]'})
df
col1 col2 nested_column
0 1 2 [{"institution":"some_institution","startMonth...
</code></pre>
<p><strong>过程</strong></p>
<pre><code>import json
df['nested_column_dict'] = df['nested_column'].transform(lambda x : json.loads(x)[0] if x is not np.nan else {})
df = pd.concat([df, pd.DataFrame.from_records(df['nested_column_dict'])], axis=1)
df.drop('nested_column_dict', axis=1, inplace=True)
</code></pre>
<p><strong>输出</strong></p>
<pre><code> df
col1 col2 nested_column institution startMonth startYear course id formation endMonth endYear status
0 1 2 [{"institution":"some_institution","startMonth... some_institution 1 2563 any 1111 any 12 2556 complete
</code></pre>