Input/output#

Avro#

`read_avro`(source, *[, columns, n_rows])	Read into a DataFrame from Apache Avro format.
`DataFrame.write_avro`(file[, compression, name])	Write to Apache Avro file.

`read_clipboard`([separator])	Read text from clipboard and pass to `read_csv`.
`DataFrame.write_clipboard`(*[, separator])	Copy `DataFrame` in csv format to the system clipboard with `write_csv`.

`read_csv`(source, *[, has_header, columns, ...])	Read a CSV file into a DataFrame.
`read_csv_batched`(source, *[, has_header, ...])	Read a CSV file in batches.
`scan_csv`(source, *[, has_header, separator, ...])	Lazily read from a CSV file or multiple files via glob patterns.
`DataFrame.write_csv`([file, include_bom, ...])	Write to comma-separated values (CSV) file.
`LazyFrame.sink_csv`(path, *[, include_bom, ...])	Evaluate the query in streaming mode and write to a CSV file.

Read n batches from the reader.

`read_database`(query, connection, *[, ...])	Read the results of a SQL query into a DataFrame, given a connection object.
`read_database_uri`(query, uri, *[, ...])	Read the results of a SQL query into a DataFrame, given a URI.
`DataFrame.write_database`(table_name, ...[, ...])	Write the data in a Polars DataFrame to a database.

`read_delta`(source, *[, version, columns, ...])	Reads into a DataFrame from a Delta lake table.
`scan_delta`(source, *[, version, ...])	Lazily read from a Delta lake table.
`DataFrame.write_delta`(target, *[, mode, ...])	Write DataFrame as delta table.

`read_excel`(source, *[, sheet_id, ...])	Read Excel spreadsheet data into a DataFrame.
`read_ods`(source, *[, sheet_id, sheet_name, ...])	Read OpenOffice (ODS) spreadsheet data into a DataFrame.
`DataFrame.write_excel`([workbook, worksheet, ...])	Write frame data to a table in an Excel workbook/worksheet.

`read_ipc`(source, *[, columns, n_rows, ...])	Read into a DataFrame from Arrow IPC (Feather v2) file.
`read_ipc_schema`(source)	Get the schema of an IPC file without reading data.
`read_ipc_stream`(source, *[, columns, ...])	Read into a DataFrame from Arrow IPC record batch stream.
`scan_ipc`(source, *[, n_rows, cache, ...])	Lazily read from an Arrow IPC (Feather v2) file or multiple files via glob patterns.
`DataFrame.write_ipc`(file, *[, compression, ...])	Write to Arrow IPC binary stream or Feather file.
`DataFrame.write_ipc_stream`(file, *[, ...])	Write to Arrow IPC record batch stream.
`LazyFrame.sink_ipc`(path, *[, compression, ...])	Evaluate the query in streaming mode and write to an IPC file.

scan_iceberg(source, *[, snapshot_id, ...])

Lazily read from an Apache Iceberg table.

`read_json`(source, *[, schema, ...])	Read into a DataFrame from a JSON file.
`read_ndjson`(source, *[, schema, ...])	Read into a DataFrame from a newline delimited JSON file.
`scan_ndjson`(source, *[, schema, ...])	Lazily read from a newline delimited JSON file or multiple files via glob patterns.
`DataFrame.write_json`([file])	Serialize to JSON representation.
`DataFrame.write_ndjson`([file])	Serialize to newline delimited JSON representation.
`LazyFrame.sink_ndjson`(path, *[, ...])	Evaluate the query in streaming mode and write to an NDJSON file.

`read_parquet`(source, *[, columns, n_rows, ...])	Read into a DataFrame from a parquet file.
`read_parquet_schema`(source)	Get the schema of a Parquet file without reading data.
`scan_parquet`(source, *[, n_rows, ...])	Lazily read from a local or cloud-hosted parquet file (or files).
`DataFrame.write_parquet`(file, *[, ...])	Write to Apache Parquet file.
`LazyFrame.sink_parquet`(path, *[, ...])	Evaluate the query in streaming mode and write to a Parquet file.

Connect to pyarrow datasets.

Scan a pyarrow dataset.

Configuration for cloud credential provisioning.

`CredentialProvider`()	Base class for credential providers.
`CredentialProviderAWS`(*[, profile_name, ...])	AWS Credential Provider.
`CredentialProviderAzure`(*[, scopes, ...])	Azure Credential Provider.
`CredentialProviderGCP`(*[, scopes, request, ...])	GCP Credential Provider.