department_hierarchy.py

import pandas as pd
import random

# Define departments and create a sample hierarchy
departments = [
    'Executive', 'Finance', 'HR', 'IT', 'Marketing', 'Sales', 'Engineering',
    'Customer Service', 'Product Development', 'Legal', 'Operations', 'R&D'
]

# Generate random hierarchy relationships
data = []
for i in range(1, len(departments)):
    # Choose a random parent department from earlier in the list for hierarchy structure
    parent_dept = departments[random.randint(0, i - 1)]
    child_dept = departments[i]
    data.append({'Parent_Department': parent_dept, 'Sub_Department': child_dept})

# Convert to a DataFrame and save as CSV
df = pd.DataFrame(data)
df.to_csv('department_hierarchy.csv', index=False)

print("Department hierarchy dataset created and saved as 'department_hierarchy.csv'.")