create_csv_files.py

import csv

def create_clusters_csv():
    """Create the initial clusters.csv file with proper headers"""
    with open('clusters.csv', 'w', newline='', encoding='utf-8') as file:
        writer = csv.writer(file)
        writer.writerow(['Keywords', 'Intent', 'Primary Keyword', 'Status'])

# Create clusters.csv
with open('clusters.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Cluster', 'Keywords', 'Intent', 'Primary Keyword', 'Status'])
    # Add some sample data
    # writer.writerow(['1', 'ai tools, business productivity, automation', 'Learn about AI tools', 'ai tools for business', 'no'])
    writer.writerow(['2', 'Nanobotz it solutions company, nanobotz it solutions company details', 'nanobotz it solutions', 'nanobotz it solutions', 'no'])

# Create completed_posts.csv
with open('completed_posts.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Title', 'Keywords', 'Meta Description', 'URL'])