将多个Twitter JSON文件转换为一个CSV

import json
import csv
import os

# 需要转换的JSON文件目录
json_dir = "path/to/json/files"

# 输出的CSV文件路径
csv_file = "path/to/output.csv"

# CSV文件的表头
csv_header = ["推文文本", "推文时间", "作者", "转发数", "喜欢数"]

# 遍历JSON文件目录
for filename in os.listdir(json_dir):
    if filename.endswith(".json"):
        json_file = os.path.join(json_dir, filename)
        
        # 打开JSON文件并解析
        with open(json_file, "r") as file:
            json_data = json.load(file)
        
        # 提取所需数据
        tweets = json_data["tweets"]
        extracted_data = []
        for tweet in tweets:
            extracted_data.append([
                tweet["text"],
                tweet["time"],
                tweet["author"],
                tweet["retweets"],
                tweet["likes"]
            ])
        
        # 写入CSV文件
        with open(csv_file, "a", newline="", encoding="utf-8") as file:
            writer = csv.writer(file)
            
            # 写入表头
            if os.stat(csv_file).st_size == 0:
                writer.writerow(csv_header)
            
            # 写入数据
            writer.writerows(extracted_data)

print("转换完成！")