npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

spreadsheet-editor

v0.7.1

Published

JupyterLab spreadsheet (csv/tsv) editor

Downloads

91

Readme

JupyterLab Spreadsheet Editor

Extension status GitHub Action Status Binder pypi-version

JupyterLab spreadsheet editor enables interactive editing of comma/tab separated value spreadsheets. It support formulas, sorting, column/row rearrangements and more!

Note: you might be interested to checkout tabular-data-editor as well

Showcase

Fully featured integration

  • row/column operations, column width adjustment
  • search and replace

Formula support basic formula calculation (rendering) - as implemented by jExcel.

Column freezing for exploration of wide datasets with many covariates

Launcher items: create CSV/TSV files easily from the launcher or the palette.

Lightweight and reliable dependencies: the spreadsheet interface is built with the jexcel, while Papa Parse provides very fast, RFC 4180 compatible CSV parsing (both have no third-party dependencies).

Requirements

  • JupyterLab >= 3.0

Install

pip install jupyterlab-spreadsheet-editor

Contributing

Development install

Note: You will need NodeJS to build the extension package.

The jlpm command is JupyterLab's pinned version of yarn that is installed with JupyterLab. You may use yarn or npm in lieu of jlpm below.

# Clone the repo to your local environment
# Change directory to the jupyterlab-spreadsheet-editor directory
# Install package in development mode
pip install -e .
# Link your development version of the extension with JupyterLab
jupyter labextension develop . --overwrite
# Rebuild extension Typescript source after making changes
jlpm run build

You can watch the source directory and run JupyterLab at the same time in different terminals to watch for changes in the extension's source and automatically rebuild the extension.

# Watch the source directory in one terminal, automatically rebuilding when needed
jlpm run watch
# Run JupyterLab in another terminal
jupyter lab

With the watch command running, every saved change will immediately be built locally and available in your running JupyterLab. Refresh JupyterLab to load the change in your browser (you may need to wait several seconds for the extension to be rebuilt).

By default, the jlpm run build command generates the source maps for this extension to make it easier to debug using the browser dev tools. To also generate source maps for the JupyterLab core extensions, you can run the following command:

jupyter lab build --minimize=False

Uninstall

pip uninstall jupyterlab-spreadsheet-editor

Related extensions

Spreadsheet editors:

Spreadsheet viewers:

In-notebook spreadsheet widgets:

  • ipysheet - programmable sheet creation, exploration and modification
  • qgrid - interactive DataFrame exploration and modification