§
    á! h`x  ã                   ó"  — d dl Z d dlZd dlZd dlmZmZmZmZ d dl	m
Z d dlmZ ej        d„ ¦   «         Zej        d„ ¦   «         Zej        d„ ¦   «         Zej        d„ ¦   «         Zej        d„ ¦   «         Z G d	„ d
¦  «        Z G d„ d¦  «        ZdS )é    N)Ú	DataFrameÚIndexÚSeriesÚjson_normalize©Únested_to_recordc                  ón   — dddddœdddœgdœd	d
ddœdddœgdœgdœdddddœgdœddddœdddœgdœgdœgS )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#   ó    ú]c:\xampp_lite_8_4\www\timesheet\venv\Lib\site-packages\pandas/tests/io/json/test_normalize.pyÚdeep_nestedr&      sÆ   € ð
 ð )à!0¸Ð?Ð?Ø!.°uÐ=Ð=ððð ð #à!+°DÐ9Ð9Ø!,°TÐ:Ð:ððð ðð	
ð 	
ð( !à!°xÈÐ.NÐ.NÐ-OÐPÐPà1à!.°tÐ<Ð<Ø!(°Ð6Ð6ððð ð	ð	
ð 	
ð)!ð !r$   c                  óN   — dddœdddœdddœgdd	id
ddœdddœdddœgddidddœgS )NÚDader   ©r   Ú
populationÚBrowardé@œ  ú
Palm Beaché`ê  Úgovernorú
Rick ScottÚFLÚFlorida)ÚcountiesÚinfoÚ	shortnameÚstateÚSummitr   ÚCuyahogaé9  úJohn KasichÚOHr   r#   r#   r$   r%   Ú
state_datar<   8   s…   € ð
  ¨uÐ5Ð5Ø"°%Ð8Ð8Ø%°UÐ;Ð;ðð
   Ð.ØØð		
ð 		
ð "°Ð6Ð6Ø#°4Ð8Ð8ðð   Ð/ØØð	
ð 	
ðð r$   c                  ó    — dd idddœdddœdœgS )	Nr4   ú
11/08/1993ú
26/05/2012©Ú
created_atÚlast_updatedÚJaneÚDoe©ÚfirstÚ	last_name©r4   Úauthor_namer#   r#   r$   r%   Úauthor_missing_datarJ   Q   s5   € ð 
�ˆà#/ÀÐNÐNØ%+¸%Ð@Ð@ð	
ð 	
ðð r$   c                  óH   — dddddddœgdd	d
igidœddddddœgdd	digidœgS )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)rW   rX   r#   r#   r$   r%   Úmissing_metadatar_   \   s‰   € ð ð #Ø*Ø'Ø!Ø ðð ðð %-°¸_Ð/MÐ.NÐ#Oð	
ð 	
ð  #Ø*Ø*Ø!Ø ðð ðð %-°¸\Ð/JÐ.KÐ#Lð	
ð 	
ðð r$   c                  ó$   — ddiddddœdœdd	id
œgS )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   {   sA   € ð ! )Ð,à(Ø$+°YÐ?Ð?ðð ð ˜3�Zð	
ð 	
ð	ð 	r$   c                   ó  — e Zd Zd„ Zd„ Zd„ Zd„ Zej         	                    dddiddigd	d	fdddiddigidd	fd
d	e
fd	d	e
fg¦  «        d„ ¦   «         Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zej         	                    ddddddœddiddid œddddœddiddid œgfddddddiddid!œdddddiddid!œgfg¦  «        d"„ ¦   «         Zd#„ Zd$„ Zej         	                    d%g d&¢¦  «        d'„ ¦   «         Zd(„ Zd)„ Zd*„ Zd	S )+ÚTestJSONNormalizec                 ó˜   — ddddœddddœdd	d
dœddddœg}t          |¦  «        }t          |¦  «        }t          j        ||¦  «         d S )Né   é   é   )rk   rl   Úcé   é   é   é   é   é	   é
   é   é   ©r   r   ÚtmÚassert_frame_equal©ÚselfÚrecsÚresultÚexpecteds       r%   Útest_simple_recordsz%TestJSONNormalize.test_simple_records�   sp   € à˜! !Ð$Ð$Ø˜! !Ð$Ð$Ø˜! !Ð$Ð$Ø˜2 BÐ'Ð'ð	
