rooms.csv

test.rb

require 'csv'

data = CSV.parse(File.read('rooms.csv'))

groups = Hash.new(0)

data.flatten!

data.each_index do |i|
	data.each_index do |j|

		if data[i] = data[j]
			if groups.has_key?(data[i])
				groups[data[i]] += 1
			else
				groups[data[i]] = 1
			end
		end
	end
end

puts groups. inspect