1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
U
­ý°d\™ã@sªddlZddlZddlZddlZddlmZmZmZm    Z    ddl
m Z ej dd„ƒZej dd„ƒZej dd„ƒZej d    d
„ƒZGd d „d ƒZGd d„dƒZGdd„dƒZdS)éN)Ú    DataFrameÚlreshapeÚmeltÚ wide_to_longcCsDt ¡dd…}|ddk tj¡|d<|ddk tj¡|d<|S)Né
ÚArÚid1ÚBÚid2)ÚtmZmakeTimeDataFrameÚastypeÚnpÚint64©Úres©rúUd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/tests/reshape/test_melt.pyÚdfsrcCsBtdddgdddgddd    ggƒ}td
ƒtd ƒg|_d d g|j_|S)Nç5ì÷Ä:ñ?çS°ÆÙtÄñ¿gKÔÔ²µÊ?ç†U¼‘y$õ¿çê>©Mœ×?g†K®âð¿çiÿ¬Õé¿ç<Ú8b->µ?ghB“Ä’òë¿ÚABCÚabcÚCAPÚlow)rÚlistÚcolumnsÚnamesrrrrÚdf1sýÿ r!cCsdS)NÚvarrrrrrÚvar_name&sr#cCsdS)NÚvalrrrrrÚ
value_name+sr%c@sÞeZdZdd„Zdd„Zdd„Zdd„Zej     d    e
e e j f¡d
d „ƒZd d „Zej     ddgdgdeddddœddddœddddœdœƒfdgdgdeddddœddddœddddœdœƒfg¡dd„ƒZej     d d!d"ggd!gd"gd!d"gg¡d#d$„ƒZd%d&„Zd'd(„Zd)d*„Zej     d+dd,g¡d-d.„ƒZd/d0„Zej     d1e ejd2d3d4d5¡ejddd6dd7gd8d9e dddddg¡g¡d:d;„ƒZd<d=„Zd>d?„Zd@dA„ZdBdC„ZdDdE„Z dFdG„Z!dHdI„Z"dJdK„Z#ej     dLdMdNg¡dOdP„ƒZ$dQS)RÚTestMeltcCs"t|ƒ}|j ¡ddgkst‚dS)NÚvariableÚvalue©rrÚtolistÚAssertionError)ÚselfrÚresultrrrÚtest_top_level_method1szTestMelt.test_top_level_methodcCs„t | ¡t|ƒ¡t |jddgddgdt|ddgddgd¡t |j||dt|||d¡t |jddt|dd¡dS)    Nrr
rr    ©Úid_varsÚ
value_vars©r#r%r©Ú    col_level)r Úassert_frame_equalr)r,rr!r#r%rrrÚtest_method_signatures5sþ  þzTestMelt.test_method_signaturescCsr| ¡}|j ¡ddgkst‚|jdgd}|j ¡dddgksDt‚|jddgd}|j ¡ddddgksnt‚dS)Nr'r(r)r0r
r))r,rr-Zresult1Zresult2rrrÚtest_default_col_namesDs zTestMelt.test_default_col_namescCs¢|jddgdd}t|ƒdks"t‚|jddgddgd}t|d ¡d|d ¡ddgddgd|d ¡|d ¡dœddd    d
gd }t ||¡dS) Nrr
rr/rr    é©rr
r'r(r'r(©r)rÚlenr+rr*r r5)r,rZresult3Zresult4Z    expected4rrrÚtest_value_varsNsü
ù    zTestMelt.test_value_varsÚtype_cCs€t|d ¡d|d ¡ddgddgd|d ¡|d ¡dœdddd    gd
}|jddg|d ƒd }t ||¡dS) Nrr8r
rrr    r9r'r(r:©rr    r/)rr*rr r5)r,r=rÚexpectedr-rrrÚtest_value_vars_types^sü
ù    zTestMelt.test_value_vars_typescCs\t|ddgt|ƒdgt|ƒ|ddœddddgd    }|jdgdgd
}t ||¡dS) N©rÚar    Úb©r    rC)rArrr(rrr(r:r/)rr;rr r5)r,r!r?r-rrrÚtest_vars_work_with_multiindexms  ü
ù
z'TestMelt.test_vars_work_with_multiindexz(id_vars, value_vars, col_level, expectedrr    rrrr©rér8rrr)rrr(rBrCrG)rBrr(cCs |j|||d}t ||¡dS)Nr3)rr r5)r,r0r1r4r?r!r-rrrÚ%test_single_vars_work_with_multiindex{s z.TestMelt.test_single_vars_work_with_multiindexzid_vars, value_varsrArDc    Cs0d}tjt|d|j||dW5QRXdS)NzF(id|value)_vars must be a list of tuples when columns are a MultiIndex©Úmatchr/)ÚpytestÚraisesÚ
ValueErrorr)r,r0r1r!ÚmsgrrrÚ$test_tuple_vars_fail_with_multiindexžs z-TestMelt.test_tuple_vars_fail_with_multiindexc     Cs,|j|d}|j ¡ddgks"t‚|jdg|d}|j ¡dddgksJt‚|jddg|d}|j ¡ddddgksvt‚|jddgd|d}|j ¡ddddgks¤t‚|jddgdd    g|d}td|d ¡d
d|d ¡d
|dgd d    gd d|d ¡|d     ¡idd|dgd }t ||¡dS) N)r#r"r(r)r0r#r
r)r0r1r#r    r8rr:©rrr*r+rr r5)    r,rr#Zresult5Zresult6Zresult7Zresult8Zresult9Z    expected9rrrÚtest_custom_var_name®s4 ÿü
ù    zTestMelt.test_custom_var_namec     Cs,|j|d}|j ¡ddgks"t‚|jdg|d}|j ¡dddgksJt‚|jddg|d}|j ¡ddddgksvt‚|jddgd|d}|j ¡ddddgks¤t‚|jddgdd    g|d}td|d ¡d
d|d ¡d
ddgd d    gd ||d ¡|d     ¡iddd|gd }t ||¡dS) N)r%r'r$r©r0r%r
r)r0r1r%r    r8rr:rP)    r,rr%Zresult10Zresult11Zresult12Zresult13Zresult14Z
expected14rrrÚtest_custom_value_nameÉs< ÿÿü
ù    zTestMelt.test_custom_value_namec Csf|j||d}|j ¡ddgks$t‚|jdg||d}|j ¡dddgksNt‚|jddg||d}|j ¡ddddgks|t‚|jddgd||d}|j ¡ddddgks¬t‚|jddgdd    g||d}td|d ¡d
d|d ¡d
|dgd d    gd ||d ¡|d     ¡idd||gd }    t ||    ¡| ¡}
d |
j_|
 ¡} | j ¡d dgksbt‚dS)Nr2r"r$r©r0r#r%r
