From ca90189f199f35017cf16b92947d738c2880b444 Mon Sep 17 00:00:00 2001
From: Harald Eilertsen <haraldei@anduin.net>
Date: Thu, 13 Feb 2014 08:54:35 +0100
Subject: Initial commit.

Parse the CSV-file, and aggregate total sales by date.
---
 parse_report.rb | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 parse_report.rb

diff --git a/parse_report.rb b/parse_report.rb
new file mode 100644
index 0000000..840708e
--- /dev/null
+++ b/parse_report.rb
@@ -0,0 +1,26 @@
+require "csv"
+
+csv_opts = {
+  :col_sep => ";",
+  :skip_lines => /^(Notes|The |;)/,
+  :headers => true,
+  :converters => :all,
+}
+
+sales_by_date = {}
+
+rows = CSV.foreach(ARGV[0], csv_opts)
+
+rows.each do |row|
+  d = Date.parse(row["Date"])
+  if sales_by_date[d]
+    sales_by_date[d][:count] += row["quantity"]
+    sales_by_date[d][:total] += row["revenue EUR"]
+  else
+    sales_by_date[d] = {:count => row["quantity"], :total => row["revenue EUR"]}
+  end
+end
+
+sales_by_date.each do |row|
+  p row
+end
-- 
cgit v1.2.3