ó
    =±ÛjyZ  ã                  óÌ   • S r SSKJr  SSKJr  SSKrSSKJr  SSKJ	r	  SSK
r
SSKrSSKrSSKJrJrJrJrJrJrJrJr  1 S	krS
rS rS rS rS rS rS rS r S r!S r"SS jr#g)a7  Extend canonical training metadata with the established AQ transcript table.

Only DDTBHP's verified schema (or its raw course_history.joblib DataFrame) is
accepted. Sources are read-only. Synthetic timestamps inherit the native AQ
semester-order assumption; they do not certify actual grade publication dates.
é    )Úannotations)ÚdefaultdictN)ÚPath©Úquoteé   )ÚAVAILABILITY_ASSUMPTIONÚTIMESTAMP_SEMANTICSÚ_canonical_idÚ	_integersÚ_missingÚ_originÚ_sha256Úsemester_ordinal>   ÚIDMHÚIDSVÚNHHKÚDiemHPÚ
DiemHPCalci † c                ó<  • U R                  5       (       d  g U S-  nUR                  5       (       a  UR                  5       $ [        S U R	                  S5       5       5      n[        U5      S:”  a  [        SU  SU 35      eU(       a  US   R                  5       $ S $ )Nz
DDTBHP.csvc              3  ó”   #   • U  H>  nUR                  5       (       d  M  UR                  R                  5       S :X  d  M:  Uv •  M@     g7f)z
ddtbhp.csvN)Úis_fileÚnameÚcasefold)Ú.0Úps     ÚD/root/disk_3tb/earlywarning/30072026/suite35_pace/pace/aq_history.pyÚ	<genexpr>Ú_csv_source.<locals>.<genexpr>!   s;   é € ð NÒ#7˜aØŸ9™9Ÿ;ó Ø+,¯6©6¯?©?Ó+<ÀÑ+L÷ ™Ò#7ùs   ‚AŸA¿	AÚ*r   z#Ambiguous DDTBHP.csv sources under ú: r   )Úis_dirr   ÚresolveÚsortedÚrglobÚlenÚ
ValueError)Ú	directoryÚdirectÚ
candidatess      r   Ú_csv_sourcer+      s™   € Ø×Ñ×ÑØØ˜Ñ%€FØ‡~�~×ÑØ�~‰~ÓÐÜñ N 9§?¡?°3Ô#7ó Nó N€Jä
ˆ:ƒ˜ÓÜÐ>¸y¸kÈÈJÈ<ÐXÓYÐYÞ&0ˆ:�a‰=× Ñ Ó"Ð:°dÐ:ó    c                ó4  • S nUbC  [        U5      R                  5       R                  5       n[        U5      nUc  [	        SU 35      eUbh  [        U5      R                  5       R                  5       nUR                  5       (       a  US-  nUR                  5       (       d  [	        SU 35      eUS4$ Ub  US4$ [        U R                  S-  5      nUb  US4$ SnU H7  nU S-  U-  S	-  nUR                  5       (       d  M%  UR                  5       S4s  $    g
)Nz4DDTBHP.csv not found in explicit database directory zcourse_history.joblibz%Explicit AQ history index not found: Ú	raw_indexÚ
DDTBHP_csvÚdatabase)Úsuite12_structured_cacheÚsuite17_structured_cacheÚ*suite17_robust_forward_specialist_boostingÚresultszraw_index/course_history.joblib©NN)r   Ú
expanduserr#   r+   ÚFileNotFoundErrorr"   r   Úparent)ÚrootÚdatabase_dirÚhistory_indexÚexplicit_csvr(   ÚpathÚknownr   s           r   Ú_sourcer?   (   s-  € ð €LØÑÜ˜Ó&×1Ñ1Ó3×;Ñ;Ó=ˆ	Ü" 9Ó-ˆØÑÜ#Ð&ZÐ[dÐZeÐ$fÓgÐgØÑ Ü�MÓ"×-Ñ-Ó/×7Ñ7Ó9ˆØ�;‰;�=‰=ØÐ1Ñ1ˆDØ�|‰|�~‰~Ü#Ð&KÈDÈ6Ð$RÓSÐSØ�[Ð Ð ØÑØ˜\Ð)Ð)Ü�t—{‘{ ZÑ/Ó0€DØÑØ�\Ð!Ð!ð;€EãˆØ�iÑ $Ñ&Ð)JÑJˆØ�<‰<�>‹>Ø—<‘<“> ;Ð.Ò.ñ ð r,   c              #  óú   #   • US:X  a(  [         R                  " U [        S[        S9 S h  v•N   g [        R
                  " U 5      n[        U[         R                  5      (       d  [        U  S35      eUv •  g  NM7f)Nr/   F)ÚdtypeÚkeep_default_naÚ	chunksizez(: raw course history must be a DataFrame)	ÚpdÚread_csvÚstrÚ_CHUNK_SIZEÚjoblibÚloadÚ
