S70 data

readme.md

Under the terms of schedules contracts, vendors must have > $25,000 in sales in a year. Based on data from https://ssq.gsa.gov/, it appears that more than 2150 vendors on Schedule 70 failed to meet this requirement in Fiscal Year 2015.

There are three files below:

• s70.csv - The raw data from the database
• s70.py - The python script that evaluates the data
• results.csv - The results of the python script.

large_vendors.R.ipynb

results.csv

s70.csv

s70.py

import csv
with open('s70.csv', 'r') as fp:
    fp.seek(0)
    rows = csv.reader(fp, delimiter=",", quotechar='"')
    results = []
    for row in rows:
        results.append({"name": row[0], "amount": int(row[1][1:].replace(",", ""))})

count = 0
for vendor in results:
    if vendor["amount"] < 25000:
        count += 1
        print (vendor, count)