ˆõ   Ñ%Ô%ˆÝ˜T‘?”?ˆå
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 óè  — t          |d         d¦  «        }t          |d         d         ¦  «        }t          j        ||¦  «         t          |d¦  «        }g }|D ]}|                     |d         ¦  «         Œt          |¦  «        }t          j        ||¦  «         t          |dd¬¦  «        }t          j        ddg¦  «                             ddg¦  «        |d<   t          j        ||¦  «         d S )	Nr   r3   r6   ©Úmetar2   r   rw   rv   )r   r   rƒ   r„   ÚextendÚnpÚarrayÚrepeat©r†   r<   rˆ   r‰   Úrecs        r%   Útest_simple_normalizez'TestJSONNormalize.test_simple_normalizeš   sò   € Ý 
¨1¤¨zÑ:Ô:ˆÝ˜Z¨œ]¨:Ô6Ñ7Ô7ˆÝ
Ô˜f hÑ/Ô/Ð/å 
¨JÑ7Ô7ˆàˆØð 	-ð 	-ˆCØ�OŠO˜C 
œOÑ,Ô,Ð,Ð,Ý˜XÑ&Ô&ˆå
Ô˜f hÑ/Ô/Ð/å 
¨J¸WÐEÑEÔEˆÝœH i°Ð%8Ñ9Ô9×@Ò@À!ÀQÀÑHÔHˆ�Ñå
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó®   — g d¢dddgidœg}t          |dgddgg¬¦  «        }t          g d¢ddgddgddggd	œ¦  «        }t          j        ||¦  «         d S )
N©ru   rv   rw   Úlistdataru   rv   )ÚvaluesÚmetadatar˜   r™   ©Úrecord_pathr�   )r   zmetadata.listdatar‚   )r†   Úparse_metadata_fields_list_typerˆ   r‰   s       r%   Útest_fields_list_type_normalizez1TestJSONNormalize.test_fields_list_type_normalize­   s™   € à �y�y¨z¸A¸q¸6Ð.BÐCÐCð+
Ð'õ  Ø+Ø!˜
Ø˜zÐ*Ð+ð
ñ 
ô 
ˆõ
 Ø�	�	°!°Q°¸!¸Q¸À!ÀQÀÐ0HÐIÐIñ
