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
191
Ë
oñúh`xãó(—ddlZddlZddlZddlmZmZmZmZddl    m
Z ddl m Z ejd„«Zejd„«Zejd„«Zejd„«Zejd„«ZGd    „d
«ZGd „d «Zy) éN)Ú    DataFrameÚIndexÚSeriesÚjson_normalize©Únested_to_recordcón—dddddœdddœgdœd    d
d dœd d dœgdœgdœdddddœgdœddddœdddœgdœgdœgS)NÚUSAÚ
Californiaú San Franciscoé90)ÚnameÚpopú Los Angelesé:0)rÚcitiesÚOhioÚColumbuséÒÚ    ClevelandéÔ)ÚcountryÚstatesÚGermanyÚBayernÚMuniché;0úNordrhein-WestfalenÚ DuesseldorféÖÚKoelnéשr#óúVH:\Change_password\venv_build\Lib\site-packages\pandas/tests/io/json/test_normalize.pyÚ deep_nestedr&s•€ð
ð)à!0¸Ñ?Ø!.°uÑ=ðñð#à!+°DÑ9Ø!,°TÑ:ðñðñ    
ð(!à!°xÈÑ.NÐ-OÑPà1à!.°tÑ<Ø!(°Ñ6ðñð    ñ     
ð)! ð!r$cóN—dddœdddœdddœgdd    id
d d œd ddœdddœgddiddd œgS)NÚDader ©rÚ
populationÚBrowardé@œú
Palm Beaché`êÚgovernorú
Rick ScottÚFLÚFlorida)ÚcountiesÚinfoÚ    shortnameÚstateÚSummitrÚCuyahogaé9ú John KasichÚOHrr#r#r$r%Ú
state_datar<8sl€ð
 ¨uÑ5Ø"°%Ñ8Ø%°UÑ;ðð
  Ð.ØØñ        
ð"°Ñ6Ø#°4Ñ8ðð  Ð/ØØñ    
ð ðr$có —ddidddœdddœdœgS)    Nr4ú
11/08/1993ú
26/05/2012©Ú
created_atÚ last_updatedÚJaneÚDoe©ÚfirstÚ    last_name©r4Ú author_namer#r#r$r%Úauthor_missing_datarJQs*€ð
ˆà#/ÀÑNØ%+¸%Ñ@ñ    
ð ðr$cóH—dddddddœgdd    d
igid œd d ddddœgdd    digidœgS)NÚAliceéZ%ú
Morris St.Ú    Massillonr;éf®)ÚnumberÚstreetÚcityr6ÚziprÚ    city_nameú Foo York City)rÚ    addressesÚprevious_residencesé!ú
Spring St.Ú ElizabethtonÚTNé “Ú
Barmingham)rWrXr#r#r$r%Úmissing_metadatar_\su€ðð#Ø*Ø'Ø!Ø ñ ðð%-° ¸_Ð/MÐ.NÐ#Oñ     
ð #Ø*Ø*Ø!Ø ñ ðð%-° ¸\Ð/JÐ.KÐ#Lñ     
ð ðr$có$—ddiddddœdœdd    id
œgS) z@
    input data to test json_normalize with max_level param
    ÚNameÚUser001ú    Some textÚID001ÚName001©ÚIdra©Ú    TextFieldÚ    UserFieldÚaÚb©Ú    CreatedByÚLookupÚImager#r#r$r%Úmax_level_test_input_datarq{s4€ð! )Ð,à(Ø$+°YÑ?ñð˜3Zñ     
