Python pandas DataFram对象列表

Question

是否有一种内置的方法将Python中的对象列表转换为Pandas数据帧。在

myList = [
    {
        name:'ABC',
        value:35,
        date:2018-01-01
    },
    {
        name:'ABC',
        value:30,
        date:2018-01-02
    },
    {
        name:'DEF',
        value:70,
        date:2018-01-01
    },
    {
        name:'DEF',
        value:22,
        date:2018-01-02
    }
]

转换为

Answer 1

您可以很容易地将数据转换为数据帧，然后pivot来实现您想要的布局：

import pandas as pd

myList = [{"name":'ABC', "value":35, "date":"2018-01-01"},{"name":'ABC', "value":30, "date":"2018-01-02"},{"name":'DEF', "value":70, "date":"2018-01-01"},{"name":'DEF', "value":22, "date":"2018-01-02"}]

df = pd.DataFrame(data=myList)

df = df.pivot(index = "date", columns = "name")

^{pr2}$