python脚本读取json文件并写入到text文件中

最新推荐文章于 2023-02-24 14:31:51 发布

liudehua_187

最新推荐文章于 2023-02-24 14:31:51 发布

阅读量1k

点赞数 2

分类专栏： python 文章标签： python json

本文链接：https://blog.csdn.net/qq_43172476/article/details/112347887

版权

python 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

读取json文件并写入到text文件中

代码

代码

import json



with open('D://gitxiangmu//exercises.json','r',encoding='utf-8') as load_f:
    load_dict = json.load(load_f)
    json_exercises = load_dict['exercises']
    f = open('D://gitxiangmu//exercises.txt','a',encoding="utf-8")
    for i in json_exercises:
        print(i['id'])
        id = i['id']
        type = i['type_id']
        subject = i['question']
        answerA = i['answer_a']
        answerB = i['answer_b']
        answerC = i['answer_c']
        answerD = i['answer_d']
        answerE = i['answer_e']
        answerF = ""
        answer_true = i['real_answer']
        sql = 'INSERT INTO `xxxxxx` VALUES (' + str(id) + ',\'' + type + '\'' + ',\'' + subject + '\'' + ',\'' + answerA + '\'' + ',\'' + answerB + '\'' + ',\'' + answerC + '\'' + ',\'' + answerD + '\'' + ',\'' + answerE + '\'' + ',\'' + answerF + '\'' + ',\'' + answer_true + '\'' + ');'
        f.write(sql + "\r\n")
    # sql = 'INSERT INTO `xxxxxx` VALUES (' + str(id) + ',\''+type+'\''+',\''+subject+'\''+',\''+answerA+'\''+',\''+answerB+'\''+',\''+answerC+'\''+',\''+answerD+'\''+',\''+answerE+'\''+',\''+answerF+'\''+',\''+answer_true+'\''+')'
    # print(sql)
    # f.write("text"+"\r\n")