python - 将熊猫数据框转换为所需的选择字典

Question

我是将熊猫数据框转换为 json 对象的新手。我有一个数据框：

转换后预期的 json 输出是这样的。

{
  "Name": {
    "id": "Max",
  },
  "Favorites" : [
        {
            "id":"Apple",
            "priority":"High",
            "Count":"4"
        },
        {
            "id":"Oranges",
            "priority":"Medium",
            "Count":"2"
        },
        {
            "id":"Banana",
            "priority":"Low",
            "Count":"1"
        }
    ]
}

标签： pythonjson

Answer 1

这是一个免费赠品。希望它可以帮助您学习如何在将来自己编写它:)

output = []


for index, row in df.iterrows():
    entry = {
        "Name": {
            "id": row['Names']
        },
        "Favorites": [
            {
                "id": row['High_Priority_Goods_Name'],
                "priority": "High",
                "count": row['High_Priority_Goods_Count']
            },
            {
                "id": row['Medium_Priority_Goods_Name'],
                "priority": "Medium",
                "count": row['Medium_Priority_Goods_Count']
            },
            {
                "id": row['Low_Priority_Goods_Name'],
                "priority": "Low",
                "count": row['Low_Priority_Goods_Count']
            }
        ]
    }
    output.append(entry)

print(output)