training_app_requester.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "training_app_requester.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "o-P9E9ON3zOz",
        "colab_type": "code",
        "outputId": "5db16660-d380-431a-cf23-924387583a81",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 121
        }
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive', force_remount=True)"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Go to this URL in a browser: https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3Aietf%3Awg%3Aoauth%3A2.0%3Aoob&scope=email%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fdocs.test%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fdrive%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fdrive.photos.readonly%20https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fpeopleapi.readonly&response_type=code\n",
            "\n",
            "Enter your authorization code:\n",
            "··········\n",
            "Mounted at /content/drive\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iHPmiGNq4wZe",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "all_truck = pd.read_csv('/content/drive/My Drive/new_dat.csv')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Gfn5FEWpRzcg",
        "colab_type": "code",
        "outputId": "0603395a-8b3c-42e4-d26b-8319ef23a4f3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        }
      },
      "source": [
        "all_truck.head()"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>id_x</th>\n",
              "      <th>id_android</th>\n",
              "      <th>speed</th>\n",
              "      <th>time_x</th>\n",
              "      <th>distance</th>\n",
              "      <th>rating</th>\n",
              "      <th>rating_bus</th>\n",
              "      <th>rating_weather</th>\n",
              "      <th>car_or_bus</th>\n",
              "      <th>linha</th>\n",
              "      <th>id_y</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>track_id</th>\n",
              "      <th>time_y</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>19.210586</td>\n",
              "      <td>0.138049</td>\n",
              "      <td>2.652</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>-10.939341</td>\n",
              "      <td>-37.062742</td>\n",
              "      <td>1</td>\n",
              "      <td>2014-09-13 07:24:32</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>19.210586</td>\n",
              "      <td>0.138049</td>\n",
              "      <td>2.652</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>-10.939341</td>\n",
              "      <td>-37.062742</td>\n",
              "      <td>1</td>\n",
              "      <td>2014-09-13 07:24:37</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>19.210586</td>\n",
              "      <td>0.138049</td>\n",
              "      <td>2.652</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>-10.939324</td>\n",
              "      <td>-37.062765</td>\n",
              "      <td>1</td>\n",
              "      <td>2014-09-13 07:24:42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>19.210586</td>\n",
              "      <td>0.138049</td>\n",
              "      <td>2.652</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>-10.939211</td>\n",
              "      <td>-37.062843</td>\n",
              "      <td>1</td>\n",
              "      <td>2014-09-13 07:24:47</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>19.210586</td>\n",
              "      <td>0.138049</td>\n",
              "      <td>2.652</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5</td>\n",
              "      <td>-10.938939</td>\n",
              "      <td>-37.062879</td>\n",
              "      <td>1</td>\n",
              "      <td>2014-09-13 07:24:53</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Unnamed: 0  id_x  id_android  ...  longitude  track_id               time_y\n",
              "0           0     1           0  ... -37.062742         1  2014-09-13 07:24:32\n",
              "1           1     1           0  ... -37.062742         1  2014-09-13 07:24:37\n",
              "2           2     1           0  ... -37.062765         1  2014-09-13 07:24:42\n",
              "3           3     1           0  ... -37.062843         1  2014-09-13 07:24:47\n",
              "4           4     1           0  ... -37.062879         1  2014-09-13 07:24:53\n",
              "\n",
              "[5 rows x 16 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qHWb_92s6D4d",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "!pip install pyrebase"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7on5BymG5ub8",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pyrebase\n",
        "\n",
        "config = {\n",
        "    \"apiKey\": \"AIzaSyBSD_sLmGCmbWsMGAfjCFq07YT6GZ44Cgk\",\n",
        "    \"authDomain\": \"rota-d2e8e.firebaseapp.com\",\n",
        "    \"databaseURL\": \"https://rota-d2e8e.firebaseio.com\",\n",
        "    \"projectId\": \"rota-d2e8e\",\n",
        "    \"storageBucket\": \"\",\n",
        "    \"messagingSenderId\": \"830006741614\",\n",
        "    \"appId\": \"1:830006741614:web:d0ad1fa4cca7e73829747f\"\n",
        "  }\n",
        "\n",
        "firebase = pyrebase.initialize_app(config)\n",
        "auth = firebase.auth()\n",
        "db = firebase.database()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EhA9gcxw6A4J",
        "colab_type": "code",
        "outputId": "ee996281-cd96-4aa8-fdb2-3f4af0674e0f",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 84
        }
      },
      "source": [
        "#good_paths = [30,31,41,37962,27,26]\n",
        "good_paths = [30,31,37962,27]\n",
        "path_num=1\n",
        "\n",
        "for i in good_paths:\n",
        "  all_request = all_truck.loc[all_truck['track_id'] == i]\n",
        "  #print(path_num,len(all_request))\n",
        "  path_points = []\n",
        "  current_num = 1\n",
        "  \n",
        "  for i in range(len(all_request)):\n",
        "    k = all_request.iloc[i,:]\n",
        "    data = {\n",
        "      \"latitude\": k['latitude'],\n",
        "      \"longitude\": k['longitude']\n",
        "    }\n",
        "    #print(data)\n",
        "    results = db.child(\"training\").child(\"path \"+str(path_num)).child(current_num).set(data)\n",
        "    current_num+=1\n",
        "    #path_points.append(data)\n",
        "  print(path_num)\n",
        "  \n",
        "  path_num+=1\n",
        "  \n",
        "#   data = {\n",
        "#     \"latitude\": k['latitude'],\n",
        "#     \"longitude\": k['longitude'],\n",
        "#     \"speed\": k['speed'],\n",
        "#     \"direction\": k['direction']\n",
        "#   }"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "1\n",
            "2\n",
            "3\n",
            "4\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8yvvmx_L-3L1",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}