CSV à JSON Ruby Script?

Personne ne sait comment écrire un script Ruby qui permettrait de convertir un fichier csv en un fichier json?

Le CSV serait dans ce format:

Canon,Digital IXUS 70,"Epic, Epic 100",3x,Yes (lockable),Yes (lockable),Yes
Canon, Digital IXUS 75,"Epic, Epic 100",3x,Yes (lockable),Yes (lockable),Yes
Canon,Digital IXUS 80,"Epic, Epic 100",3x,Yes (lockable),Yes (lockable),Yes

et le JSON aurait besoin de voir cette:

{ "aaData": [
[ "Canon" , "Digital IXUS 70" , "3x" , "Yes (lockable)" , "Yes (lockable)" , "Yes"],
[ "Canon" , "Digital IXUS 75" , "3x" , "Yes (lockable)" , "Yes (lockable)" , "Yes"],
[ "Canon" , "Digital IXUS 80" , "3x" , "Yes (lockable)" , "Yes (lockable)" , "Yes"]
]}

source d'informationauteur webbydevy

  1. 42

    C'est facile de ruby 1.9 où les données sont vos données au format csv, chaîne

     require 'csv'
 require 'json'

 CSV.parse(data).to_json
  2. 18

    Aller à partir de:

    Year,Make,Model,Description,Price
1997,Ford,E350,"ac, abs, moon",3000.00
1999,Chevy,"Venture ""Extended Edition""","",4900.00
1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00
1996,Jeep,Grand Cherokee,"MUST SELL!
air, moon roof, loaded",4799.00

    à

    [
  {:year => 1997, :make => 'Ford', :model => 'E350', :description => 'ac, abs, moon', :price => 3000.00},
  {:year => 1999, :make => 'Chevy', :model => 'Venture "Extended Edition"', :description => nil, :price => 4900.00},
  {:year => 1999, :make => 'Chevy', :model => 'Venture "Extended Edition, Very Large"', :description => nil, :price => 5000.00},
  {:year => 1996, :make => 'Jeep', :model => 'Grand Cherokee', :description => "MUST SELL!\nair, moon roof, loaded", :price => 4799.00}
]

    Ce faire:

    csv = CSV.new(body, :headers => true, :header_converters => :symbol, :converters => :all)
csv.to_a.map {|row| row.to_hash }
#=> [{:year=>1997, :make=>"Ford", :model=>"E350", :description=>"ac, abs, moon", :price=>3000.0}, {:year=>1999, :make=>"Chevy", :model=>"Venture \"Extended Edition\"", :description=>"", :price=>4900.0}, {:year=>1999, :make=>"Chevy", :model=>"Venture \"Extended Edition, Very Large\"", :description=>nil, :price=>5000.0}, {:year=>1996, :make=>"Jeep", :model=>"Grand Cherokee", :description=>"MUST SELL!\nair, moon roof, loaded", :price=>4799.0}]

    De crédit: http://technicalpickles.com/posts/parsing-csv-with-ruby/

  3. 8

    Bâtiment sur de Josh exemple, vous pouvez maintenant prendre un peu plus loin à l'aide de CSV::table:

    extracted_data   = CSV.table('your/file.csv')
transformed_data = extracted_data.map { |row| row.to_hash }

    Maintenant, vous pouvez appeler to_json l'utiliser tout de suite, ou de l'écrire dans un fichier, bien mis en forme:

    File.open('your/file.json', 'w') do |file|
  file.puts JSON.pretty_generate(transformed_data)
end
  4. 2

    Si vous êtes dans un des Rails de projet

    CSV.parse(csv_string, {headers: true})
csv.map(&:to_h).to_json