Databases
StackOverflow2013
Postsdbo
POOccurence of elements in the file with c# and Dictionary
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOccurence of elements in the file with c# and Dictionary
    text
    copied!<p>I have a file as</p> <pre class="lang-none prettyprint-override"><code>outlook temperature Humidity Windy PlayTennis sunny hot high false N sunny hot high true N overcast hot high false P rain mild high false P rain cool normal false P rain cool normal true N </code></pre> <p>I want to find occurence of each element e.g sunny: 2 rain: 3 overcast:1 hot: 3 and so on</p> <p>My code is:</p> <pre><code> string file = openFileDialog1.FileName; var text1 = File.ReadAllLines(file); StringBuilder str = new StringBuilder(); string[] lines = File.ReadAllLines(file); string[] nonempty=lines.Where(s =&gt; s.Trim(' ')!="") .Select(s =&gt; Regex.Replace(s, @"\s+", " ")).ToArray(); string[] colheader = null; if (nonempty.Length &gt; 0) colheader = nonempty[0].Split(); else return; var linevalue = nonempty.Skip(1).Select(l =&gt; l.Split()); int colcount = colheader.Length; Dictionary&lt;string, string&gt; colvalue = new Dictionary&lt;string, string&gt;(); for (int i = 0; i &lt; colcount; i++) { int k = 0; foreach (string[] values in linevalue) { if(! colvalue.ContainsKey(values[i])) { colvalue.Add(values[i],colheader[i]); } label2.Text = label2.Text + k.ToString(); } } foreach (KeyValuePair&lt;string, string&gt; pair in colvalue) { label1.Text += pair.Key+ "\n"; } </code></pre> <p>Output I get here is sunny overcast rain hot mild cool N P true false</p> <p>I also want to find the occurence, which I am unable to get. Can u please help me out here.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload