FasterCSV: columns into an array -- rails

Question

I'm trying to get fastercsv setup so that rather than parsing each row, it will place each column into an multi array.

CSV import file:
id, first name, last name, age
1, joe, smith, 11
2, jane, doe, 14

Save to array named people:
people[0][0] would equal id
people[2][1] would equal jane

This is what I currently have:

url = 'http://url.com/file.csv'
open(url) do |f|
  f.each_line do |line|
    FasterCSV.parse(line) do |row|
      row
    end
  end
end

Any help is appreciated.

Why a multi-dimensional array? What is wrong with an array of hashes which is much nicer to read. — Ryan Bigg
– Ryan Bigg, Commented Nov 2, 2009 at 11:48
I wanted a multi-dimensional array setup for each column because I don't need to store the data in active-record nor do I know what the column names will be, I want to take the array and build a xml file out of it so that each column name will be each column's attribute... if that makes sense :) — Jeffrey
– Jeffrey, Commented Nov 2, 2009 at 16:05

EmFi · Accepted Answer · 2009-11-02 06:58:26Z

3

Have you read the FasterCSV documentation?

If you did, you would know that the easiest way to do what you want is:

people = FasterCSV.read('http://url.com/file.csv')

answered Nov 2, 2009 at 6:58

EmFi

23.5k3 gold badges60 silver badges68 bronze badges

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

3 Comments

Jeffrey Over a year ago

Also tried to read a local file and I got a compile error: "odd number list for Hash"

EmFi Over a year ago

Odd number list for hash should have nothing to do with FasterCSV. Any chance you're using braces to bookend your if blocks?

EmFi Over a year ago

Also you've got to go through some tricks to read from a URL, see this question: stackoverflow.com/questions/435634/…

Jeffrey · Accepted Answer · 2009-11-02 19:22:33Z

0

Thanks EmFi, with your help I was able to come up with a solution.

This takes a remote url csv file and loads it into a multi-dimensional array, based on columns.

require 'rio'
require 'fastercsv'

url = 'http://remoteurl.com/file.csv'
people = FasterCSV.parse(rio(url).read)

answered Nov 2, 2009 at 19:22

Jeffrey

4,14612 gold badges45 silver badges67 bronze badges

Comments

PanosJee · Accepted Answer · 2009-11-03 11:23:16Z

0

You can use CsvMapper on top of FasterCSV It s a life saver

answered Nov 3, 2009 at 11:23

PanosJee

3,8666 gold badges38 silver badges49 bronze badges

Collectives™ on Stack Overflow

FasterCSV: columns into an array -- rails

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related