convert CSV to JSON hash of hashes

csv_to_json_hash

#!/usr/bin/env ruby
# convert CSV to JSON hash of hashes
# uses the first column as the ID column, must be unique per row
# takes the CSV filepath as first argument
# fallsback to STDIN when there are no arguments

require 'rubygems'
require 'csv'
require 'json'

csv_filepath = ARGV[0]
csv_data = CSV.read(csv_filepath) if csv_filepath
csv_data = CSV.parse(STDIN.read) unless csv_data

abort("No data to parse :'(") unless csv_data

headers = csv_data.shift.map {|i| i.to_s }
string_data = csv_data.map {|row| row.map {|cell| cell.to_s } }
array_of_hashes = string_data.map {|row| Hash[*headers.zip(row).flatten] }

# print array_of_hashes.to_json

hash_of_hashes = {}
array_of_hashes.each do |data|
  hash_of_hashes[ data[headers.first] ] = data
end

print hash_of_hashes.to_json