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.
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.
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
In this post I just wanted to show a couple of basic examples of how you can display Google Analytics 4 data using Python.
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.
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!
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.
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.
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.
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.
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!
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."