Hi, May be this helps: dat1<-read.table(text=" 1 2006-11 NaN 2 2006-12 NaN 3 2006-10 0.1577647 4 2006-11 NaN 5 2006-12 NaN 6 2007-01 NaN 7 2007-02 NaN 8 2007-03 0.2956429 9 2007-01 NaN 10 2007-02 NaN ",sep="",header=FALSE,stringsAsFactors=FALSE) res<-dat1[seq(which(!is.na(dat1$V3))[1],which(!is.na(dat1$V3))[2],by=1),] res # V1 V2 V3 #3 3 2006-10 0.1577647 #4 4 2006-11 NaN #5 5 2006-12 NaN #6 6 2007-01 NaN #7 7 2007-02 NaN #8 8 2007-03 0.2956429 A.K.
----- Original Message ----- From: Vasilchenko Aleksander <vasilchenko....@gmail.com> To: r-help@r-project.org Cc: Sent: Wednesday, December 5, 2012 5:46 AM Subject: [R] Trim Hello, I have a dataframe 1 2006-11 NaN 2 2006-12 NaN 3 2006-10 0.1577647 4 2006-11 NaN 5 2006-12 NaN 6 2007-01 NaN 7 2007-02 NaN 8 2007-03 0.2956429 9 2007-01 NaN 10 2007-02 NaN I need to trim first and last NaN rows Result - 1 2006-10 0.1577647 2 2006-11 NaN 3 2006-12 NaN 4 2007-01 NaN 5 2007-02 NaN 6 2007-03 0.2956429 Thanks. ______________________________________________ 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.
