data icon indicating copy to clipboard operation
data copied to clipboard

interpreting data from college-majors

Open yifanwu opened this issue 5 years ago • 2 comments

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!

yifanwu avatar Mar 08 '20 21:03 yifanwu

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

mathematicalmichael avatar Mar 17 '20 15:03 mathematicalmichael

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

djingoule avatar May 02 '20 11:05 djingoule

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.

bycoffe avatar Dec 21 '22 21:12 bycoffe