search for: valkremk

...,header = TRUE,stringsAsFactors=FALSE) > preval<-data.frame(Col1=unique(unlist(mydat[,c("Col2","col3")]))[-1], > Col2=NA,col3=NA) > rbind(preval,mydat) > mydat[is.na(mydat)]<-"0" > > Jiim > > > On Sun, Feb 25, 2018 at 11:05 AM, Val <valkremk at gmail.com> wrote: > > Sorry , I hit the send key accidentally here is my complete message. > > > > Thank you Jim and all, I got it. > > > > I have one more question on the original question > > > > What does this "[-1] " do? > >...

...c("Col2","col3")])) > napos<-which(is.na(val23)) > preval<-data.frame(Col1=val23[-napos], > Col2=NA,col3=NA) > mydat<-rbind(preval,mydat) > mydat[is.na(mydat)]<-"0" > mydat > > Jim > > On Sun, Feb 25, 2018 at 11:27 AM, Val <valkremk at gmail.com> wrote: > > Thank you Jim, > > > > I read the data as you suggested but I could not find K1 in col1. > > > > rbind(preval,mydat) > > Col1 Col2 col3 > > 1 <NA> <NA> <NA> > > 2 X1 <NA> <NA> > > 3...

...AsFactors=FALSE) val23<-unique(unlist(mydat[,c("Col2","col3")])) napos<-which(is.na(val23)) preval<-data.frame(Col1=val23[-napos], Col2=NA,col3=NA) mydat<-rbind(preval,mydat) mydat[is.na(mydat)]<-"0" mydat Jim On Sun, Feb 25, 2018 at 11:27 AM, Val <valkremk at gmail.com> wrote: > Thank you Jim, > > I read the data as you suggested but I could not find K1 in col1. > > rbind(preval,mydat) > Col1 Col2 col3 > 1 <NA> <NA> <NA> > 2 X1 <NA> <NA> > 3 Y1 <NA> <NA> > 4 K2 <N...

