Random json parsing script to convert to csv

json_to_excel.rb

require 'json'
require 'csv'

puts "Parsing..."
data = JSON.parse(File.read('LocationHistory.json'))
puts "Saving..."
CSV.open("locations.csv", "w+") do |csv|
  headers = %w( timestampMs latitudeE7 longitudeE7 accuracy )
  headers += (0..10).to_a.map { |i| "activity_#{i}" }
  csv << headers
  data['locations'].each.with_index do |location|
    row = [
      location['timestampMs'],
      location['latitudeE7'],
      location['longitudeE7'],
      location['accuracy'],
    ]
    unless location['activitys'].nil?
      row << location['activitys'][0]['timestampMs']
      unless location['activitys'][0]['activities'].nil?
        location['activitys'][0]['activities'].each do |activity|
          row << activity['type']
          row << activity['confidence']
        end
      end
    end
    csv << row
  end
end