R programming for beginners (GV900)

Lesson 3: Data table ~ select & mutate columns

Wednesday, December 27, 2023

Video of Lesson 3

1 library R packages

Code
# install.packages("tidyverse")
# install.packages("carData")

library(tidyverse)

library(carData)

2 Review row tidying

2.1 distinct

Code
BEPS |> 
  distinct(vote)
               vote
1  Liberal Democrat
2            Labour
24     Conservative

. . .

2.2 filter rows

Code
BEPS |> 
  filter(vote == "Labour") |> 
  head()
    vote age economic.cond.national economic.cond.household Blair Hague Kennedy
2 Labour  36                      4                       4     4     4       4
3 Labour  35                      4                       4     5     2       3
4 Labour  24                      4                       2     2     1       3
5 Labour  41                      2                       2     1     1       4
6 Labour  47                      3                       4     4     4       2
8 Labour  77                      3                       4     4     1       4
  Europe political.knowledge gender
2      5                   2   male
3      3                   2   male
4      4                   0 female
5      6                   2   male
6      4                   2   male
8      1                   0   male
Code
BEPS |> 
  filter(vote == "Labour" | vote == "Conservative")|> 
  head()
    vote age economic.cond.national economic.cond.household Blair Hague Kennedy
2 Labour  36                      4                       4     4     4       4
3 Labour  35                      4                       4     5     2       3
4 Labour  24                      4                       2     2     1       3
5 Labour  41                      2                       2     1     1       4
6 Labour  47                      3                       4     4     4       2
8 Labour  77                      3                       4     4     1       4
  Europe political.knowledge gender
2      5                   2   male
3      3                   2   male
4      4                   0 female
5      6                   2   male
6      4                   2   male
8      1                   0   male

. . .

Code
BEPS |> 
  filter(vote  %in% c("Labour", "Conservative"))|> 
  head()
    vote age economic.cond.national economic.cond.household Blair Hague Kennedy
2 Labour  36                      4                       4     4     4       4
3 Labour  35                      4                       4     5     2       3
4 Labour  24                      4                       2     2     1       3
5 Labour  41                      2                       2     1     1       4
6 Labour  47                      3                       4     4     4       2
8 Labour  77                      3                       4     4     1       4
  Europe political.knowledge gender
2      5                   2   male
3      3                   2   male
4      4                   0 female
5      6                   2   male
6      4                   2   male
8      1                   0   male

. . .

Code
BEPS |> 
  filter(vote != "Labour")|> 
  head()
               vote age economic.cond.national economic.cond.household Blair
1  Liberal Democrat  43                      3                       3     4
7  Liberal Democrat  57                      2                       2     4
22 Liberal Democrat  53                      2                       1     2
24     Conservative  44                      2                       4     4
25     Conservative  60                      3                       2     4
27     Conservative  56                      2                       2     2
   Hague Kennedy Europe political.knowledge gender
1      1       4      2                   2 female
7      4       2     11                   2   male
22     4       4      5                   2   male
24     4       4      9                   2   male
25     4       4      2                   2 female
27     4       4      9                   2 female

. . .

2.3 arrange

Code
BEPS |> 
  arrange(-age)|> 
  head()
             vote age economic.cond.national economic.cond.household Blair
1143 Conservative  93                      4                       4     5
132  Conservative  92                      3                       3     4
355  Conservative  92                      3                       3     2
1292       Labour  91                      4                       3     4
182  Conservative  90                      4                       4     2
119        Labour  89                      4                       3     4
     Hague Kennedy Europe political.knowledge gender
1143     5       2      6                   2 female
132      4       3      8                   2 female
355      4       2      6                   0 female
1292     4       3      2                   3   male
182      4       4     11                   3 female
119      4       3      4                   2 female

. . .

Code
BEPS |> 
  arrange(gender)|> 
  head()
               vote age economic.cond.national economic.cond.household Blair
1  Liberal Democrat  43                      3                       3     4
4            Labour  24                      4                       2     2
9            Labour  39                      3                       3     4
11           Labour  39                      3                       3     1
13           Labour  59                      4                       4     4
14           Labour  66                      3                       3     2
   Hague Kennedy Europe political.knowledge gender
1      1       4      2                   2 female
4      1       3      4                   0 female
9      4       4     11                   0 female
11     2       1      7                   0 female
13     1       4     10                   2 female
14     5       4      8                   0 female

. . .

Code
starwars |> 
  arrange(name)|> 
  head()
# A tibble: 6 × 14
  name      height  mass hair_color skin_color eye_color birth_year sex   gender
  <chr>      <int> <dbl> <chr>      <chr>      <chr>          <dbl> <chr> <chr> 
1 Ackbar       180    83 none       brown mot… orange          41   male  mascu…
2 Adi Gall…    184    50 none       dark       blue            NA   fema… femin…
3 Anakin S…    188    84 blond      fair       blue            41.9 male  mascu…
4 Arvel Cr…     NA    NA brown      fair       brown           NA   male  mascu…
5 Ayla Sec…    178    55 none       blue       hazel           48   fema… femin…
6 BB8           NA    NA none       none       black           NA   none  mascu…
# ℹ 5 more variables: homeworld <chr>, species <chr>, films <list>,
#   vehicles <list>, starships <list>

. . .

Code
starwars |> 
  arrange(desc(name))|> 
  head()
# A tibble: 6 × 14
  name      height  mass hair_color skin_color eye_color birth_year sex   gender
  <chr>      <int> <dbl> <chr>      <chr>      <chr>          <dbl> <chr> <chr> 
1 Zam Wese…    168    55 blonde     fair, gre… yellow            NA fema… femin…
2 Yoda          66    17 white      green      brown            896 male  mascu…
3 Yarael P…    264    NA none       white      yellow            NA male  mascu…
4 Wilhuff …    180    NA auburn, g… fair       blue              64 male  mascu…
5 Wicket S…     88    20 brown      brown      brown              8 male  mascu…
6 Wedge An…    170    77 brown      fair       hazel             21 male  mascu…
# ℹ 5 more variables: homeworld <chr>, species <chr>, films <list>,
#   vehicles <list>, starships <list>

3 select column (variable)

Code
BEPS |>
  select(vote, age, gender)|> 
  head()
              vote age gender
1 Liberal Democrat  43 female
2           Labour  36   male
3           Labour  35   male
4           Labour  24 female
5           Labour  41   male
6           Labour  47   male
Code
BEPS |>
  select(Vote = vote, 
         Age = age, 
         Gender = gender)|> 
  head()
              Vote Age Gender
1 Liberal Democrat  43 female
2           Labour  36   male
3           Labour  35   male
4           Labour  24 female
5           Labour  41   male
6           Labour  47   male
Code
BEPS |>
  select(Vote = vote, 
         Gender = gender,
         Age = age)|> 
  head()
              Vote Gender Age
1 Liberal Democrat female  43
2           Labour   male  36
3           Labour   male  35
4           Labour female  24
5           Labour   male  41
6           Labour   male  47
Code
BEPS |>
  select(Vote = vote, 
         Age = age, 
         Gender = gender,
         everything())|> 
  head()
              Vote Age Gender economic.cond.national economic.cond.household
1 Liberal Democrat  43 female                      3                       3
2           Labour  36   male                      4                       4
3           Labour  35   male                      4                       4
4           Labour  24 female                      4                       2
5           Labour  41   male                      2                       2
6           Labour  47   male                      3                       4
  Blair Hague Kennedy Europe political.knowledge
1     4     1       4      2                   2
2     4     4       4      5                   2
3     5     2       3      3                   2
4     2     1       3      4                   0
5     1     1       4      6                   2
6     4     4       2      4                   2
Code
BEPS |> 
  select(3:5)|> 
  head()
  economic.cond.national economic.cond.household Blair
1                      3                       3     4
2                      4                       4     4
3                      4                       4     5
4                      4                       2     2
5                      2                       2     1
6                      3                       4     4
Code
BEPS |> 
  select(-3, -5)|> 
  head()
              vote age economic.cond.household Hague Kennedy Europe
1 Liberal Democrat  43                       3     1       4      2
2           Labour  36                       4     4       4      5
3           Labour  35                       4     2       3      3
4           Labour  24                       2     1       3      4
5           Labour  41                       2     1       4      6
6           Labour  47                       4     4       2      4
  political.knowledge gender
1                   2 female
2                   2   male
3                   2   male
4                   0 female
5                   2   male
6                   2   male
Code
BEPS |> 
  select(-(3:5))|> 
  head()
              vote age Hague Kennedy Europe political.knowledge gender
1 Liberal Democrat  43     1       4      2                   2 female
2           Labour  36     4       4      5                   2   male
3           Labour  35     2       3      3                   2   male
4           Labour  24     1       3      4                   0 female
5           Labour  41     1       4      6                   2   male
6           Labour  47     4       2      4                   2   male

4 mutate: create new column (variable)

Code
BEPS |> 
  mutate(economic = economic.cond.national + economic.cond.household,
         .before = economic.cond.national)|> 
  head()
              vote age economic economic.cond.national economic.cond.household
1 Liberal Democrat  43        6                      3                       3
2           Labour  36        8                      4                       4
3           Labour  35        8                      4                       4
4           Labour  24        6                      4                       2
5           Labour  41        4                      2                       2
6           Labour  47        7                      3                       4
  Blair Hague Kennedy Europe political.knowledge gender
1     4     1       4      2                   2 female
2     4     4       4      5                   2   male
3     5     2       3      3                   2   male
4     2     1       3      4                   0 female
5     1     1       4      6                   2   male
6     4     4       2      4                   2   male
Code
BEPS |> 
  mutate(female = ifelse(gender == "male", 0, 1),
         age_span = ifelse(age <= 35, "young",
                           ifelse(age <= 55, "middle", "old")),
         .before = age)|> 
  head()
              vote female age_span age economic.cond.national
1 Liberal Democrat      1   middle  43                      3
2           Labour      0   middle  36                      4
3           Labour      0    young  35                      4
4           Labour      1    young  24                      4
5           Labour      0   middle  41                      2
6           Labour      0   middle  47                      3
  economic.cond.household Blair Hague Kennedy Europe political.knowledge gender
1                       3     4     1       4      2                   2 female
2                       4     4     4       4      5                   2   male
3                       4     5     2       3      3                   2   male
4                       2     2     1       3      4                   0 female
5                       2     1     1       4      6                   2   male
6                       4     4     4       2      4                   2   male
Code
BEPS |> 
  mutate(education = sample(x = 7:20, size = 1525, replace = TRUE)) 
                 vote age economic.cond.national economic.cond.household Blair
1    Liberal Democrat  43                      3                       3     4
2              Labour  36                      4                       4     4
3              Labour  35                      4                       4     5
4              Labour  24                      4                       2     2
5              Labour  41                      2                       2     1
6              Labour  47                      3                       4     4
7    Liberal Democrat  57                      2                       2     4
8              Labour  77                      3                       4     4
9              Labour  39                      3                       3     4
10             Labour  70                      3                       2     5
11             Labour  39                      3                       3     1
12             Labour  66                      4                       3     4
13             Labour  59                      4                       4     4
14             Labour  66                      3                       3     2
15             Labour  77                      2                       3     2
16             Labour  51                      4                       4     4
17             Labour  43                      2                       4     1
18             Labour  41                      4                       4     5
19             Labour  79                      3                       3     4
20             Labour  37                      3                       1     1
21             Labour  38                      3                       3     4
22   Liberal Democrat  53                      2                       1     2
23             Labour  59                      3                       3     4
24       Conservative  44                      2                       4     4
25       Conservative  60                      3                       2     4
26             Labour  51                      3                       3     4
27       Conservative  56                      2                       2     2
28             Labour  51                      3                       2     4
29             Labour  44                      3                       3     4
30             Labour  61                      4                       3     5
31             Labour  55                      3                       3     4
32             Labour  66                      3                       2     2
33             Labour  59                      3                       3     2
34             Labour  62                      4                       3     4
35       Conservative  76                      3                       4     4
36             Labour  41                      3                       1     4
37             Labour  27                      2                       2     2
38             Labour  52                      4                       3     4
39             Labour  48                      3                       3     4
40       Conservative  72                      1                       3     2
41             Labour  42                      4                       4     4
42             Labour  48                      3                       2     4
43             Labour  66                      1                       1     4
44             Labour  52                      3                       3     4
45             Labour  37                      4                       3     4
46       Conservative  52                      2                       2     4
47   Liberal Democrat  54                      2                       3     4
48       Conservative  50                      2                       2     1
49             Labour  46                      4                       3     4
50             Labour  62                      5                       3     5
51             Labour  61                      3                       3     4
52             Labour  33                      2                       3     4
53             Labour  51                      4                       3     5
54             Labour  59                      4                       4     4
55             Labour  58                      4                       4     5
56             Labour  64                      4                       3     4
57   Liberal Democrat  42                      3                       4     4
58             Labour  32                      1                       2     1
59       Conservative  62                      5                       3     4
60             Labour  71                      2                       3     5
61             Labour  37                      3                       3     4
62             Labour  61                      5                       4     4
63             Labour  28                      4                       1     4
64             Labour  41                      3                       3     4
65             Labour  77                      3                       3     4
66             Labour  34                      3                       4     4
67             Labour  72                      4                       4     4
68             Labour  35                      4                       4     5
69             Labour  68                      4                       4     4
70   Liberal Democrat  67                      4                       3     2
71             Labour  64                      4                       4     4
72             Labour  39                      4                       3     4
73       Conservative  88                      3                       3     4
74   Liberal Democrat  40                      4                       4     4
75             Labour  43                      4                       3     4
76   Liberal Democrat  53                      4                       4     4
77   Liberal Democrat  42                      4                       3     4
78   Liberal Democrat  38                      3                       3     4
79             Labour  66                      2                       1     4
80             Labour  76                      4                       3     4
81             Labour  44                      2                       2     4
82             Labour  43                      2                       4     2
83       Conservative  78                      3                       3     4
84             Labour  47                      3                       4     4
85             Labour  65                      2                       2     4
86   Liberal Democrat  74                      4                       3     4
87       Conservative  53                      3                       4     2
88   Liberal Democrat  28                      2                       3     4
89             Labour  56                      2                       2     4
90   Liberal Democrat  82                      4                       4     4
91             Labour  55                      3                       3     4
92       Conservative  49                      1                       1     2
93       Conservative  77                      3                       4     4
94             Labour  84                      5                       5     5
95             Labour  65                      3                       3     4
96             Labour  81                      4                       4     5
97             Labour  41                      3                       3     4
98             Labour  45                      3                       2     2
99   Liberal Democrat  74                      3                       4     2
100            Labour  67                      3                       4     5
101            Labour  40                      4                       4     4
102            Labour  71                      3                       4     4
103            Labour  49                      3                       3     4
104      Conservative  70                      2                       3     2
105  Liberal Democrat  61                      2                       2     4
106            Labour  60                      1                       3     1
107            Labour  67                      4                       3     4
108            Labour  76                      3                       3     5
109  Liberal Democrat  69                      3                       2     4
110            Labour  31                      1                       1     2
111            Labour  47                      3                       3     4
112            Labour  62                      3                       3     2
113            Labour  56                      3                       3     4
114      Conservative  66                      3                       2     2
115            Labour  62                      3                       3     4
116            Labour  63                      4                       4     5
117            Labour  48                      4                       3     4
118  Liberal Democrat  64                      4                       4     4
119            Labour  89                      4                       3     4
120            Labour  68                      4                       3     4
121      Conservative  81                      2                       4     2
122            Labour  74                      3                       2     4
123            Labour  83                      4                       2     5
124            Labour  57                      4                       4     4
125            Labour  70                      4                       3     4
126      Conservative  79                      3                       3     2
127            Labour  46                      4                       3     4
128            Labour  41                      4                       4     4
129            Labour  53                      4                       3     4
130            Labour  29                      3                       4     2
131            Labour  44                      3                       2     4
132      Conservative  92                      3                       3     4
133      Conservative  73                      2                       2     4
134      Conservative  58                      2                       3     2
135  Liberal Democrat  60                      4                       3     2
136      Conservative  73                      3                       3     2
137      Conservative  76                      4                       3     4
138            Labour  55                      4                       4     4
139      Conservative  49                      3                       3     2
140            Labour  66                      3                       3     2
141            Labour  35                      4                       3     4
142            Labour  62                      4                       3     5
143            Labour  61                      4                       2     4
144            Labour  34                      2                       4     4
145  Liberal Democrat  79                      3                       3     2
146            Labour  39                      4                       2     4
147            Labour  69                      3                       2     4
148            Labour  61                      4                       4     4
149            Labour  50                      3                       3     5
150            Labour  33                      2                       3     4
151            Labour  33                      3                       3     4
152      Conservative  65                      4                       2     1
153            Labour  49                      3                       3     2
154            Labour  72                      4                       4     4
155            Labour  70                      3                       4     5
156            Labour  75                      3                       3     5
157            Labour  24                      3                       5     4
158            Labour  39                      4                       3     5
159  Liberal Democrat  55                      4                       4     2
160            Labour  67                      1                       3     2
161            Labour  37                      4                       4     4
162            Labour  51                      3                       3     4
163      Conservative  79                      2                       3     2
164            Labour  65                      4                       4     4
165            Labour  70                      3                       2     4
166      Conservative  53                      1                       3     1
167            Labour  68                      3                       4     4
168            Labour  83                      3                       4     4
169  Liberal Democrat  35                      3                       3     1
170  Liberal Democrat  31                      3                       3     4
171            Labour  33                      4                       3     4
172            Labour  60                      4                       3     4
173  Liberal Democrat  26                      4                       4     4
174            Labour  51                      4                       4     4
175  Liberal Democrat  42                      4                       3     2
176            Labour  55                      4                       4     4
177  Liberal Democrat  41                      4                       3     4
178      Conservative  40                      3                       2     2
179      Conservative  43                      3                       2     2
180  Liberal Democrat  50                      2                       2     4
181            Labour  47                      4                       4     5
182      Conservative  90                      4                       4     2
183      Conservative  76                      4                       3     1
184  Liberal Democrat  73                      3                       2     4
185      Conservative  52                      3                       3     2
186            Labour  46                      4                       4     2
187      Conservative  70                      5                       2     2
188      Conservative  66                      3                       3     2
189  Liberal Democrat  54                      3                       4     2
190      Conservative  75                      3                       5     4
191            Labour  41                      3                       2     4
192  Liberal Democrat  62                      2                       3     2
193  Liberal Democrat  33                      3                       4     2
194      Conservative  59                      3                       2     4
195      Conservative  73                      3                       3     2
196  Liberal Democrat  46                      3                       3     2
197      Conservative  54                      3                       5     2
198  Liberal Democrat  40                      4                       2     2
199  Liberal Democrat  57                      4                       3     2
200      Conservative  43                      2                       3     1
201  Liberal Democrat  46                      4                       4     4
202  Liberal Democrat  51                      2                       2     4
203  Liberal Democrat  67                      3                       4     4
204      Conservative  65                      3                       3     2
205  Liberal Democrat  42                      2                       3     2
206      Conservative  45                      4                       4     4
207      Conservative  34                      4                       3     1
208  Liberal Democrat  55                      3                       3     4
209  Liberal Democrat  56                      4                       4     2
210      Conservative  39                      2                       2     4
211  Liberal Democrat  35                      3                       2     4
212  Liberal Democrat  45                      3                       3     2
213            Labour  28                      4                       4     4
214      Conservative  49                      3                       3     4
215            Labour  60                      2                       2     4
216      Conservative  34                      1                       1     1
217  Liberal Democrat  56                      2                       3     4
218            Labour  72                      3                       4     2
219            Labour  59                      3                       3     2
220            Labour  33                      4                       4     4
221            Labour  65                      2                       2     4
222  Liberal Democrat  24                      4                       2     4
223            Labour  67                      5                       3     5
224      Conservative  25                      2                       3     1
225            Labour  44                      4                       3     4
226  Liberal Democrat  64                      3                       3     2
227            Labour  58                      3                       2     2
228            Labour  33                      3                       3     4
229            Labour  53                      3                       2     4
230            Labour  68                      2                       3     5
231            Labour  67                      4                       4     5
232            Labour  44                      4                       2     4
233            Labour  77                      3                       3     4
234            Labour  35                      3                       3     2
235            Labour  49                      4                       3     4
236            Labour  36                      4                       4     4
237            Labour  31                      3                       3     2
238            Labour  52                      3                       3     4
239            Labour  29                      4                       4     4
240            Labour  74                      4                       4     5
241            Labour  36                      3                       3     5
242            Labour  47                      3                       1     2
243            Labour  68                      3                       3     2
244            Labour  40                      3                       2     2
245            Labour  59                      4                       3     4
246            Labour  54                      3                       3     5
247      Conservative  65                      3                       3     2
248  Liberal Democrat  54                      3                       3     2
249  Liberal Democrat  24                      4                       3     4
250      Conservative  28                      3                       2     2
251            Labour  79                      3                       3     5
252            Labour  80                      4                       5     4
253            Labour  32                      3                       2     5
254            Labour  32                      3                       2     5
255            Labour  34                      3                       3     2
256            Labour  36                      3                       3     4
257            Labour  53                      3                       4     2
258            Labour  63                      4                       3     4
259            Labour  27                      3                       3     4
260  Liberal Democrat  45                      3                       3     2
261  Liberal Democrat  77                      4                       3     4
262            Labour  57                      4                       3     4
263  Liberal Democrat  75                      4                       2     4
264            Labour  36                      4                       4     2
265            Labour  69                      3                       3     4
266  Liberal Democrat  58                      3                       3     4
267  Liberal Democrat  71                      5                       2     4
268  Liberal Democrat  55                      4                       4     4
269            Labour  38                      2                       4     4
270  Liberal Democrat  37                      4                       4     4
271  Liberal Democrat  44                      2                       3     4
272      Conservative  64                      3                       3     4
273  Liberal Democrat  37                      2                       3     2
274      Conservative  52                      3                       2     2
275  Liberal Democrat  71                      2                       3     4
276      Conservative  49                      3                       3     2
277            Labour  88                      3                       3     4
278      Conservative  63                      2                       4     2
279  Liberal Democrat  74                      4                       3     4
280  Liberal Democrat  29                      3                       5     4
281  Liberal Democrat  66                      3                       3     4
282  Liberal Democrat  43                      3                       4     1
283            Labour  71                      2                       2     2
284  Liberal Democrat  42                      3                       3     2
285  Liberal Democrat  79                      2                       2     2
286            Labour  61                      3                       3     1
287      Conservative  74                      4                       4     4
288  Liberal Democrat  54                      2                       3     2
289            Labour  81                      4                       4     4
290      Conservative  47                      4                       3     2
291      Conservative  75                      2                       3     4
292      Conservative  60                      1                       2     2
293  Liberal Democrat  51                      3                       3     4
294      Conservative  47                      4                       1     4
295      Conservative  70                      3                       2     4
296            Labour  61                      2                       3     4
297            Labour  62                      4                       2     4
298            Labour  69                      5                       5     4
299  Liberal Democrat  74                      3                       2     4
300            Labour  30                      4                       3     4
301  Liberal Democrat  70                      4                       4     4
302      Conservative  75                      3                       4     2
303            Labour  75                      4                       3     4
304            Labour  30                      4                       4     1
305  Liberal Democrat  77                      2                       2     2
306      Conservative  66                      2                       3     4
307      Conservative  70                      2                       2     4
308            Labour  38                      4                       4     4
309            Labour  49                      4                       4     4
310            Labour  40                      4                       5     4
311  Liberal Democrat  82                      4                       4     5
312  Liberal Democrat  48                      3                       2     4
313      Conservative  58                      2                       2     1
314  Liberal Democrat  29                      3                       2     2
315      Conservative  65                      2                       3     2
316      Conservative  33                      3                       1     2
317      Conservative  55                      3                       3     4
318            Labour  56                      4                       5     4
319            Labour  45                      3                       4     5
320      Conservative  50                      3                       5     1
321            Labour  80                      3                       3     5
322  Liberal Democrat  51                      3                       4     4
323  Liberal Democrat  55                      2                       3     1
324            Labour  55                      4                       4     4
325  Liberal Democrat  61                      4                       3     4
326            Labour  39                      3                       3     4
327  Liberal Democrat  49                      3                       3     2
328      Conservative  77                      3                       3     2
329  Liberal Democrat  43                      3                       3     4
330  Liberal Democrat  34                      3                       3     4
331            Labour  72                      5                       5     5
332      Conservative  60                      4                       4     2
333  Liberal Democrat  39                      3                       3     1
334  Liberal Democrat  38                      2                       4     2
335  Liberal Democrat  35                      3                       5     4
336            Labour  44                      4                       4     2
337            Labour  31                      4                       4     4
338  Liberal Democrat  33                      3                       3     2
339      Conservative  66                      2                       3     1
340  Liberal Democrat  63                      3                       2     4
341            Labour  47                      4                       4     4
342      Conservative  38                      3                       2     2
343            Labour  67                      4                       3     5
344      Conservative  37                      1                       4     1
345            Labour  27                      2                       4     2
346            Labour  50                      3                       3     5
347            Labour  77                      3                       3     5
348  Liberal Democrat  71                      3                       4     1
349            Labour  53                      3                       3     4
350            Labour  56                      4                       2     5
351      Conservative  32                      3                       4     2
352      Conservative  83                      2                       4     2
353            Labour  52                      4                       3     4
354      Conservative  74                      4                       2     2
355      Conservative  92                      3                       3     2
356      Conservative  34                      4                       4     2
357  Liberal Democrat  80                      2                       3     4
358      Conservative  39                      3                       5     4
359  Liberal Democrat  80                      3                       5     4
360  Liberal Democrat  66                      3                       3     4
361      Conservative  71                      3                       3     2
362  Liberal Democrat  46                      3                       2     4
363      Conservative  54                      3                       3     4
364      Conservative  55                      4                       4     4
365      Conservative  69                      2                       2     1
366            Labour  74                      4                       4     4
367  Liberal Democrat  56                      4                       4     5
368      Conservative  74                      2                       3     4
369      Conservative  37                      4                       4     2
370  Liberal Democrat  43                      3                       2     4
371      Conservative  50                      2                       3     4
372            Labour  57                      4                       4     4
373  Liberal Democrat  42                      3                       4     4
374      Conservative  42                      2                       3     1
375            Labour  36                      4                       5     5
376  Liberal Democrat  55                      4                       4     4
377      Conservative  73                      2                       1     2
378      Conservative  29                      4                       5     4
379            Labour  56                      4                       4     5
380      Conservative  67                      2                       3     4
381  Liberal Democrat  47                      4                       3     4
382      Conservative  38                      2                       2     4
383            Labour  35                      3                       3     5
384            Labour  83                      4                       4     4
385      Conservative  32                      4                       4     4
386      Conservative  68                      1                       1     2
387      Conservative  76                      4                       3     4
388      Conservative  63                      2                       2     4
389  Liberal Democrat  86                      3                       3     4
390            Labour  35                      4                       1     4
391            Labour  39                      3                       4     4
392  Liberal Democrat  65                      2                       2     4
393            Labour  32                      3                       3     4
394            Labour  81                      4                       4     4
395      Conservative  83                      1                       2     2
396  Liberal Democrat  33                      4                       2     4
397  Liberal Democrat  37                      2                       3     4
398  Liberal Democrat  48                      4                       4     4
399  Liberal Democrat  61                      4                       2     4
400            Labour  66                      3                       3     5
401  Liberal Democrat  38                      2                       1     2
402  Liberal Democrat  79                      4                       3     5
403  Liberal Democrat  58                      4                       3     4
404      Conservative  56                      2                       5     1
405      Conservative  61                      4                       3     2
406  Liberal Democrat  58                      3                       3     4
407  Liberal Democrat  57                      3                       3     1
408      Conservative  35                      4                       5     4
409  Liberal Democrat  59                      3                       3     4
410  Liberal Democrat  84                      3                       4     1
411  Liberal Democrat  65                      3                       3     4
412            Labour  24                      4                       4     4
413            Labour  35                      4                       3     4
414  Liberal Democrat  50                      2                       2     4
415  Liberal Democrat  42                      3                       2     2
416      Conservative  55                      4                       4     4
417            Labour  35                      4                       3     2
418  Liberal Democrat  53                      4                       3     2
419      Conservative  46                      2                       2     2
420      Conservative  55                      4                       4     4
421  Liberal Democrat  42                      3                       3     5
422      Conservative  59                      3                       3     2
423            Labour  56                      3                       3     4
424  Liberal Democrat  48                      4                       3     4
425      Conservative  52                      4                       2     1
426  Liberal Democrat  35                      3                       4     5
427  Liberal Democrat  36                      4                       4     4
428  Liberal Democrat  77                      4                       4     4
429  Liberal Democrat  51                      3                       3     4
430      Conservative  76                      2                       2     2
431      Conservative  39                      3                       4     2
432  Liberal Democrat  38                      3                       2     4
433            Labour  65                      4                       3     4
434      Conservative  48                      3                       3     2
435            Labour  31                      3                       4     4
436  Liberal Democrat  49                      1                       1     2
437      Conservative  37                      4                       1     1
438      Conservative  60                      4                       4     4
439            Labour  58                      4                       4     5
440            Labour  65                      4                       2     4
441            Labour  51                      3                       3     4
442            Labour  78                      1                       1     4
443      Conservative  58                      2                       4     4
444            Labour  61                      4                       2     4
445            Labour  88                      4                       4     5
446            Labour  33                      4                       3     4
447      Conservative  66                      1                       1     2
448            Labour  40                      4                       4     4
449  Liberal Democrat  49                      2                       3     4
450            Labour  48                      1                       1     4
451            Labour  41                      3                       4     4
452  Liberal Democrat  42                      4                       3     4
453            Labour  72                      3                       4     4
454            Labour  76                      4                       4     4
455            Labour  37                      4                       4     5
456            Labour  70                      5                       4     4
457            Labour  63                      3                       4     5
458            Labour  27                      3                       3     4
459  Liberal Democrat  57                      3                       3     4
460  Liberal Democrat  66                      4                       4     4
461      Conservative  57                      3                       2     2
462            Labour  72                      5                       4     4
463  Liberal Democrat  69                      3                       4     2
464            Labour  46                      3                       4     4
465  Liberal Democrat  75                      2                       1     1
466      Conservative  73                      3                       1     4
467            Labour  82                      3                       4     5
468  Liberal Democrat  28                      4                       3     4
469      Conservative  66                      4                       3     4
470      Conservative  67                      3                       2     2
471      Conservative  51                      3                       3     2
472      Conservative  43                      3                       3     4
473            Labour  30                      3                       4     4
474      Conservative  47                      2                       3     4
475      Conservative  27                      3                       3     2
476            Labour  32                      3                       4     4
477      Conservative  61                      3                       3     2
478      Conservative  52                      4                       4     2
479            Labour  34                      4                       4     4
480  Liberal Democrat  71                      5                       3     5
481      Conservative  54                      3                       3     1
482  Liberal Democrat  28                      3                       3     2
483      Conservative  70                      4                       3     4
484  Liberal Democrat  43                      2                       3     4
485  Liberal Democrat  70                      2                       3     4
486      Conservative  63                      2                       2     4
487  Liberal Democrat  62                      2                       3     2
488  Liberal Democrat  62                      4                       3     4
489      Conservative  47                      2                       2     2
490  Liberal Democrat  57                      2                       3     4
491      Conservative  26                      3                       5     4
492            Labour  41                      4                       3     4
493            Labour  72                      4                       4     2
494            Labour  53                      1                       1     1
495  Liberal Democrat  68                      3                       3     4
496            Labour  79                      3                       3     5
497  Liberal Democrat  26                      3                       3     4
498  Liberal Democrat  54                      2                       2     1
499      Conservative  60                      3                       4     2
500            Labour  74                      3                       4     4
501            Labour  30                      2                       4     4
502  Liberal Democrat  41                      4                       5     4
503      Conservative  68                      3                       3     1
504      Conservative  33                      3                       5     4
505  Liberal Democrat  71                      3                       3     2
506      Conservative  69                      3                       4     2
507      Conservative  72                      4                       3     4
508            Labour  40                      3                       4     4
509      Conservative  29                      1                       2     1
510      Conservative  63                      2                       2     1
511      Conservative  53                      1                       2     1
512      Conservative  46                      3                       3     2
513  Liberal Democrat  39                      3                       4     4
514      Conservative  80                      2                       2     2
515      Conservative  40                      4                       4     2
516      Conservative  44                      4                       3     4
517            Labour  58                      3                       3     5
518      Conservative  35                      4                       4     4
519      Conservative  39                      2                       3     4
520  Liberal Democrat  53                      3                       3     2
521            Labour  40                      3                       4     2
522            Labour  51                      4                       3     4
523      Conservative  51                      3                       2     2
524      Conservative  50                      3                       4     2
525      Conservative  68                      3                       3     2
526            Labour  32                      4                       4     4
527  Liberal Democrat  66                      4                       4     4
528      Conservative  62                      3                       2     2
529            Labour  79                      3                       2     4
530  Liberal Democrat  70                      4                       3     2
531            Labour  75                      3                       4     4
532  Liberal Democrat  78                      4                       4     2
533      Conservative  78                      2                       3     4
534  Liberal Democrat  71                      3                       3     4
535            Labour  73                      4                       5     4
536  Liberal Democrat  52                      4                       2     4
537  Liberal Democrat  66                      4                       3     5
538      Conservative  38                      2                       3     4
539            Labour  44                      5                       3     4
540  Liberal Democrat  83                      3                       4     4
541            Labour  34                      3                       3     4
542      Conservative  75                      1                       5     2
543      Conservative  66                      3                       3     2
544            Labour  74                      3                       4     2
545            Labour  46                      4                       4     4
546  Liberal Democrat  76                      4                       2     2
547      Conservative  53                      2                       1     2
548  Liberal Democrat  46                      2                       2     2
549      Conservative  43                      4                       3     4
550  Liberal Democrat  29                      4                       3     4
551            Labour  53                      4                       4     4
552      Conservative  31                      2                       2     2
553      Conservative  54                      4                       3     2
554      Conservative  54                      3                       4     2
555      Conservative  38                      2                       5     2
556            Labour  54                      5                       3     5
557            Labour  41                      3                       2     4
558            Labour  77                      5                       2     4
559      Conservative  39                      2                       4     1
560      Conservative  53                      3                       3     2
561  Liberal Democrat  42                      4                       4     4
562  Liberal Democrat  46                      3                       4     4
563            Labour  37                      4                       2     4
564            Labour  41                      4                       3     4
565            Labour  40                      3                       3     2
566            Labour  84                      5                       4     5
567  Liberal Democrat  43                      3                       3     4
568  Liberal Democrat  81                      4                       3     1
569            Labour  41                      3                       4     4
570            Labour  46                      4                       2     2
571      Conservative  64                      3                       3     1
572  Liberal Democrat  67                      4                       4     4
573      Conservative  71                      1                       4     2
574      Conservative  89                      2                       2     1
575      Conservative  76                      3                       4     4
576      Conservative  50                      4                       3     2
577      Conservative  53                      3                       2     2
578      Conservative  74                      4                       3     2
579  Liberal Democrat  76                      4                       3     4
580  Liberal Democrat  84                      4                       3     4
581            Labour  68                      5                       4     5
582  Liberal Democrat  46                      3                       3     2
583      Conservative  39                      3                       3     1
584      Conservative  64                      2                       3     2
585            Labour  43                      4                       2     5
586      Conservative  59                      4                       3     3
587            Labour  58                      4                       3     5
588            Labour  70                      4                       2     2
589      Conservative  35                      3                       4     2
590            Labour  36                      5                       5     4
591      Conservative  77                      3                       3     4
592            Labour  52                      4                       4     4
593  Liberal Democrat  65                      3                       1     4
594      Conservative  60                      3                       2     2
595      Conservative  48                      3                       3     2
596            Labour  38                      4                       3     5
597      Conservative  70                      3                       3     2
598      Conservative  50                      3                       2     2
599  Liberal Democrat  47                      4                       4     2
600      Conservative  62                      3                       3     4
601  Liberal Democrat  64                      5                       3     4
602      Conservative  62                      3                       3     2
603            Labour  57                      3                       4     4
604            Labour  65                      3                       3     4
605      Conservative  55                      4                       4     4
606      Conservative  64                      4                       1     4
607      Conservative  32                      2                       3     2
608      Conservative  72                      3                       3     1
609  Liberal Democrat  65                      3                       3     4
610  Liberal Democrat  84                      4                       2     4
611      Conservative  49                      3                       4     2
612  Liberal Democrat  55                      3                       3     4
613  Liberal Democrat  48                      4                       3     4
614      Conservative  30                      2                       3     4
615      Conservative  40                      3                       4     2
616      Conservative  35                      2                       2     1
617            Labour  51                      4                       4     2
618      Conservative  75                      5                       3     2
619            Labour  54                      4                       4     2
620            Labour  32                      4                       5     2
621      Conservative  64                      3                       3     4
622  Liberal Democrat  54                      3                       3     4
623            Labour  76                      3                       3     4
624  Liberal Democrat  47                      3                       2     2
625      Conservative  33                      2                       4     2
626      Conservative  88                      4                       2     4
627  Liberal Democrat  39                      3                       4     4
628      Conservative  66                      3                       3     2
629      Conservative  37                      2                       3     2
630            Labour  81                      1                       3     4
631  Liberal Democrat  64                      4                       4     4
632            Labour  37                      4                       3     4
633  Liberal Democrat  48                      2                       2     2
634      Conservative  42                      2                       2     2
635  Liberal Democrat  53                      3                       1     2
636      Conservative  57                      2                       3     2
637            Labour  39                      2                       2     4
638      Conservative  56                      3                       3     2
639            Labour  41                      4                       4     4
640      Conservative  45                      4                       3     4
641      Conservative  85                      4                       3     2
642            Labour  57                      3                       3     4
643            Labour  37                      4                       4     4
644            Labour  53                      4                       2     1
645            Labour  35                      3                       4     4
646            Labour  41                      4                       4     4
647      Conservative  37                      2                       4     2
648  Liberal Democrat  32                      4                       3     2
649      Conservative  30                      3                       1     2
650      Conservative  61                      4                       3     4
651            Labour  36                      4                       4     4
652            Labour  59                      5                       3     2
653      Conservative  72                      5                       1     4
654      Conservative  55                      3                       4     4
655            Labour  48                      3                       2     2
656            Labour  57                      4                       4     4
657      Conservative  68                      3                       3     4
658      Conservative  78                      2                       3     1
659      Conservative  68                      2                       4     4
660      Conservative  67                      3                       3     5
661      Conservative  35                      3                       2     4
662            Labour  36                      4                       3     2
663            Labour  30                      4                       2     4
664  Liberal Democrat  37                      4                       3     4
665      Conservative  43                      3                       2     2
666  Liberal Democrat  80                      5                       3     2
667      Conservative  35                      2                       4     2
668      Conservative  36                      2                       2     4
669      Conservative  81                      4                       5     2
670  Liberal Democrat  40                      4                       4     4
671  Liberal Democrat  69                      4                       2     2
672  Liberal Democrat  47                      2                       2     4
673  Liberal Democrat  31                      3                       2     4
674            Labour  79                      5                       4     4
675  Liberal Democrat  43                      4                       1     2
676      Conservative  72                      3                       3     2
677      Conservative  36                      2                       3     2
678            Labour  47                      3                       3     4
679      Conservative  66                      4                       5     2
680      Conservative  36                      3                       4     4
681      Conservative  46                      3                       3     2
682      Conservative  47                      2                       2     1
683      Conservative  75                      3                       4     4
684      Conservative  74                      4                       3     4
685      Conservative  54                      2                       4     2
686      Conservative  79                      3                       3     4
687            Labour  75                      3                       4     5
688      Conservative  71                      3                       3     2
689      Conservative  50                      2                       4     2
690  Liberal Democrat  56                      3                       3     2
691      Conservative  52                      4                       3     2
692            Labour  33                      4                       4     4
693            Labour  72                      5                       3     4
694            Labour  47                      4                       3     4
695            Labour  35                      4                       4     2
696            Labour  68                      3                       5     4
697            Labour  78                      5                       4     4
698            Labour  47                      4                       3     2
699            Labour  52                      3                       3     2
700            Labour  72                      4                       4     5
701            Labour  47                      3                       3     4
702            Labour  50                      4                       3     2
703            Labour  59                      3                       4     4
704      Conservative  37                      4                       4     2
705            Labour  72                      4                       4     4
706            Labour  35                      3                       4     4
707      Conservative  48                      2                       2     4
708            Labour  64                      5                       4     4
709  Liberal Democrat  57                      4                       5     4
710            Labour  42                      4                       3     4
711  Liberal Democrat  39                      5                       3     4
712      Conservative  75                      2                       2     4
713  Liberal Democrat  43                      3                       4     4
714            Labour  43                      4                       4     4
715            Labour  37                      3                       2     4
716            Labour  67                      4                       3     5
717            Labour  59                      4                       1     4
718            Labour  52                      3                       3     4
719            Labour  45                      5                       4     4
720      Conservative  55                      3                       2     2
721            Labour  70                      2                       2     2
722      Conservative  64                      3                       3     2
723  Liberal Democrat  35                      4                       4     4
724  Liberal Democrat  38                      3                       3     4
725  Liberal Democrat  31                      3                       2     2
726  Liberal Democrat  38                      3                       3     4
727            Labour  43                      2                       2     4
728            Labour  46                      4                       5     1
729  Liberal Democrat  42                      4                       4     2
730            Labour  44                      5                       1     5
731            Labour  40                      5                       3     4
732            Labour  37                      4                       4     4
733            Labour  47                      4                       3     4
734            Labour  44                      5                       3     4
735            Labour  29                      4                       3     4
736            Labour  37                      4                       4     4
737  Liberal Democrat  46                      3                       3     4
738            Labour  62                      3                       3     4
739            Labour  46                      5                       4     5
740            Labour  79                      4                       5     5
741            Labour  38                      4                       4     4
742      Conservative  29                      3                       3     2
743            Labour  56                      3                       2     2
744  Liberal Democrat  45                      2                       2     4
745            Labour  53                      4                       3     4
746      Conservative  70                      2                       2     4
747      Conservative  44                      3                       2     2
748  Liberal Democrat  51                      4                       4     4
749      Conservative  69                      1                       1     4
750      Conservative  43                      2                       2     2
751      Conservative  56                      4                       3     4
752            Labour  45                      4                       4     4
753            Labour  45                      5                       3     4
754      Conservative  49                      2                       2     4
755      Conservative  32                      2                       3     2
756      Conservative  58                      2                       3     2
757  Liberal Democrat  49                      4                       4     4
758            Labour  75                      3                       4     4
759      Conservative  36                      2                       2     2
760  Liberal Democrat  61                      3                       3     4
761      Conservative  76                      3                       3     4
762            Labour  36                      3                       4     4
763            Labour  37                      3                       3     2
764      Conservative  77                      2                       2     1
765            Labour  25                      4                       4     4
766      Conservative  49                      3                       5     4
767  Liberal Democrat  59                      2                       2     2
768      Conservative  31                      2                       2     2
769      Conservative  35                      2                       2     2
770            Labour  36                      3                       2     4
771            Labour  30                      2                       1     4
772            Labour  61                      4                       3     5
773      Conservative  52                      2                       3     2
774      Conservative  56                      4                       3     2
775            Labour  53                      4                       4     4
776  Liberal Democrat  46                      3                       4     4
777      Conservative  27                      3                       4     2
778            Labour  60                      5                       4     4
779      Conservative  75                      4                       3     4
780  Liberal Democrat  80                      5                       5     4
781            Labour  61                      5                       4     4
782      Conservative  55                      2                       2     1
783  Liberal Democrat  35                      4                       4     5
784  Liberal Democrat  49                      2                       4     2
785  Liberal Democrat  45                      2                       3     4
786            Labour  52                      4                       2     4
787            Labour  75                      5                       2     5
788  Liberal Democrat  85                      4                       2     4
789            Labour  38                      4                       4     4
790            Labour  34                      4                       5     4
791  Liberal Democrat  61                      3                       3     2
792            Labour  54                      2                       3     2
793  Liberal Democrat  58                      3                       3     4
794  Liberal Democrat  54                      4                       4     4
795            Labour  50                      3                       5     5
796            Labour  29                      4                       4     4
797            Labour  51                      4                       3     4
798            Labour  72                      4                       4     5
799  Liberal Democrat  50                      2                       2     2
800            Labour  85                      2                       3     4
801      Conservative  42                      2                       2     1
802  Liberal Democrat  34                      4                       3     4
803      Conservative  70                      3                       3     2
804            Labour  36                      4                       5     5
805      Conservative  35                      3                       5     4
806      Conservative  38                      4                       2     4
807  Liberal Democrat  53                      2                       3     2
808            Labour  77                      4                       4     5
809            Labour  37                      2                       4     4
810            Labour  75                      2                       2     2
811            Labour  45                      4                       5     5
812      Conservative  82                      3                       3     4
813            Labour  48                      3                       3     4
814            Labour  68                      3                       3     4
815  Liberal Democrat  48                      3                       3     4
816            Labour  87                      4                       4     4
817            Labour  52                      4                       4     4
818      Conservative  53                      4                       3     4
819      Conservative  66                      1                       2     1
820  Liberal Democrat  85                      3                       4     4
821            Labour  47                      4                       3     4
822  Liberal Democrat  51                      3                       4     4
823            Labour  41                      4                       4     4
824  Liberal Democrat  54                      4                       2     4
825            Labour  76                      4                       3     5
826      Conservative  72                      3                       3     2
827  Liberal Democrat  31                      3                       2     4
828      Conservative  27                      3                       3     2
829      Conservative  79                      3                       3     2
830  Liberal Democrat  46                      2                       3     4
831      Conservative  31                      3                       3     4
832  Liberal Democrat  66                      4                       3     4
833            Labour  42                      4                       4     4
834  Liberal Democrat  51                      3                       4     4
835  Liberal Democrat  75                      4                       4     4
836            Labour  44                      3                       3     4
837            Labour  63                      3                       3     4
838      Conservative  77                      2                       3     2
839      Conservative  75                      1                       3     2
840            Labour  50                      4                       3     4
841            Labour  67                      3                       3     4
842      Conservative  64                      3                       1     2
843      Conservative  24                      3                       2     4
844  Liberal Democrat  44                      3                       1     4
845      Conservative  39                      4                       4     2
846      Conservative  70                      3                       1     4
847      Conservative  35                      3                       4     2
848      Conservative  33                      3                       4     2
849            Labour  36                      2                       2     4
850      Conservative  45                      3                       4     1
851            Labour  57                      3                       1     4
852            Labour  63                      3                       1     4
853      Conservative  64                      2                       4     1
854  Liberal Democrat  49                      2                       4     2
855            Labour  52                      5                       3     4
856            Labour  66                      3                       2     4
857            Labour  75                      3                       4     4
858            Labour  45                      2                       4     4
859  Liberal Democrat  39                      3                       3     4
860  Liberal Democrat  40                      3                       3     4
861      Conservative  43                      3                       4     2
862      Conservative  74                      3                       3     2
863      Conservative  70                      3                       3     4
864      Conservative  27                      3                       2     4
865      Conservative  57                      4                       3     2
866      Conservative  45                      4                       4     4
867  Liberal Democrat  49                      2                       3     4
868      Conservative  80                      2                       4     4
869      Conservative  51                      3                       3     2
870            Labour  33                      4                       4     4
871  Liberal Democrat  38                      2                       4     2
872      Conservative  48                      2                       3     1
873      Conservative  45                      4                       4     2
874      Conservative  42                      2                       2     2
875            Labour  50                      3                       4     4
876            Labour  49                      4                       4     4
877      Conservative  44                      3                       3     4
878            Labour  85                      5                       5     5
879  Liberal Democrat  86                      3                       4     1
880      Conservative  69                      2                       3     2
881  Liberal Democrat  32                      2                       5     4
882  Liberal Democrat  51                      2                       4     4
883      Conservative  69                      3                       3     2
884            Labour  81                      5                       3     5
885  Liberal Democrat  75                      2                       3     4
886      Conservative  70                      4                       3     4
887      Conservative  58                      4                       2     2
888            Labour  61                      4                       2     5
889      Conservative  57                      2                       3     4
890      Conservative  35                      3                       4     2
891      Conservative  37                      2                       3     2
892      Conservative  46                      3                       3     2
893  Liberal Democrat  66                      4                       3     2
894            Labour  51                      4                       3     4
895      Conservative  73                      3                       3     2
896            Labour  32                      3                       3     4
897  Liberal Democrat  30                      3                       3     2
898            Labour  38                      4                       2     4
899      Conservative  39                      5                       4     2
900      Conservative  49                      3                       4     4
901      Conservative  82                      3                       3     2
902            Labour  42                      3                       3     4
903            Labour  37                      5                       5     4
904      Conservative  58                      3                       2     4
905  Liberal Democrat  29                      3                       3     4
906  Liberal Democrat  27                      5                       5     2
907            Labour  57                      5                       5     5
908      Conservative  30                      3                       3     2
909      Conservative  43                      3                       4     2
910            Labour  62                      5                       4     4
911  Liberal Democrat  42                      3                       4     4
912            Labour  67                      5                       3     4
913            Labour  36                      2                       3     4
914            Labour  74                      3                       4     4
915            Labour  41                      4                       4     4
916  Liberal Democrat  27                      3                       4     4
917            Labour  29                      4                       4     4
918            Labour  38                      3                       3     4
919  Liberal Democrat  74                      4                       3     4
920  Liberal Democrat  38                      3                       2     4
921  Liberal Democrat  61                      3                       3     4
922  Liberal Democrat  65                      4                       4     4
923            Labour  36                      3                       3     4
924  Liberal Democrat  48                      3                       4     4
925  Liberal Democrat  39                      2                       4     2
926            Labour  48                      3                       3     4
927      Conservative  50                      3                       3     2
928      Conservative  71                      2                       2     4
929  Liberal Democrat  42                      2                       2     1
930            Labour  56                      4                       3     4
931  Liberal Democrat  64                      1                       3     2
932  Liberal Democrat  80                      3                       4     4
933      Conservative  56                      4                       3     4
934      Conservative  60                      2                       2     2
935      Conservative  39                      2                       2     1
936            Labour  43                      2                       1     4
937            Labour  35                      3                       2     4
938            Labour  66                      5                       3     5
939      Conservative  59                      1                       4     2
940            Labour  37                      2                       4     2
941            Labour  37                      3                       4     4
942            Labour  61                      5                       5     4
943            Labour  38                      4                       5     4
944            Labour  66                      4                       3     5
945  Liberal Democrat  41                      3                       3     2
946      Conservative  65                      2                       4     2
947            Labour  57                      3                       2     2
948      Conservative  62                      2                       1     1
949            Labour  31                      4                       5     4
950      Conservative  40                      2                       3     1
951  Liberal Democrat  49                      3                       3     2
952      Conservative  65                      2                       5     4
953            Labour  35                      5                       3     2
954            Labour  76                      4                       5     5
955      Conservative  74                      2                       2     2
956      Conservative  53                      3                       3     2
957            Labour  49                      1                       2     4
958  Liberal Democrat  37                      3                       2     4
959      Conservative  54                      2                       2     2
960  Liberal Democrat  75                      4                       4     1
961            Labour  76                      4                       3     5
962            Labour  58                      3                       3     4
963      Conservative  35                      2                       3     4
964      Conservative  66                      3                       3     2
965      Conservative  80                      2                       3     4
966      Conservative  53                      4                       3     4
967            Labour  64                      3                       2     5
968            Labour  71                      3                       4     4
969            Labour  40                      4                       2     4
970            Labour  62                      4                       3     4
971      Conservative  89                      2                       2     4
972            Labour  40                      2                       4     4
973            Labour  38                      3                       4     4
974            Labour  38                      3                       3     2
975            Labour  37                      4                       4     4
976            Labour  50                      3                       2     4
977      Conservative  53                      2                       5     1
978      Conservative  78                      2                       3     2
979            Labour  73                      2                       2     4
980            Labour  64                      4                       4     2
981            Labour  56                      2                       2     4
982      Conservative  73                      4                       3     2
983      Conservative  51                      3                       2     2
984      Conservative  74                      4                       3     2
985            Labour  39                      4                       5     5
986      Conservative  56                      4                       2     5
987      Conservative  80                      4                       2     4
988      Conservative  67                      3                       2     2
989  Liberal Democrat  61                      2                       2     4
990      Conservative  81                      3                       3     4
991  Liberal Democrat  35                      2                       3     4
992      Conservative  34                      2                       4     1
993      Conservative  49                      1                       2     2
994  Liberal Democrat  41                      3                       4     4
995  Liberal Democrat  58                      5                       3     4
996            Labour  37                      4                       3     4
997            Labour  38                      4                       2     5
998            Labour  47                      4                       4     4
999            Labour  75                      4                       5     4
1000           Labour  72                      4                       3     2
1001 Liberal Democrat  75                      4                       3     4
1002     Conservative  68                      3                       1     2
1003           Labour  70                      5                       4     2
1004     Conservative  72                      2                       2     4
1005           Labour  39                      3                       2     4
1006           Labour  47                      4                       3     4
1007           Labour  42                      4                       3     5
1008           Labour  75                      4                       4     4
1009     Conservative  75                      2                       2     2
1010           Labour  32                      4                       3     4
1011           Labour  76                      4                       4     5
1012           Labour  34                      4                       4     4
1013     Conservative  67                      3                       4     4
1014 Liberal Democrat  44                      2                       2     2
1015           Labour  42                      3                       5     2
1016     Conservative  40                      2                       3     4
1017           Labour  57                      4                       3     4
1018     Conservative  65                      2                       4     4
1019     Conservative  42                      1                       1     1
1020           Labour  77                      4                       5     4
1021           Labour  49                      3                       5     5
1022 Liberal Democrat  50                      4                       3     2
1023           Labour  76                      4                       4     5
1024 Liberal Democrat  72                      3                       3     2
1025           Labour  47                      4                       3     4
1026           Labour  52                      4                       4     4
1027     Conservative  68                      2                       3     1
1028           Labour  61                      4                       5     4
1029     Conservative  72                      3                       3     2
1030     Conservative  72                      4                       4     2
1031           Labour  45                      3                       3     4
1032     Conservative  47                      2                       3     2
1033     Conservative  35                      2                       3     2
1034           Labour  34                      4                       4     4
1035           Labour  39                      4                       3     4
1036 Liberal Democrat  53                      2                       4     1
1037 Liberal Democrat  27                      3                       5     2
1038           Labour  40                      4                       3     4
1039           Labour  29                      4                       3     4
1040     Conservative  43                      5                       5     2
1041     Conservative  59                      3                       3     2
1042     Conservative  78                      4                       4     2
1043           Labour  26                      4                       4     4
1044           Labour  34                      4                       5     4
1045           Labour  42                      3                       3     4
1046 Liberal Democrat  37                      1                       2     4
1047           Labour  50                      1                       1     4
1048           Labour  61                      4                       3     4
1049           Labour  58                      4                       3     2
1050           Labour  78                      4                       4     4
1051           Labour  52                      3                       4     2
1052 Liberal Democrat  34                      3                       2     2
1053           Labour  69                      4                       3     5
1054     Conservative  69                      4                       4     1
1055           Labour  54                      5                       4     4
1056           Labour  79                      4                       3     5
1057           Labour  30                      5                       5     4
1058           Labour  52                      3                       3     4
1059           Labour  37                      3                       4     4
1060     Conservative  49                      3                       3     4
1061           Labour  31                      5                       4     4
1062           Labour  32                      2                       2     4
1063           Labour  37                      4                       4     2
1064           Labour  39                      4                       4     4
1065           Labour  74                      4                       4     5
1066 Liberal Democrat  89                      3                       5     4
1067 Liberal Democrat  66                      3                       3     2
1068 Liberal Democrat  83                      4                       5     5
1069 Liberal Democrat  45                      2                       3     4
1070     Conservative  71                      3                       3     4
1071           Labour  53                      3                       3     4
1072     Conservative  84                      3                       3     2
1073           Labour  59                      3                       3     5
1074 Liberal Democrat  69                      4                       4     4
1075 Liberal Democrat  68                      2                       3     1
1076           Labour  89                      5                       5     5
1077     Conservative  72                      3                       3     4
1078           Labour  83                      4                       3     4
1079           Labour  64                      4                       3     2
1080           Labour  47                      3                       4     4
1081           Labour  61                      4                       4     5
1082           Labour  43                      4                       4     2
1083 Liberal Democrat  42                      3                       3     4
1084           Labour  40                      3                       4     4
1085     Conservative  68                      3                       1     4
1086           Labour  24                      4                       1     2
1087 Liberal Democrat  53                      3                       2     4
1088     Conservative  36                      3                       3     2
1089           Labour  76                      4                       4     5
1090     Conservative  67                      3                       3     2
1091 Liberal Democrat  58                      2                       2     4
1092           Labour  70                      3                       3     1
1093     Conservative  35                      3                       3     4
1094           Labour  47                      4                       3     5
1095     Conservative  42                      4                       3     4
1096           Labour  40                      4                       4     4
1097 Liberal Democrat  34                      4                       5     4
1098           Labour  54                      3                       3     4
1099     Conservative  39                      3                       2     4
1100           Labour  60                      3                       3     4
1101 Liberal Democrat  74                      4                       3     5
1102     Conservative  62                      3                       3     2
1103     Conservative  59                      2                       3     4
1104           Labour  47                      4                       4     4
1105 Liberal Democrat  49                      4                       3     4
1106     Conservative  49                      2                       3     2
1107           Labour  86                      3                       4     4
1108     Conservative  67                      4                       4     4
1109     Conservative  54                      4                       2     1
1110     Conservative  85                      2                       3     2
1111 Liberal Democrat  49                      3                       1     4
1112     Conservative  55                      3                       3     4
1113 Liberal Democrat  74                      4                       3     4
1114     Conservative  70                      2                       2     1
1115     Conservative  46                      2                       2     2
1116 Liberal Democrat  29                      4                       5     4
1117 Liberal Democrat  65                      4                       4     2
1118 Liberal Democrat  49                      3                       2     4
1119     Conservative  29                      2                       4     4
1120     Conservative  37                      3                       3     4
1121           Labour  45                      4                       4     4
1122     Conservative  61                      2                       3     2
1123           Labour  34                      3                       3     2
1124           Labour  61                      4                       3     4
1125 Liberal Democrat  38                      3                       2     1
1126           Labour  37                      3                       3     4
1127           Labour  28                      4                       4     4
1128           Labour  61                      3                       3     4
1129 Liberal Democrat  53                      4                       3     4
1130           Labour  73                      4                       4     5
1131           Labour  74                      4                       4     4
1132           Labour  36                      3                       3     1
1133           Labour  67                      4                       2     4
1134     Conservative  55                      4                       3     4
1135     Conservative  45                      2                       2     1
1136           Labour  38                      4                       4     4
1137     Conservative  52                      3                       3     2
1138           Labour  70                      3                       3     4
1139 Liberal Democrat  68                      4                       4     2
1140           Labour  50                      4                       3     4
1141           Labour  34                      2                       4     5
1142           Labour  43                      2                       3     2
1143     Conservative  93                      4                       4     5
1144           Labour  82                      3                       5     5
1145     Conservative  24                      3                       4     2
1146           Labour  65                      3                       3     2
1147           Labour  41                      4                       3     4
1148           Labour  83                      3                       3     5
1149           Labour  47                      4                       4     4
1150           Labour  46                      2                       1     4
1151           Labour  30                      5                       4     4
1152           Labour  36                      3                       3     4
1153     Conservative  44                      2                       2     2
1154           Labour  57                      2                       3     4
1155     Conservative  53                      3                       4     2
1156 Liberal Democrat  64                      3                       3     4
1157     Conservative  56                      3                       3     1
1158 Liberal Democrat  49                      2                       3     2
1159           Labour  87                      5                       3     5
1160 Liberal Democrat  46                      3                       3     1
1161           Labour  50                      4                       3     4
1162           Labour  51                      4                       3     5
1163           Labour  33                      4                       5     5
1164     Conservative  77                      2                       3     2
1165           Labour  48                      4                       3     4
1166     Conservative  67                      3                       4     4
1167 Liberal Democrat  27                      3                       4     4
1168     Conservative  24                      4                       4     2
1169           Labour  26                      2                       4     5
1170 Liberal Democrat  46                      4                       3     4
1171 Liberal Democrat  25                      4                       4     1
1172           Labour  37                      4                       3     4
1173     Conservative  24                      4                       5     4
1174           Labour  32                      4                       4     2
1175           Labour  54                      3                       3     1
1176     Conservative  63                      4                       2     2
1177     Conservative  59                      4                       3     2
1178     Conservative  55                      5                       3     2
1179     Conservative  36                      3                       4     4
1180 Liberal Democrat  74                      4                       4     4
1181           Labour  47                      3                       4     4
1182           Labour  31                      4                       4     4
1183 Liberal Democrat  71                      1                       2     2
1184     Conservative  80                      2                       2     4
1185     Conservative  61                      3                       3     4
1186           Labour  42                      3                       3     4
1187           Labour  39                      4                       4     4
1188 Liberal Democrat  54                      3                       4     4
1189           Labour  75                      5                       4     5
1190           Labour  58                      4                       2     2
1191           Labour  58                      4                       4     5
1192           Labour  75                      4                       5     4
1193           Labour  50                      4                       4     4
1194     Conservative  38                      4                       2     1
1195           Labour  34                      3                       3     2
1196           Labour  39                      3                       4     4
1197           Labour  46                      3                       4     5
1198 Liberal Democrat  33                      2                       2     4
1199     Conservative  71                      4                       2     2
1200           Labour  49                      4                       3     4
1201           Labour  63                      5                       2     5
1202           Labour  57                      4                       4     4
1203     Conservative  64                      4                       5     4
1204           Labour  47                      3                       5     4
1205     Conservative  63                      3                       3     2
1206           Labour  52                      4                       4     4
1207     Conservative  44                      2                       2     2
1208 Liberal Democrat  64                      3                       3     4
1209           Labour  45                      4                       4     4
1210           Labour  36                      3                       3     2
1211           Labour  47                      4                       5     4
1212           Labour  37                      5                       5     5
1213           Labour  57                      3                       3     4
1214           Labour  54                      3                       2     4
1215     Conservative  80                      2                       4     2
1216           Labour  65                      5                       3     4
1217 Liberal Democrat  56                      3                       3     2
1218 Liberal Democrat  55                      4                       3     2
1219     Conservative  66                      4                       4     4
1220           Labour  71                      3                       3     4
1221 Liberal Democrat  32                      4                       2     2
1222     Conservative  72                      2                       2     1
1223     Conservative  76                      3                       2     4
1224     Conservative  71                      1                       1     2
1225 Liberal Democrat  45                      4                       3     5
1226 Liberal Democrat  65                      3                       3     4
1227     Conservative  39                      3                       1     1
1228           Labour  55                      4                       3     4
1229 Liberal Democrat  62                      3                       3     2
1230           Labour  70                      3                       3     2
1231 Liberal Democrat  39                      3                       5     4
1232           Labour  50                      4                       2     4
1233           Labour  40                      5                       5     5
1234           Labour  41                      4                       4     4
1235 Liberal Democrat  40                      2                       2     4
1236           Labour  71                      3                       4     5
1237 Liberal Democrat  36                      3                       3     2
1238           Labour  70                      4                       3     5
1239           Labour  42                      4                       4     4
1240     Conservative  69                      4                       3     4
1241 Liberal Democrat  60                      5                       3     2
1242           Labour  65                      4                       3     2
1243           Labour  52                      4                       4     4
1244           Labour  41                      1                       4     5
1245           Labour  29                      4                       4     4
1246 Liberal Democrat  45                      3                       4     4
1247     Conservative  48                      3                       2     4
1248 Liberal Democrat  55                      2                       4     4
1249     Conservative  75                      4                       3     4
1250 Liberal Democrat  80                      4                       2     2
1251 Liberal Democrat  51                      3                       4     1
1252           Labour  56                      3                       3     4
1253           Labour  43                      4                       4     4
1254           Labour  39                      3                       4     4
1255     Conservative  59                      4                       3     2
1256           Labour  34                      4                       4     2
1257 Liberal Democrat  27                      3                       3     4
1258 Liberal Democrat  50                      3                       2     4
1259           Labour  47                      4                       4     4
1260     Conservative  69                      2                       2     2
1261 Liberal Democrat  77                      4                       4     2
1262           Labour  74                      4                       4     2
1263     Conservative  71                      4                       3     2
1264     Conservative  63                      4                       4     4
1265           Labour  49                      4                       4     4
1266     Conservative  46                      3                       4     2
1267     Conservative  43                      3                       2     1
1268     Conservative  70                      3                       2     4
1269           Labour  67                      3                       3     4
1270           Labour  80                      4                       4     4
1271     Conservative  54                      2                       2     2
1272 Liberal Democrat  58                      4                       4     4
1273           Labour  54                      3                       3     4
1274           Labour  27                      3                       4     4
1275           Labour  40                      4                       3     4
1276           Labour  49                      4                       4     4
1277           Labour  26                      5                       3     5
1278 Liberal Democrat  51                      2                       2     4
1279 Liberal Democrat  53                      4                       4     2
1280           Labour  46                      3                       3     4
1281           Labour  42                      3                       1     4
1282 Liberal Democrat  35                      4                       2     4
1283     Conservative  69                      2                       3     1
1284           Labour  63                      4                       2     4
1285           Labour  76                      3                       4     5
1286           Labour  44                      4                       4     4
1287     Conservative  66                      2                       2     2
1288           Labour  85                      2                       3     4
1289     Conservative  32                      4                       2     2
1290           Labour  74                      3                       4     4
1291     Conservative  28                      3                       4     4
1292           Labour  91                      4                       3     4
1293           Labour  60                      5                       2     5
1294     Conservative  59                      3                       3     2
1295           Labour  31                      4                       4     4
1296           Labour  81                      3                       4     4
1297           Labour  56                      4                       3     4
1298 Liberal Democrat  28                      2                       4     4
1299           Labour  69                      3                       3     4
1300 Liberal Democrat  37                      4                       1     4
1301           Labour  24                      3                       3     4
1302           Labour  38                      3                       3     1
1303           Labour  46                      4                       4     4
1304           Labour  25                      4                       4     5
1305           Labour  49                      3                       3     5
1306           Labour  35                      3                       3     4
1307           Labour  56                      3                       3     4
1308           Labour  62                      4                       2     4
1309 Liberal Democrat  57                      4                       1     2
1310           Labour  48                      3                       4     4
1311           Labour  80                      4                       4     4
1312 Liberal Democrat  61                      3                       3     2
1313     Conservative  52                      3                       3     2
1314           Labour  32                      3                       3     2
1315 Liberal Democrat  70                      2                       2     2
1316           Labour  35                      4                       3     5
1317           Labour  33                      5                       5     5
1318           Labour  32                      3                       4     4
1319           Labour  62                      3                       3     4
1320     Conservative  30                      3                       4     2
1321           Labour  60                      3                       4     2
1322 Liberal Democrat  49                      3                       2     4
1323           Labour  69                      4                       2     4
1324 Liberal Democrat  67                      4                       3     1
1325           Labour  39                      4                       3     4
1326     Conservative  40                      3                       2     2
1327           Labour  74                      4                       4     4
1328           Labour  37                      5                       5     5
1329           Labour  35                      4                       3     4
1330           Labour  33                      5                       4     4
1331     Conservative  54                      3                       2     2
1332 Liberal Democrat  65                      4                       3     4
1333 Liberal Democrat  49                      3                       4     2
1334           Labour  72                      3                       3     4
1335     Conservative  38                      3                       1     2
1336 Liberal Democrat  67                      4                       2     2
1337           Labour  47                      3                       3     5
1338 Liberal Democrat  58                      2                       2     2
1339 Liberal Democrat  31                      3                       5     4
1340           Labour  34                      4                       5     4
1341           Labour  42                      3                       3     2
1342           Labour  67                      3                       3     4
1343 Liberal Democrat  26                      3                       3     2
1344           Labour  73                      2                       3     4
1345 Liberal Democrat  46                      2                       4     4
1346           Labour  69                      3                       3     2
1347     Conservative  56                      4                       3     2
1348     Conservative  66                      3                       5     1
1349           Labour  54                      4                       4     4
1350     Conservative  72                      3                       2     2
1351           Labour  53                      3                       3     4
1352           Labour  37                      4                       5     4
1353     Conservative  47                      4                       3     4
1354 Liberal Democrat  53                      4                       1     4
1355     Conservative  69                      3                       3     4
1356 Liberal Democrat  47                      2                       2     2
1357 Liberal Democrat  46                      4                       2     2
1358 Liberal Democrat  50                      4                       3     4
1359     Conservative  65                      4                       4     1
1360     Conservative  73                      3                       2     4
1361 Liberal Democrat  47                      3                       2     4
1362           Labour  30                      3                       4     4
1363           Labour  50                      3                       3     4
1364           Labour  53                      5                       5     4
1365     Conservative  27                      3                       5     4
1366     Conservative  65                      3                       3     4
1367           Labour  39                      4                       4     4
1368           Labour  69                      3                       3     4
1369     Conservative  73                      4                       3     2
1370           Labour  31                      3                       4     4
1371     Conservative  62                      2                       2     2
1372 Liberal Democrat  46                      4                       4     4
1373           Labour  74                      4                       4     4
1374     Conservative  50                      3                       2     2
1375           Labour  51                      4                       4     4
1376           Labour  50                      4                       3     4
1377     Conservative  42                      3                       2     2
1378           Labour  66                      4                       3     4
1379           Labour  44                      4                       4     4
1380     Conservative  62                      3                       3     2
1381           Labour  72                      4                       4     4
1382           Labour  71                      4                       4     2
1383           Labour  75                      5                       5     5
1384           Labour  35                      5                       4     2
1385 Liberal Democrat  61                      3                       3     4
1386           Labour  38                      2                       4     4
1387           Labour  50                      3                       3     5
1388     Conservative  53                      3                       2     2
1389           Labour  84                      4                       5     5
1390           Labour  57                      4                       4     2
1391           Labour  69                      3                       3     4
1392     Conservative  52                      2                       2     2
1393           Labour  33                      3                       2     2
1394     Conservative  72                      2                       2     2
1395     Conservative  54                      3                       3     4
1396           Labour  57                      3                       3     4
1397           Labour  77                      4                       3     4
1398     Conservative  58                      2                       1     2
1399     Conservative  63                      3                       4     2
1400     Conservative  49                      3                       1     2
1401     Conservative  64                      3                       2     2
1402 Liberal Democrat  55                      3                       3     4
1403     Conservative  37                      3                       5     1
1404     Conservative  48                      3                       3     2
1405 Liberal Democrat  48                      3                       3     2
1406           Labour  60                      4                       3     5
1407           Labour  59                      3                       2     1
1408     Conservative  67                      4                       3     4
1409     Conservative  52                      3                       3     2
1410           Labour  68                      4                       4     4
1411           Labour  71                      3                       4     4
1412 Liberal Democrat  54                      3                       3     2
1413     Conservative  73                      3                       2     4
1414           Labour  56                      4                       5     2
1415           Labour  54                      3                       4     4
1416     Conservative  63                      2                       3     4
1417     Conservative  66                      3                       2     2
1418           Labour  40                      4                       4     4
1419           Labour  54                      4                       3     2
1420           Labour  39                      5                       4     5
1421           Labour  74                      4                       4     5
1422     Conservative  61                      3                       2     2
1423           Labour  45                      4                       4     4
1424           Labour  72                      4                       4     5
1425           Labour  46                      3                       3     2
1426 Liberal Democrat  84                      4                       4     2
1427           Labour  60                      4                       4     4
1428           Labour  49                      5                       5     4
1429           Labour  59                      3                       3     5
1430           Labour  53                      3                       4     4
1431           Labour  78                      3                       3     5
1432           Labour  42                      3                       4     4
1433           Labour  79                      4                       4     5
1434 Liberal Democrat  59                      4                       3     4
1435           Labour  66                      4                       4     5
1436           Labour  54                      5                       3     4
1437           Labour  62                      4                       1     1
1438     Conservative  34                      2                       2     2
1439           Labour  40                      4                       3     4
1440           Labour  87                      4                       4     4
1441 Liberal Democrat  34                      3                       3     2
1442           Labour  48                      3                       3     5
1443     Conservative  68                      2                       3     2
1444           Labour  36                      4                       5     4
1445           Labour  69                      4                       4     4
1446           Labour  71                      4                       3     4
1447 Liberal Democrat  75                      4                       4     4
1448 Liberal Democrat  69                      3                       3     2
1449           Labour  55                      4                       3     4
1450 Liberal Democrat  47                      4                       4     4
1451           Labour  43                      4                       4     4
1452           Labour  73                      4                       3     4
1453     Conservative  68                      3                       4     4
1454           Labour  62                      3                       3     2
1455     Conservative  42                      2                       2     4
1456           Labour  86                      2                       4     2
1457           Labour  44                      4                       3     4
1458     Conservative  59                      3                       3     2
1459           Labour  56                      3                       3     2
1460           Labour  72                      3                       5     5
1461           Labour  43                      4                       3     4
1462           Labour  44                      3                       4     5
1463           Labour  76                      5                       3     4
1464           Labour  57                      3                       1     4
1465           Labour  44                      3                       3     4
1466           Labour  46                      4                       4     4
1467           Labour  36                      2                       2     5
1468 Liberal Democrat  58                      3                       2     4
1469           Labour  41                      3                       4     4
1470     Conservative  70                      1                       1     2
1471           Labour  46                      4                       3     4
1472           Labour  65                      3                       3     4
1473           Labour  79                      5                       5     2
1474           Labour  54                      3                       3     4
1475           Labour  56                      4                       3     2
1476           Labour  36                      4                       3     4
1477           Labour  56                      2                       2     4
1478           Labour  50                      4                       2     2
1479 Liberal Democrat  42                      3                       3     4
1480           Labour  79                      4                       4     5
1481 Liberal Democrat  55                      2                       1     4
1482     Conservative  50                      3                       2     2
1483           Labour  56                      2                       3     4
1484     Conservative  65                      3                       2     4
1485 Liberal Democrat  48                      4                       2     2
1486     Conservative  41                      2                       2     2
1487           Labour  79                      3                       3     5
1488           Labour  49                      4                       4     4
1489           Labour  77                      5                       4     5
1490     Conservative  60                      4                       3     2
1491     Conservative  54                      3                       3     2
1492           Labour  64                      3                       3     4
1493     Conservative  50                      2                       3     2
1494 Liberal Democrat  34                      3                       1     4
1495     Conservative  78                      3                       3     2
1496 Liberal Democrat  46                      3                       2     1
1497           Labour  41                      4                       5     5
1498           Labour  65                      4                       3     4
1499           Labour  65                      3                       3     2
1500     Conservative  79                      2                       2     2
1501           Labour  67                      2                       3     4
1502     Conservative  44                      3                       1     4
1503           Labour  31                      4                       3     4
1504     Conservative  54                      5                       2     4
1505 Liberal Democrat  63                      3                       2     4
1506 Liberal Democrat  75                      3                       2     4
1507           Labour  62                      3                       3     4
1508     Conservative  52                      2                       1     1
1509     Conservative  70                      2                       2     4
1510           Labour  67                      3                       3     5
1511           Labour  73                      4                       3     4
1512           Labour  63                      3                       3     4
1513     Conservative  75                      3                       3     2
1514           Labour  46                      3                       3     4
1515           Labour  74                      3                       3     5
1516     Conservative  82                      2                       2     2
1517           Labour  30                      3                       4     4
1518           Labour  76                      4                       3     2
1519           Labour  50                      3                       4     4
1520     Conservative  35                      3                       4     4
1521     Conservative  67                      5                       3     2
1522     Conservative  73                      2                       2     4
1523           Labour  37                      3                       3     5
1524     Conservative  61                      3                       3     1
1525     Conservative  74                      2                       3     2
     Hague Kennedy Europe political.knowledge gender education
