archive.git - Gitblit

Ë  
oñúhØ;ã óÐ    dZddlZddlZddlmZddlmZddlm    Z    m
Z
ejjdgdddd    iifd
dddiifdddd    iifd ddd    iifddddiifddddiifddddiifddddiifddddiifdddddifdddddifdddddifdddddifd dddiifd!dddiifd"ddd#difd$ddd%difd&dd'd(iifd)dd'd*iifd+dd'd,iifd-dd'd.iifd/dd'd(iifd0dd'd1iifd2dd'd3iifd4dd'd5iifd6dd'd*iifd7dd8d9iifd:dd8d9iifd;dd8d9iifd<dd8d9iifd=dd8d9iifd>dd8d9iifd?dd8d@iifdAdd8d@iifdBdd8d@iifdCdd8d@iifdDdd8d@iifdEddFd@iifdGddFd@iifdHddIdJiifdKifdLifdMddNd@iifdOdd@dJdPifdQddNd@iifdRddSdTiifdUddSdTiifdVddSdWiifdXddYd9iifdZddYd9iifd[ddYd9iifd\ddYd9iifd]ddYd@iifd^ddYd@iifd_ddYd@iifd`ddYd@iifdaddYd@iifdbdcdTdddeifdfdcdTdddeifdgdcdWdddeifdhdidjdkidjdkidjdkidjdkidlifdmdidjdnidjdnidjdnidjdnidlifdodidpdjdniiifdqdidpdjdniiifdrdidpdjdkiiifdsdidpdjdkiiifdtdidpdjdkiiifdudidpdjdviiifdwdidpdjdviiifdxdidpdjdyiiifdzdidpdjd{iiifd|didpdjd}iiifd~didpdjdiiifddidpdjdiiifddidkdddkdddkdddkdddifddidpdddiifddidpdkddiifddidpdddiifddddiifddddiifddddiifddddiifddddpiifddddpiifddddiifddddiifddddiifdddd9iifdddd9iifd ddd9iifd¡ddd@iifd¢d£d¤d¥iifd¦d£d¤d§iif«d¨«Z d©Zejjdªd?d«dd8d@iifd«d?dd8d@iifd?dEdd@d@d¬ifddEddFd9iifd®d«ifd¯dEddFd@iifg«d°«Zejjd±ee
j"j%««e
j"j'«Dcgc]    }d²|z|fc}zd³d´gz«dµ«Zejjd¶dd·g«d¸«Zd¹ZdºZejjd»d¼d½gd¾fd¿dÀgdÁfdÂdÃgdÄfg«dÅ«ZejjdÆgdÇ¢gddfd¿gdÀd¿ggddfdÂgdÈggddfd¿dÂgd¿dÉggddfd¿dÂgd¿dÉgd¿dÂggddfg«dÊ«Zycc}w)ËzmTests formatting as writer-agnostic ExcelCells
 
