Determining (potential) villains for a hand
Results 1 to 7 of 7
  1. #1
    Junior Member
    Join Date
    Jul 2008
    Posts
    7

    Default Determining (potential) villains for a hand

    I'm trying to write a query that determines the potential villains involved in a hand. A potential villain would be anyone who:
    • enters a hand before hero (i.e. VPIPs) or
    • is left to act after hero enters hand.

    I know I can get the villains' player_ids for a hand using the playervsplayer table, but this won't tell me anything about their positions or actions in the hand. Am I going to have to manually extract this information by looking at each villain's hand in the playerhandscashkeycolumns table or is there an easier way to do this?

  2. #2
    Junior Member
    Join Date
    Jul 2008
    Posts
    7

    Default

    Morny, Rvg72? I am a proud owner of HEM and am using its DB for a school project on data mining and machine learning. Any thoughts here?

  3. #3
    Senior Member
    Join Date
    Jan 2009
    Posts
    103

    Default

    you can get all the info you are looking for from playerhandscashkeycolumns

    positiontype_id , preflopaction_id, firstpreflopaction_id can give you all the info you need.

  4. #4
    Senior Member
    Join Date
    Jan 2009
    Posts
    103

    Default

    oh, and what excactly do you want to know about villain? only if they are involved in a pot at the same time you are? be a little more specific and I could whip up a query in no time.

  5. #5
    Junior Member
    Join Date
    Jul 2008
    Posts
    7

    Default

    PCP Poker,

    I currently plan to get each villain's VPIP and then average all the VPIPs into a "average VPIP" column. However, I might want to get additional stats from each villain in the future (e.g. PFR, fold to cbet%, etc.).

  6. #6
    Senior Member
    Join Date
    Jan 2009
    Posts
    103

    Default

    okay, that's gonna be a little more involved. a perl or php script would probably be much more effective than a simple sql query. when I have a second tomorrow, i could give you some pointers on how to accomplish this. or even write you a script for a small fee...

  7. #7
    Junior Member
    Join Date
    Jul 2008
    Posts
    7

    Default

    I can do post-processing of the data using Python, so just having a bunch of raw data to work with would be fine.

    And since this is a school project, I probably shouldn't pay anyone to do my work for me.

    Thanks for your help.

Similar Threads

  1. Villains cards not showing @ showdown?
    By stretch00 in forum Manager General
    Replies: 7
    Last Post: 02-12-2009, 02:08 PM
  2. Statistics Question: Determining Optimal Sample Size
    By PCP Poker in forum Manager General
    Replies: 16
    Last Post: 02-07-2009, 10:41 PM
  3. hand text for hand conversion
    By inƒamous in forum Manager General
    Replies: 1
    Last Post: 10-09-2008, 12:23 PM
  4. HEM potential buyer
    By mohow in forum Manager General
    Replies: 3
    Last Post: 08-29-2008, 02:36 PM
  5. Setting up HM (potential buyer) baby steps
    By the dude in forum Manager General
    Replies: 1
    Last Post: 08-29-2008, 10:13 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •