json转csv

csv转json

实验的json数据格式

[
    {
   
        "average": "300000000000",
        "Max": null,
        "Min": null,
        "timestemp": "2020-11-10T22:18:02",
        "remarks": null
    },
    {
   
        "average": "300000000000",
        "Max": null,
        "Min": null,
        "timestemp": "2020-11-10T22:18:02",
        "remarks": null
    },
    {
   
        "average": "300000000000",
        "Max": null,
        "Min": null,
        "timestemp": "2020-11-10T22:18:02",
        "remarks": null
    }
]

希望得到的csv数据

average,Max,Min,timestemp,remarks
300000000000,,,2020-11-10T22:18:02,
300000000000,,,2020-11-10T22:18:02,
300000000000,,,2020-11-10T22:18:02,

代码实现

我的想法是把json装进字典中，通过读取字典中的key和value值来进行csv数据的拼装

首先先把json数据放入dic中

# coding:utf-8

import csv
import json
import sys
import os

def trans(jsonpath, csvpath):
    json_file = open(jsonpath, 'r', encoding='utf8')
    csv_file = open(csvpath, 'w', newline='')
    json_data = json_file.read()
    dic_data = json.loads(json_data, encoding='utf8')

把dic中的key值变成csv的第一行

# coding:utf-8

import csv
import json
import sys
import os

def trans(jsonpath, csvpath):
    json_file = open(jsonpath, 'r', encoding='utf8')
    csv_file = open(csvpath, 'w', newline='')
    writer = csv.writer(csv_file)
    json_data = json_file.read()
    dic_data = json.loads(json_data, encodin