ChatGPT解决这个技术问题 Extra ChatGPT

How do you sort a dictionary by value?

I often have to sort a dictionary (consisting of keys & values) by value. For example, I have a hash of words and respective frequencies that I want to order by frequency.

There is a SortedList which is good for a single value (say frequency), that I want to map back to the word.

SortedDictionary orders by key, not value. Some resort to a custom class, but is there a cleaner way?

Aside from just sorting the dictionary (as in the accepted answer), you could also just create an IComparer that does the trick (true that it accepts a key to compare, but with a key, you can get a value). ;-)
@BrainSlugs83 - "create an IComparer" is not a complete solution. Please clarify how that IComparer would be used, to produce an ordered result.
Sorted dictionary doesn't make any sense as you access a dictionary by key. If you want a sorted list of all keys and values, convert it to a list, then sort it.

P
Peter Mortensen

Use LINQ:

Dictionary<string, int> myDict = new Dictionary<string, int>();
myDict.Add("one", 1);
myDict.Add("four", 4);
myDict.Add("two", 2);
myDict.Add("three", 3);

var sortedDict = from entry in myDict orderby entry.Value ascending select entry;

This would also allow for great flexibility in that you can select the top 10, 20 10%, etc. Or if you are using your word frequency index for type-ahead, you could also include StartsWith clause as well.


How can I change sortedDict back into a Dictionary<string, int>? Posted new SO question here: stackoverflow.com/questions/3066182/…
Sadly this does not work on VS2005 because of .net framework 2.0 there (no LINQ). It is good to have also the Bambrick's answer.
I'm not sure if it always works because iterating over dictionary doesn't guarantee that KeyValuePairs are "pulled" in the same order they have been inserted. Ergo, it doesn't matter if you use orderby in LINQ because Dictionary can change order of inserted elements. It usually works as expected but there is NO GUARANTEE, especially for large dictionaries.
Return type should be IEnumerable<KeyValuePair<TKey, TValue>> or an OrderedDictionary<TKey, TValue>. Or one should use a SortedDictionary from the start. For a plain Dictionary the MSDN clearly states "The order in which the items are returned is undefined.". It seems that @rythos42 's latest edit is to blame. :)
Please disregard all suggestions of .ToDictionary - standard dictionaries do not guarantee a sort order
P
Peter Mortensen

Use:

using System.Linq.Enumerable;
...
List<KeyValuePair<string, string>> myList = aDictionary.ToList();

myList.Sort(
    delegate(KeyValuePair<string, string> pair1,
    KeyValuePair<string, string> pair2)
    {
        return pair1.Value.CompareTo(pair2.Value);
    }
);

Since you're targeting .NET 2.0 or above, you can simplify this into lambda syntax -- it's equivalent, but shorter. If you're targeting .NET 2.0 you can only use this syntax if you're using the compiler from Visual Studio 2008 (or above).

var myList = aDictionary.ToList();

myList.Sort((pair1,pair2) => pair1.Value.CompareTo(pair2.Value));

I used this solution (Thanks!) but was confused for a minute until I read Michael Stum's post (and his code snippet from John Timney) and realised that myList is a secondary object, a list of KeyValuePairs, which is created from the dictionary, and then sorted.
it it's one liner - You don't need braces. it can be rewritten as myList.Sort((x,y)=>x.Value.CompareTo(y.Value));
To sort descending switch the x and the y on the comparison: myList.Sort((x,y)=>y.Value.CompareTo(x.Value));
I think it's worth noting that this requires Linq for the ToList extension method.
You guys are waaaay over complicating this -- a dictionary already implements IEnumerable, so you can get a sorted list like this: var mySortedList = myDictionary.OrderBy(d => d.Value).ToList();
U
U12-Forward

You could use:

var ordered = dict.OrderBy(x => x.Value).ToDictionary(x => x.Key, x => x.Value);

This is a good solution, but it should have this right before the ending semi-colon: .ToDictionary(pair => pair.Key, pair => pair.Value);
I prefer this one, clean and simple. @Gravitas: I agree, and framework version was not mentioned in the OP.
@theJerm by putting the sorted items back to a dictionary is the order guaranteed then? It might work today, but it's not guaranteed.
Using the 4.5 framework, just verified that it does not require a cast back to dictionary.
There should not be a cast back to a dictionary because dictionaries are not ordered. There's no guarantee the KeyValuePairs will stay in the order you want.
A
Alexander

