Tutorial :Ruby on Rails field average?



Question:

Is there an easy way to obtain the average of an attribute in a collection?

For instance, each user has a score.

Given a collection of user(s) (@users), how can you get the average score for the group?

Is there anything like @users.average(:score)? I think I came across something like this for database fields, but I need it to work for a collection...


Solution:1

For your question, one could actually do:

@users.collect(&:score).sum.to_f/@users.length if @users.length > 0  

Earlier I thought, @users.collect(&:score).average would have worked. For database fields, User.average(:score) will work. You can also add :conditions like other activerecord queries.


Solution:2

I use to extend our friend Array with this method:

class Array     # Calculates average of anything that responds to :"+" and :to_f    def avg       blank? and 0.0 or sum.to_f/size     end  end  


Solution:3

Here's a little snippet to not only get the average but also the standard deviation.

class User    attr_accessor :score    def initialize(score)      @score = score    end  end    @users=[User.new(10), User.new(20), User.new(30), User.new(40)]    mean=@users.inject(0){|acc, user| acc + user.score} / @users.length.to_f  stddev = Math.sqrt(@users.inject(0) { |sum, u| sum + (u.score - mean) ** 2 } / @users.length.to_f )  


Solution:4

u can use this here

http://api.rubyonrails.org/classes/ActiveRecord/Calculations.html#method-i-average


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »