College Majors And Their Graduates
Job Opportunities, Salaries and Gender Disparities
@kaggle.thedevastator_uncovering_insights_to_college_majors_and_their
Job Opportunities, Salaries and Gender Disparities
@kaggle.thedevastator_uncovering_insights_to_college_majors_and_their
By FiveThirtyEight [source]
This repository contains a comprehensive selection of lavish data and processing scripts behind the articles, graphics, and interactive experiences generated by FiveThirtyEight. With this dataset, you'll have the power to explore college programs and their graduates like never before and create stories of your own! Whether you use it to check our work or craft your own powerful visuals, we would absolutely love to know if you found it useful. Under the Creative Commons Attribution 4.0 International License and MIT License respectively, our data is available for anyone who chooses to use it. Let us know how our resources turned out at
For more datasets, click here.
- 🚨 Your notebook can be here! 🚨!
- Create an interactive comparison tool for researching college majors and their earning potential, so that prospective students can make informed decisions about what to study.
- Analyze the proportions of male and female graduates across different majors to uncover gender disparities in higher education.
- Explore the correlations between major categories, average salaries earned by graduates from specific major categories, unemployment rates for those with specific majors and more – to identify trends in job opportunities for certain specialties of study
If you use this dataset in your research, please credit the original authors.
Data Source
License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.
File: majors-list.csv
| Column name | Description |
|---|---|
| FOD1P | First-level division of the field of study (String) |
| Major | The specific major of the field of study (String) |
| Major_Category | The broader category of the field of study (String) |
File: recent-grads.csv
| Column name | Description |
|---|---|
| Major | The specific major of the field of study (String) |
| Rank | The rank of the major in terms of popularity (Integer) |
| Major_code | The code associated with the major (Integer) |
| Major_category | The category of the major (String) |
| Total | The total number of students in the major (Integer) |
| Sample_size | The sample size of the major (Integer) |
| Men | The number of male students in the major (Integer) |
| Women | The number of female students in the major (Integer) |
| ShareWomen | The percentage of female students in the major (Float) |
| Employed | The number of employed graduates from the major (Integer) |
| Full_time | The number of full-time employed graduates from the major (Integer) |
| Part_time | The number of part-time employed graduates from the major (Integer) |
| Full_time_year_round | The number of full-time year-round employed graduates from the major (Integer) |
| Unemployed | The number of unemployed graduates from the major (Integer) |
| Unemployment_rate | The unemployment rate of graduates from the major (Float) |
| Median | The median salary of graduates from the major (Integer) |
| P25th | The 25th percentile salary of graduates from the major (Integer) |
| P75th | The 75th percentile salary of graduates from the major (Integer) |
| College_jobs | The number of college jobs held by graduates from the major (Integer) |
| Non_college_jobs | The number of non-college jobs held by graduates from the major (Integer) |
| Low_wage_jobs | The number of low-wage jobs held by graduates from the major (Integer) |
File: grad-students.csv
| Column name | Description |
|---|---|
| Major_code | The code associated with the major (Integer) |
| Major | The specific major of the field of study (String) |
| Major_category | The category of the major (String) |
| Grad_total | The total number of graduates from the major (Integer) |
| Grad_sample_size | The sample size of graduates from the major (Integer) |
| Grad_employed | The number of graduates employed (Integer) |
| Grad_full_time_year_round | The number of graduates employed full-time year-round (Integer) |
| Grad_unemployed | The number of graduates unemployed (Integer) |
| Grad_unemployment_rate | The unemployment rate of graduates (Float) |
| Grad_median | The median salary of graduates (Integer) |
| Grad_P25 | The 25th percentile salary of graduates (Integer) |
| Grad_P75 | The 75th percentile salary of graduates (Integer) |
| Nongrad_total | The total number of non-graduates from the major (Integer) |
| Nongrad_employed | The number of non-graduates employed (Integer) |
| Nongrad_full_time_year_round | The number of non-graduates employed full-time year-round (Integer) |
| Nongrad_unemployed | The number of non-graduates unemployed (Integer) |
| Nongrad_unemployment_rate | The unemployment rate of non-graduates (Float) |
| Nongrad_median | The median salary of non-graduates (Integer) |
| Nongrad_P25 | The 25th percentile salary of non-graduates (Integer) |
| Nongrad_P75 | The 75th percentile salary of non-graduates (Integer) |
| Grad_share | The share of graduates in the major (Float) |
| Grad_premium | The difference between the median salary of graduates and non-graduates (Integer) |
File: women-stem.csv
| Column name | Description |
|---|---|
| Rank | The rank of the major in terms of popularity (Integer) |
| Major_code | The code associated with the major (Integer) |
| Major | The specific major of the field of study (String) |
| Major_category | The category of the major (String) |
| Total | The total number of students in the major (Integer) |
| Men | The number of male students in the major (Integer) |
| Women | The number of female students in the major (Integer) |
| ShareWomen | The percentage of female students in the major (Float) |
| Median | The median salary of graduates from the major (Integer) |
File: all-ages.csv
| Column name | Description |
|---|---|
| Major_code | The code associated with the major (Integer) |
| Major | The specific major of the field of study (String) |
| Major_category | The category of the major (String) |
| Total | The total number of students in the major (Integer) |
| Employed | The number of employed graduates from the major (Integer) |
| Unemployed | The number of unemployed graduates from the major (Integer) |
| Unemployment_rate | The unemployment rate of graduates from the major (Float) |
| Median | The median salary of graduates from the major (Integer) |
| P25th | The 25th percentile salary of graduates from the major (Integer) |
| P75th | The 75th percentile salary of graduates from the major (Integer) |
| Employed_full_time_year_round | The number of employed graduates from the major who are employed full-time year-round (Integer) |
If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit FiveThirtyEight.
CREATE TABLE all_ages (
"index" BIGINT,
"major_code" BIGINT,
"major" VARCHAR,
"major_category" VARCHAR,
"total" BIGINT,
"employed" BIGINT,
"employed_full_time_year_round" BIGINT,
"unemployed" BIGINT,
"unemployment_rate" DOUBLE,
"median" BIGINT,
"p25th" BIGINT,
"p75th" DOUBLE
);CREATE TABLE grad_students (
"index" BIGINT,
"major_code" BIGINT,
"major" VARCHAR,
"major_category" VARCHAR,
"grad_total" BIGINT,
"grad_sample_size" BIGINT,
"grad_employed" BIGINT,
"grad_full_time_year_round" BIGINT,
"grad_unemployed" BIGINT,
"grad_unemployment_rate" DOUBLE,
"grad_median" DOUBLE,
"grad_p25" BIGINT,
"grad_p75" DOUBLE,
"nongrad_total" BIGINT,
"nongrad_employed" BIGINT,
"nongrad_full_time_year_round" BIGINT,
"nongrad_unemployed" BIGINT,
"nongrad_unemployment_rate" DOUBLE,
"nongrad_median" DOUBLE,
"nongrad_p25" BIGINT,
"nongrad_p75" DOUBLE,
"grad_share" DOUBLE,
"grad_premium" DOUBLE
);CREATE TABLE majors_list (
"index" BIGINT,
"fod1p" VARCHAR,
"major" VARCHAR,
"major_category" VARCHAR
);CREATE TABLE recent_grads (
"index" BIGINT,
"rank" BIGINT,
"major_code" BIGINT,
"major" VARCHAR,
"major_category" VARCHAR,
"total" BIGINT,
"sample_size" BIGINT,
"men" BIGINT,
"women" BIGINT,
"sharewomen" DOUBLE,
"employed" BIGINT,
"full_time" BIGINT,
"part_time" BIGINT,
"full_time_year_round" BIGINT,
"unemployed" BIGINT,
"unemployment_rate" DOUBLE,
"median" BIGINT,
"p25th" BIGINT,
"p75th" BIGINT,
"college_jobs" BIGINT,
"non_college_jobs" BIGINT,
"low_wage_jobs" BIGINT
);CREATE TABLE women_stem (
"index" BIGINT,
"rank" BIGINT,
"major_code" BIGINT,
"major" VARCHAR,
"major_category" VARCHAR,
"total" BIGINT,
"men" BIGINT,
"women" BIGINT,
"sharewomen" DOUBLE,
"median" BIGINT
);Anyone who has the link will be able to view this.