How do I add?

I’ve got a file that is in two columns, how do I add the second column
up as I read through the file?

Code:
#!/usr/bin/ruby
file = File.open(‘some_file.txt’)

Going through each line

file.each do |line|
data = line.split("\t")
total += data[1] # How do I make this line work?
end

puts total

2009/8/7 chutsu [email protected]:

I’ve got a file that is in two columns, how do I add the second column
up as I read through the file?
[…]

Hello,

you read strings from the file, but you want to add numbers. Therefore
you need to convert the strings into numbers first.

Take a look at the documentation of String#to_i or String#to_f, for
example.

cu,
Thomas

On Aug 7, 2009, at 12:50 PM, chutsu wrote:

I’ve got a file that is in two columns, how do I add the second column
up as I read through the file?

Code:
#!/usr/bin/ruby
file = File.open(‘some_file.txt’)

total = 0 # make the variable have scope outside the block

Going through each line

file.each do |line|
data = line.split("\t")
total += data[1] # How do I make this line work?

and convert the string to a numeric depending on what you expect

total += data[1].to_f
total += data[1].to_i

end

puts total

Or you could:

puts File.readlines(‘some_file.txt’).inject(0) {|total,line| total +
line.split("\t")[1].to_i }

(but if the file is large, that could be terribly inefficient)

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

On Aug 7, 2009, at 2:27 PM, Thomas C. wrote:

inject is a method of Iterable, so it’s unnecessary to read the whole
I think you meant Enumerable

file into memory first to use it. I would prefer a solution that is
both elegant and efficient:

puts file.inject(0) {|acc, line| acc + line.split(/\t/)[1].to_f }

cu,
Thomas


When C++ is your hammer, every problem looks like your thumb.

Maybe “Iterable” is something from C++? :wink:

I guess I could have simply replaced .readlines with .open in my one-
liner.

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

2009/8/7 Rob B. [email protected]:

[…]
puts File.readlines(‘some_file.txt’).inject(0) {|total,line| total +
line.split("\t")[1].to_i }

(but if the file is large, that could be terribly inefficient)
[…]

Hello,

inject is a method of Iterable, so it’s unnecessary to read the whole
file into memory first to use it. I would prefer a solution that is
both elegant and efficient:

puts file.inject(0) {|acc, line| acc + line.split(/\t/)[1].to_f }

cu,
Thomas

2009/8/7 Rob B. [email protected]:

On Aug 7, 2009, at 2:27 PM, Thomas C. wrote:

[…]
inject is a method of Iterable, so it’s unnecessary to read the whole

I think you meant Enumerable

Hello,

you’re right, of course. Writing programs in Java and Scheme in
parallel and replying to a Ruby thread in between apparently caused
some mixup of contexts in my head :wink:

[…]
– When C++ is your hammer, every problem looks like your thumb.

Maybe “Iterable” is something from C++? :wink:

g

I think, the C++ STL has “iterator”, “Iterable” can, for example, be
found in Java…

cu,
Thomas

On Aug 7, 11:44 am, chutsu [email protected] wrote:

total += data[1] # How do I make this line work?
end

puts total

awk “{t += $2} END {print t}” some_file.txt

Thomas C. wrote:

I would prefer a solution that is
both elegant and efficient:

Then you would runaway from inject.

On Aug 7, 7:02 pm, w_a_x_man [email protected] wrote:

file.each do |line|
data = line.split("\t")
total += data[1] # How do I make this line work?
end

puts total

awk “{t += $2} END {print t}” some_file.txt

ruby -ane"BEGIN{$t=0}; $t += $F[1].to_f; END{p $t}" some_file.txt

On Aug 7, 2009, at 8:10 PM, w_a_x_man wrote:

ruby -ane"BEGIN{$t=0}; $t += $F[1].to_f; END{p $t}" some_file.txt
Just because you can still write your Perl in Ruby, doesn’t mean that
you should.

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

On Aug 7, 8:43 pm, Rob B. [email protected] wrote:

puts total
Rob B. http://agileconsultingllc.com
[email protected]

just ignore waxman, he’s a known troll.

On Aug 7, 7:43 pm, Rob B. [email protected] wrote:

#!/usr/bin/ruby
awk “{t += $2} END {print t}” some_file.txt

ruby -ane"BEGIN{$t=0}; $t += $F[1].to_f; END{p $t}" some_file.txt

Just because you can still write your Perl in Ruby, doesn’t mean that
you should.

An example from Matz (Ruby in a Nutshell):

ruby -ne ‘print if /Ruby/’ /usr/share/dict/words

Matz put these features in Ruby so that they could be used,
not so that they would not be used.

But in your blind arrogance, you believe that because of your
very special two-digit IQ, you are the sole arbiter of what is
permissible with Ruby. And when someone dares to post code that
does not conform to your standards of bloat, pretentiousness,
pomposity, inefficiency, and intellectual mediocrity, you lash
out with self-righteous savagery.

As a man and as a programmer, you are a sick joke.

On Aug 7, 2009, at 10:05 PM, w_a_x_man wrote:

#!/usr/bin/ruby
awk “{t += $2} END {print t}” some_file.txt
Matz put these features in Ruby so that they could be used,
not so that they would not be used.

But in your blind arrogance, you believe that because of your
very special two-digit IQ, you are the sole arbiter of what is
permissible with Ruby. And when someone dares to post code that
does not conform to your standards of bloat, pretentiousness,
pomposity, inefficiency, and intellectual mediocrity, you lash
out with self-righteous savagery.

As a man and as a programmer, you are a sick joke.

Well, I have a two-hexdigit IQ :wink:

Note that I don’t fault your awk example, but I stand by my opinion.
If the OP ever responds, we’ll know who’s advice has more long-term
value. My initial response pointed out that the local variable, total,
was scoped within the block and that the split portion of the line
needed to be converted to an arithmetic value before being added to
the total.

I made the assumption that chutsu wanted to learn something about Ruby
and not just how to obtain a very specific result. If there’s more to
his/her situation, your one-liner won’t make it too far.

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

On Aug 7, 7:48 pm, pharrington [email protected] wrote:

puts total
Rob B. http://agileconsultingllc.com
[email protected]

just ignore waxman, he’s a known troll.

Please ignore this pitiable fellow. He is a well-known
lick-spittle, toad-eater, dimwit, poltroon, catamite, sycophant,
and microcephalic idiot.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs