Displaying 7 results from an estimated 7 matches for "herd_dog".
2020 Oct 03
1
Lahman Baseball Data Using R DBI Package
...e 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 Philip <herd_dog at cox.net> wrote:
> The \?2B\? worked. Have no idea why. Can you point me somewhere that can
> explain this to me.
>
> Thanks,
> Philip
>
> *From:* Bill Dunlap
> *Sent:* Friday, October 2, 2020 3:54 PM
> *To:* Philip
> *Cc:* r-help
> *Subject:* Re: [R] Lahman...
2020 Oct 08
0
Lahman Baseball Data Using R DBI Package
...t 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 Philip <herd_dog at cox.net> wrote:
>
> > The \?2B\? worked. Have no idea why. Can you point me somewhere that can
> > explain this to me.
> >
> > Thanks,
> > Philip
> >
> > *From:* Bill Dunlap
> > *Sent:* Friday, October 2, 2020 3:54 PM
> > *To:* Philip...
2020 Oct 06
0
Installing Perl For Use in R
...option of creating an account with them, or using Github. I would opt for the former, even though I have a Github account.
If you are on Windows, an alternative Perl distribution is Strawberry Perl:
http://strawberryperl.com
Regards,
Marc Schwartz
> On Oct 6, 2020, at 11:21 AM, Philip <herd_dog at cox.net> wrote:
>
> I?m getting nowhere with this. From the website below I clicked on the ActivePerl 5.26 button which seems to lead me into creating projects on the Cloud rather than downloading the software to my hard drive.
>
> https://www.activestate.com/products/perl/...
2020 Oct 08
1
Lahman Baseball Data Using R DBI Package
...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 Philip <herd_dog at cox.net> wrote:
> >
> > > The \?2B\? worked. Have no idea why. Can you point me somewhere that
> can
> > > explain this to me.
> > >
> > > Thanks,
> > > Philip
> > >
> > > *From:* Bill Dunlap
> > > *Sent:* Frid...
2020 Oct 06
2
Installing Perl For Use in R
I?m getting nowhere with this. From the website below I clicked on the ActivePerl 5.26 button which seems to lead me into creating projects on the Cloud rather than downloading the software to my hard drive.
https://www.activestate.com/products/perl/downloads/
Can someone give me some advise? What the website is trying to do seems rather shady.
Thanks,
Philip
[[alternative HTML version
2020 Oct 02
3
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.
Can anyone give me some direction?
Thanks,
Philip Heinrich
2020 Oct 08
0
Retrosheet Data
Have used Jim Albert?s code to extract baseball data from Retrosheet.
function(team){
P <- getRetrosheet("play",2013,team)
get_plays <- function(j) data.frame(Game=P[[j]]$id[1],P[[j]]$play)#from $id and $play section of retrosheet data
do.call("rbind",lapply(1:length(P),get_plays))
}
all_plays <- do.call("rbind",lapply(Teams[1:30],get_team_plays))