Debian Codegraph @

tests/inputs/statcsv.nim

raw
1 # https://github.com/nim-lang/Nim/blob/devel/examples/statcsv.nim
2 # Example program to show the parsecsv module
3 # This program reads a CSV file and computes sum, mean, minimum, maximum and
4 # the standard deviation of its columns.
5 # The CSV file can have a header which is then used for the output.
6
7 import os, streams, parsecsv, strutils, math, stats
8
9 if paramCount() < 1:
10 quit("Usage: statcsv filename[.csv]")
11
12 var filename = addFileExt(paramStr(1), "csv")
13 var s = newFileStream(filename, fmRead)
14 if s == nil: quit("cannot open the file " & filename)
15
16 var
17 x: CsvParser
18 header: seq[string]
19 res: seq[RunningStat]
20 open(x, s, filename, separator=';', skipInitialSpace = true)
21 while readRow(x):
22 if processedRows(x) == 1:
23 newSeq(res, x.row.len) # allocate space for the result
24 if validIdentifier(x.row[0]):
25 # header line:
26 header = x.row
27 else:
28 newSeq(header, x.row.len)
29 for i in 0..x.row.len-1: header[i] = "Col " & $(i+1)
30 else:
31 # data line:
32 for i in 0..x.row.len-1:
33 push(res[i], parseFloat(x.row[i]))
34 x.close()
35
36 # Write results:
37 for i in 0..header.len-1:
38 stdout.write("\t")
39 stdout.write(header[i])
40 stdout.write("\nSum")
41 for i in 0..header.len-1:
42 stdout.write("\t")
43 stdout.write(res[i].sum)
44 stdout.write("\nMean")
45 for i in 0..header.len-1:
46 stdout.write("\t")
47 stdout.write(res[i].mean)
48 #[
49 stdout.write("\nMin")
50 for i in 0..header.len-1:
51 stdout.write("\t")
52 stdout.write(res[i].min) ]#
53 stdout.write("\nMax")
54 for i in 0..header.len-1:
55 stdout.write("\t")
56 stdout.write(res[i].max)
57 stdout.write("\nStdDev")
58 for i in 0..header.len-1:
59 stdout.write("\t")
60 stdout.write(res[i].standardDeviation)
61 stdout.write("\n")