Storing CSV data in Ruby hash

Question

Say I have a CSV file with 4 fields,

ID,name,pay,age

and about 32,000 records.

What's the best way to stick this into a hash in Ruby?

In other words, an example record would look like:

{:rec1 => {:id=>"00001", :name => "Bob", :pay => 150, :age => 95 } }

Thanks for the help!

Answer 1

You can use the Excelsior rubygem for this:

csv = ...
result = Hash.new
counter = 1
Excelsior::Reader.rows(csv) do |row|
   row_hash = result[("rec#{counter}".intern)] = Hash.new

   row.each do |col_name, col_val|
      row_hash[col_name.intern] = col_val
   end
   counter += 1
end

# do something with result...