search

fivethirtyeight / data

Data and code behind the articles and graphics at FiveThirtyEight
https://data.fivethirtyeight.com/
Creative Commons Attribution 4.0 International
16.7k stars 10.96k forks source link

interpreting data from college-majors #250

Closed yifanwu closed 1 year ago

yifanwu commented 4 years ago

Hi folks, thanks for sharing the data (digging through the raw PUMA data would have been a pain).

I was hoping to get an explanation for how Total does not equal Employed plus Unemployed, and also not the sum of College_jobs, Non_college_jobs, and Low_wage_jobs---they are supposed to add up right?

Thanks!

mathematicalmichael commented 4 years ago

@yifanwu could you please post the numbers you're getting and a code sample? that's certainly ... odd...

djingoule commented 4 years ago

Hi, I have been digging the datasets and I came to the same questions. In that screenshot of grad-students.csv, the sum of grad_employed and grad_unemployed colums is not equal to grad_total. Thank you for looking at it.

Screenshot 2020-05-02 at 13 20 00
bycoffe commented 1 year ago

The Employed and Unemployed numbers include only people who are in the workforce. (People who are not looking for work or who are out of the workforce for another reason are excluded. People employed by the military also aren’t included.) For the GENERAL AGRICULTURE major, for example, 35,291 people who graduated with that major are not in the labor force, and 189 are employed by the military. Adding those to the Employed (90,245) and Unemployed (2,423) numbers results in the Total, 128,148.