What do you mean when you say "deleted from the files"? You are discussing using space delimited files. What do you want to occupy the places where those letters are? --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity.
"zilefacel...@yahoo.com" <zilefacel...@yahoo.com> wrote: > > Hi A.K, > >Thanks for this great help. I wish to find -999.99M and replace with >NA. > All others like T, A, F etc should be deleted from the files. > > > Thanks for much. > ------ Original Message ------ > > From : arun > To : Zilefac Elvis; > Cc : R help; > Sent : 27-04-2013 16:29 > Subject : Re: [R] Help > >HI, > >"Find 'T','C','A','F' and 'Y', delete them from all the 110 files" >I assume that you meant to replace it with NA. > > >set.seed(28) >myfiles<- lapply(1:5,function(i) >as.data.frame(matrix(sample(c(LETTERS,"-999.99 >M"),40*i,replace=TRUE),ncol=(40*i)/8),stringsAsFactors=FALSE)) > myfiles[[1]] ># V1 V2 V3 V4 V5 >#1 A P K O Y >#2 C Z S M Y >#3 M S -999.99M G I >#4 X R M G X >#5 C Q G A P >#6 U W G B K >#7 A N Z X R >#8 X I F M K > > >res<-lapply(myfiles,function(x) {x1<-unlist(x); x1[x1%in% >c("-999.99M","T","C", >"A","F","Y")]<-NA;as.data.frame(matrix(x1,ncol=ncol(x)),stringsAsFactors=FALSE) >}) > >res[[1]] > # V1 V2 V3 V4 V5 >#1 P K O >#2 Z S M >#3 M S G I >#4 X R M G X >#5 Q G P >#6 U W G B K >#7 N Z X R >#8 X I M K > >lapply(seq_along(res),function(i) >write.table(res[[i]],paste0("file",i,".txt"), >row.names=FALSE,quote=FALSE)) >A.K. > > >----- Original Message ----- >From: Zilefac Elvis >To: "r-help@r-project.org" >Cc: >Sent: Saturday, April 27, 2013 11:20 AM >Subject: [R] Help > >Hello, > > > >I have a question and need your help urgently. I am new to R but want >to learn >it. > >I have several files in a folder which I have imported to R using : >temp = list.files(pattern="*.txt") >>myfiles = lapply(temp, read.delim) >The resulting files are on the workspace stored as List[110]. So they >are 110 f >iles in the list. Each file has several different columns and rows. >My question: I would like to find and replace -999.99M with NA; Find >'T','C','A >','F' and 'Y', delete them from all the 110 files. >Then, I want to write.table all the corrected files back to a folder on >my comp >uter. >Thanks for your help. >Atem. > > > >________________________________ >From: "r-help-requ...@r-project.org" > >Sent: Friday, April 26, 2013 11:08 AM >Subject: confirm bfdc3137cee0135cf3c616295c9d0e2b3adfd392 > > >Mailing list subscription confirmation notice for mailing list R-help > >We have received a request from 129.132.148.130 for subscription of > >r-help@r-project.org mailing list. To confirm that you want to be >added to this mailing list, simply reply to this message, keeping the >Subject: header intact. Or visit this web page: > >https://stat.ethz.ch/mailman/confirm/r-help/bfdc3137cee0135cf3c616295c9d0e2 >b3adfd392 > > >Or include the following line -- and only the following line -- in a >message to r-help-requ...@r-project.org: > > confirm bfdc3137cee0135cf3c616295c9d0e2b3adfd392 > >Note that simply sending a `reply' to this message should work from >most mail readers, since that usually leaves the Subject: line in the >right form (additional "Re:" text in the Subject: is okay). > >If you do not wish to be subscribed to this list, please simply >disregard this message. If you think you are being maliciously >subscribed to the list, or have any other questions, send them to >r-help-ow...@r-project.org. > [[alternative HTML version deleted]] > >______________________________________________ >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. ______________________________________________ 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.