[R] One silly question about "tapply output"
Vito Muggeo (UniPa)
vito.muggeo at unipa.it
Wed Oct 27 13:42:27 CEST 2010
dear Vincy,
Firstly, a suggestion: to increase the probability of getting help, you
should provide reproducible code (people can do "copy-and-paste" of your
code and to modify the code to obtain the response.. )
However a possible solution (not tested, of course..) could be simply
a<-tapply(rate, rating, mean)
d<-data.frame(rating=names(a),mean=a)
best,
vito
Il 27/10/2010 12.39, Vincy Pyne ha scritto:
> Dear R helpers
>
> I have a data which gives Month-wise and Rating-wise Rates. So the input file is something like
>
> month rating rate
> January AAA 9.04
> February AAA 9.07
> ..........................................
> ..........................................
> Decemeber AAA 8.97
> January BBB 11.15
> February BBB 11.13
>
>
>
> January CCC 17.13
> .............................................
> ............................................
> December CCC 17.56
>
> and so on.
>
> My objective is to calculate Rating-wise mean rate, for which I have used
>
> rating_mean = tapply(rate, rating, mean)
>
> and I am getting following output
>
>> tapply(rate, rating, mean)
> AAA BBB CCC
> 9.1104 11.1361637 17.1606779
>
> which is correct when compared with an excel output.
>
> However, I wish to have my output something like a data.frame (so that I should be able to save this output as csv file with respective headings and should be able to carry out further analysis)
>
> Rating Mean
> AAA 9.1104
> BBB 11.1361637
> CCC 17.1606779
>
>
> Please guide as how should I achieve my output like this.
>
> Thanking in advance.
>
> Regards
>
> Vincy
>
>
>
>
>
>
> [[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.
--
====================================
Vito M.R. Muggeo
Dip.to Sc Statist e Matem `Vianelli'
Università di Palermo
viale delle Scienze, edificio 13
90128 Palermo - ITALY
tel: 091 23895240
fax: 091 485726/485612
http://dssm.unipa.it/vmuggeo
More information about the R-help
mailing list