r)r0r1r#r%r    r8rr:Úfoor()    rrr*r+rr r5ÚcopyÚname) r,rr%r#Zresult15Zresult16Zresult17Zresult18Zresult19Z
expected19Zdf20Zresult20rrrÚtest_custom_var_and_value_nameæsPÿüüü
ù     z'TestMelt.test_custom_var_and_value_namer4rcCs&|j|d}|j ¡ddgks"t‚dS)Nr3rr(r))r,r4r!rrrrÚtest_col_levels zTestMelt.test_col_levelcCs$| ¡}|j ¡dddgks t‚dS)Nrrr(r))r,r!rrrrÚtest_multiindexszTestMelt.test_multiindexÚcolZ2010éz
US/Pacific)ZperiodsÚtzÚcÚdÚcategory©ÚdtypecCs²ttdƒ|dddddg|dœƒ}tjt dddddg¡|gdd}t|ddgd    d
d }tttdƒƒd tj|gd ddd gddgd|dœƒ}ddd    d
g|_t     ||¡dS)Nr\rGr)Úklassr[Úattr1Úattr2T©Z ignore_indexrcr[Ú    attributer(rTr8rdre)rrGr8é)
rÚrangeÚpdÚconcatÚSeriesrrrr r5)r,r[rZexpected_valuer-r?rrrÚtest_pandas_dtypess&
ÿ"ÿüÿzTestMelt.test_pandas_dtypescCs^tddgt ddg¡dœƒ}t|dgdgƒ}tt ddg¡ddgddgdœƒ}t ||¡dS)    NrGr8ÚXÚYr>r    r)r    r'r()rrjZ Categoricalrr r5)r,Údatar-r?rrrÚtest_preserve_category5s ÿzTestMelt.test_preserve_categoryc    CsTttj dd¡tdƒd}d}tjt|jdddd    |     d
d gd d g¡W5QRXtjt|jdddd    |     dd gdd g¡W5QRXtjt|jdddd    |     d
d ddgdd g¡W5QRX| 
¡}tdƒtdƒg|_ tjt|jdddd    |     dgdg¡W5QRXtjt|jdddd    |j    dgdgddW5QRXdS)Nr\éZabcdr:z=The following '{Var}' are not present in the DataFrame: {Col}r1z\['C'\])ZVarZColrIrBrCÚCr_r0z\['A'\]rr^z\['not_here', 'or_there'\]Znot_hereZor_thereÚABCDz\['E'\])ÚErBrDz\['F'\]ÚFrr3) rr ÚrandomÚrandnrrKrLÚKeyErrorÚformatrrVr)r,rrNZmultirrrÚ test_melt_missing_columns_raises?s. ÿ þ" ÿz)TestMelt.test_melt_missing_columns_raisescCsftdgdgdgdgdœƒ}t|ddgdd    gd
}tdgddgdtd ƒddgd œƒ}t ||¡dS) NrUÚbarrGr8)rrBrCr_rrBrCr_r/Zbd)rrBr'r()rrrr r5©r,rr-r?rrrÚtest_melt_mixed_int_str_id_varsds  ÿz(TestMelt.test_melt_mixed_int_str_id_varscCsHtdgdgdœƒ}t|ddgd}tddgddgdœƒ}t ||¡dS)NrUr|)rrBrrB)r1©r'r(©rrr r5r}rrrÚ"test_melt_mixed_int_str_value_varsmsz+TestMelt.test_melt_mixed_int_str_value_varscCsRtdgdgdœdgd}t|dd}tdd    gddgd
œddgd}t ||¡dS) NrrG©rUr|Úfirst©ÚindexFrfrUr|rr€r}rrrÚtest_ignore_indexts ÿzTestMelt.test_ignore_indexcCs”tjjddgddgd}tddgdd    gd
œ|d }t|d d }tjjddgdddgd}tdgddgddddd    gdœ|d }t ||¡dS)N)rƒÚsecond)rƒÚthirdÚbazZfoobar)r rrGr8rhr‚r„FrfrUr|r)rjZ
MultiIndexÚ from_tuplesrrr r5©r,r…rr-Zexpected_indexr?rrrÚtest_ignore_multiindex}sÿ 
ÿ þzTestMelt.test_ignore_multiindexcCs„tjddgddd}tddgdd    gd
œ|d }t|d d }tjddgdddd}tddddgdddd    gdœ|d }t ||¡dS)NrUr|r`r‰)rbrWrrGr8rh)ÚxÚyr„FrfrrŽr)rjÚIndexrrr r5r‹rrrÚtest_ignore_index_name_and_types þz(TestMelt.test_ignore_index_name_and_typecCs^tdddggdddgd}|jdgdgd}tdddgdddggddd    gd}t ||¡dS)
NÚidr8rhrBrCr:r/r'r(r€r}rrrÚ test_melt_with_duplicate_columnssÿz)TestMelt.test_melt_with_duplicate_columnsrbÚInt8ZInt64cCsjttjddgddtjddg|ddœƒ}| ¡}tddd    d    gtjddddg|dd
œƒ}t ||¡dS) NrGr8r“rarhrr©rBrCrBrCr)rrjrlrr r5)r,rbrr-r?rrrÚtest_melt_ea_dtype¦sþÿ
þÿzTestMelt.test_melt_ea_dtypeN)%Ú__name__Ú
__module__Ú __qualname__r.r6r7r<rKÚmarkÚ parametrizeÚtuplerr Úarrayr@rErrHrOrQrSrXrYrZrjrlZ
date_rangermrqr{r~rr†rŒrr’r•rrrrr&0s€
 
 
 
 
ýÿü 
 
 
ýÿüóþ
ýþ
*
ýþ
 
%            r&c@seZdZdd„ZdS)Ú TestLreshapecCsÒdddddgdddd    d
gd d d ddgdddddgdddddgdtjdddgdtjtjddgdddd d!gd"tjd#d$d%gd&tjtjd'd(gd)œ
}t|ƒ}d*d+„td,d-ƒDƒd.d+„td,d-ƒDƒd/œ}t||ƒ}ddddddddddddg dddd    d
ddd    d
dd    d
g d d d ddd d ddd ddg ddddddddddddg ddddddddddddg d0d$d1d2d3d"d#d$d%d&d'd(g d4œ}t||jd5}t ||¡t||d6d7}dddddddddddddddgdddd    d
dddd    d
dddd    d
gd d d ddd d d ddd d d ddgdddddddddddddddgddddddtjddddtjtjddgd0d$d1d2d3d"tjd#d$d%d&tjtjd'd(gd4œ}t||jd5}t ||¡d8d+„td,d9ƒDƒd:d+„td,d-ƒDƒd/œ}d;}tj    t
|d<t||ƒW5QRXdS)=NZ    08jan2009Z    20dec2008Z    30dec2008Z    21dec2008Z    11jan2009iæiå i®iC i%éeéfégéhéiZMaleZFemaleZ    22dec2008Z    04jan2009Z    29dec2008Z    20jan2009Z    21jan2009Z    22jan2009Z    31dec2008Z    03feb2009Z    05feb2009Z    02jan2009Z    15feb2009ii
i iâ iÒglŸ@g@gª@gß±@gê¡@gbª@gŲ@)
ÚbirthdtÚbirthwtr‘ÚsexZvisitdt1Zvisitdt2Zvisitdt3Zwt1Zwt2Zwt3cSsg|]}d|d›‘qS©Úvisitdtr_r©Ú.0ÚirrrÚ
<listcomp>×sz+TestLreshape.test_pairs.<locals>.<listcomp>rGrrcSsg|]}d|d›‘qS©Úwtr_rr¨rrrr«Øs)r§r­g|œ@g4˜@gÄ©@gÒ°@)r£r¤r‘r¥r§r­r:F)ZdropnacSsg|]}d|d›‘qSr¦rr¨rrrr«•srhcSsg|]}d|d›‘qSr¬rr¨rrrr«–sz$All column lists must be same lengthrI) r Únanrrirrr r5rKrLrM)r,rprÚspecr-Úexp_dataÚexprNrrrÚ
test_pairsºs’û   û êþ
ôôôôôÆI ññññññªh þzTestLreshape.test_pairsN)r–r—r˜r²rrrrr¹src@s¶eZdZdd„Zdd„Zdd„Zdd„Zd    d
„Zd d „Zd d„Z    dd„Z
dd„Z dd„Z dd„Z dd„Zdd„Zdd„Zdd„Zdd „Zd!d"„Zd#d$„Zej d%d&d'g¡d(d)„ƒZd*S)+ÚTestWideToLongc
Csôtj d¡tj d¡}tddddœddd    dœd
d d dœd dddœtttdƒ|ƒƒdœƒ}|j|d<|     ¡|     ¡dddddd    gd
d d d ddgddddddgddddddgdœ}t|ƒ}| 
ddg¡dddg}t |ddgddd}t   ||¡dS)Né{rhrBrCr^rFr_ÚeÚfç@ç333333ó?çffffffæ?皙™™™™    @çÍÌÌÌÌÌô?皙™™™™¹?)ZA1970ZA1980ZB1970ZB1980rnr‘é²é¼rrGr8©rnrr    Úyearr‘rÀrnrr    ©rªÚj©r rwÚseedrxrÚdictÚziprir…r*Ú    set_indexrr r5©r,rrr°r?r-rrrÚ test_simpležs*  
 
 
 
ûÿ    
ûzTestWideToLong.test_simplecCs\tdddddgdddd    d
ggƒ}d d d ddg|_ddg}t||d dd|ddgksXt‚dS)NrrGr8rhérrr\ééé    r‘Zinc1Zinc2Zedu1Zedu2ÚincÚeduÚagerÁ)rrrr+)r,rZstubsrrrÚ
test_stubs·s
 zTestWideToLong.test_stubsc
Csötj d¡tj d¡}tddddœddd    dœd
d d dœd dddœtttdƒ|ƒƒdœƒ}|j|d<|     ¡|     ¡dddddd    gd
d d d ddgddddddgddddddgdœ}t|ƒ}| 
ddg¡dddg}t |ddgdddd}t   ||¡dS)Nr´rhrBrCr^rFr_rµr¶r·r¸r¹rºr»r¼)zA.1970zA.1980zB.1970zB.1980rnr‘r½r¾rrGr8r¿rÀrnrr    Ú.©rªrÂÚseprÃrÈrrrÚtest_separating_characterÁs*  
 
 
 
ûÿ    
ûz(TestWideToLong.test_separating_characterc
Csôtj d¡tj d¡}tddddœddd    dœd
d d dœd dddœtttdƒ|ƒƒdœƒ}|j|d<|     ¡|     ¡dddddd    gd
d d d ddgddddddgddddddgdœ}t|ƒ}| 
ddg¡dddg}t |ddgddd}t   ||¡dS)Nr´rhrBrCr^rFr_rµr¶r·r¸r¹rºr»r¼)zA(quarterly)1970zA(quarterly)1980zB(quarterly)1970zB(quarterly)1980rnr‘r½r¾rrGr8)rnú A(quarterly)ú B(quarterly)rÀr‘rÀrnrÖr×rÁrÃrÈrrrÚtest_escapable_charactersÛs.  
 
 
 
ûÿ    
û ÿz(TestWideToLong.test_escapable_characterscCs¬tddgddgddgddgd    œƒ}|j|d
<ddddgddddgddtjtjgd d d d gd d ddgdœ}t|ƒ}| d
dg¡dddg}t|ddgd
dd}t ||¡dS)Nçð?ç@ç@ç@ç@ç@ÚX1ÚX2©ÚA2010ÚA2011ÚB2010rnr‘rrGiÚiÛ)rnrr    r‘rÀrÀrnrr    rÁ)rr…r r®rÇrr r5©r,rr°r?r-rrrÚtest_unbalancedös$üÿ
 
 
 
 
ûzTestWideToLong.test_unbalancedc Cstdddgdddgdddgd    d
d gd d dgdddgdddgdddgdœƒ}|j|d<tddddddgddddddgddddddgdddd    d
d gd d ddddgdd d dd d gddddddgdœƒ}| ddg¡ddddd g}t|ddd gddd!}t |jd d"|jd d"¡dS)#NÚa11Úa22Úa33Úa21Úa23Úb11Úb12Úb13Úb21Úb22Úb23rGr8rhrrr\rËé[é\é])ÚA11ÚA12ÚB11ÚB12ÚBB11ÚBB12ÚBBBXÚBBBZr‘ré é )rûrürr    ÚBBr‘rÀrÀrûrürr    rÿrÁ©Zaxis©rr…rÇrr r5Ú
sort_index©r,rr?r-rrrÚtest_character_overlap s2øÿ
ùÿ z%TestWideToLong.test_character_overlapc    CsÄd}tddgddgddgdd    gd
œƒ}|j|d <d gggggggd œ}t|ƒ dtji¡}| d dg¡ddddddg}|jjddgdd|_t|ddgd d|d}t     |j
dd|j
dd¡dS)Nznope!rÙrÚrÛrÜrÝrÞrßràrár‘Ú)rnrârãrär‘rÀrr    rÀrnrârãrärr    rrG©ÚlevelrÓr© rr…r r rrÇÚ
set_levelsrr r5r)r,rÔrr°r?r-rrrÚtest_invalid_separator+s2üÿ
ø
 ÿz%TestWideToLong.test_invalid_separatorc Cstdddgdddgdddgd    d
d gd d dgdddgdddgdddgdœƒ}|j|d<tddddddgddddddgddddddgdddd    d
d gd d ddddgdd d dd d gddddddgdœƒ}| ddg¡ddddd g}t|ddd gddd!}t |jd d"|jd d"¡dS)#NrçrèrérêrërìrírîrïrðrñrGr8rhrrr\rËròrórô)rõrör÷rørùrúÚAratingÚ Arating_oldr‘rrýrþ)r r rr    rÿr‘rÀrÀr r rr    rÿrÁrrrrrrÚtest_num_string_disambiguationIs6øÿ
ùÿ  ÿz-TestWideToLong.test_num_string_disambiguationc    Cs®tddgddgddgddgd    œƒ}|j|d
<d gggggggd œ}t|ƒ d tji¡}| d
d g¡}|jjddgdd|_t|ddgd
d d}t     |j
dd|j
dd¡dS)NrÙrÚrÛrÜrÝrÞrßrà)ÚAoneÚAtwoÚBonernr‘r)rnrrrr‘rÀrr    rÀrrGrrr    rÁrrrårrrÚtest_invalid_suffixtypejs,üÿ
ø
z&TestWideToLong.test_invalid_suffixtypecCs6tdddddddddg    dddddddddg    dddddddd    d
g    d d dd dddd dg    dœƒ}tdd dd dddd ddddddd    d d
dgddddddddddddddddddgddddddddddddddddddgddddddddddddddddddgdœƒ}| dddg¡dg}t|dddgdd}t ||¡dS)NrGr8rhgffffff@g333333@gš™™™™™@gÍÌÌÌÌÌü?gffffffþ?gffffff@çÍÌÌÌÌÌ@g333333 @gffffff@rºg333333@gffffff
@)ÚfamidÚbirthZht1Zht2rÚ)ÚhtrrrÐrrrÐrrÁ©rrÇrr r5rrrrÚtest_multiple_id_columns‡sFüÿî&&&éÿz'TestWideToLong.test_multiple_id_columnsc    Csdtdddddgdddddgdddddgdœƒ}d}tjt|dt|d    d
gd d d W5QRXdS)NrGr8rhrrr\)ZA_A1ZB_B1rz3the id variables need to uniquely identify each rowrIZA_AZB_BrÚcolnamerÁ©rrKrLrMr©r,rrNrrrÚtest_non_unique_idvars°s (ÿz%TestWideToLong.test_non_unique_idvarsc
Cs¤tdddgdddgddd    gd
d d gd ddgdœƒ}tddddddgddd    d
d d gddddddgd ddd ddgdœƒ ddg¡}t|ddgdddd}t ||¡dS)Nz CCH Pounderz Johnny DeppzChristoph WaltzzJoel David Moorez Orlando Bloomz Rory Kinnearg@@gˆã@g|Å@g@@gˆ³@gx@ZAvatarzPirates of the CaribbeanZSpectre)Zactor_1Zactor_2Zactor_fb_likes_1Zactor_fb_likes_2ÚtitlerGr8)ÚactorÚactor_fb_likesÚnumrrrrrÚ_rÓrrrrrÚtest_cast_j_intºsJûÿ
úúõÿëÿzTestWideToLong.test_cast_j_intc    CsXtddgddgddgddgd    œƒ}d
}tjt|d t|d d gd ddW5QRXdS)NrÙrÚrÛrÜrÝrÞrßrà)rârãrärz,stubname can't be identical to a column namerIrr    rrÁrrrrrÚtest_identical_stubnamesásüÿz'TestWideToLong.test_identical_stubnamescCsŽtddgddgddgddgd    œƒ}tddddgd
d
d d gddtjtjgddddgd œƒ}| d dg¡}t|ddgd dddd}t ||¡dS)NrÙrÚrÛrÜrÝrÞrßrà)Ztreatment_placeboZtreatment_testZresult_placeborZplaceboÚtest©rrr-Ú    treatmentrrr-r%z[a-z]+r ©rªrÂÚsuffixrÔ©rr r®rÇrr r5rrrrÚtest_nonnumeric_suffixîs0üÿ
 
 
üÿÿz%TestWideToLong.test_nonnumeric_suffixcCsŒtddgddgddgddgd    d
gd œƒ}tddddgd d d d gddddgddd    d
gdœƒ ddg¡}t|ddgddddd}t ||¡dS)NrßràrrÍrÝrÞrÙrÚrÛrÜ)rÚresult_1Z
result_fooZ treatment_1Z treatment_fooÚ1rUçç"@r$rrr-r%z.+r r&rrrrrÚtest_mixed_type_suffixs4ûÿ    
 
 
 
üÿùÿz%TestWideToLong.test_mixed_type_suffixc CsÀtddgddgddgddgd    d
gd œƒ}td    d
d    d
d    d
d    d
gd d ddd d ddgddddtjtjtjtjgtjtjtjtjddddgdœƒ}| ddg¡}t|ddgddddd}t ||¡dS)NrÙrÚrÛrÜrÝrÞrrÍrßrà)z treatment_1.1z treatment_2.1z
result_1.2r*rr¸gš™™™™™ñ?rr,r-r$rrr-r%z[0-9.]+r r&r(rrrrÚtest_float_suffixs2ûÿ    üÿÿz TestWideToLong.test_float_suffixc
Csddddddœddd    d
d dœd d d dddœddddddœddddddœdœ}t |¡}t|dgddgdd}t|dddgdd}t ||¡dS)NrrGr8rhrr)rrGr8rhrrgš™™™™™é?r,gÐ?rÙgìQ¸…ëé?g®Gáz®ç?gìQ¸…ëá?g\Âõ(\ï?g333333ã?g¤p=
×£è?g{®Gázä?g¤p=
×£à?gq=
×£på?gÃõ(\ÂÕ?r¹)Únode_idrZPA0ZPA1ZPA3ZPAr0rÚtime)Ú    stubnamesrªrÂ)rÚ    from_dictrr r5)r,Z    wide_dataZwide_dfr?r-rrrÚtest_col_substring_of_stubname4sû
z-TestWideToLong.test_col_substring_of_stubnamec    CsLttdƒtdddƒdœƒ}tjtt d¡d|jddd    W5QRXdS)
Nrrér8)r[r(zvalue_name (value) cannot matchrIr(rR)    rrrirKrLrMÚreÚescaper)r,rrrrÚtest_raise_of_column_name_valueDs ÿz.TestWideToLong.test_raise_of_column_name_valuerbÚOÚstringcCs¬tddgddgddgdœƒ}| d|i¡}t|d    d
gdd d d }tjddddgdd}tddddgtjgddœ|d}|jjd |¡}|jj    |dd|_t
  ||¡dS)Nr+Ú2édéÈi,i)r‘za-1za-2r‘rBrCrú-)r2rªrÂrÔ)r+rG)r;rG)r+r8)r;r8)r‘r)rWrrr”r„rr) rr rrjrr r®r…Úlevelsr    r r5)r,rbrr-r…r?Z    new_levelrrrÚtest_missing_stubnameOs(û
þþz$TestWideToLong.test_missing_stubnameN)r–r—r˜rÉrÑrÕrØrærr
r rrrr!r"r)r.r/r4r8rKr™ršr@rrrrr³s(
!)
'  r³)r6Únumpyr rKZpandasrjrrrrZpandas._testingZ_testingr Zfixturerr!r#r%r&rr³rrrrÚ<module>s( 
 
 
 
 e