我有数据帧,如下所示.
id | name | code | date | Additional info |
---|---|---|---|---|
01 | shirt | xyz123 | 2022-01-01 | [{'name': 'phone', 'code': 'ph123'}, {'name': 'car', 'code': 'cx2022'}, {}] |
02 | bike | bk001 | 2022-12-10 | [{}, {}, {}] |
03 | phone | ph987 | 2023-02-10 | [{'name': 'shirt', 'code': 'xyz456'}] |
我想将每个JSON的附加信息列和赋值分别取消嵌套到名称列和代码列中.预期输出如下所示.新添加的行在取消嵌套的附加信息列后加粗.在最终输出中,附加信息列将被删除.
Expected DataFrame output:个
id | name | code | date |
---|---|---|---|
01 | shirt | xyz123 | 2022-01-01 |
01 | phone | ph123 | 2022-01-01 |
01 | car | cx2022 | 2022-01-01 |
02 | bike | bk001 | 2022-12-10 |
03 | phone | ph987 | 2023-02-10 |
03 | shirt | xyz456 | 2023-02-10 |
有人能帮我解决这个挑战吗? 谢谢.