Post

How to get URL link on X (Twitter) App

On the Twitter thread, click on or icon on the bottom
Click again on or Share Via icon
Click on Copy Link to Tweet
Paste it above and click "Unroll Thread"!
More info at Twitter Help

Mushtaq Bilal, PhD

Jul 10, 2023 • 12 tweets • 4 min read • Read on X

Scrolly

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.

• • •

Missing some Tweet in this thread? You can try to force a refresh

This Thread may be Removed Anytime!

Twitter may remove this content at anytime! Save it as PDF for later use!

More from @MushtaqBilalPhD

Mushtaq Bilal, PhD

@MushtaqBilalPhD

Apr 29

Chat Academia now lets you use your own OpenAI API key.

This will make the app much more affordable. You can use it to integrate 5 academic databases with ChatGPT.

Here's how to set your OpenAI API key in Chat Academia:

1. Go to platform[.]openai[.]com and sign up for an account.

2. Once you've logged in, click on "Start building" in the top-right corner.

Enter your name and select the level of your technical proficiency. Select "Create organization" and skip the next step.

Then click on "Generate API Key" and your API key will be generated.

Read 11 tweets

Mushtaq Bilal, PhD

@MushtaqBilalPhD

Apr 19

Most apps for academic research require paid subscriptions.

Here are 10 that are free:

1. Dimensions[.]ai

AI-powered database with 150M+ publications.

2. SemanticScholar[.]org

AI-powered database with 225M+ papers covering all academic fields.

Read 14 tweets

Mushtaq Bilal, PhD

@MushtaqBilalPhD

Apr 13

😢
ChatGPT: $20/m
Claude: $20/m
Gemini: $20/m
Access to academic databases❌

😃
Chat Academia: $15/m only

ChatGPT + Claude + Gemini.
Integrated with multiple academic databases✅

Here's how to use Chat Academia:

1. Go to and click on "Get started."

You will need to buy a subscription to use the app.

It has three plans: $15/m, $30/m, and $45/m. chatacademia.com

2. This is how the homepage of Chat Academia will look like.

Click on "AI Chat" in the top-left and then "Create chat" in the top-right.

In the chat interface, you will see multiple AI models and multiple academic databases. Select the model/databse you want to use.

Read 13 tweets

Mushtaq Bilal, PhD

@MushtaqBilalPhD

Apr 11

Most AI apps need paid subscriptions, but the Chinese are building apps that are free.

Bohrium is a free AI app built for researchers.

• Combines Deep Seek's reasoning model with academic databases.
• Gives detailed answers and cites published papers.

Here's how to use it:

1. Go to bohrium[.]com and click on "Log in" in the bottom-left corner.

Enter your email to sign up for a free account.

2. In the bottom-left of the chat box, you will see options for AI models and databases.

Bohrium has integrated databases for natural sciences, engineering, life sciences, and the humanities.

For detailed answers you can select "DeepThink."

Read 8 tweets

Mushtaq Bilal, PhD

@MushtaqBilalPhD

Apr 5

Finding relevant papers for literature review takes a lot of time and labor.

You can run visual searches from within Zotero to supercharge your literature — for free.

You can also do it with Mendeley and EndNote.

Here's how:

1. Go to github(dot)com/inciteful-xyz/inciteful-zotero-plugin

Scroll down a little and click on "Version 7 - latest release."

This will download an xpi file on your computer.

2. Open your Zotero desktop app.

Click on "Tools" and select "Plugins."

In the Plugins Manager, click on the Settings icon and select "Install Plugin From File."

Navigate to the xpi file you just download and add it.

Close the Plugin Manager.

Read 10 tweets

Mushtaq Bilal, PhD

@MushtaqBilalPhD

Apr 4

Biggest flaw of AI apps: hallucinations — fake references to papers that don't even exist.

Research Flow is a new app that solves this problem. It uses full text of papers to answer your questions.

Here's an overview of its features:

1. Go to rflow(dot)ai

Click on "Try for free" to sign up for a free account.

2. In the bottom-left of the search bar, you will three options: academic, web search, and text generation.

RFlow offers three models: Claude, Gemini, and DeepSeek's latest version V3.

RFlow supports English, Chinese, and Korean.