Lazily load a CSV or set of CSVs.
This function delegates to the read_csv method on the current default backend (DuckDB or xorq.config.default_backend).
| Name | Type | Description | Default |
|---|---|---|---|
| sources | str | Path | Sequence[str | Path] | A filesystem path or URL or list of same. Supports CSV and TSV files. | required |
| table_name | str | None | A name to refer to the table. If not provided, a name will be generated. | None |
| kwargs | Any | Backend-specific keyword arguments for the file type. For the DuckDB backend used by default, please refer to: * CSV/TSV: https://duckdb.org/docs/data/csv/overview.html#parameters. | {} |
| Name | Type | Description |
|---|---|---|
| ir.Table | Table expression representing a file |
>>> import xorq
>>> xorq.options.interactive = True
>>> lines = '''a,b
... 1,d
... 2,
... ,f
... '''
>>> with open("/tmp/lines.csv", mode="w") as f:
... nbytes = f.write(lines) # nbytes is unused
>>> t = xorq.read_csv("/tmp/lines.csv")
>>> t┏━━━━━━━┳━━━━━━━━┓ ┃ a ┃ b ┃ ┡━━━━━━━╇━━━━━━━━┩ │ int64 │ string │ ├───────┼────────┤ │ 1 │ d │ │ 2 │ NULL │ │ NULL │ f │ └───────┴────────┘