Re: [R] Rotation Forest Error Message

2020-08-21 Thread Rasmus Liland
On 2020-08-21 16:22 +1200, Abby Spurdle wrote: | On Fri, Aug 21, 2020 at 4:16 PM Abby Spurdle wrote: | | On Fri, Aug 21, 2020 at 1:06 PM Sparks, John wrote: | | | | | | Hi R Helpers, | | | | | | I wanted to try the rotationForest | | | package. | | | | | | I pointed it at my data set and | | |

[R] plot.window: need finite 'ylim' values

2020-08-21 Thread Mike
Dear R users, I have already asked this in r-sig-finance (not getting a solution) but it seems to be plot-related anyway. I like to plot several financial charts to files with an identical layout according to "indicators" so the charts can be browsed quickly. quantmod::chart_Series is a function

[R] filter() question

2020-08-21 Thread Dr Eberhard Lisse
Hi, I have a small test sample with lab reports (PAP smears) from a number of different providers. These have Collection Dates and the relevant columns glimpse() something like this: $ Provider"Dr C", "Dr D", "Dr C", "Dr D" $ CollectionDate "2016-11-03", "2016-11-02", "2016-11-03", "20

Re: [R] filter() question

2020-08-21 Thread Rasmus Liland
On 2020-08-21 09:03 +0200, Dr Eberhard Lisse wrote: > Hi, > > I have a small test sample with lab > reports (PAP smears) from a number of > different providers. These have > Collection Dates and the relevant > columns glimpse() something like > this: > > $ Provider"Dr C", "Dr D", "D

Re: [R] filter() question

2020-08-21 Thread Eric Berger
Hi Eberhard, Here is one possibility using dplyr. library(dplyr) set.seed(3) ## set up some fake data dtV <- as.Date("2020-08-01") + 0:4 x <- sample(dtV,20,repl=TRUE) provider <- sample(LETTERS[1:3],20,repl=TRUE) lDf <- data.frame(Provider=provider,CollectionDate=x,stringsAsFactors=FALSE) ## get

Re: [R] plot.window: need finite 'ylim' values

2020-08-21 Thread Jim Lemon
Hi Mike, Try this: plot (chart_Series (sample.xts[,1], subset=subset, TA=ta), type="n",ylim=c(minimum,maximum)) where minimum and maximum are the extremes of the plot if there were any valid values. Jim On Fri, Aug 21, 2020 at 6:32 PM Mike wrote: > > Dear R users, > > I have already asked thi

Re: [R] filter() question

2020-08-21 Thread Dr Eberhard Lisse
Eric, Rasmus, thank you very much, ALLPAP %>% group_by(Provider) %>% mutate( minDt=min(CollectionDate), maxDt=max(CollectionDate)) %>% summarize( minDt = min(minDt), maxDt = max(maxDt),

Re: [R] filter() question

2020-08-21 Thread Jeff Newmiller
Using mutate followed by summarise in this case is completely unnecessary. a <- ( lDf %>% dplyr::group_by( Provider ) %>% dplyr::summarise( u = min( CollectionDate ) ,, v = max( CollectionDate ) ) ) On August 21, 2020 2:41:26 AM P

Re: [R] filter() question

2020-08-21 Thread Rasmus Liland
On 2020-08-21 13:45 +0200, Dr Eberhard Lisse wrote: | | Eric, Rasmus, | | thank you very much, | |ALLPAP %>% |group_by(Provider) %>% |mutate( minDt=min(CollectionDate), |maxDt=max(CollectionDate)) %>% |summarize( mi

Re: [R] Rotation Forest Error Message

2020-08-21 Thread Sparks, John
Thanks Abby and Rasumus. I like to leave the solution on this list for the next potential person. I had failed to realize that this package doesn't use one of the formula forms. So my call of RotFor2000<-rotationForest(up~.,data=modeldata) is what caused the error. After converting to the a

Re: [R] filter() question

2020-08-21 Thread Dr Eberhard Lisse
Rasmus, thank you, I am an elderly Gynecologist, dabbling a little, ie exactly the clientele for which the tidyverse "thingy" was developed :-)-O. In addition I like readable code so I later understand what I was trying to do :-)-O el On 2020-08-21 16:15 , Rasmus Liland wrote: > On 2020-08-2

[R] Export R outputs to SAS dataset

2020-08-21 Thread Jomy Jose
Hi I was able to run R code via PROC IML in SAS,so is there any way to export the generated outputs to SAS datasets since the R outputs don't follow data frame structure. Thanks in advance Jose [[alternative HTML version deleted]] __ R-help@r-p

[R] readxl question

2020-08-21 Thread Thomas Subia via R-help
Colleagues, I have 250 Excel files in a directory. Each of those files has the same layout. The problem is that the data in each Excel data is not in rectangular form. I've been using readxl to extract the data which I need. Each of my metrics are stored in a particular cell. For each metric, I

[R] readxl question

2020-08-21 Thread Thomas Subia via R-help
Colleagues, I have 250 Excel files in a directory. Each of those files has the same layout. The problem is that the data in each Excel data is not in rectangular form. I've been using readxl to extract the data which I need. Each of my metrics are stored in a particular cell. For each metric, I