Hi Raghu,
Using the example you provided. If you want Q3 for year 2011 and 2013.
dat[grep("2011 Q3|2013 Q3", Qtr1),] #change accordingly
# ID Phase RESEARCH Area Date Result
#1 100 IV S_Care A&P 7/23/2013 Positive
#5 2005 IV Speci TH 8/4/2011 <NA>
#6 2006 III Speci BN 7/13/2011 Positive
A.K.
Thanks a lot for the reply Arun.
I would like to pull the quarter for that particular year. say i want Q2 for
year 2014 r Q2 for year 2013.
You assistance is very much appreciated.
Thanks Raghu
On Wednesday, June 11, 2014 10:19 AM, arun <smartpink...@yahoo.com> wrote:
Hi,
Please Check ?as.yearqtr() fromlibrary(zoo)
dat <- read.table(text="ID Phase RESEARCH Area Date Result
100 IV S_Care A&P 7/23/2013 Positive
1001 IV P_Care EU 12/20/2012 Positive
2001 IV Car AS 9/13/2012 Positive
20003 III Spec IN 10/6/2011 NA
2005 IV Speci TH 8/4/2011 NA
2006 III Speci BN 7/13/2011 Positive
21345 II Pri HY 2/3/2011
Positive",sep="",header=TRUE,stringsAsFactors=FALSE)
library(zoo)
Qtr1 <- as.yearqtr(dat$Date, format="%m/%d/%Y")
dat[grep("Q3",Qtr1),]
# ID Phase RESEARCH Area Date Result
#1 100 IV S_Care A&P 7/23/2013 Positive
#3 2001 IV Car AS 9/13/2012 Positive
#5 2005 IV Speci TH 8/4/2011 <NA>
#6 2006 III Speci BN 7/13/2011 Positive
A.K.
Hi ,
I have a dataset as below,
ID Phase RESEARCH Area Date Result
100 IV S_Care A&P 7/23/2013 Positive
1001 IV P_Care EU 12/20/2012 Positive
2001 IV Car AS 9/13/2012 Positive
20003 III Spec IN 10/6/2011 NA
2005 IV Speci TH 8/4/2011 NA
2006 III Speci BN 7/13/2011 Positive
21345 II Pri HY 2/3/2011 Positive
I would like to pull data based on the Quarter, for example say if i want data
for 3rd quarter based on the date column how do i do it.
I tried the lubridate package but was not able to get the required result.
can any one of you assist me on this.
Your help is very much appreciated.
______________________________________________
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.
