Skip to content

Instantly share code, notes, and snippets.

@nogawanogawa

nogawanogawa/xfeat_sample_1.ipynb

Created July 7, 2021 12:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nogawanogawa/c3ee59bf60f6bcc5e38fcd7fbdbb516c to your computer and use it in GitHub Desktop.
Save nogawanogawa/c3ee59bf60f6bcc5e38fcd7fbdbb516c to your computer and use it in GitHub Desktop.
Download ZIP
xfeat_sample_1.ipynb
Display the source blob
Display the rendered blob
Raw
xfeat_sample_1.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "xfeat_sample_1.ipynb",
"provenance": [],
"collapsed_sections": [],
"authorship_tag": "ABX9TyOKMk03n6dPmGxn5KfhvCXy",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/nogawanogawa/c3ee59bf60f6bcc5e38fcd7fbdbb516c/xfeat_sample_1.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "gE-qZO_w_7tQ",
"outputId": "d0221156-acc7-4da7-b04c-843220dbdbd3"
},
"source": [
"!pip install xfeat "
],
"execution_count": 1,
"outputs": [
{
"output_type": "stream",
"text": [
"Requirement already satisfied: xfeat in /usr/local/lib/python3.7/dist-packages (0.1.1)\n",
"Requirement already satisfied: optuna>=1.3.0 in /usr/local/lib/python3.7/dist-packages (from xfeat) (2.8.0)\n",
"Requirement already satisfied: ml-metrics in /usr/local/lib/python3.7/dist-packages (from xfeat) (0.1.4)\n",
"Requirement already satisfied: scikit-learn in /usr/local/lib/python3.7/dist-packages (from xfeat) (0.22.2.post1)\n",
"Requirement already satisfied: lightgbm in /usr/local/lib/python3.7/dist-packages (from xfeat) (2.2.3)\n",
"Requirement already satisfied: PyYAML in /usr/local/lib/python3.7/dist-packages (from xfeat) (3.13)\n",
"Requirement already satisfied: pyarrow in /usr/local/lib/python3.7/dist-packages (from xfeat) (3.0.0)\n",
"Requirement already satisfied: sqlalchemy>=1.1.0 in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (1.4.18)\n",
"Requirement already satisfied: tqdm in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (4.41.1)\n",
"Requirement already satisfied: alembic in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (1.6.5)\n",
"Requirement already satisfied: cliff in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (3.8.0)\n",
"Requirement already satisfied: cmaes>=0.8.2 in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (0.8.2)\n",
"Requirement already satisfied: scipy!=1.4.0 in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (1.4.1)\n",
"Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (20.9)\n",
"Requirement already satisfied: numpy in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (1.19.5)\n",
"Requirement already satisfied: colorlog in /usr/local/lib/python3.7/dist-packages (from optuna>=1.3.0->xfeat) (5.0.1)\n",
"Requirement already satisfied: pandas in /usr/local/lib/python3.7/dist-packages (from ml-metrics->xfeat) (1.1.5)\n",
"Requirement already satisfied: joblib>=0.11 in /usr/local/lib/python3.7/dist-packages (from scikit-learn->xfeat) (1.0.1)\n",
"Requirement already satisfied: importlib-metadata; python_version < \"3.8\" in /usr/local/lib/python3.7/dist-packages (from sqlalchemy>=1.1.0->optuna>=1.3.0->xfeat) (4.5.0)\n",
"Requirement already satisfied: greenlet!=0.4.17; python_version >= \"3\" in /usr/local/lib/python3.7/dist-packages (from sqlalchemy>=1.1.0->optuna>=1.3.0->xfeat) (1.1.0)\n",
"Requirement already satisfied: python-editor>=0.3 in /usr/local/lib/python3.7/dist-packages (from alembic->optuna>=1.3.0->xfeat) (1.0.4)\n",
"Requirement already satisfied: python-dateutil in /usr/local/lib/python3.7/dist-packages (from alembic->optuna>=1.3.0->xfeat) (2.8.1)\n",
"Requirement already satisfied: Mako in /usr/local/lib/python3.7/dist-packages (from alembic->optuna>=1.3.0->xfeat) (1.1.4)\n",
"Requirement already satisfied: PrettyTable>=0.7.2 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna>=1.3.0->xfeat) (2.1.0)\n",
"Requirement already satisfied: pyparsing>=2.1.0 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna>=1.3.0->xfeat) (2.4.7)\n",
"Requirement already satisfied: stevedore>=2.0.1 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna>=1.3.0->xfeat) (3.3.0)\n",
"Requirement already satisfied: pbr!=2.1.0,>=2.0.0 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna>=1.3.0->xfeat) (5.6.0)\n",
"Requirement already satisfied: cmd2>=1.0.0 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna>=1.3.0->xfeat) (2.1.2)\n",
"Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.7/dist-packages (from pandas->ml-metrics->xfeat) (2018.9)\n",
"Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata; python_version < \"3.8\"->sqlalchemy>=1.1.0->optuna>=1.3.0->xfeat) (3.4.1)\n",
"Requirement already satisfied: typing-extensions>=3.6.4; python_version < \"3.8\" in /usr/local/lib/python3.7/dist-packages (from importlib-metadata; python_version < \"3.8\"->sqlalchemy>=1.1.0->optuna>=1.3.0->xfeat) (3.7.4.3)\n",
"Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil->alembic->optuna>=1.3.0->xfeat) (1.15.0)\n",
"Requirement already satisfied: MarkupSafe>=0.9.2 in /usr/local/lib/python3.7/dist-packages (from Mako->alembic->optuna>=1.3.0->xfeat) (2.0.1)\n",
"Requirement already satisfied: wcwidth in /usr/local/lib/python3.7/dist-packages (from PrettyTable>=0.7.2->cliff->optuna>=1.3.0->xfeat) (0.2.5)\n",
"Requirement already satisfied: colorama>=0.3.7 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna>=1.3.0->xfeat) (0.4.4)\n",
"Requirement already satisfied: pyperclip>=1.6 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna>=1.3.0->xfeat) (1.8.2)\n",
"Requirement already satisfied: attrs>=16.3.0 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna>=1.3.0->xfeat) (21.2.0)\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "CtnyrH-xAu1B"
},
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import xfeat\n",
"from xfeat import SelectNumerical\n",
"from xfeat import ArithmeticCombinations, Pipeline\n",
"from sklearn.datasets import fetch_california_housing"
],
"execution_count": 2,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 203
},
"id": "ZA6MH3qyAwHI",
"outputId": "4e0bcb3d-b2b8-4223-a884-d5bac96d36d5"
},
"source": [
"data = fetch_california_housing()\n",
"df = pd.DataFrame(\n",
" data=data.data,\n",
" columns=data.feature_names)\n",
"df.head()"
],
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>MedInc</th>\n",
" <th>HouseAge</th>\n",
" <th>AveRooms</th>\n",
" <th>AveBedrms</th>\n",
" <th>Population</th>\n",
" <th>AveOccup</th>\n",
" <th>Latitude</th>\n",
" <th>Longitude</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>8.3252</td>\n",
" <td>41.0</td>\n",
" <td>6.984127</td>\n",
" <td>1.023810</td>\n",
" <td>322.0</td>\n",
" <td>2.555556</td>\n",
" <td>37.88</td>\n",
" <td>-122.23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>8.3014</td>\n",
" <td>21.0</td>\n",
" <td>6.238137</td>\n",
" <td>0.971880</td>\n",
" <td>2401.0</td>\n",
" <td>2.109842</td>\n",
" <td>37.86</td>\n",
" <td>-122.22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>7.2574</td>\n",
" <td>52.0</td>\n",
" <td>8.288136</td>\n",
" <td>1.073446</td>\n",
" <td>496.0</td>\n",
" <td>2.802260</td>\n",
" <td>37.85</td>\n",
" <td>-122.24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5.6431</td>\n",
" <td>52.0</td>\n",
" <td>5.817352</td>\n",
" <td>1.073059</td>\n",
" <td>558.0</td>\n",
" <td>2.547945</td>\n",
" <td>37.85</td>\n",
" <td>-122.25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>3.8462</td>\n",
" <td>52.0</td>\n",
" <td>6.281853</td>\n",
" <td>1.081081</td>\n",
" <td>565.0</td>\n",
" <td>2.181467</td>\n",
" <td>37.85</td>\n",
" <td>-122.25</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" MedInc HouseAge AveRooms ... AveOccup Latitude Longitude\n",
"0 8.3252 41.0 6.984127 ... 2.555556 37.88 -122.23\n",
"1 8.3014 21.0 6.238137 ... 2.109842 37.86 -122.22\n",
"2 7.2574 52.0 8.288136 ... 2.802260 37.85 -122.24\n",
"3 5.6431 52.0 5.817352 ... 2.547945 37.85 -122.25\n",
"4 3.8462 52.0 6.281853 ... 2.181467 37.85 -122.25\n",
"\n",
"[5 rows x 8 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 3
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 437
},
"id": "VI8wPuvLBBOq",
"outputId": "bde649e4-c3d8-4304-9f73-7be4d6e8ff80"
},
"source": [
"#　カラムを組み合わせた特徴量を作成するパイプライン\n",
"encoder = Pipeline([\n",
" SelectNumerical(),\n",
" ArithmeticCombinations(\n",
" drop_origin=False,\n",
" operator=\"+\",\n",
" r=3,\n",
" output_suffix=\"\",\n",
" ),\n",
"])\n",
"encoder.fit_transform(df)"
],
"execution_count": 4,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>MedInc</th>\n",
" <th>HouseAge</th>\n",
" <th>AveRooms</th>\n",
" <th>AveBedrms</th>\n",
" <th>Population</th>\n",
" <th>AveOccup</th>\n",
" <th>Latitude</th>\n",
" <th>Longitude</th>\n",
" <th>MedIncHouseAgeAveRooms</th>\n",
" <th>MedIncHouseAgeAveBedrms</th>\n",
" <th>MedIncHouseAgePopulation</th>\n",
" <th>MedIncHouseAgeAveOccup</th>\n",
" <th>MedIncHouseAgeLatitude</th>\n",
" <th>MedIncHouseAgeLongitude</th>\n",
" <th>MedIncAveRoomsAveBedrms</th>\n",
" <th>MedIncAveRoomsPopulation</th>\n",
" <th>MedIncAveRoomsAveOccup</th>\n",
" <th>MedIncAveRoomsLatitude</th>\n",
" <th>MedIncAveRoomsLongitude</th>\n",
" <th>MedIncAveBedrmsPopulation</th>\n",
" <th>MedIncAveBedrmsAveOccup</th>\n",
" <th>MedIncAveBedrmsLatitude</th>\n",
" <th>MedIncAveBedrmsLongitude</th>\n",
" <th>MedIncPopulationAveOccup</th>\n",
" <th>MedIncPopulationLatitude</th>\n",
" <th>MedIncPopulationLongitude</th>\n",
" <th>MedIncAveOccupLatitude</th>\n",
" <th>MedIncAveOccupLongitude</th>\n",
" <th>MedIncLatitudeLongitude</th>\n",
" <th>HouseAgeAveRoomsAveBedrms</th>\n",
" <th>HouseAgeAveRoomsPopulation</th>\n",
" <th>HouseAgeAveRoomsAveOccup</th>\n",
" <th>HouseAgeAveRoomsLatitude</th>\n",
" <th>HouseAgeAveRoomsLongitude</th>\n",
" <th>HouseAgeAveBedrmsPopulation</th>\n",
" <th>HouseAgeAveBedrmsAveOccup</th>\n",
" <th>HouseAgeAveBedrmsLatitude</th>\n",
" <th>HouseAgeAveBedrmsLongitude</th>\n",
" <th>HouseAgePopulationAveOccup</th>\n",
" <th>HouseAgePopulationLatitude</th>\n",
" <th>HouseAgePopulationLongitude</th>\n",
" <th>HouseAgeAveOccupLatitude</th>\n",
" <th>HouseAgeAveOccupLongitude</th>\n",
" <th>HouseAgeLatitudeLongitude</th>\n",
" <th>AveRoomsAveBedrmsPopulation</th>\n",
" <th>AveRoomsAveBedrmsAveOccup</th>\n",
" <th>AveRoomsAveBedrmsLatitude</th>\n",
" <th>AveRoomsAveBedrmsLongitude</th>\n",
" <th>AveRoomsPopulationAveOccup</th>\n",
" <th>AveRoomsPopulationLatitude</th>\n",
" <th>AveRoomsPopulationLongitude</th>\n",
" <th>AveRoomsAveOccupLatitude</th>\n",
" <th>AveRoomsAveOccupLongitude</th>\n",
" <th>AveRoomsLatitudeLongitude</th>\n",
" <th>AveBedrmsPopulationAveOccup</th>\n",
" <th>AveBedrmsPopulationLatitude</th>\n",
" <th>AveBedrmsPopulationLongitude</th>\n",
" <th>AveBedrmsAveOccupLatitude</th>\n",
" <th>AveBedrmsAveOccupLongitude</th>\n",
" <th>AveBedrmsLatitudeLongitude</th>\n",
" <th>PopulationAveOccupLatitude</th>\n",
" <th>PopulationAveOccupLongitude</th>\n",
" <th>PopulationLatitudeLongitude</th>\n",
" <th>AveOccupLatitudeLongitude</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>8.3252</td>\n",
" <td>41.0</td>\n",
" <td>6.984127</td>\n",
" <td>1.023810</td>\n",
" <td>322.0</td>\n",
" <td>2.555556</td>\n",
" <td>37.88</td>\n",
" <td>-122.23</td>\n",
" <td>56.309327</td>\n",
" <td>50.349010</td>\n",
" <td>371.3252</td>\n",
" <td>51.880756</td>\n",
" <td>87.2052</td>\n",
" <td>-72.9048</td>\n",
" <td>16.333137</td>\n",
" <td>337.309327</td>\n",
" <td>17.864883</td>\n",
" <td>53.189327</td>\n",
" <td>-106.920673</td>\n",
" <td>331.349010</td>\n",
" <td>11.904565</td>\n",
" <td>47.229010</td>\n",
" <td>-112.880990</td>\n",
" <td>332.880756</td>\n",
" <td>368.2052</td>\n",
" <td>208.0952</td>\n",
" <td>48.760756</td>\n",
" <td>-111.349244</td>\n",
" <td>-76.0248</td>\n",
" <td>49.007937</td>\n",
" <td>369.984127</td>\n",
" <td>50.539683</td>\n",
" <td>85.864127</td>\n",
" <td>-74.245873</td>\n",
" <td>364.023810</td>\n",
" <td>44.579365</td>\n",
" <td>79.903810</td>\n",
" <td>-80.206190</td>\n",
" <td>365.555556</td>\n",
" <td>400.88</td>\n",
" <td>240.77</td>\n",
" <td>81.435556</td>\n",
" <td>-78.674444</td>\n",
" <td>-43.35</td>\n",
" <td>330.007937</td>\n",
" <td>10.563492</td>\n",
" <td>45.887937</td>\n",
" <td>-114.222063</td>\n",
" <td>331.539683</td>\n",
" <td>366.864127</td>\n",
" <td>206.754127</td>\n",
" <td>47.419683</td>\n",
" <td>-112.690317</td>\n",
" <td>-77.365873</td>\n",
" <td>325.579365</td>\n",
" <td>360.903810</td>\n",
" <td>200.793810</td>\n",
" <td>41.459365</td>\n",
" <td>-118.650635</td>\n",
" <td>-83.326190</td>\n",
" <td>362.435556</td>\n",
" <td>202.325556</td>\n",
" <td>237.65</td>\n",
" <td>-81.794444</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>8.3014</td>\n",
" <td>21.0</td>\n",
" <td>6.238137</td>\n",
" <td>0.971880</td>\n",
" <td>2401.0</td>\n",
" <td>2.109842</td>\n",
" <td>37.86</td>\n",
" <td>-122.22</td>\n",
" <td>35.539537</td>\n",
" <td>30.273280</td>\n",
" <td>2430.3014</td>\n",
" <td>31.411242</td>\n",
" <td>67.1614</td>\n",
" <td>-92.9186</td>\n",
" <td>15.511418</td>\n",
" <td>2415.539537</td>\n",
" <td>16.649379</td>\n",
" <td>52.399537</td>\n",
" <td>-107.680463</td>\n",
" <td>2410.273280</td>\n",
" <td>11.383122</td>\n",
" <td>47.133280</td>\n",
" <td>-112.946720</td>\n",
" <td>2411.411242</td>\n",
" <td>2447.1614</td>\n",
" <td>2287.0814</td>\n",
" <td>48.271242</td>\n",
" <td>-111.808758</td>\n",
" <td>-76.0586</td>\n",
" <td>28.210018</td>\n",
" <td>2428.238137</td>\n",
" <td>29.347979</td>\n",
" <td>65.098137</td>\n",
" <td>-94.981863</td>\n",
" <td>2422.971880</td>\n",
" <td>24.081722</td>\n",
" <td>59.831880</td>\n",
" <td>-100.248120</td>\n",
" <td>2424.109842</td>\n",
" <td>2459.86</td>\n",
" <td>2299.78</td>\n",
" <td>60.969842</td>\n",
" <td>-99.110158</td>\n",
" <td>-63.36</td>\n",
" <td>2408.210018</td>\n",
" <td>9.319859</td>\n",
" <td>45.070018</td>\n",
" <td>-115.009982</td>\n",
" <td>2409.347979</td>\n",
" <td>2445.098137</td>\n",
" <td>2285.018137</td>\n",
" <td>46.207979</td>\n",
" <td>-113.872021</td>\n",
" <td>-78.121863</td>\n",
" <td>2404.081722</td>\n",
" <td>2439.831880</td>\n",
" <td>2279.751880</td>\n",
" <td>40.941722</td>\n",
" <td>-119.138278</td>\n",
" <td>-83.388120</td>\n",
" <td>2440.969842</td>\n",
" <td>2280.889842</td>\n",
" <td>2316.64</td>\n",
" <td>-82.250158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>7.2574</td>\n",
" <td>52.0</td>\n",
" <td>8.288136</td>\n",
" <td>1.073446</td>\n",
" <td>496.0</td>\n",
" <td>2.802260</td>\n",
" <td>37.85</td>\n",
" <td>-122.24</td>\n",
" <td>67.545536</td>\n",
" <td>60.330846</td>\n",
" <td>555.2574</td>\n",
" <td>62.059660</td>\n",
" <td>97.1074</td>\n",
" <td>-62.9826</td>\n",
" <td>16.618982</td>\n",
" <td>511.545536</td>\n",
" <td>18.347795</td>\n",
" <td>53.395536</td>\n",
" <td>-106.694464</td>\n",
" <td>504.330846</td>\n",
" <td>11.133106</td>\n",
" <td>46.180846</td>\n",
" <td>-113.909154</td>\n",
" <td>506.059660</td>\n",
" <td>541.1074</td>\n",
" <td>381.0174</td>\n",
" <td>47.909660</td>\n",
" <td>-112.180340</td>\n",
" <td>-77.1326</td>\n",
" <td>61.361582</td>\n",
" <td>556.288136</td>\n",
" <td>63.090395</td>\n",
" <td>98.138136</td>\n",
" <td>-61.951864</td>\n",
" <td>549.073446</td>\n",
" <td>55.875706</td>\n",
" <td>90.923446</td>\n",
" <td>-69.166554</td>\n",
" <td>550.802260</td>\n",
" <td>585.85</td>\n",
" <td>425.76</td>\n",
" <td>92.652260</td>\n",
" <td>-67.437740</td>\n",
" <td>-32.39</td>\n",
" <td>505.361582</td>\n",
" <td>12.163842</td>\n",
" <td>47.211582</td>\n",
" <td>-112.878418</td>\n",
" <td>507.090395</td>\n",
" <td>542.138136</td>\n",
" <td>382.048136</td>\n",
" <td>48.940395</td>\n",
" <td>-111.149605</td>\n",
" <td>-76.101864</td>\n",
" <td>499.875706</td>\n",
" <td>534.923446</td>\n",
" <td>374.833446</td>\n",
" <td>41.725706</td>\n",
" <td>-118.364294</td>\n",
" <td>-83.316554</td>\n",
" <td>536.652260</td>\n",
" <td>376.562260</td>\n",
" <td>411.61</td>\n",
" <td>-81.587740</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5.6431</td>\n",
" <td>52.0</td>\n",
" <td>5.817352</td>\n",
" <td>1.073059</td>\n",
" <td>558.0</td>\n",
" <td>2.547945</td>\n",
" <td>37.85</td>\n",
" <td>-122.25</td>\n",
" <td>63.460452</td>\n",
" <td>58.716159</td>\n",
" <td>615.6431</td>\n",
" <td>60.191045</td>\n",
" <td>95.4931</td>\n",
" <td>-64.6069</td>\n",
" <td>12.533511</td>\n",
" <td>569.460452</td>\n",
" <td>14.008397</td>\n",
" <td>49.310452</td>\n",
" <td>-110.789548</td>\n",
" <td>564.716159</td>\n",
" <td>9.264105</td>\n",
" <td>44.566159</td>\n",
" <td>-115.533841</td>\n",
" <td>566.191045</td>\n",
" <td>601.4931</td>\n",
" <td>441.3931</td>\n",
" <td>46.041045</td>\n",
" <td>-114.058955</td>\n",
" <td>-78.7569</td>\n",
" <td>58.890411</td>\n",
" <td>615.817352</td>\n",
" <td>60.365297</td>\n",
" <td>95.667352</td>\n",
" <td>-64.432648</td>\n",
" <td>611.073059</td>\n",
" <td>55.621005</td>\n",
" <td>90.923059</td>\n",
" <td>-69.176941</td>\n",
" <td>612.547945</td>\n",
" <td>647.85</td>\n",
" <td>487.75</td>\n",
" <td>92.397945</td>\n",
" <td>-67.702055</td>\n",
" <td>-32.40</td>\n",
" <td>564.890411</td>\n",
" <td>9.438356</td>\n",
" <td>44.740411</td>\n",
" <td>-115.359589</td>\n",
" <td>566.365297</td>\n",
" <td>601.667352</td>\n",
" <td>441.567352</td>\n",
" <td>46.215297</td>\n",
" <td>-113.884703</td>\n",
" <td>-78.582648</td>\n",
" <td>561.621005</td>\n",
" <td>596.923059</td>\n",
" <td>436.823059</td>\n",
" <td>41.471005</td>\n",
" <td>-118.628995</td>\n",
" <td>-83.326941</td>\n",
" <td>598.397945</td>\n",
" <td>438.297945</td>\n",
" <td>473.60</td>\n",
" <td>-81.852055</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>3.8462</td>\n",
" <td>52.0</td>\n",
" <td>6.281853</td>\n",
" <td>1.081081</td>\n",
" <td>565.0</td>\n",
" <td>2.181467</td>\n",
" <td>37.85</td>\n",
" <td>-122.25</td>\n",
" <td>62.128053</td>\n",
" <td>56.927281</td>\n",
" <td>620.8462</td>\n",
" <td>58.027667</td>\n",
" <td>93.6962</td>\n",
" <td>-66.4038</td>\n",
" <td>11.209134</td>\n",
" <td>575.128053</td>\n",
" <td>12.309520</td>\n",
" <td>47.978053</td>\n",
" <td>-112.121947</td>\n",
" <td>569.927281</td>\n",
" <td>7.108748</td>\n",
" <td>42.777281</td>\n",
" <td>-117.322719</td>\n",
" <td>571.027667</td>\n",
" <td>606.6962</td>\n",
" <td>446.5962</td>\n",
" <td>43.877667</td>\n",
" <td>-116.222333</td>\n",
" <td>-80.5538</td>\n",
" <td>59.362934</td>\n",
" <td>623.281853</td>\n",
" <td>60.463320</td>\n",
" <td>96.131853</td>\n",
" <td>-63.968147</td>\n",
" <td>618.081081</td>\n",
" <td>55.262548</td>\n",
" <td>90.931081</td>\n",
" <td>-69.168919</td>\n",
" <td>619.181467</td>\n",
" <td>654.85</td>\n",
" <td>494.75</td>\n",
" <td>92.031467</td>\n",
" <td>-68.068533</td>\n",
" <td>-32.40</td>\n",
" <td>572.362934</td>\n",
" <td>9.544402</td>\n",
" <td>45.212934</td>\n",
" <td>-114.887066</td>\n",
" <td>573.463320</td>\n",
" <td>609.131853</td>\n",
" <td>449.031853</td>\n",
" <td>46.313320</td>\n",
" <td>-113.786680</td>\n",
" <td>-78.118147</td>\n",
" <td>568.262548</td>\n",
" <td>603.931081</td>\n",
" <td>443.831081</td>\n",
" <td>41.112548</td>\n",
" <td>-118.987452</td>\n",
" <td>-83.318919</td>\n",
" <td>605.031467</td>\n",
" <td>444.931467</td>\n",
" <td>480.60</td>\n",
" <td>-82.218533</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20635</th>\n",
" <td>1.5603</td>\n",
" <td>25.0</td>\n",
" <td>5.045455</td>\n",
" <td>1.133333</td>\n",
" <td>845.0</td>\n",
" <td>2.560606</td>\n",
" <td>39.48</td>\n",
" <td>-121.09</td>\n",
" <td>31.605755</td>\n",
" <td>27.693633</td>\n",
" <td>871.5603</td>\n",
" <td>29.120906</td>\n",
" <td>66.0403</td>\n",
" <td>-94.5297</td>\n",
" <td>7.739088</td>\n",
" <td>851.605755</td>\n",
" <td>9.166361</td>\n",
" <td>46.085755</td>\n",
" <td>-114.484245</td>\n",
" <td>847.693633</td>\n",
" <td>5.254239</td>\n",
" <td>42.173633</td>\n",
" <td>-118.396367</td>\n",
" <td>849.120906</td>\n",
" <td>886.0403</td>\n",
" <td>725.4703</td>\n",
" <td>43.600906</td>\n",
" <td>-116.969094</td>\n",
" <td>-80.0497</td>\n",
" <td>31.178788</td>\n",
" <td>875.045455</td>\n",
" <td>32.606061</td>\n",
" <td>69.525455</td>\n",
" <td>-91.044545</td>\n",
" <td>871.133333</td>\n",
" <td>28.693939</td>\n",
" <td>65.613333</td>\n",
" <td>-94.956667</td>\n",
" <td>872.560606</td>\n",
" <td>909.48</td>\n",
" <td>748.91</td>\n",
" <td>67.040606</td>\n",
" <td>-93.529394</td>\n",
" <td>-56.61</td>\n",
" <td>851.178788</td>\n",
" <td>8.739394</td>\n",
" <td>45.658788</td>\n",
" <td>-114.911212</td>\n",
" <td>852.606061</td>\n",
" <td>889.525455</td>\n",
" <td>728.955455</td>\n",
" <td>47.086061</td>\n",
" <td>-113.483939</td>\n",
" <td>-76.564545</td>\n",
" <td>848.693939</td>\n",
" <td>885.613333</td>\n",
" <td>725.043333</td>\n",
" <td>43.173939</td>\n",
" <td>-117.396061</td>\n",
" <td>-80.476667</td>\n",
" <td>887.040606</td>\n",
" <td>726.470606</td>\n",
" <td>763.39</td>\n",
" <td>-79.049394</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20636</th>\n",
" <td>2.5568</td>\n",
" <td>18.0</td>\n",
" <td>6.114035</td>\n",
" <td>1.315789</td>\n",
" <td>356.0</td>\n",
" <td>3.122807</td>\n",
" <td>39.49</td>\n",
" <td>-121.21</td>\n",
" <td>26.670835</td>\n",
" <td>21.872589</td>\n",
" <td>376.5568</td>\n",
" <td>23.679607</td>\n",
" <td>60.0468</td>\n",
" <td>-100.6532</td>\n",
" <td>9.986625</td>\n",
" <td>364.670835</td>\n",
" <td>11.793642</td>\n",
" <td>48.160835</td>\n",
" <td>-112.539165</td>\n",
" <td>359.872589</td>\n",
" <td>6.995396</td>\n",
" <td>43.362589</td>\n",
" <td>-117.337411</td>\n",
" <td>361.679607</td>\n",
" <td>398.0468</td>\n",
" <td>237.3468</td>\n",
" <td>45.169607</td>\n",
" <td>-115.530393</td>\n",
" <td>-79.1632</td>\n",
" <td>25.429825</td>\n",
" <td>380.114035</td>\n",
" <td>27.236842</td>\n",
" <td>63.604035</td>\n",
" <td>-97.095965</td>\n",
" <td>375.315789</td>\n",
" <td>22.438596</td>\n",
" <td>58.805789</td>\n",
" <td>-101.894211</td>\n",
" <td>377.122807</td>\n",
" <td>413.49</td>\n",
" <td>252.79</td>\n",
" <td>60.612807</td>\n",
" <td>-100.087193</td>\n",
" <td>-63.72</td>\n",
" <td>363.429825</td>\n",
" <td>10.552632</td>\n",
" <td>46.919825</td>\n",
" <td>-113.780175</td>\n",
" <td>365.236842</td>\n",
" <td>401.604035</td>\n",
" <td>240.904035</td>\n",
" <td>48.726842</td>\n",
" <td>-111.973158</td>\n",
" <td>-75.605965</td>\n",
" <td>360.438596</td>\n",
" <td>396.805789</td>\n",
" <td>236.105789</td>\n",
" <td>43.928596</td>\n",
" <td>-116.771404</td>\n",
" <td>-80.404211</td>\n",
" <td>398.612807</td>\n",
" <td>237.912807</td>\n",
" <td>274.28</td>\n",
" <td>-78.597193</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20637</th>\n",
" <td>1.7000</td>\n",
" <td>17.0</td>\n",
" <td>5.205543</td>\n",
" <td>1.120092</td>\n",
" <td>1007.0</td>\n",
" <td>2.325635</td>\n",
" <td>39.43</td>\n",
" <td>-121.22</td>\n",
" <td>23.905543</td>\n",
" <td>19.820092</td>\n",
" <td>1025.7000</td>\n",
" <td>21.025635</td>\n",
" <td>58.1300</td>\n",
" <td>-102.5200</td>\n",
" <td>8.025635</td>\n",
" <td>1013.905543</td>\n",
" <td>9.231178</td>\n",
" <td>46.335543</td>\n",
" <td>-114.314457</td>\n",
" <td>1009.820092</td>\n",
" <td>5.145727</td>\n",
" <td>42.250092</td>\n",
" <td>-118.399908</td>\n",
" <td>1011.025635</td>\n",
" <td>1048.1300</td>\n",
" <td>887.4800</td>\n",
" <td>43.455635</td>\n",
" <td>-117.194365</td>\n",
" <td>-80.0900</td>\n",
" <td>23.325635</td>\n",
" <td>1029.205543</td>\n",
" <td>24.531178</td>\n",
" <td>61.635543</td>\n",
" <td>-99.014457</td>\n",
" <td>1025.120092</td>\n",
" <td>20.445727</td>\n",
" <td>57.550092</td>\n",
" <td>-103.099908</td>\n",
" <td>1026.325635</td>\n",
" <td>1063.43</td>\n",
" <td>902.78</td>\n",
" <td>58.755635</td>\n",
" <td>-101.894365</td>\n",
" <td>-64.79</td>\n",
" <td>1013.325635</td>\n",
" <td>8.651270</td>\n",
" <td>45.755635</td>\n",
" <td>-114.894365</td>\n",
" <td>1014.531178</td>\n",
" <td>1051.635543</td>\n",
" <td>890.985543</td>\n",
" <td>46.961178</td>\n",
" <td>-113.688822</td>\n",
" <td>-76.584457</td>\n",
" <td>1010.445727</td>\n",
" <td>1047.550092</td>\n",
" <td>886.900092</td>\n",
" <td>42.875727</td>\n",
" <td>-117.774273</td>\n",
" <td>-80.669908</td>\n",
" <td>1048.755635</td>\n",
" <td>888.105635</td>\n",
" <td>925.21</td>\n",
" <td>-79.464365</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20638</th>\n",
" <td>1.8672</td>\n",
" <td>18.0</td>\n",
" <td>5.329513</td>\n",
" <td>1.171920</td>\n",
" <td>741.0</td>\n",
" <td>2.123209</td>\n",
" <td>39.43</td>\n",
" <td>-121.32</td>\n",
" <td>25.196713</td>\n",
" <td>21.039120</td>\n",
" <td>760.8672</td>\n",
" <td>21.990409</td>\n",
" <td>59.2972</td>\n",
" <td>-101.4528</td>\n",
" <td>8.368633</td>\n",
" <td>748.196713</td>\n",
" <td>9.319922</td>\n",
" <td>46.626713</td>\n",
" <td>-114.123287</td>\n",
" <td>744.039120</td>\n",
" <td>5.162329</td>\n",
" <td>42.469120</td>\n",
" <td>-118.280880</td>\n",
" <td>744.990409</td>\n",
" <td>782.2972</td>\n",
" <td>621.5472</td>\n",
" <td>43.420409</td>\n",
" <td>-117.329591</td>\n",
" <td>-80.0228</td>\n",
" <td>24.501433</td>\n",
" <td>764.329513</td>\n",
" <td>25.452722</td>\n",
" <td>62.759513</td>\n",
" <td>-97.990487</td>\n",
" <td>760.171920</td>\n",
" <td>21.295129</td>\n",
" <td>58.601920</td>\n",
" <td>-102.148080</td>\n",
" <td>761.123209</td>\n",
" <td>798.43</td>\n",
" <td>637.68</td>\n",
" <td>59.553209</td>\n",
" <td>-101.196791</td>\n",
" <td>-63.89</td>\n",
" <td>747.501433</td>\n",
" <td>8.624642</td>\n",
" <td>45.931433</td>\n",
" <td>-114.818567</td>\n",
" <td>748.452722</td>\n",
" <td>785.759513</td>\n",
" <td>625.009513</td>\n",
" <td>46.882722</td>\n",
" <td>-113.867278</td>\n",
" <td>-76.560487</td>\n",
" <td>744.295129</td>\n",
" <td>781.601920</td>\n",
" <td>620.851920</td>\n",
" <td>42.725129</td>\n",
" <td>-118.024871</td>\n",
" <td>-80.718080</td>\n",
" <td>782.553209</td>\n",
" <td>621.803209</td>\n",
" <td>659.11</td>\n",
" <td>-79.766791</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20639</th>\n",
" <td>2.3886</td>\n",
" <td>16.0</td>\n",
" <td>5.254717</td>\n",
" <td>1.162264</td>\n",
" <td>1387.0</td>\n",
" <td>2.616981</td>\n",
" <td>39.37</td>\n",
" <td>-121.24</td>\n",
" <td>23.643317</td>\n",
" <td>19.550864</td>\n",
" <td>1405.3886</td>\n",
" <td>21.005581</td>\n",
" <td>57.7586</td>\n",
" <td>-102.8514</td>\n",
" <td>8.805581</td>\n",
" <td>1394.643317</td>\n",
" <td>10.260298</td>\n",
" <td>47.013317</td>\n",
" <td>-113.596683</td>\n",
" <td>1390.550864</td>\n",
" <td>6.167845</td>\n",
" <td>42.920864</td>\n",
" <td>-117.689136</td>\n",
" <td>1392.005581</td>\n",
" <td>1428.7586</td>\n",
" <td>1268.1486</td>\n",
" <td>44.375581</td>\n",
" <td>-116.234419</td>\n",
" <td>-79.4814</td>\n",
" <td>22.416981</td>\n",
" <td>1408.254717</td>\n",
" <td>23.871698</td>\n",
" <td>60.624717</td>\n",
" <td>-99.985283</td>\n",
" <td>1404.162264</td>\n",
" <td>19.779245</td>\n",
" <td>56.532264</td>\n",
" <td>-104.077736</td>\n",
" <td>1405.616981</td>\n",
" <td>1442.37</td>\n",
" <td>1281.76</td>\n",
" <td>57.986981</td>\n",
" <td>-102.623019</td>\n",
" <td>-65.87</td>\n",
" <td>1393.416981</td>\n",
" <td>9.033962</td>\n",
" <td>45.786981</td>\n",
" <td>-114.823019</td>\n",
" <td>1394.871698</td>\n",
" <td>1431.624717</td>\n",
" <td>1271.014717</td>\n",
" <td>47.241698</td>\n",
" <td>-113.368302</td>\n",
" <td>-76.615283</td>\n",
" <td>1390.779245</td>\n",
" <td>1427.532264</td>\n",
" <td>1266.922264</td>\n",
" <td>43.149245</td>\n",
" <td>-117.460755</td>\n",
" <td>-80.707736</td>\n",
" <td>1428.986981</td>\n",
" <td>1268.376981</td>\n",
" <td>1305.13</td>\n",
" <td>-79.253019</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>20640 rows × 64 columns</p>\n",
"</div>"
],
"text/plain": [
" MedInc HouseAge ... PopulationLatitudeLongitude AveOccupLatitudeLongitude\n",
"0 8.3252 41.0 ... 237.65 -81.794444\n",
"1 8.3014 21.0 ... 2316.64 -82.250158\n",
"2 7.2574 52.0 ... 411.61 -81.587740\n",
"3 5.6431 52.0 ... 473.60 -81.852055\n",
"4 3.8462 52.0 ... 480.60 -82.218533\n",
"... ... ... ... ... ...\n",
"20635 1.5603 25.0 ... 763.39 -79.049394\n",
"20636 2.5568 18.0 ... 274.28 -78.597193\n",
"20637 1.7000 17.0 ... 925.21 -79.464365\n",
"20638 1.8672 18.0 ... 659.11 -79.766791\n",
"20639 2.3886 16.0 ... 1305.13 -79.253019\n",
"\n",
"[20640 rows x 64 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 4
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 437
},
"id": "karm3VOoBH08",
"outputId": "b126851a-053d-4d12-cd94-d5886e2a0630"
},
"source": [
"cols = df.columns.tolist()\n",
"\n",
"# 複数のカラムを組み合わせた特徴量を作成するパイプライン\n",
"encoder = Pipeline([\n",
" ArithmeticCombinations(input_cols=cols,\n",
" drop_origin=False,\n",
" operator=\"+\",\n",
" r=2,\n",
" output_suffix=\"_plus\"),\n",
" ArithmeticCombinations(input_cols=cols,\n",
" drop_origin=False,\n",
" operator=\"*\",\n",
" r=2,\n",
" output_suffix=\"_mul\"),\n",
" ArithmeticCombinations(input_cols=cols,\n",
" drop_origin=False,\n",
" operator=\"-\",\n",
" r=2,\n",
" output_suffix=\"_minus\"),\n",
" ArithmeticCombinations(input_cols=cols,\n",
" drop_origin=False,\n",
" operator=\"+\",\n",
" r=3,\n",
" output_suffix=\"_plus\"),\n",
"])\n",
"\n",
"encoder.fit_transform(df)"
],
"execution_count": 5,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>MedInc</th>\n",
" <th>HouseAge</th>\n",
" <th>AveRooms</th>\n",
" <th>AveBedrms</th>\n",
" <th>Population</th>\n",
" <th>AveOccup</th>\n",
" <th>Latitude</th>\n",
" <th>Longitude</th>\n",
" <th>MedIncHouseAge_plus</th>\n",
" <th>MedIncAveRooms_plus</th>\n",
" <th>MedIncAveBedrms_plus</th>\n",
" <th>MedIncPopulation_plus</th>\n",
" <th>MedIncAveOccup_plus</th>\n",
" <th>MedIncLatitude_plus</th>\n",
" <th>MedIncLongitude_plus</th>\n",
" <th>HouseAgeAveRooms_plus</th>\n",
" <th>HouseAgeAveBedrms_plus</th>\n",
" <th>HouseAgePopulation_plus</th>\n",
" <th>HouseAgeAveOccup_plus</th>\n",
" <th>HouseAgeLatitude_plus</th>\n",
" <th>HouseAgeLongitude_plus</th>\n",
" <th>AveRoomsAveBedrms_plus</th>\n",
" <th>AveRoomsPopulation_plus</th>\n",
" <th>AveRoomsAveOccup_plus</th>\n",
" <th>AveRoomsLatitude_plus</th>\n",
" <th>AveRoomsLongitude_plus</th>\n",
" <th>AveBedrmsPopulation_plus</th>\n",
" <th>AveBedrmsAveOccup_plus</th>\n",
" <th>AveBedrmsLatitude_plus</th>\n",
" <th>AveBedrmsLongitude_plus</th>\n",
" <th>PopulationAveOccup_plus</th>\n",
" <th>PopulationLatitude_plus</th>\n",
" <th>PopulationLongitude_plus</th>\n",
" <th>AveOccupLatitude_plus</th>\n",
" <th>AveOccupLongitude_plus</th>\n",
" <th>LatitudeLongitude_plus</th>\n",
" <th>MedIncHouseAge_mul</th>\n",
" <th>MedIncAveRooms_mul</th>\n",
" <th>MedIncAveBedrms_mul</th>\n",
" <th>MedIncPopulation_mul</th>\n",
" <th>...</th>\n",
" <th>MedIncPopulationLatitude_plus</th>\n",
" <th>MedIncPopulationLongitude_plus</th>\n",
" <th>MedIncAveOccupLatitude_plus</th>\n",
" <th>MedIncAveOccupLongitude_plus</th>\n",
" <th>MedIncLatitudeLongitude_plus</th>\n",
" <th>HouseAgeAveRoomsAveBedrms_plus</th>\n",
" <th>HouseAgeAveRoomsPopulation_plus</th>\n",
" <th>HouseAgeAveRoomsAveOccup_plus</th>\n",
" <th>HouseAgeAveRoomsLatitude_plus</th>\n",
" <th>HouseAgeAveRoomsLongitude_plus</th>\n",
" <th>HouseAgeAveBedrmsPopulation_plus</th>\n",
" <th>HouseAgeAveBedrmsAveOccup_plus</th>\n",
" <th>HouseAgeAveBedrmsLatitude_plus</th>\n",
" <th>HouseAgeAveBedrmsLongitude_plus</th>\n",
" <th>HouseAgePopulationAveOccup_plus</th>\n",
" <th>HouseAgePopulationLatitude_plus</th>\n",
" <th>HouseAgePopulationLongitude_plus</th>\n",
" <th>HouseAgeAveOccupLatitude_plus</th>\n",
" <th>HouseAgeAveOccupLongitude_plus</th>\n",
" <th>HouseAgeLatitudeLongitude_plus</th>\n",
" <th>AveRoomsAveBedrmsPopulation_plus</th>\n",
" <th>AveRoomsAveBedrmsAveOccup_plus</th>\n",
" <th>AveRoomsAveBedrmsLatitude_plus</th>\n",
" <th>AveRoomsAveBedrmsLongitude_plus</th>\n",
" <th>AveRoomsPopulationAveOccup_plus</th>\n",
" <th>AveRoomsPopulationLatitude_plus</th>\n",
" <th>AveRoomsPopulationLongitude_plus</th>\n",
" <th>AveRoomsAveOccupLatitude_plus</th>\n",
" <th>AveRoomsAveOccupLongitude_plus</th>\n",
" <th>AveRoomsLatitudeLongitude_plus</th>\n",
" <th>AveBedrmsPopulationAveOccup_plus</th>\n",
" <th>AveBedrmsPopulationLatitude_plus</th>\n",
" <th>AveBedrmsPopulationLongitude_plus</th>\n",
" <th>AveBedrmsAveOccupLatitude_plus</th>\n",
" <th>AveBedrmsAveOccupLongitude_plus</th>\n",
" <th>AveBedrmsLatitudeLongitude_plus</th>\n",
" <th>PopulationAveOccupLatitude_plus</th>\n",
" <th>PopulationAveOccupLongitude_plus</th>\n",
" <th>PopulationLatitudeLongitude_plus</th>\n",
" <th>AveOccupLatitudeLongitude_plus</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>8.3252</td>\n",
" <td>41.0</td>\n",
" <td>6.984127</td>\n",
" <td>1.023810</td>\n",
" <td>322.0</td>\n",
" <td>2.555556</td>\n",
" <td>37.88</td>\n",
" <td>-122.23</td>\n",
" <td>49.3252</td>\n",
" <td>15.309327</td>\n",
" <td>9.349010</td>\n",
" <td>330.3252</td>\n",
" <td>10.880756</td>\n",
" <td>46.2052</td>\n",
" <td>-113.9048</td>\n",
" <td>47.984127</td>\n",
" <td>42.023810</td>\n",
" <td>363.0</td>\n",
" <td>43.555556</td>\n",
" <td>78.88</td>\n",
" <td>-81.23</td>\n",
" <td>8.007937</td>\n",
" <td>328.984127</td>\n",
" <td>9.539683</td>\n",
" <td>44.864127</td>\n",
" <td>-115.245873</td>\n",
" <td>323.023810</td>\n",
" <td>3.579365</td>\n",
" <td>38.903810</td>\n",
" <td>-121.206190</td>\n",
" <td>324.555556</td>\n",
" <td>359.88</td>\n",
" <td>199.77</td>\n",
" <td>40.435556</td>\n",
" <td>-119.674444</td>\n",
" <td>-84.35</td>\n",
" <td>341.3332</td>\n",
" <td>58.144254</td>\n",
" <td>8.523419</td>\n",
" <td>2680.7144</td>\n",
" <td>...</td>\n",
" <td>368.2052</td>\n",
" <td>208.0952</td>\n",
" <td>48.760756</td>\n",
" <td>-111.349244</td>\n",
" <td>-76.0248</td>\n",
" <td>49.007937</td>\n",
" <td>369.984127</td>\n",
" <td>50.539683</td>\n",
" <td>85.864127</td>\n",
" <td>-74.245873</td>\n",
" <td>364.023810</td>\n",
" <td>44.579365</td>\n",
" <td>79.903810</td>\n",
" <td>-80.206190</td>\n",
" <td>365.555556</td>\n",
" <td>400.88</td>\n",
" <td>240.77</td>\n",
" <td>81.435556</td>\n",
" <td>-78.674444</td>\n",
" <td>-43.35</td>\n",
" <td>330.007937</td>\n",
" <td>10.563492</td>\n",
" <td>45.887937</td>\n",
" <td>-114.222063</td>\n",
" <td>331.539683</td>\n",
" <td>366.864127</td>\n",
" <td>206.754127</td>\n",
" <td>47.419683</td>\n",
" <td>-112.690317</td>\n",
" <td>-77.365873</td>\n",
" <td>325.579365</td>\n",
" <td>360.903810</td>\n",
" <td>200.793810</td>\n",
" <td>41.459365</td>\n",
" <td>-118.650635</td>\n",
" <td>-83.326190</td>\n",
" <td>362.435556</td>\n",
" <td>202.325556</td>\n",
" <td>237.65</td>\n",
" <td>-81.794444</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>8.3014</td>\n",
" <td>21.0</td>\n",
" <td>6.238137</td>\n",
" <td>0.971880</td>\n",
" <td>2401.0</td>\n",
" <td>2.109842</td>\n",
" <td>37.86</td>\n",
" <td>-122.22</td>\n",
" <td>29.3014</td>\n",
" <td>14.539537</td>\n",
" <td>9.273280</td>\n",
" <td>2409.3014</td>\n",
" <td>10.411242</td>\n",
" <td>46.1614</td>\n",
" <td>-113.9186</td>\n",
" <td>27.238137</td>\n",
" <td>21.971880</td>\n",
" <td>2422.0</td>\n",
" <td>23.109842</td>\n",
" <td>58.86</td>\n",
" <td>-101.22</td>\n",
" <td>7.210018</td>\n",
" <td>2407.238137</td>\n",
" <td>8.347979</td>\n",
" <td>44.098137</td>\n",
" <td>-115.981863</td>\n",
" <td>2401.971880</td>\n",
" <td>3.081722</td>\n",
" <td>38.831880</td>\n",
" <td>-121.248120</td>\n",
" <td>2403.109842</td>\n",
" <td>2438.86</td>\n",
" <td>2278.78</td>\n",
" <td>39.969842</td>\n",
" <td>-120.110158</td>\n",
" <td>-84.36</td>\n",
" <td>174.3294</td>\n",
" <td>51.785271</td>\n",
" <td>8.067969</td>\n",
" <td>19931.6614</td>\n",
" <td>...</td>\n",
" <td>2447.1614</td>\n",
" <td>2287.0814</td>\n",
" <td>48.271242</td>\n",
" <td>-111.808758</td>\n",
" <td>-76.0586</td>\n",
" <td>28.210018</td>\n",
" <td>2428.238137</td>\n",
" <td>29.347979</td>\n",
" <td>65.098137</td>\n",
" <td>-94.981863</td>\n",
" <td>2422.971880</td>\n",
" <td>24.081722</td>\n",
" <td>59.831880</td>\n",
" <td>-100.248120</td>\n",
" <td>2424.109842</td>\n",
" <td>2459.86</td>\n",
" <td>2299.78</td>\n",
" <td>60.969842</td>\n",
" <td>-99.110158</td>\n",
" <td>-63.36</td>\n",
" <td>2408.210018</td>\n",
" <td>9.319859</td>\n",
" <td>45.070018</td>\n",
" <td>-115.009982</td>\n",
" <td>2409.347979</td>\n",
" <td>2445.098137</td>\n",
" <td>2285.018137</td>\n",
" <td>46.207979</td>\n",
" <td>-113.872021</td>\n",
" <td>-78.121863</td>\n",
" <td>2404.081722</td>\n",
" <td>2439.831880</td>\n",
" <td>2279.751880</td>\n",
" <td>40.941722</td>\n",
" <td>-119.138278</td>\n",
" <td>-83.388120</td>\n",
" <td>2440.969842</td>\n",
" <td>2280.889842</td>\n",
" <td>2316.64</td>\n",
" <td>-82.250158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>7.2574</td>\n",
" <td>52.0</td>\n",
" <td>8.288136</td>\n",
" <td>1.073446</td>\n",
" <td>496.0</td>\n",
" <td>2.802260</td>\n",
" <td>37.85</td>\n",
" <td>-122.24</td>\n",
" <td>59.2574</td>\n",
" <td>15.545536</td>\n",
" <td>8.330846</td>\n",
" <td>503.2574</td>\n",
" <td>10.059660</td>\n",
" <td>45.1074</td>\n",
" <td>-114.9826</td>\n",
" <td>60.288136</td>\n",
" <td>53.073446</td>\n",
" <td>548.0</td>\n",
" <td>54.802260</td>\n",
" <td>89.85</td>\n",
" <td>-70.24</td>\n",
" <td>9.361582</td>\n",
" <td>504.288136</td>\n",
" <td>11.090395</td>\n",
" <td>46.138136</td>\n",
" <td>-113.951864</td>\n",
" <td>497.073446</td>\n",
" <td>3.875706</td>\n",
" <td>38.923446</td>\n",
" <td>-121.166554</td>\n",
" <td>498.802260</td>\n",
" <td>533.85</td>\n",
" <td>373.76</td>\n",
" <td>40.652260</td>\n",
" <td>-119.437740</td>\n",
" <td>-84.39</td>\n",
" <td>377.3848</td>\n",
" <td>60.150315</td>\n",
" <td>7.790429</td>\n",
" <td>3599.6704</td>\n",
" <td>...</td>\n",
" <td>541.1074</td>\n",
" <td>381.0174</td>\n",
" <td>47.909660</td>\n",
" <td>-112.180340</td>\n",
" <td>-77.1326</td>\n",
" <td>61.361582</td>\n",
" <td>556.288136</td>\n",
" <td>63.090395</td>\n",
" <td>98.138136</td>\n",
" <td>-61.951864</td>\n",
" <td>549.073446</td>\n",
" <td>55.875706</td>\n",
" <td>90.923446</td>\n",
" <td>-69.166554</td>\n",
" <td>550.802260</td>\n",
" <td>585.85</td>\n",
" <td>425.76</td>\n",
" <td>92.652260</td>\n",
" <td>-67.437740</td>\n",
" <td>-32.39</td>\n",
" <td>505.361582</td>\n",
" <td>12.163842</td>\n",
" <td>47.211582</td>\n",
" <td>-112.878418</td>\n",
" <td>507.090395</td>\n",
" <td>542.138136</td>\n",
" <td>382.048136</td>\n",
" <td>48.940395</td>\n",
" <td>-111.149605</td>\n",
" <td>-76.101864</td>\n",
" <td>499.875706</td>\n",
" <td>534.923446</td>\n",
" <td>374.833446</td>\n",
" <td>41.725706</td>\n",
" <td>-118.364294</td>\n",
" <td>-83.316554</td>\n",
" <td>536.652260</td>\n",
" <td>376.562260</td>\n",
" <td>411.61</td>\n",
" <td>-81.587740</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5.6431</td>\n",
" <td>52.0</td>\n",
" <td>5.817352</td>\n",
" <td>1.073059</td>\n",
" <td>558.0</td>\n",
" <td>2.547945</td>\n",
" <td>37.85</td>\n",
" <td>-122.25</td>\n",
" <td>57.6431</td>\n",
" <td>11.460452</td>\n",
" <td>6.716159</td>\n",
" <td>563.6431</td>\n",
" <td>8.191045</td>\n",
" <td>43.4931</td>\n",
" <td>-116.6069</td>\n",
" <td>57.817352</td>\n",
" <td>53.073059</td>\n",
" <td>610.0</td>\n",
" <td>54.547945</td>\n",
" <td>89.85</td>\n",
" <td>-70.25</td>\n",
" <td>6.890411</td>\n",
" <td>563.817352</td>\n",
" <td>8.365297</td>\n",
" <td>43.667352</td>\n",
" <td>-116.432648</td>\n",
" <td>559.073059</td>\n",
" <td>3.621005</td>\n",
" <td>38.923059</td>\n",
" <td>-121.176941</td>\n",
" <td>560.547945</td>\n",
" <td>595.85</td>\n",
" <td>435.75</td>\n",
" <td>40.397945</td>\n",
" <td>-119.702055</td>\n",
" <td>-84.40</td>\n",
" <td>293.4412</td>\n",
" <td>32.827897</td>\n",
" <td>6.055381</td>\n",
" <td>3148.8498</td>\n",
" <td>...</td>\n",
" <td>601.4931</td>\n",
" <td>441.3931</td>\n",
" <td>46.041045</td>\n",
" <td>-114.058955</td>\n",
" <td>-78.7569</td>\n",
" <td>58.890411</td>\n",
" <td>615.817352</td>\n",
" <td>60.365297</td>\n",
" <td>95.667352</td>\n",
" <td>-64.432648</td>\n",
" <td>611.073059</td>\n",
" <td>55.621005</td>\n",
" <td>90.923059</td>\n",
" <td>-69.176941</td>\n",
" <td>612.547945</td>\n",
" <td>647.85</td>\n",
" <td>487.75</td>\n",
" <td>92.397945</td>\n",
" <td>-67.702055</td>\n",
" <td>-32.40</td>\n",
" <td>564.890411</td>\n",
" <td>9.438356</td>\n",
" <td>44.740411</td>\n",
" <td>-115.359589</td>\n",
" <td>566.365297</td>\n",
" <td>601.667352</td>\n",
" <td>441.567352</td>\n",
" <td>46.215297</td>\n",
" <td>-113.884703</td>\n",
" <td>-78.582648</td>\n",
" <td>561.621005</td>\n",
" <td>596.923059</td>\n",
" <td>436.823059</td>\n",
" <td>41.471005</td>\n",
" <td>-118.628995</td>\n",
" <td>-83.326941</td>\n",
" <td>598.397945</td>\n",
" <td>438.297945</td>\n",
" <td>473.60</td>\n",
" <td>-81.852055</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>3.8462</td>\n",
" <td>52.0</td>\n",
" <td>6.281853</td>\n",
" <td>1.081081</td>\n",
" <td>565.0</td>\n",
" <td>2.181467</td>\n",
" <td>37.85</td>\n",
" <td>-122.25</td>\n",
" <td>55.8462</td>\n",
" <td>10.128053</td>\n",
" <td>4.927281</td>\n",
" <td>568.8462</td>\n",
" <td>6.027667</td>\n",
" <td>41.6962</td>\n",
" <td>-118.4038</td>\n",
" <td>58.281853</td>\n",
" <td>53.081081</td>\n",
" <td>617.0</td>\n",
" <td>54.181467</td>\n",
" <td>89.85</td>\n",
" <td>-70.25</td>\n",
" <td>7.362934</td>\n",
" <td>571.281853</td>\n",
" <td>8.463320</td>\n",
" <td>44.131853</td>\n",
" <td>-115.968147</td>\n",
" <td>566.081081</td>\n",
" <td>3.262548</td>\n",
" <td>38.931081</td>\n",
" <td>-121.168919</td>\n",
" <td>567.181467</td>\n",
" <td>602.85</td>\n",
" <td>442.75</td>\n",
" <td>40.031467</td>\n",
" <td>-120.068533</td>\n",
" <td>-84.40</td>\n",
" <td>200.0024</td>\n",
" <td>24.161264</td>\n",
" <td>4.158054</td>\n",
" <td>2173.1030</td>\n",
" <td>...</td>\n",
" <td>606.6962</td>\n",
" <td>446.5962</td>\n",
" <td>43.877667</td>\n",
" <td>-116.222333</td>\n",
" <td>-80.5538</td>\n",
" <td>59.362934</td>\n",
" <td>623.281853</td>\n",
" <td>60.463320</td>\n",
" <td>96.131853</td>\n",
" <td>-63.968147</td>\n",
" <td>618.081081</td>\n",
" <td>55.262548</td>\n",
" <td>90.931081</td>\n",
" <td>-69.168919</td>\n",
" <td>619.181467</td>\n",
" <td>654.85</td>\n",
" <td>494.75</td>\n",
" <td>92.031467</td>\n",
" <td>-68.068533</td>\n",
" <td>-32.40</td>\n",
" <td>572.362934</td>\n",
" <td>9.544402</td>\n",
" <td>45.212934</td>\n",
" <td>-114.887066</td>\n",
" <td>573.463320</td>\n",
" <td>609.131853</td>\n",
" <td>449.031853</td>\n",
" <td>46.313320</td>\n",
" <td>-113.786680</td>\n",
" <td>-78.118147</td>\n",
" <td>568.262548</td>\n",
" <td>603.931081</td>\n",
" <td>443.831081</td>\n",
" <td>41.112548</td>\n",
" <td>-118.987452</td>\n",
" <td>-83.318919</td>\n",
" <td>605.031467</td>\n",
" <td>444.931467</td>\n",
" <td>480.60</td>\n",
" <td>-82.218533</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20635</th>\n",
" <td>1.5603</td>\n",
" <td>25.0</td>\n",
" <td>5.045455</td>\n",
" <td>1.133333</td>\n",
" <td>845.0</td>\n",
" <td>2.560606</td>\n",
" <td>39.48</td>\n",
" <td>-121.09</td>\n",
" <td>26.5603</td>\n",
" <td>6.605755</td>\n",
" <td>2.693633</td>\n",
" <td>846.5603</td>\n",
" <td>4.120906</td>\n",
" <td>41.0403</td>\n",
" <td>-119.5297</td>\n",
" <td>30.045455</td>\n",
" <td>26.133333</td>\n",
" <td>870.0</td>\n",
" <td>27.560606</td>\n",
" <td>64.48</td>\n",
" <td>-96.09</td>\n",
" <td>6.178788</td>\n",
" <td>850.045455</td>\n",
" <td>7.606061</td>\n",
" <td>44.525455</td>\n",
" <td>-116.044545</td>\n",
" <td>846.133333</td>\n",
" <td>3.693939</td>\n",
" <td>40.613333</td>\n",
" <td>-119.956667</td>\n",
" <td>847.560606</td>\n",
" <td>884.48</td>\n",
" <td>723.91</td>\n",
" <td>42.040606</td>\n",
" <td>-118.529394</td>\n",
" <td>-81.61</td>\n",
" <td>39.0075</td>\n",
" <td>7.872423</td>\n",
" <td>1.768340</td>\n",
" <td>1318.4535</td>\n",
" <td>...</td>\n",
" <td>886.0403</td>\n",
" <td>725.4703</td>\n",
" <td>43.600906</td>\n",
" <td>-116.969094</td>\n",
" <td>-80.0497</td>\n",
" <td>31.178788</td>\n",
" <td>875.045455</td>\n",
" <td>32.606061</td>\n",
" <td>69.525455</td>\n",
" <td>-91.044545</td>\n",
" <td>871.133333</td>\n",
" <td>28.693939</td>\n",
" <td>65.613333</td>\n",
" <td>-94.956667</td>\n",
" <td>872.560606</td>\n",
" <td>909.48</td>\n",
" <td>748.91</td>\n",
" <td>67.040606</td>\n",
" <td>-93.529394</td>\n",
" <td>-56.61</td>\n",
" <td>851.178788</td>\n",
" <td>8.739394</td>\n",
" <td>45.658788</td>\n",
" <td>-114.911212</td>\n",
" <td>852.606061</td>\n",
" <td>889.525455</td>\n",
" <td>728.955455</td>\n",
" <td>47.086061</td>\n",
" <td>-113.483939</td>\n",
" <td>-76.564545</td>\n",
" <td>848.693939</td>\n",
" <td>885.613333</td>\n",
" <td>725.043333</td>\n",
" <td>43.173939</td>\n",
" <td>-117.396061</td>\n",
" <td>-80.476667</td>\n",
" <td>887.040606</td>\n",
" <td>726.470606</td>\n",
" <td>763.39</td>\n",
" <td>-79.049394</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20636</th>\n",
" <td>2.5568</td>\n",
" <td>18.0</td>\n",
" <td>6.114035</td>\n",
" <td>1.315789</td>\n",
" <td>356.0</td>\n",
" <td>3.122807</td>\n",
" <td>39.49</td>\n",
" <td>-121.21</td>\n",
" <td>20.5568</td>\n",
" <td>8.670835</td>\n",
" <td>3.872589</td>\n",
" <td>358.5568</td>\n",
" <td>5.679607</td>\n",
" <td>42.0468</td>\n",
" <td>-118.6532</td>\n",
" <td>24.114035</td>\n",
" <td>19.315789</td>\n",
" <td>374.0</td>\n",
" <td>21.122807</td>\n",
" <td>57.49</td>\n",
" <td>-103.21</td>\n",
" <td>7.429825</td>\n",
" <td>362.114035</td>\n",
" <td>9.236842</td>\n",
" <td>45.604035</td>\n",
" <td>-115.095965</td>\n",
" <td>357.315789</td>\n",
" <td>4.438596</td>\n",
" <td>40.805789</td>\n",
" <td>-119.894211</td>\n",
" <td>359.122807</td>\n",
" <td>395.49</td>\n",
" <td>234.79</td>\n",
" <td>42.612807</td>\n",
" <td>-118.087193</td>\n",
" <td>-81.72</td>\n",
" <td>46.0224</td>\n",
" <td>15.632365</td>\n",
" <td>3.364211</td>\n",
" <td>910.2208</td>\n",
" <td>...</td>\n",
" <td>398.0468</td>\n",
" <td>237.3468</td>\n",
" <td>45.169607</td>\n",
" <td>-115.530393</td>\n",
" <td>-79.1632</td>\n",
" <td>25.429825</td>\n",
" <td>380.114035</td>\n",
" <td>27.236842</td>\n",
" <td>63.604035</td>\n",
" <td>-97.095965</td>\n",
" <td>375.315789</td>\n",
" <td>22.438596</td>\n",
" <td>58.805789</td>\n",
" <td>-101.894211</td>\n",
" <td>377.122807</td>\n",
" <td>413.49</td>\n",
" <td>252.79</td>\n",
" <td>60.612807</td>\n",
" <td>-100.087193</td>\n",
" <td>-63.72</td>\n",
" <td>363.429825</td>\n",
" <td>10.552632</td>\n",
" <td>46.919825</td>\n",
" <td>-113.780175</td>\n",
" <td>365.236842</td>\n",
" <td>401.604035</td>\n",
" <td>240.904035</td>\n",
" <td>48.726842</td>\n",
" <td>-111.973158</td>\n",
" <td>-75.605965</td>\n",
" <td>360.438596</td>\n",
" <td>396.805789</td>\n",
" <td>236.105789</td>\n",
" <td>43.928596</td>\n",
" <td>-116.771404</td>\n",
" <td>-80.404211</td>\n",
" <td>398.612807</td>\n",
" <td>237.912807</td>\n",
" <td>274.28</td>\n",
" <td>-78.597193</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20637</th>\n",
" <td>1.7000</td>\n",
" <td>17.0</td>\n",
" <td>5.205543</td>\n",
" <td>1.120092</td>\n",
" <td>1007.0</td>\n",
" <td>2.325635</td>\n",
" <td>39.43</td>\n",
" <td>-121.22</td>\n",
" <td>18.7000</td>\n",
" <td>6.905543</td>\n",
" <td>2.820092</td>\n",
" <td>1008.7000</td>\n",
" <td>4.025635</td>\n",
" <td>41.1300</td>\n",
" <td>-119.5200</td>\n",
" <td>22.205543</td>\n",
" <td>18.120092</td>\n",
" <td>1024.0</td>\n",
" <td>19.325635</td>\n",
" <td>56.43</td>\n",
" <td>-104.22</td>\n",
" <td>6.325635</td>\n",
" <td>1012.205543</td>\n",
" <td>7.531178</td>\n",
" <td>44.635543</td>\n",
" <td>-116.014457</td>\n",
" <td>1008.120092</td>\n",
" <td>3.445727</td>\n",
" <td>40.550092</td>\n",
" <td>-120.099908</td>\n",
" <td>1009.325635</td>\n",
" <td>1046.43</td>\n",
" <td>885.78</td>\n",
" <td>41.755635</td>\n",
" <td>-118.894365</td>\n",
" <td>-81.79</td>\n",
" <td>28.9000</td>\n",
" <td>8.849423</td>\n",
" <td>1.904157</td>\n",
" <td>1711.9000</td>\n",
" <td>...</td>\n",
" <td>1048.1300</td>\n",
" <td>887.4800</td>\n",
" <td>43.455635</td>\n",
" <td>-117.194365</td>\n",
" <td>-80.0900</td>\n",
" <td>23.325635</td>\n",
" <td>1029.205543</td>\n",
" <td>24.531178</td>\n",
" <td>61.635543</td>\n",
" <td>-99.014457</td>\n",
" <td>1025.120092</td>\n",
" <td>20.445727</td>\n",
" <td>57.550092</td>\n",
" <td>-103.099908</td>\n",
" <td>1026.325635</td>\n",
" <td>1063.43</td>\n",
" <td>902.78</td>\n",
" <td>58.755635</td>\n",
" <td>-101.894365</td>\n",
" <td>-64.79</td>\n",
" <td>1013.325635</td>\n",
" <td>8.651270</td>\n",
" <td>45.755635</td>\n",
" <td>-114.894365</td>\n",
" <td>1014.531178</td>\n",
" <td>1051.635543</td>\n",
" <td>890.985543</td>\n",
" <td>46.961178</td>\n",
" <td>-113.688822</td>\n",
" <td>-76.584457</td>\n",
" <td>1010.445727</td>\n",
" <td>1047.550092</td>\n",
" <td>886.900092</td>\n",
" <td>42.875727</td>\n",
" <td>-117.774273</td>\n",
" <td>-80.669908</td>\n",
" <td>1048.755635</td>\n",
" <td>888.105635</td>\n",
" <td>925.21</td>\n",
" <td>-79.464365</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20638</th>\n",
" <td>1.8672</td>\n",
" <td>18.0</td>\n",
" <td>5.329513</td>\n",
" <td>1.171920</td>\n",
" <td>741.0</td>\n",
" <td>2.123209</td>\n",
" <td>39.43</td>\n",
" <td>-121.32</td>\n",
" <td>19.8672</td>\n",
" <td>7.196713</td>\n",
" <td>3.039120</td>\n",
" <td>742.8672</td>\n",
" <td>3.990409</td>\n",
" <td>41.2972</td>\n",
" <td>-119.4528</td>\n",
" <td>23.329513</td>\n",
" <td>19.171920</td>\n",
" <td>759.0</td>\n",
" <td>20.123209</td>\n",
" <td>57.43</td>\n",
" <td>-103.32</td>\n",
" <td>6.501433</td>\n",
" <td>746.329513</td>\n",
" <td>7.452722</td>\n",
" <td>44.759513</td>\n",
" <td>-115.990487</td>\n",
" <td>742.171920</td>\n",
" <td>3.295129</td>\n",
" <td>40.601920</td>\n",
" <td>-120.148080</td>\n",
" <td>743.123209</td>\n",
" <td>780.43</td>\n",
" <td>619.68</td>\n",
" <td>41.553209</td>\n",
" <td>-119.196791</td>\n",
" <td>-81.89</td>\n",
" <td>33.6096</td>\n",
" <td>9.951266</td>\n",
" <td>2.188209</td>\n",
" <td>1383.5952</td>\n",
" <td>...</td>\n",
" <td>782.2972</td>\n",
" <td>621.5472</td>\n",
" <td>43.420409</td>\n",
" <td>-117.329591</td>\n",
" <td>-80.0228</td>\n",
" <td>24.501433</td>\n",
" <td>764.329513</td>\n",
" <td>25.452722</td>\n",
" <td>62.759513</td>\n",
" <td>-97.990487</td>\n",
" <td>760.171920</td>\n",
" <td>21.295129</td>\n",
" <td>58.601920</td>\n",
" <td>-102.148080</td>\n",
" <td>761.123209</td>\n",
" <td>798.43</td>\n",
" <td>637.68</td>\n",
" <td>59.553209</td>\n",
" <td>-101.196791</td>\n",
" <td>-63.89</td>\n",
" <td>747.501433</td>\n",
" <td>8.624642</td>\n",
" <td>45.931433</td>\n",
" <td>-114.818567</td>\n",
" <td>748.452722</td>\n",
" <td>785.759513</td>\n",
" <td>625.009513</td>\n",
" <td>46.882722</td>\n",
" <td>-113.867278</td>\n",
" <td>-76.560487</td>\n",
" <td>744.295129</td>\n",
" <td>781.601920</td>\n",
" <td>620.851920</td>\n",
" <td>42.725129</td>\n",
" <td>-118.024871</td>\n",
" <td>-80.718080</td>\n",
" <td>782.553209</td>\n",
" <td>621.803209</td>\n",
" <td>659.11</td>\n",
" <td>-79.766791</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20639</th>\n",
" <td>2.3886</td>\n",
" <td>16.0</td>\n",
" <td>5.254717</td>\n",
" <td>1.162264</td>\n",
" <td>1387.0</td>\n",
" <td>2.616981</td>\n",
" <td>39.37</td>\n",
" <td>-121.24</td>\n",
" <td>18.3886</td>\n",
" <td>7.643317</td>\n",
" <td>3.550864</td>\n",
" <td>1389.3886</td>\n",
" <td>5.005581</td>\n",
" <td>41.7586</td>\n",
" <td>-118.8514</td>\n",
" <td>21.254717</td>\n",
" <td>17.162264</td>\n",
" <td>1403.0</td>\n",
" <td>18.616981</td>\n",
" <td>55.37</td>\n",
" <td>-105.24</td>\n",
" <td>6.416981</td>\n",
" <td>1392.254717</td>\n",
" <td>7.871698</td>\n",
" <td>44.624717</td>\n",
" <td>-115.985283</td>\n",
" <td>1388.162264</td>\n",
" <td>3.779245</td>\n",
" <td>40.532264</td>\n",
" <td>-120.077736</td>\n",
" <td>1389.616981</td>\n",
" <td>1426.37</td>\n",
" <td>1265.76</td>\n",
" <td>41.986981</td>\n",
" <td>-118.623019</td>\n",
" <td>-81.87</td>\n",
" <td>38.2176</td>\n",
" <td>12.551417</td>\n",
" <td>2.776184</td>\n",
" <td>3312.9882</td>\n",
" <td>...</td>\n",
" <td>1428.7586</td>\n",
" <td>1268.1486</td>\n",
" <td>44.375581</td>\n",
" <td>-116.234419</td>\n",
" <td>-79.4814</td>\n",
" <td>22.416981</td>\n",
" <td>1408.254717</td>\n",
" <td>23.871698</td>\n",
" <td>60.624717</td>\n",
" <td>-99.985283</td>\n",
" <td>1404.162264</td>\n",
" <td>19.779245</td>\n",
" <td>56.532264</td>\n",
" <td>-104.077736</td>\n",
" <td>1405.616981</td>\n",
" <td>1442.37</td>\n",
" <td>1281.76</td>\n",
" <td>57.986981</td>\n",
" <td>-102.623019</td>\n",
" <td>-65.87</td>\n",
" <td>1393.416981</td>\n",
" <td>9.033962</td>\n",
" <td>45.786981</td>\n",
" <td>-114.823019</td>\n",
" <td>1394.871698</td>\n",
" <td>1431.624717</td>\n",
" <td>1271.014717</td>\n",
" <td>47.241698</td>\n",
" <td>-113.368302</td>\n",
" <td>-76.615283</td>\n",
" <td>1390.779245</td>\n",
" <td>1427.532264</td>\n",
" <td>1266.922264</td>\n",
" <td>43.149245</td>\n",
" <td>-117.460755</td>\n",
" <td>-80.707736</td>\n",
" <td>1428.986981</td>\n",
" <td>1268.376981</td>\n",
" <td>1305.13</td>\n",
" <td>-79.253019</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>20640 rows × 148 columns</p>\n",
"</div>"
],
"text/plain": [
" MedInc ... AveOccupLatitudeLongitude_plus\n",
"0 8.3252 ... -81.794444\n",
"1 8.3014 ... -82.250158\n",
"2 7.2574 ... -81.587740\n",
"3 5.6431 ... -81.852055\n",
"4 3.8462 ... -82.218533\n",
"... ... ... ...\n",
"20635 1.5603 ... -79.049394\n",
"20636 2.5568 ... -78.597193\n",
"20637 1.7000 ... -79.464365\n",
"20638 1.8672 ... -79.766791\n",
"20639 2.3886 ... -79.253019\n",
"\n",
"[20640 rows x 148 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 5
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "JnH_ncW7B1u3"
},
"source": [
""
],
"execution_count": 5,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment