<p>在<code>{}</code>中包含的每个文本实际上都是<code>dict</code>类型。使用<code>pd.DataFrame</code>可以轻松地将此类型转换为pandas,最后使用<code>to_excel</code>转换为excel</p>
<p>完整的代码可以编写如下:</p>
<pre><code>import pandas as pd
my_dict_1={
"campaignId": "all", "startDate":"2020-06-11", "endDate":"2020-06-11", "device":"Computers", "network":"Display Network", "channel":"all", "accLevelQS":-1.0, "impressions":389, "clicks":3, "ctr":0.0, "avgCPC":0.0, "convValuePerClick":0.0, "convValuePerCost":0.0, "costConv1PerClick":0.0, "convRate1PerClick":0.0, "cost":0.142884, "conv1PerClick":0.0, "totalConvValue":0.00, "allConversions":0.0, "allConversionValue":0.00, "avgPosition":0.0, "intr":3, "searchImprShare":0.0, "contImprShare":5.0, "impressionShare":5.0
}
my_dict_2={
"campaignId": "all", "startDate":"2020-06-11", "endDate":"2020-06-11", "device":"Mobile devices with full browsers", "network":"Display Network", "channel":"all", "accLevelQS":-1.0, "impressions":6101, "clicks":90, "ctr":0.0, "avgCPC":0.0, "convValuePerClick":0.0, "convValuePerCost":0.0, "costConv1PerClick":0.0, "convRate1PerClick":0.0, "cost":4.342799, "conv1PerClick":0.0, "totalConvValue":0.00, "allConversions":0.0, "allConversionValue":0.00, "avgPosition":0.0, "intr":90, "searchImprShare":0.0, "contImprShare":5.0077566465021217, "impressionShare":5.0077566465021217
}
all_dict=[my_dict_1,my_dict_2]
df1 = pd.DataFrame(all_dict)
df1.to_excel("output.xlsx",index = False)
</code></pre>