[R] Choosing subset of data.frame
arun
smartpink111 at yahoo.com
Fri Jun 21 00:34:26 CEST 2013
HI,
You could also use:
beta_results[!is.na(match(beta_results[,1],instru)),]
# instrument beta_values
#3 JKL 0.529
#6 STU -1.080
#8 XYZ 0.420
#If there are no duplicates, this could also work
beta_results[match(instru,beta_results[,1]),]
# instrument beta_values
#3 JKL 0.529
#6 STU -1.080
#8 XYZ 0.420
A.K.
----- Original Message -----
From: Katherine Gobin <katherine_gobin at yahoo.com>
To: "r-help at r-project.org" <r-help at r-project.org>
Cc:
Sent: Thursday, June 20, 2013 6:45 AM
Subject: [R] Choosing subset of data.frame
Dear R Forum
I have a data frame as
beta_results = data.frame(instrument = c("ABC", "DEF", "JKL", "LMN", "PQR", "STU", "UVW", "XYZ"),
beta_values = c(1.27, -0.22, 0.529, 0.011, 2.31, -1.08, -2.7, 0.42))
> beta_results
instrument beta_values
1 ABC 1.270
2 DEF -0.220
3 JKL 0.529
4 LMN 0.011
5 PQR 2.310
6 STU -1.080
7 UVW -2.700
8 XYZ 0.420
Through some other process, I am getting instrument names as say (which may change each time I run this process
and hence I can't hard code it).
instru = c("JKL", "STU", "XYZ")
Now I want the subset of beta_results, (say beta_results_A) pertaining to only instru i.e
beta_results_A =
instrument beta_values
3 JKL 0.529
6 STU -1.080
8 XYZ 0.420
I did try
beta_results_A = beta_results[instru]
or
beta_results_A = subset(beta_results, beta_results$instrument = instru]
but I guess it's failing.
Kindly guide
Regards
Katherine
[[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