Ë
    ¤ehJ-  ã                  óJ  — d Z ddlmZ ddlmZmZmZ ddlZddlm	Z	 ddl
mZ ddlmZ ddlmZ dd	lmZ dd
lmZ ddlmZmZmZmZ ddlmZmZmZmZ ddlm Z  ddl!m"c m#Z$ ddl%m&Z& erddl'm(Z(m)Z) ddlm*Z* ddl+m,Z, dZ-dd„Z.d„ Z/dd„Z0dd„Z1	 	 	 d	 	 	 	 	 	 	 	 	 dd„Z2dd„Z3y)zH
Table Schema builders

https://specs.frictionlessdata.io/table-schema/
é    )Úannotations)ÚTYPE_CHECKINGÚAnyÚcastN)Úlib)Úujson_loads)Ú	timezones)Úfreq_to_period_freqstr)Úfind_stack_level)Ú	_registry)Úis_bool_dtypeÚis_integer_dtypeÚis_numeric_dtypeÚis_string_dtype)ÚCategoricalDtypeÚDatetimeTZDtypeÚExtensionDtypeÚPeriodDtype)Ú	DataFrame)Ú	to_offset)ÚDtypeObjÚJSONSerializable)ÚSeries)Ú
MultiIndexz1.4.0c                ó  — t        | «      ryt        | «      ryt        | «      ryt        j                  | d«      st        | t        t        f«      ryt        j                  | d«      ryt        | t        «      ryt        | «      ry	y)
aœ  
    Convert a NumPy / pandas type to its corresponding json_table.

    Parameters
    ----------
    x : np.dtype or ExtensionDtype

    Returns
    -------
    str
        the Table Schema data types

    Notes
    -----
    This table shows the relationship between NumPy / pandas dtypes,
    and Table Schema dtypes.

    ==============  =================
    Pandas type     Table Schema type
    ==============  =================
    int64           integer
    float64         number
    bool            boolean
    datetime64[ns]  datetime
    timedelta64[ns] duration
    object          str
    categorical     any
    =============== =================
    ÚintegerÚbooleanÚnumberÚMÚdatetimeÚmÚdurationÚanyÚstring)
r   r   r   r   Úis_np_dtypeÚ
isinstancer   r   r   r   )Úxs    úZ/var/www/skyplay_api_hub/venv/lib/python3.12/site-packages/pandas/io/json/_table_schema.pyÚas_json_table_typer)   5   sp   € ô< ˜ÔØÜ	�qÔ	ØÜ	˜!Ô	ØÜ	�‰˜˜CÔ	 ¤J¨q´?ÄKÐ2PÔ$QØÜ	�‰˜˜CÔ	 ØÜ	�A”~Ô	&ØÜ	˜Ô	Øàó    c                ó¨  — t        j                  | j                  j                  Ž rŸ| j                  j                  }t	        |«      dk(  r:| j                  j
                  dk(  r!t        j                  dt        «       ¬«       | S t	        |«      dkD  r1t        d„ |D «       «      rt        j                  dt        «       ¬«       | S | j                  «       } | j                  j                  dkD  r:t        j                  | j                  j                  «      | j                  _        | S | j                  j
                  xs d| j                  _        | S )z?Sets index names to 'index' for regular, or 'level_x' for Multié   Úindexz-Index name of 'index' is not round-trippable.)Ú
stacklevelc              3  ó>   K  — | ]  }|j                  d «      –— Œ y­w)Úlevel_N)Ú
startswith)Ú.0r'   s     r(   ú	<genexpr>z$set_default_names.<locals>.<genexpr>n   s   è ø€ Ò!F¸Q !§,¡,¨x×"8Ñ!Fùs   ‚z<Index names beginning with 'level_' are not round-trippable.)ÚcomÚall_not_noner-   ÚnamesÚlenÚnameÚwarningsÚwarnr   r#   ÚcopyÚnlevelsÚfill_missing_names)ÚdataÚnmss     r(   Úset_default_namesr@   e   sù   € ä
×Ñ˜Ÿ™×)Ñ)Ñ*Ø�j‰j×ÑˆÜˆs‹8�qŠ=˜TŸZ™ZŸ_™_°Ò7Ü�M‰MØ?Ü+Ó-õð ˆô �‹X˜Š\œcÑ!FÀ#Ô!FÔFÜ�M‰MØNÜ+Ó-õð ˆà�9‰9‹;€DØ‡z�z×Ñ˜AÒÜ×1Ñ1°$·*±*×2BÑ2BÓCˆ�
‰
Ôð €Kð Ÿ*™*Ÿ/™/Ò4¨Wˆ�
‰
ŒØ€Kr*   c                ó$  — | j                   }| j                  €d}n| j                  }|t        |«      dœ}t        |t        «      r/|j
                  }|j                  }dt        |«      i|d<   ||d<   |S t        |t        «      r|j                  j                  |d<   |S t        |t        «      rAt        j                  |j                  «      rd|d<   |S |j                  j                  |d<   |S t        |t         «      r|j                  |d	<   |S )