Looking around, and using some C# 3.0 features we can do this:

foreach (KeyValuePair<string,int> item in keywordCounts.OrderBy(key=> key.Value))
{ 
    // do something with item.Key and item.Value
}

This is the cleanest way I've seen and is similar to the Ruby way of handling hashes.


Don't forget to add the System.Linq namespace when using this syntax.
(for KeyValuePair<string, int> item in keywordCounts.OrderBy(key => key.Value) select item).ToDictionary(t => t.Key, t => t.Value) - just a small addition to your answer :) Thanks, btw :)
@AndriusNaruševičius: If you add the resulting items back into a dictionary, you will destroy the order, as dictionaries are not guaranteed to be ordered in any particular fashion.
E
E_net4 - Mr Downvoter

You can sort a Dictionary by value and save it back to itself (so that when you foreach over it the values come out in order):

dict = dict.OrderBy(x => x.Value).ToDictionary(x => x.Key, x => x.Value);

Sure, it may not be correct, but it works. Hyrum's Law means that this will very likely continue to work.


You can also use OrderByDescending if you want to sort into a descending list.
This "working" is not guaranteed. Its an implementation detail. It need not work other times. Wrong answer, downvoted.
The Dictionary output is NOT guaranteed to have any particular sort order.
I would be quite concerned to see this in production code. It is not guaranteed and could change at any time. Not that I shy away from pragmatic solutions, it just shows a lack of understanding of the data structure imo.
@mxmissile - While that "works", given that Dictionary does not guarantee order, you should have omitted .ToDictionary(...). That turns it back into a dictionary. dict.OrderBy(...) is all that should be done; that yields an enumerator, as desired.
P
Palle Due

On a high level, you have no other choice than to walk through the whole Dictionary and look at each value.

Maybe this helps: http://bytes.com/forum/thread563638.html Copy/Pasting from John Timney:

Dictionary<string, string> s = new Dictionary<string, string>();
s.Add("1", "a Item");
s.Add("2", "c Item");
s.Add("3", "b Item");

List<KeyValuePair<string, string>> myList = new List<KeyValuePair<string, string>>(s);
myList.Sort(
    delegate(KeyValuePair<string, string> firstPair,
    KeyValuePair<string, string> nextPair)
    {
        return firstPair.Value.CompareTo(nextPair.Value);
    }
);

Perfect non-Linq solution. It never ceases to amaze me how people feel the need to use Linq even when it's absolutely not required to solve the problem. With C# 3, I believe you can also simplify the Sort to just use a lambda: myList.Sort((x, y) => x.Value.CompareTo(y.Value));
R
Roger Willcocks

You'd never be able to sort a dictionary anyway. They are not actually ordered. The guarantees for a dictionary are that the key and value collections are iterable, and values can be retrieved by index or key, but there is no guarantee of any particular order. Hence you would need to get the name value pair into a list.


A sorted dictionary could yield a list of key-value pairs though.
@recursive Any dictionary should yield that. Interesting to note that my answer, which is correct, but incomplete (could have done what the better examples did) is voted below an invalid answer that would result in exceptions on duplicate values in the original dictionary (keys are unique, values are not guaranteed to be)
This is the bes answer, because Dictionary is not sortable. It hashes Keys and you can perform an extremely fast seek operation on it.
@NetMage Yes. But the other part of the problem is that they wanted ordered by Value. And you could only do that by swapping Key and Value. And Value is not necessarily unique, but Key must be.
Yes, but I think your answer is incorrect because of the absolute statements in it.
n
nawfal

You do not sort entries in the Dictionary. Dictionary class in .NET is implemented as a hashtable - this data structure is not sortable by definition.

If you need to be able to iterate over your collection (by key) - you need to use SortedDictionary, which is implemented as a Binary Search Tree.

In your case, however the source structure is irrelevant, because it is sorted by a different field. You would still need to sort it by frequency and put it in a new collection sorted by the relevant field (frequency). So in this collection the frequencies are keys and words are values. Since many words can have the same frequency (and you are going to use it as a key) you cannot use neither Dictionary nor SortedDictionary (they require unique keys). This leaves you with a SortedList.

I don't understand why you insist on maintaining a link to the original item in your main/first dictionary.

