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