1        1       4      2                   2 female        20
2        4       4      5                   2   male         7
3        2       3      3                   2   male        19
4        1       3      4                   0 female         7
5        1       4      6                   2   male        14
6        4       2      4                   2   male        12
7        4       2     11                   2   male        18
8        1       4      1                   0   male        11
9        4       4     11                   0 female         7
10       1       1     11                   2   male        13
11       2       1      7                   0 female        11
12       4       4      9                   2   male        15
13       1       4     10                   2 female        11
14       5       4      8                   0 female        17
15       1       4     11                   2 female        11
16       4       4      5                   0   male        17
17       4       3      8                   0 female        11
18       4       2      7                   2 female        11
19       2       4      1                   0   male        10
20       1       4      5                   2 female        16
21       4       2      7                   0   male        11
22       4       4      5                   2   male        20
23       2       2      1                   2   male         9
24       4       4      9                   2   male        11
25       4       4      2                   2 female        11
26       3       3      6                   0 female         9
27       4       4      9                   2 female         8
28       2       4      2                   2 female        19
29       2       4      1                   2   male         8
30       1       2      1                   2   male         8
31       4       2      6                   2 female         9
32       2       2      6                   0   male        13
33       2       2      1                   2 female        19
34       2       2      1                   2   male        10
35       4       4      3                   2 female         9
36       4       3      6                   3 female        17
37       2       3      7                   0 female        18
38       4       4      3                   2   male        10
39       4       3     11                   0 female         7
40       2       2     11                   2 female        18
41       2       2      6                   0 female         7
42       2       2      4                   0 female        10
43       2       4      8                   0 female        19
44       1       3      1                   2 female        14
45       2       4      4                   2   male        11
46       4       1      6                   3 female        15
47       2       2      7                   2 female         8
48       4       3     10                   2   male        20
49       4       1      4                   3   male         8
50       1       5      1                   2   male        17
51       4       4      4                   2   male        17
52       4       2      9                   0   male        19
53       4       2      1                   2   male        12
54       5       2     11                   0 female         8
55       1       4      1                   0 female        13
56       4       3      4                   0   male        10
57       1       4      4                   3   male        14
58       4       1      1                   2   male         7
59       5       3      9                   0   male        20
60       2       2      6                   2 female        17
61       2       2      8                   0 female        19
62       1       4     11                   2   male        19
63       2       2      6                   2 female        14
64       4       4      7                   0 female         8
65       3       3      6                   2   male        14
66       4       3      8                   0 female        18
67       4       4     11                   2 female        13
68       2       4      3                   2   male        19
69       2       4     11                   0 female         9
70       1       4      6                   2   male        14
71       2       4      2                   3 female        20
72       2       2      5                   0   male        13
73       4       4     11                   0 female         8
74       1       4      4                   3   male        16
75       2       4      6                   2   male        13
76       2       4      5                   3   male        10
77       2       4      4                   2 female        18
78       4       4      4                   2   male         7
79       2       3      6                   0 female         8
80       2       4      3                   2 female        13
81       2       3      8                   0 female        18
82       4       2      5                   0 female        11
83       4       4     11                   0 female        10
84       4       4      3                   0 female        15
85       2       4      5                   2 female        17
86       2       4      3                   2   male        14
87       2       3      6                   0 female        16
88       4       4     11                   2 female        11
89       1       3      4                   2 female        12
90       1       5      5                   3   male        10
91       1       4      4                   2   male         8
92       4       3      8                   3 female        18
93       4       4      8                   3   male        18
94       2       4      1                   0   male        10
95       2       2      6                   0 female        10
96       1       4      5                   3 female        14
97       4       3      5                   2 female        16
98       2       3     10                   0   male        19
99       4       4      1                   0   male        19
100      1       4     11                   0   male        14
101      2       4      6                   0   male        12
102      2       4      3                   2   male        20
103      2       4      6                   2 female        20
104      4       4      8                   2 female        15
105      2       3      7                   2   male        18
106      4       1      8                   0 female        16
107      2       2      4                   0   male        11
108      1       5      1                   2   male        10
109      4       2      9                   0 female        12
110      4       4     11                   0   male        17
111      1       2      4                   2   male         9
112      2       2      3                   0   male        20
113      4       3      8                   0 female         9
114      3       3      2                   0 female        15
115      2       3      5                   2 female        11
116      4       2     11                   3 female        19
117      2       2      6                   0   male        12
118      2       4      8                   2 female        20
119      4       3      4                   2 female        12
120      2       2     11                   0 female        13
121      1       4      8                   0   male        11
122      2       4      1                   2   male        11
123      1       2      5                   0 female        15
124      2       4     11                   2 female        17
125      2       4      6                   2   male        19
126      2       3      9                   2 female         8
127      4       2      2                   2   male        16
128      2       2      3                   2   male         9
129      4       4      7                   0 female         7
130      4       4      4                   0 female        17
131      4       3      7                   3 female        16
132      4       3      8                   2 female         7
133      4       2      7                   2 female        18
134      4       3      5                   2   male        11
135      3       4      6                   2   male        11
136      4       2      6                   0   male        16
137      5       3      3                   0 female        20
138      4       2      6                   2 female        12
139      5       1     10                   3   male         9
140      4       2      1                   0 female        13
141      2       4      4                   3   male        20
142      2       4      1                   2 female        20
143      3       3      3                   0   male        18
144      1       3      6                   0 female        13
145      2       4      1                   2 female         9
146      4       3      6                   0 female        19
147      2       2      8                   2 female        10
148      2       2      6                   0 female        17
149      2       4      6                   0   male         7
150      4       4      3                   2 female        20
151      2       3      6                   2 female         9
152      4       4     11                   2 female        14
153      2       3      6                   2 female        10
154      2       2      8                   2   male        14
155      2       4      1                   2 female        11
156      3       3      4                   2 female        13
157      1       2      4                   0   male        13
158      1       1     11                   0 female        16
159      2       4      4                   0   male        12
160      4       2     11                   0 female        12
161      4       2      6                   0 female        19
162      1       4      6                   2   male        20
163      4       2      5                   0 female         9
164      2       4      4                   2 female        19
165      2       1      3                   2 female        14
166      4       4      6                   2   male        12
167      4       4      4                   2 female        15
168      4       3      3                   2   male        15
169      2       5      5                   3 female        14
170      1       5      3                   0 female        12
171      1       1      5                   2 female        19
172      1       4      3                   2 female        11
173      2       4      5                   2 female        19
174      2       4      2                   3   male        12
175      1       4      3                   3   male         9
176      1       4      2                   2 female        19
177      4       4      1                   2   male        16
178      2       2      6                   2 female         8
179      4       2      8                   3 female        20
180      2       2      4                   3   male        20
181      1       2      2                   3   male        10
182      4       4     11                   3 female         7
183      4       2     11                   3   male        15
184      4       3      3                   0 female        13
185      4       2     11                   2 female         7
186      4       5      5                   0 female         7
187      5       4     11                   2 female        12
188      2       1     11                   2 female         7
189      2       3     10                   0 female        15
190      4       2      8                   3   male        19
191      2       4      5                   0 female        14
192      2       2     11                   0 female        16
193      2       4     11                   2   male        18
194      2       4      8                   2 female        19
195      4       1     11                   2   male        14
196      4       4      3                   2 female        12
197      4       2     11                   2 female        11
198      2       5      7                   2 female        17
199      1       4      2                   3 female        20
200      4       2      8                   2   male        17
201      1       3      8                   0   male        18
202      4       4      4                   2   male        15
203      4       3      7                   0   male         8
204      2       4      6                   2 female        13
205      2       2      6                   0 female        16
206      2       4     11                   3   male        14
207      4       1      5                   3   male        10
208      2       4      5                   0 female        12
209      2       4      5                   3   male        10
210      1       5      4                   0 female         9
211      2       4      6                   2 female        10
212      2       4      2                   1 female         9
213      4       2      7                   1 female         9
214      2       4      2                   2   male        10
215      2       1      7                   0   male        19
216      4       1     11                   3   male        13
217      1       4      3                   3   male        16
218      2       4      3                   0 female        17
219      2       2      4                   2   male        19
220      2       4      5                   2   male        12
221      3       3      9                   2 female        16
222      2       4      4                   0 female         7
223      1       4      6                   0 female         8
224      4       4      7                   2 female        17
225      2       1      8                   2 female        16
226      1       3      6                   2   male        11
227      4       1      8                   1 female        20
228      4       4      5                   2 female        10
229      2       2      6                   0 female         8
230      2       4      8                   0 female        12
231      4       4     10                   0 female        12
232      2       2      4                   3   male        14
233      2       3      6                   1 female        16
234      1       2      1                   2 female        10
235      2       2      6                   0   male        20
236      2       2      7                   2 female        18
237      3       3      6                   0 female        18
238      1       4      5                   0   male        19
239      4       3      6                   2 female        18
240      1       2      9                   0 female         7
241      2       3      3                   2 female        17
242      1       4      4                   0 female        14
243      1       1      8                   0   male        19
244      4       4      1                   3 female         9
245      2       4      6                   2 female        15
246      4       3      1                   0 female        10
247      4       4     11                   0 female        12
248      2       5      5                   0 female         9
249      1       4      2                   3   male        13
250      4       2      6                   0 female        20
251      1       5     11                   2   male         8
252      2       4      1                   0 female        11
253      1       5      6                   2 female         7
254      1       4      3                   2 female        16
255      1       1      2                   2   male        14
256      2       4      4                   0 female        15
257      1       3      9                   0 female        18
258      2       2      9                   0 female        15
259      4       4      7                   0 female         9
260      2       4      1                   0 female        16
261      4       2      4                   2 female        13
262      2       2      3                   2   male         9
263      4       5     11                   0 female        16
264      2       2     11                   2 female        15
265      1       4      1                   2 female        16
266      3       3     10                   0   male        16
267      3       3      3                   3   male        12
268      4       5      9                   2   male        11
269      2       2      1                   3 female        17
270      2       4     11                   0 female        12
271      4       4      6                   0 female        14
272      4       4     10                   2 female        15
273      2       4      5                   0 female        11
274      4       2     11                   2   male         7
275      2       5     11                   0 female        10
276      2       4      8                   0 female        15
277      1       2      6                   0 female         7
278      4       2     10                   3 female         8
279      2       5      8                   0 female        15
280      4       4      6                   0 female        18
281      2       4      6                   0 female        14
282      1       1      8                   3   male        13
283      1       4     11                   0 female        15
284      2       4      9                   0   male         9
285      2       4      9                   3   male         7
286      1       2      6                   2 female        17
287      2       4      7                   2 female        10
288      4       4     11                   0 female        18
289      1       4      1                   2 female         9
290      4       1      3                   3   male        18
291      4       2      8                   2 female        12
292      5       1     11                   2 female         7
293      2       4      6                   1 female        14
294      2       4      8                   3 female        20
295      4       2     11                   0 female        18
296      2       2      2                   3   male        15
297      4       3      6                   2   male        19
298      2       3     11                   0   male        13
299      2       4     11                   0 female        20
300      1       2      2                   2   male        13
301      2       3      4                   2   male        16
302      2       5     11                   0   male        17
303      2       4      9                   0 female         9
304      2       4     11                   0 female        14
305      2       2     11                   2 female        20
306      4       4     10                   2   male        10
307      2       2     10                   3   male        15
308      2       2      4                   2   male        11
309      4       2      2                   2   male         8
310      1       3      1                   0 female        12
311      2       3      6                   2   male        10
312      2       4      6                   2   male        12
313      1       1     11                   2   male        11
314      4       4      9                   2 female        17
315      2       1      4                   1   male         8
316      4       2      9                   2   male        12
317      4       2     11                   3   male         7
318      1       5     11                   2   male        11
319      2       3      7                   2 female        12
320      5       1     10                   1 female        20
321      1       2      4                   2 female        11
322      1       2      6                   2 female        12
323      4       4      1                   0 female        10
324      2       2      6                   0 female        14
325      1       4      6                   0 female        19
326      2       3      9                   0 female        15
327      1       5     11                   0   male        19
328      4       2      9                   2   male        15
329      1       4      7                   2 female        11
330      2       4      3                   2   male        18
331      4       4     11                   0 female        14
332      4       3     10                   2   male        13
333      3       3     11                   0 female        13
334      2       4      4                   3   male        17
335      2       4      5                   2   male        15
336      2       4     10                   0 female        15
337      1       4      6                   3   male         8
338      4       4      6                   3   male         9
339      5       1     11                   3   male        13
340      2       4      2                   3   male         9
341      4       4      7                   0   male        18
342      4       2     11                   2   male        12
343      4       5      6                   2 female        18
344      5       1     11                   2 female        19
345      4       4     10                   0 female         7
346      5       5      1                   3   male        16
347      4       2      2                   0   male         7
348      4       3     11                   2   male        14
349      2       4      6                   2 female        18
350      2       2      1                   2 female        12
351      2       3      9                   3 female         7
352      4       3     10                   2 female         9
353      2       2      5                   3 female        14
354      5       3     11                   2 female        20
355      4       2      6                   0 female         8
356      4       3     10                   2   male        11
357      4       4      3                   3 female        18
358      4       3     11                   3 female        18
359      1       4     10                   2 female         7
360      2       2      5                   2   male        14
361      3       3     11                   3 female        13
362      2       4     11                   2 female        12
363      4       4     11                   1   male        20
364      4       4      9                   2 female        13
365      5       1     11                   0   male        20
366      2       4      5                   2   male         7
367      1       4      2                   3   male        18
368      4       3      9                   0 female        16
369      4       1     11                   2 female         7
370      2       4      8                   3   male         8
371      4       5     10                   2 female        20
372      4       2      5                   2   male        11
373      2       4      4                   3   male        16
374      2       2      8                   2   male        10
375      2       4      4                   0   male         7
376      4       2      9                   0   male        13
377      2       1     11                   2 female        16
378      4       1      8                   2   male        20
379      2       4      5                   2 female        14
380      4       4      9                   2 female        16
381      2       3      7                   1 female        13
382      4       4     10                   2   male        20
383      1       2      4                   3 female        18
384      4       3      1                   0 female        17
385      2       1      9                   2   male        12
386      4       1     10                   2 female        13
387      5       4     11                   2   male        12
388      4       2      5                   3   male         9
389      2       4     11                   0   male        10
390      2       2     11                   0   male        17
391      2       4      5                   2   male        11
392      2       4     11                   2   male        11
393      2       4      2                   3   male        16
394      4       4     10                   2 female        20
395      4       3      6                   0 female        10
396      2       4      7                   0   male        19
397      4       4      5                   2 female        10
398      4       3      3                   3   male        13
399      2       2      6                   2 female        20
400      1       1     11                   0 female        16
401      2       4      9                   2   male        18
402      4       4     11                   0   male        18
403      4       4      5                   2 female         9
404      4       1      4                   0   male        20
405      4       4     10                   2 female        17
406      2       2      3                   3 female        18
407      1       4      6                   2 female        15
408      5       4     11                   2 female        18
409      4       4      1                   3   male        13
410      2       3      9                   3 female        15
411      1       2     10                   2 female        15
412      2       2      4                   2 female        19
413      4       2     11                   2   male        14
414      4       3      2                   2   male         9
415      4       2     11                   3 female         8
416      4       4     11                   2   male        15
417      1       1      7                   2   male        12
418      2       4      6                   3   male        20
419      2       2     11                   2   male         7
420      2       4      7                   2 female        19
421      1       4      2                   3   male        15
422      4       4      8                   2 female         7
423      2       5      1                   2   male        10
424      1       4      3                   2   male        17
425      4       1      9                   0   male        11
426      4       4      9                   2 female        16
427      2       4      2                   2   male        15
428      1       3     11                   2 female        14
429      2       4      6                   2 female        17
430      4       2     11                   2   male        12
431      4       4     11                   2 female         8
432      2       3     11                   1   male         9
433      4       4      1                   3 female        15
434      4       3     11                   2 female         8
435      2       4      8                   3   male        10
436      2       4      6                   0   male        19
437      4       1      8                   2   male         7
438      2       2      6                   2   male        10
439      1       4      5                   3   male        11
440      1       2      6                   2   male         8
441      4       4     11                   0 female        11
442      4       3      1                   0 female        10
443      4       2      3                   0   male         8
444      2       3      7                   2   male        18
445      1       2     10                   0 female        19
446      1       4      3                   2   male        19
447      4       2      9                   2   male        13
448      4       2      1                   0   male        16
449      4       2      3                   2 female        13
450      4       4     11                   2   male        20
451      4       2     11                   0 female        15
452      4       3     11                   2   male         8
453      2       4      8                   2 female        10
454      1       2     11                   0 female        19
455      4       4     11                   3 female        19
456      2       4      6                   3 female         9
457      1       1      1                   3   male         7
458      2       3     11                   0 female         9
459      3       3      5                   3   male         7
460      2       4     11                   0   male        18
461      4       4      3                   0   male        17
462      2       1      2                   2 female        11
463      2       2      6                   0   male         8
464      1       4      6                   2 female        15
465      2       4     10                   2 female        14
466      4       3     11                   2 female        10
467      4       4     11                   2   male        16
468      4       4      2                   2   male        13
469      2       2      5                   0   male        14
470      4       2     11                   2   male        12
471      4       2     10                   3   male        11
472      2       2      7                   2   male         7
473      2       2      8                   0   male        18
474      4       3      4                   2 female        20
475      4       2      8                   2   male        14
476      2       2      3                   3 female        18
477      4       3     11                   2 female        14
478      4       4      9                   2   male        18
479      2       2      1                   2   male        12
480      2       3      2                   2 female        17
481      4       4     11                   2 female         8
482      2       4      3                   3   male        15
483      2       2      3                   3   male        18
484      2       4      2                   3   male        19
485      1       3      6                   2   male        10
486      4       2     10                   2 female        12
487      4       4      3                   0 female         7
488      1       4      3                   3   male        10
489      4       2      9                   2   male        13
490      1       4      3                   3   male        17
491      4       4      6                   0 female        12
492      2       4      5                   3   male         9
493      1       2      6                   0 female         8
494      4       3      7                   2 female        17
495      4       4      7                   2 female        13
496      3       4      6                   0 female        15
497      2       4      8                   2   male        11
498      2       2     11                   2   male        19
499      4       2     11                   0   male        11
500      2       2      1                   2   male        12
501      2       2      3                   2   male        18
502      2       2      7                   2   male        10
503      4       4      5                   2 female        20
504      4       2      7                   2 female        18
505      2       4      8                   2 female         7
506      4       2      9                   2   male        15
507      4       2      6                   2 female        18
508      2       4      7                   3   male         7
509      4       3     11                   2 female         7
510      5       4     11                   2   male        17
511      2       1     10                   2 female         9
512      4       4      7                   2 female        15
513      1       4      8                   0   male        16
514      4       3      7                   2   male        19
515      2       5      7                   3   male        15
516      3       3      4                   2   male        10
517      4       5     11                   0   male         7
518      4       2      8                   2   male        10
519      2       2     11                   3   male        20
520      4       4     11                   2   male        17
521      2       2      8                   0 female         9
522      1       4      2                   2   male        14
523      2       4      3                   2 female        19
524      2       1      7                   2 female        12
525      4       4      5                   2 female        18
526      4       4      2                   2 female         9
527      2       4      3                   2 female        20
528      4       2     11                   2 female        17
529      4       4      5                   2 female        19
530      4       4     10                   2 female        14
531      4       2      8                   0   male        12
532      2       3      6                   2 female        17
533      5       2     11                   1   male        17
534      2       4     11                   0 female        17
535      1       4      3                   2   male        17
536      2       4      4                   3   male         7
537      1       4      4                   3   male         7
538      4       2     11                   2   male        14
539      2       4      8                   0   male        20
540      2       3      4                   2 female        17
541      1       4      1                   3   male        10
542      4       4     11                   2   male        19
543      4       3      5                   0   male        11
544      2       4      6                   2 female        20
545      1       1     11                   2 female        15
546      2       2      3                   3   male        14
547      5       4      4                   2 female        15
548      4       3      8                   0 female        20
549      2       1     11                   3   male        19
550      2       4      4                   2 female        17
551      1       4     10                   2 female        17
552      4       2      6                   2 female        15
553      4       3     11                   2   male        20
554      4       3      9                   2 female        14
555      4       2     10                   2   male        19
556      2       3      6                   2 female        10
557      2       2      8                   0 female         8
558      2       4      4                   2   male        18
559      2       2     11                   3   male        11
560      2       4      5                   2 female        10
561      2       4     11                   0   male         9
562      1       4      2                   0   male        12
563      2       5      8                   1   male        14
564      4       4      8                   2   male        16
565      4       2      6                   2 female        18
566      1       2      1                   2   male        10
567      1       2      4                   3   male         9
568      2       4     11                   2 female        13
569      4       3      4                   2 female        16
570      2       2      5                   2 female        12
571      2       2      3                   2   male        16
572      4       5     10                   3 female         7
573      4       2      8                   0   male        15
574      4       4      1                   0   male         9
575      4       2     10                   3 female        20
576      4       4      9                   2   male        12
577      4       2     11                   2 female        19
578      4       2      8                   2 female        10
579      4       4      8                   0   male         9
580      2       5      1                   3   male        17
581      4       4     11                   0 female        15
582      4       4      6                   0 female        16
583      4       1     11                   2 female        18
584      4       4     10                   2 female        11
585      1       3      6                   0 female        12
586      5       3      9                   3   male        18
587      2       3      3                   2   male        20
588      1       1     11                   2 female        18
589      4       3     11                   2 female        11
590      2       4      1                   3   male        19
591      4       2      9                   3   male        18
592      2       4      4                   2   male         7
593      2       2     11                   2   male        19
594      4       4     11                   2 female        12
595      5       3     10                   2 female        18
596      5       4      3                   2   male        13
597      4       3      7                   2 female         8
598      2       2      3                   2   male        10
599      2       1      5                   3 female         7
600      3       3     11                   2 female        13
601      2       1      1                   3   male         8
602      4       2      4                   0   male        11
603      2       4      6                   0 female         8
604      2       4     11                   0 female        15
605      2       4      8                   2   male        12
606      4       2      9                   0 female        15
607      4       2     11                   2 female         7
608      2       1     11                   2 female        13
609      2       2      5                   2   male        15
610      1       4      4                   3 female        18
611      4       2     11                   2   male        19
612      2       4     11                   2 female        17
613      4       5     10                   2   male        14
614      4       5      7                   3   male        19
615      2       2      9                   2 female        10
616      4       3     11                   2   male        10
617      2       4      5                   3   male        10
618      4       2     11                   2   male         9
619      2       4      3                   2   male        17
620      4       2      7                   2 female        10
621      4       3      6                   0   male        13
622      4       5      6                   3 female        17
623      2       2     11                   2   male         7
624      2       2      6                   2 female        13
625      2       3     11                   3 female        17
626      4       4      2                   0 female        12
627      2       4      5                   2   male        20
628      5       2     11                   2   male        15
629      4       2     10                   2 female        19
630      2       4     11                   1 female        10
631      4       5      5                   2 female        16
632      2       4      4                   2 female        12
633      4       1      9                   2 female         9
634      4       4     11                   3   male         8
635      4       4      6                   3 female        18
636      2       4      4                   0 female        17
637      1       4     10                   2   male         8
638      4       1      3                   2 female        15
639      2       2      5                   2   male         9
640      4       4     10                   2 female        20
641      4       4     11                   2 female         7
642      2       4      4                   2 female         8
643      4       2      3                   2   male        13
644      4       4     11                   2 female        18
645      4       3     10                   0 female         8
646      1       4      4                   0 female        20
647      5       2      9                   2 female        11
648      2       4      6                   2 female        10
649      4       5     11                   2   male        17
650      4       2      7                   2 female        12
651      4       4      1                   0 female        10
652      4       1     11                   0 female        17
653      1       4     11                   2   male        11
654      5       3      8                   3 female        14
655      3       3     11                   0 female        13
656      2       4     11                   0 female        19
657      3       3     11                   2 female         9
658      4       1     11                   3   male        16
659      2       4      6                   0 female        13
660      5       5      7                   2   male        12
661      4       4      7                   2 female        10
662      2       3      8                   2 female        13
663      2       4     11                   2 female        14
664      4       4     10                   2   male        11
665      4       3      9                   2   male        12
666      5       4      9                   0   male         8
667      2       2      7                   2 female         9
668      2       4     11                   3 female         8
669      4       2     11                   2 female         9
670      2       2      3                   2 female        17
671      4       4     10                   0 female        11
672      2       4     10                   2 female        11
673      4       3      4                   2   male        12
674      2       4      6                   2   male        11
675      4       3      6                   2   male        18
676      4       3     11                   2 female        20
677      4       3     10                   2   male        14
678      2       4     11                   0   male        18
679      5       2     11                   2   male        11
680      4       3      6                   2   male        15
681      2       2     11                   2   male         8
682      5       2     11                   3 female        20
683      4       2     11                   2 female         7
684      4       4     10                   2 female        15
685      2       1     11                   2 female         7
686      4       2     11                   2 female        20
687      2       2      3                   0 female        10
688      4       2      5                   2 female        15
689      5       4     11                   2 female        12
690      3       3      6                   3 female        16
691      4       2      7                   2 female        10
692      2       4      6                   2   male        12
693      1       4     11                   2 female        18
694      4       4      5                   2 female        19
695      1       2     11                   0   male         7
696      4       4     11                   2   male        10
697      2       4      1                   2 female        20
698      4       2      2                   0 female        16
699      1       4      1                   2   male        10
700      4       4      2                   2   male        20
701      2       4      4                   0 female         8
702      2       3     10                   0   male        18
703      2       4      2                   3   male         9
704      2       2      8                   2   male        18
705      2       4      3                   2   male        10
706      4       4      3                   3   male        19
707      2       4      8                   0   male        20
708      4       4     11                   0   male        15
709      1       4      3                   2 female         9
710      2       4      3                   2   male         9
711      2       4      5                   3   male        20
712      4       2      6                   0 female         8
713      4       4      6                   2   male         7
714      2       4      1                   1   male        10
715      4       5      5                   2 female        15
716      2       2      2                   2   male        10
717      1       3     11                   1 female        15
718      1       2      6                   2 female         8
719      2       3      9                   0   male        18
720      4       2     10                   3   male        18
721      5       2     11                   0   male        15
722      4       1     11                   2   male        17
723      2       4      6                   2 female        16
724      1       2      7                   3   male        18
725      2       4      7                   2 female        20
726      1       4      5                   3   male        17
727      2       2      9                   0 female        13
728      1       4      6                   0 female        18
729      2       2      6                   2 female        19
730      1       3      4                   3 female        19
731      2       4      4                   2 female        12
732      1       3      1                   2 female        10
733      3       3      5                   3   male        19
734      1       2      3                   3 female        11
735      2       4      4                   2   male        16
736      2       4      2                   3   male         8
737      2       4      8                   2   male        12
738      1       3      6                   3   male        18
739      2       2      9                   0   male        18
740      3       3      7                   1 female        14
741      2       2      2                   3   male        13
742      2       2      7                   0 female        10
743      2       2      4                   0 female        19
744      2       4      6                   2   male        10
745      4       4      5                   0   male        18
746      2       2     10                   2 female         7
747      4       2     11                   2   male         9
748      2       4     11                   2 female         8
749      2       4     11                   0 female        20
750      4       3      6                   0   male        17
751      4       4      3                   0 female         7
752      2       4      5                   3   male         9
753      4       4      3                   1 female        15
754      4       4     10                   2   male         8
755      5       2      1                   0 female        18
756      2       3      7                   2 female        18
757      2       4      8                   0 female        20
758      3       3      1                   2   male        17
759      2       1      9                   3   male        14
760      4       4      8                   2 female        15
761      4       3     10                   2   male        20
762      4       3      9                   0   male         9
763      1       1      9                   0 female        15
764      4       3      8                   3 female        19
765      2       4      6                   2   male        19
766      4       4      8                   2 female        11
767      2       4     11                   0 female        20
768      4       1      5                   2   male        19
769      4       1     11                   3   male        15
770      2       2      9                   0   male         7
771      4       3      2                   3 female         7
772      2       1      9                   0   male        15
773      5       2     11                   2 female        11
774      4       4     10                   2 female        16
775      4       3      8                   2 female        11
776      2       5      3                   3 female        17
777      2       2      9                   2 female        13
778      2       4      2                   2   male         7
779      4       1     11                   2   male        20
780      4       2      4                   0   male        18
781      1       4      1                   2 female        12
782      4       4      7                   2   male        18
783      2       2      6                   2   male        20
784      2       3      5                   2 female        15
785      2       4      2                   3   male        17
786      1       4      5                   2 female        13
787      1       4      1                   2 female         9
788      1       4      1                   3 female        10
789      1       4      5                   2   male        18
790      4       2      8                   0 female        16
791      1       2      7                   2 female        15
792      1       2      5                   3   male        20
793      4       5      4                   3 female        19
794      2       4     10                   0   male        15
795      1       4      3                   2   male         9
796      2       2     10                   0 female        14
797      2       1      6                   2 female        12
798      1       4      2                   2   male        14
799      2       4      6                   2 female        12
800      3       4      6                   2 female        19
801      4       4      7                   2 female        18
802      1       2      5                   2   male        12
803      2       2      4                   2 female         7
804      4       4      6                   0   male        18
805      4       2      8                   3   male         9
806      5       3     10                   2   male        20
807      2       2      5                   3 female        13
808      2       4      5                   2   male        11
809      1       4      5                   3   male        10
810      4       3      3                   3   male         9
811      4       4     10                   3 female        18
812      4       3     11                   2   male        16
813      2       4      8                   3   male        16
814      1       1      6                   2   male         7
815      1       5      2                   3 female        17
816      2       4      3                   2   male        15
817      3       3      4                   3 female         9
818      5       4     10                   2   male        12
819      4       2     11                   3 female        10
820      4       4      5                   2 female        20
821      4       2      4                   0   male         9
822      2       2     11                   2 female        18
823      4       3      5                   2 female        14
824      4       4      2                   2 female        11
825      4       4     10                   2   male        11
826      4       2      6                   2   male        14
827      2       3      6                   0 female        14
828      4       4      5                   2 female        19
829      4       2      1                   0 female        12
830      4       3      1                   2   male        17
831      5       4      9                   2   male        12
832      2       4      5                   3 female        20
833      2       2      4                   2   male        11
834      2       4      4                   2   male         8
835      1       5      3                   3 female         7
836      2       4     11                   0 female        19
837      3       3     11                   2 female        20
838      2       2     10                   2 female        12
839      2       4     11                   2 female         9
840      1       3      9                   0   male        16
841      2       4      8                   2   male        16
842      4       4     11                   0 female        18
843      2       2     10                   2 female         7
844      2       4      6                   2   male         8
845      4       4      8                   0 female        16
846      4       4      7                   2 female        15
847      1       1     11                   2 female        16
848      4       2      6                   2 female        15
849      1       2     10                   0 female        20
850      5       4     11                   0 female         9
851      3       3     11                   1 female        20
852      1       4      9                   2 female        17
853      4       3     10                   2 female        20
854      4       2      5                   1 female         9
855      2       3     11                   3   male        15
856      2       4      9                   2 female        15
857      4       3      1                   2 female        18
858      2       5      6                   2   male        16
859      2       4      8                   0   male        19
860      2       4      5                   2 female        18
861      4       1     11                   2   male         8
862      2       2      9                   2 female         9
863      2       2      5                   2   male         7
864      2       2      8                   2 female        19
865      4       1      9                   2 female        18
866      4       2      3                   0   male        16
867      1       4      6                   2 female         7
868      4       4     11                   2 female        16
869      4       4      9                   2 female         7
870      1       4      9                   0 female         9
871      2       1      4                   3   male        18
872      4       2     11                   2 female        14
873      4       1     11                   2   male        15
874      4       1     11                   3 female        11
875      4       4      8                   2   male        13
876      2       4      9                   0 female        11
877      4       5     11                   2 female        20
878      1       4      1                   2   male        16
879      4       4     11                   2 female        18
880      4       2     11                   0   male         7
881      2       4      4                   3   male        11
882      1       4      6                   3 female        15
883      2       2     11                   2 female         8
884      2       4      8                   2   male        16
885      2       3      6                   2   male         7
886      4       3      6                   0 female        20
887      4       3     11                   0 female        11
888      1       4      2                   3   male         7
889      4       2      6                   0 female        14
890      4       4     11                   0   male        14
891      2       4     10                   0 female        19
892      2       2      9                   3   male        14
893      1       4      6                   3 female        17
894      2       4      2                   2 female        14
895      4       2     11                   3 female        19
896      1       4      3                   3   male        18
897      4       4      6                   2 female        20
898      2       1      6                   2 female        14
899      2       1     11                   2   male        14
900      5       4      9                   0   male        19
901      4       4     11                   2   male         8
902      4       4      7                   2   male         8
903      1       2      6                   2 female         9
904      4       3      7                   0 female         7
905      2       2      8                   2 female        16
906      1       4      4                   3   male        18
907      2       4      9                   0   male        16
908      4       4      8                   0 female        20
909      2       4      9                   2 female         8
910      1       4      2                   3   male        20
911      2       4      3                   3   male        14
912      1       2      1                   3 female         9
913      2       4      5                   0 female         8
914      2       3      2                   3   male        13
915      2       2      4                   0 female        19
916      4       4      5                   3 female         9
917      2       4      2                   2 female        19
918      2       2      6                   2 female        11
919      2       4      7                   1 female        18
920      4       4      2                   2   male        16
921      2       4      1                   2 female        12
922      2       1      3                   0   male        13
923      4       2      5                   0   male        13
924      2       2      5                   2   male         8
925      4       4      8                   0 female        20
926      1       1      6                   2 female        14
927      5       2      7                   3   male         7
928      5       2     11                   2 female        15
929      2       2      7                   2 female        11
930      2       4      3                   2 female        16
931      1       3      3                   0 female        11
932      1       4      1                   0   male        13
933      4       4      5                   0 female        15
934      3       3     10                   2 female        16
935      4       4      9                   2   male        16
936      2       4      8                   2   male        16
937      2       4      3                   2   male         7
938      1       2      3                   2 female         7
939      4       4     11                   0   male        15
940      4       4      7                   0   male        10
941      4       4      5                   3 female        19
942      4       4      6                   0   male        13
943      4       3      6                   0   male        13
944      1       3      1                   2   male         8
945      4       3     11                   0   male        15
946      5       3     11                   2 female        14
947      2       5      2                   2   male        13
948      4       1     11                   2   male        13
949      2       2      4                   3   male        19
950      4       1      8                   3   male        16
951      1       4      9                   2 female         8
952      2       2     11                   2   male        18
953      2       3     10                   0 female        18
954      2       4      2                   3   male         8
955      4       3     10                   2 female        20
956      4       3      1                   0 female         9
957      2       2     11                   0 female         7
958      2       4      7                   2   male        10
959      2       4      9                   2   male         8
960      1       5      1                   3   male         7
961      2       5      9                   3   male        12
962      2       4      2                   2 female         9
963      4       4     10                   3 female        15
964      3       2     11                   1 female        19
965      4       3      6                   2   male        16
966      2       4      5                   2   male        18
967      2       1     11                   2   male        18
968      1       2      4                   0 female        12
969      1       4      4                   0 female        16
970      4       3      2                   2 female        14
971      4       4     11                   0 female        16
972      2       2      8                   2   male        20
973      2       4      3                   2 female        11
974      2       3     11                   0 female        12
975      2       4     10                   0   male        16
976      2       3     11                   0 female        17
977      4       4     11                   2   male        20
978      4       2     11                   1 female        15
979      2       2     10                   2   male        18
980      5       3     11                   2   male        16
981      1       3      6                   2   male        19
982      2       4     11                   2 female        14
983      2       4      9                   2   male        19
984      4       5      8                   2 female        11
985      4       3      6                   2 female        19
986      5       2      8                   2   male         9
987      5       3     11                   2 female        17
988      4       3     11                   1   male        20
989      4       4      9                   0   male        18
990      4       4     10                   2 female        12
991      2       4      3                   3 female         9
992      4       3     11                   2 female        18
993      4       4     11                   3   male         9
994      2       4     10                   0 female        17
995      1       4      5                   2   male        14
996      2       2      5                   0   male        14
997      4       4      1                   0   male        12
998      1       4      4                   3   male        18
999      4       3     11                   2 female        16
1000     2       4     11                   2 female        15
1001     2       4     11                   0   male        12
1002     2       4     11                   2   male         8
1003     5       5     11                   0   male        16
1004     4       4      4                   0 female         7
1005     2       1      7                   0 female        12
1006     2       3      5                   2 female        19
1007     4       5      4                   2 female        16
1008     1       3     11                   0   male        20
1009     4       2      8                   3 female        12
1010     2       2      4                   1 female        12
1011     2       4     11                   0 female        11
1012     2       4      3                   2 female        19
1013     4       3      4                   1 female        12
1014     4       4     11                   2 female         9
1015     1       2      9                   0   male        17
1016     4       2     11                   2 female         8
1017     2       4      6                   2   male        10
1018     4       4      5                   2   male         8
1019     4       3      6                   2 female        16
1020     2       4      1                   0   male         8
1021     2       2      5                   3   male        13
1022     1       2     11                   1   male        14
1023     4       4      3                   2   male        14
1024     2       4     11                   2   male        18
1025     2       2      4                   2   male        16
1026     2       4      4                   2 female         9
1027     4       3     11                   2 female        15
1028     2       4     10                   2   male         8
1029     4       1     11                   3   male        13
1030     2       3      9                   2 female        16
1031     2       4     11                   0 female         7
1032     4       3      8                   2 female        11
1033     3       3     10                   2   male         8
1034     2       2      7                   0 female        15
1035     2       2      3                   2 female        12
1036     4       4      2                   0   male        10
1037     4       4      6                   2 female        20
1038     2       4      2                   2   male        20
1039     4       2      6                   3 female         7
1040     4       2      4                   2 female        20
1041     4       2      4                   3 female         9
1042     2       4     10                   0 female        13
1043     2       3      5                   0   male        11
1044     2       2      5                   2   male        12
1045     2       2      3                   0   male         9
1046     4       4     11                   0 female        11
1047     4       2      6                   0 female        18
1048     4       4     10                   0   male        20
1049     2       4     11                   0   male        19
1050     2       3     11                   0 female        10
1051     1       4      6                   0 female        12
1052     2       2      9                   0 female        20
1053     2       2      3                   0   male        17
1054     5       1     11                   1   male        11
1055     2       5      6                   2   male        10
1056     1       2      3                   0   male         9
1057     5       5      9                   0 female         7
1058     1       4     11                   1   male        11
1059     2       2      8                   0 female        11
1060     4       4     11                   2   male        16
1061     4       4      6                   0 female        14
1062     4       5      5                   3   male         9
1063     2       3     10                   0   male        11
1064     2       4      2                   2 female        14
1065     2       3     11                   0 female        16
1066     2       2      1                   0   male        17
1067     4       4      6                   2   male        17
1068     2       4      3                   2   male        13
1069     2       1      6                   2   male        15
1070     4       2     11                   2   male         7
1071     1       5     11                   2   male        12
1072     5       1     11                   2 female         8
1073     2       4      6                   2   male        19
1074     5       4     11                   2 female        17
1075     4       4     11                   0   male        14
1076     2       1      1                   2   male         7
1077     4       2      8                   3   male        18
1078     3       4      8                   0 female        13
1079     1       5      4                   2   male         9
1080     2       2      2                   2 female        16
1081     1       4      1                   2   male        17
1082     3       3      5                   0   male        20
1083     1       5      6                   2 female        16
1084     1       4      3                   3   male        11
1085     5       2      9                   0   male         7
1086     2       3      7                   0 female        14
1087     4       5      6                   0 female        20
1088     4       4     10                   2 female        11
1089     2       2      1                   0 female        10
1090     5       3      9                   0   male        11
1091     2       4      4                   3   male         7
1092     5       5      3                   2   male        14
1093     4       3     10                   2   male        15
1094     1       4      2                   3 female        18
1095     4       3      5                   0   male         8
1096     2       2      2                   2 female        16
1097     4       4      7                   2 female        18
1098     2       2      1                   2 female        10
1099     4       2      9                   2 female         8
1100     1       3      6                   0   male         9
1101     4       3     11                   0 female        11
1102     5       3      8                   0   male         9
1103     2       2      6                   3 female        13
1104     1       4      4                   2 female        20
1105     2       4      8                   2   male        10
1106     3       2     11                   0   male        18
1107     2       2      4                   2 female        17
1108     4       4     11                   2 female        14
1109     4       4     11                   2 female        12
1110     2       4      8                   2 female        16
1111     4       3      4                   0   male        20
1112     4       3      3                   0 female        12
1113     1       4      2                   3   male         8
1114     2       2     11                   2   male        11
1115     1       4      8                   2   male        11
1116     4       2      8                   0 female         7
1117     1       4      3                   3 female         9
1118     2       4      2                   2 female        20
1119     4       2      9                   2 female        19
1120     4       2     10                   2 female        18
1121     2       5      9                   3   male         7
1122     2       1      5                   3   male        12
1123     2       2      9                   2   male         8
1124     4       4      1                   2 female         8
1125     5       3      5                   0 female         7
1126     2       4      6                   2   male        14
1127     2       4     10                   0 female        14
1128     2       3      6                   0 female        15
1129     2       4     10                   0 female        20
1130     2       3      6                   2   male        19
1131     4       1      7                   0   male        20
1132     5       4      7                   3 female        20
1133     1       2      1                   2   male        12
1134     5       2     11                   2 female        18
1135     5       4      9                   2   male        19
1136     4       5      3                   0 female        12
1137     4       4     11                   3 female        13
1138     2       2      4                   2   male         9
1139     2       2      4                   3   male        13
1140     1       4      3                   3   male        18
1141     1       4      3                   3   male         9
1142     3       3     11                   2 female        12
1143     5       2      6                   2 female        14
1144     2       3     11                   0 female        18
1145     4       2     11                   0   male         8
1146     1       4      1                   0 female        16
1147     2       2      6                   2   male        12
1148     1       2      6                   0 female        16
1149     2       4      5                   2 female        18
1150     4       3      9                   0 female        16
1151     2       1      6                   2   male        20
1152     1       4      6                   3   male        17
1153     2       5      7                   2   male        10
1154     2       3      6                   2 female        17
1155     2       2      6                   0 female        15
1156     2       4      6                   0 female         8
1157     4       4      9                   2 female        17
1158     4       4      6                   2 female         9
1159     4       3      4                   0 female        20
1160     2       5     11                   0 female        16
1161     2       2      4                   2   male        15
1162     2       4      1                   3   male         7
1163     4       4      2                   2 female         8
1164     4       1     11                   2   male         9
1165     2       4      6                   3 female        20
1166     4       3     11                   2 female         7
1167     4       4      2                   3   male        12
1168     1       3      4                   2 female        16
1169     2       4      4                   3   male        20
1170     2       4      5                   2 female        19
1171     1       4      3                   3 female         8
1172     1       4      4                   0   male         9
1173     4       2      6                   0   male        13
1174     2       2     11                   0 female        16
1175     2       2     11                   0   male         9
1176     4       4     10                   2 female         7
1177     4       2      8                   2 female         8
1178     2       2      7                   0 female        19
1179     4       4     10                   3   male         9
1180     2       4      9                   0 female         7
1181     2       3      6                   0 female        19
1182     2       3     11                   0   male        12
1183     3       3      9                   0 female        15
1184     2       3     11                   2 female         7
1185     2       1      6                   0 female        16
1186     4       3     10                   2 female        19
1187     1       2     11                   0 female        17
1188     4       2      7                   0 female         8
1189     2       4      1                   2   male        13
1190     4       4     11                   0   male         9
1191     4       4      7                   2   male         7
1192     2       4      4                   0 female        18
1193     2       4      2                   2 female        16
1194     4       3      9                   2 female        11
1195     4       5      9                   2   male        14
1196     2       2      6                   3   male         7
1197     2       1      3                   2 female        12
1198     2       4      5                   3 female        14
1199     4       3     11                   2 female         7
1200     2       2      4                   2   male        15
1201     2       4      1                   2   male        19
1202     3       3     11                   1 female        11
1203     4       3     11                   2 female        12
1204     1       4      3                   0 female        19
1205     4       2      9                   2   male        12
1206     2       4      1                   2   male        19
1207     4       2      9                   0 female        16
1208     2       3      4                   2 female        12
1209     2       4      6                   0 female        19
1210     2       4      6                   2 female        15
1211     2       4      2                   3 female        19
1212     2       1      4                   0   male        18
1213     2       5      3                   0   male        15
1214     2       2      7                   2   male        19
1215     2       4     11                   0 female        16
1216     2       4      7                   2 female         8
1217     4       4     11                   2   male        14
1218     2       4      5                   3   male        14
1219     4       4      9                   0   male        12
1220     2       2      2                   2   male        17
1221     2       4      6                   0 female         8
1222     4       1     11                   2   male        18
1223     5       3     11                   2   male        15
1224     4       4      9                   0   male        19
1225     4       4      1                   3 female         8
1226     2       4      3                   0 female         8
1227     2       2      8                   2 female        11
1228     2       5      5                   0 female        17
1229     2       2      8                   2   male        10
1230     2       2      5                   3   male        10
1231     1       4      1                   2 female        20
1232     2       4      5                   2   male        15
1233     1       1      3                   3   male        15
1234     2       2      4                   2 female        17
1235     4       5     11                   3   male         9
1236     4       4      1                   2 female        10
1237     2       4      6                   2 female        13
1238     2       2      1                   0 female         9
1239     2       2      3                   0 female        12
1240     4       1      8                   2 female        16
1241     2       2      5                   2 female        20
1242     4       4     10                   0 female         7
1243     2       4      5                   0 female        15
1244     1       5     11                   0   male        12
1245     2       1      2                   2 female        12
1246     2       5     10                   0 female        12
1247     4       4     11                   3 female        15
1248     2       4      3                   2 female         8
1249     5       2      7                   3 female        15
1250     3       4     11                   0 female        19
1251     1       1      3                   2 female         8
1252     2       4      6                   2 female        15
1253     2       4     11                   2   male        12
1254     2       3      3                   2 female        13
1255     4       1     11                   0   male        16
1256     2       4     11                   2 female        17
1257     2       4      4                   2 female        15
1258     4       1     11                   2   male         8
1259     2       4      1                   2   male        16
1260     5       2     11                   2 female        15
1261     2       2      1                   2 female        10
1262     4       4     11                   2   male        13
1263     4       4     11                   2 female        20
1264     4       3      3                   2 female        16
1265     2       2      3                   2   male        18
1266     2       3     11                   0   male        18
1267     4       4     11                   3 female        20
1268     4       2     10                   3   male         7
1269     2       4      3                   0 female        12
1270     2       2     10                   1 female        15
1271     5       2     11                   2   male        12
1272     4       5     11                   0   male         7
1273     2       2      3                   2 female        11
1274     4       4      9                   0 female        11
1275     4       2      6                   0   male        18
1276     2       4      3                   2 female        16
1277     1       4      4                   2 female         8
1278     4       3      8                   0 female        16
1279     1       4     10                   0   male        12
1280     2       2      5                   2   male        13
1281     2       2      4                   2 female        14
1282     2       4      3                   2   male        11
1283     4       1     11                   2 female        12
1284     2       4      4                   3   male        11
1285     2       4      9                   2   male        17
1286     2       4      5                   2   male        10
1287     4       3     11                   3   male        18
1288     2       4     11                   3   male        19
1289     4       2      5                   3   male        13
1290     1       2     11                   1 female        10
1291     4       2      8                   2   male        17
1292     4       3      2                   3   male        15
1293     2       2      1                   2   male        15
1294     2       2      7                   2 female        18
1295     2       4      4                   2   male        11
1296     4       3      4                   0 female        15
1297     2       4      6                   0   male        18
1298     4       2      7                   0   male         9
1299     2       3     11                   2 female         8
1300     2       5     11                   0 female        19
1301     4       4      4                   0 female        20
1302     2       5      6                   2 female        12
1303     2       4      3                   3   male        12
1304     1       4      4                   3   male         7
1305     4       4     10                   0   male        20
1306     1       4      1                   2   male        12
1307     4       2      3                   0   male         9
1308     2       2      5                   2 female        14
1309     2       4      3                   2   male        18
1310     1       2      6                   0 female         9
1311     2       2      5                   2 female        17
1312     2       4      6                   0 female        11
1313     4       2     10                   3   male         7
1314     4       3      6                   2   male        10
1315     4       4     11                   0 female         8
1316     4       4      5                   0   male        12
1317     4       4     11                   0 female        10
1318     4       2      9                   0   male        17
1319     1       5     11                   0 female        14
1320     5       2     11                   2 female        17
1321     2       4      9                   2 female        18
1322     4       4      9                   2   male         8
1323     2       4     11                   0 female         8
1324     4       5     11                   0   male         9
1325     2       2      8                   0   male        12
1326     4       2     11                   0   male        18
1327     2       2      1                   2   male         7
1328     2       2     11                   2 female        12
1329     4       2      7                   0 female        10
1330     4       3      8                   0   male        11
1331     5       2      9                   3   male        15
1332     4       5      9                   0   male         7
1333     4       4      7                   2   male        11
1334     2       2     11                   0 female        20
1335     4       2      7                   2   male        17
1336     2       4     10                   1 female        11
1337     2       4      1                   2   male        10
1338     2       4      1                   3 female         8
1339     2       4      3                   3   male        15
1340     1       3      6                   0 female        20
1341     2       3     11                   0 female        19
1342     2       4      6                   2   male        17
1343     4       3      6                   2 female        12
1344     4       4      2                   2   male        13
1345     4       1      6                   2 female        16
1346     4       5     11                   2 female         7
1347     2       4      4                   0 female        18
1348     5       4      8                   3   male        14
1349     2       4      1                   1   male        20
1350     4       3      7                   2 female         7
1351     2       4      6                   3   male        10
1352     2       4      6                   2 female        20
1353     5       2      8                   0 female        12
1354     2       2      3                   3 female        19
1355     4       4      9                   2 female        14
1356     1       2      6                   3   male        13
1357     1       4      5                   2 female         9
1358     1       4      3                   2 female        18
1359     4       1     11                   2 female        14
1360     4       4      4                   0 female        12
1361     2       4      3                   3   male        14
1362     4       2     11                   0   male         7
1363     4       2      6                   0 female         8
1364     4       3      2                   2 female         8
1365     4       4      8                   2   male        15
1366     5       3     11                   2 female         8
1367     4       2      7                   0 female        11
1368     2       2     11                   2   male        17
1369     4       4      9                   2   male        19
1370     4       4      9                   3   male        11
1371     4       2      6                   2 female        17
1372     4       1      1                   2   male        13
1373     2       4      2                   2   male         8
1374     2       3     11                   0 female        12
1375     2       4      6                   3   male        18
1376     1       3     11                   0 female        18
1377     4       2     10                   2   male        11
1378     2       2      6                   2   male        10
1379     2       3     11                   2 female        10
1380     4       2     11                   2   male        13
1381     2       3      6                   0 female         8
1382     4       4      6                   0   male        12
1383     2       4      1                   2   male        20
1384     2       3      4                   0 female         8
1385     2       3     10                   0   male        12
1386     4       4     11                   0   male        16
1387     2       4      9                   2 female        14
1388     1       4      4                   0 female        18
1389     2       4     11                   0 female        10
1390     2       4      6                   0 female        10
1391     2       4     10                   3   male        19
1392     4       1     11                   2 female        10
1393     2       4      5                   3   male         7
1394     5       2     11                   2   male         7
1395     4       2     11                   0 female        17
1396     1       4      6                   3   male        14
1397     2       4      3                   2   male         7
1398     4       4      4                   0   male        20
1399     2       2     11                   3 female        15
1400     5       4      9                   3   male        13
1401     4       3     10                   2 female        17
1402     2       2      3                   3 female        20
1403     5       1     10                   3   male        12
1404     4       1      2                   2 female        10
1405     4       4      5                   3   male        15
1406     1       4      6                   3   male         7
1407     2       4      1                   2   male         8
1408     2       3     11                   0 female        16
1409     4       4      5                   2 female        13
1410     2       3     11                   0   male        10
1411     1       4     11                   2   male        12
1412     1       4     11                   0 female        10
1413     1       3      6                   0   male         7
1414     2       4      9                   0 female        11
1415     2       2      3                   2 female        20
1416     4       2      6                   2   male         9
1417     4       4      6                   2   male        11
1418     2       4      1                   2 female         9
1419     4       4      6                   0 female         7
1420     2       2      2                   2 female        18
1421     2       5      1                   2 female        17
1422     4       3      2                   0   male        10
1423     1       4      8                   2 female         8
1424     1       4      1                   2   male        18
1425     1       2      4                   3   male         7
1426     1       4      7                   0   male         9
1427     2       2      9                   0 female        14
1428     1       4      1                   2 female        10
1429     4       4      5                   2   male         7
1430     2       3     10                   0   male        10
1431     2       3      3                   0 female        20
1432     4       4      3                   2 female        15
1433     2       5      3                   0   male        10
1434     1       4      8                   1   male        20
1435     4       2     11                   0   male         8
1436     2       4      8                   2   male         9
1437     1       3      1                   0   male        18
1438     2       2      7                   2   male         9
1439     2       2      2                   2   male        16
1440     1       3     10                   2   male        11
1441     2       4      8                   2 female         9
1442     2       3      6                   2   male        15
1443     4       4     10                   2 female         8
1444     2       4      6                   2 female        10
1445     2       4     11                   0 female        17
1446     2       2     11                   0   male        17
1447     2       4      4                   2 female        16
1448     5       2     11                   2   male         9
1449     4       3      3                   0 female        19
1450     2       4      5                   0 female         7
1451     2       3      5                   0 female        10
1452     2       2      1                   3   male        19
1453     4       4     11                   2   male        11
1454     2       4     11                   2 female        17
1455     5       4      9                   2   male         8
1456     3       3     11                   1   male        20
1457     1       4      4                   2   male        12
1458     1       4     11                   0 female        19
1459     1       4      1                   2 female        13
1460     2       3      1                   0 female        17
1461     4       2      8                   1   male        13
1462     1       2      6                   3   male        11
1463     1       3     11                   0 female         9
1464     4       4      3                   2   male         8
1465     2       2      7                   2   male         9
1466     2       2     11                   0   male        14
1467     2       4     11                   0 female        14
1468     2       2      6                   2 female        18
1469     2       4      6                   2   male        19
1470     5       2     11                   2   male        17
1471     1       4      1                   2   male        11
1472     1       4      2                   2   male        12
1473     1       3      3                   3   male        10
1474     1       2      5                   0 female        18
1475     4       4      8                   0   male        20
1476     2       4      4                   2   male        13
1477     2       1      7                   2   male        12
1478     1       4      3                   2   male        18
1479     2       4      4                   2 female         7
1480     1       3      3                   3   male        17
1481     4       2      7                   2 female        15
1482     4       4      9                   2 female        15
1483     4       2      5                   2 female        11
1484     5       2      9                   2 female        19
1485     4       4      3                   3   male        13
1486     4       4     11                   0 female         7
1487     4       4      1                   2   male        15
1488     2       4      3                   3   male        11
1489     4       4      2                   2   male         7
1490     4       1     10                   0 female        16
1491     4       4      1                   1 female        18
1492     1       3     11                   0   male        17
1493     4       4      6                   2 female        11
1494     2       3      6                   2 female        15
1495     2       1      6                   2 female         7
1496     4       4      9                   2   male        18
1497     4       4      5                   2 female        20
1498     2       2      6                   2 female         7
1499     2       3      1                   3 female        15
1500     4       4     11                   0 female        14
1501     2       3      4                   0 female        18
1502     2       5      9                   3 female        19
1503     4       5      5                   3 female        19
1504     2       4      6                   2 female        13
1505     1       2      3                   3   male        20
1506     4       4      6                   2   male        11
1507     1       1      6                   2   male        15
1508     4       4      8                   2 female        13
1509     2       4     11                   2   male        20
1510     2       3      4                   2 female         7
1511     2       1     11                   0   male        15
1512     2       2      8                   2 female        10
1513     4       4      7                   1   male         9
1514     2       2      4                   2   male        12
1515     2       4     11                   0 female         8
1516     1       4     11                   2 female        18
1517     2       2      4                   2   male        20
1518     2       3     11                   2   male         9
1519     2       3      5                   2   male        19
1520     2       4      8                   2   male         9
1521     4       4     11                   3   male         9
1522     4       4      8                   2   male        11
1523     4       4      2                   2   male         9
1524     4       1     11                   2   male         8
1525     4       4     11                   0 female        12

5 group & summarise

Code
BEPS |> 
  group_by(vote) |> 
  summarise(Votes = n(),
          Average_age = mean(age))
# A tibble: 3 × 3
  vote             Votes Average_age
  <fct>            <int>       <dbl>
1 Conservative       462        56.9
2 Labour             720        53.0
3 Liberal Democrat   343        53.0
Code
BEPS |>
  group_by(vote, gender) |>
  summarise(Votes = n(),
            Average_age = mean(age))
# A tibble: 6 × 4
# Groups:   vote [3]
  vote             gender Votes Average_age
  <fct>            <fct>  <int>       <dbl>
1 Conservative     female   259        58.3
2 Conservative     male     203        55.1
3 Labour           female   372        52.5
4 Labour           male     348        53.5
5 Liberal Democrat female   181        53.0
6 Liberal Democrat male     162        53.1

5.1 slice

Code
BEPS |> 
  group_by(vote) |> 
  slice_max(age, n = 3)|> 
  head()
# A tibble: 6 × 10
# Groups:   vote [2]
  vote     age economic.cond.national economic.cond.househ…¹ Blair Hague Kennedy
  <fct>  <int>                  <int>                  <int> <int> <int>   <int>
1 Conse…    93                      4                      4     5     5       2
2 Conse…    92                      3                      3     4     4       3
3 Conse…    92                      3                      3     2     4       2
4 Labour    91                      4                      3     4     4       3
5 Labour    89                      4                      3     4     4       3
6 Labour    89                      5                      5     5     2       1
# ℹ abbreviated name: ¹​economic.cond.household
# ℹ 3 more variables: Europe <int>, political.knowledge <int>, gender <fct>