...ike "failure to launch". At what point will you start showing your (failed) attempts at solving your own problems so we can help you work on your specific weaknesses and become self-sufficient? -- Sent from my phone. Please excuse my brevity. On February 25, 2018 7:55:55 AM PST, Val <valkremk at gmail.com> wrote: >HI Jim and all, > >I want to put one more condition. Include col2 and col3 if they are >not >in col1. > >Here is the data >mydat <- read.table(textConnection("Col1 Col2 col3 >K2 X1 NA >Z1 K1 K2 >Z2 NA NA >Z3 X1 NA >Z4 Y1 W1&q...

...ocessed data out" when reading chunks of a file. And you would almost certainly not be getting that error if you were not out of memory. A good rule of thumb is that you need 4 times as much free memory to process data than you need to read it in. On November 8, 2024 6:08:16 PM PST, Val <valkremk at gmail.com> wrote: >Hi Jeff, > >Memory was not an issue. The system only used 75% of the memory >allocated for the job. > > I am trying to understand what "r read large file in chunks" is doing. > >On Fri, Nov 8, 2024 at 7:50?PM Jeff Newmiller <jdnewmil at...

...; <NA> 3 Y1 <NA> <NA> 4 K2 <NA> <NA> 5 W1 <NA> <NA> 6 Z1 K1 K2 7 Z2 <NA> <NA> 8 Z3 X1 <NA> 9 Z4 Y1 W1 I could not find K1 in the first col1. Is that possible to fix this? On Sat, Feb 24, 2018 at 5:59 PM, Val <valkremk at gmail.com> wrote: > Thank you Jim and all, I got it. > > I have one more question on the original question > > What does this "[-1] " do? > preval<-data.frame(Col1=unique(unlist(mydat[,c("Col2","col3")]))[-1], > Co...

...Then you don't have enough memory to process the whole thing at once. Not unlike stuffing your mouth with cookies and not being able to chew for lack of space to move the food around in your mouth. > > Now, can you answer my question? > > On November 8, 2024 5:38:37 PM PST, Val <valkremk at gmail.com> wrote: > >The data was read. The problem is with processing. > > > >On Fri, Nov 8, 2024 at 7:30?PM Bert Gunter <bgunter.4567 at gmail.com> wrote: > >> > >> Is the problem reading the file in or processing it after it has been read in? >...

...Z1 K1 K2 Z2 NA NA Z3 X1 NA Z4 Y1 W1"),header = TRUE,stringsAsFactors=FALSE) preval<-data.frame(Col1=unique(unlist(mydat[,c("Col2","col3")]))[-1], Col2=NA,col3=NA) rbind(preval,mydat) mydat[is.na(mydat)]<-"0" Jiim On Sun, Feb 25, 2018 at 11:05 AM, Val <valkremk at gmail.com> wrote: > Sorry , I hit the send key accidentally here is my complete message. > > Thank you Jim and all, I got it. > > I have one more question on the original question > > What does this "[-1] " do? > preval<-data.frame(Col1=unique(unlist...

...general, is it? I'd think that should be x[!is.na(x1)] <- 0 x2 <- x1 Of course, in this example, x1 is 0, so it gives the same answer. Duncan Murdoch > > > Bill Dunlap > TIBCO Software > wdunlap tibco.com > > On Sat, Feb 24, 2018 at 9:59 AM, Val <valkremk at gmail.com> wrote: > >> Thank you Jim >> >> I wanted a final data frame after replacing the NA's to "0" >> >> x1 = rbind(unique(preval),mydat) >> x2 <- x1[is.na(x1)] <- 0 >> x2 >> but I got this, >> >> [1]...

...7 AM, Jim Lemon <drjimlemon at gmail.com> wrote: > Hi Val, > Try this: > > preval<-data.frame(Col1=unique(unlist(mydat[,c("Col2","col3")]))[-1], > Col2=NA,col3=NA) > rbind(preval,mydat) > > Jim > > On Sat, Feb 24, 2018 at 3:34 PM, Val <valkremk at gmail.com> wrote: > > Hi All, > > > > I am reading a file as follow, > > > > mydat <- read.table(textConnection("Col1 Col2 col3 > > Z2 NA NA > > Z3 X1 NA > > Z4 Y1 W1"),header = TRUE) > > > > 1. "NA" are miss...

Then you don't have enough memory to process the whole thing at once. Not unlike stuffing your mouth with cookies and not being able to chew for lack of space to move the food around in your mouth. Now, can you answer my question? On November 8, 2024 5:38:37 PM PST, Val <valkremk at gmail.com> wrote: >The data was read. The problem is with processing. > >On Fri, Nov 8, 2024 at 7:30?PM Bert Gunter <bgunter.4567 at gmail.com> wrote: >> >> Is the problem reading the file in or processing it after it has been read in? >> >> Bert >&gt...

...You asked why x2 was zero. The value of the expression f(a) <- b and assignments are processed right to left so x2 <- x[!is.na(x1)] <- 0 is equivalent to x[!is.na(x1)] <- 0 x2 <- 0 Bill Dunlap TIBCO Software wdunlap tibco.com On Sat, Feb 24, 2018 at 9:59 AM, Val <valkremk at gmail.com> wrote: > Thank you Jim > > I wanted a final data frame after replacing the NA's to "0" > > x1 = rbind(unique(preval),mydat) > x2 <- x1[is.na(x1)] <- 0 > x2 > but I got this, > > [1] 0 > > why I am getting this? > > &...

...<NA> > 5 2006 M 14 ac 256 AV 35 14 ac 256 AV 35 > 6 2007 F 11 11 <NA> <NA> <NA> <NA> > > As I noted previously, all columns beyond Sex are character > > Cheers, > Bert > > > On Fri, Jul 19, 2024 at 12:26?PM Val <valkremk at gmail.com> wrote: > > > > Thank you Jeff and Bert for your help! > > The components of the string could be nixed (i.e, numeric, character > > or date). Once that is splitted it would be easy for me to format it > > accordingly. > > > > On Fri, Jul 1...

...x[!is.na(x1)] <- 0 > x2 <- x1 > > Of course, in this example, x1 is 0, so it gives the same answer. > > Duncan Murdoch > > > >> >> Bill Dunlap >> TIBCO Software >> wdunlap tibco.com >> >> On Sat, Feb 24, 2018 at 9:59 AM, Val <valkremk at gmail.com> wrote: >> >> Thank you Jim >>> >>> I wanted a final data frame after replacing the NA's to "0" >>> >>> x1 = rbind(unique(preval),mydat) >>> x2 <- x1[is.na(x1)] <- 0 >>> x2 >>> but I g...

...2024 at 5:13?PM Jeff Newmiller via R-help <r-help at r-project.org> wrote: >> >> Can you tell us what is wrong with the "chunked" package which comes up when you Google "r read large file in chunks"? >> >> On November 8, 2024 4:58:18 PM PST, Val <valkremk at gmail.com> wrote: >> >Hi All, >> > >> >I am reading data file ( > 1B rows) and do some date formatting like >> > dat=fread(mydatafile) >> > dat$date1 <- as.Date(ymd(dat$date1)) >> > >> >However, I am getting an erro...

Hi All, I generated 5000 samples using the following script test<- rnorm(5000,1000,100) test1 <- subset(test, subset=(test > 1100)) d <- density(test) plot(d, main="Density of production") abline(v=mean(test1) I wanted to do the following but faced difficulties 1. to shade or color (blue) the curve using the criterion that any

...13 25 13 25 <NA> <NA> <NA> 5 2006 M 14 ac 256 AV 35 14 ac 256 AV 35 6 2007 F 11 11 <NA> <NA> <NA> <NA> As I noted previously, all columns beyond Sex are character Cheers, Bert On Fri, Jul 19, 2024 at 12:26?PM Val <valkremk at gmail.com> wrote: > > Thank you Jeff and Bert for your help! > The components of the string could be nixed (i.e, numeric, character > or date). Once that is splitted it would be easy for me to format it > accordingly. > > On Fri, Jul 19, 2024 at 2:10?PM Bert Gunter <...

Hi all I am trying t extract a variable from a column ASk/20005-01-45/90 Alldatk/25-17-4567/990 I want to assign a variable to the numbers coming the first"-" x=01 for the first and x=17 for teh second I tried using gsub but did not work x=gsub("-") any help? [[alternative HTML version deleted]]

...t; out into their own columns. I believe that they are character in the > solutions, but you should check this. If you want them as numeric, > e.g., for further processing, you will need to convert them. Or > vice-versa. > > Bert > > > On Fri, Jul 19, 2024 at 9:52?AM Val <valkremk at gmail.com> wrote: > > > > Hi All, > > > > I want to extract new variables from a string and add it to the dataframe. > > Sample data is csv file. > > > > dat<-read.csv(text="Year, Sex,string > > 2002,F,15 xc Ab > > 2003,F,14 > &...

...Cheers, > Bert > > Bert Gunter > > "The trouble with having an open mind is that people keep coming along and > sticking things into it." > -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) > > On Thu, May 17, 2018 at 5:48 PM, Val <valkremk at gmail.com> wrote: > >> Hi All, >> >> I have a sample of data set show as below. >> tdat <- read.table(textConnection("stat year Y >> AL 2003 25 >> AL 2003 13 >> AL 2004 21 >> AL 2006 20 >> AL 2007 12 >> AL...