If the objects in your collection had a more complex structure (more fields) and you needed to be able to efficiently access/sort them using several different fields as keys - You would probably need a custom data structure that would consist of the main storage that supports O(1) insertion and removal (LinkedList) and several indexing structures - Dictionaries/SortedDictionaries/SortedLists. These indexes would use one of the fields from your complex class as a key and a pointer/reference to the LinkedListNode in the LinkedList as a value.

You would need to coordinate insertions and removals to keep your indexes in sync with the main collection (LinkedList) and removals would be pretty expensive I'd think. This is similar to how database indexes work - they are fantastic for lookups but they become a burden when you need to perform many insetions and deletions.

All of the above is only justified if you are going to do some look-up heavy processing. If you only need to output them once sorted by frequency then you could just produce a list of (anonymous) tuples:

var dict = new SortedDictionary<string, int>();
// ToDo: populate dict

var output = dict.OrderBy(e => e.Value).Select(e => new {frequency = e.Value, word = e.Key}).ToList();

foreach (var entry in output)
{
    Console.WriteLine("frequency:{0}, word: {1}",entry.frequency,entry.word);
}

This is actually the best answer, from a Computer Science perspective. It's not the simplest or the fastest, and it requires one to evaluatethe actual problem at hand, instead of trying to give a non existent "quick recipe". I suppose that many programmers are OK with a solution that "seems to work". Until it doesn't. I wish that many would know better...
it was worthful for me to reach here (end).
U
U12-Forward

You could use:

Dictionary<string, string> dic= new Dictionary<string, string>();
var ordered = dic.OrderBy(x => x.Value);
return ordered.ToDictionary(t => t.Key, t => t.Value);

m
mythz

Or for fun you could use some LINQ extension goodness:

var dictionary = new Dictionary<string, int> { { "c", 3 }, { "a", 1 }, { "b", 2 } };
dictionary.OrderBy(x => x.Value)
  .ForEach(x => Console.WriteLine("{0}={1}", x.Key,x.Value));

P
Peter Mortensen

Sorting a SortedDictionary list to bind into a ListView control using VB.NET:

Dim MyDictionary As SortedDictionary(Of String, MyDictionaryEntry)

MyDictionaryListView.ItemsSource = MyDictionary.Values.OrderByDescending(Function(entry) entry.MyValue)

Public Class MyDictionaryEntry ' Need Property for GridViewColumn DisplayMemberBinding
    Public Property MyString As String
    Public Property MyValue As Integer
End Class

XAML:

<ListView Name="MyDictionaryListView">
    <ListView.View>
        <GridView>
            <GridViewColumn DisplayMemberBinding="{Binding Path=MyString}" Header="MyStringColumnName"></GridViewColumn>
            <GridViewColumn DisplayMemberBinding="{Binding Path=MyValue}" Header="MyValueColumnName"></GridViewColumn>
         </GridView>
    </ListView.View>
</ListView>

T
Tilman B. aka Nerdyyy

The other answers are good, if all you want is to have a "temporary" list sorted by Value. However, if you want to have a dictionary sorted by Key that automatically synchronizes with another dictionary that is sorted by Value, you could use the Bijection<K1, K2> class.

Bijection<K1, K2> allows you to initialize the collection with two existing dictionaries, so if you want one of them to be unsorted, and you want the other one to be sorted, you could create your bijection with code like

var dict = new Bijection<Key, Value>(new Dictionary<Key,Value>(), 
                               new SortedDictionary<Value,Key>());

You can use dict like any normal dictionary (it implements IDictionary<K, V>), and then call dict.Inverse to get the "inverse" dictionary which is sorted by Value.

Bijection<K1, K2> is part of Loyc.Collections.dll, but if you want, you could simply copy the source code into your own project.

Note: In case there are multiple keys with the same value, you can't use Bijection, but you could manually synchronize between an ordinary Dictionary<Key,Value> and a BMultiMap<Value,Key>.


Similar to http://stackoverflow.com/questions/268321 but can replace each Dictionary with SortedDictionary. Although the answers look not to support duplicate values (assumes 1 to 1).
T
Tanjim Ahmed Khan

Actually in C#, dictionaries don't have sort() methods. As you are more interested in sort by values, you can't get values until you provide them key. In short, you need to iterate through them using LINQ's OrderBy(),

