Skip to content

Instantly share code, notes, and snippets.

@garethrees

garethrees/merge_csv_columns.rb

Last active May 11, 2018 16:31
Show Gist options
  • Save garethrees/a0e03130f0ee950ab2643e84e1f55ade to your computer and use it in GitHub Desktop.
Save garethrees/a0e03130f0ee950ab2643e84e1f55ade to your computer and use it in GitHub Desktop.
Download ZIP
Merge CSV columns with same header
Raw
merge_csv_columns.rb
require 'csv'
csv = CSV.parse(<<-CSV, headers: true, header_converters: :symbol)
id,title,label,label
1,fixme,bug,backend
CSV
row = csv.first
row[:labels] = row.map { |k,v| v if k == :label }.compact
row[:labels]
# => ["bug", "backend"]
Raw
monkeypatched_csv.rb
require 'csv'
class CSV
class Row
def merge_fields(field, merged_field)
self[merged_field] = map { |k,v| v if k == field }.compact
end
end
end
csv = CSV.parse(<<-CSV, headers: true, header_converters: :symbol)
id,title,label,label
1,fixme,bug,backend
CSV
row = csv.first
row.merge_fields(:label, :labels)
# => ["bug", "backend"]
row[:labels]
# => ["bug", "backend"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment