fume-manage-python.git

U  
ý°d ã@s^
dZddlmZmZmZmZddlmZddlmZ    ddl
mZddlZ ddlZddlZddlmZddlmZddlZdd    lmZmZmZmZmZmZddlmZdd
lm Z ddl!m"Z"ddl#m$Z$ej% &d ¡Z'ej% &d¡Z(e'ddZ)e'ddZ*e'ddZ+e'ej% ,dddg¡ddZ-ej% ,de.e/eeg¡ej% ,dddg¡ddZ0e'ej% ,dddg¡d d!Z1d"d#Z2e'd$d%Z3e'd&d'Z4e'd(d)Z5ej% ,d*d+ddggd,fd-d.ddgid/fg¡d0d1Z6d2d3Z7e'd4d5Z8e'd6d7Z9e'd8d9Z:e'd:d;Z;ej%j<d<d=ej% ,d>d?d@ggddggg¡dAdBZ=e'ej% ,d>ddgdCdDgg¡dEdFZ>e'ej% ,dGddgddgg¡dHdIZ?e'ej% ,dJdKdidLdig¡dMdNZ@dOdPZAe'ej% ,dQdRddgidRfdRddgidfddggdfg¡dSdTZBe'dUdVZCe'dWdXZDe'dYdZZEej% ,dJidGd[ig¡d\d]ZFej% ,d>d^e  Gd_d`g¡ddahg¡dbdcZHej% ,ddddg¡ej% ,dedfdgg¡dhdiZIej% ,ddddg¡ej% ,dedjg¡dkdlZJe'dmdnZKej% ,dodpdqg¡drdsZLej% ,dodpdqg¡dtduZMe'ej% ,dvdwd>dCgieedxd_dygdCgdzfdwddd{eed|gdCd}gd~fdd>dCdgieedxd_dyedddggdCdgdzfddddgd{eejNedxd_dyedddfgdCdgdgd~fg¡ddZOe'ddZPe'ej% ,dvdddddgideeddd`dddddgeddd`dddddggddCdgdzfddddgddagddeedddddedddddddgedddddedddddddgedddddedddddddgedddddedddddddgedddddedddddddgedddd dedddddddggd¡dRdd_gdzfg¡d¢d£ZQe'ej% Rd¤¡d¥d¦ZSe'ej% ,d§d¨d©dªeTfd«g¡d¬dZUe'ej% ,d§d¨d®dªeTfd¯g¡d°d±ZVe'd²d³ZWe'd´dµZXd¶d·ZYej% ,d¸d¹edCdºd»gid¼d½fd¾edCd¿dÀdÁgid¼d½fg¡ej% ,d>ddg¡dÂdÃZZdÄdÅZ[e(ej% ,dÆdÇdÈdÉdÊdËdÌg¡dÍdÎZ\e(ej% ,dÏdÐdedÑddÒfdÓdedÑddÒfdÔdedÑdd_fg¡dÕdÖZ]e(ej% ,dÏdÐdedÑddÒfdÓdedÑddÒfg¡d×dØZ^dÙdÚZ_dÛdÜZ`e(ee ej% ,dÝe.dÞ¡ej% ,dKddg¡ej% ,dßdàdádâdãdädådæg¡dçdèZae(ej% ,déddêgd?d@gdëfddêgdd@gd@fddêgd?d@ggdëfddêgdd@ggd@fddêgd?dd@gid@fddêgd?d?d@gidëfddêgd?d@gd?gdëfdìdídîgdd?d@gdëfdìdídîgdìdîgdìd@gd@fg    ¡dïdðZbe(dñdòZce(dódôZde(ej% ,dõdöd÷ggdøfdùdöd÷gidùfg¡dúdûZee(düdýZfe(dþdÿZgddZhej% ,dejiddddejiddddg¡dd    Zje(d
dZke(ej% ,d§d¨ddªeTfd g¡ddZle(ddZmddZnddZoe(ej% ,ddddggfddddgifg¡ddZpe(ddZqdS(zO
Tests date parsing functionality for all of the
parsers defined in parsers.py
é)ÚdateÚdatetimeÚ    timedeltaÚtimezone)ÚStringIO)Úparse)ÚgivenN)Úparsing)Úpy_parse_datetime_string)Ú    DataFrameÚ DatetimeIndexÚIndexÚ
MultiIndexÚSeriesÚ    Timestamp)ÚDATETIME_NO_TZ)Ú
date_range)Úread_csvZ pyarrow_xfailZpyarrow_skipc    Csdd}td}|jtd|dd|dd}dd    d
ddg}tjd d|Ddd}tdddddgdddddgdddddgd|d}t ||¡dS)NcSs&| tj¡}| tj¡}tj|ddS©NÚs©Úunit©ÚastypeÚnpZfloat_Úint_ÚpdÚto_timedelta©Útime©r ú^d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/tests/io/parser/test_parse_dates.pyÚ__custom_date_parser0szCtest_read_csv_with_custom_date_parser.<locals>.__custom_date_parsera time e n h
        41047.00 -98573.7297 871458.0640 389.0089
        41048.00 -98573.7299 871458.0640 389.0089
        41049.00 -98573.7300 871458.0642 389.0088
        41050.00 -98573.7299 871458.0643 389.0088
        41051.00 -98573.7302 871458.0640 389.0086
        ú Please use 'date_format' insteadTr©Zdelim_whitespaceÚparse_datesÚdate_parserÚ    index_coliW iX iY iZ i[ cSsg|]}tj|ddqS)rr)rr)Ú.0Úir r r!Ú
