Two Plus Two Older Archives

Two Plus Two Older Archives (http://archives2.twoplustwo.com/index.php)
-   One-table Tournaments (http://archives2.twoplustwo.com/forumdisplay.php?f=34)
-   -   Data mining (http://archives2.twoplustwo.com/showthread.php?t=339139)

tjh 09-17-2005 10:57 PM

Data mining
 
Has anyone done any data mining of the SNG hands that they have in Poker Tracker ?

I am thinking about dumping the database tables to MySQL and running some queries on them. I am quite familiar with MySQL and SQL but I also see no need to reinvent the wheel so I thought I would see if anyone has done similar work.

Seems like it would be trivial to get data that would be useful such as ...
Range of hands that players push in level x
Range of hands that players call an all-in in level x

Seems like you could test a lot of assumptions. Such as
"how much tighter do they get on the bubble ? "
Or
"how effective is a stop and go compared to a preflop push? "

So if anyone wants to discuss data structure, data mining and some sample SQL queries then please use this thread to discuss.

Thanks

Tom

brimstone1 09-18-2005 03:43 AM

Re: Data mining
 
Just out of curiosity, which level are you planning on doing this for?

tjh 09-19-2005 02:22 AM

Re: Data mining
 
I play the 22's at party and the 22's at UB so that is all that I have data for. Judging by the lack of response to this thread nobody else is messing around with data mining. I will let the forum know when I give it a try because I assume someone may want to run my queries on larger more meaningful data sets at various levels.

--
tjh

swiftrhett 09-19-2005 10:18 PM

Re: Data mining
 
Poker tracker already stores it in access or postgresql. I'm also more experienced with mysql, but are you really going to convert the whole database rather than just do some postgresql queries?


All times are GMT -4. The time now is 12:57 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.