Hello,
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:
Actual Target
-0.125 0.016124906
0.135 0.120799865
... ...
... ...
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
vector.
The following code shows me the ranges for the deciles of the "Target" data:
library(Hmisc)
read_data=read.table("C:/Sample table.txt", head = T)
table(cut2(Read_data$Target,g=10))
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
deciles:
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?
Thanks,
Guy