[R] Help with Hmisc, cut2, split and quantile
guygreen at netvigator.com
Mon Mar 8 16:47:57 CET 2010
I have a set of data with two columns: "Target" and "Actual". A
http://n4.nabble.com/file/n1584647/Sample_table.txt Sample_table.txt is
attached but the data looks like this:
I want to be able to break the data into tables based on quantiles in the
"Target" column. I can see (using cut2, and also quantile) how to get the
barrier points between the different quantiles, and I can see how I would
achieve this if I was just looking to split up a vector. However I am
trying to break up the whole table based on those quantiles, not just the
The following code shows me the ranges for the deciles of the "Target" data:
read_data=read.table("C:/Sample table.txt", head = T)
However I would like to be able to break the table into ten separate tables,
each with both "Actual" and "Target" data, based on the "Target" data
top_decile = ...(top decile of "read_data", based on Target data)
next_decile = ...and so on...
bottom_decile = ...
That way I could manipulate the deciles, graph them separately (and
together) and so on, just as easily as I can the whole table. I'm sure this
must be simple, but I can't see the way forward. I have also looked at
split() and quantile() but have not been able to get them to achieve what I
am after. Can anybody see a simple way foward on this?
View this message in context: http://n4.nabble.com/Help-with-Hmisc-cut2-split-and-quantile-tp1584647p1584647.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help