data_generation_used.py

import csv
from faker import Faker
import random

# Initialize Faker
fake = Faker()

# Define batch numbers and domains of study
batches = ['19', '20', '21', '22', '23']
departments = ['Computer Science', 'Artificial Intelligence', 'Business Analytics', 'Software Engineering', 'Electrical Engineering']

# Define the desired number of students in each department
department_counts = {
    'Computer Science': 400,
    'Artificial Intelligence': 500,
    'Business Analytics': 600,
    'Software Engineering': 700,
    'Electrical Engineering': 300
}

# Generate synthetic student data
def generate_student_data():
    students = []
    for department, count in department_counts.items():
        for _ in range(count):
            batch = random.choice(batches)
            roll_number = f"{batch}F-{random.randint(1000, 9999)}"
            first_name = fake.first_name()
            last_name = fake.last_name()
            students.append({'Roll Number': roll_number, 'First Name': first_name, 'Last Name': last_name, 'Batch': batch, 'Domain': department})
    return students

# Generate synthetic student data
student_data = generate_student_data()

# Save student data to CSV file
csv_file = "student_data.csv"
fieldnames = ['Roll Number', 'First Name', 'Last Name', 'Batch', 'Domain']

with open(csv_file, mode='w', newline='') as file:
    writer = csv.DictWriter(file, fieldnames=fieldnames)
    writer.writeheader()
    for student in student_data:
        writer.writerow(student)

print(f"Student data has been saved to {csv_file}.")