Darksky_API.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Instruction: \n",
    "## https://darksky.net/dev/docs\n",
    "## https://darksky.net/dev/docs/libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import requests\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import time, calendar\n",
    "from datetime import datetime, timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# generate the list of days defined between start and end day\n",
    "def calendar_test(day, count, date_list = None):\n",
    "    if date_list is None:\n",
    "        date_list = []\n",
    "    if count == 0:\n",
    "        return date_list\n",
    "    count -= 1\n",
    "    day = day + timedelta(days=1)\n",
    "    date = day.isoformat().split('T')\n",
    "    date_list.append(\" \".join(date))\n",
    "    \n",
    "    calendar_test(day,count,date_list)\n",
    "    \n",
    "    return date_list\n",
    "\n",
    "# convert utc time to epoch time\n",
    "def convert_utc_to_epoch(timestamp_string):\n",
    "    '''Use this function to convert utc to epoch'''\n",
    "    timestamp = datetime.strptime(timestamp_string, '%Y-%m-%d %H:%M:%S')\n",
    "    epoch = int(calendar.timegm(timestamp.utctimetuple()))\n",
    "\n",
    "    return epoch\n",
    "\n",
    "# convert epoch time to YYYYMMDDHHMM format (year-month-day-hour-minute)\n",
    "def date_time_convert(item):\n",
    "    \n",
    "    date_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(item)).split(' ')\n",
    "    date = date_time[0].split('-')\n",
    "    time_ = date_time[1].split(':')\n",
    "    date = 10000*int(date[0])+100*int(date[1])+1*int(date[2])\n",
    "    time_ = 100*int(time_[0])+1*int(time_[1])\n",
    "    date_time = date*10000+time_\n",
    "    \n",
    "    return date_time\n",
    "\n",
    "\n",
    "def darksky_api_call(start_day,end_day):\n",
    "    start_day = datetime.strptime(start_day, '%Y-%m-%d')\n",
    "    end_day = datetime.strptime(end_day, '%Y-%m-%d')\n",
    "    total_day = abs((end_day - start_day).days)\n",
    "\n",
    "    day_list = calendar_test(start_day,total_day)\n",
    "\n",
    "    # darksky website\n",
    "    darksky = \"https://api.darksky.net/forecast/\"\n",
    "    # API key\n",
    "    key = \"69fcefff98d6c6a0f9b0ebfec1e6f2cc\"\n",
    "    # Position: Williamstown, MA    \n",
    "    lon_lat = \"/42.719949, -73.207822,\"\n",
    "    # Offset\n",
    "    offset = \"?exclude=minutely,flags\"\n",
    "\n",
    "    # define parameter you want to collect\n",
    "    info_list = ['time','summary','icon','precipIntensity','precipProbability','temperature','apparentTemperature',\n",
    "                 'dewPoint','humidity','pressure','windSpeed','windGust','windBearing','cloudCover','uvIndex',\n",
    "                 'visibility']\n",
    "    info = {para:[] for para in info_list}\n",
    "\n",
    "    # API calling\n",
    "    for day in day_list:\n",
    "        print(day)\n",
    "    \n",
    "        epoch_time = convert_utc_to_epoch(day)    \n",
    "        link = darksky + key + lon_lat + str(epoch_time) + offset\n",
    "\n",
    "        res = requests.get(link)\n",
    "        data = res.json()\n",
    "    \n",
    "        if 'hourly' not in data:\n",
    "            continue\n",
    "        elif 'data' not in data['hourly']:\n",
    "            continue\n",
    "    \n",
    "        for item in data['hourly']['data']:\n",
    "            epoch = item['time']\n",
    "            date_time = date_time_convert(item['time'])\n",
    "            # parameters collected\n",
    "            for para in info_list:\n",
    "                if para not in item:\n",
    "                    info[para].append(float('nan'))\n",
    "                else:\n",
    "                    info[para].append(item[para])\n",
    "        \n",
    "    file = pd.DataFrame(dict([(k,pd.Series(v)) for k,v in info.items() ]))\n",
    "    \n",
    "    return file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2017-09-13 00:00:00\n",
      "2017-09-14 00:00:00\n",
      "2017-09-15 00:00:00\n",
      "2017-09-16 00:00:00\n",
      "2017-09-17 00:00:00\n",
      "2017-09-18 00:00:00\n",
      "2017-09-19 00:00:00\n",
      "2017-09-20 00:00:00\n",
      "2017-09-21 00:00:00\n",
      "2017-09-22 00:00:00\n",
      "2017-09-23 00:00:00\n",
      "2017-09-24 00:00:00\n",
      "2017-09-25 00:00:00\n",
      "2017-09-26 00:00:00\n",
      "2017-09-27 00:00:00\n",
      "2017-09-28 00:00:00\n",
      "2017-09-29 00:00:00\n",
      "2017-09-30 00:00:00\n",
      "2017-10-01 00:00:00\n",
      "2017-10-02 00:00:00\n",
      "2017-10-03 00:00:00\n",
      "2017-10-04 00:00:00\n",
      "2017-10-05 00:00:00\n",
      "2017-10-06 00:00:00\n",
      "2017-10-07 00:00:00\n",
      "2017-10-08 00:00:00\n",
      "2017-10-09 00:00:00\n",
      "2017-10-10 00:00:00\n",
      "2017-10-11 00:00:00\n",
      "2017-10-12 00:00:00\n",
      "2017-10-13 00:00:00\n",
      "2017-10-14 00:00:00\n",
      "2017-10-15 00:00:00\n",
      "2017-10-16 00:00:00\n",
      "2017-10-17 00:00:00\n",
      "2017-10-18 00:00:00\n",
      "2017-10-19 00:00:00\n",
      "2017-10-20 00:00:00\n",
      "2017-10-21 00:00:00\n",
      "2017-10-22 00:00:00\n",
      "2017-10-23 00:00:00\n",
      "2017-10-24 00:00:00\n",
      "2017-10-25 00:00:00\n",
      "2017-10-26 00:00:00\n",
      "2017-10-27 00:00:00\n",
      "2017-10-28 00:00:00\n",
      "2017-10-29 00:00:00\n",
      "2017-10-30 00:00:00\n",
      "2017-10-31 00:00:00\n",
      "2017-11-01 00:00:00\n",
      "2017-11-02 00:00:00\n",
      "2017-11-03 00:00:00\n",
      "2017-11-04 00:00:00\n",
      "2017-11-05 00:00:00\n",
      "2017-11-06 00:00:00\n",
      "2017-11-07 00:00:00\n",
      "2017-11-08 00:00:00\n",
      "2017-11-09 00:00:00\n",
      "2017-11-10 00:00:00\n",
      "2017-11-11 00:00:00\n",
      "2017-11-12 00:00:00\n",
      "2017-11-13 00:00:00\n",
      "2017-11-14 00:00:00\n",
      "2017-11-15 00:00:00\n",
      "2017-11-16 00:00:00\n",
      "2017-11-17 00:00:00\n",
      "2017-11-18 00:00:00\n",
      "2017-11-19 00:00:00\n",
      "2017-11-20 00:00:00\n",
      "2017-11-21 00:00:00\n",
      "2017-11-22 00:00:00\n",
      "2017-11-23 00:00:00\n",
      "2017-11-24 00:00:00\n",
      "2017-11-25 00:00:00\n",
      "2017-11-26 00:00:00\n",
      "2017-11-27 00:00:00\n",
      "2017-11-28 00:00:00\n",
      "2017-11-29 00:00:00\n",
      "2017-11-30 00:00:00\n",
      "2017-12-01 00:00:00\n",
      "2017-12-02 00:00:00\n",
      "2017-12-03 00:00:00\n",
      "2017-12-04 00:00:00\n",
      "2017-12-05 00:00:00\n",
      "2017-12-06 00:00:00\n",
      "2017-12-07 00:00:00\n",
      "2017-12-08 00:00:00\n",
      "2017-12-09 00:00:00\n",
      "2017-12-10 00:00:00\n",
      "2017-12-11 00:00:00\n",
      "2017-12-12 00:00:00\n",
      "2017-12-13 00:00:00\n",
      "2017-12-14 00:00:00\n",
      "2017-12-15 00:00:00\n",
      "2017-12-16 00:00:00\n",
      "2017-12-17 00:00:00\n",
      "2017-12-18 00:00:00\n",
      "2017-12-19 00:00:00\n",
      "2017-12-20 00:00:00\n",
      "2017-12-21 00:00:00\n",
      "2017-12-22 00:00:00\n",
      "2017-12-23 00:00:00\n",
      "2017-12-24 00:00:00\n",
      "2017-12-25 00:00:00\n",
      "2017-12-26 00:00:00\n",
      "2017-12-27 00:00:00\n",
      "2017-12-28 00:00:00\n",
      "2017-12-29 00:00:00\n",
      "2017-12-30 00:00:00\n",
      "2017-12-31 00:00:00\n",
      "2018-01-01 00:00:00\n",
      "2018-01-02 00:00:00\n",
      "2018-01-03 00:00:00\n",
      "2018-01-04 00:00:00\n",
      "2018-01-05 00:00:00\n",
      "2018-01-06 00:00:00\n",
      "2018-01-07 00:00:00\n",
      "2018-01-08 00:00:00\n",
      "2018-01-09 00:00:00\n",
      "2018-01-10 00:00:00\n",
      "2018-01-11 00:00:00\n",
      "2018-01-12 00:00:00\n",
      "2018-01-13 00:00:00\n",
      "2018-01-14 00:00:00\n",
      "2018-01-15 00:00:00\n",
      "2018-01-16 00:00:00\n",
      "2018-01-17 00:00:00\n",
      "2018-01-18 00:00:00\n",
      "2018-01-19 00:00:00\n",
      "2018-01-20 00:00:00\n",
      "2018-01-21 00:00:00\n",
      "2018-01-22 00:00:00\n",
      "2018-01-23 00:00:00\n",
      "2018-01-24 00:00:00\n",
      "2018-01-25 00:00:00\n",
      "2018-01-26 00:00:00\n",
      "2018-01-27 00:00:00\n",
      "2018-01-28 00:00:00\n",
      "2018-01-29 00:00:00\n",
      "2018-01-30 00:00:00\n",
      "2018-01-31 00:00:00\n",
      "2018-02-01 00:00:00\n",
      "2018-02-02 00:00:00\n",
      "2018-02-03 00:00:00\n",
      "2018-02-04 00:00:00\n",
      "2018-02-05 00:00:00\n",
      "2018-02-06 00:00:00\n",
      "2018-02-07 00:00:00\n",
      "2018-02-08 00:00:00\n",
      "2018-02-09 00:00:00\n",
      "2018-02-10 00:00:00\n",
      "2018-02-11 00:00:00\n",
      "2018-02-12 00:00:00\n",
      "2018-02-13 00:00:00\n",
      "2018-02-14 00:00:00\n",
      "2018-02-15 00:00:00\n",
      "2018-02-16 00:00:00\n",
      "2018-02-17 00:00:00\n",
      "2018-02-18 00:00:00\n",
      "2018-02-19 00:00:00\n",
      "2018-02-20 00:00:00\n",
      "2018-02-21 00:00:00\n",
      "2018-02-22 00:00:00\n",
      "2018-02-23 00:00:00\n",
      "2018-02-24 00:00:00\n",
      "2018-02-25 00:00:00\n",
      "2018-02-26 00:00:00\n",
      "2018-02-27 00:00:00\n",
      "2018-02-28 00:00:00\n",
      "2018-03-01 00:00:00\n",
      "2018-03-02 00:00:00\n",
      "2018-03-03 00:00:00\n",
      "2018-03-04 00:00:00\n",
      "2018-03-05 00:00:00\n",
      "2018-03-06 00:00:00\n",
      "2018-03-07 00:00:00\n",
      "2018-03-08 00:00:00\n",
      "2018-03-09 00:00:00\n",
      "2018-03-10 00:00:00\n",
      "2018-03-11 00:00:00\n",
      "2018-03-12 00:00:00\n",
      "2018-03-13 00:00:00\n",
      "2018-03-14 00:00:00\n",
      "2018-03-15 00:00:00\n",
      "2018-03-16 00:00:00\n",
      "2018-03-17 00:00:00\n",
      "2018-03-18 00:00:00\n",
      "2018-03-19 00:00:00\n",
      "2018-03-20 00:00:00\n",
      "2018-03-21 00:00:00\n",
      "2018-03-22 00:00:00\n",
      "2018-03-23 00:00:00\n",
      "2018-03-24 00:00:00\n",
      "2018-03-25 00:00:00\n",
      "2018-03-26 00:00:00\n",
      "2018-03-27 00:00:00\n",
      "2018-03-28 00:00:00\n",
      "2018-03-29 00:00:00\n",
      "2018-03-30 00:00:00\n",
      "2018-03-31 00:00:00\n",
      "2018-04-01 00:00:00\n",
      "2018-04-02 00:00:00\n",
      "2018-04-03 00:00:00\n",
      "2018-04-04 00:00:00\n",
      "2018-04-05 00:00:00\n",
      "2018-04-06 00:00:00\n",
      "2018-04-07 00:00:00\n",
      "2018-04-08 00:00:00\n",
      "2018-04-09 00:00:00\n",
      "2018-04-10 00:00:00\n",
      "2018-04-11 00:00:00\n",
      "2018-04-12 00:00:00\n",
      "2018-04-13 00:00:00\n",
      "2018-04-14 00:00:00\n",
      "2018-04-15 00:00:00\n",
      "2018-04-16 00:00:00\n",
      "2018-04-17 00:00:00\n",
      "2018-04-18 00:00:00\n",
      "2018-04-19 00:00:00\n",
      "2018-04-20 00:00:00\n",
      "2018-04-21 00:00:00\n",
      "2018-04-22 00:00:00\n",
      "2018-04-23 00:00:00\n",
      "2018-04-24 00:00:00\n",
      "2018-04-25 00:00:00\n",
      "2018-04-26 00:00:00\n",
      "2018-04-27 00:00:00\n",
      "2018-04-28 00:00:00\n",
      "2018-04-29 00:00:00\n",
      "2018-04-30 00:00:00\n",
      "2018-05-01 00:00:00\n",
      "2018-05-02 00:00:00\n",
      "2018-05-03 00:00:00\n",
      "2018-05-04 00:00:00\n",
      "2018-05-05 00:00:00\n",
      "2018-05-06 00:00:00\n",
      "2018-05-07 00:00:00\n",
      "2018-05-08 00:00:00\n",
      "2018-05-09 00:00:00\n",
      "2018-05-10 00:00:00\n",
      "2018-05-11 00:00:00\n",
      "2018-05-12 00:00:00\n",
      "2018-05-13 00:00:00\n",
      "2018-05-14 00:00:00\n",
      "2018-05-15 00:00:00\n",
      "2018-05-16 00:00:00\n",
      "2018-05-17 00:00:00\n",
      "2018-05-18 00:00:00\n",
      "2018-05-19 00:00:00\n",
      "2018-05-20 00:00:00\n",
      "2018-05-21 00:00:00\n",
      "2018-05-22 00:00:00\n",
      "2018-05-23 00:00:00\n",
      "2018-05-24 00:00:00\n",
      "2018-05-25 00:00:00\n",
      "2018-05-26 00:00:00\n",
      "2018-05-27 00:00:00\n",
      "2018-05-28 00:00:00\n",
      "2018-05-29 00:00:00\n",
      "2018-05-30 00:00:00\n",
      "2018-05-31 00:00:00\n",
      "2018-06-01 00:00:00\n",
      "2018-06-02 00:00:00\n",
      "2018-06-03 00:00:00\n",
      "2018-06-04 00:00:00\n",
      "2018-06-05 00:00:00\n",
      "2018-06-06 00:00:00\n",
      "2018-06-07 00:00:00\n",
      "2018-06-08 00:00:00\n",
      "2018-06-09 00:00:00\n",
      "2018-06-10 00:00:00\n",
      "2018-06-11 00:00:00\n",
      "2018-06-12 00:00:00\n",
      "2018-06-13 00:00:00\n",
      "2018-06-14 00:00:00\n",
      "2018-06-15 00:00:00\n",
      "2018-06-16 00:00:00\n",
      "2018-06-17 00:00:00\n",
      "2018-06-18 00:00:00\n",
      "2018-06-19 00:00:00\n",
      "2018-06-20 00:00:00\n",
      "2018-06-21 00:00:00\n",
      "2018-06-22 00:00:00\n",
      "2018-06-23 00:00:00\n",
      "2018-06-24 00:00:00\n",
      "2018-06-25 00:00:00\n",
      "2018-06-26 00:00:00\n",
      "2018-06-27 00:00:00\n",
      "2018-06-28 00:00:00\n",
      "2018-06-29 00:00:00\n",
      "2018-06-30 00:00:00\n",
      "2018-07-01 00:00:00\n",
      "2018-07-02 00:00:00\n",
      "2018-07-03 00:00:00\n",
      "2018-07-04 00:00:00\n",
      "2018-07-05 00:00:00\n",
      "2018-07-06 00:00:00\n",
      "2018-07-07 00:00:00\n",
      "2018-07-08 00:00:00\n",
      "2018-07-09 00:00:00\n",
      "2018-07-10 00:00:00\n",
      "2018-07-11 00:00:00\n",
      "2018-07-12 00:00:00\n",
      "2018-07-13 00:00:00\n",
      "2018-07-14 00:00:00\n",
      "2018-07-15 00:00:00\n",
      "2018-07-16 00:00:00\n",
      "2018-07-17 00:00:00\n",
      "2018-07-18 00:00:00\n",
      "2018-07-19 00:00:00\n",
      "2018-07-20 00:00:00\n",
      "2018-07-21 00:00:00\n",
      "2018-07-22 00:00:00\n",
      "2018-07-23 00:00:00\n",
      "2018-07-24 00:00:00\n",
      "2018-07-25 00:00:00\n",
      "2018-07-26 00:00:00\n",
      "2018-07-27 00:00:00\n",
      "2018-07-28 00:00:00\n",
      "2018-07-29 00:00:00\n",
      "2018-07-30 00:00:00\n",
      "2018-07-31 00:00:00\n",
      "2018-08-01 00:00:00\n",
      "2018-08-02 00:00:00\n",
      "2018-08-03 00:00:00\n",
      "2018-08-04 00:00:00\n",
      "2018-08-05 00:00:00\n",
      "2018-08-06 00:00:00\n",
      "2018-08-07 00:00:00\n",
      "2018-08-08 00:00:00\n",
      "2018-08-09 00:00:00\n",
      "2018-08-10 00:00:00\n",
      "2018-08-11 00:00:00\n",
      "2018-08-12 00:00:00\n",
      "2018-08-13 00:00:00\n",
      "2018-08-14 00:00:00\n",
      "2018-08-15 00:00:00\n",
      "2018-08-16 00:00:00\n",
      "2018-08-17 00:00:00\n",
      "2018-08-18 00:00:00\n",
      "2018-08-19 00:00:00\n",
      "2018-08-20 00:00:00\n",
      "2018-08-21 00:00:00\n",
      "2018-08-22 00:00:00\n",
      "2018-08-23 00:00:00\n",
      "2018-08-24 00:00:00\n",
      "2018-08-25 00:00:00\n",
      "2018-08-26 00:00:00\n",
      "2018-08-27 00:00:00\n",
      "2018-08-28 00:00:00\n",
      "2018-08-29 00:00:00\n",
      "2018-08-30 00:00:00\n",
      "2018-08-31 00:00:00\n",
      "2018-09-01 00:00:00\n",
      "2018-09-02 00:00:00\n",
      "2018-09-03 00:00:00\n",
      "2018-09-04 00:00:00\n",
      "2018-09-05 00:00:00\n",
      "2018-09-06 00:00:00\n",
      "2018-09-07 00:00:00\n",
      "2018-09-08 00:00:00\n",
      "2018-09-09 00:00:00\n",
      "2018-09-10 00:00:00\n",
      "2018-09-11 00:00:00\n",
      "2018-09-12 00:00:00\n",
      "2018-09-13 00:00:00\n",
      "2018-09-14 00:00:00\n",
      "2018-09-15 00:00:00\n",
      "2018-09-16 00:00:00\n",
      "2018-09-17 00:00:00\n",
      "2018-09-18 00:00:00\n",
      "2018-09-19 00:00:00\n",
      "2018-09-20 00:00:00\n",
      "2018-09-21 00:00:00\n",
      "2018-09-22 00:00:00\n",
      "2018-09-23 00:00:00\n",
      "2018-09-24 00:00:00\n",
      "2018-09-25 00:00:00\n",
      "2018-09-26 00:00:00\n",
      "2018-09-27 00:00:00\n",
      "2018-09-28 00:00:00\n",
      "2018-09-29 00:00:00\n",
      "2018-09-30 00:00:00\n",
      "2018-10-01 00:00:00\n",
      "2018-10-02 00:00:00\n",
      "2018-10-03 00:00:00\n",
      "2018-10-04 00:00:00\n",
      "2018-10-05 00:00:00\n",
      "2018-10-06 00:00:00\n",
      "2018-10-07 00:00:00\n",
      "2018-10-08 00:00:00\n",
      "2018-10-09 00:00:00\n",
      "2018-10-10 00:00:00\n",
      "2018-10-11 00:00:00\n",
      "2018-10-12 00:00:00\n",
      "2018-10-13 00:00:00\n",
      "2018-10-14 00:00:00\n",
      "2018-10-15 00:00:00\n",
      "2018-10-16 00:00:00\n",
      "2018-10-17 00:00:00\n",
      "2018-10-18 00:00:00\n",
      "2018-10-19 00:00:00\n",
      "2018-10-20 00:00:00\n",
      "2018-10-21 00:00:00\n",
      "2018-10-22 00:00:00\n",
      "2018-10-23 00:00:00\n",
      "2018-10-24 00:00:00\n",
      "2018-10-25 00:00:00\n",
      "2018-10-26 00:00:00\n",
      "2018-10-27 00:00:00\n",
      "2018-10-28 00:00:00\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2018-10-29 00:00:00\n",
      "2018-10-30 00:00:00\n",
      "2018-10-31 00:00:00\n",
      "2018-11-01 00:00:00\n",
      "2018-11-02 00:00:00\n",
      "2018-11-03 00:00:00\n",
      "2018-11-04 00:00:00\n",
      "2018-11-05 00:00:00\n",
      "2018-11-06 00:00:00\n",
      "2018-11-07 00:00:00\n",
      "2018-11-08 00:00:00\n",
      "2018-11-09 00:00:00\n",
      "2018-11-10 00:00:00\n",
      "2018-11-11 00:00:00\n",
      "2018-11-12 00:00:00\n",
      "2018-11-13 00:00:00\n",
      "2018-11-14 00:00:00\n",
      "2018-11-15 00:00:00\n",
      "2018-11-16 00:00:00\n",
      "2018-11-17 00:00:00\n",
      "2018-11-18 00:00:00\n",
      "2018-11-19 00:00:00\n",
      "2018-11-20 00:00:00\n",
      "2018-11-21 00:00:00\n",
      "2018-11-22 00:00:00\n",
      "2018-11-23 00:00:00\n",
      "2018-11-24 00:00:00\n",
      "2018-11-25 00:00:00\n",
      "2018-11-26 00:00:00\n",
      "2018-11-27 00:00:00\n",
      "2018-11-28 00:00:00\n",
      "2018-11-29 00:00:00\n",
      "2018-11-30 00:00:00\n",
      "2018-12-01 00:00:00\n",
      "2018-12-02 00:00:00\n",
      "2018-12-03 00:00:00\n",
      "2018-12-04 00:00:00\n",
      "2018-12-05 00:00:00\n",
      "2018-12-06 00:00:00\n",
      "2018-12-07 00:00:00\n",
      "2018-12-08 00:00:00\n",
      "2018-12-09 00:00:00\n",
      "2018-12-10 00:00:00\n",
      "2018-12-11 00:00:00\n",
      "2018-12-12 00:00:00\n",
      "2018-12-13 00:00:00\n",
      "2018-12-14 00:00:00\n",
      "2018-12-15 00:00:00\n",
      "2018-12-16 00:00:00\n",
      "2018-12-17 00:00:00\n",
      "2018-12-18 00:00:00\n",
      "2018-12-19 00:00:00\n",
      "2018-12-20 00:00:00\n",
      "2018-12-21 00:00:00\n",
      "2018-12-22 00:00:00\n",
      "2018-12-23 00:00:00\n",
      "2018-12-24 00:00:00\n",
      "2018-12-25 00:00:00\n",
      "2018-12-26 00:00:00\n",
      "2018-12-27 00:00:00\n",
      "2018-12-28 00:00:00\n",
      "2018-12-29 00:00:00\n",
      "2018-12-30 00:00:00\n",
      "2018-12-31 00:00:00\n",
      "2019-01-01 00:00:00\n",
      "2019-01-02 00:00:00\n",
      "2019-01-03 00:00:00\n",
      "2019-01-04 00:00:00\n",
      "2019-01-05 00:00:00\n",
      "2019-01-06 00:00:00\n",
      "2019-01-07 00:00:00\n",
      "2019-01-08 00:00:00\n",
      "2019-01-09 00:00:00\n",
      "2019-01-10 00:00:00\n",
      "2019-01-11 00:00:00\n",
      "2019-01-12 00:00:00\n",
      "2019-01-13 00:00:00\n",
      "2019-01-14 00:00:00\n",
      "2019-01-15 00:00:00\n",
      "2019-01-16 00:00:00\n",
      "2019-01-17 00:00:00\n",
      "2019-01-18 00:00:00\n",
      "2019-01-19 00:00:00\n",
      "2019-01-20 00:00:00\n",
      "2019-01-21 00:00:00\n",
      "2019-01-22 00:00:00\n",
      "2019-01-23 00:00:00\n",
      "2019-01-24 00:00:00\n",
      "2019-01-25 00:00:00\n",
      "2019-01-26 00:00:00\n",
      "2019-01-27 00:00:00\n",
      "2019-01-28 00:00:00\n",
      "2019-01-29 00:00:00\n",
      "2019-01-30 00:00:00\n",
      "2019-01-31 00:00:00\n",
      "2019-02-01 00:00:00\n",
      "2019-02-02 00:00:00\n",
      "2019-02-03 00:00:00\n",
      "2019-02-04 00:00:00\n",
      "2019-02-05 00:00:00\n",
      "2019-02-06 00:00:00\n",
      "2019-02-07 00:00:00\n",
      "2019-02-08 00:00:00\n",
      "2019-02-09 00:00:00\n",
      "2019-02-10 00:00:00\n",
      "2019-02-11 00:00:00\n",
      "2019-02-12 00:00:00\n",
      "2019-02-13 00:00:00\n",
      "2019-02-14 00:00:00\n",
      "2019-02-15 00:00:00\n",
      "2019-02-16 00:00:00\n",
      "2019-02-17 00:00:00\n",
      "2019-02-18 00:00:00\n",
      "2019-02-19 00:00:00\n",
      "2019-02-20 00:00:00\n",
      "2019-02-21 00:00:00\n",
      "2019-02-22 00:00:00\n",
      "2019-02-23 00:00:00\n",
      "2019-02-24 00:00:00\n",
      "2019-02-25 00:00:00\n",
      "2019-02-26 00:00:00\n",
      "2019-02-27 00:00:00\n",
      "2019-02-28 00:00:00\n",
      "2019-03-01 00:00:00\n",
      "2019-03-02 00:00:00\n",
      "2019-03-03 00:00:00\n",
      "2019-03-04 00:00:00\n",
      "2019-03-05 00:00:00\n",
      "2019-03-06 00:00:00\n",
      "2019-03-07 00:00:00\n",
      "2019-03-08 00:00:00\n",
      "2019-03-09 00:00:00\n",
      "2019-03-10 00:00:00\n",
      "2019-03-11 00:00:00\n",
      "2019-03-12 00:00:00\n",
      "2019-03-13 00:00:00\n",
      "2019-03-14 00:00:00\n",
      "2019-03-15 00:00:00\n",
      "2019-03-16 00:00:00\n",
      "2019-03-17 00:00:00\n",
      "2019-03-18 00:00:00\n",
      "2019-03-19 00:00:00\n",
      "2019-03-20 00:00:00\n",
      "2019-03-21 00:00:00\n",
      "2019-03-22 00:00:00\n",
      "2019-03-23 00:00:00\n",
      "2019-03-24 00:00:00\n",
      "2019-03-25 00:00:00\n",
      "2019-03-26 00:00:00\n",
      "2019-03-27 00:00:00\n",
      "2019-03-28 00:00:00\n",
      "2019-03-29 00:00:00\n",
      "2019-03-30 00:00:00\n",
      "2019-03-31 00:00:00\n",
      "2019-04-01 00:00:00\n",
      "2019-04-02 00:00:00\n",
      "2019-04-03 00:00:00\n",
      "2019-04-04 00:00:00\n",
      "2019-04-05 00:00:00\n",
      "2019-04-06 00:00:00\n",
      "2019-04-07 00:00:00\n",
      "2019-04-08 00:00:00\n",
      "2019-04-09 00:00:00\n",
      "2019-04-10 00:00:00\n",
      "2019-04-11 00:00:00\n",
      "2019-04-12 00:00:00\n",
      "2019-04-13 00:00:00\n",
      "2019-04-14 00:00:00\n",
      "2019-04-15 00:00:00\n",
      "2019-04-16 00:00:00\n",
      "2019-04-17 00:00:00\n",
      "2019-04-18 00:00:00\n",
      "2019-04-19 00:00:00\n",
      "2019-04-20 00:00:00\n",
      "2019-04-21 00:00:00\n",
      "2019-04-22 00:00:00\n",
      "2019-04-23 00:00:00\n",
      "2019-04-24 00:00:00\n",
      "2019-04-25 00:00:00\n",
      "2019-04-26 00:00:00\n",
      "2019-04-27 00:00:00\n",
      "2019-04-28 00:00:00\n",
      "2019-04-29 00:00:00\n",
      "2019-04-30 00:00:00\n",
      "2019-05-01 00:00:00\n",
      "2019-05-02 00:00:00\n",
      "2019-05-03 00:00:00\n",
      "2019-05-04 00:00:00\n",
      "2019-05-05 00:00:00\n",
      "2019-05-06 00:00:00\n",
      "2019-05-07 00:00:00\n",
      "2019-05-08 00:00:00\n",
      "2019-05-09 00:00:00\n",
      "2019-05-10 00:00:00\n",
      "2019-05-11 00:00:00\n",
      "2019-05-12 00:00:00\n",
      "2019-05-13 00:00:00\n",
      "2019-05-14 00:00:00\n",
      "2019-05-15 00:00:00\n",
      "2019-05-16 00:00:00\n",
      "2019-05-17 00:00:00\n",
      "2019-05-18 00:00:00\n",
      "2019-05-19 00:00:00\n",
      "2019-05-20 00:00:00\n",
      "2019-05-21 00:00:00\n",
      "2019-05-22 00:00:00\n",
      "2019-05-23 00:00:00\n",
      "2019-05-24 00:00:00\n",
      "2019-05-25 00:00:00\n",
      "2019-05-26 00:00:00\n",
      "2019-05-27 00:00:00\n",
      "2019-05-28 00:00:00\n",
      "2019-05-29 00:00:00\n",
      "2019-05-30 00:00:00\n",
      "2019-05-31 00:00:00\n",
      "2019-06-01 00:00:00\n",
      "2019-06-02 00:00:00\n",
      "2019-06-03 00:00:00\n",
      "2019-06-04 00:00:00\n",
      "2019-06-05 00:00:00\n",
      "2019-06-06 00:00:00\n",
      "2019-06-07 00:00:00\n",
      "2019-06-08 00:00:00\n",
      "2019-06-09 00:00:00\n",
      "2019-06-10 00:00:00\n",
      "2019-06-11 00:00:00\n",
      "2019-06-12 00:00:00\n",
      "2019-06-13 00:00:00\n",
      "2019-06-14 00:00:00\n",
      "2019-06-15 00:00:00\n",
      "2019-06-16 00:00:00\n",
      "2019-06-17 00:00:00\n",
      "2019-06-18 00:00:00\n",
      "2019-06-19 00:00:00\n",
      "2019-06-20 00:00:00\n",
      "2019-06-21 00:00:00\n",
      "2019-06-22 00:00:00\n",
      "2019-06-23 00:00:00\n",
      "2019-06-24 00:00:00\n",
      "2019-06-25 00:00:00\n",
      "2019-06-26 00:00:00\n",
      "2019-06-27 00:00:00\n",
      "2019-06-28 00:00:00\n",
      "2019-06-29 00:00:00\n",
      "2019-06-30 00:00:00\n",
      "2019-07-01 00:00:00\n",
      "2019-07-02 00:00:00\n",
      "2019-07-03 00:00:00\n",
      "2019-07-04 00:00:00\n",
      "2019-07-05 00:00:00\n",
      "2019-07-06 00:00:00\n",
      "2019-07-07 00:00:00\n",
      "2019-07-08 00:00:00\n",
      "2019-07-09 00:00:00\n",
      "2019-07-10 00:00:00\n",
      "2019-07-11 00:00:00\n",
      "2019-07-12 00:00:00\n",
      "2019-07-13 00:00:00\n",
      "2019-07-14 00:00:00\n",
      "2019-07-15 00:00:00\n",
      "2019-07-16 00:00:00\n",
      "2019-07-17 00:00:00\n",
      "2019-07-18 00:00:00\n",
      "2019-07-19 00:00:00\n",
      "2019-07-20 00:00:00\n",
      "2019-07-21 00:00:00\n",
      "2019-07-22 00:00:00\n",
      "2019-07-23 00:00:00\n",
      "2019-07-24 00:00:00\n",
      "2019-07-25 00:00:00\n",
      "2019-07-26 00:00:00\n",
      "2019-07-27 00:00:00\n",
      "2019-07-28 00:00:00\n",
      "2019-07-29 00:00:00\n",
      "2019-07-30 00:00:00\n",
      "2019-07-31 00:00:00\n",
      "2019-08-01 00:00:00\n",
      "2019-08-02 00:00:00\n",
      "2019-08-03 00:00:00\n",
      "2019-08-04 00:00:00\n",
      "2019-08-05 00:00:00\n",
      "2019-08-06 00:00:00\n",
      "2019-08-07 00:00:00\n",
      "2019-08-08 00:00:00\n",
      "2019-08-09 00:00:00\n",
      "2019-08-10 00:00:00\n",
      "2019-08-11 00:00:00\n",
      "2019-08-12 00:00:00\n",
      "2019-08-13 00:00:00\n",
      "2019-08-14 00:00:00\n",
      "2019-08-15 00:00:00\n",
      "2019-08-16 00:00:00\n",
      "2019-08-17 00:00:00\n",
      "2019-08-18 00:00:00\n",
      "2019-08-19 00:00:00\n",
      "2019-08-20 00:00:00\n",
      "2019-08-21 00:00:00\n",
      "2019-08-22 00:00:00\n",
      "2019-08-23 00:00:00\n",
      "2019-08-24 00:00:00\n",
      "2019-08-25 00:00:00\n",
      "2019-08-26 00:00:00\n",
      "2019-08-27 00:00:00\n",
      "2019-08-28 00:00:00\n",
      "2019-08-29 00:00:00\n",
      "2019-08-30 00:00:00\n",
      "2019-08-31 00:00:00\n",
      "2019-09-01 00:00:00\n",
      "2019-09-02 00:00:00\n",
      "2019-09-03 00:00:00\n",
      "2019-09-04 00:00:00\n",
      "2019-09-05 00:00:00\n",
      "2019-09-06 00:00:00\n",
      "2019-09-07 00:00:00\n",
      "2019-09-08 00:00:00\n",
      "2019-09-09 00:00:00\n",
      "2019-09-10 00:00:00\n",
      "2019-09-11 00:00:00\n",
      "2019-09-12 00:00:00\n",
      "2019-09-13 00:00:00\n",
      "2019-09-14 00:00:00\n",
      "2019-09-15 00:00:00\n",
      "2019-09-16 00:00:00\n",
      "2019-09-17 00:00:00\n",
      "2019-09-18 00:00:00\n",
      "2019-09-19 00:00:00\n",
      "2019-09-20 00:00:00\n",
      "2019-09-21 00:00:00\n",
      "2019-09-22 00:00:00\n",
      "2019-09-23 00:00:00\n",
      "2019-09-24 00:00:00\n",
      "2019-09-25 00:00:00\n",
      "2019-09-26 00:00:00\n",
      "2019-09-27 00:00:00\n",
      "2019-09-28 00:00:00\n",
      "2019-09-29 00:00:00\n",
      "2019-09-30 00:00:00\n",
      "2019-10-01 00:00:00\n",
      "2019-10-02 00:00:00\n",
      "2019-10-03 00:00:00\n",
      "2019-10-04 00:00:00\n",
      "2019-10-05 00:00:00\n",
      "2019-10-06 00:00:00\n",
      "2019-10-07 00:00:00\n",
      "2019-10-08 00:00:00\n",
      "2019-10-09 00:00:00\n",
      "2019-10-10 00:00:00\n",
      "2019-10-11 00:00:00\n",
      "2019-10-12 00:00:00\n",
      "2019-10-13 00:00:00\n",
      "2019-10-14 00:00:00\n",
      "2019-10-15 00:00:00\n",
      "2019-10-16 00:00:00\n",
      "2019-10-17 00:00:00\n",
      "2019-10-18 00:00:00\n",
      "2019-10-19 00:00:00\n",
      "2019-10-20 00:00:00\n",
      "2019-10-21 00:00:00\n",
      "2019-10-22 00:00:00\n",
      "2019-10-23 00:00:00\n",
      "2019-10-24 00:00:00\n",
      "2019-10-25 00:00:00\n",
      "2019-10-26 00:00:00\n",
      "2019-10-27 00:00:00\n",
      "2019-10-28 00:00:00\n",
      "2019-10-29 00:00:00\n",
      "2019-10-30 00:00:00\n",
      "2019-10-31 00:00:00\n",
      "2019-11-01 00:00:00\n",
      "2019-11-02 00:00:00\n",
      "2019-11-03 00:00:00\n",
      "2019-11-04 00:00:00\n",
      "2019-11-05 00:00:00\n",
      "2019-11-06 00:00:00\n",
      "2019-11-07 00:00:00\n",
      "2019-11-08 00:00:00\n",
      "2019-11-09 00:00:00\n",
      "2019-11-10 00:00:00\n",
      "2019-11-11 00:00:00\n",
      "2019-11-12 00:00:00\n",
      "2019-11-13 00:00:00\n",
      "2019-11-14 00:00:00\n",
      "2019-11-15 00:00:00\n",
      "2019-11-16 00:00:00\n",
      "2019-11-17 00:00:00\n",
      "2019-11-18 00:00:00\n",
      "2019-11-19 00:00:00\n",
      "2019-11-20 00:00:00\n",
      "2019-11-21 00:00:00\n",
      "2019-11-22 00:00:00\n",
      "2019-11-23 00:00:00\n",
      "2019-11-24 00:00:00\n",
      "2019-11-25 00:00:00\n",
      "2019-11-26 00:00:00\n",
      "2019-11-27 00:00:00\n",
      "2019-11-28 00:00:00\n",
      "2019-11-29 00:00:00\n",
      "2019-11-30 00:00:00\n",
      "2019-12-01 00:00:00\n",
      "2019-12-02 00:00:00\n",
      "2019-12-03 00:00:00\n",
      "2019-12-04 00:00:00\n",
      "2019-12-05 00:00:00\n",
      "2019-12-06 00:00:00\n",
      "2019-12-07 00:00:00\n",
      "2019-12-08 00:00:00\n",
      "2019-12-09 00:00:00\n",
      "2019-12-10 00:00:00\n",
      "2019-12-11 00:00:00\n",
      "2019-12-12 00:00:00\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2019-12-13 00:00:00\n",
      "2019-12-14 00:00:00\n",
      "2019-12-15 00:00:00\n",
      "2019-12-16 00:00:00\n",
      "2019-12-17 00:00:00\n",
      "2019-12-18 00:00:00\n",
      "2019-12-19 00:00:00\n",
      "2019-12-20 00:00:00\n",
      "2019-12-21 00:00:00\n",
      "2019-12-22 00:00:00\n",
      "2019-12-23 00:00:00\n",
      "2019-12-24 00:00:00\n",
      "2019-12-25 00:00:00\n",
      "2019-12-26 00:00:00\n",
      "2019-12-27 00:00:00\n",
      "2019-12-28 00:00:00\n",
      "2019-12-29 00:00:00\n",
      "2019-12-30 00:00:00\n",
      "2019-12-31 00:00:00\n",
      "2020-01-01 00:00:00\n",
      "2020-01-02 00:00:00\n",
      "2020-01-03 00:00:00\n",
      "2020-01-04 00:00:00\n",
      "2020-01-05 00:00:00\n",
      "2020-01-06 00:00:00\n",
      "2020-01-07 00:00:00\n",
      "2020-01-08 00:00:00\n",
      "2020-01-09 00:00:00\n",
      "2020-01-10 00:00:00\n",
      "2020-01-11 00:00:00\n",
      "2020-01-12 00:00:00\n",
      "2020-01-13 00:00:00\n",
      "2020-01-14 00:00:00\n",
      "2020-01-15 00:00:00\n",
      "2020-01-16 00:00:00\n",
      "2020-01-17 00:00:00\n",
      "2020-01-18 00:00:00\n"
     ]
    }
   ],
   "source": [
    "# define start and end day\n",
    "start_day = '2017-9-12'\n",
    "end_day = '2020-2-12'\n",
    "\n",
    "file = darksky_api_call(start_day,end_day)\n",
    "\n",
    "# comment out if you want to save the data\n",
    "# export_csv = file.to_csv (\"file_name.csv\", index = True, header=True)"
   ]
  },
  {
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}