a D$j @s:dZddlZddlZddlZddlZddlmZej j ddde de dd d \Z Zd d gZgd ZdddZddedDZejeddZejedddded<eedZeeddkeddk@ZgZeD]ZdeZeeee keeek@Zedjedd Zeed!<eeed"<ed#ed$ed%<ed&eed'<e eqejeddZ!e!jd"d(d)jedd Z!e!dj"dd*Z!e#e!d%dkd+e!d%ej$e!d,<e!d-e!d!%ek&e'e!d.<e!j(gd/d0j"dd*Z!e#e!d.d1ke!d,d1d2e!d3<d4d5Z)d6d7Z*e+d8e,e!d9e+d:e+d;e!-d<d3.j/Z0e0D]Z1e*e1e!e!j2e1kqxe+d=e+d>e3e!j24d?de!j24DZ5e+d@e5e+d=e+dAe5Z6e*dBe!e*dCe!e!j27dDdEge*dFe!e!j27e6e*dGe!e!j27e6dS)Hz Test the user's hypothesis: did the edge drop after adding BSA, USL, Sweden, Norway? Reconstructs the exact signal set (mirrors strategy.ipynb / _ideas_study.py) but does NOT apply EXCLUDE, so we can see every league's contribution. Pure analysis. N)statszutf-8replace)encodingerrorsz E:\soccerz display.width)g?gQ?homeaway)Z game_daterrHA)rrcCs,g|]$}|dr|dkrtd|qS)z.csvztest.csvz live_data/)endswithpdZread_csv).0fr0E:\soccer\research\analysis\_league_breakdown.py srZ live_dataT)Z ignore_indexZ timestampZmixedZcoerce)formatrZtsZstatusZPREelapsedZ clv_kalshi_first)ZkeepsideZclvZkalshi_Z_askZaskZ pin_fair_p_winF)Z ascending)Zdropg?oddsftrwon)rrr)ZsubsetgnetcCsRt|}|dkr tdtdfS||jddt|}|dtj|fS)Nnanr)Zddof) lenfloatmeanZstdnpZsqrtrZnormZcdf)rnzrrrzp,s r$cCst|dkr"td|dddSt|dj\}}td|ddt|dd|jd d |jd d |jd d|dd|ddS)Nrz z<26z n= 0rz n=z>4z | WR z>5.1%z | ROI z>+7.1%z | net z>+7.1fzu | z=z+.2fz p=z.3f)rprintr$valuesrr rsum)namesr#prrrline3s r+zALL leagues, no exclusions: n= z_===============================================================================================z+PER-LEAGUE breakdown (sorted by net units):leaguez` ===============================================================================================zAvailable league codes:cs&g|]tfdddDrqS)c3s|]}|vVqdS)N)upper)r kcrr Dz.)BSAUSLZSWEZSWZNORZNO)any)r rr0rrCszauto-matched flagged-ish codes:zIWITH vs WITHOUT the flagged leagues (edit FLAGGED below if codes differ):zALL (current live set)zdrop USL,BSA onlyr5r4zdrop all flaggedz ONLY flagged)8__doc__ossysZnumpyr!Zpandasr Zscipyrstdout reconfigurechdirZ set_optionZEDGE_LOZEDGE_HIZSIDESZGAMEZ SIDE_LETTERlistdirZdfsconcatZdfZ to_datetimeZnotnacopyZpreZentriesrr1qZ sort_valuesZdrop_duplicatesappendZsigZ reset_indexwherermapZastypeintZdropnar$r+r%rgroupbyr'indexorderZlgr-sorteduniqueZflaggedZFLAGGEDZisinrrrrsf         $ "