Ë
    u™ãj%5  ã                   óÄ  — d dl Z d dlZd dlZd dlZd dlZd dlmZ	 d dl
mZ d dlmZ  ej                  d«       ej                  d„ «       Zd„ Zd„ Zej&                  j)                  dd	d
g«      d„ «       Zdg d¢dddœfdg d¢dddœfdddgdfdddgdfdddgdfdddgdfdd gd!fd"d#d$gd%fd&d#d'gdd(dœfd)d#d'gd*fd+g d,¢d-fd.g d,¢d/fd0g d,¢d1fd2g d,¢d3fd4g d,¢d5fd6g d,¢d7fd8g d,¢d9fd:g d;¢dddœfd<g d=¢d7fd>g d?¢dddœfd<g d@¢d7fd>g dA¢dddœfd<g dB¢d7fd>g dC¢dddœfd<g d,¢d7fd>g d;¢dddœfdDg d,¢dEfgZdF„ Zej&                  j)                  dd	d
g«      ej&                  j)                  dGe«      dH„ «       «       Zej&                  j)                  dd	d
g«      ej&                  j)                  dGe«      dI„ «       «       Zg dJ¢Zej&                  j)                  dd	d
g«      ej&                  j)                  dKe«      dL„ «       «       ZdM„ Zej&                  j:                  ej&                  j=                  dN«      dO„ «       «       Zej&                  j)                  dPg dQ¢«      dR„ «       Z y)Sé    N)ÚExcelWriter)ÚExcelFormatterÚjinja2c                 ól   — | t        j                  «       › d�z  }|j                  «        t        |«      S )Nú.xlsx)ÚuuidÚuuid4ÚtouchÚstr)Útmp_pathÚtmps     úk/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/pandas/tests/io/excel/test_style.pyÚ	tmp_excelr      s+   € à
œŸ
™
›�~ UÐ+Ñ
+€CØ‡I�I„KÜˆs‹8€Oó    c                 ó  — | j                   j                  |j                   j                  k(  sJ ‚| j                  j                  |j                  j                  k(  sJ ‚| j                  j                  |j                  j                  k(  sJ ‚| j                  j                  |j                  j                  k(  sJ ‚| j
                  |j
                  k(  sJ ‚| j                  j                  |j                  j                  k(  sJ ‚y ©N)Ú	alignmentÚ__dict__ÚborderÚfillÚfontÚnumber_formatÚ
protection)Úcell1Úcell2s     r   Úassert_equal_cell_stylesr      sÊ   € à�?‰?×#Ñ# u§¡×'?Ñ'?Ò?Ð?Ð?Ø�<‰<× Ñ  E§L¡L×$9Ñ$9Ò9Ð9Ð9Ø�:‰:×Ñ %§*¡*×"5Ñ"5Ò5Ð5Ð5Ø�:‰:×Ñ %§*¡*×"5Ñ"5Ò5Ð5Ð5Ø×Ñ %×"5Ñ"5Ò5Ð5Ð5Ø×Ñ×$Ñ$¨×(8Ñ(8×(AÑ(AÒAÐAÑAr   c                 óú  — t        j                  d«      }t        j                  ddddœddddœg«      }t	        | d¬«      5 }|j                  |d¬«       d d d «       t        j                  |j                  | «      «      5 }|d   j                  dd«      j                  j                  d	u sJ ‚|d   j                  dd«      j                  j                  �J ‚|d   j                  dd«      j                  j                  �J ‚|d   j                  dd«      j                  j                   j"                  �J ‚|d   j                  dd«      j                  j$                  j"                  �J ‚|d   j                  dd«      j                  j&                  j"                  �J ‚|d   j                  dd«      j                  j(                  j"                  �J ‚	 d d d «       y # 1 sw Y   �Œ�xY w# 1 sw Y   y xY w)
NÚopenpyxlé   é   é   )ÚAÚBÚC©ÚengineÚcustom©Ú
sheet_nameF)ÚpytestÚimportorskipÚpdÚ	DataFramer   Úto_excelÚ
contextlibÚclosingÚload_workbookÚcellr   Úboldr   Ú
horizontalÚverticalr   ÚbottomÚcolorÚtopÚleftÚright)r   r   ÚdfÚwriterÚwbs        r   Útest_styler_default_valuesr>   $   sÛ  € ä×"Ñ" :Ó.€HÜ	�‰˜Q Q¨QÑ/°q¸qÀqÑ1IÐJÓ	K€Bä	�Y zÔ	2ð 1°fØ
�‰�F xˆÔ0÷1ô 
×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð 
BÀ"à�(‰|× Ñ   AÓ&×+Ñ+×0Ñ0°EÑ9Ð9Ð9Ø�(‰|× Ñ   AÓ&×0Ñ0×;Ñ;ÐCÐCÐCØ�(‰|× Ñ   AÓ&×0Ñ0×9Ñ9ÐAÐAÐAð �(‰|× Ñ   AÓ&×-Ñ-×4Ñ4×:Ñ:ÐBÐBÐBØ�(‰|× Ñ   AÓ&×-Ñ-×1Ñ1×7Ñ7Ð?Ð?Ð?Ø�(‰|× Ñ   AÓ&×-Ñ-×2Ñ2×8Ñ8Ð@Ð@Ð@Ø�(‰|× Ñ   AÓ&×-Ñ-×3Ñ3×9Ñ9ÐAÐAÑA÷
Bð 
B÷1ñ 1ú÷
Bð 
Bús   ÁG$ÂEG1Ç$G.Ç1G:r&   Ú
xlsxwriterr   c                 óþ  — t        j                  | «       t        j                  t        j
                  j                  d«      j                  d«      «      }t        || ¬«      5 }|j                  |d¬«       |j                  j                  |d¬«       d d d «       t        j                  d«      }t        j                  |j                  |«      «      5 }t        |d   j                  |d   j                  d¬	«      D ][  \  }}t!        |«      t!        |«      k(  sJ ‚t        ||d¬	«      D ],  \  }}	|j"                  |	j"                  k(  sJ ‚t%        ||	«       Œ. Œ] 	 d d d «       y # 1 sw Y   ŒÓxY w# 1 sw Y   y xY w)
