API.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# CONDICIONES ATMOSFÉRIAS DE MÉXICO"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### INSTALAMOS LAS LIBRERÍAS NECESARIAS PARA CONSUMIR UN API EXTERNA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "The downloaded binary packages are in\n",
      "\t/var/folders/mj/2p9h15dj49nf04_fy5ybz_vr0000gn/T//RtmprjGzoM/downloaded_packages\n"
     ]
    }
   ],
   "source": [
    "install.packages(c(\"httr\", \"jsonlite\"))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "library(httr)\n",
    "library(jsonlite)\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### CONSUMIMOS EL API DE DATOS.GOB.MX QUE CONTIENE TODAS LAS CONDICIONES ATMOSFÉRICAS DE MÉXICO POR ESTADO Y CIUDAD. CONTIENE MÁS DE 13 MILLONES DE REGISTROS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "res <- GET(\"https://api.datos.gob.mx/v1/condiciones-atmosfericas\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "dat <- fromJSON(rawToChar(res$content))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for (i in 1:as.integer(dat$pagination$pageSize)) {\n",
    "    id <- paste(\"ID:\", i)\n",
    "    cat(\"\\n\")\n",
    "    print(id)\n",
    "    print(dat[[\"results\"]][[\"date-insert\"]][i])\n",
    "    print(dat[[\"results\"]][[\"state\"]][i])\n",
    "    print(dat[[\"results\"]][[\"name\"]][i])\n",
    "    print(dat[[\"results\"]][[\"latitude\"]][i])\n",
    "    print(dat[[\"results\"]][[\"longitude\"]][i])\n",
    "    print(dat[[\"results\"]][[\"skydescriptionlong\"]][i])\n",
    "    print(dat[[\"results\"]][[\"windspeedkm\"]][i])\n",
    "}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "getData <- function (page, state){\n",
    "    URL <- sprintf(\"https://api.datos.gob.mx/v1/condiciones-atmosfericas?page=%s&stateabbr=%s\",page,state)\n",
    "    res <- GET(URL)\n",
    "    dat <- fromJSON(rawToChar(res$content))\n",
    "    for (i in 1:10) {\n",
    "    id <- paste(\"ID:\", i)\n",
    "    cat(\"\\n\")\n",
    "    print(id)\n",
    "    print(dat[[\"results\"]][[\"date-insert\"]][i])\n",
    "    print(dat[[\"results\"]][[\"state\"]][i])\n",
    "    print(dat[[\"results\"]][[\"stateabbr\"]][i])\n",
    "    print(dat[[\"results\"]][[\"name\"]][i])\n",
    "    print(dat[[\"results\"]][[\"latitude\"]][i])\n",
    "    print(dat[[\"results\"]][[\"longitude\"]][i])\n",
    "    print(dat[[\"results\"]][[\"skydescriptionlong\"]][i])\n",
    "    print(dat[[\"results\"]][[\"windspeedkm\"]][i])\n",
    "    }\n",
    "    return(dat)\n",
    "}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "[1] \"ID: 1\"\n",
      "[1] \"2017-06-27T17:36:43.084Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"21.87982\"\n",
      "[1] \"-102.296\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"6\"\n",
      "\n",
      "[1] \"ID: 2\"\n",
      "[1] \"2017-06-27T17:36:43.088Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Asientos\"\n",
      "[1] \"22.23832\"\n",
      "[1] \"-102.0893\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"5\"\n",
      "\n",
      "[1] \"ID: 3\"\n",
      "[1] \"2017-06-27T17:36:43.088Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Calvillo\"\n",
      "[1] \"21.84691\"\n",
      "[1] \"-102.7188\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"2\"\n",
      "\n",
      "[1] \"ID: 4\"\n",
      "[1] \"2017-06-27T17:36:43.088Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Cosío\"\n",
      "[1] \"22.36641\"\n",
      "[1] \"-102.3\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"3\"\n",
      "\n",
      "[1] \"ID: 5\"\n",
      "[1] \"2017-06-27T17:36:43.089Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"El Llano\"\n",
      "[1] \"21.91887\"\n",
      "[1] \"-101.9653\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"3\"\n",
      "\n",
      "[1] \"ID: 6\"\n",
      "[1] \"2017-06-27T17:36:43.089Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Jesús María\"\n",
      "[1] \"21.96127\"\n",
      "[1] \"-102.3434\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"8\"\n",
      "\n",
      "[1] \"ID: 7\"\n",
      "[1] \"2017-06-27T17:36:43.089Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Pabellón de Arteaga\"\n",
      "[1] \"22.1492\"\n",
      "[1] \"-102.2765\"\n",
      "[1] \"Tormentas\"\n",
      "[1] \"6\"\n",
      "\n",
      "[1] \"ID: 8\"\n",
      "[1] \"2017-06-27T17:36:43.089Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"Rincón de Romos\"\n",
      "[1] \"22.22923\"\n",
      "[1] \"-102.3231\"\n",
      "[1] \"Tormentas dispersas\"\n",
      "[1] \"3\"\n",
      "\n",
      "[1] \"ID: 9\"\n",
      "[1] \"2017-06-27T17:36:43.090Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"San Francisco de los Romo\"\n",
      "[1] \"22.07239\"\n",
      "[1] \"-102.2727\"\n",
      "[1] \"Tormentas\"\n",
      "[1] \"8\"\n",
      "\n",
      "[1] \"ID: 10\"\n",
      "[1] \"2017-06-27T17:36:43.091Z\"\n",
      "[1] \"Aguascalientes\"\n",
      "[1] \"AGU\"\n",
      "[1] \"San José de Gracia\"\n",
      "[1] \"22.15022\"\n",
      "[1] \"-102.4156\"\n",
      "[1] \"Tormentas\"\n",
      "[1] \"3\"\n"
     ]
    }
   ],
   "source": [
    "first <- getData(1,\"AGU\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "List of 2\n",
      " $ pagination:List of 3\n",
      "  ..$ pageSize: int 100\n",
      "  ..$ page    : int 1\n",
      "  ..$ total   : int 58652\n",
      " $ results   :'data.frame':\t100 obs. of  17 variables:\n",
      "  ..$ _id                  : chr [1:100] \"5952983359954a0adbf7ab09\" \"5952983359954a0adbf7ab0a\" \"5952983359954a0adbf7ab0b\" \"5952983359954a0adbf7ab0c\" ...\n",
      "  ..$ cityid               : chr [1:100] \"MXAS0002\" \"MXAS0170\" \"MXAS0171\" \"MXAS0172\" ...\n",
      "  ..$ validdateutc         : chr [1:100] \"20170627T140000Z\" \"20170627T140000Z\" \"20170627T140000Z\" \"20170627T140000Z\" ...\n",
      "  ..$ winddirectioncardinal: chr [1:100] \"SSE\" \"S\" \"E\" \"S\" ...\n",
      "  ..$ probabilityofprecip  : chr [1:100] \"40\" \"60\" \"60\" \"50\" ...\n",
      "  ..$ relativehumidity     : chr [1:100] \"90\" \"91\" \"84\" \"83\" ...\n",
      "  ..$ name                 : chr [1:100] \"Aguascalientes\" \"Asientos\" \"Calvillo\" \"Cosío\" ...\n",
      "  ..$ date-insert          : chr [1:100] \"2017-06-27T17:36:43.084Z\" \"2017-06-27T17:36:43.088Z\" \"2017-06-27T17:36:43.088Z\" \"2017-06-27T17:36:43.088Z\" ...\n",
      "  ..$ longitude            : chr [1:100] \"-102.296\" \"-102.0893\" \"-102.7188\" \"-102.3\" ...\n",
      "  ..$ state                : chr [1:100] \"Aguascalientes\" \"Aguascalientes\" \"Aguascalientes\" \"Aguascalientes\" ...\n",
      "  ..$ lastreporttime       : chr [1:100] \"20170627T092449Z\" \"20170627T092453Z\" \"20170627T092453Z\" \"20170627T092453Z\" ...\n",
      "  ..$ skydescriptionlong   : chr [1:100] \"Tormentas dispersas\" \"Tormentas dispersas\" \"Tormentas dispersas\" \"Tormentas dispersas\" ...\n",
      "  ..$ stateabbr            : chr [1:100] \"AGU\" \"AGU\" \"AGU\" \"AGU\" ...\n",
      "  ..$ tempc                : chr [1:100] \"17\" \"15\" \"19\" \"17\" ...\n",
      "  ..$ latitude             : chr [1:100] \"21.87982\" \"22.23832\" \"21.84691\" \"22.36641\" ...\n",
      "  ..$ iconcode             : chr [1:100] \"96\" \"96\" \"96\" \"96\" ...\n",
      "  ..$ windspeedkm          : chr [1:100] \"6\" \"5\" \"2\" \"3\" ...\n"
     ]
    }
   ],
   "source": [
    "str(first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df <- as.data.frame(first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<caption>A data.frame: 6 × 20</caption>\n",
       "<thead>\n",
       "\t<tr><th></th><th scope=col>pagination.pageSize</th><th scope=col>pagination.page</th><th scope=col>pagination.total</th><th scope=col>results._id</th><th scope=col>results.cityid</th><th scope=col>results.validdateutc</th><th scope=col>results.winddirectioncardinal</th><th scope=col>results.probabilityofprecip</th><th scope=col>results.relativehumidity</th><th scope=col>results.name</th><th scope=col>results.date.insert</th><th scope=col>results.longitude</th><th scope=col>results.state</th><th scope=col>results.lastreporttime</th><th scope=col>results.skydescriptionlong</th><th scope=col>results.stateabbr</th><th scope=col>results.tempc</th><th scope=col>results.latitude</th><th scope=col>results.iconcode</th><th scope=col>results.windspeedkm</th></tr>\n",
       "\t<tr><th></th><th scope=col>&lt;int&gt;</th><th scope=col>&lt;int&gt;</th><th scope=col>&lt;int&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th><th scope=col>&lt;chr&gt;</th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "\t<tr><th scope=row>1</th><td>100</td><td>1</td><td>58652</td><td>5952983359954a0adbf7ab09</td><td>MXAS0002</td><td>20170627T140000Z</td><td>SSE</td><td>40</td><td>90</td><td>Aguascalientes</td><td>2017-06-27T17:36:43.084Z</td><td>-102.296 </td><td>Aguascalientes</td><td>20170627T092449Z</td><td>Tormentas dispersas</td><td>AGU</td><td>17</td><td>21.87982</td><td>96</td><td>6</td></tr>\n",
       "\t<tr><th scope=row>2</th><td>100</td><td>1</td><td>58652</td><td>5952983359954a0adbf7ab0a</td><td>MXAS0170</td><td>20170627T140000Z</td><td>S  </td><td>60</td><td>91</td><td>Asientos      </td><td>2017-06-27T17:36:43.088Z</td><td>-102.0893</td><td>Aguascalientes</td><td>20170627T092453Z</td><td>Tormentas dispersas</td><td>AGU</td><td>15</td><td>22.23832</td><td>96</td><td>5</td></tr>\n",
       "\t<tr><th scope=row>3</th><td>100</td><td>1</td><td>58652</td><td>5952983359954a0adbf7ab0b</td><td>MXAS0171</td><td>20170627T140000Z</td><td>E  </td><td>60</td><td>84</td><td>Calvillo      </td><td>2017-06-27T17:36:43.088Z</td><td>-102.7188</td><td>Aguascalientes</td><td>20170627T092453Z</td><td>Tormentas dispersas</td><td>AGU</td><td>19</td><td>21.84691</td><td>96</td><td>2</td></tr>\n",
       "\t<tr><th scope=row>4</th><td>100</td><td>1</td><td>58652</td><td>5952983359954a0adbf7ab0c</td><td>MXAS0172</td><td>20170627T140000Z</td><td>S  </td><td>50</td><td>83</td><td>Cosío         </td><td>2017-06-27T17:36:43.088Z</td><td>-102.3   </td><td>Aguascalientes</td><td>20170627T092453Z</td><td>Tormentas dispersas</td><td>AGU</td><td>17</td><td>22.36641</td><td>96</td><td>3</td></tr>\n",
       "\t<tr><th scope=row>5</th><td>100</td><td>1</td><td>58652</td><td>5952983359954a0adbf7ab0d</td><td>MXAS0173</td><td>20170627T140000Z</td><td>SSO</td><td>50</td><td>84</td><td>El Llano      </td><td>2017-06-27T17:36:43.089Z</td><td>-101.9653</td><td>Aguascalientes</td><td>20170627T092453Z</td><td>Tormentas dispersas</td><td>AGU</td><td>17</td><td>21.91887</td><td>96</td><td>3</td></tr>\n",
       "\t<tr><th scope=row>6</th><td>100</td><td>1</td><td>58652</td><td>5952983359954a0adbf7ab0e</td><td>MXAS0174</td><td>20170627T140000Z</td><td>ESE</td><td>60</td><td>90</td><td>Jesús María   </td><td>2017-06-27T17:36:43.089Z</td><td>-102.3434</td><td>Aguascalientes</td><td>20170627T092453Z</td><td>Tormentas dispersas</td><td>AGU</td><td>17</td><td>21.96127</td><td>96</td><td>8</td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "A data.frame: 6 × 20\n",
       "\\begin{tabular}{r|llllllllllllllllllll}\n",
       "  & pagination.pageSize & pagination.page & pagination.total & results.\\_id & results.cityid & results.validdateutc & results.winddirectioncardinal & results.probabilityofprecip & results.relativehumidity & results.name & results.date.insert & results.longitude & results.state & results.lastreporttime & results.skydescriptionlong & results.stateabbr & results.tempc & results.latitude & results.iconcode & results.windspeedkm\\\\\n",
       "  & <int> & <int> & <int> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr> & <chr>\\\\\n",
       "\\hline\n",
       "\t1 & 100 & 1 & 58652 & 5952983359954a0adbf7ab09 & MXAS0002 & 20170627T140000Z & SSE & 40 & 90 & Aguascalientes & 2017-06-27T17:36:43.084Z & -102.296  & Aguascalientes & 20170627T092449Z & Tormentas dispersas & AGU & 17 & 21.87982 & 96 & 6\\\\\n",
       "\t2 & 100 & 1 & 58652 & 5952983359954a0adbf7ab0a & MXAS0170 & 20170627T140000Z & S   & 60 & 91 & Asientos       & 2017-06-27T17:36:43.088Z & -102.0893 & Aguascalientes & 20170627T092453Z & Tormentas dispersas & AGU & 15 & 22.23832 & 96 & 5\\\\\n",
       "\t3 & 100 & 1 & 58652 & 5952983359954a0adbf7ab0b & MXAS0171 & 20170627T140000Z & E   & 60 & 84 & Calvillo       & 2017-06-27T17:36:43.088Z & -102.7188 & Aguascalientes & 20170627T092453Z & Tormentas dispersas & AGU & 19 & 21.84691 & 96 & 2\\\\\n",
       "\t4 & 100 & 1 & 58652 & 5952983359954a0adbf7ab0c & MXAS0172 & 20170627T140000Z & S   & 50 & 83 & Cosío          & 2017-06-27T17:36:43.088Z & -102.3    & Aguascalientes & 20170627T092453Z & Tormentas dispersas & AGU & 17 & 22.36641 & 96 & 3\\\\\n",
       "\t5 & 100 & 1 & 58652 & 5952983359954a0adbf7ab0d & MXAS0173 & 20170627T140000Z & SSO & 50 & 84 & El Llano       & 2017-06-27T17:36:43.089Z & -101.9653 & Aguascalientes & 20170627T092453Z & Tormentas dispersas & AGU & 17 & 21.91887 & 96 & 3\\\\\n",
       "\t6 & 100 & 1 & 58652 & 5952983359954a0adbf7ab0e & MXAS0174 & 20170627T140000Z & ESE & 60 & 90 & Jesús María    & 2017-06-27T17:36:43.089Z & -102.3434 & Aguascalientes & 20170627T092453Z & Tormentas dispersas & AGU & 17 & 21.96127 & 96 & 8\\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "A data.frame: 6 × 20\n",
       "\n",
       "| <!--/--> | pagination.pageSize &lt;int&gt; | pagination.page &lt;int&gt; | pagination.total &lt;int&gt; | results._id &lt;chr&gt; | results.cityid &lt;chr&gt; | results.validdateutc &lt;chr&gt; | results.winddirectioncardinal &lt;chr&gt; | results.probabilityofprecip &lt;chr&gt; | results.relativehumidity &lt;chr&gt; | results.name &lt;chr&gt; | results.date.insert &lt;chr&gt; | results.longitude &lt;chr&gt; | results.state &lt;chr&gt; | results.lastreporttime &lt;chr&gt; | results.skydescriptionlong &lt;chr&gt; | results.stateabbr &lt;chr&gt; | results.tempc &lt;chr&gt; | results.latitude &lt;chr&gt; | results.iconcode &lt;chr&gt; | results.windspeedkm &lt;chr&gt; |\n",
       "|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|\n",
       "| 1 | 100 | 1 | 58652 | 5952983359954a0adbf7ab09 | MXAS0002 | 20170627T140000Z | SSE | 40 | 90 | Aguascalientes | 2017-06-27T17:36:43.084Z | -102.296  | Aguascalientes | 20170627T092449Z | Tormentas dispersas | AGU | 17 | 21.87982 | 96 | 6 |\n",
       "| 2 | 100 | 1 | 58652 | 5952983359954a0adbf7ab0a | MXAS0170 | 20170627T140000Z | S   | 60 | 91 | Asientos       | 2017-06-27T17:36:43.088Z | -102.0893 | Aguascalientes | 20170627T092453Z | Tormentas dispersas | AGU | 15 | 22.23832 | 96 | 5 |\n",
       "| 3 | 100 | 1 | 58652 | 5952983359954a0adbf7ab0b | MXAS0171 | 20170627T140000Z | E   | 60 | 84 | Calvillo       | 2017-06-27T17:36:43.088Z | -102.7188 | Aguascalientes | 20170627T092453Z | Tormentas dispersas | AGU | 19 | 21.84691 | 96 | 2 |\n",
       "| 4 | 100 | 1 | 58652 | 5952983359954a0adbf7ab0c | MXAS0172 | 20170627T140000Z | S   | 50 | 83 | Cosío          | 2017-06-27T17:36:43.088Z | -102.3    | Aguascalientes | 20170627T092453Z | Tormentas dispersas | AGU | 17 | 22.36641 | 96 | 3 |\n",
       "| 5 | 100 | 1 | 58652 | 5952983359954a0adbf7ab0d | MXAS0173 | 20170627T140000Z | SSO | 50 | 84 | El Llano       | 2017-06-27T17:36:43.089Z | -101.9653 | Aguascalientes | 20170627T092453Z | Tormentas dispersas | AGU | 17 | 21.91887 | 96 | 3 |\n",
       "| 6 | 100 | 1 | 58652 | 5952983359954a0adbf7ab0e | MXAS0174 | 20170627T140000Z | ESE | 60 | 90 | Jesús María    | 2017-06-27T17:36:43.089Z | -102.3434 | Aguascalientes | 20170627T092453Z | Tormentas dispersas | AGU | 17 | 21.96127 | 96 | 8 |\n",
       "\n"
      ],
      "text/plain": [
       "  pagination.pageSize pagination.page pagination.total results._id             \n",
       "1 100                 1               58652            5952983359954a0adbf7ab09\n",
       "2 100                 1               58652            5952983359954a0adbf7ab0a\n",
       "3 100                 1               58652            5952983359954a0adbf7ab0b\n",
       "4 100                 1               58652            5952983359954a0adbf7ab0c\n",
       "5 100                 1               58652            5952983359954a0adbf7ab0d\n",
       "6 100                 1               58652            5952983359954a0adbf7ab0e\n",
       "  results.cityid results.validdateutc results.winddirectioncardinal\n",
       "1 MXAS0002       20170627T140000Z     SSE                          \n",
       "2 MXAS0170       20170627T140000Z     S                            \n",
       "3 MXAS0171       20170627T140000Z     E                            \n",
       "4 MXAS0172       20170627T140000Z     S                            \n",
       "5 MXAS0173       20170627T140000Z     SSO                          \n",
       "6 MXAS0174       20170627T140000Z     ESE                          \n",
       "  results.probabilityofprecip results.relativehumidity results.name  \n",
       "1 40                          90                       Aguascalientes\n",
       "2 60                          91                       Asientos      \n",
       "3 60                          84                       Calvillo      \n",
       "4 50                          83                       Cosío         \n",
       "5 50                          84                       El Llano      \n",
       "6 60                          90                       Jesús María   \n",
       "  results.date.insert      results.longitude results.state \n",
       "1 2017-06-27T17:36:43.084Z -102.296          Aguascalientes\n",
       "2 2017-06-27T17:36:43.088Z -102.0893         Aguascalientes\n",
       "3 2017-06-27T17:36:43.088Z -102.7188         Aguascalientes\n",
       "4 2017-06-27T17:36:43.088Z -102.3            Aguascalientes\n",
       "5 2017-06-27T17:36:43.089Z -101.9653         Aguascalientes\n",
       "6 2017-06-27T17:36:43.089Z -102.3434         Aguascalientes\n",
       "  results.lastreporttime results.skydescriptionlong results.stateabbr\n",
       "1 20170627T092449Z       Tormentas dispersas        AGU              \n",
       "2 20170627T092453Z       Tormentas dispersas        AGU              \n",
       "3 20170627T092453Z       Tormentas dispersas        AGU              \n",
       "4 20170627T092453Z       Tormentas dispersas        AGU              \n",
       "5 20170627T092453Z       Tormentas dispersas        AGU              \n",
       "6 20170627T092453Z       Tormentas dispersas        AGU              \n",
       "  results.tempc results.latitude results.iconcode results.windspeedkm\n",
       "1 17            21.87982         96               6                  \n",
       "2 15            22.23832         96               5                  \n",
       "3 19            21.84691         96               2                  \n",
       "4 17            22.36641         96               3                  \n",
       "5 17            21.91887         96               3                  \n",
       "6 17            21.96127         96               8                  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "head(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " chr [1:100] \"17\" \"15\" \"19\" \"17\" \"17\" \"17\" \"17\" \"17\" \"17\" \"16\" \"16\" \"17\" ...\n"
     ]
    }
   ],
   "source": [
    "str(df$results.tempc)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_array <- c(as.integer(df$results.tempc))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "16.82"
      ],
      "text/latex": [
       "16.82"
      ],
      "text/markdown": [
       "16.82"
      ],
      "text/plain": [
       "[1] 16.82"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "mean(temp_array)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "R",
   "language": "R",
   "name": "ir"
  },
  "language_info": {
   "codemirror_mode": "r",
   "file_extension": ".r",
   "mimetype": "text/x-r-source",
   "name": "R",
   "pygments_lexer": "r",
   "version": "4.0.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}