Find the ACS variable for the Percent Vacant housing units for 2011 and 2019 for Harris County, TX

v11_Profile[grep(x = v11_Profile$label,
                 "VACANT HOUSING",
                 ignore.case = TRUE), 
            c("name", "label")]
v19_Profile[grep(x = v19_Profile$label,
                 "VACANT HOUSING",
                 ignore.case = TRUE), 
            c("name", "label")]

Create a map using quantile breaks of this variable for each year

Calculate the differences between the two years, including the test for significance of the differences

head(differences11to19)
table(differences11to19$result)
## 
## insignificant change significant decrease significant increase 
##                  393                  257                  101
## Compare to tidycensus

table(merged_vacant$signif)
## 
## FALSE  TRUE 
##   393   358

Create a map showing the differences by census tract

LS0tDQp0aXRsZTogIjcwOTNfSFc0Ig0KYXV0aG9yOiAiUnlhbiBMYWJpbyINCmRhdGU6ICIyLzE2LzIwMjIiDQpvdXRwdXQ6DQogICBodG1sX2RvY3VtZW50Og0KICAgIGRmX3ByaW50OiBwYWdlZA0KICAgIGZpZ19oZWlnaHQ6IDcNCiAgICBmaWdfd2lkdGg6IDcNCiAgICB0b2M6IHllcw0KICAgIHRvY19mbG9hdDogeWVzDQogICAgY29kZV9kb3dubG9hZDogdHJ1ZQ0KLS0tDQoNCiMjIEZpbmQgdGhlIEFDUyB2YXJpYWJsZSBmb3IgdGhlIFBlcmNlbnQgVmFjYW50IGhvdXNpbmcgdW5pdHMgZm9yIDIwMTEgYW5kIDIwMTkgZm9yIEhhcnJpcyBDb3VudHksIFRYDQoNCmBgYHtyLCByZXN1bHRzPSJoaWRlIiwgbWVzc2FnZT1GQUxTRSwgZWNobz1GQUxTRX0NCg0KbGlicmFyeSh0aWR5Y2Vuc3VzKQ0KbGlicmFyeSh0aWR5dmVyc2UpDQpsaWJyYXJ5KHNmKQ0KbGlicmFyeSh0bWFwKQ0KDQp2MTFfUHJvZmlsZSA8LSBsb2FkX3ZhcmlhYmxlcygyMDExLA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgImFjczUvcHJvZmlsZSIsDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjYWNoZSA9IFRSVUUpDQoNCnYxOV9Qcm9maWxlIDwtIGxvYWRfdmFyaWFibGVzKDIwMTksDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiYWNzNS9wcm9maWxlIiwNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNhY2hlID0gVFJVRSkgDQpgYGANCg0KYGBge3J9DQoNCnYxMV9Qcm9maWxlW2dyZXAoeCA9IHYxMV9Qcm9maWxlJGxhYmVsLA0KICAgICAgICAgICAgICAgICAiVkFDQU5UIEhPVVNJTkciLA0KICAgICAgICAgICAgICAgICBpZ25vcmUuY2FzZSA9IFRSVUUpLCANCiAgICAgICAgICAgIGMoIm5hbWUiLCAibGFiZWwiKV0NCg0KdjE5X1Byb2ZpbGVbZ3JlcCh4ID0gdjE5X1Byb2ZpbGUkbGFiZWwsDQogICAgICAgICAgICAgICAgICJWQUNBTlQgSE9VU0lORyIsDQogICAgICAgICAgICAgICAgIGlnbm9yZS5jYXNlID0gVFJVRSksIA0KICAgICAgICAgICAgYygibmFtZSIsICJsYWJlbCIpXQ0KDQpgYGANCg0KIyMgQ3JlYXRlIGEgbWFwIHVzaW5nIHF1YW50aWxlIGJyZWFrcyBvZiB0aGlzIHZhcmlhYmxlIGZvciBlYWNoIHllYXINCg0KYGBge3IsIHJlc3VsdHM9ImhpZGUiLCBtZXNzYWdlPUZBTFNFLCBlY2hvPUZBTFNFfQ0KDQp2YWNhbnQxMTwtZ2V0X2FjcyhnZW9ncmFwaHkgPSAidHJhY3QiLA0KICAgICAgICAgICAgICAgIHN0YXRlPSJUWCIsDQogICAgICAgICAgICAgICAgY291bnR5ID0gIkhhcnJpcyBDb3VudHkiLA0KICAgICAgICAgICAgICAgIHllYXIgPSAyMDExLA0KICAgICAgICAgICAgICAgIHZhcmlhYmxlcz0iRFAwNF8wMDAzUCIgLA0KICAgICAgICAgICAgICAgIGdlb21ldHJ5ID0gVCwNCiAgICAgICAgICAgICAgICBvdXRwdXQgPSAid2lkZSIpDQoNCnZhY2FudDExIDwtIHZhY2FudDExICU+JQ0KICBtdXRhdGUocGN0X3ZhY2FudDExID0gRFAwNF8wMDAzUEUsDQogICAgICAgICBwY3RfdmFjYW50MTFfZXIgPSBEUDA0XzAwMDNQTS8xLjY0NSwNCiAgICAgICAgIHBjdF92YWNhbnQxMV9jdiA9IDEwMCAqIChwY3RfdmFjYW50MTFfZXIgLyBwY3RfdmFjYW50MTEpKSAlPiUNCiAgZmlsdGVyKGNvbXBsZXRlLmNhc2VzKHBjdF92YWNhbnQxMSksIGlzLmZpbml0ZShwY3RfdmFjYW50MTFfY3YpPT1UKSAlPiUNCiAgc2VsZWN0KEdFT0lELCBwY3RfdmFjYW50MTEsIHBjdF92YWNhbnQxMV9lciwgcGN0X3ZhY2FudDExX2N2KQ0KDQojIyBoZWFkKHZhY2FudDExKQ0KDQp0bV9zaGFwZSh2YWNhbnQxMSwgdW5pdD0ibWkiKSsNCiAgdG1fcG9seWdvbnMoYygicGN0X3ZhY2FudDExIiksDQogICAgICAgICAgICAgIHRpdGxlID0gYygiJSBWYWNhbnQgSG91c2luZyBVbml0cyIpLA0KICAgICAgICAgICAgICBwYWxldHRlID0gIlJlZHMiLA0KICAgICAgICAgICAgICBzdHlsZSA9ICJxdWFudGlsZSIsDQogICAgICAgICAgICAgIG4gPSA1KSsNCiAgdG1fbGF5b3V0KHRpdGxlPSIyMDExIEhhcnJpcyBDb3VudHkgSG91c2luZyBWYWNhbmN5IEVzdGltYXRlcyAtIFF1YW50aWxlIEJyZWFrcyIsDQogICAgICAgICAgICB0aXRsZS5zaXplID0gMS41LA0KICAgICAgICAgICAgbGVnZW5kLmZyYW1lID0gVFJVRSwNCiAgICAgICAgICAgIHRpdGxlLnBvc2l0aW9uID0gYygnY2VudGVyJywgJ1RPUCcpKSsNCiAgdG1fY29tcGFzcygpKw0KICB0bV9zY2FsZV9iYXIoKSsNCiAgdG1fZm9ybWF0KCJXb3JsZCIsDQogICAgICAgICAgICBsZWdlbmQucG9zaXRpb24gPSAgYygibGVmdCIsICJib3R0b20iKSkNCg0KYGBgDQoNCmBgYHtyLCByZXN1bHRzPSJoaWRlIiwgbWVzc2FnZT1GQUxTRSwgZWNobz1GQUxTRX0NCg0KdmFjYW50MTk8LWdldF9hY3MoZ2VvZ3JhcGh5ID0gInRyYWN0IiwNCiAgICAgICAgICAgICAgICBzdGF0ZT0iVFgiLA0KICAgICAgICAgICAgICAgIGNvdW50eSA9ICJIYXJyaXMgQ291bnR5IiwNCiAgICAgICAgICAgICAgICB5ZWFyID0gMjAxOSwNCiAgICAgICAgICAgICAgICB2YXJpYWJsZXM9IkRQMDRfMDAwM1AiICwNCiAgICAgICAgICAgICAgICBnZW9tZXRyeSA9IFQsDQogICAgICAgICAgICAgICAgb3V0cHV0ID0gIndpZGUiKQ0KDQp2YWNhbnQxOSA8LSB2YWNhbnQxOSAlPiUNCiAgbXV0YXRlKHBjdF92YWNhbnQxOSA9IERQMDRfMDAwM1BFLA0KICAgICAgICAgcGN0X3ZhY2FudDE5X2VyID0gRFAwNF8wMDAzUE0vMS42NDUsDQogICAgICAgICBwY3RfdmFjYW50MTlfY3YgPSAxMDAgKiAocGN0X3ZhY2FudDE5X2VyIC8gcGN0X3ZhY2FudDE5KSkgJT4lDQogIGZpbHRlcihjb21wbGV0ZS5jYXNlcyhwY3RfdmFjYW50MTkpLCBpcy5maW5pdGUocGN0X3ZhY2FudDE5X2N2KT09VCkgJT4lDQogIHNlbGVjdChHRU9JRCwgcGN0X3ZhY2FudDE5LCBwY3RfdmFjYW50MTlfZXIsIHBjdF92YWNhbnQxOV9jdikNCg0KIyMgaGVhZCh2YWNhbnQxOSkNCg0KdG1fc2hhcGUodmFjYW50MTksIHVuaXQ9Im1pIikrDQogIHRtX3BvbHlnb25zKGMoInBjdF92YWNhbnQxOSIpLA0KICAgICAgICAgICAgICB0aXRsZSA9IGMoIiUgVmFjYW50IEhvdXNpbmcgVW5pdHMiKSwNCiAgICAgICAgICAgICAgcGFsZXR0ZSA9ICJSZWRzIiwNCiAgICAgICAgICAgICAgc3R5bGUgPSAicXVhbnRpbGUiLA0KICAgICAgICAgICAgICBuID0gNSkrDQogIHRtX2xheW91dCh0aXRsZT0iMjAxOSBIYXJyaXMgQ291bnR5IEhvdXNpbmcgVmFjYW5jeSBFc3RpbWF0ZXMgLSBRdWFudGlsZSBCcmVha3MiLA0KICAgICAgICAgICAgdGl0bGUuc2l6ZSA9IDEuNSwNCiAgICAgICAgICAgIGxlZ2VuZC5mcmFtZSA9IFRSVUUsDQogICAgICAgICAgICB0aXRsZS5wb3NpdGlvbiA9IGMoJ2NlbnRlcicsICdUT1AnKSkrDQogIHRtX2NvbXBhc3MoKSsNCiAgdG1fc2NhbGVfYmFyKCkrDQogIHRtX2Zvcm1hdCgiV29ybGQiLA0KICAgICAgICAgICAgbGVnZW5kLnBvc2l0aW9uID0gIGMoImxlZnQiLCAiYm90dG9tIikpDQpgYGANCg0KIyMgQ2FsY3VsYXRlIHRoZSBkaWZmZXJlbmNlcyBiZXR3ZWVuIHRoZSB0d28geWVhcnMsIGluY2x1ZGluZyB0aGUgdGVzdCBmb3Igc2lnbmlmaWNhbmNlIG9mIHRoZSBkaWZmZXJlbmNlcw0KDQpgYGB7ciwgZWNobz1GQUxTRX0NCg0Kc3RfZ2VvbWV0cnkodmFjYW50MTkpIDwtIE5VTEwNCg0KbWVyZ2VkX3ZhY2FudCA8LSBsZWZ0X2pvaW4odmFjYW50MTEsIHZhY2FudDE5LCBieSA9IGMoIkdFT0lEIj0iR0VPSUQiKSkNCg0KIyMgaGVhZChtZXJnZWRfdmFjYW50KQ0KDQojIyBVc2luZyBEci4gU3BhcmtzJyBmdW5jdGlvbg0KDQphY3N0ZXN0PC1mdW5jdGlvbihuYW1lcyxnZW9pZCwgZXN0MSwgZXJyMSwgZXN0MiwgZXJyMiwgYWxwaGEsIHlyMSwgeXIyLCBzcGFuKXsNCiAgDQogIHNlMTwtZXJyMS9xbm9ybSguOTApDQogIHNlMjwtZXJyMi9xbm9ybSguOTApDQogIHlyczE8LXNlcSh5cjEsIHRvPXlyMS1zcGFuKQ0KICB5cnMyPC1zZXEoeXIyLCB0bz15cjItc3BhbikNCg0KICBDPC1tZWFuKHlyczIlaW4leXJzMSkNCiAgZGlmZjwtIChlc3QxLWVzdDIpDQogIHRlc3Q8LShlc3QxLWVzdDIpIC8gKHNxcnQoMS1DKSpzcXJ0KHNlMV4yK3NlMl4yKSkNCiAgY3JpdDwtcW5vcm0oMS1hbHBoYS8yKQ0KICBwdmFsPC0xLXBub3JtKGFicyh0ZXN0KSkNCiAgcmVzdWx0PC1OVUxMDQogIHJlc3VsdFtwdmFsID4gYWxwaGFdPC0iaW5zaWduaWZpY2FudCBjaGFuZ2UiDQogIHJlc3VsdFtwdmFsIDwgYWxwaGEgJiB0ZXN0IDwgMF08LSAic2lnbmlmaWNhbnQgaW5jcmVhc2UiDQogIHJlc3VsdFtwdmFsIDwgYWxwaGEgJiB0ZXN0ID4gMF08LSJzaWduaWZpY2FudCBkZWNyZWFzZSIgDQogIA0KICBkYXRhLmZyYW1lKG5hbWU9bmFtZXMsZ2VvaWQ9Z2VvaWQsIGVzdDE9ZXN0MSwgZXN0Mj1lc3QyLCBzZTE9c2UxLCBzZTI9c2UyLGRpZmZlcmVuY2U9ZGlmZiwgdGVzdD10ZXN0LCByZXN1bHQ9cmVzdWx0LCBwdmFsPXB2YWwpDQp9DQoNCmRpZmZlcmVuY2VzMTF0bzE5IDwtIGFjc3Rlc3QobmFtZXMgPSBtZXJnZWRfdmFjYW50JEdFT0lELA0KICAgICAgICAgICAgICAgICAgICBnZW9pZCA9IG1lcmdlZF92YWNhbnQkR0VPSUQsDQogICAgICAgICAgICAgICAgICAgIGVzdDEgPSBtZXJnZWRfdmFjYW50JHBjdF92YWNhbnQxMSwNCiAgICAgICAgICAgICAgICAgICAgZXN0MiA9IG1lcmdlZF92YWNhbnQkcGN0X3ZhY2FudDE5LA0KICAgICAgICAgICAgICAgICAgICBlcnIxID0gbWVyZ2VkX3ZhY2FudCRwY3RfdmFjYW50MTFfZXIsDQogICAgICAgICAgICAgICAgICAgIGVycjIgPSBtZXJnZWRfdmFjYW50JHBjdF92YWNhbnQxOV9lciwNCiAgICAgICAgICAgICAgICAgICAgYWxwaGEgPSAuMSwNCiAgICAgICAgICAgICAgICAgICAgeXIxID0gMjAxMSwgeXIyID0gMjAxOSwNCiAgICAgICAgICAgICAgICAgICAgc3BhbiA9IDUpDQoNCmBgYA0KDQpgYGB7cn0NCg0KaGVhZChkaWZmZXJlbmNlczExdG8xOSkNCg0KdGFibGUoZGlmZmVyZW5jZXMxMXRvMTkkcmVzdWx0KQ0KDQpgYGANCg0KYGBge3IsIHJlc3VsdHM9ImhpZGUiLCBlY2hvPUZBTFNFfQ0KDQojIyBVc2luZyB0aWR5Y2Vuc3VzIHBhY2thZ2UNCg0Kc2lnbmlmaWNhbmNlKGVzdDEgPSBtZXJnZWRfdmFjYW50JHBjdF92YWNhbnQxMSwNCiAgICAgICAgICAgICBlc3QyID0gbWVyZ2VkX3ZhY2FudCRwY3RfdmFjYW50MTksDQogICAgICAgICAgICAgbW9lMSA9IG1lcmdlZF92YWNhbnQkcGN0X3ZhY2FudDExX2VyLA0KICAgICAgICAgICAgIG1vZTIgPSBtZXJnZWRfdmFjYW50JHBjdF92YWNhbnQxOV9lciwNCiAgICAgICAgICAgICBjbGV2ZWwgPSAuOSkNCg0KbWVyZ2VkX3ZhY2FudCRzaWduaWYgPC0gc2lnbmlmaWNhbmNlKGVzdDEgPSBtZXJnZWRfdmFjYW50JHBjdF92YWNhbnQxMSwNCiAgICAgICAgICAgICBlc3QyID0gbWVyZ2VkX3ZhY2FudCRwY3RfdmFjYW50MTksDQogICAgICAgICAgICAgbW9lMSA9IG1lcmdlZF92YWNhbnQkcGN0X3ZhY2FudDExX2VyLA0KICAgICAgICAgICAgIG1vZTIgPSBtZXJnZWRfdmFjYW50JHBjdF92YWNhbnQxOV9lciwNCiAgICAgICAgICAgICBjbGV2ZWwgPSAuOSkNCmBgYA0KDQpgYGB7cn0NCg0KIyMgQ29tcGFyZSB0byB0aWR5Y2Vuc3VzDQoNCnRhYmxlKG1lcmdlZF92YWNhbnQkc2lnbmlmKQ0KDQpgYGANCg0KIyMgQ3JlYXRlIGEgbWFwIHNob3dpbmcgdGhlIGRpZmZlcmVuY2VzIGJ5IGNlbnN1cyB0cmFjdA0KDQpgYGB7ciwgZWNobz1GQUxTRSwgIG1lc3NhZ2U9RkFMU0V9DQoNCm1lcmdlZDJfdmFjYW50IDwtIGxlZnRfam9pbihtZXJnZWRfdmFjYW50LCBkaWZmZXJlbmNlczExdG8xOSwgYnkgPSBjKCJHRU9JRCI9Imdlb2lkIikpDQoNCnRtYXBfbW9kZSgicGxvdCIpDQoNCm0xIDwtIHRtX3NoYXBlKG1lcmdlZDJfdmFjYW50LCB1bml0PSJtaSIpKw0KICB0bV9wb2x5Z29ucyhjKCJwY3RfdmFjYW50MTEiKSwNCiAgICAgICAgICAgICAgdGl0bGUgPSBjKCIlIFZhY2FudCBIb3VzaW5nIFVuaXRzIiksDQogICAgICAgICAgICAgIHBhbGV0dGUgPSAiUmVkcyIsDQogICAgICAgICAgICAgIHN0eWxlID0gInF1YW50aWxlIiwNCiAgICAgICAgICAgICAgbiA9IDUpKw0KICB0bV9sYXlvdXQodGl0bGU9IjIwMTEgSGFycmlzIENvdW50eSBIb3VzaW5nIFZhY2FuY3kgRXN0aW1hdGVzIC0gUXVhbnRpbGUgQnJlYWtzIiwNCiAgICAgICAgICAgIHRpdGxlLnNpemUgPSAxLjUsDQogICAgICAgICAgICBsZWdlbmQuZnJhbWUgPSBUUlVFLA0KICAgICAgICAgICAgdGl0bGUucG9zaXRpb24gPSBjKCdjZW50ZXInLCAnVE9QJykpKw0KICB0bV9jb21wYXNzKCkrDQogIHRtX3NjYWxlX2JhcigpKw0KICB0bV9mb3JtYXQoIldvcmxkIiwNCiAgICAgICAgICAgIGxlZ2VuZC5wb3NpdGlvbiA9ICBjKCJsZWZ0IiwgImJvdHRvbSIpKQ0KDQptMiA8LSB0bV9zaGFwZShtZXJnZWQyX3ZhY2FudCwgdW5pdD0ibWkiKSsNCiAgdG1fcG9seWdvbnMoYygicGN0X3ZhY2FudDE5IiksDQogICAgICAgICAgICAgIHRpdGxlID0gYygiJSBWYWNhbnQgSG91c2luZyBVbml0cyIpLA0KICAgICAgICAgICAgICBwYWxldHRlID0gIlJlZHMiLA0KICAgICAgICAgICAgICBzdHlsZSA9ICJxdWFudGlsZSIsDQogICAgICAgICAgICAgIG4gPSA1KSsNCiAgdG1fbGF5b3V0KHRpdGxlPSIyMDE5IEhhcnJpcyBDb3VudHkgSG91c2luZyBWYWNhbmN5IEVzdGltYXRlcyAtIFF1YW50aWxlIEJyZWFrcyIsDQogICAgICAgICAgICB0aXRsZS5zaXplID0gMS41LA0KICAgICAgICAgICAgbGVnZW5kLmZyYW1lID0gVFJVRSwNCiAgICAgICAgICAgIHRpdGxlLnBvc2l0aW9uID0gYygnY2VudGVyJywgJ1RPUCcpKSsNCiAgdG1fY29tcGFzcygpKw0KICB0bV9zY2FsZV9iYXIoKSsNCiAgdG1fZm9ybWF0KCJXb3JsZCIsDQogICAgICAgICAgICBsZWdlbmQucG9zaXRpb24gPSAgYygibGVmdCIsICJib3R0b20iKSkNCg0KbTMgPC0gdG1fc2hhcGUobWVyZ2VkMl92YWNhbnQsIHVuaXQ9Im1pIikrDQogIHRtX3BvbHlnb25zKGMoInJlc3VsdCIpLA0KICAgICAgICAgICAgICB0aXRsZSA9IGMoIkNoYW5nZXMiKSwNCiAgICAgICAgICAgICAgcGFsZXR0ZSA9ICJTZXQzIikrDQogIHRtX2xheW91dCh0aXRsZT0iSGFycmlzIENvdW50eSBIb3VzaW5nIFZhY2FuY3kgRXN0aW1hdGUgQ2hhbmdlcyAtIDIwMTEgdG8gMjAxOSIsDQogICAgICAgICAgICB0aXRsZS5zaXplID0gMS41LA0KICAgICAgICAgICAgbGVnZW5kLmZyYW1lID0gVFJVRSwNCiAgICAgICAgICAgIHRpdGxlLnBvc2l0aW9uID0gYygnY2VudGVyJywgJ1RPUCcpKSsNCiAgdG1fY29tcGFzcygpKw0KICB0bV9zY2FsZV9iYXIoKSsNCiAgdG1fZm9ybWF0KCJXb3JsZCIsDQogICAgICAgICAgICBsZWdlbmQucG9zaXRpb24gPSAgYygibGVmdCIsICJib3R0b20iKSkNCg0KDQp0bWFwX2FycmFuZ2UobTEsIG0yLCBtMywgbnJvdz0yKQ0KDQpgYGANCg==