擅长:python、mysql、java
<p>查找<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_json.html" rel="nofollow noreferrer">pandas documentation</a></p>
<pre><code>df.to_json(orient='records')
'[{"col 1":"a","col 2":"b"},{"col 1":"c","col 2":"d"}]'
</code></pre>
<p>使用“index”格式的JSON对数据帧进行编码/解码:</p>
^{pr2}$
<p>使用“columns”格式的JSON对数据帧进行编码/解码:</p>
<pre><code>df.to_json(orient='columns')
'{"col 1":{"row 1":"a","row 2":"c"},"col 2":{"row 1":"b","row 2":"d"}}'
</code></pre>
<p>使用“values”格式的JSON对数据帧进行编码/解码:</p>
<pre><code>df.to_json(orient='values')
'[["a","b"],["c","d"]]'
</code></pre>