Python-json转换成csv(pandas)

import pandas as pd
train_sample_metadata = pd.read_json('New_dataset/metadata.json').T
train_sample_metadata.head()

import csv
import json

def fk_rl(str):
    if str == 'FAKE': return 0
    else: return 1

def transcsv(jsonpath, csvpath,strpath):
    json_file = open(jsonpath, 'r', encoding='utf8')
    csv_file = open(csvpath, 'w')
    writer = csv.writer(csv_file)   
    writer.writerow(["video_id","labels"])
    #读文件
    ls = json.load(json_file)  #将json格式的字符串转换成python的数据类型，解码过程
    data = list((key,item)  for key,item in ls.items())  # 获取列名,即key   
    for line in data:
        writer.writerow([strpath+line[0],fk_rl(list(line[1].items())[0][1])])
    #关闭文件
    json_file.close()
    csv_file.close()

transcsv('New_dataset/metadata.json','New_dataset/metadata.csv','/home/jovyan/work/data/gyx/competition_face/New_dataset/')

import pandas as pd
data = pd.read_csv('New_dataset/metadata.csv')
data