Metadata-Version: 2.5
Name: vastgrid
Version: 0.4.1
Summary: Huge tables in a notebook as a grid you can edit: DuckDB in the kernel reads DataFrames, Arrow tables, DuckDB relations and CSV, Parquet, JSON Lines, Excel and DuckDB database files, and vastgrid's grid sorts, filters, groups, edits and exports them.
Project-URL: Homepage, https://vastgrid.yhay81.com
Project-URL: Repository, https://github.com/yhay81/vastgrid
Project-URL: Issues, https://github.com/yhay81/vastgrid/issues
Author: yhay81
License-Expression: MIT
Keywords: anywidget,csv,data grid,duckdb,excel,jupyter,parquet
Classifier: Framework :: Jupyter
Classifier: Framework :: Jupyter :: JupyterLab
Classifier: Programming Language :: Python :: 3
Classifier: Topic :: Scientific/Engineering :: Visualization
Requires-Python: >=3.11
Requires-Dist: anywidget>=0.10
Requires-Dist: duckdb>=2.0.0
Requires-Dist: pyarrow>=19
Description-Content-Type: text/markdown

# vastgrid

Huge tables in a Jupyter notebook as a grid you can edit. DuckDB in the kernel reads a pandas or Polars DataFrame,
a PyArrow table, a DuckDB relation, a CSV, TSV, Parquet, JSON, JSON Lines or Excel file of any size, or a table of
a DuckDB database; vastgrid's
grid shows it in the cell's output, a row range at a time, and sorts, filters, groups, pivots, finds, edits and
exports it. The notebook gets the edited table back as a DataFrame.

```python
import vastgrid

grid = vastgrid.show("sales.parquet")
grid

grid.to_pandas(view=True)  # the grid's view, with the written cells
grid.export("view.xlsx")  # the view as CSV, TSV, Parquet, JSON or Excel
```

It needs Python 3.11 or later and runs in JupyterLab 4 and Jupyter Notebook 7 (with ipywidgets 8), as an
[anywidget](https://anywidget.dev).

- Documentation: [docs/notebook.md](https://github.com/yhay81/vastgrid/blob/main/docs/notebook.md)
- Other places vastgrid opens files: [Where vastgrid opens files](https://vastgrid.yhay81.com/apps/overview/)
- License: MIT
