How to count total item from two file

Sin Yee

hey..i got two text file and i need to total up the occurrance in tht two files..
For example:
my first file:
1 2 3 4
1 3 4

my second file:
1 3 4
2 5

After total up the item in this two file:
1: 3
2: 2
3: 3
4:3
using Dictionary <> to do this..hope someone will help me...thank you

7 Replies

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

Vulpes15y ago
If you mean in descending order by value rather than by key, then try this:

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Windows.Forms;

class Test
{
   static void Main()
   {
   string[] lines = (File.ReadAllLines("file1.txt").Concat(File.ReadAllLines("file2.txt"))).ToArray();

   var dict = new Dictionary();

   foreach(string line in lines)
   {
   string temp = line.Replace(" ",""); // get rid of spaces
   if (temp.Length == 0) continue; // ignore blank lines
   foreach(char c in temp)
   {
   string digit = c.ToString();
   if (dict.ContainsKey(digit))
   {
   dict[digit]++;
   }
   else
   {
   dict.Add(digit, 1);
   }
   }
   }

   string[] results = (from key in dict.Keys orderby dict[key] descending select key + ":" + dict[key]).ToArray();
   MessageBox.Show(String.Join("\r\n", results));
   }
}
0
Sin Yee15y ago
nono....i mean i got two files..
File 1 got two lines :
1 2 3 4
1 3 4
File 2 got two lines:
1 3 4
2 5
i need to count total value for each items in those two files
1:3
2:2
3:3
4:3
5:1
and sort in descending order.
0
Andrew Fenster15y ago
Are you asking how to open and read the files?
0
Sin Yee15y ago
but those two file is separate ..how to count like that..?
0
Andrew Fenster15y ago
The Dictionary part is pretty easy. To declare the dictionary:

Dictionary counter as new Dictionary();

Each time you count an object:

if (counter.ContainsKey(key)
    counter[key]++;
else
    counter.Add(key, 1);

To sort in descending order:

var items = from key in counter.Keys
                orderby counter[key] descending
                select key;

foreach (int key in items)
        Console.WriteLine("{0}: {1}", key, counter[key]);
0
Sin Yee15y ago
because i need to sort them in descending order..
0
Suthish Nair15y ago
why using Dictionary<>
0