The two tables I merged are:
HD2020 (00_source_data/college_enrollment_data/college_name.csv) and EF2020B (00_source_data/college_enrollment_data/enrollment_data.csv) from IPEDS_2020_2021 dataset
The merged file is: 17_college_enrollment_data_merge.csv present inside the 20_intermediate_files. This csv file is a merged table of college name and enrollment stats.
The column EFAGE09 consists the total enrollment. I have also manually verified these total enrollment stats with the numbers provided on google. The next step would be to merge this data with the 30_campuses_w_dist_to_nearest_pp.
The Code is: college_enrollment_data.py (10_code/20_merge_data/college_enrollment_data.py
WIP
The two tables I merged are: HD2020 (00_source_data/college_enrollment_data/college_name.csv) and EF2020B (00_source_data/college_enrollment_data/enrollment_data.csv) from IPEDS_2020_2021 dataset
The merged file is: 17_college_enrollment_data_merge.csv present inside the 20_intermediate_files. This csv file is a merged table of college name and enrollment stats.
The column EFAGE09 consists the total enrollment. I have also manually verified these total enrollment stats with the numbers provided on google. The next step would be to merge this data with the 30_campuses_w_dist_to_nearest_pp.
The Code is: college_enrollment_data.py (10_code/20_merge_data/college_enrollment_data.py