Loading

Comparing 2 dictionaries and removing duplicates

Comparing 2 dictionaries and removing duplicates

jo

13y2.7kVisual Basic .NET

Hi All,

I have 3 dictionaries. I am trying to compare dict1 and dict2 , remove the same entries from dict1 and sending as an output to dict3.

Dict1= ["Test1", "testing"] ["Test2", "testing76"] ["Test3", "testin67g"] ["Test4", "tests67ing"] ["Test5", "tessadting"] ["Test8", "tessadting"]

Dict2= ["Test1", "testin67g"] ["Test2", "testing 67"] ["test3", "testing6"] ["test4", "testing 213"] ["test7", "testing 21"]

Dict3= ["Test5", "tessadting"] ["Test8", "tessadting"]-------->Output needed

My line of code is,

Dictionary dict3= Dict1.Keys.Except(Dict2.Keys).ToDictionary(t => t, t => dict1[t]);

But i dont get the correct output. Kindly help.

Thanks
Jo

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
The LINQ expression looks OK but you might be getting unexpected output because the case of some of the keys in Dict2 ("test3", "test4") is not the same as in Dict1 ("Test3", "Test4").

This worked fine for me:

using System;
using System.Collections.Generic;
using System.Linq;

class Test
{
static void Main()
{
var Dict1 = new Dictionary();
Dict1.Add("Test1", "testing");
Dict1.Add("Test2", "testing76");
Dict1.Add("Test3", "testin67g");
Dict1.Add("Test4", "tests67ing");
Dict1.Add("Test5", "tessadting");
Dict1.Add("Test8", "tessadting");

var Dict2 = new Dictionary();
Dict2.Add("Test1", "testin67g");
Dict2.Add("Test2", "testing 67");
Dict2.Add("Test3", "testing6");
Dict2.Add("Test4", "testsing 213");
Dict2.Add("Test7", "testing 21");

var Dict3 = Dict1.Keys.Except(Dict2.Keys).ToDictionary(t => t , t => Dict1[t]);

foreach(var kvp in Dict3)
{
Console.WriteLine("{0} : {1}", kvp.Key, kvp.Value);
}

Console.ReadKey();
}
}

The output is:

Test5 : tessadting
Test8 : tessadting
jo13y ago
Hi Vulpes,

Thank you for your response.

Yes you are right. My code is correct, my dictionary returned different values.

I have changed the query. Now its working fine.

Thanks,
Jo