require "csv"
require "pp"
 
data = <<END
purchaser name\titem description\tprice\tcount\tmerchant address\tmerchant name
Alice Bob\t$10 off $20 of food\t10.0 2\t987 Fake St\tBob's Pizza
Example Name\t$30 of awesome for $10\t10.0 5\t456 Unreal Rd\tTom's Awesome Shop
Name Three\t$20 Sneakers for $5\t5.0    1\t123 Fake St\tSneaker Store Emporium
John Williams\t$20 Sneakers for $5\t5.0    4\t123 Fake St\tSneaker Store Emporium 
END
 
CONVERTER_SPLIT_PRICE_COUNT = lambda do |value, info|
  next value unless info.header == "price"
  price, count = value.split
  [ price.to_f, count.to_i ]
end
 
def row_to_hash_fixing_price_count(row)
  row.headers.zip(row.fields.flatten).to_h
end
 
csv_opts = {
  headers: true,
  col_sep: "\t",
  header_converters: ->(h) { h.downcase.tr(" ", "_") },
  converters: CONVERTER_SPLIT_PRICE_COUNT
}
 
data_out = CSV.new(data, csv_opts).map do |row|
  row_to_hash_fixing_price_count(row)
end
 
pp data_out

cmVxdWlyZSAiY3N2IgpyZXF1aXJlICJwcCIKCmRhdGEgPSA8PEVORApwdXJjaGFzZXIgbmFtZVx0aXRlbSBkZXNjcmlwdGlvblx0cHJpY2VcdGNvdW50XHRtZXJjaGFudCBhZGRyZXNzXHRtZXJjaGFudCBuYW1lCkFsaWNlIEJvYlx0JDEwIG9mZiAkMjAgb2YgZm9vZFx0MTAuMCAyXHQ5ODcgRmFrZSBTdFx0Qm9iJ3MgUGl6emEKRXhhbXBsZSBOYW1lXHQkMzAgb2YgYXdlc29tZSBmb3IgJDEwXHQxMC4wIDVcdDQ1NiBVbnJlYWwgUmRcdFRvbSdzIEF3ZXNvbWUgU2hvcApOYW1lIFRocmVlXHQkMjAgU25lYWtlcnMgZm9yICQ1XHQ1LjAgICAgMVx0MTIzIEZha2UgU3RcdFNuZWFrZXIgU3RvcmUgRW1wb3JpdW0KSm9obiBXaWxsaWFtc1x0JDIwIFNuZWFrZXJzIGZvciAkNVx0NS4wICAgIDRcdDEyMyBGYWtlIFN0XHRTbmVha2VyIFN0b3JlIEVtcG9yaXVtIApFTkQKCkNPTlZFUlRFUl9TUExJVF9QUklDRV9DT1VOVCA9IGxhbWJkYSBkbyB8dmFsdWUsIGluZm98CiAgbmV4dCB2YWx1ZSB1bmxlc3MgaW5mby5oZWFkZXIgPT0gInByaWNlIgogIHByaWNlLCBjb3VudCA9IHZhbHVlLnNwbGl0CiAgWyBwcmljZS50b19mLCBjb3VudC50b19pIF0KZW5kCgpkZWYgcm93X3RvX2hhc2hfZml4aW5nX3ByaWNlX2NvdW50KHJvdykKICByb3cuaGVhZGVycy56aXAocm93LmZpZWxkcy5mbGF0dGVuKS50b19oCmVuZAoKY3N2X29wdHMgPSB7CiAgaGVhZGVyczogdHJ1ZSwKICBjb2xfc2VwOiAiXHQiLAogIGhlYWRlcl9jb252ZXJ0ZXJzOiAtPihoKSB7IGguZG93bmNhc2UudHIoIiAiLCAiXyIpIH0sCiAgY29udmVydGVyczogQ09OVkVSVEVSX1NQTElUX1BSSUNFX0NPVU5UCn0KCmRhdGFfb3V0ID0gQ1NWLm5ldyhkYXRhLCBjc3Zfb3B0cykubWFwIGRvIHxyb3d8CiAgcm93X3RvX2hhc2hfZml4aW5nX3ByaWNlX2NvdW50KHJvdykKZW5kCgpwcCBkYXRhX291dA==