Nr    )r    r    r%   Ú	dataframer(   Úunstyledr   T)Ústrict)r*   r+   r,   r-   ÚnpÚrandomÚdefault_rngÚstandard_normalr   r.   Ústyler/   r0   r1   ÚzipÚcolumnsÚlenÚvaluer   )
r&   r   r;   r<   r   r=   Úcol1Úcol2r   r   s
             r   Útest_styler_to_excel_unstyledrO   9   sR  € ô ×Ñ˜ÔÜ	�‰”b—i‘i×+Ñ+¨AÓ.×>Ñ>¸vÓFÓ	G€BÜ	�Y vÔ	.ð 9°&Ø
�‰�F {ˆÔ3Ø
�‰×Ñ˜&¨ZÐÔ8÷9ô ×"Ñ" :Ó.€HÜ	×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð 	7À"ÜØˆ{‰O×#Ñ#Øˆz‰N×"Ñ"Øô
ò 	7‰JˆD�$ô
 �t“9¤ D£	Ò)Ð)Ð)Ü # D¨$°tÔ <ò 7‘��uØ—{‘{ e§k¡kÒ1Ð1Ð1Ü(¨°Õ6ñ7ñ	7÷	7ð 	7÷9ð 9ú÷
	7ð 	7ús   Á$1E'ÃBE3Å'E0Å3E<úbackground-color: #111222)r   ÚfgColorÚrgbÚFF111222Ú00111222)r?   r   zcolor: #111222)r   r7   rL   zfont-family: Arial;r   ÚnameÚarialzfont-weight: bold;ÚbTzfont-style: italic;Úiztext-decoration: underline;ÚuÚsingleznumber-format: $??,???.00;r   z