NÚvalues)r8   ÚtypeÚenumÚconstraintsÚorderedÚfreqÚUTCÚtzÚextDtype)Údtyper8   r)   r&   r   Ú
categoriesrF   Úlistr   rG   Úfreqstrr   r	   Úis_utcrI   Úzoner   )ÚarrrK   r8   ÚfieldÚcatsrF   s         r(   Ú!convert_pandas_type_to_json_fieldrT   }   s  € Ø�I‰I€Eà
‡x�xÐØ‰à�x‰xˆàÜ" 5Ó)ñ*€Eô
 �%Ô)Ô*Ø×ÑˆØ—-‘-ˆà &¬¨T«
Ð3ˆˆmÑØ"ˆˆiÑð €Lô 
�Eœ;Ô	'ØŸ
™
×*Ñ*ˆˆf‰ð €Lô 
�Eœ?Ô	+Ü×Ñ˜EŸH™HÔ%àˆE�$‰Kð €Lð  Ÿ(™(Ÿ-™-ˆE�$‰Kð €Lô 
�Eœ>Ô	*Ø!ŸJ™JˆˆjÑØ€Lr*   c                ó  — | d   }|dk(  ry|dk(  r| j                  dd«      S |dk(  r| j                  dd«      S |d	k(  r| j                  dd
«      S |dk(  ry|dk(  rd| j                  d«      r	d| d   › d�S | j                  d«      r8t        | d   «      }|j                  |j                  }}t	        ||«      }d|› d�S y|dk(  r;d| v rd| v rt        | d   d   | d   ¬«      S d| v rt        j                  | d   «      S yt        d|› �«      ‚)a  
    Converts a JSON field descriptor into its corresponding NumPy / pandas type

    Parameters
    ----------
    field
        A JSON field descriptor

    Returns
    -------
    dtype

    Raises
    ------
    ValueError
        If the type of the provided field is unknown or currently unsupported

    Examples
    --------
    >>> convert_json_field_to_pandas_type({"name": "an_int", "type": "integer"})
    'int64'

    >>> convert_json_field_to_pandas_type(
    ...     {
    ...         "name": "a_categorical",
    ...         "type": "any",
    ...         "constraints": {"enum": ["a", "b", "c"]},
    ...         "ordered": True,
    ...     }
    ... )
    CategoricalDtype(categories=['a', 'b', 'c'], ordered=True, categories_dtype=object)

    >>> convert_json_field_to_pandas_type({"name": "a_datetime", "type": "datetime"})
    'datetime64[ns]'

    >>> convert_json_field_to_pandas_type(
    ...     {"name": "a_datetime_with_tz", "type": "datetime", "tz": "US/Central"}
    ... )
    'datetime64[ns, US/Central]'
    rC   r$   Úobjectr   rJ   Úint64r   Úfloat64r   Úboolr"   Útimedelta64r    rI   zdatetime64[ns, ú]rG   zperiod[zdatetime64[ns]r#   rE   rF   rD   )rL   rF   z#Unsupported or invalid field type: )	Úgetr   Únr8   r
   r   ÚregistryÚfindÚ
ValueError)rR   ÚtypÚoffsetÚfreq_nÚ	freq_namerG   s         r(   Ú!convert_json_field_to_pandas_typere   �   sG  € ðR �‰-€CØ
ˆh‚ØØ	�	Ò	Ø�y‰y˜ WÓ-Ð-Ø	�ŠØ�y‰y˜ YÓ/Ð/Ø	�	Ò	Ø�y‰y˜ VÓ,Ð,Ø	�
Ò	ØØ	�
Ò	Ø�9‰9�TŒ?Ø$ U¨4¡[ M°Ð3Ð3Ø�Y‰Y�vÔä˜u V™}Ó-ˆFØ &§¡¨&¯+©+�IˆFÜ)¨&°)Ó<ˆDà˜T˜F !Ð$Ð$à#Ø	�ŠØ˜EÑ! i°5Ñ&8Ü#Ø  Ñ/°Ñ7ÀÀyÑAQôð ð ˜5Ñ Ü—=‘=  zÑ!2Ó3Ð3àä
Ð:¸3¸%Ð@Ó
AÐAr*   c                óR  — |du rt        | «      } i }g }|r¶| j                  j                  dkD  ryt        d| j                  «      | _        t	        | j                  j
                  | j                  j                  «      D ]&  \  }}t        |«      }||d<   |j                  |«       Œ( n$|j                  t        | j                  «      «       | j                  dkD  r3| j                  «       D ]  \  }	}
