Dan's import challenge

parser.rb

class Parser
  attr_accessor :row

  def initialize(row)
    @row = row
  end

  def question_ids
    row.headers.first.gsub('q', '').split(' ')[1..-1].map(&:to_i)
  end

  def user_id
    row.first.last.split(' ').shift.gsub('u', '').to_i
  end

  def responses
    row.first.last.split(' ')[1..-1].map(&:to_i)
  end

  def create_responses
    question_ids.each_with_index do |qid, index|
      Response.create(
        question_id: qid,
        user_id: user_id,
        response: responses[index]
      )
    end
  end
end

response.rb

class Response
  def self.create(attrs)
    p attrs
  end
end

sample.tsv

id q1 q2 q3
u1 5 6 7