<listcomp>Hsz9test_read_csv_with_custom_date_parser.<locals>.<listcomp>©Únameg>èÙ¬ÛøÀgV«ÛøÀgáz®ÛøÀgù1æ®ÛøÀg¦Ä D*AgÒÞ D*Agúíë D*AgóSt$Px@gGx$Px@gîëÀ9#Px@)ÚeÚnÚh©Úindex)rÚread_csv_check_warningsÚ FutureWarningrZTimedeltaIndexrÚtmÚassert_frame_equal©Úall_parsersr"ZtestdataÚresultrÚexpectedr r r!Ú%test_read_csv_with_custom_date_parser-s.ÿ    ù    ýú    r:c    Cshdd}td}|jtd|dd|dd}td    d
ddd gdd}tddddddgi|d}t ||¡dS)NcSs&| tj¡}| tj¡}tj|ddSrrrr r r!r"XszUtest_read_csv_with_custom_date_parser_parse_dates_false.<locals>.__custom_date_parserztime e
        41047.00 -93.77
        41048.00 -95.79
        41049.00 -98.73
        41050.00 -93.99
        41051.00 -97.72
        r#TFrr$gà
ä@gä@g ä@g@ä@g`ä@r+r-gáz®GqWÀgÃõ(\òWÀgëQ¸®XÀgÂõ(\WÀg®GáznXÀr0)rr2r3rrr4r5r6r r r!Ú7test_read_csv_with_custom_date_parser_parse_dates_falseUs&ÿ    ù    þr;cCs\|}d}ttdddddddggddgd    }|jt|d
ddddgidd }t ||¡dS)Nz06-02-2013;13:00;1-000.215éÝééé rgëQ¸A@ÚDate©Úcolumnsú;ú-é)ÚsepÚ    thousandsr%Úheader)rrrrr4r5)r7ÚparserÚdatar9Údfr r r!Útest_separator_date_conflictxsÿ
ûrLÚ keep_date_colTFcCsÌd}|}dd}d|ddgddgd|dd    d
ddd dddg    d}|jtdt|f|}ttdddddtddddddddddddd d!gtdddd"dtdddddddd#d$d%d&dd d'gtdddd(dtdddd"dddd)d*d+d&d,d d!gtdddd(dtdddd(dddd)d-d.d/d0d d1gtdddd2dtdddd(dddd3d4d+d5d6d d7gtdddd8dtdddd2dddd9d:d+d5d;d d!ggd<d=dd    d
ddd dddgd>}|s²|jd    d
dgdd?}||j}t ||¡dS)@NáÌKORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000
KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000
KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000
KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000
KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000
KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000
cWstjt |¡tdS)zË
        Test date parser.
 
        Parameters
        ----------
        date_cols : args
            The list of data columns to parse.
 
        Returns
        -------
        parsed : Series
        )rI)r    Ztry_parse_datesÚconcat_date_colsÚdu_parse)Ú    date_colsr r r!r&s ÿz2test_multiple_date_col_custom.<locals>.date_parserrEr>é©ÚactualÚnominalÚX0ÚX1ÚX2ÚX3ÚX4ÚX5ÚX6ÚX7ÚX8)rHr&r%rMÚnamesúuse 'date_format' insteadéÏééréé8ÚKORDÚ19990127ú     19:00:00ú     18:56:00çìQ¸ëé?ç{®Gáz@çÍÌÌÌÌÌ@ççq@éú     20:00:00ú     19:56:00ç{®Gáz?ç®Gáz®@ç@p@éú     21:00:00ú     20:56:00çáz®Gáâ¿çÍÌÌÌÌÌ@ú     21:18:00ç®Gáz®ï¿ç®Gáz@çÍÌÌÌÌÌ@çàp@éú     22:00:00ú     21:56:00ç\Âõ(\û?çffffff@ç r@éú     23:00:00ú     22:56:00çffffff@rTrUrA©Zaxis)    r2r3rrrÚdroprBr4r5)r7rMrJrIr&Úkwdsr8r9r r r!Útest_multiple_date_col_customsÖûýüõõõõõõ¾Qõ¯`
