PDF to Excel - Brazilian data
Budget: $30 – $250 USD
I need data extracted from pdfs of the 1985 Brazilian Agricultural Census. I want Excel spreadsheets that correspond to each PDF file for each of three Brazilian states. Each Excel spreadsheet should have nine “sheets” that correspond to each category of data listed below.
The challenge is that in the census, these data are provided at four levels: 1) the total for the state, for 2) “meso” region within the state, 3) “micro” region within the state, and 4) municipality. I only need data at the municipality level. I do not want data at any other level.
I have included an edited image of one page from one of the pdfs that identifies the rows that I do NOT need from each table (the total for the state as well as the “meso” and the “micro” region totals). You can see that the “TOTAIS” (total) line is indented a great deal. The “meso” region is furthest to the left, then the “micro” region is indented a bit. The “municipal” totals are indented a bit more than the micro regions.
Each sheet in Excel should have a header row that corresponds to the terms across the header of the table in the pdf that starts each category. Each sheet should then have one row for each municipality that contains the data for that municipality.
From each pdf (each Brazilian state), I need the following data from the following categories extracted, cleaned and made into tables. These categories appear in each pdf, but at different pages. The categories are listed in the table of contents in each document. The ToC provides the page numbers for the start of each table that contains the data for that category. The tables may be longer than one page.
"Cleaning" means removing all periods after the names of municipalities and correction of spelling errors that arise from pdf conversion.
69. “Classe da atividade economica”
70. “Condição do produtor”
77. “Uso de fertilizantes e defensivos”
84. “Grupos de area total”
85. “Grupos de area de lavouras”
86. “Utilização das terras
87. “Pessoal ocupado”
92. “Máquinas e instrumentos agrícolas”
96. “Despesas, valor da produção e receitas”
The challenge is that in the census, these data are provided at four levels: 1) the total for the state, for 2) “meso” region within the state, 3) “micro” region within the state, and 4) municipality. I only need data at the municipality level. I do not want data at any other level.
I have included an edited image of one page from one of the pdfs that identifies the rows that I do NOT need from each table (the total for the state as well as the “meso” and the “micro” region totals). You can see that the “TOTAIS” (total) line is indented a great deal. The “meso” region is furthest to the left, then the “micro” region is indented a bit. The “municipal” totals are indented a bit more than the micro regions.
Each sheet in Excel should have a header row that corresponds to the terms across the header of the table in the pdf that starts each category. Each sheet should then have one row for each municipality that contains the data for that municipality.
From each pdf (each Brazilian state), I need the following data from the following categories extracted, cleaned and made into tables. These categories appear in each pdf, but at different pages. The categories are listed in the table of contents in each document. The ToC provides the page numbers for the start of each table that contains the data for that category. The tables may be longer than one page.
"Cleaning" means removing all periods after the names of municipalities and correction of spelling errors that arise from pdf conversion.
69. “Classe da atividade economica”
70. “Condição do produtor”
77. “Uso de fertilizantes e defensivos”
84. “Grupos de area total”
85. “Grupos de area de lavouras”
86. “Utilização das terras
87. “Pessoal ocupado”
92. “Máquinas e instrumentos agrícolas”
96. “Despesas, valor da produção e receitas”