ô 
ˆõ 	Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ój   — t          g ¦  «        }t          ¦   «         }t          j        ||¦  «         d S )Nr‚   ©r†   rˆ   r‰   s      r%   Útest_empty_arrayz"TestJSONNormalize.test_empty_array»   s1   € Ý Ñ#Ô#ˆÝ‘;”;ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   z!data, record_path, exception_typerk   r   ru   Nz{"a": [{"a": 0}, {"a": 1}]}c                 ó  — |�Bt          j        |d¬¦  «        5  t          ||¬¦  «         d d d ¦  «         d S # 1 swxY w Y   d S t          ||¬¦  «        }t          ddgdg¬¦  «        }t	          j        ||¦  «         d S )NÚ ©Úmatch©r›   r   ru   rk   ©Úcolumns)ÚpytestÚraisesr   r   rƒ   r„   )r†   Údatar›   Úexception_typerˆ   r‰   s         r%   Útest_accepted_inputz%TestJSONNormalize.test_accepted_inputÀ   sÛ   € ð Ð%Ý”˜~°RÐ8Ñ8Ô8ð >ð >Ý˜t°Ð=Ñ=Ô=Ð=ð>ð >ð >ñ >ô >ð >ð >ð >ð >ð >ð >ð >øøøð >ð >ð >ð >ð >ð >õ $ D°kÐBÑBÔBˆFÝ  ! Q °#°Ð7Ñ7Ô7ˆHÝÔ! &¨(Ñ3Ô3Ð3Ð3Ð3s   ™8¸<¿<c                 óÎ  — t          ddddœi¦  «        }t          ddggddg¬¦  «        }t          j        |                     |¦  «        |¦  «         t          ddddœid¬	¦  «        }t          ddggd
dg¬¦  «        }t          j        |                     |¦  «        |¦  «         t          ddddœid¬	¦  «        }t          ddggddg¬¦  «        }t          j        |                     |¦  «        |¦  «         t          |ddgdddggd¬¦  «        }t          g d¢¦  «                             ¦   «         }|j                             ¦   «                              |¦  «        sJ ‚d S )NÚAru   rv   )r®   ÚBzA.AzA.Br¦   Ú_©ÚsepÚA_AÚA_Bu   Ïƒu   AÏƒAu   AÏƒBr   r   r   r   )r�   r²   )r   r   r   Ústates_name)	r   r   rƒ   r„   Úreindex_liker   Úsort_valuesr§   Úequals)r†   r&   rˆ   r‰   s       r%   Ú$test_simple_normalize_with_separatorz6TestJSONNormalize.test_simple_normalize_with_separatorÒ   s‘  € å ¨A°AÐ&6Ð&6Ð 7Ñ8Ô8ˆÝ˜q !˜f˜X°°u¨~Ð>Ñ>Ô>ˆÝ
Ô˜f×1Ò1°(Ñ;Ô;¸XÑFÔFÐFå ¨A°AÐ&6Ð&6Ð 7¸SÐAÑAÔAˆÝ˜q !˜f˜X°°u¨~Ð>Ñ>Ô>ˆÝ
Ô˜f×1Ò1°(Ñ;Ô;¸XÑFÔFÐFå ¨A°AÐ&6Ð&6Ð 7¸XÐFÑFÔFˆÝ˜q !˜f˜X°
¸JÐ/GÐHÑHÔHˆÝ
Ô˜f×1Ò1°(Ñ;Ô;¸XÑFÔFÐFåØØ�xÐ Ø˜h¨Ð/Ð0Øð	
ñ 
ô 
ˆõ ÐBÐBÐBÑCÔC×OÒOÑQÔQˆØŒ~×)Ò)Ñ+Ô+×2Ò2°8Ñ<Ô<Ð<Ð<Ð<Ð<Ð<r$   c                 ó˜   — ddgdddœdœ}t          |d¬¦  «        }t          ddgddggg d¢¬	¦  «        }t          j        ||¦  «         d S )
Nru   rv   )rw   ry   )Úb_1Úb_2)rk   rl   Ú__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é   sm   € à˜�V¨!°FÐ";Ð";Ð<Ð<ˆÝ ¨$Ð/Ñ/Ô/ˆÝ  1˜v q¨&Ð1Ð2Ð<UÐ<UÐ<UÐVÑVÔVˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 óˆ   — t          dddgidd¬¦  «        }t          dgdggdg¬¦  «        }t          j        ||¦  «         d S )Nr®   ru   rv   zPrefix.)Úrecord_prefixzPrefix.0r¦   r‚   rŸ   s      r%   Útest_value_array_record_prefixz0TestJSONNormalize.test_value_array_record_prefixð   sS   € å  q¨! f ¨sÀ)ÐLÑLÔLˆÝ˜q˜c A 3˜Z°*°Ð>Ñ>Ô>ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó¶   — dddddœdddœdd	dœgd
œdœ}t          |ddg¬¦  «        }t          ddgddgdd	ggddg¬¦  «        }t          j        ||¦  «         d S )Nr2   r0   r(   r   r)   r+   r,   r-   r.   )r/   r3   ©r6   r4   r4   r3   r¥   r   r*   r¦   r‚   rÀ   s       r%   Útest_nested_object_record_pathz0TestJSONNormalize.test_nested_object_record_pathö   s®   € ð à(à#°5Ð9Ð9Ø&°eÐ<Ð<Ø)¸Ð?Ð?ððð ð

ð 

ˆõ   °6¸:Ð2FÐGÑGÔGˆÝØ�eˆ_˜y¨%Ð0°<ÀÐ2GÐHØ˜\Ð*ð
ñ 
ô 
ˆõ 	Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó¼   — t          |ddgdddgg¬¦  «        }dgdz  dgd	z  z   g d
¢g d¢g d¢dœ}t          ||j        ¬¦  «        }t          j        ||¦  «         d S )Nr   r   r   r   rŒ   r
   ry   r   rw   )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§   rƒ   r„   )r†   r&   rˆ   Úex_datar‰   s        r%   Útest_more_deeply_nestedz)TestJSONNormalize.test_more_deeply_nested
  s§   € ÝØ˜( HÐ-°YÀÈ6Ð@RÐ4Sð
ñ 
ô 
ˆð �w ‘{ i [°1¡_Ñ4ðð ð ðð ð ð AÐ@Ð@ð)
ð 
ˆõ. ˜W¨f¬nÐ=Ñ=Ô=ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó  — ddddidddœdd	dœd
ddœgdœddddidddœdddœgdœg}t          |dddddgg¦  «        }g d¢dgdz  dgdz  z   g d¢dgdz  dgdz  z   g d¢dœ}t          ||j        ¬¦  «        }t          j        ||¦  «         d S )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   rw   rv   )r1   r1   r1   r;   r;   ©r   r,   r.   r   r9   )r   r6   r5   úinfo.governorr*   r¦   rÉ   )r†   rª   rˆ   rÊ   r‰   s        r%   Útest_shallow_nestedz%TestJSONNormalize.test_shallow_nested(  s%  € ð #Ø!Ø# \Ð2à#°5Ð9Ð9Ø&°eÐ<Ð<Ø)¸Ð?Ð?ðð		ð 	ð  Ø!Ø# ]Ð3à%°TÐ:Ð:Ø'°tÐ<Ð<ðð	ð ð
ˆõ,  Ø�*˜w¨°f¸jÐ5IÐJñ
ô 
ˆð LÐKÐKØ�[ 1‘_¨ x°!¡|Ñ3Ø7Ð7Ð7Ø*˜^¨aÑ/°=°/ÀAÑ2EÑEØ;Ð;Ð;ð
ð 
ˆõ ˜W¨f¬nÐ=Ñ=Ô=ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 óÚ   — t          |dgddddggd¬¦  «        }g d¢g d	¢d
gdz  dgdz  z   dgdz  dgdz  z   dgdz  dgdz  z   dœ}t          |¦  «        }t          j        ||¦  «         d S )Nr3   r6   r5   r4   r/   Úignore©rª   r›   r�   ÚerrorsrÍ   rÎ   r2   rw   r   rv   r1   r;   r0   r:   )r   r*   r6   r5   rÏ   r‚   )r†   r<   rˆ   rÊ   r‰   s        r%   Ú-test_nested_meta_path_with_nested_record_pathz?TestJSONNormalize.test_nested_meta_path_with_nested_record_pathL  s·   € åØØ#˜Ø˜;¨°Ð(<Ð=Øð	
ñ 
ô 
ˆð LÐKÐKØ;Ð;Ð;Ø�[ 1‘_¨ x°!¡|Ñ3Ø˜ !™ t f¨q¡jÑ0Ø*˜^¨aÑ/°=°/ÀAÑ2EÑEð
ð 
ˆõ ˜WÑ%Ô%ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 óö   — dddddœdddœgdœg}d	}t          j        t          |¬
¦  «        5  t          |dddg¬¦  «         d d d ¦  «         n# 1 swxY w Y   t          |dddgd¬¦  «        }dD ]}||v sJ ‚Œ	d S )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Ð7Ø(°Ð9Ð9ððð ð	
ˆð QˆÝŒ]�:¨SÐ1Ñ1Ô1ð 	>ð 	>Ý˜4 ¨u°e¨nÐ=Ñ=Ô=Ð=ð	>ð 	>ð 	>ñ 	>ô 	>ð 	>ð 	>ð 	>ð 	>ð 	>ð 	>øøøð 	>ð 	>ð 	>ð 	>õ    f°E¸5°>ÈvÐVÑVÔVˆà7ð 	!ð 	!ˆCØ˜&�=�=�=�=�=ð	!ð 	!s   ­AÁAÁAc                 ó|   — dddddœdddœgdœg}d	d
g}t          |d|d¬¦  «        }|d	d
gk    sJ ‚dD ]}||v sJ ‚Œ	d S )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_modifiedu  s”   € ð Øà'°Ð7Ð7Ø(°Ð9Ð9ððð ð	
ˆð ˜%�.ˆÝ  f°7ÈÐOÑOÔOˆà˜5 %˜.Ò(Ð(Ð(Ð(Ø7ð 	!ð 	!ˆCØ˜&�=�=�=�=�=ð	!ð 	!r$   c                 óÎ  — t          |d         d¦  «        }t          |d         d         ¦  «        }t          j        ||¦  «         t          |ddd¬¦  «        }g }|D ]}|                     |d         ¦  «         Œt          |¦  «        }|                     d„ ¬¦  «        }t          j        dd	g¦  «                             d
dg¦  «        |d<   t          j        ||¦  «         d S )Nr   r3   r6   Úcounty_)r�   rÃ   c                 ó   — d| z   S )Nrî   r#   )Úxs    r%   ú<lambda>z6TestJSONNormalize.test_record_prefix.<locals>.<lambda>–  s
   € °YÀ±]€ r$   r¦   r2   r   rw   rv   )	r   r   rƒ   r„   rŽ   Úrenamer�   r�   r‘   r’   s        r%   Útest_record_prefixz$TestJSONNormalize.test_record_prefix‰  sò   € Ý 
