{ "cells": [ { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [], "source": [ "from __future__ import print_function, division\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [], "source": [ "bp_data = pd.read_csv(\"FL_insurance_sample.csv\")" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
policyIDstatecodecountyeq_site_limithu_site_limitfl_site_limitfr_site_limittiv_2011tiv_2012eq_site_deductiblehu_site_deductiblefl_site_deductiblefr_site_deductiblepoint_latitudepoint_longitudelineconstructionpoint_granularity
0119736FLCLAY COUNTY498960.0498960.00498960.0498960.0498960.00792148.900.09979.20.0030.102261-81.711777ResidentialMasonry1
1448094FLCLAY COUNTY1322376.31322376.301322376.31322376.31322376.301438163.570.00.00.0030.063936-81.707664ResidentialMasonry3
2206893FLCLAY COUNTY190724.4190724.40190724.4190724.4190724.40192476.780.00.00.0030.089579-81.700455ResidentialWood1
3333743FLCLAY COUNTY0.079520.760.00.079520.7686854.480.00.00.0030.063236-81.707703ResidentialWood3
4172534FLCLAY COUNTY0.0254281.500.0254281.5254281.50246144.490.00.00.0030.060614-81.702675ResidentialWood1
5785275FLCLAY COUNTY0.0515035.620.00.0515035.62884419.170.00.00.0030.063236-81.707703ResidentialMasonry3
6995932FLCLAY COUNTY0.019260000.000.00.019260000.0020610000.000.00.00.0030.102226-81.713882CommercialReinforced Concrete1
7223488FLCLAY COUNTY328500.0328500.00328500.0328500.0328500.00348374.250.016425.00.0030.102217-81.707146ResidentialWood1
8433512FLCLAY COUNTY315000.0315000.00315000.0315000.0315000.00265821.570.015750.00.0030.118774-81.704613ResidentialWood1
9142071FLCLAY COUNTY705600.0705600.00705600.0705600.0705600.001010842.5614112.035280.00.0030.100628-81.703751ResidentialMasonry1
10253816FLCLAY COUNTY831498.3831498.30831498.3831498.3831498.301117791.480.00.00.0030.102160-81.719444ResidentialMasonry1
11894922FLCLAY COUNTY0.024059.090.00.024059.0933952.190.00.00.0030.095957-81.695099ResidentialWood1
12422834FLCLAY COUNTY0.048115.940.00.048115.9466755.390.00.00.0030.100073-81.739822ResidentialWood1
13582721FLCLAY COUNTY0.028869.120.00.028869.1242826.990.00.00.0030.092480-81.725167ResidentialWood1
14842700FLCLAY COUNTY0.056135.640.00.056135.6450656.800.00.00.0030.101356-81.726248ResidentialWood1
15874333FLCLAY COUNTY0.048115.940.00.048115.9467905.070.00.00.0030.113743-81.727463ResidentialWood1
16580146FLCLAY COUNTY0.048115.940.00.048115.9466938.900.00.00.0030.121655-81.732391ResidentialWood3
17456149FLCLAY COUNTY0.080192.490.00.080192.4986421.040.00.00.0030.109537-81.741661ResidentialWood1
18767862FLCLAY COUNTY0.048115.940.00.048115.9473798.500.00.00.0030.118240-81.745335ResidentialWood3
19353022FLCLAY COUNTY0.060946.790.00.060946.7962467.290.00.00.0030.065799-81.717416ResidentialWood1
20367814FLCLAY COUNTY0.028869.120.00.028869.1242727.740.00.00.0030.082993-81.710581ResidentialWood1
21671392FLCLAY COUNTY0.013410000.000.00.013410000.0011700000.000.00.00.0030.091921-81.711929CommercialReinforced Concrete3
22772887FLCLAY COUNTY0.01669113.930.00.01669113.932099127.760.00.00.0030.117352-81.711884ResidentialMasonry1
23983122FLCLAY COUNTY0.0179562.230.00.0179562.23211372.570.00.00.0030.095783-81.713181ResidentialWood3
24934215FLCLAY COUNTY0.0177744.160.00.0177744.16157171.160.00.00.0030.110518-81.727478ResidentialWood1
25385951FLCLAY COUNTY0.017757.580.00.017757.5816948.720.00.00.0030.102880-81.705719ResidentialWood1
26716332FLCLAY COUNTY0.0130129.870.00.0130129.87101758.430.00.00.0030.068468-81.716240ResidentialWood1
27751262FLCLAY COUNTY0.042854.770.00.042854.7763592.880.00.00.0030.068468-81.716240ResidentialWood1
28633663FLCLAY COUNTY0.0785.580.00.0785.58662.180.00.00.0030.068468-81.716240ResidentialWood1
29105851FLCLAY COUNTY0.0170361.910.00.0170361.91177176.380.00.00.0030.068468-81.716240ResidentialWood1
.........................................................
36604792963FLPINELLAS COUNTY0.0492483.920.00.0492483.92631451.060.00.00.0028.063780-82.702550ResidentialMasonry1
36605367030FLPINELLAS COUNTY0.0954000.000.0954000.0954000.001572497.280.047700.00.0028.041555-82.669777ResidentialMasonry1
36606594660FLPINELLAS COUNTY0.0900000.000.0900000.0900000.00811814.400.027000.00.0028.040613-82.668579ResidentialMasonry1
36607360785FLPINELLAS COUNTY0.01093500.000.01093500.01093500.001534191.440.032805.00.0028.048200-82.681200ResidentialMasonry4
36608847570FLPINELLAS COUNTY0.0436632.300.00.0436632.30688459.980.00.00.0028.056019-82.763885ResidentialMasonry3
36609196088FLPINELLAS COUNTY1917403.21917403.201917403.21917403.21917403.203302918.750.00.00.0028.081780-82.748710CommercialReinforced Masonry1
36610166064FLPINELLAS COUNTY1392346.81392346.801392346.81392346.81392346.801361819.600.00.00.0028.081780-82.748710ResidentialMasonry1
36611507269FLPINELLAS COUNTY1175310.01175310.001175310.01175310.01175310.001521291.880.00.00.0028.053280-82.745920ResidentialMasonry1
36612335445FLPINELLAS COUNTY47250.947250.9047250.947250.947250.9037895.600.00.00.0028.081780-82.748710ResidentialWood1
36613451921FLPINELLAS COUNTY18630.018630.0018630.018630.018630.0021790.390.00.00.0028.081780-82.748710ResidentialWood1
36614859202FLPINELLAS COUNTY9450.09450.009450.09450.09450.009577.310.00.00.0028.053280-82.745920ResidentialWood1
36615584224FLPINELLAS COUNTY0.0866904.300.0866904.3866904.301329858.940.00.00.0028.122885-82.770218ResidentialMasonry3
36616603769FLPINELLAS COUNTY0.01541972.700.01541972.71541972.702064682.940.00.00.0028.122885-82.770218ResidentialMasonry3
36617575194FLPINELLAS COUNTY0.03759303.600.03759303.63759303.604209183.220.00.00.0028.122885-82.770218CommercialReinforced Masonry3
36618708726FLPINELLAS COUNTY0.0717846.300.0717846.3717846.301097387.430.00.00.0028.122885-82.770218ResidentialMasonry3
36619645213FLPINELLAS COUNTY0.01728847.800.01728847.81728847.801449908.580.00.00.0028.122885-82.770218ResidentialMasonry3
36620175829FLPINELLAS COUNTY0.024210000.000.024210000.024210000.0027000000.000.00.00.0028.122885-82.770218CommercialReinforced Concrete3
36621546178FLPINELLAS COUNTY0.01331880.300.01331880.31331880.301770812.110.00.00.0028.122885-82.770218ResidentialMasonry3
36622938910FLPINELLAS COUNTY0.035408.700.035408.735408.7051588.170.00.00.0028.122885-82.770218ResidentialWood3
36623592170FLPINELLAS COUNTY0.024574.500.024574.524574.5040907.700.00.00.0028.122885-82.770218ResidentialWood3
36624827844FLPINELLAS COUNTY0.038112.300.038112.338112.3052710.450.00.00.0028.122885-82.770218ResidentialWood3
36625876385FLPINELLAS COUNTY0.018312.300.018312.318312.3018575.810.00.00.0028.122885-82.770218ResidentialWood3
36626167630FLPINELLAS COUNTY0.04522.500.04522.54522.504048.110.00.00.0028.122885-82.770218ResidentialWood3
36627241496FLPINELLAS COUNTY0.01350.000.01350.01350.001430.160.00.00.0028.122885-82.770218ResidentialWood3
36628780814FLPINELLAS COUNTY0.09770.400.09770.49770.409349.980.00.00.0028.122885-82.770218ResidentialWood3
36629404309FLPINELLAS COUNTY0.088722.000.088722.088722.00155065.650.00.00.0028.122885-82.770218ResidentialWood3
36630465875FLPINELLAS COUNTY1297057.51297057.501297057.51297057.51297057.501577500.790.00.00.0028.080900-82.758800ResidentialMasonry1
36631791209FLPINELLAS COUNTY173286.9173286.900.00.0173286.90205527.970.00.00.0028.110550-82.766360ResidentialWood4
36632322627FLPINELLAS COUNTY1499781.61499781.600.00.01499781.601768782.430.00.00.0028.089415-82.697411ResidentialMasonry3
36633398149FLPINELLAS COUNTY373488.3373488.300.00.0373488.30596003.670.00.00.0028.064440-82.774590ResidentialMasonry1
\n", "

36634 rows × 18 columns

\n", "
" ], "text/plain": [ " policyID statecode county eq_site_limit hu_site_limit \\\n", "0 119736 FL CLAY COUNTY 498960.0 498960.00 \n", "1 448094 FL CLAY COUNTY 1322376.3 1322376.30 \n", "2 206893 FL CLAY COUNTY 190724.4 190724.40 \n", "3 333743 FL CLAY COUNTY 0.0 79520.76 \n", "4 172534 FL CLAY COUNTY 0.0 254281.50 \n", "5 785275 FL CLAY COUNTY 0.0 515035.62 \n", "6 995932 FL CLAY COUNTY 0.0 19260000.00 \n", "7 223488 FL CLAY COUNTY 328500.0 328500.00 \n", "8 433512 FL CLAY COUNTY 315000.0 315000.00 \n", "9 142071 FL CLAY COUNTY 705600.0 705600.00 \n", "10 253816 FL CLAY COUNTY 831498.3 831498.30 \n", "11 894922 FL CLAY COUNTY 0.0 24059.09 \n", "12 422834 FL CLAY COUNTY 0.0 48115.94 \n", "13 582721 FL CLAY COUNTY 0.0 28869.12 \n", "14 842700 FL CLAY COUNTY 0.0 56135.64 \n", "15 874333 FL CLAY COUNTY 0.0 48115.94 \n", "16 580146 FL CLAY COUNTY 0.0 48115.94 \n", "17 456149 FL CLAY COUNTY 0.0 80192.49 \n", "18 767862 FL CLAY COUNTY 0.0 48115.94 \n", "19 353022 FL CLAY COUNTY 0.0 60946.79 \n", "20 367814 FL CLAY COUNTY 0.0 28869.12 \n", "21 671392 FL CLAY COUNTY 0.0 13410000.00 \n", "22 772887 FL CLAY COUNTY 0.0 1669113.93 \n", "23 983122 FL CLAY COUNTY 0.0 179562.23 \n", "24 934215 FL CLAY COUNTY 0.0 177744.16 \n", "25 385951 FL CLAY COUNTY 0.0 17757.58 \n", "26 716332 FL CLAY COUNTY 0.0 130129.87 \n", "27 751262 FL CLAY COUNTY 0.0 42854.77 \n", "28 633663 FL CLAY COUNTY 0.0 785.58 \n", "29 105851 FL CLAY COUNTY 0.0 170361.91 \n", "... ... ... ... ... ... \n", "36604 792963 FL PINELLAS COUNTY 0.0 492483.92 \n", "36605 367030 FL PINELLAS COUNTY 0.0 954000.00 \n", "36606 594660 FL PINELLAS COUNTY 0.0 900000.00 \n", "36607 360785 FL PINELLAS COUNTY 0.0 1093500.00 \n", "36608 847570 FL PINELLAS COUNTY 0.0 436632.30 \n", "36609 196088 FL PINELLAS COUNTY 1917403.2 1917403.20 \n", "36610 166064 FL PINELLAS COUNTY 1392346.8 1392346.80 \n", "36611 507269 FL PINELLAS COUNTY 1175310.0 1175310.00 \n", "36612 335445 FL PINELLAS COUNTY 47250.9 47250.90 \n", "36613 451921 FL PINELLAS COUNTY 18630.0 18630.00 \n", "36614 859202 FL PINELLAS COUNTY 9450.0 9450.00 \n", "36615 584224 FL PINELLAS COUNTY 0.0 866904.30 \n", "36616 603769 FL PINELLAS COUNTY 0.0 1541972.70 \n", "36617 575194 FL PINELLAS COUNTY 0.0 3759303.60 \n", "36618 708726 FL PINELLAS COUNTY 0.0 717846.30 \n", "36619 645213 FL PINELLAS COUNTY 0.0 1728847.80 \n", "36620 175829 FL PINELLAS COUNTY 0.0 24210000.00 \n", "36621 546178 FL PINELLAS COUNTY 0.0 1331880.30 \n", "36622 938910 FL PINELLAS COUNTY 0.0 35408.70 \n", "36623 592170 FL PINELLAS COUNTY 0.0 24574.50 \n", "36624 827844 FL PINELLAS COUNTY 0.0 38112.30 \n", "36625 876385 FL PINELLAS COUNTY 0.0 18312.30 \n", "36626 167630 FL PINELLAS COUNTY 0.0 4522.50 \n", "36627 241496 FL PINELLAS COUNTY 0.0 1350.00 \n", "36628 780814 FL PINELLAS COUNTY 0.0 9770.40 \n", "36629 404309 FL PINELLAS COUNTY 0.0 88722.00 \n", "36630 465875 FL PINELLAS COUNTY 1297057.5 1297057.50 \n", "36631 791209 FL PINELLAS COUNTY 173286.9 173286.90 \n", "36632 322627 FL PINELLAS COUNTY 1499781.6 1499781.60 \n", "36633 398149 FL PINELLAS COUNTY 373488.3 373488.30 \n", "\n", " fl_site_limit fr_site_limit tiv_2011 tiv_2012 \\\n", "0 498960.0 498960.0 498960.00 792148.90 \n", "1 1322376.3 1322376.3 1322376.30 1438163.57 \n", "2 190724.4 190724.4 190724.40 192476.78 \n", "3 0.0 0.0 79520.76 86854.48 \n", "4 0.0 254281.5 254281.50 246144.49 \n", "5 0.0 0.0 515035.62 884419.17 \n", "6 0.0 0.0 19260000.00 20610000.00 \n", "7 328500.0 328500.0 328500.00 348374.25 \n", "8 315000.0 315000.0 315000.00 265821.57 \n", "9 705600.0 705600.0 705600.00 1010842.56 \n", "10 831498.3 831498.3 831498.30 1117791.48 \n", "11 0.0 0.0 24059.09 33952.19 \n", "12 0.0 0.0 48115.94 66755.39 \n", "13 0.0 0.0 28869.12 42826.99 \n", "14 0.0 0.0 56135.64 50656.80 \n", "15 0.0 0.0 48115.94 67905.07 \n", "16 0.0 0.0 48115.94 66938.90 \n", "17 0.0 0.0 80192.49 86421.04 \n", "18 0.0 0.0 48115.94 73798.50 \n", "19 0.0 0.0 60946.79 62467.29 \n", "20 0.0 0.0 28869.12 42727.74 \n", "21 0.0 0.0 13410000.00 11700000.00 \n", "22 0.0 0.0 1669113.93 2099127.76 \n", "23 0.0 0.0 179562.23 211372.57 \n", "24 0.0 0.0 177744.16 157171.16 \n", "25 0.0 0.0 17757.58 16948.72 \n", "26 0.0 0.0 130129.87 101758.43 \n", "27 0.0 0.0 42854.77 63592.88 \n", "28 0.0 0.0 785.58 662.18 \n", "29 0.0 0.0 170361.91 177176.38 \n", "... ... ... ... ... \n", "36604 0.0 0.0 492483.92 631451.06 \n", "36605 0.0 954000.0 954000.00 1572497.28 \n", "36606 0.0 900000.0 900000.00 811814.40 \n", "36607 0.0 1093500.0 1093500.00 1534191.44 \n", "36608 0.0 0.0 436632.30 688459.98 \n", "36609 1917403.2 1917403.2 1917403.20 3302918.75 \n", "36610 1392346.8 1392346.8 1392346.80 1361819.60 \n", "36611 1175310.0 1175310.0 1175310.00 1521291.88 \n", "36612 47250.9 47250.9 47250.90 37895.60 \n", "36613 18630.0 18630.0 18630.00 21790.39 \n", "36614 9450.0 9450.0 9450.00 9577.31 \n", "36615 0.0 866904.3 866904.30 1329858.94 \n", "36616 0.0 1541972.7 1541972.70 2064682.94 \n", "36617 0.0 3759303.6 3759303.60 4209183.22 \n", "36618 0.0 717846.3 717846.30 1097387.43 \n", "36619 0.0 1728847.8 1728847.80 1449908.58 \n", "36620 0.0 24210000.0 24210000.00 27000000.00 \n", "36621 0.0 1331880.3 1331880.30 1770812.11 \n", "36622 0.0 35408.7 35408.70 51588.17 \n", "36623 0.0 24574.5 24574.50 40907.70 \n", "36624 0.0 38112.3 38112.30 52710.45 \n", "36625 0.0 18312.3 18312.30 18575.81 \n", "36626 0.0 4522.5 4522.50 4048.11 \n", "36627 0.0 1350.0 1350.00 1430.16 \n", "36628 0.0 9770.4 9770.40 9349.98 \n", "36629 0.0 88722.0 88722.00 155065.65 \n", "36630 1297057.5 1297057.5 1297057.50 1577500.79 \n", "36631 0.0 0.0 173286.90 205527.97 \n", "36632 0.0 0.0 1499781.60 1768782.43 \n", "36633 0.0 0.0 373488.30 596003.67 \n", "\n", " eq_site_deductible hu_site_deductible fl_site_deductible \\\n", "0 0.0 9979.2 0.0 \n", "1 0.0 0.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "5 0.0 0.0 0.0 \n", "6 0.0 0.0 0.0 \n", "7 0.0 16425.0 0.0 \n", "8 0.0 15750.0 0.0 \n", "9 14112.0 35280.0 0.0 \n", "10 0.0 0.0 0.0 \n", "11 0.0 0.0 0.0 \n", "12 0.0 0.0 0.0 \n", "13 0.0 0.0 0.0 \n", "14 0.0 0.0 0.0 \n", "15 0.0 0.0 0.0 \n", "16 0.0 0.0 0.0 \n", "17 0.0 0.0 0.0 \n", "18 0.0 0.0 0.0 \n", "19 0.0 0.0 0.0 \n", "20 0.0 0.0 0.0 \n", "21 0.0 0.0 0.0 \n", "22 0.0 0.0 0.0 \n", "23 0.0 0.0 0.0 \n", "24 0.0 0.0 0.0 \n", "25 0.0 0.0 0.0 \n", "26 0.0 0.0 0.0 \n", "27 0.0 0.0 0.0 \n", "28 0.0 0.0 0.0 \n", "29 0.0 0.0 0.0 \n", "... ... ... ... \n", "36604 0.0 0.0 0.0 \n", "36605 0.0 47700.0 0.0 \n", "36606 0.0 27000.0 0.0 \n", "36607 0.0 32805.0 0.0 \n", "36608 0.0 0.0 0.0 \n", "36609 0.0 0.0 0.0 \n", "36610 0.0 0.0 0.0 \n", "36611 0.0 0.0 0.0 \n", "36612 0.0 0.0 0.0 \n", "36613 0.0 0.0 0.0 \n", "36614 0.0 0.0 0.0 \n", "36615 0.0 0.0 0.0 \n", "36616 0.0 0.0 0.0 \n", "36617 0.0 0.0 0.0 \n", "36618 0.0 0.0 0.0 \n", "36619 0.0 0.0 0.0 \n", "36620 0.0 0.0 0.0 \n", "36621 0.0 0.0 0.0 \n", "36622 0.0 0.0 0.0 \n", "36623 0.0 0.0 0.0 \n", "36624 0.0 0.0 0.0 \n", "36625 0.0 0.0 0.0 \n", "36626 0.0 0.0 0.0 \n", "36627 0.0 0.0 0.0 \n", "36628 0.0 0.0 0.0 \n", "36629 0.0 0.0 0.0 \n", "36630 0.0 0.0 0.0 \n", "36631 0.0 0.0 0.0 \n", "36632 0.0 0.0 0.0 \n", "36633 0.0 0.0 0.0 \n", "\n", " fr_site_deductible point_latitude point_longitude line \\\n", "0 0 30.102261 -81.711777 Residential \n", "1 0 30.063936 -81.707664 Residential \n", "2 0 30.089579 -81.700455 Residential \n", "3 0 30.063236 -81.707703 Residential \n", "4 0 30.060614 -81.702675 Residential \n", "5 0 30.063236 -81.707703 Residential \n", "6 0 30.102226 -81.713882 Commercial \n", "7 0 30.102217 -81.707146 Residential \n", "8 0 30.118774 -81.704613 Residential \n", "9 0 30.100628 -81.703751 Residential \n", "10 0 30.102160 -81.719444 Residential \n", "11 0 30.095957 -81.695099 Residential \n", "12 0 30.100073 -81.739822 Residential \n", "13 0 30.092480 -81.725167 Residential \n", "14 0 30.101356 -81.726248 Residential \n", "15 0 30.113743 -81.727463 Residential \n", "16 0 30.121655 -81.732391 Residential \n", "17 0 30.109537 -81.741661 Residential \n", "18 0 30.118240 -81.745335 Residential \n", "19 0 30.065799 -81.717416 Residential \n", "20 0 30.082993 -81.710581 Residential \n", "21 0 30.091921 -81.711929 Commercial \n", "22 0 30.117352 -81.711884 Residential \n", "23 0 30.095783 -81.713181 Residential \n", "24 0 30.110518 -81.727478 Residential \n", "25 0 30.102880 -81.705719 Residential \n", "26 0 30.068468 -81.716240 Residential \n", "27 0 30.068468 -81.716240 Residential \n", "28 0 30.068468 -81.716240 Residential \n", "29 0 30.068468 -81.716240 Residential \n", "... ... ... ... ... \n", "36604 0 28.063780 -82.702550 Residential \n", "36605 0 28.041555 -82.669777 Residential \n", "36606 0 28.040613 -82.668579 Residential \n", "36607 0 28.048200 -82.681200 Residential \n", "36608 0 28.056019 -82.763885 Residential \n", "36609 0 28.081780 -82.748710 Commercial \n", "36610 0 28.081780 -82.748710 Residential \n", "36611 0 28.053280 -82.745920 Residential \n", "36612 0 28.081780 -82.748710 Residential \n", "36613 0 28.081780 -82.748710 Residential \n", "36614 0 28.053280 -82.745920 Residential \n", "36615 0 28.122885 -82.770218 Residential \n", "36616 0 28.122885 -82.770218 Residential \n", "36617 0 28.122885 -82.770218 Commercial \n", "36618 0 28.122885 -82.770218 Residential \n", "36619 0 28.122885 -82.770218 Residential \n", "36620 0 28.122885 -82.770218 Commercial \n", "36621 0 28.122885 -82.770218 Residential \n", "36622 0 28.122885 -82.770218 Residential \n", "36623 0 28.122885 -82.770218 Residential \n", "36624 0 28.122885 -82.770218 Residential \n", "36625 0 28.122885 -82.770218 Residential \n", "36626 0 28.122885 -82.770218 Residential \n", "36627 0 28.122885 -82.770218 Residential \n", "36628 0 28.122885 -82.770218 Residential \n", "36629 0 28.122885 -82.770218 Residential \n", "36630 0 28.080900 -82.758800 Residential \n", "36631 0 28.110550 -82.766360 Residential \n", "36632 0 28.089415 -82.697411 Residential \n", "36633 0 28.064440 -82.774590 Residential \n", "\n", " construction point_granularity \n", "0 Masonry 1 \n", "1 Masonry 3 \n", "2 Wood 1 \n", "3 Wood 3 \n", "4 Wood 1 \n", "5 Masonry 3 \n", "6 Reinforced Concrete 1 \n", "7 Wood 1 \n", "8 Wood 1 \n", "9 Masonry 1 \n", "10 Masonry 1 \n", "11 Wood 1 \n", "12 Wood 1 \n", "13 Wood 1 \n", "14 Wood 1 \n", "15 Wood 1 \n", "16 Wood 3 \n", "17 Wood 1 \n", "18 Wood 3 \n", "19 Wood 1 \n", "20 Wood 1 \n", "21 Reinforced Concrete 3 \n", "22 Masonry 1 \n", "23 Wood 3 \n", "24 Wood 1 \n", "25 Wood 1 \n", "26 Wood 1 \n", "27 Wood 1 \n", "28 Wood 1 \n", "29 Wood 1 \n", "... ... ... \n", "36604 Masonry 1 \n", "36605 Masonry 1 \n", "36606 Masonry 1 \n", "36607 Masonry 4 \n", "36608 Masonry 3 \n", "36609 Reinforced Masonry 1 \n", "36610 Masonry 1 \n", "36611 Masonry 1 \n", "36612 Wood 1 \n", "36613 Wood 1 \n", "36614 Wood 1 \n", "36615 Masonry 3 \n", "36616 Masonry 3 \n", "36617 Reinforced Masonry 3 \n", "36618 Masonry 3 \n", "36619 Masonry 3 \n", "36620 Reinforced Concrete 3 \n", "36621 Masonry 3 \n", "36622 Wood 3 \n", "36623 Wood 3 \n", "36624 Wood 3 \n", "36625 Wood 3 \n", "36626 Wood 3 \n", "36627 Wood 3 \n", "36628 Wood 3 \n", "36629 Wood 3 \n", "36630 Masonry 1 \n", "36631 Wood 4 \n", "36632 Masonry 3 \n", "36633 Masonry 1 \n", "\n", "[36634 rows x 18 columns]" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "bp_data" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [], "source": [ "bp_data.to_excel('test.xlsx',index=False)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.3" } }, "nbformat": 4, "nbformat_minor": 2 }