数据如下:
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'},],
]