¨1¤¨zÑ:Ô:ˆÝ˜Z¨œ]¨:Ô6Ñ7Ô7ˆÝ
Ô˜f hÑ/Ô/Ð/åØ˜
¨À	ð
ñ 
ô 
ˆð ˆØð 	-ð 	-ˆCØ�OŠO˜C 
œOÑ,Ô,Ð,Ð,Ý˜XÑ&Ô&ˆØ—?’?Ð+BÐ+B�?ÑCÔCˆÝœH i°Ð%8Ñ9Ô9×@Ò@À!ÀQÀÑHÔHˆ�Ñå
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 óü   — d                      d¦  «        }d                      d¦  «        ddgdddgdd	d
gi}t          |¦  «        }t          t          j        |¦  «        ¦  «        }t          j        ||¦  «         d S )NsK   [{"ÃœnicÃ¸de":0,"sub":{"A":1, "B":2}},{"ÃœnicÃ¸de":1,"sub":{"A":3, "B":4}}]Úutf8s	   ÃœnicÃ¸der   ru   zsub.Arw   zsub.Brv   ry   )Údecoder   r   ÚjsonÚloadsrƒ   r„   )r†   ÚtestjsonÚtestdatar‰   rˆ   s        r%   Útest_non_ascii_keyz$TestJSONNormalize.test_non_ascii_key›  s‰   € ðAç
Š&�‰.Œ.ð 	ð %×+Ò+¨FÑ3Ô3°a¸°VØ�a˜�VØ�a˜�Vð
ˆõ
 ˜XÑ&Ô&ˆå¥¤
¨8Ñ 4Ô 4Ñ5Ô5ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 óð   — t          |¦  «        }t          j        t          j        t          j        t          j        t          j        dœd dddddœg}t          |¦  «        }t	          j        ||¦  «         d S )N)r4   úinfo.created_atúinfo.last_updatedúauthor_name.firstúauthor_name.last_namer>   r?   rC   rD   ©r   r�   Únanr   rƒ   r„   )r†   rJ   rˆ   rÊ   r‰   s        r%   Útest_missing_fieldz$TestJSONNormalize.test_missing_field«  s   € åÐ 3Ñ4Ô4ˆõ œÝ#%¤6Ý%'¤VÝ%'¤VÝ)+¬ðð ð Ø#/Ø%1Ø%+Ø).ðð ð
ˆõ  ˜WÑ%Ô%ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   zmax_level,expectedrc   rd   re   rf   ra   rb   rl   )ri   rj   rn   rp   )ri   zUserField.IdzUserField.Namern   rp   c                 óÚ   — ddiddddœdœddddœdœgdd	id
ddœdddœgdœg}t          |dgdgdgg|¬¦  «        }t          ||j        j        ¬¦  «        }t	          j        ||¦  «         d S )Nra   rb   rc   rd   re   rf   rh   rk   rl   rÙ   rÚ   rÛ   rÞ   rß   )rn   ro   rp   Útagsro   rn   rp   )r›   r�   Ú	max_level)rª   r§   )r   r   r§   r˜   rƒ   Úassert_equal)r†   r  r‰   Ú
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Ð%Gðð ð
 &1Ø,3¸YÐ%GÐ%Gðð ð	ð ˜s˜à'°Ð7Ð7Ø(°Ð9Ð9ððð ð
