[R] Calculating percentages across multiple columns

Daisy Englert Duursma daisy.duursma at gmail.com
Thu Aug 9 02:52:53 CEST 2012


Your question is very unclear.Can you provide a better question or at
least a column of outputs you expect and an example with the dataframe
you provided?

On Thu, Aug 9, 2012 at 8:29 AM, Abraham Mathew <abmathewks at gmail.com> wrote:
> I have the following data and am trying to find the percentage of bid
> values purchased for that price.
>
> So let's say I have a bid of 5 and it's sold 2 times for $3 and $5. Since
> the original bid was $5, the
> percentage of times that that bid value results in a sold purchase AT that
> specific bid level was
> 1/3 because of the three time where the bid was three, it ended up being
> sold for $5 one time.
>
> So I'm wonder how to generate that info in R. The percentage of a bid being
> sold at the same purchase
> price. Can anyone point me in the right direction.
>
> f = data.frame(bid=c(3,5,5,8,3,5,4,2,3,5), purchase=c(6,3,4,5,5,5,6,2,3,7),
>                sold=c(0,1,0,0,0,1,1,0,0,1))
> f
>
>
> Thanks.
>
>
> --
> *Abraham Mathew
> Statistical Analyst
> www.amathew.com
> 720-648-0108
> @abmathewks*
>
>         [[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.



More information about the R-help mailing list