ð     ð    r$c ó—eZdZd„Zd„Zd„Zd„Zejjdddiddigd    d    fdddiddigidd    fd
d    e
fd    d    e
fg«d „«Z d „Z d „Z d„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zejjddddddœddiddid œddddœddiddid œgfddddddiddid!œdddddiddid!œgfg«d"„«Zd#„Zd$„Zejjd%gd&¢«d'„«Zd(„Zd)„Zd*„Zy    )+ÚTestJSONNormalizecóˆ—ddddœddddœdd    d
dœd d d dœg}t|«}t|«}tj||«y)Nééé)rkrlÚcéééééé    é
é é ©rrÚtmÚassert_frame_equal©ÚselfÚrecsÚresultÚexpecteds    r%Útest_simple_recordsz%TestJSONNormalize.test_simple_recordssV€à˜! !Ñ $ؘ! !Ñ $ؘ! !Ñ $ؘ2 BÑ 'ð    
ˆô  Ó%ˆÜ˜T“?ˆä
×јf hÕ/r$có¢—t|dd«}t|dd«}tj||«t|d«}g}|D]}|j    |d«Œt|«}tj||«t|dd¬«}t j ddg«jddg«|d<tj||«y)    Nrr3r6©Úmetar2rrwrv)rrrƒr„ÚextendÚnpÚarrayÚrepeat©r†r<rˆr‰Úrecs     r%Útest_simple_normalizez'TestJSONNormalize.test_simple_normalizešsĀÜ 
¨1¡ ¨zÓ:ˆÜ˜Z¨™]¨:Ñ6Ó7ˆÜ
×јf hÔ/ä 
¨JÓ7ˆàˆØò    -ˆCØ O‰O˜C 
™OÕ ,ð    -ä˜XÓ&ˆä
×јf hÔ/ä 
¨J¸WÔEˆÜŸH™H i°Ð%8Ó9×@Ñ@À!ÀQÀÓHˆÑä
×јf hÕ/r$cóž—gd¢dddgidœg}t|dgddgg¬«}tgd¢ddgddgddggd    œ«}tj||«y)
N©rurvrwÚlistdatarurv)ÚvaluesÚmetadatar˜r™©Ú record_pathr)rzmetadata.listdatar‚)r†Úparse_metadata_fields_list_typerˆr‰s    r%Útest_fields_list_type_normalizez1TestJSONNormalize.test_fields_list_type_normalize­ss€â ¨z¸A¸q¸6Ð.BÑ Cð+
Ð'ô Ø +Ø!˜
ؘzÐ*Ð+ô
ˆô
Ú°!°Q°¸!¸Q¸À!ÀQÀÐ0HÑ Ió
ˆô     ×јf hÕ/r$cóZ—tg«}t«}tj||«y)Nr‚©r†rˆr‰s   r%Útest_empty_arrayz"TestJSONNormalize.test_empty_array»s#€Ü Ó#ˆÜ“;ˆÜ
×јf hÕ/r$z!data, record_path, exception_typerkrruNz{"a": [{"a": 0}, {"a": 1}]}cóâ—|.tj|d¬«5t||¬«ddd«yt||¬«}tddgdg¬«}t    j
||«y#1swYyxYw)NÚ©Úmatch©r›rrurk©Úcolumns)ÚpytestÚraisesrrrƒr„)r†Údatar›Úexception_typerˆr‰s      r%Útest_accepted_inputz%TestJSONNormalize.test_accepted_inputÀsl€ð Ð %Ü—‘˜~°RÔ8ñ >ܘt°Õ=÷ >ð >ô$ D°kÔBˆFÜ  ! Q °#°Ô7ˆHÜ × !Ñ ! &¨(Õ 3÷  >ð >ús šA%Á%A.cól—tddddœi«}tddggddg¬«}tj|j    |«|«tddddœid¬    «}tddggd
d g¬«}tj|j    |«|«tddddœid ¬    «}tddggd dg¬«}tj|j    |«|«t|ddgdddggd¬«}t gd¢«j «}|jj «j|«sJ‚y)NÚArurv)r®ÚBzA.AzA.Br¦Ú_©ÚsepÚA_AÚA_BuσuAσAuAσBrrrr)rr²)rrrÚ states_name)    rrrƒr„Ú reindex_likerÚ sort_valuesr§Úequals)r†r&rˆr‰s    r%Ú$test_simple_normalize_with_separatorz6TestJSONNormalize.test_simple_normalize_with_separatorÒs2€ä ¨A°AÑ&6Р7Ó8ˆÜ˜q !˜f˜X°°u¨~Ô>ˆÜ
×јf×1Ñ1°(Ó;¸XÔFä ¨A°AÑ&6Р7¸SÔAˆÜ˜q !˜f˜X°°u¨~Ô>ˆÜ
×јf×1Ñ1°(Ó;¸XÔFä ¨A°AÑ&6Р7¸XÔFˆÜ˜q !˜f˜X°
¸JÐ/GÔHˆÜ
×јf×1Ñ1°(Ó;¸XÔFäØ Ø xÐ  Ø˜h¨Ð/Ð0Øô    
ˆô ÒBÓC×OÑOÓQˆØ~‰~×)Ñ)Ó+×2Ñ2°8Ô<Ð<Ñ<r$cóˆ—ddgdddœdœ}t|d¬«}tddgddgggd¢¬    «}tj||«y)
Nrurv)rwry)Úb_1Úb_2)rkrlÚ__r±)rkÚb__b_1Úb__b_2r¦r‚©r†rªrˆr‰s    r%Ú'test_normalize_with_multichar_separatorz9TestJSONNormalize.test_normalize_with_multichar_separatorésL€à˜V¨!°FÑ";Ñ<ˆÜ ¨$Ô/ˆÜ  1˜v q¨&Ð1Ð2Ò<UÔVˆÜ
×јf hÕ/r$cóx—tdddgidd¬«}tdgdggdg¬«}tj||«y)Nr®rurvzPrefix.)Ú record_prefixzPrefix.0r¦r‚rŸs   r%Útest_value_array_record_prefixz0TestJSONNormalize.test_value_array_record_prefixðs>€ä  q¨! f  ¨sÀ)ÔLˆÜ˜q˜c A 3˜Z°*°Ô>ˆÜ
×јf hÕ/r$có¦—dddddœdddœdd    dœgd
œd œ}t|d d g¬«}tddgddgdd    ggddg¬«}tj||«y)Nr2r0r(r r)r+r,r-r.)r/r3©r6r4r4r3r¥rr*r¦r‚rÀs    r%Útest_nested_object_record_pathz0TestJSONNormalize.test_nested_object_record_pathös‚€ðà(à#°5Ñ9Ø&°eÑ<Ø)¸Ñ?ðññ
 
ˆô  °6¸:Ð2FÔGˆÜؐeˆ_˜y¨%Ð0°<ÀÐ2GÐ Hؘ\Ð*ô
ˆô     ×јf hÕ/r$có¶—t|ddgdddgg¬«}dgdzdgd    zzgd
¢gd ¢gd ¢d œ}t||j¬«}tj||«y)NrrrrrŒr
ryrrw)r r rrrrr)r rrrrrr!)r rrrrr r")rz states.namerrr¦©rrr§rƒr„)r†r&rˆÚex_datar‰s     r%Útest_more_deeply_nestedz)TestJSONNormalize.test_more_deeply_nested
sq€ÜØ ˜( HÐ-°YÀÈ6Ð@RÐ4Sô
ˆðw ‘{ i [°1¡_Ñ4òòòAñ)
ˆô.˜W¨f¯n©nÔ=ˆÜ
×јf hÕ/r$có—ddddidddœdd    dœd
d dœgd œd dddidddœdddœgd œg}t|dddddgg«}gd¢dgdzd gdzzgd¢dgdzdgdzzgd¢dœ}t||j¬«}tj||«y)Nr2r1r/r0r(r r)r+r,r-r.)r6r5r4r3rr;r:r7rr8r9r3r6r5r4©r(r+r-r7r8rwrv)r1r1r1r;r;©r r,r.rr9)rr6r5ú info.governorr*r¦rÉ)r†rªrˆrÊr‰s     r%Útest_shallow_nestedz%TestJSONNormalize.test_shallow_nested(sã€ð#Ø!Ø# \Ð2à#°5Ñ9Ø&°eÑ<Ø)¸Ñ?ðñ         ð Ø!Ø# ]Ð3à%°TÑ:Ø'°tÑ<ðñ     ð
ˆô, Ø *˜w¨ °f¸jÐ5IÐJó
ˆòLؐ[ 1‘_¨ x°!¡|Ñ3Ú7Ø*˜^¨aÑ/°=°/ÀAÑ2EÑEÚ;ñ 
ˆô˜W¨f¯n©nÔ=ˆÜ
×јf hÕ/r$cóʗt|dgddddggd¬«}gd¢gd    ¢d
gd zd gd zzdgd zdgd zzdgd zdgd zzdœ}t|«}tj||«y)Nr3r6r5r4r/Úignore©rªr›rÚerrorsrÍrÎr2rwrrvr1r;r0r:)rr*r6r5rÏr‚)r†r<rˆrÊr‰s     r%Ú-test_nested_meta_path_with_nested_record_pathz?TestJSONNormalize.test_nested_meta_path_with_nested_record_pathLs€äØØ#˜ ؘ;¨°Ð(<Ð=Øô    
ˆòLÚ;ؐ[ 1‘_¨ x°!¡|Ñ3ؘ !™ t f¨q¡jÑ0Ø*˜^¨aÑ/°=°/ÀAÑ2EÑEñ 
ˆô˜WÓ%ˆÜ
×јf hÕ/r$cóâ—dddddœdddœgdœg}d    }tjt|¬
«5t|d d d g¬«ddd«t|d d d gd¬«}dD]}||vrŒJ‚y#1swYŒ(xYw)NÚhelloÚthereÚ    somethingÚelse©ÚfooÚbarÚ
something2Úelse2©rÜrÝrªz?Conflicting metadata name (foo|bar), need distinguishing prefixr£rªrÜrÝrŒr©rÚ meta_prefix©ÚmetafooÚmetabarrÜrÝ)r¨r©Ú
ValueErrorr)r†rªÚmsgrˆÚvals     r%Útest_meta_name_conflictz)TestJSONNormalize.test_meta_name_conflict`s—€ðØà'°Ñ7Ø(°Ñ9ðñ ð    
ˆðQˆÜ ]‰]œ:¨SÔ 1ñ    >Ü ˜4 ¨u°e¨nÕ =÷    >ô   f°E¸5°>ÈvÔVˆà7ò    !ˆCؘ&’=Ð  =ñ    !÷     >ð    >ús ­A%Á%A.cót—dddddœdddœgdœg}d    d
g}t|d |d ¬ «}|d    d
gk(sJ‚dD]}||vrŒJ‚y)Nr×rØrÙrÚrÛrÞrßràrÜrÝrªrrárã)r)r†rªÚCOLUMNSrˆrès     r%Ú test_meta_parameter_not_modifiedz2TestJSONNormalize.test_meta_parameter_not_modifieduss€ðØà'°Ñ7Ø(°Ñ9ðñ ð    
ˆð˜%.ˆÜ  f°7ÈÔOˆà˜5 %˜.Ò(Ð(Ð(Ø7ò    !ˆCؘ&’=Ð  =ñ    !r$có†—t|dd«}t|dd«}tj||«t|ddd¬«}g}|D]}|j    |d«Œt|«}|j d„¬«}t jdd    g«jd
d g«|d<tj||«y) Nrr3r6Úcounty_)rrÃcó —d|zS)Nrîr#)Úxs r%ú<lambda>z6TestJSONNormalize.test_record_prefix.<locals>.<lambda>–s
€°YÀ±]€r$r¦r2rrwrv)    rrrƒr„rŽÚrenamerrr‘r’s     r%Útest_record_prefixz$TestJSONNormalize.test_record_prefix‰sÀ€Ü 
¨1¡ ¨zÓ:ˆÜ˜Z¨™]¨:Ñ6Ó7ˆÜ
×јf hÔ/äØ ˜
¨À    ô
ˆðˆØò    -ˆCØ O‰O˜C 
™OÕ ,ð    -ä˜XÓ&ˆØ—?‘?Ñ+B?ÓCˆÜŸH™H i°Ð%8Ó9×@Ñ@À!ÀQÀÓHˆÑä
×јf hÕ/r$cóޗdjd«}djd«ddgdddgdd    d
gi}t|«}ttj|««}t j ||«y) NsK[{"Ünicøde":0,"sub":{"A":1, "B":2}},{"Ünicøde":1,"sub":{"A":3, "B":4}}]Úutf8s    Ãœnicøderruzsub.Arwzsub.Brvry)ÚdecoderrÚjsonÚloadsrƒr„)r†ÚtestjsonÚtestdatar‰rˆs     r%Útest_non_ascii_keyz$TestJSONNormalize.test_non_ascii_key›st€ð Aç
‰&‹.ð    ð %× +Ñ +¨FÓ 3°a¸°VØ a˜VØ a˜Vð
ˆô
˜XÓ&ˆä¤§
¡
¨8Ó 4Ó5ˆÜ
×јf hÕ/r$có—t|«}tjtjtjtjtjdœddddddœg}t|«}t    j
||«y)N)r4úinfo.created_atúinfo.last_updatedúauthor_name.firstúauthor_name.last_namer>r?rCrD©rrÚnanrrƒr„)r†rJrˆrÊr‰s     r%Útest_missing_fieldz$TestJSONNormalize.test_missing_field«sp€äР3Ó4ˆôŸ™Ü#%§6¡6Ü%'§V¡VÜ%'§V¡VÜ)+¯©ñ  ðØ#/Ø%1Ø%+Ø).ñ  ð
ˆô ˜WÓ%ˆÜ
×јf hÕ/r$zmax_level,expectedrcrdrerfrarbrl)rirjrnrp)riz UserField.IdzUserField.Namernrpcóޗddiddddœdœddddœdœgdd    id
d d œd dd œgdœg}t|dgdgdgg|¬«}t||jj¬«}t    j
||«y)NrarbrcrdrerfrhrkrlrÙrÚrÛrÞrß)rnrorpÚtagsrornrp)r›rÚ    max_level)rªr§)rrr§r˜rƒÚ assert_equal)r†rr‰Ú
test_inputrˆÚ expected_dfs      r%Ú test_max_level_with_records_pathz2TestJSONNormalize.test_max_level_with_records_pathÁs©€ðZ% iÐ0ð&1Ø,3¸YÑ%Gñð
&1Ø,3¸YÑ%Gñð     ð˜s˜à'°Ñ7Ø(°Ñ9ðñ ð
ˆ
ô* Ø Ø!˜
ؐ- ' Ð+Øô    
ˆô   X°v·~±~×7LÑ7LÔMˆ Ü
‰˜  VÕ,r$cóv—tdddiig«}tddddiigid«}tj||«y)Nr®r¯ruÚdummy)rrƒr„)r†Údf1Údf2s   r%Ú!test_nested_flattening_consistentz3TestJSONNormalize.test_nested_flattening_consistent
sE€ä˜s S¨! H˜oÐ.Ó/ˆÜ˜g¨¨s°A¨h¨Ð'8Ð9¸7ÓCˆô     ×јc 3Õ'r$có‚—td|dœdddigdœgdg¬«}tddidg¬    «}tj||«y)
NÚTexasrÆr2Úirvr4r¥r)Úindex)rrrƒr)r†Ú nulls_fixturerˆr‰s    r%Útest_nonetype_record_pathz+TestJSONNormalize.test_nonetype_record_pathsR€ô à!¨=Ñ9Ø#¨s°A¨h¨ZÑ8ð ð ˜ô 
ˆô˜c 1˜X¨a¨SÔ1ˆÜ
‰˜ Õ)r$Úvalue)ÚfalseÚtruez{}Ú1z"text"cóЗtj|«}d|dœ}d}|›d|›d|›d}tjt|¬«5t |g|g¬«ddd«y#1swYyxYw)    NrrÆr4z has non list value z
 for path z. Must be list or null.r£r¥)r÷rør¨r©Ú    TypeErrorr)r†rÚ parsed_valuerÚ    test_pathrçs      r%Ú test_non_list_record_path_errorsz2TestJSONNormalize.test_non_list_record_path_errorssz€ô—z‘z %Ó(ˆ Ø&° Ñ=ˆ
؈    àˆlÐ.¨|¨n¸JÀyÀkðR$ð $ð     ô]‰]œ9¨CÔ 0ñ    BÜ ˜J˜<°i°[Õ A÷    B÷    Bñ    Bús ÁAÁA%cóЗd}ttj|«dgdg¬«}tdgdgt    j
dgt ¬«d    œ«}tj||«y)
Nz,[{"id": 99, "data": [{"one": 1, "two": 2}]}]rªÚidršrurvéc)Údtype)ÚoneÚtwor )    rr÷rørrrÚobjectrƒr„rÀs    r%Útest_meta_non_iterablez(TestJSONNormalize.test_meta_non_iterable,sY€àAˆä¤§
¡
¨4Ó 0¸v¸hÈdÈVÔTˆÜؐC  ¬2¯8©8°R°DÄÔ+GÑ Hó
ˆô     ×јf hÕ/r$có~‡—ˆfd„}t|««}t‰dd«}tj||«y)Nc3ó2•K—‰ddEd{–—†y7Œ­w)Nrr3r#)r<s€r%Úgenerator_dataz8TestJSONNormalize.test_generator.<locals>.generator_data9søèø€Ø! !‘} ZÑ0× 0Ò 0ús ƒ rr3r‚)r†r<r)rˆr‰s `   r%Útest_generatorz TestJSONNormalize.test_generator6s:ø€ô    1ô ¡Ó 0Ó1ˆÜ˜Z¨™]¨:Ñ6Ó7ˆä
×јf hÕ/r$có‚—dddidœddœ}t|d¬«}tgd    ¢ggd
¢¬ «}tj||«y) NrÚl3r)Úa1Úl2ry)Ú_idÚggr°r±)ryrr)r0Ú_id_a1Ú    _id_l2_l3r¦r‚rÀs    r%Ú'test_top_column_with_leading_underscorez9TestJSONNormalize.test_top_column_with_leading_underscoreAs@€à ¨¨q¨    Ñ2¸!Ñ<ˆÜ ¨#Ô.ˆÜšj˜\Ò3PÔQˆä
×јf hÕ/r$)Ú__name__Ú
__module__Ú __qualname__rŠr”rr r¨ÚmarkÚ parametrizeÚNotImplementedErrorr¬r¹rÁrÄrÇrËrÐrÕrérìrórûrr
rrrr&r*r3r#r$r%rsrsŒsÖ„ò 0ò0ò& 0ò0ð
 ‡[[×ÑØ+àAˆh˜˜a˜Ð ! 4¨Ð .ؐS˜!H˜s A˜hÐ'Ð (¨#¨tÐ 4Ø *¨DÐ2EÐ FØ 4Ð,Ð -ð        
óñ4óð4ò=ò.0ò0ò 0ò(0ò<"0òH0ò(!ò*!ò(0ò$0ò 0ð, ‡[[×ÑØðð&1Ø,3¸YÑ%GØ&,¨iÐ%8Ø"% s ñ    ð&1Ø,3¸YÑ%GØ&,¨iÐ%8Ø"% s ñ    ð ð ð$ð&1Ø(/Ø*3Ø&,¨iÐ%8Ø"% s ñ ð&1Ø(/Ø*3Ø&,¨iÐ%8Ø"% s ñ ðð ð%%    
ó(ñR-óS(ðR-ò@(ò *ð ‡[[×јWÒ&LÓMñ
BóNð
Bò0ò    0ó0r$rsc óî—eZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z    d„Z
d    „Z d
„Z d „Z ejj!d d ddddddœgfdddiddddœdœddidœgfddddddœddœgfg«d„«Zd„Zd„Zy )ÚTestNestedToRecordcó@—dddœdddœg}t|«}|}||k(sJ‚y)Nrurv)Úflat1Úflat2rwry)Úflat3r>rr…s    r%Útest_flat_stays_flatz'TestNestedToRecord.test_flat_stays_flatKs3€Ø aÑ(°AÀÑ*BÐCˆÜ! $Ó'ˆØˆØ˜Ò!Ð!Ñ!r$cóD—ddddœdœ}t|«}ddddœ}||k(sJ‚y)Nrurv©rxÚd)r=Údict1)údict1.cúdict1.dr=rrÀs    r%Útest_one_level_deep_flattensz/TestNestedToRecord.test_one_level_deep_flattensQs5€Ø¨1°1Ñ%5Ñ6ˆä! $Ó'ˆØ ¨Q¸Ñ;ˆà˜Ò!Ð!Ñ!r$cóX—ddddœdddœddœdœ}t|«}dddddddœ}||k(sJ‚y)NrurvrB)ÚerC)r=rDÚnested)rErFr=znested.dz
nested.e.cz
nested.e.drrÀs    r%Útest_nested_flattensz'TestNestedToRecord.test_nested_flattensYsV€àØ 1Ñ%Ø"#¨!Ñ,°1Ñ5ñ
ˆô " $Ó'ˆàØØØØØñ 
ˆð˜Ò!Ð!Ñ!r$có†—d}tjt|¬«5t|ddd¬«ddd«y#1swYyxYw)Nú^Key 'name' not found. To replace missing values of 'name' with np.nan, pass in errors='ignore'r£rWrÚraiserÓ©r¨r©ÚKeyErrorr©r†r_rçs   r%Útest_json_normalize_errorsz-TestNestedToRecord.test_json_normalize_errorslsE€ð  :ð     ô]‰]œ8¨3Ô /ñ    Ü Ø%Ø'ØØõ     ÷    ÷    ñ    ús    ž7·Acó¤—t|ddd¬«}gd¢dddd    d
tjgg}gd ¢}t||¬ «}t    j
||«y) NrWrrÒrÓ)rMrNrOr;rPrLrYrZr[r\r])rQrRrSr6rTrr¦r©r†r_rˆrÊr§r‰s      r%Útest_missing_metaz$TestNestedToRecord.test_missing_meta}s]€ô Ø!¨{ÀÐPXô
ˆò DØ < °°u¼b¿f¹fÐ Eð
ˆòGˆÜ˜W¨gÔ6ˆÜ
×јf hÕ/r$cóŒ—ddddiddigdœ}t|dddd    ggd
¬ «}ddtjgddtjgg}gd ¢}t||¬ «j    dt
i«}t j||«tjtd¬«5t|dddd    ggd¬ «ddd«y#1swYyxYw)NrÜr“rurv)rÚ nested_metarrrrWÚleafrÒ)r›rrÔ)r“rúnested_meta.leafr¦rYz'leaf' not foundr£rN) rrrrÚastyper%rƒr„r¨r©rP)r†rªrˆrÊr§r‰s      r%Útest_missing_nested_metaz+TestNestedToRecord.test_missing_nested_metaŒsڀð¨d¸uÀa¸jÈ5ÐRSÈ*Ð=UÑVˆÜØ ØØ˜=¨&Ð1Ð2Øô    
ˆð uœbŸf™fÐ%¨¨5´"·&±&Ð'9Ð:ˆÚ5ˆÜ˜W¨gÔ6×=Ñ=Ø ¤Ð (ó
ˆô     ×јf hÔ/ô]‰]œ8Ð+=Ô >ñ    Ü ØØ#ؘ}¨fÐ5Ð6Øõ     ÷    ÷    ñ    ús ÂB:Â:CcóŠ—d}tjt|¬«5t|ddgdd¬«ddd«y#1swYyxYw)NrMr£rXrrrNrÓrOrQs   r%Ú5test_missing_meta_multilevel_record_path_errors_raisezHTestNestedToRecord.test_missing_meta_multilevel_record_path_errors_raise§sJ€ð
 :ð     ô]‰]œ8¨3Ô /ñ    Ü Ø%Ø2°HÐ=ØØõ     ÷    ÷    ñ    ús    ž9¹Acó —t|ddgdd¬«}ddgdtjgg}d    dg}t||¬