ˆ
õ*  ØØ!˜
Ø�- ' Ð+Øð	
ñ 
ô 
ˆõ   X°v´~Ô7LÐMÑMÔMˆÝ
Œ˜ VÑ,Ô,Ð,Ð,Ð,r$   c                 ó†   — t          dddiig¦  «        }t          ddddiigid¦  «        }t          j        ||¦  «         d S )Nr®   r¯   ru   Údummy)r   rƒ   r„   )r†   Údf1Údf2s      r%   Ú!test_nested_flattening_consistentz3TestJSONNormalize.test_nested_flattening_consistent
  sT   € å˜s S¨! H˜oÐ.Ñ/Ô/ˆÝ˜g¨¨s°A¨h¨Ð'8Ð9¸7ÑCÔCˆõ 	Ô˜c 3Ñ'Ô'Ð'Ð'Ð'r$   c                 ó’   — t          d|dœdddigdœgdg¬¦  «        }t          ddidg¬	¦  «        }t          j        ||¦  «         d S )
NÚTexasrÆ   r2   Úirv   r4   r¥   r   )Úindex)r   r   rƒ   r  )r†   Únulls_fixturerˆ   r‰   s       r%   Útest_nonetype_record_pathz+TestJSONNormalize.test_nonetype_record_path  sr   € õ  à!¨=Ð9Ð9Ø#¨s°A¨h¨ZÐ8Ð8ðð  ˜ð
ñ 
ô 
ˆõ ˜c 1˜X¨a¨SÐ1Ñ1Ô1ˆÝ
Œ˜ Ñ)Ô)Ð)Ð)Ð)r$   Úvalue)ÚfalseÚtruez{}Ú1z"text"c                 óà   — t          j        |¦  «        }d|dœ}d}|› d|› d|› d�}t          j        t          |¬¦  «        5  t          |g|g¬¦  «         d d d ¦  «         d S # 1 swxY w Y   d S )	Nr  rÆ   r4   z 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_errors  sú   € õ ”z %Ñ(Ô(ˆØ&°Ð=Ð=ˆ
Øˆ	àð $ð $¨|ð $ð $Àyð $ð $ð $ð 	õ Œ]�9¨CÐ0Ñ0Ô0ð 	Bð 	BÝ˜J˜<°i°[ÐAÑAÔAÐAð	Bð 	Bð 	Bñ 	Bô 	Bð 	Bð 	Bð 	Bð 	Bð 	Bð 	Bð 	Bøøøð 	Bð 	Bð 	Bð 	Bð 	Bð 	Bs   ÁA#Á#A'Á*A'c                 óÞ   — d}t          t          j        |¦  «        dgdg¬¦  «        }t          dgdgt	          j        dgt          ¬¦  «        d	œ¦  «        }t          j        ||¦  «         d S )
Nz,[{"id": 99, "data": [{"one": 1, "two": 2}]}]rª   Úidrš   ru   rv   éc   )Údtype)ÚoneÚtwor   )	r   r÷   rø   r   r�   r�   Úobjectrƒ   r„   rÀ   s       r%   Útest_meta_non_iterablez(TestJSONNormalize.test_meta_non_iterable,  su   € àAˆå¥¤
¨4Ñ 0Ô 0¸v¸hÈdÈVÐTÑTÔTˆÝØ�C  ­2¬8°R°DÅÐ+GÑ+GÔ+GÐHÐHñ
ô 
ˆõ 	Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó    ‡— ˆfd„}t           |¦   «         ¦  «        }t          ‰d         d         ¦  «        }t          j        ||¦  «         d S )Nc               3   ó4   •K  — ‰ d         d         E d {V —† d S )Nr   r3   r#   )r<   s   €r%   Úgenerator_dataz8TestJSONNormalize.test_generator.<locals>.generator_data9  s.   øè è € Ø! !”} ZÔ0Ð0Ð0Ð0Ð0Ð0Ð0Ð0Ð0Ð0r$   r   r3   r‚   )r†   r<   r)  rˆ   r‰   s    `   r%   Útest_generatorz TestJSONNormalize.test_generator6  sb   ø€ ð	1ð 	1ð 	1ð 	1ð 	1õ    Ñ 0Ô 0Ñ1Ô1ˆÝ˜Z¨œ]¨:Ô6Ñ7Ô7ˆå
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó’   — dddidœddœ}t          |d¬¦  «        }t          g d	¢gg d
¢¬¦  «        }t          j        ||¦  «         d S )Nr   Úl3r   )Úa1Úl2ry   )Ú_idÚggr°   r±   )ry   r   r   )r0  Ú_id_a1Ú	_id_l2_l3r¦   r‚   rÀ   s       r%   Ú'test_top_column_with_leading_underscorez9TestJSONNormalize.test_top_column_with_leading_underscoreA  se   € à ¨¨q¨	Ð2Ð2¸!Ð<Ð<ˆÝ ¨#Ð.Ñ.Ô.ˆÝ˜j˜j˜j˜\Ð3PÐ3PÐ3PÐQÑQÔ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û   r  r
  r  r  r  r&  r*  r3  r#   r$   r%   rs   rs   Œ   sþ  € € € € € ð0ð 0ð 0ð0ð 0ð 0ð&0ð 0ð 0ð0ð 0ð 0ð
 „[×ÒØ+à�Aˆh˜˜a˜Ð! 4¨Ð.Ø�S˜!�H˜s A˜hÐ'Ð(¨#¨tÐ4Ø*¨DÐ2EÐFØ�4Ð,Ð-ð		
ñô ð4ð 4ñô ð4ð=ð =ð =ð.0ð 0ð 0ð0ð 0ð 0ð0ð 0ð 0ð(0ð 0ð 0ð<"0ð "0ð "0ðH0ð 0ð 0ð(!ð !ð !ð*!ð !ð !ð(0ð 0ð 0ð$0ð 0ð 0ð 0ð 0ð 0ð, „[×ÒØð ð &1Ø,3¸YÐ%GÐ%GØ&,¨iÐ%8Ø"% s ð	ð ð &1Ø,3¸YÐ%GÐ%GØ&,¨iÐ%8Ø"% s ð	ð ððð$ ð &1Ø(/Ø*3Ø&,¨iÐ%8Ø"% s ðð ð &1Ø(/Ø*3Ø&,¨iÐ%8Ø"% s ðð ððð%%	
ñ(ô (ðR-ð -ñS(ô (ðR-ð@(ð (ð (ð*ð *ð *ð „[×Ò˜WÐ&LÐ&LÐ&LÑMÔMð
Bð 
Bñ NÔMð
Bð0ð 0ð 0ð	0ð 	0ð 	0ð0ð 0ð 0ð 0ð 0r$   rs   c                   óô   — e Zd Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Z	d„ Z
d	„ Zd
„ Zd„ Zej                             ddddddddœgfdddiddddœdœddidœgfddddddœddœgfg¦  «        d„ ¦   «         Zd„ Zd„ ZdS )ÚTestNestedToRecordc                 óL   — dddœdddœg}t          |¦  «        }|}||k    sJ ‚d S )Nru   rv   )Úflat1Úflat2rw   ry   )Úflat3r>  r   r…   s       r%   Útest_flat_stays_flatz'TestNestedToRecord.test_flat_stays_flatK  sE   € Ø aÐ(Ð(°AÀÐ*BÐ*BÐCˆÝ! $Ñ'Ô'ˆØˆØ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c                 óP   — ddddœdœ}t          |¦  «        }ddddœ}||k    sJ ‚d S )Nru   rv   ©rx   Úd)r=  Údict1)údict1.cúdict1.dr=  r   rÀ   s       r%   Útest_one_level_deep_flattensz/TestNestedToRecord.test_one_level_deep_flattensQ  sJ   € Ø¨1°1Ð%5Ð%5Ð6Ð6ˆå! $Ñ'Ô'ˆØ ¨Q¸Ð;Ð;ˆà˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c                 ód   — ddddœdddœddœdœ}t          |¦  «        }dddddddœ}||k    sJ ‚d S )Nru   rv   rB  )ÚerC  )r=  rD  Únested)rE  rF  r=  znested.dz
nested.e.cz
nested.e.dr   rÀ   s       r%   Útest_nested_flattensz'TestNestedToRecord.test_nested_flattensY  su   € àØ 1Ð%Ð%Ø"#¨!Ð,Ð,°1Ð5Ð5ð
ð 
ˆõ " $Ñ'Ô'ˆàØØØØØð
ð 
ˆð ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c                 ó˜   — d}t          j        t          |¬¦  «        5  t          |ddd¬¦  «         d d d ¦  «         d S # 1 swxY w Y   d S )Nú^Key 'name' not found. To replace missing values of 'name' with np.nan, pass in errors='ignore'r£   rW   r   ÚraiserÓ   ©r¨   r©   ÚKeyErrorr   ©r†   r_   rç   s      r%   Útest_json_normalize_errorsz-TestNestedToRecord.test_json_normalize_errorsl  sª   € ð:ð 	õ Œ]�8¨3Ð/Ñ/Ô/ð 	ð 	ÝØ%Ø'ØØð	ñ ô ð ð	ð 	ð 	ñ 	ô 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	øøøð 	ð 	ð 	ð 	ð 	ð 	s   ž?¿AÁAc                 ó¬   — t          |ddd¬¦  «        }g d¢dddd	d
t          j        gg}g d¢}t          ||¬¦  «        }t	          j        ||¦  «         d S )NrW   r   rÒ   rÓ   )rM   rN   rO   r;   rP   rL   rY   rZ   r[   r\   r]   )rQ   rR   rS   r6   rT   r   r¦   r  ©r†   r_   rˆ   rÊ   r§   r‰   s         r%   Útest_missing_metaz$TestNestedToRecord.test_missing_meta}  s€   € õ  Ø!¨{ÀÐPXð
ñ 
ô 
ˆð DÐCÐCØ�< °°u½b¼fÐEð
ˆð GÐFÐFˆÝ˜W¨gÐ6Ñ6Ô6ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ó¦  — dd ddiddigdœ}t          |dddd	ggd
¬¦  «        }ddt          j        gddt          j        gg}g d¢}t          ||¬¦  «                             dt
          i¦  «        }t          j        ||¦  «         t          j	        t          d¬¦  «        5  t          |dddd	ggd¬¦  «         d d d ¦  «         d S # 1 swxY w Y   d S )NrÜ   r“   ru   rv   )r�   Únested_metar  r  r�   rW  ÚleafrÒ   )r›   r�   rÔ   )r“   r�   únested_meta.leafr¦   rY  z'leaf' not foundr£   rN  )r   r�   r  r   Ú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ÐVˆÝØØØ˜=¨&Ð1Ð2Øð	