$??,???.00ztext-align: left;r   r4   r9   zvertical-align: bottom;r5   r6   zvertical-align: middle;Úcenterzborder-left: 2pt solid red©r   r9   rH   Úmediumzborder-left: 1pt dotted redÚdottedzborder-left: 2pt dotted redÚmediumDashDotDotzborder-left: 1pt dashed redÚdashedzborder-left: 2pt dashed redÚmediumDashedzborder-left: 1pt solid redÚthinzborder-left: 3pt solid redÚthickzborder-left: 2pt solid #111222)r   r9   r7   rR   zborder: 1pt solid red)r   r8   rH   zborder: 1pt solid #111222)r   r8   r7   rR   )r   r:   rH   )r   r:   r7   rR   )r   r6   rH   )r   r6   r7   rR   z1border-left-style: hair; border-left-color: blackÚhairc                 óú  ‡— dŠt        j                  d«      }t        j                  dddœdddœg«      }t	        | d¬«      5 }|j
                  j                  ˆfd„«      }|j                  |dd	¬
«       d d d «       t        j                  |j                  | «      «      5 }|d   j                  dd«      j                  j                  d	u sJ ‚|d   j                  dd«      j                  j                  �J ‚|d   j                  dd«      j                  j                   �J ‚|d   j                  dd«      j"                  j$                  j&                  �J ‚|d   j                  dd«      j"                  j(                  j&                  �J ‚|d   j                  dd«      j"                  j*                  j&                  �J ‚|d   j                  dd«      j"                  j,                  j&                  �J ‚|d   j                  dd«      j.                  j0                  j2                  dk(  sJ ‚|d   j                  dd«      j.                  j0                  j2                  dk(  sJ ‚|d   j                  dd«      j.                  j0                  j2                  dk(  sJ ‚|d   j                  dd«      j.                  j0                  j2                  dk(  sJ ‚	 d d d «       y # 1 sw Y   �ŒpxY w# 1 sw Y   y xY w)NrP   r   r   r    )r"   r#   r%   c                 ó   •— ‰S r   © )ÚxÚ	css_styles    €r   ú<lambda>z*test_styler_custom_style.<locals>.<lambda>œ   s   ø€ ¨	€ r   r'   F)r)   ÚindexrT   r!   )r*   r+   r,   r-   r   rH   Úmapr.   r/   r0   r1   r2   r   r3   r   r4   r5   r   r6   r7   r8   r9   r:   r   rQ   rk   )r   r   r;   r<   Ústylerr=   ri   s         @r   Útest_styler_custom_stylern   •   s¼  ø€ à+€IÜ×"Ñ" :Ó.€HÜ	�‰˜Q QÑ'¨q°qÑ)9Ð:Ó	;€Bä	�Y zÔ	2ð B°fØ—‘—‘Ó1Ó2ˆØ�‰˜¨8¸5ˆÔA÷Bô 
×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð HÀ"à�(‰|× Ñ   AÓ&×+Ñ+×0Ñ0°EÑ9Ð9Ð9Ø�(‰|× Ñ   AÓ&×0Ñ0×;Ñ;ÐCÐCÐCØ�(‰|× Ñ   AÓ&×0Ñ0×9Ñ9ÐAÐAÐAð �(‰|× Ñ   AÓ&×-Ñ-×4Ñ4×:Ñ:ÐBÐBÐBØ�(‰|× Ñ   AÓ&×-Ñ-×1Ñ1×7Ñ7Ð?Ð?Ð?Ø�(‰|× Ñ   AÓ&×-Ñ-×2Ñ2×8Ñ8Ð@Ð@Ð@Ø�(‰|× Ñ   AÓ&×-Ñ-×3Ñ3×9Ñ9ÐAÐAÐAð �(‰|× Ñ   AÓ&×+Ñ+×3Ñ3×9Ñ9¸ZÒGÐGÐGØ�(‰|× Ñ   AÓ&×+Ñ+×3Ñ3×9Ñ9¸ZÒGÐGÐGØ�(‰|× Ñ   AÓ&×+Ñ+×3Ñ3×9Ñ9¸ZÒGÐGÐGØ�(‰|× Ñ   AÓ&×+Ñ+×3Ñ3×9Ñ9¸ZÒGÐGÑG÷!Hð H÷	Bñ Bú÷Hð Hús   Á3K$Â"H8K1Ë$K.Ë1K:zcss, attrs, expectedc                 ó  ‡— t        j                  | «       t        j                  t        j
                  j                  d«      j                  d«      «      }|j                  j                  ˆfd„«      }t        || ¬«      5 }|j                  |d¬«       |j                  |d¬«       d d d «       t        j                  d«      }t        j                  |j                  |«      «      5 }	|	d   j                  dd«      |	d   j                  dd«      }}
