blob: aac426bd961b1d1a90454a3d7783d9c4e8642c13 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
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|
if row.count > 0
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
end
puts "Date: Streams: Revenue:"
puts "------------------------------------------"
total_rev = 0
total_streams = 0
sales_by_date.each do |key, row|
puts "#{key.iso8601}: #{row[:count].to_s.rjust(7)} #{row[:total].round(5).to_s.rjust(10)} EUR"
total_rev += row[:total]
total_streams += row[:count]
end
puts "------------------------------------------"
puts "Total: #{total_streams.to_s.rjust(7)} #{total_rev.round(5).to_s.rjust(10)} EUR"
|