Return CopyMost in LINQ

Question

I am not sure if CopyMost is the correct term to use here, but it's the term my client used ("CopyMost Data Protocol"). I have a set of data:

Increment    Value
.02            1
.04            1
.06            1
.08            2
.10            2

I need to return which Value occurs the most "CopyMost". In this case, the value is 1. Right now I had planned on writing an Extension Method for IEnumerable to do this for integer values. Is there something built into Linq that already does this easily? Or is it best for me to write an extension method that would look something like this

records.CopyMost(record => record.Value);

Answer 1

Well, here's one option:

var query = (from item in data
             group 1 by item.Value into g
             orderby g.Count() descending
             select g.Key).First();

Basically we're using GroupBy to group by the value - but all we're interested in for each group is the size of the group and the key (which is the original value). We sort the groups by size, and take the first element (the one with the most elements).

Does that help?

Answer 2

Jon beat me to it, but the term you're looking for is Modal Average.

Edit:

If I'm right In thinking that it's modal average you need then the following should do the trick:

var i = (from t in data
         group t by t.Value into aggr
         orderby aggr.Count() descending
         select aggr.Key).First();