PyGWalker: Simplifying Exploratory Data Analysis with Python

Bryan Paget
2 min readDec 5, 2023

Introducing PyGWalker, a Python library designed to streamline your exploratory data analysis (EDA) and visualization tasks within Jupyter Notebooks. Tailored for national statistical workers familiar with Excel and Power BI, PyGWalker transforms your pandas dataframe (and polars dataframe) into an intuitive Tableau-style User Interface, enhancing your data exploration experience.

What is PyGWalker?

PyGWalker, affectionately pronounced as “Pig Walker,” is short for “Python binding of Graphic Walker.” It seamlessly integrates with Jupyter Notebooks, providing a bridge to Graphic Walker — an open-source alternative to Tableau. This library empowers data scientists to analyze and visualize data effortlessly through straightforward drag-and-drop operations.

Key Features:

  • Tableau-Style Interface: Enjoy a familiar Tableau-style UI for visual exploration without leaving the Jupyter environment.
  • Drag-and-Drop Functionality: Simplify your workflow with intuitive drag-and-drop operations, making data exploration a breeze.
  • Conversational UI: Engage in conversational data exploration through a user-friendly interface.

Installation:

To get started with PyGWalker, install the library along with other necessary dependencies using the following command:

%%capture
! pip install -U pygwalker ydata-profiling ipywidgets

Usage Example:

Now, let’s dive into a practical example using a dataset. In this case, we’ll leverage a Pokémon dataset available online:

import pandas as pd
import pygwalker as pyg
from ydata_profiling.utils.cache import cache_file

# Caching the Pokémon dataset from a remote source
file_name = cache_file(
"pokemon.csv",
"https://raw.githubusercontent.com/bryanpaget/html/main/pokemon.csv"
)

# Reading the dataset into a Pandas DataFrame
pokemon_df = pd.read_csv(file_name)

# Launching PyGWalker for visual exploration
pyg.walk(pokemon_df)

With PyGWalker, effortlessly transform your data into interactive visualization apps using just one line of code. Whether you’re accustomed to Excel or Power BI, PyGWalker offers a seamless and efficient solution for exploring and understanding your datasets within the Jupyter Notebook environment.

--

--