Swapping columns in FasterCSV::Table

Question

I have almost 1000+ CSV files where I need to shuffle several columns and recreate each CSV file with the shuffled columns. As an example, initial CSV file has "H1", "H2" and "H3" columns. The new CSV file will have columns "H1", "H3" and "H2".

Using FasterCSV in Ruby how would I do it? I have tried FasterCSV::Table with column_name access but no luck.

Can some kind soul help?

Regards

K

pguardiario · Accepted Answer · 2012-10-03 02:08:15Z

1

It's not too complicated:

CSV.open('new.csv', 'w') do |new_csv|
    CSV.foreach('old.csv') do |row|
        row[1], row[2] = row[2], row[1]
        new_csv << row
    end
end

I call it CSV instead of FasterCSV because that's the 1.9 way

answered Oct 3, 2012 at 2:08

pguardiario

55.2k21 gold badges130 silver badges169 bronze badges

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

1 Comment

kishore Over a year ago

Thanks a million. Yes it is simple indeed.

Collectives™ on Stack Overflow

Swapping columns in FasterCSV::Table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related