Repository files navigation

English |Español |Français |Deutsch |中文 |Türkçe |日本語 |한국어

PyGWalker can simplify your Jupyter Notebook data analysis and data visualization workflow, by turning your pandas dataframe into an interactive user interface for visual exploration.

PyGWalker (pronounced like "Pig Walker", just for fun) is named as an abbreviation of "Python binding ofGraphicWalker". It integrates Jupyter Notebook withGraphic Walker, an open-source alternative to Tableau. It allows data scientists to visualize / clean / annotates the data with simple drag-and-drop operations and even natural language queries.

VisitGoogle Colab,Kaggle Code orGraphic Walker Online Demo to test it out!

If you prefer using R, checkGWalkR, the R wrapper of Graphic Walker.

Check our video tutorial about using pygwalker, pygwalker + streamlit and pygwalker + snowflake,How to explore data with PyGWalker in Python

Run in Kaggle	Run in Colab

Before using pygwalker, make sure to install the packages through the command line using pip or conda.

pip install pygwalker

Note

For an early trial, you can install withpip install pygwalker --upgrade to keep your version up to date with the latest release or evenpip install pygwalker --upgrade --pre to obtain latest features and bug-fixes.

conda install -c conda-forge pygwalker

or

mamba install -c conda-forge pygwalker

Seeconda-forge feedstock for more help.

Import pygwalker and pandas to your Jupyter Notebook to get started.

importpandasaspdimportpygwalkeraspyg

You can use pygwalker without breaking your existing workflow. For example, you can call up PyGWalker with the dataframe loaded in this way:

df=pd.read_csv('./bike_sharing_dc.csv')walker=pyg.walk(df)

That's it. Now you have an interactive UI to analyze and visualize data with simple drag-and-drop operations.

Cool things you can do with PyGwalker:

• You can change the mark type into others to make different charts, for example, a line chart:

• To compare different measures, you can create a concat view by adding more than one measure into rows/columns.

• To make a facet view of several subviews divided by the value in dimension, put dimensions into rows or columns to make a facets view.

• PyGWalker contains a powerful data table, which provides a quick view of data and its distribution, profiling. You can also add filters or change the data types in the table.

• You can save the data exploration result to a local file

There are some important parameters you should know when using pygwalker:

• spec: for save/load chart config (json string or file path)
• kernel_computation: for using duckdb as computing engine which allows you to handle larger dataset faster in your local machine.
• use_kernel_calc: Deprecated, usekernel_computation instead.

df=pd.read_csv('./bike_sharing_dc.csv')walker=pyg.walk(df,spec="./chart_meta_0.json",# this json file will save your chart state, you need to click save button in ui mannual when you finish a chart, 'autosave' will be supported in the future.kernel_computation=True,# set `kernel_computation=True`, pygwalker will use duckdb as computing engine, it support you explore bigger dataset(<=100GB).)

• Notebook Code:Click Here
• Preview Notebook Html:Click Here

• Use PyGWalker in Kaggle
• Use PyGWalker in Google Colab

Streamlit allows you to host a web version of pygwalker without figuring out details of how web application works.

Here are some of the app examples build with pygwalker and streamlit:

• PyGWalker + streamlit for Bike sharing dataset
• Earthquake Dashboard

frompygwalker.api.streamlitimportStreamlitRendererimportpandasaspdimportstreamlitasst# Adjust the width of the Streamlit pagest.set_page_config(page_title="Use Pygwalker In Streamlit",layout="wide")# Add Titlest.title("Use Pygwalker In Streamlit")# You should cache your pygwalker renderer, if you don't want your memory to explode@st.cache_resourcedefget_pyg_renderer()->"StreamlitRenderer":df=pd.read_csv("./bike_sharing_dc.csv")# If you want to use feature of saving chart config, set `spec_io_mode="rw"`returnStreamlitRenderer(df,spec="./gw_config.json",spec_io_mode="rw")renderer=get_pyg_renderer()renderer.explorer()

Refer it:local-development

• Jupyter Notebook
• Google Colab
• Kaggle Code
• Jupyter Lab
• Jupyter Lite
• Databricks Notebook (Since version0.1.4a0)
• Jupyter Extension for Visual Studio Code (Since version0.1.4a0)
• Most web applications compatiable with IPython kernels. (Since version0.1.4a0)
• Streamlit (Since version0.1.4.9), enabled withpyg.walk(df, env='Streamlit')
• DataCamp Workspace (Since version0.1.4a0)
• Panel. Seepanel-graphic-walker.
• marimo (Since version0.4.9.11)
• Hex Projects
• ...feel free to raise an issue for more environments.

You can usepygwalker config to set your privacy configuration.

$ pygwalker config --helpusage: pygwalker config [-h] [--set [key=value ...]] [--reset [key ...]] [--reset-all] [--list]Modify configuration file. (default:~/Library/Application Support/pygwalker/config.json) Available configurations:- privacy  ['offline','update-only','events'] (default: events)."offline": fully offline, no data is send or api is requested"update-only": only check whether this is a new version of pygwalker to update"events": share which events about which feature is usedin pygwalker, it only contains events data about which feature you arrivefor product optimization. No DATA YOU ANALYSIS IS SEND. Events data willbind with a unique id, which is generated by pygwalker when it is installed based on timestamp. We will not collect any other information about you.    - kanaries_token  ['your kanaries token'] (default: empty string).    your kanaries token, you can get it from https://kanaries.net.    refer: https://space.kanaries.net/t/how-to-get-api-key-of-kanaries.    by kanaries token, you can use kanaries servicein pygwalker, such as share chart, share config.    options:-h, --help            show thishelp message andexit  --set [key=value ...]                        Set configuration. e.g."pygwalker config --set privacy=update-only"  --reset [key ...]     Reset user configuration and use default values instead. e.g."pygwalker config --reset privacy"  --reset-all           Reset all user configuration and use default values instead. e.g."pygwalker config --reset-all"  --list                List current used configuration.

More details, refer it:How to set your privacy configuration?

Apache License 2.0

PyGWalker Cloud is released! You can now save your charts to cloud, publish the interactive cell as a web app and use advanced GPT-powered features. Check out thePyGWalker Cloud for more details.

• Check out more resources about PyGWalker onKanaries PyGWalker
• PyGWalker PaperPyGWalker: On-the-fly Assistant for Exploratory Visual Data Analysis
• We are also working onRATH: an Open Source, Automate exploratory data analysis software that redefines the workflow of data wrangling, exploration and visualization with AI-powered automation. Check out theKanaries website andRATH GitHub for more!
• Youtube: How to explore data with PyGWalker in Python
• Use pygwalker to build visual analysis app in streamlit
• Usepanel-graphic-walker to build data visualization apps with Panel.
• If you encounter any issues and need support, please join ourDiscord channel or raise an issue on github.
• Share pygwalker on these social media platforms if you like it!