[R] Calculating percentages across multiple columns

[Rui Barradas]

Hello,

If I understand it well, the following should do it.


dd <- subset(f, sold == 1)
at <- with(dd, bid == purchase)
mean(at)  # wanted value

Hope this helps,

Rui Barradas

Em 09-08-2012 01:52, Daisy Englert Duursma escreveu:
> 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.
> ______________________________________________
> 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.