
    I j5                         S SK r S SKrS SKrS SKJrJrJrJr  S SK	J
r  S SKJr  \R                  S 5       r\R                  S 5       r\R                  S 5       r " S S5      r " S	 S
5      rg)    N)	DataFrameIndexSeriesjson_normalizenested_to_recordc                  n    SSSSS.SSS./S.S	S
SS.SSS./S./S.SSSSS./S.SSSS.SSS./S./S./$ )NUSA
CaliforniaSan Francisco90  )namepopLos Angeles:0  )r   citiesOhioColumbus  	Cleveland  )countrystatesGermanyBayernMunich;0  Nordrhein-WestfalenDuesseldorf  Koeln   r#       t/root/GenerationalWealth/GenerationalWealth/venv/lib/python3.13/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    SSS.SSS.SSS./SS	0S
SS.SSS.SSS./SS0SSS./$ )NDader   r   
populationBroward@  
Palm Beach`  governor
Rick ScottFLFlorida)countiesinfo	shortnamestateSummitr   Cuyahoga9  John KasichOHr   r#   r#   r$   r%   
state_datar<   8   sl    
  u5"%8%U;
  .		
 "6#48  /	
 r$   c                  H    SSSSSSS./SS	S
0/0S.SSSSSS./SS	S0/0S./$ )NAliceZ%  
Morris St.	Massillonr;   f  )numberstreetcityr6   zipr   	city_nameFoo York City)r   	addressesprevious_residences!  
Spring St.ElizabethtonTN  
Barmingham)rI   rJ   r#   r#   r$   r%   missing_metadatarQ   Q   su      #*'!  %-_/M.N#O	
  #**!  %-\/J.K#L	
 r$   c                   ^   \ rS rSrS rS rS rS r\R                  R                  SSS0SS	0/S
S
4SSS0SS	0/0SS
4SS
\4S
S
\4/5      S 5       rS rS rS rS rS rS rS rS rS rS rS rS rS r\R                  R                  SSSSSS.SS 0SS!0S".SSSS.SS 0SS!0S"./4S	SSSSS 0SS!0S#.SSSSS 0SS!0S#./4/5      S$ 5       r\R                  R                  S%SS
/5      S& 5       rS' rS( r\R                  R                  S)/ S*Q5      S+ 5       rS, rS- r S. r!S/ r"S0r#g
)1TestJSONNormalizep   c                     SSSS.SSSS.SS	S
S.SSSS./n[        U5      n[        U5      n[        R                  " X#5        g )N         )abc               	   
         r   r   tmassert_frame_equalselfrecsresultexpecteds       r%   test_simple_records%TestJSONNormalize.test_simple_recordsq   sT    !!$!!$!!$2B'	
  %T?
f/r$   c                    [        US   S5      n[        US   S   5      n[        R                  " X#5        [        US5      n/ nU H  nUR	                  US   5        M     [        U5      n[        R                  " X#5        [        USSS9n[
        R                  " SS/5      R                  SS/5      US'   [        R                  " X#5        g )	Nr   r3   r6   metar2   r   rX   rW   )r   r   rf   rg   extendnparrayrepeatri   r<   rk   rl   recs        r%   test_simple_normalize'TestJSONNormalize.test_simple_normalize~   s    
1z:Z]:67
f/
J7COOC
O, X&
f/
JWEHHi%89@@!QH
f/r$   c                     / SQSSS/0S./n[        US/SS//S9n[        / SQSS/SS/SS//S	.5      n[        R                  " X#5        g )
NrV   rW   rX   listdatarV   rW   )valuesmetadatar}   r~   record_pathrq   )r   zmetadata.listdatare   )ri   parse_metadata_fields_list_typerk   rl   s       r%   test_fields_list_type_normalize1TestJSONNormalize.test_fields_list_type_normalize   sq     zAq6.BC+
'  +!
z*+

 !Q!Q!Q0HI
 	f/r$   c                 Z    [        / 5      n[        5       n[        R                  " X5        g )Nre   ri   rk   rl   s      r%   test_empty_array"TestJSONNormalize.test_empty_array   s!    #;
f/r$   z!data, record_path, exception_typerY   r   rV   Nz{"a": [{"a": 0}, {"a": 1}]}c                     Ub(  [         R                  " USS9   [        XS9  S S S 5        g [        XS9n[        SS/S/S9n[        R
                  " XE5        g ! , (       d  f       g = f)Nz^$matchr   r   rV   rY   columns)pytestraisesr   r   rf   rg   )ri   datar   exception_typerk   rl   s         r%   test_accepted_input%TestJSONNormalize.test_accepted_input   s]     %~T:t= ;: $DBF !Q#7H!!&3 ;:s   
A
A'c                 X   [        SSSS.05      n[        SS//SS/S9n[        R                  " UR	                  U5      U5        [        SSSS.0SS	9n[        SS//S
S/S9n[        R                  " UR	                  U5      U5        [        SSSS.0SS	9n[        SS//SS/S9n[        R                  " UR	                  U5      U5        [        USS/SSS//SS9n[        / SQ5      R                  5       nUR                  R                  5       R                  U5      (       d   eg )NArV   rW   )r   BzA.AzA.Br   _sepA_AA_Bu   σu   AσAu   AσBr   r   r   r   )rq   r   )r   r   r   states_name)	r   r   rf   rg   reindex_liker   sort_valuesr   equals)ri   r&   rk   rl   s       r%   $test_simple_normalize_with_separator6TestJSONNormalize.test_simple_normalize_with_separator   s5   AA&6 78q!fXu~>
f11(;XFAA&6 7SAq!fXu~>
f11(;XFAA&6 7XFq!fX
J/GH
f11(;XFx h/0	
 BCOOQ~~))+228<<<<r$   c                 |    SS/SSS.S.n[        USS9n[        SS/SS/// SQS	9n[        R                  " X#5        g )
NrV   rW   )rX   r\   )b_1b_2)rY   rZ   __r   )rY   b__b_1b__b_2r   re   ri   r   rk   rl   s       r%   'test_normalize_with_multichar_separator9TestJSONNormalize.test_normalize_with_multichar_separator   sJ    V!F";<$/1vq&12<UV
f/r$   c                 l    [        SSS/0SSS9n[        S/S//S/S9n[        R                  " X5        g )Nr   rV   rW   zPrefix.record_prefixzPrefix.0r   re   r   s      r%   test_value_array_record_prefix0TestJSONNormalize.test_value_array_record_prefix   s<    q!fs)LqcA3Z*>
f/r$   c                     SSSSS.SSS.SS	S./S
.S.n[        USS/S9n[        SS/SS/SS	//SS/S9n[        R                  " X#5        g )Nr2   r0   r(   r   r)   r+   r,   r-   r.   )r/   r3   r6   r4   r4   r3   r   r   r*   r   re   r   s       r%   test_nested_object_record_path0TestJSONNormalize.test_nested_object_record_path   s     (#59&e<)?

  6:2FGe_y%0<2GH\*
 	f/r$   c                     [        USS/SSS//S9nS/S-  S/S	-  -   / S
Q/ SQ/ SQS.n[        X2R                  S9n[        R                  " X$5        g )Nr   r   r   r   rp   r
   r\   r   rX   )r   r   r   r   r   r   r   )r   r   r   r   r   r   r!   )r   r   r   r   r   r    r"   )r   zstates.namer   r   r   r   r   r   rf   rg   )ri   r&   rk   ex_datarl   s        r%   test_more_deeply_nested)TestJSONNormalize.test_more_deeply_nested   sm    (H-Y6@R4S
 w{i[1_4 A)
. Wnn=
f/r$   c                    SSSS0SSS.SS	S.S
SS./S.SSSS0SSS.SSS./S./n[        USSSSS//5      n/ SQS/S-  S/S-  -   / SQS/S-  S/S-  -   / SQS.n[        X2R                  S9n[        R                  " X$5        g )Nr2   r1   r/   r0   r(   r   r)   r+   r,   r-   r.   )r6   r5   r4   r3   r   r;   r:   r7   r   r8   r9   r3   r6   r5   r4   r(   r+   r-   r7   r8   rX   rW   )r1   r1   r1   r;   r;   r   r,   r.   r   r9   )r   r6   r5   info.governorr*   r   r   )ri   r   rk   r   rl   s        r%   test_shallow_nested%TestJSONNormalize.test_shallow_nested  s     #!#\2#59&e<)?		  !#]3%T:'t<	
,  *wfj5IJ
 L[1_x!|37*^a/=/A2EE;
 Wnn=
f/r$   c                     [        US/SSSS//SS9n/ SQ/ S	QS
/S-  S/S-  -   S/S-  S/S-  -   S/S-  S/S-  -   S.n[        U5      n[        R                  " X$5        g )Nr3   r6   r5   r4   r/   ignorer   r   rq   errorsr   r   r2   rX   r   rW   r1   r;   r0   r:   )r   r*   r6   r5   r   re   )ri   r<   rk   r   rl   s        r%   -test_nested_meta_path_with_nested_record_path?TestJSONNormalize.test_nested_meta_path_with_nested_record_path0  s    #;(<=	
 L;[1_x!|3!tfqj0*^a/=/A2EE
 W%
f/r$   c                     SSSSS.SSS./S./nS	n[         R                  " [        US
9   [        USSS/S9  S S S 5        [        USSS/SS9nS H
  nXC;   a  M
   e   g ! , (       d  f       N-= f)Nhellothere	somethingelsefoobar
something2else2r   r   r   z?Conflicting metadata name (foo|bar), need distinguishing prefixr   r   r   r   rp   rq   rq   meta_prefixmetafoometabarr   r   )r   r   
ValueErrorr   )ri   r   msgrk   vals        r%   test_meta_name_conflict)TestJSONNormalize.test_meta_name_conflictD  s     '7(9	
 Q]]:S14uen= 2  fE5>vV7C= = 8 21s   A  
A.c                 v    SSSSS.SSS./S./nS	S
/n[        USUSS9nUS	S
/:X  d   eS H
  nXC;   a  M
   e   g )Nr   r   r   r   r   r   r   r   r   r   r   rq   r   r   )r   )ri   r   COLUMNSrk   r   s        r%    test_meta_parameter_not_modified2TestJSONNormalize.test_meta_parameter_not_modifiedY  sl     '7(9	
 %.f7O5%.(((7C= = 8r$   c                    [        US   S5      n[        US   S   5      n[        R                  " X#5        [        USSSS9n/ nU H  nUR	                  US   5        M     [        U5      nUR                  S S9n[        R                  " SS	/5      R                  S
S/5      US'   [        R                  " X#5        g )Nr   r3   r6   county_)rq   r   c                     SU -   $ )Nr   r#   )xs    r%   <lambda>6TestJSONNormalize.test_record_prefix.<locals>.<lambda>z  s    Y]r$   r   r2   r   rX   rW   )	r   r   rf   rg   rr   renamers   rt   ru   rv   s        r%   test_record_prefix$TestJSONNormalize.test_record_prefixm  s    
1z:Z]:67
f/
	
 COOC
O, X&??+B?CHHi%89@@!QH
f/r$   c                     [        [        S5       Vs/ s H  o SS.PM
     sn5      n[        USS9n[        SSS.SSS.S	SS./5      n[        R
                  " X45        g s  snf )
NrX   q)kmzT.r   0)zT.kzT.m12)r   ranger   r   rf   rg   )ri   isrk   rl   s        r%   (test_record_prefix_no_record_path_series:TestJSONNormalize.test_record_prefix_no_record_path_series  sl    U1X>XCs+X>?6C(C(C(
 	f/ ?s   A!c                     SR                  S5      nSR                  S5      SS/SSS/SS	S
/0n[        U5      n[        [        R                  " U5      5      n[
        R                  " XC5        g )NsK   [{"Ünicøde":0,"sub":{"A":1, "B":2}},{"Ünicøde":1,"sub":{"A":3, "B":4}}]utf8s	   Ünicøder   rV   zsub.ArX   zsub.BrW   r\   )decoder   r   jsonloadsrf   rg   )ri   testjsontestdatarl   rk   s        r%   test_non_ascii_key$TestJSONNormalize.test_non_ascii_key  sr    A
&. 	 %++F3aVaVaV

 X&

8 45
f/r$   c                 &   SS 0SSS.SSS.S./n[        U5      n[        R                  [        R                  [        R                  [        R                  [        R                  S	.S SSSSS	./n[        U5      n[        R
                  " X$5        g )
Nr4   
11/08/1993
26/05/2012
created_atlast_updatedJaneDoefirst	last_namer4   author_name)r4   info.created_atinfo.last_updatedauthor_name.firstauthor_name.last_namer   rs   nanr   rf   rg   )ri   author_missing_datark   r   rl   s        r%   test_missing_field$TestJSONNormalize.test_missing_field  s     TN'3\R)/eD
   34 #%66%'VV%'VV)+ #/%1%+).
  W%
f/r$   zmax_level,expected	Some textID001Name001IdNamer  User001rZ   )	TextField	UserField	CreatedByImage)r  zUserField.IdzUserField.Namer  r  c                     SS0SSSS.S.SSSS.S./SS	0S
SS.SSS./S./n[        US/S/S//US9n[        X$R                  R                  S9n[        R
                  " XT5        g )Nr  r  r  r  r  r  r  r  rY   rZ   r   r   r   r   r   )r  Lookupr  tagsr  r  r  )r   rq   	max_level)r   r   )r   r   r   r}   rf   assert_equal)ri   r!  rl   
test_inputrk   expected_dfs         r%    test_max_level_with_records_path2TestJSONNormalize.test_max_level_with_records_path  s    Z %i0 &1,3Y%G
 &1,3Y%G	 s'7(9

*  !
-'+	
  X~~7L7LM
,r$   r!  c                 2   [         R                  SS0SS0/n[        X!S9n[        S[         R                  SS/05      n[        R
                  " X45        Sn[        R                  " [        US9   [        SSS0/US9  S S S 5        g ! , (       d  f       g = f)Nidrd      r!  z>All items in data must be of type dict or NA-like, found floatr         ?)	rs   r  r   r   rf   rg   r   r   	TypeError)ri   r!  	data_listrk   rl   r   s         r%   "test_json_normalize_non_dict_items4TestJSONNormalize.test_json_normalize_non_dict_items  s     VVdBZ$4		?dRVVR$456
f/N]]9C0C$,	B 100s   0B
Bc                 v    [        SSS00/5      n[        SSSS00/0S5      n[        R                  " X5        g )Nr   r   rV   dummy)r   rf   rg   )ri   df1df2s      r%   !test_nested_flattening_consistent3TestJSONNormalize.test_nested_flattening_consistent  sC    sS!Ho./gsAh'897C 	c'r$   c                     [        SUS.SSS0/S./S/S9n[        SS0[        S5      S	9n[        R                  " X#5        g )
NTexasr   r2   r   rW   r4   r   rV   index)r   r   r   rf   r"  )ri   nulls_fixturerk   rl   s       r%   test_nonetype_record_path+TestJSONNormalize.test_nonetype_record_path  sR      !=9#sAhZ8  
 c1XU1X6
)r$   value)falsetruez{}r   z"text"c                     [         R                  " U5      nSUS.nSnS[        U5      R                   S3n[        R
                  " [        US9   [        U/U/S9  S S S 5        g ! , (       d  f       g = f)Nr7  r   r4   z(Path must contain list or null, but got z
 at 'info'r   r   )r   r   type__name__r   r   r,  r   )ri   r=  parsed_valuer#  	test_pathr   s         r%    test_non_list_record_path_errors2TestJSONNormalize.test_non_list_record_path_errors$  sm     zz%(&=
	L)223:? 	 ]]9C0J<i[A 100s   A&&
A4c           	          Sn[        [        R                  " U5      S/S/S9n[        S/S/[        R
                  " S/[        S9S	.5      n[        R                  " X#5        g )
Nz,[{"id": 99, "data": [{"one": 1, "two": 2}]}]r   r(  r   rV   rW   c   )dtype)onetwor(  )	r   r   r   r   rs   rt   objectrf   rg   r   s       r%   test_meta_non_iterable(TestJSONNormalize.test_meta_non_iterable1  sW    A

4 0vhdVTC288RD+GH
 	f/r$   c                    ^ U4S jn[        U" 5       5      n[        TS   S   5      n[        R                  " X45        g )Nc               3   2   >#    T S   S    S h  vN   g  N7f)Nr   r3   r#   )r<   s   r%   generator_data8TestJSONNormalize.test_generator.<locals>.generator_data>  s     !!}Z000s   r   r3   re   )ri   r<   rQ  rk   rl   s    `   r%   test_generator TestJSONNormalize.test_generator;  s8    	1   01Z]:67
