R help - Jan 2013 - Inserting percentile values in a data frame

Hello

I need to calculate and insert the values for the 50,75,90,95 & 99
percentiles in a data frame for each row.

I used agr1$quantile <- quantile(agr1$cnt, probs=c(.50, .75, .90, .95, .99))
but that didn't work.
How can calculate the percentile for my variable "cnt"  , insert &
name the
percentile as p50, p75, etc 
in my data frame agr1?


Thanks in advance for your thoughts/suggestions.



--
View this message in context:
http://r.789695.n4.nabble.com/Inserting-percentile-values-in-a-data-frame-tp4654539.html
Sent from the R help mailing list archive at Nabble.com.

it doesn't work because you're trying to save something of the wrong
length
into your data frame

I used agr1$quantile <- quantile(agr1$cnt, probs=c(.50, .75, .90, .95,
.99))
>
# these two numbers should be the same
nrow( agr1 )
length( agr1$quantile )

# these two numbers should be the same
length( c(.50, .75, .90, .95, .99) )
length( quantile(agr1$cnt, probs=c(.50, .75, .90, .95, .99)) )

# but all four of those numbers aren't the same.  there's one answer for
each percentile, not one answer for each row.

# if you want the entire column in your agr1 data frame to contain the same
number,
# you could potentially add quantiles one at a time
agr1$median <- quantile( agr1$cnt , 0.5 )
agr1$p75 <- quantile( agr1$cnt , 0.75 )
# but that may look silly, since it's the same number over and over
head( agr1 )
# why not save them elsewhere?  :)

	[[alternative HTML version deleted]]