isinstanceÚ	DataFramer'   )r=   ÚkindÚframes      r   Ú_chunksrN   H   sj   é € Øˆ|Óä—;’;˜t¬3ÀÜ)4ñ6÷ 	6ñ 	6ô —’˜DÓ!ˆÜ˜%¤§¡×.Ñ.Ü ˜vÐ%MÐNÓOÐOØ‹ñ	6ùs   ‚)A;«A9¬AA;c                ó`   • [        [        U /S5      S   5      n[        U5        [        U5      $ )NzDDTBHP.NHHK semesterr   )Úintr   r   rF   )ÚvalueÚnumbers     r   Ú	_semesterrS   T   s-   € Ü”˜E˜7Ð$:Ó;¸AÑ>Ó?€FÜ�VÔÜˆv‹;Ðr,   c                óR  • [        U 5      (       a  [        R                  S4$  [        U 5      n[        R                  " U5      (       d  [        R                  S4$ SUs=::  a  S::  d  O  [        R                  S4$ US 4$ ! [        [
        4 a    [        R                  S4s $ f = f)NÚmissingÚinvalidr   é
   Úout_of_range)r   ÚnpÚnanÚfloatÚ	TypeErrorr'   Úisfinite)rQ   Úgrades     r   Ú_grader_   Z   s“   € Ü�‡�Ü�v‰v�yÐ Ð ð!Ü�e“ˆô �;Š;�u×ÑÜ�v‰v�yÐ Ð Ø�Õ˜ÕÜ�v‰v�~Ð%Ð%Ø�$ˆ;Ðøô ”zÐ"ó !Ü�v‰v�yÐ Ò ð!ús   ¤B Â"B&Â%B&c                ó   • U S   U S   U S   4$ )NÚ
