Thank you!
Am 26.09.2012 13:31, schrieb Jim Lemon [via R]:
> On 09/26/2012 08:53 PM, Tagmarie wrote:
>
> > Hello,
> > I tried for about three hours now to solve this problem but I can't
> figure
> > it out. I am sure someone knows how do it. At least I hope so.
> >
> > I have a data frame somewhat like this:
> >
> > myframe<- data.frame (ID=c("Ernie", "Ernie", "Bert", "Bert"),
> > Timestamp=c("24.09.2012 09:00", "24.09.2012 09:00", "24.09.2012 10:00",
> > "25.09.2012 10:00"), Hunger=c("1","5","2","2"),
> Temp=c("25","30","27","28")
> > )
> > myframe
> >
> > As you can see for Ernie I do have different data for 24.09.2012
> 9:00. Now I
> > would like to average the Hunger and Temp value for this timestamp
> to get a
> > data frame without duplicated Times and the respective average Temp and
> > Hunger.
> >
> > I tried something like
> > Meanframe<- by(myframe[, 3:4], duplicated(myframe$ID,
> > Zusatzdaten3$Timestamp) == TRUE, mean)
> > but it doesn't work and I guess that it is also totally crap ;-)
> >
> Hi Tagmarie,
> Your problem is that both Hunger and Temp are read in as factors. If you
> try it like this:
>
> by(as.numeric(as.character(myframe[,3])),myframe[,"ID"],mean)
> by(as.numeric(as.character(myframe[,4])),myframe[,"ID"],mean)
>
> You might get what you want. The "as.character" call is necessary,
> otherwise you will get the wrong mean values.
>
> Jim
>
> ______________________________________________
> [hidden email] </user/SendEmail.jtp?type=node&node=4644224&i=0>
> 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.
>
>
> ------------------------------------------------------------------------
> If you reply to this email, your message will be added to the
> discussion below:
> http://r.789695.n4.nabble.com/average-environmental-data-if-AnimalID-and-Time-is-duplicated-tp4644218p4644224.html
>
>
> To unsubscribe from average environmental data if AnimalID and Time is
> duplicated, click here
> <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4644218&code=UmFtZ2FkODJAZ214Lm5ldHw0NjQ0MjE4fDIwNzkwMzU2MDU=>.
> NAML
> <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
>
--
View this message in context:
http://r.789695.n4.nabble.com/average-environmental-data-if-AnimalID-and-Time-is-duplicated-tp4644218p4644231.html
Sent from the R help mailing list archive at Nabble.com.
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
