使用每个唯一列的嵌套json将csv转换为json

Question

我有这样一个csv文件：

a   b   c   d   e   f
1   3   6   11  16  21
1   4   7   12  16  21
2   3   8   13  18  23
2   4   9   14  18  23
2   5   10  15  18  23

我想从这个csv生成json，json看起来像

{
 {"a":1,
 "data":[{"b":3,"c":6,"d":11},{"b":4,"c":7,"d":12}],
 "e":16,
 "f":21},
{"a":2,
 "data":[{"b":3,"c":8,"d":13},{"b":4,"c":9,"d":14}, 
 {"b":5,"c":10,"d":15}],
 "e":18,
 "f":23}
}

这里e和f对于每个a是固定的，只有b，c，d是变化的。如何使用python实现这一点。你知道吗

Answer 1

将^{}与^{}和^{}一起用于嵌套词典，然后通过^{}转换为json：

j = (df.groupby(['a','e','f'])['b','c','d']
       .apply(lambda x: x.to_dict('r'))
       .reset_index(name='data')
       .to_json(orient='records')
       )

---

print (j)

[{
    "a": 1,
    "e": 16,
    "f": 21,
    "data": [{
        "b": 3,
        "c": 6,
        "d": 11
    }, {
        "b": 4,
        "c": 7,
        "d": 12
    }]
}, {
    "a": 2,
    "e": 18,
    "f": 23,
    "data": [{
        "b": 3,
        "c": 8,
        "d": 13
    }, {
        "b": 4,
        "c": 9,
        "d": 14
    }, {
        "b": 5,
        "c": 10,
        "d": 15
    }]
}]