Using tabulizer to extract tabular data from daily COVID-19 reports

steffilazerte · June 7, 2021, 3:33pm

rOpenSci package or resource used*

What did you do?

Used tabulizer to extract total cases, fatalities, hospitalizations, and tests from daily COVID-19 reports for Connecticut.

URL or code snippet for your use case*

github.com

davebraze/ct-covid19/blob/efc3afd6e86baf8ff7454f1d6a02d3e68feb6154/locals.R#L29

    
      
              ## force axis range to include 0
              if(limits[1] > 0) return(c(0, limits[2]))
              else return(limits)
          }
          
          
label_date <- function(variable, value) {
              ## formatted dates for use with ggplot2 facet_* functions
              strftime(unique(value), "%b %d")
          }
          
          
read_ctcovid_pdf <- function(covid.fname, town.table=TRUE) {
              ## extract data from CT COVID-19 daily reports (PDF files).
          
          
    if(FALSE) {
                  covid.fname <- covid.fnames[29]
                  town.table=TRUE
              }
          
          
    ## extract date from file metadata
              meta <- tabulizer::extract_metadata(covid.fname)

Sector

other

Twitter handle

@davidbraze

(Submitted by Steffi LaZerte on behalf of Dave Braze)

Topic		Replies	Views
tabulizer for parsing block-text from .pdf UseCases package , tabulizer	1	1408	February 1, 2020
Extraindo tabelas de documentos pdf em R com Tabulizer UseCases tabulizer , portuguese , português	0	1486	July 20, 2020
Visualize covid19 cases using rnaturalearth package UseCases package , rnaturalearth	0	1655	May 5, 2020
pdftools for parsing .pdf from a URL - public data mining UseCases package , pdftools	0	1619	February 15, 2020
Using pdftools, tabulizer, and writexl to simplify business information handling workflow UseCases writexl , pdftools , tabulizer	3	2284	August 30, 2019