Task prompt · Data
Write a data dictionary for my dataset
by Agent Yard TeamGet a clear table that explains every column: meaning, type, allowed values and gaps.
Use cases
- Get a clear table that explains every column: meaning, type, allowed values and gaps.
- When you already have a file and want the AI to work from it instead of starting from scratch.
- As one step of the Make sense of your data prompt pack.
Featured in: Best AI prompts for cleaning messy data.
How to use it
- Open chatgpt.com or claude.ai (or another AI listed here).
- Attach the file (PDF, Word, CSV or Excel), or paste its text into the prompt.
- Copy the prompt, paste it into the chat and send.
- Works best with CSV or Excel files under a few thousand rows.
Prompt
Read the attached dataset and write a data dictionary for it. For every column give: - column name - what it means in plain words (say "unclear" if you can't tell) - data type (text, number, date, yes/no, ID) - example values - allowed values or range you observe - share of empty or invalid values Then list columns whose meaning I should confirm with whoever made the file. Don't invent meanings you can't support from the data.
One email a week
The Weekly is presented byyour brandSponsored · openThe best new prompts and personas, nothing else.