|j                  t        |
«      «       Œ! n|j                  t        | «      «       ||d<   |rf| j                  j                  rP|€N| j                  j                  dk(  r| j                  j                  g|d<   n!| j                  j                  |d<   n|�||d<   |r	t        |d<   |S )a‚  
    Create a Table schema from ``data``.

    Parameters
    ----------
    data : Series, DataFrame
    index : bool, default True
        Whether to include ``data.index`` in the schema.
    primary_key : bool or None, default True
        Column names to designate as the primary key.
        The default `None` will set `'primaryKey'` to the index
        level or levels if the index is unique.
    version : bool, default True
        Whether to include a field `pandas_version` with the version
        of pandas that last revised the table schema. This version
        can be different from the installed pandas version.

    Returns
    -------
    dict

    Notes
    -----
    See `Table Schema
    <https://pandas.pydata.org/docs/user_guide/io.html#table-schema>`__ for
    conversion types.
    Timedeltas as converted to ISO8601 duration format with
    9 decimal places after the seconds field for nanosecond precision.

    Categoricals are converted to the `any` dtype, and use the `enum` field
    constraint to list the allowed values. The `ordered` attribute is included
    in an `ordered` field.

    Examples
    --------
    >>> from pandas.io.json._table_schema import build_table_schema
    >>> df = pd.DataFrame(
    ...     {'A': [1, 2, 3],
    ...      'B': ['a', 'b', 'c'],
    ...      'C': pd.date_range('2016-01-01', freq='d', periods=3),
    ...     }, index=pd.Index(range(3), name='idx'))
    >>> build_table_schema(df)
    {'fields': [{'name': 'idx', 'type': 'integer'}, {'name': 'A', 'type': 'integer'}, {'name': 'B', 'type': 'string'}, {'name': 'C', 'type': 'datetime'}], 'primaryKey': ['idx'], 'pandas_version': '1.4.0'}
    Tr,   r   r8   ÚfieldsÚ
primaryKeyÚpandas_version)r@   r-   r<   r   ÚzipÚlevelsr6   rT   ÚappendÚndimÚitemsÚ	is_uniquer8   ÚTABLE_SCHEMA_VERSION)r>   r-   Úprimary_keyÚversionÚschemarg   Úlevelr8   Ú	new_fieldÚcolumnÚss              r(   Úbuild_table_schemarx   ê   su  € ðp ��}Ü  Ó&ˆà€FØ€FáØ�:‰:×Ñ Ò!Ü˜l¨D¯J©JÓ7ˆDŒJÜ" 4§:¡:×#4Ñ#4°d·j±j×6FÑ6FÓGò )‘��tÜ=¸eÓD�	Ø$(�	˜&Ñ!Ø—‘˜iÕ(ñ)ð
 �M‰MÔ;¸D¿J¹JÓGÔHà‡y�y�1‚}ØŸ™›ò 	@‰IˆF�AØ�M‰MÔ;¸AÓ>Õ?ñ	@ð 	�‰Ô7¸Ó=Ô>à€Fˆ8ÑÙ�—‘×%Ò%¨+Ð*=Ø�:‰:×Ñ Ò"Ø$(§J¡J§O¡OÐ#4ˆF�<Ò à#'§:¡:×#3Ñ#3ˆF�<Ò Ø	Ð	 Ø*ˆˆ|ÑáÜ#7ˆÐÑ Ø€Mr*   c                ó˜  — t        | |¬«      }|d   d   D �cg c]  }|d   ‘Œ	 }}t        |d   |¬«      |   }|d   d   D �ci c]  }|d   t        |«      “Œ }}d|j                  «       v rt	        d«      ‚|j                  |«      }d	|d   v r«|j                  |d   d	   «      }t        |j                  j                  «      d
