Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Updating primpos.mdb   Message List  
Reply | Forward Message #3800 of 3878 |
Re: [baseball-databank] Re: Updating primpos.mdb

That's awesome Tom, I didn't know that, sorry for making an assumption.  Is there anything that automatically updates data within the current season?

On Thu, Sep 3, 2009 at 9:47 AM, Tangotiger <tom@...> wrote:
PrimPos.mdb is dynamic.  It'll automatically recalculate the positions any
data the data set changes.

Tom

> Thanks. I actually wrote a few functions as part of a php library to
> handle the data. One is a method of determining primary position and
> another is a list of positions played by the player in at least a
> variable percentage of their innings. I also have a determinant of SP
> vs RP vs CL.  I have other functions as well such as
> ReturnAgeAtSeasonStart, returnarrayofteamsplayedfor and a whole lot
> more.
>
>
> The only thing I want to add is a method of weighting more recent data
> and possibly degrading data over a fixed/variable amount of years
> (depending on age,position,etc.) for the data to make more accurate
> determinations.
>
> I think it's better to make a determination "on the fly"  as opposed
> to using a fixed database especially if data is being updated at some
> point.  A static database of player-position can get stale, especially
> if the user forgets to include this years and used 2007's by accident.
>
> I'm definitely interested in discussing further, especially if I
> missed the point entirely - which is something I tend to do since I
> try to think abstractly.
>
> Matthew Gargano
>
>
>
> On Sep 3, 2009, at 5:31 AM, "sgtmac5660@..." <sgtmac5660@...>
> wrote:
>
>> Matthew;
>> If you feel that Tom's primpos.mdb is something you might be
>> interested in using, just be aware you need to make some changes to
>> use it with later versions of the Lahman Access database. Feel free
>> to contact me if you need any assistance.
>> Mac
>>
>> --- In baseball-databank@yahoogroups.com, Matthew Gargano
>> <mgargano@...> wrote:
>>>
>>> pardon my ignorance, but what is the primpos.mdb database?
>>
>>
>>
>>
>> ------------------------------------
>>
>> http://www.baseball-databank.org/Yahoo! Groups Links
>>
>>
>>
>


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com




------------------------------------

http://www.baseball-databank.org/Yahoo! Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/baseball-databank/

<*> Your email settings:
   Individual Email | Traditional

<*> To change settings online go to:
   http://groups.yahoo.com/group/baseball-databank/join
   (Yahoo! ID required)

<*> To change settings via email:
   mailto:baseball-databank-digest@yahoogroups.com
   mailto:baseball-databank-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
   baseball-databank-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
   http://docs.yahoo.com/info/terms/




Thu Sep 3, 2009 1:49 pm

tkestars
Offline Offline
Send Email Send Email

Forward
Message #3800 of 3878 |
Expand Messages Author Sort by Date

Tangotiger; I found your "primpos.mdb" in the files section. I would like to use your queries with the Lahman 5.6 database. My interest is career prime...
sgtmac5660@...
sgtmac5660...
Offline Send Email
Sep 1, 2009
2:48 pm

That would seem to be correct. Try it out, and see what you get. Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com...
Tangotiger
tom@...
Send Email
Sep 1, 2009
3:40 pm

Tom; Worked like a charm. Just what I needed. Mac...
sgtmac5660@...
sgtmac5660...
Offline Send Email
Sep 2, 2009
12:52 pm

pardon my ignorance, but what is the primpos.mdb database?...
Matthew Gargano
tkestars
Offline Send Email
Sep 2, 2009
12:56 pm

It's in the Files section. I don't remember if I put a Readme file with it. It's an Access query that figures out the primary position of every player....
Tangotiger
tom@...
Send Email
Sep 2, 2009
2:05 pm

Matthew; If you feel that Tom's primpos.mdb is something you might be interested in using, just be aware you need to make some changes to use it with later...
sgtmac5660@...
sgtmac5660...
Offline Send Email
Sep 3, 2009
11:17 am

Thanks. I actually wrote a few functions as part of a php library to handle the data. One is a method of determining primary position and another is a list of...
Matthew Gargano
tkestars
Offline Send Email
Sep 3, 2009
12:44 pm

PrimPos.mdb is dynamic. It'll automatically recalculate the positions any data the data set changes. Tom ... The Book--Playing The Percentages In Baseball ...
Tangotiger
tom@...
Send Email
Sep 3, 2009
1:47 pm

That's awesome Tom, I didn't know that, sorry for making an assumption. Is there anything that automatically updates data within the current season?...
Matthew Gargano
tkestars
Offline Send Email
Sep 3, 2009
4:55 pm

... Best bet is to join the RetroSQL group. There's a couple of (external) ongoing things that are highlighted there. Tom...
Tangotiger
tom@...
Send Email
Sep 3, 2009
5:10 pm

I joined and searched retrosql and did not see anything for current year stats. Is there some kind of guide or readme on how things work on the group?...
Matthew Gargano
tkestars
Offline Send Email
Sep 12, 2009
3:08 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help