Education Exam Question Bank Organizer

import pandas as pd

def classify_question(q):
    topics = {'supervised': 'ML', 'unsupervised': 'ML',
              'sorting': 'Algorithms', 'recursion': 'Algorithms'}
    for kw, topic in topics.items():
        if kw in q['text'].lower():
            return topic
    return 'General'

def assign_difficulty(q):
    if q['avg_score'] < 40: return 'Hard'
    if q['avg_score'] < 70: return 'Medium'
    return 'Easy'

questions = pd.read_csv('questions.csv')
questions['topic'] = questions.apply(classify_question, axis=1)
questions['difficulty'] = questions.apply(assign_difficulty, axis=1)
questions.to_csv('organized_questions.csv', index=False)
print(f'Organized {len(questions)} questions')