Citizen Data ScientistExploratory AnalysisBeginnerSingle prompt

My First Dataset Exploration AI Prompt

I just received a new dataset and I am not sure where to start. Help me explore it step by step. 1. Tell me the basics: - How many rows and columns does this dataset have? - Wha... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
I just received a new dataset and I am not sure where to start. Help me explore it step by step.

1. Tell me the basics:
   - How many rows and columns does this dataset have?
   - What does each column appear to represent based on its name and values?
   - What time period does the data cover, if it has dates?
   - What does one row in this dataset represent? (e.g. one customer, one order, one day)

2. What is the data quality like?
   - Which columns have missing values, and how many?
   - Are there any columns where the values look wrong or impossible? (negative ages, future dates, prices of zero)
   - Are there any duplicate rows?

3. What are the most interesting things in this data?
   - Which numeric columns have the widest range of values?
   - Which categories appear most and least frequently in the text columns?
   - Is there anything in this data that immediately looks unusual or surprising?

4. What questions can this data answer?
   - Based on what you can see, list 5 business questions this dataset could help answer.

5. What should I look at first?
   - Given everything above, what is the single most interesting thing to explore next and why?

Write your response in plain English. Avoid technical jargon. Explain any terms you do use.

When to use this prompt

Use case 01

Use it when you want to begin exploratory analysis work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in Exploratory Analysis or the wider Citizen Data Scientist library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Tell me the basics:, How many rows and columns does this dataset have?, What does each column appear to represent based on its name and values?. The final answer should stay clear, actionable, and easy to review inside a exploratory analysis workflow for citizen data scientist work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in Exploratory Analysis.

Frequently asked questions

What does the My First Dataset Exploration prompt do?+

It gives you a structured exploratory analysis starting point for citizen data scientist work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for citizen data scientist workflows and marked as beginner, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

My First Dataset Exploration is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Data Quality Red Flags, Find the Patterns, Plain English Data Summary.