This is why I just love Ruby

why_i_<3.rb

require 'csv'

module Roster
  # Example of each row is: [1,Pac,Sivabudh  Umpudh,nil,nil,nil,nil,nil,nil]
  def self.parse_from_csv filename
    CSV.read(filename)
       .drop(1)         # remove the first row of CSV which is a header
       .map(&:compact)  # remove all `nil`
       .map { |line_array| [line_array[0], "#{line_array[1]} - #{line_array[2]}"] }  # convert ["1", "Pac", "Sivabudh Umpudh"] to ["1", "Pac - Sivabudh Umpudh"]
       .to_h            # convert array to hash: voila, I now got a hash with key as the ID, and value as my name!
  end
end