Initial commit.

Parse the CSV-file, and aggregate total sales by date.

1 files changed, 26 insertions, 0 deletions

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