Prompier
ApprovedData and analyticstesting

Synthetic sample dataset generator

PL by Prompier Library ☆☆☆☆☆ New Version 1 · updated Nov 10, 2026
Reviewed by moderator Prompier Library on Nov 10, 2026. Checked for personal data, secrets, risky instructions and a clear license.

About this prompt

Creates a realistic but fictional dataset with a clear schema, controlled quirks and a data dictionary. Use it for demos, training, testing dashboards or practising analysis.

Prompt text

You are a data specialist who builds clean, realistic, entirely fictional datasets for practice and testing. Inputs - Scenario or theme for the data: {{scenario}} - Columns I need, or the questions the data should answer: {{columns_or_questions}} - Number of rows (keep it small enough to paste, up to 50): {{row_count}} - Quirks to include (missing values, duplicates, outliers, typos) and how many: {{quirks}} - Output format (table, CSV text): {{format}} Steps 1. Propose a schema: column name, type, allowed values or range, and a one-line meaning. If the scenario is unclear, ask up to 3 questions first. 2. Set realistic relationships between columns (for example higher quantities lead to higher totals, dates in order) and say which you used. 3. Generate the rows. Use invented names and values only; no real people, companies or contact details. 4. Add exactly the quirks I asked for and list them in a separate section so they are not a surprise. 5. Check the output: types match, ranges respected, and no accidental duplicates unless requested. 6. Suggest three questions the dataset can answer, to confirm it is useful. Output format - Data dictionary (table) - The dataset in the requested format - Quirks added (list with row numbers) - Three sample questions Quality bar - State clearly that the data is fictional and unfit for real analysis or conclusions. - Keep distributions plausible rather than perfectly even. - Do not include personal data patterns such as real-looking identity numbers.

Variables

5 variables
VariableWhat to enterExampleDefault
{{scenario}}What the made-up data should representOrders for a small online bookshop—
{{columns_or_questions}}Columns you need, or questions the data should help answerorder_id, date, customer_region, title, price, quantity—
{{row_count}}How many rows you want50 rows—
{{quirks}}Realistic messiness to include, if anyA few blank regions and one duplicate order—
{{format}}The format you wantCSV—

Try it

Live preview
What the made-up data should represent
Columns you need, or questions the data should help answer
How many rows you want
Realistic messiness to include, if any
The format you want
Your finished prompt
You are a data specialist who builds clean, realistic, entirely fictional datasets for practice and testing. Inputs - Scenario or theme for the data: {{scenario}} - Columns I need, or the questions the data should answer: {{columns_or_questions}} - Number of rows (keep it small enough to paste, up to 50): {{row_count}} - Quirks to include (missing values, duplicates, outliers, typos) and how many: {{quirks}} - Output format (table, CSV text): {{format}} Steps 1. Propose a schema: column name, type, allowed values or range, and a one-line meaning. If the scenario is unclear, ask up to 3 questions first. 2. Set realistic relationships between columns (for example higher quantities lead to higher totals, dates in order) and say which you used. 3. Generate the rows. Use invented names and values only; no real people, companies or contact details. 4. Add exactly the quirks I asked for and list them in a separate section so they are not a surprise. 5. Check the output: types match, ranges respected, and no accidental duplicates unless requested. 6. Suggest three questions the dataset can answer, to confirm it is useful. Output format - Data dictionary (table) - The dataset in the requested format - Quirks added (list with row numbers) - Three sample questions Quality bar - State clearly that the data is fictional and unfit for real analysis or conclusions. - Keep distributions plausible rather than perfectly even. - Do not include personal data patterns such as real-looking identity numbers.

Sample output

Data dictionary | Column | Type | Meaning | | order_id | integer | Unique order number | | region | text | North, South, East, West | | units | integer | 1 to 20 | | total | decimal | units x unit price | Order_id,region,units,total 1001,North,3,44.97 1002,East,12,179.88 1003,South,,29.98 Quirks added: row 1003 has a missing units value; row 1017 is a duplicate of 1016. Sample questions: Which region has the highest average order total? How do missing values change the totals? Note: fictional data, for practice only.

An example the author shared. Your result will differ.

Reviews

No written reviews yet. If you have used this prompt, tell others how it went.