python json转panda list转pandas

先把json转为List 再将list转为pandas

def json2csv():
    import json
    import pandas as pd
    # json转为list
    data = {'info': 112, 'timestamp': 100, 'get': 100}
    first_col = [key for key in data.keys()]
    second_col = []
    for key in data.keys():
        second_col.append(data[key])
    # list转为pandas
    c = {"word":first_col, "count":second_col}
    from pandas.core.frame import DataFrame
    dt = DataFrame(c)
    dt.to_csv("./word_ts.csv")
    return

list转pandas

第一种情况

    first_col = ["a", "b"]
    second_col = [3, 4]
    c = {"word":first_col, "count":second_col}
    from pandas.core.frame import DataFrame
    dt = DataFrame(c)
    dt.to_csv("./word_ts.csv")

第二种

data = [["que", 1, 2,3], ["chong", 4,5,6]
from pandas.core.frame import DataFrame
dt = DataFrame(data, columns=['name','t1','t2','t3'])
print(dt)