[R] data.frame - how to calculate the number of rows
Henrique Dallazuanna
wwwhsd at gmail.com
Wed Dec 26 20:58:03 CET 2007
If i understand your question, you can try this:
cbind(summaryBy(B+C~ A, data=df,FUN=c(mean, var)), 'num
rows'=as.numeric(table(df$A)))
On 26/12/2007, Agrarimmobilien <ralf.pfeiffer at agrarimmobilien.info> wrote:
> Hello,
>
> I had to give some more information to my posting:
>
> as ouput there are more than one row, depending on the values of column A
> (transformierung to distinct values, here 3 and 4, but there are much more)
>
> > A B C
> > 1 3 6 5
> > 2 3 4 20
> > 3 3 8 2
> > 4 4 8 3
> > 5 4 2 6
>
> Output:
>
> > A B C num rows
> > 1 3 6 6.16 3
> > 2 4 5 4.00 3
>
>
> B is mean and C variance.
>
>
> thank you
> Macki
>
>
>
> > Hello,
> >
> > it seems to be a simple problem, but I couldn't find an answer in the
> > archiv. (I think, it must has something to do with the group-select, like
> > in
> > php)
> >
> > I've the following data.frame:
> >
> > A B C
> > 1 3 6 5
> > 2 4 4 20
> > 3 5 8 2
> >
> > I want to get the number of the rows in the 4th column, like:
> >
> > A B C num rows
> > 1 3 6 6.16 3
> >
> >
> > (B is mean, C is variance by using summaryBy(B+C~ A, data=daten,
> > FUN=c(mean,var)) from the doBy-package)
> >
> > But, how can I add the column 'numrow' and count the number of the rows?
> >
> > Thanks!
> >
> > Macki
> >
> > ______________________________________________
> > 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.
> >
>
> ______________________________________________
> 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.
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
More information about the R-help
mailing list