一维格式json需要写入excel时,但不知道怎么通过python转至为2维表格形式,以方便写入单元格:
json:
{
"ret": 0,
"msg": "",
"E_T_DATA": [{
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "销售商品、提供劳务收到的现金",
"fr_day": "2019-06-30",
"fr_value": 45531.65
}, {
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "销售商品、提供劳务收到的现金",
"fr_day": "2019-09-30",
"fr_value": 74922.04
}, {
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "销售商品、提供劳务收到的现金",
"fr_day": "2019-12-31",
"fr_value": 98298.58
}, {
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "经营活动现金流入小计",
"fr_day": "2019-03-31",
"fr_value": 21618.81
}, {
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "经营活动现金流入小计",
"fr_day": "2019-06-30",
"fr_value": 46396.82
}, {
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "经营活动现金流入小计",
"fr_day": "2019-09-30",
"fr_value": 76241.97
}, {
"com_code": "300015_SZ",
"com_name": "上市公司A",
"fr_name": "现金流量表",
"fr_item_flag": null,
"fr_item": "经营活动现金流入小计",
"fr_day": "2019-12-31",
"fr_value": 100051.55
}]
}
怎么转为2维的表格样式,如下:
com_code | com_name | fr_name | fr_item_flag | fr_item | 2019-03-31 | 2019-06-30 | 2019-09-30 | 2019-12-31 |
---|---|---|---|---|---|---|---|---|
300015SZ | 上市公司A | 现金流量表 | null | 销售商品、提供劳务收到的现金 | 2019-03-31 | 2019-06-30 | 2019-09-30 | 2019-12-31 |
300015SZ | 上市公司A | 现金流量表 | null | 经营活动现金流入小计 | 2019-03-31 | 2019-06-30 | 2019-09-30 | 2019-12-31 |