How to get the frequency of items from a list in C #

Question

I am trying to get the frequency of items stored in a list.

I store the following identifier in my list

ID
1
2
1
3
3
4
4
4

I need the following output:

ID| Count
1 | 2
2 | 1
3 | 2
4 | 3

In java you can do the following way.

for (String temp : hashset) 
    {
    System.out.println(temp + ": " + Collections.frequency(list, temp));
    }

Source: http://www.mkyong.com/java/how-to-count-duplicated-items-in-java-list/

How to get list counting frequency in C #?

Thank.

Answer 1

using System.Linq;

List<int> ids = //

foreach(var grp in ids.GroupBy(i => i))
{
    Console.WriteLine("{0} : {1}", grp.Key, grp.Count());
}

Answer 2

You can use LINQ

var frequency = myList.GroupBy(x => x).ToDictionary(x => x.Key, x => x.Count());

This will create an object Dictionarywhere the key is this IDand the value is the number of times the identifier appears.

Answer 3

int[] randomNumbers =  { 2, 3, 4, 5, 5, 2, 8, 9, 3, 7 };
Dictionary<int, int> dictionary = new Dictionary<int, int>();
Array.Sort(randomNumbers);

foreach (int randomNumber in randomNumbers) {
    if (!dictionary.ContainsKey(randomNumber))
        dictionary.Add(randomNumber, 1);
    else
        dictionary[randomNumber]++;
    }

    StringBuilder sb = new StringBuilder();
    var sortedList = from pair in dictionary
                         orderby pair.Value descending
                         select pair;

    foreach (var x in sortedList) {
        for (int i = 0; i < x.Value; i++) {
                sb.Append(x.Key+" ");
        }
    }

    Console.WriteLine(sb);
}