[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,

[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,

[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]] __

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

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

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(

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

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] 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

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) ##

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",

[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",

[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

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 | | |

Re: [R] & and |

2020-08-21 Thread Ivan Calandra
Thank you Bert, this is wonderful! Best wishes, Ivan -- Dr. Ivan Calandra TraCEr, laboratory for Traceology and Controlled Experiments MONREPOS Archaeological Research Centre and Museum for Human Behavioural Evolution Schloss Monrepos 56567 Neuwied, Germany +49 (0) 2631 9772-243