Get Climate Data from capitals.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import numpy as np\n",
    "import time\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Capitals json geolocalization\n",
    "\n",
    "capitals = [\n",
    "    { \"name\": \"Rio Branco\", \"coordinates\": [-67.8662019, -9.9862442] },\n",
    "    { \"name\": \"Maceió\", \"coordinates\": [-35.7568902, -9.5943984] },\n",
    "    { \"name\": \"Macapá\", \"coordinates\": [0.1019439, -51.1670724] },\n",
    "    { \"name\": \"Manaus\", \"coordinates\": [-60.1075319, -3.0443101] },\n",
    "    { \"name\": \"Salvador\", \"coordinates\": [-38.490317, -12.9015883] },\n",
    "    { \"name\": \"Fortaleza\", \"coordinates\": [-38.5891584, -3.7899266] },\n",
    "    { \"name\": \"Brasília\", \"coordinates\": [-48.0779611, -15.7744219] },\n",
    "    { \"name\": \"Vitória\", \"coordinates\": [-49.4446947, -16.6954997] },\n",
    "    { \"name\": \"Goiânia\", \"coordinates\": [-48.0779611, -15.7744219] },\n",
    "    { \"name\": \"São Luís\", \"coordinates\": [-44.4383634, -2.6271281] },\n",
    "    { \"name\": \"Cuiabá\", \"coordinates\": [-48.0779611, -15.7744219] },\n",
    "    { \"name\": \"Campo Grande\", \"coordinates\": [-54.7057456, -20.4809249] },\n",
    "    { \"name\": \"Belo Horizonte\", \"coordinates\": [-44.0342617, -19.9025411] },\n",
    "    { \"name\": \"Belém\", \"coordinates\": [-48.5205932, -1.3411793] },\n",
    "    { \"name\": \"João Pessoa\", \"coordinates\": [-34.9518092, -7.1464332] },\n",
    "    { \"name\": \"Recife\", \"coordinates\": [-49.4302249, -25.4947398] },\n",
    "    { \"name\": \"Teresina\", \"coordinates\": [-42.8112899, -5.0935648] },\n",
    "    { \"name\": \"Rio de Janeiro\", \"coordinates\": [-43.7268521, -22.9132513] },\n",
    "    { \"name\": \"Natal\", \"coordinates\": [-35.2924559, -5.7997438] },\n",
    "    { \"name\": \"Porto Alegre\", \"coordinates\": [-51.3175682, -30.1084984] },\n",
    "    { \"name\": \"Porto Velho\", \"coordinates\": [-63.8900121, -8.7564592] },\n",
    "    { \"name\": \"Boa Vista\", \"coordinates\": [-36.2463902, -7.2660776] },\n",
    "    { \"name\": \"Florianópolis\", \"coordinates\": [-48.7511475, -27.5707043] },\n",
    "    { \"name\": \"São Paulo\", \"coordinates\": [-46.8761689, -23.6815303] },\n",
    "    { \"name\": \"Aracaju\", \"coordinates\": [-37.1733679, -11.0058313] },\n",
    "    { \"name\": \"Palmas\", \"coordinates\": [-48.417446, -10.2598832] }\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Extract climate data from meteomatics API - Use relevant features, such as those cited on https://www.sciencedirect.com/science/article/pii/S0048969720322221?via%3Dihub\n",
    "\n",
    "# username = viridi19_oliveira\n",
    "# password = LWb0YZjOp65oy\n",
    "\n",
    "frames = []\n",
    "start_date = \"2020-01-01T00:00:00Z\"\n",
    "end_date = \"2020-05-31T00:00:00Z\"\n",
    "\n",
    "for item in capitals:\n",
    "    url = f\"https://{os.getenn('USERNAME')}:{os.getenv('PASSWORD')}@api.meteomatics.com/{start_date}--{end_date}:P1D/t_2m:C,relative_humidity_2m:p,uv:idx,precip_1h:mm/{item['coordinates'][0]},{item['coordinates'][1]}/csv\"\n",
    "    results = requests.get(url)\n",
    "    \n",
    "    with open('test.csv', 'wb') as file:\n",
    "        file.write(results.content)\n",
    "    time.sleep(1)\n",
    "    frames.append(pd.read_csv('test.csv', ';'))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge results for all capitals\n",
    "result = pd.concat(frames, keys=[capital[\"name\"] for capital in capitals])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save data to a csv file\n",
    "result.to_csv('all_capitals_climate.csv')"
   ]
  }
 ],
 "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}