ExcelFormatter is tested implicitly in pandas/tests/io/excel
éN)Ú
CSSWarning)ÚCssExcelCellÚCSSToExcelConverterzcss,expectedzfont-family: foo,barÚfontÚnameÚfoozfont-family: "foo bar",bazzfoo barzfont-family: foo,
barzfont-family: foo, bar,    bazzfont-family: bar, fooÚbarzfont-family: 'foo bar', bazzfont-family: 'foo \'bar', bazzfoo 'barzfont-family: "foo \"bar", bazzfoo "barzfont-family: "foo ,bar", bazzfoo ,barzfont-family: serifÚserifé)rÚfamilyzfont-family: Serifzfont-family: roman, serifÚromanzfont-family: roman, sans-serifézfont-family: roman, sans serifzfont-family: roman, sansserifzfont-family: roman, cursiveézfont-family: roman, fantasyézfont-size: 1emÚsizeézfont-size: xx-smallézfont-size: x-smallg@zfont-size: smallg333333#@zfont-size: mediumzfont-size: largeg+@zfont-size: x-largeézfont-size: xx-largeézfont-size: 50%zfont-weight: 100ÚboldFzfont-weight: 200zfont-weight: 300zfont-weight: 400zfont-weight: normalzfont-weight: lighterzfont-weight: boldTzfont-weight: bolderzfont-weight: 700zfont-weight: 800zfont-weight: 900zfont-style: italicÚitaliczfont-style: obliqueztext-decoration: underlineÚ    underlineÚsingleztext-decoration: overlineztext-decoration: noneztext-decoration: line-throughÚstrikez'text-decoration: underline line-through)rrz9text-decoration: underline; text-decoration: line-throughz
color: redÚcolorÚFF0000zcolor: #ff0000zcolor: #f0aÚFF00AAztext-shadow: noneÚshadowztext-shadow: 0px -0em 0px #CCCztext-shadow: 0px -0em 0px #999ztext-shadow: 0px -0em 0pxztext-shadow: 2px -0em 0px #CCCztext-shadow: 0px -2em 0px #CCCztext-shadow: 0px -0em 2px #CCCztext-shadow: 0px -0em 2pxztext-shadow: 0px -2emzbackground-color: redÚfillÚsolid)ÚfgColorÚpatternTypezbackground-color: #ff0000zbackground-color: #f0azborder-style: solidÚborderÚstyleÚmedium)ÚtopÚbottomÚleftÚrightz'border-style: solid; border-width: thinÚthinz/border-top-style: solid; border-top-width: thinr&z.border-top-style: solid; border-top-width: 1ptzborder-top-style: solidz1border-top-style: solid; border-top-width: mediumz.border-top-style: solid; border-top-width: 2ptz0border-top-style: solid; border-top-width: thickÚthickz.border-top-style: solid; border-top-width: 4ptzborder-top-style: dottedÚmediumDashDotDotz0border-top-style: dotted; border-top-width: thinÚdottedzborder-top-style: dashedÚmediumDashedz0border-top-style: dashed; border-top-width: thinÚdashedzborder-top-style: doubleÚdoublez*border-style: solid; border-color: #0000ffÚ0000FF)r$r©r&r)r'r(z0border-top-style: double; border-top-color: bluez/border-top-style: solid; border-top-color: #06cÚ0066CCzborder-top-color: blueÚnone©rr$ztext-align: centerÚ    alignmentÚ
horizontalÚcenterztext-align: leftr(ztext-align: rightr)ztext-align: justifyÚjustifyzvertical-align: topÚverticalzvertical-align: text-topzvertical-align: middlezvertical-align: bottomr'zvertical-align: text-bottomzwhite-space: nowrapÚ    wrap_textzwhite-space: prezwhite-space: pre-linezwhite-space: normalznumber-format: 0%Ú number_formatÚformat_codez0%u!number-format: 0Â§[Red](0)Â§-Â§@;z0;[red](0);-;@có2t«}|||«k(sJy©N©r)ÚcssÚexpectedÚconverts   úXH:\Change_password\venv_build\Lib\site-packages\pandas/tests/io/formats/test_to_excel.pyÚtest_css_to_excelrEsôV"Ó#GØws|Ò#Ð#Ñ#ócóft«}|d«}ddddddiddiddiddidd    d
dd|k(sJy) NzÈ
        font-weight: bold;
        text-decoration: underline;
        color: red;
        border-width: thin;
        text-align: center;
        vertical-align: top;
        unused: something;
    Trr)rrrr$r*r2r8r&)r7r:)rr#r6r@)rCÚactuals  rDÚtest_css_to_excel_multiplerIâsmÜ!Ó#GÙ ð    ó
Fð¨H¸xÑHàVÐ$ØvÐ&Ø Ð'ØfÐ%ñ    
ð%-¸%Ñ@ñ    ð
ò    ð    ñ    rFzcss,inherited,expectedÚ)rrzfont-style: normalzfont-style: inheritz'font-style: normal; font-style: inheritcó4t|«}|||«k(sJyr?r@)rAÚ    inheritedrBrCs    rDÚtest_css_to_excel_inheritedrMûs ô(" )Ó,GØws|Ò#Ð#Ñ#rFzinput_color,output_colorú#)z#F0FÚFF00FF)z#ABCÚAABBCCcó
d|d|d|d|d|d|}i}d|d|d    <d
|i|d<dDcic]}||d d
c}|d<tjd«5t«}|||«k(sJ    ddd«ycc}w#1swYyxYw)Núborder-top-color: ú; border-right-color: ú; border-bottom-color: ú; border-left-color: ú; background-color: ú    ; color: r )r"r!rrrr2r4r5r#)ÚtmÚassert_produces_warningr)Úinput_colorÚoutput_colorrArBÚkrCs      rDÚtest_css_to_excel_good_colorsr]sÞð[Mð*Ø*mð, Ø +}ð-Ø)]ð+Ø(Mð*Øð     ððHà'.¸<ÑHHVÑà Ð.HVÑð4öà ð    
\¨FÑ3Ñ3òHXÑô
 
