Skip to content

The focus of this study is on certain groups of graduates in computer science and engineering in order to better understand the unique job issues they confront.

Notifications You must be signed in to change notification settings

amiegirl/Analysis_of_AMCAT_Data

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 

Repository files navigation

Introduction

The dataset was released by Aspiring Minds from the Aspiring Mind Employment Outcome 2015 (AMEO). The study is primarily limited only to students with engineering disciplines. The dataset contains the employment outcomes of engineering graduates as dependent variables (Salary, Job Titles, and Job Locations) along with the standardized scores from three different areas – cognitive skills, technical skills and personality skills. The dataset also contains demographic features. The dataset contains around 40 independent variables and 4000 data points. The independent variables are both continuous and categorical in nature. The dataset contains a unique identifier for each candidate.

Business Problem

The focus of this study is on certain groups of graduates in computer science and engineering in order to better understand the unique job issues they confront. For instance, certain job specializations pay better than others.

Objectives of the Project

  • To unravel employment outcomes of computer science and engineering graduates
  • identify possible factors that influence compensation.

Research Question

  • After doing your Computer Science Engineering if you take up jobs as a Programming Analyst, Software Engineer, Hardware Engineer and Associate Engineer you can earn up to 2.5-3 lakhs as a fresh graduate?

Exploratory Data Analysis

Data Cleaning Steps

  • The data contains no duplicate values.
  • I removed 0 values from the graduation year column
  • I Converted 'ID', '12graduation', 'CollegeID', 'CollegeTier', 'CollegeCityID', 'CollegeCityTier', 'GraduationYear' columns to object data types
  • I removed outliers from the salary column.
  • I replaced negative values in the AMCAT scores columns with nan
  • I corrected spelling errors and replaced negative and 0 values with nan in the object columns - 'Designation', 'JobCity', '10board','12board'

Data Manipulation Steps

  • I created 'age_at_hire' column by subtracting Date of joining (DOJ) from Date of Birth (DOB) and filtered data for age values of 18 and above.

Univariate analysis steps

  • I plotted a frequency distribution of each numerical column.
  • I plotted the count of each categorical variable in the dataset

Bivariate analysis steps

  • I identified relationships between numerical columns using a heatmap.
  • I identified the relationship between degree attained and salary.
  • I identified the relationship between each degree attained with gender and salary.
  • I Identified the relationship between college level and salary
  • I Identified the relationship between gender and salary.
  • I plotted a count of each specialization based on gender.
  • Investigated the compensation plans of certain job specialization. I visualized the salary distribution of job designations - Programming Analyst, Software Engineer, Hardware Engineer and Associate Engineer

Insights Findings

A normal distribution can be seen in the majority of the numerical variables. Few have a right skew.
Employee salaries often range from 100,000 to 400,000.
Ages 21 to 24 make up the majority.
The majority of employees' college GPAs range from 62 to 80.
image


The majority of workers hold a bachelor's degree. Few people possess an MCA, an M.Tech, or an M.E.
image


The most popular specialization among workers is electronics and communication engineering, which is followed by computer science and engineering and information technology. image


The most prevalent designation among workers is software engineering.
image


The majority of the workforce is based in Bangalore.
image


There heatmap shows no relationship between the salary and the candidate's scores, age, or other numerical factors.
image


The average salary of employees holding a master's degree in Technology or Engineering is higher.
image


Workers with tier 1 college degrees typically earn higher money.
image


On average, females earn less money than males.
image

In comparison to males, females who hold a master's degree earn more money.
image


In every specialization but biotechnology, where there are more females, males predominate, whereas in information and communication technology, only females are found.
image


Programmer analysts, software engineers, hardware engineers, and associate engineers earn up to 2.5 and 3 lakhs, with software engineers being the highest earners
image


Conclusion

The findings from the Analysis of Employment outcomes of computer science and engineering graduates shows us the salary for different job specializations varies. Pay is not influenced by age or scores.

While males predominate in most specializations, there are more females in biotechnology and solely females in information and communication technology. Workers with tier 1 college degrees typically earn higher money. The degree earned plays a significant role in determining compensation; those with master's degrees in Technology or Engineering typically earn more money. Even still, on average, females earn less money than males. In comparison to males, females who hold a master's degree earn more money.

Salary comparison indicates that programmer analysts, software engineers, hardware engineers, and associate engineers earn up to 2.5 and 3 lakhs, with software engineers being the highest earners.

About

The focus of this study is on certain groups of graduates in computer science and engineering in order to better understand the unique job issues they confront.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published