The primary purpose of this script was to collect data on prospective clients to filter uninsurable data points from the original CSV dataset. There were 3 metrics to remove clients: Property Square Footage, Property Present Use, and Property Title. If the following conditions were met, the property was considered uninsurable, and no mailers would be sent to that household.

1. Property with a square footage of less than 1000 sqft
2. Present Use includes an apartment/condo/business
3. Property title includes a mobile home or anything commercial(e.g enterprise)

The secondary purpose was to correct taxpayer names in the CSV dataset. The data input from SalesGenie would often mistakenly attach an address with the former owner of the property rather than the current owner. To correct this, I used King County Parcel Viewer, which contains the most recent data on home ownership in King County. The program searches each data point's address via URL and finds the current homeowner. After retrieving the data, the names are compared between the two data points. If there is a discrepancy, the more recent name replaces the former so that the new name is used for all advertising communications.

The result is a new CSV file with 7 new data points, which removes uninsurable clients.