Demonstration of reproducibly importing one table from a multi page adobe report (NCAI.pdf, attached), to generate summary statistics, and a calculated field (population change in ten years, by state), resulting in the attached DataFromPDF.xlsx file.
Follow along using the same query by saving NCAI.pdf into a folder named "data" on your C drive. Part B transforms the data into a map in addition to a pivot table and excel table.
