Deep_Feature_Synthesis_(DFS).ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Deep Feature Synthesis (DFS).ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyMeFUrDqIODKgdMK0OrtrZO",
      "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/github/arthurvaz05/Python.Script/blob/master/Deep_Feature_Synthesis_(DFS).ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Instalação Bibliotecas"
      ],
      "metadata": {
        "id": "VDpLVEd6HC-y"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "wFnRprLGG6sB",
        "outputId": "bd33298d-1fd1-4432-d5ee-8386f188bbe6"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Found existing installation: folium 0.2.1\n",
            "Uninstalling folium-0.2.1:\n",
            "  Successfully uninstalled folium-0.2.1\n",
            "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0m\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0mFound existing installation: urllib3 1.25.4\n",
            "Uninstalling urllib3-1.25.4:\n",
            "  Successfully uninstalled urllib3-1.25.4\n",
            "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0m\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0m"
          ]
        }
      ],
      "source": [
        "!pip uninstall -y folium\n",
        "!pip install -q folium==0.2.1\n",
        "!pip uninstall -y urllib3\n",
        "!pip install -q urllib3==1.25.4"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install -q --upgrade pip\n",
        "!pip uninstall -y featuretools\n",
        "#!pip install -q featuretools~=0.23.0\n",
        "!pip install -q featuretools~=0.1.14\n",
        "!pip uninstall -y pandas\n",
        "!pip install -q pandas~=1.1.0\n",
        "print('Bibliotecas instaladas com sucesso!!')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "urfCEMl7JfZf",
        "outputId": "2f1f1ae7-789c-4807-985f-e90916cd7471"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0mFound existing installation: featuretools 0.1.21\n",
            "Uninstalling featuretools-0.1.21:\n",
            "  Successfully uninstalled featuretools-0.1.21\n",
            "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0m\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0mFound existing installation: pandas 1.1.5\n",
            "Uninstalling pandas-1.1.5:\n",
            "  Successfully uninstalled pandas-1.1.5\n",
            "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0m\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0mBibliotecas instaladas com sucesso!!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "seqUW79c_Z7j",
        "outputId": "b6ae78fb-edce-4af2-9bf8-7a3800e16ced"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Carregar Bibliotecas"
      ],
      "metadata": {
        "id": "erG6OLuT74Rj"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import auth\n",
        "auth.authenticate_user()\n",
        "\n",
        "from pydrive.auth import GoogleAuth\n",
        "from pydrive.drive import GoogleDrive\n",
        "from google.colab import auth\n",
        "from oauth2client.client import GoogleCredentials\n",
        "\n",
        "gauth = GoogleAuth()\n",
        "gauth.credentials = GoogleCredentials.get_application_default()\n",
        "drive = GoogleDrive(gauth)\n",
        "data_drop = drive.CreateFile({'id':'10aXz56ohVOgF2gH4yvmrvTJFY990RHZ1'})\n",
        "data_drop.GetContentFile('dropoff_neighborhoods.csv')\n",
        "data_pick = drive.CreateFile({'id':'1zakjpcMUZTKanSeVlPWbYhL85zn5g8zX'})\n",
        "data_pick.GetContentFile('pickup_neighborhoods.csv')\n",
        "data_trips = drive.CreateFile({'id':'1D4OJPulDK-Z5l4mgwuI2C1zBr4JRC-Q5'})\n",
        "data_trips.GetContentFile('trips.pkl')\n",
        "utils_file = drive.CreateFile({'id':'1UbV2z7L5vonCz3KFLywGs4U-p2g5gQwy'})\n",
        "utils_file.GetContentFile('utils.py')\n",
        "\n",
        "print('Google Drive sincronizado com sucesso!')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "AtJHjHwjJgtF",
        "outputId": "e2d138ea-37f1-4ff0-a659-749d84d74a81"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Google Drive sincronizado com sucesso!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import featuretools as ft\n",
        "import matplotlib\n",
        "import matplotlib.pyplot as plt\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "import utils\n",
        "from featuretools.primitives import (Count, Day, Hour, Max, Mean, Median, Min,\n",
        "                                     Minute, Month, Std, Sum, Week, Weekday,\n",
        "                                     Weekend as Weekend)\n",
        "from sklearn.ensemble import GradientBoostingRegressor\n",
        "from utils import (compute_features, feature_importances, load_nyc_taxi_data,\n",
        "                   preview)\n",
        "%matplotlib inline\n",
        "\n",
        "print('Bibliotecas importadas com suceso!')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "GFK4N0QE_0_d",
        "outputId": "b115c7a8-7cae-4563-9480-f84636203592"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Bibliotecas importadas com suceso!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Exemplo 1"
      ],
      "metadata": {
        "id": "84-hprlNXZmR"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "trips, pickup_neighborhoods, dropoff_neighborhoods = load_nyc_taxi_data()\n",
        "preview(trips, 10)\n",
        "print('Dados carregados com sucesso!')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Me1hw3i5_hjM",
        "outputId": "f8d8577d-858e-49b9-eea8-829b00de42d0"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Dados carregados com sucesso!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Carregar dataset do Kaggle - Exemplo 2"
      ],
      "metadata": {
        "id": "7gICJaLA5rHK"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install kaggle"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7G9LDEuzm9T4",
        "outputId": "e3d69729-7747-44c0-a4f7-bdc4dc7ecaa8"
      },
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: kaggle in /usr/local/lib/python3.7/dist-packages (1.5.12)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.7/dist-packages (from kaggle) (2.23.0)\n",
            "Requirement already satisfied: urllib3 in /usr/local/lib/python3.7/dist-packages (from kaggle) (1.25.4)\n",
            "Requirement already satisfied: tqdm in /usr/local/lib/python3.7/dist-packages (from kaggle) (4.62.3)\n",
            "Requirement already satisfied: certifi in /usr/local/lib/python3.7/dist-packages (from kaggle) (2021.10.8)\n",
            "Requirement already satisfied: python-slugify in /usr/local/lib/python3.7/dist-packages (from kaggle) (5.0.2)\n",
            "Requirement already satisfied: six>=1.10 in /usr/local/lib/python3.7/dist-packages (from kaggle) (1.15.0)\n",
            "Requirement already satisfied: python-dateutil in /usr/local/lib/python3.7/dist-packages (from kaggle) (2.8.2)\n",
            "Requirement already satisfied: text-unidecode>=1.3 in /usr/local/lib/python3.7/dist-packages (from python-slugify->kaggle) (1.3)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests->kaggle) (3.0.4)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests->kaggle) (2.10)\n",
            "\u001b[33mWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv\u001b[0m\u001b[33m\n",
            "\u001b[0m"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import files\n",
        "\n",
        "uploaded = files.upload()\n",
        "\n",
        "for fn in uploaded.keys():\n",
        "  print('User uploaded file \"{name}\" with length {length} bytes'.format(\n",
        "      name=fn, length=len(uploaded[fn])))\n",
        "  \n",
        "# Then move kaggle.json into the folder where the API expects to find it.\n",
        "!mkdir -p ~/.kaggle/ && mv kaggle.json ~/.kaggle/ && chmod 600 ~/.kaggle/kaggle.json"
      ],
      "metadata": {
        "colab": {
          "resources": {
            "http://localhost:8080/nbextensions/google.colab/files.js": {
              "data": "Ly8gQ29weXJpZ2h0IDIwMTcgR29vZ2xlIExMQwovLwovLyBMaWNlbnNlZCB1bmRlciB0aGUgQXBhY2hlIExpY2Vuc2UsIFZlcnNpb24gMi4wICh0aGUgIkxpY2Vuc2UiKTsKLy8geW91IG1heSBub3QgdXNlIHRoaXMgZmlsZSBleGNlcHQgaW4gY29tcGxpYW5jZSB3aXRoIHRoZSBMaWNlbnNlLgovLyBZb3UgbWF5IG9idGFpbiBhIGNvcHkgb2YgdGhlIExpY2Vuc2UgYXQKLy8KLy8gICAgICBodHRwOi8vd3d3LmFwYWNoZS5vcmcvbGljZW5zZXMvTElDRU5TRS0yLjAKLy8KLy8gVW5sZXNzIHJlcXVpcmVkIGJ5IGFwcGxpY2FibGUgbGF3IG9yIGFncmVlZCB0byBpbiB3cml0aW5nLCBzb2Z0d2FyZQovLyBkaXN0cmlidXRlZCB1bmRlciB0aGUgTGljZW5zZSBpcyBkaXN0cmlidXRlZCBvbiBhbiAiQVMgSVMiIEJBU0lTLAovLyBXSVRIT1VUIFdBUlJBTlRJRVMgT1IgQ09ORElUSU9OUyBPRiBBTlkgS0lORCwgZWl0aGVyIGV4cHJlc3Mgb3IgaW1wbGllZC4KLy8gU2VlIHRoZSBMaWNlbnNlIGZvciB0aGUgc3BlY2lmaWMgbGFuZ3VhZ2UgZ292ZXJuaW5nIHBlcm1pc3Npb25zIGFuZAovLyBsaW1pdGF0aW9ucyB1bmRlciB0aGUgTGljZW5zZS4KCi8qKgogKiBAZmlsZW92ZXJ2aWV3IEhlbHBlcnMgZm9yIGdvb2dsZS5jb2xhYiBQeXRob24gbW9kdWxlLgogKi8KKGZ1bmN0aW9uKHNjb3BlKSB7CmZ1bmN0aW9uIHNwYW4odGV4dCwgc3R5bGVBdHRyaWJ1dGVzID0ge30pIHsKICBjb25zdCBlbGVtZW50ID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgnc3BhbicpOwogIGVsZW1lbnQudGV4dENvbnRlbnQgPSB0ZXh0OwogIGZvciAoY29uc3Qga2V5IG9mIE9iamVjdC5rZXlzKHN0eWxlQXR0cmlidXRlcykpIHsKICAgIGVsZW1lbnQuc3R5bGVba2V5XSA9IHN0eWxlQXR0cmlidXRlc1trZXldOwogIH0KICByZXR1cm4gZWxlbWVudDsKfQoKLy8gTWF4IG51bWJlciBvZiBieXRlcyB3aGljaCB3aWxsIGJlIHVwbG9hZGVkIGF0IGEgdGltZS4KY29uc3QgTUFYX1BBWUxPQURfU0laRSA9IDEwMCAqIDEwMjQ7CgpmdW5jdGlvbiBfdXBsb2FkRmlsZXMoaW5wdXRJZCwgb3V0cHV0SWQpIHsKICBjb25zdCBzdGVwcyA9IHVwbG9hZEZpbGVzU3RlcChpbnB1dElkLCBvdXRwdXRJZCk7CiAgY29uc3Qgb3V0cHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKG91dHB1dElkKTsKICAvLyBDYWNoZSBzdGVwcyBvbiB0aGUgb3V0cHV0RWxlbWVudCB0byBtYWtlIGl0IGF2YWlsYWJsZSBmb3IgdGhlIG5leHQgY2FsbAogIC8vIHRvIHVwbG9hZEZpbGVzQ29udGludWUgZnJvbSBQeXRob24uCiAgb3V0cHV0RWxlbWVudC5zdGVwcyA9IHN0ZXBzOwoKICByZXR1cm4gX3VwbG9hZEZpbGVzQ29udGludWUob3V0cHV0SWQpOwp9CgovLyBUaGlzIGlzIHJvdWdobHkgYW4gYXN5bmMgZ2VuZXJhdG9yIChub3Qgc3VwcG9ydGVkIGluIHRoZSBicm93c2VyIHlldCksCi8vIHdoZXJlIHRoZXJlIGFyZSBtdWx0aXBsZSBhc3luY2hyb25vdXMgc3RlcHMgYW5kIHRoZSBQeXRob24gc2lkZSBpcyBnb2luZwovLyB0byBwb2xsIGZvciBjb21wbGV0aW9uIG9mIGVhY2ggc3RlcC4KLy8gVGhpcyB1c2VzIGEgUHJvbWlzZSB0byBibG9jayB0aGUgcHl0aG9uIHNpZGUgb24gY29tcGxldGlvbiBvZiBlYWNoIHN0ZXAsCi8vIHRoZW4gcGFzc2VzIHRoZSByZXN1bHQgb2YgdGhlIHByZXZpb3VzIHN0ZXAgYXMgdGhlIGlucHV0IHRvIHRoZSBuZXh0IHN0ZXAuCmZ1bmN0aW9uIF91cGxvYWRGaWxlc0NvbnRpbnVlKG91dHB1dElkKSB7CiAgY29uc3Qgb3V0cHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKG91dHB1dElkKTsKICBjb25zdCBzdGVwcyA9IG91dHB1dEVsZW1lbnQuc3RlcHM7CgogIGNvbnN0IG5leHQgPSBzdGVwcy5uZXh0KG91dHB1dEVsZW1lbnQubGFzdFByb21pc2VWYWx1ZSk7CiAgcmV0dXJuIFByb21pc2UucmVzb2x2ZShuZXh0LnZhbHVlLnByb21pc2UpLnRoZW4oKHZhbHVlKSA9PiB7CiAgICAvLyBDYWNoZSB0aGUgbGFzdCBwcm9taXNlIHZhbHVlIHRvIG1ha2UgaXQgYXZhaWxhYmxlIHRvIHRoZSBuZXh0CiAgICAvLyBzdGVwIG9mIHRoZSBnZW5lcmF0b3IuCiAgICBvdXRwdXRFbGVtZW50Lmxhc3RQcm9taXNlVmFsdWUgPSB2YWx1ZTsKICAgIHJldHVybiBuZXh0LnZhbHVlLnJlc3BvbnNlOwogIH0pOwp9CgovKioKICogR2VuZXJhdG9yIGZ1bmN0aW9uIHdoaWNoIGlzIGNhbGxlZCBiZXR3ZWVuIGVhY2ggYXN5bmMgc3RlcCBvZiB0aGUgdXBsb2FkCiAqIHByb2Nlc3MuCiAqIEBwYXJhbSB7c3RyaW5nfSBpbnB1dElkIEVsZW1lbnQgSUQgb2YgdGhlIGlucHV0IGZpbGUgcGlja2VyIGVsZW1lbnQuCiAqIEBwYXJhbSB7c3RyaW5nfSBvdXRwdXRJZCBFbGVtZW50IElEIG9mIHRoZSBvdXRwdXQgZGlzcGxheS4KICogQHJldHVybiB7IUl0ZXJhYmxlPCFPYmplY3Q+fSBJdGVyYWJsZSBvZiBuZXh0IHN0ZXBzLgogKi8KZnVuY3Rpb24qIHVwbG9hZEZpbGVzU3RlcChpbnB1dElkLCBvdXRwdXRJZCkgewogIGNvbnN0IGlucHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKGlucHV0SWQpOwogIGlucHV0RWxlbWVudC5kaXNhYmxlZCA9IGZhbHNlOwoKICBjb25zdCBvdXRwdXRFbGVtZW50ID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQob3V0cHV0SWQpOwogIG91dHB1dEVsZW1lbnQuaW5uZXJIVE1MID0gJyc7CgogIGNvbnN0IHBpY2tlZFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgaW5wdXRFbGVtZW50LmFkZEV2ZW50TGlzdGVuZXIoJ2NoYW5nZScsIChlKSA9PiB7CiAgICAgIHJlc29sdmUoZS50YXJnZXQuZmlsZXMpOwogICAgfSk7CiAgfSk7CgogIGNvbnN0IGNhbmNlbCA9IGRvY3VtZW50LmNyZWF0ZUVsZW1lbnQoJ2J1dHRvbicpOwogIGlucHV0RWxlbWVudC5wYXJlbnRFbGVtZW50LmFwcGVuZENoaWxkKGNhbmNlbCk7CiAgY2FuY2VsLnRleHRDb250ZW50ID0gJ0NhbmNlbCB1cGxvYWQnOwogIGNvbnN0IGNhbmNlbFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgY2FuY2VsLm9uY2xpY2sgPSAoKSA9PiB7CiAgICAgIHJlc29sdmUobnVsbCk7CiAgICB9OwogIH0pOwoKICAvLyBXYWl0IGZvciB0aGUgdXNlciB0byBwaWNrIHRoZSBmaWxlcy4KICBjb25zdCBmaWxlcyA9IHlpZWxkIHsKICAgIHByb21pc2U6IFByb21pc2UucmFjZShbcGlja2VkUHJvbWlzZSwgY2FuY2VsUHJvbWlzZV0pLAogICAgcmVzcG9uc2U6IHsKICAgICAgYWN0aW9uOiAnc3RhcnRpbmcnLAogICAgfQogIH07CgogIGNhbmNlbC5yZW1vdmUoKTsKCiAgLy8gRGlzYWJsZSB0aGUgaW5wdXQgZWxlbWVudCBzaW5jZSBmdXJ0aGVyIHBpY2tzIGFyZSBub3QgYWxsb3dlZC4KICBpbnB1dEVsZW1lbnQuZGlzYWJsZWQgPSB0cnVlOwoKICBpZiAoIWZpbGVzKSB7CiAgICByZXR1cm4gewogICAgICByZXNwb25zZTogewogICAgICAgIGFjdGlvbjogJ2NvbXBsZXRlJywKICAgICAgfQogICAgfTsKICB9CgogIGZvciAoY29uc3QgZmlsZSBvZiBmaWxlcykgewogICAgY29uc3QgbGkgPSBkb2N1bWVudC5jcmVhdGVFbGVtZW50KCdsaScpOwogICAgbGkuYXBwZW5kKHNwYW4oZmlsZS5uYW1lLCB7Zm9udFdlaWdodDogJ2JvbGQnfSkpOwogICAgbGkuYXBwZW5kKHNwYW4oCiAgICAgICAgYCgke2ZpbGUudHlwZSB8fCAnbi9hJ30pIC0gJHtmaWxlLnNpemV9IGJ5dGVzLCBgICsKICAgICAgICBgbGFzdCBtb2RpZmllZDogJHsKICAgICAgICAgICAgZmlsZS5sYXN0TW9kaWZpZWREYXRlID8gZmlsZS5sYXN0TW9kaWZpZWREYXRlLnRvTG9jYWxlRGF0ZVN0cmluZygpIDoKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgJ24vYSd9IC0gYCkpOwogICAgY29uc3QgcGVyY2VudCA9IHNwYW4oJzAlIGRvbmUnKTsKICAgIGxpLmFwcGVuZENoaWxkKHBlcmNlbnQpOwoKICAgIG91dHB1dEVsZW1lbnQuYXBwZW5kQ2hpbGQobGkpOwoKICAgIGNvbnN0IGZpbGVEYXRhUHJvbWlzZSA9IG5ldyBQcm9taXNlKChyZXNvbHZlKSA9PiB7CiAgICAgIGNvbnN0IHJlYWRlciA9IG5ldyBGaWxlUmVhZGVyKCk7CiAgICAgIHJlYWRlci5vbmxvYWQgPSAoZSkgPT4gewogICAgICAgIHJlc29sdmUoZS50YXJnZXQucmVzdWx0KTsKICAgICAgfTsKICAgICAgcmVhZGVyLnJlYWRBc0FycmF5QnVmZmVyKGZpbGUpOwogICAgfSk7CiAgICAvLyBXYWl0IGZvciB0aGUgZGF0YSB0byBiZSByZWFkeS4KICAgIGxldCBmaWxlRGF0YSA9IHlpZWxkIHsKICAgICAgcHJvbWlzZTogZmlsZURhdGFQcm9taXNlLAogICAgICByZXNwb25zZTogewogICAgICAgIGFjdGlvbjogJ2NvbnRpbnVlJywKICAgICAgfQogICAgfTsKCiAgICAvLyBVc2UgYSBjaHVua2VkIHNlbmRpbmcgdG8gYXZvaWQgbWVzc2FnZSBzaXplIGxpbWl0cy4gU2VlIGIvNjIxMTU2NjAuCiAgICBsZXQgcG9zaXRpb24gPSAwOwogICAgZG8gewogICAgICBjb25zdCBsZW5ndGggPSBNYXRoLm1pbihmaWxlRGF0YS5ieXRlTGVuZ3RoIC0gcG9zaXRpb24sIE1BWF9QQVlMT0FEX1NJWkUpOwogICAgICBjb25zdCBjaHVuayA9IG5ldyBVaW50OEFycmF5KGZpbGVEYXRhLCBwb3NpdGlvbiwgbGVuZ3RoKTsKICAgICAgcG9zaXRpb24gKz0gbGVuZ3RoOwoKICAgICAgY29uc3QgYmFzZTY0ID0gYnRvYShTdHJpbmcuZnJvbUNoYXJDb2RlLmFwcGx5KG51bGwsIGNodW5rKSk7CiAgICAgIHlpZWxkIHsKICAgICAgICByZXNwb25zZTogewogICAgICAgICAgYWN0aW9uOiAnYXBwZW5kJywKICAgICAgICAgIGZpbGU6IGZpbGUubmFtZSwKICAgICAgICAgIGRhdGE6IGJhc2U2NCwKICAgICAgICB9LAogICAgICB9OwoKICAgICAgbGV0IHBlcmNlbnREb25lID0gZmlsZURhdGEuYnl0ZUxlbmd0aCA9PT0gMCA/CiAgICAgICAgICAxMDAgOgogICAgICAgICAgTWF0aC5yb3VuZCgocG9zaXRpb24gLyBmaWxlRGF0YS5ieXRlTGVuZ3RoKSAqIDEwMCk7CiAgICAgIHBlcmNlbnQudGV4dENvbnRlbnQgPSBgJHtwZXJjZW50RG9uZX0lIGRvbmVgOwoKICAgIH0gd2hpbGUgKHBvc2l0aW9uIDwgZmlsZURhdGEuYnl0ZUxlbmd0aCk7CiAgfQoKICAvLyBBbGwgZG9uZS4KICB5aWVsZCB7CiAgICByZXNwb25zZTogewogICAgICBhY3Rpb246ICdjb21wbGV0ZScsCiAgICB9CiAgfTsKfQoKc2NvcGUuZ29vZ2xlID0gc2NvcGUuZ29vZ2xlIHx8IHt9OwpzY29wZS5nb29nbGUuY29sYWIgPSBzY29wZS5nb29nbGUuY29sYWIgfHwge307CnNjb3BlLmdvb2dsZS5jb2xhYi5fZmlsZXMgPSB7CiAgX3VwbG9hZEZpbGVzLAogIF91cGxvYWRGaWxlc0NvbnRpbnVlLAp9Owp9KShzZWxmKTsK",
              "ok": true,
              "headers": [
                [
                  "content-type",
                  "application/javascript"
                ]
              ],
              "status": 200,
              "status_text": ""
            }
          },
          "base_uri": "https://localhost:8080/",
          "height": 90
        },
        "id": "9Us4flOriWol",
        "outputId": "3721fb7e-c365-4fd3-8148-5d86439080a9"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-9c3f0c0a-d0eb-49a5-b81c-fbec61f8e448\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-9c3f0c0a-d0eb-49a5-b81c-fbec61f8e448\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script src=\"/nbextensions/google.colab/files.js\"></script> "
            ],
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving kaggle.json to kaggle.json\n",
            "User uploaded file \"kaggle.json\" with length 67 bytes\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!kaggle datasets download \"willkoehrsen/automated-feature-engineering-demo\""
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DACOFJ8Qs32e",
        "outputId": "6dc5f86b-68a9-4a32-f776-9a8de1a94c11"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "automated-feature-engineering-demo.zip: Skipping, found more recently modified local copy (use --force to force download)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!unzip automated-feature-engineering-demo.zip"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "YTH4pgL64gE2",
        "outputId": "b6fb0b6d-b516-43ae-f91d-bd8bff425c8a"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Archive:  automated-feature-engineering-demo.zip\n",
            "replace clients.csv? [y]es, [n]o, [A]ll, [N]one, [r]ename: A\n",
            "  inflating: clients.csv             \n",
            "  inflating: loans.csv               \n",
            "  inflating: payments.csv            \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd \n",
        "\n",
        "basepath = \"/Data Sources/automated feature engineering demo/\"\n",
        "clients = pd.read_csv(\"clients.csv\")\n",
        "loans = pd.read_csv(\"loans.csv\")\n",
        "payments = pd.read_csv(\"payments.csv\")"
      ],
      "metadata": {
        "id": "17i696NYtZ9U"
      },
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# DFS"
      ],
      "metadata": {
        "id": "LgbCJDLgfPtZ"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Explorando os dados dos exemplos"
      ],
      "metadata": {
        "id": "sq9Y48S-ZeIL"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "trips.head(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 357
        },
        "id": "PypW8USrZhoM",
        "outputId": "f2c566d5-b5c4-4228-bde8-5441482f0199"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-35cfdba4-2b21-4b12-94d9-b15fb3560826\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id</th>\n",
              "      <th>vendor_id</th>\n",
              "      <th>pickup_datetime</th>\n",
              "      <th>dropoff_datetime</th>\n",
              "      <th>passenger_count</th>\n",
              "      <th>trip_distance</th>\n",
              "      <th>pickup_longitude</th>\n",
              "      <th>pickup_latitude</th>\n",
              "      <th>dropoff_longitude</th>\n",
              "      <th>dropoff_latitude</th>\n",
              "      <th>payment_type</th>\n",
              "      <th>trip_duration</th>\n",
              "      <th>pickup_neighborhood</th>\n",
              "      <th>dropoff_neighborhood</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>514030</td>\n",
              "      <td>2</td>\n",
              "      <td>2016-04-02 00:00:00</td>\n",
              "      <td>2016-04-02 00:17:00</td>\n",
              "      <td>1</td>\n",
              "      <td>2.46</td>\n",
              "      <td>-73.987595</td>\n",
              "      <td>40.754711</td>\n",
              "      <td>-73.959633</td>\n",
              "      <td>40.762836</td>\n",
              "      <td>1</td>\n",
              "      <td>1039</td>\n",
              "      <td>AA</td>\n",
              "      <td>K</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>514031</td>\n",
              "      <td>1</td>\n",
              "      <td>2016-04-02 00:00:00</td>\n",
              "      <td>2016-04-02 00:24:00</td>\n",
              "      <td>2</td>\n",
              "      <td>7.90</td>\n",
              "      <td>-73.924713</td>\n",
              "      <td>40.745567</td>\n",
              "      <td>-73.972763</td>\n",
              "      <td>40.793354</td>\n",
              "      <td>1</td>\n",
              "      <td>1454</td>\n",
              "      <td>L</td>\n",
              "      <td>U</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>514032</td>\n",
              "      <td>1</td>\n",
              "      <td>2016-04-02 00:00:00</td>\n",
              "      <td>2016-04-02 00:19:00</td>\n",
              "      <td>1</td>\n",
              "      <td>1.00</td>\n",
              "      <td>-73.989800</td>\n",
              "      <td>40.732994</td>\n",
              "      <td>-74.000557</td>\n",
              "      <td>40.742622</td>\n",
              "      <td>1</td>\n",
              "      <td>1168</td>\n",
              "      <td>H</td>\n",
              "      <td>Q</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>514033</td>\n",
              "      <td>2</td>\n",
              "      <td>2016-04-02 00:00:00</td>\n",
              "      <td>2016-04-02 00:01:00</td>\n",
              "      <td>1</td>\n",
              "      <td>0.02</td>\n",
              "      <td>-73.987465</td>\n",
              "      <td>40.719822</td>\n",
              "      <td>-73.987289</td>\n",
              "      <td>40.720016</td>\n",
              "      <td>2</td>\n",
              "      <td>35</td>\n",
              "      <td>AC</td>\n",
              "      <td>AC</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>514034</td>\n",
              "      <td>1</td>\n",
              "      <td>2016-04-02 00:01:00</td>\n",
              "      <td>2016-04-02 00:58:00</td>\n",
              "      <td>2</td>\n",
              "      <td>19.00</td>\n",
              "      <td>-73.790131</td>\n",
              "      <td>40.643429</td>\n",
              "      <td>-73.975594</td>\n",
              "      <td>40.779327</td>\n",
              "      <td>1</td>\n",
              "      <td>3470</td>\n",
              "      <td>G</td>\n",
              "      <td>I</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-35cfdba4-2b21-4b12-94d9-b15fb3560826')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-35cfdba4-2b21-4b12-94d9-b15fb3560826 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-35cfdba4-2b21-4b12-94d9-b15fb3560826');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "       id  vendor_id  ... pickup_neighborhood dropoff_neighborhood\n",
              "0  514030          2  ...                  AA                    K\n",
              "1  514031          1  ...                   L                    U\n",
              "2  514032          1  ...                   H                    Q\n",
              "3  514033          2  ...                  AC                   AC\n",
              "4  514034          1  ...                   G                    I\n",
              "\n",
              "[5 rows x 14 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pickup_neighborhoods.head(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "Y2NLpZeyZhgb",
        "outputId": "42417610-fae4-493a-9b48-d681c8d3f9e8"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-7dfc6a48-374f-4818-8244-8da984712926\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>neighborhood_id</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>AH</td>\n",
              "      <td>40.804349</td>\n",
              "      <td>-73.961716</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Z</td>\n",
              "      <td>40.715828</td>\n",
              "      <td>-73.954298</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>D</td>\n",
              "      <td>40.750179</td>\n",
              "      <td>-73.992557</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>AT</td>\n",
              "      <td>40.729670</td>\n",
              "      <td>-73.981693</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AG</td>\n",
              "      <td>40.749843</td>\n",
              "      <td>-74.003458</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7dfc6a48-374f-4818-8244-8da984712926')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7dfc6a48-374f-4818-8244-8da984712926 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7dfc6a48-374f-4818-8244-8da984712926');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "  neighborhood_id   latitude  longitude\n",
              "0              AH  40.804349 -73.961716\n",
              "1               Z  40.715828 -73.954298\n",
              "2               D  40.750179 -73.992557\n",
              "3              AT  40.729670 -73.981693\n",
              "4              AG  40.749843 -74.003458"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dropoff_neighborhoods.head(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "TrbhsqC9daOG",
        "outputId": "ee233e5f-00e7-497c-caed-64d12b0e4b6f"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-a4c78d0e-a655-46ae-b873-0b3b429ca7d6\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>neighborhood_id</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>C</td>\n",
              "      <td>40.783780</td>\n",
              "      <td>-73.953145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>S</td>\n",
              "      <td>40.836792</td>\n",
              "      <td>-73.934381</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>AL</td>\n",
              "      <td>40.818445</td>\n",
              "      <td>-73.948046</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>J</td>\n",
              "      <td>40.799573</td>\n",
              "      <td>-73.940427</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AV</td>\n",
              "      <td>40.776270</td>\n",
              "      <td>-73.982322</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a4c78d0e-a655-46ae-b873-0b3b429ca7d6')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a4c78d0e-a655-46ae-b873-0b3b429ca7d6 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a4c78d0e-a655-46ae-b873-0b3b429ca7d6');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "  neighborhood_id   latitude  longitude\n",
              "0               C  40.783780 -73.953145\n",
              "1               S  40.836792 -73.934381\n",
              "2              AL  40.818445 -73.948046\n",
              "3               J  40.799573 -73.940427\n",
              "4              AV  40.776270 -73.982322"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "clients.head(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "mOoBkvxPdeAX",
        "outputId": "7f38c87d-1b80-45a5-a634-863acc5c11c9"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-75438d59-c95c-480f-b769-ff94e2fdb490\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>client_id</th>\n",
              "      <th>joined</th>\n",
              "      <th>income</th>\n",
              "      <th>credit_score</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>46109</td>\n",
              "      <td>2002-04-16</td>\n",
              "      <td>172677</td>\n",
              "      <td>527</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>49545</td>\n",
              "      <td>2007-11-14</td>\n",
              "      <td>104564</td>\n",
              "      <td>770</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>41480</td>\n",
              "      <td>2013-03-11</td>\n",
              "      <td>122607</td>\n",
              "      <td>585</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>46180</td>\n",
              "      <td>2001-11-06</td>\n",
              "      <td>43851</td>\n",
              "      <td>562</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>25707</td>\n",
              "      <td>2006-10-06</td>\n",
              "      <td>211422</td>\n",
              "      <td>621</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-75438d59-c95c-480f-b769-ff94e2fdb490')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-75438d59-c95c-480f-b769-ff94e2fdb490 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-75438d59-c95c-480f-b769-ff94e2fdb490');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "   client_id      joined  income  credit_score\n",
              "0      46109  2002-04-16  172677           527\n",
              "1      49545  2007-11-14  104564           770\n",
              "2      41480  2013-03-11  122607           585\n",
              "3      46180  2001-11-06   43851           562\n",
              "4      25707  2006-10-06  211422           621"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "loans.head(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "mTs5GNr_dgkx",
        "outputId": "1691e11d-d0e7-4cb2-ea16-a38119c12d1f"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-5f3ae9d8-2cdd-4d36-b1f1-fbb620a51671\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>client_id</th>\n",
              "      <th>loan_type</th>\n",
              "      <th>loan_amount</th>\n",
              "      <th>repaid</th>\n",
              "      <th>loan_id</th>\n",
              "      <th>loan_start</th>\n",
              "      <th>loan_end</th>\n",
              "      <th>rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>46109</td>\n",
              "      <td>home</td>\n",
              "      <td>13672</td>\n",
              "      <td>0</td>\n",
              "      <td>10243</td>\n",
              "      <td>2002-04-16</td>\n",
              "      <td>2003-12-20</td>\n",
              "      <td>2.15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>46109</td>\n",
              "      <td>credit</td>\n",
              "      <td>9794</td>\n",
              "      <td>0</td>\n",
              "      <td>10984</td>\n",
              "      <td>2003-10-21</td>\n",
              "      <td>2005-07-17</td>\n",
              "      <td>1.25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>46109</td>\n",
              "      <td>home</td>\n",
              "      <td>12734</td>\n",
              "      <td>1</td>\n",
              "      <td>10990</td>\n",
              "      <td>2006-02-01</td>\n",
              "      <td>2007-07-05</td>\n",
              "      <td>0.68</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>46109</td>\n",
              "      <td>cash</td>\n",
              "      <td>12518</td>\n",
              "      <td>1</td>\n",
              "      <td>10596</td>\n",
              "      <td>2010-12-08</td>\n",
              "      <td>2013-05-05</td>\n",
              "      <td>1.24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>46109</td>\n",
              "      <td>credit</td>\n",
              "      <td>14049</td>\n",
              "      <td>1</td>\n",
              "      <td>11415</td>\n",
              "      <td>2010-07-07</td>\n",
              "      <td>2012-05-21</td>\n",
              "      <td>3.13</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5f3ae9d8-2cdd-4d36-b1f1-fbb620a51671')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-5f3ae9d8-2cdd-4d36-b1f1-fbb620a51671 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-5f3ae9d8-2cdd-4d36-b1f1-fbb620a51671');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "   client_id loan_type  loan_amount  ...  loan_start    loan_end  rate\n",
              "0      46109      home        13672  ...  2002-04-16  2003-12-20  2.15\n",
              "1      46109    credit         9794  ...  2003-10-21  2005-07-17  1.25\n",
              "2      46109      home        12734  ...  2006-02-01  2007-07-05  0.68\n",
              "3      46109      cash        12518  ...  2010-12-08  2013-05-05  1.24\n",
              "4      46109    credit        14049  ...  2010-07-07  2012-05-21  3.13\n",
              "\n",
              "[5 rows x 8 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "payments.head(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "9XanaYMPdnRO",
        "outputId": "b2ecbf77-f66a-4dcb-ea26-f7d24abdb0c7"
      },
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-bcf4be93-e3e0-48c6-b26a-3779005eec0a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>loan_id</th>\n",
              "      <th>payment_amount</th>\n",
              "      <th>payment_date</th>\n",
              "      <th>missed</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10243</td>\n",
              "      <td>2369</td>\n",
              "      <td>2002-05-31</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>10243</td>\n",
              "      <td>2439</td>\n",
              "      <td>2002-06-18</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>10243</td>\n",
              "      <td>2662</td>\n",
              "      <td>2002-06-29</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>10243</td>\n",
              "      <td>2268</td>\n",
              "      <td>2002-07-20</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>10243</td>\n",
              "      <td>2027</td>\n",
              "      <td>2002-07-31</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bcf4be93-e3e0-48c6-b26a-3779005eec0a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bcf4be93-e3e0-48c6-b26a-3779005eec0a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bcf4be93-e3e0-48c6-b26a-3779005eec0a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "   loan_id  payment_amount payment_date  missed\n",
              "0    10243            2369   2002-05-31       1\n",
              "1    10243            2439   2002-06-18       1\n",
              "2    10243            2662   2002-06-29       0\n",
              "3    10243            2268   2002-07-20       0\n",
              "4    10243            2027   2002-07-31       1"
            ]
          },
          "metadata": {},
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Entidades e relações"
      ],
      "metadata": {
        "id": "vg-PHZclf8St"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Exemplo 1 - direto, mencionando a variavel que vai ficar como index e a variavel que tem formato de data. Colocar no formato de dicionário\n",
        "entities = {\n",
        "    \"trips\": (trips, \"id\", 'pickup_datetime'),\n",
        "    \"pickup_neighborhoods\": (pickup_neighborhoods, \"neighborhood_id\"),\n",
        "    \"dropoff_neighborhoods\": (dropoff_neighborhoods, \"neighborhood_id\"),\n",
        "}"
      ],
      "metadata": {
        "id": "3AfZ0NdDf-dr"
      },
      "execution_count": 21,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Exemplo 2 - podemos criar de forma mais customizada e indicando as variáveis \n",
        "#Cria o set de dataframes ou tabelas\n",
        "es = ft.EntitySet(id = 'clients')\n",
        "#Cria uma entity do dataset client\n",
        "# Esse dataset já tem u index e time index\n",
        "es = es.entity_from_dataframe(entity_id = 'clients', dataframe = clients, \n",
        "                              index = 'client_id', time_index = 'joined')\n",
        "#Cria uma entity do dataset loans\n",
        "es = es.entity_from_dataframe(entity_id = 'loans', dataframe = loans, \n",
        "                              variable_types = {'repaid': ft.variable_types.Categorical},\n",
        "                              index = 'loan_id', \n",
        "                              time_index = 'loan_start')\n",
        "#Cria uma entity do dataset payments\n",
        "# Esse dataset não possui index mas possui time index\n",
        "es = es.entity_from_dataframe(entity_id = 'payments', \n",
        "                              dataframe = payments,\n",
        "                              variable_types = {'missed': ft.variable_types.Categorical},\n",
        "                              make_index = True,\n",
        "                              index = 'payment_id',\n",
        "                              time_index = 'payment_date')"
      ],
      "metadata": {
        "id": "g1-k3HXmY6gk"
      },
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "es"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2evDpC6mY6Mq",
        "outputId": "27cedbac-18b1-4a4a-8287-7da77c841ee6"
      },
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Entityset: clients\n",
              "  Entities:\n",
              "    clients [Rows: 25, Columns: 4]\n",
              "    loans [Rows: 443, Columns: 8]\n",
              "    payments [Rows: 3456, Columns: 5]\n",
              "  Relationships:\n",
              "    No relationships"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Relationships"
      ],
      "metadata": {
        "id": "fvIYjrO7q-zJ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Exemplo 1 - na mesma lógica do entity, criar uma lista para indicar as relações\n",
        "relationships = [(\"pickup_neighborhoods\", \"neighborhood_id\", \"trips\", \"pickup_neighborhood\"),\n",
        "                 (\"dropoff_neighborhoods\", \"neighborhood_id\", \"trips\", \"dropoff_neighborhood\")]"
      ],
      "metadata": {
        "id": "iReVjteJrAuY"
      },
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Exemplo 2 - Criar diretamente no grupo de função DFS, as relações das variaveis clients e loans atraves da variavel em comum client_id\n",
        "r_client_previous = ft.Relationship(es['clients']['client_id'],es['loans']['client_id'])\n",
        "\n",
        "# Adicionar no entity set criado\n",
        "es = es.add_relationship(r_client_previous)\n",
        "\n",
        "# Exemplo 2 - Criar diretamente no grupo de função DFS, as relações das variaveis loans e payments atraves da variavel em comum loan_id\n",
        "r_payments = ft.Relationship(es['loans']['loan_id'],es['payments']['loan_id'])\n",
        "\n",
        "# Adicionar no entity set criado\n",
        "es = es.add_relationship(r_payments)\n",
        "\n"
      ],
      "metadata": {
        "id": "jVnhUpEirAiB"
      },
      "execution_count": 25,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Feature Primitives"
      ],
      "metadata": {
        "id": "NAwwG7qJfTkw"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "primitives = ft.list_primitives()\n",
        "pd.options.display.max_colwidth = 100\n",
        "primitives[primitives['type'] == 'transform'].head(10)"
      ],
      "metadata": {
        "id": "cZb1KJsd_tIT",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "80757333-af8a-47b4-8fc4-0019167392e4"
      },
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-600d8e27-6a4b-4f8c-bf08-759ce2bf5e0c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>name</th>\n",
              "      <th>type</th>\n",
              "      <th>description</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>not</td>\n",
              "      <td>transform</td>\n",
              "      <td>For each value of the base feature, negates the boolean value.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>seconds</td>\n",
              "      <td>transform</td>\n",
              "      <td>Transform a Timedelta feature into the number of seconds.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>hours</td>\n",
              "      <td>transform</td>\n",
              "      <td>Transform a Timedelta feature into the number of hours.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>isin</td>\n",
              "      <td>transform</td>\n",
              "      <td>For each value of the base feature, checks whether it is in a provided list.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>days</td>\n",
              "      <td>transform</td>\n",
              "      <td>Transform a Timedelta feature into the number of days.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>time_since</td>\n",
              "      <td>transform</td>\n",
              "      <td>Calculates time since the cutoff time.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>mod</td>\n",
              "      <td>transform</td>\n",
              "      <td>Creates a transform feature that divides two features.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>characters</td>\n",
              "      <td>transform</td>\n",
              "      <td>Return the characters in a given string.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>cum_max</td>\n",
              "      <td>transform</td>\n",
              "      <td>Calculates the max of previous values of an instance for each value in a time-dependent entity.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>multiply</td>\n",
              "      <td>transform</td>\n",
              "      <td>Creates a transform feature that multplies two features.</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-600d8e27-6a4b-4f8c-bf08-759ce2bf5e0c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-600d8e27-6a4b-4f8c-bf08-759ce2bf5e0c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-600d8e27-6a4b-4f8c-bf08-759ce2bf5e0c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "          name  ...                                                                                      description\n",
              "19         not  ...                                   For each value of the base feature, negates the boolean value.\n",
              "20     seconds  ...                                        Transform a Timedelta feature into the number of seconds.\n",
              "21       hours  ...                                          Transform a Timedelta feature into the number of hours.\n",
              "22        isin  ...                     For each value of the base feature, checks whether it is in a provided list.\n",
              "23        days  ...                                           Transform a Timedelta feature into the number of days.\n",
              "24  time_since  ...                                                           Calculates time since the cutoff time.\n",
              "25         mod  ...                                           Creates a transform feature that divides two features.\n",
              "26  characters  ...                                                         Return the characters in a given string.\n",
              "27     cum_max  ...  Calculates the max of previous values of an instance for each value in a time-dependent entity.\n",
              "28    multiply  ...                                         Creates a transform feature that multplies two features.\n",
              "\n",
              "[10 rows x 3 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "primitives[primitives['type'] == 'aggregation'].head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "1QpcXmBJXz1p",
        "outputId": "69e1ec03-a9b0-489e-b247-dc9cfeac5148"
      },
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-5bfdc8c2-5b47-41f8-8971-d075462b1449\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>name</th>\n",
              "      <th>type</th>\n",
              "      <th>description</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>std</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Finds the standard deviation of a numeric feature ignoring null values.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>count</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Counts the number of non null values.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>median</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Finds the median value of any feature with well-ordered values.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>n_most_common</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Finds the N most common elements in a categorical feature.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>num_true</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Finds the number of 'True' values in a boolean.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>max</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Finds the maximum non-null value of a numeric feature.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>mode</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Finds the most common element in a categorical feature.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>sum</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Counts the number of elements of a numeric or boolean feature.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>trend</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Calculates the slope of the linear trend of variable overtime.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>all</td>\n",
              "      <td>aggregation</td>\n",
              "      <td>Test if all values are 'True'.</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5bfdc8c2-5b47-41f8-8971-d075462b1449')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-5bfdc8c2-5b47-41f8-8971-d075462b1449 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-5bfdc8c2-5b47-41f8-8971-d075462b1449');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "            name  ...                                                              description\n",
              "0            std  ...  Finds the standard deviation of a numeric feature ignoring null values.\n",
              "1          count  ...                                    Counts the number of non null values.\n",
              "2         median  ...          Finds the median value of any feature with well-ordered values.\n",
              "3  n_most_common  ...               Finds the N most common elements in a categorical feature.\n",
              "4       num_true  ...                          Finds the number of 'True' values in a boolean.\n",
              "5            max  ...                   Finds the maximum non-null value of a numeric feature.\n",
              "6           mode  ...                  Finds the most common element in a categorical feature.\n",
              "7            sum  ...           Counts the number of elements of a numeric or boolean feature.\n",
              "8          trend  ...           Calculates the slope of the linear trend of variable overtime.\n",
              "9            all  ...                                           Test if all values are 'True'.\n",
              "\n",
              "[10 rows x 3 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Exemplo 1 - Montar a função DSF\n",
        "features1, feature_names1 = ft.dfs(entityset = es, target_entity = 'clients', \n",
        "                                 agg_primitives = ['mean', 'max', 'percent_true', 'last'],\n",
        "                                 trans_primitives = ['years', 'month', 'divide'])\n",
        "\n",
        "print(f\"Número de features: {len(feature_names1)}\")\n",
        "feature_names1"
      ],
      "metadata": {
        "id": "cc0Lj4QBX_4X"
      },
      "execution_count": 32,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Exemplo 2 - Além de escolher a operação Weekend importada, iremos montar o formato DFS, utilizando as listas criadas anteriores, além de ignorar variáveis\n",
        "#Essa operação Weekend irá percorrer todo o dataset em busca de variáveis de tempo para criar \n",
        "trans_primitives = [Weekend]\n",
        "\n",
        "#Criar a funçnao DFS\n",
        "features2 = ft.dfs(entities =entities,\n",
        "                  relationships=relationships,\n",
        "                  target_entity=\"trips\",\n",
        "                  trans_primitives=trans_primitives,\n",
        "                  agg_primitives=[],\n",
        "                  ignore_variables={\"trips\": [\"pickup_latitude\", \"pickup_longitude\",\n",
        "                                              \"dropoff_latitude\", \"dropoff_longitude\", \"trip_duration\"]},\n",
        "                  features_only=True)\n",
        "\n",
        "print(f\"Número de features: {len(features2)}\")\n",
        "features2"
      ],
      "metadata": {
        "id": "7ntDGlnSfYMm",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "4e98d7ba-4b08-41fd-a52a-0139c9126afc"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Primitivas de transformação configuradas com sucesso!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(f\"Número de features: {len(features2)}\")\n",
        "features2"
      ],
      "metadata": {
        "id": "cneGqByRfPcT",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "fc6c6d76-2963-4970-c733-6b1c49be643e"
      },
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Número de features: 12\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[<Feature: vendor_id>,\n",
              " <Feature: passenger_count>,\n",
              " <Feature: trip_distance>,\n",
              " <Feature: payment_type>,\n",
              " <Feature: pickup_neighborhood>,\n",
              " <Feature: dropoff_neighborhood>,\n",
              " <Feature: WEEKEND(pickup_datetime)>,\n",
              " <Feature: WEEKEND(dropoff_datetime)>,\n",
              " <Feature: pickup_neighborhoods.latitude>,\n",
              " <Feature: pickup_neighborhoods.longitude>,\n",
              " <Feature: dropoff_neighborhoods.latitude>,\n",
              " <Feature: dropoff_neighborhoods.longitude>]"
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "features"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 993
        },
        "id": "kmr6AcUS8Bh_",
        "outputId": "e0b6c2f6-899e-492a-d9e3-7fdf8d6f5655"
      },
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-a9bf7b10-3d11-48d4-9a1c-92cb4a220171\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>income</th>\n",
              "      <th>credit_score</th>\n",
              "      <th>MEAN(loans.loan_amount)</th>\n",
              "      <th>MEAN(loans.rate)</th>\n",
              "      <th>MAX(loans.loan_amount)</th>\n",
              "      <th>MAX(loans.rate)</th>\n",
              "      <th>LAST(loans.loan_type)</th>\n",
              "      <th>LAST(loans.loan_amount)</th>\n",
              "      <th>LAST(loans.rate)</th>\n",
              "      <th>LAST(loans.repaid)</th>\n",
              "      <th>MEAN(payments.payment_amount)</th>\n",
              "      <th>MAX(payments.payment_amount)</th>\n",
              "      <th>LAST(payments.payment_amount)</th>\n",
              "      <th>LAST(payments.missed)</th>\n",
              "      <th>MONTH(joined)</th>\n",
              "      <th>income / credit_score</th>\n",
              "      <th>credit_score / income</th>\n",
              "      <th>MEAN(loans.MEAN(payments.payment_amount))</th>\n",
              "      <th>MEAN(loans.MAX(payments.payment_amount))</th>\n",
              "      <th>MEAN(loans.LAST(payments.payment_amount))</th>\n",
              "      <th>MEAN(loans.loan_amount / rate)</th>\n",
              "      <th>MEAN(loans.rate / loan_amount)</th>\n",
              "      <th>MAX(loans.MEAN(payments.payment_amount))</th>\n",
              "      <th>MAX(loans.LAST(payments.payment_amount))</th>\n",
              "      <th>MAX(loans.loan_amount / rate)</th>\n",
              "      <th>MAX(loans.rate / loan_amount)</th>\n",
              "      <th>LAST(loans.MEAN(payments.payment_amount))</th>\n",
              "      <th>LAST(loans.MAX(payments.payment_amount))</th>\n",
              "      <th>LAST(loans.MONTH(loan_start))</th>\n",
              "      <th>LAST(loans.MONTH(loan_end))</th>\n",
              "      <th>LAST(loans.loan_amount / rate)</th>\n",
              "      <th>LAST(loans.rate / loan_amount)</th>\n",
              "      <th>MONTH(LAST(loans.loan_start))</th>\n",
              "      <th>MONTH(LAST(loans.loan_end))</th>\n",
              "      <th>MONTH(LAST(payments.payment_date))</th>\n",
              "      <th>MAX(payments.payment_amount) / LAST(loans.rate)</th>\n",
              "      <th>MEAN(loans.rate) / MAX(payments.payment_amount)</th>\n",
              "      <th>MEAN(loans.loan_amount) / MAX(payments.payment_amount)</th>\n",
              "      <th>MAX(loans.loan_amount) / MEAN(loans.loan_amount)</th>\n",
              "      <th>MAX(loans.rate) / MEAN(loans.loan_amount)</th>\n",
              "      <th>...</th>\n",
              "      <th>LAST(payments.payment_amount) / MEAN(loans.rate)</th>\n",
              "      <th>MAX(loans.rate) / LAST(loans.loan_amount)</th>\n",
              "      <th>LAST(payments.payment_amount) / MAX(loans.rate)</th>\n",
              "      <th>MEAN(loans.loan_amount) / income</th>\n",
              "      <th>LAST(loans.loan_amount) / MEAN(loans.rate)</th>\n",
              "      <th>MEAN(payments.payment_amount) / MEAN(loans.rate)</th>\n",
              "      <th>credit_score / MEAN(loans.loan_amount)</th>\n",
              "      <th>credit_score / MEAN(payments.payment_amount)</th>\n",
              "      <th>credit_score / MAX(loans.rate)</th>\n",
              "      <th>credit_score / MAX(loans.loan_amount)</th>\n",
              "      <th>LAST(loans.rate) / LAST(payments.payment_amount)</th>\n",
              "      <th>LAST(payments.payment_amount) / MAX(payments.payment_amount)</th>\n",
              "      <th>MEAN(loans.loan_amount) / LAST(payments.payment_amount)</th>\n",
              "      <th>MEAN(loans.rate) / credit_score</th>\n",
              "      <th>MAX(loans.loan_amount) / MAX(loans.rate)</th>\n",
              "      <th>credit_score / MAX(payments.payment_amount)</th>\n",
              "      <th>MEAN(payments.payment_amount) / credit_score</th>\n",
              "      <th>MAX(loans.loan_amount) / MEAN(payments.payment_amount)</th>\n",
              "      <th>MEAN(loans.loan_amount) / MEAN(payments.payment_amount)</th>\n",
              "      <th>LAST(loans.loan_amount) / income</th>\n",
              "      <th>MAX(payments.payment_amount) / MEAN(loans.loan_amount)</th>\n",
              "      <th>MEAN(loans.loan_amount) / MEAN(loans.rate)</th>\n",
              "      <th>MAX(loans.loan_amount) / LAST(loans.rate)</th>\n",
              "      <th>LAST(payments.payment_amount) / LAST(loans.rate)</th>\n",
              "      <th>MAX(payments.payment_amount) / LAST(loans.loan_amount)</th>\n",
              "      <th>MAX(payments.payment_amount) / credit_score</th>\n",
              "      <th>MEAN(loans.loan_amount) / LAST(loans.rate)</th>\n",
              "      <th>LAST(payments.payment_amount) / MEAN(loans.loan_amount)</th>\n",
              "      <th>LAST(loans.rate) / income</th>\n",
              "      <th>MAX(loans.loan_amount) / credit_score</th>\n",
              "      <th>MEAN(loans.rate) / MAX(loans.rate)</th>\n",
              "      <th>MEAN(loans.rate) / LAST(loans.loan_amount)</th>\n",
              "      <th>MEAN(loans.rate) / MAX(loans.loan_amount)</th>\n",
              "      <th>income / LAST(loans.rate)</th>\n",
              "      <th>MAX(loans.rate) / income</th>\n",
              "      <th>LAST(loans.loan_amount) / LAST(loans.rate)</th>\n",
              "      <th>LAST(loans.rate) / MAX(payments.payment_amount)</th>\n",
              "      <th>MEAN(payments.payment_amount) / LAST(loans.loan_amount)</th>\n",
              "      <th>MEAN(loans.loan_amount) / LAST(loans.loan_amount)</th>\n",
              "      <th>income / MEAN(loans.rate)</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>client_id</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>25707</th>\n",
              "      <td>211422</td>\n",
              "      <td>621</td>\n",
              "      <td>7963.950000</td>\n",
              "      <td>3.477000</td>\n",
              "      <td>13913</td>\n",
              "      <td>9.44</td>\n",
              "      <td>home</td>\n",
              "      <td>2203</td>\n",
              "      <td>7.40</td>\n",
              "      <td>0</td>\n",
              "      <td>1178.552795</td>\n",
              "      <td>2704</td>\n",
              "      <td>241</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>340.454106</td>\n",
              "      <td>0.002937</td>\n",
              "      <td>1175.760996</td>\n",
              "      <td>1578.750000</td>\n",
              "      <td>1195.550000</td>\n",
              "      <td>5490.060050</td>\n",
              "      <td>0.000646</td>\n",
              "      <td>2155.142857</td>\n",
              "      <td>2402</td>\n",
              "      <td>3.650909e+04</td>\n",
              "      <td>0.003359</td>\n",
              "      <td>293.500000</td>\n",
              "      <td>368</td>\n",
              "      <td>2</td>\n",
              "      <td>8</td>\n",
              "      <td>297.702703</td>\n",
              "      <td>0.003359</td>\n",
              "      <td>2</td>\n",
              "      <td>8</td>\n",
              "      <td>11</td>\n",
              "      <td>365.405405</td>\n",
              "      <td>0.001286</td>\n",
              "      <td>2.945248</td>\n",
              "      <td>1.746997</td>\n",
              "      <td>0.001185</td>\n",
              "      <td>...</td>\n",
              "      <td>69.312626</td>\n",
              "      <td>0.004285</td>\n",
              "      <td>25.529661</td>\n",
              "      <td>0.037669</td>\n",
              "      <td>633.592177</td>\n",
              "      <td>338.956800</td>\n",
              "      <td>0.077976</td>\n",
              "      <td>0.526917</td>\n",
              "      <td>65.783898</td>\n",
              "      <td>0.044635</td>\n",
              "      <td>0.030705</td>\n",
              "      <td>0.089127</td>\n",
              "      <td>33.045436</td>\n",
              "      <td>0.005599</td>\n",
              "      <td>1473.834746</td>\n",
              "      <td>0.229660</td>\n",
              "      <td>1.897831</td>\n",
              "      <td>11.805156</td>\n",
              "      <td>6.757398</td>\n",
              "      <td>0.010420</td>\n",
              "      <td>0.339530</td>\n",
              "      <td>2290.465919</td>\n",
              "      <td>1880.135135</td>\n",
              "      <td>32.567568</td>\n",
              "      <td>1.227417</td>\n",
              "      <td>4.354267</td>\n",
              "      <td>1076.209459</td>\n",
              "      <td>0.030261</td>\n",
              "      <td>0.000035</td>\n",
              "      <td>22.404187</td>\n",
              "      <td>0.368326</td>\n",
              "      <td>0.001578</td>\n",
              "      <td>0.000250</td>\n",
              "      <td>28570.540541</td>\n",
              "      <td>0.000045</td>\n",
              "      <td>297.702703</td>\n",
              "      <td>0.002737</td>\n",
              "      <td>0.534976</td>\n",
              "      <td>3.615048</td>\n",
              "      <td>60805.867127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26326</th>\n",
              "      <td>227920</td>\n",
              "      <td>633</td>\n",
              "      <td>7270.062500</td>\n",
              "      <td>2.517500</td>\n",
              "      <td>13464</td>\n",
              "      <td>6.73</td>\n",
              "      <td>credit</td>\n",
              "      <td>5275</td>\n",
              "      <td>1.45</td>\n",
              "      <td>0</td>\n",
              "      <td>1166.736842</td>\n",
              "      <td>2658</td>\n",
              "      <td>932</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>360.063191</td>\n",
              "      <td>0.002777</td>\n",
              "      <td>1161.691608</td>\n",
              "      <td>1547.500000</td>\n",
              "      <td>1155.375000</td>\n",
              "      <td>5622.633622</td>\n",
              "      <td>0.000556</td>\n",
              "      <td>2143.888889</td>\n",
              "      <td>2483</td>\n",
              "      <td>2.426863e+04</td>\n",
              "      <td>0.002144</td>\n",
              "      <td>977.375000</td>\n",
              "      <td>1573</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>3637.931034</td>\n",
              "      <td>0.000275</td>\n",
              "      <td>11</td>\n",
              "      <td>7</td>\n",
              "      <td>8</td>\n",
              "      <td>1833.103448</td>\n",
              "      <td>0.000947</td>\n",
              "      <td>2.735163</td>\n",
              "      <td>1.851979</td>\n",
              "      <td>0.000926</td>\n",
              "      <td>...</td>\n",
              "      <td>370.208540</td>\n",
              "      <td>0.001276</td>\n",
              "      <td>138.484398</td>\n",
              "      <td>0.031897</td>\n",
              "      <td>2095.332671</td>\n",
              "      <td>463.450583</td>\n",
              "      <td>0.087069</td>\n",
              "      <td>0.542539</td>\n",
              "      <td>94.056464</td>\n",
              "      <td>0.047014</td>\n",
              "      <td>0.001556</td>\n",
              "      <td>0.350640</td>\n",
              "      <td>7.800496</td>\n",
              "      <td>0.003977</td>\n",
              "      <td>2000.594354</td>\n",
              "      <td>0.238149</td>\n",
              "      <td>1.843186</td>\n",
              "      <td>11.539877</td>\n",
              "      <td>6.231107</td>\n",
              "      <td>0.023144</td>\n",
              "      <td>0.365609</td>\n",
              "      <td>2887.810328</td>\n",
              "      <td>9285.517241</td>\n",
              "      <td>642.758621</td>\n",
              "      <td>0.503886</td>\n",
              "      <td>4.199052</td>\n",
              "      <td>5013.836207</td>\n",
              "      <td>0.128197</td>\n",
              "      <td>0.000006</td>\n",
              "      <td>21.270142</td>\n",
              "      <td>0.374071</td>\n",
              "      <td>0.000477</td>\n",
              "      <td>0.000187</td>\n",
              "      <td>157186.206897</td>\n",
              "      <td>0.000030</td>\n",
              "      <td>3637.931034</td>\n",
              "      <td>0.000546</td>\n",
              "      <td>0.221182</td>\n",
              "      <td>1.378211</td>\n",
              "      <td>90534.260179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26695</th>\n",
              "      <td>174532</td>\n",
              "      <td>680</td>\n",
              "      <td>7824.722222</td>\n",
              "      <td>2.466111</td>\n",
              "      <td>14865</td>\n",
              "      <td>6.51</td>\n",
              "      <td>other</td>\n",
              "      <td>13918</td>\n",
              "      <td>0.90</td>\n",
              "      <td>1</td>\n",
              "      <td>1207.433824</td>\n",
              "      <td>2932</td>\n",
              "      <td>2084</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>256.664706</td>\n",
              "      <td>0.003896</td>\n",
              "      <td>1221.200615</td>\n",
              "      <td>1518.833333</td>\n",
              "      <td>1276.222222</td>\n",
              "      <td>5199.555018</td>\n",
              "      <td>0.000433</td>\n",
              "      <td>2511.800000</td>\n",
              "      <td>2271</td>\n",
              "      <td>1.592727e+04</td>\n",
              "      <td>0.001595</td>\n",
              "      <td>1769.166667</td>\n",
              "      <td>2084</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>15464.444444</td>\n",
              "      <td>0.000065</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>3</td>\n",
              "      <td>3257.777778</td>\n",
              "      <td>0.000841</td>\n",
              "      <td>2.668732</td>\n",
              "      <td>1.899748</td>\n",
              "      <td>0.000832</td>\n",
              "      <td>...</td>\n",
              "      <td>845.055193</td>\n",
              "      <td>0.000468</td>\n",
              "      <td>320.122888</td>\n",
              "      <td>0.044833</td>\n",
              "      <td>5643.703537</td>\n",
              "      <td>489.610471</td>\n",
              "      <td>0.086904</td>\n",
              "      <td>0.563178</td>\n",
              "      <td>104.454685</td>\n",
              "      <td>0.045745</td>\n",
              "      <td>0.000432</td>\n",
              "      <td>0.710778</td>\n",
              "      <td>3.754665</td>\n",
              "      <td>0.003627</td>\n",
              "      <td>2283.410138</td>\n",
              "      <td>0.231924</td>\n",
              "      <td>1.775638</td>\n",
              "      <td>12.311234</td>\n",
              "      <td>6.480456</td>\n",
              "      <td>0.079745</td>\n",
              "      <td>0.374710</td>\n",
              "      <td>3172.899302</td>\n",
              "      <td>16516.666667</td>\n",
              "      <td>2315.555556</td>\n",
              "      <td>0.210662</td>\n",
              "      <td>4.311765</td>\n",
              "      <td>8694.135802</td>\n",
              "      <td>0.266335</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>21.860294</td>\n",
              "      <td>0.378819</td>\n",
              "      <td>0.000177</td>\n",
              "      <td>0.000166</td>\n",
              "      <td>193924.444444</td>\n",
              "      <td>0.000037</td>\n",
              "      <td>15464.444444</td>\n",
              "      <td>0.000307</td>\n",
              "      <td>0.086753</td>\n",
              "      <td>0.562202</td>\n",
              "      <td>70772.155891</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26945</th>\n",
              "      <td>214516</td>\n",
              "      <td>806</td>\n",
              "      <td>7125.933333</td>\n",
              "      <td>2.855333</td>\n",
              "      <td>14593</td>\n",
              "      <td>5.65</td>\n",
              "      <td>cash</td>\n",
              "      <td>9249</td>\n",
              "      <td>2.86</td>\n",
              "      <td>1</td>\n",
              "      <td>1109.473214</td>\n",
              "      <td>2768</td>\n",
              "      <td>1597</td>\n",
              "      <td>1</td>\n",
              "      <td>11</td>\n",
              "      <td>266.148883</td>\n",
              "      <td>0.003757</td>\n",
              "      <td>1115.150112</td>\n",
              "      <td>1411.600000</td>\n",
              "      <td>1237.400000</td>\n",
              "      <td>6414.060680</td>\n",
              "      <td>0.000982</td>\n",
              "      <td>2272.857143</td>\n",
              "      <td>2530</td>\n",
              "      <td>2.918600e+04</td>\n",
              "      <td>0.004518</td>\n",
              "      <td>1598.666667</td>\n",
              "      <td>1834</td>\n",
              "      <td>12</td>\n",
              "      <td>5</td>\n",
              "      <td>3233.916084</td>\n",
              "      <td>0.000309</td>\n",
              "      <td>12</td>\n",
              "      <td>5</td>\n",
              "      <td>7</td>\n",
              "      <td>967.832168</td>\n",
              "      <td>0.001032</td>\n",
              "      <td>2.574398</td>\n",
              "      <td>2.047872</td>\n",
              "      <td>0.000793</td>\n",
              "      <td>...</td>\n",
              "      <td>559.304226</td>\n",
              "      <td>0.000611</td>\n",
              "      <td>282.654867</td>\n",
              "      <td>0.033219</td>\n",
              "      <td>3239.201494</td>\n",
              "      <td>388.561714</td>\n",
              "      <td>0.113108</td>\n",
              "      <td>0.726471</td>\n",
              "      <td>142.654867</td>\n",
              "      <td>0.055232</td>\n",
              "      <td>0.001791</td>\n",
              "      <td>0.576951</td>\n",
              "      <td>4.462075</td>\n",
              "      <td>0.003543</td>\n",
              "      <td>2582.831858</td>\n",
              "      <td>0.291185</td>\n",
              "      <td>1.376518</td>\n",
              "      <td>13.153089</td>\n",
              "      <td>6.422808</td>\n",
              "      <td>0.043116</td>\n",
              "      <td>0.388440</td>\n",
              "      <td>2495.657250</td>\n",
              "      <td>5102.447552</td>\n",
              "      <td>558.391608</td>\n",
              "      <td>0.299276</td>\n",
              "      <td>3.434243</td>\n",
              "      <td>2491.585082</td>\n",
              "      <td>0.224111</td>\n",
              "      <td>0.000013</td>\n",
              "      <td>18.105459</td>\n",
              "      <td>0.505369</td>\n",
              "      <td>0.000309</td>\n",
              "      <td>0.000196</td>\n",
              "      <td>75005.594406</td>\n",
              "      <td>0.000026</td>\n",
              "      <td>3233.916084</td>\n",
              "      <td>0.001033</td>\n",
              "      <td>0.119956</td>\n",
              "      <td>0.770454</td>\n",
              "      <td>75128.181181</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29841</th>\n",
              "      <td>38354</td>\n",
              "      <td>523</td>\n",
              "      <td>9813.000000</td>\n",
              "      <td>3.445000</td>\n",
              "      <td>14837</td>\n",
              "      <td>6.76</td>\n",
              "      <td>home</td>\n",
              "      <td>7223</td>\n",
              "      <td>5.09</td>\n",
              "      <td>1</td>\n",
              "      <td>1439.433333</td>\n",
              "      <td>2898</td>\n",
              "      <td>800</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>73.334608</td>\n",
              "      <td>0.013636</td>\n",
              "      <td>1455.233737</td>\n",
              "      <td>1866.000000</td>\n",
              "      <td>1416.833333</td>\n",
              "      <td>6501.008754</td>\n",
              "      <td>0.000403</td>\n",
              "      <td>2383.777778</td>\n",
              "      <td>2742</td>\n",
              "      <td>4.636562e+04</td>\n",
              "      <td>0.000856</td>\n",
              "      <td>1125.500000</td>\n",
              "      <td>1373</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>1419.056974</td>\n",
              "      <td>0.000705</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>569.351670</td>\n",
              "      <td>0.001189</td>\n",
              "      <td>3.386128</td>\n",
              "      <td>1.511974</td>\n",
              "      <td>0.000689</td>\n",
              "      <td>...</td>\n",
              "      <td>232.220610</td>\n",
              "      <td>0.000936</td>\n",
              "      <td>118.343195</td>\n",
              "      <td>0.255853</td>\n",
              "      <td>2096.661829</td>\n",
              "      <td>417.832608</td>\n",
              "      <td>0.053297</td>\n",
              "      <td>0.363337</td>\n",
              "      <td>77.366864</td>\n",
              "      <td>0.035250</td>\n",
              "      <td>0.006363</td>\n",
              "      <td>0.276052</td>\n",
              "      <td>12.266250</td>\n",
              "      <td>0.006587</td>\n",
              "      <td>2194.822485</td>\n",
              "      <td>0.180469</td>\n",
              "      <td>2.752263</td>\n",
              "      <td>10.307528</td>\n",
              "      <td>6.817266</td>\n",
              "      <td>0.188325</td>\n",
              "      <td>0.295323</td>\n",
              "      <td>2848.476052</td>\n",
              "      <td>2914.931238</td>\n",
              "      <td>157.170923</td>\n",
              "      <td>0.401218</td>\n",
              "      <td>5.541109</td>\n",
              "      <td>1927.897839</td>\n",
              "      <td>0.081525</td>\n",
              "      <td>0.000133</td>\n",
              "      <td>28.369025</td>\n",
              "      <td>0.509615</td>\n",
              "      <td>0.000477</td>\n",
              "      <td>0.000232</td>\n",
              "      <td>7535.166994</td>\n",
              "      <td>0.000176</td>\n",
              "      <td>1419.056974</td>\n",
              "      <td>0.001756</td>\n",
              "      <td>0.199285</td>\n",
              "      <td>1.358577</td>\n",
              "      <td>11133.236575</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32726</th>\n",
              "      <td>235705</td>\n",
              "      <td>730</td>\n",
              "      <td>6633.263158</td>\n",
              "      <td>3.058947</td>\n",
              "      <td>14802</td>\n",
              "      <td>9.10</td>\n",
              "      <td>other</td>\n",
              "      <td>5325</td>\n",
              "      <td>2.83</td>\n",
              "      <td>1</td>\n",
              "      <td>944.298013</td>\n",
              "      <td>2695</td>\n",
              "      <td>1013</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>322.883562</td>\n",
              "      <td>0.003097</td>\n",
              "      <td>1014.163680</td>\n",
              "      <td>1315.736842</td>\n",
              "      <td>1066.473684</td>\n",
              "      <td>2900.658982</td>\n",
              "      <td>0.000718</td>\n",
              "      <td>2325.285714</td>\n",
              "      <td>2695</td>\n",
              "      <td>8.843750e+03</td>\n",
              "      <td>0.003712</td>\n",
              "      <td>799.500000</td>\n",
              "      <td>1013</td>\n",
              "      <td>4</td>\n",
              "      <td>10</td>\n",
              "      <td>1881.625442</td>\n",
              "      <td>0.000531</td>\n",
              "      <td>4</td>\n",
              "      <td>10</td>\n",
              "      <td>12</td>\n",
              "      <td>952.296820</td>\n",
              "      <td>0.001135</td>\n",
              "      <td>2.461322</td>\n",
              "      <td>2.231481</td>\n",
              "      <td>0.001372</td>\n",
              "      <td>...</td>\n",
              "      <td>331.159670</td>\n",
              "      <td>0.001709</td>\n",
              "      <td>111.318681</td>\n",
              "      <td>0.028142</td>\n",
              "      <td>1740.794907</td>\n",
              "      <td>308.700314</td>\n",
              "      <td>0.110051</td>\n",
              "      <td>0.773061</td>\n",
              "      <td>80.219780</td>\n",
              "      <td>0.049318</td>\n",
              "      <td>0.002794</td>\n",
              "      <td>0.375881</td>\n",
              "      <td>6.548137</td>\n",
              "      <td>0.004190</td>\n",
              "      <td>1626.593407</td>\n",
              "      <td>0.270872</td>\n",
              "      <td>1.293559</td>\n",
              "      <td>15.675136</td>\n",
              "      <td>7.024544</td>\n",
              "      <td>0.022592</td>\n",
              "      <td>0.406286</td>\n",
              "      <td>2168.479009</td>\n",
              "      <td>5230.388693</td>\n",
              "      <td>357.950530</td>\n",
              "      <td>0.506103</td>\n",
              "      <td>3.691781</td>\n",
              "      <td>2343.909243</td>\n",
              "      <td>0.152715</td>\n",
              "      <td>0.000012</td>\n",
              "      <td>20.276712</td>\n",
              "      <td>0.336148</td>\n",
              "      <td>0.000574</td>\n",
              "      <td>0.000207</td>\n",
              "      <td>83287.985866</td>\n",
              "      <td>0.000039</td>\n",
              "      <td>1881.625442</td>\n",
              "      <td>0.001050</td>\n",
              "      <td>0.177333</td>\n",
              "      <td>1.245683</td>\n",
              "      <td>77054.284240</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32885</th>\n",
              "      <td>58955</td>\n",
              "      <td>642</td>\n",
              "      <td>9920.400000</td>\n",
              "      <td>2.436000</td>\n",
              "      <td>14162</td>\n",
              "      <td>9.11</td>\n",
              "      <td>other</td>\n",
              "      <td>11886</td>\n",
              "      <td>9.11</td>\n",
              "      <td>0</td>\n",
              "      <td>1396.495652</td>\n",
              "      <td>2422</td>\n",
              "      <td>1909</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>91.830218</td>\n",
              "      <td>0.010890</td>\n",
              "      <td>1438.236984</td>\n",
              "      <td>1866.866667</td>\n",
              "      <td>1614.066667</td>\n",
              "      <td>17606.211367</td>\n",
              "      <td>0.000259</td>\n",
              "      <td>2127.500000</td>\n",
              "      <td>2367</td>\n",
              "      <td>1.030500e+05</td>\n",
              "      <td>0.000766</td>\n",
              "      <td>1729.000000</td>\n",
              "      <td>2025</td>\n",
              "      <td>5</td>\n",
              "      <td>12</td>\n",
              "      <td>1304.720088</td>\n",
              "      <td>0.000766</td>\n",
              "      <td>5</td>\n",
              "      <td>12</td>\n",
              "      <td>12</td>\n",
              "      <td>265.861690</td>\n",
              "      <td>0.001006</td>\n",
              "      <td>4.095954</td>\n",
              "      <td>1.427563</td>\n",
              "      <td>0.000918</td>\n",
              "      <td>...</td>\n",
              "      <td>783.661741</td>\n",
              "      <td>0.000766</td>\n",
              "      <td>209.549945</td>\n",
              "      <td>0.168271</td>\n",
              "      <td>4879.310345</td>\n",
              "      <td>573.274077</td>\n",
              "      <td>0.064715</td>\n",
              "      <td>0.459722</td>\n",
              "      <td>70.472009</td>\n",
              "      <td>0.045333</td>\n",
              "      <td>0.004772</td>\n",
              "      <td>0.788192</td>\n",
              "      <td>5.196647</td>\n",
              "      <td>0.003794</td>\n",
              "      <td>1554.555434</td>\n",
              "      <td>0.265070</td>\n",
              "      <td>2.175227</td>\n",
              "      <td>10.141099</td>\n",
              "      <td>7.103782</td>\n",
              "      <td>0.201611</td>\n",
              "      <td>0.244143</td>\n",
              "      <td>4072.413793</td>\n",
              "      <td>1554.555434</td>\n",
              "      <td>209.549945</td>\n",
              "      <td>0.203769</td>\n",
              "      <td>3.772586</td>\n",
              "      <td>1088.957190</td>\n",
              "      <td>0.192432</td>\n",
              "      <td>0.000155</td>\n",
              "      <td>22.059190</td>\n",
              "      <td>0.267398</td>\n",
              "      <td>0.000205</td>\n",
              "      <td>0.000172</td>\n",
              "      <td>6471.459934</td>\n",
              "      <td>0.000155</td>\n",
              "      <td>1304.720088</td>\n",
              "      <td>0.003761</td>\n",
              "      <td>0.117491</td>\n",
              "      <td>0.834629</td>\n",
              "      <td>24201.559934</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32961</th>\n",
              "      <td>230341</td>\n",
              "      <td>714</td>\n",
              "      <td>7882.235294</td>\n",
              "      <td>3.930588</td>\n",
              "      <td>14784</td>\n",
              "      <td>9.14</td>\n",
              "      <td>cash</td>\n",
              "      <td>1693</td>\n",
              "      <td>1.46</td>\n",
              "      <td>1</td>\n",
              "      <td>1039.053435</td>\n",
              "      <td>2791</td>\n",
              "      <td>223</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>322.606443</td>\n",
              "      <td>0.003100</td>\n",
              "      <td>1155.584111</td>\n",
              "      <td>1579.647059</td>\n",
              "      <td>1312.647059</td>\n",
              "      <td>59668.765738</td>\n",
              "      <td>0.000929</td>\n",
              "      <td>2169.000000</td>\n",
              "      <td>2791</td>\n",
              "      <td>9.237000e+05</td>\n",
              "      <td>0.004018</td>\n",
              "      <td>282.600000</td>\n",
              "      <td>337</td>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>1159.589041</td>\n",
              "      <td>0.000862</td>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>1911.643836</td>\n",
              "      <td>0.001408</td>\n",
              "      <td>2.824162</td>\n",
              "      <td>1.875610</td>\n",
              "      <td>0.001160</td>\n",
              "      <td>...</td>\n",
              "      <td>56.734511</td>\n",
              "      <td>0.005399</td>\n",
              "      <td>24.398249</td>\n",
              "      <td>0.034220</td>\n",
              "      <td>430.724334</td>\n",
              "      <td>264.350620</td>\n",
              "      <td>0.090583</td>\n",
              "      <td>0.687164</td>\n",
              "      <td>78.118162</td>\n",
              "      <td>0.048295</td>\n",
              "      <td>0.006547</td>\n",
              "      <td>0.079900</td>\n",
              "      <td>35.346347</td>\n",
              "      <td>0.005505</td>\n",
              "      <td>1617.505470</td>\n",
              "      <td>0.255822</td>\n",
              "      <td>1.455257</td>\n",
              "      <td>14.228335</td>\n",
              "      <td>7.585977</td>\n",
              "      <td>0.007350</td>\n",
              "      <td>0.354087</td>\n",
              "      <td>2005.357677</td>\n",
              "      <td>10126.027397</td>\n",
              "      <td>152.739726</td>\n",
              "      <td>1.648553</td>\n",
              "      <td>3.908964</td>\n",
              "      <td>5398.791297</td>\n",
              "      <td>0.028291</td>\n",
              "      <td>0.000006</td>\n",
              "      <td>20.705882</td>\n",
              "      <td>0.430042</td>\n",
              "      <td>0.002322</td>\n",
              "      <td>0.000266</td>\n",
              "      <td>157767.808219</td>\n",
              "      <td>0.000040</td>\n",
              "      <td>1159.589041</td>\n",
              "      <td>0.000523</td>\n",
              "      <td>0.613735</td>\n",
              "      <td>4.655780</td>\n",
              "      <td>58602.170009</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35089</th>\n",
              "      <td>131176</td>\n",
              "      <td>771</td>\n",
              "      <td>6939.200000</td>\n",
              "      <td>3.513500</td>\n",
              "      <td>13194</td>\n",
              "      <td>7.63</td>\n",
              "      <td>other</td>\n",
              "      <td>773</td>\n",
              "      <td>7.63</td>\n",
              "      <td>1</td>\n",
              "      <td>1094.748428</td>\n",
              "      <td>2563</td>\n",
              "      <td>106</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>170.137484</td>\n",
              "      <td>0.005878</td>\n",
              "      <td>1051.937989</td>\n",
              "      <td>1320.650000</td>\n",
              "      <td>923.450000</td>\n",
              "      <td>3635.394096</td>\n",
              "      <td>0.001075</td>\n",
              "      <td>2089.636364</td>\n",
              "      <td>1703</td>\n",
              "      <td>1.633881e+04</td>\n",
              "      <td>0.009871</td>\n",
              "      <td>110.400000</td>\n",
              "      <td>122</td>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>101.310616</td>\n",
              "      <td>0.009871</td>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>335.910878</td>\n",
              "      <td>0.001371</td>\n",
              "      <td>2.707452</td>\n",
              "      <td>1.901372</td>\n",
              "      <td>0.001100</td>\n",
              "      <td>...</td>\n",
              "      <td>30.169347</td>\n",
              "      <td>0.009871</td>\n",
              "      <td>13.892529</td>\n",
              "      <td>0.052900</td>\n",
              "      <td>220.008538</td>\n",
              "      <td>311.583443</td>\n",
              "      <td>0.111108</td>\n",
              "      <td>0.704271</td>\n",
              "      <td>101.048493</td>\n",
              "      <td>0.058436</td>\n",
              "      <td>0.071981</td>\n",
              "      <td>0.041358</td>\n",
              "      <td>65.464151</td>\n",
              "      <td>0.004557</td>\n",
              "      <td>1729.226737</td>\n",
              "      <td>0.300819</td>\n",
              "      <td>1.419907</td>\n",
              "      <td>12.052084</td>\n",
              "      <td>6.338625</td>\n",
              "      <td>0.005893</td>\n",
              "      <td>0.369351</td>\n",
              "      <td>1975.010673</td>\n",
              "      <td>1729.226737</td>\n",
              "      <td>13.892529</td>\n",
              "      <td>3.315653</td>\n",
              "      <td>3.324254</td>\n",
              "      <td>909.462647</td>\n",
              "      <td>0.015276</td>\n",
              "      <td>0.000058</td>\n",
              "      <td>17.112840</td>\n",
              "      <td>0.460485</td>\n",
              "      <td>0.004545</td>\n",
              "      <td>0.000266</td>\n",
              "      <td>17192.136304</td>\n",
              "      <td>0.000058</td>\n",
              "      <td>101.310616</td>\n",
              "      <td>0.002977</td>\n",
              "      <td>1.416233</td>\n",
              "      <td>8.976973</td>\n",
              "      <td>37334.851288</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35214</th>\n",
              "      <td>95849</td>\n",
              "      <td>696</td>\n",
              "      <td>7173.555556</td>\n",
              "      <td>3.108333</td>\n",
              "      <td>14767</td>\n",
              "      <td>8.44</td>\n",
              "      <td>home</td>\n",
              "      <td>9389</td>\n",
              "      <td>1.40</td>\n",
              "      <td>0</td>\n",
              "      <td>1076.987952</td>\n",
              "      <td>2874</td>\n",
              "      <td>1615</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>137.714080</td>\n",
              "      <td>0.007261</td>\n",
              "      <td>1085.168400</td>\n",
              "      <td>1534.666667</td>\n",
              "      <td>1296.000000</td>\n",
              "      <td>5420.894265</td>\n",
              "      <td>0.000936</td>\n",
              "      <td>2506.800000</td>\n",
              "      <td>2671</td>\n",
              "      <td>3.095625e+04</td>\n",
              "      <td>0.007661</td>\n",
              "      <td>1410.250000</td>\n",
              "      <td>1833</td>\n",
              "      <td>3</td>\n",
              "      <td>5</td>\n",
              "      <td>6706.428571</td>\n",
              "      <td>0.000149</td>\n",
              "      <td>3</td>\n",
              "      <td>5</td>\n",
              "      <td>11</td>\n",
              "      <td>2052.857143</td>\n",
              "      <td>0.001082</td>\n",
              "      <td>2.496018</td>\n",
              "      <td>2.058533</td>\n",
              "      <td>0.001177</td>\n",
              "      <td>...</td>\n",
              "      <td>519.571046</td>\n",
              "      <td>0.000899</td>\n",
              "      <td>191.350711</td>\n",
              "      <td>0.074842</td>\n",
              "      <td>3020.589812</td>\n",
              "      <td>346.484060</td>\n",
              "      <td>0.097023</td>\n",
              "      <td>0.646247</td>\n",
              "      <td>82.464455</td>\n",
              "      <td>0.047132</td>\n",
              "      <td>0.000867</td>\n",
              "      <td>0.561935</td>\n",
              "      <td>4.441830</td>\n",
              "      <td>0.004466</td>\n",
              "      <td>1749.644550</td>\n",
              "      <td>0.242171</td>\n",
              "      <td>1.547396</td>\n",
              "      <td>13.711388</td>\n",
              "      <td>6.660757</td>\n",
              "      <td>0.097956</td>\n",
              "      <td>0.400638</td>\n",
              "      <td>2307.846291</td>\n",
              "      <td>10547.857143</td>\n",
              "      <td>1153.571429</td>\n",
              "      <td>0.306103</td>\n",
              "      <td>4.129310</td>\n",
              "      <td>5123.968254</td>\n",
              "      <td>0.225132</td>\n",
              "      <td>0.000015</td>\n",
              "      <td>21.216954</td>\n",
              "      <td>0.368286</td>\n",
              "      <td>0.000331</td>\n",
              "      <td>0.000210</td>\n",
              "      <td>68463.571429</td>\n",
              "      <td>0.000088</td>\n",
              "      <td>6706.428571</td>\n",
              "      <td>0.000487</td>\n",
              "      <td>0.114707</td>\n",
              "      <td>0.764038</td>\n",
              "      <td>30836.139410</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38537</th>\n",
              "      <td>127183</td>\n",
              "      <td>643</td>\n",
              "      <td>8986.352941</td>\n",
              "      <td>2.389412</td>\n",
              "      <td>14804</td>\n",
              "      <td>8.01</td>\n",
              "      <td>cash</td>\n",
              "      <td>8797</td>\n",
              "      <td>0.64</td>\n",
              "      <td>1</td>\n",
              "      <td>1340.682927</td>\n",
              "      <td>2889</td>\n",
              "      <td>1615</td>\n",
              "      <td>0</td>\n",
              "      <td>10</td>\n",
              "      <td>197.796267</td>\n",
              "      <td>0.005056</td>\n",
              "      <td>1368.381559</td>\n",
              "      <td>1701.352941</td>\n",
              "      <td>1456.705882</td>\n",
              "      <td>7880.178181</td>\n",
              "      <td>0.000441</td>\n",
              "      <td>2542.142857</td>\n",
              "      <td>2837</td>\n",
              "      <td>2.854348e+04</td>\n",
              "      <td>0.003343</td>\n",
              "      <td>1348.833333</td>\n",
              "      <td>1634</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>13745.312500</td>\n",
              "      <td>0.000073</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>9</td>\n",
              "      <td>4514.062500</td>\n",
              "      <td>0.000827</td>\n",
              "      <td>3.110541</td>\n",
              "      <td>1.647387</td>\n",
              "      <td>0.000891</td>\n",
              "      <td>...</td>\n",
              "      <td>675.898572</td>\n",
              "      <td>0.000911</td>\n",
              "      <td>201.622971</td>\n",
              "      <td>0.070657</td>\n",
              "      <td>3681.659281</td>\n",
              "      <td>561.093298</td>\n",
              "      <td>0.071553</td>\n",
              "      <td>0.479606</td>\n",
              "      <td>80.274657</td>\n",
              "      <td>0.043434</td>\n",
              "      <td>0.000396</td>\n",
              "      <td>0.559017</td>\n",
              "      <td>5.564305</td>\n",
              "      <td>0.003716</td>\n",
              "      <td>1848.189763</td>\n",
              "      <td>0.222568</td>\n",
              "      <td>2.085043</td>\n",
              "      <td>11.042134</td>\n",
              "      <td>6.702817</td>\n",
              "      <td>0.069168</td>\n",
              "      <td>0.321487</td>\n",
              "      <td>3760.905958</td>\n",
              "      <td>23131.250000</td>\n",
              "      <td>2523.437500</td>\n",
              "      <td>0.328407</td>\n",
              "      <td>4.493002</td>\n",
              "      <td>14041.176471</td>\n",
              "      <td>0.179717</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>23.023328</td>\n",
              "      <td>0.298304</td>\n",
              "      <td>0.000272</td>\n",
              "      <td>0.000161</td>\n",
              "      <td>198723.437500</td>\n",
              "      <td>0.000063</td>\n",
              "      <td>13745.312500</td>\n",
              "      <td>0.000222</td>\n",
              "      <td>0.152402</td>\n",
              "      <td>1.021525</td>\n",
              "      <td>53227.744953</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39384</th>\n",
              "      <td>191204</td>\n",
              "      <td>617</td>\n",
              "      <td>7865.473684</td>\n",
              "      <td>3.538421</td>\n",
              "      <td>14654</td>\n",
              "      <td>9.23</td>\n",
              "      <td>other</td>\n",
              "      <td>14654</td>\n",
              "      <td>2.26</td>\n",
              "      <td>0</td>\n",
              "      <td>1193.630137</td>\n",
              "      <td>2822</td>\n",
              "      <td>2045</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>309.893031</td>\n",
              "      <td>0.003227</td>\n",
              "      <td>1194.628227</td>\n",
              "      <td>1503.473684</td>\n",
              "      <td>1265.000000</td>\n",
              "      <td>4108.614441</td>\n",
              "      <td>0.000578</td>\n",
              "      <td>2311.285714</td>\n",
              "      <td>2472</td>\n",
              "      <td>2.221860e+04</td>\n",
              "      <td>0.001492</td>\n",
              "      <td>2311.285714</td>\n",
              "      <td>2822</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>6484.070796</td>\n",
              "      <td>0.000154</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>1248.672566</td>\n",
              "      <td>0.001254</td>\n",
              "      <td>2.787198</td>\n",
              "      <td>1.863079</td>\n",
              "      <td>0.001173</td>\n",
              "      <td>...</td>\n",
              "      <td>577.941395</td>\n",
              "      <td>0.000630</td>\n",
              "      <td>221.560130</td>\n",
              "      <td>0.041137</td>\n",
              "      <td>4141.395210</td>\n",
              "      <td>337.334116</td>\n",
              "      <td>0.078444</td>\n",
              "      <td>0.516911</td>\n",
              "      <td>66.847237</td>\n",
              "      <td>0.042105</td>\n",
              "      <td>0.001105</td>\n",
              "      <td>0.724663</td>\n",
              "      <td>3.846197</td>\n",
              "      <td>0.005735</td>\n",
              "      <td>1587.648971</td>\n",
              "      <td>0.218639</td>\n",
              "      <td>1.934571</td>\n",
              "      <td>12.276835</td>\n",
              "      <td>6.589540</td>\n",
              "      <td>0.076641</td>\n",
              "      <td>0.358783</td>\n",
              "      <td>2222.876692</td>\n",
              "      <td>6484.070796</td>\n",
              "      <td>904.867257</td>\n",
              "      <td>0.192575</td>\n",
              "      <td>4.573744</td>\n",
              "      <td>3480.298090</td>\n",
              "      <td>0.259997</td>\n",
              "      <td>0.000012</td>\n",
              "      <td>23.750405</td>\n",
              "      <td>0.383361</td>\n",
              "      <td>0.000241</td>\n",
              "      <td>0.000241</td>\n",
              "      <td>84603.539823</td>\n",
              "      <td>0.000048</td>\n",
              "      <td>6484.070796</td>\n",
              "      <td>0.000801</td>\n",
              "      <td>0.081454</td>\n",
              "      <td>0.536746</td>\n",
              "      <td>54036.531310</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39505</th>\n",
              "      <td>153873</td>\n",
              "      <td>610</td>\n",
              "      <td>7424.050000</td>\n",
              "      <td>3.190500</td>\n",
              "      <td>14575</td>\n",
              "      <td>9.91</td>\n",
              "      <td>cash</td>\n",
              "      <td>9600</td>\n",
              "      <td>0.25</td>\n",
              "      <td>0</td>\n",
              "      <td>1162.026490</td>\n",
              "      <td>2764</td>\n",
              "      <td>1072</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>252.250820</td>\n",
              "      <td>0.003964</td>\n",
              "      <td>1109.334182</td>\n",
              "      <td>1440.500000</td>\n",
              "      <td>1160.000000</td>\n",
              "      <td>8624.776831</td>\n",
              "      <td>0.000665</td>\n",
              "      <td>2355.571429</td>\n",
              "      <td>2703</td>\n",
              "      <td>5.438421e+04</td>\n",
              "      <td>0.002030</td>\n",
              "      <td>1230.777778</td>\n",
              "      <td>1784</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>38400.000000</td>\n",
              "      <td>0.000026</td>\n",
              "      <td>6</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>11056.000000</td>\n",
              "      <td>0.001154</td>\n",
              "      <td>2.685980</td>\n",
              "      <td>1.963214</td>\n",
              "      <td>0.001335</td>\n",
              "      <td>...</td>\n",
              "      <td>335.997493</td>\n",
              "      <td>0.001032</td>\n",
              "      <td>108.173562</td>\n",
              "      <td>0.048248</td>\n",
              "      <td>3008.932769</td>\n",
              "      <td>364.214540</td>\n",
              "      <td>0.082165</td>\n",
              "      <td>0.524945</td>\n",
              "      <td>61.553986</td>\n",
              "      <td>0.041852</td>\n",
              "      <td>0.000233</td>\n",
              "      <td>0.387844</td>\n",
              "      <td>6.925420</td>\n",
              "      <td>0.005230</td>\n",
              "      <td>1470.736630</td>\n",
              "      <td>0.220695</td>\n",
              "      <td>1.904961</td>\n",
              "      <td>12.542743</td>\n",
              "      <td>6.388882</td>\n",
              "      <td>0.062389</td>\n",
              "      <td>0.372304</td>\n",
              "      <td>2326.923680</td>\n",
              "      <td>58300.000000</td>\n",
              "      <td>4288.000000</td>\n",
              "      <td>0.287917</td>\n",
              "      <td>4.531148</td>\n",
              "      <td>29696.200000</td>\n",
              "      <td>0.144396</td>\n",
              "      <td>0.000002</td>\n",
              "      <td>23.893443</td>\n",
              "      <td>0.321948</td>\n",
              "      <td>0.000332</td>\n",
              "      <td>0.000219</td>\n",
              "      <td>615492.000000</td>\n",
              "      <td>0.000064</td>\n",
              "      <td>38400.000000</td>\n",
              "      <td>0.000090</td>\n",
              "      <td>0.121044</td>\n",
              "      <td>0.773339</td>\n",
              "      <td>48228.490832</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41472</th>\n",
              "      <td>152214</td>\n",
              "      <td>638</td>\n",
              "      <td>7510.812500</td>\n",
              "      <td>3.981250</td>\n",
              "      <td>13657</td>\n",
              "      <td>9.82</td>\n",
              "      <td>cash</td>\n",
              "      <td>10122</td>\n",
              "      <td>1.03</td>\n",
              "      <td>0</td>\n",
              "      <td>1129.076190</td>\n",
              "      <td>2436</td>\n",
              "      <td>1453</td>\n",
              "      <td>0</td>\n",
              "      <td>11</td>\n",
              "      <td>238.579937</td>\n",
              "      <td>0.004191</td>\n",
              "      <td>1133.414162</td>\n",
              "      <td>1382.687500</td>\n",
              "      <td>1076.937500</td>\n",
              "      <td>28670.868454</td>\n",
              "      <td>0.000935</td>\n",
              "      <td>1992.250000</td>\n",
              "      <td>2230</td>\n",
              "      <td>4.078000e+05</td>\n",
              "      <td>0.007732</td>\n",
              "      <td>1427.000000</td>\n",
              "      <td>1803</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>9827.184466</td>\n",
              "      <td>0.000102</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>2365.048544</td>\n",
              "      <td>0.001634</td>\n",
              "      <td>3.083256</td>\n",
              "      <td>1.818312</td>\n",
              "      <td>0.001307</td>\n",
              "      <td>...</td>\n",
              "      <td>364.960754</td>\n",
              "      <td>0.000970</td>\n",
              "      <td>147.963340</td>\n",
              "      <td>0.049344</td>\n",
              "      <td>2542.417582</td>\n",
              "      <td>283.598415</td>\n",
              "      <td>0.084944</td>\n",
              "      <td>0.565064</td>\n",
              "      <td>64.969450</td>\n",
              "      <td>0.046716</td>\n",
              "      <td>0.000709</td>\n",
              "      <td>0.596470</td>\n",
              "      <td>5.169176</td>\n",
              "      <td>0.006240</td>\n",
              "      <td>1390.733198</td>\n",
              "      <td>0.261905</td>\n",
              "      <td>1.769712</td>\n",
              "      <td>12.095729</td>\n",
              "      <td>6.652175</td>\n",
              "      <td>0.066498</td>\n",
              "      <td>0.324332</td>\n",
              "      <td>1886.546311</td>\n",
              "      <td>13259.223301</td>\n",
              "      <td>1410.679612</td>\n",
              "      <td>0.240664</td>\n",
              "      <td>3.818182</td>\n",
              "      <td>7292.050971</td>\n",
              "      <td>0.193454</td>\n",
              "      <td>0.000007</td>\n",
              "      <td>21.405956</td>\n",
              "      <td>0.405423</td>\n",
              "      <td>0.000393</td>\n",
              "      <td>0.000292</td>\n",
              "      <td>147780.582524</td>\n",
              "      <td>0.000065</td>\n",
              "      <td>9827.184466</td>\n",
              "      <td>0.000423</td>\n",
              "      <td>0.111547</td>\n",
              "      <td>0.742029</td>\n",
              "      <td>38232.715856</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41480</th>\n",
              "      <td>122607</td>\n",
              "      <td>585</td>\n",
              "      <td>7894.850000</td>\n",
              "      <td>3.110500</td>\n",
              "      <td>14399</td>\n",
              "      <td>10.49</td>\n",
              "      <td>home</td>\n",
              "      <td>11154</td>\n",
              "      <td>6.48</td>\n",
              "      <td>1</td>\n",
              "      <td>1246.509934</td>\n",
              "      <td>2719</td>\n",
              "      <td>2115</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>209.584615</td>\n",
              "      <td>0.004771</td>\n",
              "      <td>1271.415709</td>\n",
              "      <td>1638.700000</td>\n",
              "      <td>1249.900000</td>\n",
              "      <td>4693.124109</td>\n",
              "      <td>0.000641</td>\n",
              "      <td>2143.142857</td>\n",
              "      <td>2543</td>\n",
              "      <td>1.190000e+04</td>\n",
              "      <td>0.003560</td>\n",
              "      <td>1862.800000</td>\n",
              "      <td>2169</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>1721.296296</td>\n",
              "      <td>0.000581</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>419.598765</td>\n",
              "      <td>0.001144</td>\n",
              "      <td>2.903586</td>\n",
              "      <td>1.823847</td>\n",
              "      <td>0.001329</td>\n",
              "      <td>...</td>\n",
              "      <td>679.954991</td>\n",
              "      <td>0.000940</td>\n",
              "      <td>201.620591</td>\n",
              "      <td>0.064392</td>\n",
              "      <td>3585.918663</td>\n",
              "      <td>400.742625</td>\n",
              "      <td>0.074099</td>\n",
              "      <td>0.469310</td>\n",
              "      <td>55.767398</td>\n",
              "      <td>0.040628</td>\n",
              "      <td>0.003064</td>\n",
              "      <td>0.777860</td>\n",
              "      <td>3.732790</td>\n",
              "      <td>0.005317</td>\n",
              "      <td>1372.640610</td>\n",
              "      <td>0.215153</td>\n",
              "      <td>2.130786</td>\n",
              "      <td>11.551452</td>\n",
              "      <td>6.333564</td>\n",
              "      <td>0.090974</td>\n",
              "      <td>0.344402</td>\n",
              "      <td>2538.128918</td>\n",
              "      <td>2222.067901</td>\n",
              "      <td>326.388889</td>\n",
              "      <td>0.243769</td>\n",
              "      <td>4.647863</td>\n",
              "      <td>1218.341049</td>\n",
              "      <td>0.267896</td>\n",
              "      <td>0.000053</td>\n",
              "      <td>24.613675</td>\n",
              "      <td>0.296520</td>\n",
              "      <td>0.000279</td>\n",
              "      <td>0.000216</td>\n",
              "      <td>18920.833333</td>\n",
              "      <td>0.000086</td>\n",
              "      <td>1721.296296</td>\n",
              "      <td>0.002383</td>\n",
              "      <td>0.111755</td>\n",
              "      <td>0.707804</td>\n",
              "      <td>39417.135509</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42320</th>\n",
              "      <td>229481</td>\n",
              "      <td>563</td>\n",
              "      <td>7062.066667</td>\n",
              "      <td>2.457333</td>\n",
              "      <td>13887</td>\n",
              "      <td>6.74</td>\n",
              "      <td>home</td>\n",
              "      <td>8090</td>\n",
              "      <td>3.18</td>\n",
              "      <td>0</td>\n",
              "      <td>1021.483333</td>\n",
              "      <td>2769</td>\n",
              "      <td>1082</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>407.603908</td>\n",
              "      <td>0.002453</td>\n",
              "      <td>1042.907672</td>\n",
              "      <td>1325.066667</td>\n",
              "      <td>1001.733333</td>\n",
              "      <td>4763.524219</td>\n",
              "      <td>0.000644</td>\n",
              "      <td>2229.400000</td>\n",
              "      <td>2098</td>\n",
              "      <td>1.330781e+04</td>\n",
              "      <td>0.004903</td>\n",
              "      <td>1192.333333</td>\n",
              "      <td>1484</td>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>2544.025157</td>\n",
              "      <td>0.000393</td>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>870.754717</td>\n",
              "      <td>0.000887</td>\n",
              "      <td>2.550403</td>\n",
              "      <td>1.966422</td>\n",
              "      <td>0.000954</td>\n",
              "      <td>...</td>\n",
              "      <td>440.314704</td>\n",
              "      <td>0.000833</td>\n",
              "      <td>160.534125</td>\n",
              "      <td>0.030774</td>\n",
              "      <td>3292.186652</td>\n",
              "      <td>415.687737</td>\n",
              "      <td>0.079722</td>\n",
              "      <td>0.551159</td>\n",
              "      <td>83.531157</td>\n",
              "      <td>0.040542</td>\n",
              "      <td>0.002939</td>\n",
              "      <td>0.390755</td>\n",
              "      <td>6.526864</td>\n",
              "      <td>0.004365</td>\n",
              "      <td>2060.385757</td>\n",
              "      <td>0.203322</td>\n",
              "      <td>1.814358</td>\n",
              "      <td>13.594935</td>\n",
              "      <td>6.913541</td>\n",
              "      <td>0.035253</td>\n",
              "      <td>0.392095</td>\n",
              "      <td>2873.874118</td>\n",
              "      <td>4366.981132</td>\n",
              "      <td>340.251572</td>\n",
              "      <td>0.342274</td>\n",
              "      <td>4.918295</td>\n",
              "      <td>2220.775681</td>\n",
              "      <td>0.153213</td>\n",
              "      <td>0.000014</td>\n",
              "      <td>24.666075</td>\n",
              "      <td>0.364590</td>\n",
              "      <td>0.000304</td>\n",
              "      <td>0.000177</td>\n",
              "      <td>72163.836478</td>\n",
              "      <td>0.000029</td>\n",
              "      <td>2544.025157</td>\n",
              "      <td>0.001148</td>\n",
              "      <td>0.126265</td>\n",
              "      <td>0.872938</td>\n",
              "      <td>93386.190993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44387</th>\n",
              "      <td>151903</td>\n",
              "      <td>781</td>\n",
              "      <td>7387.733333</td>\n",
              "      <td>2.806667</td>\n",
              "      <td>14900</td>\n",
              "      <td>5.97</td>\n",
              "      <td>credit</td>\n",
              "      <td>7279</td>\n",
              "      <td>4.10</td>\n",
              "      <td>1</td>\n",
              "      <td>1055.752294</td>\n",
              "      <td>2915</td>\n",
              "      <td>736</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>194.498079</td>\n",
              "      <td>0.005141</td>\n",
              "      <td>1060.088303</td>\n",
              "      <td>1358.066667</td>\n",
              "      <td>950.800000</td>\n",
              "      <td>10279.874331</td>\n",
              "      <td>0.000803</td>\n",
              "      <td>2200.875000</td>\n",
              "      <td>2445</td>\n",
              "      <td>1.005667e+05</td>\n",
              "      <td>0.006000</td>\n",
              "      <td>1050.000000</td>\n",
              "      <td>1243</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>1775.365854</td>\n",
              "      <td>0.000563</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>10</td>\n",
              "      <td>710.975610</td>\n",
              "      <td>0.000963</td>\n",
              "      <td>2.534385</td>\n",
              "      <td>2.016857</td>\n",
              "      <td>0.000808</td>\n",
              "      <td>...</td>\n",
              "      <td>262.232779</td>\n",
              "      <td>0.000820</td>\n",
              "      <td>123.283082</td>\n",
              "      <td>0.048635</td>\n",
              "      <td>2593.467933</td>\n",
              "      <td>376.158774</td>\n",
              "      <td>0.105716</td>\n",
              "      <td>0.739757</td>\n",
              "      <td>130.820771</td>\n",
              "      <td>0.052416</td>\n",
              "      <td>0.005571</td>\n",
              "      <td>0.252487</td>\n",
              "      <td>10.037681</td>\n",
              "      <td>0.003594</td>\n",
              "      <td>2495.812395</td>\n",
              "      <td>0.267925</td>\n",
              "      <td>1.351796</td>\n",
              "      <td>14.113159</td>\n",
              "      <td>6.997601</td>\n",
              "      <td>0.047919</td>\n",
              "      <td>0.394573</td>\n",
              "      <td>2632.209026</td>\n",
              "      <td>3634.146341</td>\n",
              "      <td>179.512195</td>\n",
              "      <td>0.400467</td>\n",
              "      <td>3.732394</td>\n",
              "      <td>1801.886179</td>\n",
              "      <td>0.099625</td>\n",
              "      <td>0.000027</td>\n",
              "      <td>19.078105</td>\n",
              "      <td>0.470128</td>\n",
              "      <td>0.000386</td>\n",
              "      <td>0.000188</td>\n",
              "      <td>37049.512195</td>\n",
              "      <td>0.000039</td>\n",
              "      <td>1775.365854</td>\n",
              "      <td>0.001407</td>\n",
              "      <td>0.145041</td>\n",
              "      <td>1.014938</td>\n",
              "      <td>54122.209026</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44601</th>\n",
              "      <td>156341</td>\n",
              "      <td>518</td>\n",
              "      <td>6869.250000</td>\n",
              "      <td>4.151000</td>\n",
              "      <td>14104</td>\n",
              "      <td>9.22</td>\n",
              "      <td>other</td>\n",
              "      <td>6129</td>\n",
              "      <td>2.76</td>\n",
              "      <td>1</td>\n",
              "      <td>1087.762821</td>\n",
              "      <td>2659</td>\n",
              "      <td>1011</td>\n",
              "      <td>0</td>\n",
              "      <td>10</td>\n",
              "      <td>301.816602</td>\n",
              "      <td>0.003313</td>\n",
              "      <td>1023.402440</td>\n",
              "      <td>1319.000000</td>\n",
              "      <td>1095.350000</td>\n",
              "      <td>8949.030771</td>\n",
              "      <td>0.000819</td>\n",
              "      <td>1968.000000</td>\n",
              "      <td>2488</td>\n",
              "      <td>1.361714e+05</td>\n",
              "      <td>0.004521</td>\n",
              "      <td>973.166667</td>\n",
              "      <td>1182</td>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>2220.652174</td>\n",
              "      <td>0.000450</td>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>963.405797</td>\n",
              "      <td>0.001561</td>\n",
              "      <td>2.583396</td>\n",
              "      <td>2.053208</td>\n",
              "      <td>0.001342</td>\n",
              "      <td>...</td>\n",
              "      <td>243.555770</td>\n",
              "      <td>0.001504</td>\n",
              "      <td>109.652928</td>\n",
              "      <td>0.043938</td>\n",
              "      <td>1476.511684</td>\n",
              "      <td>262.048379</td>\n",
              "      <td>0.075409</td>\n",
              "      <td>0.476207</td>\n",
              "      <td>56.182213</td>\n",
              "      <td>0.036727</td>\n",
              "      <td>0.002730</td>\n",
              "      <td>0.380218</td>\n",
              "      <td>6.794510</td>\n",
              "      <td>0.008014</td>\n",
              "      <td>1529.718004</td>\n",
              "      <td>0.194810</td>\n",
              "      <td>2.099928</td>\n",
              "      <td>12.966062</td>\n",
              "      <td>6.315026</td>\n",
              "      <td>0.039203</td>\n",
              "      <td>0.387087</td>\n",
              "      <td>1654.842207</td>\n",
              "      <td>5110.144928</td>\n",
              "      <td>366.304348</td>\n",
              "      <td>0.433839</td>\n",
              "      <td>5.133205</td>\n",
              "      <td>2488.858696</td>\n",
              "      <td>0.147178</td>\n",
              "      <td>0.000018</td>\n",
              "      <td>27.227799</td>\n",
              "      <td>0.450217</td>\n",
              "      <td>0.000677</td>\n",
              "      <td>0.000294</td>\n",
              "      <td>56645.289855</td>\n",
              "      <td>0.000059</td>\n",
              "      <td>2220.652174</td>\n",
              "      <td>0.001038</td>\n",
              "      <td>0.177478</td>\n",
              "      <td>1.120778</td>\n",
              "      <td>37663.454589</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46109</th>\n",
              "      <td>172677</td>\n",
              "      <td>527</td>\n",
              "      <td>8951.600000</td>\n",
              "      <td>3.152500</td>\n",
              "      <td>14049</td>\n",
              "      <td>9.48</td>\n",
              "      <td>other</td>\n",
              "      <td>10853</td>\n",
              "      <td>2.82</td>\n",
              "      <td>0</td>\n",
              "      <td>1375.560284</td>\n",
              "      <td>2735</td>\n",
              "      <td>1827</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>327.660342</td>\n",
              "      <td>0.003052</td>\n",
              "      <td>1422.461290</td>\n",
              "      <td>1820.500000</td>\n",
              "      <td>1433.400000</td>\n",
              "      <td>5883.073183</td>\n",
              "      <td>0.000936</td>\n",
              "      <td>2334.666667</td>\n",
              "      <td>2644</td>\n",
              "      <td>1.872647e+04</td>\n",
              "      <td>0.007424</td>\n",
              "      <td>1708.875000</td>\n",
              "      <td>1983</td>\n",
              "      <td>11</td>\n",
              "      <td>8</td>\n",
              "      <td>3848.581560</td>\n",
              "      <td>0.000260</td>\n",
              "      <td>11</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>969.858156</td>\n",
              "      <td>0.001153</td>\n",
              "      <td>3.272980</td>\n",
              "      <td>1.569440</td>\n",
              "      <td>0.001059</td>\n",
              "      <td>...</td>\n",
              "      <td>579.540048</td>\n",
              "      <td>0.000873</td>\n",
              "      <td>192.721519</td>\n",
              "      <td>0.051840</td>\n",
              "      <td>3442.664552</td>\n",
              "      <td>436.339503</td>\n",
              "      <td>0.058872</td>\n",
              "      <td>0.383117</td>\n",
              "      <td>55.590717</td>\n",
              "      <td>0.037512</td>\n",
              "      <td>0.001544</td>\n",
              "      <td>0.668007</td>\n",
              "      <td>4.899617</td>\n",
              "      <td>0.005982</td>\n",
              "      <td>1481.962025</td>\n",
              "      <td>0.192687</td>\n",
              "      <td>2.610171</td>\n",
              "      <td>10.213293</td>\n",
              "      <td>6.507603</td>\n",
              "      <td>0.062851</td>\n",
              "      <td>0.305532</td>\n",
              "      <td>2839.524187</td>\n",
              "      <td>4981.914894</td>\n",
              "      <td>647.872340</td>\n",
              "      <td>0.252004</td>\n",
              "      <td>5.189753</td>\n",
              "      <td>3174.326241</td>\n",
              "      <td>0.204098</td>\n",
              "      <td>0.000016</td>\n",
              "      <td>26.658444</td>\n",
              "      <td>0.332542</td>\n",
              "      <td>0.000290</td>\n",
              "      <td>0.000224</td>\n",
              "      <td>61232.978723</td>\n",
              "      <td>0.000055</td>\n",
              "      <td>3848.581560</td>\n",
              "      <td>0.001031</td>\n",
              "      <td>0.126745</td>\n",
              "      <td>0.824804</td>\n",
              "      <td>54774.623315</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46180</th>\n",
              "      <td>43851</td>\n",
              "      <td>562</td>\n",
              "      <td>7700.850000</td>\n",
              "      <td>3.502500</td>\n",
              "      <td>14081</td>\n",
              "      <td>9.26</td>\n",
              "      <td>other</td>\n",
              "      <td>3834</td>\n",
              "      <td>1.38</td>\n",
              "      <td>0</td>\n",
              "      <td>1186.550336</td>\n",
              "      <td>2660</td>\n",
              "      <td>697</td>\n",
              "      <td>1</td>\n",
              "      <td>11</td>\n",
              "      <td>78.026690</td>\n",
              "      <td>0.012816</td>\n",
              "      <td>1163.803383</td>\n",
              "      <td>1491.450000</td>\n",
              "      <td>1176.400000</td>\n",
              "      <td>3904.509018</td>\n",
              "      <td>0.000634</td>\n",
              "      <td>2016.750000</td>\n",
              "      <td>2273</td>\n",
              "      <td>1.321461e+04</td>\n",
              "      <td>0.002776</td>\n",
              "      <td>557.125000</td>\n",
              "      <td>706</td>\n",
              "      <td>5</td>\n",
              "      <td>2</td>\n",
              "      <td>2778.260870</td>\n",
              "      <td>0.000360</td>\n",
              "      <td>5</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>1927.536232</td>\n",
              "      <td>0.001317</td>\n",
              "      <td>2.895056</td>\n",
              "      <td>1.828499</td>\n",
              "      <td>0.001202</td>\n",
              "      <td>...</td>\n",
              "      <td>199.000714</td>\n",
              "      <td>0.002415</td>\n",
              "      <td>75.269978</td>\n",
              "      <td>0.175614</td>\n",
              "      <td>1094.646681</td>\n",
              "      <td>338.772401</td>\n",
              "      <td>0.072979</td>\n",
              "      <td>0.473642</td>\n",
              "      <td>60.691145</td>\n",
              "      <td>0.039912</td>\n",
              "      <td>0.001980</td>\n",
              "      <td>0.262030</td>\n",
              "      <td>11.048565</td>\n",
              "      <td>0.006232</td>\n",
              "      <td>1520.626350</td>\n",
              "      <td>0.211278</td>\n",
              "      <td>2.111300</td>\n",
              "      <td>11.867175</td>\n",
              "      <td>6.490117</td>\n",
              "      <td>0.087432</td>\n",
              "      <td>0.345416</td>\n",
              "      <td>2198.672377</td>\n",
              "      <td>10203.623188</td>\n",
              "      <td>505.072464</td>\n",
              "      <td>0.693792</td>\n",
              "      <td>4.733096</td>\n",
              "      <td>5580.326087</td>\n",
              "      <td>0.090509</td>\n",
              "      <td>0.000031</td>\n",
              "      <td>25.055160</td>\n",
              "      <td>0.378240</td>\n",
              "      <td>0.000914</td>\n",
              "      <td>0.000249</td>\n",
              "      <td>31776.086957</td>\n",
              "      <td>0.000211</td>\n",
              "      <td>2778.260870</td>\n",
              "      <td>0.000519</td>\n",
              "      <td>0.309481</td>\n",
              "      <td>2.008568</td>\n",
              "      <td>12519.914347</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46958</th>\n",
              "      <td>225709</td>\n",
              "      <td>644</td>\n",
              "      <td>9378.384615</td>\n",
              "      <td>3.153846</td>\n",
              "      <td>14942</td>\n",
              "      <td>6.17</td>\n",
              "      <td>credit</td>\n",
              "      <td>8308</td>\n",
              "      <td>0.32</td>\n",
              "      <td>0</td>\n",
              "      <td>1346.413043</td>\n",
              "      <td>2986</td>\n",
              "      <td>1451</td>\n",
              "      <td>0</td>\n",
              "      <td>7</td>\n",
              "      <td>350.479814</td>\n",
              "      <td>0.002853</td>\n",
              "      <td>1362.412210</td>\n",
              "      <td>1766.461538</td>\n",
              "      <td>1373.076923</td>\n",
              "      <td>5930.597157</td>\n",
              "      <td>0.000518</td>\n",
              "      <td>2033.400000</td>\n",
              "      <td>2265</td>\n",
              "      <td>2.596250e+04</td>\n",
              "      <td>0.002254</td>\n",
              "      <td>1248.375000</td>\n",
              "      <td>1659</td>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>25962.500000</td>\n",
              "      <td>0.000039</td>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "      <td>9331.250000</td>\n",
              "      <td>0.001056</td>\n",
              "      <td>3.140785</td>\n",
              "      <td>1.593238</td>\n",
              "      <td>0.000658</td>\n",
              "      <td>...</td>\n",
              "      <td>460.073171</td>\n",
              "      <td>0.000743</td>\n",
              "      <td>235.170178</td>\n",
              "      <td>0.041551</td>\n",
              "      <td>2634.243902</td>\n",
              "      <td>426.911453</td>\n",
              "      <td>0.068669</td>\n",
              "      <td>0.478308</td>\n",
              "      <td>104.376013</td>\n",
              "      <td>0.043100</td>\n",
              "      <td>0.000221</td>\n",
              "      <td>0.485934</td>\n",
              "      <td>6.463394</td>\n",
              "      <td>0.004897</td>\n",
              "      <td>2421.717990</td>\n",
              "      <td>0.215673</td>\n",
              "      <td>2.090703</td>\n",
              "      <td>11.097635</td>\n",
              "      <td>6.965459</td>\n",
              "      <td>0.036808</td>\n",
              "      <td>0.318392</td>\n",
              "      <td>2973.634146</td>\n",
              "      <td>46693.750000</td>\n",
              "      <td>4534.375000</td>\n",
              "      <td>0.359413</td>\n",
              "      <td>4.636646</td>\n",
              "      <td>29307.451923</td>\n",
              "      <td>0.154717</td>\n",
              "      <td>0.000001</td>\n",
              "      <td>23.201863</td>\n",
              "      <td>0.511158</td>\n",
              "      <td>0.000380</td>\n",
              "      <td>0.000211</td>\n",
              "      <td>705340.625000</td>\n",
              "      <td>0.000027</td>\n",
              "      <td>25962.500000</td>\n",
              "      <td>0.000107</td>\n",
              "      <td>0.162062</td>\n",
              "      <td>1.128838</td>\n",
              "      <td>71566.268293</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48177</th>\n",
              "      <td>190632</td>\n",
              "      <td>769</td>\n",
              "      <td>7424.368421</td>\n",
              "      <td>3.938947</td>\n",
              "      <td>14740</td>\n",
              "      <td>10.89</td>\n",
              "      <td>credit</td>\n",
              "      <td>659</td>\n",
              "      <td>1.52</td>\n",
              "      <td>1</td>\n",
              "      <td>1199.715190</td>\n",
              "      <td>2724</td>\n",
              "      <td>115</td>\n",
              "      <td>0</td>\n",
              "      <td>6</td>\n",
              "      <td>247.895969</td>\n",
              "      <td>0.004034</td>\n",
              "      <td>1127.764411</td>\n",
              "      <td>1546.368421</td>\n",
              "      <td>1077.210526</td>\n",
              "      <td>4158.755765</td>\n",
              "      <td>0.001294</td>\n",
              "      <td>2160.375000</td>\n",
              "      <td>2482</td>\n",
              "      <td>1.426721e+04</td>\n",
              "      <td>0.008789</td>\n",
              "      <td>98.666667</td>\n",
              "      <td>119</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>433.552632</td>\n",
              "      <td>0.002307</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>7</td>\n",
              "      <td>1792.105263</td>\n",
              "      <td>0.001446</td>\n",
              "      <td>2.725539</td>\n",
              "      <td>1.985354</td>\n",
              "      <td>0.001467</td>\n",
              "      <td>...</td>\n",
              "      <td>29.195617</td>\n",
              "      <td>0.016525</td>\n",
              "      <td>10.560147</td>\n",
              "      <td>0.038946</td>\n",
              "      <td>167.303581</td>\n",
              "      <td>304.577614</td>\n",
              "      <td>0.103578</td>\n",
              "      <td>0.640985</td>\n",
              "      <td>70.615243</td>\n",
              "      <td>0.052171</td>\n",
              "      <td>0.013217</td>\n",
              "      <td>0.042217</td>\n",
              "      <td>64.559725</td>\n",
              "      <td>0.005122</td>\n",
              "      <td>1353.535354</td>\n",
              "      <td>0.282305</td>\n",
              "      <td>1.560098</td>\n",
              "      <td>12.286249</td>\n",
              "      <td>6.188442</td>\n",
              "      <td>0.003457</td>\n",
              "      <td>0.366900</td>\n",
              "      <td>1884.861037</td>\n",
              "      <td>9697.368421</td>\n",
              "      <td>75.657895</td>\n",
              "      <td>4.133536</td>\n",
              "      <td>3.542263</td>\n",
              "      <td>4884.452909</td>\n",
              "      <td>0.015490</td>\n",
              "      <td>0.000008</td>\n",
              "      <td>19.167750</td>\n",
              "      <td>0.361703</td>\n",
              "      <td>0.005977</td>\n",
              "      <td>0.000267</td>\n",
              "      <td>125415.789474</td>\n",
              "      <td>0.000057</td>\n",
              "      <td>433.552632</td>\n",
              "      <td>0.000558</td>\n",
              "      <td>1.820509</td>\n",
              "      <td>11.266113</td>\n",
              "      <td>48396.686264</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49068</th>\n",
              "      <td>128813</td>\n",
              "      <td>603</td>\n",
              "      <td>7617.888889</td>\n",
              "      <td>3.095556</td>\n",
              "      <td>13910</td>\n",
              "      <td>6.78</td>\n",
              "      <td>other</td>\n",
              "      <td>10082</td>\n",
              "      <td>0.63</td>\n",
              "      <td>1</td>\n",
              "      <td>1204.308725</td>\n",
              "      <td>2738</td>\n",
              "      <td>1431</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>213.620232</td>\n",
              "      <td>0.004681</td>\n",
              "      <td>1180.577027</td>\n",
              "      <td>1543.944444</td>\n",
              "      <td>1139.722222</td>\n",
              "      <td>47357.190660</td>\n",
              "      <td>0.000572</td>\n",
              "      <td>2263.000000</td>\n",
              "      <td>2525</td>\n",
              "      <td>6.669000e+05</td>\n",
              "      <td>0.001578</td>\n",
              "      <td>1542.125000</td>\n",
              "      <td>1924</td>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>16003.174603</td>\n",
              "      <td>0.000062</td>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>6</td>\n",
              "      <td>4346.031746</td>\n",
              "      <td>0.001131</td>\n",
              "      <td>2.782282</td>\n",
              "      <td>1.825965</td>\n",
              "      <td>0.000890</td>\n",
              "      <td>...</td>\n",
              "      <td>462.275664</td>\n",
              "      <td>0.000672</td>\n",
              "      <td>211.061947</td>\n",
              "      <td>0.059139</td>\n",
              "      <td>3256.927495</td>\n",
              "      <td>389.044455</td>\n",
              "      <td>0.079156</td>\n",
              "      <td>0.500702</td>\n",
              "      <td>88.938053</td>\n",
              "      <td>0.043350</td>\n",
              "      <td>0.000440</td>\n",
              "      <td>0.522644</td>\n",
              "      <td>5.323472</td>\n",
              "      <td>0.005134</td>\n",
              "      <td>2051.622419</td>\n",
              "      <td>0.220234</td>\n",
              "      <td>1.997195</td>\n",
              "      <td>11.550194</td>\n",
              "      <td>6.325528</td>\n",
              "      <td>0.078268</td>\n",
              "      <td>0.359417</td>\n",
              "      <td>2460.911701</td>\n",
              "      <td>22079.365079</td>\n",
              "      <td>2271.428571</td>\n",
              "      <td>0.271573</td>\n",
              "      <td>4.540630</td>\n",
              "      <td>12091.887125</td>\n",
              "      <td>0.187847</td>\n",
              "      <td>0.000005</td>\n",
              "      <td>23.067993</td>\n",
              "      <td>0.456572</td>\n",
              "      <td>0.000307</td>\n",
              "      <td>0.000223</td>\n",
              "      <td>204465.079365</td>\n",
              "      <td>0.000053</td>\n",
              "      <td>16003.174603</td>\n",
              "      <td>0.000230</td>\n",
              "      <td>0.119451</td>\n",
              "      <td>0.755593</td>\n",
              "      <td>41612.239770</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49545</th>\n",
              "      <td>104564</td>\n",
              "      <td>770</td>\n",
              "      <td>10289.300000</td>\n",
              "      <td>2.684000</td>\n",
              "      <td>14971</td>\n",
              "      <td>6.52</td>\n",
              "      <td>home</td>\n",
              "      <td>7061</td>\n",
              "      <td>4.23</td>\n",
              "      <td>1</td>\n",
              "      <td>1481.188482</td>\n",
              "      <td>2873</td>\n",
              "      <td>894</td>\n",
              "      <td>0</td>\n",
              "      <td>11</td>\n",
              "      <td>135.797403</td>\n",
              "      <td>0.007364</td>\n",
              "      <td>1496.020608</td>\n",
              "      <td>1992.050000</td>\n",
              "      <td>1439.100000</td>\n",
              "      <td>20302.601180</td>\n",
              "      <td>0.000302</td>\n",
              "      <td>2537.000000</td>\n",
              "      <td>2849</td>\n",
              "      <td>2.084400e+05</td>\n",
              "      <td>0.000985</td>\n",
              "      <td>1130.888889</td>\n",
              "      <td>1348</td>\n",
              "      <td>3</td>\n",
              "      <td>12</td>\n",
              "      <td>1669.267139</td>\n",
              "      <td>0.000599</td>\n",
              "      <td>3</td>\n",
              "      <td>12</td>\n",
              "      <td>11</td>\n",
              "      <td>679.196217</td>\n",
              "      <td>0.000934</td>\n",
              "      <td>3.581378</td>\n",
              "      <td>1.455007</td>\n",
              "      <td>0.000634</td>\n",
              "      <td>...</td>\n",
              "      <td>333.084948</td>\n",
              "      <td>0.000923</td>\n",
              "      <td>137.116564</td>\n",
              "      <td>0.098402</td>\n",
              "      <td>2630.774963</td>\n",
              "      <td>551.858600</td>\n",
              "      <td>0.074835</td>\n",
              "      <td>0.519853</td>\n",
              "      <td>118.098160</td>\n",
              "      <td>0.051433</td>\n",
              "      <td>0.004732</td>\n",
              "      <td>0.311173</td>\n",
              "      <td>11.509284</td>\n",
              "      <td>0.003486</td>\n",
              "      <td>2296.165644</td>\n",
              "      <td>0.268013</td>\n",
              "      <td>1.923621</td>\n",
              "      <td>10.107424</td>\n",
              "      <td>6.946651</td>\n",
              "      <td>0.067528</td>\n",
              "      <td>0.279222</td>\n",
              "      <td>3833.569300</td>\n",
              "      <td>3539.243499</td>\n",
              "      <td>211.347518</td>\n",
              "      <td>0.406883</td>\n",
              "      <td>3.731169</td>\n",
              "      <td>2432.458629</td>\n",
              "      <td>0.086886</td>\n",
              "      <td>0.000040</td>\n",
              "      <td>19.442857</td>\n",
              "      <td>0.411656</td>\n",
              "      <td>0.000380</td>\n",
              "      <td>0.000179</td>\n",
              "      <td>24719.621749</td>\n",
              "      <td>0.000062</td>\n",
              "      <td>1669.267139</td>\n",
              "      <td>0.001472</td>\n",
              "      <td>0.209770</td>\n",
              "      <td>1.457202</td>\n",
              "      <td>38958.271237</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49624</th>\n",
              "      <td>49036</td>\n",
              "      <td>800</td>\n",
              "      <td>9174.533333</td>\n",
              "      <td>4.037333</td>\n",
              "      <td>14679</td>\n",
              "      <td>12.62</td>\n",
              "      <td>cash</td>\n",
              "      <td>8621</td>\n",
              "      <td>3.18</td>\n",
              "      <td>0</td>\n",
              "      <td>1419.099010</td>\n",
              "      <td>2866</td>\n",
              "      <td>1369</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>61.295000</td>\n",
              "      <td>0.016315</td>\n",
              "      <td>1372.265053</td>\n",
              "      <td>1695.533333</td>\n",
              "      <td>1296.533333</td>\n",
              "      <td>101558.295717</td>\n",
              "      <td>0.000642</td>\n",
              "      <td>2335.888889</td>\n",
              "      <td>2538</td>\n",
              "      <td>1.442100e+06</td>\n",
              "      <td>0.001796</td>\n",
              "      <td>1432.142857</td>\n",
              "      <td>1674</td>\n",
              "      <td>7</td>\n",
              "      <td>12</td>\n",
              "      <td>2711.006289</td>\n",
              "      <td>0.000369</td>\n",
              "      <td>7</td>\n",
              "      <td>12</td>\n",
              "      <td>5</td>\n",
              "      <td>901.257862</td>\n",
              "      <td>0.001409</td>\n",
              "      <td>3.201163</td>\n",
              "      <td>1.599972</td>\n",
              "      <td>0.001376</td>\n",
              "      <td>...</td>\n",
              "      <td>339.085205</td>\n",
              "      <td>0.001464</td>\n",
              "      <td>108.478605</td>\n",
              "      <td>0.187098</td>\n",
              "      <td>2135.320343</td>\n",
              "      <td>351.494140</td>\n",
              "      <td>0.087198</td>\n",
              "      <td>0.563738</td>\n",
              "      <td>63.391442</td>\n",
              "      <td>0.054500</td>\n",
              "      <td>0.002323</td>\n",
              "      <td>0.477669</td>\n",
              "      <td>6.701631</td>\n",
              "      <td>0.005047</td>\n",
              "      <td>1163.153724</td>\n",
              "      <td>0.279135</td>\n",
              "      <td>1.773874</td>\n",
              "      <td>10.343887</td>\n",
              "      <td>6.465041</td>\n",
              "      <td>0.175810</td>\n",
              "      <td>0.312386</td>\n",
              "      <td>2272.424042</td>\n",
              "      <td>4616.037736</td>\n",
              "      <td>430.503145</td>\n",
              "      <td>0.332444</td>\n",
              "      <td>3.582500</td>\n",
              "      <td>2885.073375</td>\n",
              "      <td>0.149217</td>\n",
              "      <td>0.000065</td>\n",
              "      <td>18.348750</td>\n",
              "      <td>0.319915</td>\n",
              "      <td>0.000468</td>\n",
              "      <td>0.000275</td>\n",
              "      <td>15420.125786</td>\n",
              "      <td>0.000257</td>\n",
              "      <td>2711.006289</td>\n",
              "      <td>0.001110</td>\n",
              "      <td>0.164610</td>\n",
              "      <td>1.064208</td>\n",
              "      <td>12145.640687</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>25 rows × 143 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a9bf7b10-3d11-48d4-9a1c-92cb4a220171')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a9bf7b10-3d11-48d4-9a1c-92cb4a220171 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a9bf7b10-3d11-48d4-9a1c-92cb4a220171');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "           income  ...  income / MEAN(loans.rate)\n",
              "client_id          ...                           \n",
              "25707      211422  ...               60805.867127\n",
              "26326      227920  ...               90534.260179\n",
              "26695      174532  ...               70772.155891\n",
              "26945      214516  ...               75128.181181\n",
              "29841       38354  ...               11133.236575\n",
              "32726      235705  ...               77054.284240\n",
              "32885       58955  ...               24201.559934\n",
              "32961      230341  ...               58602.170009\n",
              "35089      131176  ...               37334.851288\n",
              "35214       95849  ...               30836.139410\n",
              "38537      127183  ...               53227.744953\n",
              "39384      191204  ...               54036.531310\n",
              "39505      153873  ...               48228.490832\n",
              "41472      152214  ...               38232.715856\n",
              "41480      122607  ...               39417.135509\n",
              "42320      229481  ...               93386.190993\n",
              "44387      151903  ...               54122.209026\n",
              "44601      156341  ...               37663.454589\n",
              "46109      172677  ...               54774.623315\n",
              "46180       43851  ...               12519.914347\n",
              "46958      225709  ...               71566.268293\n",
              "48177      190632  ...               48396.686264\n",
              "49068      128813  ...               41612.239770\n",
              "49545      104564  ...               38958.271237\n",
              "49624       49036  ...               12145.640687\n",
              "\n",
              "[25 rows x 143 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Exemplo 1 - Montar a função DSF automatica\n",
        "features3, feature_names3 = ft.dfs(entityset=es, target_entity='clients', \n",
        "                                 max_depth = 2)"
      ],
      "metadata": {
        "id": "hdI_U672DMKL"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}