python两个二维list按照指定的列，第3,4,6列排序,把第2个list分组排序后时间最大的数据插入到第一个list

[C罗子]

2个二维list的数据如下：

list1：

[['04',50,'Tokyo','apple',32.5,20191005],
['06',40,'Tokyo','apple',32.5,20191006],
['01',55,'Tokyo','apple',33.5,20191007],
['04',23,'Tokyo','apple',34.5,20191008],
['04',40,'Tokyo','apple',32.0,20191009],
['04',50,'Tokyo','banana',19.5,20191002],
['06',40,'Tokyo','banana',39.5,20191003],
['01',55,'Tokyo','banana',45.5,20191004],
['04',23,'Tokyo','banana',47.5,20191005],
['04',40,'Tokyo','banana',30.0,20191006],
['07',20,'Usaka','apple',44.5,20191001],
['06',22,'Usaka','apple',44.5,20191002],
['03',15,'Usaka','apple',45.5,20191003],
['04',22,'Usaka','apple',65.3,20191004],
['05',87,'Usaka','apple',80.2,20191005],
['04',20,'Usaka','banana',44.5,20191023],
['16',22,'Usaka','banana',44.5,20191023],
['23',15,'Usaka','banana',45.5,20191024],
['14',22,'Usaka','banana',65.3,20191024],
['01',87,'Usaka','banana',80.2,20191025]]

list2:

[['09',301,'Tokyo','apple','A',20191005],
['09',285,'Tokyo','apple','A',20191006],
['09',50,'Tokyo','apple','A',20191007],
['09',120,'Tokyo','apple','A',20191008],
['09',530,'Tokyo','apple','A',20191009],
['09',55,'Tokyo','banana','A',20191004],
['09',23,'Tokyo','banana','A',20191005],
['09',40,'Tokyo','banana','A',20191006],
['09',22,'Usaka','apple','A',20191004],
['09',87,'Usaka','apple','A',20191005],
['09',20,'Usaka','banana','A',20191023],
['09',22,'Usaka','banana','A',20191023],
['09',15,'Usaka','banana','A',20191024],
['09',87,'Usaka','banana','A',20191025],
['09',68,'W1','apple','A',20191114],
['09',68,'W1','apple','A',20191116],
['09',68,'W2','banana','A',20191114],
['09',68,'W2','banana','A',20191116]]

我想把list2中按照第3列和第4列分组排序后的数据取第6列最大的那条数据，一共能取出6条：

[['09',530,'Tokyo','apple','A',20191009],
['09',40,'Tokyo','banana','A',20191006],
['09',87,'Usaka','apple','A',20191005],
['09',87,'Usaka','banana','A',20191025],
['09',68,'W1','apple','A',20191116],
['09',68,'W2','banana','A',20191116]]

把这4条数据插入到list1中,按照第3列和第4列分组排序后的每组的第一列：
插入后list3的样子(新声明一个list3)：

[['09',530,'Tokyo','apple','A',20191009],
['04',50,'Tokyo','apple',32.5,20191005],
['06',40,'Tokyo','apple',32.5,20191006],
['01',55,'Tokyo','apple',33.5,20191007],
['04',23,'Tokyo','apple',34.5,20191008],
['04',40,'Tokyo','apple',32.0,20191009],
['09',40,'Tokyo','banana','A',20191006],
['04',50,'Tokyo','banana',19.5,20191002],
['06',40,'Tokyo','banana',39.5,20191003],
['01',55,'Tokyo','banana',45.5,20191004],
['04',23,'Tokyo','banana',47.5,20191005],
['04',40,'Tokyo','banana',30.0,20191006],
['09',87,'Usaka','apple','A',20191005],
['07',20,'Usaka','apple',44.5,20191001],
['06',22,'Usaka','apple',44.5,20191002],
['03',15,'Usaka','apple',45.5,20191003],
['04',22,'Usaka','apple',65.3,20191004],
['05',87,'Usaka','apple',80.2,20191005],
['09',87,'Usaka','banana','A',20191025]
['04',20,'Usaka','banana',44.5,20191023],
['16',22,'Usaka','banana',44.5,20191023],
['23',15,'Usaka','banana',45.5,20191024],
['14',22,'Usaka','banana',65.3,20191024],
['01',87,'Usaka','banana',80.2,20191025],
['09',68,'W1','apple','A',20191116],
['09',68,'W2','banana','A',20191116]]

请问用python语言如何实现？

[看着奢扣]

用pandas 分组算一下呗 查查API很简单

[jmzl]

处理这种规律的东西没有什么难度，就是不是很明白你的意思