k(  r,|j                  j                  dk(  rd|j                  _
        |S |j                  j                  D �cg c]  }|j                  d«      rdn|‘Œ c}|j                  _	        |S c c}w c c}w c c}w )a  
    Builds a DataFrame from a given schema

    Parameters
    ----------
    json :
        A JSON table schema
    precise_float : bool
        Flag controlling precision when decoding string to double values, as
        dictated by ``read_json``

    Returns
    -------
    df : DataFrame

    Raises
    ------
    NotImplementedError
        If the JSON table schema contains either timezone or timedelta data

    Notes
    -----
        Because :func:`DataFrame.to_json` uses the string 'index' to denote a
        name-less :class:`Index`, this function sets the name of the returned
        :class:`DataFrame` to ``None`` when said string is encountered with a
        normal :class:`Index`. For a :class:`MultiIndex`, the same limitation
        applies to any strings beginning with 'level_'. Therefore, an
        :class:`Index` name of 'index'  and :class:`MultiIndex` names starting
        with 'level_' are not supported.

    See Also
    --------
    build_table_schema : Inverse function.
    pandas.read_json
    )Úprecise_floatrs   rg   r8   r>   )ÚcolumnsrZ   z<table="orient" can not yet read ISO-formatted Timedelta datarh   r,   r-   Nr0   )r   r   re   rB   ÚNotImplementedErrorÚastypeÚ	set_indexr7   r-   r6   r8   r1   )Újsonrz   ÚtablerR   Ú	col_orderÚdfÚdtypesr'   s           r(   Úparse_table_schemar„   F  sU  € ôH ˜¨MÔ:€EØ,1°(©O¸HÑ,EÖF 5��v“ÐF€IÐFÜ	�5˜‘=¨)Ô	4°YÑ	?€Bð ˜8‘_ XÑ.öàð 	ˆf‰Ô8¸Ó?Ñ?ð€Fð ð ˜Ÿ™›Ñ'Ü!ØJó
ð 	
ð 
�‰�6Ó	€Bà�u˜X‘Ñ&Ø�\‰\˜% ™/¨,Ñ7Ó8ˆÜˆr�x‰x�~‰~Ó !Ò#Ø�x‰x�}‰} Ò'Ø $�—‘”ð €Ið @B¿x¹x¿~¹~öØ:;˜Ÿ™ XÔ.‘°AÑ5òˆB�H‰HŒNð €Iùò5 Gùòùò&s   ˜D=ÁEÄE)r'   r   ÚreturnÚstr)r…   údict[str, JSONSerializable])r…   zstr | CategoricalDtype)TNT)
r>   zDataFrame | Seriesr-   rY   rq   zbool | Nonerr   rY   r…   r‡   )rz   rY   r…   r   )4Ú__doc__Ú
__future__r   Útypingr   r   r   r9   Úpandas._libsr   Úpandas._libs.jsonr   Úpandas._libs.tslibsr	   Úpandas._libs.tslibs.dtypesr
   Úpandas.util._exceptionsr   Úpandas.core.dtypes.baser   r^   Úpandas.core.dtypes.commonr   r   r   r   Úpandas.core.dtypes.dtypesr   r   r   r   Úpandasr   Úpandas.core.commonÚcoreÚcommonr4   Úpandas.tseries.frequenciesr   Úpandas._typingr   r   r   Úpandas.core.indexes.multir   rp   r)   r@   rT   re   rx   r„   © r*   r(   ú<module>r›      sÍ   ðñõ
 #÷ñ ó
 å Ý )Ý )Ý =Ý 4å 9÷ó ÷ó õ ß  Ð  å 0á÷õ
 Ý4ð Ð ó-ò`ó0ó@JBð^ Ø#Øð	YØ
ðYàðYð ðYð ð	Yð
 !óYôx?r*   