Translating and integrating census population estimates

The US Census Bureau provides a large collection of data files, some of which are encoded separately or do not have an obvious means to integrate. Suppose that the files are located and need to be integrated to make some data-driven decisions using Census population estimates. The resultant files may be very useful to explore, but the user wants to get into visual representation and start considering things spatially and temporally. In this resource, the Jupyter notebook walks through a set of operations created to integrate Census population estimates with the known ESRI shapefile for the equivalent county-scales.