Untitled

# Standardizing course names (capitalization and splitting if needed)
final_cleaned_data = []

for entry in final_course_schedule_data:
    faculty = entry["Faculty"]
    days_available = entry["Days Available"]

    # Ensuring all courses are capitalized and properly formatted
    qualified_courses = [course.upper().strip() for course in entry["Qualified Courses"] if course.strip()]
    
    final_cleaned_data.append({
        "Faculty": faculty,
        "Days Available": days_available,
        "Qualified Courses": qualified_courses
    })

# Creating the final structured DataFrame
df_final_cleaned_schedule = pd.DataFrame(final_cleaned_data)
df_final_cleaned_schedule.head()