python将json文件展平为datafram

Question

如何使用一个单元格中的所有值将json展平到dataframe。你知道吗

文件具有以下结构

{"c_id": "C8", "cart": [{"p_id": "P53", "value": 644}, {"p_id": "P59", "value": 836}], "timestamp": "2018-12-01 12:51:00"}
{"c_id": "C17", "cart": [{"p_id": "P03", "value": 475}], "timestamp": "2018-12-01 20:31:00"}
{"c_id": "C19", "cart": [{"p_id": "P52", "value": 1001}], "timestamp": "2018-12-01 23:01:00"}

尝试了json.loads，json_normalize却没有运气

history = pd.read_json('../purchase.json', lines=True)

结果应该是数据帧，所有值都在单个单元格中