我有以下格式的数据(每个包含3个列表的dict列表):
[{40258: [['2018-07-03T14:13:41'], ['Open'], ['Closed']]},
{40257: [['2018-07-03T13:47:55',
'2018-07-03T14:21:52',
'2018-07-04T11:56:44'],
['Open', 'In Progress', 'Waiting on 3rd Party'],
['In Progress', 'Waiting on 3rd Party', 'In Progress']]},
{40255: [['2018-07-03T13:12:58'], ['Open'], ['Closed']]},
{40250: [[], [], []]}]
我希望将上述数据转换为以下数据框:
key List1-1 List1-2 List1-3 List2-1 List2-2 List2-3 List3-1 List3-2 List3-3
40258 2018-07-03T14:13:41 nan nan 'Open' nan nan 'Closed' nan nan
40257 2018-07-03T13:47:55 2018-07-03T14:21:52 2018-07-04T11:56:44 'Open' 'In Progress' 'Waiting on 3rd Party' 'In Progress' 'Waiting on 3rd Party' 'In Progress'
40255 2018-07-03T13:12:58 nan nan 'Open' nan nan 'Closed' nan nan
40250 nan nan nan nan nan nan nan nan nan
我尝试了一个简单的pd.DataFrame
和pd.DataFrame.from_dict
但是我找不到解决方法来处理dict中的多个列表
非常感谢您的帮助。你知道吗
创建列表列表,然后使用pd.数据帧(数据、列)似乎是最简单的选择。你知道吗
我希望你能明白
输出
我想我可以分享我的解决方案:
输出:
相关问题 更多 >
编程相关推荐