get_bbls.py

# get bbls
import glob
import csv

def get_bbl(row):
    return row[69] + ','

# create file to store bbls
bbl_file = open('./all_bbls.csv', 'w')

# get all pluto csvs - change filepath as needed
list_of_files = glob.glob('./data/pluto/*.csv')

# iterate through files
for path in list_of_files:
    with open(path) as f:
        # ignore first line
        next(f)
        # handle file as CSV
        reader = csv.reader(f, delimiter=',', quotechar='"')
        # write bbl for each row
        for row in reader:
            bbl_file.write(get_bbl(row))

# close bbl_file
bbl_file.close()