DS Labs: San Bernadino Private School Enrollment
Nia Pillow
2022-03-26
#Load Libraries
library(tidyverse)## -- Attaching packages --------------------------------------- tidyverse 1.3.1 --## v ggplot2 3.3.5 v purrr 0.3.4
## v tibble 3.1.6 v dplyr 1.0.8
## v tidyr 1.2.0 v stringr 1.4.0
## v readr 2.1.2 v forcats 0.5.1## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()library(ggplot2)
library(dplyr)
library(treemapify)## Warning: package 'treemapify' was built under R version 4.1.3library(reshape2)## Warning: package 'reshape2' was built under R version 4.1.3##
## Attaching package: 'reshape2'## The following object is masked from 'package:tidyr':
##
## smithslibrary(RColorBrewer)
library(treemap)#Load Data
library(readr)
kindergarten_CA_1_ <- read_csv("kindergarten_CA (1).csv")## Rows: 110382 Columns: 8
## -- Column specification --------------------------------------------------------
## Delimiter: ","
## chr (4): district, county, pub_priv, school
## dbl (4): sch_code, enrollment, complete, start_year
##
## i Use `spec()` to retrieve the full column specification for this data.
## i Specify the column types or set `show_col_types = FALSE` to quiet this message.View(kindergarten_CA_1_)#Data Wrangling
Goal: Pull out All private schools in San Bernardino County… Noticed a significant amount of Montessori schools in the county.
K5PV <- kindergarten_CA_1_ %>%
select(county, pub_priv, start_year, enrollment, complete, school) %>%
filter(county== "San Bernardino", pub_priv== "Private", start_year== "2015") %>%
group_by(enrollment, complete, school)
K5PV## # A tibble: 49 x 6
## # Groups: enrollment, complete, school [49]
## county pub_priv start_year enrollment complete school
## <chr> <chr> <dbl> <dbl> <dbl> <chr>
## 1 San Bernardino Private 2015 28 25 ALTA LOMA CHRISTIAN
## 2 San Bernardino Private 2015 12 12 APPLE VALLEY CHRISTIAN
## 3 San Bernardino Private 2015 17 14 BARSTOW CHRISTIAN SCH~
## 4 San Bernardino Private 2015 30 29 BLOOMINGTON CHRISTIAN~
## 5 San Bernardino Private 2015 27 20 CALVARY CHAPEL RIALTO~
## 6 San Bernardino Private 2015 27 26 CARDEN ARBOR VIEW
## 7 San Bernardino Private 2015 73 73 CHILDREN'S MONTESSORI~
## 8 San Bernardino Private 2015 14 12 DEL ROSA CHRISTIAN SC~
## 9 San Bernardino Private 2015 50 46 HEIGHTS CHRISTIAN SCH~
## 10 San Bernardino Private 2015 16 14 HESPERIA CHRISTIAN
## # ... with 39 more rows#I am going to pull out all Montessori Schools in the county and look at the enrollment/complete rates.
as.numeric(K5PV$enrollment)## [1] 28 12 17 30 27 27 73 14 50 16 24 11 28 16 83 36 14 14 26 15 37 12 70 21 11
## [26] 11 72 36 14 17 25 59 24 17 39 16 50 32 34 18 16 14 30 47 14 35 41 22 13K5PVEN <- K5PV %>% select(school, county, pub_priv, enrollment, complete, start_year) %>%
filter(school %in% c("MONTESSORI IN REDLANDS", "MONTESSORI SCHOOL OF CHINO HILLS", "SUNSHINE MONTESSORI", "MONTESSORI CHILD DEVELOPMENT CENTER", "CHILDREN'S MONTESSORI SCHOOL", "MONTESSORI ACADEMY OF CHINO","MONTESSORI SCHOOL HOUSE")) %>%
group_by(school %in% c(" MONTESSORI IN REDLANDS", "MONTESSORI SCHOOL OF CHINO HILLS", "SUNSHINE MONTESSORI", "MONTESSORI CHILD DEVELOPMENT CENTER", "MONTESSORI SCHOOL HOUSE", "MONTESSORI ACADEMY OF CHINO", "CHILDREN'S MONTESSORI SCHOOL", enrollment))
K5PVEN## # A tibble: 7 x 7
## # Groups: school %in% ... [2]
## school county pub_priv enrollment complete start_year `school %in% .~`
## <chr> <chr> <chr> <dbl> <dbl> <dbl> <lgl>
## 1 CHILDREN'S MO~ San B~ Private 73 73 2015 TRUE
## 2 MONTESSORI AC~ San B~ Private 26 26 2015 TRUE
## 3 MONTESSORI CH~ San B~ Private 15 15 2015 TRUE
## 4 MONTESSORI IN~ San B~ Private 37 36 2015 FALSE
## 5 MONTESSORI SC~ San B~ Private 12 12 2015 TRUE
## 6 MONTESSORI SC~ San B~ Private 70 70 2015 TRUE
## 7 SUNSHINE MONT~ San B~ Private 14 14 2015 TRUEVSIZE is BOX SIZE IS BASED ON ENROLLMENT.
The higher the enrollment/complete, the larger the box.
K5PVENTREE <- treemap(K5PVEN,
index=c("school","county","pub_priv"),
vSize = "enrollment",
type="index",
palette = "PuRd",
title="Largest Private Montessori School Enrollment in San Bernardino County (California) in 2015",
fontsize.title = 7,
border.col= "Gold"
)
K5PVENTREE## $tm
## school county pub_priv vSize vColor
## 1 CHILDREN'S MONTESSORI SCHOOL <NA> <NA> 73 1
## 2 CHILDREN'S MONTESSORI SCHOOL San Bernardino <NA> 73 1
## 3 CHILDREN'S MONTESSORI SCHOOL San Bernardino Private 73 1
## 4 MONTESSORI ACADEMY OF CHINO <NA> <NA> 26 1
## 5 MONTESSORI ACADEMY OF CHINO San Bernardino <NA> 26 1
## 6 MONTESSORI ACADEMY OF CHINO San Bernardino Private 26 1
## 7 MONTESSORI CHILD DEVELOPMENT CENTER <NA> <NA> 15 1
## 8 MONTESSORI CHILD DEVELOPMENT CENTER San Bernardino <NA> 15 1
## 9 MONTESSORI CHILD DEVELOPMENT CENTER San Bernardino Private 15 1
## 10 MONTESSORI IN REDLANDS <NA> <NA> 37 1
## 11 MONTESSORI IN REDLANDS San Bernardino <NA> 37 1
## 12 MONTESSORI IN REDLANDS San Bernardino Private 37 1
## 13 MONTESSORI SCHOOL HOUSE <NA> <NA> 12 1
## 14 MONTESSORI SCHOOL HOUSE San Bernardino <NA> 12 1
## 15 MONTESSORI SCHOOL HOUSE San Bernardino Private 12 1
## 16 MONTESSORI SCHOOL OF CHINO HILLS <NA> <NA> 70 1
## 17 MONTESSORI SCHOOL OF CHINO HILLS San Bernardino <NA> 70 1
## 18 MONTESSORI SCHOOL OF CHINO HILLS San Bernardino Private 70 1
## 19 SUNSHINE MONTESSORI <NA> <NA> 14 1
## 20 SUNSHINE MONTESSORI San Bernardino <NA> 14 1
## 21 SUNSHINE MONTESSORI San Bernardino Private 14 1
## stdErr vColorValue level x0 y0 w h color
## 1 73 NA 1 0.0000000 0.4895105 0.5789474 0.5104895 #F7F4F9
## 2 73 NA 2 0.0000000 0.4895105 0.5789474 0.5104895 #F7F4F9
## 3 73 NA 3 0.0000000 0.4895105 0.5789474 0.5104895 #F7F4F9
## 4 26 NA 1 0.5789474 0.2500000 0.2670090 0.3942308 #E7E1EF
## 5 26 NA 2 0.5789474 0.2500000 0.2670090 0.3942308 #E7E1EF
## 6 26 NA 3 0.5789474 0.2500000 0.2670090 0.3942308 #E7E1EF
## 7 15 NA 1 0.8459564 0.2500000 0.1540436 0.3942308 #D4B9DA
## 8 15 NA 2 0.8459564 0.2500000 0.1540436 0.3942308 #D4B9DA
## 9 15 NA 3 0.8459564 0.2500000 0.1540436 0.3942308 #D4B9DA
## 10 37 NA 1 0.5789474 0.6442308 0.4210526 0.3557692 #C994C7
## 11 37 NA 2 0.5789474 0.6442308 0.4210526 0.3557692 #C994C7
## 12 37 NA 3 0.5789474 0.6442308 0.4210526 0.3557692 #C994C7
## 13 12 NA 1 0.8056680 0.0000000 0.1943320 0.2500000 #DF65B0
## 14 12 NA 2 0.8056680 0.0000000 0.1943320 0.2500000 #DF65B0
## 15 12 NA 3 0.8056680 0.0000000 0.1943320 0.2500000 #DF65B0
## 16 70 NA 1 0.0000000 0.0000000 0.5789474 0.4895105 #E7298A
## 17 70 NA 2 0.0000000 0.0000000 0.5789474 0.4895105 #E7298A
## 18 70 NA 3 0.0000000 0.0000000 0.5789474 0.4895105 #E7298A
## 19 14 NA 1 0.5789474 0.0000000 0.2267206 0.2500000 #CE1256
## 20 14 NA 2 0.5789474 0.0000000 0.2267206 0.2500000 #CE1256
## 21 14 NA 3 0.5789474 0.0000000 0.2267206 0.2500000 #CE1256
##
## $type
## [1] "index"
##
## $vSize
## [1] "enrollment"
##
## $vColor
## [1] NA
##
## $stdErr
## [1] "enrollment"
##
## $algorithm
## [1] "pivotSize"
##
## $vpCoorX
## [1] 0.02812148 0.97187852
##
## $vpCoorY
## [1] 0.01968504 0.94531496
##
## $aspRatio
## [1] 1.427417
##
## $range
## [1] NA
##
## $mapping
## [1] NA NA NA
##
## $draw
## [1] TRUE###Let’s look at all private schools in San Bernardino County
PriK5CA <- K5PV %>% select(county, enrollment, complete, pub_priv, school, start_year) %>%
filter(county== "San Bernardino") %>%
filter(pub_priv== "Private") %>%
group_by(pub_priv %in% c("Private", enrollment))
PriK5CA## # A tibble: 49 x 7
## # Groups: pub_priv %in% c("Private", enrollment) [1]
## county enrollment complete pub_priv school start_year `pub_priv %in%~`
## <chr> <dbl> <dbl> <chr> <chr> <dbl> <lgl>
## 1 San Bernardi~ 28 25 Private ALTA ~ 2015 TRUE
## 2 San Bernardi~ 12 12 Private APPLE~ 2015 TRUE
## 3 San Bernardi~ 17 14 Private BARST~ 2015 TRUE
## 4 San Bernardi~ 30 29 Private BLOOM~ 2015 TRUE
## 5 San Bernardi~ 27 20 Private CALVA~ 2015 TRUE
## 6 San Bernardi~ 27 26 Private CARDE~ 2015 TRUE
## 7 San Bernardi~ 73 73 Private CHILD~ 2015 TRUE
## 8 San Bernardi~ 14 12 Private DEL R~ 2015 TRUE
## 9 San Bernardi~ 50 46 Private HEIGH~ 2015 TRUE
## 10 San Bernardi~ 16 14 Private HESPE~ 2015 TRUE
## # ... with 39 more rows#Creating another treemap
Montessori school seems to be a very popular choice for private education in San Bernardino county.
PriK5CATree <- treemap(PriK5CA,
index=c("school","county","pub_priv"),
vSize = "enrollment",
type="index",
palette = "Greens",
title="Largest Private (Montessori, Christian, etc..) School Enrollment in San Bernardino County (California) in 2015",
fontsize.title = 7,
border.col= "Gold"
)
PriK5CATree## $tm
## school county pub_priv
## 1 ALTA LOMA CHRISTIAN <NA> <NA>
## 2 ALTA LOMA CHRISTIAN San Bernardino <NA>
## 3 ALTA LOMA CHRISTIAN San Bernardino Private
## 4 APPLE VALLEY CHRISTIAN <NA> <NA>
## 5 APPLE VALLEY CHRISTIAN San Bernardino <NA>
## 6 APPLE VALLEY CHRISTIAN San Bernardino Private
## 7 BARSTOW CHRISTIAN SCHOOL <NA> <NA>
## 8 BARSTOW CHRISTIAN SCHOOL San Bernardino <NA>
## 9 BARSTOW CHRISTIAN SCHOOL San Bernardino Private
## 10 BLOOMINGTON CHRISTIAN SCHOOL <NA> <NA>
## 11 BLOOMINGTON CHRISTIAN SCHOOL San Bernardino <NA>
## 12 BLOOMINGTON CHRISTIAN SCHOOL San Bernardino Private
## 13 CALVARY CHAPEL RIALTO CHRISTIAN SCHOOL <NA> <NA>
## 14 CALVARY CHAPEL RIALTO CHRISTIAN SCHOOL San Bernardino <NA>
## 15 CALVARY CHAPEL RIALTO CHRISTIAN SCHOOL San Bernardino Private
## 16 CARDEN ARBOR VIEW <NA> <NA>
## 17 CARDEN ARBOR VIEW San Bernardino <NA>
## 18 CARDEN ARBOR VIEW San Bernardino Private
## 19 CHILDREN'S MONTESSORI SCHOOL <NA> <NA>
## 20 CHILDREN'S MONTESSORI SCHOOL San Bernardino <NA>
## 21 CHILDREN'S MONTESSORI SCHOOL San Bernardino Private
## 22 DEL ROSA CHRISTIAN SCHOOL <NA> <NA>
## 23 DEL ROSA CHRISTIAN SCHOOL San Bernardino <NA>
## 24 DEL ROSA CHRISTIAN SCHOOL San Bernardino Private
## 25 HEIGHTS CHRISTIAN SCHOOL - CHINO HILLS CHRISTIAN <NA> <NA>
## 26 HEIGHTS CHRISTIAN SCHOOL - CHINO HILLS CHRISTIAN San Bernardino <NA>
## 27 HEIGHTS CHRISTIAN SCHOOL - CHINO HILLS CHRISTIAN San Bernardino Private
## 28 HESPERIA CHRISTIAN <NA> <NA>
## 29 HESPERIA CHRISTIAN San Bernardino <NA>
## 30 HESPERIA CHRISTIAN San Bernardino Private
## 31 HOLY ROSARY ACADEMY <NA> <NA>
## 32 HOLY ROSARY ACADEMY San Bernardino <NA>
## 33 HOLY ROSARY ACADEMY San Bernardino Private
## 34 HOPE CHRISTIAN SCHOOL <NA> <NA>
## 35 HOPE CHRISTIAN SCHOOL San Bernardino <NA>
## 36 HOPE CHRISTIAN SCHOOL San Bernardino Private
## 37 JOSHUA SPRINGS CHRISTIAN SCHOOL <NA> <NA>
## 38 JOSHUA SPRINGS CHRISTIAN SCHOOL San Bernardino <NA>
## 39 JOSHUA SPRINGS CHRISTIAN SCHOOL San Bernardino Private
## 40 LAKE ARROWHEAD CHRISTIAN SCHOOL <NA> <NA>
## 41 LAKE ARROWHEAD CHRISTIAN SCHOOL San Bernardino <NA>
## 42 LAKE ARROWHEAD CHRISTIAN SCHOOL San Bernardino Private
## 43 LOMA LINDA ACADEMY <NA> <NA>
## 44 LOMA LINDA ACADEMY San Bernardino <NA>
## 45 LOMA LINDA ACADEMY San Bernardino Private
## 46 LOVING SAVIOR LUTHERAN SCHOOL <NA> <NA>
## 47 LOVING SAVIOR LUTHERAN SCHOOL San Bernardino <NA>
## 48 LOVING SAVIOR LUTHERAN SCHOOL San Bernardino Private
## 49 MESA GRANDE SDA ACADEMY <NA> <NA>
## 50 MESA GRANDE SDA ACADEMY San Bernardino <NA>
## 51 MESA GRANDE SDA ACADEMY San Bernardino Private
## 52 MONTECITO BAPTIST SCHOOL <NA> <NA>
## 53 MONTECITO BAPTIST SCHOOL San Bernardino <NA>
## 54 MONTECITO BAPTIST SCHOOL San Bernardino Private
## 55 MONTESSORI ACADEMY OF CHINO <NA> <NA>
## 56 MONTESSORI ACADEMY OF CHINO San Bernardino <NA>
## 57 MONTESSORI ACADEMY OF CHINO San Bernardino Private
## 58 MONTESSORI CHILD DEVELOPMENT CENTER <NA> <NA>
## 59 MONTESSORI CHILD DEVELOPMENT CENTER San Bernardino <NA>
## 60 MONTESSORI CHILD DEVELOPMENT CENTER San Bernardino Private
## 61 MONTESSORI IN REDLANDS <NA> <NA>
## 62 MONTESSORI IN REDLANDS San Bernardino <NA>
## 63 MONTESSORI IN REDLANDS San Bernardino Private
## 64 MONTESSORI SCHOOL HOUSE <NA> <NA>
## 65 MONTESSORI SCHOOL HOUSE San Bernardino <NA>
## 66 MONTESSORI SCHOOL HOUSE San Bernardino Private
## 67 MONTESSORI SCHOOL OF CHINO HILLS <NA> <NA>
## 68 MONTESSORI SCHOOL OF CHINO HILLS San Bernardino <NA>
## 69 MONTESSORI SCHOOL OF CHINO HILLS San Bernardino Private
## 70 MOUNTAIN VIEW CHRISTIAN PRESCHOOL AND KINDERGARTEN <NA> <NA>
## 71 MOUNTAIN VIEW CHRISTIAN PRESCHOOL AND KINDERGARTEN San Bernardino <NA>
## 72 MOUNTAIN VIEW CHRISTIAN PRESCHOOL AND KINDERGARTEN San Bernardino Private
## 73 NEW HOPE CHRISTIAN SCHOOLS <NA> <NA>
## 74 NEW HOPE CHRISTIAN SCHOOLS San Bernardino <NA>
## 75 NEW HOPE CHRISTIAN SCHOOLS San Bernardino Private
## 76 NEW LIFE CHRISTIAN ACADEMY <NA> <NA>
## 77 NEW LIFE CHRISTIAN ACADEMY San Bernardino <NA>
## 78 NEW LIFE CHRISTIAN ACADEMY San Bernardino Private
## 79 ONTARIO CHRISTIAN ELEMENTARY <NA> <NA>
## 80 ONTARIO CHRISTIAN ELEMENTARY San Bernardino <NA>
## 81 ONTARIO CHRISTIAN ELEMENTARY San Bernardino Private
## 82 OUR LADY OF LOURDES <NA> <NA>
## 83 OUR LADY OF LOURDES San Bernardino <NA>
## 84 OUR LADY OF LOURDES San Bernardino Private
## 85 OUR LADY OF THE ASSUMPTION ELEMENTARY <NA> <NA>
## 86 OUR LADY OF THE ASSUMPTION ELEMENTARY San Bernardino <NA>
## 87 OUR LADY OF THE ASSUMPTION ELEMENTARY San Bernardino Private
## 88 PACKINGHOUSE CHRISTIAN ACADEMY <NA> <NA>
## 89 PACKINGHOUSE CHRISTIAN ACADEMY San Bernardino <NA>
## 90 PACKINGHOUSE CHRISTIAN ACADEMY San Bernardino Private
## 91 REDLANDS ADVENTIST ACADEMY <NA> <NA>
## 92 REDLANDS ADVENTIST ACADEMY San Bernardino <NA>
## 93 REDLANDS ADVENTIST ACADEMY San Bernardino Private
## 94 REDLANDS CHRISTIAN SCHOOL <NA> <NA>
## 95 REDLANDS CHRISTIAN SCHOOL San Bernardino <NA>
## 96 REDLANDS CHRISTIAN SCHOOL San Bernardino Private
## 97 RESURRECTION ACADEMY <NA> <NA>
## 98 RESURRECTION ACADEMY San Bernardino <NA>
## 99 RESURRECTION ACADEMY San Bernardino Private
## 100 SACRED HEART ACADEMY <NA> <NA>
## 101 SACRED HEART ACADEMY San Bernardino <NA>
## 102 SACRED HEART ACADEMY San Bernardino Private
## 103 SACRED HEART PARISH SCHOOL <NA> <NA>
## 104 SACRED HEART PARISH SCHOOL San Bernardino <NA>
## 105 SACRED HEART PARISH SCHOOL San Bernardino Private
## 106 ST. CATHERINE OF SIENA <NA> <NA>
## 107 ST. CATHERINE OF SIENA San Bernardino <NA>
## 108 ST. CATHERINE OF SIENA San Bernardino Private
## 109 ST. GEORGE <NA> <NA>
## 110 ST. GEORGE San Bernardino <NA>
## 111 ST. GEORGE San Bernardino Private
## 112 ST. JOSEPH ELEMENTARY <NA> <NA>
## 113 ST. JOSEPH ELEMENTARY San Bernardino <NA>
## 114 ST. JOSEPH ELEMENTARY San Bernardino Private
## 115 ST. MARGARET MARY <NA> <NA>
## 116 ST. MARGARET MARY San Bernardino <NA>
## 117 ST. MARGARET MARY San Bernardino Private
## 118 ST. MARK'S EPISCOPAL <NA> <NA>
## 119 ST. MARK'S EPISCOPAL San Bernardino <NA>
## 120 ST. MARK'S EPISCOPAL San Bernardino Private
## 121 ST. PETER AND ST. PAUL SCHOOL <NA> <NA>
## 122 ST. PETER AND ST. PAUL SCHOOL San Bernardino <NA>
## 123 ST. PETER AND ST. PAUL SCHOOL San Bernardino Private
## 124 SUNSHINE MONTESSORI <NA> <NA>
## 125 SUNSHINE MONTESSORI San Bernardino <NA>
## 126 SUNSHINE MONTESSORI San Bernardino Private
## 127 THE ROCK CHRISTIAN SCHOOL <NA> <NA>
## 128 THE ROCK CHRISTIAN SCHOOL San Bernardino <NA>
## 129 THE ROCK CHRISTIAN SCHOOL San Bernardino Private
## 130 UPLAND CHRISTIAN ACADEMY <NA> <NA>
## 131 UPLAND CHRISTIAN ACADEMY San Bernardino <NA>
## 132 UPLAND CHRISTIAN ACADEMY San Bernardino Private
## 133 VALLEY PREPARATORY SCHOOL <NA> <NA>
## 134 VALLEY PREPARATORY SCHOOL San Bernardino <NA>
## 135 VALLEY PREPARATORY SCHOOL San Bernardino Private
## 136 VICTOR VALLEY CHRISTIAN ELEMENTARY <NA> <NA>
## 137 VICTOR VALLEY CHRISTIAN ELEMENTARY San Bernardino <NA>
## 138 VICTOR VALLEY CHRISTIAN ELEMENTARY San Bernardino Private
## 139 WATER OF LIFE CHRISTIAN <NA> <NA>
## 140 WATER OF LIFE CHRISTIAN San Bernardino <NA>
## 141 WATER OF LIFE CHRISTIAN San Bernardino Private
## 142 WESTSIDE CHRISTIAN SCHOOL <NA> <NA>
## 143 WESTSIDE CHRISTIAN SCHOOL San Bernardino <NA>
## 144 WESTSIDE CHRISTIAN SCHOOL San Bernardino Private
## 145 WILDWOOD CHRISTIAN ACADEMY <NA> <NA>
## 146 WILDWOOD CHRISTIAN ACADEMY San Bernardino <NA>
## 147 WILDWOOD CHRISTIAN ACADEMY San Bernardino Private
## vSize vColor stdErr vColorValue level x0 y0 w
## 1 28 1 28 NA 1 0.3870739 0.0000000 0.13880974
## 2 28 1 28 NA 2 0.3870739 0.0000000 0.13880974
## 3 28 1 28 NA 3 0.3870739 0.0000000 0.13880974
## 4 12 1 12 NA 1 0.8102241 0.0000000 0.06777709
## 5 12 1 12 NA 2 0.8102241 0.0000000 0.06777709
## 6 12 1 12 NA 3 0.8102241 0.0000000 0.06777709
## 7 17 1 17 NA 1 0.8293653 0.4846477 0.08531733
## 8 17 1 17 NA 2 0.8293653 0.4846477 0.08531733
## 9 17 1 17 NA 3 0.8293653 0.4846477 0.08531733
## 10 30 1 30 NA 1 0.3870739 0.2967600 0.13880974
## 11 30 1 30 NA 2 0.3870739 0.2967600 0.13880974
## 12 30 1 30 NA 3 0.3870739 0.2967600 0.13880974
## 13 27 1 27 NA 1 0.6488027 0.6261648 0.11852910
## 14 27 1 27 NA 2 0.6488027 0.6261648 0.11852910
## 15 27 1 27 NA 3 0.6488027 0.6261648 0.11852910
## 16 27 1 27 NA 1 0.7673318 0.6261648 0.11852910
## 17 27 1 27 NA 2 0.7673318 0.6261648 0.11852910
## 18 27 1 27 NA 3 0.7673318 0.6261648 0.11852910
## 19 73 1 73 NA 1 0.0000000 0.4765101 0.21164773
## 20 73 1 73 NA 2 0.0000000 0.4765101 0.21164773
## 21 73 1 73 NA 3 0.0000000 0.4765101 0.21164773
## 22 14 1 14 NA 1 0.9156552 0.3667604 0.08434483
## 23 14 1 14 NA 2 0.9156552 0.3667604 0.08434483
## 24 14 1 14 NA 3 0.9156552 0.3667604 0.08434483
## 25 50 1 50 NA 1 0.2116477 0.5587045 0.17542614
## 26 50 1 50 NA 2 0.2116477 0.5587045 0.17542614
## 27 50 1 50 NA 3 0.2116477 0.5587045 0.17542614
## 28 16 1 16 NA 1 0.6336373 0.2385958 0.09525429
## 29 16 1 16 NA 2 0.6336373 0.2385958 0.09525429
## 30 16 1 16 NA 3 0.6336373 0.2385958 0.09525429
## 31 24 1 24 NA 1 0.5258836 0.3031956 0.10775373
## 32 24 1 24 NA 2 0.5258836 0.3031956 0.10775373
## 33 24 1 24 NA 3 0.5258836 0.3031956 0.10775373
## 34 11 1 11 NA 1 0.9416528 0.1280751 0.05834724
## 35 11 1 11 NA 2 0.9416528 0.1280751 0.05834724
## 36 11 1 11 NA 3 0.9416528 0.1280751 0.05834724
## 37 28 1 28 NA 1 0.5258836 0.6261648 0.12291907
## 38 28 1 28 NA 2 0.5258836 0.6261648 0.12291907
## 39 28 1 28 NA 3 0.5258836 0.6261648 0.12291907
## 40 16 1 16 NA 1 0.6336373 0.1192979 0.09525429
## 41 16 1 16 NA 2 0.6336373 0.1192979 0.09525429
## 42 16 1 16 NA 3 0.6336373 0.1192979 0.09525429
## 43 83 1 83 NA 1 0.0000000 0.7214765 0.21164773
## 44 83 1 83 NA 2 0.0000000 0.7214765 0.21164773
## 45 83 1 83 NA 3 0.0000000 0.7214765 0.21164773
## 46 36 1 36 NA 1 0.6416224 0.7879490 0.12057563
## 47 36 1 36 NA 2 0.6416224 0.7879490 0.12057563
## 48 36 1 36 NA 3 0.6416224 0.7879490 0.12057563
## 49 14 1 14 NA 1 0.7288916 0.2445069 0.08133251
## 50 14 1 14 NA 2 0.7288916 0.2445069 0.08133251
## 51 14 1 14 NA 3 0.7288916 0.2445069 0.08133251
## 52 14 1 14 NA 1 0.7288916 0.1222535 0.08133251
## 53 14 1 14 NA 2 0.7288916 0.1222535 0.08133251
## 54 14 1 14 NA 3 0.7288916 0.1222535 0.08133251
## 55 26 1 26 NA 1 0.8858609 0.6261648 0.11413913
## 56 26 1 26 NA 2 0.8858609 0.6261648 0.11413913
## 57 26 1 26 NA 3 0.8858609 0.6261648 0.11413913
## 58 15 1 15 NA 1 0.8252857 0.3667604 0.09036946
## 59 15 1 15 NA 2 0.8252857 0.3667604 0.09036946
## 60 15 1 15 NA 3 0.8252857 0.3667604 0.09036946
## 61 37 1 37 NA 1 0.5176975 0.7879490 0.12392496
## 62 37 1 37 NA 2 0.5176975 0.7879490 0.12392496
## 63 37 1 37 NA 3 0.5176975 0.7879490 0.12392496
## 64 12 1 12 NA 1 0.8780012 0.1280751 0.06365153
## 65 12 1 12 NA 2 0.8780012 0.1280751 0.06365153
## 66 12 1 12 NA 3 0.8780012 0.1280751 0.06365153
## 67 70 1 70 NA 1 0.0000000 0.0000000 0.21164773
## 68 70 1 70 NA 2 0.0000000 0.0000000 0.21164773
## 69 70 1 70 NA 3 0.0000000 0.0000000 0.21164773
## 70 21 1 21 NA 1 0.6336373 0.4846477 0.10539200
## 71 21 1 21 NA 2 0.6336373 0.4846477 0.10539200
## 72 21 1 21 NA 3 0.6336373 0.4846477 0.10539200
## 73 11 1 11 NA 1 0.8780012 0.0000000 0.06099938
## 74 11 1 11 NA 2 0.8780012 0.0000000 0.06099938
## 75 11 1 11 NA 3 0.8780012 0.0000000 0.06099938
## 76 11 1 11 NA 1 0.9390006 0.0000000 0.06099938
## 77 11 1 11 NA 2 0.9390006 0.0000000 0.06099938
## 78 11 1 11 NA 3 0.9390006 0.0000000 0.06099938
## 79 72 1 72 NA 1 0.0000000 0.2348993 0.21164773
## 80 72 1 72 NA 2 0.0000000 0.2348993 0.21164773
## 81 72 1 72 NA 3 0.0000000 0.2348993 0.21164773
## 82 36 1 36 NA 1 0.7621981 0.7879490 0.12057563
## 83 36 1 36 NA 2 0.7621981 0.7879490 0.12057563
## 84 36 1 36 NA 3 0.7621981 0.7879490 0.12057563
## 85 14 1 14 NA 1 0.7288916 0.0000000 0.08133251
## 86 14 1 14 NA 2 0.7288916 0.0000000 0.08133251
## 87 14 1 14 NA 3 0.7288916 0.0000000 0.08133251
## 88 17 1 17 NA 1 0.9146827 0.4846477 0.08531733
## 89 17 1 17 NA 2 0.9146827 0.4846477 0.08531733
## 90 17 1 17 NA 3 0.9146827 0.4846477 0.08531733
## 91 25 1 25 NA 1 0.5258836 0.4613846 0.10775373
## 92 25 1 25 NA 2 0.5258836 0.4613846 0.10775373
## 93 25 1 25 NA 3 0.5258836 0.4613846 0.10775373
## 94 59 1 59 NA 1 0.2116477 0.7611336 0.17542614
## 95 59 1 59 NA 2 0.2116477 0.7611336 0.17542614
## 96 59 1 59 NA 3 0.2116477 0.7611336 0.17542614
## 97 24 1 24 NA 1 0.5258836 0.1450066 0.10775373
## 98 24 1 24 NA 2 0.5258836 0.1450066 0.10775373
## 99 24 1 24 NA 3 0.5258836 0.1450066 0.10775373
## 100 17 1 17 NA 1 0.6336373 0.3578937 0.09525429
## 101 17 1 17 NA 2 0.6336373 0.3578937 0.09525429
## 102 17 1 17 NA 3 0.6336373 0.3578937 0.09525429
## 103 39 1 39 NA 1 0.3870739 0.7879490 0.13062360
## 104 39 1 39 NA 2 0.3870739 0.7879490 0.13062360
## 105 39 1 39 NA 3 0.3870739 0.7879490 0.13062360
## 106 16 1 16 NA 1 0.6336373 0.0000000 0.09525429
## 107 16 1 16 NA 2 0.6336373 0.0000000 0.09525429
## 108 16 1 16 NA 3 0.6336373 0.0000000 0.09525429
## 109 50 1 50 NA 1 0.2116477 0.3562753 0.17542614
## 110 50 1 50 NA 2 0.2116477 0.3562753 0.17542614
## 111 50 1 50 NA 3 0.2116477 0.3562753 0.17542614
## 112 32 1 32 NA 1 0.3870739 0.4502566 0.13880974
## 113 32 1 32 NA 2 0.3870739 0.4502566 0.13880974
## 114 32 1 32 NA 3 0.3870739 0.4502566 0.13880974
## 115 34 1 34 NA 1 0.3870739 0.6139862 0.13880974
## 116 34 1 34 NA 2 0.3870739 0.6139862 0.13880974
## 117 34 1 34 NA 3 0.3870739 0.6139862 0.13880974
## 118 18 1 18 NA 1 0.7390293 0.4846477 0.09033600
## 119 18 1 18 NA 2 0.7390293 0.4846477 0.09033600
## 120 18 1 18 NA 3 0.7390293 0.4846477 0.09033600
## 121 16 1 16 NA 1 0.7288916 0.3667604 0.09639409
## 122 16 1 16 NA 2 0.7288916 0.3667604 0.09639409
## 123 16 1 16 NA 3 0.7288916 0.3667604 0.09639409
## 124 14 1 14 NA 1 0.8102241 0.2619717 0.09488793
## 125 14 1 14 NA 2 0.8102241 0.2619717 0.09488793
## 126 14 1 14 NA 3 0.8102241 0.2619717 0.09488793
## 127 30 1 30 NA 1 0.3870739 0.1432635 0.13880974
## 128 30 1 30 NA 2 0.3870739 0.1432635 0.13880974
## 129 30 1 30 NA 3 0.3870739 0.1432635 0.13880974
## 130 47 1 47 NA 1 0.2116477 0.1659919 0.17542614
## 131 47 1 47 NA 2 0.2116477 0.1659919 0.17542614
## 132 47 1 47 NA 3 0.2116477 0.1659919 0.17542614
## 133 14 1 14 NA 1 0.9051121 0.2619717 0.09488793
## 134 14 1 14 NA 2 0.9051121 0.2619717 0.09488793
## 135 14 1 14 NA 3 0.9051121 0.2619717 0.09488793
## 136 35 1 35 NA 1 0.8827737 0.7879490 0.11722631
## 137 35 1 35 NA 2 0.8827737 0.7879490 0.11722631
## 138 35 1 35 NA 3 0.8827737 0.7879490 0.11722631
## 139 41 1 41 NA 1 0.2116477 0.0000000 0.17542614
## 140 41 1 41 NA 2 0.2116477 0.0000000 0.17542614
## 141 41 1 41 NA 3 0.2116477 0.0000000 0.17542614
## 142 22 1 22 NA 1 0.5258836 0.0000000 0.10775373
## 143 22 1 22 NA 2 0.5258836 0.0000000 0.10775373
## 144 22 1 22 NA 3 0.5258836 0.0000000 0.10775373
## 145 13 1 13 NA 1 0.8102241 0.1257464 0.06777709
## 146 13 1 13 NA 2 0.8102241 0.1257464 0.06777709
## 147 13 1 13 NA 3 0.8102241 0.1257464 0.06777709
## h color
## 1 0.1432635 #F7FCF5
## 2 0.1432635 #F7FCF5
## 3 0.1432635 #F7FCF5
## 4 0.1257464 #E5F5E0
## 5 0.1257464 #E5F5E0
## 6 0.1257464 #E5F5E0
## 7 0.1415171 #C7E9C0
## 8 0.1415171 #C7E9C0
## 9 0.1415171 #C7E9C0
## 10 0.1534966 #A1D99B
## 11 0.1534966 #A1D99B
## 12 0.1534966 #A1D99B
## 13 0.1617842 #74C476
## 14 0.1617842 #74C476
## 15 0.1617842 #74C476
## 16 0.1617842 #41AB5D
## 17 0.1617842 #41AB5D
## 18 0.1617842 #41AB5D
## 19 0.2449664 #238B45
## 20 0.2449664 #238B45
## 21 0.2449664 #238B45
## 22 0.1178873 #006D2C
## 23 0.1178873 #006D2C
## 24 0.1178873 #006D2C
## 25 0.2024291 #00441B
## 26 0.2024291 #00441B
## 27 0.2024291 #00441B
## 28 0.1192979 #F7FCF5
## 29 0.1192979 #F7FCF5
## 30 0.1192979 #F7FCF5
## 31 0.1581890 #E5F5E0
## 32 0.1581890 #E5F5E0
## 33 0.1581890 #E5F5E0
## 34 0.1338967 #C7E9C0
## 35 0.1338967 #C7E9C0
## 36 0.1338967 #C7E9C0
## 37 0.1617842 #A1D99B
## 38 0.1617842 #A1D99B
## 39 0.1617842 #A1D99B
## 40 0.1192979 #74C476
## 41 0.1192979 #74C476
## 42 0.1192979 #74C476
## 43 0.2785235 #41AB5D
## 44 0.2785235 #41AB5D
## 45 0.2785235 #41AB5D
## 46 0.2120510 #238B45
## 47 0.2120510 #238B45
## 48 0.2120510 #238B45
## 49 0.1222535 #006D2C
## 50 0.1222535 #006D2C
## 51 0.1222535 #006D2C
## 52 0.1222535 #00441B
## 53 0.1222535 #00441B
## 54 0.1222535 #00441B
## 55 0.1617842 #F7FCF5
## 56 0.1617842 #F7FCF5
## 57 0.1617842 #F7FCF5
## 58 0.1178873 #E5F5E0
## 59 0.1178873 #E5F5E0
## 60 0.1178873 #E5F5E0
## 61 0.2120510 #C7E9C0
## 62 0.2120510 #C7E9C0
## 63 0.2120510 #C7E9C0
## 64 0.1338967 #A1D99B
## 65 0.1338967 #A1D99B
## 66 0.1338967 #A1D99B
## 67 0.2348993 #74C476
## 68 0.2348993 #74C476
## 69 0.2348993 #74C476
## 70 0.1415171 #41AB5D
## 71 0.1415171 #41AB5D
## 72 0.1415171 #41AB5D
## 73 0.1280751 #238B45
## 74 0.1280751 #238B45
## 75 0.1280751 #238B45
## 76 0.1280751 #006D2C
## 77 0.1280751 #006D2C
## 78 0.1280751 #006D2C
## 79 0.2416107 #00441B
## 80 0.2416107 #00441B
## 81 0.2416107 #00441B
## 82 0.2120510 #F7FCF5
## 83 0.2120510 #F7FCF5
## 84 0.2120510 #F7FCF5
## 85 0.1222535 #E5F5E0
## 86 0.1222535 #E5F5E0
## 87 0.1222535 #E5F5E0
## 88 0.1415171 #C7E9C0
## 89 0.1415171 #C7E9C0
## 90 0.1415171 #C7E9C0
## 91 0.1647802 #A1D99B
## 92 0.1647802 #A1D99B
## 93 0.1647802 #A1D99B
## 94 0.2388664 #74C476
## 95 0.2388664 #74C476
## 96 0.2388664 #74C476
## 97 0.1581890 #41AB5D
## 98 0.1581890 #41AB5D
## 99 0.1581890 #41AB5D
## 100 0.1267540 #238B45
## 101 0.1267540 #238B45
## 102 0.1267540 #238B45
## 103 0.2120510 #006D2C
## 104 0.2120510 #006D2C
## 105 0.2120510 #006D2C
## 106 0.1192979 #00441B
## 107 0.1192979 #00441B
## 108 0.1192979 #00441B
## 109 0.2024291 #F7FCF5
## 110 0.2024291 #F7FCF5
## 111 0.2024291 #F7FCF5
## 112 0.1637297 #E5F5E0
## 113 0.1637297 #E5F5E0
## 114 0.1637297 #E5F5E0
## 115 0.1739628 #C7E9C0
## 116 0.1739628 #C7E9C0
## 117 0.1739628 #C7E9C0
## 118 0.1415171 #A1D99B
## 119 0.1415171 #A1D99B
## 120 0.1415171 #A1D99B
## 121 0.1178873 #74C476
## 122 0.1178873 #74C476
## 123 0.1178873 #74C476
## 124 0.1047887 #41AB5D
## 125 0.1047887 #41AB5D
## 126 0.1047887 #41AB5D
## 127 0.1534966 #238B45
## 128 0.1534966 #238B45
## 129 0.1534966 #238B45
## 130 0.1902834 #006D2C
## 131 0.1902834 #006D2C
## 132 0.1902834 #006D2C
## 133 0.1047887 #00441B
## 134 0.1047887 #00441B
## 135 0.1047887 #00441B
## 136 0.2120510 #F7FCF5
## 137 0.2120510 #F7FCF5
## 138 0.2120510 #F7FCF5
## 139 0.1659919 #E5F5E0
## 140 0.1659919 #E5F5E0
## 141 0.1659919 #E5F5E0
## 142 0.1450066 #C7E9C0
## 143 0.1450066 #C7E9C0
## 144 0.1450066 #C7E9C0
## 145 0.1362253 #A1D99B
## 146 0.1362253 #A1D99B
## 147 0.1362253 #A1D99B
##
## $type
## [1] "index"
##
## $vSize
## [1] "enrollment"
##
## $vColor
## [1] NA
##
## $stdErr
## [1] "enrollment"
##
## $algorithm
## [1] "pivotSize"
##
## $vpCoorX
## [1] 0.02812148 0.97187852
##
## $vpCoorY
## [1] 0.01968504 0.94531496
##
## $aspRatio
## [1] 1.427417
##
## $range
## [1] NA
##
## $mapping
## [1] NA NA NA
##
## $draw
## [1] TRUE#Paragraph
About my Data I used the (kindergarten_CA.csv) dataset from our course resources tab. The kindergarten dataset contains district, county, name of school, how many students were enrolled, how many students completed, and whether the school attended was a private or public school.
Data Cleaning – Location: San Bernardino, CA Year Start – 2015 Enrolled/Complete Private Schools only. I looked at all the Montessori schools in San Bernardino County and created my first visualization using the dplyr and functions filter and select. After that, I began to look at ALL the private schools in San Bernardino County within this dataset again using the filter and select functions. Tree Mapping- I used a Tree Map to demonstrate a hierarchical chart for my visualization. The size of the box will be relevant to the size of the enrollment. Schools with large enrollments will display a larger box. Also the darker shades of green green are relevant to enrollment size as well. For example; Loma Linda Academy has an enrollment size of 83. Schools with smaller enrollments had smaller box sizes and lack a shade of green, displaying an all white box. From both visualizations I created, I noticed that private Montessori school were favorable amongst parents residing in San Bernardino County.
#END