|
各位大神,本人python小白一个,长话不说,上问题:
本人从网站上下载json 数据,如下:
"data": [
{
"mc": 3634891840632.4004,
"date": "2020-02-14T00:00:00+08:00",
"pb": {
"avg": 7.497295660864022,
"equalAvg": 4.495590635336181,
"median": 6.245556907362702,
"weightedAvg": 6.383818659442611
},
"pe_ttm": {
"avg": 64.1581081096013,
"equalAvg": 59.75739968429202,
"median": 58.56557531179844,
"weightedAvg": 58.74577310247905
},
"ps_ttm": {
"avg": 9.384182154513223,
"equalAvg": 3.7209959601477145,
"median": 8.410010473409654,
"weightedAvg": 5.587291500533653
},
"dyr": {
"avg": 0.005620294070719708,
"equalAvg": 0.005620294070719708,
"median": 0.0029733632138593553,
"weightedAvg": 0.005093786445851078
},
"cp": 2069.22,
"stockCode": "399006"
},
存为txt,从网上下载了代码,成功转化为csv,但每个pettm、ps、pb、dyr下面还有四个类型,却没有进一步读取展开:
以下是python的代码,望各位能否帮助点拨一二,看看怎么改可以使得每个pettm、ps、pb、dyr下面还有四个类型数据,根据date,进一步展开。
#!/usr/bin/python3
# -*- coding: utf-8 -*-
import csv
# 获取json数据
import json
with open('399006.txt', 'r') as f:
rows = json.load(f)
# 创建文件对象
f = open('399006.csv', 'w')
# 通过文件创建csv对象
csv_write = csv.writer(f)
# writerow: 按行写入, writerows: 是批量写入
# 写入数据 取列表的第一行字典,用字典的key值做为头行数据
csv_write.writerow(rows[0].keys())
# 循环里面的字典,将value作为数据写入进去
for row in rows:
csv_write.writerow(row.values())
# 关闭打开的文件
f.close()
|
-
|