{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Exploring Customer Segmentation\n", "\n", "\n", "
\n", " | Customer ID | \n", "Referred a Friend | \n", "Number of Referrals | \n", "Tenure in Months | \n", "Offer | \n", "Phone Service | \n", "Avg Monthly Long Distance Charges | \n", "Multiple Lines | \n", "Internet Service | \n", "Internet Type | \n", "... | \n", "Latitude | \n", "Longitude | \n", "Population | \n", "Churn Value | \n", "CLTV | \n", "Churn Category | \n", "Churn Reason | \n", "Total Customer Svc Requests | \n", "Product/Service Issues Reported | \n", "Customer Satisfaction | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "8779-QRDMV | \n", "No | \n", "0 | \n", "1 | \n", "None | \n", "No | \n", "0.00 | \n", "No | \n", "Yes | \n", "Fiber Optic | \n", "... | \n", "34.023810 | \n", "-118.156582 | \n", "68701 | \n", "1 | \n", "5433 | \n", "Competitor | \n", "Competitor offered more data | \n", "5 | \n", "0 | \n", "NaN | \n", "
1 | \n", "7495-OOKFY | \n", "Yes | \n", "1 | \n", "8 | \n", "Offer E | \n", "Yes | \n", "48.85 | \n", "Yes | \n", "Yes | \n", "Cable | \n", "... | \n", "34.044271 | \n", "-118.185237 | \n", "55668 | \n", "1 | \n", "5302 | \n", "Competitor | \n", "Competitor made better offer | \n", "5 | \n", "0 | \n", "NaN | \n", "
2 | \n", "1658-BYGOY | \n", "No | \n", "0 | \n", "18 | \n", "Offer D | \n", "Yes | \n", "11.33 | \n", "Yes | \n", "Yes | \n", "Fiber Optic | \n", "... | \n", "34.108833 | \n", "-118.229715 | \n", "47534 | \n", "1 | \n", "3179 | \n", "Competitor | \n", "Competitor made better offer | \n", "1 | \n", "0 | \n", "NaN | \n", "
3 | \n", "4598-XLKNJ | \n", "Yes | \n", "1 | \n", "25 | \n", "Offer C | \n", "Yes | \n", "19.76 | \n", "No | \n", "Yes | \n", "Fiber Optic | \n", "... | \n", "33.936291 | \n", "-118.332639 | \n", "27778 | \n", "1 | \n", "5337 | \n", "Dissatisfaction | \n", "Limited range of services | \n", "1 | \n", "1 | \n", "2.0 | \n", "
4 | \n", "4846-WHAFZ | \n", "Yes | \n", "1 | \n", "37 | \n", "Offer C | \n", "Yes | \n", "6.33 | \n", "Yes | \n", "Yes | \n", "Cable | \n", "... | \n", "33.972119 | \n", "-118.020188 | \n", "26265 | \n", "1 | \n", "2793 | \n", "Price | \n", "Extra data charges | \n", "1 | \n", "0 | \n", "2.0 | \n", "
5 rows × 46 columns
\n", "\n", " | Number of Referrals | \n", "Tenure in Months | \n", "Avg Monthly Long Distance Charges | \n", "Avg Monthly GB Download | \n", "Monthly Charge | \n", "Total Regular Charges | \n", "Total Refunds | \n", "Total Extra Data Charges | \n", "Total Long Distance Charges | \n", "Age | \n", "Number of Dependents | \n", "Zip Code | \n", "Latitude | \n", "Longitude | \n", "Population | \n", "Churn Value | \n", "CLTV | \n", "Total Customer Svc Requests | \n", "Product/Service Issues Reported | \n", "Customer Satisfaction | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
count | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "1834.000000 | \n", "
mean | \n", "1.951867 | \n", "32.386767 | \n", "22.958954 | \n", "21.110890 | \n", "65.538800 | \n", "2280.381264 | \n", "1.962182 | \n", "278.499225 | \n", "749.099262 | \n", "46.509726 | \n", "0.468692 | \n", "93486.070567 | \n", "36.197455 | \n", "-119.756684 | \n", "22139.603294 | \n", "0.265370 | \n", "4400.295755 | \n", "1.338776 | \n", "0.308107 | \n", "3.005453 | \n", "
std | \n", "3.001199 | \n", "24.542061 | \n", "15.448113 | \n", "20.948471 | \n", "30.606805 | \n", "2266.220462 | \n", "7.902614 | \n", "685.039625 | \n", "846.660055 | \n", "16.750352 | \n", "0.962802 | \n", "1856.767505 | \n", "2.468929 | \n", "2.154425 | \n", "21152.392837 | \n", "0.441561 | \n", "1183.057152 | \n", "1.430471 | \n", "0.717514 | \n", "1.256938 | \n", "
min | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "18.250000 | \n", "18.800000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "19.000000 | \n", "0.000000 | \n", "90001.000000 | \n", "32.555828 | \n", "-124.301372 | \n", "11.000000 | \n", "0.000000 | \n", "2003.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "
25% | \n", "0.000000 | \n", "9.000000 | \n", "9.210000 | \n", "3.000000 | \n", "35.890000 | \n", "400.150000 | \n", "0.000000 | \n", "0.000000 | \n", "70.545000 | \n", "32.000000 | \n", "0.000000 | \n", "92101.000000 | \n", "33.990646 | \n", "-121.788090 | \n", "2344.000000 | \n", "0.000000 | \n", "3469.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2.000000 | \n", "
50% | \n", "0.000000 | \n", "29.000000 | \n", "22.890000 | \n", "17.000000 | \n", "71.968000 | \n", "1394.550000 | \n", "0.000000 | \n", "0.000000 | \n", "401.440000 | \n", "46.000000 | \n", "0.000000 | \n", "93518.000000 | \n", "36.205465 | \n", "-119.595293 | \n", "17554.000000 | \n", "0.000000 | \n", "4527.000000 | \n", "1.000000 | \n", "0.000000 | \n", "3.000000 | \n", "
75% | \n", "3.000000 | \n", "55.000000 | \n", "36.395000 | \n", "28.000000 | \n", "90.650000 | \n", "3786.600000 | \n", "0.000000 | \n", "182.620000 | \n", "1191.100000 | \n", "60.000000 | \n", "0.000000 | \n", "95329.000000 | \n", "38.161321 | \n", "-117.969795 | \n", "36125.000000 | \n", "1.000000 | \n", "5380.500000 | \n", "2.000000 | \n", "0.000000 | \n", "4.000000 | \n", "
max | \n", "11.000000 | \n", "72.000000 | \n", "49.990000 | \n", "94.000000 | \n", "123.084000 | \n", "8684.800000 | \n", "49.790000 | \n", "6477.000000 | \n", "3564.720000 | \n", "80.000000 | \n", "9.000000 | \n", "96150.000000 | \n", "41.962127 | \n", "-114.192901 | \n", "105285.000000 | \n", "1.000000 | \n", "6500.000000 | \n", "9.000000 | \n", "6.000000 | \n", "5.000000 | \n", "
\n", " | Customer ID | \n", "Referred a Friend | \n", "Number of Referrals | \n", "Tenure in Months | \n", "Offer | \n", "Phone Service | \n", "Avg Monthly Long Distance Charges | \n", "Multiple Lines | \n", "Internet Service | \n", "Internet Type | \n", "... | \n", "Latitude | \n", "Longitude | \n", "Population | \n", "Churn Value | \n", "CLTV | \n", "Churn Category | \n", "Churn Reason | \n", "Total Customer Svc Requests | \n", "Product/Service Issues Reported | \n", "Customer Satisfaction | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0.00 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "34.023810 | \n", "-118.156582 | \n", "68701 | \n", "1 | \n", "5433 | \n", "0.0 | \n", "0 | \n", "5 | \n", "0 | \n", "NaN | \n", "
1 | \n", "1 | \n", "1 | \n", "1 | \n", "8 | \n", "1 | \n", "1 | \n", "48.85 | \n", "1 | \n", "0 | \n", "1 | \n", "... | \n", "34.044271 | \n", "-118.185237 | \n", "55668 | \n", "1 | \n", "5302 | \n", "0.0 | \n", "1 | \n", "5 | \n", "0 | \n", "NaN | \n", "
2 | \n", "2 | \n", "0 | \n", "0 | \n", "18 | \n", "2 | \n", "1 | \n", "11.33 | \n", "1 | \n", "0 | \n", "0 | \n", "... | \n", "34.108833 | \n", "-118.229715 | \n", "47534 | \n", "1 | \n", "3179 | \n", "0.0 | \n", "1 | \n", "1 | \n", "0 | \n", "NaN | \n", "
3 | \n", "3 | \n", "1 | \n", "1 | \n", "25 | \n", "3 | \n", "1 | \n", "19.76 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "33.936291 | \n", "-118.332639 | \n", "27778 | \n", "1 | \n", "5337 | \n", "1.0 | \n", "2 | \n", "1 | \n", "1 | \n", "2.0 | \n", "
4 | \n", "4 | \n", "1 | \n", "1 | \n", "37 | \n", "3 | \n", "1 | \n", "6.33 | \n", "1 | \n", "0 | \n", "1 | \n", "... | \n", "33.972119 | \n", "-118.020188 | \n", "26265 | \n", "1 | \n", "2793 | \n", "2.0 | \n", "3 | \n", "1 | \n", "0 | \n", "2.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
7038 | \n", "7038 | \n", "0 | \n", "0 | \n", "72 | \n", "0 | \n", "1 | \n", "22.77 | \n", "0 | \n", "1 | \n", "3 | \n", "... | \n", "34.341737 | \n", "-116.539416 | \n", "2182 | \n", "0 | \n", "5306 | \n", "5.0 | \n", "19 | \n", "0 | \n", "0 | \n", "NaN | \n", "
7039 | \n", "7039 | \n", "1 | \n", "1 | \n", "24 | \n", "3 | \n", "1 | \n", "36.05 | \n", "1 | \n", "0 | \n", "2 | \n", "... | \n", "34.667815 | \n", "-117.536183 | \n", "18980 | \n", "0 | \n", "2140 | \n", "5.0 | \n", "19 | \n", "2 | \n", "0 | \n", "NaN | \n", "
7040 | \n", "7040 | \n", "1 | \n", "4 | \n", "72 | \n", "0 | \n", "1 | \n", "29.66 | \n", "1 | \n", "0 | \n", "1 | \n", "... | \n", "34.559882 | \n", "-115.637164 | \n", "42 | \n", "0 | \n", "5560 | \n", "5.0 | \n", "19 | \n", "2 | \n", "0 | \n", "4.0 | \n", "
7041 | \n", "7041 | \n", "1 | \n", "1 | \n", "11 | \n", "0 | \n", "0 | \n", "0.00 | \n", "0 | \n", "0 | \n", "2 | \n", "... | \n", "34.167800 | \n", "-116.864330 | \n", "301 | \n", "0 | \n", "2793 | \n", "5.0 | \n", "19 | \n", "0 | \n", "0 | \n", "NaN | \n", "
7042 | \n", "7042 | \n", "0 | \n", "0 | \n", "66 | \n", "0 | \n", "1 | \n", "30.96 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "34.424926 | \n", "-117.184503 | \n", "28819 | \n", "0 | \n", "5097 | \n", "5.0 | \n", "19 | \n", "1 | \n", "2 | \n", "NaN | \n", "
7043 rows × 46 columns
\n", "\n", " | Customer ID | \n", "Referred a Friend | \n", "Number of Referrals | \n", "Tenure in Months | \n", "Offer | \n", "Phone Service | \n", "Avg Monthly Long Distance Charges | \n", "Multiple Lines | \n", "Internet Service | \n", "Internet Type | \n", "... | \n", "Latitude | \n", "Longitude | \n", "Population | \n", "Churn Value | \n", "CLTV | \n", "Churn Category | \n", "Churn Reason | \n", "Total Customer Svc Requests | \n", "Product/Service Issues Reported | \n", "Customer Satisfaction | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
count | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "... | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "7043.000000 | \n", "1834.000000 | \n", "
mean | \n", "3521.000000 | \n", "0.457476 | \n", "1.951867 | \n", "32.386767 | \n", "1.299162 | \n", "0.903166 | \n", "22.958954 | \n", "0.421837 | \n", "0.216669 | \n", "1.346585 | \n", "... | \n", "36.197455 | \n", "-119.756684 | \n", "22139.603294 | \n", "0.265370 | \n", "4400.295755 | \n", "4.039614 | \n", "15.844668 | \n", "1.338776 | \n", "0.308107 | \n", "3.005453 | \n", "
std | \n", "2033.283305 | \n", "0.498224 | \n", "3.001199 | \n", "24.542061 | \n", "1.736908 | \n", "0.295752 | \n", "15.448113 | \n", "0.493888 | \n", "0.412004 | \n", "1.144798 | \n", "... | \n", "2.468929 | \n", "2.154425 | \n", "21152.392837 | \n", "0.441561 | \n", "1183.057152 | \n", "1.783112 | \n", "5.924739 | \n", "1.430471 | \n", "0.717514 | \n", "1.256938 | \n", "
min | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "32.555828 | \n", "-124.301372 | \n", "11.000000 | \n", "0.000000 | \n", "2003.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "
25% | \n", "1760.500000 | \n", "0.000000 | \n", "0.000000 | \n", "9.000000 | \n", "0.000000 | \n", "1.000000 | \n", "9.210000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "33.990646 | \n", "-121.788090 | \n", "2344.000000 | \n", "0.000000 | \n", "3469.000000 | \n", "4.000000 | \n", "16.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2.000000 | \n", "
50% | \n", "3521.000000 | \n", "0.000000 | \n", "0.000000 | \n", "29.000000 | \n", "0.000000 | \n", "1.000000 | \n", "22.890000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "... | \n", "36.205465 | \n", "-119.595293 | \n", "17554.000000 | \n", "0.000000 | \n", "4527.000000 | \n", "5.000000 | \n", "19.000000 | \n", "1.000000 | \n", "0.000000 | \n", "3.000000 | \n", "
75% | \n", "5281.500000 | \n", "1.000000 | \n", "3.000000 | \n", "55.000000 | \n", "2.000000 | \n", "1.000000 | \n", "36.395000 | \n", "1.000000 | \n", "0.000000 | \n", "2.000000 | \n", "... | \n", "38.161321 | \n", "-117.969795 | \n", "36125.000000 | \n", "1.000000 | \n", "5380.500000 | \n", "5.000000 | \n", "19.000000 | \n", "2.000000 | \n", "0.000000 | \n", "4.000000 | \n", "
max | \n", "7042.000000 | \n", "1.000000 | \n", "11.000000 | \n", "72.000000 | \n", "5.000000 | \n", "1.000000 | \n", "49.990000 | \n", "1.000000 | \n", "1.000000 | \n", "3.000000 | \n", "... | \n", "41.962127 | \n", "-114.192901 | \n", "105285.000000 | \n", "1.000000 | \n", "6500.000000 | \n", "5.000000 | \n", "20.000000 | \n", "9.000000 | \n", "6.000000 | \n", "5.000000 | \n", "
8 rows × 46 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "-3.002798 | \n", "2.568436 | \n", "0.435735 | \n", "-0.998816 | \n", "1.607802 | \n", "0.901909 | \n", "-0.503341 | \n", "-0.857402 | \n", "1.166325 | \n", "1.585681 | \n", "
1 | \n", "-1.568821 | \n", "2.566579 | \n", "1.360710 | \n", "-1.384496 | \n", "-0.872650 | \n", "1.102183 | \n", "0.015085 | \n", "0.194377 | \n", "1.155558 | \n", "1.078244 | \n", "
2 | \n", "-0.861567 | \n", "2.371619 | \n", "0.488412 | \n", "1.242926 | \n", "1.372669 | \n", "1.079625 | \n", "5.737100 | \n", "0.826943 | \n", "-0.353325 | \n", "0.183389 | \n", "
3 | \n", "-0.719786 | \n", "2.132869 | \n", "1.624001 | \n", "-1.217324 | \n", "1.356086 | \n", "1.072161 | \n", "1.160244 | \n", "0.273082 | \n", "-1.231701 | \n", "-0.350140 | \n", "
4 | \n", "-1.152766 | \n", "1.944855 | \n", "0.834273 | \n", "-0.609254 | \n", "1.597955 | \n", "0.270291 | \n", "-0.066083 | \n", "2.060842 | \n", "-1.163752 | \n", "0.077246 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
7038 | \n", "0.869339 | \n", "1.025794 | \n", "-1.851187 | \n", "-0.876996 | \n", "-0.113642 | \n", "-0.330329 | \n", "1.551243 | \n", "-2.133172 | \n", "-1.191048 | \n", "-1.674934 | \n", "
7039 | \n", "-0.087797 | \n", "1.153038 | \n", "-0.509277 | \n", "0.514926 | \n", "-0.583164 | \n", "0.490409 | \n", "6.223361 | \n", "0.320231 | \n", "-0.304054 | \n", "-0.982371 | \n", "
7040 | \n", "5.552551 | \n", "2.150479 | \n", "1.580899 | \n", "2.959293 | \n", "0.281390 | \n", "0.426125 | \n", "5.144912 | \n", "-1.114288 | \n", "0.907409 | \n", "-2.173735 | \n", "
7041 | \n", "-1.501072 | \n", "0.724941 | \n", "-2.323556 | \n", "1.618127 | \n", "0.650849 | \n", "0.430918 | \n", "3.104344 | \n", "0.077345 | \n", "-0.954009 | \n", "-1.768319 | \n", "
7042 | \n", "2.054742 | \n", "1.791835 | \n", "1.241261 | \n", "-1.484360 | \n", "-0.075540 | \n", "0.045408 | \n", "-0.510082 | \n", "-0.764531 | \n", "0.347994 | \n", "-0.701506 | \n", "
7043 rows × 10 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "
---|---|---|---|
0 | \n", "-3.002798 | \n", "2.568436 | \n", "0.435735 | \n", "
1 | \n", "-1.568821 | \n", "2.566579 | \n", "1.360710 | \n", "
2 | \n", "-0.861567 | \n", "2.371619 | \n", "0.488412 | \n", "
3 | \n", "-0.719786 | \n", "2.132869 | \n", "1.624001 | \n", "
4 | \n", "-1.152766 | \n", "1.944855 | \n", "0.834273 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
7038 | \n", "0.869339 | \n", "1.025794 | \n", "-1.851187 | \n", "
7039 | \n", "-0.087797 | \n", "1.153038 | \n", "-0.509277 | \n", "
7040 | \n", "5.552551 | \n", "2.150479 | \n", "1.580899 | \n", "
7041 | \n", "-1.501072 | \n", "0.724941 | \n", "-2.323556 | \n", "
7042 | \n", "2.054742 | \n", "1.791835 | \n", "1.241261 | \n", "
7043 rows × 3 columns
\n", "\n", " | Customer ID | \n", "Referred a Friend | \n", "Number of Referrals | \n", "Tenure in Months | \n", "Offer | \n", "Phone Service | \n", "Avg Monthly Long Distance Charges | \n", "Multiple Lines | \n", "Internet Service | \n", "Internet Type | \n", "... | \n", "Latitude | \n", "Longitude | \n", "Population | \n", "Churn Value | \n", "CLTV | \n", "Churn Category | \n", "Churn Reason | \n", "Total Customer Svc Requests | \n", "Product/Service Issues Reported | \n", "Customer Satisfaction | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0.00 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "34.023810 | \n", "-118.156582 | \n", "68701 | \n", "1 | \n", "5433 | \n", "0.0 | \n", "0 | \n", "5 | \n", "0 | \n", "3.005453 | \n", "
1 | \n", "1 | \n", "1 | \n", "1 | \n", "8 | \n", "1 | \n", "1 | \n", "48.85 | \n", "1 | \n", "0 | \n", "1 | \n", "... | \n", "34.044271 | \n", "-118.185237 | \n", "55668 | \n", "1 | \n", "5302 | \n", "0.0 | \n", "1 | \n", "5 | \n", "0 | \n", "3.005453 | \n", "
2 | \n", "2 | \n", "0 | \n", "0 | \n", "18 | \n", "2 | \n", "1 | \n", "11.33 | \n", "1 | \n", "0 | \n", "0 | \n", "... | \n", "34.108833 | \n", "-118.229715 | \n", "47534 | \n", "1 | \n", "3179 | \n", "0.0 | \n", "1 | \n", "1 | \n", "0 | \n", "3.005453 | \n", "
3 | \n", "3 | \n", "1 | \n", "1 | \n", "25 | \n", "3 | \n", "1 | \n", "19.76 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "33.936291 | \n", "-118.332639 | \n", "27778 | \n", "1 | \n", "5337 | \n", "1.0 | \n", "2 | \n", "1 | \n", "1 | \n", "2.000000 | \n", "
4 | \n", "4 | \n", "1 | \n", "1 | \n", "37 | \n", "3 | \n", "1 | \n", "6.33 | \n", "1 | \n", "0 | \n", "1 | \n", "... | \n", "33.972119 | \n", "-118.020188 | \n", "26265 | \n", "1 | \n", "2793 | \n", "2.0 | \n", "3 | \n", "1 | \n", "0 | \n", "2.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
7038 | \n", "7038 | \n", "0 | \n", "0 | \n", "72 | \n", "0 | \n", "1 | \n", "22.77 | \n", "0 | \n", "1 | \n", "3 | \n", "... | \n", "34.341737 | \n", "-116.539416 | \n", "2182 | \n", "0 | \n", "5306 | \n", "5.0 | \n", "19 | \n", "0 | \n", "0 | \n", "3.005453 | \n", "
7039 | \n", "7039 | \n", "1 | \n", "1 | \n", "24 | \n", "3 | \n", "1 | \n", "36.05 | \n", "1 | \n", "0 | \n", "2 | \n", "... | \n", "34.667815 | \n", "-117.536183 | \n", "18980 | \n", "0 | \n", "2140 | \n", "5.0 | \n", "19 | \n", "2 | \n", "0 | \n", "3.005453 | \n", "
7040 | \n", "7040 | \n", "1 | \n", "4 | \n", "72 | \n", "0 | \n", "1 | \n", "29.66 | \n", "1 | \n", "0 | \n", "1 | \n", "... | \n", "34.559882 | \n", "-115.637164 | \n", "42 | \n", "0 | \n", "5560 | \n", "5.0 | \n", "19 | \n", "2 | \n", "0 | \n", "4.000000 | \n", "
7041 | \n", "7041 | \n", "1 | \n", "1 | \n", "11 | \n", "0 | \n", "0 | \n", "0.00 | \n", "0 | \n", "0 | \n", "2 | \n", "... | \n", "34.167800 | \n", "-116.864330 | \n", "301 | \n", "0 | \n", "2793 | \n", "5.0 | \n", "19 | \n", "0 | \n", "0 | \n", "3.005453 | \n", "
7042 | \n", "7042 | \n", "0 | \n", "0 | \n", "66 | \n", "0 | \n", "1 | \n", "30.96 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "34.424926 | \n", "-117.184503 | \n", "28819 | \n", "0 | \n", "5097 | \n", "5.0 | \n", "19 | \n", "1 | \n", "2 | \n", "3.005453 | \n", "
7043 rows × 46 columns
\n", "