Download and extract data about CPS lead tests

lead_tests.py

import subprocess
import sys
from io import StringIO
import csv

if __name__ == "__main__":
    
    proc = subprocess.Popen(['java', 
                             '-jar', 
                             '../tabula-java/target/tabula-0.9.0-jar-with-dependencies.jar',
                             '--pages', 
                             'all', 
                             '-r',
                             'Individualschool_Beasley.pdf'], stdout=subprocess.PIPE)

    output, error = proc.communicate()

    output_string = output.decode('utf-8')
    
    begin = output_string.find('Sample ID')
    end = output_string.find('EPA ACTION LEVEL')
    
    part_we_want = output_string[begin:end]
    first_part = output_string[:begin]

    print(first_part)

    reader = csv.reader(StringIO(part_we_want))
    
    with open('beasley.csv', 'w') as f:
        writer = csv.writer(f)
        writer.writerows(reader)