首页 > 解决方案 > 如何将泡菜文件转换为 JSON 格式?

问题描述

我有一个pickle文件需要转换成json格式,我用了这段代码


    import pickle
    import pandas as pd
    from sys import argv
    
    script, filename = argv
    input_file = open('f.pkl', 'rb')
    new_dict = pickle.load(input_file)
    
    df = pd.DataFrame.from_dict(new_dict, orient='index')
    df['index1'] = df.index
    index1 = df['index1']
    df.drop(labels=['index1'], axis=1, inplace=True)
    df.insert(0, 'index1', index1)
    json_df = df.to_json(orient='values', date_format='iso', date_unit='s')
    with open('data.json', 'w') as js_file:
        js_file.write(json_df)

但得到了

 df = pd.DataFrame.from_dict(new_dict, orient='index')
  File "pandas/core/frame.py", line 1127, in from_dict
    if isinstance(list(data.values())[0], (Series, dict)):
AttributeError: 'list' object has no attribute 'values'

标签: pythonjsonpickle

解决方案


推荐阅读