How to write columns header to a csv file with Ruby? How to write columns header to a csv file with Ruby? ruby ruby

How to write columns header to a csv file with Ruby?


I would recommend to use the CSV-library instead:

require 'csv'CSV.open('test.csv','w',     :write_headers=> true,    :headers => ["numerator","denominator","calculation"] #< column header  ) do|hdr|  1.upto(12){|numerator|    1.upto(12){ |denominator|      data_out = [numerator, denominator, numerator/denominator.to_f]      hdr << data_out    }  }end

If you can't use the w option and you really need the a+ (e.g., the data isn't available all at once), then you could try the following trick:

require 'csv'column_header = ["numerator","denominator","calculation"]1.upto(12){|numerator|  1.upto(12){ |denominator|    CSV.open('test.csv','a+',         :write_headers=> true,        :headers => column_header      ) do|hdr|          column_header = nil #No header after first insertion          data_out = [numerator, denominator, numerator/denominator.to_f]          hdr << data_out        end  }}


The cleanest way to do this is to open the file once, in mode 'w', write the headers, and then write the data.

If there's some technical reason that can't do this (e.g., the data isn't available all at once), then you can use the IO#tell method on the file to return the current file position. When you open the file for appending, the position is set to the end of the file, so if the current file position is zero, then the file was newly created and has no headers:

File.open('cdhu3_X.csv', 'a+') do |hdr|  if hdr.tell() == 0  # file is empty, so write header    hdr << "numerator, denominator, calculation\n"  end  hdr << "#{data_out}\n"end


Best way to handle csv file is to use Ruby's CSV module.

I had same problem after reading CSV code I came across this solution which i find most efficient.

headers = ['col1','col2','col3']CSV.open(file_path, 'a+', {force_quotes: true}) do |csv|  csv << headers if csv.count.eql? 0 # csv.count method gives number of lines in file if zero insert headersend