Loading required package: leaflet
Loading required package: maps
Loading required package: ggplot2
Loading required package: highcharter
Highcharts (www.highcharts.com) is a Highsoft software product which is
not free for commercial and Governmental use
mapCPS = leaflet(cps) %>% 
  setView(lng = -87.6298, lat = 41.8781, zoom = 12) %>%
  addTiles() %>% 
  addCircleMarkers(lng= ~Longitude,lat = ~Latitude, radius=~Safety.Score, col=~Color)
mapCPS
cps$Safety.Icon<-factor(cps$Safety.Icon, levels=c("Very Weak", "Weak", "Average", "Strong", "Very Strong", "NDA"))
hchart(cps[!is.na(cps$Safety.Score) & !is.na(cps$Environment.Score),], "scatter", hcaes(x=Safety.Score, y=Environment.Score, group=Safety.Icon)) %>%  hc_title(text="Safety Score and Environment Score grouped by Safety Icon")
cps$Average.Student.Attendance<-as.numeric(sub("%","",cps$Average.Student.Attendance))
cps$Average.Teacher.Attendance<-as.numeric(sub("%","",cps$Average.Teacher.Attendance))
cps$Average.Teacher.Attendance[cps$Average.Teacher.Attendance==0] <- NA 
hchart(cps, "scatter", hcaes(x=Average.Student.Attendance, y=Average.Teacher.Attendance))
LS0tCnRpdGxlOiAiQ1BTIERhdGEgVmlzdWFsaXphdGlvbiIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKYGBge3IsIGVjaG89RkFMU0V9CmlmKCFyZXF1aXJlKGxlYWZsZXQpKSBpbnN0YWxsLnBhY2thZ2VzKCJsZWFmbGV0IikKaWYoIXJlcXVpcmUobWFwcykpIGluc3RhbGwucGFja2FnZXMoIm1hcHMiKQppZighcmVxdWlyZShnZ3Bsb3QyKSkgaW5zdGFsbC5wYWNrYWdlcygiZ2dwbG90MiIpCmlmKCFyZXF1aXJlKGhpZ2hjaGFydGVyKSkgaW5zdGFsbC5wYWNrYWdlcygiaGlnaGNoYXJ0ZXIiKQoKY3BzPC1yZWFkLmNzdihmaWxlPSJkYXRhL2Nwcy5jc3YiKQpjcHMkU2FmZXR5LlNjb3JlIDwtIGNwcyRTYWZldHkuU2NvcmUvMTAKY3BzJENvbG9yIDwtIHJlcCgiZ3JlZW4iLCBucm93KGNwcykpCmNwcyRDb2xvclshaXMubmEoY3BzJFNhZmV0eS5TY29yZSldIDwtIHJnYigxLShjcHMkU2FmZXR5LlNjb3JlWyFpcy5uYShjcHMkU2FmZXR5LlNjb3JlKV0vMTApLDAsIGNwcyRTYWZldHkuU2NvcmVbIWlzLm5hKGNwcyRTYWZldHkuU2NvcmUpXS8xMCkKCmBgYAoKCmBgYHtyfQptYXBDUFMgPSBsZWFmbGV0KGNwcykgJT4lIAogIHNldFZpZXcobG5nID0gLTg3LjYyOTgsIGxhdCA9IDQxLjg3ODEsIHpvb20gPSAxMikgJT4lCiAgYWRkVGlsZXMoKSAlPiUgCiAgYWRkQ2lyY2xlTWFya2Vycyhsbmc9IH5Mb25naXR1ZGUsbGF0ID0gfkxhdGl0dWRlLCByYWRpdXM9flNhZmV0eS5TY29yZSwgY29sPX5Db2xvcikKCm1hcENQUwpgYGAKCmBgYHtyfQoKY3BzJFNhZmV0eS5JY29uPC1mYWN0b3IoY3BzJFNhZmV0eS5JY29uLCAKICAgICAgICAgICAgICAgICAgICAgICAgbGV2ZWxzPWMoIlZlcnkgV2VhayIsICJXZWFrIiwgIkF2ZXJhZ2UiLCAiU3Ryb25nIiwgIlZlcnkgU3Ryb25nIiwgIk5EQSIpKQoKaGNoYXJ0KAogIGNwc1shaXMubmEoY3BzJFNhZmV0eS5TY29yZSkgJiAhaXMubmEoY3BzJEVudmlyb25tZW50LlNjb3JlKSxdLCAKICAic2NhdHRlciIsIGhjYWVzKHg9U2FmZXR5LlNjb3JlLCB5PUVudmlyb25tZW50LlNjb3JlLCBncm91cD1TYWZldHkuSWNvbikpICU+JQogIGhjX3RpdGxlKHRleHQ9IlNhZmV0eSBTY29yZSBhbmQgRW52aXJvbm1lbnQgU2NvcmUgZ3JvdXBlZCBieSBTYWZldHkgSWNvbiIKICApCgpgYGAKCmBgYHtyfQpjcHMkQXZlcmFnZS5TdHVkZW50LkF0dGVuZGFuY2U8LWFzLm51bWVyaWMoc3ViKCIlIiwiIixjcHMkQXZlcmFnZS5TdHVkZW50LkF0dGVuZGFuY2UpKQpjcHMkQXZlcmFnZS5UZWFjaGVyLkF0dGVuZGFuY2U8LWFzLm51bWVyaWMoc3ViKCIlIiwiIixjcHMkQXZlcmFnZS5UZWFjaGVyLkF0dGVuZGFuY2UpKQpjcHMkQXZlcmFnZS5UZWFjaGVyLkF0dGVuZGFuY2VbY3BzJEF2ZXJhZ2UuVGVhY2hlci5BdHRlbmRhbmNlPT0wXSA8LSBOQQoKaGNoYXJ0KGNwcywgInNjYXR0ZXIiLCBoY2Flcyh4PUF2ZXJhZ2UuU3R1ZGVudC5BdHRlbmRhbmNlLCB5PUF2ZXJhZ2UuVGVhY2hlci5BdHRlbmRhbmNlKSkKYGBgCgo=