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.