rÚ    containerÚdimrEr>c    sLd}dtfddt|D}tjt|dt |¡W5QRXdS)Nz0not all elements from date_cols are numpy arraysrgc3s|]}gVqdS©Nr )r(Ú_©rÚvaluer r!Ú    <genexpr>*sz,test_concat_date_col_fail.<locals>.<genexpr>©Úmatch)ÚtupleÚrangeÚpytestÚraisesÚ
ValueErrorr    rO)rrÚmsgrQr rr!Útest_concat_date_col_fail$s
rcCs²d}|}dddgddgg|ddddd    d
ddd g    d}|jt|f|}ttdddddtddddddddddddddgtdddddtddddddddd d!d"ddd#gtdddd$dtdddddddd%d&d'd"d(ddgtdddd$dtdddd$dddd%d)d*d+d,dd-gtdddd.dtdddd$dddd/d0d'd1d2dd3gtdddd4dtdddd.dddd5d6d'd1d7ddggd8d9ddddd    d
ddd gd:}|s¢|jdddgdd;}t ||¡dS)<NrNrEr>rRrVrWrXrYrZr[r\r]r^)rHr%rMr_rarbrcrrdrerfrgrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rrrrrrrrrrZX1_X2ZX1_X3rAr)rrrrrr4r5)r7rMrJrIrr8r9r r r!Útest_multiple_date_col0sÄüõõõõõõ¾Qõ¯`rcCs.d}|}ddgdddddddd    d
gd}|jt|f|}ttddd ddtddd ddtddd ddtddd ddtddd ddgdd}tdddddddgdddddddgddd dd!ddgdd"d#d$d%dd&gdd'd d(d)dd*ggdddddd    d
g|d+}|jd,krt d-|d¡jj    |d<t
 ||¡dS).NazKORD,19990127 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000
KORD,19990127 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000
KORD,19990127 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000
KORD,19990127 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000
KORD,19990127 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000
rErVrWrXrYrZr[r\r])rHr%r'r_rarbrcrrorurr+rfrirjrkrlrmrnrqrrrsrtrwrxryrzr{r|r}r~rrrr©rBr1Úpyarrowú
1970-01-01)rrr rrÚenginerÚto_datetimeÚdtrr4r5)r7rJrIrr8r1r9r r r!Útest_date_col_as_index_colªs<üûø
û÷r¤c Cs8d}ddgddgd}|}d|tjd}|jtdt|f|}ttddd    d
dtddd    dd ddgtddd    ddtddd    d
d ddgtddd    ddtddd    dd ddgtddd    ddtddd    ddddgtddd    ddtddd    dd ddgtddd    ddtddd    dd ddggddddgd}||j}t     ||¡dS)NúÿKORD,19990127, 19:00:00, 18:56:00, 0.8100
KORD,19990127, 20:00:00, 19:56:00, 0.0100
KORD,19990127, 21:00:00, 20:56:00, -0.5900
KORD,19990127, 21:00:00, 21:18:00, -0.9900
KORD,19990127, 22:00:00, 21:56:00, -0.5900
KORD,19990127, 23:00:00, 22:56:00, -0.5900rEr>rRrS©rHr%r&r`rarbrcrrdrerfrjrorrrurxr{rrrTrUérA)
rr¢r2r3rrrrBr4r5)r7rJr%rIrr8r9r r r!Ú test_multiple_date_cols_int_castØsVÿýÿÿ""üüüüë
ã#
r¨c    Cs~|}d}|jtdt|ddggdtd}ttdddddtjdgtddd    ddtjdggd
ddd dddgd}t ||¡dS)Nz]05/31/2012,15:30:00.029,1306.25,1,E,0,,1306.25
05/31/2012,15:30:00.029,1306.25,8,E,0,,1306.25r`rrE)r%rHr&z05/31/2012, 15:30:00.029gi@ÚEéZ0_1r>rRr§ér=érA)    r2r3rrrrÚnanr4r5©r7rIrJr8r9r r r!Ú&test_multiple_date_col_timestamp_parses>úù
ùöër¯cCs|}d}|jt|dddgid}ttddddd    d
ddd dddgtddddd    d
ddddddgtddddd    d
ddddddgtddddd    d
ddddddgtddddd    d
d dd!d"dd#gtdddd$d    d
d%dd!d&ddggdd'd(d)d*d+d,d-gd.}t ||¡dS)/Na ID,date,NominalTime,ActualTime,TDew,TAir,Windspeed,Precip,WindDir
KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000
KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000
KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000
KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000
KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000
KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000rUrEr>©r%rarbrcrrfrirjrkrlrmrnrorqrrrsrtrurwrxryrzr{r|r}r~rrrrrrrrÚIDÚ
ActualTimeÚTDewÚTAirÚ    WindspeedÚPrecipÚWindDirrA)rrrrr4r5r®r r r!Ú#test_multiple_date_cols_with_header=s    øøøøøøÍ?øÁJr¸zdata,parse_dates,msgzSdate_NominalTime,date,NominalTime
KORD1,19990127, 19:00:00
KORD2,19990127, 20:00:00z0New date column already in dict date_NominalTimezCID,date,nominalTime
KORD,19990127, 19:00:00
KORD,19990127, 20:00:00r±zDate column ID already in dictc    Cs4|}tjt|d|jt||dW5QRXdS)Nrr°)rrrrr)r7rJr%rrIr r r!Ú%test_multiple_date_col_name_collisionsr¹cCs|}d}|jtdt|ddgddd}tdddd    d
ddd ddddggddddddddddddgttdgddd }t ||¡dS)!Nz¶posix_timestamp,elapsed,sys,user,queries,query_time,rows,accountid,userid,contactid,level,silo,method
1343103150,0.062353,0,4,6,0.01690,3,12345,1,-1,3,invoice_InvoiceResource,search
r`rcSst t|¡Sr)rÚutcfromtimestampÚint©Úxr r r!Ú<lambda>Ãóz*test_date_parser_int_bug.<locals>.<lambda>)r'r%r&go»ì¯?r§r=gX¨5Í;N?rRi90rEéÿÿÿÿZinvoice_InvoiceResourceÚsearchÚelapsedÚsysÚuserZqueriesZ
query_timeÚrowsZ    accountidZuseridZ    contactidÚlevelZsiloÚmethodz2012-07-24 04:12:30Zposix_timestampr+r)r2r3rrr rr4r5r®r r r!Útest_date_parser_int_bug³sTÿúôÿôá!rÈc    Cs~|}tttjdddtdd}tj|jddddf<t d¡.}|     |¡|j
|d    d
gd}t ||¡W5QRXdS)Né
Úfloat64©ÚdtypeZ20010101)ÚAÚBrRr=z__nat_parse_.csvrrÎ©r'r%)rÚdictrZarangerrZilocr4Zensure_cleanZto_csvrr5)r7rIrKÚpathr8r r r!Útest_nat_parseésÿ
rÒcCsbd}|}|jtdt|ddd}|jt|dd}t ||¡|jt|dd    }t ||¡dS)
Nú3A,B,C
20090101,a,1,2
20090102,b,3,4
20090103,c,4,5
r`cSst |d¡S)Nú%Y%m%d)rÚstrptimer¼r r r!r¾r¿z(test_csv_custom_parser.<locals>.<lambda>)r&Tr°rÔ)Údate_format)r2r3rrr4r5©r7rJrIr8r9r r r!Útest_csv_custom_parserùsürØcCs>d}|}|jt|dd}|jt|ddd}t ||¡dS)NrÓTr°rrÏ©rrr4r5r×r r r!Ú#test_parse_dates_implicit_first_col s
rÚcCsnd}|}|jt|ddgd}tttdddddd}tdd    d
gdddgd ddgd|d}t ||¡dS)Nz8date,A,B,C
20090101,a,1,2
20090102,b,3,4
20090103,c,4,5
rrÏz1/1/2009rR)Zperiods)r,ÚfreqÚaÚbÚcrEr§r>r«)rÍrÎÚCr0)rrrÚlistrrr4r5)r7rJrIr8r1r9r r r!Útest_parse_dates_stringsÿÿráz#yearfirst is not surfaced in read_*©Úreasonr%rrc
Csd}|}|jtdt|d|d}ttddddddtdd    d
dddtdddd ddgtdd}tdddgd    ddgd|d}t ||¡dS)Nz>date,time,B,C
090131,0010,1,2
090228,1020,3,4
090331,0830,5,6
úCould not infer formatrrÏéÙrEérÉr>érorRrªéÚ    date_time©rÌr,r«r§r=©rÎrßr0)    r2ÚUserWarningrrrÚobjectrr4r5)r7r%rJrIr8r1r9r r r!Útest_yy_format_with_year_first1s&ûýù    rîrÜrÞcCsfd}|}ttdddgdgtdddgd}| ddg¡}|jt|d    dg|d
d}t ||¡dS)Nza,b,c
01/01/2010,1,15/02/2010éÚrEr>é©rÜrÝrÞrÜrÝrT)r'r%Údayfirst)rrÚ    set_indexrrr4r5)r7r%rJrIr9r8r r r!Útest_parse_dates_column_listNs ÿÿrôr'cCsØd}|}tjtdddtdddtdddfdgddgd    }|dd
gkrT| d
d¡}tdddgddd gdd dgdddgddd gdd dgdddgddd gdd dgg    dddg|d}|jtdt||dd}t     ||¡dS)NzÅindex1,index2,A,B,C
20090101,one,a,1,2
20090101,two,b,3,4
20090101,three,c,4,5
20090102,one,a,1,2
20090102,two,b,3,4
20090102,three,c,4,5
20090103,one,a,1,2
20090103,two,b,3,4
20090103,three,c,4,5
rårEr>rR)ZoneZtwoZthreeZindex1Úindex2©r_rrÜrÝr§rÞr«rÍrÎrßrräTrÏ)
rZfrom_productrZ    swaplevelrr2rìrr4r5)r7r'rJrIr1r9r8r r r!Útest_multi_index_parse_dates_s@ þû    ÷óûr÷ÚkwargsròZ    day_firstcsò|}d}dkr|jtdt|dddgfddd    d    d
dgd    }ttd ddtd ddtd ddgdd}tdddgdtjdgd|ddgd}t     ||¡nPd}t
jt|d8|jtdt|dddgfddd    gd    d
dgd    W5QRXdS)Nz:foo,bar,baz
31/01/2010,1,2
01/02/2010,1,NA
02/02/2010,1,2
ròr`rÚQÚNTUcst|fSr©rP©Úd©rør r!r¾¢r¿z5test_parse_dates_custom_euro_format.<locals>.<lambda>rTZNA)r_r&rHr'r%Ú    na_valuesrïrErær>r+)rùrú©r1rBz.got an unexpected keyword argument 'day_first'rcst|fSrrûrürþr r!r¾ºr¿)r_r&Zskiprowsr'r%rÿ) r2r3rr rrrrr4r5rrÚ    TypeError)r7rørIrJrKZ    exp_indexr9rr rþr!Ú#test_parse_dates_custom_euro_formatsJ
÷ þý
÷rcCst|}d}|jt|ddd}tddgittdgdd    d
}t ||¡|jdkrZtj    }nt
j    }|jj|kspt dS)NzDate,x
2012-06-13T01:39:00Z,0.5rTrÏr½gà?z2012-06-13 01:39:00+00:00r@r+r0r)rrrr rr4r5r¡ÚpytzÚutcrr1ÚtzÚAssertionError)r7ÚrequestrIrJr8r9Zexpected_tzr r r!Útest_parse_tz_awareÂsÿ
rzparse_dates,index_colrUcCs|}d}ttdddddddd    d
ddd gtddddddddddddgtdddddddddddd gtddddddddddddgtdddddd d!dd"d#dd$gtdddd%dd&d'dd"d(dd ggd)d*d+d,d-d.d/d0gd1}| d)¡}t|tsôd2|j_|jt|||d3}t     
||¡dS)4Na
ID,date,NominalTime,ActualTime,TDew,TAir,Windspeed,Precip,WindDir
KORD1,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000
KORD2,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000
KORD3,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000
KORD4,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000
KORD5,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000
KORD6,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000
rarErbrcrZKORD1rirjrkrlrmrnroZKORD2rqrrrsrtruZKORD3rwrxryZKORD4rzr{r|r}r~rZKORD5rrrrrZKORD6rrrUr±r²r³r´rµr¶r·rAZdate_NominalTime©r%r')rrróÚ
isinstancerÐr1r,rrr4r5)r7r%r'rIrJr9r8r r r!Útest_multiple_date_cols_indexÓs    øøøøøøÍ?øÁJ
 
