ChatGPT Prompts for Data Analysis

Enhance Data Analysis with ChatGPT Prompts. Discover AI-powered data insights,
visualization techniques, and advanced analytics for comprehensive data exploration.

Use Prompt

Show

entries

Search:

Prompts for Data Analysis	Prompt Details
Act as an Excel Sheet	I want you to act as a text based excel. you'll only reply me the text-based 10 rows excel sheet with row numbers and cell letters as columns (A to L). First column header should be empty to reference row number. I will tell you what to write into cells and you'll reply only the result of excel table as text, and nothing else. Do not write explanations. i will write you formulas and you'll execute formulas and you'll only reply the result of excel table as text. First, reply me the empty sheet.
Act as a Statistician	I want to act as a Statistician. I will provide you with details related with statistics. You should be knowledge of statistics terminology, statistical distributions, confidence interval, probabillity, hypothesis testing and statistical charts. My first request is "I need help calculating how many million banknotes are in active use in the world".
Act as a Scientific Data Visualizer	I want you to act as a scientific data visualizer. You will apply your knowledge of data science principles and visualization techniques to create compelling visuals that help convey complex information, develop effective graphs and maps for conveying trends over time or across geographies, utilize tools such as Tableau and R to design meaningful interactive dashboards, collaborate with subject matter experts in order to understand key needs and deliver on their requirements. My first suggestion request is "I need help creating impactful charts from atmospheric CO2 levels collected from research cruises around the world."
Act as a Fill in the Blank Worksheets Generator	I want you to act as a fill in the blank worksheets generator for students learning English as a second language. Your task is to create worksheets with a list of sentences, each with a blank space where a word is missing. The student's task is to fill in the blank with the correct word from a provided list of options. The sentences should be grammatically correct and appropriate for students at an intermediate level of English proficiency. Your worksheets should not include any explanations or additional instructions, just the list of sentences and word options. To get started, please provide me with a list of words and a sentence containing a blank space where one of the words should be inserted.
Write Python Code to Find the Best Classification Model	I want you to act as an automatic machine learning (AutoML) bot using TPOT for me. I am working on a model that predicts [...]. Please write python code to find the best classification model with the highest AUC score on the test set.
Need a Dataset with X Rows and Y Columns	I need a dataset that has x rows and y columns: [insert column names].
The Most Important KPIs for the Field	What are the most important KPIs for [insert industry/field].
Provide Mathematical Formulas for KPIs	Can you provide me with the mathematical formulas for the most important KPIs for [insert industry/field].
Give 4 Formulas in SQL Code	Can you give the 4 formulas for [metrics] in SQL code?
Generate an Example of a Transactions Dataset	Generate an example of a transactions dataset that [company] can create.
Write a SWOT Analysis for EGO Power Products	Please write a SWOT analysis for EGO power products.
Write Code to Tune Hyper Parameters	I want you to act as a data scientist and code for me. I have trained a [model name]. Please write the code to tune the hyper parameters.
Write Code for Data Visualization and Exploration	I want you to act as a data scientist and code for me. I have a dataset of [describe dataset]. Please write code for data visualization and exploration.
Oversample and Undersample Data	I want you to act as a coder. I have trained a machine learning model on an imbalanced dataset. The predictor variable is the column [Insert column name]. In python, how do I oversample and/or undersample my data?
Explain the Model's Results	I want you to act as a data scientist and explain the model's results. I have trained a decision tree model and I would like to find the most important features. Please write the code.
Describe Graph Requirements	I want you to act as a coder in python. I have a dataset [name] with columns [name]. [Describe graph requirements].
Describe the Organized Files	I want you to act as a coder. I have a folder of images. [Describe how files are organized in directory] [Describe how you want images to be printed].
Pretend as a SQL terminal	Pretend you are as a SQL terminal in front of an example database. The database contains tables named “Users”, “Items”, “Orders”, “Ratings”. I will type queries and you will reply with what the terminal would show. I want you to reply with a table of query results in a single code block, and nothing else. Do not write explanations or type commands unless I instruct you to do so. If I have to tell you something in English I will do so in curly braces {like this). Alright let’s get started . My first command is ‘SELECT TOP 10 * FROM Items ORDER BY Id DESC’.
Pretend as a Machine Learning Engineer	Pretend you are a machine learning engineer. I will write some machine learning concepts and it will be your job to explain them in easy-to-understand terms. This could contain providing step-by-step instructions for building a model, demonstrating various techniques with visuals, or suggesting online resources for further study. My first suggestion request is “I have a dataset without labels. Which machine learning algorithm should I use?”
Clean Data	I want you to act as a data analyst. I have a dataset of [describe dataset]. Please write python code to clean the data by removing missing values, duplicates, and outliers. Example: I want you to act as a data analyst. I have a dataset of customer orders that includes order ID, customer ID, order date, product ID, and quantity. Please write Python code to clean the data by removing missing values, duplicates, and outliers.
Generate Data	I want you to act as a fake data scientist. I need a dataset that has x rows and y columns: [insert column names]. Can you generate fake data for me?
Train Regression Model	I want you to act as a data scientist and code for me. I have a dataset of [describe dataset]. Please build a machine learning model that predicts [target variable] using a regression algorithm such as linear regression, random forest regression, etc.
Train Clustering Model	I want you to act as a data scientist and code for me. I have a dataset of [describe dataset]. Please build a machine learning model that groups the data into n clusters based on similarity using a clustering algorithm such as k-means, hierarchical clustering, etc.
Train Neural Network Model	I want you to act as a data scientist and code for me. I have a dataset of [describe dataset]. Please build a neural network model that predicts [target variable] using a deep learning framework such as TensorFlow, Keras, PyTorch, etc.
Merge Data	I want you to act as a data analyst. I have two datasets [describe datasets]. Please write python code to merge these datasets by joining them on a common column.
Reshape Data	I want you to act as a data analyst. I have a dataset of [describe dataset]. Please write python code to reshape the data from wide to long format or vice versa.
Group Data	I want you to act as a data analyst. I have a dataset of [describe dataset]. Please write python code to group the data by one or more columns and calculate summary statistics such as count, mean, median, etc.
Filter Data	I want you to act as a data analyst. I have a dataset of [describe dataset]. Please write python code to filter the data based on certain criteria, such as a range of values or a specific category.
Calculate Moving Average	I want you to act as a data analyst. I have a time series dataset [describe dataset]. Please write python code to calculate a moving average of the target variable over a window of n days.
Create Lagged Variables	I want you to act as a data analyst. I have a time series dataset [describe dataset]. Please write python code to create lagged variables of the target variable for n periods.
Calculate Percentage Change	I want you to act as a data analyst. I have a time series dataset [describe dataset]. Please write python code to calculate the percentage change of the target variable over a window of n days.
Normalize Data	I want you to act as a data analyst. I have a dataset of [describe dataset]. Please write python code to normalize the data by scaling each feature to have zero mean and unit variance.
Parallelize Code	I want you to act as a code optimizer. The following code is taking a long time to run. Can you parallelize it for me? [Insert code here]
Remove Special Characters in Python	Assume you are a Python developer. Can you develop a script that removes special characters and symbols from a given dataset?
Optimize Numpy	I want you to act as a code optimizer. Can you optimize the following numpy code? [Insert code here]
Refactor Code	I want you to act as a software developer. Can you refactor the following code for me? [Insert code here]
Write Regex	I want you to act as a coder. Please write me a regex in python that [describe regex].
Train Time Series	I want you to act as a data scientist and code for me. I have a time series dataset [describe dataset]. Please build a machine learning model that predict [target variable]. Please use [time range] as train and [time range] as validation.
Feature Engineering	I want you to act as a data scientist. I have a dataset of [describe dataset]. Please write python code to create new features from the existing ones using techniques such as one-hot encoding, binning, scaling, etc.
Memory Optimization	I want you to act as a code optimizer. The following code is consuming too much memory. Can you optimize it to reduce memory usage? [Insert code here]
Optimize Regular Expressions	I want you to act as a code optimizer. The following regular expression code is taking a long time to execute. Can you optimize it for me? [Insert code here]
Vectorize Code	I want you to act as a code optimizer. The following code is taking a long time to execute. Can you vectorize it for me? [Insert code here]
Optimize Pandas Apply Function	I want you to act as a code optimizer. The following Pandas apply function is taking a long time to execute. Can you optimize it for me? [Insert code here]
Optimize Matplotlib	I want you to act as a code optimizer. The following Matplotlib code is taking a long time to execute. Can you optimize it for me? [Insert code here]
Optimize Image Processing	I want you to act as a code optimizer. The following image processing code is taking a long time to execute. Can you optimize it for me? [Insert code here]
Optimize Network Communication	I want you to act as a code optimizer. The following code is performing network communication and taking a long time to execute. Can you optimize it for me? [Insert code here]
Optimize Database Queries	I want you to act as a code optimizer. The following code is performing database queries and taking a long time to execute. Can you optimize it for me? [Insert code here]
Optimize File I/O	I want you to act as a code optimizer. The following code is performing file I/O operations and taking a long time to execute. Can you optimize it for me? [Insert code here]
Optimize GPU Computing	I want you to act as a code optimizer. The following code is using a GPU and taking a long time to execute. Can you optimize it for me? [Insert code here]
Data Wrangling	I want you to act as a data wrangler. I have a dataset of [describe dataset]. Please write the code to manipulate the data into a format that is easy to work with.