f/r$   c                 v    SSS0S.SS.n[        USS9n[        / S	Q// S
QS9n[        R                  " X#5        g )Nrb   l3r   )a1l2r\   )_idggr   r   )r\   rb   r   )rZ  _id_a1	_id_l2_l3r   re   r   s       r%   'test_top_column_with_leading_underscore9TestJSONNormalize.test_top_column_with_leading_underscoreF  s>     q	2!<#.j\3PQ
f/r$   c                    [        SS/5      n[        XS9n[        U5      n[        R                  " UR
                  U5        [        US5      n[        R                  " UR
                  UR                  SS/5      5        g )Nr_   r`   r8  r3   rX   rW   )r   r   r   rf   assert_index_equalr9  ru   )ri   r<   idxseriesrk   s        r%   test_series_index#TestJSONNormalize.test_series_indexN  sd    QFm
.'
fllC0
3
fllCJJ1v,>?r$   r#   )$rB  
__module____qualname____firstlineno__rm   rx   r   r   r   markparametrizeNotImplementedErrorr   r   r   r   r   r   r   r   r   r   r   r   r   r  r%  r.  r4  r;  rE  rM  rS  r]  rc  __static_attributes__r#   r$   r%   rS   rS   p   s   00&00
 [[+Aha!4.S!HsAh'(#t4*D2EF4,-		
44=.000(0<"0H0(!*!(0$00 0: [[  &1,3Y%G&,i%8"%s	 &1,3Y%G&,i%8"%s	$  &1(/*3&,i%8"%s &1(/*3&,i%8"%s%%	
(R-S(R-@ [[[1d)4
C 5
C(* [[W&LM
B N
B0	00@r$   rS   c                       \ rS rSrS rS rS rS rS rS r	S r
S	 rS
 rS rS r\R                   R#                  SSSSSSSS./4SSS0SSSS.S.SS0S./4SSSSSS.SS./4/5      S 5       rS rS rS  rS!rg)"TestNestedToRecordiW  c                 @    SSS.SSS./n[        U5      nUnX#:X  d   eg )NrV   rW   )flat1flat2rX   r\   )flat3rp  r   rh   s       r%   test_flat_stays_flat'TestNestedToRecord.test_flat_stays_flatX  s1    a(A*BC!$'!!!r$   c                 D    SSSS.S.n[        U5      nSSSS.nX#:X  d   eg )NrV   rW   r[   d)ro  dict1)dict1.cdict1.dro  r   r   s       r%   test_one_level_deep_flattens/TestNestedToRecord.test_one_level_deep_flattens^  s3    11%56!$' Q;!!!r$   c                 X    SSSS.SSS.SS.S.n[        U5      nSSSSSSS.nX#:X  d   eg )NrV   rW   ru  )erv  )ro  rw  nested)rx  ry  ro  znested.dz
nested.e.cz
nested.e.dr   r   s       r%   test_nested_flattens'TestNestedToRecord.test_nested_flattensf  sT    1%"#!,15
 "$'
 !!!r$   c                     Sn[         R                  " [        US9   [        USSSS9  S S S 5        g ! , (       d  f       g = f)N^Key 'name' not found. To replace missing values of 'name' with np.nan, pass in errors='ignore'r   rI   r   raiser   r   r   KeyErrorr   ri   rQ   r   s      r%   test_json_normalize_errors-TestNestedToRecord.test_json_normalize_errorsy  s<    : 	 ]]83/%'	 0//s	   2
A c                     [        USSSS9n/ SQSSSS	S
[        R                  //n/ SQn[        X4S9n[        R
                  " X%5        g )NrI   r   r   r   )r?   r@   rA   r;   rB   r>   rK   rL   rM   rN   rO   )rC   rD   rE   r6   rF   r   r   r  ri   rQ   rk   r   r   rl   s         r%   test_missing_meta$TestNestedToRecord.test_missing_meta  sY      !{PX
 D<ubffE
 GW6
f/r$   c                 ~   SS SS0SS0/S.n[        USSSS	//S
S9nSS[        R                  /SS[        R                  //n/ SQn[        X4S9R	                  S[
        05      n[        R                  " X%5        [        R                  " [        SS9   [        USSSS	//SS9  S S S 5        g ! , (       d  f       g = f)Nr   rw   rV   rW   )rq   nested_metar=  r=  rq   r  leafr   )r   rq   r   )rw   rq   nested_meta.leafr   r  z'leaf' not foundr   r  )r   rs   r  r   astyperL  rf   rg   r   r   r  )ri   r   rk   r   r   rl   s         r%   test_missing_nested_meta+TestNestedToRecord.test_missing_nested_meta  s     duaj5RS*=UV=&12	
 ubff%5"&&'9:5W6==(
 	f/ ]]8+=>#}f56	 ?>>s   B..
B<c                     Sn[         R                  " [        US9   [        USS/SSS9  S S S 5        g ! , (       d  f       g = f)Nr  r   rJ   r   r   r  r   r  r  s      r%   5test_missing_meta_multilevel_record_path_errors_raiseHTestNestedToRecord.test_missing_meta_multilevel_record_path_errors_raise  sA    
: 	 ]]83/%2H=	 0//s	   4
Ac                     [        USS/SSS9nSS/S[        R                  //nS	S/n[        X4S
9n[        R
                  " X%5        g )NrJ   r   r   r   r   rH   r>   rP   rG   r   r  r  s         r%   6test_missing_meta_multilevel_record_path_errors_ignoreITestNestedToRecord.test_missing_meta_multilevel_record_path_errors_ignore  s`      !.9	
 g&266"
 'W6
f/r$   c                 h    S SSS.S.SSS.SS	S.S./n[        U5      nS SSS
.SS	SSS./nX#:X  d   eg )NSmith	Appleseedr  r  r   r   r   r  r  )r4   r  r  )r  r  r	  r
  r   r   s       r%   test_donot_drop_nonevalues-TestNestedToRecord.test_donot_drop_nonevalues  sq     G+*VW'3\R)/eD
 "$' %,)4 &,).#/%1	
 !!!r$   c           
      `    S SSS S S SSSS.S.00S.n[        U5      nS S S S SSSS	.nX#:X  d   eg )
Nr   r6       gH@   @   ;@)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.zr   r   s       r%   $test_nonetype_top_level_bottom_level7TestNestedToRecord.test_nonetype_top_level_bottom_level  sp     ""&&*!3!4!3&	
" "$')-377;2D2E2D
 !!!r$   c           	      d    S S S S S SSSS.S.S.S.S.n[        U5      nS S S S S SSSS	.nX#:X  d   eg )
Nr  r  r  )r  r   r  r  r  )r(  r6   )r(  r   r  )r(  zlocation.idzlocation.country.idr  r  r  r  r  r   r   s       r%   test_nonetype_multiple_levels0TestNestedToRecord.test_nonetype_multiple_levels  sp     "&*!3!4!3	&
$ "$'#')-7;2D2E2D	
 !!!r$   zmax_level, expectedNr  r  r  r  rZ   )CreatedBy.NameLookup.TextFieldzLookup.UserField.IdzLookup.UserField.NameImage.ar   r  r  r  rY   r  r  r  rV   )r  r  zLookup.UserFieldr  c                 F    SS0SSSS.S.SS	0S
./n[        X1S9nXB:X  d   eg )Nr  r  r  r  r  r  r  rY   rZ   r  r*  r   )ri   r!  rl   max_level_test_input_dataoutputs        r%   test_with_max_level&TestNestedToRecord.test_with_max_level2  sL    Z %i0!,(/!C s	%
! "";Q!!!r$   c           	      p    SnSSSSS.SSS	S
SS0S.S.S.0S.00/nSSSS	S
SS./n[        X!S9nXC:X  d   eg )Nd   r  userLeoThomson)	firstnameLastNamefather	Father001	Father002	Father003r  	Father004)r   r  )r  r  )r   family_tree)zCreatedBy.user.name.firstnamezCreatedBy.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.Namer*  r   )ri   r!  
input_datarl   r  s        r%   test_with_large_max_level,TestNestedToRecord.test_with_large_max_levelj  s    	 .3 K$(3,70;39;2G/&+"	'(

. 2709:EALHSOZ	
 "*B!!!r$   c           	         SSSS0S.SSSS0S.SS	S
S0S.S.n[        U5      n/ SQUl        [        U5      n[        / SQ/ SQS[        R
                  [        R
                  /[        R
                  S[        R
                  /[        R
                  [        R
                  S/S./ SQS9n[        R                  " X45        g )NrV   FoorY   )r(  r   elementsrW   BarrZ   rX   Bazr[   )r   rV   rW   r{   )r  r  r  r+  g       @g      @)r(  r   z
elements.az
elements.bz
elements.cr8  )r   r9  r   r   rs   r  rf   rg   )ri   r   r   rk   rl   s        r%   test_series_non_zero_index-TestNestedToRecord.test_series_non_zero_index  s     S!H=S!H=S!H=

 4L"-"BFFBFF3!vvsBFF3!vvrvvs3 	
 	f/r$   c                    SSSS0/S./n[         R                  " [        SS9   [        US/S	9  S S S 5        [         R                  " [        SS9   [        US
/S/S9  S S S 5        g ! , (       d  f       N>= f! , (       d  f       g = f)NrV   
meta_valuerZ   rW   )rY   rd   r~  zmust be stringsr   rd   rp   r~  r   )r   r   r,  r   )ri   r   s     r%   *test_json_normalize_meta_string_validation=TestNestedToRecord.test_json_normalize_meta_string_validation  st    \sAhZ@A ]]9,=>4rd+ ? ]]9,=>4hZrdC ?> ?> ?>s   A(A9(
A69
Br#   )rB  re  rf  rg  rr  rz  r  r  r  r  r  r  r  r  r  r   rh  ri  r  r  r  r  rk  r#   r$   r%   rm  rm  W  s    """&"06 0$"4"@ "D [[  +4,7/61:#&  '-i%8)407)K# #&s	  +4,73:I,N#&	
5%	
(R"S(R"#"J0,	Dr$   rm  )r   numpyrs   r   pandasr   r   r   r   pandas._testing_testingrf   pandas.io.json._normalizer   fixturer&   r<   rQ   rS   rm  r#   r$   r%   <module>r     s         6 # #L  0  <d@ d@NWD WDr$   