Find max value in a group of subsublists in a specific order

sql select max value for each group
sql group by having max
sql max group by
sql max group by multiple columns
find max value in group
sql select top 1 from each group
sql max(count group by)
sql server get max value for each group

I have the following list:

L=[
[ [4.0, 4.0] , [1.0, 2.0, 3.0] ],
[ [4.0, 5.0] , [1.0          ] ]
]

I need to get the max value of each 'column' of sublists. In other words I must get:

result=[5.0, 3.0]

...because 5.0 is the max value in the first 'column' of subsublists:

[4.0, 4.0]
[4.0, 5.0]

...and 3.0 is the max value in second columns of subsublists:

[1.0, 2.0, 3.0]
[1.0]

Number of sublists may change, as well as number of subsublists and values inside subsublists, I'm afraid. I've been trying for hours but I'm just able to iterate in the first value of subsublists, therefore I'm missing the max values located at the end of their respective subsublists :-( Thank you in advance.

PS.: Unfortuntately I cannot use Pandas or Numpy...


You can use zip

L= [[[4.0, 4.0], [1.0, 2.0, 3.0]], [[4.0, 5.0], [1.0]]]
new_l = [max(c for b in i for c in b) for i in zip(*L)]

Output:

[5.0, 3.0]

python, I have the following list: L=[ [ [4.0, 4.0] , [1.0, 2.0, 3.0] ], [ [4.0, 5.0] , [1.0 ] ] ]. I need to get the max value of each 'column' of sublists. In other words I must get: SQL MAX() function with GROUP by, ORDER by: How the GROUP BY and ORDER BY clause along with the SQL MAX() can be used to find the maximum value of a column over each group.


You can use:

In [140]: import itertools as it

In [141]: [max(max(g) for g in e if g) for e in it.zip_longest(*L)]
Out[141]: [5.0, 3.0]

SQL MAX() function with GROUP by, ORDER by, In this page we are discussing, how the GROUP BY clause along with the SQL MAX() can be used to find the maximum value of a column over  This is a slightly harder problem to solve. Finding a single row from each group is easy with SQL’s aggregate functions (MIN(), MAX(), and so on). Finding the first several from each group is not possible with that method because aggregate functions only return a single value. Still, it’s possible to do.


Ugly solution using functools.partial:

list(map(max, zip(*map(partial(map, max), L))))
# [5.0, 3.0]

Here, map(partial(map, max), L) transforms each row by picking the maximum of each cell; zip performs the transpose; another map(max, ...) finds the maximum of each column.

Less ugly solution:

c1 = c2 = 0
for col1, col2 in L:
    c1 = max(c1, *col1)
    c2 = max(c2, *col2)
# c1 = 5; c2 = 3

Excel MAX function, Find max value in a group; Max formula for non-adjacent cells or ranges In Excel 2019 and Excel for Office 365, there is a special function  Finding max/min value in a group by applying pivot table There is another way that can quickly find the max or min value in each group by inserting a pivot table. 1. Select the data range, and then click Insert > Pivot Table > Pivot Table.


SQLite MAX: Get the Maximum Value in a Set, For example, you can use the MAX function to find the most expensive products, find the biggest item in its group, etc. The following illustrates the basic syntax of  “The ‘MAX’ and ‘MIN’ functions in and of themselves find the maximum or minimum value in the range of cells selected” Kasper Langmann , Co-founder of Spreadsheeto So whether we select a literal list of values like ‘=MAX(1,2,3,4,5)’ or a range of cell references containing values like ‘=MAX(A2:A6)’, the outcome is the same and no other criteria may be used to filter the results.


MySQL MAX Function, A) Using MySQL MAX() function to find the maximum value in a column example FROM payments GROUP BY customerNumber ORDER BY MAX(amount);. DAX Calculate the Max for a Group. Subscribe to RSS Feed. Email to a Friend. Report Inappropriate Content. ‎09-01-2016 10:24 AM. Hello! I have a problem and have a feeling a simple DAX formula can solve it. I would like the 'Desired Output' column to be the Max of the 'Check' column, evaluated for each Name. Any help is much appreciated, thanks.


MAX Function, Rows with a NULL value for the specified column are ignored. When the query contains a GROUP BY clause, returns one value for each combination of from region, region.r_nations as r_nations group by r_name order by r_name; Find the largest value for this column in the table. select max(c1) from t1; -- Find the  To find the maximum value in a range with specific criteria, you can use a basic array formula based on the IF function and MAX function. In the example shown, the formula in cell H8 is: Excel formula: Max if criteria match | Exceljet