day4.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "day4.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "mount_file_id": "1oEgLBrvxETpjWy6vN5Ll1CQAlbtWIZoe",
      "authorship_tag": "ABX9TyMEbow7Sy2Ed7H6SdorYZpq",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/helter88/dw_matrix/blob/master/day4.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-N2W42sxw75h",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "from sklearn.tree import DecisionTreeRegressor\n",
        "from sklearn.metrics import mean_absolute_error\n",
        "from sklearn.model_selection import cross_val_score"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8hFB8tLRx8nl",
        "colab_type": "code",
        "outputId": "3d9f743c-7dc7-437d-cdba-42df5671d6da",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "cd '/content/drive/My Drive/Colab Notebooks/dw_matrix'"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/content/drive/My Drive/Colab Notebooks/dw_matrix\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jMNO1nHwyqnB",
        "colab_type": "code",
        "outputId": "ec2ecc71-e1b0-4e2e-9d9b-8694b50b11e8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "ls data"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "men_shoes.csv\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ml2LnjDzyuof",
        "colab_type": "code",
        "outputId": "849b5c7a-74cb-4f51-b880-268c5923e24f",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "df = pd.read_csv('data/men_shoes.csv', low_memory=False)\n",
        "df.shape"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(18280, 48)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 78
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wc3tZKs2zIR9",
        "colab_type": "code",
        "outputId": "120ce495-48b8-42bb-bfa6-954f9b0b4fb9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 230
        }
      },
      "source": [
        "df.columns"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['id', 'asins', 'brand', 'categories', 'colors', 'count', 'dateadded',\n",
              "       'dateupdated', 'descriptions', 'dimension', 'ean', 'features',\n",
              "       'flavors', 'imageurls', 'isbn', 'keys', 'manufacturer',\n",
              "       'manufacturernumber', 'merchants', 'name', 'prices_amountmin',\n",
              "       'prices_amountmax', 'prices_availability', 'prices_color',\n",
              "       'prices_condition', 'prices_count', 'prices_currency',\n",
              "       'prices_dateadded', 'prices_dateseen', 'prices_flavor', 'prices_issale',\n",
              "       'prices_merchant', 'prices_offer', 'prices_returnpolicy',\n",
              "       'prices_shipping', 'prices_size', 'prices_source', 'prices_sourceurls',\n",
              "       'prices_warranty', 'quantities', 'reviews', 'sizes', 'skus',\n",
              "       'sourceurls', 'upc', 'vin', 'websiteids', 'weight'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 79
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6qQu9kq9zZor",
        "colab_type": "code",
        "outputId": "3736416a-5457-4417-a863-18fcc4797693",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "mean_price = np.mean(df['prices_amountmin'])\n",
        "mean_price"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "93.53952188183217"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 80
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "08pfH8Qmz9CB",
        "colab_type": "code",
        "outputId": "4178869b-7f07-4c28-dcba-bc0021cc32df",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "y_true = df['prices_amountmin']\n",
        "y_true.shape[0]\n"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "18280"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 81
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WKZCQpwV0aOl",
        "colab_type": "code",
        "outputId": "9a0e156a-e739-44bd-d440-551d477f14cc",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "y_pred = [mean_price]* y_true.shape[0]\n",
        "\n",
        "mean_absolute_error(y_true, y_pred)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "63.968341227870624"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 82
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "53Fx1Msk1FsR",
        "colab_type": "code",
        "outputId": "d57e734a-87c4-447d-aad7-5123b536b4eb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        }
      },
      "source": [
        "df['prices_amountmin'].hist(bins=100)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83dca62e80>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 83
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD4CAYAAAAAczaOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0\ndHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAWqUlEQVR4nO3df5BdZX3H8feniUAhLQlEtzHJdGOJ\nOkiqhi2Eoe3cEIXwYwx/oIamklg6O22DosSRUP9gqsM0tlYK1tJuTUroUFZEKhmg0hi4w/gHv2KV\nEH7ICpHsTiAiIXahSle//eM8CXd372Z37717b/Y+n9fMzp7znOec+9xvbj737DnnnquIwMzM8vBr\nrR6AmZk1j0PfzCwjDn0zs4w49M3MMuLQNzPLyMxWD+BI5s6dG52dnTWv/9prr3HCCSc0bkDTnOsx\nnOsxmmsy3HStx86dO1+OiLdWW3ZUh35nZyePPfZYzeuXy2VKpVLjBjTNuR7DuR6juSbDTdd6SPrx\nWMt8eMfMLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8vIuKEvaYuk/ZKeGNH+\nCUlPS9ot6W8q2q+R1CfpGUnnVbSvTG19kjY29mmYmdlETOQTuTcD/wDccqhB0nJgFfDeiPiFpLel\n9lOB1cB7gLcD35H0zrTaV4EPAv3Ao5K2RcSTjXoiterceM/h6T2bLmzhSMzMpt64oR8RD0rqHNH8\n58CmiPhF6rM/ta8CelP785L6gDPSsr6IeA5AUm/q2/LQNzPLSa333nkn8AeSrgN+DnwmIh4F5gMP\nVfTrT20Ae0e0n1ltw5K6gW6Ajo4OyuVyjUOEwcHBcdffsGTo8HQ9jzUdTKQeOXE9RnNNhmvHetQa\n+jOBk4BlwO8Bt0t6RyMGFBE9QA9AV1dX1HOzo4ncLGld5eGdNbU/1nQwXW8eNVVcj9Fck+HasR61\nhn4/cGcU36r+iKRfAXOBAWBhRb8FqY0jtJuZWZPUGvrfApYDD6QTtccALwPbgH+X9GWKE7mLgUcA\nAYslLaII+9XAH9U59ppVnrw1M8vJuKEv6TagBMyV1A9cC2wBtqTLON8A1qa9/t2Sbqc4QTsErI+I\nX6btXAHcB8wAtkTE7il4PmZmdgQTuXrn0jEW/fEY/a8DrqvSfi9w76RGZ2ZmDeVP5JqZZcShb2aW\nEYe+mVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGav1EblZ8+2Uzaxfe0zczy4hD38wsIw59M7OMOPTN\nzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy8i4oS9pi6T96asRRy7bICkkzU3zknSjpD5Jj0ta\nWtF3raRn08/axj4NMzObiIns6d8MrBzZKGkhcC7wQkXz+RRfhr4Y6AZuSn1Povhu3TOBM4BrJc2p\nZ+BmZjZ544Z+RDwIvFJl0fXAZ4GoaFsF3BKFh4DZkuYB5wHbI+KViDgAbKfKG4mZmU2tmm64JmkV\nMBARP5BUuWg+sLdivj+1jdVebdvdFH8l0NHRQblcrmWIAAwODlZdf8OSoar9x3qsyv71jKfVxqpH\nrlyP0VyT4dqxHpMOfUnHA39JcWin4SKiB+gB6OrqilKpVPO2yuUy1dZfV3HXzEp71lR/rMr+Y/WZ\nDsaqR65cj9Fck+HasR61XL3zO8Ai4AeS9gALgO9J+i1gAFhY0XdBahur3czMmmjSoR8RuyLibRHR\nGRGdFIdqlkbEi8A24LJ0Fc8y4GBE7APuA86VNCedwD03tZmZWRONe3hH0m1ACZgrqR+4NiI2j9H9\nXuACoA94Hfg4QES8IukLwKOp3+cjotrJ4Zbyl6WYWbsbN/Qj4tJxlndWTAewfox+W4Atkxxfy3SO\ncdzfzGw68ydyzcwy4tA3M8uIQ9/MLCM1fTgrZz7Za2bTmff0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0\nzcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjIwb+pK2SNov6YmKtr+V9LSk\nxyX9h6TZFcuukdQn6RlJ51W0r0xtfZI2Nv6pmJnZeCayp38zsHJE23bgtIj4XeCHwDUAkk4FVgPv\nSev8o6QZkmYAXwXOB04FLk19zcysicYN/Yh4EHhlRNt/RcRQmn0IWJCmVwG9EfGLiHie4rtyz0g/\nfRHxXES8AfSmvmZm1kSNuJ/+nwBfT9PzKd4EDulPbQB7R7SfWW1jkrqBboCOjg7K5XLNAxscHKy6\n/oYlQ6M716CesbXCWPXIlesxmmsyXDvWo67Ql/Q5YAi4tTHDgYjoAXoAurq6olQq1bytcrlMtfXX\nNehLz/esGb3to9lY9ciV6zGaazJcO9aj5tCXtA64CFgREZGaB4CFFd0WpDaO0G5mZk1S0yWbklYC\nnwU+FBGvVyzaBqyWdKykRcBi4BHgUWCxpEWSjqE42butvqGbmdlkjbunL+k2oATMldQPXEtxtc6x\nwHZJAA9FxJ9FxG5JtwNPUhz2WR8Rv0zbuQK4D5gBbImI3VPwfMzM7AjGDf2IuLRK8+Yj9L8OuK5K\n+73AvZManZmZNZQ/kWtmlhGHvplZRhz6ZmYZceibmWXEoW9mlhGHvplZRhpx751sdVbczmHPpgtb\nOBIzs4nJJvQ7G3S/HTOz6cyHd8zMMuLQNzPLiEPfzCwjDn0zs4w49M3MMuLQNzPLiEPfzCwjDn0z\ns4w49M3MMjJu6EvaImm/pCcq2k6StF3Ss+n3nNQuSTdK6pP0uKSlFeusTf2flbR2ap6OmZkdyUT2\n9G8GVo5o2wjsiIjFwI40D3A+xZehLwa6gZugeJOg+G7dM4EzgGsPvVGYmVnzjBv6EfEg8MqI5lXA\n1jS9Fbi4ov2WKDwEzJY0DzgP2B4Rr0TEAWA7o99IzMxsitV6w7WOiNiXpl8EOtL0fGBvRb/+1DZW\n+yiSuin+SqCjo4NyuVzjEGFwcPDw+huWDNW8nYmoZ5zNUlkPcz2qcU2Ga8d61H2XzYgISdGIwaTt\n9QA9AF1dXVEqlWreVrlc5tD666b4Lpt71pSmdPuNUFkPcz2qcU2Ga8d61Hr1zkvpsA3p9/7UPgAs\nrOi3ILWN1W5mZk1Ua+hvAw5dgbMWuKui/bJ0Fc8y4GA6DHQfcK6kOekE7rmpzczMmmjcwzuSbgNK\nwFxJ/RRX4WwCbpd0OfBj4COp+73ABUAf8DrwcYCIeEXSF4BHU7/PR8TIk8NmZjbFxg39iLh0jEUr\nqvQNYP0Y29kCbJnU6MzMrKH8iVwzs4w49M3MMuLQNzPLiEPfzCwjDn0zs4w49M3MMuLQNzPLiEPf\nzCwjDn0zs4w49M3MMuLQNzPLiEPfzCwjDn0zs4w49M3MMuLQNzPLiEPfzCwjdYW+pE9L2i3pCUm3\nSTpO0iJJD0vqk/R1Scekvsem+b60vLMRT8DMzCau5tCXNB/4JNAVEacBM4DVwBeB6yPiFOAAcHla\n5XLgQGq/PvUzM7Mmqvfwzkzg1yXNBI4H9gHnAHek5VuBi9P0qjRPWr5Ckup8fDMzm4SaQz8iBoAv\nAS9QhP1BYCfwakQMpW79wPw0PR/Ym9YdSv1PrvXxzcxs8sb9YvSxSJpDsfe+CHgV+Aawst4BSeoG\nugE6Ojool8s1b2twcPDw+huWDB25c53qGWezVNbDXI9qXJPh2rEeNYc+8AHg+Yj4CYCkO4GzgdmS\nZqa9+QXAQOo/ACwE+tPhoBOBn47caET0AD0AXV1dUSqVah5guVzm0PrrNt5T83YmYs+a0pRuvxEq\n62GuRzWuyXDtWI96jum/ACyTdHw6Nr8CeBJ4ALgk9VkL3JWmt6V50vL7IyLqeHwzM5ukeo7pP0xx\nQvZ7wK60rR7gauAqSX0Ux+w3p1U2Ayen9quAjXWM28zMalDP4R0i4lrg2hHNzwFnVOn7c+DD9Tye\nmZnVx5/INTPLSF17+lZdZ8VJ4z2bLmzhSMzMhvOevplZRhz6ZmYZceibmWXEoW9mlhGHvplZRhz6\nZmYZceibmWXEoW9mlhGHvplZRvyJ3AbpnOJbN5uZNYL39M3MMuLQNzPLiEPfzCwjDn0zs4z4RO4U\n822WzexoUteevqTZku6Q9LSkpySdJekkSdslPZt+z0l9JelGSX2SHpe0tDFPwczMJqrewzs3AN+O\niHcD7wWeovju2x0RsRjYwZvfhXs+sDj9dAM31fnYZmY2STWHvqQTgT8kffF5RLwREa8Cq4CtqdtW\n4OI0vQq4JQoPAbMlzat55GZmNmmKiNpWlN4H9ABPUuzl7wSuBAYiYnbqI+BARMyWdDewKSK+m5bt\nAK6OiMdGbLeb4i8BOjo6Tu/t7a1pfACDg4PMmjULgF0DB2veTqMsmX9iSx+/sh7melTjmgw3Xeux\nfPnynRHRVW1ZPSdyZwJLgU9ExMOSbuDNQzkARERImtS7SkT0ULyZ0NXVFaVSqeYBlstlDq2/7ij4\nxOyeNaWWPn5lPcz1qMY1Ga4d61HPMf1+oD8iHk7zd1C8Cbx06LBN+r0/LR8AFlasvyC1mZlZk9Qc\n+hHxIrBX0rtS0wqKQz3bgLWpbS1wV5reBlyWruJZBhyMiH21Pr6ZmU1evdfpfwK4VdIxwHPAxyne\nSG6XdDnwY+Ajqe+9wAVAH/B66mtmZk1UV+hHxPeBaicLVlTpG8D6eh7PzMzq49swmJllxKFvZpYR\nh76ZWUZ8w7Um8s3XzKzVvKdvZpYRh76ZWUYc+mZmGXHom5llxKFvZpYRh76ZWUYc+mZmGXHom5ll\nxKFvZpYRh76ZWUYc+mZmGXHom5llxKFvZpaRuu+yKWkG8BgwEBEXSVoE9AInAzuBj0XEG5KOBW4B\nTgd+Cnw0IvbU+/jtwHffNLNmacStla8EngJ+M81/Ebg+Inol/RNwOXBT+n0gIk6RtDr1+2gDHn9a\nqgx6M7NmqevwjqQFwIXA19K8gHOAO1KXrcDFaXpVmictX5H6m5lZk6j4vvIaV5buAP4a+A3gM8A6\n4KGIOCUtXwj8Z0ScJukJYGVE9KdlPwLOjIiXR2yzG+gG6OjoOL23t7fm8Q0ODjJr1iwAdg0crHk7\nzbRk/olTtu3KepjrUY1rMtx0rcfy5ct3RkRXtWU1H96RdBGwPyJ2SirVup2RIqIH6AHo6uqKUqn2\nTX/l1rv4u+++luamx5eE7VlTmrJtl8tl6qlnu3E9RnNNhmvHetSThGcDH5J0AXAcxTH9G4DZkmZG\nxBCwABhI/QeAhUC/pJnAiRQndM3MrElqPqYfEddExIKI6ARWA/dHxBrgAeCS1G0tcFea3pbmScvv\nj3qOLZmZ2aRNxXX6VwNXSeqjuGxzc2rfDJyc2q8CNk7BY5uZ2RE05EB3RJSBcpp+DjijSp+fAx9u\nxOOZmVltpsfZzUz5Q1tm1mi+DYOZWUYc+mZmGXHom5llxKFvZpYRn8g9yvhGbGY2lbynb2aWEYe+\nmVlGHPpmZhlx6JuZZcShb2aWEV+9M034lgxm1gje0zczy4hD38wsIw59M7OMOPTNzDJSc+hLWijp\nAUlPStot6crUfpKk7ZKeTb/npHZJulFSn6THJS1t1JMwM7OJqWdPfwjYEBGnAsuA9ZJOpfgaxB0R\nsRjYwZtfi3g+sDj9dAM31fHYZmZWg3q+GH1fRHwvTf8P8BQwH1gFbE3dtgIXp+lVwC1ReAiYLWle\nzSM3M7NJU0TUvxGpE3gQOA14ISJmp3YBByJitqS7gU0R8d20bAdwdUQ8NmJb3RR/CdDR0XF6b29v\nzePa/8pBXvrfmlc/ai2Zf+Lh6V0DByfUD2BwcJBZs2ZN2bimG9djNNdkuOlaj+XLl++MiK5qy+r+\ncJakWcA3gU9FxM+KnC9EREia1LtKRPQAPQBdXV1RKpVqHttXbr2Lv9vVfp8/27OmdHh63RFuxVzZ\nD6BcLlNPPduN6zGaazJcO9ajrkSU9BaKwL81Iu5MzS9JmhcR+9Lhm/2pfQBYWLH6gtRmk+R77ptZ\nreq5ekfAZuCpiPhyxaJtwNo0vRa4q6L9snQVzzLgYETsq/Xxzcxs8uq5euds4GPAOZK+n34uADYB\nH5T0LPCBNA9wL/Ac0Af8C/AXdTy2TVLnxnvYNXDQfyWYZa7mwzvphKzGWLyiSv8A1tf6eGZmVr/2\nO8tph3mv3sxG8m0YzMwy4tA3M8uIQ9/MLCM+pm9NM52+/Ws6jdVsMrynb2aWEe/p22GT3bv13rDZ\n9OM9fTOzjHhPP0P17KG3w7X/h57DhiVDlFo7FLOmc+hnrh1C3MwmzqFvVfnNwKw9OfStIXxS12x6\ncOibtYDfJK1VHPrWcA40s6OXQ9+mlM8NmB1dHPpm1lD+S+/o5tC3o8pYfxnUEh4OH7PRmh76klYC\nNwAzgK9FxKZxVrE2VM9hn1aGeSPflMxaoamhL2kG8FXgg0A/8KikbRHxZDPHYdPPRN4kjtSnnvWn\n+rxEoz4h7b+GbCKavad/BtAXEc8BSOoFVgEOfatJvYHcqECfijeGyW5zov3HCvfOjfewYckQ6zbe\nM6zPRP66mYo61vMm1Kg3w3a8VYeK7ytv0oNJlwArI+JP0/zHgDMj4oqKPt1Ad5p9F/BMHQ85F3i5\njvXbjesxnOsxmmsy3HStx29HxFurLTjqTuRGRA/Q04htSXosIroasa124HoM53qM5poM1471aPat\nlQeAhRXzC1KbmZk1QbND/1FgsaRFko4BVgPbmjwGM7NsNfXwTkQMSboCuI/iks0tEbF7Ch+yIYeJ\n2ojrMZzrMZprMlzb1aOpJ3LNzKy1/HWJZmYZceibmWWkLUNf0kpJz0jqk7Sx1eNpBkkLJT0g6UlJ\nuyVdmdpPkrRd0rPp95zULkk3pho9Lmlpa5/B1JE0Q9J/S7o7zS+S9HB67l9PFxUg6dg035eWd7Zy\n3FNB0mxJd0h6WtJTks7K/TUi6dPp/8wTkm6TdFw7v0baLvQrbvVwPnAqcKmkU1s7qqYYAjZExKnA\nMmB9et4bgR0RsRjYkeahqM/i9NMN3NT8ITfNlcBTFfNfBK6PiFOAA8Dlqf1y4EBqvz71azc3AN+O\niHcD76WoS7avEUnzgU8CXRFxGsUFJqtp59dIRLTVD3AWcF/F/DXANa0eVwvqcBfFPY6eAealtnnA\nM2n6n4FLK/of7tdOPxSfBdkBnAPcDYjiE5YzR75eKK4qOytNz0z91Orn0MBanAg8P/I55fwaAeYD\ne4GT0r/53cB57fwaabs9fd78RzykP7VlI/3J+X7gYaAjIvalRS8CHWk6lzr9PfBZ4Fdp/mTg1YgY\nSvOVz/twTdLyg6l/u1gE/AT413S462uSTiDj10hEDABfAl4A9lH8m++kjV8j7Rj6WZM0C/gm8KmI\n+Fnlsih2T7K5RlfSRcD+iNjZ6rEcJWYCS4GbIuL9wGu8eSgHyPI1Mofipo+LgLcDJwArWzqoKdaO\noZ/trR4kvYUi8G+NiDtT80uS5qXl84D9qT2HOp0NfEjSHqCX4hDPDcBsSYc+mFj5vA/XJC0/Efhp\nMwc8xfqB/oh4OM3fQfEmkPNr5APA8xHxk4j4P+BOitdN275G2jH0s7zVgyQBm4GnIuLLFYu2AWvT\n9FqKY/2H2i9LV2gsAw5W/InfFiLimohYEBGdFK+D+yNiDfAAcEnqNrImh2p1SerfNnu9EfEisFfS\nu1LTCorbmmf7GqE4rLNM0vHp/9ChmrTva6TVJxWm4ge4APgh8CPgc60eT5Oe8+9T/Fn+OPD99HMB\nxfHGHcCzwHeAk1J/UVzl9CNgF8XVCy1/HlNYnxJwd5p+B/AI0Ad8Azg2tR+X5vvS8ne0etxTUIf3\nAY+l18m3gDm5v0aAvwKeBp4A/g04tp1fI74Ng5lZRtrx8I6ZmY3BoW9mlhGHvplZRhz6ZmYZceib\nmWXEoW9mlhGHvplZRv4fBnckiw8FKkYAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vkj6xAVd1cBj",
        "colab_type": "code",
        "outputId": "f32bc561-f04f-4166-e139-2263f41ee30e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 282
        }
      },
      "source": [
        "np.log1p(df['prices_amountmin']).hist(bins=100)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f83da6cf160>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 84
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD4CAYAAAAXUaZHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0\ndHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAARO0lEQVR4nO3dX4xcZ3nH8e9DnEDIgg1JtIpsi41E\nlArFKsSrBJQKrXGpEoIIF4BCQxqjVO5FoKFJ1RhuaC9QzQWk6R9FsmIqR01ZggmNFQcKSuy2uYhL\nHNJuiKF1UtN4FWICxrAhiKZ9erGvzcTsn9nZmTkz734/0mrPnPOemWfG69+8+5wzZyMzkSTV5VVN\nFyBJ6j7DXZIqZLhLUoUMd0mqkOEuSRVa1XQBAOedd16OjY11tO+LL77IOeec092Cesya+8Oae2/Y\n6oW6aj548OALmXn+nDtlZuNfGzduzE7t27ev432bYs39Yc29N2z1ZtZVM/BYzpOrtmUkqUKGuyRV\nyHCXpAoZ7pJUIcNdkipkuEtShQx3SaqQ4S5JFTLcJalCA3H5AUm/bmzb3lPLR7Zf3WAlGkbO3CWp\nQoa7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqUKGuyRVqK1wj4g/iojvRMSTEfHF\niHhNRFwYEQci4nBEfCkizipjX11uHy7bx3r5BCRJv27RcI+ItcAfAuOZeQlwBnAt8Fng9sx8M3Ac\nuLHsciNwvKy/vYyTJPVRu22ZVcDZEbEKeC3wHPAuYHfZvgt4f1m+ptymbN8cEdGdciVJ7YjMXHxQ\nxM3AZ4CXgG8ANwOPltk5EbEe+FpmXhIRTwJXZubRsu1p4PLMfOG0+9wKbAUYHR3dODk52dETmJmZ\nYWRkpKN9m2LN/THsNU9Nnzi1fsPa1U2VtKBhf42HxXw1b9q06WBmjs+5U2Yu+AW8AXgYOB84E/gH\n4CPA4ZYx64Eny/KTwLqWbU8D5y30GBs3bsxO7du3r+N9m2LN/THsNb/ptgdOfQ2qYX+Nh8V8NQOP\n5Ty52k5b5reB/8rMH2bm/wD3AVcAa0qbBmAdMF2Wp0vYU7avBn7UxuNIkrqknXD/b+DtEfHa0jvf\nDDwF7AM+UMbcANxflveU25TtD5d3GElSnywa7pl5gNkDo48DU2WfHcBtwC0RcRg4F9hZdtkJnFvW\n3wJs60HdkqQFtPVn9jLz08CnT1v9DHDZHGN/AXxw+aVJkjrlJ1QlqUKGuyRVyHCXpAoZ7pJUIcNd\nkipkuEtShQx3SaqQ4S5JFTLcJalChrskVchwl6QKGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWp\nQoa7JFXIcJekCrX1N1Ql1WFs295Ty0e2X91gJeo1w10aAoaylsq2jCRVyHCXpAoZ7pJUIcNdkipk\nuEtShQx3SaqQ4S5JFfI8d6kBnreuXjPcpSHjG4PaYbhLlTD01cqeuyRVyHCXpAoZ7pJUIcNdkipk\nuEtShQx3SaqQ4S5JFTLcJalCbYV7RKyJiN0R8d2IOBQR74iIN0bENyPiP8v3N5SxERF/GRGHI+Lf\nI+LS3j4FSdLp2p253wF8PTN/A/hN4BCwDXgoMy8CHiq3Aa4CLipfW4E7u1qxJGlRi4Z7RKwG3gns\nBMjMX2bmT4BrgF1l2C7g/WX5GuDunPUosCYiLuh65ZKkeUVmLjwg4q3ADuApZmftB4GbgenMXFPG\nBHA8M9dExAPA9sx8pGx7CLgtMx877X63MjuzZ3R0dOPk5GRHT2BmZoaRkZGO9m2KNffHINc8NX3i\n1PKGtatPLbfW3DpmPq37znef7Txupwb5NZ5PTTVv2rTpYGaOz7VPOxcOWwVcCnw8Mw9ExB38qgUD\nQGZmRCz8LnGazNzB7JsG4+PjOTExsZTdT9m/fz+d7tsUa+6PQa55S+tFvq6bOLXcWnPrmPm07jvf\nfbbzuJ0a5Nd4Piul5nZ67keBo5l5oNzezWzYP3+y3VK+Hyvbp4H1LfuvK+skSX2yaLhn5g+AZyPi\n4rJqM7Mtmj3ADWXdDcD9ZXkP8HvlrJm3Aycy87nuli1JWki713P/OHBPRJwFPAN8lNk3hnsj4kbg\n+8CHytgHgfcAh4Gfl7GSpD5qK9wz8wlgrqb95jnGJnDTMuuSJC2Dn1CVpAoZ7pJUIcNdkirkH8iW\nKjfWxvnyqo8zd0mqkOEuSRWyLSMNMVsumo8zd0mqkOEuSRWyLSN1WWur5Mj2qxusRCuZM3dJqpAz\nd2mATE2faOs67tJinLlLUoWcuUt94mmL6idn7pJUIcNdkipkW0ZawOmtFE9t1LBw5i5JFTLcJalC\ntmWkDtX0SdSanotmOXOXpAoZ7pJUIcNdkipkz12qkJ+GlTN3SaqQ4S5JFTLcJalChrskVchwl6QK\nGe6SVCHDXZIqZLhLUoUMd0mqkOEuSRUy3CWpQoa7qjS2bS9T0ye8xopWLC8cJnWBbyIaNM7cJalC\nztwlzcs/vze82p65R8QZEfHtiHig3L4wIg5ExOGI+FJEnFXWv7rcPly2j/WmdEnSfJbSlrkZONRy\n+7PA7Zn5ZuA4cGNZfyNwvKy/vYyTJPVRW22ZiFgHXA18BrglIgJ4F/C7Zcgu4E+BO4FryjLAbuCv\nIyIyM7tXtqRe8eBwHaKdzI2I3cCfA68D/hjYAjxaZudExHrga5l5SUQ8CVyZmUfLtqeByzPzhdPu\ncyuwFWB0dHTj5ORkR09gZmaGkZGRjvZtijX33tT0CUbPhudfgg1rVy/rflq13tfp2+bSzvjWMcd+\nfILnX1pqlZ1ZznM5adh+LqCumjdt2nQwM8fn2mfRmXtEvBc4lpkHI2Ji2VUWmbkD2AEwPj6eExOd\n3fX+/fvpdN+mWHPvbdm2l1s3vMznplZx5LqJZd1Pq9b7On3bXNoZ3zrmr+65n89N9ec8h+U8l5OG\n7ecCVk7N7fwUXQG8LyLeA7wGeD1wB7AmIlZl5svAOmC6jJ8G1gNHI2IVsBr40ZKqkvrAM0FUs0UP\nqGbmJzNzXWaOAdcCD2fmdcA+4ANl2A3A/WV5T7lN2f6w/XZJ6q/lfIjpNmYPrh4GzgV2lvU7gXPL\n+luAbcsrUZK0VEtq7mXmfmB/WX4GuGyOMb8APtiF2iRJHfLyA5JUIcNdkirktWWkhrWetXPrhgYL\nWYKTNd+64WW2bNvr2UYDyJm7JFXIcJekChnuklQhw12SKmS4S1KFDHdJqpDhLkkVMtwlqUKGuyRV\nyHCXpAp5+QFpCfz7ohoWhruktvjGNlxsy0hShQx3SaqQbRmph2xlqCnO3CWpQoa7JFXItoykZWtt\nP/lXmQaDM3dJqpAzd+k0HgRVDZy5S1KFnLlL6ir774PBcJfUMwZ9cwx3rSj207VS2HOXpAoZ7pJU\nIdsy0gpli6puztwlqUKGuyRVyHCXpAoZ7pJUIcNdkipkuEtShQx3SaqQ4S5JFfJDTJL6zguK9d6i\n4R4R64G7gVEggR2ZeUdEvBH4EjAGHAE+lJnHIyKAO4D3AD8HtmTm470pX1KtfANYnnbaMi8Dt2bm\nW4C3AzdFxFuAbcBDmXkR8FC5DXAVcFH52grc2fWqJUkLWnTmnpnPAc+V5Z9FxCFgLXANMFGG7QL2\nA7eV9XdnZgKPRsSaiLig3I+kFcpr2fTXkg6oRsQY8DbgADDaEtg/YLZtA7PB/2zLbkfLOklSn8Ts\nBLuNgREjwD8Bn8nM+yLiJ5m5pmX78cx8Q0Q8AGzPzEfK+oeA2zLzsdPubyuzbRtGR0c3Tk5OdvQE\nZmZmGBkZ6Wjfplhz701Nn2D0bHj+JdiwdvUr1s+lnTH9cLLmYdGNeltf+1at/w7zjenEsP0sw/w1\nb9q06WBmjs+1T1tny0TEmcBXgHsy876y+vmT7ZaIuAA4VtZPA+tbdl9X1r1CZu4AdgCMj4/nxMRE\nO6X8mv3799Ppvk2x5t7bsm0vt254mc9NreLIdROvWD+Xdsb0w8mah0U36m197Vu1/jvMN6YTw/az\nDJ3V3M7ZMgHsBA5l5udbNu0BbgC2l+/3t6z/WERMApcDJ+y3qx/s6Uq/0s5b7hXA9cBURDxR1n2K\n2VC/NyJuBL4PfKhse5DZ0yAPM3sq5Ee7WrEkaVHtnC3zCBDzbN48x/gEblpmXVJfOetXbbz8gCRV\naHiO3EhzcMYtzc1wl7Qi1X55A8Nd0lCpPZS7xXDXUPA/tLQ0hrukRvnG3RuGu6SB4QHy7vFUSEmq\nkOEuSRUy3CWpQvbcNXSW2pe1j6uVyHBX37RzVoRnTkjdYVtGkipkuEtShQx3SSvG2La9TE2fWBHH\nYey5Sxp4KyGMu82ZuyRVyHCXpArZllHj/JVb6j5n7pJUIcNdkipkuEtShey5q+u6dQkBe/FS5wx3\nSWpRy/WNbMtIUoWcuUuqQi0z7m4x3CUNLY/LzM+2jCRVyJm7GuGMS+otZ+6SVCFn7ivYQgeglnpw\nypm4BtVK/dk03LUknpEgDQfDXT21UmdNWjkGdcJjz12SKuTMXVJ1/I3RcJekec3XchmGNw/bMlrU\nSvqL8VItDHdJqpBtmUr14wi+M3nVosafZcN9GQb1FChJ6km4R8SVwB3AGcBdmbm9F4+jV5pv9tHO\nm1CNMxepmzr5P9LkBLDr4R4RZwB/A7wbOAp8KyL2ZOZT3X6slWSYj9pLK8VC/x/7HfS9mLlfBhzO\nzGcAImISuAboSbhPTZ9gyxwvaL/fJef7R13OdVl6Mcv2zUBqXj+CPjKzu3cY8QHgysz8/XL7euDy\nzPzYaeO2AlvLzYuB73X4kOcBL3S4b1OsuT+sufeGrV6oq+Y3Zeb5c+3Q2AHVzNwB7Fju/UTEY5k5\n3oWS+saa+8Oae2/Y6oWVU3MvznOfBta33F5X1kmS+qQX4f4t4KKIuDAizgKuBfb04HEkSfPoelsm\nM1+OiI8B/8jsqZBfyMzvdPtxWiy7tdMAa+4Pa+69YasXVkjNXT+gKklqnteWkaQKGe6SVKGhDveI\nuDIivhcRhyNiW9P1LCYivhARxyLiyaZraUdErI+IfRHxVER8JyJubrqmxUTEayLiXyPi30rNf9Z0\nTe2KiDMi4tsR8UDTtbQjIo5ExFREPBERjzVdTzsiYk1E7I6I70bEoYh4R9M1LSQiLi6v78mvn0bE\nJ9rad1h77uUyB/9By2UOgA8P8mUOIuKdwAxwd2Ze0nQ9i4mIC4ALMvPxiHgdcBB4/4C/xgGck5kz\nEXEm8Ahwc2Y+2nBpi4qIW4Bx4PWZ+d6m61lMRBwBxjNzaD4QFBG7gH/JzLvK2XyvzcyfNF1XO0rm\nTTP7odDvLzZ+mGfupy5zkJm/BE5e5mBgZeY/Az9uuo52ZeZzmfl4Wf4ZcAhY22xVC8tZM+XmmeVr\n4GcwEbEOuBq4q+laahURq4F3AjsBMvOXwxLsxWbg6XaCHYY73NcCz7bcPsqAB88wi4gx4G3AgWYr\nWVxpbzwBHAO+mZkDXzPwF8CfAP/XdCFLkMA3IuJguZzIoLsQ+CHwt6X9dVdEnNN0UUtwLfDFdgcP\nc7irTyJiBPgK8InM/GnT9SwmM/83M9/K7KejL4uIgW6BRcR7gWOZebDpWpbotzLzUuAq4KbSdhxk\nq4BLgTsz823Ai8DAH6sDKC2k9wFfbnefYQ53L3PQB6Vv/RXgnsy8r+l6lqL8yr0PuLLpWhZxBfC+\n0sOeBN4VEX/XbEmLy8zp8v0Y8FVmW6WD7ChwtOU3ud3Mhv0wuAp4PDOfb3eHYQ53L3PQY+Xg5E7g\nUGZ+vul62hER50fEmrJ8NrMH3L/bbFULy8xPZua6zBxj9uf44cz8SMNlLSgizikH2Smtjd8BBvos\nsMz8AfBsRFxcVm2mR5ci74EPs4SWDAzxn9lr4DIHyxYRXwQmgPMi4ijw6czc2WxVC7oCuB6YKj1s\ngE9l5oMN1rSYC4Bd5cyCVwH3ZuZQnFo4ZEaBr86+/7MK+PvM/HqzJbXl48A9ZUL4DPDRhutZVHnz\nfDfwB0vab1hPhZQkzW+Y2zKSpHkY7pJUIcNdkipkuEtShQx3SaqQ4S5JFTLcJalC/w/5MH7iu4gW\n+AAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Ywe5oF-X11T_",
        "colab_type": "code",
        "outputId": "f14f7d1f-e437-4f2e-e25e-c0156a05a6f8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "y_true = df['prices_amountmin']\n",
        "y_pred = [np.median(y_true)]* y_true.shape[0]\n",
        "\n",
        "mean_absolute_error(y_true, y_pred)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "58.01120240700219"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 85
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9EWxOkBW2wjl",
        "colab_type": "code",
        "outputId": "e0b5b224-89cf-4047-ea8a-73ef2268a136",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "y_true = df['prices_amountmin']\n",
        "price_log_mean = np.expm1(np.mean(np.log1p(y_true)))\n",
        "y_pred = [price_log_mean]* y_true.shape[0]\n",
        "\n",
        "mean_absolute_error(y_true, y_pred)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "58.03539547661041"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 86
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wsfN6R7P3ksz",
        "colab_type": "code",
        "outputId": "ed125e73-412e-4b8d-e79b-1382273cdf8a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "np.expm1(np.mean(np.log1p(y_true)))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "62.92811169273113"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 87
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aTYDX9Vd3mo4",
        "colab_type": "code",
        "outputId": "312a7aca-7d4c-48de-e3bb-b6a5bd341173",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 230
        }
      },
      "source": [
        "df.columns"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['id', 'asins', 'brand', 'categories', 'colors', 'count', 'dateadded',\n",
              "       'dateupdated', 'descriptions', 'dimension', 'ean', 'features',\n",
              "       'flavors', 'imageurls', 'isbn', 'keys', 'manufacturer',\n",
              "       'manufacturernumber', 'merchants', 'name', 'prices_amountmin',\n",
              "       'prices_amountmax', 'prices_availability', 'prices_color',\n",
              "       'prices_condition', 'prices_count', 'prices_currency',\n",
              "       'prices_dateadded', 'prices_dateseen', 'prices_flavor', 'prices_issale',\n",
              "       'prices_merchant', 'prices_offer', 'prices_returnpolicy',\n",
              "       'prices_shipping', 'prices_size', 'prices_source', 'prices_sourceurls',\n",
              "       'prices_warranty', 'quantities', 'reviews', 'sizes', 'skus',\n",
              "       'sourceurls', 'upc', 'vin', 'websiteids', 'weight'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 88
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0gSJ7H5r4tB7",
        "colab_type": "code",
        "outputId": "92a832a0-5c35-419f-90e6-6511458517d5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 230
        }
      },
      "source": [
        "df.brand.value_counts()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Nike                  1709\n",
              "PUMA                   574\n",
              "Ralph Lauren           524\n",
              "New Balance            361\n",
              "VANS                   356\n",
              "                      ... \n",
              "3dRose LLC               1\n",
              "Rockport Works           1\n",
              "adidas Performance       1\n",
              "Broken T                 1\n",
              "LEVI STRAUSS & CO.       1\n",
              "Name: brand, Length: 1856, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 89
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "v6ca61J045G-",
        "colab_type": "code",
        "outputId": "ece68302-6e46-4938-fa30-77efd72cde6a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "df['brand'].factorize()[0]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([  0,   0,   1, ..., 411, 411, 411])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 90
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dFrn1Lmt5VXM",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df['brand_cat']= df['brand'].factorize()[0]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XkJfx8LU5uAv",
        "colab_type": "code",
        "outputId": "2ee015ae-4bc1-4be8-df57-41822fbaceb7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "feats= ['brand_cat']\n",
        "X = df[ feats].values\n",
        "Y = df['prices_amountmin'].values\n",
        "\n",
        "model = DecisionTreeRegressor(max_depth = 5)\n",
        "\n",
        "scores = cross_val_score(model, X, Y, scoring= 'neg_mean_absolute_error')\n",
        "np.mean(scores), np.std(scores)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(-58.38655694633361, 4.223555478221712)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 92
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "A1ufDCMC7Top",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "\n",
        "def run_model(feats):\n",
        "  X = df[ feats].values\n",
        "  Y = df['prices_amountmin'].values\n",
        "\n",
        "  model = DecisionTreeRegressor(max_depth = 5)\n",
        "\n",
        "  scores = cross_val_score(model, X, Y, scoring= 'neg_mean_absolute_error')\n",
        "  return np.mean(scores), np.std(scores)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HOQa2eOx8FjR",
        "colab_type": "code",
        "outputId": "27ea25d0-6b95-444f-ddb1-56ef7bfb8bc8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "run_model(['brand_cat'])"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(-58.38655694633361, 4.223555478221712)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 94
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iBPi_CvG8Pax",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df['flavors_cat']= df['flavors'].factorize()[0]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GANGeZ518qi9",
        "colab_type": "code",
        "outputId": "d996dafb-6d43-499a-dcb2-f2efca987fb7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "run_model(['flavors_cat'])"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(-64.00110841258031, 3.605273194168391)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pLVSU-dc-U8b",
        "colab_type": "code",
        "outputId": "711575a5-30f4-4e18-b82e-4a6ba7bc3796",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "run_model(['brand_cat', 'flavors_cat' ])"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(-58.38655694633361, 4.223555478221712)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 97
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qPOsGPtD-d9V",
        "colab_type": "code",
        "outputId": "fd556ab7-ec8a-4d29-a371-898136be5bf5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 230
        }
      },
      "source": [
        "!git add day4.ipynb\n",
        "!git commit -m \"Dzień 4 drzewa decyzyjne \"\n",
        "!git push"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "fatal: pathspec 'day4.ipynb' did not match any files\n",
            "On branch master\n",
            "Your branch is up to date with 'origin/master'.\n",
            "\n",
            "Changes not staged for commit:\n",
            "\t\u001b[31mmodified:   matrix_one/day3.ipynb\u001b[m\n",
            "\n",
            "Untracked files:\n",
            "\t\u001b[31mdw_matrix/\u001b[m\n",
            "\n",
            "no changes added to commit\n",
            "Everything up-to-date\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Dmal02eN-3Nq",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "!git config --global user.email \"helter@wp.pl\"\n",
        "!git config --global user.name \"Helter88\""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hHS4y9sOAE1S",
        "colab_type": "code",
        "outputId": "28ec44dd-0c39-4747-b8e4-f05eca0dda1d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 132
        }
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "error",
          "ename": "SyntaxError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-103-74dfe3f08114>\"\u001b[0;36m, line \u001b[0;32m1\u001b[0m\n\u001b[0;31m    git config --global user.email \"helter@wp.pl\"\u001b[0m\n\u001b[0m             ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "99GXYQKLD79b",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "W0k1VR2tFdNh",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eCx3-b8YFvFZ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}