Skip to content

Instantly share code, notes, and snippets.

@dharamgollapudi
Forked from enriclluelles/csv_to_json.rb
Created July 19, 2018 19:43
Show Gist options
  • Save dharamgollapudi/a9385d86506e63ef0996ffea0b09ceb1 to your computer and use it in GitHub Desktop.
Save dharamgollapudi/a9385d86506e63ef0996ffea0b09ceb1 to your computer and use it in GitHub Desktop.
CSV to JSON
#!/usr/bin/env ruby
require 'csv'
require 'json'
if ARGV.size != 2
puts 'Usage: csv_to_json input_file.csv output_file.json'
puts 'This script uses the first line of the csv file as the keys for the JSON properties of the objects'
exit(1)
end
lines = CSV.open(ARGV[0]).readlines
keys = lines.delete lines.first
File.open(ARGV[1], 'w') do |f|
data = lines.map do |values|
Hash[keys.zip(values)]
end
f.puts JSON.pretty_generate(data)
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment