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
Not necessarily the most efficient, but one of the shortest and most readable using C++: std::to_string(num).length()
Another version of a hash with a key for each element in your array and value for the count of each element a = [ 1, 2, 3, 3, 4, 3] h = Hash.new(0) a.each { | v | h.store(v, h[v]+1) } # h = { 3=>3, 2=>1, 1=>1, 4=>1 }
For a very quick estimate: SELECT reltuples FROM pg_class WHERE relname=”my_table”; There are several caveats, though. For one, relname is not necessarily unique in pg_class. There can be multiple tables with the same relname in multiple schemas of the database. To be unambiguous: SELECT reltuples::bigint FROM pg_class WHERE oid = ‘my_schema.my_table’::regclass; If you do not … Read more
You can use XL4 macros (Excel formula) to count up cells with different backcolor or even font colour in excel 🙂 See this LINK. For Font color the type_num is 24. And for backcolor we will use 63 Open the Name Manager Give a name. Say BackColor Type this formula in Refers To =GET.CELL(63,OFFSET(INDIRECT(“RC”,FALSE),-1,0)) and … Read more
int divisor = AllMyControls.Where(p => p.IsActiveUserControlChecked).Count() or simply int divisor = AllMyControls.Count(p => p.IsActiveUserControlChecked); Since you are a beginner, it would be worthwhile to take a look at Enumerable documentation
try this; select gid from `gd` group by gid having count(*) > 10 order by lastupdated desc
Here are couple of ways to reshape your data df In [27]: df Out[27]: Col X Col Y 0 class 1 cat 1 1 class 2 cat 1 2 class 3 cat 2 3 class 2 cat 3 1) Using pd.crosstab() In [28]: pd.crosstab(df[‘Col X’], df[‘Col Y’]) Out[28]: Col Y cat 1 cat 2 cat … Read more
In Postgres 9.4 or later, use the aggregate FILTER option. Typically cleanest and fastest: SELECT category , count(*) FILTER (WHERE question1 = 0) AS zero , count(*) FILTER (WHERE question1 = 1) AS one , count(*) FILTER (WHERE question1 = 2) AS two FROM reviews GROUP BY 1; Details for the FILTER clause: Aggregate columns … Read more
$array = array(“Kyle”,”Ben”,”Sue”,”Phil”,”Ben”,”Mary”,”Sue”,”Ben”); $counts = array_count_values($array); echo $counts[‘Ben’];