ÿrcCs`|}d}ttdddddddd    d
ddd gtddddddddddddgtdddddddddddd gtddddddddddddgtdddddddddddd gtdddd!ddd"ddd#dd ggd$d%d&d'd(d)d*d+gd,}| d$¡}|jt|d$dd-gid$d-d.}t|}W5QRXt |d|dd-¡t |d|d-d/¡t |d-|d/d¡dS)0NáõID,date,nominalTime,actualTime,A,B,C,D,E
KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000
KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000
KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000
KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000
KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000
KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000
rarErbrcrrfrirjrkrlrmrnrorqrrrsrtrurwrxryrzr{r|r}r~rrrrrrrrrUr±Z
actualTimerÍrÎrßÚDr©rAr>)r%r'Ú    chunksizer§)rrrórrràr4r5)r7rIrJr9ÚreaderÚchunksr r r!Útest_multiple_date_cols_chunked8s
øøøøøøÍ>ÁA
 
ürcCsP|}d}|jt|dddgidd}|jt|ddddgid}t ||¡dS)    NrrUrEr>r    rZnominalTimerÏrÙ)r7rIrJZwith_indicesZ
with_namesr r r!Ú)test_multiple_date_col_named_index_compats
 
ÿ
ýrcCs`|}d}|jt|ddgdddgid}|jt|dddgid}| ddg¡}t ||¡dS)NrrUr±rEr>rÏr°)rrrór4r5r®r r r!Ú,test_multiple_date_col_multiple_index_compats    
ÿrrßc    CsD|}d}d}tjt|d |jt|fddi|W5QRXdS)NúSOnly booleans, lists, and dictionaries are accepted for the 'parse_dates' parameterúA,B,C
    1,2,2003-11-1rr%rß©rrrrr)r7rørIrrJr r r!Ú*test_read_with_parse_dates_scalar_non_boolÂsÿr©rEr§r«rRc    Cs<|}d}d}tjt|d|jt|ddW5QRXdS)Nrrrrr°r)r7r%rIrrJr r r!Ú'test_read_with_parse_dates_invalid_typeÑsÿrÚcache_datesrrÚc    CsP|}t|dd}|jdkr*|s*t}nd}|j|d|dddgdg|ddS©Nz,
