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.


How to combine data from two BigQuery public datasets using SQL

How to combine data from two BigQuery public datasets using SQL

So in this blog post I'll show how you can combine data from two BigQuery public datasets using SQL and to visualize the data in Data Studio.

Read more


Visualizing Data showing Police Brutality by Country

Visualizing Data showing Police Brutality by Country

So in the past week Police Brutality has been a major issue in Canada, South Africa and the United States. I thought that some might find it useful to see a data visualization showing Police Brutality by Country.

Read more


Compare Countries using World Development Indicators in Google Data Studio

Compare Countries using World Development Indicators in Google Data Studio

So in this post I'll share a dashboard I made that allows you to compare countries using World Development Indicators from the World Bank.

Read more


Comparing COVID-19 cases in the US and Europe

Comparing COVID-19 cases in the United States and Europe

In this dashboard I wanted to show the differences between the number of COVID-19 cases in the United States and Europe. Thanks to Johnny Miller from Unequal Scenes for the suggestion to take a look at the data.

Read more


Build a Google Data Studio report using BigQuery Public Data-Sets

Build a Google Data Studio report using BigQuery Public Data-Sets

In this post I'll show you how to build a dashboard using one of the many Public data-sets available to users in BigQuery.

Read more