擅长:python、mysql、java
<p>你想要这个吗</p>
<pre><code>df = pd.json_normalize(data).transpose().explode(0).reset_index().rename(columns={'index': 'vertical', 0 :'subvertical'})
df.to_excel('out.xlsx', index=False)
</code></pre>
<p><strong>输出-</strong></p>
<pre><code> vertical subvertical
0 ADVERTISING_AND_MARKETING CREATIVE_AGENCY
1 ADVERTISING_AND_MARKETING FULL_SERVICE_AGENCY
2 ADVERTISING_AND_MARKETING BUYING_AGENCY
3 AGRICULTURE FARMING_AND_RANCHING
4 AGRICULTURE FISHING_AND_HUNTING_AND_FORESTRY_AND_LOGGING
5 AUTOMOTIVE T1_MOTORCYCLE
6 AUTOMOTIVE RECREATIONAL
7 AUTOMOTIVE T1_AUTOMOTIVE_MANUFACTURER
8 AUTOMOTIVE T2_DEALER_ASSOCIATIONS
</code></pre>