擅长:python、mysql、java
<p>按名称访问JSON/dict值的更直接的方法是使用<code>.str[]</code>访问器。如下所示,使用列<code>q</code>访问嵌套JSON深处的<code>t</code>值:</p>
<pre><code>df['q'] = df['q'].str['ps'].str['np'].str['t']
</code></pre>
<h2>演示</h2>
<pre><code>data = {'q':[
{'ps': {'np': {'t': 773183901}}},
{'ps': {'np': {'t': 773183902}}},
{'ps': {'np': {'t': 773183903}}},
{'ps': {'np': {'t': 773183904}}}]}
df = pd.DataFrame(data)
print(df)
q
0 {'ps': {'np': {'t': 773183901}}}
1 {'ps': {'np': {'t': 773183902}}}
2 {'ps': {'np': {'t': 773183903}}}
3 {'ps': {'np': {'t': 773183904}}}
df['q'] = df['q'].str['ps'].str['np'].str['t']
print(df)
q
0 773183901
1 773183902
2 773183903
3 773183904
</code></pre>