In [23]:
import pandas as pd
pd.set_option('display.mpl_style', 'default')
pd.set_option('display.width', 5000)
pd.set_option('display.max_columns', 60)
In [24]:
colleges = pd.read_csv('/Users/carol/Downloads/college.csv')
In [26]:
colleges
Out[26]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
0
100663
University of Alabama at Birmingham
2013
Fall 2013
5689
2214
3475
4934
1944
2990
1773
717
1056
87
88
Fall 2013
520
640
520
650
NaN
NaN
22
28
22
29
20
26
NaN
NaN
87
88
36
37
7206
10,000 - 19,999
Alabama
13108
2195
1
100706
University of Alabama in Huntsville
2013
Fall 2013
2054
1183
871
1656
975
681
651
396
255
81
82
Fall 2013
510
640
510
650
NaN
NaN
23
29
22
30
22
28
NaN
NaN
81
82
39
41
9192
5,000 - 9,999
Alabama
6695
1099
2
100858
Auburn University
2013
Fall 2013
15745
6912
8833
13027
5727
7300
3726
1791
1935
83
83
Fall 2013
520
620
540
650
510
620
24
30
24
32
23
28
6
8
83
83
29
31
9852
20,000 and above
Alabama
21091
4278
3
100937
Birmingham Southern College
2013
Fall 2013
1931
942
989
1240
639
601
356
202
154
64
68
Fall 2013
520
630
520
640
NaN
NaN
23
29
23
30
22
27
NaN
NaN
64
68
29
32
30690
1,000 - 4,999
Alabama
1256
301
4
101541
Judson College
2013
Fall 2013
268
NaN
268
198
NaN
198
68
NaN
68
74
NaN
Fall 2013
550
640
500
600
530
610
19
24
19
26
16
23
NaN
NaN
74
NaN
34
NaN
15630
Under 1,000
Alabama
394
38
5
102049
Samford University
2013
Fall 2013
3447
1276
2171
2653
937
1716
765
267
498
77
73
Fall 2013
500
630
510
610
500
610
23
28
23
30
21
27
NaN
NaN
77
73
29
28
26328
1,000 - 4,999
Alabama
3124
667
6
104151
Arizona State University-Tempe
2013
Fall 2013
21770
11822
9948
17465
9292
8173
7171
4019
3152
80
79
Fall 2013
500
620
520
650
NaN
NaN
22
28
21
28
23
28
NaN
NaN
80
79
41
43
9861
20,000 and above
Arizona
43072
9278
7
104586
Embry-Riddle Aeronautical University-Prescott
2013
Fall 2013
1689
1352
337
1334
1057
277
448
329
119
79
78
Fall 2013
500
630
540
650
490
600
23
29
21
30
24
29
NaN
NaN
79
78
34
31
31034
1,000 - 4,999
Arizona
1813
322
8
106397
University of Arkansas
2013
Fall 2013
18908
8464
10444
11076
4947
6129
4339
2051
2288
59
58
Fall 2013
500
600
520
630
NaN
NaN
23
28
22
29
23
27
NaN
NaN
59
58
39
41
7818
20,000 and above
Arkansas
22355
3347
9
107080
Hendrix College
2013
Fall 2013
1928
948
980
1550
728
822
436
213
223
80
77
Fall 2013
530
680
540
650
NaN
NaN
26
32
26
34
25
30
NaN
NaN
80
77
28
29
37816
1,000 - 4,999
Arkansas
1423
314
10
107141
John Brown University
2013
Fall 2013
1143
458
685
798
340
458
305
134
171
70
74
Fall 2013
500
640
505
640
490
610
22
28
22
30
21
27
6
8
70
74
38
39
22734
1,000 - 4,999
Arkansas
2269
466
11
110097
Biola University
2013
Fall 2013
4816
1699
3117
3509
1165
2344
903
322
581
73
69
Fall 2013
500
620
503
620
490
620
22
27
21
28
22
27
NaN
NaN
73
69
26
28
32142
5,000 - 9,999
California
4516
908
12
110404
California Institute of Technology
2013
Fall 2013
5535
4109
1426
584
344
240
249
161
88
11
8
Fall 2013
720
800
770
800
720
790
33
35
33
35
34
36
8
10
11
8
43
47
41538
1,000 - 4,999
California
1021
256
13
110413
California Lutheran University
2013
Fall 2013
6920
3138
3782
3323
1470
1853
540
247
293
48
47
Fall 2013
500
590
510
613
NaN
NaN
22
26
22
27
22
27
NaN
NaN
48
47
16
17
35720
1,000 - 4,999
California
3178
721
14
110422
California Polytechnic State University-San Lu...
2013
Fall 2012
36941
19855
17086
11537
5746
5791
3635
2001
1634
31
29
Fall 2012
550
650
590
690
NaN
NaN
25
30
24
31
26
31
NaN
NaN
31
29
32
35
8724
10,000 - 19,999
California
18052
3300
15
110635
University of California-Berkeley
2013
Fall 2012
61717
30715
31002
11108
5233
5875
4162
2036
2126
18
17
Fall 2012
590
720
630
770
620
750
27
33
26
34
27
34
NaN
NaN
18
17
37
39
12864
20,000 and above
California
28662
7775
16
110644
University of California-Davis
2013
Fall 2012
49820
23010
26810
22526
9532
12994
5208
2066
3142
45
41
Fall 2012
510
640
560
680
530
650
23
29
22
30
24
30
NaN
NaN
45
41
23
22
13895
20,000 and above
California
27829
7015
17
110662
University of California-Los Angeles
2013
Fall 2012
72676
33663
39013
15981
7177
8804
5620
2417
3203
22
21
Fall 2012
560
680
600
760
590
710
25
31
24
32
25
33
NaN
NaN
22
21
35
34
12697
20,000 and above
California
30180
7329
18
110680
University of California-San Diego
2013
Fall 2012
60832
28725
32107
22812
10815
11997
4575
2329
2246
38
38
Fall 2012
550
660
620
730
580
690
25
31
24
31
26
33
NaN
NaN
38
38
20
22
13271
20,000 and above
California
24443
6344
19
110705
University of California-Santa Barbara
2013
Fall 2012
55258
24909
30349
24556
10850
13706
4741
2189
2552
44
44
Fall 2012
530
650
560
690
550
660
24
29
23
30
24
30
NaN
NaN
44
44
19
20
13746
20,000 and above
California
20557
5222
20
111948
Chapman University
2013
Fall 2013
11750
4398
7352
5253
1973
3280
1289
484
805
45
45
Fall 2013
550
640
570
660
560
650
24
29
24
31
24
29
8
9
45
45
25
25
43573
5,000 - 9,999
California
6173
1300
21
112260
Claremont McKenna College
2013
Fall 2013
5518
2526
2992
647
304
343
337
165
172
12
12
Fall 2013
650
740
670
760
660
750
29
33
29
34
29
34
NaN
NaN
12
12
52
54
45625
1,000 - 4,999
California
1319
289
22
115409
Harvey Mudd College
2013
Fall 2013
3539
2498
1041
643
313
330
217
114
103
18
13
Fall 2013
680
760
720
800
670
760
32
35
31
35
33
36
8
9
18
13
34
36
46509
Under 1,000
California
788
189
23
117946
Loyola Marymount University
2013
Fall 2013
11472
4438
7034
6209
2365
3844
1341
556
775
54
53
Fall 2013
540
640
550
650
550
650
25
29
24
31
24
28
8
9
54
53
22
24
40265
5,000 - 9,999
California
6529
1524
24
118888
Mills College
2013
Fall 2013
1827
0
1827
1242
NaN
1242
217
NaN
217
68
NaN
Fall 2013
540
640
500
610
520
620
23
28
NaN
NaN
NaN
NaN
NaN
NaN
68
NaN
17
NaN
41494
1,000 - 4,999
California
1022
241
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
26
120883
University of the Pacific
2013
Fall 2013
14222
5499
8723
10332
4146
6186
958
452
506
73
75
Fall 2013
500
640
530
680
500
640
22
29
21
28
22
28
NaN
NaN
73
75
9
11
39810
5,000 - 9,999
California
4099
823
27
121150
Pepperdine University
2013
Fall 2013
9721
3400
6321
3630
1472
2158
784
309
475
37
43
Fall 2013
560
660
570
680
570
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
37
43
22
21
44902
5,000 - 9,999
California
3651
989
28
121309
Point Loma Nazarene University
2013
Fall 2013
3138
951
2187
2088
709
1379
647
226
421
67
75
Fall 2013
520
630
520
630
NaN
NaN
23
28
23
29
23
27
NaN
NaN
67
75
31
32
30356
1,000 - 4,999
California
2504
562
29
121345
Pomona College
2013
Fall 2013
7153
2802
4351
996
474
522
397
188
209
14
17
Fall 2013
690
760
690
780
690
780
31
34
31
35
30
34
NaN
NaN
14
17
40
40
43580
1,000 - 4,999
California
1627
380
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
322
232423
James Madison University
2013
Fall 2012
22648
9307
13341
14394
5388
9004
4325
1710
2615
64
58
Fall 2012
520
620
530
630
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
64
58
30
32
9176
20,000 and above
Virginia
20065
4047
323
232681
University of Mary Washington
2013
Fall 2013
4496
1544
2952
3640
1201
2439
947
315
632
81
78
Fall 2013
510
620
500
590
490
600
22
26
21
27
21
25
NaN
NaN
81
78
26
26
9720
1,000 - 4,999
Virginia
5048
1026
324
233374
University of Richmond
2013
Fall 2013
9825
4237
5588
3061
1378
1683
805
391
414
31
33
Fall 2013
590
690
620
720
600
690
28
31
NaN
NaN
NaN
NaN
NaN
NaN
31
33
26
28
45320
1,000 - 4,999
Virginia
3893
929
325
233921
Virginia Polytechnic Institute and State Unive...
2013
Fall 2013
19112
11417
7695
13432
7718
5714
5364
3008
2356
70
68
Fall 2013
540
640
580
680
540
640
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
70
68
40
39
11455
20,000 and above
Virginia
24786
5604
326
234030
Virginia Commonwealth University
2013
Fall 2013
14156
5749
8407
9786
3991
5795
3525
1450
2075
69
69
Fall 2013
500
610
500
600
490
590
21
26
20
26
20
26
NaN
NaN
69
69
36
36
12002
20,000 and above
Virginia
26677
4659
327
234076
University of Virginia-Main Campus
2013
Fall 2013
28984
13632
15352
8691
3908
4783
3520
1556
1964
30
29
Fall 2013
620
720
630
740
620
720
29
33
29
34
28
34
8
9
30
29
41
40
12668
20,000 and above
Virginia
18133
3738
328
234085
Virginia Military Institute
2013
Fall 2013
2012
1801
211
952
821
131
502
441
61
47
46
Fall 2013
520
620
530
630
490
600
22
27
21
27
23
27
NaN
NaN
47
46
53
54
14404
1,000 - 4,999
Virginia
1804
359
329
234207
Washington and Lee University
2013
Fall 2013
6222
3034
3188
1147
565
582
480
245
235
18
19
Fall 2013
650
740
660
720
650
730
30
33
31
34
28
30
NaN
NaN
18
19
42
43
44507
1,000 - 4,999
Virginia
1841
459
330
235167
The Evergreen State College
2013
Fall 2013
1583
664
919
1537
632
905
509
225
284
97
95
Fall 2013
500
630
450
580
460
590
20
27
20
28
17
24
6
8
97
95
33
36
8574
1,000 - 4,999
Washington
5189
1215
331
235316
Gonzaga University
2013
Fall 2012
6991
3162
3829
4650
2018
2632
1096
462
634
67
64
Fall 2012
540
640
550
650
NaN
NaN
25
29
NaN
NaN
NaN
NaN
NaN
NaN
67
64
24
23
35062
5,000 - 9,999
Washington
5122
1255
332
236328
University of Puget Sound
2013
Fall 2013
4588
2028
2560
3910
1653
2257
670
291
379
85
82
Fall 2013
570
670
550
660
550
670
25
30
25
31
24
29
8
9
85
82
17
18
41868
1,000 - 4,999
Washington
2684
641
333
236577
Seattle Pacific University
2013
Fall 2013
5165
1601
3564
3726
1123
2603
767
245
522
72
70
Fall 2013
520
630
510
610
500
620
23
28
22
29
23
27
NaN
NaN
72
70
21
22
33813
1,000 - 4,999
Washington
3523
775
334
236595
Seattle University
2013
Fall 2013
7160
2687
4473
5243
1957
3286
976
589
382
73
73
Fall 2013
520
640
530
630
520
630
24
29
23
29
23
29
7
9
73
73
19
30
36465
5,000 - 9,999
Washington
5010
1150
335
236948
University of Washington-Seattle Campus
2013
Fall 2013
30199
14047
16152
16679
7484
9195
6253
2970
3283
55
53
Fall 2013
520
650
580
710
530
640
25
30
24
31
25
31
8
9
55
53
37
40
12397
20,000 and above
Washington
32139
7651
336
237057
Whitman College
2013
Fall 2013
2586
1022
1564
1473
591
882
392
172
220
57
58
Fall 2013
610
730
610
693
608
700
28
32
NaN
NaN
NaN
NaN
NaN
NaN
57
58
27
29
43500
1,000 - 4,999
Washington
1630
365
337
238333
Beloit College
2013
Fall 2013
2253
1054
1199
1525
668
857
300
126
173
68
63
Fall 2013
550
710
540
660
NaN
NaN
24
30
24
32
23
28
NaN
NaN
68
63
20
19
41250
1,000 - 4,999
Wisconsin
1417
298
338
239105
Marquette University
2013
Fall 2013
23432
10865
12567
13462
6098
7364
1990
941
1049
57
56
Fall 2013
520
630
550
650
520
630
25
29
24
30
24
29
8
9
57
56
15
15
34640
10,000 - 19,999
Wisconsin
8562
1748
339
239318
Milwaukee School of Engineering
2013
Fall 2013
2167
1533
634
1482
1090
392
544
422
122
68
71
Fall 2013
540
640
590
680
NaN
NaN
25
30
22
28
26
30
NaN
NaN
68
71
37
39
34470
1,000 - 4,999
Wisconsin
2490
537
340
240444
University of Wisconsin-Madison
2013
Fall 2012
23324
11326
11998
15841
7264
8577
6279
2932
3347
68
64
Fall 2012
530
650
630
750
580
670
26
30
26
32
26
31
8
9
68
64
40
40
10403
20,000 and above
Wisconsin
33353
6661
341
243221
University of Puerto Rico-Rio Piedras
2013
Fall 2013
5391
2147
3244
2829
1139
1690
2236
856
1380
52
53
Fall 2013
543
644
533
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
52
53
79
75
2082
10,000 - 19,999
Puerto Rico
12623
1824
342
243744
Stanford University
2013
Fall 2013
38828
20464
18364
2208
1147
1061
1677
904
773
6
6
Fall 2013
680
780
700
790
690
780
31
34
32
35
31
35
NaN
NaN
6
6
76
79
43683
10,000 - 19,999
California
8249
1660
343
243780
Purdue University-Main Campus
2013
Fall 2013
31083
18258
12825
18779
10589
8190
6422
3659
2763
60
58
Fall 2013
520
630
560
690
520
630
24
30
23
31
25
32
NaN
NaN
60
58
34
35
9992
20,000 and above
Indiana
32874
7058
344
262129
New College of Florida
2013
Fall 2013
1376
508
868
834
310
524
222
88
134
61
61
Fall 2013
620
720
570
660
590
680
27
30
28
33
25
28
8
9
61
61
27
28
6866
Under 1,000
Florida
861
198
345
399911
Soka University of America
2013
Fall 2013
422
159
263
183
67
116
112
44
68
43
42
Fall 2013
500
640
580
700
540
630
25
29
25
31
24
28
NaN
NaN
43
42
61
66
29144
Under 1,000
California
436
119
346
440396
New Saint Andrews College
2013
Fall 2013
73
32
41
63
26
37
46
18
28
86
81
Fall 2013
560
670
480
620
550
670
22
27
23
28
17
24
NaN
NaN
86
81
73
69
11200
Under 1,000
Idaho
151
18
347
441982
Franklin W Olin College of Engineering
2013
Fall 2013
801
594
207
135
56
79
82
36
46
17
9
Fall 2013
690
760
738
790
670
780
31
34
30
35
31
36
8
10
17
9
61
64
45156
Under 1,000
Massachusetts
363
76
348
443410
DigiPen Institute of Technology
2013
Fall 2013
312
253
59
207
168
39
137
112
25
66
66
Fall 2013
540
668
553
670
520
610
25
30
23
30
24
29
NaN
NaN
66
66
66
67
26720
1,000 - 4,999
Washington
1121
105
349
451671
University of South Florida-Sarasota-Manatee
2013
Fall 2013
393
173
220
136
55
81
86
39
47
35
32
Fall 2013
502
580
490
570
490
570
22
25
21
25
21
25
7
8
35
32
63
71
5587
1,000 - 4,999
Florida
2275
556
350
454184
The King’s College
2013
Fall 2013
3033
1025
2008
2158
745
1413
127
42
85
71
73
Fall 2013
540
630
510
600
520
640
24
28
24
29
22
26
NaN
NaN
71
73
6
6
31300
Under 1,000
New York
583
75
351
456959
University of Minnesota-Rochester
2013
Fall 2013
570
159
411
309
86
223
155
42
113
54
54
Fall 2013
550
700
540
660
520
610
23
27
21
26
23
27
7
8
54
54
50
49
13056
Under 1,000
Minnesota
421
49
352 rows × 39 columns
In [31]:
colleges[0:3]
Out[31]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
0
100663
University of Alabama at Birmingham
2013
Fall 2013
5689
2214
3475
4934
1944
2990
1773
717
1056
87
88
Fall 2013
520
640
520
650
NaN
NaN
22
28
22
29
20
26
NaN
NaN
87
88
36
37
7206
10,000 - 19,999
Alabama
13108
2195
1
100706
University of Alabama in Huntsville
2013
Fall 2013
2054
1183
871
1656
975
681
651
396
255
81
82
Fall 2013
510
640
510
650
NaN
NaN
23
29
22
30
22
28
NaN
NaN
81
82
39
41
9192
5,000 - 9,999
Alabama
6695
1099
2
100858
Auburn University
2013
Fall 2013
15745
6912
8833
13027
5727
7300
3726
1791
1935
83
83
Fall 2013
520
620
540
650
510
620
24
30
24
32
23
28
6
8
83
83
29
31
9852
20,000 and above
Alabama
21091
4278
In [48]:
colleges.count()
Out[48]:
unitid 352
institution name 352
year 352
IC2013.Fall reporting period for applicant and admissions 352
IC2013.Applicants total 352
IC2013.Applicants men 348
IC2013.Applicants women 352
IC2013.Admissions total 352
IC2013.Admissions men 347
IC2013.Admissions women 352
IC2013.Enrolled total 352
IC2013.Enrolled men 347
IC2013.Enrolled women 352
DRVIC2013.Percent admitted - total 352
DRVIC2013.Percent admitted - men 342
IC2013.Fall reporting period for SAT/ACT test scores 352
IC2013.SAT Critical Reading 25th percentile score 352
IC2013.SAT Critical Reading 75th percentile score 352
IC2013.SAT Math 25th percentile score 352
IC2013.SAT Math 75th percentile score 352
IC2013.SAT Writing 25th percentile score 250
IC2013.SAT Writing 75th percentile score 250
IC2013.ACT Composite 25th percentile score 339
IC2013.ACT Composite 75th percentile score 339
IC2013.ACT English 25th percentile score 271
IC2013.ACT English 75th percentile score 271
IC2013.ACT Math 25th percentile score 271
IC2013.ACT Math 75th percentile score 271
IC2013.ACT Writing 25th percentile score 107
IC2013.ACT Writing 75th percentile score 107
DRVIC2013.Percent admitted - total.1 352
DRVIC2013.Percent admitted - men.1 342
DRVIC2013.Admissions yield - total 352
DRVIC2013.Admissions yield - men 342
DRVIC2013.Tuition and fees, 2013-14 352
HD2013.Institution size category 352
HD2013.State abbreviation 352
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13 352
DRVC2013.Bachelor's degree 352
dtype: int64
In [57]:
leastcompetitive = colleges[colleges['DRVIC2013.Percent admitted - men'] > 50]
leastcompetitive[:]
Out[57]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
0
100663
University of Alabama at Birmingham
2013
Fall 2013
5689
2214
3475
4934
1944
2990
1773
717
1056
87
88
Fall 2013
520
640
520
650
NaN
NaN
22
28
22
29
20
26
NaN
NaN
87
88
36
37
7206
10,000 - 19,999
Alabama
13108
2195
1
100706
University of Alabama in Huntsville
2013
Fall 2013
2054
1183
871
1656
975
681
651
396
255
81
82
Fall 2013
510
640
510
650
NaN
NaN
23
29
22
30
22
28
NaN
NaN
81
82
39
41
9192
5,000 - 9,999
Alabama
6695
1099
2
100858
Auburn University
2013
Fall 2013
15745
6912
8833
13027
5727
7300
3726
1791
1935
83
83
Fall 2013
520
620
540
650
510
620
24
30
24
32
23
28
6
8
83
83
29
31
9852
20,000 and above
Alabama
21091
4278
3
100937
Birmingham Southern College
2013
Fall 2013
1931
942
989
1240
639
601
356
202
154
64
68
Fall 2013
520
630
520
640
NaN
NaN
23
29
23
30
22
27
NaN
NaN
64
68
29
32
30690
1,000 - 4,999
Alabama
1256
301
5
102049
Samford University
2013
Fall 2013
3447
1276
2171
2653
937
1716
765
267
498
77
73
Fall 2013
500
630
510
610
500
610
23
28
23
30
21
27
NaN
NaN
77
73
29
28
26328
1,000 - 4,999
Alabama
3124
667
6
104151
Arizona State University-Tempe
2013
Fall 2013
21770
11822
9948
17465
9292
8173
7171
4019
3152
80
79
Fall 2013
500
620
520
650
NaN
NaN
22
28
21
28
23
28
NaN
NaN
80
79
41
43
9861
20,000 and above
Arizona
43072
9278
7
104586
Embry-Riddle Aeronautical University-Prescott
2013
Fall 2013
1689
1352
337
1334
1057
277
448
329
119
79
78
Fall 2013
500
630
540
650
490
600
23
29
21
30
24
29
NaN
NaN
79
78
34
31
31034
1,000 - 4,999
Arizona
1813
322
8
106397
University of Arkansas
2013
Fall 2013
18908
8464
10444
11076
4947
6129
4339
2051
2288
59
58
Fall 2013
500
600
520
630
NaN
NaN
23
28
22
29
23
27
NaN
NaN
59
58
39
41
7818
20,000 and above
Arkansas
22355
3347
9
107080
Hendrix College
2013
Fall 2013
1928
948
980
1550
728
822
436
213
223
80
77
Fall 2013
530
680
540
650
NaN
NaN
26
32
26
34
25
30
NaN
NaN
80
77
28
29
37816
1,000 - 4,999
Arkansas
1423
314
10
107141
John Brown University
2013
Fall 2013
1143
458
685
798
340
458
305
134
171
70
74
Fall 2013
500
640
505
640
490
610
22
28
22
30
21
27
6
8
70
74
38
39
22734
1,000 - 4,999
Arkansas
2269
466
11
110097
Biola University
2013
Fall 2013
4816
1699
3117
3509
1165
2344
903
322
581
73
69
Fall 2013
500
620
503
620
490
620
22
27
21
28
22
27
NaN
NaN
73
69
26
28
32142
5,000 - 9,999
California
4516
908
23
117946
Loyola Marymount University
2013
Fall 2013
11472
4438
7034
6209
2365
3844
1341
556
775
54
53
Fall 2013
540
640
550
650
550
650
25
29
24
31
24
28
8
9
54
53
22
24
40265
5,000 - 9,999
California
6529
1524
26
120883
University of the Pacific
2013
Fall 2013
14222
5499
8723
10332
4146
6186
958
452
506
73
75
Fall 2013
500
640
530
680
500
640
22
29
21
28
22
28
NaN
NaN
73
75
9
11
39810
5,000 - 9,999
California
4099
823
28
121309
Point Loma Nazarene University
2013
Fall 2013
3138
951
2187
2088
709
1379
647
226
421
67
75
Fall 2013
520
630
520
630
NaN
NaN
23
28
23
29
23
27
NaN
NaN
67
75
31
32
30356
1,000 - 4,999
California
2504
562
30
121691
University of Redlands
2013
Fall 2013
4668
2018
2650
3137
1324
1813
673
297
376
67
66
Fall 2013
510
610
520
620
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
67
66
21
22
41290
5,000 - 9,999
California
3939
736
32
122612
University of San Francisco
2013
Fall 2013
14808
5189
9619
9076
3172
5904
1148
415
733
61
61
Fall 2013
530
630
540
640
530
630
23
27
23
29
24
27
8
9
61
61
13
13
40294
10,000 - 19,999
California
7118
1388
33
122931
Santa Clara University
2013
Fall 2012
14339
6602
7737
7344
3389
3955
1278
680
598
51
51
Fall 2012
590
680
610
700
NaN
NaN
27
31
NaN
NaN
NaN
NaN
NaN
NaN
51
51
17
20
42156
5,000 - 9,999
California
5596
1155
35
123554
Saint Mary's College of California
2013
Fall 2013
4864
1759
3105
3379
1259
2120
622
255
367
69
72
Fall 2013
500
600
510
610
510
610
22
27
22
27
22
27
7
8
69
72
18
20
39890
1,000 - 4,999
California
3221
636
37
124292
Thomas Aquinas College
2013
Fall 2013
178
80
98
141
63
78
88
44
44
79
79
Fall 2013
590
700
570
640
570
690
23
31
26
33
24
32
6
8
79
79
62
70
24500
Under 1,000
California
376
91
38
125727
Westmont College
2013
Fall 2013
2145
747
1398
1505
531
974
298
115
183
70
71
Fall 2013
520
650
540
660
520
650
24
29
23
31
24
29
NaN
NaN
70
71
20
22
38510
1,000 - 4,999
California
1397
311
39
126614
University of Colorado Boulder
2013
Fall 2013
22473
11995
10478
19710
10302
9408
5846
3159
2687
88
86
Fall 2013
520
630
540
650
NaN
NaN
24
29
23
30
23
29
NaN
NaN
88
86
30
31
10347
20,000 and above
Colorado
29290
5752
42
126818
Colorado State University-Fort Collins
2013
Fall 2013
17970
8218
9752
13914
6022
7892
4443
2016
2427
77
73
Fall 2013
510
620
510
630
NaN
NaN
22
27
22
28
22
27
NaN
NaN
77
73
32
33
9313
20,000 and above
Colorado
25594
4736
43
127060
University of Denver
2013
Fall 2013
13735
6381
7354
10539
4690
5849
1413
669
744
77
73
Fall 2013
540
660
560
660
520
630
25
30
25
31
24
29
8
9
77
73
13
14
40707
10,000 - 19,999
Colorado
5836
1223
45
129020
University of Connecticut
2013
Fall 2013
27479
12937
14542
14745
6902
7843
3755
1866
1889
54
53
Fall 2013
550
650
580
680
NaN
NaN
25
30
NaN
NaN
NaN
NaN
NaN
NaN
54
53
25
27
12022
20,000 and above
Connecticut
18920
4867
50
130943
University of Delaware
2013
Fall 2013
25458
10767
14691
16467
6543
9924
4224
1746
2478
65
61
Fall 2013
520
630
540
650
520
630
24
29
23
29
24
29
8
9
65
61
26
27
12112
20,000 and above
Delaware
19299
3741
52
131283
Catholic University of America
2013
Fall 2013
6298
2822
3476
3783
1751
2032
837
401
436
60
62
Fall 2013
500
610
510
610
NaN
NaN
22
27
NaN
NaN
NaN
NaN
NaN
NaN
60
62
22
23
38526
5,000 - 9,999
District of Columbia
3837
733
56
133492
Eckerd College
2013
Fall 2012
3912
1478
2434
2779
977
1802
534
218
316
71
66
Fall 2012
510
620
500
610
NaN
NaN
23
28
22
27
22
29
NaN
NaN
71
66
19
22
37362
1,000 - 4,999
Florida
2653
522
57
133711
Flagler College-St Augustine
2013
Fall 2013
5396
2255
3141
2691
1202
1489
708
287
421
50
53
Fall 2013
540
580
530
580
520
570
21
25
21
26
21
25
NaN
NaN
50
53
26
24
16180
1,000 - 4,999
Florida
2959
644
58
133881
Florida Institute of Technology
2013
Fall 2013
7820
5570
2250
4727
3387
1340
783
573
210
60
61
Fall 2013
500
610
530
650
NaN
NaN
23
28
21
28
23
29
NaN
NaN
60
61
17
17
36020
5,000 - 9,999
Florida
3122
533
60
134097
Florida State University
2013
Fall 2013
29579
12131
17448
16803
6793
10010
6048
2482
3566
57
56
Fall 2013
560
640
550
640
560
640
25
29
NaN
NaN
NaN
NaN
NaN
NaN
57
56
36
37
6507
20,000 and above
Florida
36086
7938
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
310
229267
Trinity University
2013
Fall 2013
4505
2120
2385
2880
1317
1563
534
259
275
64
62
Fall 2013
560
690
590
680
NaN
NaN
26
31
26
32
25
30
NaN
NaN
64
62
19
20
34678
1,000 - 4,999
Texas
2379
572
312
230807
Westminster College
2013
Fall 2013
2461
1057
1404
1850
794
1056
449
211
238
75
75
Fall 2013
500
610
500
610
NaN
NaN
22
28
21
28
21
27
NaN
NaN
75
75
24
27
29500
1,000 - 4,999
Utah
2710
506
313
230852
Champlain College
2013
Fall 2013
5047
2386
2661
3573
1682
1891
594
361
233
71
70
Fall 2013
500
620
490
620
490
600
22
28
21
31
21
26
NaN
NaN
71
70
17
21
31350
1,000 - 4,999
Vermont
3248
506
315
231059
Saint Michael's College
2013
Fall 2013
4431
2155
2276
3328
1527
1801
512
228
284
75
71
Fall 2013
530
650
530
640
530
630
23
28
22
29
23
27
NaN
NaN
75
71
15
15
39015
1,000 - 4,999
Vermont
2120
408
316
231174
University of Vermont
2013
Fall 2013
22381
9745
12636
17357
7095
10262
2495
1087
1408
78
73
Fall 2013
540
640
540
650
540
650
24
29
23
30
24
28
8
9
78
73
14
15
15718
10,000 - 19,999
Vermont
13140
2566
318
231651
Regent University
2013
Fall 2013
1238
415
823
1054
348
706
231
87
144
85
84
Fall 2013
500
630
460
570
NaN
NaN
19
25
20
26
17
24
NaN
NaN
85
84
22
25
15838
5,000 - 9,999
Virginia
2631
382
319
231712
Christopher Newport University
2013
Fall 2013
7016
2944
4072
4141
1599
2542
1276
545
731
59
54
Fall 2013
540
630
530
620
NaN
NaN
23
28
NaN
NaN
NaN
NaN
NaN
NaN
59
54
31
34
11092
5,000 - 9,999
Virginia
5121
1057
320
232186
George Mason University
2013
Fall 2013
20805
9262
11543
12905
5562
7343
3011
1420
1591
62
60
Fall 2013
520
620
530
630
NaN
NaN
24
28
23
29
23
27
NaN
NaN
62
60
23
26
9908
20,000 and above
Virginia
30850
4920
322
232423
James Madison University
2013
Fall 2012
22648
9307
13341
14394
5388
9004
4325
1710
2615
64
58
Fall 2012
520
620
530
630
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
64
58
30
32
9176
20,000 and above
Virginia
20065
4047
323
232681
University of Mary Washington
2013
Fall 2013
4496
1544
2952
3640
1201
2439
947
315
632
81
78
Fall 2013
510
620
500
590
490
600
22
26
21
27
21
25
NaN
NaN
81
78
26
26
9720
1,000 - 4,999
Virginia
5048
1026
325
233921
Virginia Polytechnic Institute and State Unive...
2013
Fall 2013
19112
11417
7695
13432
7718
5714
5364
3008
2356
70
68
Fall 2013
540
640
580
680
540
640
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
70
68
40
39
11455
20,000 and above
Virginia
24786
5604
326
234030
Virginia Commonwealth University
2013
Fall 2013
14156
5749
8407
9786
3991
5795
3525
1450
2075
69
69
Fall 2013
500
610
500
600
490
590
21
26
20
26
20
26
NaN
NaN
69
69
36
36
12002
20,000 and above
Virginia
26677
4659
330
235167
The Evergreen State College
2013
Fall 2013
1583
664
919
1537
632
905
509
225
284
97
95
Fall 2013
500
630
450
580
460
590
20
27
20
28
17
24
6
8
97
95
33
36
8574
1,000 - 4,999
Washington
5189
1215
331
235316
Gonzaga University
2013
Fall 2012
6991
3162
3829
4650
2018
2632
1096
462
634
67
64
Fall 2012
540
640
550
650
NaN
NaN
25
29
NaN
NaN
NaN
NaN
NaN
NaN
67
64
24
23
35062
5,000 - 9,999
Washington
5122
1255
332
236328
University of Puget Sound
2013
Fall 2013
4588
2028
2560
3910
1653
2257
670
291
379
85
82
Fall 2013
570
670
550
660
550
670
25
30
25
31
24
29
8
9
85
82
17
18
41868
1,000 - 4,999
Washington
2684
641
333
236577
Seattle Pacific University
2013
Fall 2013
5165
1601
3564
3726
1123
2603
767
245
522
72
70
Fall 2013
520
630
510
610
500
620
23
28
22
29
23
27
NaN
NaN
72
70
21
22
33813
1,000 - 4,999
Washington
3523
775
334
236595
Seattle University
2013
Fall 2013
7160
2687
4473
5243
1957
3286
976
589
382
73
73
Fall 2013
520
640
530
630
520
630
24
29
23
29
23
29
7
9
73
73
19
30
36465
5,000 - 9,999
Washington
5010
1150
335
236948
University of Washington-Seattle Campus
2013
Fall 2013
30199
14047
16152
16679
7484
9195
6253
2970
3283
55
53
Fall 2013
520
650
580
710
530
640
25
30
24
31
25
31
8
9
55
53
37
40
12397
20,000 and above
Washington
32139
7651
336
237057
Whitman College
2013
Fall 2013
2586
1022
1564
1473
591
882
392
172
220
57
58
Fall 2013
610
730
610
693
608
700
28
32
NaN
NaN
NaN
NaN
NaN
NaN
57
58
27
29
43500
1,000 - 4,999
Washington
1630
365
337
238333
Beloit College
2013
Fall 2013
2253
1054
1199
1525
668
857
300
126
173
68
63
Fall 2013
550
710
540
660
NaN
NaN
24
30
24
32
23
28
NaN
NaN
68
63
20
19
41250
1,000 - 4,999
Wisconsin
1417
298
338
239105
Marquette University
2013
Fall 2013
23432
10865
12567
13462
6098
7364
1990
941
1049
57
56
Fall 2013
520
630
550
650
520
630
25
29
24
30
24
29
8
9
57
56
15
15
34640
10,000 - 19,999
Wisconsin
8562
1748
339
239318
Milwaukee School of Engineering
2013
Fall 2013
2167
1533
634
1482
1090
392
544
422
122
68
71
Fall 2013
540
640
590
680
NaN
NaN
25
30
22
28
26
30
NaN
NaN
68
71
37
39
34470
1,000 - 4,999
Wisconsin
2490
537
340
240444
University of Wisconsin-Madison
2013
Fall 2012
23324
11326
11998
15841
7264
8577
6279
2932
3347
68
64
Fall 2012
530
650
630
750
580
670
26
30
26
32
26
31
8
9
68
64
40
40
10403
20,000 and above
Wisconsin
33353
6661
341
243221
University of Puerto Rico-Rio Piedras
2013
Fall 2013
5391
2147
3244
2829
1139
1690
2236
856
1380
52
53
Fall 2013
543
644
533
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
52
53
79
75
2082
10,000 - 19,999
Puerto Rico
12623
1824
343
243780
Purdue University-Main Campus
2013
Fall 2013
31083
18258
12825
18779
10589
8190
6422
3659
2763
60
58
Fall 2013
520
630
560
690
520
630
24
30
23
31
25
32
NaN
NaN
60
58
34
35
9992
20,000 and above
Indiana
32874
7058
344
262129
New College of Florida
2013
Fall 2013
1376
508
868
834
310
524
222
88
134
61
61
Fall 2013
620
720
570
660
590
680
27
30
28
33
25
28
8
9
61
61
27
28
6866
Under 1,000
Florida
861
198
346
440396
New Saint Andrews College
2013
Fall 2013
73
32
41
63
26
37
46
18
28
86
81
Fall 2013
560
670
480
620
550
670
22
27
23
28
17
24
NaN
NaN
86
81
73
69
11200
Under 1,000
Idaho
151
18
348
443410
DigiPen Institute of Technology
2013
Fall 2013
312
253
59
207
168
39
137
112
25
66
66
Fall 2013
540
668
553
670
520
610
25
30
23
30
24
29
NaN
NaN
66
66
66
67
26720
1,000 - 4,999
Washington
1121
105
350
454184
The King’s College
2013
Fall 2013
3033
1025
2008
2158
745
1413
127
42
85
71
73
Fall 2013
540
630
510
600
520
640
24
28
24
29
22
26
NaN
NaN
71
73
6
6
31300
Under 1,000
New York
583
75
351
456959
University of Minnesota-Rochester
2013
Fall 2013
570
159
411
309
86
223
155
42
113
54
54
Fall 2013
550
700
540
660
520
610
23
27
21
26
23
27
7
8
54
54
50
49
13056
Under 1,000
Minnesota
421
49
204 rows × 39 columns
In [58]:
leastcompetitive.count()
Out[58]:
unitid 204
institution name 204
year 204
IC2013.Fall reporting period for applicant and admissions 204
IC2013.Applicants total 204
IC2013.Applicants men 204
IC2013.Applicants women 204
IC2013.Admissions total 204
IC2013.Admissions men 204
IC2013.Admissions women 204
IC2013.Enrolled total 204
IC2013.Enrolled men 204
IC2013.Enrolled women 204
DRVIC2013.Percent admitted - total 204
DRVIC2013.Percent admitted - men 204
IC2013.Fall reporting period for SAT/ACT test scores 204
IC2013.SAT Critical Reading 25th percentile score 204
IC2013.SAT Critical Reading 75th percentile score 204
IC2013.SAT Math 25th percentile score 204
IC2013.SAT Math 75th percentile score 204
IC2013.SAT Writing 25th percentile score 131
IC2013.SAT Writing 75th percentile score 131
IC2013.ACT Composite 25th percentile score 199
IC2013.ACT Composite 75th percentile score 199
IC2013.ACT English 25th percentile score 165
IC2013.ACT English 75th percentile score 165
IC2013.ACT Math 25th percentile score 165
IC2013.ACT Math 75th percentile score 165
IC2013.ACT Writing 25th percentile score 54
IC2013.ACT Writing 75th percentile score 54
DRVIC2013.Percent admitted - total.1 204
DRVIC2013.Percent admitted - men.1 204
DRVIC2013.Admissions yield - total 204
DRVIC2013.Admissions yield - men 204
DRVIC2013.Tuition and fees, 2013-14 204
HD2013.Institution size category 204
HD2013.State abbreviation 204
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13 204
DRVC2013.Bachelor's degree 204
dtype: int64
In [59]:
morecompetitive = colleges[colleges['DRVIC2013.Percent admitted - men'] <= 50]
morecompetitive[:]
Out[59]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
12
110404
California Institute of Technology
2013
Fall 2013
5535
4109
1426
584
344
240
249
161
88
11
8
Fall 2013
720
800
770
800
720
790
33
35
33
35
34
36
8
10
11
8
43
47
41538
1,000 - 4,999
California
1021
256
13
110413
California Lutheran University
2013
Fall 2013
6920
3138
3782
3323
1470
1853
540
247
293
48
47
Fall 2013
500
590
510
613
NaN
NaN
22
26
22
27
22
27
NaN
NaN
48
47
16
17
35720
1,000 - 4,999
California
3178
721
14
110422
California Polytechnic State University-San Lu...
2013
Fall 2012
36941
19855
17086
11537
5746
5791
3635
2001
1634
31
29
Fall 2012
550
650
590
690
NaN
NaN
25
30
24
31
26
31
NaN
NaN
31
29
32
35
8724
10,000 - 19,999
California
18052
3300
15
110635
University of California-Berkeley
2013
Fall 2012
61717
30715
31002
11108
5233
5875
4162
2036
2126
18
17
Fall 2012
590
720
630
770
620
750
27
33
26
34
27
34
NaN
NaN
18
17
37
39
12864
20,000 and above
California
28662
7775
16
110644
University of California-Davis
2013
Fall 2012
49820
23010
26810
22526
9532
12994
5208
2066
3142
45
41
Fall 2012
510
640
560
680
530
650
23
29
22
30
24
30
NaN
NaN
45
41
23
22
13895
20,000 and above
California
27829
7015
17
110662
University of California-Los Angeles
2013
Fall 2012
72676
33663
39013
15981
7177
8804
5620
2417
3203
22
21
Fall 2012
560
680
600
760
590
710
25
31
24
32
25
33
NaN
NaN
22
21
35
34
12697
20,000 and above
California
30180
7329
18
110680
University of California-San Diego
2013
Fall 2012
60832
28725
32107
22812
10815
11997
4575
2329
2246
38
38
Fall 2012
550
660
620
730
580
690
25
31
24
31
26
33
NaN
NaN
38
38
20
22
13271
20,000 and above
California
24443
6344
19
110705
University of California-Santa Barbara
2013
Fall 2012
55258
24909
30349
24556
10850
13706
4741
2189
2552
44
44
Fall 2012
530
650
560
690
550
660
24
29
23
30
24
30
NaN
NaN
44
44
19
20
13746
20,000 and above
California
20557
5222
20
111948
Chapman University
2013
Fall 2013
11750
4398
7352
5253
1973
3280
1289
484
805
45
45
Fall 2013
550
640
570
660
560
650
24
29
24
31
24
29
8
9
45
45
25
25
43573
5,000 - 9,999
California
6173
1300
21
112260
Claremont McKenna College
2013
Fall 2013
5518
2526
2992
647
304
343
337
165
172
12
12
Fall 2013
650
740
670
760
660
750
29
33
29
34
29
34
NaN
NaN
12
12
52
54
45625
1,000 - 4,999
California
1319
289
22
115409
Harvey Mudd College
2013
Fall 2013
3539
2498
1041
643
313
330
217
114
103
18
13
Fall 2013
680
760
720
800
670
760
32
35
31
35
33
36
8
9
18
13
34
36
46509
Under 1,000
California
788
189
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
27
121150
Pepperdine University
2013
Fall 2013
9721
3400
6321
3630
1472
2158
784
309
475
37
43
Fall 2013
560
660
570
680
570
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
37
43
22
21
44902
5,000 - 9,999
California
3651
989
29
121345
Pomona College
2013
Fall 2013
7153
2802
4351
996
474
522
397
188
209
14
17
Fall 2013
690
760
690
780
690
780
31
34
31
35
30
34
NaN
NaN
14
17
40
40
43580
1,000 - 4,999
California
1627
380
31
122436
University of San Diego
2013
Fall 2013
14693
5850
8843
7178
2672
4506
1238
493
745
49
46
Fall 2013
540
650
570
670
NaN
NaN
25
30
25
31
25
30
NaN
NaN
49
46
17
18
41392
5,000 - 9,999
California
5905
1336
36
123961
University of Southern California
2013
Fall 2013
47358
22324
25034
9395
4416
4979
2922
1420
1502
20
20
Fall 2013
620
720
660
760
640
750
29
33
28
34
29
34
NaN
NaN
20
20
31
32
46298
20,000 and above
California
19533
4740
40
126678
Colorado College
2013
Fall 2013
5780
2566
3182
1288
531
757
522
224
298
22
21
Fall 2013
610
710
610
720
620
700
27
32
28
34
26
31
8
10
22
21
41
42
44222
1,000 - 4,999
Colorado
2289
522
41
126775
Colorado School of Mines
2013
Fall 2012
11682
8401
3281
4373
2971
1402
949
679
270
37
35
Fall 2012
570
670
630
720
550
650
27
31
25
31
27
32
NaN
NaN
37
35
22
23
16485
5,000 - 9,999
Colorado
4333
814
44
128328
United States Air Force Academy
2013
Fall 2013
9634
7329
2305
1486
1125
361
1154
887
267
15
15
Fall 2013
590
690
620
710
NaN
NaN
29
32
27
33
28
33
NaN
NaN
15
15
78
79
0
1,000 - 4,999
Colorado
4121
1033
46
130590
Trinity College
2013
Fall 2013
7652
3667
3985
2432
1198
1234
604
317
287
32
33
Fall 2013
570
680
580
670
590
673
25
29
25
29
25
30
NaN
NaN
32
33
25
26
47510
1,000 - 4,999
Connecticut
2455
540
47
130624
United States Coast Guard Academy
2013
Fall 2013
1992
1575
417
328
213
115
234
150
84
16
14
Fall 2013
570
670
620
690
560
650
25
30
24
30
26
31
7
8
16
14
71
70
0
Under 1,000
Connecticut
967
230
48
130697
Wesleyan University
2013
Fall 2012
10046
3993
6053
2102
911
1191
752
349
403
21
23
Fall 2012
640
740
660
740
650
750
29
33
30
34
28
33
8
10
21
23
36
38
47244
1,000 - 4,999
Connecticut
3154
785
49
130794
Yale University
2013
Fall 2012
28977
13641
15336
2043
1079
964
1356
689
667
7
8
Fall 2012
700
800
710
790
710
800
32
35
NaN
NaN
NaN
NaN
NaN
NaN
7
8
66
64
44000
10,000 - 19,999
Connecticut
6380
1308
51
131159
American University
2013
Fall 2013
17545
6580
10965
7566
2473
5093
1627
556
1071
43
38
Fall 2013
590
690
570
660
580
680
26
30
26
33
24
28
8
10
43
38
22
22
40649
10,000 - 19,999
District of Columbia
7872
1776
53
131469
George Washington University
2013
Fall 2012
21756
8895
12861
7197
3187
4010
2387
1076
1311
33
36
Fall 2012
600
690
600
700
610
700
27
31
27
33
26
31
8
9
33
36
33
34
47343
20,000 and above
District of Columbia
11172
2454
54
131496
Georgetown University
2013
Fall 2012
20115
8259
11856
3413
1547
1866
1570
725
845
17
19
Fall 2012
650
750
660
750
NaN
NaN
29
33
NaN
NaN
NaN
NaN
NaN
NaN
17
19
46
47
44805
10,000 - 19,999
District of Columbia
9557
1836
55
132903
University of Central Florida
2013
Fall 2013
31820
13315
18505
15572
6711
8861
6068
2729
3339
49
50
Fall 2013
540
630
550
640
510
610
23
28
NaN
NaN
NaN
NaN
NaN
NaN
49
50
39
41
6317
20,000 and above
Florida
59332
12320
59
133951
Florida International University
2013
Fall 2013
16549
6933
9616
7122
3076
4046
2990
1398
1592
43
44
Fall 2013
540
620
530
610
520
600
24
27
23
27
23
27
NaN
NaN
43
44
42
45
6496
20,000 and above
Florida
51334
7746
61
134130
University of Florida
2013
Fall 2013
27107
11745
15362
12618
5232
7386
6373
2658
3715
47
45
Fall 2013
580
670
590
690
570
680
26
31
25
32
25
30
8
9
47
45
51
51
6263
20,000 and above
Florida
35895
8244
62
135726
University of Miami
2013
Fall 2013
28907
13495
15407
11691
5586
6105
2140
1039
1101
40
41
Fall 2013
600
700
630
720
590
690
28
32
29
34
27
33
NaN
NaN
40
41
18
19
42852
10,000 - 19,999
Florida
12235
2451
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
260
212674
Gettysburg College
2013
Fall 2013
5453
2623
2830
2270
1034
1236
703
337
366
42
39
Fall 2013
600
690
600
680
NaN
NaN
27
29
NaN
NaN
NaN
NaN
NaN
NaN
42
39
31
33
45870
1,000 - 4,999
Pennsylvania
2791
639
262
212911
Haverford College
2013
Fall 2013
3585
1657
1928
842
376
466
330
157
173
23
23
Fall 2013
660
750
650
740
660
750
30
33
30
34
29
34
NaN
NaN
23
23
39
42
45426
1,000 - 4,999
Pennsylvania
1264
299
263
213385
Lafayette College
2013
Fall 2013
6766
3651
3115
2310
1160
1150
635
329
306
34
32
Fall 2013
570
670
610
700
580
690
27
31
26
32
27
32
8
9
34
32
27
28
44670
1,000 - 4,999
Pennsylvania
2529
589
264
213543
Lehigh University
2013
Fall 2013
12589
7144
5445
3882
2117
1765
1198
680
518
31
30
Fall 2013
580
670
640
740
NaN
NaN
28
32
NaN
NaN
NaN
NaN
NaN
NaN
31
30
31
32
43520
5,000 - 9,999
Pennsylvania
4965
1177
266
214175
Muhlenberg College
2013
Fall 2013
5152
2028
3124
2378
847
1531
579
215
364
46
42
Fall 2013
570
670
570
670
570
670
25
31
NaN
NaN
NaN
NaN
NaN
NaN
46
42
24
25
42755
1,000 - 4,999
Pennsylvania
2732
593
268
215062
University of Pennsylvania
2013
Fall 2013
31282
16005
15277
3830
1850
1980
2421
1187
1234
12
12
Fall 2013
670
760
690
780
690
780
30
34
31
35
30
35
8
10
12
12
63
64
45890
20,000 and above
Pennsylvania
13158
2848
274
216287
Swarthmore College
2013
Fall 2013
6615
2742
3873
947
459
488
388
194
194
14
17
Fall 2013
680
760
670
770
680
770
31
34
32
35
29
34
8
10
14
17
41
42
44718
1,000 - 4,999
Pennsylvania
1577
381
277
216597
Villanova University
2013
Fall 2013
14966
7228
7738
7319
3503
3816
1659
793
866
49
48
Fall 2013
590
690
620
710
600
690
29
31
29
33
27
32
NaN
NaN
49
48
23
23
44430
10,000 - 19,999
Pennsylvania
7771
1787
278
216764
West Chester University of Pennsylvania
2013
Fall 2013
13424
4855
8569
6922
2433
4489
2298
812
1486
52
50
Fall 2013
500
590
520
600
490
590
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
52
50
33
33
8850
10,000 - 19,999
Pennsylvania
15017
2760
279
217156
Brown University
2013
Fall 2013
28919
11664
17255
2654
1328
1326
1543
754
789
9
11
Fall 2013
660
760
670
780
670
770
29
34
29
35
28
34
NaN
NaN
9
11
58
57
45612
5,000 - 9,999
Rhode Island
6936
1554
282
217493
Rhode Island School of Design
2013
Fall 2013
3215
904
2311
878
277
601
455
143
312
27
31
Fall 2013
530
670
560
710
550
690
24
32
23
33
24
31
NaN
NaN
27
31
52
52
42932
1,000 - 4,999
Rhode Island
2059
481
291
219976
Lipscomb University
2013
Fall 2013
3467
1285
2182
1827
643
1184
684
257
427
53
50
Fall 2013
520
650
510
650
NaN
NaN
22
28
23
31
22
27
NaN
NaN
53
50
37
40
26094
1,000 - 4,999
Tennessee
3340
525
292
220808
Memphis College of Art
2013
Fall 2013
983
338
645
391
129
262
141
40
101
40
38
Fall 2013
500
620
410
530
NaN
NaN
19
25
19
26
16
23
NaN
NaN
40
38
36
31
27500
Under 1,000
Tennessee
374
71
297
221999
Vanderbilt University
2013
Fall 2013
31099
13699
17400
3963
2054
1909
1613
784
829
13
15
Fall 2013
700
780
710
790
680
770
32
34
32
35
30
35
8
10
13
15
41
38
42978
10,000 - 19,999
Tennessee
6928
1675
301
226231
LeTourneau University
2013
Fall 2013
1810
1006
804
736
482
254
335
216
119
41
48
Fall 2013
500
640
530
660
NaN
NaN
22
30
21
29
23
28
NaN
NaN
41
48
46
45
25740
1,000 - 4,999
Texas
3337
557
302
227757
Rice University
2013
Fall 2013
15415
7937
7478
2581
1312
1269
978
511
467
17
17
Fall 2013
670
760
700
790
670
770
31
34
31
35
30
35
8
9
17
17
38
39
38941
5,000 - 9,999
Texas
4139
964
305
228343
Southwestern University
2013
Fall 2013
3546
1549
1997
1850
743
1107
491
226
265
52
48
Fall 2013
520
640
540
640
NaN
NaN
22
29
22
29
23
27
NaN
NaN
52
48
27
30
35240
1,000 - 4,999
Texas
1455
338
307
228778
The University of Texas at Austin
2013
Fall 2013
38161
18361
19800
15335
6780
8555
7249
3190
4059
40
37
Fall 2013
550
670
590
710
550
680
25
31
25
33
26
32
7
9
40
37
47
47
9798
20,000 and above
Texas
42933
9154
309
228875
Texas Christian University
2013
Fall 2013
18551
7299
11252
8791
3202
5589
1936
728
1208
47
44
Fall 2013
540
620
550
650
540
640
25
29
NaN
NaN
NaN
NaN
NaN
NaN
47
44
22
23
36590
5,000 - 9,999
Texas
8848
1841
311
230038
Brigham Young University-Provo
2013
Fall 2013
11423
4026
7397
5645
1777
3868
4427
1345
3082
49
44
Fall 2013
570
680
580
680
NaN
NaN
26
31
26
33
25
30
NaN
NaN
49
44
78
76
4850
20,000 and above
Utah
37615
6619
314
230959
Middlebury College
2013
Fall 2012
8847
3704
5143
1518
735
783
598
294
304
17
20
Fall 2012
630
740
640
740
650
750
31
33
NaN
NaN
NaN
NaN
NaN
NaN
17
20
39
40
45314
1,000 - 4,999
Vermont
3728
656
317
231624
College of William and Mary
2013
Fall 2013
14046
5150
8896
4665
2101
2564
1479
652
827
33
41
Fall 2013
640
740
630
720
620
720
28
32
28
34
27
32
8
9
33
41
32
31
15463
5,000 - 9,999
Virginia
6702
1517
324
233374
University of Richmond
2013
Fall 2013
9825
4237
5588
3061
1378
1683
805
391
414
31
33
Fall 2013
590
690
620
720
600
690
28
31
NaN
NaN
NaN
NaN
NaN
NaN
31
33
26
28
45320
1,000 - 4,999
Virginia
3893
929
327
234076
University of Virginia-Main Campus
2013
Fall 2013
28984
13632
15352
8691
3908
4783
3520
1556
1964
30
29
Fall 2013
620
720
630
740
620
720
29
33
29
34
28
34
8
9
30
29
41
40
12668
20,000 and above
Virginia
18133
3738
328
234085
Virginia Military Institute
2013
Fall 2013
2012
1801
211
952
821
131
502
441
61
47
46
Fall 2013
520
620
530
630
490
600
22
27
21
27
23
27
NaN
NaN
47
46
53
54
14404
1,000 - 4,999
Virginia
1804
359
329
234207
Washington and Lee University
2013
Fall 2013
6222
3034
3188
1147
565
582
480
245
235
18
19
Fall 2013
650
740
660
720
650
730
30
33
31
34
28
30
NaN
NaN
18
19
42
43
44507
1,000 - 4,999
Virginia
1841
459
342
243744
Stanford University
2013
Fall 2013
38828
20464
18364
2208
1147
1061
1677
904
773
6
6
Fall 2013
680
780
700
790
690
780
31
34
32
35
31
35
NaN
NaN
6
6
76
79
43683
10,000 - 19,999
California
8249
1660
345
399911
Soka University of America
2013
Fall 2013
422
159
263
183
67
116
112
44
68
43
42
Fall 2013
500
640
580
700
540
630
25
29
25
31
24
28
NaN
NaN
43
42
61
66
29144
Under 1,000
California
436
119
347
441982
Franklin W Olin College of Engineering
2013
Fall 2013
801
594
207
135
56
79
82
36
46
17
9
Fall 2013
690
760
738
790
670
780
31
34
30
35
31
36
8
10
17
9
61
64
45156
Under 1,000
Massachusetts
363
76
349
451671
University of South Florida-Sarasota-Manatee
2013
Fall 2013
393
173
220
136
55
81
86
39
47
35
32
Fall 2013
502
580
490
570
490
570
22
25
21
25
21
25
7
8
35
32
63
71
5587
1,000 - 4,999
Florida
2275
556
138 rows × 39 columns
In [61]:
morecompetitive.count()
Out[61]:
unitid 138
institution name 138
year 138
IC2013.Fall reporting period for applicant and admissions 138
IC2013.Applicants total 138
IC2013.Applicants men 138
IC2013.Applicants women 138
IC2013.Admissions total 138
IC2013.Admissions men 138
IC2013.Admissions women 138
IC2013.Enrolled total 138
IC2013.Enrolled men 138
IC2013.Enrolled women 138
DRVIC2013.Percent admitted - total 138
DRVIC2013.Percent admitted - men 138
IC2013.Fall reporting period for SAT/ACT test scores 138
IC2013.SAT Critical Reading 25th percentile score 138
IC2013.SAT Critical Reading 75th percentile score 138
IC2013.SAT Math 25th percentile score 138
IC2013.SAT Math 75th percentile score 138
IC2013.SAT Writing 25th percentile score 111
IC2013.SAT Writing 75th percentile score 111
IC2013.ACT Composite 25th percentile score 130
IC2013.ACT Composite 75th percentile score 130
IC2013.ACT English 25th percentile score 99
IC2013.ACT English 75th percentile score 99
IC2013.ACT Math 25th percentile score 99
IC2013.ACT Math 75th percentile score 99
IC2013.ACT Writing 25th percentile score 51
IC2013.ACT Writing 75th percentile score 51
DRVIC2013.Percent admitted - total.1 138
DRVIC2013.Percent admitted - men.1 138
DRVIC2013.Admissions yield - total 138
DRVIC2013.Admissions yield - men 138
DRVIC2013.Tuition and fees, 2013-14 138
HD2013.Institution size category 138
HD2013.State abbreviation 138
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13 138
DRVC2013.Bachelor's degree 138
dtype: int64
In [63]:
crazycompetitive = colleges[colleges['DRVIC2013.Percent admitted - men'] <= 10]
crazycompetitive[:]
Out[63]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
12
110404
California Institute of Technology
2013
Fall 2013
5535
4109
1426
584
344
240
249
161
88
11
8
Fall 2013
720
800
770
800
720
790
33
35
33
35
34
36
8
10
11
8
43
47
41538
1,000 - 4,999
California
1021
256
49
130794
Yale University
2013
Fall 2012
28977
13641
15336
2043
1079
964
1356
689
667
7
8
Fall 2012
700
800
710
790
710
800
32
35
NaN
NaN
NaN
NaN
NaN
NaN
7
8
66
64
44000
10,000 - 19,999
Connecticut
6380
1308
80
144050
University of Chicago
2013
Fall 2013
30304
14339
15965
2670
1392
1278
1426
781
645
9
10
Fall 2013
720
800
720
790
700
780
32
35
33
35
31
35
8
10
9
10
53
56
47514
10,000 - 19,999
Illinois
5710
1278
121
164155
United States Naval Academy
2013
Fall 2013
19146
14710
4436
1408
1075
333
1200
927
273
7
7
Fall 2013
570
680
610
700
NaN
NaN
NaN
NaN
25
32
26
32
NaN
NaN
7
7
85
86
0
1,000 - 4,999
Maryland
4554
1058
133
166027
Harvard University
2013
Fall 2013
35023
18327
16696
2047
1092
955
1659
869
790
6
6
Fall 2013
700
800
710
800
710
800
32
35
33
35
31
35
8
10
6
6
81
80
42292
20,000 and above
Massachusetts
14666
1803
137
166683
Massachusetts Institute of Technology
2013
Fall 2013
18989
13380
5609
1548
808
740
1115
609
506
8
6
Fall 2013
680
770
750
800
690
780
33
35
33
35
34
36
8
10
8
6
72
75
43498
10,000 - 19,999
Massachusetts
4572
1042
174
182670
Dartmouth College
2013
Fall 2012
23110
11229
11881
2260
1153
1107
1098
552
546
10
10
Fall 2012
670
780
680
780
680
790
30
34
NaN
NaN
NaN
NaN
NaN
NaN
10
10
49
48
46752
5,000 - 9,999
New Hampshire
4646
1058
176
186131
Princeton University
2013
Fall 2013
26499
13982
12517
1963
987
976
1285
655
630
7
7
Fall 2013
700
800
710
800
710
790
31
35
32
35
30
35
8
10
7
7
65
66
40170
5,000 - 9,999
New Jersey
5341
1271
187
190150
Columbia University in the City of New York
2013
Fall 2012
31851
14686
17165
2362
1221
1141
1415
718
697
7
8
Fall 2012
690
780
700
790
690
780
31
34
32
35
29
35
8
10
7
8
60
59
49138
20,000 and above
New York
8074
2121
188
190372
Cooper Union for the Advancement of Science an...
2013
Fall 2013
3193
1688
1505
247
154
93
186
118
68
8
9
Fall 2013
610
710
610
780
610
730
29
33
NaN
NaN
NaN
NaN
NaN
NaN
8
9
75
77
41400
Under 1,000
New York
906
183
217
197036
United States Military Academy
2013
Fall 2013
15408
12283
3125
1380
1152
228
1176
991
185
9
9
Fall 2013
580
695
600
690
550
665
27
30
27
31
26
31
8
9
9
9
85
86
0
1,000 - 4,999
New York
4622
1054
342
243744
Stanford University
2013
Fall 2013
38828
20464
18364
2208
1147
1061
1677
904
773
6
6
Fall 2013
680
780
700
790
690
780
31
34
32
35
31
35
NaN
NaN
6
6
76
79
43683
10,000 - 19,999
California
8249
1660
347
441982
Franklin W Olin College of Engineering
2013
Fall 2013
801
594
207
135
56
79
82
36
46
17
9
Fall 2013
690
760
738
790
670
780
31
34
30
35
31
36
8
10
17
9
61
64
45156
Under 1,000
Massachusetts
363
76
In [64]:
crazycompetitive.count()
Out[64]:
unitid 13
institution name 13
year 13
IC2013.Fall reporting period for applicant and admissions 13
IC2013.Applicants total 13
IC2013.Applicants men 13
IC2013.Applicants women 13
IC2013.Admissions total 13
IC2013.Admissions men 13
IC2013.Admissions women 13
IC2013.Enrolled total 13
IC2013.Enrolled men 13
IC2013.Enrolled women 13
DRVIC2013.Percent admitted - total 13
DRVIC2013.Percent admitted - men 13
IC2013.Fall reporting period for SAT/ACT test scores 13
IC2013.SAT Critical Reading 25th percentile score 13
IC2013.SAT Critical Reading 75th percentile score 13
IC2013.SAT Math 25th percentile score 13
IC2013.SAT Math 75th percentile score 13
IC2013.SAT Writing 25th percentile score 12
IC2013.SAT Writing 75th percentile score 12
IC2013.ACT Composite 25th percentile score 12
IC2013.ACT Composite 75th percentile score 12
IC2013.ACT English 25th percentile score 10
IC2013.ACT English 75th percentile score 10
IC2013.ACT Math 25th percentile score 10
IC2013.ACT Math 75th percentile score 10
IC2013.ACT Writing 25th percentile score 8
IC2013.ACT Writing 75th percentile score 8
DRVIC2013.Percent admitted - total.1 13
DRVIC2013.Percent admitted - men.1 13
DRVIC2013.Admissions yield - total 13
DRVIC2013.Admissions yield - men 13
DRVIC2013.Tuition and fees, 2013-14 13
HD2013.Institution size category 13
HD2013.State abbreviation 13
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13 13
DRVC2013.Bachelor's degree 13
dtype: int64
In [72]:
crazycompetitive['IC2013.SAT Critical Reading 25th percentile score']
Out[72]:
12 720
49 700
80 720
121 570
133 700
137 680
174 670
176 700
187 690
188 610
217 580
342 680
347 690
Name: IC2013.SAT Critical Reading 25th percentile score, dtype: int64
In [79]:
is_above25 = crazycompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
crazycompetitive[is_above25][:]
Out[79]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
121
164155
United States Naval Academy
2013
Fall 2013
19146
14710
4436
1408
1075
333
1200
927
273
7
7
Fall 2013
570
680
610
700
NaN
NaN
NaN
NaN
25
32
26
32
NaN
NaN
7
7
85
86
0
1,000 - 4,999
Maryland
4554
1058
188
190372
Cooper Union for the Advancement of Science an...
2013
Fall 2013
3193
1688
1505
247
154
93
186
118
68
8
9
Fall 2013
610
710
610
780
610
730
29
33
NaN
NaN
NaN
NaN
NaN
NaN
8
9
75
77
41400
Under 1,000
New York
906
183
217
197036
United States Military Academy
2013
Fall 2013
15408
12283
3125
1380
1152
228
1176
991
185
9
9
Fall 2013
580
695
600
690
550
665
27
30
27
31
26
31
8
9
9
9
85
86
0
1,000 - 4,999
New York
4622
1054
In [82]:
is_above25 = colleges['IC2013.SAT Critical Reading 25th percentile score'] <= 630
is_min500 = colleges['IC2013.SAT Critical Reading 25th percentile score'] >= 500
colleges[is_above25 & is_min500][:]
Out[82]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
0
100663
University of Alabama at Birmingham
2013
Fall 2013
5689
2214
3475
4934
1944
2990
1773
717
1056
87
88
Fall 2013
520
640
520
650
NaN
NaN
22
28
22
29
20
26
NaN
NaN
87
88
36
37
7206
10,000 - 19,999
Alabama
13108
2195
1
100706
University of Alabama in Huntsville
2013
Fall 2013
2054
1183
871
1656
975
681
651
396
255
81
82
Fall 2013
510
640
510
650
NaN
NaN
23
29
22
30
22
28
NaN
NaN
81
82
39
41
9192
5,000 - 9,999
Alabama
6695
1099
2
100858
Auburn University
2013
Fall 2013
15745
6912
8833
13027
5727
7300
3726
1791
1935
83
83
Fall 2013
520
620
540
650
510
620
24
30
24
32
23
28
6
8
83
83
29
31
9852
20,000 and above
Alabama
21091
4278
3
100937
Birmingham Southern College
2013
Fall 2013
1931
942
989
1240
639
601
356
202
154
64
68
Fall 2013
520
630
520
640
NaN
NaN
23
29
23
30
22
27
NaN
NaN
64
68
29
32
30690
1,000 - 4,999
Alabama
1256
301
4
101541
Judson College
2013
Fall 2013
268
NaN
268
198
NaN
198
68
NaN
68
74
NaN
Fall 2013
550
640
500
600
530
610
19
24
19
26
16
23
NaN
NaN
74
NaN
34
NaN
15630
Under 1,000
Alabama
394
38
5
102049
Samford University
2013
Fall 2013
3447
1276
2171
2653
937
1716
765
267
498
77
73
Fall 2013
500
630
510
610
500
610
23
28
23
30
21
27
NaN
NaN
77
73
29
28
26328
1,000 - 4,999
Alabama
3124
667
6
104151
Arizona State University-Tempe
2013
Fall 2013
21770
11822
9948
17465
9292
8173
7171
4019
3152
80
79
Fall 2013
500
620
520
650
NaN
NaN
22
28
21
28
23
28
NaN
NaN
80
79
41
43
9861
20,000 and above
Arizona
43072
9278
7
104586
Embry-Riddle Aeronautical University-Prescott
2013
Fall 2013
1689
1352
337
1334
1057
277
448
329
119
79
78
Fall 2013
500
630
540
650
490
600
23
29
21
30
24
29
NaN
NaN
79
78
34
31
31034
1,000 - 4,999
Arizona
1813
322
8
106397
University of Arkansas
2013
Fall 2013
18908
8464
10444
11076
4947
6129
4339
2051
2288
59
58
Fall 2013
500
600
520
630
NaN
NaN
23
28
22
29
23
27
NaN
NaN
59
58
39
41
7818
20,000 and above
Arkansas
22355
3347
9
107080
Hendrix College
2013
Fall 2013
1928
948
980
1550
728
822
436
213
223
80
77
Fall 2013
530
680
540
650
NaN
NaN
26
32
26
34
25
30
NaN
NaN
80
77
28
29
37816
1,000 - 4,999
Arkansas
1423
314
10
107141
John Brown University
2013
Fall 2013
1143
458
685
798
340
458
305
134
171
70
74
Fall 2013
500
640
505
640
490
610
22
28
22
30
21
27
6
8
70
74
38
39
22734
1,000 - 4,999
Arkansas
2269
466
11
110097
Biola University
2013
Fall 2013
4816
1699
3117
3509
1165
2344
903
322
581
73
69
Fall 2013
500
620
503
620
490
620
22
27
21
28
22
27
NaN
NaN
73
69
26
28
32142
5,000 - 9,999
California
4516
908
13
110413
California Lutheran University
2013
Fall 2013
6920
3138
3782
3323
1470
1853
540
247
293
48
47
Fall 2013
500
590
510
613
NaN
NaN
22
26
22
27
22
27
NaN
NaN
48
47
16
17
35720
1,000 - 4,999
California
3178
721
14
110422
California Polytechnic State University-San Lu...
2013
Fall 2012
36941
19855
17086
11537
5746
5791
3635
2001
1634
31
29
Fall 2012
550
650
590
690
NaN
NaN
25
30
24
31
26
31
NaN
NaN
31
29
32
35
8724
10,000 - 19,999
California
18052
3300
15
110635
University of California-Berkeley
2013
Fall 2012
61717
30715
31002
11108
5233
5875
4162
2036
2126
18
17
Fall 2012
590
720
630
770
620
750
27
33
26
34
27
34
NaN
NaN
18
17
37
39
12864
20,000 and above
California
28662
7775
16
110644
University of California-Davis
2013
Fall 2012
49820
23010
26810
22526
9532
12994
5208
2066
3142
45
41
Fall 2012
510
640
560
680
530
650
23
29
22
30
24
30
NaN
NaN
45
41
23
22
13895
20,000 and above
California
27829
7015
17
110662
University of California-Los Angeles
2013
Fall 2012
72676
33663
39013
15981
7177
8804
5620
2417
3203
22
21
Fall 2012
560
680
600
760
590
710
25
31
24
32
25
33
NaN
NaN
22
21
35
34
12697
20,000 and above
California
30180
7329
18
110680
University of California-San Diego
2013
Fall 2012
60832
28725
32107
22812
10815
11997
4575
2329
2246
38
38
Fall 2012
550
660
620
730
580
690
25
31
24
31
26
33
NaN
NaN
38
38
20
22
13271
20,000 and above
California
24443
6344
19
110705
University of California-Santa Barbara
2013
Fall 2012
55258
24909
30349
24556
10850
13706
4741
2189
2552
44
44
Fall 2012
530
650
560
690
550
660
24
29
23
30
24
30
NaN
NaN
44
44
19
20
13746
20,000 and above
California
20557
5222
20
111948
Chapman University
2013
Fall 2013
11750
4398
7352
5253
1973
3280
1289
484
805
45
45
Fall 2013
550
640
570
660
560
650
24
29
24
31
24
29
8
9
45
45
25
25
43573
5,000 - 9,999
California
6173
1300
23
117946
Loyola Marymount University
2013
Fall 2013
11472
4438
7034
6209
2365
3844
1341
556
775
54
53
Fall 2013
540
640
550
650
550
650
25
29
24
31
24
28
8
9
54
53
22
24
40265
5,000 - 9,999
California
6529
1524
24
118888
Mills College
2013
Fall 2013
1827
0
1827
1242
NaN
1242
217
NaN
217
68
NaN
Fall 2013
540
640
500
610
520
620
23
28
NaN
NaN
NaN
NaN
NaN
NaN
68
NaN
17
NaN
41494
1,000 - 4,999
California
1022
241
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
26
120883
University of the Pacific
2013
Fall 2013
14222
5499
8723
10332
4146
6186
958
452
506
73
75
Fall 2013
500
640
530
680
500
640
22
29
21
28
22
28
NaN
NaN
73
75
9
11
39810
5,000 - 9,999
California
4099
823
27
121150
Pepperdine University
2013
Fall 2013
9721
3400
6321
3630
1472
2158
784
309
475
37
43
Fall 2013
560
660
570
680
570
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
37
43
22
21
44902
5,000 - 9,999
California
3651
989
28
121309
Point Loma Nazarene University
2013
Fall 2013
3138
951
2187
2088
709
1379
647
226
421
67
75
Fall 2013
520
630
520
630
NaN
NaN
23
28
23
29
23
27
NaN
NaN
67
75
31
32
30356
1,000 - 4,999
California
2504
562
30
121691
University of Redlands
2013
Fall 2013
4668
2018
2650
3137
1324
1813
673
297
376
67
66
Fall 2013
510
610
520
620
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
67
66
21
22
41290
5,000 - 9,999
California
3939
736
31
122436
University of San Diego
2013
Fall 2013
14693
5850
8843
7178
2672
4506
1238
493
745
49
46
Fall 2013
540
650
570
670
NaN
NaN
25
30
25
31
25
30
NaN
NaN
49
46
17
18
41392
5,000 - 9,999
California
5905
1336
32
122612
University of San Francisco
2013
Fall 2013
14808
5189
9619
9076
3172
5904
1148
415
733
61
61
Fall 2013
530
630
540
640
530
630
23
27
23
29
24
27
8
9
61
61
13
13
40294
10,000 - 19,999
California
7118
1388
33
122931
Santa Clara University
2013
Fall 2012
14339
6602
7737
7344
3389
3955
1278
680
598
51
51
Fall 2012
590
680
610
700
NaN
NaN
27
31
NaN
NaN
NaN
NaN
NaN
NaN
51
51
17
20
42156
5,000 - 9,999
California
5596
1155
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
319
231712
Christopher Newport University
2013
Fall 2013
7016
2944
4072
4141
1599
2542
1276
545
731
59
54
Fall 2013
540
630
530
620
NaN
NaN
23
28
NaN
NaN
NaN
NaN
NaN
NaN
59
54
31
34
11092
5,000 - 9,999
Virginia
5121
1057
320
232186
George Mason University
2013
Fall 2013
20805
9262
11543
12905
5562
7343
3011
1420
1591
62
60
Fall 2013
520
620
530
630
NaN
NaN
24
28
23
29
23
27
NaN
NaN
62
60
23
26
9908
20,000 and above
Virginia
30850
4920
321
232308
Hollins University
2013
Fall 2013
824
0
824
571
0
571
148
0
148
69
NaN
Fall 2013
500
640
470
580
NaN
NaN
21
27
NaN
NaN
NaN
NaN
NaN
NaN
69
NaN
26
NaN
33320
Under 1,000
Virginia
655
159
322
232423
James Madison University
2013
Fall 2012
22648
9307
13341
14394
5388
9004
4325
1710
2615
64
58
Fall 2012
520
620
530
630
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
64
58
30
32
9176
20,000 and above
Virginia
20065
4047
323
232681
University of Mary Washington
2013
Fall 2013
4496
1544
2952
3640
1201
2439
947
315
632
81
78
Fall 2013
510
620
500
590
490
600
22
26
21
27
21
25
NaN
NaN
81
78
26
26
9720
1,000 - 4,999
Virginia
5048
1026
324
233374
University of Richmond
2013
Fall 2013
9825
4237
5588
3061
1378
1683
805
391
414
31
33
Fall 2013
590
690
620
720
600
690
28
31
NaN
NaN
NaN
NaN
NaN
NaN
31
33
26
28
45320
1,000 - 4,999
Virginia
3893
929
325
233921
Virginia Polytechnic Institute and State Unive...
2013
Fall 2013
19112
11417
7695
13432
7718
5714
5364
3008
2356
70
68
Fall 2013
540
640
580
680
540
640
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
70
68
40
39
11455
20,000 and above
Virginia
24786
5604
326
234030
Virginia Commonwealth University
2013
Fall 2013
14156
5749
8407
9786
3991
5795
3525
1450
2075
69
69
Fall 2013
500
610
500
600
490
590
21
26
20
26
20
26
NaN
NaN
69
69
36
36
12002
20,000 and above
Virginia
26677
4659
327
234076
University of Virginia-Main Campus
2013
Fall 2013
28984
13632
15352
8691
3908
4783
3520
1556
1964
30
29
Fall 2013
620
720
630
740
620
720
29
33
29
34
28
34
8
9
30
29
41
40
12668
20,000 and above
Virginia
18133
3738
328
234085
Virginia Military Institute
2013
Fall 2013
2012
1801
211
952
821
131
502
441
61
47
46
Fall 2013
520
620
530
630
490
600
22
27
21
27
23
27
NaN
NaN
47
46
53
54
14404
1,000 - 4,999
Virginia
1804
359
330
235167
The Evergreen State College
2013
Fall 2013
1583
664
919
1537
632
905
509
225
284
97
95
Fall 2013
500
630
450
580
460
590
20
27
20
28
17
24
6
8
97
95
33
36
8574
1,000 - 4,999
Washington
5189
1215
331
235316
Gonzaga University
2013
Fall 2012
6991
3162
3829
4650
2018
2632
1096
462
634
67
64
Fall 2012
540
640
550
650
NaN
NaN
25
29
NaN
NaN
NaN
NaN
NaN
NaN
67
64
24
23
35062
5,000 - 9,999
Washington
5122
1255
332
236328
University of Puget Sound
2013
Fall 2013
4588
2028
2560
3910
1653
2257
670
291
379
85
82
Fall 2013
570
670
550
660
550
670
25
30
25
31
24
29
8
9
85
82
17
18
41868
1,000 - 4,999
Washington
2684
641
333
236577
Seattle Pacific University
2013
Fall 2013
5165
1601
3564
3726
1123
2603
767
245
522
72
70
Fall 2013
520
630
510
610
500
620
23
28
22
29
23
27
NaN
NaN
72
70
21
22
33813
1,000 - 4,999
Washington
3523
775
334
236595
Seattle University
2013
Fall 2013
7160
2687
4473
5243
1957
3286
976
589
382
73
73
Fall 2013
520
640
530
630
520
630
24
29
23
29
23
29
7
9
73
73
19
30
36465
5,000 - 9,999
Washington
5010
1150
335
236948
University of Washington-Seattle Campus
2013
Fall 2013
30199
14047
16152
16679
7484
9195
6253
2970
3283
55
53
Fall 2013
520
650
580
710
530
640
25
30
24
31
25
31
8
9
55
53
37
40
12397
20,000 and above
Washington
32139
7651
336
237057
Whitman College
2013
Fall 2013
2586
1022
1564
1473
591
882
392
172
220
57
58
Fall 2013
610
730
610
693
608
700
28
32
NaN
NaN
NaN
NaN
NaN
NaN
57
58
27
29
43500
1,000 - 4,999
Washington
1630
365
337
238333
Beloit College
2013
Fall 2013
2253
1054
1199
1525
668
857
300
126
173
68
63
Fall 2013
550
710
540
660
NaN
NaN
24
30
24
32
23
28
NaN
NaN
68
63
20
19
41250
1,000 - 4,999
Wisconsin
1417
298
338
239105
Marquette University
2013
Fall 2013
23432
10865
12567
13462
6098
7364
1990
941
1049
57
56
Fall 2013
520
630
550
650
520
630
25
29
24
30
24
29
8
9
57
56
15
15
34640
10,000 - 19,999
Wisconsin
8562
1748
339
239318
Milwaukee School of Engineering
2013
Fall 2013
2167
1533
634
1482
1090
392
544
422
122
68
71
Fall 2013
540
640
590
680
NaN
NaN
25
30
22
28
26
30
NaN
NaN
68
71
37
39
34470
1,000 - 4,999
Wisconsin
2490
537
340
240444
University of Wisconsin-Madison
2013
Fall 2012
23324
11326
11998
15841
7264
8577
6279
2932
3347
68
64
Fall 2012
530
650
630
750
580
670
26
30
26
32
26
31
8
9
68
64
40
40
10403
20,000 and above
Wisconsin
33353
6661
341
243221
University of Puerto Rico-Rio Piedras
2013
Fall 2013
5391
2147
3244
2829
1139
1690
2236
856
1380
52
53
Fall 2013
543
644
533
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
52
53
79
75
2082
10,000 - 19,999
Puerto Rico
12623
1824
343
243780
Purdue University-Main Campus
2013
Fall 2013
31083
18258
12825
18779
10589
8190
6422
3659
2763
60
58
Fall 2013
520
630
560
690
520
630
24
30
23
31
25
32
NaN
NaN
60
58
34
35
9992
20,000 and above
Indiana
32874
7058
344
262129
New College of Florida
2013
Fall 2013
1376
508
868
834
310
524
222
88
134
61
61
Fall 2013
620
720
570
660
590
680
27
30
28
33
25
28
8
9
61
61
27
28
6866
Under 1,000
Florida
861
198
345
399911
Soka University of America
2013
Fall 2013
422
159
263
183
67
116
112
44
68
43
42
Fall 2013
500
640
580
700
540
630
25
29
25
31
24
28
NaN
NaN
43
42
61
66
29144
Under 1,000
California
436
119
346
440396
New Saint Andrews College
2013
Fall 2013
73
32
41
63
26
37
46
18
28
86
81
Fall 2013
560
670
480
620
550
670
22
27
23
28
17
24
NaN
NaN
86
81
73
69
11200
Under 1,000
Idaho
151
18
348
443410
DigiPen Institute of Technology
2013
Fall 2013
312
253
59
207
168
39
137
112
25
66
66
Fall 2013
540
668
553
670
520
610
25
30
23
30
24
29
NaN
NaN
66
66
66
67
26720
1,000 - 4,999
Washington
1121
105
349
451671
University of South Florida-Sarasota-Manatee
2013
Fall 2013
393
173
220
136
55
81
86
39
47
35
32
Fall 2013
502
580
490
570
490
570
22
25
21
25
21
25
7
8
35
32
63
71
5587
1,000 - 4,999
Florida
2275
556
350
454184
The King’s College
2013
Fall 2013
3033
1025
2008
2158
745
1413
127
42
85
71
73
Fall 2013
540
630
510
600
520
640
24
28
24
29
22
26
NaN
NaN
71
73
6
6
31300
Under 1,000
New York
583
75
351
456959
University of Minnesota-Rochester
2013
Fall 2013
570
159
411
309
86
223
155
42
113
54
54
Fall 2013
550
700
540
660
520
610
23
27
21
26
23
27
7
8
54
54
50
49
13056
Under 1,000
Minnesota
421
49
308 rows × 39 columns
In [83]:
is_above25 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
is_min500 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] >= 500
morecompetitive[is_above25 & is_min500][:]
Out[83]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
13
110413
California Lutheran University
2013
Fall 2013
6920
3138
3782
3323
1470
1853
540
247
293
48
47
Fall 2013
500
590
510
613
NaN
NaN
22
26
22
27
22
27
NaN
NaN
48
47
16
17
35720
1,000 - 4,999
California
3178
721
14
110422
California Polytechnic State University-San Lu...
2013
Fall 2012
36941
19855
17086
11537
5746
5791
3635
2001
1634
31
29
Fall 2012
550
650
590
690
NaN
NaN
25
30
24
31
26
31
NaN
NaN
31
29
32
35
8724
10,000 - 19,999
California
18052
3300
15
110635
University of California-Berkeley
2013
Fall 2012
61717
30715
31002
11108
5233
5875
4162
2036
2126
18
17
Fall 2012
590
720
630
770
620
750
27
33
26
34
27
34
NaN
NaN
18
17
37
39
12864
20,000 and above
California
28662
7775
16
110644
University of California-Davis
2013
Fall 2012
49820
23010
26810
22526
9532
12994
5208
2066
3142
45
41
Fall 2012
510
640
560
680
530
650
23
29
22
30
24
30
NaN
NaN
45
41
23
22
13895
20,000 and above
California
27829
7015
17
110662
University of California-Los Angeles
2013
Fall 2012
72676
33663
39013
15981
7177
8804
5620
2417
3203
22
21
Fall 2012
560
680
600
760
590
710
25
31
24
32
25
33
NaN
NaN
22
21
35
34
12697
20,000 and above
California
30180
7329
18
110680
University of California-San Diego
2013
Fall 2012
60832
28725
32107
22812
10815
11997
4575
2329
2246
38
38
Fall 2012
550
660
620
730
580
690
25
31
24
31
26
33
NaN
NaN
38
38
20
22
13271
20,000 and above
California
24443
6344
19
110705
University of California-Santa Barbara
2013
Fall 2012
55258
24909
30349
24556
10850
13706
4741
2189
2552
44
44
Fall 2012
530
650
560
690
550
660
24
29
23
30
24
30
NaN
NaN
44
44
19
20
13746
20,000 and above
California
20557
5222
20
111948
Chapman University
2013
Fall 2013
11750
4398
7352
5253
1973
3280
1289
484
805
45
45
Fall 2013
550
640
570
660
560
650
24
29
24
31
24
29
8
9
45
45
25
25
43573
5,000 - 9,999
California
6173
1300
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
27
121150
Pepperdine University
2013
Fall 2013
9721
3400
6321
3630
1472
2158
784
309
475
37
43
Fall 2013
560
660
570
680
570
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
37
43
22
21
44902
5,000 - 9,999
California
3651
989
31
122436
University of San Diego
2013
Fall 2013
14693
5850
8843
7178
2672
4506
1238
493
745
49
46
Fall 2013
540
650
570
670
NaN
NaN
25
30
25
31
25
30
NaN
NaN
49
46
17
18
41392
5,000 - 9,999
California
5905
1336
36
123961
University of Southern California
2013
Fall 2013
47358
22324
25034
9395
4416
4979
2922
1420
1502
20
20
Fall 2013
620
720
660
760
640
750
29
33
28
34
29
34
NaN
NaN
20
20
31
32
46298
20,000 and above
California
19533
4740
40
126678
Colorado College
2013
Fall 2013
5780
2566
3182
1288
531
757
522
224
298
22
21
Fall 2013
610
710
610
720
620
700
27
32
28
34
26
31
8
10
22
21
41
42
44222
1,000 - 4,999
Colorado
2289
522
41
126775
Colorado School of Mines
2013
Fall 2012
11682
8401
3281
4373
2971
1402
949
679
270
37
35
Fall 2012
570
670
630
720
550
650
27
31
25
31
27
32
NaN
NaN
37
35
22
23
16485
5,000 - 9,999
Colorado
4333
814
44
128328
United States Air Force Academy
2013
Fall 2013
9634
7329
2305
1486
1125
361
1154
887
267
15
15
Fall 2013
590
690
620
710
NaN
NaN
29
32
27
33
28
33
NaN
NaN
15
15
78
79
0
1,000 - 4,999
Colorado
4121
1033
46
130590
Trinity College
2013
Fall 2013
7652
3667
3985
2432
1198
1234
604
317
287
32
33
Fall 2013
570
680
580
670
590
673
25
29
25
29
25
30
NaN
NaN
32
33
25
26
47510
1,000 - 4,999
Connecticut
2455
540
47
130624
United States Coast Guard Academy
2013
Fall 2013
1992
1575
417
328
213
115
234
150
84
16
14
Fall 2013
570
670
620
690
560
650
25
30
24
30
26
31
7
8
16
14
71
70
0
Under 1,000
Connecticut
967
230
51
131159
American University
2013
Fall 2013
17545
6580
10965
7566
2473
5093
1627
556
1071
43
38
Fall 2013
590
690
570
660
580
680
26
30
26
33
24
28
8
10
43
38
22
22
40649
10,000 - 19,999
District of Columbia
7872
1776
53
131469
George Washington University
2013
Fall 2012
21756
8895
12861
7197
3187
4010
2387
1076
1311
33
36
Fall 2012
600
690
600
700
610
700
27
31
27
33
26
31
8
9
33
36
33
34
47343
20,000 and above
District of Columbia
11172
2454
55
132903
University of Central Florida
2013
Fall 2013
31820
13315
18505
15572
6711
8861
6068
2729
3339
49
50
Fall 2013
540
630
550
640
510
610
23
28
NaN
NaN
NaN
NaN
NaN
NaN
49
50
39
41
6317
20,000 and above
Florida
59332
12320
59
133951
Florida International University
2013
Fall 2013
16549
6933
9616
7122
3076
4046
2990
1398
1592
43
44
Fall 2013
540
620
530
610
520
600
24
27
23
27
23
27
NaN
NaN
43
44
42
45
6496
20,000 and above
Florida
51334
7746
61
134130
University of Florida
2013
Fall 2013
27107
11745
15362
12618
5232
7386
6373
2658
3715
47
45
Fall 2013
580
670
590
690
570
680
26
31
25
32
25
30
8
9
47
45
51
51
6263
20,000 and above
Florida
35895
8244
62
135726
University of Miami
2013
Fall 2013
28907
13495
15407
11691
5586
6105
2140
1039
1101
40
41
Fall 2013
600
700
630
720
590
690
28
32
29
34
27
33
NaN
NaN
40
41
18
19
42852
10,000 - 19,999
Florida
12235
2451
65
137351
University of South Florida-Main Campus
2013
Fall 2013
28512
12506
16006
12900
5518
7382
3904
1713
2191
45
44
Fall 2013
530
620
550
640
510
610
23
28
23
28
24
27
7
8
45
44
30
31
6410
20,000 and above
Florida
36828
7617
69
139658
Emory University
2013
Fall 2012
17475
7271
10204
4602
1896
2706
1363
593
770
26
26
Fall 2012
620
710
650
750
640
730
29
32
NaN
NaN
NaN
NaN
NaN
NaN
26
26
30
31
44008
10,000 - 19,999
Georgia
8343
1755
72
139931
Georgia Southern University
2013
Fall 2012
10525
5731
4794
5473
2773
2700
3604
1834
1770
52
48
Fall 2012
520
590
510
600
490
570
21
25
21
25
20
25
6
8
52
48
66
66
6071
20,000 and above
Georgia
20501
2912
101
153384
Grinnell College
2013
Fall 2013
3979
1831
2148
1395
622
773
423
183
240
35
34
Fall 2013
620
730
630
770
NaN
NaN
28
32
26
32
28
34
NaN
NaN
35
34
30
29
43656
1,000 - 4,999
Iowa
1695
334
105
156295
Berea College
2013
Fall 2013
1620
679
927
551
249
302
397
181
216
34
37
Fall 2013
510
630
513
610
483
610
22
26
22
27
21
26
NaN
NaN
34
37
72
73
23170
1,000 - 4,999
Kentucky
1732
283
110
160755
Tulane University of Louisiana
2013
Fall 2013
30122
11967
18155
7961
3038
4923
1609
665
944
26
25
Fall 2013
620
700
620
700
630
720
29
32
29
34
27
32
NaN
NaN
26
25
20
22
46930
10,000 - 19,999
Louisiana
9318
1689
112
161086
Colby College
2013
Fall 2013
5407
2555
2852
1408
632
776
483
243
240
26
25
Fall 2013
620
710
640
720
620
720
28
32
28
34
27
32
NaN
NaN
26
25
34
38
45760
1,000 - 4,999
Maine
2064
510
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
223
198385
Davidson College
2013
Fall 2013
4745
2069
2676
1215
601
614
483
228
255
26
29
Fall 2013
630
730
600
710
610
710
29
33
NaN
NaN
NaN
NaN
NaN
NaN
26
29
40
38
42849
1,000 - 4,999
North Carolina
1932
461
227
199120
University of North Carolina at Chapel Hill
2013
Fall 2012
28437
11636
16801
7847
3294
4553
3915
1616
2299
28
28
Fall 2012
590
700
610
710
580
690
28
32
28
34
27
33
8
9
28
28
50
49
8340
20,000 and above
North Carolina
19688
4627
229
199193
North Carolina State University at Raleigh
2013
Fall 2012
20700
10837
9863
10353
5322
5031
4398
2419
1979
50
49
Fall 2012
550
640
590
670
520
620
25
30
24
30
25
30
7
8
50
49
42
45
8206
20,000 and above
North Carolina
28247
5446
234
201645
Case Western Reserve University
2013
Fall 2013
18418
10095
8323
7713
4031
3682
1252
664
588
42
40
Fall 2013
600
720
670
760
620
710
29
33
28
34
28
34
8
9
42
40
16
16
41800
10,000 - 19,999
Ohio
4554
898
236
202523
Denison University
2013
Fall 2013
4770
2079
2691
2193
892
1301
582
259
323
46
43
Fall 2013
590
660
600
670
NaN
NaN
27
31
NaN
NaN
NaN
NaN
NaN
NaN
46
43
27
29
43910
1,000 - 4,999
Ohio
2363
544
237
203535
Kenyon College
2013
Fall 2013
4054
1562
2492
1556
652
904
483
222
261
38
42
Fall 2013
630
720
600
690
630
730
28
32
29
34
27
31
8
10
38
42
31
34
45640
1,000 - 4,999
Ohio
1786
414
246
207971
University of Tulsa
2013
Fall 2013
7304
3636
3668
2965
1588
1377
856
490
366
41
44
Fall 2013
560
710
570
690
NaN
NaN
25
32
24
33
24
30
NaN
NaN
41
44
29
31
34835
1,000 - 4,999
Oklahoma
3488
676
248
209287
Multnomah University
2013
Fall 2013
184
91
93
99
42
57
57
25
32
54
46
Fall 2013
500
650
490
580
490
590
19
27
NaN
NaN
NaN
NaN
NaN
NaN
54
46
58
60
21850
Under 1,000
Oregon
569
150
255
211291
Bucknell University
2013
Fall 2013
7947
4094
3853
2345
1101
1244
933
449
484
30
27
Fall 2013
580
680
620
720
600
690
27
32
28
33
27
32
9
10
30
27
40
41
46902
1,000 - 4,999
Pennsylvania
3644
850
257
212009
Dickinson College
2013
Fall 2013
5826
2264
3553
2589
953
1636
625
270
355
44
42
Fall 2013
590
675
600
690
590
680
27
31
NaN
NaN
NaN
NaN
NaN
NaN
44
42
24
28
46094
1,000 - 4,999
Pennsylvania
2499
526
260
212674
Gettysburg College
2013
Fall 2013
5453
2623
2830
2270
1034
1236
703
337
366
42
39
Fall 2013
600
690
600
680
NaN
NaN
27
29
NaN
NaN
NaN
NaN
NaN
NaN
42
39
31
33
45870
1,000 - 4,999
Pennsylvania
2791
639
263
213385
Lafayette College
2013
Fall 2013
6766
3651
3115
2310
1160
1150
635
329
306
34
32
Fall 2013
570
670
610
700
580
690
27
31
26
32
27
32
8
9
34
32
27
28
44670
1,000 - 4,999
Pennsylvania
2529
589
264
213543
Lehigh University
2013
Fall 2013
12589
7144
5445
3882
2117
1765
1198
680
518
31
30
Fall 2013
580
670
640
740
NaN
NaN
28
32
NaN
NaN
NaN
NaN
NaN
NaN
31
30
31
32
43520
5,000 - 9,999
Pennsylvania
4965
1177
266
214175
Muhlenberg College
2013
Fall 2013
5152
2028
3124
2378
847
1531
579
215
364
46
42
Fall 2013
570
670
570
670
570
670
25
31
NaN
NaN
NaN
NaN
NaN
NaN
46
42
24
25
42755
1,000 - 4,999
Pennsylvania
2732
593
277
216597
Villanova University
2013
Fall 2013
14966
7228
7738
7319
3503
3816
1659
793
866
49
48
Fall 2013
590
690
620
710
600
690
29
31
29
33
27
32
NaN
NaN
49
48
23
23
44430
10,000 - 19,999
Pennsylvania
7771
1787
278
216764
West Chester University of Pennsylvania
2013
Fall 2013
13424
4855
8569
6922
2433
4489
2298
812
1486
52
50
Fall 2013
500
590
520
600
490
590
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
52
50
33
33
8850
10,000 - 19,999
Pennsylvania
15017
2760
282
217493
Rhode Island School of Design
2013
Fall 2013
3215
904
2311
878
277
601
455
143
312
27
31
Fall 2013
530
670
560
710
550
690
24
32
23
33
24
31
NaN
NaN
27
31
52
52
42932
1,000 - 4,999
Rhode Island
2059
481
291
219976
Lipscomb University
2013
Fall 2013
3467
1285
2182
1827
643
1184
684
257
427
53
50
Fall 2013
520
650
510
650
NaN
NaN
22
28
23
31
22
27
NaN
NaN
53
50
37
40
26094
1,000 - 4,999
Tennessee
3340
525
292
220808
Memphis College of Art
2013
Fall 2013
983
338
645
391
129
262
141
40
101
40
38
Fall 2013
500
620
410
530
NaN
NaN
19
25
19
26
16
23
NaN
NaN
40
38
36
31
27500
Under 1,000
Tennessee
374
71
301
226231
LeTourneau University
2013
Fall 2013
1810
1006
804
736
482
254
335
216
119
41
48
Fall 2013
500
640
530
660
NaN
NaN
22
30
21
29
23
28
NaN
NaN
41
48
46
45
25740
1,000 - 4,999
Texas
3337
557
305
228343
Southwestern University
2013
Fall 2013
3546
1549
1997
1850
743
1107
491
226
265
52
48
Fall 2013
520
640
540
640
NaN
NaN
22
29
22
29
23
27
NaN
NaN
52
48
27
30
35240
1,000 - 4,999
Texas
1455
338
307
228778
The University of Texas at Austin
2013
Fall 2013
38161
18361
19800
15335
6780
8555
7249
3190
4059
40
37
Fall 2013
550
670
590
710
550
680
25
31
25
33
26
32
7
9
40
37
47
47
9798
20,000 and above
Texas
42933
9154
309
228875
Texas Christian University
2013
Fall 2013
18551
7299
11252
8791
3202
5589
1936
728
1208
47
44
Fall 2013
540
620
550
650
540
640
25
29
NaN
NaN
NaN
NaN
NaN
NaN
47
44
22
23
36590
5,000 - 9,999
Texas
8848
1841
311
230038
Brigham Young University-Provo
2013
Fall 2013
11423
4026
7397
5645
1777
3868
4427
1345
3082
49
44
Fall 2013
570
680
580
680
NaN
NaN
26
31
26
33
25
30
NaN
NaN
49
44
78
76
4850
20,000 and above
Utah
37615
6619
314
230959
Middlebury College
2013
Fall 2012
8847
3704
5143
1518
735
783
598
294
304
17
20
Fall 2012
630
740
640
740
650
750
31
33
NaN
NaN
NaN
NaN
NaN
NaN
17
20
39
40
45314
1,000 - 4,999
Vermont
3728
656
324
233374
University of Richmond
2013
Fall 2013
9825
4237
5588
3061
1378
1683
805
391
414
31
33
Fall 2013
590
690
620
720
600
690
28
31
NaN
NaN
NaN
NaN
NaN
NaN
31
33
26
28
45320
1,000 - 4,999
Virginia
3893
929
327
234076
University of Virginia-Main Campus
2013
Fall 2013
28984
13632
15352
8691
3908
4783
3520
1556
1964
30
29
Fall 2013
620
720
630
740
620
720
29
33
29
34
28
34
8
9
30
29
41
40
12668
20,000 and above
Virginia
18133
3738
328
234085
Virginia Military Institute
2013
Fall 2013
2012
1801
211
952
821
131
502
441
61
47
46
Fall 2013
520
620
530
630
490
600
22
27
21
27
23
27
NaN
NaN
47
46
53
54
14404
1,000 - 4,999
Virginia
1804
359
345
399911
Soka University of America
2013
Fall 2013
422
159
263
183
67
116
112
44
68
43
42
Fall 2013
500
640
580
700
540
630
25
29
25
31
24
28
NaN
NaN
43
42
61
66
29144
Under 1,000
California
436
119
349
451671
University of South Florida-Sarasota-Manatee
2013
Fall 2013
393
173
220
136
55
81
86
39
47
35
32
Fall 2013
502
580
490
570
490
570
22
25
21
25
21
25
7
8
35
32
63
71
5587
1,000 - 4,999
Florida
2275
556
96 rows × 39 columns
In [86]:
is_location = morecompetitive['HD2013.State abbreviation'] == 'California'
is_jakeabove25 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
is_min500 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] >= 500
morecompetitive[is_jakeabove25 & is_min500 & is_location][:]
Out[86]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
13
110413
California Lutheran University
2013
Fall 2013
6920
3138
3782
3323
1470
1853
540
247
293
48
47
Fall 2013
500
590
510
613
NaN
NaN
22
26
22
27
22
27
NaN
NaN
48
47
16
17
35720
1,000 - 4,999
California
3178
721
14
110422
California Polytechnic State University-San Lu...
2013
Fall 2012
36941
19855
17086
11537
5746
5791
3635
2001
1634
31
29
Fall 2012
550
650
590
690
NaN
NaN
25
30
24
31
26
31
NaN
NaN
31
29
32
35
8724
10,000 - 19,999
California
18052
3300
15
110635
University of California-Berkeley
2013
Fall 2012
61717
30715
31002
11108
5233
5875
4162
2036
2126
18
17
Fall 2012
590
720
630
770
620
750
27
33
26
34
27
34
NaN
NaN
18
17
37
39
12864
20,000 and above
California
28662
7775
16
110644
University of California-Davis
2013
Fall 2012
49820
23010
26810
22526
9532
12994
5208
2066
3142
45
41
Fall 2012
510
640
560
680
530
650
23
29
22
30
24
30
NaN
NaN
45
41
23
22
13895
20,000 and above
California
27829
7015
17
110662
University of California-Los Angeles
2013
Fall 2012
72676
33663
39013
15981
7177
8804
5620
2417
3203
22
21
Fall 2012
560
680
600
760
590
710
25
31
24
32
25
33
NaN
NaN
22
21
35
34
12697
20,000 and above
California
30180
7329
18
110680
University of California-San Diego
2013
Fall 2012
60832
28725
32107
22812
10815
11997
4575
2329
2246
38
38
Fall 2012
550
660
620
730
580
690
25
31
24
31
26
33
NaN
NaN
38
38
20
22
13271
20,000 and above
California
24443
6344
19
110705
University of California-Santa Barbara
2013
Fall 2012
55258
24909
30349
24556
10850
13706
4741
2189
2552
44
44
Fall 2012
530
650
560
690
550
660
24
29
23
30
24
30
NaN
NaN
44
44
19
20
13746
20,000 and above
California
20557
5222
20
111948
Chapman University
2013
Fall 2013
11750
4398
7352
5253
1973
3280
1289
484
805
45
45
Fall 2013
550
640
570
660
560
650
24
29
24
31
24
29
8
9
45
45
25
25
43573
5,000 - 9,999
California
6173
1300
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
27
121150
Pepperdine University
2013
Fall 2013
9721
3400
6321
3630
1472
2158
784
309
475
37
43
Fall 2013
560
660
570
680
570
670
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
37
43
22
21
44902
5,000 - 9,999
California
3651
989
31
122436
University of San Diego
2013
Fall 2013
14693
5850
8843
7178
2672
4506
1238
493
745
49
46
Fall 2013
540
650
570
670
NaN
NaN
25
30
25
31
25
30
NaN
NaN
49
46
17
18
41392
5,000 - 9,999
California
5905
1336
36
123961
University of Southern California
2013
Fall 2013
47358
22324
25034
9395
4416
4979
2922
1420
1502
20
20
Fall 2013
620
720
660
760
640
750
29
33
28
34
29
34
NaN
NaN
20
20
31
32
46298
20,000 and above
California
19533
4740
345
399911
Soka University of America
2013
Fall 2013
422
159
263
183
67
116
112
44
68
43
42
Fall 2013
500
640
580
700
540
630
25
29
25
31
24
28
NaN
NaN
43
42
61
66
29144
Under 1,000
California
436
119
In [87]:
is_location = morecompetitive['HD2013.State abbreviation'] == 'Texas'
is_jakeabove25 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
is_min500 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] >= 500
morecompetitive[is_jakeabove25 & is_min500 & is_location][:]
Out[87]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
301
226231
LeTourneau University
2013
Fall 2013
1810
1006
804
736
482
254
335
216
119
41
48
Fall 2013
500
640
530
660
NaN
NaN
22
30
21
29
23
28
NaN
NaN
41
48
46
45
25740
1,000 - 4,999
Texas
3337
557
305
228343
Southwestern University
2013
Fall 2013
3546
1549
1997
1850
743
1107
491
226
265
52
48
Fall 2013
520
640
540
640
NaN
NaN
22
29
22
29
23
27
NaN
NaN
52
48
27
30
35240
1,000 - 4,999
Texas
1455
338
307
228778
The University of Texas at Austin
2013
Fall 2013
38161
18361
19800
15335
6780
8555
7249
3190
4059
40
37
Fall 2013
550
670
590
710
550
680
25
31
25
33
26
32
7
9
40
37
47
47
9798
20,000 and above
Texas
42933
9154
309
228875
Texas Christian University
2013
Fall 2013
18551
7299
11252
8791
3202
5589
1936
728
1208
47
44
Fall 2013
540
620
550
650
540
640
25
29
NaN
NaN
NaN
NaN
NaN
NaN
47
44
22
23
36590
5,000 - 9,999
Texas
8848
1841
In [88]:
is_location = morecompetitive['HD2013.State abbreviation'] == 'Michigan'
is_jakeabove25 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
is_min500 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] >= 500
morecompetitive[is_jakeabove25 & is_min500 & is_location][:]
Out[88]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
149
170976
University of Michigan-Ann Arbor
2013
Fall 2013
46813
24728
22085
15570
7307
8263
6200
3016
3184
33
30
Fall 2013
620
720
660
760
630
730
28
32
27
31
28
34
NaN
NaN
33
30
40
41
13142
20,000 and above
Michigan
28821
6741
In [89]:
is_location = morecompetitive['HD2013.State abbreviation'] == 'Minnesota'
is_jakeabove25 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
is_min500 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] >= 500
morecompetitive[is_jakeabove25 & is_min500 & is_location][:]
Out[89]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
155
173902
Macalester College
2013
Fall 2013
6683
2605
4078
2283
853
1430
555
226
329
34
33
Fall 2013
620
740
610
710
630
720
29
32
30
34
27
32
8
9
34
33
24
26
45388
1,000 - 4,999
Minnesota
2223
536
156
174066
University of Minnesota-Twin Cities
2013
Fall 2013
43048
20210
22838
19121
8928
10193
5544
2629
2915
44
44
Fall 2013
550
690
620
740
570
670
26
30
24
31
25
30
7
8
44
44
29
29
13555
20,000 and above
Minnesota
44332
7559
In [92]:
#is_location = morecompetitive['HD2013.State abbreviation'] == 'Minnesota'
is_jakeabove75 = colleges['IC2013.SAT Critical Reading 75th percentile score'] <= 630
is_min500 = colleges['IC2013.SAT Critical Reading 25th percentile score'] >= 500
colleges[is_jakeabove75 & is_min500][:]
Out[92]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
2
100858
Auburn University
2013
Fall 2013
15745
6912
8833
13027
5727
7300
3726
1791
1935
83
83
Fall 2013
520
620
540
650
510
620
24
30
24
32
23
28
6
8
83
83
29
31
9852
20,000 and above
Alabama
21091
4278
3
100937
Birmingham Southern College
2013
Fall 2013
1931
942
989
1240
639
601
356
202
154
64
68
Fall 2013
520
630
520
640
NaN
NaN
23
29
23
30
22
27
NaN
NaN
64
68
29
32
30690
1,000 - 4,999
Alabama
1256
301
5
102049
Samford University
2013
Fall 2013
3447
1276
2171
2653
937
1716
765
267
498
77
73
Fall 2013
500
630
510
610
500
610
23
28
23
30
21
27
NaN
NaN
77
73
29
28
26328
1,000 - 4,999
Alabama
3124
667
6
104151
Arizona State University-Tempe
2013
Fall 2013
21770
11822
9948
17465
9292
8173
7171
4019
3152
80
79
Fall 2013
500
620
520
650
NaN
NaN
22
28
21
28
23
28
NaN
NaN
80
79
41
43
9861
20,000 and above
Arizona
43072
9278
7
104586
Embry-Riddle Aeronautical University-Prescott
2013
Fall 2013
1689
1352
337
1334
1057
277
448
329
119
79
78
Fall 2013
500
630
540
650
490
600
23
29
21
30
24
29
NaN
NaN
79
78
34
31
31034
1,000 - 4,999
Arizona
1813
322
8
106397
University of Arkansas
2013
Fall 2013
18908
8464
10444
11076
4947
6129
4339
2051
2288
59
58
Fall 2013
500
600
520
630
NaN
NaN
23
28
22
29
23
27
NaN
NaN
59
58
39
41
7818
20,000 and above
Arkansas
22355
3347
11
110097
Biola University
2013
Fall 2013
4816
1699
3117
3509
1165
2344
903
322
581
73
69
Fall 2013
500
620
503
620
490
620
22
27
21
28
22
27
NaN
NaN
73
69
26
28
32142
5,000 - 9,999
California
4516
908
13
110413
California Lutheran University
2013
Fall 2013
6920
3138
3782
3323
1470
1853
540
247
293
48
47
Fall 2013
500
590
510
613
NaN
NaN
22
26
22
27
22
27
NaN
NaN
48
47
16
17
35720
1,000 - 4,999
California
3178
721
28
121309
Point Loma Nazarene University
2013
Fall 2013
3138
951
2187
2088
709
1379
647
226
421
67
75
Fall 2013
520
630
520
630
NaN
NaN
23
28
23
29
23
27
NaN
NaN
67
75
31
32
30356
1,000 - 4,999
California
2504
562
30
121691
University of Redlands
2013
Fall 2013
4668
2018
2650
3137
1324
1813
673
297
376
67
66
Fall 2013
510
610
520
620
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
67
66
21
22
41290
5,000 - 9,999
California
3939
736
32
122612
University of San Francisco
2013
Fall 2013
14808
5189
9619
9076
3172
5904
1148
415
733
61
61
Fall 2013
530
630
540
640
530
630
23
27
23
29
24
27
8
9
61
61
13
13
40294
10,000 - 19,999
California
7118
1388
35
123554
Saint Mary's College of California
2013
Fall 2013
4864
1759
3105
3379
1259
2120
622
255
367
69
72
Fall 2013
500
600
510
610
510
610
22
27
22
27
22
27
7
8
69
72
18
20
39890
1,000 - 4,999
California
3221
636
39
126614
University of Colorado Boulder
2013
Fall 2013
22473
11995
10478
19710
10302
9408
5846
3159
2687
88
86
Fall 2013
520
630
540
650
NaN
NaN
24
29
23
30
23
29
NaN
NaN
88
86
30
31
10347
20,000 and above
Colorado
29290
5752
42
126818
Colorado State University-Fort Collins
2013
Fall 2013
17970
8218
9752
13914
6022
7892
4443
2016
2427
77
73
Fall 2013
510
620
510
630
NaN
NaN
22
27
22
28
22
27
NaN
NaN
77
73
32
33
9313
20,000 and above
Colorado
25594
4736
50
130943
University of Delaware
2013
Fall 2013
25458
10767
14691
16467
6543
9924
4224
1746
2478
65
61
Fall 2013
520
630
540
650
520
630
24
29
23
29
24
29
8
9
65
61
26
27
12112
20,000 and above
Delaware
19299
3741
52
131283
Catholic University of America
2013
Fall 2013
6298
2822
3476
3783
1751
2032
837
401
436
60
62
Fall 2013
500
610
510
610
NaN
NaN
22
27
NaN
NaN
NaN
NaN
NaN
NaN
60
62
22
23
38526
5,000 - 9,999
District of Columbia
3837
733
55
132903
University of Central Florida
2013
Fall 2013
31820
13315
18505
15572
6711
8861
6068
2729
3339
49
50
Fall 2013
540
630
550
640
510
610
23
28
NaN
NaN
NaN
NaN
NaN
NaN
49
50
39
41
6317
20,000 and above
Florida
59332
12320
56
133492
Eckerd College
2013
Fall 2012
3912
1478
2434
2779
977
1802
534
218
316
71
66
Fall 2012
510
620
500
610
NaN
NaN
23
28
22
27
22
29
NaN
NaN
71
66
19
22
37362
1,000 - 4,999
Florida
2653
522
57
133711
Flagler College-St Augustine
2013
Fall 2013
5396
2255
3141
2691
1202
1489
708
287
421
50
53
Fall 2013
540
580
530
580
520
570
21
25
21
26
21
25
NaN
NaN
50
53
26
24
16180
1,000 - 4,999
Florida
2959
644
58
133881
Florida Institute of Technology
2013
Fall 2013
7820
5570
2250
4727
3387
1340
783
573
210
60
61
Fall 2013
500
610
530
650
NaN
NaN
23
28
21
28
23
29
NaN
NaN
60
61
17
17
36020
5,000 - 9,999
Florida
3122
533
59
133951
Florida International University
2013
Fall 2013
16549
6933
9616
7122
3076
4046
2990
1398
1592
43
44
Fall 2013
540
620
530
610
520
600
24
27
23
27
23
27
NaN
NaN
43
44
42
45
6496
20,000 and above
Florida
51334
7746
63
136172
University of North Florida
2013
Fall 2013
10635
4252
6383
5682
2340
3342
1615
746
869
53
55
Fall 2013
540
620
540
610
500
590
23
26
22
26
22
26
7
8
53
55
28
32
6353
10,000 - 19,999
Florida
17352
3221
65
137351
University of South Florida-Main Campus
2013
Fall 2013
28512
12506
16006
12900
5518
7382
3904
1713
2191
45
44
Fall 2013
530
620
550
640
510
610
23
28
23
28
24
27
7
8
45
44
30
31
6410
20,000 and above
Florida
36828
7617
71
139861
Georgia College and State University
2013
Fall 2013
4051
1511
2540
2754
1037
1717
1392
542
850
68
69
Fall 2013
530
610
520
620
510
600
22
26
22
27
22
26
NaN
NaN
68
69
51
52
8790
5,000 - 9,999
Georgia
6186
1151
72
139931
Georgia Southern University
2013
Fall 2012
10525
5731
4794
5473
2773
2700
3604
1834
1770
52
48
Fall 2012
520
590
510
600
490
570
21
25
21
25
20
25
6
8
52
48
66
66
6071
20,000 and above
Georgia
20501
2912
74
140164
Kennesaw State University
2013
Fall 2012
9471
3820
5651
5355
2147
3208
3194
1303
1891
57
56
Fall 2012
500
590
490
580
470
570
21
24
20
24
19
24
6
8
57
56
60
61
5818
20,000 and above
Georgia
26769
3491
75
140447
Mercer University
2013
Fall 2013
3864
1539
2325
2666
1137
1529
728
343
385
69
74
Fall 2013
540
630
540
640
NaN
NaN
23
28
23
29
23
27
NaN
NaN
69
74
27
30
33120
5,000 - 9,999
Georgia
4936
965
76
140696
Oglethorpe University
2013
Fall 2013
4403
1550
2853
2455
871
1584
282
129
153
56
56
Fall 2013
520
630
510
610
490
610
22
27
NaN
NaN
NaN
NaN
NaN
NaN
56
56
11
15
31280
1,000 - 4,999
Georgia
1120
176
77
141097
Southern Polytechnic State University
2013
Fall 2013
1689
1391
298
1317
1100
217
797
681
116
78
79
Fall 2013
500
600
530
630
NaN
NaN
22
26
20
25
22
26
NaN
NaN
78
79
61
62
5732
5,000 - 9,999
Georgia
6351
781
78
143288
Blackburn College
2013
Fall 2013
528
232
296
359
155
204
116
53
63
68
67
Fall 2013
520
570
500
620
NaN
NaN
19
25
19
26
17
23
NaN
NaN
68
67
32
34
18506
Under 1,000
Illinois
570
86
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
271
215770
Saint Joseph's University
2013
Fall 2013
7831
3565
4266
6165
2786
3379
1275
588
687
79
78
Fall 2013
510
590
510
610
510
600
22
26
22
27
22
27
NaN
NaN
79
78
21
21
39040
5,000 - 9,999
Pennsylvania
5642
1176
272
215929
University of Scranton
2013
Fall 2013
9087
3533
5554
6818
2688
4130
881
348
533
75
76
Fall 2013
510
600
520
610
NaN
NaN
22
27
NaN
NaN
NaN
NaN
NaN
NaN
75
76
13
13
38754
5,000 - 9,999
Pennsylvania
4183
906
273
216278
Susquehanna University
2013
Fall 2013
3217
1468
1749
2327
1007
1320
589
260
329
72
69
Fall 2013
510
620
510
610
490
610
23
27
22
28
22
27
NaN
NaN
72
69
25
26
38780
1,000 - 4,999
Pennsylvania
2404
493
275
216339
Temple University
2013
Fall 2013
18813
8314
10499
12016
5261
6755
4390
2028
2362
64
63
Fall 2013
500
610
510
620
500
610
22
27
21
28
22
27
6
8
64
63
37
39
14096
20,000 and above
Pennsylvania
30509
5914
278
216764
West Chester University of Pennsylvania
2013
Fall 2013
13424
4855
8569
6922
2433
4489
2298
812
1486
52
50
Fall 2013
500
590
520
600
490
590
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
52
50
33
33
8850
10,000 - 19,999
Pennsylvania
15017
2760
280
217165
Bryant University
2013
Fall 2013
6013
3472
2541
4603
2649
1954
890
510
380
77
76
Fall 2013
510
590
540
630
500
590
23
27
NaN
NaN
NaN
NaN
NaN
NaN
77
76
19
19
37234
1,000 - 4,999
Rhode Island
3286
753
281
217402
Providence College
2013
Fall 2013
9660
4016
5644
5776
2489
3287
1027
452
575
60
62
Fall 2013
520
620
530
640
530
640
23
28
NaN
NaN
NaN
NaN
NaN
NaN
60
62
18
18
43245
1,000 - 4,999
Rhode Island
4487
869
283
217536
Salve Regina University
2013
Fall 2013
5070
1562
3508
3400
967
2433
465
132
333
67
62
Fall 2013
510
590
510
600
505
600
23
26
22
27
22
26
NaN
NaN
67
62
14
14
34950
1,000 - 4,999
Rhode Island
2129
431
284
217819
College of Charleston
2013
Fall 2012
11509
3847
7662
8092
2638
5454
2138
718
1420
70
69
Fall 2012
530
630
540
630
NaN
NaN
23
28
23
29
22
26
NaN
NaN
70
69
26
27
10626
10,000 - 19,999
South Carolina
11392
2220
288
218973
Wofford College
2013
Fall 2013
2718
1342
1376
1870
879
991
415
210
205
69
65
Fall 2013
540
620
540
640
520
620
24
29
23
29
23
27
NaN
NaN
69
65
22
24
35515
1,000 - 4,999
South Carolina
1715
391
289
219347
South Dakota School of Mines and Technology
2013
Fall 2013
1343
1089
254
1156
937
219
553
456
97
86
86
Fall 2013
500
630
560
660
NaN
NaN
24
28
21
27
24
29
NaN
NaN
86
86
48
49
10040
1,000 - 4,999
South Dakota
2378
253
292
220808
Memphis College of Art
2013
Fall 2013
983
338
645
391
129
262
141
40
101
40
38
Fall 2013
500
620
410
530
NaN
NaN
19
25
19
26
16
23
NaN
NaN
40
38
36
31
27500
Under 1,000
Tennessee
374
71
303
227845
Saint Edward's University
2013
Fall 2013
3694
1309
2385
2901
1022
1879
791
311
480
79
78
Fall 2013
510
610
510
610
490
600
22
26
21
26
21
26
NaN
NaN
79
78
27
30
33720
1,000 - 4,999
Texas
4618
963
306
228723
Texas A & M University-College Station
2013
Fall 2013
31387
15933
15454
21803
10667
11136
10241
5066
5175
69
67
Fall 2013
520
630
550
660
490
610
23
29
22
29
24
29
6
8
69
67
47
47
8506
20,000 and above
Texas
44468
9538
309
228875
Texas Christian University
2013
Fall 2013
18551
7299
11252
8791
3202
5589
1936
728
1208
47
44
Fall 2013
540
620
550
650
540
640
25
29
NaN
NaN
NaN
NaN
NaN
NaN
47
44
22
23
36590
5,000 - 9,999
Texas
8848
1841
312
230807
Westminster College
2013
Fall 2013
2461
1057
1404
1850
794
1056
449
211
238
75
75
Fall 2013
500
610
500
610
NaN
NaN
22
28
21
28
21
27
NaN
NaN
75
75
24
27
29500
1,000 - 4,999
Utah
2710
506
313
230852
Champlain College
2013
Fall 2013
5047
2386
2661
3573
1682
1891
594
361
233
71
70
Fall 2013
500
620
490
620
490
600
22
28
21
31
21
26
NaN
NaN
71
70
17
21
31350
1,000 - 4,999
Vermont
3248
506
318
231651
Regent University
2013
Fall 2013
1238
415
823
1054
348
706
231
87
144
85
84
Fall 2013
500
630
460
570
NaN
NaN
19
25
20
26
17
24
NaN
NaN
85
84
22
25
15838
5,000 - 9,999
Virginia
2631
382
319
231712
Christopher Newport University
2013
Fall 2013
7016
2944
4072
4141
1599
2542
1276
545
731
59
54
Fall 2013
540
630
530
620
NaN
NaN
23
28
NaN
NaN
NaN
NaN
NaN
NaN
59
54
31
34
11092
5,000 - 9,999
Virginia
5121
1057
320
232186
George Mason University
2013
Fall 2013
20805
9262
11543
12905
5562
7343
3011
1420
1591
62
60
Fall 2013
520
620
530
630
NaN
NaN
24
28
23
29
23
27
NaN
NaN
62
60
23
26
9908
20,000 and above
Virginia
30850
4920
322
232423
James Madison University
2013
Fall 2012
22648
9307
13341
14394
5388
9004
4325
1710
2615
64
58
Fall 2012
520
620
530
630
NaN
NaN
23
27
NaN
NaN
NaN
NaN
NaN
NaN
64
58
30
32
9176
20,000 and above
Virginia
20065
4047
323
232681
University of Mary Washington
2013
Fall 2013
4496
1544
2952
3640
1201
2439
947
315
632
81
78
Fall 2013
510
620
500
590
490
600
22
26
21
27
21
25
NaN
NaN
81
78
26
26
9720
1,000 - 4,999
Virginia
5048
1026
326
234030
Virginia Commonwealth University
2013
Fall 2013
14156
5749
8407
9786
3991
5795
3525
1450
2075
69
69
Fall 2013
500
610
500
600
490
590
21
26
20
26
20
26
NaN
NaN
69
69
36
36
12002
20,000 and above
Virginia
26677
4659
328
234085
Virginia Military Institute
2013
Fall 2013
2012
1801
211
952
821
131
502
441
61
47
46
Fall 2013
520
620
530
630
490
600
22
27
21
27
23
27
NaN
NaN
47
46
53
54
14404
1,000 - 4,999
Virginia
1804
359
330
235167
The Evergreen State College
2013
Fall 2013
1583
664
919
1537
632
905
509
225
284
97
95
Fall 2013
500
630
450
580
460
590
20
27
20
28
17
24
6
8
97
95
33
36
8574
1,000 - 4,999
Washington
5189
1215
333
236577
Seattle Pacific University
2013
Fall 2013
5165
1601
3564
3726
1123
2603
767
245
522
72
70
Fall 2013
520
630
510
610
500
620
23
28
22
29
23
27
NaN
NaN
72
70
21
22
33813
1,000 - 4,999
Washington
3523
775
338
239105
Marquette University
2013
Fall 2013
23432
10865
12567
13462
6098
7364
1990
941
1049
57
56
Fall 2013
520
630
550
650
520
630
25
29
24
30
24
29
8
9
57
56
15
15
34640
10,000 - 19,999
Wisconsin
8562
1748
343
243780
Purdue University-Main Campus
2013
Fall 2013
31083
18258
12825
18779
10589
8190
6422
3659
2763
60
58
Fall 2013
520
630
560
690
520
630
24
30
23
31
25
32
NaN
NaN
60
58
34
35
9992
20,000 and above
Indiana
32874
7058
349
451671
University of South Florida-Sarasota-Manatee
2013
Fall 2013
393
173
220
136
55
81
86
39
47
35
32
Fall 2013
502
580
490
570
490
570
22
25
21
25
21
25
7
8
35
32
63
71
5587
1,000 - 4,999
Florida
2275
556
350
454184
The King’s College
2013
Fall 2013
3033
1025
2008
2158
745
1413
127
42
85
71
73
Fall 2013
540
630
510
600
520
640
24
28
24
29
22
26
NaN
NaN
71
73
6
6
31300
Under 1,000
New York
583
75
121 rows × 39 columns
In [93]:
is_jakeabove25 = colleges['IC2013.SAT Critical Reading 25th percentile score'] <= 630
#is_jakeabove75 = colleges['IC2013.SAT Critical Reading 75th percentile score'] <= 630
is_min600 = colleges['IC2013.SAT Critical Reading 25th percentile score'] >= 600
colleges[is_jakeabove25 & is_min600][:]
Out[93]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
36
123961
University of Southern California
2013
Fall 2013
47358
22324
25034
9395
4416
4979
2922
1420
1502
20
20
Fall 2013
620
720
660
760
640
750
29
33
28
34
29
34
NaN
NaN
20
20
31
32
46298
20,000 and above
California
19533
4740
40
126678
Colorado College
2013
Fall 2013
5780
2566
3182
1288
531
757
522
224
298
22
21
Fall 2013
610
710
610
720
620
700
27
32
28
34
26
31
8
10
22
21
41
42
44222
1,000 - 4,999
Colorado
2289
522
53
131469
George Washington University
2013
Fall 2012
21756
8895
12861
7197
3187
4010
2387
1076
1311
33
36
Fall 2012
600
690
600
700
610
700
27
31
27
33
26
31
8
9
33
36
33
34
47343
20,000 and above
District of Columbia
11172
2454
62
135726
University of Miami
2013
Fall 2013
28907
13495
15407
11691
5586
6105
2140
1039
1101
40
41
Fall 2013
600
700
630
720
590
690
28
32
29
34
27
33
NaN
NaN
40
41
18
19
42852
10,000 - 19,999
Florida
12235
2451
69
139658
Emory University
2013
Fall 2012
17475
7271
10204
4602
1896
2706
1363
593
770
26
26
Fall 2012
620
710
650
750
640
730
29
32
NaN
NaN
NaN
NaN
NaN
NaN
26
26
30
31
44008
10,000 - 19,999
Georgia
8343
1755
70
139755
Georgia Institute of Technology-Main Campus
2013
Fall 2012
14645
10009
4636
8045
5253
2792
3044
1980
1064
55
52
Fall 2012
600
700
660
760
610
700
28
32
28
33
29
34
8
9
55
52
38
38
10650
20,000 and above
Georgia
16085
3122
89
149781
Wheaton College
2013
Fall 2012
1959
817
1142
1346
624
722
598
287
311
69
76
Fall 2012
600
720
610
700
600
710
27
32
27
34
26
31
8
9
69
76
44
46
30880
1,000 - 4,999
Illinois
2580
652
101
153384
Grinnell College
2013
Fall 2013
3979
1831
2148
1395
622
773
423
183
240
35
34
Fall 2013
620
730
630
770
NaN
NaN
28
32
26
32
28
34
NaN
NaN
35
34
30
29
43656
1,000 - 4,999
Iowa
1695
334
110
160755
Tulane University of Louisiana
2013
Fall 2013
30122
11967
18155
7961
3038
4923
1609
665
944
26
25
Fall 2013
620
700
620
700
630
720
29
32
29
34
27
32
NaN
NaN
26
25
20
22
46930
10,000 - 19,999
Louisiana
9318
1689
112
161086
Colby College
2013
Fall 2013
5407
2555
2852
1408
632
776
483
243
240
26
25
Fall 2013
620
710
640
720
620
720
28
32
28
34
27
32
NaN
NaN
26
25
34
38
45760
1,000 - 4,999
Maine
2064
510
127
164924
Boston College
2013
Fall 2013
24538
10742
13796
7905
3584
4321
2215
1033
1182
32
33
Fall 2013
620
710
650
740
640
730
30
33
29
34
28
33
8
10
32
33
28
29
45622
10,000 - 19,999
Massachusetts
10354
2377
129
165015
Brandeis University
2013
Fall 2013
9496
3917
5579
3517
1515
2002
833
376
457
37
39
Fall 2013
600
710
630
760
620
720
28
32
28
34
27
34
8
9
37
39
24
25
45856
5,000 - 9,999
Massachusetts
3907
851
149
170976
University of Michigan-Ann Arbor
2013
Fall 2013
46813
24728
22085
15570
7307
8263
6200
3016
3184
33
30
Fall 2013
620
720
660
760
630
730
28
32
27
31
28
34
NaN
NaN
33
30
40
41
13142
20,000 and above
Michigan
28821
6741
155
173902
Macalester College
2013
Fall 2013
6683
2605
4078
2283
853
1430
555
226
329
34
33
Fall 2013
620
740
610
710
630
720
29
32
30
34
27
32
8
9
34
33
24
26
45388
1,000 - 4,999
Minnesota
2223
536
184
189097
Barnard College
2013
Fall 2013
5606
0
5606
1151
0
1151
580
0
580
21
NaN
Fall 2013
620
730
620
710
650
740
28
32
29
34
26
31
NaN
NaN
21
NaN
50
NaN
44790
1,000 - 4,999
New York
2609
623
186
190099
Colgate University
2013
Fall 2013
8374
3749
4625
2209
933
1276
759
319
440
26
25
Fall 2013
620
720
650
740
NaN
NaN
30
32
30
34
28
33
NaN
NaN
26
25
34
34
46380
1,000 - 4,999
New York
3007
685
188
190372
Cooper Union for the Advancement of Science an...
2013
Fall 2013
3193
1688
1505
247
154
93
186
118
68
8
9
Fall 2013
610
710
610
780
610
730
29
33
NaN
NaN
NaN
NaN
NaN
NaN
8
9
75
77
41400
Under 1,000
New York
906
183
198
193900
New York University
2013
Fall 2013
57845
18487
27292
15066
5784
9282
5207
2083
3124
26
31
Fall 2013
620
720
630
740
640
730
28
32
NaN
NaN
NaN
NaN
NaN
NaN
26
31
35
36
44848
20,000 and above
New York
26781
5333
201
194824
Rensselaer Polytechnic Institute
2013
Fall 2013
16150
11273
4877
6654
4377
2277
1411
975
436
41
39
Fall 2013
620
720
670
768
NaN
NaN
27
31
NaN
NaN
NaN
NaN
NaN
NaN
41
39
21
22
46269
5,000 - 9,999
New York
5474
1294
203
195030
University of Rochester
2013
Fall 2013
17244
8521
8723
6153
2977
3176
1472
738
734
36
35
Fall 2013
600
700
650
750
620
700
29
32
28
34
27
33
NaN
NaN
36
35
24
25
45372
10,000 - 19,999
New York
6401
1441
223
198385
Davidson College
2013
Fall 2013
4745
2069
2676
1215
601
614
483
228
255
26
29
Fall 2013
630
730
600
710
610
710
29
33
NaN
NaN
NaN
NaN
NaN
NaN
26
29
40
38
42849
1,000 - 4,999
North Carolina
1932
461
234
201645
Case Western Reserve University
2013
Fall 2013
18418
10095
8323
7713
4031
3682
1252
664
588
42
40
Fall 2013
600
720
670
760
620
710
29
33
28
34
28
34
8
9
42
40
16
16
41800
10,000 - 19,999
Ohio
4554
898
237
203535
Kenyon College
2013
Fall 2013
4054
1562
2492
1556
652
904
483
222
261
38
42
Fall 2013
630
720
600
690
630
730
28
32
29
34
27
31
8
10
38
42
31
34
45640
1,000 - 4,999
Ohio
1786
414
247
209056
Lewis & Clark College
2013
Fall 2013
6458
2565
3893
4059
1516
2543
473
177
296
63
59
Fall 2013
600
700
580
670
580
690
26
31
NaN
NaN
NaN
NaN
NaN
NaN
63
59
12
12
41928
1,000 - 4,999
Oregon
2334
432
254
211273
Bryn Mawr College
2013
Fall 2013
2708
NaN
2708
1081
NaN
1081
365
NaN
365
40
NaN
Fall 2013
600
710
610
760
620
720
27
32
27
34
26
31
8
9
40
NaN
34
NaN
43900
1,000 - 4,999
Pennsylvania
1409
327
260
212674
Gettysburg College
2013
Fall 2013
5453
2623
2830
2270
1034
1236
703
337
366
42
39
Fall 2013
600
690
600
680
NaN
NaN
27
29
NaN
NaN
NaN
NaN
NaN
NaN
42
39
31
33
45870
1,000 - 4,999
Pennsylvania
2791
639
304
228246
Southern Methodist University
2013
Fall 2013
12080
5238
6842
6125
2745
3380
1431
694
737
51
52
Fall 2013
600
690
620
700
590
680
27
31
27
33
26
32
8
9
51
52
23
25
43800
10,000 - 19,999
Texas
6917
1617
314
230959
Middlebury College
2013
Fall 2012
8847
3704
5143
1518
735
783
598
294
304
17
20
Fall 2012
630
740
640
740
650
750
31
33
NaN
NaN
NaN
NaN
NaN
NaN
17
20
39
40
45314
1,000 - 4,999
Vermont
3728
656
327
234076
University of Virginia-Main Campus
2013
Fall 2013
28984
13632
15352
8691
3908
4783
3520
1556
1964
30
29
Fall 2013
620
720
630
740
620
720
29
33
29
34
28
34
8
9
30
29
41
40
12668
20,000 and above
Virginia
18133
3738
336
237057
Whitman College
2013
Fall 2013
2586
1022
1564
1473
591
882
392
172
220
57
58
Fall 2013
610
730
610
693
608
700
28
32
NaN
NaN
NaN
NaN
NaN
NaN
57
58
27
29
43500
1,000 - 4,999
Washington
1630
365
344
262129
New College of Florida
2013
Fall 2013
1376
508
868
834
310
524
222
88
134
61
61
Fall 2013
620
720
570
660
590
680
27
30
28
33
25
28
8
9
61
61
27
28
6866
Under 1,000
Florida
861
198
In [95]:
colleges[is_jakeabove25 & is_min600][:].count()
Out[95]:
unitid 32
institution name 32
year 32
IC2013.Fall reporting period for applicant and admissions 32
IC2013.Applicants total 32
IC2013.Applicants men 31
IC2013.Applicants women 32
IC2013.Admissions total 32
IC2013.Admissions men 31
IC2013.Admissions women 32
IC2013.Enrolled total 32
IC2013.Enrolled men 31
IC2013.Enrolled women 32
DRVIC2013.Percent admitted - total 32
DRVIC2013.Percent admitted - men 30
IC2013.Fall reporting period for SAT/ACT test scores 32
IC2013.SAT Critical Reading 25th percentile score 32
IC2013.SAT Critical Reading 75th percentile score 32
IC2013.SAT Math 25th percentile score 32
IC2013.SAT Math 75th percentile score 32
IC2013.SAT Writing 25th percentile score 28
IC2013.SAT Writing 75th percentile score 28
IC2013.ACT Composite 25th percentile score 32
IC2013.ACT Composite 75th percentile score 32
IC2013.ACT English 25th percentile score 23
IC2013.ACT English 75th percentile score 23
IC2013.ACT Math 25th percentile score 23
IC2013.ACT Math 75th percentile score 23
IC2013.ACT Writing 25th percentile score 14
IC2013.ACT Writing 75th percentile score 14
DRVIC2013.Percent admitted - total.1 32
DRVIC2013.Percent admitted - men.1 30
DRVIC2013.Admissions yield - total 32
DRVIC2013.Admissions yield - men 30
DRVIC2013.Tuition and fees, 2013-14 32
HD2013.Institution size category 32
HD2013.State abbreviation 32
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13 32
DRVC2013.Bachelor's degree 32
dtype: int64
In [96]:
is_jakeabove25 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] <= 630
#is_jakeabove75 = colleges['IC2013.SAT Critical Reading 75th percentile score'] <= 630
is_min600 = morecompetitive['IC2013.SAT Critical Reading 25th percentile score'] >= 600
morecompetitive[is_jakeabove25 & is_min600][:]
Out[96]:
unitid
institution name
year
IC2013.Fall reporting period for applicant and admissions
IC2013.Applicants total
IC2013.Applicants men
IC2013.Applicants women
IC2013.Admissions total
IC2013.Admissions men
IC2013.Admissions women
IC2013.Enrolled total
IC2013.Enrolled men
IC2013.Enrolled women
DRVIC2013.Percent admitted - total
DRVIC2013.Percent admitted - men
IC2013.Fall reporting period for SAT/ACT test scores
IC2013.SAT Critical Reading 25th percentile score
IC2013.SAT Critical Reading 75th percentile score
IC2013.SAT Math 25th percentile score
IC2013.SAT Math 75th percentile score
IC2013.SAT Writing 25th percentile score
IC2013.SAT Writing 75th percentile score
IC2013.ACT Composite 25th percentile score
IC2013.ACT Composite 75th percentile score
IC2013.ACT English 25th percentile score
IC2013.ACT English 75th percentile score
IC2013.ACT Math 25th percentile score
IC2013.ACT Math 75th percentile score
IC2013.ACT Writing 25th percentile score
IC2013.ACT Writing 75th percentile score
DRVIC2013.Percent admitted - total.1
DRVIC2013.Percent admitted - men.1
DRVIC2013.Admissions yield - total
DRVIC2013.Admissions yield - men
DRVIC2013.Tuition and fees, 2013-14
HD2013.Institution size category
HD2013.State abbreviation
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13
DRVC2013.Bachelor's degree
25
120254
Occidental College
2013
Fall 2013
6072
2442
3630
2574
964
1610
548
233
315
42
39
Fall 2013
600
700
610
700
610
700
27
31
25
33
25
31
10
12
42
39
21
24
46652
1,000 - 4,999
California
2230
554
36
123961
University of Southern California
2013
Fall 2013
47358
22324
25034
9395
4416
4979
2922
1420
1502
20
20
Fall 2013
620
720
660
760
640
750
29
33
28
34
29
34
NaN
NaN
20
20
31
32
46298
20,000 and above
California
19533
4740
40
126678
Colorado College
2013
Fall 2013
5780
2566
3182
1288
531
757
522
224
298
22
21
Fall 2013
610
710
610
720
620
700
27
32
28
34
26
31
8
10
22
21
41
42
44222
1,000 - 4,999
Colorado
2289
522
53
131469
George Washington University
2013
Fall 2012
21756
8895
12861
7197
3187
4010
2387
1076
1311
33
36
Fall 2012
600
690
600
700
610
700
27
31
27
33
26
31
8
9
33
36
33
34
47343
20,000 and above
District of Columbia
11172
2454
62
135726
University of Miami
2013
Fall 2013
28907
13495
15407
11691
5586
6105
2140
1039
1101
40
41
Fall 2013
600
700
630
720
590
690
28
32
29
34
27
33
NaN
NaN
40
41
18
19
42852
10,000 - 19,999
Florida
12235
2451
69
139658
Emory University
2013
Fall 2012
17475
7271
10204
4602
1896
2706
1363
593
770
26
26
Fall 2012
620
710
650
750
640
730
29
32
NaN
NaN
NaN
NaN
NaN
NaN
26
26
30
31
44008
10,000 - 19,999
Georgia
8343
1755
101
153384
Grinnell College
2013
Fall 2013
3979
1831
2148
1395
622
773
423
183
240
35
34
Fall 2013
620
730
630
770
NaN
NaN
28
32
26
32
28
34
NaN
NaN
35
34
30
29
43656
1,000 - 4,999
Iowa
1695
334
110
160755
Tulane University of Louisiana
2013
Fall 2013
30122
11967
18155
7961
3038
4923
1609
665
944
26
25
Fall 2013
620
700
620
700
630
720
29
32
29
34
27
32
NaN
NaN
26
25
20
22
46930
10,000 - 19,999
Louisiana
9318
1689
112
161086
Colby College
2013
Fall 2013
5407
2555
2852
1408
632
776
483
243
240
26
25
Fall 2013
620
710
640
720
620
720
28
32
28
34
27
32
NaN
NaN
26
25
34
38
45760
1,000 - 4,999
Maine
2064
510
127
164924
Boston College
2013
Fall 2013
24538
10742
13796
7905
3584
4321
2215
1033
1182
32
33
Fall 2013
620
710
650
740
640
730
30
33
29
34
28
33
8
10
32
33
28
29
45622
10,000 - 19,999
Massachusetts
10354
2377
129
165015
Brandeis University
2013
Fall 2013
9496
3917
5579
3517
1515
2002
833
376
457
37
39
Fall 2013
600
710
630
760
620
720
28
32
28
34
27
34
8
9
37
39
24
25
45856
5,000 - 9,999
Massachusetts
3907
851
149
170976
University of Michigan-Ann Arbor
2013
Fall 2013
46813
24728
22085
15570
7307
8263
6200
3016
3184
33
30
Fall 2013
620
720
660
760
630
730
28
32
27
31
28
34
NaN
NaN
33
30
40
41
13142
20,000 and above
Michigan
28821
6741
155
173902
Macalester College
2013
Fall 2013
6683
2605
4078
2283
853
1430
555
226
329
34
33
Fall 2013
620
740
610
710
630
720
29
32
30
34
27
32
8
9
34
33
24
26
45388
1,000 - 4,999
Minnesota
2223
536
186
190099
Colgate University
2013
Fall 2013
8374
3749
4625
2209
933
1276
759
319
440
26
25
Fall 2013
620
720
650
740
NaN
NaN
30
32
30
34
28
33
NaN
NaN
26
25
34
34
46380
1,000 - 4,999
New York
3007
685
188
190372
Cooper Union for the Advancement of Science an...
2013
Fall 2013
3193
1688
1505
247
154
93
186
118
68
8
9
Fall 2013
610
710
610
780
610
730
29
33
NaN
NaN
NaN
NaN
NaN
NaN
8
9
75
77
41400
Under 1,000
New York
906
183
198
193900
New York University
2013
Fall 2013
57845
18487
27292
15066
5784
9282
5207
2083
3124
26
31
Fall 2013
620
720
630
740
640
730
28
32
NaN
NaN
NaN
NaN
NaN
NaN
26
31
35
36
44848
20,000 and above
New York
26781
5333
201
194824
Rensselaer Polytechnic Institute
2013
Fall 2013
16150
11273
4877
6654
4377
2277
1411
975
436
41
39
Fall 2013
620
720
670
768
NaN
NaN
27
31
NaN
NaN
NaN
NaN
NaN
NaN
41
39
21
22
46269
5,000 - 9,999
New York
5474
1294
203
195030
University of Rochester
2013
Fall 2013
17244
8521
8723
6153
2977
3176
1472
738
734
36
35
Fall 2013
600
700
650
750
620
700
29
32
28
34
27
33
NaN
NaN
36
35
24
25
45372
10,000 - 19,999
New York
6401
1441
223
198385
Davidson College
2013
Fall 2013
4745
2069
2676
1215
601
614
483
228
255
26
29
Fall 2013
630
730
600
710
610
710
29
33
NaN
NaN
NaN
NaN
NaN
NaN
26
29
40
38
42849
1,000 - 4,999
North Carolina
1932
461
234
201645
Case Western Reserve University
2013
Fall 2013
18418
10095
8323
7713
4031
3682
1252
664
588
42
40
Fall 2013
600
720
670
760
620
710
29
33
28
34
28
34
8
9
42
40
16
16
41800
10,000 - 19,999
Ohio
4554
898
237
203535
Kenyon College
2013
Fall 2013
4054
1562
2492
1556
652
904
483
222
261
38
42
Fall 2013
630
720
600
690
630
730
28
32
29
34
27
31
8
10
38
42
31
34
45640
1,000 - 4,999
Ohio
1786
414
260
212674
Gettysburg College
2013
Fall 2013
5453
2623
2830
2270
1034
1236
703
337
366
42
39
Fall 2013
600
690
600
680
NaN
NaN
27
29
NaN
NaN
NaN
NaN
NaN
NaN
42
39
31
33
45870
1,000 - 4,999
Pennsylvania
2791
639
314
230959
Middlebury College
2013
Fall 2012
8847
3704
5143
1518
735
783
598
294
304
17
20
Fall 2012
630
740
640
740
650
750
31
33
NaN
NaN
NaN
NaN
NaN
NaN
17
20
39
40
45314
1,000 - 4,999
Vermont
3728
656
327
234076
University of Virginia-Main Campus
2013
Fall 2013
28984
13632
15352
8691
3908
4783
3520
1556
1964
30
29
Fall 2013
620
720
630
740
620
720
29
33
29
34
28
34
8
9
30
29
41
40
12668
20,000 and above
Virginia
18133
3738
In [97]:
morecompetitive[is_jakeabove25 & is_min600][:].count()
Out[97]:
unitid 24
institution name 24
year 24
IC2013.Fall reporting period for applicant and admissions 24
IC2013.Applicants total 24
IC2013.Applicants men 24
IC2013.Applicants women 24
IC2013.Admissions total 24
IC2013.Admissions men 24
IC2013.Admissions women 24
IC2013.Enrolled total 24
IC2013.Enrolled men 24
IC2013.Enrolled women 24
DRVIC2013.Percent admitted - total 24
DRVIC2013.Percent admitted - men 24
IC2013.Fall reporting period for SAT/ACT test scores 24
IC2013.SAT Critical Reading 25th percentile score 24
IC2013.SAT Critical Reading 75th percentile score 24
IC2013.SAT Math 25th percentile score 24
IC2013.SAT Math 75th percentile score 24
IC2013.SAT Writing 25th percentile score 20
IC2013.SAT Writing 75th percentile score 20
IC2013.ACT Composite 25th percentile score 24
IC2013.ACT Composite 75th percentile score 24
IC2013.ACT English 25th percentile score 17
IC2013.ACT English 75th percentile score 17
IC2013.ACT Math 25th percentile score 17
IC2013.ACT Math 75th percentile score 17
IC2013.ACT Writing 25th percentile score 9
IC2013.ACT Writing 75th percentile score 9
DRVIC2013.Percent admitted - total.1 24
DRVIC2013.Percent admitted - men.1 24
DRVIC2013.Admissions yield - total 24
DRVIC2013.Admissions yield - men 24
DRVIC2013.Tuition and fees, 2013-14 24
HD2013.Institution size category 24
HD2013.State abbreviation 24
DRVEF122013.12-month unduplicated headcount, undergraduate: 2012-13 24
DRVC2013.Bachelor's degree 24
dtype: int64
In [ ]:
Content source: willingc/seaside-notebooks
Similar notebooks: