Project 2

This project aims to analyze the career choices of alumni from two universities based on their passing year and the course they completed. The dataset consists of six CSV files containing records of alumni from College A and College B. The records are divided into three categories: Higher Studies, Self Employed, and Service/Job. The tasks to be performed include creating a new schema called "alumni," importing all CSV files into MySQL, and running SQL commands to view the structure of the six tables. Additionally, the first 1000 rows of each table will be displayed using Python. All records from the tables will be imported into MS Excel, and data cleaning will be performed on College_A_HS and College_A_SE tables. The cleaned data will be stored in College_A_HS_V and College_A_SE_V views, respectively. The final deliverables will include a Jupyter notebook containing the Python code and an Excel file with the imported records.