Project 2 - Analysis of the choices of Alumni's of two colleges Using MySQL, MS Excel and Python

The project aims to analyze the career choices of alumni from two universities with respect to their passing year and course completed. Six CSV files containing alumni records for higher studies, self-employment, and service/job records of College A and College B will be used in the analysis. The tasks include creating a new schema for alumni, importing all CSV files into MySQL, displaying the first 1000 rows of six tables using Python, importing all records of tables into MS Excel, performing data cleaning on all tables and storing cleaned data in views, creating a procedure to use string functions for converting record of Name, FatherName, MotherName into lowercase for views, importing the created views into MS Excel and making pivot charts for the location of alumni, and writing queries to create procedures to fetch names of all students from College A and College B. Lastly, the percentage of career choices for College A and College B alumni will be calculated with respect to higher studies, self-employment, and service/job.