| Name | jupyterlab-tabular-data-viewer-extension JSON |
| Version |
1.2.24
JSON |
| download |
| home_page | None |
| Summary | Jupyterlab extension to browse tabular data files (Parquet, Excel, CSV, TSV) with filtering and sorting capabilities |
| upload_time | 2025-11-04 15:13:06 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | >=3.9 |
| license | BSD 3-Clause License
Copyright (c) 2025, Stellars Henson
All rights reserved.
Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice, this
list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice,
this list of conditions and the following disclaimer in the documentation
and/or other materials provided with the distribution.
3. Neither the name of the copyright holder nor the names of its
contributors may be used to endorse or promote products derived from
this software without specific prior written permission.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| keywords |
csv
excel
jupyter
jupyterlab
jupyterlab-extension
parquet
tabular-data
tsv
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# jupyterlab_tabular_data_viewer_extension
[](https://github.com/stellarshenson/jupyterlab_tabular_data_viewer_extension/actions/workflows/build.yml)
[](https://www.npmjs.com/package/jupyterlab_tabular_data_viewer_extension)
[](https://pypi.org/project/jupyterlab-tabular-data-viewer-extension/)
[](https://pepy.tech/project/jupyterlab-tabular-data-viewer-extension)
[](https://jupyterlab.readthedocs.io/en/stable/)
View and browse Parquet, Excel, CSV, and TSV files directly in JupyterLab. Double-click any .parquet, .xlsx, .csv, or .tsv file to open it in a simple, spreadsheet-like table view - no code required. Navigate through your data, inspect values, and explore the structure of your tabular data files with interactive column resizing and advanced filtering capabilities.
**Opening files:** Right-click any supported file and select "Tabular Data Viewer" from the "Open With" menu, or simply double-click to open with the default viewer.
**Column statistics:** Hover over any column header to reveal an info icon, click it to view comprehensive statistics.
**Context menu:** Right-click any row to copy data as JSON.
## Features
**Supported File Formats:**
- **Parquet files** (.parquet) - Full support with efficient columnar data reading
- **Excel files** (.xlsx) - Reads first worksheet only. Excel files must be simple tabular data without merged cells, complex formulas, or advanced formatting. Files with these features may not display correctly or fail to load
- **CSV files** (.csv) - Comma-separated values with UTF-8 encoding (fallback to latin1)
- **TSV files** (.tsv) - Tab-separated values with UTF-8 encoding (fallback to latin1)
**Core viewing and navigation:**
- Simple table display showing your data in familiar spreadsheet format
- Column headers with field names and simplified datatype indicators
- Interactive column resizing - drag column borders to adjust width independently
- Progressive loading - starts with 500 rows, automatically loads more as you scroll
- File statistics (column count, row count, file size) at a glance
- Fixed status bar remains visible during horizontal scrolling
- Handles large files efficiently with server-side processing
**Advanced filtering and sorting:**
- Column sorting with three-state toggle (ascending, descending, off)
- Per-column filtering with substring or regex pattern matching
- Case-insensitive search option
- Numerical filters supporting comparison operators (`>`, `<`, `>=`, `<=`, `=`)
- Clear filters functionality to reset all active filters
- Multiple filters work together to narrow down results
**Additional features:**
- Column statistics modal - View comprehensive statistics including data type, row counts, null values, unique counts, and type-specific metrics (numeric: min/max/mean/median/std dev/outliers; string: most common value/length stats; date: earliest/latest dates). Copy statistics as JSON with one click
- Right-click context menu on rows to copy data as JSON
- Configurable file type support via Settings - Enable/disable Parquet, Excel, or CSV/TSV handling
- All features work seamlessly across all supported file formats
## Installation
Requires JupyterLab 4.0.0 or higher.
```bash
pip install jupyterlab_tabular_data_viewer_extension
```
Uninstall:
```bash
pip uninstall jupyterlab_tabular_data_viewer_extension
```
## Configuration
Configure file type support through JupyterLab Settings:
1. Open **Settings → Settings Editor**
2. Search for "Tabular Data Viewer Extension"
3. Configure options:
- **Enable Parquet files** - Default: enabled
- **Enable Excel files** - Default: enabled
- **Enable CSV files** - Default: enabled
- **Enable TSV files** - Default: enabled
When a file type is disabled, files open with JupyterLab's default handler instead.
## Troubleshooting
Verify both extension components are enabled if the extension doesn't work:
```bash
# Check server extension
jupyter server extension list
# Check frontend extension
jupyter labextension list
```
Both commands should show `jupyterlab_tabular_data_viewer_extension` as enabled. Reinstall if either is missing or disabled.
## Development Setup
Requires NodeJS for building TypeScript frontend. Uses `jlpm` (JupyterLab's pinned yarn version) for consistency.
**Initial setup:**
```bash
# Create virtual environment
python -m venv .venv
source .venv/bin/activate
# Install in editable mode
pip install --editable ".[dev,test]"
# Link frontend and enable server extension
jupyter labextension develop . --overwrite
jupyter server extension enable jupyterlab_tabular_data_viewer_extension
```
**Development workflow:**
Use two terminals for efficient development:
- Terminal 1: `jlpm watch` (auto-rebuild on file changes)
- Terminal 2: `jupyter lab` (run development instance)
Refresh browser after changes to see updates. Build generates source maps for debugging.
Enable deeper debugging with unminimized JupyterLab build:
```bash
jupyter lab build --minimize=False
```
**Removing development installation:**
```bash
jupyter server extension disable jupyterlab_tabular_data_viewer_extension
pip uninstall jupyterlab_tabular_data_viewer_extension
```
Then delete the `jupyterlab_tabular_data_viewer_extension` symlink from your `labextensions` directory (find with `jupyter labextension list`).
## Testing
Three-tier testing strategy: Python backend, TypeScript frontend, and integration tests.
**Python tests** (pytest with coverage):
```bash
pip install -e ".[test]"
jupyter labextension develop . --overwrite
pytest -vv -r ap --cov jupyterlab_tabular_data_viewer_extension
```
**TypeScript tests** (Jest):
```bash
jlpm
jlpm test
```
**Integration tests** (Playwright + Galata):
Simulates real user interactions to validate complete workflows. See [ui-tests README](./ui-tests/README.md) for detailed instructions.
## Packaging and Release
See [RELEASE.md](RELEASE.md) for instructions on building distributable packages and publishing releases.
Raw data
{
"_id": null,
"home_page": null,
"name": "jupyterlab-tabular-data-viewer-extension",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": null,
"keywords": "csv, excel, jupyter, jupyterlab, jupyterlab-extension, parquet, tabular-data, tsv",
"author": null,
"author_email": "Stellars Henson <konrad.jelen@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/41/8d/99cdd1df13fc47da79c25be17dca1429bf57874da51253c210952561b633/jupyterlab_tabular_data_viewer_extension-1.2.24.tar.gz",
"platform": null,
"description": "# jupyterlab_tabular_data_viewer_extension\n\n[](https://github.com/stellarshenson/jupyterlab_tabular_data_viewer_extension/actions/workflows/build.yml)\n[](https://www.npmjs.com/package/jupyterlab_tabular_data_viewer_extension)\n[](https://pypi.org/project/jupyterlab-tabular-data-viewer-extension/)\n[](https://pepy.tech/project/jupyterlab-tabular-data-viewer-extension)\n[](https://jupyterlab.readthedocs.io/en/stable/)\n\nView and browse Parquet, Excel, CSV, and TSV files directly in JupyterLab. Double-click any .parquet, .xlsx, .csv, or .tsv file to open it in a simple, spreadsheet-like table view - no code required. Navigate through your data, inspect values, and explore the structure of your tabular data files with interactive column resizing and advanced filtering capabilities.\n\n\n\n**Opening files:** Right-click any supported file and select \"Tabular Data Viewer\" from the \"Open With\" menu, or simply double-click to open with the default viewer.\n\n\n\n**Column statistics:** Hover over any column header to reveal an info icon, click it to view comprehensive statistics.\n\n\n\n\n\n**Context menu:** Right-click any row to copy data as JSON.\n\n\n\n## Features\n\n**Supported File Formats:**\n- **Parquet files** (.parquet) - Full support with efficient columnar data reading\n- **Excel files** (.xlsx) - Reads first worksheet only. Excel files must be simple tabular data without merged cells, complex formulas, or advanced formatting. Files with these features may not display correctly or fail to load\n- **CSV files** (.csv) - Comma-separated values with UTF-8 encoding (fallback to latin1)\n- **TSV files** (.tsv) - Tab-separated values with UTF-8 encoding (fallback to latin1)\n\n**Core viewing and navigation:**\n- Simple table display showing your data in familiar spreadsheet format\n- Column headers with field names and simplified datatype indicators\n- Interactive column resizing - drag column borders to adjust width independently\n- Progressive loading - starts with 500 rows, automatically loads more as you scroll\n- File statistics (column count, row count, file size) at a glance\n- Fixed status bar remains visible during horizontal scrolling\n- Handles large files efficiently with server-side processing\n\n**Advanced filtering and sorting:**\n- Column sorting with three-state toggle (ascending, descending, off)\n- Per-column filtering with substring or regex pattern matching\n- Case-insensitive search option\n- Numerical filters supporting comparison operators (`>`, `<`, `>=`, `<=`, `=`)\n- Clear filters functionality to reset all active filters\n- Multiple filters work together to narrow down results\n\n**Additional features:**\n- Column statistics modal - View comprehensive statistics including data type, row counts, null values, unique counts, and type-specific metrics (numeric: min/max/mean/median/std dev/outliers; string: most common value/length stats; date: earliest/latest dates). Copy statistics as JSON with one click\n- Right-click context menu on rows to copy data as JSON\n- Configurable file type support via Settings - Enable/disable Parquet, Excel, or CSV/TSV handling\n- All features work seamlessly across all supported file formats\n\n## Installation\n\nRequires JupyterLab 4.0.0 or higher.\n\n```bash\npip install jupyterlab_tabular_data_viewer_extension\n```\n\nUninstall:\n```bash\npip uninstall jupyterlab_tabular_data_viewer_extension\n```\n\n## Configuration\n\nConfigure file type support through JupyterLab Settings:\n\n1. Open **Settings \u2192 Settings Editor**\n2. Search for \"Tabular Data Viewer Extension\"\n3. Configure options:\n - **Enable Parquet files** - Default: enabled\n - **Enable Excel files** - Default: enabled\n - **Enable CSV files** - Default: enabled\n - **Enable TSV files** - Default: enabled\n\nWhen a file type is disabled, files open with JupyterLab's default handler instead.\n\n## Troubleshooting\n\nVerify both extension components are enabled if the extension doesn't work:\n\n```bash\n# Check server extension\njupyter server extension list\n\n# Check frontend extension\njupyter labextension list\n```\n\nBoth commands should show `jupyterlab_tabular_data_viewer_extension` as enabled. Reinstall if either is missing or disabled.\n\n## Development Setup\n\nRequires NodeJS for building TypeScript frontend. Uses `jlpm` (JupyterLab's pinned yarn version) for consistency.\n\n**Initial setup:**\n\n```bash\n# Create virtual environment\npython -m venv .venv\nsource .venv/bin/activate\n\n# Install in editable mode\npip install --editable \".[dev,test]\"\n\n# Link frontend and enable server extension\njupyter labextension develop . --overwrite\njupyter server extension enable jupyterlab_tabular_data_viewer_extension\n```\n\n**Development workflow:**\n\nUse two terminals for efficient development:\n- Terminal 1: `jlpm watch` (auto-rebuild on file changes)\n- Terminal 2: `jupyter lab` (run development instance)\n\nRefresh browser after changes to see updates. Build generates source maps for debugging.\n\nEnable deeper debugging with unminimized JupyterLab build:\n```bash\njupyter lab build --minimize=False\n```\n\n**Removing development installation:**\n\n```bash\njupyter server extension disable jupyterlab_tabular_data_viewer_extension\npip uninstall jupyterlab_tabular_data_viewer_extension\n```\n\nThen delete the `jupyterlab_tabular_data_viewer_extension` symlink from your `labextensions` directory (find with `jupyter labextension list`).\n\n## Testing\n\nThree-tier testing strategy: Python backend, TypeScript frontend, and integration tests.\n\n**Python tests** (pytest with coverage):\n```bash\npip install -e \".[test]\"\njupyter labextension develop . --overwrite\npytest -vv -r ap --cov jupyterlab_tabular_data_viewer_extension\n```\n\n**TypeScript tests** (Jest):\n```bash\njlpm\njlpm test\n```\n\n**Integration tests** (Playwright + Galata):\nSimulates real user interactions to validate complete workflows. See [ui-tests README](./ui-tests/README.md) for detailed instructions.\n\n## Packaging and Release\n\nSee [RELEASE.md](RELEASE.md) for instructions on building distributable packages and publishing releases.\n",
"bugtrack_url": null,
"license": "BSD 3-Clause License\n \n Copyright (c) 2025, Stellars Henson\n All rights reserved.\n \n Redistribution and use in source and binary forms, with or without\n modification, are permitted provided that the following conditions are met:\n \n 1. Redistributions of source code must retain the above copyright notice, this\n list of conditions and the following disclaimer.\n \n 2. Redistributions in binary form must reproduce the above copyright notice,\n this list of conditions and the following disclaimer in the documentation\n and/or other materials provided with the distribution.\n \n 3. Neither the name of the copyright holder nor the names of its\n contributors may be used to endorse or promote products derived from\n this software without specific prior written permission.\n \n THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS \"AS IS\"\n AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE\n IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE\n DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE\n FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL\n DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR\n SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER\n CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,\n OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE\n OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.",
"summary": "Jupyterlab extension to browse tabular data files (Parquet, Excel, CSV, TSV) with filtering and sorting capabilities",
"version": "1.2.24",
"project_urls": {
"Bug Tracker": "https://github.com/stellarshenson/jupyterlab_tabular_data_viewer_extension/issues",
"Homepage": "https://github.com/stellarshenson/jupyterlab_tabular_data_viewer_extension",
"Repository": "https://github.com/stellarshenson/jupyterlab_tabular_data_viewer_extension.git"
},
"split_keywords": [
"csv",
" excel",
" jupyter",
" jupyterlab",
" jupyterlab-extension",
" parquet",
" tabular-data",
" tsv"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "bf7259df878b291cf83ee3ffee13b1a3aa22d54023e6365f382d4c4d422c4ca0",
"md5": "d9c02dddf5e7806805fc74d0f30822cc",
"sha256": "8f3caf75768bf61d249668423c5cee9d69a8e4fd908d4609b3564e78de8d0d27"
},
"downloads": -1,
"filename": "jupyterlab_tabular_data_viewer_extension-1.2.24-py3-none-any.whl",
"has_sig": false,
"md5_digest": "d9c02dddf5e7806805fc74d0f30822cc",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 36475,
"upload_time": "2025-11-04T15:13:04",
"upload_time_iso_8601": "2025-11-04T15:13:04.808451Z",
"url": "https://files.pythonhosted.org/packages/bf/72/59df878b291cf83ee3ffee13b1a3aa22d54023e6365f382d4c4d422c4ca0/jupyterlab_tabular_data_viewer_extension-1.2.24-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "418d99cdd1df13fc47da79c25be17dca1429bf57874da51253c210952561b633",
"md5": "cbb3d08cc833e9a094abf79ee123e773",
"sha256": "54c6d2dfac30a53f51fde706587f779d161b23d51c16264b0c44c4d8c4a4f633"
},
"downloads": -1,
"filename": "jupyterlab_tabular_data_viewer_extension-1.2.24.tar.gz",
"has_sig": false,
"md5_digest": "cbb3d08cc833e9a094abf79ee123e773",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 1008557,
"upload_time": "2025-11-04T15:13:06",
"upload_time_iso_8601": "2025-11-04T15:13:06.242044Z",
"url": "https://files.pythonhosted.org/packages/41/8d/99cdd1df13fc47da79c25be17dca1429bf57874da51253c210952561b633/jupyterlab_tabular_data_viewer_extension-1.2.24.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-11-04 15:13:06",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "stellarshenson",
"github_project": "jupyterlab_tabular_data_viewer_extension",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "jupyterlab-tabular-data-viewer-extension"
}