ñ 
ô 
ˆð �u�bœfÐ%¨¨5µ"´&Ð'9Ð:ˆØ5Ð5Ð5ˆÝ˜W¨gÐ6Ñ6Ô6×=Ò=Ø¥Ð(ñ
ô 
ˆõ 	Ô˜f hÑ/Ô/Ð/õ Œ]�8Ð+=Ð>Ñ>Ô>ð 	ð 	ÝØØ#Ø˜}¨fÐ5Ð6Øð	ñ ô ð ð	ð 	ð 	ñ 	ô 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	øøøð 	ð 	ð 	ð 	ð 	ð 	s   Â!CÃC
ÃC
c                 óœ   — d}t          j        t          |¬¦  «        5  t          |ddgdd¬¦  «         d d d ¦  «         d S # 1 swxY w Y   d S )NrM  r£   rX   r   r   rN  rÓ   rO  rQ  s      r%   Ú5test_missing_meta_multilevel_record_path_errors_raisezHTestNestedToRecord.test_missing_meta_multilevel_record_path_errors_raise§  s¯   € ð
:ð 	õ Œ]�8¨3Ð/Ñ/Ô/ð 	ð 	ÝØ%Ø2°HÐ=ØØð	ñ ô ð ð	ð 	ð 	ñ 	ô 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	øøøð 	ð 	ð 	ð 	ð 	ð 	s   žAÁAÁAc                 ó¨   — t          |ddgdd¬¦  «        }ddgdt          j        gg}d	dg}t          ||¬
¦  «        }t	          j        ||¦  «         d S )NrX   r   r   rÒ   rÓ   rV   rL   r^   rU   r¦   r  rT  s         r%   Ú6test_missing_meta_multilevel_record_path_errors_ignorezITestNestedToRecord.test_missing_meta_multilevel_record_path_errors_ignore·  s{   € õ  Ø!Ø.°Ð9ØØð	
ñ 
ô 
ˆð ˜gÐ&Ø�2œ6Ð"ð
ˆð  Ð'ˆÝ˜W¨gÐ6Ñ6Ô6ˆÝ
Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   c                 ót   — d dddœdœdddœdd	dœdœg}t          |¦  «        }d ddd
œdd	dddœg}||k    sJ ‚d S )NÚSmithÚ	AppleseedrE   rH   r>   r?   r@   rC   rD   )r4   rÿ   r   )rÿ   r   rý   rþ   r   rÀ   s       r%   Útest_donot_drop_nonevaluesz-TestNestedToRecord.test_donot_drop_nonevaluesÉ  sš   € ð °GÈ+Ð*VÐ*VÐWÐWà'3À\ÐRÐRØ)/¸eÐDÐDðð ð
ˆõ " $Ñ'Ô'ˆð Ø%,Ø)4ðð ð &,Ø).Ø#/Ø%1ð	ð ð
ˆð ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c           
      ól   — d ddd d d ddddœdœiidœ}t          |¦  «        }d d d d dddd	œ}||k    sJ ‚d S )
