Not the absolutely most efficient, but it works: var maxRepeatedItem = prod.GroupBy(x => x) .OrderByDescending(x => x.Count()) .First().Key; This is more efficient: var maxRepeatedItem = prod.GroupBy(x => x) .MaxBy(x => x.Count()) .First().Key; but it requires MoreLinq‘s extension MaxBy EDIT (as per comment) : If you want all the max repeated elements in case of ties, … Read more
You can very well express aggregate functions with only basic operators. It’s a pretty neat thing. Suppose we have a table T, and we’d like to find the maximum of its “value” field. First, we should take the cartesian product of T with itself — or rather with a copy of itself, T2. Then we … Read more
This should do it: SELECT report_id, computer_id, date_entered FROM reports AS a WHERE date_entered = ( SELECT MAX(date_entered) FROM reports AS b WHERE a.report_id = b.report_id AND a.computer_id = b.computer_id )
edit: .NET 6 introduced a new method var max = results.MaxBy(kvp => kvp.Value).Key; You should probably use that if you can. I think this is the most readable O(n) answer using standard LINQ. var max = results.Aggregate((l, r) => l.Value > r.Value ? l : r).Key; edit: explanation for CoffeeAddict Aggregate is the LINQ name … Read more
Use the all() function with a generator expression: >>> my_list1 = [30, 34, 56] >>> my_list2 = [29, 500, 43] >>> all(i >= 30 for i in my_list1) True >>> all(i >= 30 for i in my_list2) False Note that this tests for greater than or equal to 30, otherwise my_list1 would not pass the … Read more
Use the builtin function max. Example: max(2, 4) returns 4. Just for giggles, there’s a min as well…should you need it. 😛
Using C++11/C++0x compile flags, you can auto it = max_element(std::begin(cloud), std::end(cloud)); // C++11 Otherwise, write your own: template <typename T, size_t N> const T* mybegin(const T (&a)[N]) { return a; } template <typename T, size_t N> const T* myend (const T (&a)[N]) { return a+N; } See it live at http://ideone.com/aDkhW: #include <iostream> #include <algorithm> … Read more
Use GREATEST() E.g.: SELECT GREATEST(2,1); Note: Whenever if any single value contains null at that time this function always returns null (Thanks to user @sanghavi7)
Pandas has a rolling method for both Series and DataFrames, and that could be of use here: import pandas as pd lst = [6,4,8,7,1,4,3,5,7,8,4,6,2,1,3,5,6,3,4,7,1,9,4,3,2] lst1 = pd.Series(lst).rolling(5).max().dropna().tolist() # [8.0, 8.0, 8.0, 7.0, 7.0, 8.0, 8.0, 8.0, 8.0, 8.0, 6.0, 6.0, 6.0, 6.0, 6.0, 7.0, 7.0, 9.0, 9.0, 9.0, 9.0] For consistency, you can coerce each … Read more
getMaxValue(array); // get smallest number getMinValue(array); You are calling the methods but not using the returned values. System.out.println(getMaxValue(array)); System.out.println(getMinValue(array));