Python pandas 将对象列表转换为 DataFrame

Question

这个问题已经有答案了:

How can I pivot a dataframe? (5 个回答)

已关闭 5 年前。

是否有一种内置方法可以将 Python 中的对象列表转换为 Pandas DataFrame。

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

您可以轻松地将数据转换为数据框，然后透视以实现您想要的布局:

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")

>>> df
           value    
name         ABC DEF
date                
2018-01-01    35  70
2018-01-02    30  22