Nr   r6   ç    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.zr   rÀ   s       r%   Ú$test_nonetype_top_level_bottom_levelz7TestNestedToRecord.test_nonetype_top_level_bottom_levelã  s’   € ð àØØ"à"&Ø&*Ø!3Ø!4Ø!3ð&ð &ð	ð 	ððð
ð 
ˆõ" " $Ñ'Ô'ˆàØ)-Ø37Ø7;Ø2DØ2EØ2Dð
ð 
ˆð ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c           	      óp   — d d d d d ddddœdœdœdœdœ}t          |¦  «        }d d d d d dddd	œ}||k    sJ ‚d S )
Nre  rf  rg  )rh  rð   ri  rj  rk  )r   r6   )r   r   rl  )r   zlocation.idzlocation.country.idrn  ro  rp  rq  rr  r   rÀ   s       r%   Útest_nonetype_multiple_levelsz0TestNestedToRecord.test_nonetype_multiple_levels  sœ   € ð ààà"à&*Ø!3Ø!4Ø!3ð	&ð &ðð ðð ðð ð
ð 
ˆõ$ " $Ñ'Ô'ˆàØØ#'Ø)-Ø7;Ø2DØ2EØ2Dð	
ð 	
ˆð ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   zmax_level, expectedNrb   rc   rd   re   rl   )úCreatedBy.NameúLookup.TextFieldzLookup.UserField.IdzLookup.UserField.NameúImage.ar   ra   rf   rh   rk   rm   ru   )rv  rw  zLookup.UserFieldrx  c                 ó8   — t          ||¬¦  «        }||k    sJ ‚d S )N©r  r   )r†   r  r‰   rq   Úoutputs        r%   Útest_with_max_levelz&TestNestedToRecord.test_with_max_level%  s/   € õV "Ð";ÀyÐQÑQÔQˆØ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c           	      ó„   — d}dddddœddd	d
ddidœdœdœidœiig}dddd	d
ddœg}t          ||¬¦  «        }||k    sJ ‚d S )Néd   rn   ÚuserÚLeoÚThomson)Ú	firstnameÚLastNameÚfatherÚ	Father001Ú	Father002Ú	Father003ra   Ú	Father004)r   r„  )ra   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.Namerz  r   )r†   r  Ú
input_datar‰   r{  s        r%   Útest_with_large_max_levelz,TestNestedToRecord.test_with_large_max_levelS  s¼   € àˆ	ð ØØ.3ÀÐ KÐ Kà$Ø(3à,7à0;Ø39¸;Ð2Gð/&ð /&ð+"ð +"ð	'ð 	'ð(ðð ððð
ˆ
ð. 27Ø09Ø:EØALØHSØOZðð ð	
ˆõ " *¸	ÐBÑBÔBˆØ˜Ò!Ð!Ð!Ð!Ð!Ð!r$   c           	      ój  — ddddidœddddidœdd	d
didœdœ}t          |¦  «        }g d¢|_        t          |¦  «        }t          g d¢g d¢dt          j        t          j        gt          j        dt          j        gt          j        t          j        dgdœ¦  «        }t          j        ||¦  «         d S )Nru   ÚFoork   )r   r   Úelementsrv   ÚBarrl   rw   ÚBazrx   )r   ru   rv   r–   )r�  r�  r�  g      ð?g       @g      @)r   r   z
elements.az
elements.bz
elements.c)r   r  r   r   r�   r  rƒ   r„   )r†   rª   Úsrˆ   r‰   s        r%   Útest_series_non_zero_indexz-TestNestedToRecord.test_series_non_zero_indexx  sÖ   € ð  °S¸!°HÐ=Ð=Ø °S¸!°HÐ=Ð=Ø °S¸!°HÐ=Ð=ð
ð 
ˆõ
 �4‰LŒLˆØ�)�)ˆŒÝ Ñ"Ô"ˆÝà�i�iØ-Ð-Ð-Ø"¥B¤F­B¬FÐ3Ý!œv s­B¬FÐ3Ý!œv¥r¤v¨sÐ3ðð ñ
