碟中碟山 2021-05-27 14:18 采纳率: 0%
浏览 42

python字典数据分组

数据如下:


data = [{'id':1,'Time': '2021-03-07 10:05:01.459000', 'key': 'B'},
{'id':2,'Time': '2021-03-07 10:05:01.459000', 'key': 'A'}, 
{'id':3,'Time': '2021-03-07 10:05:01.459000', 'key': 'B'}, 
{'id':4,'Time': '2021-03-07 10:05:01.659000', 'key': 'B'}, 
{'id':5,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':6,'Time': '2021-03-07 10:05:02.259000', 'key': 'C'}, 
{'id':7,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':8,'Time': '2021-03-07 10:05:02.659000', 'key': 'C'}, 
{'id':9,'Time': '2021-03-07 10:05:02.659000', 'key': 'B'}, ]




data2 = [
{'id':1,'Time': '2021-03-07 10:05:01.459000', 'key': 'B'},
{'id':2,'Time': '2021-03-07 10:05:01.459000', 'key': 'A'}, 
{'id':3,'Time': '2021-03-07 10:05:01.459000', 'key': 'B'}, 
{'id':4,'Time': '2021-03-07 10:05:01.659000', 'key': 'B'}, 
{'id':5,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':6,'Time': '2021-03-07 10:05:02.259000', 'key': 'C'}, 
{'id':7,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':8,'Time': '2021-03-07 10:05:02.659000', 'key': 'C'}, 
{'id':9,'Time': '2021-03-07 10:05:02.659000', 'key': 'B'},
{'id':10,'Time': '2021-03-07 10:06:01.459000', 'key': 'A'}, 
{'id':7,'Time': '2021-03-07 10:07:02.259000', 'key': 'B'}, 
{'id':8,'Time': '2021-03-07 10:07:02.659000', 'key': 'C'},
 ]


每一个key ,A,B,C 需要分到一个list

取第一个A后的B,C,  要求B,C为下一个A前,如图 取id为7的B,d为8的C,

data 得到数据应该是:
[
{'id':2,'Time': '2021-03-07 10:05:01.459000', 'key': 'A'},
{'id':7,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':8,'Time': '2021-03-07 10:05:02.659000', 'key': 'C'},
]



data2 得到数据应该是:
[
[{'id':2,'Time': '2021-03-07 10:05:01.459000', 'key': 'A'},
{'id':7,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':8,'Time': '2021-03-07 10:05:02.659000', 'key': 'C'},],

[[{'id':2,'Time': '2021-03-07 10:05:01.459000', 'key': 'A'},
{'id':7,'Time': '2021-03-07 10:05:02.259000', 'key': 'B'}, 
{'id':8,'Time': '2021-03-07 10:05:02.659000', 'key': 'C'},],
]

 

 

 

  • 写回答

3条回答 默认 最新

  • CSDN专家-黄老师 2021-05-27 14:41
    关注

    你这个分组规律是怎样的?

    评论

报告相同问题?