Wine + GPT4 + Code Interpreter: WOW!!

by | Tuesday, July 11, 2023

OpenAI just released Code Interpreter. It allows you to execute Python code within a live working environment. One of the things that it allows us to do is take data files and conduct data analysis and create graphs and charts.

Not knowing what that meant I decided to play with it. So I found a publicly available database on wine quality (and why not? Don’t give me that look) and imported it into Code Interpreter. I am not including the entire conversation I had with GPT but provide some key excerpts below. You can read the entire interaction in this linked pdf document.

So I started with a complete blank slate. I had no idea what I was doing. So I started the conversation with:

Can you create some interesting data visualizations based on this dataset?

After looking over the data, it suggested the following:

For instance, we can examine the distribution of quality ratings for both types of wine, the correlation between different properties and the quality of the wine, and some other interesting relationships. Does that sound good to you?

And once I said yes, within seconds I had the following diagram, with the explanation below.

In the first plot, “Distribution of Quality Ratings for Each Wine Type,” we can see that the majority of wines, both red and white, have a quality rating of 5, 6, or 7. White wine tends to have slightly higher quality ratings overall compared to red wine. In the second plot, “Distribution of Alcohol Content for Each Quality Rating,” we see that higher-quality wines generally contain more alcohol. This is true for both red and white wines. The trend suggests that wines with higher alcohol content tend to be rated better in quality.

Hmmm… wines with higher alcohol content tend to be rated higher! Why am I not suprised 🙂

Not sure of what to do next, I wrote:

I am interested in some cool visualizations that can emerge from this analysis. What would you suggest?

After a bit of back and forth, where it provided me with a variety of options, I asked it to create a correlational heatmap. Within seconds I had the following.

Here’s the correlation heatmap of the wine properties. From the heatmap, we can observe that:

  1. The alcohol content has a relatively strong positive correlation with the quality of the wine. This observation aligns with our earlier analysis where we noticed that higher-quality wines generally contain more alcohol.
  2. The density of the wine has a somewhat strong negative correlation with the quality of the wine. This suggests that higher-quality wines tend to have a lower density.
  3. The volatile acidity also has a negative correlation with the quality of the wine, implying that better-quality wines tend to have lower volatile acidity.
  4. There are also some strong correlations between different properties of the wine, which are not directly related to the quality. For example, density has a strong positive correlation with residual sugar.

This is when I had to jump onto a meeting in zoom, so I hit pause.

Let me just add that all this took just 20 minutes, maybe less.

I am still trying to wrap my head around this. But the possibilities appear endless and I am constrained by nothing but my imagination.

A few randomly selected blog posts…

TPACK commercial II, Mastercard “Priceless”

Here is the second of the two commercials created specially for our ISTE Radio/Video show. The first one (a take-off on the UPS/Whiteboard commercials can be seen here). Enjoy. As always, the director’s commentary is provided below....

Fishing for problems: Podcast interview

Fishing for problems: Podcast interview

I was recently interviewed by Matt Schneidman (Curator, Creator, Podcast Host) for his Fishing for Problems podcast. Matt also publishes an  ed-focused newsletter. Our discussion was broadly framed around educational technology and the TPACK framework - but...

Designing learning in a transformed world: Keynote

Designing learning in a transformed world: Keynote

I was recently invited to present virtually at The Heart of Innovation Summer Summit, organized by the Heartland Area Education Agency in Iowa. The video of my talk can be seen below. Maybe my first serious keynote talk about generative AI and education. Enjoy...

Funny TPACK mashups, the Aussie way

TPACK is huge in Australia (for instance see this note TPACK underpins Aussie Teacher Ed Restructuring). I am hopeful that one of these days this interest will translate into a trip down-under... It would be great to travel around the continent, giving talks, meeting...

Limerick on Math & Beauty

Image credit: eoliene_pe_campii Mathematical Beauty: A limerick Punya Mishra, Jan 27, 2010 Doesn’t it just gladden your heart to see These games we can play with infinity? How can one stay aloof From the elegance of a proof And remain immune to mathematics’ subtle...

On breaking the rules (and words)

My daughter on her blog has a new poem / haiku called Sweat, a haiku with one glich. She is in India right now where the temperatures are easily in the 90's - which I guess explains the genesis of the poem. What was more interesting, to me however, was the manner in...

Vote for Leigh

Leigh Wolf, is many things: techie, teacher, foodie, and friend. She is also a doctoral student in our program and coordinator of our Master's in Educational Technology Program. Recently Leigh was nominated and short-listed for the Learning without Frontiers awards in...

Hype & Luck: Gratuitous Self-Promotion (2024 Edition)

Hype & Luck: Gratuitous Self-Promotion (2024 Edition)

It is natural, if you have been working in a field for a while, and have been somewhat successful, that some accolades will come your way, just by dint of being around long enough. As Bing Chat wrote, when asked to create a funny, self-deprecating profile of me in the...

Creativity & Courage

Creativity & Courage

Here is the next article in our series Rethinking Technology & Creativity in the 21st Century for the journal TechTrends. This article features an interview with Dr. Yong Zhao, Foundation Distinguished Professor in the School of Education at...

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *