[R] Lahman Baseball Data Using R DBI Package

[Bill Dunlap]

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 <herd_dog using cox.net> 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 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.
>
> Can anyone give me some direction?
>
> Thanks,
> Philip Heinrich
>
> ***************************************************************************************************************************************************
> tail(dbReadTable(Lahman,"batting"))
>
> ID                       playerID      yearID    stint teamID team_ID
> lgID   G        G_batting   AB     R     H       X2B    X3B   HR   RBI   SB
> 107414 107414 yastrmi01      2019       1       SFN       2920      NL
>  107        NA          371   64  101      22       3     21     55    2
> 107416 107416 yelicch01      2019        1       MIL       2911      NL
>  130        NA          489 100  161      29       3     44    97   30
> 107419 107419 youngal01     2019       1       ARI        2896      NL
>    17        NA            25     1      1        0       0       0      0
>    0
> 107420 107420 zagunma01   2019        1      CHN       2901      NL
> 30        NA             36     2      9        3       0      0       5
>  0
> 107422 107422 zavalse01      2019        1      CHA       2900      AL
>     5        NA             12     1      1        0       0      0
>  0     0
> 107427 107427 zimmery01     2019        1      WAS      2925      NL
> 52        NA           171   20    44        9      0      6      27     0
> 107428 107428 zobribe01       2019        1      CHN      2901      NL
>   47        NA           150   24   39         5      0      1      17     0
> 107429 107429 zuninmi01       2019        1      TBA       2922      AL
>   90        NA           266    30  44       10      1      9      32     0
>
>
> Hack11Batting <- dbGetQuery(Lahman,"SELECT playerID,yearID,AB,R,H,2B,3B,HR,
>                             RBI,SB,CS,BB,SO,IBB,HBP,SH,SF,GIDP FROM batting
>                             WHERE yearID = 2018 AND AB >99")
> Error: unrecognized token: "2B"
>
>  Hack11Batting <- dbGetQuery(Lahman,"SELECT
> playerID,yearID,AB,R,H,X2B,X3B,HR,
>                             RBI,SB,CS,BB,SO,IBB,HBP,SH,SF,GIDP FROM batting
>                             WHERE yearID = 2018 AND AB >99")
> Error: no such column: X2B
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>

	[[alternative HTML version deleted]]