擅长:python、mysql、java
<p>您可以使用Pandas Normalize类将json规范化为Pandas dataframe,然后将dataframe写入csv</p>
<p>假设变量'data'中有Json字典,比如:[{json1},{json2},{json3}…]</p>
<pre><code> import json
import pandas
from pandas.io.json import json_normalize
for d in data:
normalized_data = json_normalize(d)
normalized_data .to_csv('csv_file_name', sep='|', mode='a', index=False, na_rep='', header=False)
</code></pre>
<p>参考:<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.io.json.json_normalize.html" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.io.json.json_normalize.html</a></p>