d d d «       |D ]  }t!        
|d «      t!        |«      }}
Œ t#        |t$        «      r
�
|
||    k7  sJ ‚||    k(  sJ ‚y 
�|
|k7  sJ ‚|k(  sJ ‚y # 1 sw Y   ŒÍxY w# 1 sw Y   ŒmxY w)	Nr    ©r   r   c                 ó   •— ‰S r   rg   ©rh   Úcsss    €r   rj   z,test_styler_to_excel_basic.<locals>.<lambda>·   ó   ø€  C€ r   r%   rA   r(   Ústyledr   ©r*   r+   r,   r-   rD   rE   rF   rG   rH   rl   r   r.   r/   r0   r1   r2   ÚgetattrÚ
isinstanceÚdict)r&   rs   ÚattrsÚexpectedr   r;   rm   r<   r   r=   Úu_cellÚs_cellÚattrs    `           r   Útest_styler_to_excel_basicr   ²   sƒ  ø€ ô ×Ñ˜ÔÜ	�‰”b—i‘i×+Ñ+¨AÓ.×>Ñ>¸vÓFÓ	G€BØ�X‰X�\‰\›-Ó(€Fä	�Y vÔ	.ð 5°&Ø
�‰�F {ˆÔ3Ø�‰˜¨8ˆÔ4÷5ô ×"Ñ" :Ó.€HÜ	×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð MÀ"ð ˜K™×-Ñ-¨a°Ó3°R¸±\×5FÑ5FÀqÈ!Ó5L�ˆ÷Mð ò LˆÜ  ¨¨tÓ4´g¸fÀdÓ6K�‰ðLô �(œDÔ!Øˆ~ ¨8°FÑ+;Ò!;Ð;Ð;Ø˜ &Ñ)Ò)Ð)Ñ)àˆ~ ¨8Ò!3Ð3Ð3Ø˜Ò!Ð!Ñ!÷#5ð 5ú÷
Mð Mús   Â'E6Ã++FÅ6E?ÆFc                 ó°  ‡— t        j                  | «       t        j                  t        j
                  j                  d«      j                  d«      «      }|j                  }|j                  ˆfd„d¬«       |j                  ˆfd„d¬«       |j                  }|j                  d„ «       |j                  d	„ d¬«       |j                  d
„ d¬«       t        || ¬«      5 }|j                  |d¬«       |j                  |d¬«       d d d «       t        j                  d«      }	t        j                  |	j                  |«      «      5 }
|
d   j!                  dd«      |
d   j!                  dd«      }}|
d   j!                  dd«      |
d   j!                  dd«      }}d d d «       |D ]4  }t#        |d «      t#        |«      }}t#        |d «      t#        |«      }}Œ6 t%        |t&        «      r-�
|||    k7  sJ ‚||    k(  sJ ‚�
|||    k7  sJ ‚||    k(  sJ ‚y �||k7  sJ ‚|k(  sJ ‚�||k7  sJ ‚|k(  sJ ‚y # 1 sw Y   �Œ7xY w# 1 sw Y   Œ­xY w)Nr    rp   c                 ó   •— ‰S r   rg   rr   s    €r   rj   z4test_styler_to_excel_basic_indexes.<locals>.<lambda>Ô   ó   ø€ ˜s€ r   r   ©Úaxisc                 ó   •— ‰S r   rg   rr   s    €r   rj   z4test_styler_to_excel_basic_indexes.<locals>.<lambda>Õ   r‚   r   r   c                  ó   — y©Nz
null: css;rg   ©rh   s    r   rj   z4test_styler_to_excel_basic_indexes.<locals>.<lambda>Ø   ó   � r   c                  ó   — yr‡   rg   rˆ   s    r   rj   z4test_styler_to_excel_basic_indexes.<locals>.<lambda>Ù   r‰   r   c                  ó   — yr‡   rg   rˆ   s    r   rj   z4test_styler_to_excel_basic_indexes.<locals>.<lambda>Ú   r‰   r   r%   Únull_styledr(   ru   r   )r*   r+   r,   r-   rD   rE   rF   rG   rH   Ú	map_indexrl   r   r.   r/   r0   r1   r2   rw   rx   ry   )r&   rs   rz   r{   r   r;   rm   Únull_stylerr<   r   r=   Úui_cellÚsi_cellÚuc_cellÚsc_cellr~   s    `              r   Ú"test_styler_to_excel_basic_indexesr“   Í   sq  ø€ ô ×Ñ˜ÔÜ	�‰”b—i‘i×+Ñ+¨AÓ.×>Ñ>¸vÓFÓ	G€Bà�X‰X€FØ
×Ñ“]¨ÐÔ+Ø
×Ñ“]¨ÐÔ+à—(‘(€KØ‡O�OÑ*Ô+Ø×ÑÑ0°qÐÔ9Ø×ÑÑ0°qÐÔ9ä	�Y vÔ	.ð 5°&Ø×Ñ˜V°ÐÔ>Ø�‰˜¨8ˆÔ4÷5ô ×"Ñ" :Ó.€HÜ	×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð QÀ"ð ˜mÑ,×1Ñ1°!°QÓ7¸¸H¹×9JÑ9JÈ1ÈaÓ9P�ˆØ˜mÑ,×1Ñ1°!°QÓ7¸¸H¹×9JÑ9JÈ1ÈaÓ9P�ˆ÷	Qð
 ò PˆÜ" 7¨D°$Ó7¼ÀÈ$Ó9O�ˆÜ" 7¨D°$Ó7¼ÀÈ$Ó9O�‰ðPô �(œDÔ!Øˆ '¨X°fÑ-=Ò"=Ð=Ð=Ø˜( 6Ñ*Ò*Ð*Ð*Øˆ '¨X°fÑ-=Ò"=Ð=Ð=Ø˜( 6Ñ*Ò*Ð*Ñ*àˆ '¨XÒ"5Ð5Ð5Ø˜(Ò"Ð"Ð"Øˆ '¨XÒ"5Ð5Ð5Ø˜(Ò"Ð"Ñ"÷/5ñ 5ú÷
Qð Qús   Ã#'H?ÅAIÈ?I	ÉI)
r`   ÚmediumDashDotÚ
dashDotDotrd   r^   r_   ÚdoubleÚdashDotÚslantDashDotra   Úborder_stylec                 ó4  ‡— d|› d�Šg d¢}|}t        j                  | «       t        j                  t        j
                  j                  d«      j                  d«      «      }|j                  j                  ˆfd„«      }t        || ¬«      5 }|j                  |d¬	«       |j                  |d
¬	«       d d d «       t        j                  d«      }t        j                  |j                  |«      «      5 }	|	d   j                  dd«      |	d
   j                  dd«      }}
d d d «       |D ]  }t!        
|d «      t!        |«      }}
Œ t#        |t$        «      r
�
|
||    k7  sJ ‚||    k(  sJ ‚y 
�|
|k7  sJ ‚|k(  sJ ‚y # 1 sw Y   ŒÍxY w# 1 sw Y   ŒmxY w)Nzborder-left: z black thinr\   r    rp   c                 ó   •— ‰S r   rg   rr   s    €r   rj   z3test_styler_to_excel_border_style.<locals>.<lambda>  rt   r   r%   rA   r(   ru   r   rv   )r&   r™   r   rz   r{   r;   rm   r<   r   r=   r|   r}   r~   rs   s                @r   Ú!test_styler_to_excel_border_stylerœ   
  s›  ø€ ð ˜,˜ {Ð
3€CÚ'€EØ€Hä
×Ñ˜ÔÜ	�‰”b—i‘i×+Ñ+¨AÓ.×>Ñ>¸vÓFÓ	G€BØ�X‰X�\‰\›-Ó(€Fä	�Y vÔ	.ð 5°&Ø
�‰�F {ˆÔ3Ø�‰˜¨8ˆÔ4÷5ô ×"Ñ" :Ó.€HÜ	×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð MÀ"ð ˜K™×-Ñ-¨a°Ó3°R¸±\×5FÑ5FÀqÈ!Ó5L�ˆ÷Mð ò LˆÜ  ¨¨tÓ4´g¸fÀdÓ6K�‰ðLô �(œDÔ!Øˆ~ ¨8°FÑ+;Ò!;Ð;Ð;Ø˜ &Ñ)Ò)Ð)Ñ)àˆ~ ¨8Ò!3Ð3Ð3Ø˜Ò!Ð!Ñ!÷#5ð 5ú÷
Mð Mús   Â'FÃ7+FÆFÆFc                 óR  — t        j                  d«      }d„ }t        j                  t        j
                  j                  d«      j                  d«      «      }|j                  j                  d„ «      }t        | d¬«      5 }t        ||¬«      j                  |d¬	«       d d d «       t        j                  |j                  | «      «      5 }|d   j!                  dd«      j"                  j$                  j&                  d
k(  sJ ‚	 d d d «       y # 1 sw Y   ŒpxY w# 1 sw Y   y xY w)Nr   c                 ó   — ddddiiiS )Nr   r7   rR   Ú111222rg   )rs   s    r   Úcustom_converterz6test_styler_custom_converter.<locals>.custom_converter,  s   € Ø˜ 5¨(Ð"3Ð4Ð5Ð5r   r    rp   c                  ó   — y)Nzcolor: #888999rg   rˆ   s    r   rj   z.test_styler_custom_converter.<locals>.<lambda>0  r‰   r   r%   )Ústyle_converterr'   r(   rT   )r*   r+   r,   r-   rD   rE   rF   rG   rH   rl   r   r   Úwriter/   r0   r1   r2   r   r7   rL   )r   r   r    r;   rm   r<   r=   s          r   Útest_styler_custom_converterr¤   )  s  € Ü×"Ñ" :Ó.€Hò6ô 
�‰”b—i‘i×+Ñ+¨AÓ.×>Ñ>¸vÓFÓ	G€BØ�X‰X�\‰\Ñ4Ó5€FÜ	�Y zÔ	2ð 
°fÜ�vÐ/?Ô@×FÑFØ˜xð 	Gô 	
÷
ô
 
×	Ñ	˜H×2Ñ2°9Ó=Ó	>ð FÀ"Ø�(‰|× Ñ   AÓ&×+Ñ+×1Ñ1×7Ñ7¸:ÒEÐEÑE÷Fð F÷
ð 
ú÷
Fð Fús   ÂDÃ9DÄDÄD&zBignore:The default engine for reading:pandas.errors.Pandas4Warningc                 óL  — | j                   }t        j                  «       › d�}t        j                  g d¢g d¢dœ«      }|j
                  j                  d¬«      }d|› d|› �}|j                  ||¬	«       t        j                  |d
|¬«      }t        j                  ||«       y )Nr   )r   r    r!   )r    é   é   )rh   Úyrk   rƒ   zs3://ú/)Ústorage_optionsr   )Ú	index_colrª   )rU   r   r	   r,   r-   rH   Ú
set_stickyr.   Ú
read_excelÚtmÚassert_frame_equal)Ús3_bucket_publicÚs3soÚmock_bucket_nameÚtarget_filer;   rm   ÚuriÚresults           r   Útest_styler_to_s3r¶   :  s’   € ð (×,Ñ,ÐÜ—Z‘Z“\�N %Ð(€KÜ	�‰šIªIÑ6Ó	7€BØ�X‰X× Ñ  gÐ Ó.€FØÐ"Ð# 1 [ MÐ
2€CØ
‡O�O�C¨€OÔ.Ü�]‰]˜3¨!¸TÔB€FÜ×Ñ˜& "Õ%r   Úmerge_cells)TFrJ   c           
      óŽ  — t        j                  dddgit         j                  j                  t        j                  ddd¬«      dd	ggd
dg¬«      ¬«      }t        || ¬«      }|j                  «       }|D ]M  }|j                  dk7  sŒ|j                  dk(  sŒ#t        |j                  t         j                  «      rŒHJ d«       ‚ y )Nr"   r   r    z
2006-10-06z
2006-10-07ÚD)ÚstartÚendÚfreqÚXÚYÚdateÚcategory)Únames)rk   )r·   r   z'Period should be converted to Timestamp)r,   r-   Ú
MultiIndexÚfrom_arraysÚperiod_ranger   Ú_format_hierarchical_rowsÚrowÚcolrx   ÚvalÚ	Timestamp)r·   r;   Ú	formatterÚformatted_cellsr2   s        r   Ú)test_format_hierarchical_rows_periodindexrÌ   J  s¼   € ô 
�‰Ø	ˆq�!ˆfˆÜ�m‰m×'Ñ'ä—‘ l¸È3ÔOØ�c�
ðð ˜:Ð&ð (ó 
ô	
€Bô ˜r¨{Ô;€IØ×9Ñ9Ó;€Oàò ˆØ�8‰8�q‹=˜TŸX™X¨›]Ü˜dŸh™h¬¯©Õ5ð Ø9óÐ5ñr   )!r/   r   ÚnumpyrD   r*   Úpandasr,   Úpandas._testingÚ_testingr®   Úpandas.io.excelr   Úpandas.io.formats.excelr   r+   Úfixturer   r   r>   ÚmarkÚparametrizerO   Úshared_style_paramsrn   r   r“   Úexcel_border_stylesrœ   r¤   Ú
single_cpuÚfilterwarningsr¶   rÌ   rg   r   r   ú<module>rÚ      sg  ðÛ Û ã Û ã Ý å 'Ý 2à €× Ñ �HÔ ð ‡�ñó ðòBòBð* ‡�×Ñ˜ L°*Ð#=Ó>ñ7ó ?ð7ð. 	$Ú"Ø!¨zÑ:ðð 	Ú"Ø!¨zÑ:ðð
 ˜V VÐ,¨gÐ6Ø˜F C˜=¨$Ð/Ø˜V S˜M¨4Ð0Ø" V¨S M°8Ð<Ø! OÐ#4°lÐCØ˜;¨Ð5°vÐ>à!Ø	�jÐ!Ø¨Ñ2ðð
  ¨jÐ 9¸8ÐDà!Ò#>ÀÐIØ"Ò$?ÀÐJØ"Ò$?ÐASÐTØ"Ò$?ÀÐJØ"Ò$?ÀÐPØ!Ò#>ÀÐGØ!Ò#>ÀÐHð 	)Ú*Ø!¨zÑ:ðð
 Ò8¸&ÐAà#Ú)Ø!¨zÑ:ðð
 Ò:¸FÐCà#Ú+Ø!¨zÑ:ðð
 Ò;¸VÐDà#Ú,Ø!¨zÑ:ðð
 Ò9¸6ÐBà#Ú*Ø!¨zÑ:ðð 	<Ú#Øðð}CÐ òLHð: ‡�×Ñ˜ L°*Ð#=Ó>Ø‡�×ÑÐ/Ð1DÓEñ"ó Fó ?ð"ð2 ‡�×Ñ˜ L°*Ð#=Ó>Ø‡�×ÑÐ/Ð1DÓEñ$#ó Fó ?ð$#òTÐ ð" ‡�×Ñ˜ L°*Ð#=Ó>Ø‡�×Ñ˜Ð)<Ó=ñ"ó >ó ?ð"ò:Fð" ‡�×ÑØ‡�×ÑØHóñ	&óó ð	&ð ‡�×Ñ˜Ò(@ÓAñó Bñr   