ó
    3ÖÓjé  ã                   óŠ   • S r SSKJr  SSKrSSKrSSKJrJ	r	J
r
  S r\S:X  a   SSKr\" \" \R                  S   5      5        gg)zHOnly for pipeline tests: synthesize raw AQ-style CSVs from test fixture.é    )ÚPathN)ÚgenerateÚSEMÚORIGINSc                 ó  • [        U 5      n [        U 5        U R                  S-  oR                  SSS9  [        R
                  " U S-  S-  S-  [        S9n[        [        [        5       VVs0 s H  u  p4U[        R                  " U5      _M     nnn/ n/ n[        UR                  SS	95       GH)  u  p‰XYR                     n
US
-  S:H  nX«(       a  [        R                  " SS9O[        R                  " SS9* -   nUR                  [!        U	R                  [        US-   5      U	R"                  U	R$                  [        U5      US-  S:X  a   [        U
[        R                  " SS9-   5      OSU	R&                  S95        UR                  [!        U	R                  U	R$                  U	R(                  [        U
[        R                  " SS9-
  5      S95        GM,     [        R*                  " U5      R-                  US-  SS	9  [        R*                  " U5      R/                  SS/5      R-                  US-  SS	9  [        R*                  " [        [        [        5       VVs/ s H  u  p4[!        X4S9PM     snn5      R-                  US-  SS	9  / nUR1                  SS/5       H£  u  u  pÞnX^   [        R                  " SS9-   nUR2                  R5                  5       R7                  5       (       a0  [9        UR2                  R;                  5       R<                  S   5      OSnUR                  [!        XíU[        U5      S95        M¥     [        R*                  " U5      R-                  US -  SS	9  X4$ s  snnf s  snnf )!NÚdatabaseT)ÚparentsÚexist_okÚdataÚasof_rosterszroster_asof.csv)ÚdtypeF)Úindexé   r   é   )Údaysé   é   ée   Ú )ÚNHHKÚIDKQDKÚIDSVÚIDToHocÚNgayThemÚNgayDoiNhomÚIDDVPCé   )r   r   ÚIDMHr   z	MKQDK.csvr   r   z
KToHoc.csv)r   ÚNgayBDHKzHDMNHHK.csvÚ
student_idÚsemesteré   g      @)r   r   ÚDTBHKr   z
DDTBHK.csv)r   r   ÚparentÚmkdirÚpdÚread_csvÚstrÚzipr   r   Ú	TimestampÚ	enumerateÚ
itertuplesr!   Ú	TimedeltaÚappendÚdictr    Ú
section_idÚsource_facultyÚ	course_idÚ	DataFrameÚto_csvÚdrop_duplicatesÚgroupbyÚ	prior_gpaÚnotnaÚanyÚfloatÚdropnaÚiloc)ÚrootÚoutÚrosterÚsÚdÚsemdateÚregsÚssÚjÚrÚdtÚlateÚgpÚstudentr!   ÚfÚatÚvals                     ÚY/root/disk_3tb/earlywarning/30072026/suite33_offering_context/tests/make_synthetic_raw.pyÚgenerate_rawrO      s.  € Ü	ˆd‹€D”H˜T”NØ�‰�JÑ€CŸy™y°¸t˜yÑDÜ�;Š;�t˜F‘{ >Ñ1Ð2CÑCÌ#ÑN€FÜ*-¬c´'Ô*:Ô;Ò*:¡3 1ˆQŒr�|Š|˜A‹ÒÑ*:€GÑ;Ø	€DˆrˆBÜ˜×*Ñ*°Ð*Ð7×8‰ˆØ—:‘:Ñˆàˆr‰T�1‰WˆØ
¥dŒb�lŠl Ò"´·²À1Ñ1EÐ0EÑ
FˆØ�‰”D˜aŸj™j´°A°a±C³¸a¿l¹lÐST×S_ÑS_ÔilÐmnÓioð  ]^ð  _bñ  ]bð  deó  ]eÔ|ð  ACô  DF÷  DPò  DPð  VWñ  DXñ  AXô  }Yð  kmð  uv÷  uEñ  uEñ  Fô  	GØ
�	‰	”$˜AŸJ™J¨q¯|©|ÀÇÁÔVYÐZ\Ô]_×]iÒ]iÐoqÑ]rÑZrÓVsÑt×uñ 9ô ‡L‚L�Ó×Ñ˜c +™o°EÐÑ:Ü‡L‚L�Ó×$Ñ$ f¨YÐ%7Ó8×?Ñ?ÀÀLÑ@PÐW\Ð?Ñ]Ü‡L‚L´S¼¼WÔ5EÔFÒ5E©c¨a”$˜AÔ)Ñ5EÒFÓG×NÑNÈsÐS`ÑO`ÐglÐNÑmØ	€BØ &§¡°¸ZÐ/HÖ IÑÑˆ˜1ØÑœRŸ\š\¨rÑ2Ñ2ˆØ34·;±;×3DÑ3DÓ3F×3JÑ3J×3LÑ3LŒE�!—+‘+×$Ñ$Ó&×+Ñ+¨AÑ.Ô/ÐRUˆØ
�	‰	”$˜H¸ÄSÈÃWÑMÖNñ !Jô ‡L‚L�Ó×Ñ˜C Ñ,°5ÐÑ9Øˆ8€Oùó% <ùó Gs   Á.#M8É$M>
Ú__main__r   )Ú__doc__Úpathlibr   ÚnumpyÚnpÚpandasr&   Útests.make_syntheticr   r   r   rO   Ú__name__ÚsysÚprintÚargv© ó    rN   Ú<module>r]      sC   ðÙ NÝ Û Û ß 5Ñ 5òð0 ˆZÓÛÙ	‰,�s—x‘x ‘{Ó
#Õ$ð r\   