/Nit-Kurukshetra-OnCampus-Placements-2021

This repo has 2021 on-campus placements data of Nit Kurukshetra.

Primary LanguageJupyter Notebook

Objective

This repo contains the data and maybe some Stats of On-Campus Placements in Nit Kurukshetra of 2021 Batch. I have stitched this repo to serve some purposes:

  1. So that Juniors can take informed decisions while preparing for placements.
  2. To make the Placement-data Public so that people can run numbers.
  3. To learn what it takes to gather the data.
  4. Run some numbers myself and find some interesting things from the data.

How did I collect data?

  1. I used the Gmail API to scrap the emails that have the invariant that they have placement or recruitment or drive in them.
  2. Then I automated collecting some data points like JobLocation, CompanyName, and MinCgpa, etc.
  3. One more long day went into structuring the data.

About Data

  1. The data in data.csv have these different data-columns.
  2. The data in data_with_ctc.csv adds just one more column to the above columns.
Column Name Description
CompanyName Name of the company, Example: Oneplus
JobProfile What will you be doing, Example: Software Developer, Analyst, etc.
JobLocation Where the job is located
EligibleBranches Branches allowed to sit for the exam, Example: cs, it
MinCgpa Minimum CGPA required by the company, Example: 7.5
IIITAllowed 1 if IIIT was Allowed, 0 if IIIT was not allowed, 0.5 if I couldn't figure it out
CTC Initial CTC offered by the company

RESULTS

Note: Please read data_explore.ipynb for detailed explanation.
Note: The data is of BTech students only. I have omitted all the details of MTech and MBA due to lack of resources.
* indicates data collected till March 1st, 2021. It will change in the future.

  1. Total Companies that came are: 114*.

  2. Total Different Profiles that students are placed in: 79*.

  3. Total Different Job Locations that students will go to in India: 49*.

  4. Branch wise distribution of Companies:

    Branch Companies Allowed
    CSE 86
    IT 81
    ECE 82
    EE 65
    MECH 47
    PIE 38
    CIVIL 29

  5. CGPA Requirements:

    CGPA Eligibility Description
    8 100 percentile (you can sit for >=100% of the companies)
    7 75 percentile (you can sit for >= 75% of the companies)

A Little Appreciation

  1. I would like to thank all the TnP and individual Placement-Coordinators for working so hard in getting companies.
  2. Finally, some of my friends for the ~support they gave.

Caution

  1. I am the sole author of this data. I have scraped the data from my emails using the GMAIL API.
  2. I have no affiliation with any school, organization.
  3. The data will surely have discrepancies.
  4. Read or use at your own will.