iPÃrräÚfooÚbar)rHr_r%r©rr¡rìr2©r7rrrIrÚwarnr r r!Útest_bad_date_parseßsùr"Ú0c    CsV|}t|dd}|jdkr&d}n|r0d}nt}|j|d|dddgdg|ddSrrr r r r!Ú test_bad_date_parse_with_warningüs 
ùr$cCsT|}d}|jt|dgdd}ttddddgtjdggddgd    }t ||¡dS)
NúDate,test
2012-01-01,1
,2r@F)r%Z    na_filteriÜrEr>ÚtestrA)rrrrrÚNaTr4r5r®r r r!Útest_parse_dates_empty_stringsÿr(rr2Zread_table_check_warningscCs,|}d}t||tdt|dgddddS)Nr%z2The argument 'infer_datetime_format' is deprecatedr@Tú,)r%Zinfer_datetime_formatrF)Úgetattrr3r)r7rrIrJr r r!Ú.test_parse_dates_infer_datetime_format_warning(súr+c
CsN|}d}d}tjt|d*t||tdt|dgtjdddW5QRXdS)    Nr%z/Cannot use both 'date_parser' and 'date_format'rr`r@ZISO8601r))r%r&rÖrF)rrrr*r3rrr¢)r7rrIrJrr r r!Ú,test_parse_dates_date_parser_and_date_format:sùr,zdata,kwargs,expectedza
04.15.2016iàrðrAr    z
2016-04-15r+rza,b
04.15.2016,09.16.2013rÝr<é    éröcCs.|}|jt|fddi|}t ||¡dS)NrGÚ.rÙ©r7rJrør9rIr8r r r!Ú%test_parse_dates_no_convert_thousandsNs#r1cCsd}|}|jtdt|ddgdddgitjd}tdddd    ddd
dgtddddddd dgg}t|dddgd}t ||¡dS)NzUD,T,A,B
date, time,a,b
2001-01-05, 09:00:00, 0.0, 10.
2001-01-06, 00:00:00, 1.0, 11.
r`rrErér¦éÑr«r-rmç$@r=çð?ç&@)rÍrÜ)rÎrÝrA)    r2r3rrr¢rrr4r5)r7rJrIr8Ú expected_datar9r r r!Ú,test_parse_date_time_multi_level_column_namews
ú
þr7zKdate,time,a,b
2001-01-05, 10:00:00, 0.0, 10.
2001-01-05, 00:00:00, 1., 11.
ré©rHr%r2rÉrmr4r5r¥rSrarbrcrdrerfrjrorrrurxr{rrrTcCs>|}|jtdt|fdtji|}||j}t ||¡dS)Nr`r&)r2r3rrr¢rBr4r5r0r r r!Útest_parse_date_timesJýüû
r9z+ignore:elementwise comparison:FutureWarningc    Csj|}d}|jtdt|dddddgitjd}ttddd    d
gtddddggddgd }t ||¡dS)Nú-year,month,day,a
2001,01,10,10.
2001,02,1,11.r`rZymdrEr>r¦r2rÉr3r5rÜrA)    r2r3rrr¢rrr4r5r®r r r!Útest_parse_date_fieldsësú    þr;)Úkeyrr!r&cCstj|ddS)Nú%Y %m %d %H %M %S©Úformat©rr¢r¼r r r!r¾r¿r¾)rÖr=Nc
Cs|}d}|j|dt|fdddddddd    gid
||i}ttddd    dddd dgtddd    dddddggdddgd}t ||¡dS)NzZyear,month,day,hour,minute,second,a,b
2001,01,05,10,00,0,0.0,10.
2001,01,5,10,0,00,1.,11.
r`rÚymdHMSrEr>rRr§r«r8r2rÉrmr3r4r5rÜrÝrA©r2rrrr4r5©r7r<rr!rIrJr8r9r r r!Útest_parse_date_all_fieldss& ýûúþûrDcCstj|ddS)Nú%Y %m %d %H %M %S.%fr>r@r¼r r r!r¾,r¿)rÖrENcCs|}d}|j|dt|fdddddddd    gid
||i}ttddd    dddd dddgtddd    dddddddggdddgd}t ||¡dS)Nzgyear,month,day,hour,minute,second,a,b
2001,01,05,10,00,0.123456,0.0,10.
2001,01,5,10,0,0.500000,1.,11.
r`rrArEr>rRr§r«r8r2rÉi@â)Úmicrosecondrmr3i ¡r4r5rÜrÝrArBrCr r r!Ú test_datetime_fractional_seconds&s& ýûúþûrGcCs|}d}dd}|jtdt|ddddgi|d}ttd    ddd
dgtd    dddd ggdddgd}|d d¡|d<t ||¡dS)Nr:cSsddt||DS)NcSs&g|]\}}tt|t|ddqS)rE)ÚyearÚmonthÚday)rr»)r(ÚyÚmr r r!r*Qsz8test_generic.<locals>.parse_function.<locals>.<listcomp>)Úzip)ÚyyÚmmr r r!Úparse_functionPsz$test_generic.<locals>.parse_functionr`rZymrEr¦r2rÉr3r>r5rJrÜrAúdatetime64[ns])r2r3rrrrr4r5)r7rIrJrPr8r9r r r!Útest_genericKs"
ú"þrRcCs|}d}dd}|jtdt||dddgiddgd    }tjd
gddd }tddgditj|dddggddgdd}t     ||¡dS)Nzxdate,time,prn,rxstatus
2013-11-03,19:00:00,126,00E80000
2013-11-03,19:00:00,23,00E80000
2013-11-03,19:00:00,13,00E80000
cSsHz|d|}Wn(tk
r8ddt||D}YnXtj|ddS)NÚTcSsg|]\}}t ||¡qSr )rÚcombine)r(rýÚtr r r!r*sszNtest_date_parser_resolution_if_not_ns.<locals>.date_parser.<locals>.<listcomp>ú datetime64[s]rË)rrMrÚarray)r£rZarrr r r!r&ns
z:test_date_parser_resolution_if_not_ns.<locals>.date_parserr`rrrZprn)r&r%r'z2013-11-03T19:00:00rRrVrËZrxstatusZ00E80000é~rr?rö)rJr1)
r2r3rrrWrrZfrom_arraysr4r5)r7rIrJr&r8Z    datetimesr9r r r!Ú%test_date_parser_resolution_if_not_nscs(
ú    þþrYcCsR|}d}|jt|dgd}ddgddgddgg}t|d    dgd
}t ||¡dS)Nz+case,opdate
7,10/18/2006
7,10/18/2008
621, Zopdater°r¬z
10/18/2006z
10/18/2008imú ZcaserA©rrrr4r5©r7rIrJr8r6r9r r r!Ú(test_parse_date_column_with_empty_stringsr]z data,expectedz"a
135217135789158401
1352171357E+5l0 l H®bêkrÊrËz%a
99999999999
123456789012345
1234E+0lÿgí]ly_"AiÒcCs&|}|jt||d}t ||¡dS)Nr°rÙ)r7rJr9r%rIr8r r r!Útest_parse_date_floatsr^c
Csn|}d}|jt|dgd}tttdddttddd    dd
}|dddddgd }t|}t     ||¡dS)Nzìdt,val
              2018-01-04 09:01:00+09:00,23350
              2018-01-04 09:02:00+09:00,23400
              2018-01-04 09:03:00+09:00,23400
              2018-01-04 09:04:00+09:00,23400
              2018-01-04 09:05:00+09:00,23400r£r°z2018-01-04 09:01:00z2018-01-04 09:05:00Z1mini)Úminutes)ÚstartÚendrÛr)rÛi6[ih[)r£Úval)
