Thread by @MushtaqBilalPhD

ChatGPT's latest update — Code Interpreter — is a powerful data assistant.

But many folks still don't know about it.

Here's how to use Code Interpreter to sort and visualize data in an Excel sheet.

A video tutorial:

To use Code Interpreter, you will need to enable it first.

Go to your ChatGPT account's Settings and click on Beta Features. Then enable Code Interpreter.

Next open a new chat and click on GPT-4 and select Code Interpreter.

I am uploading an Excel sheet to ChatGPT.

It contains names of hundreds of speakers who participated in the Karachi Literature Festival from 2010-2018.

Now if I want to know many times a speaker participated, it'll take me a lot of time and effot.

But with Code Interpreter you can do in seconds.

Before uploading the Excel sheet, it's a good idea to prime ChatGPT.

Ask it if it can help you analyze data in an Excel sheet. It will say yes.

Upload the Excel sheet and let ChatGPT process it.

Tell ChatGPT a bit about the data in the Excel sheet and ask your question.

I asked it to give me names of ten speakers who appeared most often during the period. And it answered in seconds.

Want to learn how to use AI-powered apps to supercharge your academic writing?

I have a complete tutorial (250+ slides) for you.

It's being used by 2,200+ academics including those at Harvard, Princeton, Yale, and Stanford.

You can get it here:
efficientacademicwriter.carrd.co

ChatGPT is notorious for "hallucianting" or making things up. So, I wanted to see if its answers are accurate or not.

I went to the Excel sheet and looked up how many times the writer Kishwar Naheed's had appeared — 9 times.

ChatGPT's answer was 9 too. Correct.

I raised the stakes a bit and asked ChatGPT to give me a table that shows how many times every speaker has appeared during the period.

ChatGPT gave me a table and said that the complete table is too large to display.

So, I asked ChatGPT to create a CSV file of the table.

And here is the CSV file that ChatGPT created for me.

Extremely helpful and efficient.

You can also ask ChatGPT to create graphs for you.

I asked it create a graph for yearly attendance and another to compare the number of English and Urdu sessions during the festivals.

Final words: AI powered tools are here to stay. Start learning about them. The demand for AI skills is only going to increase in the future.

Found this tutorial helpful?

1. Scroll to the top and retweet the first tweet to share it with your friends.

2. Bookmark it so you can come back to it later.

3. Follow me for regular threads on how to use AI apps for academic purposes.