Re: [R] Lahman Baseball Data Using R DBI Package

The double quotes are required by SQL if a name is not of the form letter-followed-by-any-number-of-letters-or-numbers or if the name is a SQL keyword like 'where' or 'select'. If you are doing this from a function, you may as well quote all the names. -Bill On Fri, Oct 2, 2020 at 6:18 PM

Re: [R] help in R code

Hi Faheem, This is a complete guess, but the hours of the day may range from 0 to 23 not 1 to 24. So you may be asking for an out of range hour. Jim On Fri, Oct 2, 2020 at 10:00 PM Faheem Jan via R-help wrote: > > > Hello , i am working in the functional time series using the multivariate >

Re: [R] Lahman Baseball Data Using R DBI Package

Have you tried putting double quotes around 2B and 3B: "...2B, 3B, ..." -> "...\"2B\",\"3B\",..."? -Bill On Fri, Oct 2, 2020 at 3:49 PM Philip wrote: > I’m trying to pull data from one table (batting) in the Lahman Baseball > database. Notice X2B for doubles and X3B for triples – fourth and

[R] Lahman Baseball Data Using R DBI Package

I’m trying to pull data from one table (batting) in the Lahman Baseball database. Notice X2B for doubles and X3B for triples – fourth and fifth from the right. The dbGetQuery function runs fine when I leave there two out but I get error messages (in red) when I include 2B/3B or X2B/X3B.

[R] Unable to compile with R CMD INSTALL on windows when sourcing from Rprofile

Hello, I am currently facing a rather unusual situation. I am running the following command on two windows 10 machines: C:\\Program Files\\R\\R-3.6.3\\bin\\R.exe CMD INSTALL -l ".envs\\default\\lib"

[R] What is the threshold for `useRaster` of graphics::image()?

Hi R-help list What is the threshold for the `useRaster` argument of graphics::image() to decide whether a grid is "regular" or not (i.e. the usage of useRaster=T is allowed or not). My `dev.capabilities("rasterImage")$rasterImage` is "yes". I could not find this information in the internet. I

Re: [R] summarize_all Function

Thanks Bill – got it From: Bill Dunlap Sent: Thursday, October 1, 2020 1:56 PM To: reichm...@sbcglobal.net Cc: r-help@r-project.org Subject: Re: [R] summarize_all Function The warning gives some suggestions. E.g., replace funs(sum,prod) with list(sum=sum,prod=prod). % R CMD Rscript

Re: [R] summarize_all Function

Thanks Rui -Original Message- From: Rui Barradas Sent: Thursday, October 1, 2020 1:49 PM To: reichm...@sbcglobal.net; r-help@r-project.org Subject: Re: [R] summarize_all Function Hello, Any of the two will do, the first is now preferred. library(dplyr) mtcars %>%

[R] help in R code

Hello , i am working in the functional time series using the multivariate time series data(hourly time series data). Sir  i am using FAR model more than one order for which no statistical package is available in R, so for this i convert my data into functional form and obtained the functional