Convert results of ping output to csv

plot_ping.rb

#!/usr/bin/env ruby

require 'csv'

class Entry
  attr_reader :id, :text

  def initialize(text)
    @id, @text = parse_text(text)
  end

  private
  def parse_text(text)
    [text.split.reverse.first, text]
  end
end

class Timeout < Entry
end

class Passed < Entry
  attr_reader :id, :text, :ttl, :time

  def initialize(text)
    @id, @text, @ttl, @time = parse_text(text)
  end

  private
  def parse_text(text)
    params = text.sub(/^[\d]{2}[ ]bytes[ ][\w\s.]*:[ ]/, '').split.select { |e| e.include?('=') }
    id, ttl, time = params.map { |p| p.split('=').last }
    [id, text, ttl, time]
  end
end

requests = File.read('/tmp/graph/requests.txt').split("\n")
parsed_entries = requests.map do |req|
  if req.start_with?('Request timeout')
    Timeout.new(req)
  else
    Passed.new(req)
  end
end

csv_string = CSV.generate do |csv|
  parsed_entries.each do |entry|
    row = if entry.is_a?(Timeout)
            [entry.id, 99999]
          elsif entry.is_a?(Passed)
            [entry.id, entry.time]
          else
            []
          end
    csv << row
  end
end

File.write('plot.csv', csv_string)