💻 Save 87.4% of your time (literally) when analyzing data

Hello folks,

It’s the dawn of a new week and with that, a new lesson on using AI, automation, and no-code to save you time.

I promise that this one is HUGE, and will likely feature this one again and again because of how powerful it is.

See below for how we can use AI + data analysis to literally save your hours and hours of work…

In this issue:

• 📕 Learn Something: Save hours with Code Interpreter to analyze data

• 💥 Trending Tool: Put AI right into your Google Sheets with SheetAI

• 🙃 Something Fun: Can AI play ping pong now? Not yet

Let’s get right into it…

📕 LEARN SOMETHING
Save hours with Code Interpreter to analyze data

It just works…

A phrase frequently used by many but not always justified. This is one of those times where it’s completely real and you will need to do a double take after reading below.

When doing simple data analysis, the two tools that people use are Excel and Pandas (Python). Excel is easy but limited, Python is hard but limitless.

Well, guess what? Code Interpreter, the newest technology from OpenAI is easy, limitless, and the easiest of them all!

The one data analyst tool to rule them all… More details below.

1) Upload a file

After you’ve turned on Code Interpreter (see instructions below), you can upload a file virtually in any data format (Excel, CSV, TSV).

Here I’ve uploaded a dataset that I pulled from IMDB for the top 1000 movies.

Code Interpreter even gives you its understanding of the dataset.

2) Ask questions

Now that ChatGPT has a file to play with, let’s ask some simple questions and see how easily it handles them.

Let’s ask, from to easy to hard.

• Which genre has the highest average IMDB movie rating?

• Which genre has the highest average gross revenue, with IMDB scores above 5?

• Which Director makes the longest movies, on average? Only include Directors who have made 2 or more movies. Include the movie titles as well.

Well, to our surprise, it took less than 1 minute to answer all those questions, correctly!

It did not sweat at all! We had a data analyst to the same, and it' took them ~8 minutes… so Code Interpreter is 87.4% faster!

3) Visual data

Code Interpreter can also create graphs for you with some quick instruction. These visualizations can get pretty complicated as well.

Let’s ask: Is there a relationship between the average movie budget and average gross revenue, by genre? Could you visualize that?

Let’s also try: Visualize a bar graph showing the average budget and average gross revenue by genre

4) There’s more

In this post, we are barely scratching the surface here.

There is so much Code Interpreter can do, like downloading analysis, statistical tests, adding traceability, data cleaning, and much more.

To watch our full deep dive video on Code Interpreter, watch here [30min].

📊 5) Turn on Code Interpreter

To use Code Interpreter, you need to have a ChatGPT Plus account, which you can get here. It’s about $20 / month, and we highly endorse it here at the TIW.

To add the plugin, go into your Settings —> Beta features, and toggle Code Interpreter on. After that, when you hover over GPT-4, you’ll be able to select that plugin.

Related tutorials:

• Code interpreter - The dawn of a new era in data analysis: 7min 📰

• Examples of Code Interpreter - full list of possibilities: 20min 📰

• Deep dive in Code Interpreter - detailed 1hr walkthrough: 61min 🎬

• Power BI + AI - a full list of AI features in Power BI: 5min 📰

• TableauGPT - GPT within Tableau to do analysis: 7min 🎬

💥 TRENDING TOOL
Put AI right into your Google Sheets with SheetAI

Ever wish you can use ChatGPT directly in your spreadsheets?

SheetAI solves this in the most beautiful way possible, by creating custom formulas that leverage OpenAI’s ChatGPT API.

It makes tedious and time-consuming tasks pretty easy and fast, especially if you use Google Sheets already.

Here are a 2 quick examples:

• Use ChatGPT prompts directly in Google Sheets

• Populate data with the SHEETAI_FILL formula

Other cool tools:

• Equals - spreadsheets with built-in connections to databases

• Viable - Use GPT4 to leverage insights from your data

• Sheety - Turn your Google Sheets into an API, updated dynamically

• PolymerSearch - BI tool —> quicker and easier than Power BI / Tableau

• Data analysis prompts with ChatGPT - Over 4800+ prompts

🙃 SOMETHING FUN
Can AI play ping pong now? Not yet

This video has gone completely viral over the weekend. It shows a robot competing on the Ping Pong grand stage.

This does look like something from Boston Dynamics, but it’s (fortunately) a fake.

The RunwayML tool was used to super-impose a model over an actual professional Ping Pong player, from this video.

So far, we’re safe from robots taking over our sports… or are we?

ℹ️ ABOUT US

The Intelligent Worker helps you to be more productive at work with AI, automation, no-code, and other technologies.

We like real, practical, and tangible use-cases and hate hand-wavy, theoretical, and abstract concepts that don’t drive real-world outcomes.

Our mission is to empower individuals, boost their productivity, and future-proof their careers.