擅长:python、mysql、java
<p>这是因为要将ndarray类型传递给jsonify。在</p>
<p>尽管df.to_json文件(orient=“records”)将为您服务,
您可以通过数据框错误()和/或defaultdit
下面是一个例子:</p>
<pre><code>@app.route('/')
def pandasJSON():
df2 = pd.DataFrame({'A': 1.,
'C': pd.Series(1, index=list(range(4)), dtype='float32'),
'D': np.array([3] * 4, dtype='int32'),
'E': pd.Categorical(["test", "train", "test", "train"]),
'F': 'foo'})
df2['G'] = [100,200,300,400]
df2.set_index('G', inplace=True)
result = {}
for index, row in df2.iterrows():
#result[index] = row.to_json()
result[index] = dict(row)
return jsonify(result)
</code></pre>
<p><a href="https://i.stack.imgur.com/pXYml.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pXYml.jpg" alt="Output Image"/></a></p>