2015-02-20 09:02:09 -05:00
|
|
|
require 'csv'
|
|
|
|
|
# read:
|
|
|
|
|
ar = CSV.table("test.csv").to_a #table method assumes headers and converts numbers if possible.
|
|
|
|
|
|
|
|
|
|
# manipulate:
|
|
|
|
|
ar.first << "SUM"
|
2020-02-17 23:21:07 -08:00
|
|
|
ar[1..-1].each{|row| row << row.sum}
|
2015-02-20 09:02:09 -05:00
|
|
|
|
|
|
|
|
# write:
|
|
|
|
|
CSV.open("out.csv", 'w') do |csv|
|
|
|
|
|
ar.each{|line| csv << line}
|
|
|
|
|
end
|