- The Art of AI Content Creation
- Posts
- Tut: Data Analysis using ChatGPT Prompts
Tut: Data Analysis using ChatGPT Prompts
Also, Google Bard AI update + AI Writing Course +10 AIs for Academic Reserach.
Sharyph
April 23, 2023
Welcome to today’s version of AiSuite.
By the way, if you don’t have my favorite AI tools, You can get them here.
(I am updating this tool suite regularly, now you can find the tutorial section as well)
Let's get started!
📒 In today's edition:
🧠 Top Stories in AI Space
📚️ Lessons (Data Analysis using Prompts)
⚡️ Trending AI Tools
🎬️ AI Tutorial
💥 My Best Read about AI
Read time - 5 minutes
Today’s Top AI Tool
Revolutionize your Screen Recording with Vento - the ultimate tool for flawless recordings.
Tired of hitting the record, only to realize you made a mistake halfway through? With Vento, you can pause, rewind a few seconds, and re-record with ease. No more starting over from scratch or settling for a subpar recording. Plus, with the ability to jump to the last rewind point and re-record again and again, you'll have the confidence to record without fear of mistakes.
Upgrade your screen recording game with Vento today and experience the difference.
Want to promote your tools or services? Check here
📚️ Lessons
Exploratory Data Analysis (EDA) using ChatGPT
EDA is to:
→Examine the data distribution
→Handling missing values of the dataset
→Handling the outliers
→Removing duplicate data
→Encoding the categorical variables
→Normalizing and Scaling the data
For this, we are going to use a dataset about heart disease.
In this process, I am going to show you 7 ChatGPT prompts and conclude with insights about this Dataset.
Prompt 1
“I want you to act as a data scientist and analyze the dataset. Provide me with the exact and definitive answer for each question. Do not provide me with the code snippets for the questions. The dataset is provided below. Consider the given dataset for analysis. The first row of the dataset contains the header.”
Now it is ready for my Dataset.
Prompt 2
[Copy and paste the Dataset from Excel to ChatGPT] (Including column headers)
ChatGPT has a character limit. So, it may not work with large Datasets with this method.
Prompt 3
"List down the numerical and categorical columns"
This will helps us understand the dataset better by generating summary statistics for numerical data in the dataset and providing count, unique most frequent value, and corresponding frequency for categorical features
Prompt 4
“Check for NANs present in the dataset? If yes, print the no. of nans in each column.”
Checking for NaNs in a dataset helps us find missing values Missing values can cause problems when modeling the data. We can remove or impute missing values by identifying them.
Prompt 5
“Are there any outliers in the dataset?”
Checking for outliers because it can, →Skew a dataset's mean →Standard deviation →which can lead to incorrect conclusions about the data1.
By identifying outliers, we can decide whether to remove them or transform them.
Prompt 6
“Name the columns that contain the outliers. Provide me with the exact answer.”
Prompt 7
“What are the significant factors that affect heart attack based on the correlation between the features (columns) in the dataset and the targeted variable (output). You can do a correlation analysis to find out which features have a significant positive or negative correlation with the target variable.”
Here, I want to know which features are correlated with heart attacks. [Main Problem Course]
ChatGPT also explained how it came to that conclusion.
Next
Now, these questions can go on... based on the desired output or the question you want to answer.
I haven't gone deep into this, I just want to show you how you can use ChatGPT as a data analyst effectively.
Also, I have a gift for you
I have prepared a Notion file with the most commonly used ChatGPT Prompts in
SQL
Python
R
for Data Analysis.
You can get them here for FREE.
By the way, if you are not new to my newsletter, you may find this [Lessons] section new. I hope you like this.. In this section, my main aim is to educate you guys by sharing what I have been learning and experiencing.
You may not find this section everyday. But I will try to share a lesson like this every week.
🧠 2 Top Stories in AI Space
Bill Gates says A.I. chatbots will teach kids to read within 18 months.
“The AI’s will get to that ability, to be as good a tutor as any human ever could,”
Google’s Bard AI chatbot can now help you code and create functions for Google Sheets
For programmers in writing and debugging code, Google is upgrading its Bard AI chatbot. Code generation is supported by rivals like ChatGPT and Bing AI, but according to Google, it has been "one of the top requests" since Bard access was made available last month.
Now, Bard is capable of writing functions for Google Sheets as well as writing new code, debugging older code, and explaining lines of code. "We're launching these capabilities in more than 20 programming languages, including C++, Go, Java, Javascript, Python and Typescript," says Paige Bailey.
⚡️ Trending Tools
Takasbai tool for organizing and completing copywriting, email, and report assignments. visit here
WordTune to summarize documents and identify key points with AI visit here
Librarian AI Discover your Favorite Book Powered by AI visit here
Merlin Gives you the power of OpenAI ChatGPT Plus on all your favorite sites for free visit here
Reface AI app to face-swap in GIFs and videos. visit here
Hints integrate with any software to perform tasks on your behalf visit here
Ess AI users quickly and easily create websites by specifying their desired design or content. visit here
Meet Geek Maximize the value of your meetings visit here
Slide Sai Create Presentation Slides with AI in seconds visit here
Myask AI Your own fully customizable ChatGPT that uses only your content and can be used wherever you want. visit here
🎬️ Ai Tutorial
AI Writing Course
💥 My Best Read
Top 10 AI Tools for Academic Research
We have come to the end.
Reply