need help for value in sortedList change to percentage

y s

i meet 2 problems now.
the 1st problem is ,i have a sortedList, i need to change the value into percentage.
my 2nd problem is after change to percentage.
when i key in minimum support, if the value which is not fulfill the minimum support, then will ignore it.

* total trasaction is 20=contentBox
my sortedLIst:
1: 11
2: 14
4: 5
3: 13
6: 3
5: 6
now i can change the value to percentage.the code are shown below.
but the problem is , it just can show value only, i want the output is like this:
1: 55
2: 70
4: 25
3: 65
6: 15
5: 30

double v2;
richTextBox13.Clear();
foreach (String sorting2 in sortList1.Keys)
{
if (!(sortList11.ContainsKey(sorting2)))
{
sortList1.TryGetValue(sorting2, out v2);

sortList11.Add(sorting2, v2);
double Count1 = (double)sortList11[sorting2];
sortList11[sorting2] = (v2 / ContentBox.Lines.Length)*100;

}
richTextBox13.AppendText(sortList11[sorting2].ToString() + "\n");
}
       double[] store = new double[richTextBox13.Lines.Length];
        int al = 0;
            foreach (double abv in sortList11.Values)
            {
                store[al] = abv;
                al++;
            }
            string min_supp = textBox9.Text;
            double min = Double.Parse(min_supp);
            textBox4.Text = textBox9.Text;
            string output = "";

            for (int prune = 0; prune < richTextBox13.Lines.Length; prune++)
            {
                if (store[prune] >= min)
                {
                 output += store[prune] + "\n";
                }
                richTextBox14.Clear();
                   richTextBox14.AppendText(output );
            }
explaination above are my 1st problem.

for my 2nd problem,
if i get my expected output,
then if i key in minimum support like 40%, if nto fulfill 40, it will ignore.
My expected output is :

1: 55
2: 70
3: 65

hope can help me..

10 Replies

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

Vulpes15y ago
Accepted answer
I can't see any mistake in your code and, as I can't run it as it stands, I've modelled it as a console app and it works fine with the output exactly as expected:

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

class Test
{
   static void Main()
   {
   List richTextBox13 = new List(); // modelling an RTB with a List
   richTextBox13.Add("1: 55");
   richTextBox13.Add("2: 70");
   richTextBox13.Add("4: 25");
   richTextBox13.Add("3: 65");
   richTextBox13.Add("6: 15");
   richTextBox13.Add("5: 30");
   MessageBox.Show(String.Join("\n", richTextBox13.ToArray()));

   string min_supp = "40";
   double min = Double.Parse(min_supp);
   string output = "";

   for (int prune = 0; prune < richTextBox13.Count; prune++)
   {
   string[] items = richTextBox13[prune].Split(':');
   string key = items[0];
   double value = Double.Parse(items[1]);
   if (value >= min)
   {
   output += key + ": " + value.ToString() + "\n";
   }
   }
   MessageBox.Show(output);
   }
}

Are you putting '40' in the textbox or '40%'? The latter though would give an exception.

You'll have to try and debug it concentrating on this part of the code:

  for (int prune = 0; prune < richTextBox13.Lines.Length; prune++)
{
     string[] items = richTextBox13.Lines[prune].Split(':');
     string key = items[0];
    double value = Double.Parse(items[1]);
     if (value >= min)
     {
        output += key + ": " + value.ToString() + "\n"; // put a breakpoint here
     }
}

I'd put a breakpoint on the line indicated and check what 'key' and 'value' are each time through the loop.

0
Vulpes15y ago
Sure, just add a couple of lines:

   var sl = new SortedList();

   for (int prune = 0; prune < richTextBox13.Count; prune++)
   {
   string[] items = richTextBox13[prune].Split(':');
   string key = items[0];
   double value = Double.Parse(items[1]);
   if (value >= min)
   {
   output += key + ": " + value.ToString() + "\n";
   sl.Add(key, value);
   }
   }
0
y s15y ago
after i get my expected output:
1: 55
2: 70
3: 65

may i know how to store it into sortedList?
0
y s15y ago
when i key in minimum support =40%.
My expected output is :

1: 55
2: 70
3: 65
still cannot come out with this output.
0
y s15y ago
double v2;
            richTextBox13.Clear();
            foreach (String sorting2 in sortList1.Keys)
            {
                if (!(sortList11.ContainsKey(sorting2)))
                {
                    sortList1.TryGetValue(sorting2, out v2);

                    sortList11.Add(sorting2, v2);
                    double Count1 = (double)sortList11[sorting2];
                    sortList11[sorting2] = (v2 / ContentBox.Lines.Length) * 100;

                }
            richTextBox13.AppendText(sorting2 + ": " + sortList11[sorting2].ToString() + "\n");
            }

string min_supp = textBox9.Text;
            double min = Double.Parse(min_supp);
            textBox4.Text = textBox9.Text;
            string output = "";

           for (int prune = 0; prune < richTextBox13.Lines.Length; prune++)
{
     string[] items = richTextBox13.Lines[prune].Split(':');
     string key = items[0];
    double value = Double.Parse(items[1]);
     if (value >= min)
     {
        output += key + ": " + value.ToString() + "\n";
     }
}
richTextBox14.Clear();
richTextBox14.AppendText(output);

i have did any mistake with it?
0
Vulpes15y ago
Sorry again, that line should be:

double value = Double.Parse(items[1]);
0
y s15y ago
May i know this line
double value = Double.Parse(items[i);
the item[i] is what?
i change it to item[0]; but no output also .
my" min" values does not key in too high.
0
Vulpes15y ago
Sorry, that was a slip on my part - I'm just doing it off the top of my head.

However, as long as you haven't cleared the richTextBox13 again, then I'd expect this to work.

for (int prune = 0; prune < richTextBox13.Lines.Length; prune++)
{
string[] items = richTextBox13.Lines[prune].Split(':');
string key = items[0];
double value = Double.Parse(items[1]); // CORRECTED
if (value >= min)
{
output += key + ": " + value.ToString() + "\n";
}
}
richTextBox14.Clear();
richTextBox14.AppendText(output);

If you're seeing nothing, then perhaps your 'min' value is set so high that it's filtering every line out?
0
y s15y ago
the first point is work, but the second point cant work.
if i use this line
string value = Double.Parse(items[0]);
then got error, therefor i change it to double value = Double.Parse(items[0]);
after i change it, can run the program , but nothing come out.
0
Vulpes15y ago
On the first point, if I've understand it correctly, then it should just be a matter of changing this line:

  richTextBox13.AppendText(sortList11[sorting2].ToString() + "\n");

to this:

  richTextBox13.AppendText(sorting2 + ": " + sortList11[sorting2].ToString() + "\n");

On the second point, I'd then change the rest of the code to this:

  string min_supp = textBox9.Text;
  double min = Double.Parse(min_supp);
  textBox4.Text = textBox9.Text;
  string output = "";

  for (int prune = 0; prune < richTextBox13.Lines.Length; prune++)
  {
   string[] items = richTextBox13.Lines[prune].Split(':');
   string key = items[0];
   string value = Double.Parse(items[i);
   if (value >= min)
   {
   output += key + ": " + value + "\n";
   }
  }
  richTextBox14.Clear();
  richTextBox14.AppendText(output);
0