HI,
If I understand it correctly,
try this:
dat1<-read.table(text="
Year Market Winner BID
1990 ABC Apple 0.1260
1990 ABC Apple 0.1395
1990 EFG Pear 0.1350
1991 EFG Apple 0.1113
1991 EFG Orange 0.1094
",sep="",header=TRUE,stringsAsFactors=FALSE)
dat1[with(dat1,{Year==1990 & Market=="ABC"}),]
#or
dat1[((grepl("ABC{0,1}",dat1$Market))&(grepl("1990",dat1$Year))),]
# Year Market Winner BID
#1 1990 ABC Apple 0.1260
#2 1990 ABC Apple 0.1395
A.K.
----- Original Message -----
From: kangam3 <jowe.tjioe.2...@business.smu.edu.sg>
To: r-help@r-project.org
Cc:
Sent: Saturday, September 15, 2012 5:22 AM
Subject: [R] how to view only readings of a selected data from a column while
the other columns remain
Hi Friends
I am new here and have a problem
Year Market Winner BID
1 1990 ABC Apple 0.1260
2 1990 ABC Apple 0.1395
3 1990 EFG Pear 0.1350
4 1991 EFG Apple 0.1113
5 1991 EFG Orange 0.1094
For each year and separately for the two markets (i.e.,ABC,EFG), examine the
combined data for Apple and Pear on the bid price variable BID for presence
of potential outliers.5 Identify instances where you observe the presence of
potential outliers.
I managed to separate the data by year only
y <- c(1, seq(300))
> year1991 <- subset(X, y < 39)
> year1991
Year1991 <- year1991[, c(1,2,3,5)]
> Year1991
now I need help on whats the right R command to key to select(View) only ABC
of the Market COLUMN, which the other column values remains.
Is it possible to do multiple separation at one time? or step by step
Kindly advise :)
--
View this message in context:
http://r.789695.n4.nabble.com/how-to-view-only-readings-of-a-selected-data-from-a-column-while-the-other-columns-remain-tp4643216.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@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@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.
