analyze.rb

require 'json'
require 'time'
require 'csv'

file = File.open("messages.json").read
messages = JSON.parse(file)

# consolidate


# Sort
analytics = messages.map do |message|
  puts message["contact"]
  {
    contact: message["contact"],
    last_message: Time.at(message["messages"][0]["timestamp"]),
    count: message["messages"].count,
  }
end

analytics.sort! {|a, b| b[:count] <=> a[:count]}


csv = CSV.open("analysis.csv", "w+")

analytics.each do |a|
  csv << [a[:contact], a[:count], a[:last_message]]
end