Skip to content

Instantly share code, notes, and snippets.

@naxIO
Created April 12, 2017 21:56
Show Gist options
  • Save naxIO/bba38f7936c4658681c515f1faae8c37 to your computer and use it in GitHub Desktop.
Save naxIO/bba38f7936c4658681c515f1faae8c37 to your computer and use it in GitHub Desktop.
CSV to JSON (Ruby)
#!/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