Hello, I've searched the forum but couldnt find anything
I need to subsample hands for a specific player (that i have e.g. 20k hands) and get the stats for these subsamples. For example get the stats of his first 1k hands than of his second and so on.
If you wonder why I need it: I want to do some cross validation on a weighted winrate...
Im not so experienced in sql, so the only thing i thought could work was to filter in the where clause, but i cannot use aggregate fcts (to count the hands) and limiting the id_hand to a treshold wont produce samples of same size, i presume?!?
The last thing that comes to my mind is export every HH for a player to matlab and devide it and calculate stats in there.
