Friday, July 19, 2024
Google search engine
HomeUncategorizedShow HN: Turn Your Pandas Dataframe into a Tableau-Style UI for Visual...

Show HN: Turn Your Pandas Dataframe into a Tableau-Style UI for Visual Analysis

PyGWalker: A Python Library for Exploratory Data Analysis with Visualization


PyPI version


binder


discord invitation link


Twitter Follow

PyGWalker can simplify your Jupyter Notebook data analysis and data visualization workflow. By turning your pandas dataframe into a Tableau-style User Interface for visual exploration.

PyGWalker (pronounced like “Pig Walker”, just for fun) is named as an abbreviation of “Python binding of Graphic Walker“. It intergrates Jupyter Notebook (or other jupyter-based notebooks) with Graphic Walker, a different type of open-source alternative to Tableau. It allows data scientists to analyze data and visualize patterns with simple drag-and-drop operations.

Visit Google Colab, Kaggle Code, Binder or Graphic Walker Online Demo to test it out!

PyGWalker will add more support such as R in the future.

Tested Environments

  • Jupyter Notebook
  • Google Colab
  • Kaggle Code
  • Jupyter Lab (WIP: There’re still some tiny CSS issues)
  • Visual Studio Code
  • …feel free to raise an issue for more environments.

Setup pygwalker

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

Use pygwalker in Jupyter Notebook

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

import pandas as pd
import pygwalker as pyg

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

df = pd.read_csv('./bike_sharing_dc.csv', parse_dates=['date'])
gwalker = pyg.walk(df)

You can even try it online, simply visiting Binder, Google Colab or Kaggle Code.

That’s it. Now you have a Tableau-like user interface to analyze and visualize data by dragging and dropping variables.

Manually explore your data with a Tableau-like UI

Cool things you can do with Graphic Walker:

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

graphic walker line chart

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

graphic walker area chart

  • 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. The rules are similar to Tableau.

graphic walker scatter chart

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

For more detailed instructions, visit the Graphic Walker GitHub page.

MIT License

  • Check out more resources about Graphic Walker on Graphic Walker GitHub
  • We are also working on RATH: an Open Source, Automate exploratory data analysis tool that redefines the workflow of data wrangling, exploration and visualization with AI-powered automation. Check out the Kanaries website and RATH GitHub for more!
  • If you encounter any issues and need support, join our Slack or Discord channels.
  • Share pygwalker on these social media platforms:

Reddit
HackerNews
Twitter
Facebook
LinkedIn

Read More

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments