gistfile1.rb

CSV_SETTINGS = {
  headers: true, # first row is headers
  header_converters: :symbol, # convert headers to symbols
  converters: [
    -> (f) { f.present? ? f : nil }, # convert empty cells to nil
    -> (f) { f.respond_to?(:gsub) ? f.gsub(/\s+$/, '') : f }, # convert whitespace to nil
    :all # converts things to numbers and dates
  ]
}


CSV.parse(name, CSV_SETTINGS)