×    #Ñ    # DÓ    )ñ(Ü%Ó'Ø7 3<Ò'Ð'Ñ'÷(ð(ùò÷
(ð(úsª A4ÁA9Á9BrZznot-a-colorcóÎd|d|d|d|d|d|}i}|ddi|d    <tjt«5t«}|||«k(sJ    ddd«y#1swYyxYw)
NrRrSrTrUrVrWr"r r)rXrYrr)rZrArBrCs    rDÚtest_css_to_excel_bad_colorsr_6s ð[Mð*Ø*mð, Ø +}ð-Ø)]ð+Ø(Mð*Øð     ððHàÐØ)¨7Ð3Ñä    ×    #Ñ    #¤JÓ    /ñ(Ü%Ó'Ø7 3<Ò'Ð'Ñ'÷(÷(ñ(ús¹AÁA$cóötttjtj
««tjj«D]&}t|«dk(rtfd|D««r&Jy)Nrc3ó&K|]}|v
ywr?©)Ú.0ÚcÚ
upper_hexss  rDú    <genexpr>z/tests_css_named_colors_valid.<locals>.<genexpr>OsøèøÒ&F¸1 q¨J¤Ñ&Fùs)ÚsetÚmapÚstrÚupperÚstringÚ    hexdigitsrÚNAMED_COLORSÚvaluesÚlenÚall)rres @rDÚtests_css_named_colors_validrqLs\øÜS¤F×$4Ñ$4Ó5Ó6JÜ$×1Ñ1×8Ñ8Ó:òGÜ5zQ¤3Ó&FÀÔ&FÕ#FÐFÐFñGrFcó´tjd«}tj}|jj«D]\}}||vr|||ddk(rJy)Nzmatplotlib.colorsr)ÚpytestÚimportorskiprrmÚCSS4_COLORSÚitems)Ú
mpl_colorsÚ    pd_colorsrrs    rDÚ&test_css_named_colors_from_mpl_presentryRsaÜ×$Ñ$Ð%8Ó9Jä#×0Ñ0IØ!×-Ñ-×3Ñ3Ó5òBeØyÑ  Y¨t¡_¸¸a¸b¸    Ó%AÐAÐAñBrFzstyles,expected©rÚgreen©rÚredzcolor: red;)úfont-weightr)r~Únormalzfont-weight: normal;)ú
text-alignr8)ú
TEXT-ALIGNr)ztext-align: right;c
óÜt«}|jj«d|i}tdddd|dd|¬«}|jj«|j||«k(sJy)z>It applies favors latter declarations over former declarations)rrrrJN©ÚrowÚcolÚvalr$Ú
css_stylesÚcss_rowÚcss_colÚ css_converter)rÚ_call_cachedÚcache_clearrr$)ÚstylesrBÚ    converterrÚcells     rDÚtest_css_excel_cell_precedencerZsuô$Ó%IØ ×Ñ×&Ñ&Ô(Ø&Ð!JÜØ Ø ØØØØØØô    Dð×Ñ×&Ñ&Ô(à:: 8Ó,Ò,Ð,Ñ,rFzstyles,cache_hits,cache_misses)rzr|rz)rr8)rr(có~t«}|jj«t|«Dcic]
\}}d|f|}}}|D]\}}t    dddd||||¬«|jj«}    |jj«|    j|k(sJ|    j|k(sJycc}}w)zIt caches unique cell stylesrrJNr)rrrÚ    enumeraterÚ
cache_infoÚhitsÚmisses)
rÚ
cache_hitsÚcache_missesrÚiÚ_stylerrrrs
          rDÚtest_css_excel_cell_cacherwsËôF$Ó%IØ ×Ñ×&Ñ&Ô(ä2;¸FÓ2C×D¡Y Q¨1a&&.ÐDJÑDØ&ò
 
ÑÜØØØØØ!ØØØ#ö        
ð
 
ð×'Ñ'×2Ñ2Ó4JØ ×Ñ×&Ñ&Ô(à??jÒ(Ð(Ð(Ø×Ñ Ò,Ð,Ñ,ùó!Es³B9)Ú__doc__rkrsÚ pandas.errorsrÚpandas._testingÚ_testingrXÚpandas.io.formats.excelrrÚmarkÚparametrizerErIrMÚlistrmrvrnr]r_rqryrr)Úrgbs0rDú<module>r¤s ðñóã å$å÷ð×ÑØðFð
  &¨6°5¨/Ð!:Ð;ðFð
&¨°¸Ð0CÐ'DÐEð    Fð
 
" F¨V°U¨OÐ#<Ð=ðFð
)¨6°F¸E°?Ð*CÐDð Fð
! 6¨F°E¨?Ð";Ð<ðFð
'¨°&¸)Ð1DÐ(EÐFðFð
*¨F°V¸ZÐ4HÐ+IÐJðFð
*¨F°V¸ZÐ4HÐ+IÐJðFð
(¨&°6¸:Ð2FÐ)GÐHðFð
 °ÀAÑ(FÐGÐHðFð
 °ÀAÑ(FÐGÐHðFð
% v¸È1Ñ/MÐ&NÐOðFð 
*¨F¸WÐPQÑ4RÐ+SÐTð!Fð"
*¨F°V¸WÐ4EÐ+FÐGð#Fð$
)¨6°F¸GÐ3DÐ*EÐFð%Fð&
'¨¸'ÈQÑ1OÐ(PÐQð'Fð(
'¨¸'ÈQÑ1OÐ(PÐQð)Fð,
F V¨R LÐ1Ð2ð-Fð.
 ¨&°!¨Ð 5Ð6ð/Fð0
 ¨°¨ Ð6Ð7ð1Fð2
f v¨s mÐ4Ð5ð3Fð4
v¨° |Ð4Ð5ð5Fð6
f v¨t nÐ5Ð6ð7Fð8
 ¨°¨Ð5Ð6ð9Fð:
 ¨&°"¨Ð 6Ð7ð;Fð<
F V¨Q KÐ0Ð1ð=Fð@
f v¨u oÐ6Ð7ðAFðB
f v¨u oÐ6Ð7ðCFðD
f v¨u oÐ6Ð7ðEFðF
f v¨u oÐ6Ð7ðGFðH
 ¨&°%¨Ð 9Ð:ðIFðJ
  &¨6°5¨/Ð!:Ð;ðKFðL
v¨° ~Ð6Ð7ðMFðN
 ¨&°$¨Ð 8Ð9ðOFðP
f v¨t nÐ5Ð6ðQFðR
f v¨t nÐ5Ð6ðSFðT
f v¨t nÐ5Ð6ðUFðX
 ¨°4Ð(8Ð9Ð:ðYFðZ
 ¨(°DÐ)9Ð :Ð;ð[Fð^
&¨°¸hÐ0GÐ'HÐIð_Fð`
% bÐ)ðaFðb
! "Ð%ðcFðf
)¨6°H¸dÐ3CÐ*DÐEðgFðj 6Ø  °8Ñ<Ð=ð    
ðiFðr HØ h Ð%Ð&ð    
ðqFðz
 ¨(Ð 3Ð4Ð5ð{Fð|
F W¨hÐ$7Ð8Ð9ð}Fð~
 '¨8Ð!4Ð5Ð6ðFðB
v¨°%Ð'8Ð9Ð:ðCFðD
*¨F°X¸uÐ4EÐ+FÐGðEFðF
*¨F°X¸uÐ4EÐ+FÐGðGFðH
% v°¸%Ð/@Ð&AÐBðIFðJ
*¨F°X¸tÐ4DÐ+EÐFðKFðL
*¨F°X¸tÐ4DÐ+EÐFðMFðN
*¨F°X¸tÐ4DÐ+EÐFðOFðP
% v°¸$Ð/?Ð&@ÐAðQFðR
! 6¨H°dÐ+;Ð"<Ð=ðSFðZ $Ø  ¸'ÑBÐCð    
ðYFðb (Ø  ¸'ÑBÐCð    
ðaFðj %Ø  ¸'ÑBÐCð    
ðiFðv "àØ# XÐ.Ø&¨Ð1Ø$ hÐ/Ø% xÐ0ñ    ð ð
    
ðuFðL 6àØ# VÐ,Ø&¨Ð/Ø$ fÐ-Ø% vÐ.ñ    ð ð
    
ðKFðb >Ø  ¨Ð0Ð1Ð2ð    
ðaFðj =Ø  ¨Ð0Ð1Ð2ð    
ðiFðp
# X°¸ÀÐ7JÐ/KÐ$LÐMðqFðt @Ø  ¨Ð2Ð3Ð4ð    
ðsFð| =Ø  ¨Ð2Ð3Ð4ð    
ð{FðD ?Ø  ¨Ð1Ð2Ð3ð    
ðCFðL =Ø  ¨Ð1Ð2Ð3ð    
ðKFðT 'Ø  Ð);Ð<Ð=Ð>ð    
ðSFð\ ?Ø  ¨Ð2Ð3Ð4ð    
ð[Fðb
$ h°¸À.Ð8QÐ0RÐ%SÐTðcFðf ?Ø  ¨Ð2Ð3Ð4ð    
ðeFðl
$ h°¸À(Ð8KÐ0LÐ%MÐNðmFðr 9àØ%-¸ÑAØ'/¸(ÑCØ(0¸8ÑDØ&.¸ÑBñ    ð ð
    
ðqFðH ?Ø ¨¸HÑEÐFÐGð    
ðGFðP >Ø ¨¸HÑEÐFÐGð    
ðOFðX %Ø ¨¸FÑCÐDÐEð    
ðWFðb
 ¨l¸HÐ-EÐFÐGðcFðd
k¨L¸&Ð+AÐBÐCðeFðf
{¨\¸7Ð,CÐDÐEðgFðh
 ¨|¸YÐ.GÐ HÐIðiFðl
 ¨z¸5Ð.AÐ BÐCðmFðn
$ k°JÀÐ3FÐ%GÐHðoFðp
" K°*¸hÐ1GÐ#HÐIðqFðr
" K°*¸hÐ1GÐ#HÐIðsFðt
'¨°zÀ8Ð6LÐ(MÐNðuFðx
 ¨{¸EÐ.BÐ CÐDðyFðz
k¨K¸Ð+?Ð@ÐAð{Fð|
! ;°¸eÐ0DÐ"EÐFð}Fð~
 ¨{¸DÐ.AÐ BÐCðFðB
°ÀÐ0EÐFÐGðCFðF 0Ø }Ð.>Ð?Ð@ð    
ðEFóIñT$óUIðT$ò
ð2×ÑØà    b 6¨F°D¨>Ð":Ð;Ø    Ð   6¨F°D¨>Ð":Ð;àØ Ø d¨dÑ3Ð4ð    
ð
 
Ð3°f¸xÈÐ>OÐ5PÐQØ      BÐ'à5Ø Ø h Ð%Ð&ð    
ðóñ&$ó'ð&$ð
×ÑØáÐ  × -Ñ -× 3Ñ 3Ó 5Ó6Ø':×'GÑ'G×'NÑ'NÓ'PÖ
Q C#IsÒÒ
Qñ    RàÐ1Ð
2ñ    3óñ(óð(ð6×Ñ¨¨}Ð(=Ó>ñ(ó?ð(ò*GòBð×ÑØà
Ð.Ð    /°Ð?Ø
!Ð#<Ð    =Ð?UÐVØ
"Ð$;Ð    <Ð>RÐSðóñ-óð-ð*×ÑØ$â
DÐ    EÀqÈ!ÐLð)Ð)Ø*Ð,CÐDð ð Ø ð     
ð$Ð
$Ð'?Ð&@Ð    AÀ1ÀaÐHð)Ð*BÐCØ(Ð*@ÐAð ð Ø ð     
ð)Ð*BÐCØ(Ð*@ÐAØ(Ð*BÐCð ð
 Ø ð    
ð'óñ@-óAñ@-ùòARsÐS#