data <- read_excel("../01_module4/data/myData.xlsx")
data## # A tibble: 1,104 × 31
## town11cd town11nm population_2011 size_flag rgn11nm coastal coastal_detailed
## <chr> <chr> <dbl> <chr> <chr> <chr> <chr>
## 1 E34000007 Carlton… 5456 Small To… East M… Non-co… Smaller non-coa…
## 2 E34000016 Dorches… 19060 Small To… South … Non-co… Smaller non-coa…
## 3 E34000020 Ely BUA 19090 Small To… East o… Non-co… Smaller non-coa…
## 4 E34000026 Market … 6429 Small To… Yorksh… Non-co… Smaller non-coa…
## 5 E34000027 Downham… 10884 Small To… East o… Non-co… Smaller non-coa…
## 6 E34000039 Penrith… 15181 Small To… North … Non-co… Smaller non-coa…
## 7 E34000048 Bolsove… 11754 Small To… East M… Non-co… Smaller non-coa…
## 8 E34000055 March B… 21051 Medium T… East o… Non-co… Large non-coast…
## 9 E34000056 Southam… 6567 Small To… West M… Non-co… Smaller non-coa…
## 10 E34000067 Royston… 15781 Small To… East o… Non-co… Smaller non-coa…
## # ℹ 1,094 more rows
## # ℹ 24 more variables: ttwa11cd <chr>, ttwa11nm <chr>,
## # ttwa_classification <chr>, job_density_flag <chr>, income_flag <chr>,
## # university_flag <chr>, level4qual_residents35_64_2011 <chr>,
## # ks4_2012_2013_counts <dbl>,
## # key_stage_2_attainment_school_year_2007_to_2008 <dbl>,
## # key_stage_4_attainment_school_year_2012_to_2013 <dbl>, …data$size_flag## [1] "Small Towns" "Small Towns" "Small Towns"
## [4] "Small Towns" "Small Towns" "Small Towns"
## [7] "Small Towns" "Medium Towns" "Small Towns"
## [10] "Small Towns" "Small Towns" "Small Towns"
## [13] "Small Towns" "Small Towns" "Small Towns"
## [16] "Small Towns" "Small Towns" "Small Towns"
## [19] "Medium Towns" "Small Towns" "Small Towns"
## [22] "Small Towns" "Small Towns" "Medium Towns"
## [25] "Small Towns" "Small Towns" "Small Towns"
## [28] "Small Towns" "Small Towns" "Small Towns"
## [31] "Small Towns" "Small Towns" "Small Towns"
## [34] "Medium Towns" "Medium Towns" "Small Towns"
## [37] "Small Towns" "Small Towns" "Small Towns"
## [40] "Small Towns" "Medium Towns" "Small Towns"
## [43] "Small Towns" "Small Towns" "Small Towns"
## [46] "Small Towns" "Small Towns" "Medium Towns"
## [49] "Small Towns" "Medium Towns" "Medium Towns"
## [52] "Small Towns" "Small Towns" "Small Towns"
## [55] "Small Towns" "Medium Towns" "Small Towns"
## [58] "Small Towns" "Medium Towns" "Small Towns"
## [61] "Medium Towns" "Small Towns" "Small Towns"
## [64] "Medium Towns" "Medium Towns" "Large Towns"
## [67] "Small Towns" "Small Towns" "Small Towns"
## [70] "Medium Towns" "Small Towns" "Small Towns"
## [73] "Small Towns" "Small Towns" "Small Towns"
## [76] "Small Towns" "Small Towns" "Small Towns"
## [79] "Small Towns" "Small Towns" "Small Towns"
## [82] "Small Towns" "Small Towns" "Small Towns"
## [85] "Small Towns" "Small Towns" "Small Towns"
## [88] "Small Towns" "Small Towns" "Small Towns"
## [91] "Small Towns" "Small Towns" "Small Towns"
## [94] "Small Towns" "Small Towns" "Small Towns"
## [97] "Small Towns" "Small Towns" "Small Towns"
## [100] "Small Towns" "Small Towns" "Small Towns"
## [103] "Small Towns" "Small Towns" "Medium Towns"
## [106] "Small Towns" "Small Towns" "Small Towns"
## [109] "Small Towns" "Small Towns" "Medium Towns"
## [112] "Small Towns" "Small Towns" "Small Towns"
## [115] "Small Towns" "Small Towns" "Small Towns"
## [118] "Small Towns" "Small Towns" "Small Towns"
## [121] "Small Towns" "Small Towns" "Small Towns"
## [124] "Small Towns" "Small Towns" "Medium Towns"
## [127] "Small Towns" "Small Towns" "Small Towns"
## [130] "Small Towns" "Small Towns" "Small Towns"
## [133] "Small Towns" "Small Towns" "Small Towns"
## [136] "Small Towns" "Medium Towns" "Medium Towns"
## [139] "Small Towns" "Medium Towns" "Small Towns"
## [142] "Small Towns" "Medium Towns" "Small Towns"
## [145] "Small Towns" "Small Towns" "Small Towns"
## [148] "Small Towns" "Small Towns" "Small Towns"
## [151] "Small Towns" "Small Towns" "Small Towns"
## [154] "Medium Towns" "Medium Towns" "Small Towns"
## [157] "Small Towns" "Small Towns" "Small Towns"
## [160] "Small Towns" "Small Towns" "Small Towns"
## [163] "Small Towns" "Small Towns" "Small Towns"
## [166] "Small Towns" "Medium Towns" "Medium Towns"
## [169] "Small Towns" "Small Towns" "Small Towns"
## [172] "Small Towns" "Medium Towns" "Medium Towns"
## [175] "Small Towns" "Medium Towns" "Medium Towns"
## [178] "Small Towns" "Small Towns" "Small Towns"
## [181] "Large Towns" "Small Towns" "Small Towns"
## [184] "Small Towns" "Small Towns" "Small Towns"
## [187] "Medium Towns" "Small Towns" "Small Towns"
## [190] "Small Towns" "Small Towns" "Small Towns"
## [193] "Small Towns" "Medium Towns" "Small Towns"
## [196] "Small Towns" "Small Towns" "Small Towns"
## [199] "Small Towns" "Small Towns" "Medium Towns"
## [202] "Small Towns" "Small Towns" "Small Towns"
## [205] "Small Towns" "Small Towns" "Small Towns"
## [208] "Small Towns" "Small Towns" "Medium Towns"
## [211] "Small Towns" "Small Towns" "Small Towns"
## [214] "Small Towns" "Small Towns" "Small Towns"
## [217] "Small Towns" "Small Towns" "Small Towns"
## [220] "Medium Towns" "Small Towns" "Small Towns"
## [223] "Small Towns" "Small Towns" "Small Towns"
## [226] "Small Towns" "Medium Towns" "Small Towns"
## [229] "Small Towns" "Small Towns" "Small Towns"
## [232] "Medium Towns" "Medium Towns" "Small Towns"
## [235] "Small Towns" "Small Towns" "Small Towns"
## [238] "Small Towns" "Small Towns" "Small Towns"
## [241] "Small Towns" "Small Towns" "Small Towns"
## [244] "Small Towns" "Small Towns" "Small Towns"
## [247] "Small Towns" "Small Towns" "Small Towns"
## [250] "Medium Towns" "Small Towns" "Small Towns"
## [253] "Small Towns" "Small Towns" "Small Towns"
## [256] "Small Towns" "Small Towns" "Small Towns"
## [259] "Small Towns" "Small Towns" "Small Towns"
## [262] "Small Towns" "Small Towns" "Small Towns"
## [265] "Small Towns" "Small Towns" "Small Towns"
## [268] "Small Towns" "Small Towns" "Small Towns"
## [271] "Small Towns" "Small Towns" "Small Towns"
## [274] "Small Towns" "Small Towns" "Small Towns"
## [277] "Small Towns" "Small Towns" "Small Towns"
## [280] "Small Towns" "Medium Towns" "Small Towns"
## [283] "Small Towns" "Small Towns" "Small Towns"
## [286] "Small Towns" "Small Towns" "Small Towns"
## [289] "Small Towns" "Small Towns" "Medium Towns"
## [292] "Small Towns" "Small Towns" "Small Towns"
## [295] "Small Towns" "Medium Towns" "Small Towns"
## [298] "Small Towns" "Medium Towns" "Small Towns"
## [301] "Small Towns" "Small Towns" "Small Towns"
## [304] "Small Towns" "Small Towns" "Small Towns"
## [307] "Small Towns" "Small Towns" "Small Towns"
## [310] "Small Towns" "Small Towns" "Small Towns"
## [313] "Medium Towns" "Small Towns" "Small Towns"
## [316] "Large Towns" "Medium Towns" "Small Towns"
## [319] "Small Towns" "Small Towns" "Small Towns"
## [322] "Small Towns" "Small Towns" "Medium Towns"
## [325] "Small Towns" "Small Towns" "Small Towns"
## [328] "Small Towns" "Small Towns" "Small Towns"
## [331] "Small Towns" "Small Towns" "Small Towns"
## [334] "Small Towns" "Medium Towns" "Small Towns"
## [337] "Medium Towns" "Small Towns" "Small Towns"
## [340] "Small Towns" "Small Towns" "Small Towns"
## [343] "Small Towns" "Small Towns" "Medium Towns"
## [346] "Medium Towns" "Small Towns" "Small Towns"
## [349] "Medium Towns" "Small Towns" "Small Towns"
## [352] "Small Towns" "Medium Towns" "Small Towns"
## [355] "Small Towns" "Small Towns" "Small Towns"
## [358] "Small Towns" "Small Towns" "Medium Towns"
## [361] "Small Towns" "Small Towns" "Medium Towns"
## [364] "Small Towns" "Large Towns" "Medium Towns"
## [367] "Small Towns" "Small Towns" "Small Towns"
## [370] "Medium Towns" "Small Towns" "Medium Towns"
## [373] "Medium Towns" "Medium Towns" "Small Towns"
## [376] "Small Towns" "Small Towns" "Small Towns"
## [379] "Small Towns" "Small Towns" "Small Towns"
## [382] "Medium Towns" "Large Towns" "Small Towns"
## [385] "Medium Towns" "Medium Towns" "Small Towns"
## [388] "Small Towns" "Small Towns" "Small Towns"
## [391] "Medium Towns" "Small Towns" "Small Towns"
## [394] "Medium Towns" "Small Towns" "Medium Towns"
## [397] "Medium Towns" "Medium Towns" "Small Towns"
## [400] "Medium Towns" "Medium Towns" "Small Towns"
## [403] "Small Towns" "Medium Towns" "Small Towns"
## [406] "Small Towns" "Medium Towns" "Medium Towns"
## [409] "Small Towns" "Small Towns" "Small Towns"
## [412] "Small Towns" "Medium Towns" "Small Towns"
## [415] "Medium Towns" "Small Towns" "Small Towns"
## [418] "Small Towns" "Medium Towns" "Medium Towns"
## [421] "Medium Towns" "Medium Towns" "Medium Towns"
## [424] "Medium Towns" "Medium Towns" "Large Towns"
## [427] "Large Towns" "Medium Towns" "Small Towns"
## [430] "Small Towns" "Small Towns" "Small Towns"
## [433] "Small Towns" "Small Towns" "Small Towns"
## [436] "Small Towns" "Small Towns" "Small Towns"
## [439] "Small Towns" "Medium Towns" "Small Towns"
## [442] "Small Towns" "Small Towns" "Small Towns"
## [445] "Small Towns" "Medium Towns" "Small Towns"
## [448] "Medium Towns" "Medium Towns" "Medium Towns"
## [451] "Medium Towns" "Large Towns" "Large Towns"
## [454] "Small Towns" "Medium Towns" "Small Towns"
## [457] "Small Towns" "Medium Towns" "Small Towns"
## [460] "Small Towns" "Medium Towns" "Small Towns"
## [463] "Small Towns" "Medium Towns" "Small Towns"
## [466] "Large Towns" "Medium Towns" "Small Towns"
## [469] "Small Towns" "Small Towns" "Small Towns"
## [472] "Medium Towns" "Small Towns" "Small Towns"
## [475] "Small Towns" "Medium Towns" "Small Towns"
## [478] "Small Towns" "Small Towns" "Small Towns"
## [481] "Small Towns" "Small Towns" "Small Towns"
## [484] "Medium Towns" "Small Towns" "Medium Towns"
## [487] "Medium Towns" "Small Towns" "Medium Towns"
## [490] "Large Towns" "Small Towns" "Small Towns"
## [493] "Small Towns" "Small Towns" "Small Towns"
## [496] "Small Towns" "Small Towns" "Large Towns"
## [499] "Small Towns" "Medium Towns" "Medium Towns"
## [502] "Small Towns" "Medium Towns" "Medium Towns"
## [505] "Large Towns" "Small Towns" "Medium Towns"
## [508] "Small Towns" "Medium Towns" "Small Towns"
## [511] "Medium Towns" "Large Towns" "Small Towns"
## [514] "Small Towns" "Medium Towns" "Medium Towns"
## [517] "Small Towns" "Small Towns" "Small Towns"
## [520] "Medium Towns" "Small Towns" "Small Towns"
## [523] "Small Towns" "Medium Towns" "Small Towns"
## [526] "Medium Towns" "Small Towns" "Medium Towns"
## [529] "Small Towns" "Medium Towns" "Medium Towns"
## [532] "Small Towns" "Medium Towns" "City"
## [535] "Small Towns" "Medium Towns" "Small Towns"
## [538] "Medium Towns" "Medium Towns" "Medium Towns"
## [541] "Medium Towns" "Small Towns" "Large Towns"
## [544] "Small Towns" "Small Towns" "Small Towns"
## [547] "Small Towns" "Medium Towns" "Small Towns"
## [550] "Small Towns" "Large Towns" "Large Towns"
## [553] "Small Towns" "Medium Towns" "Small Towns"
## [556] "Medium Towns" "Medium Towns" "Small Towns"
## [559] "Small Towns" "Small Towns" "Small Towns"
## [562] "Small Towns" "Medium Towns" "Small Towns"
## [565] "Small Towns" "Small Towns" "Medium Towns"
## [568] "Medium Towns" "Small Towns" "Small Towns"
## [571] "Small Towns" "Medium Towns" "Medium Towns"
## [574] "Small Towns" "Small Towns" "Medium Towns"
## [577] "Small Towns" "Large Towns" "Medium Towns"
## [580] "Medium Towns" "Small Towns" "Small Towns"
## [583] "Medium Towns" "Large Towns" "Small Towns"
## [586] "Small Towns" "Small Towns" "Large Towns"
## [589] "Small Towns" "Small Towns" "Medium Towns"
## [592] "Medium Towns" "Medium Towns" "Medium Towns"
## [595] "Small Towns" "Medium Towns" "Small Towns"
## [598] "Small Towns" "Small Towns" "Small Towns"
## [601] "Large Towns" "Medium Towns" "Large Towns"
## [604] "Medium Towns" "Medium Towns" "Small Towns"
## [607] "Medium Towns" "Small Towns" "Medium Towns"
## [610] "Small Towns" "Medium Towns" "Small Towns"
## [613] "Medium Towns" "Large Towns" "Small Towns"
## [616] "City" "Small Towns" "Small Towns"
## [619] "Small Towns" "Large Towns" "Small Towns"
## [622] "Medium Towns" "Medium Towns" "Small Towns"
## [625] "Medium Towns" "Small Towns" "Medium Towns"
## [628] "Small Towns" "Small Towns" "Medium Towns"
## [631] "Small Towns" "Medium Towns" "Small Towns"
## [634] "Small Towns" "Small Towns" "Small Towns"
## [637] "Small Towns" "Small Towns" "Medium Towns"
## [640] "Small Towns" "Small Towns" "Small Towns"
## [643] "Medium Towns" "Small Towns" "Medium Towns"
## [646] "Medium Towns" "Medium Towns" "Small Towns"
## [649] "Small Towns" "Medium Towns" "Small Towns"
## [652] "Medium Towns" "Medium Towns" "Medium Towns"
## [655] "Small Towns" "Small Towns" "Small Towns"
## [658] "Medium Towns" "Medium Towns" "Small Towns"
## [661] "Medium Towns" "Small Towns" "Small Towns"
## [664] "Medium Towns" "Small Towns" "Medium Towns"
## [667] "Medium Towns" "Small Towns" "Small Towns"
## [670] "Large Towns" "Medium Towns" "Small Towns"
## [673] "Medium Towns" "Medium Towns" "Small Towns"
## [676] "Medium Towns" "Small Towns" "Small Towns"
## [679] "Medium Towns" "Small Towns" "Medium Towns"
## [682] "Small Towns" "Small Towns" "Small Towns"
## [685] "Small Towns" "Large Towns" "Small Towns"
## [688] "Medium Towns" "Medium Towns" "Small Towns"
## [691] "Small Towns" "Medium Towns" "Small Towns"
## [694] "Small Towns" "Medium Towns" "Small Towns"
## [697] "Small Towns" "Medium Towns" "Medium Towns"
## [700] "Small Towns" "Small Towns" "Medium Towns"
## [703] "Medium Towns" "Small Towns" "Medium Towns"
## [706] "Medium Towns" "Small Towns" "Small Towns"
## [709] "Large Towns" "Small Towns" "Small Towns"
## [712] "Small Towns" "Medium Towns" "Medium Towns"
## [715] "Medium Towns" "Medium Towns" "Medium Towns"
## [718] "Small Towns" "Small Towns" "Medium Towns"
## [721] "Medium Towns" "Small Towns" "Small Towns"
## [724] "Small Towns" "Large Towns" "Small Towns"
## [727] "Small Towns" "Medium Towns" "Small Towns"
## [730] "Small Towns" "Medium Towns" "Small Towns"
## [733] "Small Towns" "Medium Towns" "Medium Towns"
## [736] "Large Towns" "Medium Towns" "Medium Towns"
## [739] "Medium Towns" "Small Towns" "Small Towns"
## [742] "Small Towns" "Medium Towns" "Small Towns"
## [745] "Small Towns" "Small Towns" "Small Towns"
## [748] "Medium Towns" "Small Towns" "Small Towns"
## [751] "Small Towns" "Medium Towns" "Small Towns"
## [754] "Small Towns" "Medium Towns" "Medium Towns"
## [757] "Medium Towns" "Medium Towns" "Small Towns"
## [760] "Medium Towns" "Small Towns" "Small Towns"
## [763] "Medium Towns" "Small Towns" "Small Towns"
## [766] "Small Towns" "City" "Medium Towns"
## [769] "Medium Towns" "Medium Towns" "Small Towns"
## [772] "Medium Towns" "Medium Towns" "Small Towns"
## [775] "Small Towns" "Large Towns" "Small Towns"
## [778] "Large Towns" "Medium Towns" "Small Towns"
## [781] "Small Towns" "Small Towns" "Medium Towns"
## [784] "Medium Towns" "Small Towns" "Medium Towns"
## [787] "Small Towns" "Small Towns" "Medium Towns"
## [790] "Small Towns" "Small Towns" "Medium Towns"
## [793] "Small Towns" "Small Towns" "Small Towns"
## [796] "Small Towns" "Medium Towns" "Medium Towns"
## [799] "Medium Towns" "Small Towns" "Medium Towns"
## [802] "Medium Towns" "Small Towns" "Medium Towns"
## [805] "Medium Towns" "Small Towns" "Small Towns"
## [808] "Medium Towns" "Medium Towns" "Small Towns"
## [811] "Small Towns" "Small Towns" "Small Towns"
## [814] "Small Towns" "Small Towns" "Small Towns"
## [817] "Small Towns" "Medium Towns" "Small Towns"
## [820] "Small Towns" "Medium Towns" "Medium Towns"
## [823] "Medium Towns" "Small Towns" "Small Towns"
## [826] "Small Towns" "Small Towns" "Small Towns"
## [829] "Small Towns" "Small Towns" "Medium Towns"
## [832] "Small Towns" "Small Towns" "Small Towns"
## [835] "Small Towns" "Small Towns" "Small Towns"
## [838] "Small Towns" "Small Towns" "Small Towns"
## [841] "Small Towns" "Small Towns" "Large Towns"
## [844] "Small Towns" "Medium Towns" "Small Towns"
## [847] "Medium Towns" "Small Towns" "Small Towns"
## [850] "Small Towns" "Small Towns" "Large Towns"
## [853] "Small Towns" "Large Towns" "Medium Towns"
## [856] "Medium Towns" "Large Towns" "City"
## [859] "Medium Towns" "Small Towns" "Small Towns"
## [862] "Small Towns" "Small Towns" "City"
## [865] "Medium Towns" "Small Towns" "Large Towns"
## [868] "Large Towns" "Small Towns" "Small Towns"
## [871] "Small Towns" "Medium Towns" "Medium Towns"
## [874] "Medium Towns" "Medium Towns" "Medium Towns"
## [877] "Large Towns" "Small Towns" "Medium Towns"
## [880] "Large Towns" "Large Towns" "Large Towns"
## [883] "Medium Towns" "Medium Towns" "Medium Towns"
## [886] "Small Towns" "Large Towns" "City"
## [889] "Medium Towns" "Medium Towns" "Small Towns"
## [892] "Medium Towns" "Medium Towns" "Medium Towns"
## [895] "Large Towns" "Small Towns" "Medium Towns"
## [898] "Large Towns" "Small Towns" "Medium Towns"
## [901] "Medium Towns" "Small Towns" "Medium Towns"
## [904] "Small Towns" "Large Towns" "Medium Towns"
## [907] "Small Towns" "Small Towns" "Medium Towns"
## [910] "City" "Medium Towns" "Medium Towns"
## [913] "Small Towns" "Medium Towns" "Large Towns"
## [916] "Small Towns" "Small Towns" "Medium Towns"
## [919] "Medium Towns" "Medium Towns" "Large Towns"
## [922] "Large Towns" "Small Towns" "City"
## [925] "Medium Towns" "Large Towns" "Medium Towns"
## [928] "Large Towns" "City" "Medium Towns"
## [931] "Medium Towns" "Medium Towns" "Small Towns"
## [934] "Large Towns" "Large Towns" "Medium Towns"
## [937] "Small Towns" "Medium Towns" "Large Towns"
## [940] "Large Towns" "Small Towns" "Small Towns"
## [943] "Large Towns" "Medium Towns" "Small Towns"
## [946] "Large Towns" "Small Towns" "Small Towns"
## [949] "Medium Towns" "Small Towns" "Small Towns"
## [952] "Small Towns" "Large Towns" "Medium Towns"
## [955] "Medium Towns" "Small Towns" "Small Towns"
## [958] "Medium Towns" "Medium Towns" "Large Towns"
## [961] "Medium Towns" "Medium Towns" "City"
## [964] "Large Towns" "Medium Towns" "Medium Towns"
## [967] "City" "Medium Towns" "Large Towns"
## [970] "Small Towns" "Large Towns" "Medium Towns"
## [973] "Medium Towns" "Medium Towns" "Medium Towns"
## [976] "Small Towns" "Large Towns" "Medium Towns"
## [979] "City" "Large Towns" "City"
## [982] "Medium Towns" "Medium Towns" "Small Towns"
## [985] "Small Towns" "Medium Towns" "Medium Towns"
## [988] "Large Towns" "Medium Towns" "Medium Towns"
## [991] "Small Towns" "Medium Towns" "Large Towns"
## [994] "Medium Towns" "Medium Towns" "Large Towns"
## [997] "City" "Small Towns" "Small Towns"
## [1000] "Medium Towns" "Medium Towns" "Medium Towns"
## [1003] "Medium Towns" "Medium Towns" "Small Towns"
## [1006] "Medium Towns" "Small Towns" "Small Towns"
## [1009] "Small Towns" "City" "Large Towns"
## [1012] "Large Towns" "Small Towns" "Small Towns"
## [1015] "Large Towns" "Small Towns" "Medium Towns"
## [1018] "Small Towns" "Large Towns" "Large Towns"
## [1021] "Medium Towns" "Small Towns" "Medium Towns"
## [1024] "Medium Towns" "City" "City"
## [1027] "Small Towns" "Medium Towns" "Large Towns"
## [1030] "Small Towns" "Large Towns" "Small Towns"
## [1033] "Medium Towns" "Medium Towns" "Medium Towns"
## [1036] "Small Towns" "Large Towns" "Small Towns"
## [1039] "Medium Towns" "Small Towns" "Small Towns"
## [1042] "Medium Towns" "Small Towns" "Small Towns"
## [1045] "Medium Towns" "Medium Towns" "Medium Towns"
## [1048] "Medium Towns" "Small Towns" "Large Towns"
## [1051] "Large Towns" "Medium Towns" "Large Towns"
## [1054] "Medium Towns" "Medium Towns" "Small Towns"
## [1057] "Large Towns" "Small Towns" "Large Towns"
## [1060] "Large Towns" "Small Towns" "Medium Towns"
## [1063] "Large Towns" "Small Towns" "Medium Towns"
## [1066] "Small Towns" "Small Towns" "Medium Towns"
## [1069] "Small Towns" "Small Towns" "Small Towns"
## [1072] "City" "Small Towns" "Large Towns"
## [1075] "Large Towns" "Small Towns" "Medium Towns"
## [1078] "Small Towns" "Medium Towns" "Small Towns"
## [1081] "Small Towns" "Medium Towns" "Small Towns"
## [1084] "Medium Towns" "Medium Towns" "Medium Towns"
## [1087] "Medium Towns" "Medium Towns" "Small Towns"
## [1090] "Large Towns" "Large Towns" "Medium Towns"
## [1093] "Small Towns" "Large Towns" "Medium Towns"
## [1096] "Small Towns" "Medium Towns" "Large Towns"
## [1099] "Large Towns" "Large Towns" "Inner London BUA"
## [1102] "Outer london BUA" "Other Small BUAs" "Not BUA"str_detect(data$size_flag, "Small Towns")## [1] TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE
## [13] TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE FALSE
## [25] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE TRUE
## [37] TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [49] TRUE FALSE FALSE TRUE TRUE TRUE TRUE FALSE TRUE TRUE FALSE TRUE
## [61] FALSE TRUE TRUE FALSE FALSE FALSE TRUE TRUE TRUE FALSE TRUE TRUE
## [73] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [85] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [97] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE
## [109] TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [121] TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE
## [133] TRUE TRUE TRUE TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE
## [145] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE TRUE
## [157] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE
## [169] TRUE TRUE TRUE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
## [181] FALSE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE
## [193] TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE
## [205] TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE
## [217] TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE
## [229] TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [241] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE
## [253] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [265] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [277] TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [289] TRUE TRUE FALSE TRUE TRUE TRUE TRUE FALSE TRUE TRUE FALSE TRUE
## [301] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [313] FALSE TRUE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [325] TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE
## [337] FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE TRUE TRUE
## [349] FALSE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE FALSE
## [361] TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE FALSE TRUE FALSE
## [373] FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE TRUE
## [385] FALSE FALSE TRUE TRUE TRUE TRUE FALSE TRUE TRUE FALSE TRUE FALSE
## [397] FALSE FALSE TRUE FALSE FALSE TRUE TRUE FALSE TRUE TRUE FALSE FALSE
## [409] TRUE TRUE TRUE TRUE FALSE TRUE FALSE TRUE TRUE TRUE FALSE FALSE
## [421] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE
## [433] TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE
## [445] TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE
## [457] TRUE FALSE TRUE TRUE FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE
## [469] TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE
## [481] TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE
## [493] TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE
## [505] FALSE TRUE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE FALSE FALSE
## [517] TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE TRUE FALSE TRUE FALSE
## [529] TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE FALSE FALSE FALSE
## [541] FALSE TRUE FALSE TRUE TRUE TRUE TRUE FALSE TRUE TRUE FALSE FALSE
## [553] TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE FALSE TRUE
## [565] TRUE TRUE FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE FALSE
## [577] TRUE FALSE FALSE FALSE TRUE TRUE FALSE FALSE TRUE TRUE TRUE FALSE
## [589] TRUE TRUE FALSE FALSE FALSE FALSE TRUE FALSE TRUE TRUE TRUE TRUE
## [601] FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE TRUE FALSE TRUE
## [613] FALSE FALSE TRUE FALSE TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE
## [625] FALSE TRUE FALSE TRUE TRUE FALSE TRUE FALSE TRUE TRUE TRUE TRUE
## [637] TRUE TRUE FALSE TRUE TRUE TRUE FALSE TRUE FALSE FALSE FALSE TRUE
## [649] TRUE FALSE TRUE FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE
## [661] FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE FALSE FALSE TRUE
## [673] FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE FALSE TRUE TRUE TRUE
## [685] TRUE FALSE TRUE FALSE FALSE TRUE TRUE FALSE TRUE TRUE FALSE TRUE
## [697] TRUE FALSE FALSE TRUE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE
## [709] FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE
## [721] FALSE TRUE TRUE TRUE FALSE TRUE TRUE FALSE TRUE TRUE FALSE TRUE
## [733] TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE TRUE
## [745] TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE TRUE TRUE FALSE FALSE
## [757] FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE TRUE FALSE FALSE
## [769] FALSE FALSE TRUE FALSE FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE
## [781] TRUE TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE FALSE
## [793] TRUE TRUE TRUE TRUE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE
## [805] FALSE TRUE TRUE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [817] TRUE FALSE TRUE TRUE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE
## [829] TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
## [841] TRUE TRUE FALSE TRUE FALSE TRUE FALSE TRUE TRUE TRUE TRUE FALSE
## [853] TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE FALSE
## [865] FALSE TRUE FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE
## [877] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [889] FALSE FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE
## [901] FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE
## [913] TRUE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [925] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [937] TRUE FALSE FALSE FALSE TRUE TRUE FALSE FALSE TRUE FALSE TRUE TRUE
## [949] FALSE TRUE TRUE TRUE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE
## [961] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [973] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [985] TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
## [997] FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE TRUE
## [1009] TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE TRUE FALSE FALSE
## [1021] FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE
## [1033] FALSE FALSE FALSE TRUE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE
## [1045] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [1057] FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE
## [1069] TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE TRUE FALSE TRUE
## [1081] TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [1093] TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSEsum(str_detect(data$size_flag, "Small Towns")
)## [1] 662data %>%
summarise(num_SmallTowns = sum(str_detect(size_flag, "Small Towns")))## # A tibble: 1 × 1
## num_SmallTowns
## <int>
## 1 662mean(str_detect(data$size_flag, "Small Towns"))## [1] 0.5996377data %>%
mutate(col_SmallTowns = str_extract(size_flag, "Small Towns")) %>%
select(size_flag, col_SmallTowns) %>%
filter(!is.na(col_SmallTowns))## # A tibble: 662 × 2
## size_flag col_SmallTowns
## <chr> <chr>
## 1 Small Towns Small Towns
## 2 Small Towns Small Towns
## 3 Small Towns Small Towns
## 4 Small Towns Small Towns
## 5 Small Towns Small Towns
## 6 Small Towns Small Towns
## 7 Small Towns Small Towns
## 8 Small Towns Small Towns
## 9 Small Towns Small Towns
## 10 Small Towns Small Towns
## # ℹ 652 more rowsdata %>%
mutate(col_LargeTowns = str_replace(size_flag, "Small Towns", "Large Towns")) %>%
select(size_flag, col_LargeTowns)## # A tibble: 1,104 × 2
## size_flag col_LargeTowns
## <chr> <chr>
## 1 Small Towns Large Towns
## 2 Small Towns Large Towns
## 3 Small Towns Large Towns
## 4 Small Towns Large Towns
## 5 Small Towns Large Towns
## 6 Small Towns Large Towns
## 7 Small Towns Large Towns
## 8 Medium Towns Medium Towns
## 9 Small Towns Large Towns
## 10 Small Towns Large Towns
## # ℹ 1,094 more rows