python - pandas Dataframe 到 JSON 字典列表

Question

这是样本数据集

datetime  2017-12-24  2017-12-31                             
a                1.5         0.5
b                0.0         1.5
c                1.5         0.0

我正在使用 to_json 将其转换为 json，我得到了这个输出

{"2017-12-24":{"a":1.5,"b":0.0,"c":1.5},"2017-12-31":{"a":0.5,"b":1.5,"c":0.0}}

我想做的是让 json 得到一个像这样的字典列表

[{"datetime":"2017-12-24","a":1.5,"b":0.0,"c":1.5},{"datetime":"2017-12-31", "a":0.5,"b":1.5,"c":0.0}]

我的代码在这里

df = pd.DataFrame({'2017-12-24': [1.5, 0.0, 1.5], '2017-12-31': [0.5, 1.5, 0.0]}, index=['a', 'b', 'c'])
df.columns.name='datetime'
print(df.to_json())

Answer 1

转置、reset_index 和to_json

i = df.T.reset_index()
i

     datetime    a    b    c
0  2017-12-24  1.5  0.0  1.5
1  2017-12-31  0.5  1.5  0.0

i.to_json()
'[{"datetime":"2017-12-24","a":1.5,"b":0.0,"c":1.5},{"datetime":"2017-12-31","a":0.5,"b":1.5,"c":0.0}]'

---

入栈 + 出栈

(df.stack()
   .unstack(0)
   .reset_index()
   .to_json(orient='records'))

'[{"datetime":"2017-12-24","a":1.5,"b":0.0,"c":1.5},{"datetime":"2017-12-31","a":0.5,"b":1.5,"c":0.0}]'