Re: [R] Question: Beginner stuck in a R cycle

From: Ted Harding <Ted.Harding_at_manchester.ac.uk>
Date: Tue, 08 Jul 2008 17:01:40 +0100 (BST)


On 08-Jul-08 13:18:13, Daniela Ottaviani wrote:
> Dear All,
> I have a database of 200 observations named myD.
> In the dataframe there are a column named code (with codes varying
> from 1 to 77), a column named "prevalence" with some quantitative
> measurements are given and an column named Pr_mean, with no values.
>
> I would like to set a cycle to compute the average of prevalence values
> for each different code and store the averages under the empty field
> Pr_mean.

I think something on the following lines would do what you want (I think it is wise to call the final column "Pr.mean", as below, rather than "Pr_mean"):

  for( Code in unique(myD$code) ){
    ix <- (myD$code == Code )
    myD$Pr.mean[ix] <- mean(myD$prevalence[ix])   }

Ted.

> This is what I wrote:
>

># Set a cycle

> for (i in 1:nrow(myD)) {
> mycode = myD$code[i]
> mymean[i] = mean(prevalence)
> myD$Pr_mean[i] = mymean[i]
> }
>
> With the above cycle I am able to compute the average of all 200
> observations which is then written in every cell.
> I understand that a condition is missing, that indicates that the
> average has to be computed amongst the observations showing the same
> codes values.
>
> Could you please help me ?
>
>
> D.
>
>
>
> Posta, news, sport, oroscopo: tutto in una sola pagina.
> Crea l&#39;home page che piace a te!
> www.yahoo.it/latuapagina
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.


E-Mail: (Ted Harding) <Ted.Harding_at_manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861
Date: 08-Jul-08                                       Time: 17:01:38
------------------------------ XFMail ------------------------------

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Tue 08 Jul 2008 - 16:10:33 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 08 Jul 2008 - 17:31:25 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive