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

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
534  Liberal Democrat  71                      3                       3     4
1368           Labour  69                      3                       3     4
674            Labour  79                      5                       4     4
647      Conservative  37                      2                       4     2
951  Liberal Democrat  49                      3                       3     2
1281           Labour  42                      3                       1     4
     Hague Kennedy Europe political.knowledge gender
534      2       4     11                   0 female
1368     2       2     11                   2   male
674      2       4      6                   2   male
647      5       2      9                   2 female
951      1       4      9                   2 female
1281     2       2      4                   2 female

. . .

Code
BEPS |> 
  slice_sample(prop = 0.33)|> 
  head()
                 vote age economic.cond.national economic.cond.household Blair
1407           Labour  59                      3                       2     1
715            Labour  37                      3                       2     4
1440           Labour  87                      4                       4     4
945  Liberal Democrat  41                      3                       3     2
183      Conservative  76                      4                       3     1
527  Liberal Democrat  66                      4                       4     4
     Hague Kennedy Europe political.knowledge gender
1407     2       4      1                   2   male
715      4       5      5                   2 female
1440     1       3     10                   2   male
945      4       3     11                   0   male
183      4       2     11                   3   male
527      2       4      3                   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!