Day004_HW.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "uSf0mVenUdOf"
   },
   "source": [
    "# 利用 Python 存取 API\n",
    "\n",
    "\n",
    "* 了解 Server Client 的架構與溝通方法\n",
    "* 知道 HTTP Request & Response 的內容\n",
    "* 什麼是 API？如何用 Python 程式存取 API 資料\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "FwvxVPZuUdOh"
   },
   "source": [
    "## 作業目標\n",
    "\n",
    "* 比較一下範例檔案中的「r.text」與「json.loads(r.text)」讀出來的內容有什麼差異\n",
    "* 自行尋找一個合適的 API 接口做練習，並且查看其回傳內容\n",
    "    * https://cat-fact.herokuapp.com/facts (來源：https://alexwohlbruck.github.io/cat-facts/)\n",
    "    * http://odata.wra.gov.tw/v4/RealtimeWaterLevel (來源：https://data.gov.tw/dataset/25768)\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "r5GIjwYuUdOi"
   },
   "source": [
    "### 比較一下範例檔案中的「r.text」與「json.loads(r.text)」讀出來的內容有什麼差異"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "sVxW3MTeUdOj",
    "outputId": "a83e3e3b-eb9d-4c6d-d5d2-3a2ef30cee87"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\nYour Code\\n'"
      ]
     },
     "execution_count": 3,
     "metadata": {
      "tags": []
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'\n",
    "「r.text」是字符串的格式\n",
    "「json.loads(r.text)」是字典的格式\n",
    "'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "eJwMGD6XUdOn"
   },
   "source": [
    "### 自行尋找一個合適的 API 接口做練習，並且查看其回傳內容\n",
    "\n",
    "* https://cat-fact.herokuapp.com/facts (來源：https://alexwohlbruck.github.io/cat-facts/)\n",
    "* http://odata.wra.gov.tw/v4/RealtimeWaterLevel (來源：https://data.gov.tw/dataset/25768)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "XDvzxwA0UdOn",
    "outputId": "154b29e6-cd0d-48b9-e659-6e9a3f55e274"
   },
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       ": '7.5',\n",
       "   'O3_8hr': '7',\n",
       "   'PM10': '65',\n",
       "   'PM2.5': '50',\n",
       "   'NO2': '23',\n",
       "   'NOx': '25.1',\n",
       "   'NO': '2.1',\n",
       "   'WindSpeed': '1.3',\n",
       "   'WindDirec': '325',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '49',\n",
       "   'PM10_AVG': '64',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.358083',\n",
       "   'Latitude': '22.627392',\n",
       "   'SiteId': '50',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '大寮',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '120',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '1.5',\n",
       "   'CO': '0.42',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '10.4',\n",
       "   'O3_8hr': '8',\n",
       "   'PM10': '61',\n",
       "   'PM2.5': '48',\n",
       "   'NO2': '17.8',\n",
       "   'NOx': '18.8',\n",
       "   'NO': '1.1',\n",
       "   'WindSpeed': '1.6',\n",
       "   'WindDirec': '308',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '43',\n",
       "   'PM10_AVG': '60',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.425311',\n",
       "   'Latitude': '22.56413611',\n",
       "   'SiteId': '51',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '林園',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '118',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '5.4',\n",
       "   'CO': '0.55',\n",
       "   'CO_8hr': '0.6',\n",
       "   'O3': '5.3',\n",
       "   'O3_8hr': '7',\n",
       "   'PM10': '88',\n",
       "   'PM2.5': '45',\n",
       "   'NO2': '28.4',\n",
       "   'NOx': '34.8',\n",
       "   'NO': '6.4',\n",
       "   'WindSpeed': '1.9',\n",
       "   'WindDirec': '28',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '42',\n",
       "   'PM10_AVG': '74',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.41175',\n",
       "   'Latitude': '22.4795',\n",
       "   'SiteId': '52',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '楠梓',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '115',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '1.4',\n",
       "   'CO': '0.48',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '19.3',\n",
       "   'O3_8hr': '16',\n",
       "   'PM10': '69',\n",
       "   'PM2.5': '45',\n",
       "   'NO2': '16.3',\n",
       "   'NOx': '18.5',\n",
       "   'NO': '2.3',\n",
       "   'WindSpeed': '2.3',\n",
       "   'WindDirec': '332',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '41',\n",
       "   'PM10_AVG': '66',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '120.328289',\n",
       "   'Latitude': '22.733667',\n",
       "   'SiteId': '53',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '左營',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '116',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '3',\n",
       "   'CO': '0.53',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '18.2',\n",
       "   'O3_8hr': '13',\n",
       "   'PM10': '77',\n",
       "   'PM2.5': '51',\n",
       "   'NO2': '18.1',\n",
       "   'NOx': '19.5',\n",
       "   'NO': '1.4',\n",
       "   'WindSpeed': '2.3',\n",
       "   'WindDirec': '344',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '41',\n",
       "   'PM10_AVG': '66',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.292917',\n",
       "   'Latitude': '22.674861',\n",
       "   'SiteId': '54',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '前金',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '113',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '2.5',\n",
       "   'CO': '0.5',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '15.7',\n",
       "   'O3_8hr': '13',\n",
       "   'PM10': '71',\n",
       "   'PM2.5': '45',\n",
       "   'NO2': '18.7',\n",
       "   'NOx': '20.7',\n",
       "   'NO': '2',\n",
       "   'WindSpeed': '2.3',\n",
       "   'WindDirec': '5',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '40',\n",
       "   'PM10_AVG': '64',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.288086',\n",
       "   'Latitude': '22.632567',\n",
       "   'SiteId': '56',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '前鎮',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '135',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '2',\n",
       "   'CO': '0.47',\n",
       "   'CO_8hr': '0.6',\n",
       "   'O3': '12.6',\n",
       "   'O3_8hr': '9',\n",
       "   'PM10': '72',\n",
       "   'PM2.5': '55',\n",
       "   'NO2': '20.1',\n",
       "   'NOx': '22.1',\n",
       "   'NO': '2',\n",
       "   'WindSpeed': '2',\n",
       "   'WindDirec': '17',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '49',\n",
       "   'PM10_AVG': '66',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.307564',\n",
       "   'Latitude': '22.605386',\n",
       "   'SiteId': '57',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '小港',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '122',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '3.3',\n",
       "   'CO': '0.51',\n",
       "   'CO_8hr': '0.6',\n",
       "   'O3': '6',\n",
       "   'O3_8hr': '9',\n",
       "   'PM10': '63',\n",
       "   'PM2.5': '45',\n",
       "   'NO2': '28.1',\n",
       "   'NOx': '30.3',\n",
       "   'NO': '2.1',\n",
       "   'WindSpeed': '1.2',\n",
       "   'WindDirec': '29',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '44',\n",
       "   'PM10_AVG': '65',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.337736',\n",
       "   'Latitude': '22.565833',\n",
       "   'SiteId': '58',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '屏東',\n",
       "   'County': '屏東縣',\n",
       "   'AQI': '99',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '1.7',\n",
       "   'CO': '0.4',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '10',\n",
       "   'O3_8hr': '14',\n",
       "   'PM10': '61',\n",
       "   'PM2.5': '35',\n",
       "   'NO2': '15.4',\n",
       "   'NOx': '16.4',\n",
       "   'NO': '1',\n",
       "   'WindSpeed': '0.9',\n",
       "   'WindDirec': '69',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '35',\n",
       "   'PM10_AVG': '54',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.488033',\n",
       "   'Latitude': '22.673081',\n",
       "   'SiteId': '59',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '潮州',\n",
       "   'County': '屏東縣',\n",
       "   'AQI': '112',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '1.2',\n",
       "   'CO': '0.44',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '7.3',\n",
       "   'O3_8hr': '12',\n",
       "   'PM10': '63',\n",
       "   'PM2.5': '42',\n",
       "   'NO2': '19.7',\n",
       "   'NOx': '19.9',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '0.7',\n",
       "   'WindDirec': '291',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '40',\n",
       "   'PM10_AVG': '62',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.561175',\n",
       "   'Latitude': '22.523108',\n",
       "   'SiteId': '60',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '恆春',\n",
       "   'County': '屏東縣',\n",
       "   'AQI': '41',\n",
       "   'Pollutant': '',\n",
       "   'Status': '良好',\n",
       "   'SO2': '1.1',\n",
       "   'CO': '0.35',\n",
       "   'CO_8hr': '0.3',\n",
       "   'O3': '43.7',\n",
       "   'O3_8hr': '44',\n",
       "   'PM10': '16',\n",
       "   'PM2.5': '11',\n",
       "   'NO2': '2.9',\n",
       "   'NOx': '4.3',\n",
       "   'NO': '1.3',\n",
       "   'WindSpeed': '8.7',\n",
       "   'WindDirec': '34',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '9',\n",
       "   'PM10_AVG': '11',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '120.788928',\n",
       "   'Latitude': '21.958069',\n",
       "   'SiteId': '61',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '臺東',\n",
       "   'County': '臺東縣',\n",
       "   'AQI': '47',\n",
       "   'Pollutant': '',\n",
       "   'Status': '良好',\n",
       "   'SO2': '1',\n",
       "   'CO': '0.47',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '40.2',\n",
       "   'O3_8hr': '38',\n",
       "   'PM10': '27',\n",
       "   'PM2.5': '21',\n",
       "   'NO2': '3.5',\n",
       "   'NOx': '3.9',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '2.1',\n",
       "   'WindDirec': '325',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '14',\n",
       "   'PM10_AVG': '22',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '121.15045',\n",
       "   'Latitude': '22.755358',\n",
       "   'SiteId': '62',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '花蓮',\n",
       "   'County': '花蓮縣',\n",
       "   'AQI': '43',\n",
       "   'Pollutant': '',\n",
       "   'Status': '良好',\n",
       "   'SO2': '1.3',\n",
       "   'CO': '0.42',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '32.9',\n",
       "   'O3_8hr': '41',\n",
       "   'PM10': '16',\n",
       "   'PM2.5': '10',\n",
       "   'NO2': '4.2',\n",
       "   'NOx': '5.1',\n",
       "   'NO': '1',\n",
       "   'WindSpeed': '1.2',\n",
       "   'WindDirec': '217',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '13',\n",
       "   'PM10_AVG': '23',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '121.599769',\n",
       "   'Latitude': '23.971306',\n",
       "   'SiteId': '63',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '陽明',\n",
       "   'County': '臺北市',\n",
       "   'AQI': '52',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '1.8',\n",
       "   'CO': '0.22',\n",
       "   'CO_8hr': '0.3',\n",
       "   'O3': '47.7',\n",
       "   'O3_8hr': '47',\n",
       "   'PM10': '11',\n",
       "   'PM2.5': '9',\n",
       "   'NO2': '2.4',\n",
       "   'NOx': '2.7',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '2.5',\n",
       "   'WindDirec': '360',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '16',\n",
       "   'PM10_AVG': '19',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '121.529583',\n",
       "   'Latitude': '25.182722',\n",
       "   'SiteId': '64',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '宜蘭',\n",
       "   'County': '宜蘭縣',\n",
       "   'AQI': '64',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '1.9',\n",
       "   'CO': '0.4',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '28.8',\n",
       "   'O3_8hr': '37',\n",
       "   'PM10': '',\n",
       "   'PM2.5': '12',\n",
       "   'NO2': '3.5',\n",
       "   'NOx': '4.2',\n",
       "   'NO': '0.7',\n",
       "   'WindSpeed': '1.1',\n",
       "   'WindDirec': '276',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '21',\n",
       "   'PM10_AVG': '',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '121.746394',\n",
       "   'Latitude': '24.747917',\n",
       "   'SiteId': '65',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '冬山',\n",
       "   'County': '宜蘭縣',\n",
       "   'AQI': '71',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '0.5',\n",
       "   'CO': '0.34',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '36.5',\n",
       "   'O3_8hr': '38',\n",
       "   'PM10': '22',\n",
       "   'PM2.5': '18',\n",
       "   'NO2': '3.1',\n",
       "   'NOx': '3.9',\n",
       "   'NO': '0.8',\n",
       "   'WindSpeed': '1.8',\n",
       "   'WindDirec': '249',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '24',\n",
       "   'PM10_AVG': '31',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '121.792928',\n",
       "   'Latitude': '24.632203',\n",
       "   'SiteId': '66',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '三重',\n",
       "   'County': '新北市',\n",
       "   'AQI': '97',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '2',\n",
       "   'CO': '0.75',\n",
       "   'CO_8hr': '1',\n",
       "   'O3': '-',\n",
       "   'O3_8hr': '-',\n",
       "   'PM10': '39',\n",
       "   'PM2.5': '24',\n",
       "   'NO2': '29.8',\n",
       "   'NOx': '53.9',\n",
       "   'NO': '24.1',\n",
       "   'WindSpeed': '-',\n",
       "   'WindDirec': '-',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '34',\n",
       "   'PM10_AVG': '50',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '121.493806',\n",
       "   'Latitude': '25.072611',\n",
       "   'SiteId': '67',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '中壢',\n",
       "   'County': '桃園市',\n",
       "   'AQI': '121',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '6',\n",
       "   'CO': '0.62',\n",
       "   'CO_8hr': '1',\n",
       "   'O3': '23.3',\n",
       "   'O3_8hr': '20',\n",
       "   'PM10': '50',\n",
       "   'PM2.5': '37',\n",
       "   'NO2': '18',\n",
       "   'NOx': '18.6',\n",
       "   'NO': '0.7',\n",
       "   'WindSpeed': '0.6',\n",
       "   'WindDirec': '351',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '43',\n",
       "   'PM10_AVG': '60',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '121.221667',\n",
       "   'Latitude': '24.953278',\n",
       "   'SiteId': '68',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '竹山',\n",
       "   'County': '南投縣',\n",
       "   'AQI': '102',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '2',\n",
       "   'CO': '0.53',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '25',\n",
       "   'O3_8hr': '20',\n",
       "   'PM10': '59',\n",
       "   'PM2.5': '39',\n",
       "   'NO2': '10',\n",
       "   'NOx': '9.6',\n",
       "   'NO': '0',\n",
       "   'WindSpeed': '1.7',\n",
       "   'WindDirec': '26',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '36',\n",
       "   'PM10_AVG': '56',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.677306',\n",
       "   'Latitude': '23.756389',\n",
       "   'SiteId': '69',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '永和',\n",
       "   'County': '新北市',\n",
       "   'AQI': '95',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '2',\n",
       "   'CO': '0.4',\n",
       "   'CO_8hr': '0.7',\n",
       "   'O3': '31',\n",
       "   'O3_8hr': '30',\n",
       "   'PM10': '33',\n",
       "   'PM2.5': '24',\n",
       "   'NO2': '7.5',\n",
       "   'NOx': '8.7',\n",
       "   'NO': '1.2',\n",
       "   'WindSpeed': '0.8',\n",
       "   'WindDirec': '164',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '34',\n",
       "   'PM10_AVG': '48',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '121.516306',\n",
       "   'Latitude': '25.017',\n",
       "   'SiteId': '70',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '復興',\n",
       "   'County': '高雄市',\n",
       "   'AQI': '130',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '2.9',\n",
       "   'CO': '0.53',\n",
       "   'CO_8hr': '0.6',\n",
       "   'O3': '13.9',\n",
       "   'O3_8hr': '10',\n",
       "   'PM10': '75',\n",
       "   'PM2.5': '47',\n",
       "   'NO2': '19.8',\n",
       "   'NOx': '22.1',\n",
       "   'NO': '2.3',\n",
       "   'WindSpeed': '1.2',\n",
       "   'WindDirec': '114',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '47',\n",
       "   'PM10_AVG': '69',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.312017',\n",
       "   'Latitude': '22.608711',\n",
       "   'SiteId': '71',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '埔里',\n",
       "   'County': '南投縣',\n",
       "   'AQI': '61',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '1.1',\n",
       "   'CO': '0.37',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '8.1',\n",
       "   'O3_8hr': '16',\n",
       "   'PM10': '25',\n",
       "   'PM2.5': '19',\n",
       "   'NO2': '9.3',\n",
       "   'NOx': '10.1',\n",
       "   'NO': '0.9',\n",
       "   'WindSpeed': '0.6',\n",
       "   'WindDirec': '81',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '20',\n",
       "   'PM10_AVG': '26',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.967903',\n",
       "   'Latitude': '23.968842',\n",
       "   'SiteId': '72',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '馬祖',\n",
       "   'County': '連江縣',\n",
       "   'AQI': '126',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '3.5',\n",
       "   'CO': '0.42',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '47.4',\n",
       "   'O3_8hr': '49',\n",
       "   'PM10': '62',\n",
       "   'PM2.5': '43',\n",
       "   'NO2': '6.4',\n",
       "   'NOx': '7.2',\n",
       "   'NO': '0.8',\n",
       "   'WindSpeed': '2.3',\n",
       "   'WindDirec': '321',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '45',\n",
       "   'PM10_AVG': '65',\n",
       "   'SO2_AVG': '4',\n",
       "   'Longitude': '119.949875',\n",
       "   'Latitude': '26.160469',\n",
       "   'SiteId': '75',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '金門',\n",
       "   'County': '金門縣',\n",
       "   'AQI': '99',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '2.5',\n",
       "   'CO': '0.47',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '42.2',\n",
       "   'O3_8hr': '46',\n",
       "   'PM10': '75',\n",
       "   'PM2.5': '50',\n",
       "   'NO2': '10.4',\n",
       "   'NOx': '10.9',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '3.6',\n",
       "   'WindDirec': '44',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '35',\n",
       "   'PM10_AVG': '57',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '118.312256',\n",
       "   'Latitude': '24.432133',\n",
       "   'SiteId': '77',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '馬公',\n",
       "   'County': '澎湖縣',\n",
       "   'AQI': '97',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '0.5',\n",
       "   'CO': '0.32',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '43.7',\n",
       "   'O3_8hr': '52',\n",
       "   'PM10': '52',\n",
       "   'PM2.5': '28',\n",
       "   'NO2': '4',\n",
       "   'NOx': '5.6',\n",
       "   'NO': '1.6',\n",
       "   'WindSpeed': '7.6',\n",
       "   'WindDirec': '24',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '34',\n",
       "   'PM10_AVG': '53',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '119.566158',\n",
       "   'Latitude': '23.569031',\n",
       "   'SiteId': '78',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '關山',\n",
       "   'County': '臺東縣',\n",
       "   'AQI': '37',\n",
       "   'Pollutant': '',\n",
       "   'Status': '良好',\n",
       "   'SO2': '0.5',\n",
       "   'CO': '-',\n",
       "   'CO_8hr': '-',\n",
       "   'O3': '36.6',\n",
       "   'O3_8hr': '37',\n",
       "   'PM10': '20',\n",
       "   'PM2.5': '17',\n",
       "   'NO2': '3',\n",
       "   'NOx': '4.1',\n",
       "   'NO': '1.1',\n",
       "   'WindSpeed': '1.3',\n",
       "   'WindDirec': '27',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '12',\n",
       "   'PM10_AVG': '15',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '121.161933',\n",
       "   'Latitude': '23.045083',\n",
       "   'SiteId': '80',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '麥寮',\n",
       "   'County': '雲林縣',\n",
       "   'AQI': '118',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '5.2',\n",
       "   'CO': '0.45',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '27.2',\n",
       "   'O3_8hr': '32',\n",
       "   'PM10': '49',\n",
       "   'PM2.5': '37',\n",
       "   'NO2': '13.5',\n",
       "   'NOx': '16.5',\n",
       "   'NO': '2.9',\n",
       "   'WindSpeed': '5.4',\n",
       "   'WindDirec': '8',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '42',\n",
       "   'PM10_AVG': '59',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.251825',\n",
       "   'Latitude': '23.753506',\n",
       "   'SiteId': '83',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '富貴角',\n",
       "   'County': '新北市',\n",
       "   'AQI': '87',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '0.5',\n",
       "   'CO': '0.24',\n",
       "   'CO_8hr': '0.3',\n",
       "   'O3': '57.3',\n",
       "   'O3_8hr': '55',\n",
       "   'PM10': '65',\n",
       "   'PM2.5': '27',\n",
       "   'NO2': '2',\n",
       "   'NOx': '1.9',\n",
       "   'NO': '0',\n",
       "   'WindSpeed': '10.7',\n",
       "   'WindDirec': '48',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '30',\n",
       "   'PM10_AVG': '73',\n",
       "   'SO2_AVG': '0',\n",
       "   'Longitude': '121.54738',\n",
       "   'Latitude': '25.29228',\n",
       "   'SiteId': '84',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '彰化(員林)',\n",
       "   'County': '彰化縣',\n",
       "   'AQI': '106',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '2.2',\n",
       "   'CO': '0.5',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '32.8',\n",
       "   'O3_8hr': '36',\n",
       "   'PM10': '59',\n",
       "   'PM2.5': '39',\n",
       "   'NO2': '11.8',\n",
       "   'NOx': '11.5',\n",
       "   'NO': '0',\n",
       "   'WindSpeed': '1',\n",
       "   'WindDirec': '5',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '37',\n",
       "   'PM10_AVG': '58',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.58178611',\n",
       "   'Latitude': '23.95058333',\n",
       "   'SiteId': '201',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '彰化(大城)',\n",
       "   'County': '彰化縣',\n",
       "   'AQI': '106',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '2.9',\n",
       "   'CO': '0.14',\n",
       "   'CO_8hr': '0.2',\n",
       "   'O3': '43.3',\n",
       "   'O3_8hr': '43',\n",
       "   'PM10': '57',\n",
       "   'PM2.5': '23',\n",
       "   'NO2': '8.8',\n",
       "   'NOx': '10.1',\n",
       "   'NO': '1.3',\n",
       "   'WindSpeed': '6.5',\n",
       "   'WindDirec': '22',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '37',\n",
       "   'PM10_AVG': '67',\n",
       "   'SO2_AVG': '2',\n",
       "   'Longitude': '120.27311',\n",
       "   'Latitude': '23.84313',\n",
       "   'SiteId': '202',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '臺南(麻豆)',\n",
       "   'County': '臺南市',\n",
       "   'AQI': '125',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '1',\n",
       "   'CO': '0.56',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '21.5',\n",
       "   'O3_8hr': '28',\n",
       "   'PM10': '69',\n",
       "   'PM2.5': '52',\n",
       "   'NO2': '14.1',\n",
       "   'NOx': '14.8',\n",
       "   'NO': '0.7',\n",
       "   'WindSpeed': '2.1',\n",
       "   'WindDirec': '10',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '45',\n",
       "   'PM10_AVG': '63',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '120.24583056',\n",
       "   'Latitude': '23.17904722',\n",
       "   'SiteId': '203',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '屏東(琉球)',\n",
       "   'County': '屏東縣',\n",
       "   'AQI': '104',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '3.5',\n",
       "   'CO': '0.81',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '0.5',\n",
       "   'O3_8hr': '14',\n",
       "   'PM10': '77',\n",
       "   'PM2.5': '49',\n",
       "   'NO2': '40.1',\n",
       "   'NOx': '45.1',\n",
       "   'NO': '5',\n",
       "   'WindSpeed': '1.3',\n",
       "   'WindDirec': '311',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '37',\n",
       "   'PM10_AVG': '65',\n",
       "   'SO2_AVG': '3',\n",
       "   'Longitude': '120.37722',\n",
       "   'Latitude': '22.35222',\n",
       "   'SiteId': '204',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '臺南(北門)',\n",
       "   'County': '臺南市',\n",
       "   'AQI': '112',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '1.1',\n",
       "   'CO': '0.48',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '26.8',\n",
       "   'O3_8hr': '30',\n",
       "   'PM10': '',\n",
       "   'PM2.5': '39',\n",
       "   'NO2': '11.3',\n",
       "   'NOx': '11.6',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '3.1',\n",
       "   'WindDirec': '20',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '40',\n",
       "   'PM10_AVG': '64',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '120.12444444',\n",
       "   'Latitude': '23.26472222',\n",
       "   'SiteId': '310',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '新北(樹林)',\n",
       "   'County': '新北市',\n",
       "   'AQI': '107',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '0.5',\n",
       "   'CO': '0.39',\n",
       "   'CO_8hr': '0.5',\n",
       "   'O3': '16.9',\n",
       "   'O3_8hr': '20',\n",
       "   'PM10': '-',\n",
       "   'PM2.5': '29',\n",
       "   'NO2': '15.7',\n",
       "   'NOx': '15.8',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '0',\n",
       "   'WindDirec': '193',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '38',\n",
       "   'PM10_AVG': '-',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '121.38352778',\n",
       "   'Latitude': '24.94902778',\n",
       "   'SiteId': '311',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '桃園(竹圍)',\n",
       "   'County': '桃園市',\n",
       "   'AQI': '84',\n",
       "   'Pollutant': '細懸浮微粒',\n",
       "   'Status': '普通',\n",
       "   'SO2': '0.5',\n",
       "   'CO': '0.24',\n",
       "   'CO_8hr': '0.3',\n",
       "   'O3': '43.4',\n",
       "   'O3_8hr': '38',\n",
       "   'PM10': '57',\n",
       "   'PM2.5': '26',\n",
       "   'NO2': '4.5',\n",
       "   'NOx': '4.6',\n",
       "   'NO': '0.3',\n",
       "   'WindSpeed': '2.1',\n",
       "   'WindDirec': '37',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '29',\n",
       "   'PM10_AVG': '64',\n",
       "   'SO2_AVG': '1',\n",
       "   'Longitude': '121.24426111',\n",
       "   'Latitude': '25.10363611',\n",
       "   'SiteId': '312',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'},\n",
       "  {'SiteName': '屏東(枋寮)',\n",
       "   'County': '屏東縣',\n",
       "   'AQI': '105',\n",
       "   'Pollutant': '二氧化硫',\n",
       "   'Status': '對敏感族群不健康',\n",
       "   'SO2': '84.6',\n",
       "   'CO': '0.42',\n",
       "   'CO_8hr': '0.4',\n",
       "   'O3': '4.2',\n",
       "   'O3_8hr': '7',\n",
       "   'PM10': '74',\n",
       "   'PM2.5': '38',\n",
       "   'NO2': '23.1',\n",
       "   'NOx': '24.7',\n",
       "   'NO': '1.6',\n",
       "   'WindSpeed': '0.2',\n",
       "   'WindDirec': '47',\n",
       "   'PublishTime': '2020/12/25 04:00:00',\n",
       "   'PM2.5_AVG': '34',\n",
       "   'PM10_AVG': '63',\n",
       "   'SO2_AVG': '8',\n",
       "   'Longitude': '120.59116667',\n",
       "   'Latitude': '22.37094722',\n",
       "   'SiteId': '313',\n",
       "   'ImportDate': '2020-12-25 04:45:02.143000'}],\n",
       " 'limit': 1000,\n",
       " 'offset': 0,\n",
       " '_links': {'start': '/api/v1/aqx_p_432?api_key=9be7b239-557b-4c10-9775-78cadfc555e9&limit=1000&format=json',\n",
       "  'next': '/api/v1/aqx_p_432?api_key=9be7b239-557b-4c10-9775-78cadfc555e9&limit=1000&offset=1000&format=json'},\n",
       " 'total': 85}"
      ]
     },
     "metadata": {},
     "execution_count": 2
    }
   ],
   "source": [
    "\n",
    "import requests\n",
    "import json\n",
    "r = requests.get('https://data.epa.gov.tw/api/v1/aqx_p_432?limit=1000&api_key=9be7b239-557b-4c10-9775-78cadfc555e9&format=json')\n",
    "r.text\n",
    "\n",
    "json.loads(r.text)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "RPISC-Y4UdOq"
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "H5EyeQRIUdOr"
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "name": "homework.ipynb",
   "provenance": []
  },
  "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-final"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}