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.
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.
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.
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.
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.
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.