excel-grab-mars-insight-data-demokey.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "68d402a9-af05-415a-96c6-a05a6e6356ae",
   "metadata": {
    "slideshow": {
     "slide_type": "fragment"
    },
    "tags": [
     "insight-api"
    ]
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Response Status:\n",
      "200\n",
      "Response Content:\n",
      "{\n",
      "  \"sol_keys\": [],\n",
      "  \"validity_checks\": {\n",
      "    \"880\": {\n",
      "      \"AT\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21,\n",
      "          22\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"HWS\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21,\n",
      "          22\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"PRE\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          3,\n",
      "          4,\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21,\n",
      "          22\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"WD\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21,\n",
      "          22\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      }\n",
      "    },\n",
      "    \"882\": {\n",
      "      \"AT\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"HWS\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"PRE\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          1,\n",
      "          2,\n",
      "          3,\n",
      "          4,\n",
      "          5,\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"WD\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          13,\n",
      "          14,\n",
      "          15,\n",
      "          16,\n",
      "          17,\n",
      "          18,\n",
      "          19,\n",
      "          20,\n",
      "          21\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      }\n",
      "    },\n",
      "    \"884\": {\n",
      "      \"AT\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          11,\n",
      "          12,\n",
      "          13,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"HWS\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          11,\n",
      "          12,\n",
      "          13,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"PRE\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          11,\n",
      "          12,\n",
      "          13,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"WD\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          11,\n",
      "          12,\n",
      "          13,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      }\n",
      "    },\n",
      "    \"885\": {\n",
      "      \"AT\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1,\n",
      "          2,\n",
      "          3\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"HWS\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1,\n",
      "          2,\n",
      "          3\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"PRE\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1,\n",
      "          2,\n",
      "          3\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"WD\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1,\n",
      "          2,\n",
      "          3\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      }\n",
      "    },\n",
      "    \"886\": {\n",
      "      \"AT\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          21,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"HWS\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          21,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"PRE\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          21,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"WD\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          21,\n",
      "          22,\n",
      "          23\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      }\n",
      "    },\n",
      "    \"887\": {\n",
      "      \"AT\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"HWS\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"PRE\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      },\n",
      "      \"WD\": {\n",
      "        \"sol_hours_with_data\": [\n",
      "          0,\n",
      "          1\n",
      "        ],\n",
      "        \"valid\": false\n",
      "      }\n",
      "    },\n",
      "    \"sol_hours_required\": 18,\n",
      "    \"sols_checked\": [\n",
      "      \"880\",\n",
      "      \"882\",\n",
      "      \"884\",\n",
      "      \"885\",\n",
      "      \"886\",\n",
      "      \"887\"\n",
      "    ]\n",
      "  }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "from datetime import date\n",
    "\n",
    "# Get the latest feed\n",
    "r = requests.get('https://api.nasa.gov/insight_weather/?api_key=DEMO_KEY&feedtype=json')\n",
    "\n",
    "# Get the Status code from the API call\n",
    "print(\"Response Status:\")\n",
    "print(r.status_code)\n",
    "\n",
    "#Create the date for the Excel sheet name\n",
    "today = date.today()\n",
    "date_run = today.strftime(\"%m%d%Y\")\n",
    "\n",
    "# Normalize the json response and download it as an Excel sheet\n",
    "df = pd.json_normalize(r.json())\n",
    "df.to_excel('./latest_insight_data.xlsx',sheet_name=date_run)\n",
    "\n",
    "# Get, convert, and print the response here\n",
    "# Convert the response to text for later print out\n",
    "insight_response = r.text\n",
    "\n",
    "#Convert to JSON objects\n",
    "json_object = json.loads(insight_response)\n",
    "\n",
    "#Format to make it pretty\n",
    "json_formatted_str = json.dumps(json_object, indent=2)\n",
    "\n",
    "#Print the pretty JSON response\n",
    "print(\"Response Content:\")\n",
    "print(json_formatted_str)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "556d6a3b-871f-4afb-bfd2-d7483a74b87c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "76474685-7410-4f02-9454-883cbf8e1a45",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d1eb4c37-1500-4419-b1c8-48726dcf067c",
   "metadata": {
    "tags": []
   },
   "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}