Exploratory Data Analysis of College Scorecard Data
Julia Silge
2016-09-06
The College Scorecord is a website and set of data that allows students and those who support them to access information about U.S. colleges/university and understand it. The developers and analysts who maintain the College Scorecard have their GitHub repository public, and they have extensive information on the data behind the scorecard including detailed documentation.
What Is In the College Scorecard Data?
I have downloaded the data available at the “Download All Data” button on this site; it contains separate CSV files for several years. For starters, let’s just open up the most recent year of data. (There are also CSV files for the years 1996 - 2012; it may be worth using some of that data as well.) Let’s also open up the data dictionary.
library(readr)
colleges <- read_csv("data/merged_2013_PP.csv", na = c("NULL", "PrivacySuppressed"))
dictionary <- read_csv("data/CollegeScorecardDataDictionary-09-08-2015.csv")What is here? How much of this data frame is NA?
dim(colleges)## [1] 7804 1729sapply(colleges, function(x) sum(is.na(x)))## UNITID OPEID opeid6
## 0 0 0
## INSTNM CITY STABBR
## 0 0 0
## ZIP AccredAgency INSTURL
## 0 233 85
## NPCURL sch_deg HCM2
## 591 7804 0
## main NUMBRANCH PREDDEG
## 0 0 0
## HIGHDEG CONTROL st_fips
## 0 0 0
## region LOCALE locale2
## 0 424 7804
## LATITUDE LONGITUDE CCBASIC
## 785 785 3449
## CCUGPROF CCSIZSET HBCU
## 4245 4228 421
## PBI ANNHI TRIBAL
## 421 421 421
## AANAPII HSI NANTI
## 421 421 421
## MENONLY WOMENONLY RELAFFIL
## 421 421 6887
## ADM_RATE ADM_RATE_ALL SATVR25
## 5584 5320 6503
## SATVR75 SATMT25 SATMT75
## 6503 6489 6489
## SATWR25 SATWR75 SATVRMID
## 7011 7011 6503
## SATMTMID SATWRMID ACTCM25
## 6489 7011 6462
## ACTCM75 ACTEN25 ACTEN75
## 6462 6639 6639
## ACTMT25 ACTMT75 ACTWR25
## 6638 6638 7504
## ACTWR75 ACTCMMID ACTENMID
## 7504 6462 6639
## ACTMTMID ACTWRMID SAT_AVG
## 6638 7504 6384
## SAT_AVG_ALL PCIP01 PCIP03
## 6273 718 718
## PCIP04 PCIP05 PCIP09
## 718 718 718
## PCIP10 PCIP11 PCIP12
## 718 718 718
## PCIP13 PCIP14 PCIP15
## 718 718 718
## PCIP16 PCIP19 PCIP22
## 718 718 718
## PCIP23 PCIP24 PCIP25
## 718 718 718
## PCIP26 PCIP27 PCIP29
## 718 718 718
## PCIP30 PCIP31 PCIP38
## 718 718 718
## PCIP39 PCIP40 PCIP41
## 718 718 718
## PCIP42 PCIP43 PCIP44
## 718 718 718
## PCIP45 PCIP46 PCIP47
## 718 718 718
## PCIP48 PCIP49 PCIP50
## 718 718 718
## PCIP51 PCIP52 PCIP54
## 718 718 718
## CIP01CERT1 CIP01CERT2 CIP01ASSOC
## 421 421 421
## CIP01CERT4 CIP01BACHL CIP03CERT1
## 421 421 421
## CIP03CERT2 CIP03ASSOC CIP03CERT4
## 421 421 421
## CIP03BACHL CIP04CERT1 CIP04CERT2
## 421 421 421
## CIP04ASSOC CIP04CERT4 CIP04BACHL
## 421 421 421
## CIP05CERT1 CIP05CERT2 CIP05ASSOC
## 421 421 421
## CIP05CERT4 CIP05BACHL CIP09CERT1
## 421 421 421
## CIP09CERT2 CIP09ASSOC CIP09CERT4
## 421 421 421
## CIP09BACHL CIP10CERT1 CIP10CERT2
## 421 421 421
## CIP10ASSOC CIP10CERT4 CIP10BACHL
## 421 421 421
## CIP11CERT1 CIP11CERT2 CIP11ASSOC
## 421 421 421
## CIP11CERT4 CIP11BACHL CIP12CERT1
## 421 421 421
## CIP12CERT2 CIP12ASSOC CIP12CERT4
## 421 421 421
## CIP12BACHL CIP13CERT1 CIP13CERT2
## 421 421 421
## CIP13ASSOC CIP13CERT4 CIP13BACHL
## 421 421 421
## CIP14CERT1 CIP14CERT2 CIP14ASSOC
## 421 421 421
## CIP14CERT4 CIP14BACHL CIP15CERT1
## 421 421 421
## CIP15CERT2 CIP15ASSOC CIP15CERT4
## 421 421 421
## CIP15BACHL CIP16CERT1 CIP16CERT2
## 421 421 421
## CIP16ASSOC CIP16CERT4 CIP16BACHL
## 421 421 421
## CIP19CERT1 CIP19CERT2 CIP19ASSOC
## 421 421 421
## CIP19CERT4 CIP19BACHL CIP22CERT1
## 421 421 421
## CIP22CERT2 CIP22ASSOC CIP22CERT4
## 421 421 421
## CIP22BACHL CIP23CERT1 CIP23CERT2
## 421 421 421
## CIP23ASSOC CIP23CERT4 CIP23BACHL
## 421 421 421
## CIP24CERT1 CIP24CERT2 CIP24ASSOC
## 421 421 421
## CIP24CERT4 CIP24BACHL CIP25CERT1
## 421 421 421
## CIP25CERT2 CIP25ASSOC CIP25CERT4
## 421 421 421
## CIP25BACHL CIP26CERT1 CIP26CERT2
## 421 421 421
## CIP26ASSOC CIP26CERT4 CIP26BACHL
## 421 421 421
## CIP27CERT1 CIP27CERT2 CIP27ASSOC
## 421 421 421
## CIP27CERT4 CIP27BACHL CIP29CERT1
## 421 421 421
## CIP29CERT2 CIP29ASSOC CIP29CERT4
## 421 421 421
## CIP29BACHL CIP30CERT1 CIP30CERT2
## 421 421 421
## CIP30ASSOC CIP30CERT4 CIP30BACHL
## 421 421 421
## CIP31CERT1 CIP31CERT2 CIP31ASSOC
## 421 421 421
## CIP31CERT4 CIP31BACHL CIP38CERT1
## 421 421 421
## CIP38CERT2 CIP38ASSOC CIP38CERT4
## 421 421 421
## CIP38BACHL CIP39CERT1 CIP39CERT2
## 421 421 421
## CIP39ASSOC CIP39CERT4 CIP39BACHL
## 421 421 421
## CIP40CERT1 CIP40CERT2 CIP40ASSOC
## 421 421 421
## CIP40CERT4 CIP40BACHL CIP41CERT1
## 421 421 421
## CIP41CERT2 CIP41ASSOC CIP41CERT4
## 421 421 421
## CIP41BACHL CIP42CERT1 CIP42CERT2
## 421 421 421
## CIP42ASSOC CIP42CERT4 CIP42BACHL
## 421 421 421
## CIP43CERT1 CIP43CERT2 CIP43ASSOC
## 421 421 421
## CIP43CERT4 CIP43BACHL CIP44CERT1
## 421 421 421
## CIP44CERT2 CIP44ASSOC CIP44CERT4
## 421 421 421
## CIP44BACHL CIP45CERT1 CIP45CERT2
## 421 421 421
## CIP45ASSOC CIP45CERT4 CIP45BACHL
## 421 421 421
## CIP46CERT1 CIP46CERT2 CIP46ASSOC
## 421 421 421
## CIP46CERT4 CIP46BACHL CIP47CERT1
## 421 421 421
## CIP47CERT2 CIP47ASSOC CIP47CERT4
## 421 421 421
## CIP47BACHL CIP48CERT1 CIP48CERT2
## 421 421 421
## CIP48ASSOC CIP48CERT4 CIP48BACHL
## 421 421 421
## CIP49CERT1 CIP49CERT2 CIP49ASSOC
## 421 421 421
## CIP49CERT4 CIP49BACHL CIP50CERT1
## 421 421 421
## CIP50CERT2 CIP50ASSOC CIP50CERT4
## 421 421 421
## CIP50BACHL CIP51CERT1 CIP51CERT2
## 421 421 421
## CIP51ASSOC CIP51CERT4 CIP51BACHL
## 421 421 421
## CIP52CERT1 CIP52CERT2 CIP52ASSOC
## 421 421 421
## CIP52CERT4 CIP52BACHL CIP54CERT1
## 421 421 421
## CIP54CERT2 CIP54ASSOC CIP54CERT4
## 421 421 421
## CIP54BACHL DISTANCEONLY UGDS
## 421 421 714
## UG UGDS_WHITE UGDS_BLACK
## 7804 714 714
## UGDS_HISP UGDS_ASIAN UGDS_AIAN
## 714 714 714
## UGDS_NHPI UGDS_2MOR UGDS_NRA
## 714 714 714
## UGDS_UNKN UGDS_WHITENH UGDS_BLACKNH
## 714 7804 7804
## UGDS_API UGDS_AIANOld UGDS_HISPOld
## 7804 7804 7804
## UG_NRA UG_UNKN UG_WHITENH
## 7804 7804 7804
## UG_BLACKNH UG_API UG_AIANOld
## 7804 7804 7804
## UG_HISPOld PPTUG_EF PPTUG_EF2
## 7804 732 7804
## CURROPER NPT4_PUB NPT4_PRIV
## 0 5881 3051
## NPT4_PROG NPT4_OTHER NPT41_PUB
## 7804 7804 5886
## NPT42_PUB NPT43_PUB NPT44_PUB
## 6062 6135 6353
## NPT45_PUB NPT41_PRIV NPT42_PRIV
## 6541 3107 3853
## NPT43_PRIV NPT44_PRIV NPT45_PRIV
## 4276 4981 5583
## NPT41_PROG NPT42_PROG NPT43_PROG
## 7804 7804 7804
## NPT44_PROG NPT45_PROG NPT41_OTHER
## 7804 7804 7804
## NPT42_OTHER NPT43_OTHER NPT44_OTHER
## 7804 7804 7804
## NPT45_OTHER NPT4_048_PUB NPT4_048_PRIV
## 7804 5882 3075
## NPT4_048_PROG NPT4_048_OTHER NPT4_3075_PUB
## 7804 7804 6037
## NPT4_3075_PRIV NPT4_75UP_PUB NPT4_75UP_PRIV
## 3718 6337 4826
## NPT4_3075_PROG NPT4_3075_OTHER NPT4_75UP_PROG
## 7804 7804 7804
## NPT4_75UP_OTHER NUM4_PUB NUM4_PRIV
## 7804 5880 3019
## NUM4_PROG NUM4_OTHER NUM41_PUB
## 7804 7804 5880
## NUM42_PUB NUM43_PUB NUM44_PUB
## 5880 5880 5880
## NUM45_PUB NUM41_PRIV NUM42_PRIV
## 5880 3052 3052
## NUM43_PRIV NUM44_PRIV NUM45_PRIV
## 3052 3052 3052
## NUM41_PROG NUM42_PROG NUM43_PROG
## 7804 7804 7804
## NUM44_PROG NUM45_PROG NUM41_OTHER
## 7804 7804 7804
## NUM42_OTHER NUM43_OTHER NUM44_OTHER
## 7804 7804 7804
## NUM45_OTHER COSTT4_A COSTT4_P
## 7804 3667 5263
## TUITIONFEE_IN TUITIONFEE_OUT TUITIONFEE_PROG
## 3389 3608 5092
## TUITFTE INEXPFTE AVGFACSAL
## 442 442 3150
## PFTFAC PCTPELL C150_4
## 3677 741 5356
## C150_L4 C150_4_POOLED C150_L4_POOLED
## 3839 5332 3786
## poolyrs PFTFTUG1_EF D150_4
## 1314 4118 5356
## D150_L4 D150_4_POOLED D150_L4_POOLED
## 3839 5332 3786
## C150_4_WHITE C150_4_BLACK C150_4_HISP
## 5463 5633 5631
## C150_4_ASIAN C150_4_AIAN C150_4_NHPI
## 5924 6269 7412
## C150_4_2MOR C150_4_NRA C150_4_UNKN
## 7043 6315 6054
## C150_4_WHITENH C150_4_BLACKNH C150_4_API
## 7804 7804 7804
## C150_4_AIANOld C150_4_HISPOld C150_L4_WHITE
## 7804 7804 5731
## C150_L4_BLACK C150_L4_HISP C150_L4_ASIAN
## 5910 5948 6338
## C150_L4_AIAN C150_L4_NHPI C150_L4_2MOR
## 6479 7054 6534
## C150_L4_NRA C150_L4_UNKN C150_L4_WHITENH
## 7189 6410 7804
## C150_L4_BLACKNH C150_L4_API C150_L4_AIANOld
## 7804 7804 7804
## C150_L4_HISPOld C200_4 C200_L4
## 7804 5674 4143
## D200_4 D200_L4 RET_FT4
## 5674 4143 5456
## RET_FTL4 RET_PT4 RET_PTL4
## 3884 6336 5540
## C200_4_POOLED C200_L4_POOLED poolyrs200
## 5644 4010 1850
## D200_4_POOLED D200_L4_POOLED PCTFLOAN
## 5644 4010 741
## UG25abv CDR2 CDR3
## 773 7804 62
## DEATH_YR2_RT COMP_ORIG_YR2_RT COMP_4YR_TRANS_YR2_RT
## 7804 7804 7804
## COMP_2YR_TRANS_YR2_RT WDRAW_ORIG_YR2_RT WDRAW_4YR_TRANS_YR2_RT
## 7804 7804 7804
## WDRAW_2YR_TRANS_YR2_RT ENRL_ORIG_YR2_RT ENRL_4YR_TRANS_YR2_RT
## 7804 7804 7804
## ENRL_2YR_TRANS_YR2_RT UNKN_ORIG_YR2_RT UNKN_4YR_TRANS_YR2_RT
## 7804 7804 7804
## UNKN_2YR_TRANS_YR2_RT LO_INC_DEATH_YR2_RT LO_INC_COMP_ORIG_YR2_RT
## 7804 7804 7804
## LO_INC_COMP_4YR_TRANS_YR2_RT LO_INC_COMP_2YR_TRANS_YR2_RT LO_INC_WDRAW_ORIG_YR2_RT
## 7804 7804 7804
## LO_INC_WDRAW_4YR_TRANS_YR2_RT LO_INC_WDRAW_2YR_TRANS_YR2_RT LO_INC_ENRL_ORIG_YR2_RT
## 7804 7804 7804
## LO_INC_ENRL_4YR_TRANS_YR2_RT LO_INC_ENRL_2YR_TRANS_YR2_RT LO_INC_UNKN_ORIG_YR2_RT
## 7804 7804 7804
## LO_INC_UNKN_4YR_TRANS_YR2_RT LO_INC_UNKN_2YR_TRANS_YR2_RT MD_INC_DEATH_YR2_RT
## 7804 7804 7804
## MD_INC_COMP_ORIG_YR2_RT MD_INC_COMP_4YR_TRANS_YR2_RT MD_INC_COMP_2YR_TRANS_YR2_RT
## 7804 7804 7804
## MD_INC_WDRAW_ORIG_YR2_RT MD_INC_WDRAW_4YR_TRANS_YR2_RT MD_INC_WDRAW_2YR_TRANS_YR2_RT
## 7804 7804 7804
## MD_INC_ENRL_ORIG_YR2_RT MD_INC_ENRL_4YR_TRANS_YR2_RT MD_INC_ENRL_2YR_TRANS_YR2_RT
## 7804 7804 7804
## MD_INC_UNKN_ORIG_YR2_RT MD_INC_UNKN_4YR_TRANS_YR2_RT MD_INC_UNKN_2YR_TRANS_YR2_RT
## 7804 7804 7804
## HI_INC_DEATH_YR2_RT HI_INC_COMP_ORIG_YR2_RT HI_INC_COMP_4YR_TRANS_YR2_RT
## 7804 7804 7804
## HI_INC_COMP_2YR_TRANS_YR2_RT HI_INC_WDRAW_ORIG_YR2_RT HI_INC_WDRAW_4YR_TRANS_YR2_RT
## 7804 7804 7804
## HI_INC_WDRAW_2YR_TRANS_YR2_RT HI_INC_ENRL_ORIG_YR2_RT HI_INC_ENRL_4YR_TRANS_YR2_RT
## 7804 7804 7804
## HI_INC_ENRL_2YR_TRANS_YR2_RT HI_INC_UNKN_ORIG_YR2_RT HI_INC_UNKN_4YR_TRANS_YR2_RT
## 7804 7804 7804
## HI_INC_UNKN_2YR_TRANS_YR2_RT DEP_DEATH_YR2_RT DEP_COMP_ORIG_YR2_RT
## 7804 7804 7804
## DEP_COMP_4YR_TRANS_YR2_RT DEP_COMP_2YR_TRANS_YR2_RT DEP_WDRAW_ORIG_YR2_RT
## 7804 7804 7804
## DEP_WDRAW_4YR_TRANS_YR2_RT DEP_WDRAW_2YR_TRANS_YR2_RT DEP_ENRL_ORIG_YR2_RT
## 7804 7804 7804
## DEP_ENRL_4YR_TRANS_YR2_RT DEP_ENRL_2YR_TRANS_YR2_RT DEP_UNKN_ORIG_YR2_RT
## 7804 7804 7804
## DEP_UNKN_4YR_TRANS_YR2_RT DEP_UNKN_2YR_TRANS_YR2_RT IND_DEATH_YR2_RT
## 7804 7804 7804
## IND_COMP_ORIG_YR2_RT IND_COMP_4YR_TRANS_YR2_RT IND_COMP_2YR_TRANS_YR2_RT
## 7804 7804 7804
## IND_WDRAW_ORIG_YR2_RT IND_WDRAW_4YR_TRANS_YR2_RT IND_WDRAW_2YR_TRANS_YR2_RT
## 7804 7804 7804
## IND_ENRL_ORIG_YR2_RT IND_ENRL_4YR_TRANS_YR2_RT IND_ENRL_2YR_TRANS_YR2_RT
## 7804 7804 7804
## IND_UNKN_ORIG_YR2_RT IND_UNKN_4YR_TRANS_YR2_RT IND_UNKN_2YR_TRANS_YR2_RT
## 7804 7804 7804
## FEMALE_DEATH_YR2_RT FEMALE_COMP_ORIG_YR2_RT FEMALE_COMP_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FEMALE_COMP_2YR_TRANS_YR2_RT FEMALE_WDRAW_ORIG_YR2_RT FEMALE_WDRAW_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FEMALE_WDRAW_2YR_TRANS_YR2_RT FEMALE_ENRL_ORIG_YR2_RT FEMALE_ENRL_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FEMALE_ENRL_2YR_TRANS_YR2_RT FEMALE_UNKN_ORIG_YR2_RT FEMALE_UNKN_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FEMALE_UNKN_2YR_TRANS_YR2_RT MALE_DEATH_YR2_RT MALE_COMP_ORIG_YR2_RT
## 7804 7804 7804
## MALE_COMP_4YR_TRANS_YR2_RT MALE_COMP_2YR_TRANS_YR2_RT MALE_WDRAW_ORIG_YR2_RT
## 7804 7804 7804
## MALE_WDRAW_4YR_TRANS_YR2_RT MALE_WDRAW_2YR_TRANS_YR2_RT MALE_ENRL_ORIG_YR2_RT
## 7804 7804 7804
## MALE_ENRL_4YR_TRANS_YR2_RT MALE_ENRL_2YR_TRANS_YR2_RT MALE_UNKN_ORIG_YR2_RT
## 7804 7804 7804
## MALE_UNKN_4YR_TRANS_YR2_RT MALE_UNKN_2YR_TRANS_YR2_RT PELL_DEATH_YR2_RT
## 7804 7804 7804
## PELL_COMP_ORIG_YR2_RT PELL_COMP_4YR_TRANS_YR2_RT PELL_COMP_2YR_TRANS_YR2_RT
## 7804 7804 7804
## PELL_WDRAW_ORIG_YR2_RT PELL_WDRAW_4YR_TRANS_YR2_RT PELL_WDRAW_2YR_TRANS_YR2_RT
## 7804 7804 7804
## PELL_ENRL_ORIG_YR2_RT PELL_ENRL_4YR_TRANS_YR2_RT PELL_ENRL_2YR_TRANS_YR2_RT
## 7804 7804 7804
## PELL_UNKN_ORIG_YR2_RT PELL_UNKN_4YR_TRANS_YR2_RT PELL_UNKN_2YR_TRANS_YR2_RT
## 7804 7804 7804
## NOPELL_DEATH_YR2_RT NOPELL_COMP_ORIG_YR2_RT NOPELL_COMP_4YR_TRANS_YR2_RT
## 7804 7804 7804
## NOPELL_COMP_2YR_TRANS_YR2_RT NOPELL_WDRAW_ORIG_YR2_RT NOPELL_WDRAW_4YR_TRANS_YR2_RT
## 7804 7804 7804
## NOPELL_WDRAW_2YR_TRANS_YR2_RT NOPELL_ENRL_ORIG_YR2_RT NOPELL_ENRL_4YR_TRANS_YR2_RT
## 7804 7804 7804
## NOPELL_ENRL_2YR_TRANS_YR2_RT NOPELL_UNKN_ORIG_YR2_RT NOPELL_UNKN_4YR_TRANS_YR2_RT
## 7804 7804 7804
## NOPELL_UNKN_2YR_TRANS_YR2_RT LOAN_DEATH_YR2_RT LOAN_COMP_ORIG_YR2_RT
## 7804 7804 7804
## LOAN_COMP_4YR_TRANS_YR2_RT LOAN_COMP_2YR_TRANS_YR2_RT LOAN_WDRAW_ORIG_YR2_RT
## 7804 7804 7804
## LOAN_WDRAW_4YR_TRANS_YR2_RT LOAN_WDRAW_2YR_TRANS_YR2_RT LOAN_ENRL_ORIG_YR2_RT
## 7804 7804 7804
## LOAN_ENRL_4YR_TRANS_YR2_RT LOAN_ENRL_2YR_TRANS_YR2_RT LOAN_UNKN_ORIG_YR2_RT
## 7804 7804 7804
## LOAN_UNKN_4YR_TRANS_YR2_RT LOAN_UNKN_2YR_TRANS_YR2_RT NOLOAN_DEATH_YR2_RT
## 7804 7804 7804
## NOLOAN_COMP_ORIG_YR2_RT NOLOAN_COMP_4YR_TRANS_YR2_RT NOLOAN_COMP_2YR_TRANS_YR2_RT
## 7804 7804 7804
## NOLOAN_WDRAW_ORIG_YR2_RT NOLOAN_WDRAW_4YR_TRANS_YR2_RT NOLOAN_WDRAW_2YR_TRANS_YR2_RT
## 7804 7804 7804
## NOLOAN_ENRL_ORIG_YR2_RT NOLOAN_ENRL_4YR_TRANS_YR2_RT NOLOAN_ENRL_2YR_TRANS_YR2_RT
## 7804 7804 7804
## NOLOAN_UNKN_ORIG_YR2_RT NOLOAN_UNKN_4YR_TRANS_YR2_RT NOLOAN_UNKN_2YR_TRANS_YR2_RT
## 7804 7804 7804
## FIRSTGEN_DEATH_YR2_RT FIRSTGEN_COMP_ORIG_YR2_RT FIRSTGEN_COMP_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FIRSTGEN_COMP_2YR_TRANS_YR2_RT FIRSTGEN_WDRAW_ORIG_YR2_RT FIRSTGEN_WDRAW_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FIRSTGEN_WDRAW_2YR_TRANS_YR2_RT FIRSTGEN_ENRL_ORIG_YR2_RT FIRSTGEN_ENRL_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FIRSTGEN_ENRL_2YR_TRANS_YR2_RT FIRSTGEN_UNKN_ORIG_YR2_RT FIRSTGEN_UNKN_4YR_TRANS_YR2_RT
## 7804 7804 7804
## FIRSTGEN_UNKN_2YR_TRANS_YR2_RT NOT1STGEN_DEATH_YR2_RT NOT1STGEN_COMP_ORIG_YR2_RT
## 7804 7804 7804
## NOT1STGEN_COMP_4YR_TRANS_YR2_RT NOT1STGEN_COMP_2YR_TRANS_YR2_RT NOT1STGEN_WDRAW_ORIG_YR2_RT
## 7804 7804 7804
## NOT1STGEN_WDRAW_4YR_TRANS_YR2_RT NOT1STGEN_WDRAW_2YR_TRANS_YR2_RT NOT1STGEN_ENRL_ORIG_YR2_RT
## 7804 7804 7804
## NOT1STGEN_ENRL_4YR_TRANS_YR2_RT NOT1STGEN_ENRL_2YR_TRANS_YR2_RT NOT1STGEN_UNKN_ORIG_YR2_RT
## 7804 7804 7804
## NOT1STGEN_UNKN_4YR_TRANS_YR2_RT NOT1STGEN_UNKN_2YR_TRANS_YR2_RT DEATH_YR3_RT
## 7804 7804 7804
## COMP_ORIG_YR3_RT COMP_4YR_TRANS_YR3_RT COMP_2YR_TRANS_YR3_RT
## 7804 7804 7804
## WDRAW_ORIG_YR3_RT WDRAW_4YR_TRANS_YR3_RT WDRAW_2YR_TRANS_YR3_RT
## 7804 7804 7804
## ENRL_ORIG_YR3_RT ENRL_4YR_TRANS_YR3_RT ENRL_2YR_TRANS_YR3_RT
## 7804 7804 7804
## UNKN_ORIG_YR3_RT UNKN_4YR_TRANS_YR3_RT UNKN_2YR_TRANS_YR3_RT
## 7804 7804 7804
## LO_INC_DEATH_YR3_RT LO_INC_COMP_ORIG_YR3_RT LO_INC_COMP_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LO_INC_COMP_2YR_TRANS_YR3_RT LO_INC_WDRAW_ORIG_YR3_RT LO_INC_WDRAW_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LO_INC_WDRAW_2YR_TRANS_YR3_RT LO_INC_ENRL_ORIG_YR3_RT LO_INC_ENRL_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LO_INC_ENRL_2YR_TRANS_YR3_RT LO_INC_UNKN_ORIG_YR3_RT LO_INC_UNKN_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LO_INC_UNKN_2YR_TRANS_YR3_RT MD_INC_DEATH_YR3_RT MD_INC_COMP_ORIG_YR3_RT
## 7804 7804 7804
## MD_INC_COMP_4YR_TRANS_YR3_RT MD_INC_COMP_2YR_TRANS_YR3_RT MD_INC_WDRAW_ORIG_YR3_RT
## 7804 7804 7804
## MD_INC_WDRAW_4YR_TRANS_YR3_RT MD_INC_WDRAW_2YR_TRANS_YR3_RT MD_INC_ENRL_ORIG_YR3_RT
## 7804 7804 7804
## MD_INC_ENRL_4YR_TRANS_YR3_RT MD_INC_ENRL_2YR_TRANS_YR3_RT MD_INC_UNKN_ORIG_YR3_RT
## 7804 7804 7804
## MD_INC_UNKN_4YR_TRANS_YR3_RT MD_INC_UNKN_2YR_TRANS_YR3_RT HI_INC_DEATH_YR3_RT
## 7804 7804 7804
## HI_INC_COMP_ORIG_YR3_RT HI_INC_COMP_4YR_TRANS_YR3_RT HI_INC_COMP_2YR_TRANS_YR3_RT
## 7804 7804 7804
## HI_INC_WDRAW_ORIG_YR3_RT HI_INC_WDRAW_4YR_TRANS_YR3_RT HI_INC_WDRAW_2YR_TRANS_YR3_RT
## 7804 7804 7804
## HI_INC_ENRL_ORIG_YR3_RT HI_INC_ENRL_4YR_TRANS_YR3_RT HI_INC_ENRL_2YR_TRANS_YR3_RT
## 7804 7804 7804
## HI_INC_UNKN_ORIG_YR3_RT HI_INC_UNKN_4YR_TRANS_YR3_RT HI_INC_UNKN_2YR_TRANS_YR3_RT
## 7804 7804 7804
## DEP_DEATH_YR3_RT DEP_COMP_ORIG_YR3_RT DEP_COMP_4YR_TRANS_YR3_RT
## 7804 7804 7804
## DEP_COMP_2YR_TRANS_YR3_RT DEP_WDRAW_ORIG_YR3_RT DEP_WDRAW_4YR_TRANS_YR3_RT
## 7804 7804 7804
## DEP_WDRAW_2YR_TRANS_YR3_RT DEP_ENRL_ORIG_YR3_RT DEP_ENRL_4YR_TRANS_YR3_RT
## 7804 7804 7804
## DEP_ENRL_2YR_TRANS_YR3_RT DEP_UNKN_ORIG_YR3_RT DEP_UNKN_4YR_TRANS_YR3_RT
## 7804 7804 7804
## DEP_UNKN_2YR_TRANS_YR3_RT IND_DEATH_YR3_RT IND_COMP_ORIG_YR3_RT
## 7804 7804 7804
## IND_COMP_4YR_TRANS_YR3_RT IND_COMP_2YR_TRANS_YR3_RT IND_WDRAW_ORIG_YR3_RT
## 7804 7804 7804
## IND_WDRAW_4YR_TRANS_YR3_RT IND_WDRAW_2YR_TRANS_YR3_RT IND_ENRL_ORIG_YR3_RT
## 7804 7804 7804
## IND_ENRL_4YR_TRANS_YR3_RT IND_ENRL_2YR_TRANS_YR3_RT IND_UNKN_ORIG_YR3_RT
## 7804 7804 7804
## IND_UNKN_4YR_TRANS_YR3_RT IND_UNKN_2YR_TRANS_YR3_RT FEMALE_DEATH_YR3_RT
## 7804 7804 7804
## FEMALE_COMP_ORIG_YR3_RT FEMALE_COMP_4YR_TRANS_YR3_RT FEMALE_COMP_2YR_TRANS_YR3_RT
## 7804 7804 7804
## FEMALE_WDRAW_ORIG_YR3_RT FEMALE_WDRAW_4YR_TRANS_YR3_RT FEMALE_WDRAW_2YR_TRANS_YR3_RT
## 7804 7804 7804
## FEMALE_ENRL_ORIG_YR3_RT FEMALE_ENRL_4YR_TRANS_YR3_RT FEMALE_ENRL_2YR_TRANS_YR3_RT
## 7804 7804 7804
## FEMALE_UNKN_ORIG_YR3_RT FEMALE_UNKN_4YR_TRANS_YR3_RT FEMALE_UNKN_2YR_TRANS_YR3_RT
## 7804 7804 7804
## MALE_DEATH_YR3_RT MALE_COMP_ORIG_YR3_RT MALE_COMP_4YR_TRANS_YR3_RT
## 7804 7804 7804
## MALE_COMP_2YR_TRANS_YR3_RT MALE_WDRAW_ORIG_YR3_RT MALE_WDRAW_4YR_TRANS_YR3_RT
## 7804 7804 7804
## MALE_WDRAW_2YR_TRANS_YR3_RT MALE_ENRL_ORIG_YR3_RT MALE_ENRL_4YR_TRANS_YR3_RT
## 7804 7804 7804
## MALE_ENRL_2YR_TRANS_YR3_RT MALE_UNKN_ORIG_YR3_RT MALE_UNKN_4YR_TRANS_YR3_RT
## 7804 7804 7804
## MALE_UNKN_2YR_TRANS_YR3_RT PELL_DEATH_YR3_RT PELL_COMP_ORIG_YR3_RT
## 7804 7804 7804
## PELL_COMP_4YR_TRANS_YR3_RT PELL_COMP_2YR_TRANS_YR3_RT PELL_WDRAW_ORIG_YR3_RT
## 7804 7804 7804
## PELL_WDRAW_4YR_TRANS_YR3_RT PELL_WDRAW_2YR_TRANS_YR3_RT PELL_ENRL_ORIG_YR3_RT
## 7804 7804 7804
## PELL_ENRL_4YR_TRANS_YR3_RT PELL_ENRL_2YR_TRANS_YR3_RT PELL_UNKN_ORIG_YR3_RT
## 7804 7804 7804
## PELL_UNKN_4YR_TRANS_YR3_RT PELL_UNKN_2YR_TRANS_YR3_RT NOPELL_DEATH_YR3_RT
## 7804 7804 7804
## NOPELL_COMP_ORIG_YR3_RT NOPELL_COMP_4YR_TRANS_YR3_RT NOPELL_COMP_2YR_TRANS_YR3_RT
## 7804 7804 7804
## NOPELL_WDRAW_ORIG_YR3_RT NOPELL_WDRAW_4YR_TRANS_YR3_RT NOPELL_WDRAW_2YR_TRANS_YR3_RT
## 7804 7804 7804
## NOPELL_ENRL_ORIG_YR3_RT NOPELL_ENRL_4YR_TRANS_YR3_RT NOPELL_ENRL_2YR_TRANS_YR3_RT
## 7804 7804 7804
## NOPELL_UNKN_ORIG_YR3_RT NOPELL_UNKN_4YR_TRANS_YR3_RT NOPELL_UNKN_2YR_TRANS_YR3_RT
## 7804 7804 7804
## LOAN_DEATH_YR3_RT LOAN_COMP_ORIG_YR3_RT LOAN_COMP_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LOAN_COMP_2YR_TRANS_YR3_RT LOAN_WDRAW_ORIG_YR3_RT LOAN_WDRAW_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LOAN_WDRAW_2YR_TRANS_YR3_RT LOAN_ENRL_ORIG_YR3_RT LOAN_ENRL_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LOAN_ENRL_2YR_TRANS_YR3_RT LOAN_UNKN_ORIG_YR3_RT LOAN_UNKN_4YR_TRANS_YR3_RT
## 7804 7804 7804
## LOAN_UNKN_2YR_TRANS_YR3_RT NOLOAN_DEATH_YR3_RT NOLOAN_COMP_ORIG_YR3_RT
## 7804 7804 7804
## NOLOAN_COMP_4YR_TRANS_YR3_RT NOLOAN_COMP_2YR_TRANS_YR3_RT NOLOAN_WDRAW_ORIG_YR3_RT
## 7804 7804 7804
## NOLOAN_WDRAW_4YR_TRANS_YR3_RT NOLOAN_WDRAW_2YR_TRANS_YR3_RT NOLOAN_ENRL_ORIG_YR3_RT
## 7804 7804 7804
## NOLOAN_ENRL_4YR_TRANS_YR3_RT NOLOAN_ENRL_2YR_TRANS_YR3_RT NOLOAN_UNKN_ORIG_YR3_RT
## 7804 7804 7804
## NOLOAN_UNKN_4YR_TRANS_YR3_RT NOLOAN_UNKN_2YR_TRANS_YR3_RT FIRSTGEN_DEATH_YR3_RT
## 7804 7804 7804
## FIRSTGEN_COMP_ORIG_YR3_RT FIRSTGEN_COMP_4YR_TRANS_YR3_RT FIRSTGEN_COMP_2YR_TRANS_YR3_RT
## 7804 7804 7804
## FIRSTGEN_WDRAW_ORIG_YR3_RT FIRSTGEN_WDRAW_4YR_TRANS_YR3_RT FIRSTGEN_WDRAW_2YR_TRANS_YR3_RT
## 7804 7804 7804
## FIRSTGEN_ENRL_ORIG_YR3_RT FIRSTGEN_ENRL_4YR_TRANS_YR3_RT FIRSTGEN_ENRL_2YR_TRANS_YR3_RT
## 7804 7804 7804
## FIRSTGEN_UNKN_ORIG_YR3_RT FIRSTGEN_UNKN_4YR_TRANS_YR3_RT FIRSTGEN_UNKN_2YR_TRANS_YR3_RT
## 7804 7804 7804
## NOT1STGEN_DEATH_YR3_RT NOT1STGEN_COMP_ORIG_YR3_RT NOT1STGEN_COMP_4YR_TRANS_YR3_RT
## 7804 7804 7804
## NOT1STGEN_COMP_2YR_TRANS_YR3_RT NOT1STGEN_WDRAW_ORIG_YR3_RT NOT1STGEN_WDRAW_4YR_TRANS_YR3_RT
## 7804 7804 7804
## NOT1STGEN_WDRAW_2YR_TRANS_YR3_RT NOT1STGEN_ENRL_ORIG_YR3_RT NOT1STGEN_ENRL_4YR_TRANS_YR3_RT
## 7804 7804 7804
## NOT1STGEN_ENRL_2YR_TRANS_YR3_RT NOT1STGEN_UNKN_ORIG_YR3_RT NOT1STGEN_UNKN_4YR_TRANS_YR3_RT
## 7804 7804 7804
## NOT1STGEN_UNKN_2YR_TRANS_YR3_RT DEATH_YR4_RT COMP_ORIG_YR4_RT
## 7804 7804 7804
## COMP_4YR_TRANS_YR4_RT COMP_2YR_TRANS_YR4_RT WDRAW_ORIG_YR4_RT
## 7804 7804 7804
## WDRAW_4YR_TRANS_YR4_RT WDRAW_2YR_TRANS_YR4_RT ENRL_ORIG_YR4_RT
## 7804 7804 7804
## ENRL_4YR_TRANS_YR4_RT ENRL_2YR_TRANS_YR4_RT UNKN_ORIG_YR4_RT
## 7804 7804 7804
## UNKN_4YR_TRANS_YR4_RT UNKN_2YR_TRANS_YR4_RT LO_INC_DEATH_YR4_RT
## 7804 7804 7804
## LO_INC_COMP_ORIG_YR4_RT LO_INC_COMP_4YR_TRANS_YR4_RT LO_INC_COMP_2YR_TRANS_YR4_RT
## 7804 7804 7804
## LO_INC_WDRAW_ORIG_YR4_RT LO_INC_WDRAW_4YR_TRANS_YR4_RT LO_INC_WDRAW_2YR_TRANS_YR4_RT
## 7804 7804 7804
## LO_INC_ENRL_ORIG_YR4_RT LO_INC_ENRL_4YR_TRANS_YR4_RT LO_INC_ENRL_2YR_TRANS_YR4_RT
## 7804 7804 7804
## LO_INC_UNKN_ORIG_YR4_RT LO_INC_UNKN_4YR_TRANS_YR4_RT LO_INC_UNKN_2YR_TRANS_YR4_RT
## 7804 7804 7804
## MD_INC_DEATH_YR4_RT MD_INC_COMP_ORIG_YR4_RT MD_INC_COMP_4YR_TRANS_YR4_RT
## 7804 7804 7804
## MD_INC_COMP_2YR_TRANS_YR4_RT MD_INC_WDRAW_ORIG_YR4_RT MD_INC_WDRAW_4YR_TRANS_YR4_RT
## 7804 7804 7804
## MD_INC_WDRAW_2YR_TRANS_YR4_RT MD_INC_ENRL_ORIG_YR4_RT MD_INC_ENRL_4YR_TRANS_YR4_RT
## 7804 7804 7804
## MD_INC_ENRL_2YR_TRANS_YR4_RT MD_INC_UNKN_ORIG_YR4_RT MD_INC_UNKN_4YR_TRANS_YR4_RT
## 7804 7804 7804
## MD_INC_UNKN_2YR_TRANS_YR4_RT HI_INC_DEATH_YR4_RT HI_INC_COMP_ORIG_YR4_RT
## 7804 7804 7804
## HI_INC_COMP_4YR_TRANS_YR4_RT HI_INC_COMP_2YR_TRANS_YR4_RT HI_INC_WDRAW_ORIG_YR4_RT
## 7804 7804 7804
## HI_INC_WDRAW_4YR_TRANS_YR4_RT HI_INC_WDRAW_2YR_TRANS_YR4_RT HI_INC_ENRL_ORIG_YR4_RT
## 7804 7804 7804
## HI_INC_ENRL_4YR_TRANS_YR4_RT HI_INC_ENRL_2YR_TRANS_YR4_RT HI_INC_UNKN_ORIG_YR4_RT
## 7804 7804 7804
## HI_INC_UNKN_4YR_TRANS_YR4_RT HI_INC_UNKN_2YR_TRANS_YR4_RT DEP_DEATH_YR4_RT
## 7804 7804 7804
## DEP_COMP_ORIG_YR4_RT DEP_COMP_4YR_TRANS_YR4_RT DEP_COMP_2YR_TRANS_YR4_RT
## 7804 7804 7804
## DEP_WDRAW_ORIG_YR4_RT DEP_WDRAW_4YR_TRANS_YR4_RT DEP_WDRAW_2YR_TRANS_YR4_RT
## 7804 7804 7804
## DEP_ENRL_ORIG_YR4_RT DEP_ENRL_4YR_TRANS_YR4_RT DEP_ENRL_2YR_TRANS_YR4_RT
## 7804 7804 7804
## DEP_UNKN_ORIG_YR4_RT DEP_UNKN_4YR_TRANS_YR4_RT DEP_UNKN_2YR_TRANS_YR4_RT
## 7804 7804 7804
## IND_DEATH_YR4_RT IND_COMP_ORIG_YR4_RT IND_COMP_4YR_TRANS_YR4_RT
## 7804 7804 7804
## IND_COMP_2YR_TRANS_YR4_RT IND_WDRAW_ORIG_YR4_RT IND_WDRAW_4YR_TRANS_YR4_RT
## 7804 7804 7804
## IND_WDRAW_2YR_TRANS_YR4_RT IND_ENRL_ORIG_YR4_RT IND_ENRL_4YR_TRANS_YR4_RT
## 7804 7804 7804
## IND_ENRL_2YR_TRANS_YR4_RT IND_UNKN_ORIG_YR4_RT IND_UNKN_4YR_TRANS_YR4_RT
## 7804 7804 7804
## IND_UNKN_2YR_TRANS_YR4_RT FEMALE_DEATH_YR4_RT FEMALE_COMP_ORIG_YR4_RT
## 7804 7804 7804
## FEMALE_COMP_4YR_TRANS_YR4_RT FEMALE_COMP_2YR_TRANS_YR4_RT FEMALE_WDRAW_ORIG_YR4_RT
## 7804 7804 7804
## FEMALE_WDRAW_4YR_TRANS_YR4_RT FEMALE_WDRAW_2YR_TRANS_YR4_RT FEMALE_ENRL_ORIG_YR4_RT
## 7804 7804 7804
## FEMALE_ENRL_4YR_TRANS_YR4_RT FEMALE_ENRL_2YR_TRANS_YR4_RT FEMALE_UNKN_ORIG_YR4_RT
## 7804 7804 7804
## FEMALE_UNKN_4YR_TRANS_YR4_RT FEMALE_UNKN_2YR_TRANS_YR4_RT MALE_DEATH_YR4_RT
## 7804 7804 7804
## MALE_COMP_ORIG_YR4_RT MALE_COMP_4YR_TRANS_YR4_RT MALE_COMP_2YR_TRANS_YR4_RT
## 7804 7804 7804
## MALE_WDRAW_ORIG_YR4_RT MALE_WDRAW_4YR_TRANS_YR4_RT MALE_WDRAW_2YR_TRANS_YR4_RT
## 7804 7804 7804
## MALE_ENRL_ORIG_YR4_RT MALE_ENRL_4YR_TRANS_YR4_RT MALE_ENRL_2YR_TRANS_YR4_RT
## 7804 7804 7804
## MALE_UNKN_ORIG_YR4_RT MALE_UNKN_4YR_TRANS_YR4_RT MALE_UNKN_2YR_TRANS_YR4_RT
## 7804 7804 7804
## PELL_DEATH_YR4_RT PELL_COMP_ORIG_YR4_RT PELL_COMP_4YR_TRANS_YR4_RT
## 7804 7804 7804
## PELL_COMP_2YR_TRANS_YR4_RT PELL_WDRAW_ORIG_YR4_RT PELL_WDRAW_4YR_TRANS_YR4_RT
## 7804 7804 7804
## PELL_WDRAW_2YR_TRANS_YR4_RT PELL_ENRL_ORIG_YR4_RT PELL_ENRL_4YR_TRANS_YR4_RT
## 7804 7804 7804
## PELL_ENRL_2YR_TRANS_YR4_RT PELL_UNKN_ORIG_YR4_RT PELL_UNKN_4YR_TRANS_YR4_RT
## 7804 7804 7804
## PELL_UNKN_2YR_TRANS_YR4_RT NOPELL_DEATH_YR4_RT NOPELL_COMP_ORIG_YR4_RT
## 7804 7804 7804
## NOPELL_COMP_4YR_TRANS_YR4_RT NOPELL_COMP_2YR_TRANS_YR4_RT NOPELL_WDRAW_ORIG_YR4_RT
## 7804 7804 7804
## NOPELL_WDRAW_4YR_TRANS_YR4_RT NOPELL_WDRAW_2YR_TRANS_YR4_RT NOPELL_ENRL_ORIG_YR4_RT
## 7804 7804 7804
## NOPELL_ENRL_4YR_TRANS_YR4_RT NOPELL_ENRL_2YR_TRANS_YR4_RT NOPELL_UNKN_ORIG_YR4_RT
## 7804 7804 7804
## NOPELL_UNKN_4YR_TRANS_YR4_RT NOPELL_UNKN_2YR_TRANS_YR4_RT LOAN_DEATH_YR4_RT
## 7804 7804 7804
## LOAN_COMP_ORIG_YR4_RT LOAN_COMP_4YR_TRANS_YR4_RT LOAN_COMP_2YR_TRANS_YR4_RT
## 7804 7804 7804
## LOAN_WDRAW_ORIG_YR4_RT LOAN_WDRAW_4YR_TRANS_YR4_RT LOAN_WDRAW_2YR_TRANS_YR4_RT
## 7804 7804 7804
## LOAN_ENRL_ORIG_YR4_RT LOAN_ENRL_4YR_TRANS_YR4_RT LOAN_ENRL_2YR_TRANS_YR4_RT
## 7804 7804 7804
## LOAN_UNKN_ORIG_YR4_RT LOAN_UNKN_4YR_TRANS_YR4_RT LOAN_UNKN_2YR_TRANS_YR4_RT
## 7804 7804 7804
## NOLOAN_DEATH_YR4_RT NOLOAN_COMP_ORIG_YR4_RT NOLOAN_COMP_4YR_TRANS_YR4_RT
## 7804 7804 7804
## NOLOAN_COMP_2YR_TRANS_YR4_RT NOLOAN_WDRAW_ORIG_YR4_RT NOLOAN_WDRAW_4YR_TRANS_YR4_RT
## 7804 7804 7804
## NOLOAN_WDRAW_2YR_TRANS_YR4_RT NOLOAN_ENRL_ORIG_YR4_RT NOLOAN_ENRL_4YR_TRANS_YR4_RT
## 7804 7804 7804
## NOLOAN_ENRL_2YR_TRANS_YR4_RT NOLOAN_UNKN_ORIG_YR4_RT NOLOAN_UNKN_4YR_TRANS_YR4_RT
## 7804 7804 7804
## NOLOAN_UNKN_2YR_TRANS_YR4_RT FIRSTGEN_DEATH_YR4_RT FIRSTGEN_COMP_ORIG_YR4_RT
## 7804 7804 7804
## FIRSTGEN_COMP_4YR_TRANS_YR4_RT FIRSTGEN_COMP_2YR_TRANS_YR4_RT FIRSTGEN_WDRAW_ORIG_YR4_RT
## 7804 7804 7804
## FIRSTGEN_WDRAW_4YR_TRANS_YR4_RT FIRSTGEN_WDRAW_2YR_TRANS_YR4_RT FIRSTGEN_ENRL_ORIG_YR4_RT
## 7804 7804 7804
## FIRSTGEN_ENRL_4YR_TRANS_YR4_RT FIRSTGEN_ENRL_2YR_TRANS_YR4_RT FIRSTGEN_UNKN_ORIG_YR4_RT
## 7804 7804 7804
## FIRSTGEN_UNKN_4YR_TRANS_YR4_RT FIRSTGEN_UNKN_2YR_TRANS_YR4_RT NOT1STGEN_DEATH_YR4_RT
## 7804 7804 7804
## NOT1STGEN_COMP_ORIG_YR4_RT NOT1STGEN_COMP_4YR_TRANS_YR4_RT NOT1STGEN_COMP_2YR_TRANS_YR4_RT
## 7804 7804 7804
## NOT1STGEN_WDRAW_ORIG_YR4_RT NOT1STGEN_WDRAW_4YR_TRANS_YR4_RT NOT1STGEN_WDRAW_2YR_TRANS_YR4_RT
## 7804 7804 7804
## NOT1STGEN_ENRL_ORIG_YR4_RT NOT1STGEN_ENRL_4YR_TRANS_YR4_RT NOT1STGEN_ENRL_2YR_TRANS_YR4_RT
## 7804 7804 7804
## NOT1STGEN_UNKN_ORIG_YR4_RT NOT1STGEN_UNKN_4YR_TRANS_YR4_RT NOT1STGEN_UNKN_2YR_TRANS_YR4_RT
## 7804 7804 7804
## DEATH_YR6_RT COMP_ORIG_YR6_RT COMP_4YR_TRANS_YR6_RT
## 7804 7804 7804
## COMP_2YR_TRANS_YR6_RT WDRAW_ORIG_YR6_RT WDRAW_4YR_TRANS_YR6_RT
## 7804 7804 7804
## WDRAW_2YR_TRANS_YR6_RT ENRL_ORIG_YR6_RT ENRL_4YR_TRANS_YR6_RT
## 7804 7804 7804
## ENRL_2YR_TRANS_YR6_RT UNKN_ORIG_YR6_RT UNKN_4YR_TRANS_YR6_RT
## 7804 7804 7804
## UNKN_2YR_TRANS_YR6_RT LO_INC_DEATH_YR6_RT LO_INC_COMP_ORIG_YR6_RT
## 7804 7804 7804
## LO_INC_COMP_4YR_TRANS_YR6_RT LO_INC_COMP_2YR_TRANS_YR6_RT LO_INC_WDRAW_ORIG_YR6_RT
## 7804 7804 7804
## LO_INC_WDRAW_4YR_TRANS_YR6_RT LO_INC_WDRAW_2YR_TRANS_YR6_RT LO_INC_ENRL_ORIG_YR6_RT
## 7804 7804 7804
## LO_INC_ENRL_4YR_TRANS_YR6_RT LO_INC_ENRL_2YR_TRANS_YR6_RT LO_INC_UNKN_ORIG_YR6_RT
## 7804 7804 7804
## LO_INC_UNKN_4YR_TRANS_YR6_RT LO_INC_UNKN_2YR_TRANS_YR6_RT MD_INC_DEATH_YR6_RT
## 7804 7804 7804
## MD_INC_COMP_ORIG_YR6_RT MD_INC_COMP_4YR_TRANS_YR6_RT MD_INC_COMP_2YR_TRANS_YR6_RT
## 7804 7804 7804
## MD_INC_WDRAW_ORIG_YR6_RT MD_INC_WDRAW_4YR_TRANS_YR6_RT MD_INC_WDRAW_2YR_TRANS_YR6_RT
## 7804 7804 7804
## MD_INC_ENRL_ORIG_YR6_RT MD_INC_ENRL_4YR_TRANS_YR6_RT MD_INC_ENRL_2YR_TRANS_YR6_RT
## 7804 7804 7804
## MD_INC_UNKN_ORIG_YR6_RT MD_INC_UNKN_4YR_TRANS_YR6_RT MD_INC_UNKN_2YR_TRANS_YR6_RT
## 7804 7804 7804
## HI_INC_DEATH_YR6_RT HI_INC_COMP_ORIG_YR6_RT HI_INC_COMP_4YR_TRANS_YR6_RT
## 7804 7804 7804
## HI_INC_COMP_2YR_TRANS_YR6_RT HI_INC_WDRAW_ORIG_YR6_RT HI_INC_WDRAW_4YR_TRANS_YR6_RT
## 7804 7804 7804
## HI_INC_WDRAW_2YR_TRANS_YR6_RT HI_INC_ENRL_ORIG_YR6_RT HI_INC_ENRL_4YR_TRANS_YR6_RT
## 7804 7804 7804
## HI_INC_ENRL_2YR_TRANS_YR6_RT HI_INC_UNKN_ORIG_YR6_RT HI_INC_UNKN_4YR_TRANS_YR6_RT
## 7804 7804 7804
## HI_INC_UNKN_2YR_TRANS_YR6_RT DEP_DEATH_YR6_RT DEP_COMP_ORIG_YR6_RT
## 7804 7804 7804
## DEP_COMP_4YR_TRANS_YR6_RT DEP_COMP_2YR_TRANS_YR6_RT DEP_WDRAW_ORIG_YR6_RT
## 7804 7804 7804
## DEP_WDRAW_4YR_TRANS_YR6_RT DEP_WDRAW_2YR_TRANS_YR6_RT DEP_ENRL_ORIG_YR6_RT
## 7804 7804 7804
## DEP_ENRL_4YR_TRANS_YR6_RT DEP_ENRL_2YR_TRANS_YR6_RT DEP_UNKN_ORIG_YR6_RT
## 7804 7804 7804
## DEP_UNKN_4YR_TRANS_YR6_RT DEP_UNKN_2YR_TRANS_YR6_RT IND_DEATH_YR6_RT
## 7804 7804 7804
## IND_COMP_ORIG_YR6_RT IND_COMP_4YR_TRANS_YR6_RT IND_COMP_2YR_TRANS_YR6_RT
## 7804 7804 7804
## IND_WDRAW_ORIG_YR6_RT IND_WDRAW_4YR_TRANS_YR6_RT IND_WDRAW_2YR_TRANS_YR6_RT
## 7804 7804 7804
## IND_ENRL_ORIG_YR6_RT IND_ENRL_4YR_TRANS_YR6_RT IND_ENRL_2YR_TRANS_YR6_RT
## 7804 7804 7804
## IND_UNKN_ORIG_YR6_RT IND_UNKN_4YR_TRANS_YR6_RT IND_UNKN_2YR_TRANS_YR6_RT
## 7804 7804 7804
## FEMALE_DEATH_YR6_RT FEMALE_COMP_ORIG_YR6_RT FEMALE_COMP_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FEMALE_COMP_2YR_TRANS_YR6_RT FEMALE_WDRAW_ORIG_YR6_RT FEMALE_WDRAW_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FEMALE_WDRAW_2YR_TRANS_YR6_RT FEMALE_ENRL_ORIG_YR6_RT FEMALE_ENRL_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FEMALE_ENRL_2YR_TRANS_YR6_RT FEMALE_UNKN_ORIG_YR6_RT FEMALE_UNKN_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FEMALE_UNKN_2YR_TRANS_YR6_RT MALE_DEATH_YR6_RT MALE_COMP_ORIG_YR6_RT
## 7804 7804 7804
## MALE_COMP_4YR_TRANS_YR6_RT MALE_COMP_2YR_TRANS_YR6_RT MALE_WDRAW_ORIG_YR6_RT
## 7804 7804 7804
## MALE_WDRAW_4YR_TRANS_YR6_RT MALE_WDRAW_2YR_TRANS_YR6_RT MALE_ENRL_ORIG_YR6_RT
## 7804 7804 7804
## MALE_ENRL_4YR_TRANS_YR6_RT MALE_ENRL_2YR_TRANS_YR6_RT MALE_UNKN_ORIG_YR6_RT
## 7804 7804 7804
## MALE_UNKN_4YR_TRANS_YR6_RT MALE_UNKN_2YR_TRANS_YR6_RT PELL_DEATH_YR6_RT
## 7804 7804 7804
## PELL_COMP_ORIG_YR6_RT PELL_COMP_4YR_TRANS_YR6_RT PELL_COMP_2YR_TRANS_YR6_RT
## 7804 7804 7804
## PELL_WDRAW_ORIG_YR6_RT PELL_WDRAW_4YR_TRANS_YR6_RT PELL_WDRAW_2YR_TRANS_YR6_RT
## 7804 7804 7804
## PELL_ENRL_ORIG_YR6_RT PELL_ENRL_4YR_TRANS_YR6_RT PELL_ENRL_2YR_TRANS_YR6_RT
## 7804 7804 7804
## PELL_UNKN_ORIG_YR6_RT PELL_UNKN_4YR_TRANS_YR6_RT PELL_UNKN_2YR_TRANS_YR6_RT
## 7804 7804 7804
## NOPELL_DEATH_YR6_RT NOPELL_COMP_ORIG_YR6_RT NOPELL_COMP_4YR_TRANS_YR6_RT
## 7804 7804 7804
## NOPELL_COMP_2YR_TRANS_YR6_RT NOPELL_WDRAW_ORIG_YR6_RT NOPELL_WDRAW_4YR_TRANS_YR6_RT
## 7804 7804 7804
## NOPELL_WDRAW_2YR_TRANS_YR6_RT NOPELL_ENRL_ORIG_YR6_RT NOPELL_ENRL_4YR_TRANS_YR6_RT
## 7804 7804 7804
## NOPELL_ENRL_2YR_TRANS_YR6_RT NOPELL_UNKN_ORIG_YR6_RT NOPELL_UNKN_4YR_TRANS_YR6_RT
## 7804 7804 7804
## NOPELL_UNKN_2YR_TRANS_YR6_RT LOAN_DEATH_YR6_RT LOAN_COMP_ORIG_YR6_RT
## 7804 7804 7804
## LOAN_COMP_4YR_TRANS_YR6_RT LOAN_COMP_2YR_TRANS_YR6_RT LOAN_WDRAW_ORIG_YR6_RT
## 7804 7804 7804
## LOAN_WDRAW_4YR_TRANS_YR6_RT LOAN_WDRAW_2YR_TRANS_YR6_RT LOAN_ENRL_ORIG_YR6_RT
## 7804 7804 7804
## LOAN_ENRL_4YR_TRANS_YR6_RT LOAN_ENRL_2YR_TRANS_YR6_RT LOAN_UNKN_ORIG_YR6_RT
## 7804 7804 7804
## LOAN_UNKN_4YR_TRANS_YR6_RT LOAN_UNKN_2YR_TRANS_YR6_RT NOLOAN_DEATH_YR6_RT
## 7804 7804 7804
## NOLOAN_COMP_ORIG_YR6_RT NOLOAN_COMP_4YR_TRANS_YR6_RT NOLOAN_COMP_2YR_TRANS_YR6_RT
## 7804 7804 7804
## NOLOAN_WDRAW_ORIG_YR6_RT NOLOAN_WDRAW_4YR_TRANS_YR6_RT NOLOAN_WDRAW_2YR_TRANS_YR6_RT
## 7804 7804 7804
## NOLOAN_ENRL_ORIG_YR6_RT NOLOAN_ENRL_4YR_TRANS_YR6_RT NOLOAN_ENRL_2YR_TRANS_YR6_RT
## 7804 7804 7804
## NOLOAN_UNKN_ORIG_YR6_RT NOLOAN_UNKN_4YR_TRANS_YR6_RT NOLOAN_UNKN_2YR_TRANS_YR6_RT
## 7804 7804 7804
## FIRSTGEN_DEATH_YR6_RT FIRSTGEN_COMP_ORIG_YR6_RT FIRSTGEN_COMP_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FIRSTGEN_COMP_2YR_TRANS_YR6_RT FIRSTGEN_WDRAW_ORIG_YR6_RT FIRSTGEN_WDRAW_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FIRSTGEN_WDRAW_2YR_TRANS_YR6_RT FIRSTGEN_ENRL_ORIG_YR6_RT FIRSTGEN_ENRL_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FIRSTGEN_ENRL_2YR_TRANS_YR6_RT FIRSTGEN_UNKN_ORIG_YR6_RT FIRSTGEN_UNKN_4YR_TRANS_YR6_RT
## 7804 7804 7804
## FIRSTGEN_UNKN_2YR_TRANS_YR6_RT NOT1STGEN_DEATH_YR6_RT NOT1STGEN_COMP_ORIG_YR6_RT
## 7804 7804 7804
## NOT1STGEN_COMP_4YR_TRANS_YR6_RT NOT1STGEN_COMP_2YR_TRANS_YR6_RT NOT1STGEN_WDRAW_ORIG_YR6_RT
## 7804 7804 7804
## NOT1STGEN_WDRAW_4YR_TRANS_YR6_RT NOT1STGEN_WDRAW_2YR_TRANS_YR6_RT NOT1STGEN_ENRL_ORIG_YR6_RT
## 7804 7804 7804
## NOT1STGEN_ENRL_4YR_TRANS_YR6_RT NOT1STGEN_ENRL_2YR_TRANS_YR6_RT NOT1STGEN_UNKN_ORIG_YR6_RT
## 7804 7804 7804
## NOT1STGEN_UNKN_4YR_TRANS_YR6_RT NOT1STGEN_UNKN_2YR_TRANS_YR6_RT DEATH_YR8_RT
## 7804 7804 7804
## COMP_ORIG_YR8_RT COMP_4YR_TRANS_YR8_RT COMP_2YR_TRANS_YR8_RT
## 7804 7804 7804
## WDRAW_ORIG_YR8_RT WDRAW_4YR_TRANS_YR8_RT WDRAW_2YR_TRANS_YR8_RT
## 7804 7804 7804
## ENRL_ORIG_YR8_RT ENRL_4YR_TRANS_YR8_RT ENRL_2YR_TRANS_YR8_RT
## 7804 7804 7804
## UNKN_ORIG_YR8_RT UNKN_4YR_TRANS_YR8_RT UNKN_2YR_TRANS_YR8_RT
## 7804 7804 7804
## LO_INC_DEATH_YR8_RT LO_INC_COMP_ORIG_YR8_RT LO_INC_COMP_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LO_INC_COMP_2YR_TRANS_YR8_RT LO_INC_WDRAW_ORIG_YR8_RT LO_INC_WDRAW_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LO_INC_WDRAW_2YR_TRANS_YR8_RT LO_INC_ENRL_ORIG_YR8_RT LO_INC_ENRL_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LO_INC_ENRL_2YR_TRANS_YR8_RT LO_INC_UNKN_ORIG_YR8_RT LO_INC_UNKN_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LO_INC_UNKN_2YR_TRANS_YR8_RT MD_INC_DEATH_YR8_RT MD_INC_COMP_ORIG_YR8_RT
## 7804 7804 7804
## MD_INC_COMP_4YR_TRANS_YR8_RT MD_INC_COMP_2YR_TRANS_YR8_RT MD_INC_WDRAW_ORIG_YR8_RT
## 7804 7804 7804
## MD_INC_WDRAW_4YR_TRANS_YR8_RT MD_INC_WDRAW_2YR_TRANS_YR8_RT MD_INC_ENRL_ORIG_YR8_RT
## 7804 7804 7804
## MD_INC_ENRL_4YR_TRANS_YR8_RT MD_INC_ENRL_2YR_TRANS_YR8_RT MD_INC_UNKN_ORIG_YR8_RT
## 7804 7804 7804
## MD_INC_UNKN_4YR_TRANS_YR8_RT MD_INC_UNKN_2YR_TRANS_YR8_RT HI_INC_DEATH_YR8_RT
## 7804 7804 7804
## HI_INC_COMP_ORIG_YR8_RT HI_INC_COMP_4YR_TRANS_YR8_RT HI_INC_COMP_2YR_TRANS_YR8_RT
## 7804 7804 7804
## HI_INC_WDRAW_ORIG_YR8_RT HI_INC_WDRAW_4YR_TRANS_YR8_RT HI_INC_WDRAW_2YR_TRANS_YR8_RT
## 7804 7804 7804
## HI_INC_ENRL_ORIG_YR8_RT HI_INC_ENRL_4YR_TRANS_YR8_RT HI_INC_ENRL_2YR_TRANS_YR8_RT
## 7804 7804 7804
## HI_INC_UNKN_ORIG_YR8_RT HI_INC_UNKN_4YR_TRANS_YR8_RT HI_INC_UNKN_2YR_TRANS_YR8_RT
## 7804 7804 7804
## DEP_DEATH_YR8_RT DEP_COMP_ORIG_YR8_RT DEP_COMP_4YR_TRANS_YR8_RT
## 7804 7804 7804
## DEP_COMP_2YR_TRANS_YR8_RT DEP_WDRAW_ORIG_YR8_RT DEP_WDRAW_4YR_TRANS_YR8_RT
## 7804 7804 7804
## DEP_WDRAW_2YR_TRANS_YR8_RT DEP_ENRL_ORIG_YR8_RT DEP_ENRL_4YR_TRANS_YR8_RT
## 7804 7804 7804
## DEP_ENRL_2YR_TRANS_YR8_RT DEP_UNKN_ORIG_YR8_RT DEP_UNKN_4YR_TRANS_YR8_RT
## 7804 7804 7804
## DEP_UNKN_2YR_TRANS_YR8_RT IND_DEATH_YR8_RT IND_COMP_ORIG_YR8_RT
## 7804 7804 7804
## IND_COMP_4YR_TRANS_YR8_RT IND_COMP_2YR_TRANS_YR8_RT IND_WDRAW_ORIG_YR8_RT
## 7804 7804 7804
## IND_WDRAW_4YR_TRANS_YR8_RT IND_WDRAW_2YR_TRANS_YR8_RT IND_ENRL_ORIG_YR8_RT
## 7804 7804 7804
## IND_ENRL_4YR_TRANS_YR8_RT IND_ENRL_2YR_TRANS_YR8_RT IND_UNKN_ORIG_YR8_RT
## 7804 7804 7804
## IND_UNKN_4YR_TRANS_YR8_RT IND_UNKN_2YR_TRANS_YR8_RT FEMALE_DEATH_YR8_RT
## 7804 7804 7804
## FEMALE_COMP_ORIG_YR8_RT FEMALE_COMP_4YR_TRANS_YR8_RT FEMALE_COMP_2YR_TRANS_YR8_RT
## 7804 7804 7804
## FEMALE_WDRAW_ORIG_YR8_RT FEMALE_WDRAW_4YR_TRANS_YR8_RT FEMALE_WDRAW_2YR_TRANS_YR8_RT
## 7804 7804 7804
## FEMALE_ENRL_ORIG_YR8_RT FEMALE_ENRL_4YR_TRANS_YR8_RT FEMALE_ENRL_2YR_TRANS_YR8_RT
## 7804 7804 7804
## FEMALE_UNKN_ORIG_YR8_RT FEMALE_UNKN_4YR_TRANS_YR8_RT FEMALE_UNKN_2YR_TRANS_YR8_RT
## 7804 7804 7804
## MALE_DEATH_YR8_RT MALE_COMP_ORIG_YR8_RT MALE_COMP_4YR_TRANS_YR8_RT
## 7804 7804 7804
## MALE_COMP_2YR_TRANS_YR8_RT MALE_WDRAW_ORIG_YR8_RT MALE_WDRAW_4YR_TRANS_YR8_RT
## 7804 7804 7804
## MALE_WDRAW_2YR_TRANS_YR8_RT MALE_ENRL_ORIG_YR8_RT MALE_ENRL_4YR_TRANS_YR8_RT
## 7804 7804 7804
## MALE_ENRL_2YR_TRANS_YR8_RT MALE_UNKN_ORIG_YR8_RT MALE_UNKN_4YR_TRANS_YR8_RT
## 7804 7804 7804
## MALE_UNKN_2YR_TRANS_YR8_RT PELL_DEATH_YR8_RT PELL_COMP_ORIG_YR8_RT
## 7804 7804 7804
## PELL_COMP_4YR_TRANS_YR8_RT PELL_COMP_2YR_TRANS_YR8_RT PELL_WDRAW_ORIG_YR8_RT
## 7804 7804 7804
## PELL_WDRAW_4YR_TRANS_YR8_RT PELL_WDRAW_2YR_TRANS_YR8_RT PELL_ENRL_ORIG_YR8_RT
## 7804 7804 7804
## PELL_ENRL_4YR_TRANS_YR8_RT PELL_ENRL_2YR_TRANS_YR8_RT PELL_UNKN_ORIG_YR8_RT
## 7804 7804 7804
## PELL_UNKN_4YR_TRANS_YR8_RT PELL_UNKN_2YR_TRANS_YR8_RT NOPELL_DEATH_YR8_RT
## 7804 7804 7804
## NOPELL_COMP_ORIG_YR8_RT NOPELL_COMP_4YR_TRANS_YR8_RT NOPELL_COMP_2YR_TRANS_YR8_RT
## 7804 7804 7804
## NOPELL_WDRAW_ORIG_YR8_RT NOPELL_WDRAW_4YR_TRANS_YR8_RT NOPELL_WDRAW_2YR_TRANS_YR8_RT
## 7804 7804 7804
## NOPELL_ENRL_ORIG_YR8_RT NOPELL_ENRL_4YR_TRANS_YR8_RT NOPELL_ENRL_2YR_TRANS_YR8_RT
## 7804 7804 7804
## NOPELL_UNKN_ORIG_YR8_RT NOPELL_UNKN_4YR_TRANS_YR8_RT NOPELL_UNKN_2YR_TRANS_YR8_RT
## 7804 7804 7804
## LOAN_DEATH_YR8_RT LOAN_COMP_ORIG_YR8_RT LOAN_COMP_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LOAN_COMP_2YR_TRANS_YR8_RT LOAN_WDRAW_ORIG_YR8_RT LOAN_WDRAW_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LOAN_WDRAW_2YR_TRANS_YR8_RT LOAN_ENRL_ORIG_YR8_RT LOAN_ENRL_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LOAN_ENRL_2YR_TRANS_YR8_RT LOAN_UNKN_ORIG_YR8_RT LOAN_UNKN_4YR_TRANS_YR8_RT
## 7804 7804 7804
## LOAN_UNKN_2YR_TRANS_YR8_RT NOLOAN_DEATH_YR8_RT NOLOAN_COMP_ORIG_YR8_RT
## 7804 7804 7804
## NOLOAN_COMP_4YR_TRANS_YR8_RT NOLOAN_COMP_2YR_TRANS_YR8_RT NOLOAN_WDRAW_ORIG_YR8_RT
## 7804 7804 7804
## NOLOAN_WDRAW_4YR_TRANS_YR8_RT NOLOAN_WDRAW_2YR_TRANS_YR8_RT NOLOAN_ENRL_ORIG_YR8_RT
## 7804 7804 7804
## NOLOAN_ENRL_4YR_TRANS_YR8_RT NOLOAN_ENRL_2YR_TRANS_YR8_RT NOLOAN_UNKN_ORIG_YR8_RT
## 7804 7804 7804
## NOLOAN_UNKN_4YR_TRANS_YR8_RT NOLOAN_UNKN_2YR_TRANS_YR8_RT FIRSTGEN_DEATH_YR8_RT
## 7804 7804 7804
## FIRSTGEN_COMP_ORIG_YR8_RT FIRSTGEN_COMP_4YR_TRANS_YR8_RT FIRSTGEN_COMP_2YR_TRANS_YR8_RT
## 7804 7804 7804
## FIRSTGEN_WDRAW_ORIG_YR8_RT FIRSTGEN_WDRAW_4YR_TRANS_YR8_RT FIRSTGEN_WDRAW_2YR_TRANS_YR8_RT
## 7804 7804 7804
## FIRSTGEN_ENRL_ORIG_YR8_RT FIRSTGEN_ENRL_4YR_TRANS_YR8_RT FIRSTGEN_ENRL_2YR_TRANS_YR8_RT
## 7804 7804 7804
## FIRSTGEN_UNKN_ORIG_YR8_RT FIRSTGEN_UNKN_4YR_TRANS_YR8_RT FIRSTGEN_UNKN_2YR_TRANS_YR8_RT
## 7804 7804 7804
## NOT1STGEN_DEATH_YR8_RT NOT1STGEN_COMP_ORIG_YR8_RT NOT1STGEN_COMP_4YR_TRANS_YR8_RT
## 7804 7804 7804
## NOT1STGEN_COMP_2YR_TRANS_YR8_RT NOT1STGEN_WDRAW_ORIG_YR8_RT NOT1STGEN_WDRAW_4YR_TRANS_YR8_RT
## 7804 7804 7804
## NOT1STGEN_WDRAW_2YR_TRANS_YR8_RT NOT1STGEN_ENRL_ORIG_YR8_RT NOT1STGEN_ENRL_4YR_TRANS_YR8_RT
## 7804 7804 7804
## NOT1STGEN_ENRL_2YR_TRANS_YR8_RT NOT1STGEN_UNKN_ORIG_YR8_RT NOT1STGEN_UNKN_4YR_TRANS_YR8_RT
## 7804 7804 7804
## NOT1STGEN_UNKN_2YR_TRANS_YR8_RT RPY_1YR_RT COMPL_RPY_1YR_RT
## 7804 7804 7804
## NONCOM_RPY_1YR_RT LO_INC_RPY_1YR_RT MD_INC_RPY_1YR_RT
## 7804 7804 7804
## HI_INC_RPY_1YR_RT DEP_RPY_1YR_RT IND_RPY_1YR_RT
## 7804 7804 7804
## PELL_RPY_1YR_RT NOPELL_RPY_1YR_RT FEMALE_RPY_1YR_RT
## 7804 7804 7804
## MALE_RPY_1YR_RT FIRSTGEN_RPY_1YR_RT NOTFIRSTGEN_RPY_1YR_RT
## 7804 7804 7804
## RPY_3YR_RT COMPL_RPY_3YR_RT NONCOM_RPY_3YR_RT
## 1669 5363 5466
## LO_INC_RPY_3YR_RT MD_INC_RPY_3YR_RT HI_INC_RPY_3YR_RT
## 2913 4079 6386
## DEP_RPY_3YR_RT IND_RPY_3YR_RT PELL_RPY_3YR_RT
## 5861 4611 4013
## NOPELL_RPY_3YR_RT FEMALE_RPY_3YR_RT MALE_RPY_3YR_RT
## 6450 4002 5672
## FIRSTGEN_RPY_3YR_RT NOTFIRSTGEN_RPY_3YR_RT RPY_5YR_RT
## 2701 2574 1907
## COMPL_RPY_5YR_RT NONCOM_RPY_5YR_RT LO_INC_RPY_5YR_RT
## 5632 5511 3116
## MD_INC_RPY_5YR_RT HI_INC_RPY_5YR_RT DEP_RPY_5YR_RT
## 4214 6406 5634
## IND_RPY_5YR_RT PELL_RPY_5YR_RT NOPELL_RPY_5YR_RT
## 5021 4393 6244
## FEMALE_RPY_5YR_RT MALE_RPY_5YR_RT FIRSTGEN_RPY_5YR_RT
## 4153 5745 3040
## NOTFIRSTGEN_RPY_5YR_RT RPY_7YR_RT COMPL_RPY_7YR_RT
## 2872 2113 5916
## NONCOM_RPY_7YR_RT LO_INC_RPY_7YR_RT MD_INC_RPY_7YR_RT
## 5339 3255 4453
## HI_INC_RPY_7YR_RT DEP_RPY_7YR_RT IND_RPY_7YR_RT
## 6457 5457 4902
## PELL_RPY_7YR_RT NOPELL_RPY_7YR_RT FEMALE_RPY_7YR_RT
## 4399 6413 4237
## MALE_RPY_7YR_RT FIRSTGEN_RPY_7YR_RT NOTFIRSTGEN_RPY_7YR_RT
## 5426 3174 3068
## INC_PCT_LO DEP_STAT_PCT_IND DEP_INC_PCT_LO
## 7676 7676 5662
## IND_INC_PCT_LO PAR_ED_PCT_1STGEN INC_PCT_M1
## 4117 1008 7681
## INC_PCT_M2 INC_PCT_H1 INC_PCT_H2
## 7678 7683 7798
## DEP_INC_PCT_M1 DEP_INC_PCT_M2 DEP_INC_PCT_H1
## 6246 6442 7220
## DEP_INC_PCT_H2 IND_INC_PCT_M1 IND_INC_PCT_M2
## 7499 4792 5442
## IND_INC_PCT_H1 IND_INC_PCT_H2 PAR_ED_PCT_MS
## 6397 7791 1087
## PAR_ED_PCT_HS PAR_ED_PCT_PS APPL_SCH_PCT_GE2
## 964 965 7804
## APPL_SCH_PCT_GE3 APPL_SCH_PCT_GE4 APPL_SCH_PCT_GE5
## 7804 7804 7804
## DEP_INC_AVG IND_INC_AVG OVERALL_YR2_N
## 5208 3332 7804
## LO_INC_YR2_N MD_INC_YR2_N HI_INC_YR2_N
## 7804 7804 7804
## DEP_YR2_N IND_YR2_N FEMALE_YR2_N
## 7804 7804 7804
## MALE_YR2_N PELL_YR2_N NOPELL_YR2_N
## 7804 7804 7804
## LOAN_YR2_N NOLOAN_YR2_N FIRSTGEN_YR2_N
## 7804 7804 7804
## NOT1STGEN_YR2_N OVERALL_YR3_N LO_INC_YR3_N
## 7804 7804 7804
## MD_INC_YR3_N HI_INC_YR3_N DEP_YR3_N
## 7804 7804 7804
## IND_YR3_N FEMALE_YR3_N MALE_YR3_N
## 7804 7804 7804
## PELL_YR3_N NOPELL_YR3_N LOAN_YR3_N
## 7804 7804 7804
## NOLOAN_YR3_N FIRSTGEN_YR3_N NOT1STGEN_YR3_N
## 7804 7804 7804
## OVERALL_YR4_N LO_INC_YR4_N MD_INC_YR4_N
## 7804 7804 7804
## HI_INC_YR4_N DEP_YR4_N IND_YR4_N
## 7804 7804 7804
## FEMALE_YR4_N MALE_YR4_N PELL_YR4_N
## 7804 7804 7804
## NOPELL_YR4_N LOAN_YR4_N NOLOAN_YR4_N
## 7804 7804 7804
## FIRSTGEN_YR4_N NOT1STGEN_YR4_N OVERALL_YR6_N
## 7804 7804 7804
## LO_INC_YR6_N MD_INC_YR6_N HI_INC_YR6_N
## 7804 7804 7804
## DEP_YR6_N IND_YR6_N FEMALE_YR6_N
## 7804 7804 7804
## MALE_YR6_N PELL_YR6_N NOPELL_YR6_N
## 7804 7804 7804
## LOAN_YR6_N NOLOAN_YR6_N FIRSTGEN_YR6_N
## 7804 7804 7804
## NOT1STGEN_YR6_N OVERALL_YR8_N LO_INC_YR8_N
## 7804 7804 7804
## MD_INC_YR8_N HI_INC_YR8_N DEP_YR8_N
## 7804 7804 7804
## IND_YR8_N FEMALE_YR8_N MALE_YR8_N
## 7804 7804 7804
## PELL_YR8_N NOPELL_YR8_N LOAN_YR8_N
## 7804 7804 7804
## NOLOAN_YR8_N FIRSTGEN_YR8_N NOT1STGEN_YR8_N
## 7804 7804 7804
## DEBT_MDN GRAD_DEBT_MDN WDRAW_DEBT_MDN
## 1241 1455 1626
## LO_INC_DEBT_MDN MD_INC_DEBT_MDN HI_INC_DEBT_MDN
## 1975 2476 4175
## DEP_DEBT_MDN IND_DEBT_MDN PELL_DEBT_MDN
## 3988 2826 2425
## NOPELL_DEBT_MDN FEMALE_DEBT_MDN MALE_DEBT_MDN
## 4740 2495 3583
## FIRSTGEN_DEBT_MDN NOTFIRSTGEN_DEBT_MDN DEBT_N
## 1533 1467 957
## GRAD_DEBT_N WDRAW_DEBT_N LO_INC_DEBT_N
## 1376 1375 1713
## MD_INC_DEBT_N HI_INC_DEBT_N DEP_DEBT_N
## 2107 4134 3888
## IND_DEBT_N PELL_DEBT_N NOPELL_DEBT_N
## 2610 2065 4719
## FEMALE_DEBT_N MALE_DEBT_N FIRSTGEN_DEBT_N
## 2204 3536 1423
## NOTFIRSTGEN_DEBT_N GRAD_DEBT_MDN10YR CUML_DEBT_N
## 1312 1455 957
## CUML_DEBT_P90 CUML_DEBT_P75 CUML_DEBT_P25
## 1772 1507 1507
## CUML_DEBT_P10 INC_N DEP_INC_N
## 1772 7675 5208
## IND_INC_N DEP_STAT_N PAR_ED_N
## 3332 7675 963
## APPL_SCH_N REPAY_DT_MDN SEPAR_DT_MDN
## 7804 7804 7804
## REPAY_DT_N SEPAR_DT_N RPY_1YR_N
## 7804 7804 7804
## COMPL_RPY_1YR_N NONCOM_RPY_1YR_N LO_INC_RPY_1YR_N
## 7804 7804 7804
## MD_INC_RPY_1YR_N HI_INC_RPY_1YR_N DEP_RPY_1YR_N
## 7804 7804 7804
## IND_RPY_1YR_N PELL_RPY_1YR_N NOPELL_RPY_1YR_N
## 7804 7804 7804
## FEMALE_RPY_1YR_N MALE_RPY_1YR_N FIRSTGEN_RPY_1YR_N
## 7804 7804 7804
## NOTFIRSTGEN_RPY_1YR_N RPY_3YR_N COMPL_RPY_3YR_N
## 7804 1311 3601
## NONCOM_RPY_3YR_N LO_INC_RPY_3YR_N MD_INC_RPY_3YR_N
## 4244 2136 2315
## HI_INC_RPY_3YR_N DEP_RPY_3YR_N IND_RPY_3YR_N
## 4977 4433 2973
## PELL_RPY_3YR_N NOPELL_RPY_3YR_N FEMALE_RPY_3YR_N
## 2612 4953 2545
## MALE_RPY_3YR_N FIRSTGEN_RPY_3YR_N NOTFIRSTGEN_RPY_3YR_N
## 4314 1763 1713
## RPY_5YR_N COMPL_RPY_5YR_N NONCOM_RPY_5YR_N
## 1603 3864 4303
## LO_INC_RPY_5YR_N MD_INC_RPY_5YR_N HI_INC_RPY_5YR_N
## 2329 2601 5030
## DEP_RPY_5YR_N IND_RPY_5YR_N PELL_RPY_5YR_N
## 4235 3392 2961
## NOPELL_RPY_5YR_N FEMALE_RPY_5YR_N MALE_RPY_5YR_N
## 4843 2836 4398
## FIRSTGEN_RPY_5YR_N NOTFIRSTGEN_RPY_5YR_N RPY_7YR_N
## 2035 1988 1776
## COMPL_RPY_7YR_N NONCOM_RPY_7YR_N LO_INC_RPY_7YR_N
## 3980 4092 2370
## MD_INC_RPY_7YR_N HI_INC_RPY_7YR_N DEP_RPY_7YR_N
## 2733 4908 4050
## IND_RPY_7YR_N PELL_RPY_7YR_N NOPELL_RPY_7YR_N
## 3264 2989 4597
## FEMALE_RPY_7YR_N MALE_RPY_7YR_N FIRSTGEN_RPY_7YR_N
## 2830 4107 2170
## NOTFIRSTGEN_RPY_7YR_N count_ed loan_ever
## 2138 7804 7804
## pell_ever age_entry age_entry_sq
## 7804 7804 7804
## agege24 female married
## 7804 7804 7804
## dependent veteran first_gen
## 7804 7804 7804
## faminc md_faminc faminc_ind
## 7804 7804 7804
## lnfaminc lnfaminc_ind pct_white
## 7804 7804 7804
## pct_black pct_asian pct_hispanic
## 7804 7804 7804
## pct_ba pct_grad_prof pct_born_us
## 7804 7804 7804
## median_hh_inc poverty_rate unemp_rate
## 7804 7804 7804
## ln_median_hh_inc fsend_count fsend_1
## 7804 7804 7804
## fsend_2 fsend_3 fsend_4
## 7804 7804 7804
## fsend_5 count_nwne_p10 count_wne_p10
## 7804 7804 7804
## mn_earn_wne_p10 md_earn_wne_p10 pct10_earn_wne_p10
## 7804 7804 7804
## pct25_earn_wne_p10 pct75_earn_wne_p10 pct90_earn_wne_p10
## 7804 7804 7804
## sd_earn_wne_p10 count_wne_inc1_p10 count_wne_inc2_p10
## 7804 7804 7804
## count_wne_inc3_p10 count_wne_indep0_inc1_p10 count_wne_indep0_p10
## 7804 7804 7804
## count_wne_indep1_p10 count_wne_male0_p10 count_wne_male1_p10
## 7804 7804 7804
## gt_25k_p10 mn_earn_wne_inc1_p10 mn_earn_wne_inc2_p10
## 7804 7804 7804
## mn_earn_wne_inc3_p10 mn_earn_wne_indep0_inc1_p10 mn_earn_wne_indep0_p10
## 7804 7804 7804
## mn_earn_wne_indep1_p10 mn_earn_wne_male0_p10 mn_earn_wne_male1_p10
## 7804 7804 7804
## count_nwne_p6 count_wne_p6 mn_earn_wne_p6
## 7804 7804 7804
## md_earn_wne_p6 pct10_earn_wne_p6 pct25_earn_wne_p6
## 7804 7804 7804
## pct75_earn_wne_p6 pct90_earn_wne_p6 sd_earn_wne_p6
## 7804 7804 7804
## count_wne_inc1_p6 count_wne_inc2_p6 count_wne_inc3_p6
## 7804 7804 7804
## count_wne_indep0_inc1_p6 count_wne_indep0_p6 count_wne_indep1_p6
## 7804 7804 7804
## count_wne_male0_p6 count_wne_male1_p6 gt_25k_p6
## 7804 7804 7804
## mn_earn_wne_inc1_p6 mn_earn_wne_inc2_p6 mn_earn_wne_inc3_p6
## 7804 7804 7804
## mn_earn_wne_indep0_inc1_p6 mn_earn_wne_indep0_p6 mn_earn_wne_indep1_p6
## 7804 7804 7804
## mn_earn_wne_male0_p6 mn_earn_wne_male1_p6 count_nwne_p7
## 7804 7804 7804
## count_wne_p7 mn_earn_wne_p7 sd_earn_wne_p7
## 7804 7804 7804
## gt_25k_p7 count_nwne_p8 count_wne_p8
## 7804 7804 7804
## mn_earn_wne_p8 md_earn_wne_p8 pct10_earn_wne_p8
## 7804 7804 7804
## pct25_earn_wne_p8 pct75_earn_wne_p8 pct90_earn_wne_p8
## 7804 7804 7804
## sd_earn_wne_p8 gt_25k_p8 count_nwne_p9
## 7804 7804 7804
## count_wne_p9 mn_earn_wne_p9 sd_earn_wne_p9
## 7804 7804 7804
## gt_25k_p9 DEBT_MDN_SUPP GRAD_DEBT_MDN_SUPP
## 7804 1165 1449
## GRAD_DEBT_MDN10YR_SUPP RPY_3YR_RT_SUPP LO_INC_RPY_3YR_RT_SUPP
## 1449 1523 1730
## MD_INC_RPY_3YR_RT_SUPP HI_INC_RPY_3YR_RT_SUPP COMPL_RPY_3YR_RT_SUPP
## 2291 3180 1839
## NONCOM_RPY_3YR_RT_SUPP DEP_RPY_3YR_RT_SUPP IND_RPY_3YR_RT_SUPP
## 2150 2165 1903
## PELL_RPY_3YR_RT_SUPP NOPELL_RPY_3YR_RT_SUPP FEMALE_RPY_3YR_RT_SUPP
## 1669 2322 1698
## MALE_RPY_3YR_RT_SUPP FIRSTGEN_RPY_3YR_RT_SUPP NOTFIRSTGEN_RPY_3YR_RT_SUPP
## 2635 1984 1979
## C150_L4_POOLED_SUPP C150_4_POOLED_SUPP C200_L4_POOLED_SUPP
## 3942 5432 4141
## C200_4_POOLED_SUPP
## 5800That’s quite a lot of NA values, which is going to be an issue for clustering algorithms. Let’s make a heatmap of some scaled values so we can see what is going on here with missing values.
library(Amelia)
missmap(colleges, col=c("gray90", "navy"), legend = FALSE, rank.order = FALSE,
y.labels = NULL, y.at = NULL)
Start to Clean This Up
At the very least, let’s remove the rows that are all NA.
colleges <- Filter(function(x)!all(is.na(x)), colleges)
dim(colleges)## [1] 7804 550Now, just for a first go at some analysis, let’s pick out some columns that we think are likely to be meaningful.
library(dplyr)
college_subset <- colleges %>%
select(OPEID, INSTNM, CITY, STABBR, ZIP,
main, LOCALE, HIGHDEG, CONTROL, CCBASIC, HBCU, WOMENONLY,
ADM_RATE, SAT_AVG, UGDS, PPTUG_EF, TUITIONFEE_IN, AVGFACSAL,
PCTFLOAN, C150_4, DEBT_MDN, DEP_INC_AVG)What are the quantities I have chosen here, for a first go at some analysis?
dictionary %>% filter(`VARIABLE NAME` %in% names(college_subset)) %>% select(`NAME OF DATA ELEMENT`)## # A tibble: 22 × 1
## `NAME OF DATA ELEMENT`
## <chr>
## 1 8-digit OPE ID for institution
## 2 Institution name
## 3 City
## 4 State postcode
## 5 ZIP code
## 6 Flag for main campus
## 7 Highest degree awarded\n0 Non-degree-granting\n1 Certificate degree\n2 Associate degree\n3 Bachelor's degree\n4 Graduate
## 8 Control of institution
## 9 Locale of institution
## 10 Carnegie Classification -- basic
## # ... with 12 more rowsThere are still lots of NA values here, so just to get started here, let’s only keep the schools that have reported values for all of these observations. How many does that give us?
college_subset <- college_subset[complete.cases(college_subset),]
dim(college_subset)## [1] 1209 22Principal Component Analysis
Let’s take a look at how these variables are related to each other using principal component analysis. First, let’s scale the values and then do PCA.
college_names <- college_subset$INSTNM
college_SAT <- college_subset$SAT_AVG
college_subset <- college_subset[,6:22]
college_subset <- scale(college_subset)
college_pca <- prcomp(college_subset)Let’s see what the first few of the principal components look like.
library(reshape2)
library(ggplot2)
melted <- melt(college_pca$rotation[,1:9])
ggplot(data = melted) +
theme(legend.position = "none", axis.text.x = element_blank(),
axis.ticks.x = element_blank()) +
labs(x = "Measurements in College Scorecard data",
y = "Relative importance in each principle component",
title = "Variables in Principal Component Analysis") +
geom_bar(aes(x=Var1, y=value, fill=Var1), stat="identity") +
facet_wrap(~Var2)
Each of these components are orthogonal to each other, and the colored bars show the contribution of each original measurement in the College Scorecard to that principal component. Each principal component is uncorrelated to the others and together, the principal components contain the information in the data set. Let’s zoom in on the first principal component, the one that has the largest variance and accounts for the most variability between the colleges.
ggplot(data = melted[melted$Var2 == "PC1",]) +
theme(legend.position = "none",
axis.text.x= element_text(angle=45, hjust = 1),
axis.ticks.x = element_blank()) +
labs(x = "Measurements in College Scorecard data",
y = "Relative importance in principle component",
title = "Variables in PC1") +
geom_bar(aes(x=Var1, y=value, fill=Var1), stat="identity")
The biggest contributors to this principal component (and thus to the variation between colleges in this subset of colleges) are SAT score and completion rate, followed by faculty salary and students’ family income. It appears that this principal component is finding schools with students who did well on the SAT score, complete college at a high rate, and come from high-income families (also the professors are paid well there). (Notice that all those values go in the negative direction, so the value for this principal component will be negative for these types of schools.)
We could look at the other principal components to look for lower level effects, and we probably should.
First Attempt at Clustering
Now let’s see if we can do some clustering with this subset of the colleges. I’m going to start with k-means clustering. Let’s use the broom package to explore how many clusters may be appropriate for this data set. For starters, let’s try out 4 to 12 clusters.
library(broom)
library(tidyr)
set.seed(1234)
kclusts <- data.frame(k=4:18) %>%
group_by(k) %>%
do(kclust = kmeans(college_subset, .$k))Now let’s use tidy, augment, and glance to organize these various sets of k-means clusterings.
clusters <- kclusts %>% group_by(k) %>% do(tidy(.$kclust[[1]]))
assignments <- kclusts %>% group_by(k) %>% do(augment(.$kclust[[1]], college_subset))
clusterings <- kclusts %>% group_by(k) %>% do(glance(.$kclust[[1]]))Specifically, let’s look at the total within sum of squares, saved in the tot.withinss column in clusterings. This shows us the variance within the clusters.
library(ggfortify)
ggplot(clusterings, aes(k, tot.withinss)) +
geom_line(color = "blue", alpha = 0.5, size = 2) +
geom_point(size = 0.8)
Notice that the variance decreases with more clusters, but there is a “bend” around 10 clusters. This tells us that for this particular subset of colleges, we don’t gain as much by going beyond 10 clusters. Let’s look at how the colleges are distributed in the space of principal component 1 and 2, clustered with \(k = 10\).
set.seed(1234)
autoplot(kmeans(college_subset, 10), data = college_subset, size = 3, alpha = 0.8) +
ggtitle("K-Means Clustering of College Scorecard Data") +
theme(legend.position="none")
Remember that the colleges with very negative values of PC1 were colleges where the students have high SAT scores, high completion rates, high family income levels, and the faculty have high salaries. Let’s label a few of them.
library(ggrepel)
set.seed(1234)
rownames(college_subset) <- college_names
autoplot(kmeans(college_subset, 10), data = college_subset, size = 3, alpha = 0.8) +
ggtitle("K-Means Clustering of College Scorecard Data") +
theme(legend.position="none") +
geom_text_repel(aes(PC1, PC2,
color = factor(kmeans(college_subset, 10)$cluster),
label = ifelse(college_SAT > 1475,rownames(college_subset),'')),
segment.color = NA)
Some of these clusters are overlapping as viewed in this space (PC1 and PC2) but they may be more separated in other components/dimensions.