«}t    j
||«y) NrXrrrÒrÓrVrLr^rUr¦rrTs      r%Ú6test_missing_meta_multilevel_record_path_errors_ignorezITestNestedToRecord.test_missing_meta_multilevel_record_path_errors_ignore·sd€ô Ø!Ø.°Ð9ØØô    
ˆð˜gÐ &Ø œ2Ÿ6™6Ð "ð
ˆð Ð'ˆÜ˜W¨gÔ6ˆÜ
×јf hÕ/r$cóh—ddddœdœdddœdd    dœdœg}t|«}dddd
œdd    ddd œg}||k(sJ‚y) NÚSmithÚ    AppleseedrErHr>r?r@rCrD)r4rÿr)rÿrrýrþrrÀs    r%Útest_donot_drop_nonevaluesz-TestNestedToRecord.test_donot_drop_nonevaluesÉss€ð°GÈ+Ñ*VÑ Wà'3À\ÑRØ)/¸eÑDñ ð
ˆô" $Ó'ˆðØ%,Ø)4ñ ð &,Ø).Ø#/Ø%1ñ     ð 
ˆð˜Ò!Ð!Ñ!r$c
ó`—ddddddddddœdœiidœ}t|«}dddddddd    œ}||k(sJ‚y)
Nrr6çg“H@çÀ“@À瀂’;@)r ÚregionrðÚyÚz©r z    town.info©r Úlocation)r úlocation.country.state.idz#location.country.state.town.info.idú'location.country.state.town.info.regionú"location.country.state.town.info.xú"location.country.state.town.info.yú"location.country.state.town.info.zrrÀs    r%Ú$test_nonetype_top_level_bottom_levelz7TestNestedToRecord.test_nonetype_top_level_bottom_levelãsr€ðàØØ"à"&Ø&*Ø!3Ø!4Ø!3ñ &ñ    ð ð ñ
ˆô"" $Ó'ˆàØ)-Ø37Ø7;Ø2DØ2EØ2Dñ
ˆð˜Ò!Ð!Ñ!r$c    ód—dddddddddœdœdœdœdœ}t|«}ddddddddd    œ}||k(sJ‚y)
Nrerfrg)rhrðrirjrk)r r6)r rrl)r z location.idzlocation.country.idrnrorprqrrrrÀs    r%Útest_nonetype_multiple_levelsz0TestNestedToRecord.test_nonetype_multiple_levelssr€ðààà"à&*Ø!3Ø!4Ø!3ñ    &ññ ññ
ˆô$" $Ó'ˆàØØ#'Ø)-Ø7;Ø2DØ2EØ2Dñ    
ˆð˜Ò!Ð!Ñ!r$zmax_level, expectedNrbrcrdrerl)úCreatedBy.NameúLookup.TextFieldzLookup.UserField.IdzLookup.UserField.NameúImage.arrarfrhrkrmru)rvrwzLookup.UserFieldrxcó,—t||¬«}||k(sJ‚y)N©rr)r†rr‰rqÚoutputs     r%Útest_with_max_levelz&TestNestedToRecord.test_with_max_level%s €ôV"Ð";ÀyÔQˆØ˜Ò!Ð!Ñ!r$c    óx—d}dddddœddd    d
d d id œdœd œidœiig}dddd    d
d dœg}t||¬«}||k(sJ‚y)NédrnÚuserÚLeoÚThomson)Ú    firstnameÚLastNameÚfatherÚ    Father001Ú    Father002Ú    Father003raÚ    Father004)rr„)rar„)rÚ family_tree)zCreatedBy.user.name.firstnamezCreatedBy.user.name.LastNamez&CreatedBy.user.family_tree.father.namez-CreatedBy.user.family_tree.father.father.Namez4CreatedBy.user.family_tree.father.father.father.namez;CreatedBy.user.family_tree.father.father.father.father.Namerzr)r†rÚ
input_datar‰r{s     r%Útest_with_large_max_levelz,TestNestedToRecord.test_with_large_max_levelSs‘€àˆ    ðØØ.3ÀÑ Kà$Ø(3à,7à0;Ø39¸;Ð2Gñ/&ñ+"ñ    'ð (ñðð ð
ˆ
ð.27Ø09Ø:EØALØHSØOZñ  ð    
ˆô" *¸    ÔBˆØ˜Ò!Ð!Ñ!r$c    ó‚—ddddidœddddidœdd    d
didœd œ}t|«}gd ¢|_t|«}tgd ¢gd ¢dtj
tj
gtj
dtj
gtj
tj
dgdœ«}t j||«y)NruÚFoork)r rÚelementsrvÚBarrlrwÚBazrx)rrurvr–)rrrgð?g@g@)r rz
elements.az
elements.bz
elements.c)rrrrrrrƒr„)r†rªÚsrˆr‰s     r%Útest_series_non_zero_indexz-TestNestedToRecord.test_series_non_zero_indexxs®€ð °S¸!°HÑ=Ø °S¸!°HÑ=Ø °S¸!°HÑ=ñ
ˆô
4‹LˆÚˆŒÜ Ó"ˆÜâÚ-Ø"¤B§F¡F¬B¯F©FÐ3Ü!Ÿv™v s¬B¯F©FÐ3Ü!Ÿv™v¤r§v¡v¨sÐ3ñ  ó
ˆô     ×јf hÕ/r$)r4r5r6r@rGrKrRrUr[r]r_rcrsrur¨r7r8r|r‹r’r#r$r%r;r;Js÷„ò"ò "ò"ò&ò" 0òò6ò 0ò$"ò4"ò@ "ðD ‡[[×ÑØðð+4Ø,7Ø/6Ø1:Ø#&ñ ðð ðð'-¨iÐ%8à)4Ø07ÀÑ)Kñ#ð#& s ñ ð    ð ðð+4Ø,7Ø3:ÀIÑ,NØ#&ñ    ðð
ð5%    
ó(ñR"óS(ðR"ò
#"óJ0r$r;)r÷Únumpyrr¨ÚpandasrrrrÚpandas._testingÚ_testingrƒÚpandas.io.json._normalizerÚfixturer&r<rJr_rqrsr;r#r$r%ú<module>r™s²ðÛ ãÛ ÷óõ å6ð‡ñ#óð#ðL‡ñóðð0‡ñóðð‡ñóðð<‡ñ óð ÷ {0ñ{0÷| A0òA0r$