Project 2
Dear Sir/ Madam
Once a student is passed out from a Institute or College, he/she is known as Alumni of
the Institute. Alumni’s career growth plays important role in Institute’s ranking and other
networking activities. In this project, career choices of alumni of two Universities will be
analyzed with respect to their passing year as well as the course the completed. Dataset:
Six .csv file (Alumni record of College A and College B) Higher Studies, Self Employed
and Service/Job record
· College_A_HS ~ Higher Studies Record of College A
· College_A_SE ~ Self Employed Record of College A
· College_A_SJ ~ Service/Job Record of College A
· College_B_HS ~ Higher Studies Record of College B
· College_B_SE ~ Self-Employed Record of College B
· College_B_SJ ~ Service/Job respectively Record of College B
outlining a project to analyze the career choices of alumni from two different universities
based on their passing year and the courses they completed.
Tasks to be Performed:
1. Data Preparation:
· Import the six CSV files containing the alumni records of both colleges.
· Merge the records from the corresponding files to create a comprehensive dataset.
2. Data Cleaning:
· Check for missing values, duplicates, and inconsistencies in the dataset.
· Standardize column names and formats for consistency.
3. Exploratory Data Analysis (EDA):
· Analyze the distribution of passing years and courses completed for both universities.
· Explore the proportion of alumni in each career choice category.
· Identify any trends or patterns in career choices over passing years and courses completed.
4. Comparative Analysis:
· Compare the career choices between College A and College B alumni.
· Investigate if there are any significant differences in career choices based on the university.
5. Temporal Analysis:
· Examine how career choices vary over passing years for both universities.
· Identify any temporal trends or shifts in career preferences.
6. Course-wise Analysis:
· Analyze the career choices among alumni based on the courses they completed.
· Determine if certain courses are more likely to lead to specific career choices.
7. Impact on Institute Ranking:
· Discuss how alumni career growth can influence the ranking of the institutes.
· Explore potential correlations between alumni career success and the reputation of the universities.
8. Networking Activities:
· Suggest strategies for leveraging alumni career data for networking activities.
· Discuss how the insights gained from this analysis can be used to strengthen alumni networks and engagement.
9. Visualization:
· Create visualizations (e.g., bar charts, line graphs) to present key findings from the analysis effectively.
· Use interactive plots if necessary to facilitate exploration of the data.
10. Conclusion and Recommendations:
· Summarize the key findings from the analysis.
· Provide recommendations for the universities based on the insights gained.
· Discuss potential areas for future research or analysis.