python解析json文件并保存为txt文件

代码如下：

import json

path = r"D:\reviews_Office_Products.json"
file = open(path, 'r',encoding='utf-8')
file1 = open(r"D:\test.txt", 'w')

for line in file.readlines():
    fileJson = json.loads(line)
    reviewerID = fileJson["reviewerID"]
    asin = fileJson["asin"]
    try:
        reviewerName = fileJson["reviewerName"]
    except:
        reviewerName = 0
    helpful = fileJson["helpful"]
    reviewText = fileJson["reviewText"]
    overall = fileJson["overall"]
    summary = fileJson["summary"]
    unixReviewTime = fileJson["unixReviewTime"]
    reviewTime = fileJson["reviewTime"]
    # print(reviewTime)
    file1.write(reviewerID + "," + str(asin) + "," + str(reviewerName) + "," + str(helpful) + "," + reviewText + "," + str(overall) + "," + summary + "," + str(unixReviewTime) + "," + reviewTime)
    file1.write("\n")

参考博客：

https://blog.csdn.net/weixin_39217599/article/details/79979317