var items = new Dictionary<string, int>();
items.Add("cat", 0);
items.Add("dog", 20);
items.Add("bear", 100);
items.Add("lion", 50);

// Call OrderBy() method here on each item and provide them the IDs.
foreach (var item in items.OrderBy(k => k.Key))
{
    Console.WriteLine(item);// items are in sorted order
}

You can do one trick:

var sortedDictByOrder = items.OrderBy(v => v.Value);

or:

var sortedKeys = from pair in dictName
            orderby pair.Value ascending
            select pair;

It also depends on what kind of values you are storing: single (like string, int) or multiple (like List, Array, user defined class). If it's single you can make list of it and then apply sort.
If it's user defined class, then that class must implement IComparable, ClassName: IComparable<ClassName> and override compareTo(ClassName c) as they are more faster and more object oriented than LINQ.


R
RajeshKdev

Suppose we have a dictionary as

   Dictionary<int, int> dict = new Dictionary<int, int>();
   dict.Add(21,1041);
   dict.Add(213, 1021);
   dict.Add(45, 1081);
   dict.Add(54, 1091);
   dict.Add(3425, 1061);
   sict.Add(768, 1011);

1) you can use temporary dictionary to store values as :

        Dictionary<int, int> dctTemp = new Dictionary<int, int>();

        foreach (KeyValuePair<int, int> pair in dict.OrderBy(key => key.Value))
        {
            dctTemp .Add(pair.Key, pair.Value);
        }

J
Jaydeep Shil

Required namespace : using System.Linq;

Dictionary<string, int> counts = new Dictionary<string, int>();
counts.Add("one", 1);
counts.Add("four", 4);
counts.Add("two", 2);
counts.Add("three", 3);

Order by desc :

foreach (KeyValuePair<string, int> kvp in counts.OrderByDescending(key => key.Value))
{
// some processing logic for each item if you want.
}

Order by Asc :

foreach (KeyValuePair<string, int> kvp in counts.OrderBy(key => key.Value))
{
// some processing logic for each item if you want.
}

Upvoted for clear use of OrderByDescending.
P
Poul Bak

The easiest way to get a sorted Dictionary is to use the built in SortedDictionary class:

//Sorts sections according to the key value stored on "sections" unsorted dictionary, which is passed as a constructor argument
System.Collections.Generic.SortedDictionary<int, string> sortedSections = null;
if (sections != null)
{
    sortedSections = new SortedDictionary<int, string>(sections);
}

sortedSections will contain the sorted version of sections


As you mention in your comment, SortedDictionary sorts by keys. The OP wants to sort by value. SortedDictionary doesn't help in this case.
Well... If he/she (you) can, just set the values as the keys. I timed the operations and sorteddictionary() always won out by at least 1 microsecond, and it's much easier to manage (as the overhead of converting it back into something easily interacted with and managed similarly to a Dictionary is 0 (it is already a sorteddictionary)).
@mbrownnyc - nope, doing that requires the assumption or precondition that the VALUES are unique, which is not guaranteed.
P
PeterK

Sort and print:

var items = from pair in players_Dic
                orderby pair.Value descending
                select pair;

// Display results.
foreach (KeyValuePair<string, int> pair in items)
{
    Debug.Log(pair.Key + " - " + pair.Value);
}

Change descending to acending to change sort order


F
Franz Kurt

A dictionary by definition is an unordered associative structure that contains only values and keys in a hashable way. In other words has not a previsible way to orderer a dictionary.

For reference read this article from python language.

Link python data structures


V
Vineet Agarwal

Best way:

var list = dict.Values.OrderByDescending(x => x).ToList();
var sortedData = dict.OrderBy(x => list.IndexOf(x.Value));

T
Tisho

You can sort the Dictionary by value and get the result in dictionary using the code below:

Dictionary <<string, string>> ShareUserNewCopy = 
       ShareUserCopy.OrderBy(x => x.Value).ToDictionary(pair => pair.Key,
                                                        pair => pair.Value);                                          

By putting the sorted items back into a dictionary, they are no longer guaranteed to be sorted when you enumerate the new dictionary.
And why are you adding this answer when this is already answered?
a
aggaton

Given you have a dictionary you can sort them directly on values using below one liner:

var x = (from c in dict orderby c.Value.Order ascending select c).ToDictionary(c => c.Key, c=>c.Value);