. . .

Code
BEPS |> 
  group_by(vote) |> 
  slice_min(age, n = 3, with_ties = TRUE)|> 
  head()
# A tibble: 6 × 10
# Groups:   vote [2]
  vote     age economic.cond.national economic.cond.househ…¹ Blair Hague Kennedy
  <fct>  <int>                  <int>                  <int> <int> <int>   <int>
1 Conse…    24                      3                      2     4     2       2
2 Conse…    24                      3                      4     2     4       2
3 Conse…    24                      4                      4     2     1       3
4 Conse…    24                      4                      5     4     4       2
5 Labour    24                      4                      2     2     1       3
6 Labour    24                      3                      5     4     1       2
# ℹ abbreviated name: ¹​economic.cond.household
# ℹ 3 more variables: Europe <int>, political.knowledge <int>, gender <fct>

. . .

Code
BEPS |> 
  slice_sample(n = 100)|> 
  head()
                 vote age economic.cond.national economic.cond.household Blair
1119     Conservative  29                      2                       4     4
981            Labour  56                      2                       2     4
744  Liberal Democrat  45                      2                       2     4
259            Labour  27                      3                       3     4
83       Conservative  78                      3                       3     4
514      Conservative  80                      2                       2     2
     Hague Kennedy Europe political.knowledge gender
