#! /usr/bin/env ruby

require 'csv'
require 'json'

MIN_LEVEL = -40

views = {}
times = []

CSV.foreach('1991data') do |row|
  sig_level = row[7].to_i
  next if sig_level < MIN_LEVEL

  router_id = row[1].to_i
  time = Time.at(row[2].to_i)
  mac = row[3].strip

  times << time

  views[router_id] ||= {}
  views[router_id][time] ||= []
  views[router_id][time] << mac
end

categories = times.uniq.sort
series = []

views.each do |router_id, time_views|
  data = categories.map do |time|
    time_views.fetch(time, []).uniq.count
  end
  series << {name: router_id, data: data}
end

puts 'Categories:'
puts categories.to_json
puts
puts 'Series:'
puts series.to_json