This is the process book that covers how we loaded and cleaned the schools data for the year 2009-2010. We use the schools data in the visualization.
We did not use the schools data in our models because graduation rate data is not available nationwide at the school level. We found invidual states or cities that made graduation rate data publically available, yet it would have been too time consuming to download from many different places. School level data is for data vizualization purpose.
In [1]:
%matplotlib inline
import numpy as np
import scipy as sp
import matplotlib as mpl
import matplotlib.cm as cm
import matplotlib.pyplot as plt
import pandas as pd
pd.set_option('display.width', 500)
pd.set_option('display.max_columns', 100)
pd.set_option('display.notebook_repr_html', True)
import seaborn as sns
sns.set_style("whitegrid")
sns.set_context("poster")
In [3]:
# Load schools.csv (raw data)
sdf_v0 = pd.read_csv("tempdata/schools.csv")
sdf_v0.shape
In [4]:
sc_drdf = pd.read_csv("tempdata/schools_rc.csv") # schools.csv column [d]rop [r]ename
sdf_v1 = sdf_v0.copy(deep=True)
In [5]:
for index, row in sc_drdf.iterrows():
current_colname = str(row['Raw Column Name'])
new_colname = str(row['New Column Name'])
if new_colname == "drop":
#print "Dropping : ", current_colname
sdf_v1.drop(current_colname, axis=1, inplace=True)
else :
#print "Renaming : ", current_colname, " --> ", new_colname
sdf_v1.rename(columns={current_colname : new_colname }, inplace=True)
sdf_v1.shape
Out[5]:
(99074, 333)
| Notation | Description |
|---|---|
| pk | School Year : Prekindergarten |
| k | School Year : Kindergarten |
| g (g1,g2… g12) | School Year : Grade (Grade1, Grade2… Grade12) |
| ug | School Year : Ungraded |
| an | Race : American Indian/Asian Native |
| a | Race : Asian/Pacific Islander |
| h | Race : Hispanic |
| b | Race : Black |
| w | Race : White |
| hp | Race : Hawaiian Native/Pacific Islander |
| mr | Race : Two or more races |
| m | Sex : Male |
| f | Sex : Female |
In [63]:
#sdf_v1.to_csv("tempdata/schools_v1.csv")
#sdf_v1 = pd.read_csv("tempdata/schools_v1.csv")
In [6]:
# Trimming cells that contain :
# ="abc" to abc
# "abc" to abc
for i, col in enumerate(sdf_v1.columns):
if sdf_v1[col].dtype == object:
sdf_v1[col] = sdf_v1[col].str.replace('="', '')
sdf_v1[col] = sdf_v1[col].str.replace('"', '')
In [8]:
# Replacing Missing Data / NA / Bad Quality data with NaN
# Ref : http://pandas.pydata.org/pandas-docs/version/0.15.2/missing_data.html
sdf_v1 = sdf_v1.replace('\xe2\x80\x93', np.nan) # Replace "-" (Missing Data) with NaN
sdf_v1 = sdf_v1.replace('\xe2\x80\xa0', np.nan) # Replace "†" (Not Applicable) with NaN
sdf_v1 = sdf_v1.replace('\xe2\x80\xa1', np.nan) # Replace "‡" (Bad Quality) with NaN
In [9]:
# Converting some columns to boolean data types by replacing "1-Yes", "2-No" to True & False resp.
tfmap = {'1-Yes': True, '2-No': False}
vtfmap = {'A virtual school': True, 'Not a virtual school': False} # virtual_school
ltfmap = {'Yes under Community Eligibility Option (CEO)': True,
'Yes participating without using any Provision or the CEO': True,
'Yes under Provision 3': True,
'Yes under Provision 2': True,
'Yes under Provision 1': True,
'No': False }
sdf_v1 = sdf_v1.replace(tfmap)
sdf_v1 = sdf_v1.replace(vtfmap)
sdf_v1 = sdf_v1.replace(ltfmap)
In [11]:
sdf_v1.to_csv("tempdata/schools_v2.csv")
sdf_v2 = pd.read_csv("tempdata/schools_v2.csv")
In [12]:
for i, col in enumerate(sdf_v2.columns):
print i," : ", col, " : ", sdf_v2[col].dtype
0 : Unnamed: 0 : int64
1 : School Name : object
2 : state : object
3 : state_abbr : object
4 : school_id_nces : int64
5 : agency_name : object
6 : agency_id_nces : int64
7 : county : object
8 : data_available : object
9 : data_na : object
10 : city : object
11 : zipcode : int64
12 : school_type : object
13 : agency_type : object
14 : operational : object
15 : charter_school : object
16 : magnet_school : object
17 : shared_time_school : object
18 : location_type : object
19 : title1_school_wide : object
20 : title1_eligible : object
21 : title1_status : object
22 : latitude : float64
23 : longitude : float64
24 : school_id_state : object
25 : agency_id_state : object
26 : congressional_code : float64
27 : virtual_school : object
28 : lunch_program : object
29 : offered_g_lowest : object
30 : offered_g_highest : object
31 : offered_pk : bool
32 : offered_k : bool
33 : offered_g1 : bool
34 : offered_g2 : bool
35 : offered_g3 : bool
36 : offered_g4 : bool
37 : offered_g5 : bool
38 : offered_g6 : bool
39 : offered_g7 : bool
40 : offered_g8 : bool
41 : offered_g9 : bool
42 : offered_g10 : bool
43 : offered_g11 : bool
44 : offered_g12 : bool
45 : offered_ug : bool
46 : total_students : float64
47 : lunch_free_eligible : float64
48 : lunch_reduced_eligible : float64
49 : lunch_total_free_and_reduced : float64
50 : students_pk_k : float64
51 : students_g1_g8 : float64
52 : students_g9_g12 : float64
53 : students_pk : float64
54 : students_k : float64
55 : students_g1 : float64
56 : students_g2 : float64
57 : students_g3 : float64
58 : students_g4 : float64
59 : students_g5 : float64
60 : students_g6 : float64
61 : students_g7 : float64
62 : students_g8 : float64
63 : students_g9 : float64
64 : students_g10 : float64
65 : students_g11 : float64
66 : students_g12 : float64
67 : students_ug : float64
68 : students_m : float64
69 : students_f : float64
70 : students_an : float64
71 : students_a : float64
72 : students_h : float64
73 : students_b : float64
74 : students_w : float64
75 : students_hp : float64
76 : students_mr : float64
77 : total_race : float64
78 : an_m : float64
79 : an_f : float64
80 : a_m : float64
81 : a_f : float64
82 : h_m : float64
83 : h_f : float64
84 : b_m : float64
85 : b_f : float64
86 : w_m : float64
87 : w_f : float64
88 : hp_m : float64
89 : hp_f : float64
90 : mr_m : float64
91 : mr_f : float64
92 : pk_m : float64
93 : pk_f : float64
94 : k_m : float64
95 : k_f : float64
96 : g1_m : float64
97 : g1_f : float64
98 : g2_m : float64
99 : g2_f : float64
100 : g3_m : float64
101 : g3_f : float64
102 : g4_m : float64
103 : g4_f : float64
104 : g5_m : float64
105 : g5_f : float64
106 : g6_m : float64
107 : g6_f : float64
108 : g7_m : float64
109 : g7_f : float64
110 : g8_m : float64
111 : g8_f : float64
112 : g9_m : float64
113 : g9_f : float64
114 : g10_m : float64
115 : g10_f : float64
116 : g11_m : float64
117 : g11_f : float64
118 : g12_m : float64
119 : g12_f : float64
120 : gug_m : float64
121 : gug_f : float64
122 : pk_an_m : float64
123 : pk_an_f : float64
124 : pk_a_m : float64
125 : pk_a_f : float64
126 : pk_h_m : float64
127 : pk_h_f : float64
128 : pk_b_m : float64
129 : pk_b_f : float64
130 : pk_w_m : float64
131 : pk_w_f : float64
132 : pk_hp_m : float64
133 : pk_hp_f : float64
134 : pk_mr_m : float64
135 : pk_mr_f : float64
136 : k_an_m : float64
137 : k_an_f : float64
138 : k_a_m : float64
139 : k_a_f : float64
140 : k_h_m : float64
141 : k_h_f : float64
142 : k_b_m : float64
143 : k_b_f : float64
144 : k_w_m : float64
145 : k_w_f : float64
146 : k_hp_m : float64
147 : k_hp_f : float64
148 : k_mr_m : float64
149 : k_mr_f : float64
150 : g1_an_m : float64
151 : g1_an_f : float64
152 : g1_a_m : float64
153 : g1_a_f : float64
154 : g1_h_m : float64
155 : g1_h_f : float64
156 : g1_b_m : float64
157 : g1_b_f : float64
158 : g1_w_m : float64
159 : g1_w_f : float64
160 : g1_hp_m : float64
161 : g1_hp_f : float64
162 : g1_mr_m : float64
163 : g1_mr_f : float64
164 : g2_an_m : float64
165 : g2_an_f : float64
166 : g2_a_m : float64
167 : g2_a_f : float64
168 : g2_h_m : float64
169 : g2_h_f : float64
170 : g2_b_m : float64
171 : g2_b_f : float64
172 : g2_w_m : float64
173 : g2_w_f : float64
174 : g2_hp_m : float64
175 : g2_hp_f : float64
176 : g2_mr_m : float64
177 : g2_mr_f : float64
178 : g3_an_m : float64
179 : g3_an_f : float64
180 : g3_a_m : float64
181 : g3_a_f : float64
182 : g3_h_m : float64
183 : g3_h_f : float64
184 : g3_b_m : float64
185 : g3_b_f : float64
186 : g3_w_m : float64
187 : g3_w_f : float64
188 : g3_hp_m : float64
189 : g3_hp_f : float64
190 : g3_mr_m : float64
191 : g3_mr_f : float64
192 : g4_an_m : float64
193 : g4_an_f : float64
194 : g4_a_m : float64
195 : g4_a_f : float64
196 : g4_h_m : float64
197 : g4_h_f : float64
198 : g4_b_m : float64
199 : g4_b_f : float64
200 : g4_w_m : float64
201 : g4_w_f : float64
202 : g4_hp_m : float64
203 : g4_hp_f : float64
204 : g4_mr_m : float64
205 : g4_mr_f : float64
206 : g5_an_m : float64
207 : g5_an_f : float64
208 : g5_a_m : float64
209 : g5_a_f : float64
210 : g5_h_m : float64
211 : g5_h_f : float64
212 : g5_b_m : float64
213 : g5_b_f : float64
214 : g5_w_m : float64
215 : g5_w_f : float64
216 : g5_hp_m : float64
217 : g5_hp_f : float64
218 : g5_mr_m : float64
219 : g5_mr_f : float64
220 : g6_an_m : float64
221 : g6_an_f : float64
222 : g6_a_m : float64
223 : g6_a_f : float64
224 : g6_h_m : float64
225 : g6_h_f : float64
226 : g6_b_m : float64
227 : g6_b_f : float64
228 : g6_w_m : float64
229 : g6_w_f : float64
230 : g6_hp_m : float64
231 : g6_hp_f : float64
232 : g6_mr_m : float64
233 : g6_mr_f : float64
234 : g7_an_m : float64
235 : g7_an_f : float64
236 : g7_a_m : float64
237 : g7_a_f : float64
238 : g7_h_m : float64
239 : g7_h_f : float64
240 : g7_b_m : float64
241 : g7_b_f : float64
242 : g7_w_m : float64
243 : g7_w_f : float64
244 : g7_hp_m : float64
245 : g7_hp_f : float64
246 : g7_mr_m : float64
247 : g7_mr_f : float64
248 : g8_an_m : float64
249 : g8_an_f : float64
250 : g8_a_m : float64
251 : g8_a_f : float64
252 : g8_h_m : float64
253 : g8_h_f : float64
254 : g8_b_m : float64
255 : g8_b_f : float64
256 : g8_w_m : float64
257 : g8_w_f : float64
258 : g8_hp_m : float64
259 : g8_hp_f : float64
260 : g8_mr_m : float64
261 : g8_mr_f : float64
262 : g9_an_m : float64
263 : g9_an_f : float64
264 : g9_a_m : float64
265 : g9_a_f : float64
266 : g9_h_m : float64
267 : g9_h_f : float64
268 : g9_b_m : float64
269 : g9_b_f : float64
270 : g9_w_m : float64
271 : g9_w_f : float64
272 : g9_hp_m : float64
273 : g9_hp_f : float64
274 : g9_mr_m : float64
275 : g9_mr_f : float64
276 : g10_an_m : float64
277 : g10_an_f : float64
278 : g10_a_m : float64
279 : g10_a_f : float64
280 : g10_h_m : float64
281 : g10_h_f : float64
282 : g10_b_m : float64
283 : g10_b_f : float64
284 : g10_w_m : float64
285 : g10_w_f : float64
286 : g10_hp_m : float64
287 : g10_hp_f : float64
288 : g10_mr_m : float64
289 : g10_mr_f : float64
290 : g11_an_m : float64
291 : g11_an_f : float64
292 : g11_a_m : float64
293 : g11_a_f : float64
294 : g11_h_m : float64
295 : g11_h_f : float64
296 : g11_b_m : float64
297 : g11_b_f : float64
298 : g11_w_m : float64
299 : g11_w_f : float64
300 : g11_hp_m : float64
301 : g11_hp_f : float64
302 : g11_mr_m : float64
303 : g11_mr_f : float64
304 : g12_an_m : float64
305 : g12_an_f : float64
306 : g12_a_m : float64
307 : g12_a_f : float64
308 : g12_h_m : float64
309 : g12_h_f : float64
310 : g12_b_m : float64
311 : g12_b_f : float64
312 : g12_w_m : float64
313 : g12_w_f : float64
314 : g12_hp_m : float64
315 : g12_hp_f : float64
316 : g12_mr_m : float64
317 : g12_mr_f : float64
318 : gug_an_m : float64
319 : gug_an_f : float64
320 : gug_a_m : float64
321 : gug_a_f : float64
322 : gug_h_m : float64
323 : gug_h_f : float64
324 : gug_b_m : float64
325 : gug_b_f : float64
326 : gug_w_m : float64
327 : gug_w_f : float64
328 : gug_hp_m : float64
329 : gug_hp_f : float64
330 : gug_mr_m : float64
331 : gug_mr_f : float64
332 : teacher_fulltime : float64
333 : pupil_teacher_ratio : float64
In [13]:
sdf_v2.shape
Out[13]:
(99074, 334)
In [2]:
# Load schools_v2.csv (clean school data)
school_df = pd.read_csv("tempdata/schools_v2.csv")
school_df.rename(columns={"Unnamed: 0" : "rowid" }, inplace=True)
school_df.head(10)
Out[2]:
rowid
School Name
state
state_abbr
school_id_nces
agency_name
agency_id_nces
county
data_available
data_na
city
zipcode
school_type
agency_type
operational
charter_school
magnet_school
shared_time_school
location_type
title1_school_wide
title1_eligible
title1_status
latitude
longitude
school_id_state
agency_id_state
congressional_code
virtual_school
lunch_program
offered_g_lowest
offered_g_highest
offered_pk
offered_k
offered_g1
offered_g2
offered_g3
offered_g4
offered_g5
offered_g6
offered_g7
offered_g8
offered_g9
offered_g10
offered_g11
offered_g12
offered_ug
total_students
lunch_free_eligible
lunch_reduced_eligible
lunch_total_free_and_reduced
...
g10_w_m
g10_w_f
g10_hp_m
g10_hp_f
g10_mr_m
g10_mr_f
g11_an_m
g11_an_f
g11_a_m
g11_a_f
g11_h_m
g11_h_f
g11_b_m
g11_b_f
g11_w_m
g11_w_f
g11_hp_m
g11_hp_f
g11_mr_m
g11_mr_f
g12_an_m
g12_an_f
g12_a_m
g12_a_f
g12_h_m
g12_h_f
g12_b_m
g12_b_f
g12_w_m
g12_w_f
g12_hp_m
g12_hp_f
g12_mr_m
g12_mr_f
gug_an_m
gug_an_f
gug_a_m
gug_a_f
gug_h_m
gug_h_f
gug_b_m
gug_b_f
gug_w_m
gug_w_f
gug_hp_m
gug_hp_f
gug_mr_m
gug_mr_f
teacher_fulltime
pupil_teacher_ratio
0
0
EDWARD DUKE ELLINGTON @ BECKHAM
Michigan
MI
261200004838
DETROIT CITY SCHOOL DISTRICT
2612000
WAYNE COUNTY
1986-2013
NaN
DETROIT
48213
1-Regular school
1-Local school district
1-Currently operational
False
False
False
11-City: Large
True
True
5-Eligible for Title I SWP provides SWP program
42.4084
-82.9786
03737
82010
2614
False
True
Prekindergarten
8th Grade
True
True
True
True
True
True
True
True
True
True
False
False
False
False
True
697
609
0
609
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
0
0
0
0
0
0
0
0
0
0
0
0
0
0
41.00
17.00
1
1
J.M. CHICK BUCKBEE JUVENILE CENTER
West Virginia
WV
540051101159
INSTITUTIONAL EDUCATIONAL PROGRAMS
5400511
HAMPSHIRE COUNTY
2003-2013
1986-2002
AUGUSTA
26704
4-Alternative/other school
5-State-operated institution
1-Currently operational
NaN
NaN
False
42-Rural: Distant
NaN
False
6-Not eligible for either TAS or SWP
39.3013
-78.6464
34126
3400000
5402
False
True
7th Grade
12th Grade
False
False
False
False
False
False
False
False
True
True
True
True
True
True
False
15
12
0
12
...
3
0
0
0
0
0
0
0
0
0
0
0
0
0
2
0
0
0
0
0
0
0
0
0
1
0
1
0
2
0
0
0
0
0
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2.00
7.50
2
2
JAMES H. TIGER MORTON JUVENILE CENTER
West Virginia
WV
540051101146
INSTITUTIONAL EDUCATIONAL PROGRAMS
5400511
KANAWHA COUNTY
2003-2013
1986-2002
DUNBAR
25064
4-Alternative/other school
5-State-operated institution
1-Currently operational
NaN
NaN
False
41-Rural: Fringe
NaN
False
6-Not eligible for either TAS or SWP
38.3747
-81.7600
34125
3400000
5402
False
True
7th Grade
12th Grade
False
False
False
False
False
False
False
False
True
True
True
True
True
True
False
17
14
0
14
...
2
2
0
0
1
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
1
4
0
0
0
0
0
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2.00
8.50
3
3
MARY HARRIS MOTHER JONES ELEMENTARY
Maryland
MD
240051001257
PRINCE GEORGE'S COUNTY PUBLIC SCHOOLS
2400510
PRINCE GEORGE'S COUNTY
2002-2013
1986-2001
ADELPHI
20783
1-Regular school
1-Local school district
1-Currently operational
False
False
False
21-Suburb: Large
True
True
5-Eligible for Title I SWP provides SWP program
38.9999
-76.9661
161730
16
2404
False
True
Prekindergarten
6th Grade
True
True
True
True
True
True
True
True
False
False
False
False
False
False
False
1029
856
83
939
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
69.01
14.91
4
4
PEMAYETV EMAHAKV CHARTER OUR WAY SCHOOL
Florida
FL
120066004849
GLADES
1200660
GLADES COUNTY
2006-2013
1986-2005
OKEECHOBEE
34974
1-Regular school
1-Local school district
1-Currently operational
True
False
False
43-Rural: Remote
NaN
False
6-Not eligible for either TAS or SWP
27.0856
-81.0805
0056
22
1217
False
False
Kindergarten
5th Grade
False
True
True
True
True
True
True
False
False
False
False
False
False
False
False
175
0
0
0
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
29.00
6.03
5
5
WILLIAM SONNY NELSON SCHOOL
Alaska
AK
20071000465
SOUTHWEST REGION SCHOOL DISTRICT
200710
DILLINGHAM CENSUS AREA
1986-2013
NaN
EKWOK
99580
1-Regular school
1-Local school district
1-Currently operational
False
False
False
43-Rural: Remote
True
True
5-Eligible for Title I SWP provides SWP program
59.3496
-157.4768
450040
45
200
False
True
Prekindergarten
8th Grade
True
True
True
True
True
True
True
True
True
True
False
False
False
False
False
11
4
4
8
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
1.75
6.29
6
6
1 LT CHARLES W. WHITCOMB SCHOOL
Massachusetts
MA
250732002639
MARLBOROUGH
2507320
MIDDLESEX COUNTY
2008-2013
1986-2007
MARLBOROUGH
1752
1-Regular school
1-Local school district
1-Currently operational
False
NaN
False
21-Suburb: Large
True
True
5-Eligible for Title I SWP provides SWP program
42.3574
-71.5486
01700045
0170
2503
False
True
5th Grade
8th Grade
False
False
False
False
False
False
True
True
True
True
False
False
False
False
True
1365
554
133
687
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
0
0
0
0
0
0
0
0
0
0
0
0
0
0
106.33
12.84
7
7
100 BLACK MEN OF THE BAY AREA COMMUNITY
California
CA
62805013190
OAKLAND UNIFIED
628050
ALAMEDA COUNTY
2012-2013
1986-2011
OAKLAND
94607
1-Regular school
1-Local school district
1-Currently operational
False
False
NaN
11-City: Large
NaN
False
6-Not eligible for either TAS or SWP
37.7454
-122.1407
0125856
0161259
613
NaN
False
Kindergarten
12th Grade
False
True
True
True
True
True
True
True
True
True
True
True
True
True
False
103
41
6
47
...
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
7.00
14.71
8
8
1050 ADAIR CO. HIGH
Missouri
MO
290579000125
ADAIR CO. R-II
2905790
ADAIR COUNTY
1986-2013
NaN
BRASHEAR
63533
1-Regular school
1-Local school district
1-Currently operational
False
False
False
42-Rural: Distant
True
True
4-Eligible for Title I SWP provides no program
40.1497
-92.3802
1050001092
001092
2906
False
True
7th Grade
12th Grade
False
False
False
False
False
False
False
False
True
True
True
True
True
True
False
96
52
6
58
...
9
9
0
0
0
0
0
0
0
0
0
0
0
0
3
10
0
0
1
0
0
0
0
0
0
0
0
0
6
13
0
0
1
0
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
11.99
8.01
9
9
10TH STREET SCHOOL
Washington
WA
530486002475
MARYSVILLE SCHOOL DISTRICT
5304860
SNOHOMISH COUNTY
1995-2013
1986-1994
MARYSVILLE
98271
1-Regular school
1-Local school district
1-Currently operational
NaN
NaN
False
22-Suburb: Mid-size
NaN
False
6-Not eligible for either TAS or SWP
48.0619
-122.1949
1656
31025
5302
NaN
True
6th Grade
8th Grade
False
False
False
False
False
False
False
True
True
True
False
False
False
False
False
170
23
6
29
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
10 rows × 334 columns
In [3]:
print len(school_df)
df_summary = school_df.describe()
df_summary
99074
Out[3]:
rowid
school_id_nces
agency_id_nces
zipcode
latitude
longitude
congressional_code
offered_pk
offered_k
offered_g1
offered_g2
offered_g3
offered_g4
offered_g5
offered_g6
offered_g7
offered_g8
offered_g9
offered_g10
offered_g11
offered_g12
offered_ug
total_students
lunch_free_eligible
lunch_reduced_eligible
lunch_total_free_and_reduced
students_pk_k
students_g1_g8
students_g9_g12
students_pk
students_k
students_g1
students_g2
students_g3
students_g4
students_g5
students_g6
students_g7
students_g8
students_g9
students_g10
students_g11
students_g12
students_ug
students_m
students_f
students_an
students_a
students_h
students_b
...
g10_w_m
g10_w_f
g10_hp_m
g10_hp_f
g10_mr_m
g10_mr_f
g11_an_m
g11_an_f
g11_a_m
g11_a_f
g11_h_m
g11_h_f
g11_b_m
g11_b_f
g11_w_m
g11_w_f
g11_hp_m
g11_hp_f
g11_mr_m
g11_mr_f
g12_an_m
g12_an_f
g12_a_m
g12_a_f
g12_h_m
g12_h_f
g12_b_m
g12_b_f
g12_w_m
g12_w_f
g12_hp_m
g12_hp_f
g12_mr_m
g12_mr_f
gug_an_m
gug_an_f
gug_a_m
gug_a_f
gug_h_m
gug_h_f
gug_b_m
gug_b_f
gug_w_m
gug_w_f
gug_hp_m
gug_hp_f
gug_mr_m
gug_mr_f
teacher_fulltime
pupil_teacher_ratio
count
99074.000000
9.907400e+04
99074.000000
99074.000000
79897.000000
79897.000000
79897.000000
99074
99074
99074
99074
99074
99074
99074
99074
99074
99074
99074
99074
99074
99074
99074
95085.000000
93472.000000
93472.000000
93472.000000
53491.000000
77273.000000
26269.000000
28589.000000
52042.000000
52418.000000
52455.000000
52368.000000
52074.000000
50833.000000
36485.000000
30525.000000
30752.000000
25436.000000
24884.000000
24724.000000
24607.000000
12710.000000
95052.000000
95052.000000
95052.000000
95052.000000
95052.000000
95052.000000
...
24881.000000
24881.000000
24881.000000
24881.000000
24881.000000
24881.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24720.000000
24603.00000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
24603.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
12709.000000
91972.000000
90180.000000
mean
49536.500000
2.839179e+11
2839178.689848
54030.967206
38.638499
-93.354354
2686.135800
0.3005733
0.5298161
0.534015
0.5343985
0.5337425
0.5308154
0.5177544
0.3725801
0.3145326
0.315875
0.2716959
0.2687587
0.2677494
0.2665079
0.1247956
522.795152
237.596082
36.242864
273.838946
92.767755
387.410441
558.819711
39.762461
73.507379
73.970087
72.137794
71.231649
71.052483
72.563807
100.748609
122.455823
121.694719
155.930178
150.547058
142.034865
140.428008
10.070732
268.520999
254.354806
5.436024
25.263067
130.072771
81.465777
...
40.230095
38.260279
0.268277
0.252723
1.879627
1.918653
0.735922
0.714644
3.773746
3.634264
16.169013
15.765736
10.700405
10.808819
38.678762
37.225971
0.248341
0.233940
1.650485
1.716707
0.73991
0.713246
3.789497
3.656018
15.666707
15.351746
10.206763
10.518229
38.874202
37.312889
0.233386
0.231435
1.554445
1.601553
0.044299
0.027146
0.335274
0.150602
1.679755
0.816036
1.809348
0.793768
2.858289
1.413723
0.011803
0.006137
0.082697
0.042647
32.330727
18.873339
std
28600.344622
1.607975e+11
1607974.740655
28729.404055
5.218317
17.522567
1585.502684
0.4585097
0.4991127
0.4988442
0.4988179
0.4988627
0.499052
0.4996872
0.4834941
0.4643318
0.4648658
0.4448362
0.4433164
0.4427885
0.442135
0.3304887
443.622578
246.056194
48.874060
273.371272
68.525649
273.503275
697.303750
56.395698
47.682745
45.900503
44.524504
44.576988
46.098087
54.094826
107.289947
130.669922
132.114613
196.344583
186.613891
174.914354
169.092568
45.138161
225.742963
219.779652
24.347120
75.840167
234.612024
154.154596
...
55.203454
53.626485
2.621932
2.368646
4.688455
4.538950
3.398944
3.249643
14.375701
13.415633
39.712031
38.841423
23.256914
24.432999
53.317911
52.266598
2.282334
2.062832
4.033589
4.023280
3.24736
3.204820
14.244199
13.429129
37.752683
37.491811
21.683860
23.595753
52.579507
51.740630
1.937251
1.977335
3.701090
3.692454
0.396719
0.276511
2.095613
0.960903
8.640708
4.751604
11.508017
3.804646
17.096842
9.583746
0.138062
0.096166
0.476393
0.283433
25.269772
441.613918
min
0.000000
1.000020e+10
100002.000000
1001.000000
19.061200
-176.639900
101.000000
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
...
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.030000
25%
24768.250000
1.301863e+11
1301862.500000
30297.000000
35.091700
-108.813200
1206.000000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
255.000000
70.000000
10.000000
88.000000
51.000000
202.000000
70.000000
11.000000
43.000000
44.000000
43.000000
42.000000
41.000000
39.000000
25.000000
21.000000
19.000000
14.000000
17.000000
19.000000
21.000000
0.000000
131.000000
123.000000
0.000000
1.000000
9.000000
3.000000
...
2.000000
1.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
2.000000
2.000000
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
3.000000
2.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
17.000000
13.140000
50%
49536.500000
2.803405e+11
2803405.000000
55025.000000
39.111200
-87.785600
2707.000000
0
1
1
1
1
1
1
0
0
0
0
0
0
0
0
444.000000
172.000000
26.000000
206.000000
82.000000
356.000000
263.000000
28.000000
70.000000
71.000000
69.000000
68.000000
67.000000
67.000000
65.000000
72.000000
70.000000
73.000000
72.000000
69.000000
71.000000
1.000000
228.000000
215.000000
1.000000
4.000000
38.000000
17.000000
...
15.000000
14.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
2.000000
2.000000
1.000000
1.000000
15.000000
14.000000
0.000000
0.000000
0.000000
0.000000
0.00000
0.000000
0.000000
0.000000
2.000000
2.000000
1.000000
1.000000
16.000000
15.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
27.400000
15.580000
75%
74304.750000
4.208550e+11
4208550.000000
78520.000000
42.057800
-80.070900
3907.000000
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
662.000000
331.000000
48.000000
379.000000
121.000000
523.000000
807.000000
50.000000
97.000000
98.000000
96.000000
95.000000
95.000000
96.000000
136.000000
196.000000
196.000000
232.000000
221.000000
207.000000
204.000000
8.000000
340.000000
323.000000
3.000000
18.000000
144.000000
89.000000
...
58.000000
55.000000
0.000000
0.000000
2.000000
2.000000
0.000000
0.000000
2.000000
2.000000
12.000000
12.000000
9.000000
9.000000
55.000000
53.000000
0.000000
0.000000
2.000000
2.000000
0.00000
0.000000
2.000000
2.000000
12.000000
11.000000
9.000000
9.000000
55.000000
53.000000
0.000000
0.000000
1.000000
2.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
1.000000
0.000000
2.000000
1.000000
0.000000
0.000000
0.000000
0.000000
40.810000
18.470000
max
99073.000000
5.680254e+11
5680254.000000
99950.000000
71.300300
-66.989400
5600.000000
True
True
True
True
True
True
True
True
True
True
True
True
True
True
True
13300.000000
8079.000000
2595.000000
8465.000000
1809.000000
9139.000000
9650.000000
1809.000000
955.000000
874.000000
840.000000
955.000000
961.000000
1052.000000
1232.000000
1534.000000
1745.000000
3187.000000
2333.000000
2824.000000
2522.000000
2684.000000
6673.000000
7003.000000
1462.000000
3309.000000
7116.000000
5731.000000
...
726.000000
903.000000
171.000000
145.000000
381.000000
318.000000
209.000000
175.000000
469.000000
347.000000
593.000000
562.000000
430.000000
509.000000
952.000000
1192.000000
135.000000
135.000000
281.000000
238.000000
139.00000
153.000000
486.000000
348.000000
536.000000
526.000000
270.000000
332.000000
765.000000
1083.000000
115.000000
126.000000
151.000000
142.000000
17.000000
8.000000
71.000000
34.000000
330.000000
286.000000
883.000000
159.000000
1251.000000
881.000000
4.000000
4.000000
15.000000
10.000000
1702.000000
131850.000000
8 rows × 310 columns
In [4]:
# Function takes DataFrame as input and returns
# 1. DF with column_name, unique values in a column, length of unique values, perc of NaN in column values
# 2. Invalid Columns (with more than 85% NaNs)]
# 3. Indicator Columns
def df_desc(in_DF):
col_dicts = []
INVALID_COLS = []
INDICATOR_COLS = []
for col in in_DF.columns:
col_dict={}
uniq_vals=in_DF[col].unique()
l_uniq = len(uniq_vals)
l_NaN = len(in_DF[pd.isnull(school_df[col])])
l_DF = len(in_DF)
NaN_perc = l_NaN/99074.0
col_dict['col_name']=col
col_dict['col_uniqval_cnt']=l_uniq
col_dict['col_NaN_perc'] = NaN_perc
col_dict['uniq_vals'] = uniq_vals
col_dicts.append(col_dict)
if NaN_perc < .85:
if l_uniq <= 10: # Adding columns with few unique values to Indicators columns list
INDICATOR_COLS.append(col)
else: # Adding columns with high NaN % to invalid columns list
INVALID_COLS.append(col)
df_col_uv = pd.DataFrame(col_dicts).sort(['col_uniqval_cnt','col_NaN_perc'], ascending=[True, False]) #DF to store column unique value counts
return df_col_uv, INVALID_COLS,INDICATOR_COLS
In [5]:
INVALID_COLUMNS=[]
INDICATOR_COLUMNS = []
df_col_uv, INVALID_COLUMNS, INDICATOR_COLUMNS = df_desc(school_df)
df_col_uv.to_csv("tempdata/schools_cols_uniq_val.csv")
In [6]:
for index, row in df_col_uv.iterrows():
if row['col_name'] not in INVALID_COLUMNS:
print '-------------------------------------------------------------------------------------------------'
print row['col_name'], row['col_NaN_perc'], row['col_uniqval_cnt']#, row['uniq_vals']
print school_df[row['col_name']].value_counts(dropna=False)
-------------------------------------------------------------------------------------------------
offered_pk 0.0 2
False 69295
True 29779
dtype: int64
-------------------------------------------------------------------------------------------------
offered_k 0.0 2
True 52491
False 46583
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g1 0.0 2
True 52907
False 46167
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g2 0.0 2
True 52945
False 46129
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g3 0.0 2
True 52880
False 46194
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g4 0.0 2
True 52590
False 46484
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g5 0.0 2
True 51296
False 47778
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g6 0.0 2
False 62161
True 36913
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g7 0.0 2
False 67912
True 31162
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g8 0.0 2
False 67779
True 31295
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g9 0.0 2
False 72156
True 26918
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g10 0.0 2
False 72447
True 26627
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g11 0.0 2
False 72547
True 26527
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g12 0.0 2
False 72670
True 26404
dtype: int64
-------------------------------------------------------------------------------------------------
offered_ug 0.0 2
False 86710
True 12364
dtype: int64
-------------------------------------------------------------------------------------------------
title1_school_wide 0.438581262491 3
NaN 43452
True 42382
False 13240
dtype: int64
-------------------------------------------------------------------------------------------------
magnet_school 0.40554534994 3
False 56141
NaN 40179
True 2754
dtype: int64
-------------------------------------------------------------------------------------------------
virtual_school 0.328562488645 3
False 66067
NaN 32552
True 455
dtype: int64
-------------------------------------------------------------------------------------------------
shared_time_school 0.323495568969 3
False 65248
NaN 32050
True 1776
dtype: int64
-------------------------------------------------------------------------------------------------
charter_school 0.289349375214 3
False 64865
NaN 28667
True 5542
dtype: int64
-------------------------------------------------------------------------------------------------
title1_eligible 0.213769505622 3
True 55622
False 22273
NaN 21179
dtype: int64
-------------------------------------------------------------------------------------------------
lunch_program 0.19356238771 3
True 58564
False 21333
NaN 19177
dtype: int64
-------------------------------------------------------------------------------------------------
school_type 0.19356238771 5
1-Regular school 72586
NaN 19177
4-Alternative/other school 4344
2-Special education school 1743
3-Vocational school 1224
dtype: int64
-------------------------------------------------------------------------------------------------
operational 0.19356238771 6
1-Currently operational 78234
NaN 19177
3-New school 1193
5-School has changed agency 423
8-School has reopened 25
4-School was operational but not reported last year 22
dtype: int64
-------------------------------------------------------------------------------------------------
title1_status 0.213769505622 7
5-Eligible for Title I SWP provides SWP program 33435
6-Not eligible for either TAS or SWP 22273
NaN 21179
2-Eligible for Title I TAS provides TAS program 8078
4-Eligible for Title I SWP provides no program 6195
1-Eligible for Title I TAS provides no program 5162
3-Eligible for Title I SWP provides TAS program 2752
dtype: int64
-------------------------------------------------------------------------------------------------
agency_type 0.19356238771 8
1-Local school district 72283
NaN 19177
7-Charter school agency 2875
2-Local school district component of supervisory union 2509
4-Regional education services agency 1665
5-State-operated institution 472
8-Other education agency 73
3-Supervisory union administrative center 20
dtype: int64
-------------------------------------------------------------------------------------------------
pk_hp_m 0.711488382421 13
NaN 70490
0 27658
1 712
2 127
3 42
4 16
5 11
7 5
8 4
6 4
16 2
9 2
14 1
dtype: int64
-------------------------------------------------------------------------------------------------
location_type 0.19356238771 13
21-Suburb: Large 21406
NaN 19177
11-City: Large 10840
41-Rural: Fringe 8392
42-Rural: Distant 8070
43-Rural: Remote 5704
13-City: Small 5557
32-Town: Distant 4612
12-City: Mid-size 4600
33-Town: Remote 3802
22-Suburb: Mid-size 2759
31-Town: Fringe 2451
23-Suburb: Small 1704
dtype: int64
-------------------------------------------------------------------------------------------------
pk_hp_f 0.711488382421 14
NaN 70490
0 27839
1 604
2 86
3 30
4 12
5 4
12 2
8 2
11 1
10 1
9 1
7 1
6 1
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g_lowest 0.0133738417748 16
Prekindergarten 29366
Kindergarten 24325
9th Grade 16779
6th Grade 12593
7th Grade 5859
5th Grade 2688
3rd Grade 1540
NaN 1325
4th Grade 1244
1st Grade 1025
8th Grade 687
10th Grade 610
2nd Grade 608
11th Grade 213
12th Grade 140
Ungraded 72
dtype: int64
-------------------------------------------------------------------------------------------------
offered_g_highest 0.0133738417748 16
5th Grade 26970
12th Grade 26481
8th Grade 21162
6th Grade 11588
4th Grade 3985
2nd Grade 1573
3rd Grade 1523
NaN 1325
Prekindergarten 1197
9th Grade 923
7th Grade 544
Kindergarten 537
1st Grade 534
10th Grade 332
11th Grade 328
Ungraded 72
dtype: int64
-------------------------------------------------------------------------------------------------
g4_mr_f 0.474503906171 25
NaN 47011
0 27091
1 10813
2 5974
3 3580
4 1951
5 1101
6 691
7 358
8 222
9 99
10 57
11 38
12 28
14 16
13 14
16 8
15 7
17 4
20 4
19 3
30 1
18 1
24 1
52 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_mr_m 0.471526333851 25
NaN 46716
0 26236
1 10863
2 6355
3 3684
4 2198
5 1276
6 712
7 414
8 239
9 133
10 99
11 61
12 27
13 19
14 13
15 7
16 7
17 4
18 4
19 3
27 1
23 1
25 1
32 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_mr_f 0.471526333851 26
NaN 46716
0 26350
1 11092
2 6323
3 3645
4 2164
5 1141
6 688
7 386
8 210
9 158
10 73
11 49
12 26
13 16
14 11
16 7
15 6
18 3
19 3
20 2
25 1
17 1
22 1
23 1
29 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_mr_m 0.474503906171 28
NaN 47011
0 26696
1 10808
2 6189
3 3527
4 2063
5 1194
6 650
7 345
8 246
9 123
10 74
11 52
12 29
14 22
13 12
15 10
16 7
17 3
20 3
18 2
19 2
34 1
22 1
23 1
24 1
27 1
79 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_mr_m 0.487029896845 29
NaN 48252
0 27140
1 10396
2 5628
3 3154
4 1874
5 1056
6 610
7 368
8 205
9 127
10 74
11 54
12 36
13 24
15 18
14 14
16 14
19 8
18 6
20 4
17 3
21 2
23 2
46 1
22 1
29 1
38 1
87 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_mr_f 0.471021660577 29
NaN 46666
0 24608
1 10656
2 6639
3 4156
4 2504
5 1518
6 863
7 536
8 339
9 203
10 136
11 66
12 59
14 33
13 25
15 18
16 12
17 9
22 5
18 4
19 4
23 4
24 4
20 3
29 1
26 1
27 1
53 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_mr_m 0.470648202354 29
NaN 46629
0 24848
1 11080
2 6564
3 3923
4 2441
5 1431
6 853
7 493
8 318
9 165
10 112
11 68
12 50
13 27
14 19
15 17
16 11
17 7
20 4
18 3
21 3
19 2
29 1
22 1
23 1
25 1
26 1
55 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_mr_f 0.487029896845 30
NaN 48252
0 27442
1 10147
2 5688
3 3262
4 1867
5 976
6 573
7 335
8 186
9 111
10 72
11 59
12 25
13 21
16 14
14 9
15 9
17 5
21 4
18 3
19 3
20 3
27 2
56 1
22 1
23 1
25 1
42 1
66 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_mr_m 0.471021660577 30
NaN 46666
0 24073
1 10918
2 6534
3 4132
4 2525
5 1593
6 964
7 587
8 349
9 248
10 143
11 111
12 66
13 55
14 33
15 24
16 14
19 9
18 6
17 5
20 5
21 4
22 3
27 2
34 1
24 1
29 1
32 1
78 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_mr_f 0.470648202354 30
NaN 46629
0 25464
1 10819
2 6548
3 3959
4 2322
5 1331
6 746
7 471
8 303
9 162
10 116
11 64
12 50
13 26
14 14
15 14
16 11
18 10
19 3
17 2
20 2
34 1
21 1
22 1
23 1
24 1
25 1
32 1
68 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_hp_f 0.471021660577 32
0 48705
NaN 46666
1 2782
2 489
3 154
4 64
5 48
6 26
7 20
8 14
9 14
12 10
10 10
11 10
15 9
13 9
19 8
16 6
14 5
21 4
17 3
23 3
27 3
20 2
31 2
37 2
39 1
22 1
24 1
30 1
32 1
53 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_mr_f 0.711488382421 34
NaN 70490
0 20550
1 4442
2 1687
3 814
4 404
5 249
6 149
7 68
8 44
9 34
10 26
12 25
11 24
13 15
15 12
16 7
14 6
17 3
19 3
20 3
28 3
24 2
29 2
23 2
22 2
39 1
27 1
21 1
18 1
30 1
32 1
34 1
53 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_hp_f 0.470648202354 35
0 48840
NaN 46629
1 2751
2 459
3 154
4 49
5 34
7 25
6 20
8 17
9 12
10 11
12 11
13 10
11 8
16 6
20 5
15 5
25 4
14 3
31 3
30 2
17 2
19 2
18 2
23 1
24 1
39 1
26 1
27 1
29 1
34 1
35 1
36 1
40 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_mr_m 0.711488382421 36
NaN 70490
0 19494
1 4861
2 1996
3 931
4 485
5 274
6 161
7 101
8 70
9 33
10 32
11 29
13 28
12 13
14 12
15 10
17 9
16 8
18 6
21 4
20 3
24 3
25 3
41 2
33 2
19 2
26 2
35 2
30 2
34 1
27 1
32 1
31 1
28 1
51 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_hp_m 0.470648202354 37
0 48827
NaN 46629
1 2734
2 449
3 146
4 74
5 38
6 23
8 19
7 14
10 13
9 12
11 12
14 11
12 10
15 8
13 8
18 7
19 5
17 4
20 4
24 4
21 3
27 3
22 2
25 2
30 2
37 2
16 1
35 1
38 1
36 1
28 1
33 1
32 1
40 1
41 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_hp_m 0.474826897067 38
0 48408
NaN 47043
1 2700
2 492
3 145
4 72
5 41
6 25
7 19
8 15
10 13
9 11
13 10
15 10
18 9
12 9
14 7
16 6
27 6
17 4
33 4
22 3
11 3
21 2
34 2
32 2
28 2
36 1
29 1
35 1
31 1
26 1
19 1
25 1
24 1
23 1
20 1
46 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_hp_f 0.474503906171 38
0 48689
NaN 47011
1 2546
2 435
3 125
4 51
5 40
6 26
9 20
10 13
16 12
7 11
14 11
11 10
8 8
12 7
17 7
20 6
25 4
15 4
21 4
31 4
18 3
38 3
28 3
27 3
19 3
24 3
26 2
22 2
23 1
30 1
13 1
32 1
34 1
37 1
43 1
53 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_an_f 0.711488382421 39
NaN 70490
0 26100
1 1512
2 346
3 153
4 103
5 76
6 48
7 43
8 39
9 31
10 22
11 17
12 11
13 11
15 9
20 6
19 6
14 6
17 5
16 5
22 4
18 3
21 3
24 3
34 3
38 3
23 2
27 2
42 2
48 2
57 1
25 1
26 1
28 1
30 1
31 1
40 1
84 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_mr_f 0.631830752771 39
NaN 62598
0 20722
1 5878
2 3063
3 1909
4 1264
5 925
6 664
7 519
8 400
9 276
10 192
11 161
12 115
13 91
14 70
15 46
17 38
16 36
18 20
20 17
19 16
21 10
23 10
22 7
26 6
31 3
25 2
27 2
30 2
32 2
45 2
35 2
47 1
41 1
29 1
38 1
33 1
68 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_hp_f 0.474826897067 39
0 48475
NaN 47043
1 2675
2 476
3 133
4 73
5 36
6 31
7 19
8 15
10 15
15 10
11 8
12 8
9 7
13 7
14 7
18 4
20 4
16 3
19 2
23 2
29 2
24 2
26 2
21 2
22 1
25 1
48 1
27 1
17 1
30 1
31 1
32 1
33 1
35 1
40 1
47 1
54 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_hp_m 0.471021660577 39
0 48689
NaN 46666
1 2743
2 505
3 177
4 89
5 40
6 23
7 17
8 16
9 12
11 12
10 11
13 11
12 8
21 8
14 7
17 5
15 4
16 3
18 3
23 3
24 3
22 2
26 2
19 2
45 1
37 1
43 1
42 1
39 1
38 1
30 1
34 1
31 1
28 1
27 1
20 1
47 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_mr_m 0.691967620163 40
NaN 68556
0 17003
1 4582
2 2406
3 1556
4 1107
5 854
6 663
7 521
8 362
9 321
10 252
11 203
12 153
13 109
14 83
15 64
16 60
17 40
19 32
18 30
21 19
20 18
26 13
22 11
25 10
24 9
23 8
27 6
29 4
28 3
36 3
34 2
35 2
37 2
31 2
30 2
33 1
32 1
41 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_mr_m 0.474826897067 40
NaN 47043
0 23740
1 10493
2 6507
3 4138
4 2547
5 1675
6 989
7 644
8 456
9 253
10 170
11 121
12 76
13 53
14 29
15 27
16 20
18 18
17 13
19 9
20 8
21 8
23 4
24 4
25 4
28 3
31 3
27 3
26 3
22 3
29 2
72 1
32 1
34 1
38 1
39 1
45 1
48 1
78 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_mr_f 0.474826897067 40
NaN 47043
0 24326
1 10615
2 6458
3 4094
4 2447
5 1522
6 929
7 563
8 321
9 241
10 148
11 92
12 68
13 44
14 42
15 23
16 20
17 17
21 10
18 8
20 6
27 6
19 6
22 4
29 3
24 3
26 2
30 2
34 1
47 1
41 1
37 1
35 1
69 1
33 1
31 1
25 1
23 1
76 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_hp_m 0.474503906171 40
0 48562
NaN 47011
1 2633
2 448
3 141
4 61
5 27
6 26
8 19
7 17
10 12
16 11
12 10
13 9
22 7
14 7
19 6
9 6
11 6
18 6
20 5
17 5
15 4
23 4
21 3
24 3
25 3
32 3
34 3
52 2
26 2
27 2
36 2
41 2
44 1
50 1
28 1
42 1
37 1
56 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_mr_f 0.691967620163 41
NaN 68556
0 17181
1 4475
2 2282
3 1635
4 1196
5 802
6 647
7 504
8 392
9 317
10 251
11 178
12 151
13 121
14 81
15 70
16 55
17 35
18 26
20 18
19 16
24 15
22 12
23 11
21 10
31 6
25 5
26 4
27 4
28 3
32 3
29 2
36 2
30 2
38 1
37 1
39 1
34 1
33 1
40 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_mr_f 0.689676403496 41
NaN 68329
0 17808
1 4352
2 2345
3 1556
4 1070
5 812
6 609
7 518
8 411
9 273
10 212
11 181
12 120
13 100
14 82
15 58
16 47
17 41
18 29
21 21
19 20
20 18
23 11
22 9
24 8
28 5
26 4
34 3
25 3
27 3
30 3
46 2
43 2
29 2
33 2
35 1
36 1
38 1
40 1
51 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_mr_m 0.631830752771 41
NaN 62598
0 20502
1 6012
2 3084
3 1887
4 1297
5 910
6 681
7 549
8 379
9 274
10 182
11 169
12 109
13 92
14 77
15 60
16 49
17 34
18 26
19 26
21 16
20 11
24 9
23 8
22 7
25 6
28 3
32 3
29 2
26 2
35 1
41 1
40 1
39 1
46 1
33 1
31 1
30 1
27 1
58 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_mr_m 0.689676403496 42
NaN 68329
0 17525
1 4610
2 2348
3 1525
4 1116
5 819
6 629
7 497
8 384
9 285
10 216
11 156
12 130
14 95
13 91
16 58
15 57
17 42
18 32
19 23
20 17
22 17
23 16
21 8
24 6
25 6
32 5
29 4
31 4
27 4
28 3
33 3
34 3
35 3
30 2
42 1
44 1
47 1
38 1
26 1
58 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_hp_m 0.487029896845 42
NaN 48252
0 47418
1 2530
2 441
3 151
4 58
5 32
6 27
7 18
8 18
9 16
11 12
13 12
10 10
22 7
16 7
14 6
20 6
17 6
18 5
12 5
35 4
19 3
25 3
32 3
23 2
24 2
26 2
27 2
28 2
39 2
33 2
51 1
37 1
49 1
46 1
30 1
36 1
31 1
21 1
15 1
60 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_hp_f 0.487029896845 42
NaN 48252
0 47527
1 2468
2 447
3 123
4 61
5 29
6 20
8 17
9 17
7 12
11 11
14 11
15 9
10 8
12 8
13 7
22 6
16 5
19 4
21 4
20 2
18 2
24 2
37 2
36 2
27 2
28 2
33 1
41 1
38 1
35 1
34 1
30 1
32 1
31 1
45 1
26 1
25 1
23 1
17 1
55 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_hp_f 0.471526333851 42
0 48934
NaN 46716
1 2535
2 464
3 140
4 66
5 41
6 19
7 17
13 15
11 14
8 13
10 10
14 9
9 8
12 7
20 7
15 7
18 5
26 4
23 4
22 4
17 4
29 3
30 3
16 3
19 2
21 2
24 2
28 2
31 2
43 2
51 1
25 1
27 1
33 1
34 1
35 1
36 1
38 1
47 1
54 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_an_m 0.711488382421 45
NaN 70490
0 25782
1 1682
2 405
3 171
4 97
5 96
6 60
7 52
8 47
10 27
11 27
9 18
14 14
12 14
13 12
16 11
17 9
15 8
18 7
24 5
19 4
25 3
23 3
37 3
20 3
33 3
21 2
41 2
28 2
42 1
55 1
51 1
48 1
47 1
45 1
44 1
56 1
22 1
39 1
34 1
32 1
31 1
27 1
84 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_hp_f 0.751670468539 46
NaN 74471
0 22312
1 1507
2 368
3 171
4 75
5 37
6 23
7 21
10 9
11 9
8 8
14 6
9 5
12 4
21 4
23 3
17 3
35 2
18 2
55 2
46 2
39 2
36 2
13 2
25 2
31 2
20 2
19 1
53 1
66 1
65 1
60 1
59 1
58 1
57 1
48 1
50 1
29 1
40 1
26 1
34 1
15 1
16 1
77 1
126 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_hp_m 0.471526333851 47
0 48786
NaN 46716
1 2678
2 473
3 141
4 59
5 37
6 18
7 18
8 14
11 14
10 12
15 10
12 9
9 8
16 8
17 8
19 8
23 6
21 5
18 5
14 5
27 3
13 3
41 2
24 2
31 2
20 2
36 2
29 2
30 2
60 1
57 1
25 1
26 1
28 1
33 1
34 1
35 1
37 1
39 1
40 1
43 1
45 1
50 1
51 1
22 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_hp_f 0.750489533076 48
NaN 74354
0 22460
1 1479
2 366
3 151
4 80
5 43
6 27
7 24
8 10
9 9
11 7
12 7
14 6
27 4
10 3
19 3
13 2
16 2
24 2
25 2
23 2
30 2
41 2
46 2
43 2
42 2
37 1
50 1
75 1
73 1
65 1
63 1
61 1
59 1
55 1
51 1
82 1
18 1
22 1
32 1
20 1
40 1
39 1
15 1
38 1
17 1
135 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_an_f 0.474503906171 48
NaN 47011
0 44398
1 5234
2 1019
3 406
4 215
5 145
6 116
7 78
8 74
10 51
11 40
9 40
13 30
12 22
14 22
15 21
16 20
20 16
21 11
18 11
17 10
22 9
25 7
32 7
23 6
27 6
24 5
19 5
28 5
30 5
26 4
37 3
29 3
64 2
49 2
33 2
35 2
31 2
38 1
39 1
40 1
44 1
46 1
66 1
55 1
59 1
92 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_hp_m 0.751670468539 49
NaN 74471
0 22304
1 1490
2 372
3 170
4 82
5 47
6 31
7 19
8 11
10 8
9 7
14 5
11 4
12 4
19 3
13 3
17 3
24 3
32 3
37 2
47 2
16 2
57 2
18 2
52 1
49 1
50 1
30 1
42 1
58 1
59 1
60 1
65 1
67 1
55 1
34 1
29 1
33 1
15 1
31 1
20 1
21 1
23 1
71 1
25 1
26 1
28 1
115 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_mr_f 0.751670468539 49
NaN 74471
0 14813
1 3572
2 1789
3 1019
4 655
5 533
6 425
7 330
8 273
9 220
10 176
11 144
12 113
13 87
14 72
15 64
16 55
18 45
17 39
19 27
20 22
22 21
23 18
21 14
24 12
25 9
28 6
26 5
27 4
39 4
37 4
32 3
38 3
29 3
30 3
31 3
45 3
33 3
43 2
35 2
79 1
51 1
88 1
34 1
44 1
41 1
40 1
142 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_mr_f 0.750489533076 50
NaN 74354
0 14643
1 3587
2 1765
3 1008
4 741
5 593
6 399
7 357
8 266
9 223
10 193
11 170
12 139
13 130
14 82
15 76
16 57
17 43
20 39
18 33
19 26
21 20
24 17
23 16
22 15
25 9
28 9
29 9
26 8
27 7
30 6
32 5
31 5
39 4
34 3
53 2
35 2
37 2
48 1
79 1
60 1
44 1
47 1
36 1
43 1
42 1
41 1
40 1
238 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_hp_f 0.748864485132 50
NaN 74193
0 22539
1 1523
2 387
3 152
4 95
5 45
6 29
7 19
8 11
9 8
10 6
11 5
12 5
19 4
47 3
14 3
16 3
20 2
13 2
15 2
17 2
27 2
83 2
76 2
31 2
65 2
34 2
58 2
48 2
30 1
49 1
71 1
68 1
62 1
55 1
53 1
52 1
46 1
28 1
43 1
39 1
38 1
35 1
18 1
33 1
24 1
26 1
92 1
145 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_mr_f 0.748864485132 50
NaN 74193
0 14489
1 3409
2 1748
3 1103
4 758
5 611
6 428
7 391
8 306
9 251
10 244
11 186
12 157
13 125
14 108
16 99
15 87
17 61
19 48
18 47
22 30
20 28
23 26
21 25
24 17
28 15
29 13
25 12
26 7
27 7
31 6
32 5
41 4
33 4
37 4
36 3
35 3
30 3
38 2
44 2
117 1
34 1
39 1
42 1
43 1
48 1
56 1
61 1
318 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_a_f 0.711488382421 50
NaN 70490
0 22955
1 2917
2 1021
3 528
4 322
5 201
6 127
7 99
8 80
9 58
11 37
12 33
13 30
10 28
14 20
17 16
15 15
19 13
16 11
20 7
21 6
18 6
25 6
24 6
23 5
32 5
22 3
31 3
43 2
30 2
37 2
38 2
49 2
64 1
59 1
58 1
56 1
50 1
45 1
40 1
42 1
41 1
72 1
39 1
35 1
29 1
27 1
26 1
84 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_hp_f 0.689676403496 50
NaN 68329
0 28220
1 1738
2 382
3 144
4 70
5 35
6 35
7 24
8 16
9 13
10 7
11 5
15 5
26 3
16 3
12 2
13 2
17 2
19 2
29 2
45 2
71 2
60 2
56 2
38 2
44 2
49 1
75 1
74 1
61 1
59 1
58 1
55 1
53 1
51 1
34 1
46 1
32 1
14 1
39 1
18 1
37 1
24 1
25 1
36 1
84 1
30 1
31 1
172 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_hp_m 0.631830752771 50
NaN 62598
0 33628
1 2021
2 399
3 159
4 71
5 43
10 16
7 16
6 15
11 13
9 12
13 7
8 6
15 6
17 5
24 5
14 4
12 4
16 3
23 3
29 3
20 2
22 2
53 2
27 2
33 2
35 2
37 2
57 2
19 2
90 1
89 1
28 1
65 1
64 1
63 1
60 1
56 1
55 1
51 1
50 1
49 1
44 1
43 1
40 1
36 1
34 1
32 1
26 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_hp_f 0.631830752771 50
NaN 62598
0 33684
1 1938
2 424
3 168
4 67
5 49
7 16
6 14
8 11
10 10
15 8
9 8
12 7
13 6
11 5
14 5
16 5
22 4
18 4
48 3
26 3
19 2
20 2
23 2
45 2
28 2
31 2
33 2
24 2
44 2
73 1
69 1
61 1
59 1
55 1
53 1
51 1
49 1
46 1
36 1
39 1
35 1
34 1
32 1
17 1
27 1
25 1
21 1
79 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_hp_m 0.750489533076 51
NaN 74354
0 22439
1 1486
2 364
3 147
4 91
5 43
6 25
7 20
9 18
8 13
10 9
11 6
14 5
15 5
43 3
21 3
34 3
33 2
12 2
17 2
23 2
26 2
27 2
35 2
28 1
54 1
86 1
84 1
79 1
74 1
66 1
64 1
63 1
61 1
58 1
57 1
56 1
53 1
94 1
13 1
50 1
42 1
16 1
39 1
18 1
19 1
38 1
36 1
25 1
135 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_mr_m 0.750489533076 51
NaN 74354
0 14785
1 3646
2 1685
3 1030
4 772
5 549
6 375
7 338
8 253
9 217
10 200
11 169
12 121
13 95
14 83
15 74
16 49
17 42
18 37
21 31
19 27
20 25
22 20
23 17
26 10
24 9
25 8
27 6
28 5
29 4
30 4
31 4
32 4
34 3
38 3
42 3
41 3
33 2
50 1
68 1
51 1
57 1
46 1
49 1
37 1
45 1
39 1
36 1
35 1
281 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_hp_m 0.748864485132 51
NaN 74193
0 22577
1 1445
2 392
3 153
4 83
5 60
6 48
7 26
9 11
10 10
11 7
8 6
12 5
50 4
13 3
14 3
17 3
22 3
28 2
15 2
16 2
19 2
25 2
26 2
59 2
95 2
46 2
67 2
61 1
85 1
81 1
76 1
73 1
71 1
69 1
68 1
65 1
96 1
29 1
56 1
48 1
44 1
43 1
39 1
38 1
20 1
21 1
34 1
23 1
171 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_mr_m 0.748864485132 51
NaN 74193
0 14457
1 3578
2 1733
3 1067
4 779
5 621
6 421
7 346
8 288
9 261
10 203
12 177
11 168
13 154
14 121
15 73
16 63
17 52
19 49
18 44
20 38
21 29
23 24
24 22
22 18
25 15
27 11
28 10
33 9
32 8
26 8
30 7
29 3
40 3
34 3
38 2
52 2
35 2
49 1
58 1
68 1
56 1
112 1
36 1
48 1
44 1
43 1
39 1
31 1
381 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_hp_m 0.689676403496 51
NaN 68329
0 28183
1 1717
2 387
3 174
4 92
5 33
6 27
7 26
8 20
10 9
9 7
12 6
13 5
17 5
24 4
11 3
44 3
15 3
31 2
14 2
16 2
26 2
28 2
33 2
36 2
63 2
53 2
25 1
61 1
92 1
80 1
79 1
72 1
71 1
67 1
65 1
27 1
62 1
57 1
35 1
54 1
99 1
50 1
49 1
42 1
40 1
38 1
20 1
22 1
182 1
dtype: int64
-------------------------------------------------------------------------------------------------
state 0.0 51
California 10289
Texas 9225
New York 4801
Florida 4319
Illinois 4204
Ohio 3694
Michigan 3545
Pennsylvania 3068
North Carolina 2625
New Jersey 2510
Minnesota 2430
Missouri 2410
Washington 2385
Georgia 2379
Arizona 2363
Wisconsin 2263
Virginia 2167
Indiana 1928
Massachusetts 1865
Tennessee 1855
Colorado 1832
Oklahoma 1789
Alabama 1639
Kentucky 1567
Maryland 1442
Louisiana 1412
Iowa 1382
Kansas 1346
Oregon 1246
South Carolina 1244
Connecticut 1152
Arkansas 1112
Nebraska 1102
Mississippi 1066
Utah 1012
New Mexico 881
Montana 830
West Virginia 760
Idaho 709
South Dakota 699
Nevada 664
Maine 619
Alaska 516
North Dakota 513
New Hampshire 486
Wyoming 366
Vermont 316
Rhode Island 304
Hawaii 290
District of Columbia 227
Delaware 226
dtype: int64
-------------------------------------------------------------------------------------------------
state_abbr 0.0 51
CA 10289
TX 9225
NY 4801
FL 4319
IL 4204
OH 3694
MI 3545
PA 3068
NC 2625
NJ 2510
MN 2430
MO 2410
WA 2385
GA 2379
AZ 2363
WI 2263
VA 2167
IN 1928
MA 1865
TN 1855
CO 1832
OK 1789
AL 1639
KY 1567
MD 1442
LA 1412
IA 1382
KS 1346
OR 1246
SC 1244
CT 1152
AR 1112
NE 1102
MS 1066
UT 1012
NM 881
MT 830
WV 760
ID 709
SD 699
NV 664
ME 619
AK 516
ND 513
NH 486
WY 366
VT 316
RI 304
HI 290
DC 227
DE 226
dtype: int64
-------------------------------------------------------------------------------------------------
g12_mr_m 0.751670468539 52
NaN 74471
0 14938
1 3544
2 1745
3 1078
4 696
5 500
6 402
7 318
8 250
9 201
10 174
11 147
12 105
13 87
14 85
15 51
16 41
18 34
17 32
19 21
21 20
20 19
22 17
23 12
24 12
25 12
26 10
28 7
27 6
29 5
30 4
40 4
31 3
32 3
38 2
36 2
33 2
62 1
63 1
53 1
46 1
48 1
47 1
139 1
45 1
44 1
41 1
39 1
35 1
34 1
151 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_an_f 0.471526333851 52
NaN 46716
0 44682
1 5202
2 1038
3 391
4 235
5 149
6 116
7 81
8 78
9 60
10 40
11 33
12 33
13 25
15 23
18 19
16 18
14 14
19 11
25 10
20 10
22 10
21 7
32 6
17 6
23 6
31 5
27 5
24 4
29 4
30 4
37 4
26 4
28 3
34 3
33 2
42 2
54 2
74 1
49 1
73 1
69 1
59 1
53 1
39 1
45 1
43 1
38 1
36 1
35 1
87 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_mr_m 0.743292892182 53
NaN 73641
0 14513
1 3539
2 1754
3 1140
4 815
5 604
6 476
7 402
8 375
9 272
10 238
11 219
12 150
13 134
15 120
14 116
16 82
17 62
18 59
19 46
21 43
22 37
20 33
23 25
24 25
27 23
26 19
25 17
29 15
28 13
31 10
30 7
35 6
39 5
32 5
38 5
34 4
33 3
42 3
37 3
41 2
36 2
40 2
46 2
55 1
58 1
56 1
74 1
50 1
45 1
43 1
155 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_mr_f 0.743292892182 53
NaN 73641
0 14724
1 3465
2 1679
3 1107
4 823
5 613
6 471
7 371
8 327
9 317
11 219
10 216
12 175
13 155
14 128
15 98
17 79
16 78
19 48
18 46
20 43
22 38
21 32
25 21
24 20
23 19
27 16
26 14
33 11
28 10
31 9
29 7
30 7
35 6
32 6
34 5
39 4
36 3
49 3
44 3
54 2
50 2
40 2
41 2
47 2
46 1
37 1
45 1
42 1
38 1
69 1
133 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_an_m 0.474503906171 53
NaN 47011
0 44173
1 5276
2 1152
3 396
4 224
5 149
6 128
7 89
8 72
9 61
10 47
12 34
11 31
13 27
14 21
15 20
17 16
16 13
20 13
22 10
18 10
19 10
28 10
21 10
23 8
27 7
24 7
26 5
25 4
41 3
31 3
32 3
34 3
37 3
40 2
48 2
45 2
29 2
50 2
39 2
30 2
51 1
65 1
60 1
69 1
67 1
73 1
44 1
43 1
38 1
33 1
79 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_hp_m 0.691967620163 54
NaN 68556
0 27984
1 1708
2 421
3 144
4 67
5 46
6 36
7 14
9 11
8 10
11 7
10 6
12 5
13 4
22 3
27 3
59 3
46 3
66 2
28 2
15 2
18 2
20 2
14 2
33 2
38 2
72 1
74 1
69 1
50 1
65 1
60 1
76 1
92 1
98 1
55 1
53 1
45 1
17 1
47 1
16 1
39 1
19 1
23 1
24 1
26 1
104 1
29 1
30 1
31 1
34 1
35 1
153 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_hp_f 0.691967620163 54
NaN 68556
0 28051
1 1689
2 365
3 142
4 83
6 38
5 36
7 16
8 13
9 9
10 8
12 8
11 4
13 4
14 3
41 3
26 2
46 2
15 2
43 2
39 2
17 2
20 2
31 2
23 2
16 1
18 1
21 1
129 1
27 1
28 1
97 1
85 1
82 1
74 1
69 1
66 1
61 1
60 1
59 1
57 1
55 1
54 1
51 1
48 1
47 1
45 1
40 1
38 1
36 1
33 1
100 1
29 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_an_f 0.487029896845 54
NaN 48252
0 43178
1 5089
2 1119
3 436
4 227
5 152
6 93
7 83
8 72
9 55
10 42
11 31
12 30
13 22
14 20
15 18
18 15
16 14
20 11
23 11
19 10
21 10
26 9
17 9
24 8
25 7
27 6
22 4
31 4
28 3
30 3
43 3
47 3
34 2
29 2
42 2
35 2
39 2
61 1
51 1
52 1
45 1
54 1
56 1
46 1
38 1
44 1
40 1
37 1
36 1
33 1
32 1
69 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_hp_f 0.743292892182 55
NaN 73641
0 23102
1 1508
2 365
3 166
4 100
6 43
5 28
7 19
8 18
10 12
9 7
22 5
12 5
14 4
11 4
13 3
18 3
53 2
24 2
37 2
120 2
29 1
15 1
19 1
20 1
26 1
27 1
28 1
177 1
31 1
67 1
96 1
95 1
94 1
92 1
89 1
86 1
85 1
82 1
74 1
68 1
65 1
35 1
64 1
63 1
61 1
54 1
51 1
46 1
45 1
44 1
42 1
38 1
33 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_a_m 0.711488382421 55
NaN 70490
0 22119
1 3295
2 1231
3 591
4 343
5 232
6 159
7 117
8 87
9 72
10 46
12 41
11 36
13 28
14 20
17 16
16 15
19 15
15 13
23 12
18 9
20 8
24 8
28 7
21 7
22 5
25 5
32 4
31 4
27 4
26 3
33 3
39 3
44 2
35 2
36 2
41 2
30 2
56 1
72 1
71 1
70 1
65 1
60 1
58 1
73 1
53 1
51 1
47 1
40 1
38 1
37 1
34 1
96 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_an_m 0.487029896845 55
NaN 48252
0 43033
1 5132
2 1184
3 434
4 220
5 144
6 130
7 85
9 67
8 63
10 42
11 31
12 25
14 25
13 20
16 17
15 16
17 16
19 16
18 13
20 13
21 11
25 8
22 8
24 7
26 7
30 5
38 5
27 4
23 4
29 4
34 3
28 3
31 3
37 3
32 2
36 2
56 1
59 1
60 1
77 1
61 1
54 1
68 1
55 1
40 1
52 1
47 1
44 1
43 1
41 1
35 1
33 1
79 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_an_f 0.474826897067 56
NaN 47043
0 44648
1 4949
2 991
3 399
4 233
5 143
6 125
7 81
8 63
10 46
9 44
11 38
13 33
12 29
14 22
15 19
16 16
17 16
18 16
20 10
25 10
19 9
32 8
30 8
28 8
21 6
27 6
24 6
22 5
23 4
29 4
34 4
33 3
45 3
26 2
36 2
37 2
42 2
31 2
73 1
55 1
69 1
65 1
64 1
62 1
61 1
59 1
49 1
51 1
48 1
47 1
46 1
40 1
39 1
79 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_hp_m 0.743292892182 57
NaN 73641
0 23016
1 1520
2 449
3 158
4 73
5 50
6 39
7 22
8 15
9 11
10 7
13 7
16 5
21 4
11 3
14 3
15 3
17 3
22 3
40 2
37 2
33 2
61 2
58 2
49 1
70 1
12 1
84 1
85 1
86 1
89 1
90 1
95 1
98 1
99 1
102 1
108 1
122 1
123 1
83 1
67 1
43 1
64 1
18 1
19 1
59 1
23 1
24 1
26 1
27 1
29 1
142 1
52 1
51 1
42 1
208 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_an_m 0.471526333851 57
NaN 46716
0 44579
1 5210
2 1108
3 427
4 238
5 161
6 109
7 82
8 63
10 43
11 41
9 35
12 33
13 23
15 19
17 18
14 17
18 15
19 14
23 10
16 10
21 10
20 9
27 9
26 7
24 6
32 6
22 5
28 4
25 4
29 4
33 3
35 3
36 3
30 2
38 2
47 2
45 2
41 2
40 2
34 2
31 2
37 1
42 1
44 1
46 1
80 1
49 1
50 1
52 1
54 1
61 1
66 1
67 1
75 1
82 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_an_m 0.471021660577 57
NaN 46666
0 44515
1 5221
2 1099
3 453
4 255
5 168
6 111
8 92
7 65
9 53
10 53
12 34
11 30
13 27
14 25
15 25
16 24
19 19
17 13
24 13
20 12
21 10
28 9
18 7
27 6
26 5
25 5
22 5
35 5
30 5
23 4
29 3
51 3
32 3
39 2
73 2
50 2
47 2
40 2
37 2
33 2
36 2
31 2
43 1
46 1
34 1
42 1
41 1
55 1
56 1
61 1
63 1
64 1
65 1
82 1
90 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_an_f 0.471021660577 57
NaN 46666
0 44819
1 5054
2 1072
3 414
4 220
5 149
6 127
7 93
8 69
9 59
10 43
12 33
11 27
13 26
16 23
14 17
18 17
20 15
15 13
28 12
19 12
17 10
22 9
21 8
29 7
25 6
27 5
24 4
23 4
30 3
56 3
26 3
41 2
36 2
55 2
40 2
38 2
45 2
33 2
32 2
53 1
64 1
69 1
72 1
54 1
66 1
75 1
46 1
44 1
43 1
42 1
39 1
35 1
34 1
31 1
77 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_an_m 0.470648202354 57
NaN 46629
0 44574
1 5288
2 1096
3 400
4 231
5 178
6 109
7 96
8 69
9 62
10 41
12 35
11 34
14 23
15 23
13 22
17 15
20 13
18 12
19 12
16 10
22 10
21 9
26 7
24 7
23 6
25 6
27 6
29 5
37 4
30 4
31 4
28 4
34 3
43 2
42 2
40 2
36 2
52 2
60 1
61 1
65 1
74 1
59 1
55 1
53 1
83 1
50 1
49 1
48 1
46 1
39 1
35 1
33 1
32 1
93 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_an_f 0.470648202354 57
NaN 46629
0 44839
1 5170
2 1033
3 389
4 212
5 149
6 105
7 98
8 64
9 53
10 40
11 38
12 27
13 23
15 21
14 20
16 16
18 15
19 15
17 12
20 10
22 8
23 8
24 8
28 6
21 6
27 6
29 5
26 5
35 4
30 4
31 3
34 3
39 2
52 2
53 2
42 2
40 2
48 2
25 2
55 1
54 1
56 1
57 1
58 1
51 1
74 1
47 1
46 1
43 1
38 1
37 1
36 1
33 1
32 1
79 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_an_m 0.474826897067 58
NaN 47043
0 44340
1 5082
2 1095
3 425
4 253
5 145
6 112
7 89
8 68
9 52
10 40
12 37
11 36
13 27
15 20
14 18
16 18
17 16
18 16
19 15
21 12
27 12
22 10
26 8
29 7
23 7
30 6
20 6
32 5
25 5
24 5
40 4
36 4
34 4
28 4
35 3
55 2
39 2
31 2
59 2
78 1
75 1
73 1
68 1
64 1
60 1
56 1
33 1
52 1
51 1
47 1
46 1
45 1
44 1
42 1
86 1
91 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_an_f 0.751670468539 60
NaN 74471
0 18742
1 3292
2 1091
3 444
4 270
5 147
6 94
7 92
8 61
11 49
10 42
9 38
12 28
13 28
14 18
17 15
19 11
20 11
26 10
15 10
16 10
18 9
23 8
21 7
28 6
27 5
24 5
30 4
34 4
22 4
31 4
42 3
29 3
68 3
35 3
33 2
52 2
50 2
45 2
38 2
36 2
25 2
64 2
76 1
85 1
67 1
74 1
73 1
71 1
88 1
47 1
59 1
57 1
53 1
48 1
43 1
40 1
98 1
153 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_an_f 0.691967620163 60
NaN 68556
0 24189
1 3731
2 1097
3 443
4 208
5 138
6 108
7 98
8 78
10 49
9 43
11 35
12 35
13 29
14 26
15 25
17 22
18 14
20 13
19 12
16 9
26 9
28 9
21 9
22 8
23 8
24 6
37 5
47 4
34 4
44 4
36 4
25 4
29 3
31 3
32 3
51 3
75 2
45 2
55 2
49 2
39 2
30 2
41 2
42 2
105 1
59 1
85 1
88 1
91 1
74 1
46 1
58 1
57 1
40 1
38 1
35 1
33 1
119 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_an_m 0.631830752771 60
NaN 62598
0 29467
1 4313
2 1210
3 458
4 179
5 139
6 119
7 95
8 64
9 58
10 49
11 42
12 34
14 23
13 23
16 20
15 16
20 15
19 14
17 12
21 10
18 9
23 7
26 7
22 6
24 6
25 6
27 5
36 5
28 4
45 4
29 4
30 4
31 4
33 4
35 4
39 4
32 3
37 3
38 3
65 2
71 2
46 2
40 2
42 2
75 1
77 1
69 1
59 1
60 1
82 1
58 1
56 1
51 1
48 1
47 1
44 1
41 1
85 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_an_f 0.750489533076 62
NaN 74354
0 18866
1 3261
2 1078
3 487
4 251
5 167
6 112
7 74
8 55
9 45
10 41
11 31
12 26
13 23
14 22
17 17
15 16
19 14
18 12
20 11
16 9
25 8
26 8
28 7
21 7
23 7
22 4
29 4
34 4
...
31 3
47 3
27 3
33 2
30 2
24 2
54 2
36 2
37 2
32 2
60 2
66 2
69 1
81 1
73 1
79 1
82 1
89 1
65 1
53 1
58 1
55 1
52 1
50 1
44 1
42 1
41 1
103 1
35 1
175 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_an_f 0.631830752771 62
NaN 62598
0 29673
1 4232
2 1097
3 425
4 229
5 144
6 116
7 92
8 51
9 46
11 39
12 34
10 34
13 31
14 25
16 20
15 19
17 16
19 16
18 14
24 13
21 12
22 11
20 10
23 8
27 6
25 5
26 4
29 4
...
33 4
37 3
32 3
30 2
38 2
34 2
31 2
28 2
55 1
84 1
78 1
73 1
71 1
69 1
67 1
60 1
59 1
57 1
48 1
53 1
52 1
51 1
50 1
91 1
47 1
46 1
41 1
40 1
39 1
101 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_an_m 0.750489533076 63
NaN 74354
0 18743
1 3332
2 1081
3 492
4 261
5 162
6 123
7 87
8 66
9 53
10 42
11 29
12 25
13 24
16 18
15 18
17 17
18 16
20 10
23 10
19 9
14 8
25 7
22 6
33 5
24 5
38 5
34 4
37 4
...
46 3
29 3
28 3
39 3
47 3
30 2
41 2
42 2
44 2
32 2
58 2
104 1
63 1
102 1
94 1
91 1
78 1
73 1
70 1
67 1
55 1
62 1
54 1
53 1
51 1
50 1
43 1
40 1
35 1
209 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_an_f 0.689676403496 63
NaN 68329
0 24232
1 3827
2 1185
3 459
4 216
5 146
6 92
7 90
8 59
9 58
10 42
14 35
11 34
13 30
15 27
12 26
16 22
20 17
17 14
19 14
18 11
24 8
21 7
25 6
23 6
26 5
27 5
22 5
34 5
...
28 4
31 3
33 3
38 3
39 3
41 2
32 2
35 2
36 2
40 2
53 2
43 2
46 2
47 2
79 1
72 1
73 1
30 1
89 1
62 1
91 1
64 1
49 1
56 1
54 1
51 1
50 1
113 1
37 1
131 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_an_m 0.751670468539 64
NaN 74471
0 18607
1 3254
2 1175
3 505
4 250
5 153
6 128
7 81
8 67
9 48
11 39
10 38
12 35
13 30
15 16
17 15
16 15
14 14
18 13
22 10
19 8
25 8
21 7
28 7
20 6
24 6
27 6
23 5
26 4
...
42 2
33 2
34 2
72 2
38 2
40 2
41 2
31 2
43 2
44 2
49 2
78 1
68 1
71 1
104 1
61 1
87 1
97 1
100 1
66 1
53 1
59 1
57 1
56 1
55 1
52 1
37 1
36 1
35 1
139 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_an_f 0.748864485132 64
NaN 74193
0 18850
1 3307
2 1106
3 499
4 252
5 177
6 129
7 82
8 57
10 50
11 39
9 34
14 33
13 26
12 24
16 24
15 17
19 17
17 15
20 13
18 11
23 9
28 9
21 8
24 6
25 6
33 6
32 6
37 5
...
29 3
49 3
73 3
22 3
43 3
69 2
62 2
54 2
51 2
44 2
27 2
45 1
34 1
100 1
94 1
90 1
88 1
84 1
82 1
77 1
38 1
46 1
58 1
57 1
41 1
52 1
137 1
50 1
48 1
204 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_an_m 0.691967620163 64
NaN 68556
0 24014
1 3784
2 1142
3 474
4 235
5 147
7 99
6 94
8 68
9 49
10 43
11 43
12 35
14 33
15 32
13 24
19 20
16 19
17 16
21 13
18 12
22 11
38 8
20 7
24 7
27 7
25 6
29 5
23 5
...
33 4
26 4
36 4
51 3
35 3
53 2
42 2
58 2
57 2
37 2
82 1
80 1
75 1
61 1
59 1
88 1
94 1
83 1
46 1
55 1
54 1
50 1
99 1
44 1
43 1
40 1
39 1
34 1
28 1
135 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_an_m 0.689676403496 66
NaN 68329
0 24119
1 3875
2 1154
3 491
4 241
5 163
6 110
7 75
8 69
9 54
10 39
12 38
11 35
13 28
16 27
14 24
19 22
15 19
18 16
20 13
17 11
23 11
25 11
21 9
27 7
22 6
28 5
33 4
24 4
...
32 3
50 3
36 3
29 3
58 2
86 2
66 2
52 2
37 2
108 1
101 1
71 1
69 1
67 1
64 1
61 1
59 1
56 1
57 1
55 1
51 1
110 1
48 1
47 1
46 1
43 1
30 1
40 1
35 1
149 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_an_m 0.748864485132 69
NaN 74193
0 18658
1 3316
2 1191
3 519
4 308
5 177
6 110
7 93
8 66
9 55
10 46
11 39
12 25
14 23
15 22
13 20
16 19
20 18
21 17
18 16
17 13
23 10
22 9
24 8
26 8
19 7
36 7
29 7
31 6
...
35 3
37 2
41 2
49 2
73 2
66 2
62 1
105 1
104 1
97 1
95 1
92 1
79 1
74 1
70 1
68 1
59 1
60 1
39 1
58 1
116 1
55 1
54 1
53 1
50 1
48 1
44 1
43 1
42 1
198 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_an_f 0.743292892182 72
NaN 73641
0 19431
1 3220
2 1140
3 486
4 272
5 153
6 100
7 90
8 77
10 52
9 44
11 37
12 34
14 28
13 23
15 20
16 18
18 15
17 14
22 13
23 12
20 11
21 10
25 10
19 10
30 10
24 9
27 8
45 6
...
39 2
59 2
78 2
70 2
66 2
46 2
43 2
95 1
100 1
87 1
83 1
82 1
73 1
107 1
109 1
72 1
93 1
160 1
65 1
57 1
56 1
55 1
54 1
52 1
51 1
48 1
47 1
42 1
41 1
207 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_a_f 0.474826897067 74
NaN 47043
0 31487
1 8201
2 3705
3 2174
4 1472
5 939
6 780
7 490
8 428
9 348
10 278
11 214
12 172
13 167
15 135
14 133
16 97
17 81
19 67
20 67
18 59
21 50
22 45
26 43
25 38
24 37
23 34
29 21
27 21
...
41 6
57 6
48 5
58 5
49 4
43 4
45 3
47 3
67 3
61 3
72 2
83 2
63 2
62 2
59 2
51 2
56 2
55 2
53 2
50 2
44 2
60 1
54 1
52 1
68 1
73 1
75 1
79 1
85 1
121 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_an_m 0.743292892182 78
NaN 73641
0 19062
1 3393
2 1211
3 536
4 274
5 182
6 107
8 88
7 87
9 46
10 43
11 41
12 38
13 26
14 25
15 24
18 20
16 19
17 18
21 14
20 13
23 13
24 11
19 11
26 10
22 10
25 8
29 7
28 7
...
64 2
55 2
89 1
84 1
87 1
88 1
97 1
93 1
95 1
77 1
105 1
108 1
116 1
138 1
83 1
177 1
75 1
72 1
70 1
69 1
60 1
53 1
52 1
51 1
50 1
44 1
43 1
41 1
34 1
212 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_a_f 0.487029896845 80
NaN 48252
0 29483
1 8054
2 3977
3 2398
4 1548
5 1004
6 804
7 555
8 422
9 351
10 279
11 228
12 196
13 173
15 144
14 139
16 124
17 98
18 85
19 79
20 63
21 54
24 46
22 45
25 44
23 33
28 32
26 27
27 26
...
47 6
48 6
49 6
46 6
43 5
71 3
62 3
54 3
53 3
56 2
59 2
60 2
61 2
63 2
64 2
68 2
69 2
94 1
87 1
93 1
120 1
92 1
91 1
123 1
83 1
74 1
67 1
57 1
52 1
143 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_a_m 0.474826897067 80
NaN 47043
0 31350
1 7913
2 3775
3 2175
4 1493
5 978
6 798
7 584
8 429
9 368
10 268
11 257
12 185
13 157
14 141
15 124
17 102
18 89
16 83
20 79
19 57
21 56
22 52
23 45
24 40
25 36
26 34
28 26
31 26
...
42 4
69 4
55 4
62 3
54 3
56 3
52 3
49 3
59 2
60 2
61 2
47 2
66 2
75 2
71 1
112 1
109 1
99 1
95 1
83 1
78 1
68 1
70 1
114 1
51 1
64 1
63 1
58 1
57 1
146 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_a_m 0.470648202354 80
NaN 46629
0 31322
1 8119
2 3823
3 2249
4 1527
5 1071
6 757
7 535
8 449
9 374
10 270
11 247
12 197
13 161
15 153
14 140
16 105
17 85
18 76
19 73
23 61
21 52
24 52
25 48
20 47
22 40
27 39
26 35
30 29
...
43 5
67 5
46 4
55 4
56 4
48 3
50 3
58 3
53 2
72 2
93 2
68 2
64 2
80 1
78 1
94 1
84 1
85 1
89 1
76 1
118 1
71 1
70 1
66 1
65 1
63 1
61 1
57 1
54 1
131 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_a_m 0.471526333851 81
NaN 46716
0 31046
1 8135
2 3963
3 2302
4 1490
5 1024
6 777
7 546
8 478
9 342
10 304
11 228
12 205
14 171
13 161
16 121
15 118
17 91
18 87
19 78
20 60
21 58
25 45
24 44
22 42
26 36
23 35
27 32
29 29
...
46 5
71 5
50 4
80 3
60 3
77 3
62 3
56 3
57 3
55 3
48 3
73 3
65 2
66 2
67 2
68 2
49 2
70 2
72 2
93 1
83 1
76 1
79 1
95 1
69 1
64 1
63 1
61 1
59 1
139 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_a_f 0.471526333851 81
NaN 46716
0 30856
1 8341
2 3984
3 2353
4 1509
5 1032
6 771
7 607
8 412
9 339
10 301
11 242
12 176
13 157
15 139
14 121
16 99
17 98
19 87
18 75
20 63
21 61
22 51
24 46
23 36
25 33
26 31
27 28
33 25
...
57 4
51 4
50 4
52 3
54 3
58 3
60 3
65 3
64 2
77 2
68 2
83 2
67 2
59 2
62 2
56 2
55 2
47 2
63 1
61 1
89 1
69 1
71 1
73 1
75 1
76 1
80 1
82 1
84 1
139 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_a_m 0.471021660577 81
NaN 46666
0 31521
1 7997
2 3823
3 2221
4 1445
5 1060
6 730
7 557
8 456
9 343
10 287
11 273
12 198
13 171
14 143
15 124
16 115
17 87
18 82
19 72
20 66
21 65
22 47
23 45
25 40
27 33
24 32
26 29
28 26
...
47 4
55 4
69 4
57 3
58 3
64 3
84 2
63 2
71 2
70 2
65 2
56 2
60 2
53 2
49 2
78 2
91 1
101 1
85 1
77 1
121 1
61 1
76 1
73 1
72 1
66 1
62 1
124 1
51 1
141 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_a_f 0.471021660577 81
NaN 46666
0 31426
1 8292
2 3881
3 2213
4 1476
5 1011
6 756
7 560
8 413
9 334
10 282
11 222
12 190
13 159
14 127
15 115
17 103
16 89
19 87
18 71
20 57
21 49
22 44
24 39
23 37
29 30
25 28
27 28
28 28
...
46 4
69 3
51 3
63 3
55 3
68 3
61 2
71 2
75 2
67 2
58 2
57 2
82 1
81 1
86 1
72 1
100 1
107 1
113 1
62 1
66 1
65 1
64 1
42 1
60 1
59 1
54 1
52 1
49 1
147 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_a_f 0.474503906171 83
NaN 47011
0 30198
1 8417
2 4060
3 2422
4 1542
5 1039
6 783
7 623
8 438
9 346
10 306
11 235
12 177
13 174
14 157
15 140
16 99
18 78
17 75
19 66
20 66
21 51
22 49
26 40
25 39
23 36
24 35
27 31
28 31
...
50 5
57 4
52 3
71 3
64 3
55 3
58 3
59 3
61 2
62 2
56 2
54 2
68 2
70 2
87 1
89 1
125 1
92 1
104 1
123 1
77 1
81 1
60 1
76 1
73 1
72 1
67 1
66 1
65 1
134 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_a_m 0.487029896845 84
NaN 48252
0 30041
1 7802
2 3760
3 2228
4 1532
5 1022
6 737
7 593
8 455
9 353
10 276
11 226
12 188
13 178
14 168
15 131
16 114
17 99
18 83
21 65
19 64
20 63
23 55
22 53
25 41
26 41
24 34
27 34
29 33
...
67 5
58 4
52 4
61 4
56 4
62 3
55 3
54 3
50 3
64 3
74 2
76 2
96 2
63 2
60 2
77 2
94 1
91 1
87 1
80 1
85 1
107 1
139 1
75 1
72 1
71 1
66 1
65 1
57 1
156 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_a_f 0.470648202354 84
NaN 46629
0 31161
1 8405
2 3922
3 2297
4 1529
5 991
6 765
7 545
8 405
9 369
10 283
11 223
12 182
13 151
15 131
14 121
16 94
18 91
17 90
19 55
20 54
23 46
21 43
22 41
24 40
27 39
25 30
26 29
30 29
...
63 3
58 3
53 2
71 2
51 2
50 2
66 2
89 1
85 1
80 1
79 1
78 1
77 1
75 1
74 1
73 1
72 1
68 1
69 1
55 1
67 1
65 1
64 1
114 1
62 1
61 1
60 1
57 1
52 1
134 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_a_m 0.474503906171 87
NaN 47011
0 30874
1 8150
2 3771
3 2259
4 1448
5 1075
6 775
7 586
8 461
9 380
10 327
11 231
13 182
12 166
14 137
15 136
16 107
17 105
18 76
19 72
20 72
21 63
23 53
22 52
24 42
25 40
27 34
26 30
31 25
...
53 3
72 3
58 3
49 3
70 3
68 3
71 2
69 2
65 2
82 2
62 2
60 2
52 2
104 1
89 1
107 1
81 1
87 1
83 1
92 1
61 1
79 1
78 1
76 1
73 1
66 1
64 1
63 1
139 1
158 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_b_f 0.474503906171 99
NaN 47011
0 20841
1 7061
2 3910
3 2709
4 2048
5 1667
6 1352
7 1171
8 1007
9 888
10 778
11 733
12 644
13 607
14 525
15 459
16 445
17 425
18 367
19 346
20 302
21 282
22 279
23 262
24 249
25 244
27 200
26 194
28 166
...
75 4
74 4
71 4
64 4
62 4
69 3
76 3
86 3
82 3
84 3
77 2
83 2
113 2
87 2
72 2
91 2
73 2
80 2
154 1
88 1
78 1
94 1
95 1
97 1
106 1
79 1
129 1
139 1
144 1
231 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_b_m 0.474503906171 101
NaN 47011
0 19994
1 7216
2 4015
3 2817
4 2111
5 1656
6 1368
7 1199
8 987
9 865
10 831
11 774
12 663
13 582
14 508
15 503
16 499
17 399
18 383
19 355
20 341
21 314
23 299
22 285
24 259
25 248
26 200
27 193
28 186
...
71 4
77 4
72 4
67 3
79 3
81 3
80 3
88 3
76 3
78 2
75 2
83 2
86 2
73 2
89 2
96 2
99 2
100 1
151 1
149 1
137 1
128 1
106 1
92 1
94 1
164 1
90 1
84 1
82 1
231 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_b_f 0.471526333851 101
NaN 46716
0 21063
1 7064
2 3936
3 2625
4 2052
5 1586
6 1337
7 1123
8 1064
9 886
10 802
11 720
12 653
13 594
14 505
15 479
16 436
17 435
18 386
20 337
19 330
21 321
22 312
23 259
24 258
26 223
27 223
25 212
28 166
...
68 4
79 4
80 3
92 3
69 3
71 3
70 3
83 3
86 2
85 2
94 2
84 2
73 2
82 2
81 2
139 1
167 1
114 1
175 1
106 1
111 1
108 1
189 1
99 1
95 1
91 1
78 1
77 1
75 1
244 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_b_f 0.470648202354 102
NaN 46629
0 21146
1 7156
2 3848
3 2606
4 1986
5 1625
6 1367
7 1110
8 984
9 840
10 808
11 735
12 604
13 580
14 533
15 479
16 447
17 446
18 403
19 363
20 356
22 303
21 284
23 268
24 243
25 240
26 211
28 183
27 169
...
64 4
83 3
97 3
73 3
77 3
79 3
99 2
90 2
88 2
85 2
71 2
82 2
80 2
74 2
69 2
129 1
155 1
125 1
119 1
112 1
103 1
107 1
217 1
101 1
92 1
89 1
86 1
84 1
81 1
246 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_b_m 0.471526333851 105
NaN 46716
0 20287
1 7251
2 3997
3 2709
4 2013
5 1662
6 1358
7 1238
8 976
9 911
10 832
12 645
11 626
14 586
13 556
15 511
16 487
17 432
18 389
19 354
20 325
21 325
22 291
23 264
24 258
25 241
26 239
27 197
30 194
...
76 4
78 4
90 3
80 3
89 2
111 2
85 2
77 2
81 2
70 2
122 1
155 1
183 1
106 1
99 1
104 1
103 1
102 1
101 1
192 1
96 1
95 1
92 1
91 1
87 1
86 1
84 1
79 1
73 1
231 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_b_m 0.470648202354 108
NaN 46629
0 20378
1 7244
2 4014
3 2643
4 2052
5 1646
6 1335
7 1171
8 990
9 875
10 801
11 700
12 643
13 588
14 539
15 493
16 452
17 422
18 399
19 361
21 337
20 322
22 295
23 276
24 275
25 243
27 233
26 213
30 191
...
73 3
71 3
85 3
101 3
91 2
95 2
87 2
80 2
67 2
130 1
137 1
124 1
148 1
163 1
118 1
104 1
116 1
114 1
111 1
197 1
103 1
102 1
98 1
93 1
88 1
86 1
84 1
82 1
76 1
273 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_b_f 0.471021660577 109
NaN 46666
0 21223
1 7014
2 3905
3 2552
4 1965
5 1541
6 1333
7 1141
8 970
9 886
10 765
12 639
11 632
13 555
14 490
15 479
16 457
17 420
18 386
20 344
19 326
21 317
22 304
24 265
26 244
25 240
23 240
27 223
30 190
...
81 3
74 3
101 3
86 2
119 2
117 2
114 2
76 2
91 2
93 2
73 2
77 2
78 2
87 1
116 1
167 1
165 1
138 1
122 1
121 1
79 1
89 1
113 1
107 1
202 1
105 1
83 1
84 1
92 1
265 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_b_f 0.487029896845 111
NaN 48252
0 20251
1 6955
2 3792
3 2578
4 1981
5 1567
6 1367
7 1137
8 996
9 848
10 742
11 689
12 654
13 566
14 528
15 473
16 437
17 406
19 400
18 390
20 309
21 300
23 263
22 248
25 228
24 218
26 190
27 179
28 168
...
76 3
101 2
98 2
62 2
80 2
73 2
72 2
71 2
123 2
162 1
145 1
140 1
135 1
131 1
115 1
127 1
126 1
125 1
164 1
113 1
110 1
108 1
94 1
93 1
90 1
88 1
87 1
86 1
85 1
238 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_b_m 0.471021660577 113
NaN 46666
0 20534
1 7079
2 3922
3 2643
4 1994
5 1596
6 1358
7 1105
8 964
9 881
10 783
11 722
12 598
13 574
14 544
15 488
16 426
19 390
18 378
17 375
21 314
23 314
20 312
22 303
24 266
25 258
26 235
27 226
28 200
...
98 3
97 3
93 2
106 2
104 2
73 2
99 2
87 2
88 2
129 1
126 1
199 1
145 1
155 1
156 1
166 1
177 1
115 1
116 1
84 1
112 1
108 1
103 1
94 1
89 1
86 1
85 1
83 1
81 1
247 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_b_f 0.474826897067 117
NaN 47043
0 21489
1 7055
2 3813
3 2538
4 1847
5 1522
6 1231
7 1088
8 988
9 859
10 726
11 680
12 627
14 518
13 511
16 440
15 437
17 412
18 384
20 342
19 310
21 306
22 293
23 276
24 247
25 227
26 220
28 212
27 187
...
102 2
103 2
107 2
76 2
117 2
110 1
111 1
228 1
175 1
129 1
138 1
151 1
159 1
168 1
192 1
109 1
86 1
105 1
104 1
100 1
99 1
97 1
94 1
92 1
82 1
80 1
79 1
78 1
77 1
251 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_a_f 0.631830752771 120
NaN 62598
0 22165
1 4708
2 2418
3 1412
4 998
5 722
6 598
7 424
8 346
9 310
10 273
11 231
12 184
13 166
14 134
16 110
17 103
15 91
18 87
21 75
19 70
20 65
27 43
23 42
22 41
25 40
26 37
24 33
31 30
...
150 2
76 2
81 2
135 1
119 1
113 1
118 1
117 1
116 1
155 1
149 1
145 1
115 1
114 1
177 1
185 1
107 1
105 1
98 1
97 1
96 1
93 1
89 1
87 1
79 1
77 1
70 1
69 1
60 1
204 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_b_m 0.487029896845 120
NaN 48252
0 19578
1 6821
2 4063
3 2646
4 1987
5 1620
6 1315
7 1166
8 1056
9 920
10 790
12 670
11 665
13 562
14 541
15 495
16 467
17 394
18 384
19 363
20 341
21 298
22 294
23 268
24 246
26 234
25 224
27 190
28 184
...
78 2
84 2
83 2
82 2
87 1
152 1
144 1
142 1
128 1
120 1
118 1
117 1
116 1
216 1
114 1
111 1
107 1
109 1
90 1
105 1
103 1
102 1
101 1
81 1
99 1
96 1
95 1
94 1
92 1
237 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_b_m 0.474826897067 120
NaN 47043
0 20793
1 7023
2 3913
3 2587
4 1942
5 1537
6 1308
7 1088
8 958
9 816
10 770
12 658
11 657
13 576
14 526
15 472
16 462
17 399
18 366
19 360
20 322
21 309
22 287
23 283
24 262
25 229
26 201
28 192
29 191
...
111 2
84 2
138 1
132 1
145 1
129 1
163 1
127 1
113 1
183 1
187 1
122 1
118 1
190 1
212 1
91 1
110 1
109 1
104 1
100 1
99 1
96 1
94 1
90 1
88 1
86 1
76 1
74 1
72 1
269 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_h_f 0.471526333851 122
NaN 46716
0 12982
1 6565
2 4554
3 3319
4 2643
5 2078
6 1675
7 1440
8 1268
9 1055
10 903
11 855
12 775
13 686
15 629
14 621
16 535
17 530
18 489
19 467
20 451
21 426
22 389
23 357
24 345
25 324
27 314
28 293
26 292
...
82 5
90 4
86 4
89 4
92 3
87 3
108 3
112 2
123 2
105 2
104 2
103 2
102 2
100 2
99 2
97 2
116 2
118 1
125 1
133 1
136 1
121 1
152 1
115 1
107 1
106 1
101 1
98 1
95 1
308 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_h_f 0.474503906171 123
NaN 47011
0 13342
1 6530
2 4562
3 3191
4 2602
5 2021
6 1716
7 1414
8 1212
9 1013
10 934
11 843
12 764
13 688
14 639
16 585
15 573
18 500
17 480
19 455
21 443
20 421
22 374
23 360
26 346
24 337
28 316
25 305
27 291
...
94 4
86 4
81 4
95 3
109 3
108 2
118 2
116 2
99 2
100 2
122 2
167 1
124 1
144 1
136 1
141 1
146 1
149 1
121 1
210 1
117 1
114 1
112 1
107 1
105 1
103 1
101 1
98 1
93 1
372 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_a_m 0.631830752771 126
NaN 62598
0 22454
1 4672
2 2240
3 1388
4 966
5 680
6 535
7 460
8 343
9 299
10 266
11 224
12 201
14 150
13 142
15 118
16 116
17 112
18 80
19 78
20 71
21 61
23 52
24 50
22 44
29 36
25 36
28 31
27 30
...
151 1
149 1
158 1
147 1
122 1
163 1
144 1
135 1
167 1
134 1
183 1
132 1
129 1
92 1
118 1
63 1
88 1
117 1
116 1
115 1
110 1
78 1
84 1
103 1
102 1
101 1
98 1
96 1
94 1
204 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_h_f 0.470648202354 126
NaN 46629
0 12639
1 6591
2 4445
3 3398
4 2607
5 2122
6 1748
7 1400
8 1242
9 1027
10 905
11 834
12 823
13 743
14 663
16 589
15 581
17 552
18 481
19 479
20 463
21 433
22 396
23 360
24 360
25 328
27 315
26 286
30 279
...
93 4
81 4
111 3
97 3
89 3
142 2
122 2
118 2
117 2
115 2
112 2
124 2
106 2
107 2
104 2
133 1
145 1
144 1
152 1
141 1
139 1
134 1
126 1
96 1
98 1
121 1
100 1
102 1
103 1
315 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_b_f 0.711488382421 128
NaN 70490
0 16214
1 3167
2 1621
3 1033
4 782
5 610
6 517
7 452
8 409
9 364
10 324
11 291
12 235
14 213
13 205
15 197
16 161
18 152
17 151
19 135
20 113
21 113
22 103
23 85
24 79
25 69
26 59
27 53
29 47
...
78 2
71 2
138 2
110 2
150 1
146 1
142 1
169 1
154 1
166 1
175 1
192 1
199 1
214 1
134 1
218 1
128 1
127 1
122 1
121 1
117 1
114 1
111 1
100 1
94 1
92 1
91 1
88 1
76 1
268 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_h_m 0.471526333851 128
NaN 46716
0 12497
1 6688
2 4457
3 3340
4 2542
5 2106
6 1710
7 1404
8 1255
9 1112
10 940
11 837
12 806
13 690
14 638
15 604
16 589
17 559
18 496
19 454
21 454
20 433
22 386
23 362
24 337
27 334
25 313
26 308
28 286
...
88 3
96 3
99 3
100 3
114 3
87 3
111 2
110 2
108 2
126 2
105 2
103 2
101 2
113 2
129 1
131 1
158 1
136 1
144 1
125 1
151 1
175 1
124 1
118 1
116 1
112 1
109 1
107 1
92 1
350 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_b_m 0.711488382421 131
NaN 70490
0 15171
1 3343
2 1793
3 1153
4 876
5 714
6 543
7 512
8 437
9 382
10 351
11 285
12 266
13 252
14 223
15 204
16 169
18 158
19 158
17 144
20 137
21 110
23 93
24 91
22 80
25 74
26 60
30 57
29 46
...
174 1
129 1
131 1
127 1
139 1
172 1
194 1
150 1
165 1
152 1
188 1
160 1
128 1
95 1
122 1
118 1
117 1
113 1
112 1
109 1
102 1
98 1
96 1
90 1
88 1
84 1
62 1
228 1
74 1
280 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_h_m 0.474503906171 131
NaN 47011
0 12868
1 6547
2 4485
3 3253
4 2589
5 2122
6 1696
7 1433
8 1195
9 1026
10 972
11 849
12 758
14 679
13 676
16 586
15 553
20 495
17 492
19 467
18 454
21 412
22 412
23 365
24 356
26 338
25 328
28 307
27 301
...
92 2
106 2
123 2
124 2
100 2
99 2
98 2
164 1
185 1
146 1
142 1
137 1
129 1
127 1
126 1
149 1
114 1
120 1
119 1
117 1
116 1
111 1
110 1
109 1
108 1
107 1
105 1
209 1
101 1
327 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_h_f 0.471021660577 132
NaN 46666
0 12403
1 6471
2 4314
3 3346
4 2610
5 2059
6 1686
7 1473
8 1305
9 1109
10 977
11 871
12 785
13 780
14 652
16 637
15 587
18 535
17 505
19 500
22 423
21 415
20 412
25 386
23 378
24 362
26 342
28 313
27 312
...
117 2
109 2
108 2
106 2
99 2
98 2
92 2
121 2
152 1
150 1
166 1
160 1
162 1
133 1
125 1
123 1
122 1
96 1
119 1
118 1
116 1
115 1
114 1
112 1
105 1
104 1
102 1
101 1
171 1
331 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_h_m 0.470648202354 133
NaN 46629
0 12303
1 6531
2 4453
3 3385
4 2638
5 2036
6 1649
7 1436
8 1263
9 1069
10 957
11 855
12 798
13 746
14 642
15 627
16 547
17 545
18 498
19 487
20 449
21 405
23 377
22 369
25 364
24 359
27 313
29 311
26 305
...
108 3
107 2
115 2
106 2
105 2
104 2
101 2
93 2
127 1
155 1
141 1
156 1
138 1
137 1
136 1
133 1
132 1
131 1
113 1
126 1
125 1
122 1
121 1
118 1
117 1
116 1
110 1
109 1
185 1
309 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_a_f 0.691967620163 135
NaN 68556
0 18764
1 3703
2 1722
3 1138
4 834
5 593
6 492
7 374
8 310
9 284
10 216
11 198
12 160
13 144
15 123
14 116
16 106
17 84
18 79
19 71
20 70
21 59
22 45
24 43
25 42
23 42
26 39
29 32
28 31
...
132 1
131 1
210 1
145 1
128 1
153 1
158 1
169 1
174 1
184 1
189 1
199 1
129 1
107 1
125 1
121 1
109 1
108 1
104 1
102 1
99 1
96 1
93 1
91 1
90 1
86 1
79 1
78 1
74 1
224 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_h_m 0.471021660577 138
NaN 46666
0 11938
1 6396
2 4511
3 3309
4 2576
5 2062
6 1715
7 1428
8 1246
9 1202
10 1015
11 840
12 753
13 697
15 651
14 636
16 623
17 517
18 508
19 465
20 454
21 416
23 399
22 390
24 369
26 359
25 335
28 327
29 300
...
108 2
109 2
132 1
136 1
137 1
139 1
142 1
141 1
127 1
145 1
146 1
147 1
161 1
151 1
131 1
183 1
126 1
125 1
123 1
122 1
119 1
117 1
114 1
111 1
110 1
106 1
104 1
101 1
90 1
321 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_a_f 0.689676403496 139
NaN 68329
0 19060
1 3694
2 1730
3 1095
4 787
5 599
6 458
7 366
8 327
9 250
10 238
11 195
12 173
13 139
14 139
16 114
15 108
17 86
19 78
18 70
22 60
21 59
20 56
24 43
25 42
26 41
27 39
23 37
28 36
...
136 1
208 1
148 1
149 1
182 1
203 1
156 1
158 1
159 1
195 1
169 1
177 1
90 1
120 1
129 1
127 1
123 1
122 1
118 1
113 1
74 1
110 1
109 1
213 1
75 1
101 1
99 1
96 1
93 1
233 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_w_f 0.711488382421 143
NaN 70490
0 8045
1 2846
2 1928
3 1516
4 1361
5 1199
7 1066
6 1047
8 930
9 884
10 820
11 669
12 616
13 533
14 516
15 462
16 378
17 356
18 312
19 300
20 264
21 207
22 180
23 171
24 143
26 142
25 139
27 137
30 91
...
94 2
300 1
175 1
180 1
184 1
213 1
192 1
198 1
218 1
326 1
153 1
301 1
295 1
88 1
148 1
137 1
136 1
133 1
386 1
126 1
124 1
121 1
119 1
117 1
115 1
108 1
103 1
100 1
96 1
555 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_w_f 0.471021660577 143
NaN 46666
0 6545
1 2978
2 2098
3 1783
4 1497
5 1419
6 1339
7 1285
8 1273
9 1260
11 1218
10 1176
15 1165
12 1144
16 1105
18 1099
14 1093
19 1089
21 1087
13 1085
20 1074
17 1055
23 979
22 975
25 971
24 958
26 881
28 831
29 797
...
106 3
128 3
125 3
119 2
137 2
149 2
126 2
118 2
104 2
117 2
112 2
111 2
110 2
141 2
162 1
190 1
191 1
154 1
148 1
142 1
143 1
234 1
138 1
135 1
133 1
130 1
124 1
116 1
115 1
334 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_a_m 0.691967620163 145
NaN 68556
0 19020
1 3540
2 1734
3 1109
4 798
5 549
6 503
7 365
8 305
9 249
10 202
11 187
12 171
13 153
14 147
16 96
15 88
20 86
17 82
21 69
19 66
18 61
23 54
25 51
22 48
24 41
26 39
28 37
30 32
...
156 1
158 1
166 1
171 1
173 1
175 1
194 1
203 1
212 1
189 1
106 1
131 1
108 1
221 1
70 1
94 1
95 1
100 1
101 1
103 1
110 1
130 1
112 1
114 1
115 1
117 1
120 1
127 1
128 1
237 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_h_f 0.474826897067 145
NaN 47043
0 12720
1 6442
2 4301
3 3193
4 2563
5 2085
6 1601
7 1446
8 1183
9 1123
10 953
11 867
12 784
13 753
14 632
15 558
17 553
18 528
16 516
19 462
21 434
20 408
23 377
25 365
22 361
24 360
26 333
28 313
29 301
...
110 1
210 1
169 1
184 1
187 1
190 1
218 1
214 1
154 1
225 1
233 1
245 1
252 1
167 1
148 1
96 1
111 1
147 1
144 1
138 1
134 1
103 1
131 1
128 1
104 1
106 1
270 1
118 1
117 1
322 1
dtype: int64
-------------------------------------------------------------------------------------------------
mr_m 0.0405959182026 145
0 20721
1 9982
2 7486
3 6174
4 5221
5 4513
NaN 4022
6 3992
7 3553
8 3167
9 2807
10 2557
11 2247
12 2162
13 1917
14 1763
15 1527
16 1389
17 1268
18 1098
19 1044
20 947
21 841
22 731
23 652
24 629
25 583
26 521
27 434
28 396
...
124 2
123 2
172 2
108 2
116 2
105 2
106 2
135 2
177 1
167 1
171 1
336 1
182 1
206 1
214 1
231 1
164 1
165 1
436 1
157 1
152 1
149 1
142 1
137 1
136 1
117 1
110 1
107 1
103 1
956 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_w_f 0.470648202354 148
NaN 46629
0 6644
1 3188
2 2060
3 1799
4 1538
5 1383
7 1326
6 1303
8 1268
9 1215
10 1192
12 1189
11 1173
13 1154
14 1143
18 1142
16 1113
17 1100
15 1097
19 1066
20 1045
21 1030
22 1025
23 994
24 919
25 860
26 844
27 815
28 782
...
110 2
117 2
109 2
170 2
105 2
154 1
153 1
152 1
158 1
162 1
151 1
149 1
147 1
173 1
140 1
144 1
238 1
135 1
134 1
129 1
127 1
126 1
121 1
120 1
119 1
116 1
111 1
108 1
106 1
277 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_w_f 0.471526333851 151
NaN 46716
0 6883
1 3068
2 2132
3 1724
4 1538
5 1463
6 1346
7 1312
10 1192
12 1180
11 1178
8 1177
9 1171
16 1158
15 1155
14 1155
13 1147
17 1064
19 1063
18 1046
20 1044
21 1043
23 987
22 975
24 920
25 874
27 781
26 776
28 776
...
161 2
101 2
169 2
114 2
165 1
142 1
163 1
166 1
158 1
157 1
171 1
155 1
176 1
150 1
221 1
253 1
141 1
139 1
134 1
132 1
131 1
130 1
127 1
124 1
123 1
122 1
120 1
118 1
115 1
333 1
dtype: int64
-------------------------------------------------------------------------------------------------
mr_f 0.0405959182026 151
0 21304
1 10190
2 7512
3 6077
4 5106
5 4522
NaN 4022
6 3976
7 3572
8 3191
9 2888
10 2509
11 2351
12 2020
13 1889
14 1724
15 1525
16 1356
17 1195
18 1094
19 1012
20 881
21 839
22 720
23 647
24 624
25 528
26 490
27 422
28 391
...
164 1
165 1
162 1
244 1
167 1
168 1
169 1
172 1
177 1
195 1
218 1
379 1
154 1
115 1
145 1
142 1
140 1
137 1
134 1
130 1
127 1
125 1
121 1
117 1
423 1
113 1
106 1
105 1
103 1
831 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_a_m 0.689676403496 152
NaN 68329
0 19277
1 3551
2 1791
3 1076
4 705
5 581
6 458
7 389
8 304
9 235
10 213
11 211
12 186
13 144
14 121
15 97
16 95
17 87
18 79
22 69
19 67
21 62
20 61
23 47
25 41
29 36
24 34
30 33
27 32
...
170 1
110 1
179 1
60 1
184 1
186 1
222 1
198 1
212 1
221 1
140 1
136 1
137 1
108 1
104 1
118 1
101 1
122 1
98 1
124 1
97 1
96 1
128 1
129 1
130 1
93 1
132 1
133 1
134 1
252 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_h_f 0.487029896845 152
NaN 48252
0 13487
1 6202
2 4325
3 3160
4 2370
5 1966
6 1620
7 1371
8 1160
9 1079
10 925
11 851
12 707
13 663
14 633
15 535
16 533
17 513
18 495
19 453
20 396
21 369
22 363
23 356
25 331
24 329
26 309
27 304
28 278
...
205 1
162 1
197 1
215 1
193 1
178 1
179 1
180 1
184 1
186 1
188 1
149 1
220 1
144 1
114 1
87 1
102 1
103 1
104 1
111 1
113 1
119 1
142 1
120 1
123 1
124 1
125 1
129 1
132 1
318 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_w_m 0.471021660577 152
NaN 46666
0 6006
1 2969
2 2050
3 1707
4 1499
5 1364
6 1283
7 1248
8 1232
12 1168
10 1160
17 1136
9 1135
13 1134
14 1055
18 1052
15 1050
11 1048
16 1048
20 1030
19 1029
22 992
21 982
24 952
23 948
25 921
26 880
27 859
29 826
...
102 3
114 3
150 3
110 2
141 2
139 2
134 2
152 2
129 2
111 2
125 2
115 2
122 2
179 1
198 1
167 1
165 1
164 1
156 1
249 1
254 1
149 1
145 1
143 1
138 1
137 1
132 1
126 1
120 1
397 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_w_m 0.470648202354 154
NaN 46629
0 6123
1 3046
2 2141
3 1665
4 1509
5 1409
7 1319
6 1299
8 1217
10 1207
9 1169
11 1154
12 1130
13 1084
16 1072
14 1059
17 1051
19 1046
15 1043
18 1026
22 1006
21 1003
20 1000
23 968
26 919
25 917
24 914
28 841
27 819
...
112 2
119 2
111 2
149 2
117 2
178 1
174 1
186 1
173 1
168 1
185 1
163 1
162 1
158 1
153 1
145 1
269 1
144 1
143 1
142 1
141 1
140 1
139 1
136 1
135 1
130 1
113 1
106 1
99 1
332 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_w_m 0.471526333851 156
NaN 46716
0 6235
1 3117
2 2153
3 1708
4 1554
5 1425
6 1281
7 1243
10 1201
8 1187
9 1153
11 1113
13 1112
17 1102
12 1096
18 1051
15 1051
19 1034
14 1030
16 1021
20 982
23 982
21 973
22 952
24 929
25 916
27 849
26 817
28 749
...
113 2
159 2
131 2
112 2
164 2
187 1
162 1
168 1
180 1
171 1
176 1
151 1
287 1
179 1
153 1
137 1
149 1
145 1
141 1
140 1
138 1
134 1
132 1
130 1
289 1
124 1
120 1
104 1
109 1
353 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_h_m 0.487029896845 158
NaN 48252
0 12998
1 6254
2 4318
3 3170
4 2348
5 1969
6 1679
7 1410
8 1191
9 1051
10 918
11 804
12 732
13 670
14 662
15 578
16 516
18 481
17 477
19 446
20 430
21 402
22 352
23 344
26 333
24 304
25 300
27 283
29 278
...
183 1
184 1
197 1
185 1
195 1
147 1
120 1
145 1
119 1
264 1
94 1
95 1
99 1
101 1
105 1
108 1
110 1
113 1
121 1
142 1
122 1
125 1
126 1
127 1
129 1
134 1
135 1
138 1
139 1
383 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_h_m 0.474826897067 158
NaN 47043
0 12311
1 6243
2 4231
3 3259
4 2570
5 2029
6 1681
7 1517
8 1250
9 1068
10 927
11 870
12 768
13 668
14 643
15 609
16 593
17 542
18 485
20 471
19 468
21 436
22 406
23 358
24 357
25 344
26 329
27 320
29 294
...
217 1
211 1
216 1
226 1
270 1
227 1
229 1
238 1
251 1
165 1
116 1
158 1
124 1
280 1
107 1
108 1
110 1
115 1
119 1
122 1
130 1
157 1
133 1
135 1
141 1
142 1
148 1
149 1
150 1
321 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_w_f 0.474826897067 158
NaN 47043
0 6476
1 2925
2 2103
3 1653
4 1494
5 1415
6 1336
8 1325
7 1308
9 1236
16 1232
11 1207
15 1205
14 1200
10 1191
13 1181
12 1169
19 1160
20 1160
18 1157
17 1130
22 1031
21 1023
24 984
23 970
25 910
26 901
27 880
28 798
...
142 2
141 2
140 2
129 2
117 2
153 2
135 2
218 1
211 1
159 1
165 1
170 1
188 1
194 1
196 1
161 1
248 1
152 1
150 1
145 1
138 1
131 1
128 1
127 1
124 1
123 1
120 1
118 1
110 1
356 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_a_f 0.743292892182 163
NaN 73641
0 16320
1 2749
2 1274
3 741
4 597
5 482
6 356
7 288
8 232
10 206
9 170
12 138
11 136
14 123
13 110
15 94
16 90
17 87
18 85
21 73
19 64
20 58
22 54
24 44
25 37
23 33
32 33
29 32
28 30
...
256 1
279 1
166 1
159 1
162 1
108 1
109 1
111 1
113 1
97 1
95 1
124 1
125 1
93 1
129 1
131 1
85 1
133 1
79 1
141 1
142 1
145 1
146 1
83 1
81 1
153 1
155 1
156 1
158 1
409 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_w_m 0.474826897067 163
NaN 47043
0 6045
1 2879
2 1964
3 1616
4 1424
6 1350
5 1349
8 1233
7 1233
9 1207
12 1162
10 1148
11 1130
20 1114
13 1099
18 1099
17 1094
19 1094
16 1083
15 1079
21 1031
14 1017
23 992
22 981
24 944
27 941
25 893
26 873
28 842
...
106 2
109 2
133 1
173 1
175 1
177 1
178 1
185 1
170 1
295 1
189 1
194 1
214 1
215 1
227 1
172 1
160 1
169 1
134 1
159 1
153 1
150 1
146 1
145 1
116 1
123 1
125 1
128 1
132 1
331 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_a_m 0.751670468539 166
NaN 74471
0 15181
1 2890
2 1371
3 795
4 563
5 444
6 365
7 306
8 249
9 181
11 155
10 151
12 146
13 135
14 102
15 92
16 87
18 74
17 70
19 69
20 65
22 63
23 60
21 50
25 48
24 47
26 43
27 43
32 32
...
275 1
278 1
307 1
210 1
170 1
174 1
140 1
107 1
106 1
115 1
103 1
95 1
125 1
127 1
128 1
134 1
135 1
379 1
108 1
66 1
144 1
150 1
151 1
152 1
94 1
159 1
165 1
168 1
169 1
486 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_a_f 0.748864485132 166
NaN 74193
0 15767
1 2701
2 1292
3 802
4 605
5 432
6 319
7 280
8 234
9 201
10 181
11 159
13 140
12 137
14 109
17 94
15 87
16 83
18 77
20 64
19 61
21 60
22 49
25 45
23 45
24 42
26 35
27 35
29 29
...
249 1
257 1
274 1
170 1
134 1
167 1
126 1
92 1
73 1
97 1
100 1
103 1
106 1
111 1
117 1
119 1
124 1
137 1
164 1
138 1
139 1
145 1
147 1
157 1
158 1
159 1
160 1
161 1
162 1
346 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_b_f 0.631830752771 168
NaN 62598
0 16137
1 4292
2 2289
3 1511
4 1114
5 836
6 773
7 608
8 577
9 497
10 472
11 413
12 403
13 383
14 321
16 314
15 307
17 278
18 266
19 252
20 236
21 226
22 183
23 176
24 168
25 156
26 153
27 139
28 138
...
145 2
123 2
167 2
164 1
223 1
169 1
198 1
154 1
176 1
185 1
186 1
190 1
155 1
147 1
153 1
151 1
141 1
140 1
139 1
138 1
137 1
135 1
108 1
133 1
130 1
129 1
252 1
127 1
125 1
261 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_a_f 0.751670468539 169
NaN 74471
0 15144
1 2904
2 1386
3 797
4 572
5 474
6 381
7 305
8 238
9 195
10 174
11 160
13 126
12 116
14 114
15 89
16 83
17 82
19 76
18 74
20 60
21 59
22 45
27 44
23 42
25 41
24 40
28 35
26 34
...
259 1
165 1
160 1
163 1
99 1
105 1
114 1
116 1
101 1
118 1
100 1
121 1
122 1
123 1
125 1
127 1
98 1
162 1
130 1
133 1
135 1
136 1
137 1
142 1
340 1
150 1
156 1
158 1
159 1
348 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_a_f 0.750489533076 169
NaN 74354
0 15338
1 2944
2 1309
3 772
4 574
5 436
6 368
7 302
8 274
9 203
10 176
12 140
11 132
13 131
14 124
15 106
17 76
16 72
18 70
19 69
22 57
20 52
26 46
21 46
24 44
23 41
29 37
25 37
31 34
...
269 1
172 1
166 1
168 1
140 1
105 1
121 1
100 1
123 1
124 1
128 1
129 1
96 1
135 1
136 1
95 1
91 1
167 1
142 1
144 1
145 1
80 1
148 1
149 1
152 1
156 1
157 1
158 1
165 1
347 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_b_m 0.631830752771 170
NaN 62598
0 15484
1 4455
2 2363
3 1534
4 1165
5 947
6 815
7 641
8 563
9 525
10 471
11 423
12 410
13 384
14 324
15 296
16 277
17 274
18 268
19 241
20 237
22 221
21 210
24 174
23 168
26 162
25 161
29 157
28 150
...
160 2
163 2
186 2
121 2
139 2
133 2
132 2
130 2
127 2
176 2
191 1
174 1
202 1
187 1
184 1
217 1
183 1
234 1
149 1
169 1
167 1
165 1
156 1
154 1
152 1
146 1
137 1
255 1
118 1
273 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_w_m 0.474503906171 170
NaN 47011
0 6500
1 3065
2 2141
3 1777
4 1601
5 1393
6 1290
8 1207
7 1190
9 1138
10 1110
12 1091
11 1086
14 1054
15 1019
16 1006
18 1005
20 993
13 987
17 973
21 962
19 956
23 901
22 900
24 890
26 874
25 859
27 783
29 751
...
124 2
135 2
119 2
134 2
129 2
126 2
179 1
181 1
189 1
192 1
197 1
170 1
202 1
215 1
218 1
281 1
297 1
139 1
169 1
165 1
164 1
137 1
161 1
157 1
128 1
148 1
145 1
136 1
141 1
352 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_w_f 0.474503906171 170
NaN 47011
0 7085
1 3154
2 2188
3 1665
4 1559
6 1397
5 1372
8 1246
7 1213
9 1180
11 1157
10 1156
15 1110
17 1102
13 1095
12 1093
16 1057
14 1054
18 1016
19 989
20 974
21 946
22 933
23 930
24 899
26 814
25 812
27 789
28 747
...
153 1
159 1
161 1
199 1
186 1
165 1
191 1
174 1
188 1
181 1
154 1
286 1
152 1
151 1
99 1
119 1
120 1
123 1
128 1
130 1
133 1
134 1
136 1
140 1
141 1
143 1
144 1
149 1
150 1
315 1
dtype: int64
-------------------------------------------------------------------------------------------------
hp_f 0.0405959182026 172
0 73315
1 11746
2 4171
NaN 4022
3 1910
4 1006
5 638
6 415
7 285
8 238
9 153
10 148
11 119
13 82
12 76
14 66
15 53
17 40
16 37
19 37
18 36
20 27
22 22
21 20
23 18
27 14
26 12
25 12
30 11
31 11
...
89 1
93 1
98 1
131 1
106 1
111 1
130 1
114 1
115 1
118 1
121 1
83 1
77 1
135 1
50 1
39 1
157 1
152 1
43 1
44 1
49 1
150 1
63 1
149 1
147 1
144 1
143 1
60 1
139 1
587 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_a_m 0.750489533076 174
NaN 74354
0 15470
1 2858
2 1313
3 776
4 531
5 442
6 356
7 277
8 246
9 192
10 177
11 165
12 127
13 117
16 103
14 102
15 96
17 89
18 78
20 65
19 55
22 55
21 53
23 50
24 49
25 43
26 33
27 33
32 31
...
140 1
166 1
122 1
83 1
95 1
99 1
101 1
102 1
103 1
105 1
109 1
116 1
117 1
118 1
119 1
130 1
163 1
131 1
136 1
139 1
351 1
141 1
144 1
145 1
146 1
149 1
151 1
152 1
156 1
469 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_b_f 0.691967620163 175
NaN 68556
0 13195
1 3179
2 1677
3 1245
4 886
5 696
6 603
7 538
8 450
10 401
9 399
11 380
12 345
13 304
15 282
14 278
16 266
19 231
17 229
20 226
18 223
21 208
22 193
24 177
23 174
27 153
26 145
25 141
29 138
...
126 2
141 2
146 1
122 1
245 1
214 1
203 1
197 1
196 1
190 1
189 1
185 1
182 1
177 1
254 1
172 1
167 1
144 1
123 1
134 1
136 1
160 1
157 1
137 1
154 1
152 1
142 1
150 1
149 1
268 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_a_m 0.743292892182 176
NaN 73641
0 16322
1 2709
2 1264
3 781
4 571
5 459
6 352
7 271
8 257
9 185
10 175
11 156
13 144
12 138
14 112
15 93
20 79
16 76
17 69
19 68
18 66
22 63
21 55
23 48
25 45
26 42
24 41
28 32
31 30
...
166 1
162 1
126 1
87 1
96 1
102 1
104 1
107 1
109 1
110 1
113 1
117 1
120 1
122 1
123 1
129 1
159 1
135 1
136 1
140 1
141 1
142 1
143 1
146 1
148 1
150 1
156 1
157 1
158 1
86 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_w_m 0.711488382421 176
NaN 70490
0 6726
1 2594
2 1742
3 1372
4 1300
5 1177
6 1142
7 1046
8 1010
9 902
10 892
11 795
12 668
13 632
14 589
15 516
16 479
17 430
19 393
18 364
20 299
21 260
22 249
23 221
24 215
25 176
26 157
27 144
29 134
...
357 1
358 1
360 1
361 1
394 1
188 1
144 1
176 1
140 1
89 1
110 1
112 1
115 1
123 1
125 1
126 1
131 1
134 1
141 1
174 1
142 1
415 1
149 1
150 1
151 1
156 1
159 1
166 1
169 1
801 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_h_f 0.711488382421 177
NaN 70490
0 13175
1 3830
2 2082
3 1358
4 1065
5 766
6 595
7 530
8 449
9 368
10 314
11 267
12 262
13 221
14 220
16 202
15 166
17 166
18 161
20 153
19 147
22 119
21 115
24 97
23 93
26 86
30 85
25 82
28 80
...
133 1
84 1
437 1
97 1
99 1
102 1
104 1
105 1
109 1
116 1
119 1
123 1
124 1
131 1
134 1
173 1
136 1
137 1
143 1
145 1
146 1
152 1
155 1
156 1
157 1
158 1
162 1
168 1
169 1
87 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_a_m 0.748864485132 178
NaN 74193
0 15758
1 2785
2 1250
3 791
4 552
5 384
6 351
7 277
8 248
9 215
10 187
11 162
12 139
13 131
15 111
14 101
18 82
16 73
17 72
19 69
22 50
20 49
24 47
25 47
23 45
26 44
21 43
28 39
27 35
...
67 1
118 1
116 1
85 1
324 1
157 1
100 1
102 1
106 1
108 1
109 1
110 1
123 1
112 1
127 1
128 1
130 1
131 1
132 1
139 1
141 1
142 1
143 1
144 1
150 1
151 1
152 1
155 1
156 1
466 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_b_f 0.689676403496 178
NaN 68329
0 13357
1 3342
2 1716
3 1174
4 832
5 737
6 596
7 482
8 467
10 393
9 390
11 367
12 316
13 316
16 273
15 271
14 270
17 251
18 237
19 207
21 203
20 198
22 184
23 174
25 166
24 162
26 153
27 147
28 140
...
116 2
118 2
138 2
177 1
168 1
170 1
179 1
178 1
229 1
239 1
190 1
199 1
195 1
191 1
129 1
167 1
159 1
158 1
157 1
156 1
155 1
154 1
151 1
150 1
146 1
143 1
140 1
126 1
268 1
274 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_b_m 0.691967620163 179
NaN 68556
0 12489
1 3397
2 1849
3 1219
4 1003
5 740
6 647
7 520
8 474
9 461
10 390
11 365
12 320
13 296
14 286
16 283
15 258
17 231
18 229
20 215
21 206
19 197
23 194
25 186
22 173
24 165
26 165
28 149
27 143
...
123 2
125 2
196 2
147 2
141 2
167 2
200 1
188 1
184 1
201 1
204 1
216 1
224 1
170 1
233 1
243 1
165 1
162 1
161 1
157 1
156 1
153 1
150 1
145 1
144 1
143 1
142 1
139 1
138 1
279 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_h_m 0.711488382421 183
NaN 70490
0 11921
1 3796
2 2220
3 1549
4 1110
5 899
6 754
7 594
8 485
9 395
10 347
11 335
12 268
13 265
15 226
16 211
14 200
17 181
19 177
18 164
20 139
24 130
23 127
21 123
22 117
26 99
25 97
31 82
28 81
...
189 1
188 1
477 1
94 1
100 1
105 1
107 1
113 1
117 1
121 1
123 1
128 1
129 1
135 1
137 1
138 1
140 1
143 1
146 1
149 1
151 1
159 1
166 1
168 1
169 1
171 1
178 1
183 1
186 1
561 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_b_m 0.689676403496 183
NaN 68329
0 12615
1 3480
2 1827
3 1262
4 935
5 746
6 638
7 545
8 471
9 461
10 380
11 364
12 328
13 312
15 288
14 274
17 273
16 257
18 235
20 216
19 210
21 209
23 202
22 199
24 173
26 169
25 148
28 135
27 130
...
174 1
175 1
218 1
176 1
187 1
194 1
215 1
206 1
172 1
193 1
173 1
154 1
170 1
168 1
128 1
131 1
269 1
140 1
145 1
146 1
151 1
152 1
153 1
157 1
159 1
160 1
161 1
163 1
164 1
299 1
dtype: int64
-------------------------------------------------------------------------------------------------
hp_m 0.0405959182026 183
0 73004
1 11731
2 4222
NaN 4022
3 1974
4 1070
5 691
6 437
7 299
8 234
9 176
10 144
11 106
12 96
13 83
14 82
15 44
18 42
16 36
17 36
20 25
23 24
19 23
22 23
21 22
24 18
26 16
25 14
40 11
32 10
...
131 1
81 1
82 1
91 1
94 1
184 1
95 1
124 1
101 1
113 1
114 1
118 1
139 1
142 1
143 1
68 1
145 1
146 1
153 1
60 1
158 1
164 1
167 1
169 1
170 1
172 1
42 1
176 1
178 1
631 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_f 0.470648202354 195
NaN 46629
0 1549
33 1104
30 1085
29 1056
38 1046
28 1039
34 1039
36 1032
27 1017
32 1016
25 1010
39 1000
35 995
26 993
31 990
41 970
40 961
24 957
37 955
23 942
22 918
42 907
44 888
21 883
43 880
20 850
46 830
45 821
19 800
...
148 2
203 2
155 2
348 2
163 2
192 1
189 1
345 1
205 1
208 1
210 1
215 1
231 1
236 1
350 1
144 1
186 1
184 1
183 1
181 1
177 1
173 1
170 1
169 1
168 1
165 1
164 1
161 1
149 1
394 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_w_f 0.487029896845 196
NaN 48252
0 7570
1 3062
2 2103
3 1714
4 1486
5 1365
6 1292
7 1225
8 1165
10 1164
9 1108
11 1082
13 1059
14 1052
15 1033
12 1021
16 994
19 935
18 931
20 916
17 911
21 906
22 894
23 869
24 834
25 800
26 778
27 670
29 651
...
166 2
152 2
159 2
158 2
151 2
219 1
212 1
213 1
168 1
221 1
206 1
230 1
233 1
279 1
294 1
211 1
196 1
200 1
197 1
309 1
191 1
190 1
132 1
186 1
157 1
173 1
129 1
165 1
170 1
328 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_b_m 0.751670468539 199
NaN 74471
0 10015
1 2909
2 1510
3 1002
4 782
5 580
6 514
7 469
8 403
9 335
10 276
11 264
13 248
12 247
14 235
15 206
16 190
17 174
18 174
19 152
20 151
22 140
24 132
25 126
21 123
23 123
26 118
27 115
29 113
...
206 1
209 1
185 1
213 1
238 1
227 1
236 1
189 1
174 1
184 1
163 1
137 1
256 1
133 1
148 1
152 1
156 1
159 1
162 1
166 1
181 1
167 1
168 1
170 1
171 1
173 1
177 1
179 1
180 1
270 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_f 0.471526333851 201
NaN 46716
0 1643
29 1095
26 1089
34 1081
37 1060
31 1042
30 1040
32 1036
35 1033
33 1026
27 1023
25 1014
38 1005
36 1005
24 998
23 990
28 985
39 979
22 950
40 930
42 911
41 908
44 872
43 844
21 844
46 819
20 802
45 801
18 785
...
251 1
206 1
207 1
235 1
236 1
287 1
330 1
342 1
356 1
378 1
191 1
148 1
187 1
186 1
399 1
152 1
153 1
154 1
155 1
156 1
163 1
168 1
170 1
171 1
172 1
175 1
178 1
183 1
184 1
448 1
dtype: int64
-------------------------------------------------------------------------------------------------
g2_m 0.470648202354 202
NaN 46629
0 1266
34 1040
35 1031
33 1014
37 1006
31 1001
39 996
30 993
28 992
40 988
32 984
38 984
36 975
41 967
29 951
25 933
26 931
42 930
27 905
43 900
45 872
24 863
23 859
44 837
47 833
46 818
22 816
48 810
21 773
...
168 2
204 2
161 2
163 2
345 1
229 1
238 1
241 1
217 1
363 1
214 1
210 1
209 1
288 1
228 1
397 1
200 1
198 1
194 1
192 1
190 1
186 1
181 1
180 1
175 1
174 1
172 1
156 1
146 1
446 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_f 0.471021660577 203
NaN 46666
0 1556
34 1094
36 1081
31 1054
35 1050
32 1050
33 1049
27 1047
38 1037
28 1023
30 1019
29 1004
41 999
37 995
39 982
25 974
40 951
26 951
42 934
43 907
22 904
24 903
45 885
23 867
21 826
46 812
44 809
20 793
48 792
...
151 2
160 2
199 2
165 2
167 2
351 1
242 1
240 1
323 1
214 1
213 1
311 1
376 1
193 1
218 1
388 1
192 1
188 1
185 1
184 1
183 1
179 1
178 1
177 1
169 1
164 1
163 1
162 1
156 1
400 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_b_m 0.750489533076 205
NaN 74354
0 10363
1 2799
2 1489
3 973
4 740
5 610
6 483
7 467
8 342
9 332
10 285
12 266
13 259
11 251
14 222
15 197
17 184
16 164
19 157
21 154
18 147
23 142
20 134
22 117
25 115
24 109
30 108
26 99
29 98
...
209 1
212 1
213 1
215 1
220 1
255 1
225 1
194 1
148 1
191 1
169 1
287 1
150 1
158 1
163 1
164 1
166 1
167 1
168 1
170 1
187 1
172 1
174 1
177 1
178 1
179 1
181 1
185 1
186 1
430 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_b_f 0.751670468539 212
NaN 74471
0 10938
1 2663
2 1365
3 905
4 669
5 545
6 495
7 401
8 359
9 323
10 269
12 254
11 253
13 213
14 205
15 189
16 188
17 176
18 159
19 147
20 147
23 141
21 129
24 114
27 110
29 109
25 107
22 102
34 96
...
235 1
236 1
239 1
253 1
263 1
264 1
265 1
283 1
206 1
199 1
201 1
167 1
168 1
169 1
171 1
162 1
173 1
174 1
160 1
176 1
177 1
178 1
305 1
184 1
186 1
145 1
193 1
194 1
198 1
332 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_w_m 0.487029896845 212
NaN 48252
0 6869
1 3066
2 2132
3 1722
4 1496
5 1345
6 1245
7 1223
9 1179
8 1156
10 1059
11 1025
12 1008
14 983
13 973
15 965
19 962
17 941
16 938
18 901
20 897
21 879
23 855
22 853
24 840
25 808
26 743
27 726
28 705
...
215 1
225 1
227 1
232 1
255 1
263 1
197 1
157 1
194 1
193 1
142 1
144 1
151 1
153 1
317 1
158 1
159 1
162 1
164 1
165 1
171 1
177 1
178 1
183 1
185 1
188 1
190 1
191 1
192 1
361 1
dtype: int64
-------------------------------------------------------------------------------------------------
g3_m 0.471526333851 212
NaN 46716
0 1274
34 1065
36 1035
31 1007
37 1006
29 1004
33 1002
38 993
39 992
30 987
35 983
26 975
41 974
40 974
27 955
32 943
25 942
28 931
24 910
43 899
42 891
45 867
23 846
22 843
44 841
46 841
21 830
20 783
47 740
...
206 1
408 1
208 1
381 1
214 1
198 1
348 1
316 1
223 1
217 1
164 1
195 1
176 1
435 1
168 1
169 1
170 1
171 1
153 1
151 1
179 1
165 1
145 1
183 1
184 1
188 1
189 1
190 1
192 1
507 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_f 0.474503906171 217
NaN 47011
0 1733
31 1134
27 1072
29 1068
34 1055
23 1050
32 1037
33 1033
28 1031
26 1020
37 1015
30 1007
36 1005
35 1005
24 987
38 968
25 959
39 935
41 928
40 909
22 880
42 869
43 855
21 849
44 830
20 828
46 764
19 757
18 751
...
223 1
226 1
229 1
332 1
200 1
231 1
206 1
184 1
199 1
194 1
146 1
435 1
166 1
167 1
170 1
171 1
174 1
176 1
177 1
178 1
179 1
181 1
185 1
131 1
188 1
189 1
190 1
191 1
192 1
466 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_b_f 0.750489533076 220
NaN 74354
0 11046
1 2712
2 1382
3 863
4 670
5 543
6 444
7 410
8 350
9 283
10 259
11 240
12 232
15 220
13 219
14 192
16 191
17 178
18 170
20 143
19 141
22 123
21 121
25 116
28 111
26 107
23 106
31 105
27 104
...
243 1
295 1
250 1
266 1
272 1
213 1
238 1
156 1
211 1
206 1
365 1
132 1
140 1
154 1
157 1
161 1
166 1
167 1
169 1
174 1
176 1
185 1
191 1
192 1
193 1
194 1
201 1
204 1
205 1
509 1
dtype: int64
-------------------------------------------------------------------------------------------------
g1_m 0.471021660577 220
NaN 46666
0 1311
36 1020
37 1014
35 991
40 990
38 983
31 974
34 974
33 964
39 963
32 957
43 945
27 942
29 940
44 932
30 931
28 924
41 912
42 908
24 882
45 881
26 873
23 838
25 837
47 809
48 788
21 774
46 774
50 765
...
214 1
216 1
240 1
367 1
208 1
228 1
255 1
350 1
369 1
223 1
220 1
432 1
205 1
202 1
166 1
168 1
169 1
170 1
171 1
178 1
179 1
181 1
184 1
186 1
190 1
197 1
198 1
199 1
201 1
474 1
dtype: int64
-------------------------------------------------------------------------------------------------
g4_m 0.474503906171 226
NaN 47011
0 1387
35 1032
34 1011
31 1008
39 999
38 998
26 994
32 991
33 984
37 972
36 966
41 959
29 955
28 954
27 952
30 929
40 928
25 911
42 893
24 892
22 882
45 879
43 878
44 856
23 849
21 791
20 783
46 781
48 764
...
261 1
263 1
339 1
275 1
269 1
214 1
215 1
191 1
212 1
209 1
146 1
145 1
161 1
169 1
171 1
179 1
431 1
185 1
189 1
192 1
193 1
195 1
196 1
197 1
199 1
200 1
202 1
204 1
205 1
495 1
dtype: int64
-------------------------------------------------------------------------------------------------
an_f 0.0405959182026 230
0 51024
1 18763
2 9017
3 4681
NaN 4022
4 2668
5 1686
6 1072
7 781
8 580
9 426
10 353
11 282
12 256
13 192
14 190
15 154
16 144
17 137
18 121
19 116
21 113
20 102
24 88
23 76
25 72
22 70
29 63
27 63
26 61
...
170 1
167 1
166 1
165 1
151 1
214 1
149 1
147 1
146 1
139 1
131 1
120 1
174 1
176 1
179 1
182 1
463 1
186 1
188 1
191 1
192 1
193 1
194 1
202 1
203 1
204 1
207 1
209 1
213 1
739 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_w_f 0.631830752771 231
NaN 62598
0 7020
1 2253
2 1437
3 1142
4 985
5 914
6 878
7 776
8 734
9 682
10 665
11 632
12 593
15 557
16 556
14 538
17 517
13 506
18 487
20 477
19 457
21 454
22 433
23 431
26 378
24 375
25 354
27 340
28 326
...
193 2
189 2
180 2
230 2
196 2
254 1
252 1
249 1
255 1
276 1
229 1
244 1
241 1
291 1
239 1
248 1
345 1
226 1
224 1
222 1
214 1
213 1
209 1
205 1
204 1
203 1
199 1
195 1
184 1
408 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_b_m 0.748864485132 233
NaN 74193
0 10400
1 2725
2 1486
3 988
4 706
5 579
6 478
7 418
8 385
9 317
11 294
10 286
12 224
13 214
14 206
17 191
15 184
16 178
18 167
20 146
19 132
21 127
23 126
25 121
24 116
28 112
22 103
26 103
27 102
...
283 1
281 1
250 1
251 1
224 1
225 1
189 1
222 1
196 1
147 1
161 1
162 1
172 1
178 1
443 1
185 1
187 1
142 1
197 1
219 1
200 1
206 1
207 1
210 1
213 1
214 1
215 1
216 1
218 1
778 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_f 0.474826897067 234
NaN 47043
0 1631
36 1086
29 1081
30 1079
33 1073
34 1057
32 1054
37 1052
31 1044
28 1039
27 1014
40 1009
38 999
26 997
35 989
23 981
25 964
21 945
24 939
41 927
39 909
42 904
43 897
22 889
44 864
45 840
20 813
46 794
19 779
...
333 1
340 1
365 1
367 1
230 1
222 1
228 1
226 1
173 1
168 1
184 1
188 1
190 1
159 1
192 1
196 1
158 1
199 1
205 1
208 1
209 1
211 1
213 1
214 1
216 1
218 1
219 1
177 1
223 1
464 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_b_f 0.748864485132 235
NaN 74193
0 11077
1 2695
2 1369
3 894
4 662
5 526
6 474
7 366
8 316
9 290
10 268
11 261
12 232
13 206
14 194
15 190
16 170
17 165
19 144
21 144
18 133
22 130
20 122
25 122
23 117
27 115
29 107
26 106
24 105
...
279 1
283 1
297 1
301 1
308 1
333 1
223 1
217 1
146 1
149 1
189 1
190 1
171 1
194 1
195 1
170 1
197 1
169 1
201 1
202 1
203 1
159 1
208 1
158 1
210 1
211 1
213 1
152 1
181 1
811 1
dtype: int64
-------------------------------------------------------------------------------------------------
an_m 0.0405959182026 236
0 49860
1 18998
2 9209
3 4835
NaN 4022
4 2770
5 1776
6 1182
7 728
8 630
9 453
10 365
11 331
12 264
13 242
14 210
15 163
17 143
16 143
19 132
18 114
20 106
21 104
22 87
23 83
26 78
24 77
25 63
28 63
29 63
...
148 1
147 1
146 1
144 1
138 1
137 1
136 1
128 1
123 1
119 1
530 1
177 1
186 1
189 1
211 1
229 1
227 1
226 1
225 1
218 1
217 1
210 1
193 1
209 1
205 1
204 1
200 1
197 1
195 1
723 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_h_f 0.631830752771 238
NaN 62598
0 11675
1 4052
2 2476
3 1774
4 1368
5 1183
6 915
7 892
8 777
9 619
10 574
12 546
11 525
13 440
14 407
15 369
16 359
17 315
18 296
21 285
19 277
20 266
22 245
24 234
25 213
23 206
26 188
27 186
30 178
...
267 1
236 1
269 1
286 1
288 1
292 1
328 1
338 1
349 1
239 1
223 1
233 1
163 1
185 1
184 1
182 1
197 1
199 1
201 1
204 1
209 1
227 1
210 1
211 1
213 1
217 1
162 1
186 1
401 1
421 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_h_m 0.631830752771 244
NaN 62598
0 11209
1 4126
2 2569
3 1790
4 1416
5 1113
6 997
7 917
8 733
9 643
10 641
11 526
12 446
13 423
14 406
15 405
16 338
17 336
18 318
19 317
20 296
21 262
23 250
25 241
22 237
24 187
27 183
31 182
26 178
...
265 1
242 1
286 1
295 1
309 1
338 1
341 1
342 1
360 1
280 1
231 1
164 1
215 1
201 1
202 1
203 1
190 1
207 1
210 1
214 1
218 1
175 1
177 1
223 1
224 1
225 1
226 1
228 1
229 1
412 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_w_m 0.631830752771 245
NaN 62598
0 6166
1 2369
2 1593
3 1257
4 972
5 900
6 897
7 780
8 726
9 702
10 670
11 637
12 580
16 551
13 548
14 546
18 504
15 502
19 477
20 469
17 458
21 421
22 414
24 382
23 379
25 370
27 355
26 349
29 332
...
250 1
252 1
249 1
254 1
263 1
260 1
262 1
243 1
264 1
267 1
268 1
306 1
318 1
247 1
226 1
241 1
237 1
233 1
229 1
223 1
222 1
216 1
213 1
183 1
209 1
208 1
367 1
205 1
199 1
410 1
dtype: int64
-------------------------------------------------------------------------------------------------
k_m 0.474826897067 246
NaN 47043
0 1432
33 1012
32 1004
38 993
31 987
37 978
26 970
40 969
35 965
39 958
29 952
36 950
30 932
27 932
25 924
28 919
43 917
41 915
34 890
24 869
42 863
44 861
45 842
22 825
23 807
46 804
49 794
47 761
21 759
...
338 1
329 1
246 1
388 1
239 1
237 1
160 1
173 1
179 1
181 1
185 1
189 1
192 1
195 1
200 1
203 1
205 1
207 1
208 1
209 1
212 1
214 1
215 1
216 1
217 1
222 1
223 1
228 1
231 1
491 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_w_f 0.691967620163 249
NaN 68556
0 6097
1 1982
2 1184
3 869
4 715
5 692
6 620
7 565
8 556
10 472
9 466
11 435
12 404
14 394
13 369
15 357
17 346
16 315
18 314
23 289
20 287
19 286
21 266
25 265
24 255
22 250
30 236
26 235
29 234
...
182 2
207 2
179 2
429 1
262 1
266 1
269 1
272 1
258 1
280 1
281 1
283 1
288 1
346 1
368 1
259 1
246 1
196 1
221 1
241 1
198 1
234 1
231 1
230 1
228 1
211 1
225 1
212 1
222 1
459 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_b_f 0.743292892182 250
NaN 73641
0 11625
1 2658
2 1348
3 913
4 620
5 536
6 440
7 363
8 301
10 275
9 265
11 228
13 225
12 224
14 207
15 179
16 163
18 159
17 158
19 155
21 139
20 133
26 115
23 114
25 114
28 109
22 105
24 98
31 96
...
310 1
320 1
360 1
367 1
249 1
243 1
245 1
244 1
183 1
199 1
389 1
202 1
203 1
204 1
209 1
212 1
214 1
176 1
221 1
223 1
224 1
227 1
174 1
233 1
234 1
168 1
236 1
237 1
196 1
880 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_f 0.711488382421 259
NaN 70490
0 4026
1 1349
2 942
8 905
10 887
9 880
11 878
7 820
3 805
12 769
13 766
4 728
6 726
5 723
16 716
15 688
19 684
14 676
18 672
17 666
20 588
21 571
22 521
23 478
24 449
25 387
26 358
27 329
29 314
...
177 1
176 1
170 1
169 1
165 1
157 1
153 1
150 1
146 1
137 1
729 1
198 1
199 1
200 1
231 1
254 1
249 1
247 1
246 1
244 1
241 1
223 1
201 1
214 1
211 1
206 1
205 1
204 1
202 1
128 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_mr 0.0405959182026 259
0 14849
1 7142
2 5605
3 4413
NaN 4022
4 3930
5 3535
6 3146
7 2860
8 2706
9 2429
10 2332
11 2153
12 2082
13 1945
14 1817
15 1687
16 1585
17 1541
18 1482
19 1398
20 1305
21 1289
22 1213
23 1065
24 1065
25 1008
26 972
27 926
28 880
...
475 1
759 1
265 1
202 1
253 1
247 1
815 1
165 1
169 1
184 1
185 1
195 1
197 1
199 1
200 1
207 1
213 1
215 1
216 1
218 1
220 1
223 1
224 1
227 1
238 1
241 1
243 1
244 1
245 1
1787 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_w_m 0.691967620163 261
NaN 68556
0 5346
1 2030
2 1248
3 940
4 792
5 710
6 640
7 566
8 544
9 540
11 460
10 449
12 434
13 402
14 374
16 348
15 326
18 314
17 313
22 301
20 286
19 276
21 274
24 267
23 256
26 250
29 247
27 244
25 243
...
263 1
267 1
369 1
269 1
270 1
280 1
306 1
298 1
332 1
300 1
301 1
315 1
262 1
449 1
255 1
254 1
253 1
246 1
243 1
242 1
241 1
238 1
235 1
233 1
231 1
223 1
215 1
210 1
204 1
476 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_h_f 0.691967620163 262
NaN 68556
0 10323
1 3344
2 2001
3 1400
4 1128
5 900
6 697
7 608
8 577
9 499
10 489
11 404
12 365
13 327
14 296
15 274
16 263
18 248
17 246
19 227
22 189
23 184
20 181
21 178
24 175
25 160
26 135
33 127
27 123
...
265 1
339 1
344 1
346 1
350 1
357 1
371 1
383 1
267 1
256 1
261 1
260 1
204 1
222 1
223 1
224 1
225 1
199 1
196 1
193 1
236 1
237 1
238 1
239 1
241 1
242 1
245 1
217 1
257 1
653 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_w_f 0.689676403496 263
NaN 68329
0 6255
1 2017
2 1184
3 938
4 762
5 679
6 612
8 536
9 526
7 520
10 464
11 439
12 417
13 381
14 357
16 349
15 346
18 318
19 318
17 309
20 303
21 272
23 264
27 261
24 259
22 256
26 237
28 225
29 223
...
296 1
327 1
298 1
308 1
306 1
330 1
220 1
243 1
221 1
557 1
200 1
204 1
206 1
208 1
211 1
215 1
216 1
217 1
223 1
238 1
224 1
225 1
226 1
227 1
228 1
230 1
231 1
233 1
237 1
574 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_b_m 0.743292892182 264
NaN 73641
0 10771
1 2791
2 1460
3 986
4 708
5 540
6 489
7 407
8 377
9 317
12 267
10 264
14 224
13 215
11 213
16 167
17 166
15 164
18 158
21 143
23 140
19 137
20 131
22 131
24 120
30 108
29 107
25 106
27 92
...
293 1
294 1
301 1
302 1
306 1
334 1
264 1
393 1
256 1
255 1
180 1
188 1
204 1
207 1
208 1
211 1
213 1
219 1
221 1
224 1
226 1
227 1
235 1
237 1
245 1
249 1
251 1
252 1
253 1
785 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_h_f 0.689676403496 264
NaN 68329
0 10728
1 3379
2 2034
3 1406
4 1075
5 887
6 771
7 590
8 547
9 504
10 485
11 388
13 340
12 337
14 304
15 255
17 243
16 240
18 232
19 205
20 202
21 197
23 177
24 161
25 153
22 152
26 148
28 137
27 130
...
350 1
357 1
368 1
393 1
394 1
311 1
256 1
269 1
231 1
210 1
216 1
217 1
207 1
201 1
221 1
199 1
227 1
197 1
196 1
263 1
190 1
239 1
240 1
181 1
180 1
248 1
250 1
255 1
211 1
642 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_f 0.487029896845 266
NaN 48252
0 2096
29 1039
27 1004
34 1004
31 993
26 976
36 973
32 972
24 971
28 966
25 958
30 944
39 939
38 939
37 916
33 905
35 904
23 896
22 882
40 870
41 867
21 818
1 799
20 788
43 786
44 779
19 769
42 753
46 740
...
335 1
282 1
353 1
348 1
289 1
326 1
343 1
332 1
261 1
204 1
254 1
203 1
170 1
167 1
227 1
228 1
218 1
230 1
217 1
232 1
213 1
180 1
240 1
241 1
242 1
243 1
208 1
246 1
250 1
483 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_hp 0.0405959182026 270
0 64134
1 13779
2 6020
NaN 4022
3 3088
4 1859
5 1265
6 872
7 603
8 461
9 327
10 284
11 265
12 208
13 174
14 138
15 121
16 105
17 83
19 81
18 79
21 67
20 57
22 55
23 52
24 41
27 40
29 37
26 36
28 33
...
70 1
261 1
256 1
163 1
245 1
244 1
77 1
240 1
233 1
227 1
85 1
86 1
87 1
90 1
205 1
91 1
220 1
219 1
96 1
97 1
98 1
214 1
101 1
103 1
104 1
210 1
209 1
107 1
109 1
1218 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_h_m 0.691967620163 274
NaN 68556
0 9807
1 3558
2 2095
3 1410
4 1054
5 878
6 782
7 652
8 538
9 508
10 485
11 405
12 383
13 348
15 289
14 283
16 274
17 274
18 217
19 217
20 198
21 197
22 173
24 170
23 165
26 153
25 145
28 135
27 130
...
320 1
273 1
323 1
328 1
448 1
223 1
269 1
262 1
193 1
200 1
203 1
204 1
214 1
215 1
224 1
225 1
227 1
229 1
230 1
235 1
238 1
246 1
251 1
252 1
254 1
255 1
256 1
259 1
260 1
646 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_w_m 0.689676403496 274
NaN 68329
0 5309
1 2077
2 1375
3 1019
4 826
5 675
6 669
7 618
8 568
9 516
10 466
11 447
12 428
13 388
14 356
15 352
16 330
17 322
18 312
21 290
19 289
20 269
22 269
24 265
25 250
26 243
27 237
23 236
28 233
...
313 1
322 1
357 1
365 1
375 1
392 1
264 1
262 1
261 1
260 1
230 1
523 1
232 1
226 1
235 1
236 1
225 1
223 1
221 1
219 1
243 1
215 1
245 1
247 1
207 1
250 1
251 1
253 1
255 1
534 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_h_m 0.689676403496 279
NaN 68329
0 10029
1 3657
2 2158
3 1505
4 1072
5 879
6 801
7 642
8 554
9 531
10 423
11 381
12 353
13 343
15 301
14 295
16 244
17 236
19 221
18 212
20 193
22 180
21 178
23 171
24 157
25 154
29 154
26 146
27 130
...
360 1
275 1
508 1
272 1
235 1
185 1
192 1
202 1
207 1
211 1
218 1
220 1
221 1
228 1
233 1
234 1
236 1
263 1
237 1
238 1
241 1
242 1
243 1
244 1
245 1
247 1
248 1
254 1
262 1
644 1
dtype: int64
-------------------------------------------------------------------------------------------------
g5_m 0.487029896845 283
NaN 48252
0 1613
31 980
35 967
27 956
30 940
34 937
32 934
38 929
33 926
28 918
36 915
37 901
29 885
26 877
23 873
40 871
24 840
25 837
46 831
41 830
22 827
39 826
43 817
42 813
1 812
45 810
44 777
21 767
19 743
...
387 1
372 1
339 1
353 1
207 1
268 1
273 1
271 1
228 1
229 1
232 1
233 1
219 1
237 1
218 1
239 1
242 1
246 1
247 1
249 1
186 1
206 1
254 1
264 1
265 1
266 1
454 1
225 1
270 1
569 1
dtype: int64
-------------------------------------------------------------------------------------------------
pk_m 0.711488382421 287
NaN 70490
0 3163
1 1102
11 912
10 882
9 847
8 826
12 793
15 773
7 770
2 758
13 749
17 739
19 724
18 721
16 709
20 657
14 657
6 648
5 611
21 604
3 602
4 599
22 574
23 515
24 504
25 462
26 416
28 369
27 364
...
855 1
243 1
220 1
117 1
218 1
110 1
197 1
211 1
208 1
238 1
244 1
308 1
279 1
176 1
304 1
198 1
296 1
295 1
291 1
290 1
271 1
248 1
270 1
168 1
261 1
260 1
254 1
161 1
249 1
1055 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_w_f 0.751670468539 314
NaN 74471
0 4157
1 1497
2 941
3 766
4 648
5 556
6 495
7 477
8 467
9 429
10 404
11 387
13 339
12 317
14 306
18 290
15 285
16 284
17 264
19 255
21 231
23 215
20 208
25 196
26 194
24 191
30 187
22 187
28 183
...
420 1
322 1
358 1
397 1
395 1
369 1
345 1
275 1
321 1
318 1
237 1
250 1
257 1
259 1
265 1
824 1
269 1
271 1
284 1
287 1
298 1
299 1
301 1
302 1
303 1
306 1
308 1
309 1
314 1
1083 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_w_f 0.743292892182 317
NaN 73641
0 5575
1 1699
2 990
3 706
4 552
5 478
6 461
7 409
9 373
8 343
10 302
11 293
12 280
18 247
13 247
14 244
15 236
17 232
16 224
23 223
19 210
20 209
21 203
25 201
22 198
24 190
26 178
29 168
33 155
...
401 1
249 1
416 1
433 1
438 1
454 1
455 1
513 1
323 1
314 1
316 1
315 1
263 1
277 1
654 1
262 1
259 1
257 1
253 1
290 1
252 1
250 1
295 1
296 1
297 1
298 1
304 1
307 1
310 1
744 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_h_f 0.751670468539 321
NaN 74471
0 8589
1 2997
2 1660
3 1121
4 873
5 715
6 535
7 498
8 452
9 378
10 332
11 317
12 263
14 223
15 215
13 214
16 193
17 183
18 155
20 154
19 150
22 144
24 127
23 126
21 124
25 105
29 101
31 101
30 100
...
240 1
238 1
233 1
230 1
228 1
222 1
201 1
165 1
496 1
156 1
256 1
260 1
305 1
261 1
304 1
302 1
301 1
300 1
290 1
286 1
285 1
284 1
276 1
275 1
274 1
273 1
268 1
264 1
263 1
526 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_w_f 0.750489533076 322
NaN 74354
0 4452
1 1511
2 1033
3 788
4 664
5 594
6 508
7 476
8 422
9 412
10 347
11 345
12 337
14 315
13 298
15 282
16 259
17 247
18 238
20 234
19 231
22 212
23 212
21 206
24 198
25 193
27 192
29 170
33 169
...
479 1
409 1
477 1
412 1
422 1
325 1
700 1
322 1
280 1
239 1
240 1
251 1
257 1
268 1
273 1
275 1
276 1
278 1
281 1
316 1
284 1
290 1
295 1
299 1
300 1
303 1
310 1
313 1
314 1
1192 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_h_m 0.751670468539 325
NaN 74471
0 8153
1 3120
2 1715
3 1174
4 962
5 686
6 610
7 484
8 437
9 345
10 329
11 300
12 290
14 262
13 234
15 221
16 203
17 166
18 163
21 152
20 150
19 139
22 138
24 127
23 122
26 120
25 106
27 101
28 97
...
257 1
484 1
253 1
246 1
267 1
241 1
231 1
223 1
178 1
203 1
202 1
264 1
269 1
314 1
292 1
308 1
306 1
304 1
296 1
294 1
293 1
290 1
271 1
289 1
288 1
286 1
282 1
279 1
277 1
536 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_h_f 0.750489533076 327
NaN 74354
0 8514
1 3036
2 1665
3 1157
4 872
5 738
6 589
7 515
8 424
9 380
10 321
11 309
12 286
13 232
14 227
15 205
16 195
17 173
19 151
22 147
23 147
20 145
18 142
21 140
24 124
26 120
29 102
27 100
25 98
...
242 1
240 1
234 1
232 1
223 1
319 1
222 1
219 1
206 1
203 1
168 1
560 1
254 1
255 1
260 1
262 1
265 1
268 1
272 1
278 1
293 1
295 1
297 1
301 1
304 1
307 1
311 1
313 1
314 1
562 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_w_m 0.751670468539 328
NaN 74471
0 3539
1 1414
2 985
3 782
4 703
5 583
6 545
7 474
8 470
9 446
12 386
10 384
11 383
13 341
14 331
15 329
16 322
17 288
18 259
19 251
20 228
21 222
22 219
23 215
28 208
24 203
25 202
26 196
27 192
...
384 1
358 1
373 1
637 1
313 1
309 1
242 1
249 1
254 1
263 1
265 1
267 1
268 1
273 1
276 1
281 1
283 1
285 1
288 1
292 1
294 1
295 1
297 1
298 1
299 1
301 1
303 1
304 1
308 1
765 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_w_m 0.750489533076 328
NaN 74354
0 3674
1 1579
2 1130
3 868
4 677
5 622
7 529
6 523
8 490
9 402
10 391
11 356
12 343
14 324
16 306
15 305
13 304
17 265
20 255
18 240
19 224
22 210
23 202
21 202
24 186
28 184
27 183
26 173
31 167
...
419 1
417 1
317 1
535 1
314 1
312 1
247 1
256 1
257 1
266 1
267 1
269 1
270 1
275 1
279 1
281 1
282 1
288 1
290 1
292 1
294 1
296 1
299 1
301 1
302 1
303 1
304 1
306 1
311 1
952 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_w_f 0.748864485132 331
NaN 74193
0 4798
1 1681
2 1057
3 718
4 660
5 505
6 480
7 408
8 401
9 356
10 346
13 314
11 309
12 279
16 271
17 263
14 257
15 236
18 224
22 220
20 216
19 205
21 200
23 194
27 179
24 176
26 176
30 168
29 167
...
416 1
321 1
305 1
319 1
295 1
258 1
260 1
262 1
273 1
276 1
277 1
280 1
287 1
290 1
291 1
292 1
296 1
318 1
297 1
583 1
302 1
303 1
306 1
309 1
311 1
313 1
314 1
316 1
317 1
903 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_h_m 0.750489533076 332
NaN 74354
0 8221
1 3029
2 1695
3 1259
4 927
5 751
6 574
7 491
8 424
9 390
10 306
11 303
12 288
13 273
14 242
15 219
16 205
17 200
22 155
18 153
20 152
19 148
23 131
21 130
25 127
24 116
28 112
27 102
26 98
...
254 1
342 1
264 1
532 1
193 1
204 1
237 1
238 1
243 1
244 1
247 1
248 1
256 1
257 1
261 1
269 1
341 1
286 1
289 1
295 1
302 1
307 1
311 1
315 1
321 1
325 1
326 1
329 1
340 1
593 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_w_m 0.748864485132 336
NaN 74193
0 3959
1 1619
2 1132
3 850
4 711
5 599
6 501
7 495
8 434
9 403
12 337
11 335
10 330
13 298
15 267
14 264
16 263
17 242
19 238
20 231
18 228
22 197
25 193
21 193
24 191
23 176
29 171
28 167
30 161
...
421 1
429 1
444 1
460 1
465 1
376 1
257 1
473 1
267 1
274 1
287 1
273 1
290 1
291 1
295 1
296 1
270 1
298 1
300 1
332 1
302 1
308 1
311 1
313 1
317 1
320 1
321 1
277 1
327 1
726 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_w_m 0.743292892182 336
NaN 73641
0 4617
1 1682
2 1124
3 772
4 705
5 562
6 465
7 432
8 409
9 393
11 324
10 322
12 297
14 261
17 248
13 248
16 239
18 238
20 233
19 216
15 214
22 204
21 198
23 198
24 195
26 182
25 169
29 162
30 155
...
432 1
442 1
452 1
456 1
457 1
467 1
489 1
629 1
317 1
322 1
264 1
288 1
289 1
290 1
275 1
295 1
297 1
299 1
300 1
302 1
249 1
263 1
305 1
308 1
311 1
312 1
313 1
315 1
282 1
841 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_f 0.631830752771 342
NaN 62598
0 3139
1 997
2 567
20 503
22 501
3 501
25 492
11 487
21 485
9 484
27 480
29 478
5 478
26 477
8 472
12 470
23 470
28 466
19 461
13 460
4 457
24 455
18 455
16 452
30 450
6 448
31 448
10 444
17 442
...
403 1
467 1
408 1
330 1
298 1
328 1
602 1
228 1
272 1
276 1
281 1
282 1
285 1
289 1
291 1
293 1
294 1
302 1
327 1
307 1
308 1
310 1
314 1
315 1
316 1
318 1
321 1
323 1
324 1
603 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_h_f 0.748864485132 345
NaN 74193
0 8721
1 2939
2 1717
3 1132
4 821
5 715
6 570
7 529
8 394
9 375
10 333
11 296
12 253
14 225
13 223
15 221
16 196
18 166
17 164
20 150
19 143
22 139
21 134
23 130
24 111
28 105
29 105
26 97
30 90
...
310 1
272 1
197 1
282 1
283 1
202 1
285 1
267 1
265 1
291 1
259 1
299 1
307 1
252 1
315 1
245 1
249 1
317 1
319 1
322 1
323 1
326 1
327 1
331 1
333 1
278 1
337 1
607 1
224 1
710 1
dtype: int64
-------------------------------------------------------------------------------------------------
g6_m 0.631830752771 345
NaN 62598
0 2434
1 1021
2 706
3 563
8 543
5 496
23 492
4 491
10 484
7 483
32 482
9 473
27 471
6 467
22 466
21 465
12 457
34 454
24 450
19 447
13 447
30 445
29 443
15 440
16 439
14 439
28 439
25 436
11 431
...
345 1
414 1
428 1
429 1
455 1
481 1
572 1
347 1
335 1
270 1
316 1
292 1
577 1
288 1
307 1
310 1
311 1
312 1
314 1
319 1
338 1
320 1
321 1
327 1
277 1
333 1
334 1
296 1
337 1
629 1
dtype: int64
-------------------------------------------------------------------------------------------------
data_na 0.611320830894 350
NaN 60566
1986-2004 2805
1986-2005 2344
1986-2003 1919
1986-2008 1668
1986-2010 1662
1986-2007 1657
1986-2011 1617
1986-2006 1589
1986-2001 1563
1986-1997 1555
1986-2009 1550
1986-2002 1467
1986-2000 1429
1986-1999 1373
1986-1998 1349
1986-1996 1324
1986-1992 1324
1986-1995 1304
1986-1989 1182
1986-1993 1168
1986-1991 1113
1986-1994 1004
1986-1990 949
1986 909
1986-1988 882
1986-1987 827
1986-1992 2008 41
1986-2001 2007-2008 31
1986-1994 1996 26
...
1986-1987 2005 1
1986-1987 2004 1
1986-1987 2003 1
1986 1995-1996 1
1986-1995 2004-2005 1
1986-1987 2004-2005 1
1986-2002 2010 1
1986-1994 2003-2005 1
1986-1989 2004-2006 1
1986-2007 2009-2011 1
1986-2007 2009-2012 1
1986-2005 2012 1
1986-1997 2002 2005 1
1986-1990 2010 1
1986-1997 2008-2009 1
1986-1999 2002 2004-2005 1
1986-2002 2011 1
2007-2009 1
1986-2004 2011-2012 1
1986-1996 2010 1
1986-1994 2006 1
1986-1994 2004 1
1986-1994 2002 1
1986-1997 2002-2003 1
1986-1999 2003-2008 1
1986-1988 1997-1998 1
1986-1992 2004-2005 2008 1
1986-1989 2008-2011 1
1986-2004 2006 1
1986-1994 1998 2003 1
dtype: int64
-------------------------------------------------------------------------------------------------
data_available 0.0 351
1986-2013 58668
2005-2013 2805
2006-2013 2344
2004-2013 1919
2013 1898
2009-2013 1668
2011-2013 1662
2008-2013 1657
2012-2013 1617
2007-2013 1589
2002-2013 1563
1998-2013 1555
2010-2013 1550
2003-2013 1467
2001-2013 1429
2000-2013 1373
1999-2013 1349
1997-2013 1324
1993-2013 1324
1996-2013 1304
1990-2013 1182
1994-2013 1168
1992-2013 1113
1995-2013 1004
1991-2013 949
1987-2013 909
1989-2013 882
1988-2013 827
1993-2007 2009-2013 41
2002-2006 2009-2013 31
...
1991-2003 2006-2013 1
1987-1994 1997-2013 1
1998-2002 2004-2008 2010-2013 1
1986-2007 2010-2013 1
2003-2009 2011-2013 1
1987-2008 2011-2013 1
1997-2009 2011-2013 1
1986-2004 2006 2008-2013 1
1995-1997 1999-2002 2004-2013 1
2004-2008 2010-2013 1
1988-2002 2004-2013 1
2005 2007-2013 1
1992-1994 1997 1999-2013 1
2007-2009 2012-2013 1
1994-2004 2006-2013 1
2000-2011 2013 1
1997-2006 2008-2013 1
1992-1994 1996-2013 1
1999-2001 2005-2013 1
1999-2003 2007-2013 1
1988-1994 1996-2013 1
1986-1991 1993-2013 1
1999-2011 2013 1
1989-2011 2013 1
1999-2008 2011-2013 1
1997-2002 2004-2013 1
1998-2008 2012-2013 1
2000-2001 2003-2004 2006-2013 1
1993-2003 2006-2007 2009-2013 1
1993-1997 1999-2013 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g3 0.471425399197 359
NaN 46706
0 969
72 562
75 558
60 553
74 540
66 540
58 538
61 538
70 535
50 534
71 533
59 525
73 524
76 523
63 522
52 519
56 517
77 511
68 510
65 509
47 508
78 508
86 508
64 505
53 503
62 503
69 502
48 498
1 498
...
291 1
283 1
277 1
271 1
834 1
339 1
264 1
262 1
259 1
256 1
255 1
252 1
297 1
300 1
305 1
306 1
307 1
309 1
313 1
315 1
316 1
317 1
320 1
322 1
325 1
326 1
327 1
332 1
338 1
955 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g2 0.470547267699 360
NaN 46619
0 935
72 591
66 586
75 553
71 553
52 551
73 543
62 540
77 531
63 530
70 528
53 527
65 515
69 513
59 511
67 511
54 509
48 509
74 509
61 505
79 504
68 504
64 502
82 501
85 497
60 496
1 493
50 492
57 490
...
293 1
292 1
288 1
287 1
279 1
339 1
274 1
266 1
263 1
262 1
249 1
238 1
299 1
300 1
303 1
304 1
306 1
307 1
308 1
310 1
313 1
314 1
315 1
317 1
321 1
322 1
329 1
334 1
338 1
840 1
dtype: int64
-------------------------------------------------------------------------------------------------
congressional_code 0.19356238771 361
NaN 19177
3000 825
4600 698
3103 582
3800 511
200 507
4003 483
4002 478
2001 470
2707 443
601 436
2906 419
2908 387
602 381
401 374
804 371
2302 370
1602 369
5507 367
2904 356
2701 352
5600 352
803 347
4004 345
5503 340
2105 338
1601 336
2708 335
2002 334
3503 332
...
630 139
1216 138
1211 138
4207 138
645 137
648 137
1227 136
5307 136
1307 135
1218 133
633 130
629 130
3605 130
1311 129
1222 128
1306 126
1207 123
3610 122
1213 121
1501 120
628 119
4213 118
1223 117
3612 117
612 116
3606 111
1221 111
3611 110
3203 103
3614 100
dtype: int64
-------------------------------------------------------------------------------------------------
g7_f 0.691967620163 363
NaN 68556
0 2968
1 989
2 625
3 530
5 432
4 422
6 406
8 404
7 398
10 392
12 392
9 386
15 365
13 350
11 346
14 335
16 333
19 328
20 318
17 318
21 312
23 303
26 302
22 290
25 290
28 289
30 286
18 277
24 272
...
410 1
418 1
372 1
450 1
555 1
561 1
581 1
373 1
281 1
370 1
337 1
297 1
263 1
303 1
311 1
312 1
315 1
325 1
336 1
338 1
366 1
340 1
342 1
346 1
347 1
351 1
694 1
355 1
362 1
728 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_h_m 0.748864485132 368
NaN 74193
0 8104
1 3128
2 1814
3 1172
4 904
5 678
6 600
7 500
8 437
10 364
9 353
11 310
12 295
13 241
14 221
15 208
16 180
17 179
19 170
20 165
21 158
24 137
23 132
18 127
22 125
28 105
26 102
25 101
30 99
...
259 1
255 1
253 1
234 1
233 1
209 1
582 1
171 1
291 1
299 1
342 1
304 1
341 1
337 1
333 1
329 1
328 1
327 1
325 1
323 1
322 1
321 1
319 1
314 1
312 1
311 1
309 1
308 1
305 1
829 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g1 0.470920725922 371
NaN 46656
0 995
69 562
66 557
75 554
72 553
74 545
81 533
80 533
63 532
78 532
70 531
62 528
65 527
60 526
77 520
61 512
84 511
64 511
76 505
52 505
59 501
86 494
46 493
71 492
79 487
73 485
67 484
1 480
48 479
...
367 1
366 1
265 1
820 1
279 1
285 1
292 1
297 1
298 1
299 1
301 1
302 1
310 1
311 1
237 1
326 1
327 1
328 1
329 1
333 1
335 1
339 1
348 1
350 1
352 1
353 1
355 1
356 1
365 1
874 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_h_f 0.743292892182 376
NaN 73641
0 9242
1 2898
2 1622
3 1139
4 859
5 693
6 532
7 525
8 414
9 382
10 311
12 276
11 265
13 213
14 210
15 195
16 189
17 185
20 162
18 159
19 154
22 143
21 134
23 127
28 117
24 107
26 106
25 95
29 91
...
278 1
274 1
358 1
242 1
239 1
236 1
234 1
208 1
188 1
574 1
298 1
305 1
309 1
310 1
357 1
356 1
354 1
351 1
349 1
346 1
338 1
336 1
334 1
329 1
324 1
320 1
316 1
313 1
312 1
717 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_f 0.689676403496 377
NaN 68329
0 2925
1 1115
2 720
3 565
4 513
5 448
9 448
8 428
7 422
6 422
10 383
11 376
12 370
16 357
15 341
13 338
14 327
17 315
23 315
18 311
22 302
21 296
24 292
25 290
19 286
28 283
29 283
20 277
27 274
...
563 1
573 1
575 1
666 1
380 1
360 1
669 1
372 1
310 1
320 1
308 1
307 1
325 1
327 1
329 1
303 1
337 1
292 1
339 1
285 1
343 1
283 1
351 1
352 1
354 1
357 1
358 1
364 1
369 1
877 1
dtype: int64
-------------------------------------------------------------------------------------------------
g7_m 0.691967620163 381
NaN 68556
0 2227
1 1005
2 713
3 536
4 519
5 459
8 458
7 421
6 419
10 416
11 401
9 394
12 379
14 376
13 355
16 346
19 337
21 325
17 318
15 317
18 302
22 301
20 298
23 295
24 293
28 284
25 283
26 279
31 272
...
477 1
481 1
557 1
410 1
685 1
363 1
328 1
280 1
292 1
293 1
303 1
304 1
316 1
318 1
319 1
321 1
325 1
329 1
357 1
334 1
337 1
339 1
341 1
342 1
343 1
347 1
351 1
353 1
354 1
806 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_an 0.0405959182026 382
0 37476
1 17444
2 11072
3 7078
4 4627
NaN 4022
5 3134
6 2250
7 1678
8 1202
9 982
10 739
11 616
12 476
13 410
14 364
15 310
16 276
17 248
18 212
20 190
19 154
21 151
22 150
23 122
24 121
25 120
26 103
27 99
28 93
...
172 1
371 1
370 1
364 1
351 1
347 1
346 1
343 1
338 1
336 1
334 1
333 1
331 1
327 1
323 1
285 1
316 1
312 1
310 1
308 1
306 1
304 1
303 1
301 1
300 1
294 1
290 1
287 1
286 1
1462 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g4 0.474392878051 388
NaN 47000
0 1046
72 564
78 554
65 550
75 550
70 532
59 531
69 530
1 528
50 527
64 527
67 527
62 524
63 524
60 523
56 522
49 519
73 518
51 514
55 514
71 501
57 500
76 499
77 499
68 498
61 498
66 497
53 490
52 489
...
301 1
299 1
297 1
296 1
282 1
281 1
277 1
273 1
272 1
266 1
265 1
314 1
315 1
319 1
347 1
367 1
364 1
359 1
358 1
355 1
349 1
343 1
320 1
342 1
339 1
332 1
331 1
325 1
324 1
961 1
dtype: int64
-------------------------------------------------------------------------------------------------
g8_m 0.689676403496 390
NaN 68329
0 2188
1 1050
2 701
4 594
3 572
5 528
7 495
6 494
9 449
8 441
10 421
11 419
14 397
12 369
13 362
21 349
15 340
22 334
17 331
18 323
16 312
24 295
20 290
28 288
23 284
19 282
26 277
25 274
29 273
...
309 1
381 1
348 1
300 1
299 1
294 1
675 1
291 1
334 1
335 1
336 1
337 1
339 1
340 1
341 1
349 1
380 1
350 1
352 1
354 1
360 1
362 1
366 1
367 1
368 1
371 1
375 1
378 1
379 1
868 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_h_m 0.743292892182 395
NaN 73641
0 8608
1 3016
2 1742
3 1230
4 809
5 755
6 602
7 484
8 416
9 342
10 328
11 313
12 272
13 256
14 198
15 198
16 191
17 185
18 179
19 153
20 139
21 139
22 137
23 125
26 121
25 116
24 115
28 114
29 99
...
273 1
272 1
271 1
266 1
227 1
252 1
248 1
242 1
215 1
320 1
378 1
327 1
377 1
374 1
373 1
218 1
365 1
361 1
356 1
355 1
217 1
353 1
350 1
339 1
338 1
333 1
331 1
330 1
329 1
717 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_k 0.474715868946 411
NaN 47032
0 1125
72 595
70 566
69 560
66 552
64 542
75 541
61 530
67 529
74 529
60 527
48 520
79 516
65 516
73 516
50 514
76 512
52 511
63 510
71 501
62 496
68 495
78 495
82 494
81 491
77 491
54 490
59 489
46 480
...
290 1
288 1
278 1
269 1
262 1
243 1
342 1
343 1
346 1
347 1
392 1
388 1
378 1
376 1
375 1
372 1
370 1
368 1
364 1
363 1
362 1
361 1
360 1
357 1
356 1
355 1
351 1
350 1
348 1
955 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_pk 0.711437915094 455
NaN 70485
0 2734
1 953
20 847
18 667
2 612
40 576
19 561
36 559
3 482
22 428
17 417
16 416
4 409
21 402
35 395
39 391
30 389
15 385
14 362
32 359
29 355
13 351
12 348
38 347
26 345
5 345
25 342
31 337
28 337
...
414 1
415 1
417 1
418 1
431 1
374 1
240 1
434 1
436 1
438 1
289 1
223 1
301 1
406 1
405 1
404 1
243 1
400 1
399 1
397 1
395 1
393 1
390 1
389 1
207 1
288 1
204 1
377 1
376 1
1809 1
dtype: int64
-------------------------------------------------------------------------------------------------
a_f 0.0405959182026 462
0 30637
1 12398
2 7742
3 5275
NaN 4022
4 4021
5 3320
6 2605
7 2263
8 1873
9 1562
10 1397
11 1281
12 1165
13 1037
14 925
15 861
16 803
17 772
18 696
19 618
20 552
21 547
22 538
23 465
24 414
25 407
27 389
26 357
28 340
...
380 1
381 1
431 1
481 1
478 1
474 1
473 1
472 1
469 1
460 1
456 1
440 1
436 1
435 1
432 1
430 1
387 1
429 1
427 1
418 1
412 1
410 1
408 1
406 1
405 1
400 1
396 1
395 1
394 1
1442 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_f 0.751670468539 483
NaN 74471
0 2023
1 748
2 535
3 507
5 409
4 406
8 400
6 388
7 384
9 348
11 338
10 326
12 323
13 306
16 295
14 287
15 284
17 274
18 271
21 267
19 245
23 242
25 238
22 234
24 221
20 219
31 205
26 202
36 199
...
394 1
391 1
390 1
387 1
384 1
379 1
375 1
368 1
353 1
421 1
422 1
423 1
452 1
466 1
465 1
464 1
463 1
462 1
456 1
455 1
450 1
428 1
446 1
441 1
440 1
319 1
433 1
431 1
429 1
1517 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_f 0.750489533076 484
NaN 74354
0 2121
1 828
2 607
3 524
4 479
5 461
6 409
8 381
7 379
9 372
12 352
11 336
13 304
14 296
17 284
10 281
16 277
18 264
22 263
19 238
15 235
20 235
21 218
29 216
26 212
24 210
25 204
27 200
23 198
...
422 1
420 1
418 1
411 1
405 1
479 1
392 1
389 1
387 1
381 1
378 1
926 1
430 1
441 1
445 1
446 1
448 1
450 1
451 1
456 1
457 1
458 1
460 1
462 1
467 1
470 1
471 1
473 1
476 1
1584 1
dtype: int64
-------------------------------------------------------------------------------------------------
g12_m 0.751670468539 485
NaN 74471
0 1484
1 707
2 552
3 479
5 438
4 437
6 435
7 426
8 376
13 368
9 360
12 337
11 337
10 332
14 308
16 302
15 301
17 296
20 260
18 259
22 257
23 256
19 249
21 242
26 233
24 220
27 215
25 215
30 213
...
415 1
387 1
464 1
411 1
389 1
408 1
405 1
404 1
403 1
395 1
382 1
425 1
428 1
432 1
462 1
397 1
460 1
458 1
456 1
455 1
452 1
347 1
448 1
447 1
444 1
439 1
364 1
434 1
433 1
1005 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g5 0.486918868724 486
NaN 48241
0 1262
1 638
60 524
62 514
75 513
66 505
61 504
56 501
59 501
68 501
48 499
55 498
50 497
49 495
72 492
71 490
74 489
76 485
54 479
58 475
70 473
67 472
53 471
57 468
77 467
45 467
63 463
69 462
65 462
...
329 1
322 1
310 1
306 1
301 1
874 1
388 1
393 1
396 1
398 1
468 1
465 1
463 1
457 1
455 1
447 1
440 1
439 1
437 1
428 1
427 1
421 1
417 1
416 1
408 1
407 1
402 1
401 1
400 1
1052 1
dtype: int64
-------------------------------------------------------------------------------------------------
g11_m 0.750489533076 495
NaN 74354
0 1514
1 774
2 631
3 556
4 482
6 438
7 431
9 412
8 410
5 402
10 382
11 346
15 337
12 332
14 327
13 321
17 296
16 290
20 273
19 260
21 256
18 252
23 251
22 247
29 226
25 218
24 213
31 205
27 203
...
350 1
421 1
415 1
824 1
407 1
371 1
403 1
376 1
400 1
394 1
447 1
449 1
489 1
450 1
488 1
479 1
478 1
476 1
474 1
472 1
470 1
466 1
465 1
464 1
388 1
459 1
456 1
453 1
452 1
1240 1
dtype: int64
-------------------------------------------------------------------------------------------------
a_m 0.0405959182026 505
0 31411
1 12171
2 7698
3 5299
NaN 4022
4 3882
5 3061
6 2573
7 2161
8 1825
9 1542
10 1381
11 1295
12 1090
13 1036
14 964
15 845
16 750
17 712
18 676
19 597
20 537
21 519
23 474
22 468
24 454
25 416
26 395
27 386
28 321
...
447 1
422 1
448 1
458 1
460 1
461 1
462 1
465 1
466 1
423 1
416 1
376 1
393 1
377 1
378 1
383 1
384 1
385 1
387 1
389 1
396 1
415 1
397 1
398 1
405 1
408 1
410 1
411 1
412 1
1867 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_f 0.748864485132 506
NaN 74193
0 2362
1 957
2 697
3 536
4 488
5 465
7 399
9 379
6 368
8 345
11 322
10 304
14 288
12 261
17 252
13 251
15 245
18 232
20 229
19 223
16 222
21 210
23 209
24 199
25 196
30 195
22 194
26 188
27 175
...
448 1
403 1
443 1
413 1
414 1
416 1
433 1
431 1
420 1
421 1
422 1
458 1
395 1
394 1
489 1
498 1
497 1
496 1
423 1
494 1
492 1
485 1
388 1
480 1
380 1
473 1
472 1
468 1
465 1
1285 1
dtype: int64
-------------------------------------------------------------------------------------------------
g10_m 0.748864485132 524
NaN 74193
0 1733
1 837
2 651
3 534
4 510
5 474
6 443
7 414
8 397
9 395
10 364
11 346
13 319
14 296
12 292
15 288
16 264
21 243
18 240
20 239
19 233
24 225
17 223
22 222
27 199
25 193
26 192
23 188
29 186
...
447 1
446 1
442 1
379 1
437 1
435 1
434 1
428 1
424 1
422 1
399 1
355 1
462 1
463 1
492 1
514 1
513 1
503 1
499 1
498 1
497 1
490 1
464 1
486 1
475 1
474 1
470 1
467 1
466 1
1048 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_f 0.743292892182 527
NaN 73641
0 3117
1 1091
2 681
3 574
4 461
5 385
6 381
8 339
7 330
9 330
11 274
12 261
10 258
13 257
14 231
16 218
15 217
20 214
22 206
18 204
21 202
26 193
19 189
23 187
17 186
25 181
24 174
28 168
29 165
...
419 1
481 1
457 1
426 1
449 1
431 1
434 1
435 1
436 1
480 1
483 1
524 1
503 1
517 1
516 1
514 1
509 1
507 1
401 1
504 1
502 1
484 1
403 1
498 1
497 1
495 1
494 1
493 1
491 1
1637 1
dtype: int64
-------------------------------------------------------------------------------------------------
lunch_reduced_eligible 0.0565435936775 528
0 9814
NaN 5602
2 1906
11 1581
14 1542
16 1535
1 1522
10 1502
15 1494
17 1486
18 1468
19 1465
13 1459
20 1441
9 1437
12 1431
8 1428
3 1420
21 1416
24 1393
7 1392
22 1390
5 1372
6 1368
26 1366
4 1362
23 1361
25 1327
28 1305
29 1292
...
518 1
519 1
521 1
523 1
526 1
528 1
530 1
531 1
486 1
471 1
412 1
462 1
413 1
414 1
417 1
418 1
422 1
428 1
438 1
439 1
442 1
448 1
450 1
451 1
454 1
455 1
456 1
457 1
459 1
2595 1
dtype: int64
-------------------------------------------------------------------------------------------------
g9_m 0.743292892182 560
NaN 73641
0 2346
1 959
2 690
3 563
4 492
5 464
8 409
6 397
7 365
9 332
11 315
10 314
12 295
13 264
16 249
14 239
15 231
17 225
21 223
18 217
20 210
19 209
22 209
24 190
29 184
23 183
28 183
27 179
25 177
...
449 1
448 1
447 1
436 1
433 1
414 1
408 1
495 1
499 1
550 1
524 1
546 1
539 1
536 1
535 1
531 1
529 1
528 1
527 1
522 1
500 1
515 1
512 1
511 1
509 1
504 1
503 1
502 1
501 1
1550 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_pk_k 0.460090437451 590
NaN 45583
0 1033
72 497
66 489
74 480
69 466
75 462
67 452
76 450
61 447
73 444
70 443
60 440
82 439
64 439
78 438
71 437
77 435
79 433
80 430
88 428
86 427
50 426
96 425
65 420
81 420
87 418
92 416
68 415
83 414
...
540 1
541 1
543 1
546 1
548 1
553 1
555 1
557 1
563 1
569 1
574 1
525 1
523 1
522 1
497 1
478 1
480 1
483 1
485 1
493 1
495 1
501 1
520 1
509 1
510 1
512 1
516 1
517 1
519 1
1809 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g6 0.631739911581 624
NaN 62589
0 1932
1 923
2 533
3 424
4 341
5 298
46 272
21 270
24 262
17 261
44 258
26 258
25 256
14 256
6 255
19 253
64 252
10 252
56 251
49 250
52 249
60 249
47 248
61 245
51 244
50 244
18 242
53 240
48 240
...
520 1
519 1
518 1
516 1
515 1
511 1
508 1
493 1
536 1
540 1
611 1
543 1
609 1
606 1
1179 1
602 1
599 1
598 1
581 1
580 1
576 1
495 1
435 1
563 1
559 1
554 1
553 1
552 1
544 1
1232 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g7 0.691896965904 677
NaN 68549
0 1717
1 871
2 573
3 436
4 347
5 305
6 289
15 243
8 242
7 234
14 229
16 217
9 216
10 216
19 212
12 212
11 207
17 206
22 205
20 204
13 201
21 201
18 194
25 193
24 193
23 186
32 177
27 174
34 172
...
575 1
555 1
600 1
599 1
576 1
596 1
581 1
592 1
591 1
623 1
625 1
684 1
662 1
682 1
680 1
678 1
585 1
522 1
669 1
667 1
527 1
553 1
658 1
533 1
649 1
643 1
635 1
634 1
550 1
1534 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g8 0.689605749238 688
NaN 68322
0 1623
1 885
2 554
3 476
4 396
5 347
6 326
7 287
9 275
8 273
12 251
11 250
10 249
13 241
20 237
15 235
14 233
16 222
17 219
22 210
19 209
18 207
21 198
24 197
26 194
27 187
25 185
47 178
23 176
...
571 1
595 1
594 1
590 1
589 1
555 1
631 1
633 1
656 1
679 1
678 1
677 1
676 1
673 1
671 1
668 1
660 1
658 1
651 1
554 1
649 1
648 1
647 1
645 1
546 1
548 1
640 1
637 1
553 1
1745 1
dtype: int64
-------------------------------------------------------------------------------------------------
b_m 0.0405959182026 689
0 15911
1 8537
2 5894
3 4475
NaN 4022
4 3425
5 2743
6 2333
7 2038
8 1722
9 1542
10 1439
11 1336
12 1158
13 1063
15 1001
14 992
16 874
17 832
18 769
19 767
20 735
21 701
22 673
23 631
24 615
25 589
26 552
27 539
28 524
...
645 1
647 1
651 1
656 1
626 1
662 1
665 1
671 1
674 1
676 1
678 1
627 1
2331 1
588 1
606 1
589 1
591 1
593 1
600 1
601 1
603 1
607 1
622 1
613 1
615 1
617 1
618 1
620 1
621 1
2839 1
dtype: int64
-------------------------------------------------------------------------------------------------
b_f 0.0405959182026 695
0 17759
1 8619
2 6006
3 4454
NaN 4022
4 3451
5 2656
6 2260
7 1912
8 1746
9 1523
10 1346
11 1250
12 1163
13 1043
14 970
15 862
16 826
17 808
18 766
19 707
21 693
20 670
23 646
22 638
24 590
25 525
26 519
28 515
27 514
...
681 1
687 1
590 1
690 1
692 1
693 1
696 1
702 1
707 1
709 1
653 1
650 1
649 1
648 1
596 1
598 1
606 1
607 1
608 1
610 1
613 1
615 1
617 1
619 1
626 1
631 1
633 1
637 1
639 1
2892 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_a 0.0405959182026 791
0 22953
1 10024
2 6898
3 5261
NaN 4022
4 3992
5 3191
6 2739
7 2284
8 2073
9 1747
10 1613
11 1463
12 1281
13 1166
14 1091
15 996
16 883
17 874
18 783
19 782
20 733
21 683
23 606
22 582
24 575
27 519
26 512
25 494
28 487
...
708 1
702 1
638 1
700 1
641 1
2410 1
396 1
647 1
648 1
483 1
654 1
411 1
659 1
661 1
662 1
414 1
666 1
669 1
671 1
672 1
673 1
674 1
678 1
679 1
682 1
684 1
687 1
689 1
698 1
3309 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g12 0.751630094677 862
NaN 74467
0 1102
1 530
2 412
3 331
5 281
4 269
8 249
7 243
6 239
12 234
10 218
9 212
14 209
16 208
15 201
17 200
18 194
11 193
13 186
20 186
22 177
25 176
19 171
24 170
32 168
23 164
28 160
21 159
34 156
...
798 1
801 1
802 1
805 1
807 1
751 1
808 1
811 1
813 1
815 1
817 1
818 1
791 1
790 1
789 1
786 1
783 1
781 1
778 1
775 1
774 1
773 1
771 1
769 1
766 1
765 1
760 1
757 1
755 1
2522 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g11 0.750449159214 874
NaN 74350
0 1070
1 595
2 413
3 368
4 357
5 321
6 299
8 272
7 254
10 248
11 247
14 229
17 221
9 216
19 202
12 202
15 201
21 200
13 198
16 194
20 184
18 182
23 174
25 167
29 166
22 165
28 160
24 158
26 155
...
828 1
861 1
858 1
856 1
854 1
847 1
846 1
845 1
840 1
837 1
835 1
834 1
832 1
831 1
827 1
787 1
825 1
822 1
819 1
814 1
811 1
810 1
803 1
801 1
800 1
799 1
794 1
792 1
788 1
2824 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g10 0.748834204736 932
NaN 74190
0 1208
1 629
2 504
3 436
4 358
6 335
5 323
8 264
9 264
7 262
11 248
10 238
12 222
14 220
17 217
13 208
16 204
18 200
19 191
15 187
21 166
22 162
20 159
25 158
23 157
29 155
26 152
31 140
36 137
...
759 1
886 1
887 1
888 1
889 1
892 1
893 1
896 1
901 1
909 1
911 1
875 1
874 1
651 1
846 1
833 1
835 1
838 1
840 1
842 1
665 1
849 1
872 1
856 1
859 1
861 1
865 1
869 1
871 1
2333 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g9 0.743262611785 971
NaN 73638
0 1771
1 835
2 559
3 455
4 353
5 343
6 310
8 292
7 268
9 238
10 225
12 207
13 204
15 200
11 198
14 189
16 183
17 183
18 183
21 172
19 159
20 149
24 142
27 138
22 130
25 130
23 128
29 126
40 118
...
926 1
929 1
861 1
931 1
934 1
936 1
941 1
942 1
949 1
950 1
906 1
903 1
900 1
898 1
864 1
866 1
867 1
869 1
872 1
873 1
874 1
876 1
877 1
878 1
879 1
882 1
893 1
895 1
897 1
3187 1
dtype: int64
-------------------------------------------------------------------------------------------------
h_f 0.0405959182026 1006
0 8607
1 5269
2 4247
NaN 4022
3 3502
4 3061
5 2764
6 2384
7 2247
8 1982
9 1866
10 1723
11 1611
12 1453
13 1353
14 1327
15 1203
16 1149
17 1023
18 1004
19 982
20 923
21 901
22 837
23 820
24 773
25 728
27 719
26 683
29 672
...
793 1
796 1
797 1
800 1
804 1
805 1
806 1
807 1
814 1
819 1
820 1
821 1
822 1
825 1
826 1
828 1
829 1
832 1
833 1
834 1
835 1
837 1
841 1
849 1
852 1
853 1
855 1
857 1
862 1
3514 1
dtype: int64
-------------------------------------------------------------------------------------------------
w_f 0.0405959182026 1034
0 4346
NaN 4022
1 2476
2 1806
3 1470
4 1361
5 1188
6 1003
7 865
8 819
9 744
11 719
10 717
12 636
13 596
14 577
17 566
16 550
15 548
22 494
21 487
18 472
23 452
19 451
24 449
20 446
25 419
27 418
32 411
28 409
...
997 1
1001 1
1003 1
1004 1
1005 1
1008 1
1011 1
1021 1
958 1
957 1
956 1
953 1
875 1
878 1
886 1
887 1
888 1
898 1
900 1
919 1
921 1
925 1
927 1
928 1
929 1
936 1
941 1
947 1
952 1
5491 1
dtype: int64
-------------------------------------------------------------------------------------------------
h_m 0.0405959182026 1039
0 7574
1 5032
2 4198
NaN 4022
3 3515
4 3057
5 2728
6 2442
7 2277
8 1989
9 1893
10 1722
11 1563
12 1517
13 1383
14 1313
15 1194
16 1126
17 1104
18 1058
20 958
19 956
21 853
22 851
23 833
24 777
27 725
25 723
26 718
28 670
...
812 1
809 1
807 1
804 1
799 1
798 1
796 1
791 1
790 1
789 1
788 1
827 1
830 1
832 1
860 1
876 1
874 1
872 1
870 1
869 1
865 1
859 1
837 1
857 1
856 1
855 1
853 1
852 1
842 1
3602 1
dtype: int64
-------------------------------------------------------------------------------------------------
w_m 0.0405959182026 1056
NaN 4022
0 3367
1 2096
2 1651
3 1399
4 1243
5 1113
6 993
7 885
8 863
10 743
9 737
11 696
13 617
12 603
14 581
16 566
17 556
15 539
18 487
19 465
20 464
21 463
22 459
24 458
25 446
28 445
26 438
31 415
23 413
...
995 1
1004 1
1007 1
1018 1
1019 1
1022 1
1023 1
1029 1
969 1
967 1
965 1
962 1
918 1
919 1
925 1
934 1
935 1
4496 1
939 1
943 1
944 1
945 1
947 1
949 1
950 1
953 1
959 1
960 1
961 1
5279 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_b 0.0405959182026 1189
0 11256
1 6128
2 4914
NaN 4022
3 3862
4 3239
5 2717
6 2294
7 2000
8 1797
9 1578
10 1324
11 1260
12 1133
13 1059
14 985
15 952
16 856
17 849
18 791
19 739
20 715
21 696
22 593
23 593
24 571
26 545
27 543
25 534
28 493
...
993 1
996 1
997 1
998 1
999 1
1000 1
1006 1
1009 1
1011 1
1015 1
1017 1
1018 1
1020 1
1024 1
1065 1
1025 1
1026 1
1029 1
1041 1
1042 1
1045 1
1046 1
1047 1
1054 1
1055 1
1056 1
1058 1
1059 1
1064 1
5731 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_f 0.0405959182026 1602
NaN 4022
0 1104
1 419
3 322
2 320
185 311
197 307
188 300
202 292
192 289
190 288
208 288
157 286
243 286
216 285
177 285
221 284
187 284
233 284
212 283
193 280
203 279
176 279
184 279
191 278
186 278
213 278
200 278
230 277
247 277
...
1452 1
1450 1
1446 1
1444 1
1441 1
1116 1
1439 1
1173 1
1436 1
1435 1
1432 1
1430 1
1167 1
1470 1
1471 1
1473 1
1475 1
1476 1
1477 1
1157 1
1482 1
1483 1
1148 1
1487 1
1488 1
1139 1
1126 1
1496 1
1121 1
7003 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g1_g8 0.220047641157 1634
NaN 21801
0 901
1 580
2 315
3 286
4 224
5 195
6 180
347 171
7 168
399 163
280 157
322 157
302 155
380 154
370 153
319 152
323 152
8 152
309 151
377 151
10 150
353 150
361 150
373 149
299 149
350 149
354 148
357 148
358 148
...
1545 1
1539 1
1497 1
1316 1
1498 1
1499 1
1109 1
1320 1
1502 1
1503 1
1505 1
1508 1
1509 1
1511 1
1512 1
1513 1
1514 1
1515 1
1516 1
1518 1
1519 1
1090 1
1523 1
1524 1
1318 1
1527 1
1529 1
1531 1
1534 1
9139 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_m 0.0405959182026 1663
NaN 4022
0 572
210 285
235 281
220 279
185 278
212 278
208 276
252 276
213 276
241 275
219 275
1 274
237 272
236 271
260 270
205 270
218 270
225 268
226 268
198 267
214 267
234 266
224 265
231 265
249 265
196 264
194 264
223 264
170 263
...
1438 1
1430 1
1506 1
1429 1
1427 1
1426 1
1420 1
1418 1
1417 1
1413 1
1453 1
1455 1
1458 1
1459 1
1499 1
1490 1
1487 1
1486 1
1485 1
1481 1
1478 1
1474 1
1470 1
1465 1
1464 1
1463 1
1462 1
1461 1
1460 1
6673 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_h 0.0405959182026 1687
0 4964
NaN 4022
1 3178
2 2748
3 2550
4 2184
5 1994
6 1900
7 1710
8 1613
9 1516
10 1435
11 1267
12 1241
13 1136
14 1106
16 1080
15 1065
17 1002
19 945
18 904
20 897
21 843
22 829
23 775
24 759
25 727
28 667
26 657
27 635
...
1455 1
1456 1
1458 1
1459 1
1529 1
1528 1
1527 1
1520 1
1513 1
1508 1
1507 1
1504 1
1498 1
1496 1
1495 1
1494 1
1493 1
1490 1
1486 1
1482 1
1479 1
1478 1
1474 1
1473 1
1471 1
1468 1
1463 1
1462 1
1461 1
7116 1
dtype: int64
-------------------------------------------------------------------------------------------------
lunch_free_eligible 0.0565435936775 1722
NaN 5602
0 2649
1 438
15 352
17 344
24 344
12 338
23 336
47 336
6 331
32 329
4 326
29 325
53 325
10 325
34 324
8 324
7 323
11 320
27 320
14 319
38 318
37 318
43 317
52 317
25 316
22 316
40 315
26 312
50 312
...
1373 1
1372 1
1371 1
1427 1
1428 1
1430 1
1449 1
1473 1
1470 1
1464 1
1463 1
1462 1
1461 1
1459 1
1456 1
1452 1
1450 1
1448 1
1435 1
1447 1
1446 1
1445 1
1444 1
1442 1
1441 1
1440 1
1439 1
1437 1
1436 1
8079 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_w 0.0405959182026 1855
NaN 4022
0 2209
1 1514
2 1201
3 1034
4 959
5 848
6 783
7 737
8 638
10 609
9 595
11 552
12 511
13 486
14 466
15 456
16 455
19 407
17 401
18 387
22 355
23 350
21 340
20 333
24 328
26 320
27 310
28 306
25 295
...
1599 1
1592 1
1591 1
1590 1
1586 1
1583 1
1582 1
1576 1
1623 1
1624 1
1635 1
1637 1
1670 1
1664 1
1663 1
1662 1
1660 1
1659 1
1657 1
1656 1
1655 1
1651 1
1646 1
1645 1
1644 1
1642 1
1641 1
1639 1
1638 1
10770 1
dtype: int64
-------------------------------------------------------------------------------------------------
lunch_total_free_and_reduced 0.0565435936775 1859
NaN 5602
0 2455
3 431
27 281
4 281
13 270
8 269
26 266
32 264
50 264
41 263
17 263
100 263
28 261
23 261
9 259
25 258
59 258
35 257
20 256
61 255
5 254
40 254
66 253
46 252
74 252
49 251
24 251
69 251
76 251
...
1620 1
1618 1
1658 1
1661 1
1712 1
1662 1
1709 1
1708 1
1707 1
1705 1
1703 1
1701 1
1700 1
1194 1
1697 1
1195 1
1695 1
1197 1
1691 1
1690 1
1689 1
1688 1
1202 1
1682 1
1681 1
1673 1
1672 1
1669 1
1665 1
8465 1
dtype: int64
-------------------------------------------------------------------------------------------------
county 0.0 1874
LOS ANGELES COUNTY 2232
COOK COUNTY 1320
MARICOPA COUNTY 1211
HARRIS COUNTY 1119
ORANGE COUNTY 1056
JEFFERSON COUNTY 1024
MONTGOMERY COUNTY 906
WASHINGTON COUNTY 837
WAYNE COUNTY 810
DALLAS COUNTY 793
FRANKLIN COUNTY 759
SAN DIEGO COUNTY 754
CLARK COUNTY 667
KINGS COUNTY 647
MIDDLESEX COUNTY 639
JACKSON COUNTY 623
MARION COUNTY 606
TARRANT COUNTY 559
LAKE COUNTY 559
SAN BERNARDINO COUNTY 552
MIAMI-DADE COUNTY 534
BEXAR COUNTY 528
SUFFOLK COUNTY 517
KING COUNTY 505
RIVERSIDE COUNTY 504
ESSEX COUNTY 503
EL PASO COUNTY 494
DOUGLAS COUNTY 479
SHELBY COUNTY 450
HENNEPIN COUNTY 443
...
PICKETT COUNTY 2
ECHOLS COUNTY 2
DIVIDE COUNTY 2
TOWNER COUNTY 2
DUNDY COUNTY 2
GLASSCOCK COUNTY 2
BRISCOE COUNTY 2
HODGEMAN COUNTY 2
LUCE COUNTY 2
TREUTLEN COUNTY 2
YAKUTAT CITY AND BOROUGH 2
RAPPAHANNOCK COUNTY 2
BANNER COUNTY 2
SCHLEY COUNTY 2
HAYES COUNTY 2
LAKE OF THE WOODS COUNTY 2
CULBERSON COUNTY 2
HOOKER COUNTY 2
IRION COUNTY 2
GOSPER COUNTY 2
COTTLE COUNTY 1
TALIAFERRO COUNTY 1
EMPORIA CITY 1
GLASCOCK COUNTY 1
SKAGWAY MUNICIPALITY 1
KENEDY COUNTY 1
MOTLEY COUNTY 1
HINSDALE COUNTY 1
BORDEN COUNTY 1
FALLS CHURCH CITY 1
dtype: int64
-------------------------------------------------------------------------------------------------
students_g9_g12 0.734854755032 2821
NaN 72805
0 677
1 399
2 238
3 168
4 162
7 127
5 124
8 122
9 119
11 119
6 118
19 114
12 107
13 107
14 103
21 102
10 93
15 93
18 93
28 90
16 88
17 88
27 85
25 84
23 83
35 82
20 82
37 80
33 79
...
2535 1
2539 1
2476 1
2540 1
2541 1
2026 1
2544 1
2546 1
2550 1
2024 1
2524 1
2517 1
2516 1
2514 1
2477 1
1710 1
2488 1
2037 1
2490 1
2491 1
2492 1
2495 1
1386 1
2497 1
2501 1
2504 1
2506 1
2510 1
2511 1
9650 1
dtype: int64
-------------------------------------------------------------------------------------------------
total_race 0.0404848900822 2860
NaN 4011
0 320
1 185
2 169
415 167
390 164
342 163
418 161
504 154
395 153
3 153
455 152
355 151
393 151
410 151
480 150
414 149
374 148
295 148
481 147
400 146
8 146
437 146
474 145
424 145
389 144
401 144
454 144
479 143
510 143
...
2560 1
2561 1
2565 1
2566 1
2567 1
2571 1
2572 1
2575 1
2576 1
2583 1
2584 1
2541 1
2540 1
2539 1
2521 1
2507 1
2509 1
2511 1
2513 1
2515 1
2517 1
2524 1
2538 1
2526 1
2527 1
2528 1
2530 1
2533 1
2535 1
13300 1
dtype: int64
-------------------------------------------------------------------------------------------------
total_students 0.0402628338414 2860
NaN 3989
0 327
1 186
2 170
415 167
390 164
342 163
418 161
504 154
395 153
3 153
455 152
355 151
393 151
410 151
480 150
414 149
374 148
295 148
481 147
400 146
8 146
437 146
474 145
424 145
389 144
401 144
454 144
479 143
510 143
...
2560 1
2561 1
2565 1
2566 1
2567 1
2571 1
2572 1
2575 1
2576 1
2583 1
2584 1
2541 1
2540 1
2539 1
2521 1
2507 1
2509 1
2511 1
2513 1
2515 1
2517 1
2524 1
2538 1
2526 1
2527 1
2528 1
2530 1
2533 1
2535 1
13300 1
dtype: int64
-------------------------------------------------------------------------------------------------
pupil_teacher_ratio 0.089771282072 3814
NaN 8894
15.00 244
16.00 228
14.00 207
17.00 174
13.00 171
12.00 167
18.00 162
20.00 139
10.00 137
14.50 135
15.38 128
15.50 126
16.67 125
15.33 122
16.50 120
14.76 120
16.19 119
15.64 118
8.00 117
15.80 117
14.67 117
14.33 116
14.09 116
14.80 116
15.67 115
11.00 115
14.84 114
17.14 114
14.29 113
...
2.05 1
32.23 1
1103.33 1
37.36 1
35.14 1
124.89 1
42.86 1
0.54 1
40.27 1
46.36 1
33.02 1
2216.42 1
425.00 1
55.33 1
2726.19 1
31.60 1
35.54 1
34.22 1
74.47 1
36.73 1
45.45 1
3.78 1
34.67 1
0.76 1
83.44 1
35.31 1
43.43 1
61.26 1
33.93 1
29.79 1
dtype: int64
-------------------------------------------------------------------------------------------------
teacher_fulltime 0.0716837919131 9821
NaN 7102
23.00 806
1.00 801
25.00 771
22.00 756
26.00 755
24.00 747
20.00 743
27.00 732
18.00 691
21.00 687
17.00 681
29.00 660
28.00 659
19.00 649
30.00 633
31.00 572
16.00 565
32.00 553
33.00 547
15.00 538
2.00 532
34.00 525
14.00 519
0.00 517
35.00 499
36.00 476
37.00 458
10.00 438
13.00 437
...
96.37 1
111.02 1
74.88 1
90.81 1
54.66 1
69.62 1
71.02 1
101.63 1
82.03 1
133.17 1
149.46 1
145.54 1
61.51 1
121.02 1
191.14 1
96.04 1
52.37 1
98.01 1
169.70 1
120.49 1
103.31 1
62.87 1
101.30 1
74.12 1
78.72 1
111.49 1
101.79 1
146.78 1
94.92 1
67.38 1
dtype: int64
-------------------------------------------------------------------------------------------------
agency_id_state 0.19356238771 12468
NaN 19177
1964733 983
001 667
13 655
16 570
02 504
06 407
29 340
792 286
50 271
03 270
029 261
48 252
05 244
30 241
15 234
3768338 225
126515001 214
12 195
36 188
0880 184
920 182
600 181
52 180
190 179
01 178
1420 175
056275000 173
3619 165
53 163
...
79072 1
1189 1
010180 1
211701040000 1
59-C002 1
013030 1
295220 1
09730 1
90758 1
01109 1
009964 1
115223050 1
321000860999 1
5H 1
040204040000 1
T246 1
120450003 1
120450002 1
105250004 1
012557 1
105250001 1
774002000 1
419000000000 1
580303020000 1
33202 1
33205 1
20403 1
20402 1
89829 1
91309 1
dtype: int64
-------------------------------------------------------------------------------------------------
city 0.0 12674
HOUSTON 790
CHICAGO 600
BROOKLYN 593
LOS ANGELES 572
SAN ANTONIO 494
BRONX 446
PHOENIX 441
DALLAS 400
NEW YORK 358
COLUMBUS 354
TUCSON 325
PHILADELPHIA 316
BALTIMORE 314
MIAMI 309
WASHINGTON 306
SAN DIEGO 291
LAS VEGAS 285
SPRINGFIELD 284
JACKSONVILLE 265
AUSTIN 264
MEMPHIS 260
EL PASO 250
CLEVELAND 241
SAN JOSE 239
RICHMOND 232
FORT WORTH 230
INDIANAPOLIS 227
DENVER 224
DETROIT 210
KANSAS CITY 208
...
TAPPAN 1
BRANCHLAND 1
POWDERVILLE 1
GLEN ELLEN 1
SULPHUR ROCK 1
NESCOPECK 1
LANE 1
BECKET 1
SWITZ CITY 1
COVE CITY 1
TOLLESBORO 1
UNION BEACH 1
EAST GREENVILLE 1
PORT WENTWORTH 1
GREENBACK 1
ARABI 1
EAST FALMOUTH 1
TEEC NOS POS. 1
DEATH VALLEY 1
KIVALINA 1
THAWVILLE 1
WEST GARDINER 1
LACOSTE 1
APISON 1
CABAZON 1
RUTHTON 1
HUACHUCA CITY 1
PARKS 1
ROCKHILL FURNACE 1
GIBBSBORO 1
dtype: int64
-------------------------------------------------------------------------------------------------
agency_name 0.0 16784
LOS ANGELES UNIFIED 989
CITY OF CHICAGO SD 299 595
DADE 534
CLARK COUNTY SCHOOL DISTRICT 365
BROWARD 356
HILLSBOROUGH 314
HAWAII DEPARTMENT OF EDUCATION 290
SHELBY CO 290
HOUSTON ISD 284
PALM BEACH 272
ORANGE 256
JEFFERSON COUNTY 256
DALLAS ISD 238
SAN DIEGO UNIFIED 225
FAIRFAX CO PBLC SCHS 218
PHILADELPHIA CITY SD 214
PRINCE GEORGE'S COUNTY PUBLIC SCHOOLS 209
MONTGOMERY COUNTY PUBLIC SCHOOLS 207
DUVAL 207
BALTIMORE CITY PUBLIC SCHOOLS 189
SCHOOL DISTRICT NO. 1 IN THE COUNTY OF DENVER AND STATE OF C 184
BALTIMORE COUNTY PUBLIC SCHOOLS 173
WAKE COUNTY SCHOOLS 171
PINELLAS 170
CHARLOTTE-MECKLENBURG SCHOOLS 165
MILWAUKEE SCHOOL DISTRICT 165
JEFFERSON COUNTY SCHOOL DISTRICT NO. R-1 164
POLK 162
ALBUQUERQUE PUBLIC SCHOOLS 162
DAVIDSON COUNTY 158
...
LEADING EDGE ACADEMY MARICOPA 1
ELMWOOD VILLAGE CHARTER SCHOOL 1
LEGACY SCHOOLS 1
HILLSIDE SD 93 1
GRAND RAPIDS ELLINGTON ACADEMY OF ARTS & TECHNOLOGY 1
SIDNEY ISD 1
EVERGREEN COMMUNITY CS 1
MADISON-CARVER ACADEMY 1
KANKAKEE AREA SPEC EDUC COOP 1
GRANT ELEM 1
STRATFORD COMM SCHOOL DISTRICT 1
DUAL IMMERSION ACADEMY 1
SHREWSBURY SCHOOL DISTRICT 1
HIGHLAND JOINT DISTRICT 1
CHARLOTTE LEARNING ACADEMY 1
SALINE COUNTY VOCATIONAL CENTER 1
WOODSON ISD 1
NYS OFFICE FOR PEOPLE WITH DEVELOPMENTAL DISABILITIES 1
EASTAMPTON TOWNSHIP SCHOOL DISTRICT 1
WHITING SCHOOL DISTRICT 1
LAMBERT H S 1
SOUTHERN WORCESTER COUNTY REGIONAL VOCATIONAL TECHNICAL 1
COUNTRY GARDENS CHARTER SCHOOLS 1
KAIZEN EDUCATION FOUNDATION DBA SUMMIT HIGH SCHOOL 1
TRI-RIVERS 1
STATE CHARTER SCHOOLS- IVY PREPARATORY YOUNG MEN'S LEADERSH 1
SUGAR VALLEY RURAL CS 1
TRINITY CENTER ELEMENTARY 1
ARISTOTLE PREPARATORY ACADEMY 1
DETROIT SERVICE LEARNING ACADEMY 1
dtype: int64
-------------------------------------------------------------------------------------------------
agency_id_nces 0.0 17259
622710 989
1709930 595
1200390 534
3200060 365
1200180 356
1200870 314
4700148 290
1500030 290
4823640 284
1201500 272
1201440 253
4816230 238
634320 225
5101260 218
4218990 214
2400510 209
1200480 207
2400480 207
2400090 189
803360 184
2102990 174
2400120 173
3704720 171
1201560 170
5509600 165
3702970 165
804800 164
1201590 162
3500060 162
4703180 158
...
3007080 1
3905116 1
3601034 1
2601060 1
2800003 1
2600994 1
2928770 1
2605100 1
1800064 1
600113 1
627900 1
4110200 1
1704020 1
5005400 1
2601058 1
3901541 1
3500153 1
3027090 1
1300180 1
3307360 1
4280510 1
4826970 1
1100045 1
1708310 1
4800265 1
3600115 1
618810 1
1726180 1
2101590 1
904350 1
dtype: int64
-------------------------------------------------------------------------------------------------
zipcode 0.0 22646
10456 46
78572 44
10457 42
78577 42
78521 42
11212 39
85364 37
93257 37
78539 36
78586 36
90011 36
55441 36
85705 35
11207 35
60623 35
76904 34
88001 34
10002 34
10029 33
93065 33
11206 32
78501 31
85706 31
93274 30
90255 30
66062 30
11221 30
93706 30
78130 29
33610 29
..
78827 1
68588 1
66541 1
70639 1
38473 1
95075 1
24101 1
37727 1
28438 1
44814 1
83462 1
26288 1
23238 1
65334 1
2764 1
60112 1
71417 1
4347 1
28374 1
2828 1
45851 1
24272 1
95925 1
31554 1
2892 1
85618 1
30293 1
35112 1
98628 1
22840 1
dtype: int64
-------------------------------------------------------------------------------------------------
school_id_state 0.19356238771 56252
NaN 19177
050 415
0020 415
0040 390
0060 282
01 264
060 234
0100 218
02 213
0080 202
0010 188
03 171
0030 164
070 157
030 143
0050 139
080 134
04 132
000 128
0110 120
040 117
0120 115
61 115
0025 105
0015 104
0005 100
51 99
090 94
100 92
0070 92
...
660900010023 1
660900010022 1
0108076 1
2544 1
6017073 1
6020093 1
000737 1
908 1
102525 1
905 1
907 1
906 1
901 1
903 1
902 1
6000681 1
4344 1
0400008 1
11441 1
4345 1
6066963 1
6057723 1
102107 1
041201011 1
57202 1
1220020 1
57204 1
041201016 1
6013973 1
3517 1
dtype: int64
-------------------------------------------------------------------------------------------------
latitude 0.19356238771 58265
NaN 19177
44.9997 22
34.5132 11
40.7655 10
40.8772 10
40.8220 10
34.2782 10
25.7897 10
40.7749 9
33.9205 9
37.7617 8
35.1583 8
45.0770 8
44.9012 8
45.3122 8
25.7898 8
39.3994 8
40.8401 8
40.6974 8
40.7174 8
41.1775 8
40.6695 8
40.7931 8
32.7201 8
34.6602 8
41.9499 8
44.7902 8
42.8662 8
40.8399 8
48.0598 7
...
45.9265 1
39.6350 1
42.3310 1
46.1962 1
32.9013 1
39.0720 1
44.8320 1
42.2052 1
47.6712 1
40.8452 1
37.4883 1
40.8964 1
41.5038 1
37.9900 1
40.2128 1
29.9907 1
33.6195 1
28.1122 1
34.9563 1
48.1741 1
39.2035 1
26.0781 1
30.2351 1
36.6754 1
41.7749 1
35.9358 1
41.8018 1
42.0241 1
44.7382 1
35.8278 1
dtype: int64
-------------------------------------------------------------------------------------------------
longitude 0.19356238771 66136
NaN 19177
-93.4497 20
-110.0948 11
-80.1895 10
-118.7885 10
-73.8558 10
-73.9860 9
-73.9816 8
-93.4699 8
-94.1911 8
-73.9178 8
-73.8085 8
-104.7817 8
-73.9856 8
-73.9561 7
-94.0095 7
-93.5756 7
-73.8603 7
-73.9125 7
-117.7461 7
-118.2247 7
-73.9514 7
-73.9874 7
-73.9113 7
-73.9790 7
-93.4212 7
-73.0475 7
-73.9894 7
-84.3888 7
-95.0137 7
...
-81.5094 1
-81.7144 1
-96.1267 1
-76.9711 1
-117.1034 1
-80.2791 1
-80.0616 1
-157.7887 1
-73.8914 1
-93.1560 1
-122.6073 1
-86.3738 1
-83.4921 1
-76.1220 1
-89.0250 1
-79.8160 1
-82.7050 1
-123.1593 1
-117.1685 1
-84.5540 1
-71.4747 1
-92.9933 1
-78.8578 1
-92.3390 1
-81.1206 1
-116.5999 1
-111.8182 1
-70.7238 1
-77.4027 1
-124.1397 1
dtype: int64
-------------------------------------------------------------------------------------------------
School Name 0.0 84516
LINCOLN ELEMENTARY SCHOOL 89
LINCOLN ELEMENTARY 73
WASHINGTON ELEMENTARY SCHOOL 70
JEFFERSON ELEMENTARY 67
CENTRAL ELEMENTARY SCHOOL 64
WASHINGTON ELEMENTARY 55
JEFFERSON ELEMENTARY SCHOOL 51
CENTRAL ELEMENTARY 42
ROOSEVELT ELEMENTARY SCHOOL 40
ROOSEVELT ELEMENTARY 39
CENTRAL HIGH SCHOOL 37
FRANKLIN ELEMENTARY 36
LIBERTY ELEMENTARY SCHOOL 35
FRANKLIN ELEMENTARY SCHOOL 33
LINCOLN SCHOOL 33
LINCOLN ELEM SCHOOL 33
EARLY CHILDHOOD CENTER 32
NORTH ELEMENTARY SCHOOL 31
EAST ELEMENTARY SCHOOL 31
WILSON ELEMENTARY 29
MOUNTAIN VIEW ELEMENTARY 29
MADISON ELEMENTARY 28
CENTRAL MIDDLE SCHOOL 28
HIGHLAND ELEMENTARY SCHOOL 27
WASHINGTON ELEM SCHOOL 27
MCKINLEY ELEMENTARY 26
WEST ELEMENTARY SCHOOL 25
LINCOLN MIDDLE SCHOOL 25
GARFIELD ELEMENTARY SCHOOL 24
RIVERSIDE ELEMENTARY SCHOOL 24
..
OKLAHOMA EL SCH 1
LANOKA HARBOR ELEMENTARY SCHOOL 1
INCHELIUM MIDDLE SCHOOL 1
TRI-COUNTY ROP 1
PSJA SONIA M SOTOMAYOR H S 1
BREWTON ELEM SCH 1
HORACE MANN J H 1
LUDINGTON MAGNET MIDDLE SCHOOL 1
PAINT VALLEY MIDDLE SCHOOL 1
EASLEY ELEMENTARY 1
PRINCE WILLIAM JUV. DETENTION HOME 1
NORTHWEST ARKANSAS CLASSICAL ACADEMY 1
VIBES PUBLIC CHARTER SCHOOL 1
KARIGON ELEMENTARY SCHOOL 1
COPPERGATE ELEMENTARY SCHOOL 1
RAMAH ELEMENTARY 1
WATFORD CITY HIGH SCHOOL 1
CUSTER COUNTY HIGH SCHOOL 1
TALIHINA ES 1
WICHITA COUNTY JUNIOR-SENIOR HIGH SCHOOL 1
SOUTH CARROLL HIGH 1
MD ACADEMY OF TECHNOLOGY AND HEALTH SCIENCES 1
ZICCOLELLA MIDDLE SCHOOL 1
CHRISTIAN COUNTY HIGH SCHOOL 1
PS 87 MIDDLE VILLAGE 1
MCMURRAY EL SCH 1
LEAWOOD ELEMENTARY 1
GLENN COUNTY JUVENILE COURT 1
ADAIR CO. HIGH 1
VIRGINIA WILLIAMSON ELEM 1
dtype: int64
-------------------------------------------------------------------------------------------------
rowid 0.0 99074
2047 1
96890 1
2708 1
661 1
6806 1
4759 1
27288 1
25241 1
31386 1
29339 1
19100 1
17053 1
23198 1
21151 1
98981 1
76464 1
74417 1
80562 1
78515 1
68276 1
66229 1
72374 1
70327 1
12947 1
14994 1
8849 1
33413 1
84604 1
82557 1
88702 1
..
58742 1
60791 1
38264 1
40313 1
34170 1
25958 1
30052 1
42302 1
70984 1
44351 1
87360 1
89409 1
83266 1
85315 1
95556 1
97605 1
91462 1
93511 1
73033 1
19811 1
66890 1
68939 1
79180 1
81229 1
75086 1
77135 1
21856 1
23905 1
17762 1
0 1
dtype: int64
-------------------------------------------------------------------------------------------------
school_id_nces 0.0 99074
62271012856 1
10123000450 1
180657001143 1
90042000041 1
490000501404 1
173474003634 1
60133211730 1
10135000841 1
302796000781 1
120168004201 1
390468903553 1
250216000176 1
220033000257 1
120156001698 1
464164000391 1
390450401951 1
482145008399 1
170020803239 1
550468000502 1
80480000702 1
302275000986 1
390480403094 1
62181002590 1
260858008255 1
64158012071 1
470085001897 1
360008606393 1
64059006703 1
320036000190 1
62271003209 1
..
370488001954 1
61209001357 1
62955009420 1
410264000165 1
360585000356 1
293165002903 1
193129001822 1
261611005262 1
64158010715 1
280162000241 1
272520001219 1
290100000305 1
362166003070 1
60797007673 1
360663000446 1
370096000371 1
360110806384 1
130174001586 1
530267002208 1
260390004078 1
362895003917 1
251323002239 1
360011902412 1
550960002340 1
470255000913 1
390484303251 1
170011205381 1
62271012205 1
62460003690 1
341596005410 1
dtype: int64
In [7]:
# Identified list of columns that are amenable for standardization.
STANDARDIZABLE = ['lunch_free_eligible', 'lunch_reduced_eligible', 'students_g1_g8', 'students_g9_g12', 'students_ug', 'students_m', 'students_f', 'students_an', 'students_a', 'students_h', 'students_b', 'students_w', 'students_hp', 'students_mr', 'teacher_fulltime']
In [8]:
print INVALID_COLUMNS
print '---------------------------------------------------------------------------------------------'
print INDICATOR_COLUMNS
print '---------------------------------------------------------------------------------------------'
print STANDARDIZABLE
['students_ug', 'gug_m', 'gug_f', 'gug_an_m', 'gug_an_f', 'gug_a_m', 'gug_a_f', 'gug_h_m', 'gug_h_f', 'gug_b_m', 'gug_b_f', 'gug_w_m', 'gug_w_f', 'gug_hp_m', 'gug_hp_f', 'gug_mr_m', 'gug_mr_f']
---------------------------------------------------------------------------------------------
['school_type', 'agency_type', 'operational', 'charter_school', 'magnet_school', 'shared_time_school', 'title1_school_wide', 'title1_eligible', 'title1_status', 'virtual_school', 'lunch_program', 'offered_pk', 'offered_k', 'offered_g1', 'offered_g2', 'offered_g3', 'offered_g4', 'offered_g5', 'offered_g6', 'offered_g7', 'offered_g8', 'offered_g9', 'offered_g10', 'offered_g11', 'offered_g12', 'offered_ug']
---------------------------------------------------------------------------------------------
['lunch_free_eligible', 'lunch_reduced_eligible', 'students_g1_g8', 'students_g9_g12', 'students_ug', 'students_m', 'students_f', 'students_an', 'students_a', 'students_h', 'students_b', 'students_w', 'students_hp', 'students_mr', 'teacher_fulltime']
In [9]:
school_dftouse = school_df.copy(deep=True)
In [10]:
#Renaming Indicators columns list
for i, icol in enumerate(INDICATOR_COLUMNS):
school_dftouse.rename(columns={icol : 'i_'+icol}, inplace=True)
INDICATOR_COLUMNS[i] = 'i_'+icol
In [11]:
#Adding teacher_fulltime to indicators list
school_dftouse['i_teacher_fulltime']=1*(school_dftouse.teacher_fulltime > 0)
INDICATOR_COLUMNS.append('i_teacher_fulltime')
In [12]:
#Adding few indicator columns to STANDARDIZABLE list
for i, icol in enumerate(INDICATOR_COLUMNS):
if icol not in (u'i_school_type', u'i_operational', u'i_title1_status', u'i_agency_type'):
STANDARDIZABLE.append(icol)
In [13]:
INDICATOR_COLUMNS
Out[13]:
['i_school_type',
'i_agency_type',
'i_operational',
'i_charter_school',
'i_magnet_school',
'i_shared_time_school',
'i_title1_school_wide',
'i_title1_eligible',
'i_title1_status',
'i_virtual_school',
'i_lunch_program',
'i_offered_pk',
'i_offered_k',
'i_offered_g1',
'i_offered_g2',
'i_offered_g3',
'i_offered_g4',
'i_offered_g5',
'i_offered_g6',
'i_offered_g7',
'i_offered_g8',
'i_offered_g9',
'i_offered_g10',
'i_offered_g11',
'i_offered_g12',
'i_offered_ug',
'i_teacher_fulltime']
In [14]:
STANDARDIZABLE
Out[14]:
['lunch_free_eligible',
'lunch_reduced_eligible',
'students_g1_g8',
'students_g9_g12',
'students_ug',
'students_m',
'students_f',
'students_an',
'students_a',
'students_h',
'students_b',
'students_w',
'students_hp',
'students_mr',
'teacher_fulltime',
'i_charter_school',
'i_magnet_school',
'i_shared_time_school',
'i_title1_school_wide',
'i_title1_eligible',
'i_virtual_school',
'i_lunch_program',
'i_offered_pk',
'i_offered_k',
'i_offered_g1',
'i_offered_g2',
'i_offered_g3',
'i_offered_g4',
'i_offered_g5',
'i_offered_g6',
'i_offered_g7',
'i_offered_g8',
'i_offered_g9',
'i_offered_g10',
'i_offered_g11',
'i_offered_g12',
'i_offered_ug',
'i_teacher_fulltime']
In [ ]:
Content source: ashwindeo/dataschoolers
Similar notebooks: