数据写出到json

字典类型数据写出到json

import json
def write_to_file(content, filename):
    with open(filename, 'a', encoding='utf-8') as f:
        f.write(json.dumps(content, ensure_ascii=False) + '\n')

DataFrame类型数据写出到json

import json
def df2json(df,filepath):
    with open(filepath,'a+',encoding='utf-8') as f:
        for i in df.columns:
            df[i] = df[i].astype('str')
        contents = df.to_dict('records')
        for index,content in enumerate(contents):
            try:
                f.write(json.dumps(content,ensure_ascii=False) + '\n')
            except:
                print(F'{index+1},{content} 无法写出')