[R] how to view only readings of a selected data from a column while the other columns remain

[arun]

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.2012 at business.smu.edu.sg>
To: r-help at 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 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.