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))
Homework. There's a no homework policy, but see ?aggregate.
Rui Barradas
Em 15-09-2012 10:22, kangam3 escreveu:
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))
This looks a lot like homework. However here is a hint
ABD1990 <- subset(xx, Year == 1990 & Market == "ABC")
John Kane
Kingston ON Canada
-----Original Message-----
From: jowe.tjioe.2012 at business.smu.edu.sg
Sent: Sat, 15 Sep 2012 02:22:42 -0700 (PDT)
To: r-help at r-project.org
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))
____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at http://www.inbox.com/smileys
Works with AIM?, MSN? Messenger, Yahoo!? Messenger, ICQ?, Google Talk? and most webmails
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))
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.
An identical question was posted on StackOverflow. Not only is there a no homework policy, there is also a no cross-posting policy.
David.
>
> 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.
David Winsemius, MD
Alameda, CA, USA