Pandas expression composers using Jupyter widgets.
Project description
Pandas_GUI (aka: jupyter_Pandas_GUI)
Introduction | Current Features | Wishlist | Usage | Installation | Change Log | Issues or comments | License | PyPi link
Introduction:
This package provides GUI tools to help the user construct Pandas and Python expressions to create things such as new calculated columns, plots or fits. The tools are meant to run in an interactive Jupyter notebook in classic Jupyter, Jupyter Lab and Google Colab. All tools are based on ipywidgets widgets.
These tools are meant to help the user learn how to construct the commands. They are intended for new or occasional users of Pandas. However, sophisticated users may find them useful for doing simple one-off tasks where the ability to choose python objects from menus can reduce errors.
Current Features:
The user can pass the GUI tools a list of Pandas DataFrames to work with. If nothing is passed, the GUI will look for Pandas DataFrames in the interactive session. The whole GUI and the Jupyter cell that created it are deleted when done. This leaves only the code that was generated by the GUI and the results of running the generated code.
The generated code contains sparse comments meant to help new users understand the code.
Currently defined GUIs:
-
new_pandas_column_GUI()
: A GUI with four steps to lead the user through formulating an expression for a new column. -
plot_pandas_GUI()
: A GUI with four steps to lead the user through plotting Pandas data as a scatter or line plot using plotly. -
fit_pandas_GUI()
: A GUI with six steps to lead the user through fitting Pandas data to a line, polynomial, exponential, Gaussian or sine function. This tool currently does NOT work in Colab. The tabs are not rendered in Colab.
Wishlist:
- GUIs for plots beyond scatter/line plots.
Usage:
If the jupyter_Pandas_GUI
is installed in your Jupyter/Python environment
start by importing it:
from pandas_GUI import *
When you want to use a particular GUI issue the appropriate command. Currently:
new_pandas_column_GUI()
or
plot_pandas_GUI()
or
fit_pandas_GUI()
See the documentation for examples, more details and information about passing dataframes that are not at the root of the interactive namespace or presenting the user with alternative names for the dataframes. There is also an option to make columns containing text available. By default they are ignored.
Installation:
Installation using pip into a virtual environment is recommended.
Production
-
If not installed, install pipenv:
$ pip3 install --user pipenv
. You may need to add~/.local/bin
to yourPATH
to makepipenv
available in your command shell. More discussion: The Hitchhiker's Guide to Python. -
Navigate to the directory where this package will be installed.
-
Start a shell in the environment
$ pipenv shell
. -
Install using pip.
pip install jupyter-Pandas-GUI
. This will install Jupyter into the same virtual environment if you do not already have it on your machine. If Jupyter is already installed the virtual environment will use the existing installation. This takes a long time on a Raspberry Pi. It will not run on a 3B+ without at least 1 GB of swap. See: Build Jupyter on a Pi .- Still within the environment shell test this by starting jupyter
jupyter notebook
orJupyter lab
. The version of Jupyter requested should launch in your browser.- Open a new notebook using the default (Python 3) kernel.
- In the first cell import the pandas_GUI module:
from pandas_GUI import *
- To try:
- Create some Pandas DataFrames in the notebook.
- Use the command
new_pandas_column_GUI()
to start the GUI. - It will search for the DataFrames you created.
- Follow the steps to create a new column in one of your DataFrames.
-
Optional You can make this environment available to an alternate Jupyter install as a special kernel when you are the user.
- Make sure you are running in your virtual environment
$ pipenv shell
in the directory for virtual environment will do that. - Issue the command to add this as a kernel to your personal space:
$ python -m ipykernel install --user --name=<name-you-want-for-kernel>
. - More information is available in the Jupyter/Ipython documentation. A simple tutorial from Nikolai Jankiev (Parametric Thoughts) can be found here.
- Make sure you are running in your virtual environment
Development
Simply replace $ pip install jupyter-Pandas-GUI
with $ pip install -e ../jupyter_Pandas_GUI
in the Production
instructions.
Change Log
- 0.7.0rc1
- GUIs now also work in Jupyter Lab, although less
elegently than in classic Jupyter. Only the
new_pandas_column_GUI()
and theplot_pandas_GUI()
commands work in Colab. - Some minor bug fixes and clarification of instructions.
- More and better comments in generated code.
- Replacement of notebook cell javascript tools with those from JPSLUtils is complete.
- GUIs now also work in Jupyter Lab, although less
elegently than in classic Jupyter. Only the
- 0.6.2.1 Fix for python move of
Iterable
tocollections.abc
- 0.6.2
- Can now pass dataframes to the GUIs and they will search for additional dataframes in the user namespace. Search can be turned off.
- Fixed edge case where GUI fit range picking did nothing.
- 0.6.1 fixed
fit_pandas_GUI()
mishandling of user friendly names for the data frames. - 0.6.0
- Documentation (Examples and API).
- Addition of fitting GUI.
- Minor bug and typo fixes.
- Images show up on Pypi page.
- 0.5.2
- Widget states autosaved when a new plot is made.
- Began making use of JPSLUtils.
- 0.5.1
- Possible to use pandas dataframes in namespaces other than the user global namespace.
- Readme updates.
- 0.5.0 Initial beta release.
Issues or comments
JupyterPhysSciLab/jupyter_Pandas_GUI/issues
This software is distributed under the GNU V3 license
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
Copyright - Jonathan Gutow, 2021, 2022.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for jupyter_Pandas_GUI-0.7.0rc2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4c3efe6b0f14b5d37fc70b9b13ee69e4373e6b6ebab3c02ec7ac475d93e0dcf4 |
|
MD5 | 36d3d28fc7700f05760b84cd8369f463 |
|
BLAKE2b-256 | cc27b3bd0d91cd61b3204a00e4737df3466fe5e85047d9750175262dae996452 |
Hashes for jupyter_Pandas_GUI-0.7.0rc2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e7e9b69e938edb57abf42094142f669347a6c9826da4432b2a68d9f3f9c6098a |
|
MD5 | b247737e5036ea5357aebf58fdf076ef |
|
BLAKE2b-256 | 5b02f4c6c2416a260b9c691f54e5e8d428da824737362b121a3b97af4a4d3f1b |