apigoogletrend.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "IPython.OutputArea.auto_scroll_threshold = 9999;\n"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%javascript\n",
    "IPython.OutputArea.auto_scroll_threshold = 9999;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Carregando...aguarde\n",
      "2005\n",
      "01\n",
      "2005-01-01 2005-01-30\n",
      "['Audi']\n",
      "2005-01-01 2005-01-30\n",
      "['BMW']\n",
      "2005-01-01 2005-01-30\n",
      "['Mercedes']\n",
      "2005-01-01 2005-01-30\n",
      "['Ford']\n",
      "2005-01-01 2005-01-30\n",
      "['Fiat']\n",
      "2005-01-01 2005-01-30\n",
      "['Vauxhall']\n",
      "2005-01-01 2005-01-30\n",
      "['Chevrolet']\n",
      "2005-01-01 2005-01-30\n",
      "['Volks']\n",
      "2005-01-01 2005-01-30\n",
      "['Motor']\n",
      "2005-01-01 2005-01-30\n",
      "['Car']\n",
      "2005-01-01 2005-01-30\n",
      "['Ferrari']\n",
      "2005-01-01 2005-01-30\n",
      "['Mustang']\n",
      "2005-01-01 2005-01-30\n",
      "['Nissan']\n",
      "02\n",
      "2005-02-01 2005-02-28\n",
      "['Audi']\n",
      "2005-02-01 2005-02-28\n",
      "['BMW']\n",
      "2005-02-01 2005-02-28\n",
      "['Mercedes']\n",
      "2005-02-01 2005-02-28\n",
      "['Ford']\n",
      "2005-02-01 2005-02-28\n",
      "['Fiat']\n",
      "2005-02-01 2005-02-28\n",
      "['Vauxhall']\n",
      "2005-02-01 2005-02-28\n",
      "['Chevrolet']\n",
      "2005-02-01 2005-02-28\n",
      "['Volks']\n",
      "2005-02-01 2005-02-28\n",
      "['Motor']\n",
      "2005-02-01 2005-02-28\n",
      "['Car']\n",
      "2005-02-01 2005-02-28\n",
      "['Ferrari']\n",
      "2005-02-01 2005-02-28\n",
      "['Mustang']\n",
      "2005-02-01 2005-02-28\n",
      "['Nissan']\n",
      "03\n",
      "Sleep_março\n",
      "2005-03-01 2005-03-30\n",
      "['Audi']\n",
      "2005-03-01 2005-03-30\n",
      "['BMW']\n",
      "2005-03-01 2005-03-30\n",
      "['Mercedes']\n",
      "2005-03-01 2005-03-30\n",
      "['Ford']\n",
      "2005-03-01 2005-03-30\n",
      "['Fiat']\n",
      "2005-03-01 2005-03-30\n",
      "['Vauxhall']\n",
      "2005-03-01 2005-03-30\n",
      "['Chevrolet']\n",
      "2005-03-01 2005-03-30\n",
      "['Volks']\n",
      "2005-03-01 2005-03-30\n",
      "['Motor']\n",
      "2005-03-01 2005-03-30\n",
      "['Car']\n",
      "2005-03-01 2005-03-30\n",
      "['Ferrari']\n",
      "2005-03-01 2005-03-30\n",
      "['Mustang']\n",
      "2005-03-01 2005-03-30\n",
      "['Nissan']\n",
      "04\n",
      "2005-04-01 2005-04-30\n",
      "['Audi']\n",
      "2005-04-01 2005-04-30\n",
      "['BMW']\n",
      "2005-04-01 2005-04-30\n",
      "['Mercedes']\n",
      "2005-04-01 2005-04-30\n",
      "['Ford']\n",
      "2005-04-01 2005-04-30\n",
      "['Fiat']\n",
      "2005-04-01 2005-04-30\n",
      "['Vauxhall']\n",
      "2005-04-01 2005-04-30\n",
      "['Chevrolet']\n",
      "2005-04-01 2005-04-30\n",
      "['Volks']\n",
      "2005-04-01 2005-04-30\n",
      "['Motor']\n",
      "2005-04-01 2005-04-30\n",
      "['Car']\n",
      "2005-04-01 2005-04-30\n",
      "['Ferrari']\n",
      "2005-04-01 2005-04-30\n",
      "['Mustang']\n",
      "2005-04-01 2005-04-30\n",
      "['Nissan']\n",
      "05\n",
      "2005-05-01 2005-05-30\n",
      "['Audi']\n",
      "2005-05-01 2005-05-30\n",
      "['BMW']\n",
      "2005-05-01 2005-05-30\n",
      "['Mercedes']\n",
      "2005-05-01 2005-05-30\n",
      "['Ford']\n",
      "2005-05-01 2005-05-30\n",
      "['Fiat']\n",
      "2005-05-01 2005-05-30\n",
      "['Vauxhall']\n",
      "2005-05-01 2005-05-30\n",
      "['Chevrolet']\n",
      "2005-05-01 2005-05-30\n",
      "['Volks']\n",
      "2005-05-01 2005-05-30\n",
      "['Motor']\n",
      "2005-05-01 2005-05-30\n",
      "['Car']\n",
      "2005-05-01 2005-05-30\n",
      "['Ferrari']\n",
      "2005-05-01 2005-05-30\n",
      "['Mustang']\n",
      "2005-05-01 2005-05-30\n",
      "['Nissan']\n",
      "06\n",
      "Sleep_junho\n",
      "2005-06-01 2005-06-30\n",
      "['Audi']\n",
      "2005-06-01 2005-06-30\n",
      "['BMW']\n",
      "2005-06-01 2005-06-30\n",
      "['Mercedes']\n",
      "2005-06-01 2005-06-30\n",
      "['Ford']\n",
      "2005-06-01 2005-06-30\n",
      "['Fiat']\n",
      "2005-06-01 2005-06-30\n",
      "['Vauxhall']\n",
      "2005-06-01 2005-06-30\n",
      "['Chevrolet']\n",
      "2005-06-01 2005-06-30\n",
      "['Volks']\n",
      "2005-06-01 2005-06-30\n",
      "['Motor']\n",
      "2005-06-01 2005-06-30\n",
      "['Car']\n",
      "2005-06-01 2005-06-30\n",
      "['Ferrari']\n",
      "2005-06-01 2005-06-30\n",
      "['Mustang']\n",
      "2005-06-01 2005-06-30\n",
      "['Nissan']\n",
      "07\n",
      "2005-07-01 2005-07-30\n",
      "['Audi']\n",
      "2005-07-01 2005-07-30\n",
      "['BMW']\n",
      "2005-07-01 2005-07-30\n",
      "['Mercedes']\n",
      "2005-07-01 2005-07-30\n",
      "['Ford']\n",
      "2005-07-01 2005-07-30\n",
      "['Fiat']\n",
      "2005-07-01 2005-07-30\n",
      "['Vauxhall']\n",
      "2005-07-01 2005-07-30\n",
      "['Chevrolet']\n",
      "2005-07-01 2005-07-30\n",
      "['Volks']\n",
      "2005-07-01 2005-07-30\n",
      "['Motor']\n",
      "2005-07-01 2005-07-30\n",
      "['Car']\n",
      "2005-07-01 2005-07-30\n",
      "['Ferrari']\n",
      "2005-07-01 2005-07-30\n",
      "['Mustang']\n",
      "2005-07-01 2005-07-30\n",
      "['Nissan']\n",
      "08\n",
      "2005-08-01 2005-08-30\n",
      "['Audi']\n",
      "2005-08-01 2005-08-30\n",
      "['BMW']\n",
      "2005-08-01 2005-08-30\n",
      "['Mercedes']\n",
      "2005-08-01 2005-08-30\n",
      "['Ford']\n",
      "2005-08-01 2005-08-30\n",
      "['Fiat']\n",
      "2005-08-01 2005-08-30\n",
      "['Vauxhall']\n",
      "2005-08-01 2005-08-30\n",
      "['Chevrolet']\n",
      "2005-08-01 2005-08-30\n",
      "['Volks']\n",
      "2005-08-01 2005-08-30\n",
      "['Motor']\n",
      "2005-08-01 2005-08-30\n",
      "['Car']\n",
      "2005-08-01 2005-08-30\n",
      "['Ferrari']\n",
      "2005-08-01 2005-08-30\n",
      "['Mustang']\n",
      "2005-08-01 2005-08-30\n",
      "['Nissan']\n",
      "09\n",
      "2005-09-01 2005-09-30\n",
      "['Audi']\n",
      "2005-09-01 2005-09-30\n",
      "['BMW']\n",
      "2005-09-01 2005-09-30\n",
      "['Mercedes']\n",
      "2005-09-01 2005-09-30\n",
      "['Ford']\n",
      "2005-09-01 2005-09-30\n",
      "['Fiat']\n",
      "2005-09-01 2005-09-30\n",
      "['Vauxhall']\n",
      "2005-09-01 2005-09-30\n",
      "['Chevrolet']\n",
      "2005-09-01 2005-09-30\n",
      "['Volks']\n",
      "2005-09-01 2005-09-30\n",
      "['Motor']\n",
      "2005-09-01 2005-09-30\n",
      "['Car']\n",
      "2005-09-01 2005-09-30\n",
      "['Ferrari']\n",
      "2005-09-01 2005-09-30\n",
      "['Mustang']\n",
      "2005-09-01 2005-09-30\n",
      "['Nissan']\n",
      "10\n",
      "Sleep_outubro\n",
      "2005-10-01 2005-10-30\n",
      "['Audi']\n",
      "2005-10-01 2005-10-30\n",
      "['BMW']\n",
      "2005-10-01 2005-10-30\n",
      "['Mercedes']\n",
      "2005-10-01 2005-10-30\n",
      "['Ford']\n",
      "2005-10-01 2005-10-30\n",
      "['Fiat']\n",
      "2005-10-01 2005-10-30\n",
      "['Vauxhall']\n",
      "2005-10-01 2005-10-30\n",
      "['Chevrolet']\n",
      "2005-10-01 2005-10-30\n",
      "['Volks']\n",
      "2005-10-01 2005-10-30\n",
      "['Motor']\n",
      "2005-10-01 2005-10-30\n",
      "['Car']\n",
      "2005-10-01 2005-10-30\n",
      "['Ferrari']\n",
      "2005-10-01 2005-10-30\n",
      "['Mustang']\n",
      "2005-10-01 2005-10-30\n",
      "['Nissan']\n",
      "11\n",
      "2005-11-01 2005-11-30\n",
      "['Audi']\n",
      "2005-11-01 2005-11-30\n",
      "['BMW']\n",
      "2005-11-01 2005-11-30\n",
      "['Mercedes']\n",
      "2005-11-01 2005-11-30\n",
      "['Ford']\n",
      "2005-11-01 2005-11-30\n",
      "['Fiat']\n",
      "2005-11-01 2005-11-30\n",
      "['Vauxhall']\n",
      "2005-11-01 2005-11-30\n",
      "['Chevrolet']\n",
      "2005-11-01 2005-11-30\n",
      "['Volks']\n",
      "2005-11-01 2005-11-30\n",
      "['Motor']\n",
      "2005-11-01 2005-11-30\n",
      "['Car']\n",
      "2005-11-01 2005-11-30\n",
      "['Ferrari']\n",
      "2005-11-01 2005-11-30\n",
      "['Mustang']\n",
      "2005-11-01 2005-11-30\n",
      "['Nissan']\n",
      "12\n",
      "2005-12-01 2005-12-30\n",
      "['Audi']\n",
      "2005-12-01 2005-12-30\n",
      "['BMW']\n",
      "2005-12-01 2005-12-30\n",
      "['Mercedes']\n",
      "2005-12-01 2005-12-30\n",
      "['Ford']\n",
      "2005-12-01 2005-12-30\n",
      "['Fiat']\n",
      "2005-12-01 2005-12-30\n",
      "['Vauxhall']\n",
      "2005-12-01 2005-12-30\n",
      "['Chevrolet']\n",
      "2005-12-01 2005-12-30\n",
      "['Volks']\n",
      "2005-12-01 2005-12-30\n",
      "['Motor']\n",
      "2005-12-01 2005-12-30\n",
      "['Car']\n",
      "2005-12-01 2005-12-30\n",
      "['Ferrari']\n",
      "2005-12-01 2005-12-30\n",
      "['Mustang']\n",
      "2005-12-01 2005-12-30\n",
      "['Nissan']\n",
      "Execution time in sec.: 8346.921707391739\n",
      "Sleep_dezembro\n",
      "2006\n",
      "01\n",
      "2006-01-01 2006-01-30\n",
      "['Audi']\n",
      "2006-01-01 2006-01-30\n",
      "['BMW']\n",
      "2006-01-01 2006-01-30\n",
      "['Mercedes']\n",
      "2006-01-01 2006-01-30\n",
      "['Ford']\n",
      "2006-01-01 2006-01-30\n",
      "['Fiat']\n",
      "2006-01-01 2006-01-30\n",
      "['Vauxhall']\n",
      "2006-01-01 2006-01-30\n",
      "['Chevrolet']\n",
      "2006-01-01 2006-01-30\n",
      "['Volks']\n",
      "2006-01-01 2006-01-30\n",
      "['Motor']\n"
     ]
    },
    {
     "ename": "ReadTimeout",
     "evalue": "HTTPSConnectionPool(host='trends.google.com', port=443): Read timed out. (read timeout=2)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mtimeout\u001b[0m                                   Traceback (most recent call last)",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connectionpool.py\u001b[0m in \u001b[0;36m_make_request\u001b[1;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001b[0m\n\u001b[0;32m    380\u001b[0m         \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 381\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_validate_conn\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mconn\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    382\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mSocketTimeout\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mBaseSSLError\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connectionpool.py\u001b[0m in \u001b[0;36m_validate_conn\u001b[1;34m(self, conn)\u001b[0m\n\u001b[0;32m    975\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mconn\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"sock\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m  \u001b[1;31m# AppEngine might not have  `.sock`\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 976\u001b[1;33m             \u001b[0mconn\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mconnect\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    977\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connection.py\u001b[0m in \u001b[0;36mconnect\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    360\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 361\u001b[1;33m         self.sock = ssl_wrap_socket(\n\u001b[0m\u001b[0;32m    362\u001b[0m             \u001b[0msock\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mconn\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\util\\ssl_.py\u001b[0m in \u001b[0;36mssl_wrap_socket\u001b[1;34m(sock, keyfile, certfile, cert_reqs, ca_certs, server_hostname, ssl_version, ciphers, ssl_context, ca_cert_dir, key_password, ca_cert_data)\u001b[0m\n\u001b[0;32m    376\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mHAS_SNI\u001b[0m \u001b[1;32mand\u001b[0m \u001b[0mserver_hostname\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 377\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mcontext\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mwrap_socket\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0msock\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mserver_hostname\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mserver_hostname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    378\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\ssl.py\u001b[0m in \u001b[0;36mwrap_socket\u001b[1;34m(self, sock, server_side, do_handshake_on_connect, suppress_ragged_eofs, server_hostname, session)\u001b[0m\n\u001b[0;32m    499\u001b[0m         \u001b[1;31m# ctx._wrap_socket()\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 500\u001b[1;33m         return self.sslsocket_class._create(\n\u001b[0m\u001b[0;32m    501\u001b[0m             \u001b[0msock\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0msock\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\ssl.py\u001b[0m in \u001b[0;36m_create\u001b[1;34m(cls, sock, server_side, do_handshake_on_connect, suppress_ragged_eofs, server_hostname, context, session)\u001b[0m\n\u001b[0;32m   1039\u001b[0m                         \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"do_handshake_on_connect should not be specified for non-blocking sockets\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1040\u001b[1;33m                     \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdo_handshake\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1041\u001b[0m             \u001b[1;32mexcept\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mOSError\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\ssl.py\u001b[0m in \u001b[0;36mdo_handshake\u001b[1;34m(self, block)\u001b[0m\n\u001b[0;32m   1308\u001b[0m                 \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msettimeout\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1309\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_sslobj\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdo_handshake\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1310\u001b[0m         \u001b[1;32mfinally\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mtimeout\u001b[0m: _ssl.c:1091: The handshake operation timed out",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mReadTimeoutError\u001b[0m                          Traceback (most recent call last)",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\requests\\adapters.py\u001b[0m in \u001b[0;36msend\u001b[1;34m(self, request, stream, timeout, verify, cert, proxies)\u001b[0m\n\u001b[0;32m    438\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mchunked\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 439\u001b[1;33m                 resp = conn.urlopen(\n\u001b[0m\u001b[0;32m    440\u001b[0m                     \u001b[0mmethod\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connectionpool.py\u001b[0m in \u001b[0;36murlopen\u001b[1;34m(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)\u001b[0m\n\u001b[0;32m    723\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 724\u001b[1;33m             retries = retries.increment(\n\u001b[0m\u001b[0;32m    725\u001b[0m                 \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0merror\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0m_pool\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0m_stacktrace\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0msys\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexc_info\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m2\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\util\\retry.py\u001b[0m in \u001b[0;36mincrement\u001b[1;34m(self, method, url, response, error, _pool, _stacktrace)\u001b[0m\n\u001b[0;32m    402\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mread\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mFalse\u001b[0m \u001b[1;32mor\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_is_method_retryable\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 403\u001b[1;33m                 \u001b[1;32mraise\u001b[0m \u001b[0msix\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreraise\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mtype\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0merror\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0merror\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0m_stacktrace\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    404\u001b[0m             \u001b[1;32melif\u001b[0m \u001b[0mread\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\packages\\six.py\u001b[0m in \u001b[0;36mreraise\u001b[1;34m(tp, value, tb)\u001b[0m\n\u001b[0;32m    734\u001b[0m                 \u001b[1;32mraise\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mwith_traceback\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mtb\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 735\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    736\u001b[0m         \u001b[1;32mfinally\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connectionpool.py\u001b[0m in \u001b[0;36murlopen\u001b[1;34m(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)\u001b[0m\n\u001b[0;32m    669\u001b[0m             \u001b[1;31m# Make the request on the httplib connection object.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 670\u001b[1;33m             httplib_response = self._make_request(\n\u001b[0m\u001b[0;32m    671\u001b[0m                 \u001b[0mconn\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connectionpool.py\u001b[0m in \u001b[0;36m_make_request\u001b[1;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001b[0m\n\u001b[0;32m    383\u001b[0m             \u001b[1;31m# Py2 raises this as a BaseSSLError, Py3 raises it as socket timeout.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 384\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_raise_timeout\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0merr\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtimeout_value\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mconn\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtimeout\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    385\u001b[0m             \u001b[1;32mraise\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\urllib3\\connectionpool.py\u001b[0m in \u001b[0;36m_raise_timeout\u001b[1;34m(self, err, url, timeout_value)\u001b[0m\n\u001b[0;32m    334\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0merr\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mSocketTimeout\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 335\u001b[1;33m             raise ReadTimeoutError(\n\u001b[0m\u001b[0;32m    336\u001b[0m                 \u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m\"Read timed out. (read timeout=%s)\"\u001b[0m \u001b[1;33m%\u001b[0m \u001b[0mtimeout_value\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mReadTimeoutError\u001b[0m: HTTPSConnectionPool(host='trends.google.com', port=443): Read timed out. (read timeout=2)",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mReadTimeout\u001b[0m                               Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-1-835fbbc4df5c>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m     44\u001b[0m              \u001b[0mtimeframes\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'{}-{}-01 {}-{}-{}'\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mano\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mmes\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mano\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mmes\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mdia_final\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     45\u001b[0m              \u001b[0mkeywords\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0mdf2\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 46\u001b[1;33m              pytrend.build_payload(\n\u001b[0m\u001b[0;32m     47\u001b[0m              \u001b[0mkw_list\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mkeywords\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     48\u001b[0m              \u001b[0mcat\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\pytrends\\request.py\u001b[0m in \u001b[0;36mbuild_payload\u001b[1;34m(self, kw_list, cat, timeframe, geo, gprop)\u001b[0m\n\u001b[0;32m    167\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtoken_payload\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'req'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mjson\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdumps\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtoken_payload\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'req'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    168\u001b[0m         \u001b[1;31m# get tokens\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 169\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_tokens\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    170\u001b[0m         \u001b[1;32mreturn\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    171\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\pytrends\\request.py\u001b[0m in \u001b[0;36m_tokens\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    173\u001b[0m         \u001b[1;34m\"\"\"Makes request to Google to get API tokens for interest over time, interest by region and related queries\"\"\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    174\u001b[0m         \u001b[1;31m# make the request and parse the returned json\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 175\u001b[1;33m         widget_dict = self._get_data(\n\u001b[0m\u001b[0;32m    176\u001b[0m             \u001b[0murl\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mTrendReq\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mGENERAL_URL\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    177\u001b[0m             \u001b[0mmethod\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mTrendReq\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mGET_METHOD\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\pytrends\\request.py\u001b[0m in \u001b[0;36m_get_data\u001b[1;34m(self, url, method, trim_chars, **kwargs)\u001b[0m\n\u001b[0;32m    124\u001b[0m                               cookies=self.cookies, **kwargs, **self.requests_args)  # DO NOT USE retries or backoff_factor here\n\u001b[0;32m    125\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 126\u001b[1;33m             response = s.get(url, timeout=self.timeout, cookies=self.cookies,\n\u001b[0m\u001b[0;32m    127\u001b[0m                              **kwargs, **self.requests_args)   # DO NOT USE retries or backoff_factor here\n\u001b[0;32m    128\u001b[0m         \u001b[1;31m# check if the response contains json and throw an exception otherwise\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\requests\\sessions.py\u001b[0m in \u001b[0;36mget\u001b[1;34m(self, url, **kwargs)\u001b[0m\n\u001b[0;32m    541\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    542\u001b[0m         \u001b[0mkwargs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msetdefault\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'allow_redirects'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 543\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'GET'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    544\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    545\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0moptions\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\requests\\sessions.py\u001b[0m in \u001b[0;36mrequest\u001b[1;34m(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)\u001b[0m\n\u001b[0;32m    528\u001b[0m         }\n\u001b[0;32m    529\u001b[0m         \u001b[0msend_kwargs\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0msettings\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 530\u001b[1;33m         \u001b[0mresp\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mprep\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0msend_kwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    531\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    532\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mresp\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\requests\\sessions.py\u001b[0m in \u001b[0;36msend\u001b[1;34m(self, request, **kwargs)\u001b[0m\n\u001b[0;32m    641\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    642\u001b[0m         \u001b[1;31m# Send the request\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 643\u001b[1;33m         \u001b[0mr\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0madapter\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    644\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    645\u001b[0m         \u001b[1;31m# Total elapsed time of the request (approximately)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\Anaconda3\\lib\\site-packages\\requests\\adapters.py\u001b[0m in \u001b[0;36msend\u001b[1;34m(self, request, stream, timeout, verify, cert, proxies)\u001b[0m\n\u001b[0;32m    527\u001b[0m                 \u001b[1;32mraise\u001b[0m \u001b[0mSSLError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mrequest\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    528\u001b[0m             \u001b[1;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mReadTimeoutError\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 529\u001b[1;33m                 \u001b[1;32mraise\u001b[0m \u001b[0mReadTimeout\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mrequest\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    530\u001b[0m             \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    531\u001b[0m                 \u001b[1;32mraise\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mReadTimeout\u001b[0m: HTTPSConnectionPool(host='trends.google.com', port=443): Read timed out. (read timeout=2)"
     ]
    }
   ],
   "source": [
    "from pytrends.request import TrendReq\n",
    "import pandas as pd\n",
    "import time\n",
    "startTime = time.time()\n",
    "pytrend = TrendReq(hl='en-GB', tz=360)\n",
    "\n",
    "colnames = [\"keywords\"]\n",
    "df = pd.read_csv(\"C:\\\\Users\\\\paulo.almeida\\\\Documents\\\\CSV\\\\keyword_list.csv\", names=colnames)\n",
    "df2 = df[\"keywords\"].values.tolist()\n",
    "df2.remove(\"Keywords\")\n",
    "\n",
    "#dataset = []\n",
    "print('Carregando...aguarde')\n",
    "dataset =[]\n",
    "anos = [2005,2006,2007,2008]#,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]\n",
    "meses = ['01','02','03','04','05','06','07','08','09','10','11','12']\n",
    "\n",
    "\n",
    "pytrends = TrendReq(hl='en-US', tz=360, timeout=(10,25), retries=2, backoff_factor=0.1)#proxies=['https://34.203.233.13:80',]\n",
    "for ano in anos:\n",
    "    \n",
    "   \n",
    "    \n",
    "    print(ano)\n",
    "    for mes in meses:\n",
    "        print(mes)\n",
    "        if mes == '02':\n",
    "            dia_final=28\n",
    "        else: dia_final = 30\n",
    "        \n",
    "        if mes == '03':\n",
    "            print('Sleep_março')\n",
    "            time.sleep(1200)\n",
    "        elif mes == '06':\n",
    "            print('Sleep_junho')\n",
    "            time.sleep(1200)\n",
    "        elif mes == '10':\n",
    "            print('Sleep_outubro')\n",
    "            time.sleep(1200)\n",
    "        else: pass\n",
    "        for x in range(0,len(df2)):\n",
    "             \n",
    "             \n",
    "             timeframes='{}-{}-01 {}-{}-{}'.format(ano,mes,ano,mes,dia_final)\n",
    "             keywords = [df2[x]]\n",
    "             pytrend.build_payload(\n",
    "             kw_list=keywords,\n",
    "             cat=0,\n",
    "             timeframe=timeframes,\n",
    "             geo='GB')\n",
    "             print(timeframes)\n",
    "             time.sleep(3)\n",
    "             executionTime = (time.time() - startTime)\n",
    "             #print('Execution time in sec.: ' + str(executionTime))\n",
    "             data = pytrend.interest_over_time()\n",
    "\n",
    "             if not data.empty:\n",
    "                  data = data.drop(labels=['isPartial'],axis='columns')\n",
    "                  dataset.append(data) \n",
    "     \n",
    "             print(keywords)\n",
    "             \n",
    "             \n",
    "        time.sleep(15)\n",
    "        \n",
    "          \n",
    "    result = pd.concat(dataset, axis=1)\n",
    "    result.to_csv(\"C:\\\\Users\\\\paulo.almeida\\\\Documents\\\\CSV\\\\Resultado_GTrends{}.csv\".format(ano))\n",
    "    executionTime = (time.time() - startTime)\n",
    "    print('Execution time in sec.: ' + str(executionTime))\n",
    "    print('Sleep_dezembro')\n",
    "    time.sleep(2000)\n",
    "\n",
    "result = pd.concat(dataset, axis=1)\n",
    "executionTime = (time.time() - startTime)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[            Audi\n",
       " date            \n",
       " 2005-01-01   100\n",
       " 2005-01-02    55\n",
       " 2005-01-03    51\n",
       " 2005-01-04    57\n",
       " 2005-01-05    67\n",
       " 2005-01-06    58\n",
       " 2005-01-07    51\n",
       " 2005-01-08    65\n",
       " 2005-01-09    45\n",
       " 2005-01-10    52\n",
       " 2005-01-11    46\n",
       " 2005-01-12    54\n",
       " 2005-01-13    33\n",
       " 2005-01-14    73\n",
       " 2005-01-15    75\n",
       " 2005-01-16    48\n",
       " 2005-01-17    56\n",
       " 2005-01-18    57\n",
       " 2005-01-19    66\n",
       " 2005-01-20    75\n",
       " 2005-01-21    65\n",
       " 2005-01-22    59\n",
       " 2005-01-23    47\n",
       " 2005-01-24    60\n",
       " 2005-01-25    48\n",
       " 2005-01-26    50\n",
       " 2005-01-27    63\n",
       " 2005-01-28    64\n",
       " 2005-01-29    68\n",
       " 2005-01-30    78,\n",
       "             BMW\n",
       " date           \n",
       " 2005-01-01  100\n",
       " 2005-01-02   60\n",
       " 2005-01-03   69\n",
       " 2005-01-04   71\n",
       " 2005-01-05   87\n",
       " 2005-01-06   90\n",
       " 2005-01-07   88\n",
       " 2005-01-08   91\n",
       " 2005-01-09   77\n",
       " 2005-01-10   78\n",
       " 2005-01-11   77\n",
       " 2005-01-12   73\n",
       " 2005-01-13   77\n",
       " 2005-01-14   72\n",
       " 2005-01-15   80\n",
       " 2005-01-16   57\n",
       " 2005-01-17   61\n",
       " 2005-01-18   73\n",
       " 2005-01-19   62\n",
       " 2005-01-20   79\n",
       " 2005-01-21   77\n",
       " 2005-01-22   70\n",
       " 2005-01-23   80\n",
       " 2005-01-24   72\n",
       " 2005-01-25   78\n",
       " 2005-01-26   72\n",
       " 2005-01-27   72\n",
       " 2005-01-28   65\n",
       " 2005-01-29   72\n",
       " 2005-01-30   94,\n",
       "             Mercedes\n",
       " date                \n",
       " 2005-01-01        75\n",
       " 2005-01-02       100\n",
       " 2005-01-03        65\n",
       " 2005-01-04        59\n",
       " 2005-01-05        66\n",
       " 2005-01-06        78\n",
       " 2005-01-07        70\n",
       " 2005-01-08        67\n",
       " 2005-01-09        55\n",
       " 2005-01-10        70\n",
       " 2005-01-11        54\n",
       " 2005-01-12        60\n",
       " 2005-01-13        86\n",
       " 2005-01-14        69\n",
       " 2005-01-15        92\n",
       " 2005-01-16        82\n",
       " 2005-01-17        79\n",
       " 2005-01-18        94\n",
       " 2005-01-19        74\n",
       " 2005-01-20        77\n",
       " 2005-01-21        95\n",
       " 2005-01-22        86\n",
       " 2005-01-23        72\n",
       " 2005-01-24        61\n",
       " 2005-01-25        67\n",
       " 2005-01-26        79\n",
       " 2005-01-27        67\n",
       " 2005-01-28        84\n",
       " 2005-01-29        50\n",
       " 2005-01-30        67]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "result.to_csv('C:\\\\Users\\\\paulo.almeida\\\\Documents\\\\CSV\\\\search_trends.csv')\n",
    "\n",
    "executionTime = (time.time() - startTime)\n",
    "\n",
    "print('Execution time in sec.: ' + str(executionTime))\n",
    "        \n",
    "   \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "             data = pytrend.interest_over_time()\n",
    "\n",
    "             if not data.empty:\n",
    "                  data = data.drop(labels=['isPartial'],axis='columns')\n",
    "                  dataset.append(data)\n",
    "     \n",
    "             print(keywords)\n",
    "\n",
    "result = pd.concat(dataset, axis=1)\n",
    "result.to_csv('C:\\\\Users\\\\paulo.almeida\\\\Documents\\\\CSV\\\\search_trends.csv')\n",
    "\n",
    "executionTime = (time.time() - startTime)\n",
    "\n",
    "print('Execution time in sec.: ' + str(executionTime))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}