rrrràrrrrr4r5)r7rIrJr8Zdtir6r9r r r!Útest_parse_timezone®s"üÿ÷rcÚdate_stringz
32/32/2019z
02/30/2019z
13/13/2019z13/2019z
a3/11/2018z
10/11/2o17cCs<|}td|gidd}|jt|ddgd}t ||¡dS)NrrírËr8©rrrr4r5)r7rdrIr9r8r r r!Ú!test_invalid_parse_delimited_dateÊsýrfzdate_string,dayfirst,expectedz
13/02/2019iãr?z
02/13/2019z
04/02/2019cCs>|}td|gidd}|jt|d|dgd}t ||¡dS)NrrQrË©rHròr%re)r7rdròr9rIr8r r r!Ú)test_parse_delimited_date_swap_no_warningÚsÿrhcCsF|}td|gidd}d}|jt|t|d|dgd}t ||¡dS)NrrQrËúzParsing dates in .* format when dayfirst=.* was specified. Pass `dayfirst=.*` or specify a format to silence this warning.rg)rr2rìrr4r5)r7rdròr9rIÚwarning_msgr8r r r!Ú+test_parse_delimited_date_swap_with_warningñs ÿúrkc    Cs0tjtddt ddddg¡W5QRXdS)Nz_^time data "31/05/2000" doesn\'t match format "%m/%d/%Y", at position 1. You might want to try:rz
01/01/2000z
31/05/2000z
31/05/2001z
01/02/2000)rrrrr¢r r r r!Ú6test_parse_multiple_delimited_dates_with_swap_warningss
ýrlc
KsLd\}}z||f|}Wn*tk
rB}zt|}W5d}~XYnX||fS)N)NN)rÚstr)Úcallrdrørr8Zerr r r!Ú!_helper_hypothesis_delimited_datesroÚ    delimiterz -./rÖz%d %m %Yz%m %d %Yú%m %Yz%Y %m %dz%y %m %drÔz%y%m%dc
Cs|dkr&|dkr&|j tjjdd¡| | d|¡¡}tt||d\}}tt    |t
ddd|dd    \}}    ||kstt||    kstdS)
Nrqr/zRparse_datetime_string cannot reliably tell whether e.g. %m.%Y is a float or a daterârZ)ròrEF)ÚdefaultròZ    yearfirst)ÚnodeZ
add_markerrÚmarkÚxfailÚstrftimeÚreplaceror
rPrr)
rrÖròrpZ test_datetimerdZexcept_out_dateutilr8Zexcept_in_dateutilr9r r r!Útest_hypothesis_delimited_date$s*ÿÿÿ
 
