224 lines
24 KiB
Plaintext
224 lines
24 KiB
Plaintext
2025-12-04 15:17:57,143 - DataAnalysis - INFO - Loading College Scorecard data from file data/scorecard/College_Scorecard_Raw_Data_05192025/merged.parquet (run.py:33)
|
|
2025-12-04 15:18:20,065 - DataAnalysis - INFO - Saving scorecard-only statistics (run.py:38)
|
|
2025-12-04 15:18:23,197 - Scorecard Data - INFO -
|
|
|
|
National Percentage (Last Academic Year): (scorecard_tools.py:135)
|
|
2025-12-04 15:18:23,209 - Scorecard Data - INFO -
|
|
|
|
National Percentage (Avg): (scorecard_tools.py:138)
|
|
2025-12-04 15:18:23,493 - Scorecard Data - INFO -
|
|
|
|
Program Percentage (The University of Alabama, Last Academic Year): (scorecard_tools.py:158)
|
|
2025-12-04 15:18:23,504 - Scorecard Data - INFO -
|
|
|
|
Program Percentage (The University of Alabama, Avg): (scorecard_tools.py:161)
|
|
/opt/conda/lib/python3.12/site-packages/openpyxl/styles/stylesheet.py:237: UserWarning: Workbook contains no default style, apply openpyxl's default
|
|
warn("Workbook contains no default style, apply openpyxl's default")
|
|
Name Percent (Last) Percent (Avg) Students (Last) Students (Avg)
|
|
35 health 22.149643 12.027962 5960.320075 NaN
|
|
36 business_marketing 14.511786 17.399856 3653.717364 NaN
|
|
15 humanities 10.181786 9.546438 3624.366286 NaN
|
|
8 education 7.426786 6.705871 2231.885475 NaN
|
|
6 computer 7.148571 2.808726 2416.331129 NaN
|
|
31 mechanic_repair_technology 6.220357 0.811160 1382.265304 NaN
|
|
27 security_law_enforcement 4.961071 3.019295 1735.563754 NaN
|
|
10 engineering_technology 3.409286 1.377941 962.291996 NaN
|
|
20 multidiscipline 2.957857 1.964365 981.708071 NaN
|
|
12 family_consumer_science 2.880357 1.222658 799.266364 NaN
|
|
32 precision_production 2.701429 0.379921 1043.298893 NaN
|
|
17 biological 2.671786 4.908001 913.827739 NaN
|
|
29 social_science 2.312143 6.253486 567.835936 NaN
|
|
28 public_administration_social_service 1.677500 1.601816 531.436800 NaN
|
|
26 psychology 1.285714 5.195744 529.515436 NaN
|
|
4 communication 1.136786 3.192944 456.121346 NaN
|
|
9 engineering 0.972143 2.803155 333.565925 NaN
|
|
34 visual_performing 0.807500 3.903754 287.056654 NaN
|
|
7 personal_culinary 0.698571 0.444786 246.205414 NaN
|
|
11 language 0.633929 0.951896 224.890446 NaN
|
|
18 mathematics 0.611071 1.048517 205.602029 NaN
|
|
21 parks_recreation_fitness 0.593214 1.885363 225.476271 NaN
|
|
30 construction 0.573571 0.317400 232.164054 NaN
|
|
13 legal 0.529286 0.366860 151.130189 NaN
|
|
24 physical_science 0.421429 1.598245 125.394396 NaN
|
|
14 english 0.237500 2.671756 91.474121 NaN
|
|
37 history 0.208929 1.670524 76.740832 NaN
|
|
22 philosophy_religious 0.072500 0.677424 26.515154 NaN
|
|
3 ethnic_cultural_gender 0.007500 0.368425 1.937561 NaN
|
|
1 resources 0.000000 0.700875 0.000000 NaN
|
|
5 communications_technology 0.000000 0.215724 0.000000 NaN
|
|
2 architecture 0.000000 0.243856 0.000000 NaN
|
|
0 agriculture 0.000000 0.819862 0.000000 NaN
|
|
16 library 0.000000 0.012911 0.000000 NaN
|
|
19 military 0.000000 0.035292 0.000000 NaN
|
|
25 science_technology 0.000000 0.080646 0.000000 NaN
|
|
23 theology_religious_vocation 0.000000 0.432991 0.000000 NaN
|
|
33 transportation 0.000000 0.331288 0.000000 NaN
|
|
Name Percent (Last) Percent (Avg) Students (Last) Students (Avg)
|
|
36 business_marketing 14.511786 17.399856 3653.717364 NaN
|
|
35 health 22.149643 12.027962 5960.320075 NaN
|
|
15 humanities 10.181786 9.546438 3624.366286 NaN
|
|
8 education 7.426786 6.705871 2231.885475 NaN
|
|
29 social_science 2.312143 6.253486 567.835936 NaN
|
|
26 psychology 1.285714 5.195744 529.515436 NaN
|
|
17 biological 2.671786 4.908001 913.827739 NaN
|
|
34 visual_performing 0.807500 3.903754 287.056654 NaN
|
|
4 communication 1.136786 3.192944 456.121346 NaN
|
|
27 security_law_enforcement 4.961071 3.019295 1735.563754 NaN
|
|
6 computer 7.148571 2.808726 2416.331129 NaN
|
|
9 engineering 0.972143 2.803155 333.565925 NaN
|
|
14 english 0.237500 2.671756 91.474121 NaN
|
|
20 multidiscipline 2.957857 1.964365 981.708071 NaN
|
|
21 parks_recreation_fitness 0.593214 1.885363 225.476271 NaN
|
|
37 history 0.208929 1.670524 76.740832 NaN
|
|
28 public_administration_social_service 1.677500 1.601816 531.436800 NaN
|
|
24 physical_science 0.421429 1.598245 125.394396 NaN
|
|
10 engineering_technology 3.409286 1.377941 962.291996 NaN
|
|
12 family_consumer_science 2.880357 1.222658 799.266364 NaN
|
|
18 mathematics 0.611071 1.048517 205.602029 NaN
|
|
11 language 0.633929 0.951896 224.890446 NaN
|
|
0 agriculture 0.000000 0.819862 0.000000 NaN
|
|
31 mechanic_repair_technology 6.220357 0.811160 1382.265304 NaN
|
|
1 resources 0.000000 0.700875 0.000000 NaN
|
|
22 philosophy_religious 0.072500 0.677424 26.515154 NaN
|
|
7 personal_culinary 0.698571 0.444786 246.205414 NaN
|
|
23 theology_religious_vocation 0.000000 0.432991 0.000000 NaN
|
|
32 precision_production 2.701429 0.379921 1043.298893 NaN
|
|
3 ethnic_cultural_gender 0.007500 0.368425 1.937561 NaN
|
|
13 legal 0.529286 0.366860 151.130189 NaN
|
|
33 transportation 0.000000 0.331288 0.000000 NaN
|
|
30 construction 0.573571 0.317400 232.164054 NaN
|
|
2 architecture 0.000000 0.243856 0.000000 NaN
|
|
5 communications_technology 0.000000 0.215724 0.000000 NaN
|
|
25 science_technology 0.000000 0.080646 0.000000 NaN
|
|
19 military 0.000000 0.035292 0.000000 NaN
|
|
16 library 0.000000 0.012911 0.000000 NaN
|
|
Name Percent (Last) Percent (Avg) Students (Last) Students (Avg)
|
|
36 business_marketing 30.11 28.734643 10662.8543 7409.063086
|
|
9 engineering 9.66 8.218571 3420.8958 2251.159975
|
|
35 health 9.66 9.055000 3420.8958 2404.925375
|
|
4 communication 9.42 10.607143 3335.9046 2703.289471
|
|
29 social_science 7.99 4.308214 2829.4987 1147.649796
|
|
12 family_consumer_science 6.96 7.195714 2464.7448 1848.827150
|
|
26 psychology 5.13 3.813929 1816.6869 978.664311
|
|
17 biological 3.89 3.384643 1377.5657 878.928314
|
|
21 parks_recreation_fitness 2.86 0.308929 1012.8118 107.747239
|
|
8 education 2.72 7.219643 963.2336 1749.198443
|
|
34 visual_performing 2.17 3.532143 768.4621 860.670914
|
|
20 multidiscipline 1.72 2.466786 609.1036 591.093271
|
|
6 computer 1.44 0.937500 509.9472 248.493907
|
|
37 history 1.17 1.755714 414.3321 421.027957
|
|
28 public_administration_social_service 1.09 1.165357 386.0017 286.223114
|
|
24 physical_science 1.06 0.981071 375.3778 256.140975
|
|
14 english 0.97 1.992857 343.5061 458.707082
|
|
18 mathematics 0.89 0.571786 315.1757 164.741461
|
|
11 language 0.45 0.713929 159.3585 173.877018
|
|
1 resources 0.38 0.251786 134.5694 77.018761
|
|
22 philosophy_religious 0.18 0.357143 63.7434 89.032021
|
|
3 ethnic_cultural_gender 0.09 0.299286 31.8717 73.607264
|
|
5 communications_technology 0.00 0.000000 0.0000 0.000000
|
|
2 architecture 0.00 0.017500 0.0000 2.880346
|
|
0 agriculture 0.00 0.000000 0.0000 0.000000
|
|
16 library 0.00 0.000000 0.0000 0.000000
|
|
10 engineering_technology 0.00 0.000000 0.0000 0.000000
|
|
7 personal_culinary 0.00 0.000000 0.0000 0.000000
|
|
15 humanities 0.00 0.001429 0.0000 0.228757
|
|
13 legal 0.00 0.000000 0.0000 0.000000
|
|
19 military 0.00 0.000000 0.0000 0.000000
|
|
27 security_law_enforcement 0.00 2.109286 0.0000 521.904729
|
|
23 theology_religious_vocation 0.00 0.000000 0.0000 0.000000
|
|
25 science_technology 0.00 0.000000 0.0000 0.000000
|
|
33 transportation 0.00 0.000000 0.0000 0.000000
|
|
32 precision_production 0.00 0.000000 0.0000 0.000000
|
|
31 mechanic_repair_technology 0.00 0.000000 0.0000 0.000000
|
|
30 construction 0.00 0.000000 0.0000 0.000000
|
|
Name Percent (Last) Percent (Avg) Students (Last) Students (Avg)
|
|
36 business_marketing 30.11 28.734643 10662.8543 7409.063086
|
|
4 communication 9.42 10.607143 3335.9046 2703.289471
|
|
35 health 9.66 9.055000 3420.8958 2404.925375
|
|
9 engineering 9.66 8.218571 3420.8958 2251.159975
|
|
8 education 2.72 7.219643 963.2336 1749.198443
|
|
12 family_consumer_science 6.96 7.195714 2464.7448 1848.827150
|
|
29 social_science 7.99 4.308214 2829.4987 1147.649796
|
|
26 psychology 5.13 3.813929 1816.6869 978.664311
|
|
34 visual_performing 2.17 3.532143 768.4621 860.670914
|
|
17 biological 3.89 3.384643 1377.5657 878.928314
|
|
20 multidiscipline 1.72 2.466786 609.1036 591.093271
|
|
27 security_law_enforcement 0.00 2.109286 0.0000 521.904729
|
|
14 english 0.97 1.992857 343.5061 458.707082
|
|
37 history 1.17 1.755714 414.3321 421.027957
|
|
28 public_administration_social_service 1.09 1.165357 386.0017 286.223114
|
|
24 physical_science 1.06 0.981071 375.3778 256.140975
|
|
6 computer 1.44 0.937500 509.9472 248.493907
|
|
11 language 0.45 0.713929 159.3585 173.877018
|
|
18 mathematics 0.89 0.571786 315.1757 164.741461
|
|
22 philosophy_religious 0.18 0.357143 63.7434 89.032021
|
|
21 parks_recreation_fitness 2.86 0.308929 1012.8118 107.747239
|
|
3 ethnic_cultural_gender 0.09 0.299286 31.8717 73.607264
|
|
1 resources 0.38 0.251786 134.5694 77.018761
|
|
2 architecture 0.00 0.017500 0.0000 2.880346
|
|
15 humanities 0.00 0.001429 0.0000 0.228757
|
|
0 agriculture 0.00 0.000000 0.0000 0.000000
|
|
5 communications_technology 0.00 0.000000 0.0000 0.000000
|
|
7 personal_culinary 0.00 0.000000 0.0000 0.000000
|
|
10 engineering_technology 0.00 0.000000 0.0000 0.000000
|
|
13 legal 0.00 0.000000 0.0000 0.000000
|
|
19 military 0.00 0.000000 0.0000 0.000000
|
|
16 library 0.00 0.000000 0.0000 0.000000
|
|
23 theology_religious_vocation 0.00 0.000000 0.0000 0.000000
|
|
25 science_technology 0.00 0.000000 0.0000 0.000000
|
|
33 transportation 0.00 0.000000 0.0000 0.000000
|
|
32 precision_production 0.00 0.000000 0.0000 0.000000
|
|
31 mechanic_repair_technology 0.00 0.000000 0.0000 0.000000
|
|
30 construction 0.00 0.000000 0.0000 0.000000
|
|
Field All R&D expenditures ... Nonprofit organizations Percent All other sources Percent
|
|
0 All R&D fields 184880.0 ... 0.948183 0.376460
|
|
1 Science 92834.0 ... 0.613999 0.187431
|
|
2 Computer and information sciences 18813.0 ... 0.015946 0.212619
|
|
3 Geosciences, atmospheric sciences, and ocean s... 16822.0 ... 0.606349 0.095114
|
|
4 Atmospheric science and meteorology 0.0 ... NaN NaN
|
|
5 Geological and earth sciences 14248.0 ... 0.715890 0.112296
|
|
6 Ocean sciences and marine sciences 2574.0 ... 0.000000 0.000000
|
|
7 Geosciences, atmospheric sciences, and ocean s... 0.0 ... NaN NaN
|
|
8 Life sciences 23853.0 ... 1.224165 0.314426
|
|
9 Agricultural sciences 11.0 ... 0.000000 0.000000
|
|
10 Biological and biomedical sciences 10055.0 ... 0.616609 0.159125
|
|
11 Health sciences 13736.0 ... 1.674432 0.422248
|
|
12 Natural resources and conservation 0.0 ... NaN NaN
|
|
13 Life sciences nec 51.0 ... 0.000000 1.960784
|
|
14 Mathematics and statistics 2918.0 ... 0.959561 0.000000
|
|
15 Physical sciences 11124.0 ... 0.107875 0.000000
|
|
16 Astronomy and astrophysics 271.0 ... 0.000000 0.000000
|
|
17 Chemistry 7938.0 ... 0.151172 0.000000
|
|
18 Materials science 0.0 ... NaN NaN
|
|
19 Physics 2911.0 ... 0.000000 0.000000
|
|
20 Physical sciences nec 4.0 ... 0.000000 0.000000
|
|
21 Psychology 5690.0 ... 0.351494 0.000000
|
|
22 Social sciences 13350.0 ... 0.846442 0.322097
|
|
23 Anthropology 792.0 ... 1.767677 5.429293
|
|
24 Economics 3707.0 ... 0.000000 0.000000
|
|
25 Political science and government 898.0 ... 1.559020 0.000000
|
|
26 Sociology, demography, and population studies 2908.0 ... 0.000000 0.000000
|
|
27 Social sciences nec 5045.0 ... 1.684836 0.000000
|
|
28 Sciences nec 264.0 ... 0.000000 0.000000
|
|
29 Engineering 51029.0 ... 1.312979 0.850497
|
|
30 Aerospace, aeronautical, and astronautical eng... 4665.0 ... 0.000000 0.000000
|
|
31 Bioengineering and biomedical engineering 0.0 ... NaN NaN
|
|
32 Chemical engineering 6647.0 ... 2.888521 0.000000
|
|
33 Civil engineering 15198.0 ... 0.782998 1.796289
|
|
34 Electrical, electronic, and communications eng... 10299.0 ... 3.359549 0.854452
|
|
35 Industrial and manufacturing engineering 0.0 ... NaN NaN
|
|
36 Mechanical engineering 7056.0 ... 0.000000 0.255102
|
|
37 Metallurgical and materials engineering 6473.0 ... 0.000000 0.849683
|
|
38 Engineering nec 691.0 ... 1.881331 0.000000
|
|
39 Non-S&E 41017.0 ... 1.250701 0.214545
|
|
40 Business management and business administration 11919.0 ... 0.092290 0.000000
|
|
41 Communication and communications technologies 2675.0 ... 0.523364 0.074766
|
|
42 Education 9731.0 ... 1.459254 0.000000
|
|
43 Humanities 4813.0 ... 1.059630 1.225847
|
|
44 Law 2076.0 ... 9.633911 0.000000
|
|
45 Social work 4557.0 ... 0.987492 0.285275
|
|
46 Visual and performing arts 2803.0 ... 0.356761 0.499465
|
|
47 Non-S&E nec 2443.0 ... 1.637331 0.000000
|
|
|
|
[48 rows x 14 columns]
|