Yeah, it looks like there's something seriously broken about this poll code. I'm seeing 159 total votes, and only 13 visible votes.

Total 139, chart shows 0 votes...

Of course that's what you'd say...

awk is made for this, but it took me a few minutes to whip this up in java. I figured if numeric polls are used in the future, this can be used as a code-base. The indentation isn't coming through, but any IDE will fix that for you.

This doesn't work on arbitrary numeric entry polls, but for those, you can gather the statistics as you go along, putting it in the GATHER loop

EDITED to fix serious bug.

usage: paste this into PollStat.java, compile it. then run

java PollStat < poll.csv.txt

So far, the winners are endoself and army1987. I wasn't far off.

~~~~~~~~~

import java.io.*;
import java.util.*;
public class PollStat {
public static void main(String[] args) {
try {
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
String line = br.readLine();
int[] counts = new int[12]; // PUT NUMBER OF POLL OPTIONS HERE
int end, begin;
int linen = 0;
while (line != null && line.charAt(0) == '#') {
line = br.readLine();
linen++;
}
while (line != null) { // GATHER LOOP
linen++;
end = line.lastIndexOf("\",\"");
begin = line.lastIndexOf("\",\"", end-1);
try {
line = line.substring(begin+3, end);
} catch (Exception e) {
System.out.println("At line number "+linen+":");
e.printStackTrace();
System.exit(1);
}
Integer c = Integer.parseInt(line);
counts[c]++;
// For arbitrary numeric responses, don't use counts.
// just continuously gather your statistics. Alternately, make a list of Doubles or something.
line = br.readLine();
}
br.close();
int total = 0;
int resp = 0;
int[] numbers = new int[]{100, 64, 41, 26, 17, 11, 7, 4, 3, 2, 1, 0}; // PUT POLL OPTIONS HERE
for (int i = 0; i < c.length; i++) {
System.out.println(numbers[i]+": "+counts[i]);
total += numbers[i] * counts[i];
resp += counts[i];
}
System.out.println("total: "+total);
System.out.println("average: "+((double)total)/resp);
} catch (IOException ioe) {
ioe.printStackTrace();
System.exit(2);
}
}
}

Not really -- if you check out the wiki page this type of poll is meant for discrete options, not for numbers or probabilities. For probabilities the "poll:probability" type should be used, which does automatically compute averages and medians.

Ahrgh, if only everyone was running TDT…

Or UDT. Or CDT. Or EDT.