Advanced Charting

In this example we use VerbaGPT to get an advanced charting technique while using the famous Chinook dataset¹.

Video:

User question: from the chinook db, can you plot the number of customers by country on a map, and color code it by number of customers (white for few, and green for more)?

VerbaGPT response:

Cost of query: $0.00

VerbaGPT answers the question correctly and gives us exactly what we asked for. And it is an attractive looking chart to boot!

VerbaGPT is a powerful way to communicate with the data. A user can ask any kind of similar question in free-form natural language. Check out the full VerbaGPT read-out by click on below.

import pandas as pd
import plotly.express as px

query = "SELECT Country, COUNT(*) as Count FROM Customer GROUP BY Country"
df = pd.read_sql(query, conn)

fig = px.choropleth(df, locations="Country", locationmode="country names", color="Count", color_continuous_scale="greens")
fig.show()

1. Chinook dataset