Dummy Dataset Generation

Generate realistic dummy datasets for testing with customizable columns, constraints, and output formats (CSV, JSON, SQL, Python script). Creates executable scripts or direct data files for immediate use.

Use when: Creating test data, generating sample datasets, building realistic mock data for development, or populating test environments.

Arguments:

• $PRODUCT: The product or system name
• $DATASET_TYPE: Type of data (e.g., customer feedback, transactions, user profiles)
• $ROWS: Number of rows to generate (default: 100)
• $COLUMNS: Specific columns or fields to include
• $FORMAT: Output format (CSV, JSON, SQL, Python script)
• $CONSTRAINTS: Additional constraints or business rules

Step-by-Step Process

1. Identify dataset type - Understand the data domain
2. Define column specifications - Names, data types, and value ranges
3. Determine row count - How many sample records needed
4. Select output format - CSV, JSON, SQL INSERT, or Python script
5. Apply realistic patterns - Ensure data looks authentic and valid
6. Add business constraints - Respect business logic and relationships
7. Generate or script data - Create executable output
8. Validate output - Ensure data quality and completeness

Template: Python Script Output

import csv
import json
from datetime import datetime, timedelta
import random

# Configuration
ROWS = $ROWS
FILENAME = "$DATASET_TYPE.csv"

# Column definitions with realistic value generators
columns = {
    "id": "auto-increment",
    "name": "first_last_name",
    "email": "email",
    "created_at": "timestamp",
    # Add more columns...
}

def generate_dataset():
    """Generate realistic dummy dataset"""
    data = []
    for i in range(1, ROWS + 1):
        record = {
            "id": f"U{i:06d}",
            # Generate values based on column definitions
        }
        data.append(record)
    return data