û
rxz)names, usecols, parse_dates, missing_colsrbz
date, timeZdate1Ztime1Ztemperaturec    CsJ|}td}d|d}tjt|d|j|d|||dW5QRXdS)Nz%date,time,val
2020-01-31,04:20:32,32
z+Missing column provided to 'parse_dates': 'ú'rr))rFr_Úusecolsr%)rrrrr)r7r_rzr%Zmissing_colsrIÚcontentrr r r!Ú&test_missing_parse_dates_column_raisesGsÿr|cCsL|}td}|jtd|dgdgd}tdddgiddgd    }t ||¡dS)
Nzx,y
1,2rärÎ)r%r_rKÚ2r½Ú1r0)rr2rìrr4r5r®r r r!Útest_date_parser_and_nameshsûrcCsF|}d}|jt|dgddgd}ttddgd}t ||¡dS)    Nza,b
1,2
2019-12-31,6©rÜr~rrE©r%rHú
2019-12-31r=)r©rÝr}©rrrrr4r5r®r r r!Ú#test_date_parser_multiindex_columnsxs
rzparse_spec, col_namerr)Úa_bZ1_2)rr~cCsF|}d}|jt||ddgd}t|tdddgi}t ||¡dS)Nza,b,c
1,2,3
2019-12,-31,6rrErr)rÞÚ3r=r)r7Z
parse_specZcol_namerIrJr8r9r r r!Ú0test_date_parser_multiindex_columns_combine_colss    ýrcCsTd}|}|jtdt|dgddgdd}tddgtd    gdd
}t ||¡dS)Nz2A,B,C
    1,3,20-09-01-01
    2,4,20-09-01-01
    rärEr>rD)r%rzrGrRr§z20-09-2001 01:00:00rë)r2rìrrrr4r5r×r r r!Ú"test_date_parser_usecols_thousandssúrcCsP|}d}|jt|ddgidd}tdtdg}t||d}t ||¡dS)    NzA
