代码如下:
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