Convert CSV to Array?

Question

Any ideas on how to convert this CSV into a ruby array using vim?

Starting CSV:

Year,Make,Model
1997,Ford,E350
2000,Mercury,Cougar

Desired Array:

car_info = [
  {'Year' => '1997', 'Make' => 'Ford', 'Model' => 'E350'},
  {'Year' => '2000', 'Make' => 'Mercury', 'Model' => 'Cougar'},
]

I have > 2000 entries like the CSV above, and I'd love a way to quickly re-format it for use in my Rails app. I'd like to use vim, but I'm open to other options too.

Why don't you just read the file in and convert it to the object you want using Ruby? — Peter Brown
– Peter Brown, Commented Mar 18, 2012 at 18:46
That's a good idea -- could you post an example in the answers? — Sauce McBoss
– Sauce McBoss, Commented Mar 18, 2012 at 20:36

Harish Shetty · Accepted Answer · 2012-03-18 22:28:18Z

6

FasterCSV.read("path/to/file.csv", :headers => true).map do |row|
  { "Year" => row[0], "Make" => row[1], "Model" => row[2] }
end

PS: Install faster_csv gem

edited Mar 18, 2012 at 22:28

answered Mar 18, 2012 at 19:13

Harish Shetty

64.4k21 gold badges154 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Michael Kohl Over a year ago

+1. You could also use :headers => true when reading the CSV.

Sauce McBoss Over a year ago

Awesome. This looks more promising than doing it by hand. Thanks!

Thilo · Accepted Answer · 2012-03-18 19:14:43Z

4

In vim, you can use global search and replace with a regular expression:

:g/\(.*\),\(.*\),\(.*\)/s//{'Year' => '\1', 'Make' => '\2', 'Model' => '\3'}/g

Then edit the first and last lines of the resulting file accordingly.

answered Mar 18, 2012 at 19:14

Thilo

17.8k5 gold badges70 silver badges86 bronze badges

1 Comment

Sauce McBoss Over a year ago

Thanks -- this looks like a good solution. Didn't know you could combine search with regex.

Collectives™ on Stack Overflow

Convert CSV to Array?

2 Answers 2

2 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Related