Testing out ChatGPT Code Interpreter

Testing out ChatGPT Code Interpreter

I just wanted to document my first interactions with ChatGPT's new Code Interpreter.

I used a data set from the Toronto Police Service Public Safety Data Portal.

This is a screenshot of what the data looks like in the CSV file I downloaded.

CSV file toronto crime data

1. Describing the Dataset itself

I asked the Code Interpreter "Can you provide some insights about crime in Toronto based on this data?"

There is a lot going on under the hood which you take a look at, as shown below. ChatGPT uses Python code to create the visualizations.

ChatGPT uses Python code to create the visualizations.

2. Analyzing the Data

ChatGPT provides some analysis of the data.

3. Visualizing the Data

The real cool stuff when ChatGPT visualizes the data. The following were created as image files.

4. Asking ChatGPT for some Unusual Visualizations

I asked ChatGPT for some unusual or interesting data visualizations and it gave me the following;

WordCloud for Neighbourhoods: This word cloud represents the frequency of homicides in various neighbourhoods. The size of each neighbourhood name in the word cloud corresponds to the frequency of homicides in that neighbourhood. Larger names correspond to neighbourhoods with more incidents. This visualization provides an immediate visual understanding of the areas with the most frequent incidents.

Donut Plot for Crime Type: This donut plot provides a visual breakdown of the types of homicides in the dataset. The size of each section corresponds to the frequency of each type of homicide, with labels and percentages for clarity. This visualization provides a clear and immediate understanding of the most common types of homicides.

My Other Blog Posts

If you liked this you might enjoy my other blog posts.


Visualizing GA4 Geographic Data with Python

Visualizing GA4 Geographic Data with Python

In this post I just wanted to show a couple of basic examples of how you can display Google Analytics 4 data using Python.

Read more


YouTube Analytics Looker Studio Dashboard Template

YouTube Analytics Looker Studio Dashboard Template

I've made a YouTube Analytics template for Looker Studio that you can download from the ByMarketers website. I used YouTube Analytics data from my own small channel where I've messing around with AI generated images.

Here is the link to view the YouTube Analytics template.

Read more


ChatGPT-4 created and visualized the top 30 Wine Farms near Cape Town

ChatGPT-4 created and visualized the top 30 Wine Farms near Cape Town

Below is an interactive map showing the top 30 wine farms surrounding. I created it relatively quickly using ChatGPT-4!

Read more


Comparing Geo Maps and Google Maps in Google Data Studio

Comparing Geo Maps and Google Maps in Google Data Studio

I thought I'd put together a blog post comparing Geo Maps and Google Maps and looking at the advantages and disadvantages of both when displaying geographic data in Google Data Studio.

Read more


How to use Google Maps in Google Data Studio

How to use Google Maps in Google Data Studio

Yesterday Google Data Studio launched a cool new feature - Google Maps as a chart type! This is major game changer for Data Studio and opens up a lot of possibilities.

Read more


Make a Long-term Growth Dashboard for Google Analytics Data using Data Studio

Make a Long-term Growth Dashboard for Google Analytics Data using Data Studio

In this post I'll show you how to make a Growth Dashboard for Google Analytics using Google Data Studio.

Read more


New Partner Visualizations available in Google Data Studio

New Partner Visualizations available in Google Data Studio

Google Data Studio has recently launched a range of new custom visualizations called Partner Visualizations.

When you click "Community Chart" you will see four community visualizations, as shown below.

Read more


How to make a Flight Path Map in Tableau

How to make a Flight Path Map in Tableau

In this article I'll show you how to make a Flight Path Map in Tableau. This is my first blog post about Tableau, and I hope you enjoy!

Read more


How to analyse sales data using Google BigQuery and Data Studio

How to analyse sales data using Google BigQuery and Data Studio

In this post I'll show you how to analyse sales data using Google BigQuery and Google Data Studio.

According to Google Cloud; "BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in."

Read more