You are viewing documentation about an older version (1.30.0). View latest version

Input/Output¶

Flat file

`read_csv`(filepath_or_buffer, *[, sep, ...])	Read csv file(s) into a Snowpark pandas DataFrame.
`read_excel`(io[, sheet_name, header, names, ...])	Read an Excel file into a Snowpark pandas DataFrame.
`read_json`(path_or_buf, *[, orient, typ, ...])	Read new-line delimited json file(s) into a Snowpark pandas DataFrame.
`read_parquet`(path[, engine, columns, ...])	Read parquet file(s) into a Snowpark pandas DataFrame.
`read_sas`(filepath_or_buffer, *[, format, ...])	Read SAS files stored as either XPORT or SAS7BDAT format files.
`read_pickle`(filepath_or_buffer[, ...])	Load pickled pandas object (or any object) from file and return unpickled object.
`read_html`(io, *[, match, flavor, header, ...])	Read HTML tables into a list of DataFrame objects.
`read_xml`(path_or_buffer, *[, xpath, ...])	Read XML document into a DataFrame object.

SQL

`read_snowflake`(name_or_query[, index_col, ...])	Read a Snowflake table or SQL Query to a Snowpark pandas DataFrame.
`to_snowflake`(obj, name[, if_exists, index, ...])	Save the Snowpark pandas DataFrame or Series as a Snowflake table.
`to_snowpark`(obj[, index, index_label])	Convert the Snowpark pandas DataFrame or Series to a Snowpark DataFrame.

pandas

to_pandas(obj, *[, statement_params])

Convert Snowpark pandas DataFrame or Series to pandas DataFrame or Series