1119     4       2      9                   2 female
981      1       3      6                   2   male
744      2       4      6                   2   male
259      4       4      7                   0 female
83       4       4     11                   0 female
514      4       3      7                   2   male

. . .

Code
BEPS |> 
  slice_sample(prop = 0.33)|> 
  head()
                 vote age economic.cond.national economic.cond.household Blair
592            Labour  52                      4                       4     4
548  Liberal Democrat  46                      2                       2     2
1241 Liberal Democrat  60                      5                       3     2
561  Liberal Democrat  42                      4                       4     4
861      Conservative  43                      3                       4     2
329  Liberal Democrat  43                      3                       3     4
     Hague Kennedy Europe political.knowledge gender
592      2       4      4                   2   male
548      4       3      8                   0 female
1241     2       2      5                   2 female
561      2       4     11                   0   male
861      4       1     11                   2   male
329      1       4      7                   2 female

6 Homework

6.1 Task 1: filter rows in dataset BEPS

  1. age <= 27

  2. 35 <= age <= 55

  3. age == 54 and vote is Labour and gender is female

  4. meet either condition: age = 54; vote is Conservative or gender is male

  5. political.knowledge is not zero.

  6. Sort Europe from high to low

. . .

6.2 Task 2: select columns

  1. select vote, age and gender and name them as Party, Age, and Sex, then filter those age >= 35 and gender is female

  2. select vote, Europe and political.knowledge, then sort political.knowledge from high to low and vote by alphabetic order.

  3. select all variables but Blair, Hague, Kennedy

. . .

6.3 Task 3: mutate new variables

  1. Create a new variable which is the sum of Blair, Hague, Kennedy, name it “BHK”, and put it in front of Blair.

  2. Create a new variable named “retired”, with 1 over age 65, 0 others, then put it after variable age.

6.4 Task 4: group and summarise

  1. group gender, then count the number of male and female, and calculate average age and average political.knowledge

  2. group vote and gender, then count the number, and find out the maximum age and minimum age.


Thank you!