PyGWalker_Analyze_Pandas_dataframe.ipynb

Kernel: Python 3

PyGWalker - Analyze Pandas dataframe

Give Feedback | Bug report

Tags: #pandas #dataframe #tableau #pygwalker #analyze #jupyter

Author: Abraham Israel

Last update: 2023-04-12 (Created: 2023-03-07)

Description: This notebook will demonstrate how to analyze a Pandas dataframe in Jupyter using a Tableau-style interface.

References:

• Tableau Documentation

• Pandas Documentation

Input

Import libraries

import pandas as pd
import numpy as np
try:
    import pygwalker as pyg
except:
    !pip install pygwalker --user
    import pygwalker as pyg

Setup Variables

• df: Pandas dataframe to be analyzed

df = pd.DataFrame(np.random.randint(0, 100, size=(100, 4)), columns=list("ABCD"))

Model

Analyze dataframe

This action will analyze the dataframe using a Tableau-style interface.

# Analyze dataframe
df.describe()

Output

Display result

# Display result
gwalker = pyg.walk(df)