20150908
20150909
rrÍT)r%rMz
2015-09-08z
2015-09-09)rrÍ)rrrrr4r5r\r r r!Ú&test_parse_dates_and_keep_orgin_column®sÿrc    Csúd}tddgdddd}d}tt|dgddd    j}t ||¡tjt|d
tt|dgddd    j}W5QRXt ||¡d}td dgddd}tt|dgddd    j}t ||¡tjt|d
tt|dgddd    j}W5QRXt ||¡dS)Nzdate
31/12/2014
10/03/2011z
2014-12-31z
2011-03-10rQr©rÌrÛr,riT)r%ròr'rFzdate
31/12/2014
03/30/2011z
31/12/2014z
03/30/2011rírê)    rrrr1r4Úassert_index_equalÚassert_produces_warningrìr )Úinputr9rjZres1Zres2Zres5Zres6r r r!Útest_dayfirst_warnings¾sRÿÿÿÿÿÿrzdate_string, dayfirstz    31/1/2014zsecond date is single-digit)Úidz    1/31/2014zfirst date is single-digitc    Csbd|}tdgdddd}d}tjt|dtt|dgd|dj}W5QRXt ||¡dS)    Nzdate
z
2014-01-31rQrrrir)r%r'rò)rr4rrìrrr1r)rdròÚ initial_valuer9rjÚresr r r!Ú&test_dayfirst_warnings_no_leading_zeroîs"
ÿÿürcCsB|}d}|jt|dgd}tdddddgd    }t ||¡dS)
Nza,b,c
1970-01-01,2,3,4rÜr°r}rRr§rñr r0r[r®r r r!Ú test_infer_first_column_as_indexsþrcCstj|ddS)Nú%Y-%m-%dr>r@r¼r r r!r¾"r¿)rÖrNcCsl|}d}|j|dt|fdddgidgd||i}tdtdtjtdtjtd    gi}t ||¡dS)
Nz*Test
2012-10-01
0
2015-05-15
#
2017-09-09
r`ZTestú#r#)rÿr%z
2012-10-01z
2015-05-15z
2017-09-09)r2rrrrr'r4r5rCr r r!Ú&test_replace_nans_before_parsing_datess.
ý
ûúûÿÿrcCsV|}d}|jt|ddgd}tdgtdgd}|d d¡|d<t ||¡dS)    Nza,b
1,2019-12-31
ÚstringrÝ)rÌr%r~r©rÜrÝrÜ)rrrrrr4r5r®r r r!Ú!test_parse_dates_and_string_dtypeFsrcCs|}d}|jdkr*tddgddd}d}ntdd    gd
dd}t}d}|j||t|dd d}tdddgi|d}t ||¡dS)Nz7a,b
27.03.2003 14:55:00.000,1
03.08.2003 15:20:00.000,2rz27.03.2003 14:55:00.000z03.08.2003 15:20:00.000rírÜrêz2003-03-27 14:55:00z2003-08-03 15:20:00rQz1when dayfirst=False \(the default\) was specifiedTrr    rÝrEr>r0)    r¡r rrìr2rrr4r5)r7rIrJZexpected_indexr!rr8r9r r r!Útest_parse_dot_separated_datesSs2
ýýÿrcCs\|}d}|jt|dddddgd}ttdtd    gtdtd    gd}t ||¡dS)
Nú/a,b
2019-12-31,31-12-2019
2020-12-31,31-12-2020rz%d-%m-%YrrÜrÝ©rÖr%rú
2020-12-31rr®r r r!Útest_parse_dates_dict_formatosýþÿrzkey, parse_datesrrc    Cs^|}d}t d¡|jt||di|d}W5QRXt|tdtdgi}t ||¡dS)Nza,b
31-,12-2019
31-,12-2020z    %d- %m-%Yrrr)r4rrrrrr5)r7r<r%rIrJr8r9r r r!Ú(test_parse_dates_dict_format_two_columnssÿÿÿr cCsZ|}d}|jt|ddiddd}tddd    gittd
tdgddd }t ||¡dS)NrrÜrTr)rÖr%r'rÝz
31-12-2019z
31-12-2020rrr+r0)rrrr rr4r5r®r r r!Ú"test_parse_dates_dict_format_indexsÿÿür¡)rÚ__doc__rrrrÚiorZdateutil.parserrrPZ
hypothesisrÚnumpyrrrZpandas._libs.tslibsr    Zpandas._libs.tslibs.parsingr
Zpandasrrrr rrrZpandas._testingZ_testingr4Zpandas._testing._hypothesisrZpandas.core.indexes.datetimesrZpandas.io.parsersrrtZusefixturesZ xfail_pyarrowZskip_pyarrowr:r;rLZparametrizerràrrrr¤r¨r¯r¸r¹rÈrÒrØrÚrárurîrôr÷rrrrrrrrWrr"r$r(r+r,Úfrom_tuplesr1r7r9Úfilterwarningsr;r3rDrGrRrYr]r^rcrfrhrkrlrorxr|rrrrrrÚparamrrrrrrr r¡r r r r!Ú<module>s° 
'
"

x.
<
'
Yú    
ú÷þ
6
 
 
 
2-*þ`
\
 
 
 
 
ÿ
ÿ
ýý
ÿýÿüýîþ 
þûùüüüüüüá&
ÙöðþH
ýúþýúþ
 
&þþûþ þúþüþ        þü÷þ 
 
 
þþ
 
0ýýúþþþ "ÿ