LMhUddlZddlZddlmZmZmZmZddlZddl m Z de de dej fdZ idejd ejd ejd ejd ejd ejdejde de de de de de dejdejdejdejejejejdZee efed<ddiddidZee ee ee efffed <d!Zdd"d#e de d$edee deej eeee fej fff d%Zd&e dee defd'Zd(ede dee defd)Zd&e d$edefd*ZdS)+N)AnyCallableOptionalUnion)dataset_download sql_querypathreturnctj|5}tj||}|cdddS#1swxYwYdSN)sqlite3connectpdread_sql_query)rr conndfs Y/var/www/html/test/jupyter/venv/lib/python3.11/site-packages/kagglehub/pandas_datasets.pywrapped_read_sql_queryrs   $  y$ / /s 9==z.csv.tsvz.json.jsonlz.xmlz.parquetz.featherz.sqlitez.sqlite3z.dbz.db3z.s3dbz.dl3z.xlsz.xlsxz.xlsmz.xlsb)z.odfz.odsz.odt%SUPPORTED_READ_FUNCTIONS_BY_EXTENSIONsep linesT)rrSTATIC_KWARGS_BY_EXTENSIONz/Loading from a SQLite file requires a SQL query) pandas_kwargshandlerc8|in|}tj|d}t||}t ||} |t |||it ||}n'#t$r}d|} t| |d}~wwxYw|S)aCreates pandas DataFrame(s) from a file in the dataset Args: handle: (string) The dataset handle path: (string) Path to a file within the dataset pandas_kwargs: (dict) Optional set of kwargs to pass to the pandas `read_*` method while constructing the DataFrame(s) sql_query: (string) Argument to be used for SQLite files. Required when reading a SQLite file. See pandas documentation for details: https://pandas.pydata.org/docs/reference/api/pandas.read_sql_query.html Returns: - dict[int | str, DataFrame] for Excel-like files with multiple sheets - A pandas DataFrame for all others Raises: ValueError: If the file extension is not supported or the file fails to read NzError reading file: ) osr splitext_validate_read_functionr _build_args _build_kwargs Exception ValueError) rr rrfile_extension read_functionfilepathresulteread_error_messages rload_pandas_datasetr-;s2(/BB]MW%%d++A.N+NIFFM --H4 ) < < NM::   4447A77+,,!34 Ms %A33 B=BBr'c|tvrBd|ddt}t|dt|}|tur|stt |S)NzUnsupported file extension: 'z"'. Supported file extensions are: z, )rjoinkeysr&rMISSING_SQL_QUERY_ERROR_MESSAGE)r'rextension_error_messager(s rr"r"fsBBB hN h h.2ii8]8b8b8d8d.e.e h h 011t;9.IM...y.8999 r(c&|tkr|gn||gSr )r)r(r rs rr#r#us"&<<|tvrin t|}i||Sr )r)r'r static_kwargss rr$r$zs2$>>>D^_mDn .m -} --r3) r r typingrrrrpandasrkagglehub.datasetsrstr DataFramerread_csv read_jsonread_xml read_parquet read_feather read_excelrdict__annotations__rboolr1intr-r"listr#r$r3rrHs  111111111111////// c> BK> BK> R\> bl >  BK >  >>%>&> !> "> #>  "!>& BM'>( R])>* R]+>, R]->. M M M3>>>%tCM'::PUVZmhoqugvEwEwDd3c4i0@+@&A!ABwww"S ((( ( ( ( } (  2<eCHor|;< <= ((((V C HSM h    TxTsTx}TQUTTTT .#.c.d......r3