From: Anthony Eden <anthonyeden@...>
Date: 2007-03-23T20:36:58+09:00
Subject: Re: count distinct values in csv

Consider using either the built in CSV parser in Ruby stdlib or
FasterCSV ( http://fastercsv.rubyforge.org/ ). It'll save you time in
the long run.

V/r
Anthony Eden

On 3/23/07, Christian <ozric@web.de> wrote:
> Hi,
>
> i'm new to ruby.
> How  could i read a tab-delimted textfile  with two columns + header
> row
> and count the distinct values from the 2.column?
>
>
> ## my first experiments missed because i have  to elimnate the header
> row!?#######
>
> filename = gets.chomp
> text = String.new
> File.open(filename) { |f|  text = f.read }
> values = text.split(/\t/)
> freqs = Hash.new(0)
> values.each { |values| freqs[values] += 1 }
> freqs = freqs.sort_by {|x,y| y }
> freqs.each {|values, freq| puts values+' '+freq.to_s}
>
>
> Many thanks for a starting point.
> regards, christian
>
>
>


-- 
Cell: 808 782-5046
Current Location: Melbourne, FL