student_idÚ	course_idÚsemester© )Úrows    r   Ú_tuplerf   h   s   € Øˆ|Ñ˜c +Ñ.°°J±Ð?Ð?r,   c                ó,  • [        U 5      [        U5      :w  a  [        US-   5      e[        R                  " U S   5      (       aP  [        R                  " US   5      (       a1  [        R                  " U S   US   SSS9(       d  [        US-   5      eg g g )Nz": student/course/semester conflictr^   ç•Ö&è.>r   ©ÚatolÚrtolz: grade conflict)rf   r'   rY   r]   Úisclose)ÚleftÚrightÚmessages      r   Ú_compatiblerp   l   s‚   € Üˆdƒ|”v˜e“}Ó$Ü˜Ð#GÑGÓHÐHÜ
�Š�D˜‘M×"Ñ"¤r§{¢{°5¸±>×'BÑ'BÜ—J’J˜t G™}¨e°G©nÀ4Èa×PÜ˜Ð#5Ñ5Ó6Ð6ð Qð (CÐ"r,   c                óÐ   • U R                  S5      n[        U5      (       dE  [        U5      S;  d$  [        [        U5      5      [        US:  5      :w  a  [	        SU S   -   5      eg g )NÚfailure_label)ç        g      ð?é   z)Canonical/raw failure label conflict for Úevent_id)Úgetr   r[   rP   r'   )Ú	canonicalr^   Úlabels      r   Ú_label_compatiblery   t   s_   € Ø�M‰M˜/Ó*€EÜ�E�?‰?Ü�‹<˜xÓ'¬3¬u°U«|Ó+<ÄÀEÈAÁIÃÓ+NÜÐHÈ9ÐU_ÑK`Ñ`ÓaÐað ,Oð r,   c                óŽ	  • / 0 pT[        [        5      n[        X5       GH=  n[        [	        U5      -
  nU(       a  [        U  S[        U5       35      eUS==   [        U5      -  ss'   UR                  S5       GH³  n	 [        U	S   S5      n
X¢;  a  US==   S-  ss'   M(   [        U	S	   5      n[        U	S   S5      nU	R                  S5      n[        U5      (       a  S O[        US5      nU	S   nU	S   n[        U5      u  nn[         R"                  " [         R$                  " USS95      nU(       a  [        U5      u  nnUS:X  a  US:X  a  SnOUUnnU=(       a    US L n['        X¯UUUS9nUb  UR                  U5      OS nUb  [)        UUSU< S35        U(       a  USU S3==   S-  ss'   Ub  Uc  UUU'   GMH  U(       a   US==   S-  ss'   US:X  a  US ==   S-  ss'   U	R                  S!5      n[        U5      US"'   US"   (       a  S#nUS$==   S-  ss'   O8 [+        U5      n[.        R0                  " U5      (       a  US&:  a  [        S%5      eUUS''   UbE  S(U;   a?  [.        R2                  " US'   US)S&S*9(       d  [        SU< S+35      eUS,==   S-  ss'   GM-  Ub  S-[5        US.S/9-   US('   UUU'   O\/ [7        U5      Q[9        US05      P[9        US05      P7nUU   nUU==   S-  ss'   S1S2R;                  S3 U 5       5      -   S2U 3-   US('   UR                  U5        GM¶     [=        S4US    S5[        U5       S6US
    S7US8    3S9S:9  GM@     U(       a†  [        X5       Hw  nSU;  a  M  USS/   R?                  S;S S<9 HS  u  nn [        U5      (       a  M  [        US5      nUU;   d  M,  [        U S5      n
X¥U   S=   :w  d  ME  [        SU< S>35      e   My     [        U5      US?'   U$ ! [
         a    US==   S-  ss'    GM�  f = f! [
         az    US
==   S-  ss'   [        U	S	   5      nUS==   [        U5      -  ss'   U(       a  SO[        U	S	   5      S S nUS   nXÞ;  a   [        U5      S:  a  UR                  U5         GM$  f = f! [,        [
        4 a  n[        S%5      UeS nAff = f)@Nz%: unsupported DDTBHP schema; missing Úraw_rows_scannedÚrecordsr   zDDTBHP.IDSVÚraw_rows_invalid_student_idr   Úraw_rows_unselected_studentsr   Ú!raw_invalid_semester_rows_droppedÚ!raw_missing_semester_rows_droppedz	<missing>é(   Úraw_invalid_semester_examplesrW   r   zDDTBHP.IDMHÚ
IDCongDiemzDDTBHP.IDCongDiemr   r   Úcoerce)ÚerrorsrU   rV   )ra   rb   rc   r^   Úgrade_record_idzduplicate grade ID ú	 conflictÚraw_Ú_grade_rows_droppedÚraw_grades_coalescedÚ$raw_invalid_primary_grades_recoveredÚSoTinChiÚ_credits_missingrs   Ú raw_missing_credits_default_zeroz2DDTBHP.SoTinChi must be finite nonnegative creditsr   Úcreditsru   rh   ri   z conflict: credits conflictÚraw_duplicate_grade_ids_removedúgrade|Ú ©Úsafez.17gzraw|Ú|c              3  ó6   #   • U  H  n[        US S9v •  M     g7f)r’   r“   Nr   ©r   Úxs     r   r   Ú_read_raw.<locals>.<genexpr>Ö   s   é € Ð6VÒRUÈQ´u¸QÀRÖ7HÒRUùs   ‚zAQ TRANSCRIPT scanned=z
 retained=z invalid_semester_dropped=z missing_grade_dropped=Úraw_missing_grade_rows_droppedT©ÚflushF)Úindexr   ra   z conflict: student conflictÚraw_usable_events) r   rP   rN   Ú_REQUIRED_RAWÚsetr'   r$   r&   Úto_dictr   rS   r   rF   Úappendrv   r_   rD   ÚisnaÚ
to_numericÚdictrp   r[   r\   rY   r]   rl   r   rf   ÚformatÚjoinÚprintÚ
itertuples)!r=   rL   ÚstudentsÚauditr|   Úby_grade_idÚoccurrencesÚchunkrU   ÚvaluesÚstudentrc   Úmissing_semesterÚexampleÚexamplesÚcourseÚraw_idÚgrade_idÚprimaryÚfallbackÚprimary_gradeÚprimary_problemÚprimary_numeric_missingr^   ÚproblemÚ	coalescedÚrecordÚpreviousÚcreditÚexcÚkeyÚ
occurrenceÚraw_students!                                    r   Ú	_read_rawrÅ   {   si  € Ø˜rˆ[ÜœcÓ"€KÜ˜×$ˆÜ¤# e£*Ñ,ˆÞÜ ˜vÐ%JÌ6ÐRYË?ÐJ[Ð\Ó]Ð]ØÐ Ó!¤S¨£ZÑ/Ó!Ø—m‘m I×.ˆFðÜ'¨¨v©¸ÓF�ð Ó&ØÐ4Ó5¸Ñ:Ó5Ùð
	Ü$ V¨F¡^Ó4�ô # 6¨&¡>°=ÓAˆFØ—Z‘Z Ó-ˆFÜ'¨×/Ñ/‘t´]À6ÐK^Ó5_ˆHØ˜XÑ&ˆGØ˜lÑ+ˆHô .4°G«_Ñ*ˆM˜?Ü&(§g¢g¬b¯mªm¸GÈHÑ.UÓ&VÐ#Þ&Ü!'¨Ó!1‘��wØ˜iÓ'¨O¸yÓ,HØ'�Gøà!.°�w�Ø/×C°G¸t°OˆIô  WÈØ %°xñAˆFà4<Ñ4H�{—‘ xÔ0ÈdˆHØÑ#Ü˜H fÐ0CÀHÁ<ÈyÐ.YÔZÞØ˜˜W˜IÐ%8Ð9Ó:¸aÑ?Ó:ØÑ'¨HÑ,<Ø,2�K Ñ)ÚÞØÐ,Ó-°Ñ2Ó-Ø" iÓ/ØÐ@ÓAÀQÑFÓAØ—Z‘Z 
Ó+ˆFÜ)1°&Ó)9ˆFÐ%Ñ&ØÐ(×)Ø�ØÐ8Ó9¸QÑ>Ô9ðdÜ" 6›]�Fô —{’{ 6×*Ñ*¨f°q«jÜ$Ð%YÓZÐZØ &ˆF�9ÑØÑ#¨
°hÓ(>Ü—z’z (¨9Ñ"5°vÀDÈq×QÜ$Ð':¸8¹,ÐFaÐ%bÓcÐcØÐ7Ó8¸AÑ=Ó8ÚØÑ#Ø%-´°hÀRÑ0HÑ%H��zÑ"Ø(.�˜HÒ%ð Wœ˜v›ÐV¬¨u°fÓ(=ÐV¼vÀfÈfÓ?UÑV�Ø(¨Ñ-�
Ø˜CÓ  AÑ%Ó Ø%+¨c¯h©hÑ6VÑRUÓ6VÓ.VÑ%VÐ[\Ð]gÐ\hÐYiÑ%i��zÑ"Ø�N‰N˜6×"ñi /ôj 	Ð& uÐ-?Ñ'@Ð&AÀÌCÐPWËLÈ>ð Z*Ø*/Ð0SÑ*TÐ)Uð V'Ø',Ð-MÑ'NÐ&OðQàW[õ	]ñu %ö@ Ü˜TÖ(ˆEØ 5Ó(ÙØ',¨l¸FÐ-CÑ'D×'OÑ'OÐV[ÐbfÐ'OÓ'gÑ#�˜Ü˜F×#Ñ#ÙÜ(¨Ð1DÓE�Ø˜{Õ*Ü+¨K¸ÓG�GØ¨hÑ"7¸Ñ"EÕEÜ(Ð+>¸x¹lÐJeÐ)fÓgÐgó (hñ )ô "% W£€EÐ
ÑØ€NøôK ó ØÐ3Ó4¸Ñ9Ó4Ûðûô ó ØÐ9Ó:¸aÑ?Ó:Ü#+¨F°6©NÓ#;Ð ØÐ9Ó:¼cÐBRÓ>SÑSÓ:Þ)9™+¼sÀ6È&Á>Ó?RÐSVÐTVÐ?W�Ø Ð!@ÑA�ØÓ*¬s°8«}¸rÓ/AÀ(Ç/Á/ÐRYÔBZÛðûôb "¤:Ð.ó dÜ$Ð%YÓZÐ`cÐcûðdús=   Â O=Â$PÈ$R#Ï=PÐPÐA?R ÒR Ò#SÒ3R?Ò?Sc                óR  ^ ^+^,^-^.• [        U 5      R                  5       R                  5       n [        XU5      u  pES Vs0 s H  ofS_M     nnUR	                  [
        / S[        [        U5      SS9  Uc#  UR	                  SSS	9  UR                  5       U0 4$ S
[        U5      -   [        U5      0nUR	                  S[        U5      US9  UR                  5       R                  S5      m+[        [        5      n	UR                  R                  S0 5      R!                  5        Hm  u  p«[#        U
S5      n
[%        U[&        [(        [        45      (       a  U(       a  [+        S U 5       5      (       a  [-        S5      eXš   R	                  U5        Mo     T+ GHO  nS H  n[#        XÆ   SU-   5      XÆ'   M     [/        US   5      US'   [#        US   S5      US'   [1        US   5      u  pÞUS;  a  [-        S5      eXÜS'   UR                  S5      n[3        U5      (       a  SO[#        US5      US'   UR                  S5      n[3        U5      (       a  [        US   5      /O[4        R6                  " U5      n[%        U[&        5      (       a  [+        S U 5       5      (       a  [-        S5      eXœS       R	                  U5        XœS       R9                  [        US   5      5        GMR     [;        S!U S"[        U	5       3S#S$9  [=        XE[        U	5      U5      m.US%   (       a  [;        S&US%    S'US(    S)3S#S$9  [?        T.5       VVs0 s H  u  nnUS   c  M  US   U_M     nnn[        [&        5      n[?        T.5       H#  u  nnU[A        U5         RC                  U5        M%     [        5       m,0 m-0 n/ nT+ H‡  nUS   nUba  UU;   a[  UU   n[E        UUS*U< S+35        [F        RH                  " US   5      (       a  [K        UUS   5        US   US'   US,==   S--  ss'   Ml  URC                  U5        Uc  M‚  UUU'   M‰     Um+[?        T+5       Hg  u  nnUS   nUc  M  UU;   d  M  UU   n[E        UT.U   S.U< S+35        [K        UT.U   S   5        UT-U'   T,R9                  U5        US/==   S--  ss'   Mi     [M        U-4S0 j[O        [        T+5      5       5       U+4S1 jS29n[        [&        5      nU HM  nT+U   nUS   b  M  [F        RH                  " US   5      (       d  M0  U[A        U5         RC                  U5        MO     U GH>  nT+U   nU[A        U5          Vs/ s H  nUS   b  T.U   S   b  M  UPM     nnU Vs/ s H  nUT,;  d  M  UPM     nn[F        RH                  " US   5      nU(       a;  UnU Vs/ s H,  n[F        RP                  " US   T.U   S   S3SS49(       d  M*  UPM.     nnU(       d9  US   c3  [+        U,4S5 jU 5       5      (       a  [-        S6[A        U5      < S735      eU(       aR  U(       dK  W(       aD  [M        U Vs1 s H  nT.U   S   iM     sn5      n[-        S8[A        U5      < S9US    S:U S;35      eU(       d  GMP  U(       a«  US   c¥  U[A        U5          V s/ s H4  n U T-;  d  M  [F        RP                  " T+U    S   US   S3SS49(       d  M2  U PM6     n!n [        U!5      S-:”  aI  [        U!5      [        U5      :”  a1  [-        S<[A        U5      < S=[        U!5       S>[        U5       S?35      e[        U5      S-:”  aI  U Vs1 s H  nT.U   S   T.U   S@   4iM     n"nU(       a  [        U"5      S-:”  a  [-        SAUS   < SB35      eU(       dš  U V ^ s/ s Hs  m T U:w  d  M  T T-;  d  M  [F        RH                  " T+T    S   5      (       a  M6  [A        T+T    5      [A        U5      :X  d  MS  [+        U+U U.4SC jU 5       5      (       d  Mq  T PMu     n#n U#(       a  [-        SDUS   < 35      e[S        UU.4SE jS29n[K        UT.U   S   5        UT-U'   T,R9                  U5        USF==   S--  ss'   GMA     / n$[?        T+5       GH/  u  nnUT-;   Ga  T.T-U      n%[F        RH                  " US   5      (       d  U%S   US'   USG==   S--  ss'   UR                  SHSI5      n&[3        U&5      (       + =(       a    [U        U&5      n'U'(       a%  U%SJ   (       d  U%S@   US@'   SIUSH'   USK==   S--  ss'   OIU'(       dB  U%SJ   (       d8  [F        RP                  " [W        US@   5      U%S@   S3SS49(       d  USL==   S--  ss'   U%S   b  U%S   US'   US   b  SM[Y        US   SNSO9-   OU%S   US'   U$RC                  U5        GM2     [?        T.5       H:  u  nnUT,;  d  M  SIUSH'   [M        XœS       5      S   US'   U$RC                  U5        M<     U$ HX  n[4        RZ                  " [M        XœS       5      SISP9US'   []        [_        US   5      5      [`        Rb                  " SQSR9-   USS'   MZ     ['        URd                  5      n(SU(;  a  U(RC                  S5        [`        Rf                  " U$U(ST9n)U)Rh                  Rk                  5       R+                  5       (       a  [-        SU5      eU)Rm                  U)Rn                  Rq                  [^        5      SV9Rs                  / SWQSXSY9Rt                  n*U)Rv                  U*   Ry                  S SZ/SIS[9R{                  5       R}                  5       S--   U)Rv                  U*S\4'   U)S\   R                  [F        R€                  5      U)S\'   UR	                  [        T+5      [        T-5      -
  [        T.5      [        T,5      -
  [        U)5      S]9  U)Rƒ                  S#S^9Xx4$ s  snf s  snnf s  snf s  snf s  snf s  snf s  sn f s  snf s  sn f )_aº  Return reconciled events, audit, and SHA-256 of original source bytes.

Known grade identities reconcile first. Remaining observed-grade records
match one-to-one by normalized student/course/semester and grade. Multiple
otherwise equivalent candidates are interchangeable only when credits also
agree; missing canonical grades require a unique unmatched tuple candidate.
Distinct known grade IDs are distinct attempts even when tuples agree.
)r{   r~   r}   r   r€   rš   Úraw_invalid_grade_rows_droppedÚ#raw_out_of_range_grade_rows_droppedrŽ   rŠ   r‹   r�   rž   Úcanonical_exact_id_matchesÚcanonical_tuple_matchesÚ"canonical_missing_grades_recoveredÚ#canonical_missing_credits_recoveredÚ)canonical_raw_observed_credit_differencesÚ%canonical_duplicate_grade_ids_removedr   z•Supplemental raw records with missing/invalid NHHK are excluded; chronology is not inferred. Canonical enrollment semester validation remains strict.z¤Canonical snapshot priority: preserve observed credits, including genuine zero, when raw credits differ; recover only credits marked missing from known raw credits.)Úavailability_assumptionr‚   Úraw_semester_policyÚtimestamp_semanticsÚcanonical_input_eventsÚcredit_reconciliation_policyNÚcanonical_only_no_sourcezJAutomatic DDTBHP.csv and known raw course_history.joblib sources not found)ÚstatusÚreasonzsource:Úextended)rÕ   ÚsourceÚsource_kindr|   Ústudent_faculty_membershipszcanonical metadata student_idc              3  óL   #   • U  H  n[        U[        5      (       + v •  M     g 7f©N©rJ   rF   r—   s     r   r   Ú!extend_history.<locals>.<genexpr>  s"   é € ÐHoÒinÐdeÌZÐXYÔ[^ÓM_×I_ÑI_Òinùó   ‚"$zLcanonical metadata student faculty memberships require nonempty string lists)ra   rb   z
canonical.rc   ru   zcanonical.event_idr^   )NrU   z0canonical grade must be numeric 0..10 or missingr†   zcanonical.grade_record_idÚfaculty_membershipsÚfacultyc              3  óL   #   • U  H  n[        U[        5      (       + v •  M     g 7frÜ   rÝ   r—   s     r   r   rÞ   ,  s   é € Ð-TÊeÈ´*¸QÄÓ2D×.DÑ.DÊeùrß   z<canonical faculty_memberships must be a JSON list of stringsra   zAQ TRANSCRIPT source=z selected_students=Tr›   r   zAQ TRANSCRIPT excluded z8 selected-student raw rows with unusable NHHK; examples=r‚   z=. Canonical enrollments are retained; no semester is guessed.zcanonical duplicate grade ID r‡   rÎ   r   zcanonical/raw grade ID rÉ   c              3  ó6   >#   • U  H  oT;  d  M
  Uv •  M     g 7frÜ   rd   )r   ÚiÚmatchess     €r   r   rÞ   W  s   øé € ÐKÒ!6˜AÀ7Ñ:J—a‘aÒ!6ùs   ƒ	�	c                óV   >• [         R                  " TU    S   5      (       + TU    S   4$ )Nr^   ru   )rY   r]   )rä   rw   s    €r   Ú<lambda>Ú extend_history.<locals>.<lambda>X  s*   ø€ ¬¯ª°I¸a±LÀÑ4IÓ(JÔ$JÈIÐVWÉLÐYcÑLdÑ#er,   )rÂ   rh   ri   c              3  ó,   >#   • U  H	  oT;   v •  M     g 7frÜ   rd   )r   ÚjÚconsumeds     €r   r   rÞ   h  s   øé € ÐDeÒ\dÐWXÈ(Æ]Ò\dùs   ƒz+ambiguous canonical registration for tuple z[: same-tuple raw grade evidence was already consumed; distinct attempts are not establishedzcanonical/raw tuple z grade mismatch: canonical z versus raw z&; unresolved identity/outcome conflictz,ambiguous canonical registrations for tuple r!   z% unidentified registrations but only zB matching raw grade records; distinct attempts are not establishedr�   z(ambiguous canonical/raw tuple match for z; supply grade_record_idc              3  ód   >#   • U  H%  nTT   S    SL=(       a
    TU   S    SL(       + v •  M'     g7f)r†   Nrd   )r   rê   rw   ÚkÚraws     €€€r   r   rÞ   …  sK   øé € ð #8â,6 qð )2°!©Ð5FÑ(GÈtÐ(S÷ )RØ,/°©FÐ3DÑ,EÈTÐ,Q÷$Sñ $Sâ,6ùs   ƒ-0z4ambiguous missing-grade canonical registrations for c                ó   >• TU    S   $ )Nru   rd   )rí   rî   s    €r   rç   rè   Š  s   ø€ ¨#¨a©&°Ò*<r,   rÊ   rË   Úcredits_missingFr�   rÌ   rÍ   r‘   r’   r“   )Úensure_asciié   )ÚhoursÚavailable_at)Úcolumnsz6Reconciled event identity conflict: duplicate event_id)Ú_ordinal)ra   rb   rö   ru   Ústable)rL   rb   )ÚsortÚattempt)Úcanonical_only_eventsÚsupplemental_raw_eventsÚoutput_events)Údrop)Br   r6   r#   r?   Úupdater	   r
   r&   ÚcopyrF   r   r¡   r   r    Úattrsrv   Úitemsr   rJ   ÚlistÚtupleÚanyr'   rS   r_   r   ÚjsonÚloadsÚaddr¨   rÅ   Ú	enumeraterf   r¢   rp   rY   r]   ry   r$   Úrangerl   ÚminÚboolr[   r   Údumpsr   r   rD   Ú	Timedeltarõ   rK   ru   Ú
duplicatedÚassignrc   ÚmapÚsort_valuesr�   ÚlocÚgroupbyÚcumcountÚto_numpyÚastypeÚint64Úreset_index)/r9   Úcanonical_eventsr:   r;   r=   rL   r   r«   ÚfingerprintsÚmembershipsr°   Únamesre   r^   r¼   rµ   rä   ÚrÚraw_idsÚ
raw_groupsÚcanonical_idsÚdeduplicatedr¶   r¿   rê   ÚpendingÚunidentified_by_tupleÚeligibler*   ÚobservedÚtuple_candidatesÚ
raw_gradesrí   ÚpeersÚpayloadsÚcompetitorsÚoutputrØ   ÚmarkerÚmissing_creditrõ   ÚeventsÚorderedrw   rë   rå   rî   s/                                   `          @@@@r   Úextend_historyr0  î   s]  ü€ ô �‹:× Ñ Ó"×*Ñ*Ó,€DÜ˜¨]Ó;�J€Dñ"ó ò "˜�1ŠWñ "€Eð ð 
‡L�LÔ)@Ø/1ðPä%8Ü(+Ð,<Ó(=ðlð ñ 	nð �|Ø�‰Ð6Øhð 	ñ 	jà×$Ñ$Ó&¨¨rÐ1Ð1Ø¤ D£	Ñ)¬7°4«=Ð9€LØ	‡L�L˜
¬3¨t«9À$€LÑGØ ×%Ñ%Ó'×/Ñ/°	Ó:€IÜœcÓ"€Kð +×0Ñ0×4Ñ4Ð5RÐTVÓW×]Ñ]Ö_‰ˆÜ Ð)HÓIˆÜ˜%¤$¬¬sÐ!3×4Ñ4¾EÄSÑHoÑinÓHo×EoÑEoÜÐkÓlÐlØÑ×#Ñ# EÖ*ñ	 `ô
 ˆÛ/ˆDÜ% c¡i°ÀÑ1DÓEˆC‹Iñ 0ä# C¨
¡OÓ4ˆˆJ‰Ü'¨¨J©Ð9MÓNˆˆJ‰Ü  G¡Ó-‰ˆØÐ+Ó+ÜÐOÓPÐPØˆG‰Ø—‘Ð*Ó+ˆÜ)1°&×)9Ñ)9¡¼}ÈVÐUpÓ?qˆÐÑØ—‘Ð-Ó.ˆÜ)1°%¯©”�S˜‘^Ó$Ñ%¼d¿jºjÈÓ>OˆÜ˜%¤×&Ñ&¬#Ñ-TÉeÓ-T×*TÑ*TÜÐ[Ó\Ð\Ø˜Ñ%Ñ&×-Ñ-¨eÔ4Ø˜Ñ%Ñ&×*Ñ*¬3¨s°9©~Ó+>×?ñ! ô" 
Ð! $ Ð':¼3¸{Ó;KÐ:LÐ
MÐTXÒYÜ
�D¤ KÓ 0°%Ó
8€CØÐ0×1ÜÐ'¨Ð.QÑ(RÐ'Sð T.Ø.3Ð4SÑ.TÐ-Uð VLðLàRVò	Xô 4=¸S´>Ôf²>©4¨1¨aÀQÐGXÑEYÓ&ˆqÐ"Ñ# QÒ&±>€GÑfÜœTÓ"€JÜ˜C–.‰ˆˆ3Ø”6˜#“;Ñ×&Ñ& qÖ)ñ !ä‹u€HØ€GØ€MØ€LÛˆØÐ(Ñ)ˆØÑ H°Ó$=Ø$ XÑ.ˆHÜ˜ #Ð)FÀxÁlÐR[Ð'\Ô]Ü�{Š{˜3˜w™<×(Ñ(Ü! (¨C°©LÔ9Ø$'¨¡L�˜Ñ!ØÐ9Ó:¸aÑ?Ó:ÙØ×Ñ˜CÔ ØÓØ&)ˆM˜(Ó#ñ ð €IÜ˜IÖ&‰ˆˆ3ØÐ(Ñ)ˆØÓ H°Õ$7Ø˜Ñ!ˆAÜ˜˜S ™VÐ'>¸x¹lÈ)Ð%TÔUÜ˜c 3 q¡6¨'¡?Ô3ØˆG�A‰JØ�L‰L˜ŒOØÐ.Ó/°1Ñ4Õ/ñ 'ô ÔK¤¤s¨9£~Ô!6ÓKÜeñg€Gä'¬Ó-ÐÛˆØ˜‰lˆØÐ Ñ!Ó)¬b¯kªk¸#¸g¹,×.GÓ.GØ!¤&¨£+Ñ.×5Ñ5°aÖ8ñ ô ˆØ˜‰lˆØ)¬&°«+Ò6ó HÒ6˜!ØÐ 1Ñ2Ñ>Ø # A¡Ð'8Ñ 9÷ Ñ6ˆð Hñ "*Ó?¢˜A¨Q°hÑ->—a¡ˆ
Ð?Ü—;’;˜s 7™|Ó,ˆÞØ)ÐÙ%/Óp¢Z ´2·:²:¸cÀ'¹lÈCÐPQÉFÐSZÉOÐbfÐmnÕ3oŸ!¡ZˆJÐpÞ˜cÐ"3Ñ4Ñ<ÄÔDeÑ\dÓDe×AeÑAeÜØ=¼fÀS»k¹_ð Mlð lómð mö žJÖ+;ÜÑ:JÓ KÒ:J°Q  Q¡¨¤Ñ:JÑ KÓLˆJÜØ&¤v¨c£{¡oÐ5PØ�w‘<�. ¨Z¨LÐ8^ð`óað aö ÚÞ˜Ð-Ñ.Ñ6Ø 5´f¸S³kÒ Bó ]Ò B˜1ÀaÈwÑFV“QÜŸš I¨a¡L°Ñ$9¸3¸w¹<ÈdÐYZÕ[÷ Ñ BˆEð ]ä�5‹z˜A‹~¤# e£*¬s°:«Ó">Ü ØBÄ6È#Ã;Á/ÐQSÜ˜5“z�lÐ"GÌÈJËÐGXð YXðXóYð Yô ˆz‹?˜QÓÙFPÓQÂjÀ˜˜Q™ ™¨#¨a©&°Ñ*;Ó<ÁjˆHÐQÞœs 8›}¨qÓ0Ü Ð#KÈCÐPZÉOÑK^Ð^vÐ!wÓxÐxÞñ '.ô 9¢g °°a±›1¸AÀWÑ<L›1Ü#%§;¢;¨y¸©|¸GÑ/D×#Eó ä% i°¡lÓ3´v¸c³{ÑBó ô  #ö #8á,6ó#8÷  8÷ ¡gˆKð 9ö Ü Ð#WÐX[Ð\fÑXgÑWjÐ!kÓlÐlÜ�
Ô <Ñ=ˆÜ˜#˜s 1™v g™Ô/Øˆ�‰
Ø�‰�QŒØÐ'Ó(¨AÑ-Ö(ña ðb €FÜ˜I×&‰ˆˆ3Ø�Œ<Ø˜ ™‘_ˆFÜ—;’;˜s 7™|×,Ñ,Ø% g™��G‘ØÐ:Ó;¸qÑ@Ó;Ø—W‘WÐ.°Ó6ˆFÜ!)¨&Ó!1Ô1×B´d¸6³lˆNÞ fÐ-?×&@Ø!'¨	Ñ!2��I‘Ø).�Ð%Ñ&ØÐ;Ó<ÀÑAÔ<Þ#¨FÐ3E×,FÌrÏzÊzÜ˜#˜i™.Ó)¨6°)Ñ+<À4Èa÷PQàÐAÓBÀaÑGÓBØÐ'Ñ(Ñ4Ø)/Ð0AÑ)B�Ð%Ñ&à"%Ð&7Ñ"8Ñ"Dð  (¬%°Ð4EÑ0FÈRÑ*PÒPØJPÐQ[ÑJ\ð �
‰Oà�‰�c×ñ' 'ô( ˜C–.‰ˆˆ3Ø�HÕØ%*ˆCÐ!Ñ"Ü# K°LÑ0AÑ$BÓCÀAÑFˆC�	‰NØ�M‰M˜#Öñ	 !ó
 ˆÜ%)§Z¢Z´°{À|ÑCTÑ7UÓ0VÐejÑ%kˆÐ!Ñ"Ü%Ô&6°s¸:±Ó&GÓHÌ2Ï<Ê<Ð^`ÑKaÑaˆˆNÓñ ô Ð#×+Ñ+Ó,€GØ Ó'Ø�‰Ð(Ô)Ü�\Š\˜&¨'Ñ2€FØ‡�×!Ñ!Ó#×'Ñ'×)Ñ)ÜÐQÓRÐRØ�m‰m V§_¡_×%8Ñ%8Ô9IÓ%JˆmÐK×WÑWÚ;À(ð Xð LßLQÉEð à%+§Z¡Z°Ñ%8×%@Ñ%@Ø	�{Ð#¨%ð &Að &1ß19±³¿H¹H»JÈñ&K€F‡J�Jˆw˜	Ð!Ñ"à˜yÑ)×0Ñ0´·±Ó:€Fˆ9ÑØ	‡L�L¤s¨9£~¼¸G»Ñ'DÜ),¨S«´C¸³MÑ)AÔQTÐU[ÓQ\ð ñ ^à×Ñ 4ÐÐ(¨%Ð=Ð=ùòAùóz gùòTHùò @ùò qùò !Lùò]ùò Rùò9sw   ¿o;Íp Í
p Õ#pÕ:pÖ
pÖp×)p×/pÙp
Ú7
pÛ#pÛ,pÝpÞ0
p$Þ>p$ßp$ß)p$àp$à$p$r5   )$Ú__doc__Ú
__future__r   Úcollectionsr   r  Úpathlibr   Úurllib.parser   rH   ÚnumpyrY   ÚpandasrD   Ú	aq_nativer	   r
   r   r   r   r   r   r   rŸ   rG   r+   r?   rN   rS   r_   rf   rp   ry   rÅ   r0  rd   r,   r   Ú<module>r9     sx   ðñõ #å #Û Ý Ý ã Û Û ÷÷ ó ò
 A€Ø€ò
;òò@	òòò@ò7òbòpõfK>r,   