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