ô 
ˆõ 	Ô˜f hÑ/Ô/Ð/Ð/Ð/r$   )r4  r5  r6  r@  rG  rK  rR  rU  r[  r]  r_  rc  rs  ru  r¨   r7  r8  r|  r‹  r’  r#   r$   r%   r;  r;  J  s²  € € € € € ð"ð "ð "ð"ð "ð "ð"ð "ð "ð&ð ð ð"0ð 0ð 0ðð ð ð6ð ð ð 0ð 0ð 0ð$"ð "ð "ð4"ð "ð "ð@ "ð  "ð  "ðD „[×ÒØð ð +4Ø,7Ø/6Ø1:Ø#&ðð ððð ð '-¨iÐ%8à)4Ø07ÀÐ)KÐ)Kð#ð #ð #& s ðð ð	ðð ð +4Ø,7Ø3:ÀIÐ,NÐ,NØ#&ð	ð ðð
ð5%	
ñ(ô (ðR"ð "ñS(ô (ðR"ð
#"ð #"ð #"ðJ0ð 0ð 0ð 0ð 0r$   r;  )r÷   Únumpyr�   r¨   Úpandasr   r   r   r   Úpandas._testingÚ_testingrƒ   Úpandas.io.json._normalizer   Úfixturer&   r<   rJ   r_   rq   rs   r;  r#   r$   r%   ú<module>r™     s„  ðØ €€€à Ð Ð Ð Ø €€€ðð ð ð ð ð ð ð ð ð ð ð ð Ð Ð Ð Ð Ð à 6Ð 6Ð 6Ð 6Ð 6Ð 6ð „ð#ð #ñ „ð#ðL „ðð ñ „ðð0 „ðð ñ „ðð „ðð ñ „ðð< „ðð ñ „ðð {0ð {0ð {0ð {0ð {0ñ {0ô {0ð {0ð|A0ð A0ð A0ð A0ð A0ñ A0ô A0ð A0ð A0ð A0r$   