Ernesto Gomez, September 11, 2017

Tidyverse, Reading Data, Applying Dplyr Magics, & Plotting

library(tidyverse)
NYChealth2 <- read_csv("/Users/ernesto/Documents/Advanced Analytics/Data/NYChealthdrug1.csv")%>%
rename(
                    "County" = Geo_NAME,
                    "poorhealth" = SE_T002_001,
                    "smokers" = SE_T011_001,
                    "drinkers" = SE_T011_002,
                    "teenbirth" = SE_NV008_001,
                    "HIV" = SE_NV008_003,
                    "chlamydia" = SE_NV008_002)%>%
select(County, poorhealth, smokers, drinkers, HIV, teenbirth, chlamydia)%>%
mutate(HIVchl=HIV+chlamydia)
head(NYChealth2)

Reported Poor Health and Smoking

ggplot(data = NYChealth2) + 
  geom_point(mapping = aes(x = poorhealth , y = smokers))

Variable Key:

T002_001: Adults that Report Fair or Poor Health

T011_001: Current Smokers (18 or Over)

T011_002: Current Drinkers (18 or Over)

NV008_001: Teen Birth Rates Per 100k

NV008_002: Chlamydia Rates Per 100k

NV008_003: HIV Rates Per 100k

LS0tCnRpdGxlOiAiSG9tZXdvcmsgIzIgLSBEUExZUiIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQojIyNFcm5lc3RvIEdvbWV6LCBTZXB0ZW1iZXIgMTEsIDIwMTcKI1RpZHl2ZXJzZSwgUmVhZGluZyBEYXRhLCBBcHBseWluZyBEcGx5ciBNYWdpY3MsICYgUGxvdHRpbmcKCgpgYGB7ciwgZWNobz1UUlVFLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQpsaWJyYXJ5KHRpZHl2ZXJzZSkKCk5ZQ2hlYWx0aDIgPC0gcmVhZF9jc3YoIi9Vc2Vycy9lcm5lc3RvL0RvY3VtZW50cy9BZHZhbmNlZCBBbmFseXRpY3MvRGF0YS9OWUNoZWFsdGhkcnVnMS5jc3YiKSU+JQpyZW5hbWUoCiAgICAgICAgICAgICAgICAgICAgIkNvdW50eSIgPSBHZW9fTkFNRSwKICAgICAgICAgICAgICAgICAgICAicG9vcmhlYWx0aCIgPSBTRV9UMDAyXzAwMSwKICAgICAgICAgICAgICAgICAgICAic21va2VycyIgPSBTRV9UMDExXzAwMSwKICAgICAgICAgICAgICAgICAgICAiZHJpbmtlcnMiID0gU0VfVDAxMV8wMDIsCiAgICAgICAgICAgICAgICAgICAgInRlZW5iaXJ0aCIgPSBTRV9OVjAwOF8wMDEsCiAgICAgICAgICAgICAgICAgICAgIkhJViIgPSBTRV9OVjAwOF8wMDMsCiAgICAgICAgICAgICAgICAgICAgImNobGFteWRpYSIgPSBTRV9OVjAwOF8wMDIpJT4lCnNlbGVjdChDb3VudHksIHBvb3JoZWFsdGgsIHNtb2tlcnMsIGRyaW5rZXJzLCBISVYsIHRlZW5iaXJ0aCwgY2hsYW15ZGlhKSU+JQptdXRhdGUoSElWY2hsPUhJVitjaGxhbXlkaWEpCgpoZWFkKE5ZQ2hlYWx0aDIpCmBgYAojUmVwb3J0ZWQgUG9vciBIZWFsdGggYW5kIFNtb2tpbmcKYGBge3J9CmdncGxvdChkYXRhID0gTllDaGVhbHRoMikgKyAKICBnZW9tX3BvaW50KG1hcHBpbmcgPSBhZXMoeCA9IHBvb3JoZWFsdGggLCB5ID0gc21va2VycykpCmBgYAoKCgojVmFyaWFibGUgS2V5OgoKIyMjVDAwMl8wMDE6IEFkdWx0cyB0aGF0IFJlcG9ydCBGYWlyIG9yIFBvb3IgSGVhbHRoCiMjI1QwMTFfMDAxOiBDdXJyZW50IFNtb2tlcnMgKDE4IG9yIE92ZXIpCiMjI1QwMTFfMDAyOiBDdXJyZW50IERyaW5rZXJzICgxOCBvciBPdmVyKQojIyNOVjAwOF8wMDE6IFRlZW4gQmlydGggUmF0ZXMgUGVyIDEwMGsKIyMjTlYwMDhfMDAyOiBDaGxhbXlkaWEgUmF0ZXMgUGVyIDEwMGsKIyMjTlYwMDhfMDAzOiBISVYgUmF0ZXMgUGVyIDEwMGsK