search

nickeubank / mtv_viacom_capstone

1 stars 0 forks source link

Enrollment Data #95

Open nickeubank opened 2 years ago

nickeubank commented 2 years ago

Poking around at the website that Vaughan pointed us to, looks like we can get the full IPEDS dump here: https://nces.ed.gov/ipeds/use-the-data/download-access-database

In there is a variable called Fall Enrollment in this table:

EF2020CP | 22 | Major field of study,   race/ethnicity, gender, attendance status, and level of student: Fall 2020 | This table contains   the number of students enrolled in the fall, by race/ethnicity, gender,   attendance (full- or part-time) status and level of student for selected   major fields of study.  Major field of   studies included are Education, Engineering, Biological Sciences/Life   Sciences, Mathematics, Physical Sciences, Business Management and   Administrative Services, Law, Dentistry, and Medicine. This data file   contains enrollment data for 4-year institutions only.  Institutions with traditional academic year   calendar systems (semester, quarter, trimester or  4-1-4) report their enrollment as of   October 15 or the official fall reporting date of the institution.   Institutions with calendar systems that differ by program or allow continuous   enrollment report students that are enrolled at any time between August 1 and   October 31. This table has multiple records per institution.  Records are uniquely defined by the   variables IPEDS ID (UNITID), and the major field of study, attendance status   and level of student (EFCIPLEV).   Each   record will contain the total enrollment,    enrollment for men and women, and the total enrollment and enrollment   for men and women for all nine race/ethnicity categories. | Provisional | December   2021

Since y'all have learned SQL, would one of you mind pulling the data from 2020, extracting that enrollment table, and merging it with our demographic data?

PranavM98 commented 2 years ago

I could look into this!

PranavM98 commented 2 years ago

Created a pull request with updates!

PranavM98 commented 2 years ago

After trying to merge the newest 30_campuses_w_dist_to_nearest_pp.geojson (Jasmine created) with the college_enrollment, 1527 colleges merged and 717 colleges did not merge. I have created the left only, right only merge files to start manual matching. Interestingly, many well known colleges present in our dataset is not present in the college_enrollment data.

adrianefresh commented 2 years ago

@nickeubank Do you want to comment on this merge? I want to make sure everyone doesn't invest in tedious manual merges if there's anything preferable that can be done given the tight timeline. If that is what it takes, understood. Just thought your opinion here might be helpful.

On Thu, Jan 13, 2022 at 2:55 PM Pranav Manjunath @.***> wrote:

After trying to merge the newest 30_campuses_w_dist_to_nearest_pp.geojson (Jasmine created) with the college_enrollment, 1527 colleges merged and 717 colleges did not merge. I have created the left only, right only merge files to start manual matching.

— Reply to this email directly, view it on GitHub https://github.com/nickeubank/mtv_viacom_capstone/issues/95#issuecomment-1012459872, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEXM52KXM5MWSVZBHMM5CN3UV4U4JANCNFSM5LSMWJ2Q . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you are subscribed to this thread.Message ID: @.***>