create_sample_data.py

"""
Create Sample Data - One-time setup script
------------------------------------------
Generates data.xlsx with realistic sample rows for the automation agent.
Run once: python create_sample_data.py
"""

import pandas as pd
from pathlib import Path

# Sample data: id, name, company, city, website, status
SAMPLE_DATA = [
    {"id": 1, "name": "Sarah Chen", "company": "TechFlow Solutions", "city": "San Francisco", "website": "techflow.io", "status": "active"},
    {"id": 2, "name": "Marcus Johnson", "company": "GreenEnergy Corp", "city": "Austin", "website": "greenenergy.com", "status": "active"},
    {"id": 3, "name": "Emma Williams", "company": "DataDrive Analytics", "city": "Seattle", "website": "datadrive.io", "status": "pending"},
    {"id": 4, "name": "David Kim", "company": "CloudNine Software", "city": "New York", "website": "cloudnine.dev", "status": "active"},
    {"id": 5, "name": "Olivia Martinez", "company": "HealthFirst Medical", "city": "Boston", "website": "healthfirst.org", "status": "active"},
    {"id": 6, "name": "James Wilson", "company": "FinServe Banking", "city": "Chicago", "website": "finserve.com", "status": "inactive"},
    {"id": 7, "name": "Sophia Lee", "company": "EduTech Learning", "city": "Denver", "website": "edutech.edu", "status": "active"},
    {"id": 8, "name": "Michael Brown", "company": "LogiMove Transport", "city": "Atlanta", "website": "logimove.net", "status": "pending"},
    {"id": 9, "name": "Isabella Garcia", "company": "SecureNet Cybersecurity", "city": "Phoenix", "website": "securenet.io", "status": "active"},
    {"id": 10, "name": "Daniel Taylor", "company": "AgriGrow Farms", "city": "Minneapolis", "website": "agrigrow.com", "status": "active"},
]

def main():
    script_dir = Path(__file__).parent
    output_path = script_dir / "data.xlsx"

    df = pd.DataFrame(SAMPLE_DATA)
    df.to_excel(output_path, index=False, engine="openpyxl")
    print(f"Created {output_path} with {len(SAMPLE_DATA)} rows.")

if __name__ == "__main__":
    main()