date_data_process.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import github_config\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4033\n",
      "3907\n",
      "1172\n",
      "2018-10-23T15:37:34Z\n"
     ]
    }
   ],
   "source": [
    "#We nee to add year data to languages.csv\n",
    "\n",
    "#must do api call to Github and API call to ASCL\n",
    "\n",
    "#First, we'll start with Github\n",
    "df = pd.read_csv(\"languages.csv\")\n",
    "df = df.drop(df.columns[0], axis=1)\n",
    "print(len(df))\n",
    "\n",
    "#get rid of all the abnormal rows\n",
    "patternDel = \"^\\d*$\"\n",
    "df = df[df.Bytes.str.match(patternDel)]\n",
    "\n",
    "print(len(df))\n",
    "\n",
    "#get all the unique values of repos & author\n",
    "newdf = df[['Repo','Author']].drop_duplicates()\n",
    "print(len(newdf))\n",
    "\n",
    "#set up HTTP call\n",
    "session = requests.Session()\n",
    "session.auth = (github_config.username, github_config.password)\n",
    "\n",
    "\n",
    "#https://api.github.com/repos/{:owner}/{:repository}\n",
    "#will return json -- get the created_at field\n",
    "http_base = \"https://api.github.com/repos/\"\n",
    "\n",
    "#test run\n",
    "r = session.get(http_base+'0satoken/Eclairs')\n",
    "json = r.json()\n",
    "#print(json)\n",
    "print(json['created_at'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['2018-10-23T15:37:34Z', '2017-03-07T13:02:16Z', '2018-02-06T02:53:21Z', '2018-10-17T19:56:13Z', '2016-01-01T16:02:56Z', '2016-04-26T14:16:33Z', '2018-06-26T17:10:20Z', '2014-06-26T16:02:34Z', '2016-08-04T07:13:01Z', '2018-09-26T22:19:43Z', '2015-01-21T20:10:37Z', '2017-09-18T23:39:12Z', '2016-08-02T19:03:48Z', '2015-01-26T19:00:42Z', '2017-04-28T19:37:00Z', '2016-03-09T15:00:56Z', '2018-12-07T15:32:48Z', '2018-11-26T14:24:50Z', '2014-01-13T19:29:09Z', '2013-10-07T03:28:51Z', '2018-02-25T13:12:54Z', '2013-02-27T12:04:06Z', '2017-03-20T13:22:12Z', '2012-01-06T20:44:53Z', '2019-08-08T14:56:00Z', '2015-12-15T09:29:50Z', '2015-09-20T03:09:27Z', '2014-08-21T18:57:11Z', '2013-12-05T19:16:19Z', '2017-07-12T18:55:44Z', '2016-08-29T19:22:43Z', '2013-12-23T14:16:42Z', '2015-11-19T15:15:33Z', '2017-04-21T10:09:17Z', '2017-11-15T20:36:42Z', '2016-07-24T03:04:02Z', '2020-01-08T18:24:49Z', '2015-12-01T19:24:27Z', '2019-04-11T22:29:44Z', '2018-04-09T14:46:55Z', '2014-08-22T17:16:09Z', '2015-12-07T00:16:44Z', '2016-02-02T16:09:34Z', '2012-09-17T15:46:10Z', '2016-01-19T23:37:45Z', '2015-06-30T09:56:40Z', '2015-12-21T23:20:27Z', '2014-11-27T00:15:49Z', '2014-11-26T20:16:02Z', '2014-07-15T15:18:44Z', '2013-07-10T15:04:59Z', '2013-08-27T19:29:12Z', '2018-09-16T10:52:52Z', '2016-12-15T06:12:29Z', '2019-02-06T04:10:35Z', '2016-03-07T20:39:34Z', '2017-07-26T14:23:25Z', '2020-04-03T20:33:53Z', '2016-03-03T23:37:07Z', '2018-05-24T02:26:06Z', '2016-08-15T09:50:23Z', '2017-08-27T17:53:48Z', '2017-10-11T08:32:51Z', '2017-08-07T09:38:42Z', '2017-08-11T17:53:06Z', '2015-07-29T08:26:45Z', '2013-04-13T10:55:00Z', '2016-07-11T21:14:37Z', '2016-10-19T18:33:20Z', '2018-07-27T23:21:08Z', '2016-12-20T12:37:15Z', '2019-08-29T08:07:54Z', '2017-07-15T00:13:40Z', '2019-12-10T08:58:28Z', '2015-02-10T05:46:43Z', '2015-01-22T00:07:34Z', '2019-01-23T07:57:18Z', '2016-06-17T10:10:21Z', '2012-02-22T02:51:45Z', '2015-09-01T13:04:03Z', '2019-07-31T09:04:34Z', '2017-09-29T18:00:10Z', '2018-05-04T00:44:45Z', '2018-09-18T16:08:22Z', '2014-07-21T08:56:25Z', '2016-01-14T12:34:10Z', '2008-12-31T19:33:40Z', '2015-10-01T18:11:38Z', '2018-08-20T09:03:15Z', '2015-12-25T08:54:52Z', '2015-12-19T05:54:03Z', '2018-02-03T20:18:47Z', '2016-01-22T12:08:54Z', '2019-07-11T11:48:49Z', '2016-08-31T05:41:36Z', '2016-08-31T05:40:29Z', '2016-08-31T05:41:12Z', '2017-04-20T08:11:35Z', '2014-02-17T17:39:50Z', '2015-01-26T01:38:45Z', '2015-11-11T06:10:05Z', '2016-03-02T14:48:29Z', '2015-01-19T02:55:06Z', '2017-10-01T12:33:03Z', '2018-05-31T07:44:54Z', '2016-03-14T18:17:50Z', '2011-06-06T00:01:21Z', '2014-01-31T17:32:17Z', '2011-09-26T14:48:34Z', '2019-10-03T13:52:26Z', '2017-05-17T17:58:51Z', '2016-05-16T12:45:37Z', '2015-07-29T23:57:13Z', '2013-04-13T10:19:04Z', '2016-06-24T17:56:47Z', '2014-08-09T11:49:26Z', '2015-09-25T15:23:27Z', '2014-10-16T17:49:44Z', '2015-08-07T17:54:03Z', '2014-11-12T19:40:34Z', '2019-09-30T14:04:23Z', '2014-10-22T00:57:54Z', '2015-07-08T21:06:20Z', '2015-06-25T05:00:39Z', '2015-09-27T02:01:50Z', '2018-01-22T00:49:59Z', '2016-04-29T14:08:38Z', '2018-07-29T06:29:34Z', '2013-04-05T23:48:38Z', '2015-12-10T19:53:20Z', '2017-03-08T10:51:20Z', '2012-11-06T13:01:40Z', '2015-04-06T10:23:47Z', '2017-10-16T16:43:48Z', '2015-01-04T23:59:13Z', '2017-03-24T14:45:04Z', '2015-11-19T16:48:25Z', '2018-09-25T13:56:51Z', '2019-12-23T10:18:29Z', '2012-02-20T03:15:24Z', '2017-03-06T21:49:18Z', '2015-02-13T15:28:07Z', '2017-02-02T19:17:57Z', '2018-10-29T13:53:43Z', '2017-02-15T22:30:23Z', '2013-06-09T08:14:23Z', '2018-12-14T11:24:43Z', '2015-10-12T22:26:31Z', '2017-04-13T21:12:03Z', '2014-02-01T22:46:41Z', '2017-10-06T22:41:48Z', '2017-05-04T22:02:47Z', '2010-06-11T02:11:55Z', '2016-02-09T09:06:10Z', '2014-07-30T18:05:19Z', '2014-05-29T16:11:49Z', '2016-01-29T11:19:16Z', '2014-11-03T03:43:02Z', '2015-04-02T14:30:39Z', '2016-11-19T05:37:34Z', '2014-07-21T04:34:04Z', '2018-02-23T01:48:06Z', '2013-10-29T23:09:48Z', '2015-12-17T16:52:45Z', '2014-09-01T16:16:04Z', '2017-03-14T15:55:43Z', '2016-04-11T21:56:29Z', '2015-06-18T02:20:42Z', '2015-11-24T18:36:24Z', '2018-10-10T13:50:06Z', '2017-05-23T15:23:19Z', '2016-10-24T13:22:39Z', '2016-10-11T17:18:18Z', '2014-04-22T18:07:49Z', '2015-02-25T16:36:43Z', '2017-11-21T09:36:26Z', '2016-06-04T21:00:03Z', '2018-02-02T10:10:24Z', '2017-11-27T09:55:26Z', '2015-10-19T20:47:41Z', '2014-11-02T19:58:48Z', '2012-10-18T02:01:36Z', '2013-08-13T22:57:37Z', '2015-03-18T18:52:25Z', '2015-04-07T22:04:48Z', '2015-01-27T15:33:21Z', '2018-05-21T19:18:04Z', '2009-09-30T14:48:30Z', '2017-09-28T17:01:02Z', '2014-10-06T13:29:00Z', '2016-07-17T23:01:21Z', '2014-03-02T06:27:43Z', '2017-11-09T20:04:47Z', '2018-06-09T15:05:08Z', '2018-03-07T13:03:35Z', '2018-09-18T08:38:21Z', '2020-06-10T15:22:19Z', '2016-07-20T23:27:33Z', '2019-04-22T14:39:47Z', '2015-02-24T18:49:51Z', '2016-11-29T11:44:02Z', '2012-07-23T14:18:58Z', '2015-09-08T11:31:41Z', '2014-09-04T16:56:29Z', '2012-08-20T21:58:46Z', '2012-10-22T16:44:00Z', '2012-07-24T18:05:26Z', '2013-04-25T18:51:07Z', '2012-07-24T18:15:25Z', '2013-08-05T09:18:44Z', '2017-06-19T07:00:03Z', '2016-09-14T22:48:39Z', '2015-10-27T18:03:10Z', '2016-05-19T18:36:04Z', '2019-11-22T08:58:00Z', '2015-08-01T09:31:40Z', '2013-03-19T11:26:45Z', '2020-04-15T20:35:19Z', '2018-06-20T17:53:00Z', '2013-01-24T17:32:09Z', '2017-11-29T13:00:27Z', '2016-08-30T13:56:42Z', '2015-03-27T15:55:16Z', '2014-04-14T17:56:57Z', '2012-09-07T19:36:19Z', '2019-03-29T11:46:52Z', '2016-05-07T22:15:27Z', '2019-02-09T09:52:39Z', '2019-10-30T06:31:01Z', '2017-01-02T19:16:05Z', '2015-04-23T21:43:37Z', '2016-10-10T13:33:36Z', '2018-07-24T14:30:16Z', '2016-03-03T22:50:31Z', '2017-03-27T10:21:18Z', '2013-10-27T22:06:35Z', '2015-09-22T15:41:48Z', '2013-06-10T21:23:43Z', '2012-09-25T23:14:53Z', '2012-08-27T15:38:39Z', '2015-01-13T10:40:50Z', '2015-01-13T10:41:13Z', '2016-06-20T19:28:42Z', '2016-09-16T10:14:08Z', '2017-10-11T13:30:43Z', '2015-06-04T15:33:38Z', '2014-03-10T00:56:18Z', '2014-10-30T11:06:23Z', '2016-09-05T22:13:08Z', '2016-09-04T16:47:58Z', '2014-01-30T05:28:32Z', '2019-04-14T15:47:56Z', '2013-09-15T06:00:11Z', '2018-07-24T22:02:29Z', '2017-11-07T14:01:36Z', '2017-11-30T22:22:11Z', '2018-07-21T23:33:52Z', '2016-04-11T23:01:56Z', '2015-08-31T16:38:29Z', '2018-04-19T13:07:35Z', '2013-05-16T17:52:30Z', '2016-11-15T18:05:49Z', '2015-02-18T13:11:29Z', '2015-04-16T19:43:53Z', '2016-11-17T17:20:02Z', '2019-09-15T16:48:09Z', '2018-04-06T09:59:31Z', '2020-07-03T10:52:35Z', '2016-05-25T21:34:40Z', '2016-08-18T15:10:28Z', '2014-11-24T20:42:43Z', '2017-07-27T10:27:47Z', '2018-08-26T18:18:12Z', '2015-01-21T02:40:36Z', '2017-11-25T23:53:15Z', '2019-01-31T13:35:39Z', '2016-08-16T14:25:08Z', '2013-08-18T04:14:24Z', '2019-03-26T15:06:41Z', '2014-09-26T08:54:18Z', '2020-03-16T08:06:22Z', '2015-11-22T22:20:32Z', '2018-08-23T12:19:35Z', '2018-04-09T18:10:11Z', '2020-01-13T17:07:49Z', '2018-04-18T09:32:16Z', '2019-02-14T18:44:17Z', '2019-06-27T19:35:10Z', '2013-05-14T17:01:18Z', '2017-05-11T00:35:29Z', '2015-02-20T17:25:31Z', '2015-07-29T11:51:10Z', '2018-05-23T09:27:42Z', '2017-08-05T07:05:58Z', '2017-11-22T05:05:46Z', '2013-10-05T14:59:14Z', '2014-11-19T08:10:36Z', '2013-03-18T02:46:39Z', '2018-04-05T11:37:02Z', '2015-07-28T20:33:02Z', '2015-07-29T07:18:43Z', '2015-07-30T13:56:29Z', '2015-07-30T08:00:31Z', '2017-04-07T15:35:31Z', '2015-07-30T14:09:44Z', '2015-07-16T18:25:49Z', '2015-07-30T07:28:48Z', '2017-07-08T05:02:06Z', '2015-01-28T02:03:35Z', '2016-03-11T17:40:38Z', '2013-01-16T15:12:37Z', '2017-10-25T09:20:12Z', '2016-01-11T08:24:37Z', '2015-10-09T16:21:51Z', '2018-05-06T20:50:49Z', '2018-09-30T18:13:00Z', '2019-04-03T18:23:47Z', '2019-11-01T18:38:38Z', '2015-11-03T02:03:50Z', '2013-06-28T07:45:34Z', '2015-04-27T22:00:00Z', '2012-06-25T20:52:07Z', '2013-10-07T13:05:51Z', '2015-01-09T21:43:58Z', '2011-10-25T02:39:28Z', '2013-06-22T13:24:39Z', '2011-10-14T16:11:38Z', '2018-03-14T21:15:31Z', '2015-07-23T16:36:54Z', '2015-05-13T20:33:15Z', '2012-08-06T19:14:28Z', '2020-05-29T18:48:40Z', '2017-06-29T12:29:27Z', '2016-07-19T04:11:56Z', '2016-11-22T19:47:21Z', '2018-07-02T23:29:46Z', '2018-08-17T11:38:33Z', '2017-07-24T15:56:59Z', '2017-07-18T13:01:37Z', '2013-09-17T19:04:58Z', '2013-12-29T01:42:11Z', '2017-12-01T02:44:16Z', '2012-03-27T18:16:01Z', '2015-08-31T23:32:16Z', '2017-07-25T18:34:51Z', '2015-06-24T08:25:08Z', '2015-06-23T09:23:27Z', '2015-09-04T08:04:55Z', '2015-09-04T07:58:03Z', '2014-02-13T16:54:12Z', '2018-07-08T08:45:37Z', '2018-07-01T19:34:18Z', '2013-06-28T10:23:53Z', '2016-12-16T12:16:13Z', '2016-09-05T13:52:49Z', '2013-07-16T17:31:39Z', '2013-02-22T16:26:16Z', '2016-08-01T19:38:47Z', '2018-10-31T18:23:33Z', '2015-04-21T19:43:37Z', '2018-05-11T19:08:29Z', '2013-08-21T11:30:21Z', '2016-03-15T15:44:03Z', '2016-05-02T08:18:49Z', '2015-01-07T09:52:40Z', '2013-12-09T16:46:37Z', '2017-05-07T19:45:01Z', '2017-03-20T13:03:41Z', '2020-04-02T02:40:16Z', '2019-04-25T15:09:52Z', '2015-01-20T08:11:34Z', '2014-12-08T15:14:12Z', '2017-06-08T06:24:32Z', '2015-12-21T14:12:47Z', '2020-01-15T09:32:07Z', '2016-07-13T16:55:27Z', '2017-10-26T16:19:27Z', '2019-07-31T18:49:32Z', '2017-05-09T18:03:53Z', '2015-03-13T06:09:39Z', '2017-04-26T13:11:33Z', '2018-05-02T12:59:21Z', '2017-10-03T14:41:53Z', '2016-09-18T09:10:01Z', '2016-04-15T10:38:11Z', '2017-12-03T10:12:44Z', '2012-06-25T05:36:05Z', '2013-05-04T02:30:48Z', '2012-03-08T10:50:44Z', '2016-04-28T19:02:11Z', '2018-04-19T08:05:19Z', '2016-06-15T18:19:24Z', '2017-10-07T17:59:51Z', '2016-08-02T16:23:55Z', '2019-01-10T03:47:57Z', '2014-10-05T22:23:13Z', '2016-02-29T19:47:51Z', '2017-06-30T14:55:20Z', '2012-06-09T21:31:22Z', '2017-06-14T10:17:30Z', '2016-09-12T19:33:06Z', '2019-03-18T16:51:42Z', '2016-07-05T17:23:27Z', '2017-05-15T13:58:01Z', '2015-03-31T06:27:52Z', '2015-03-06T16:42:18Z', '2012-06-21T19:37:29Z', '2017-01-18T20:23:51Z', '2019-01-31T22:18:21Z', '2015-04-16T20:10:57Z', '2018-06-23T19:03:36Z', '2015-04-19T16:54:53Z', '2016-08-11T17:24:30Z', '2016-01-29T07:10:59Z', '2016-02-17T15:27:03Z', '2015-09-22T16:58:48Z', '2014-07-14T02:51:24Z', '2018-11-13T18:09:51Z', '2019-07-09T19:44:57Z', '2018-03-05T09:05:36Z', '2016-06-27T21:38:54Z', '2017-08-11T22:03:04Z', '2014-03-15T22:07:22Z', '2014-04-11T23:12:51Z', '2017-05-25T20:08:07Z', '2017-03-12T02:31:53Z', '2015-05-20T15:26:59Z', '2015-06-08T23:11:14Z', '2014-04-17T20:46:30Z', '2014-03-05T15:25:40Z', '2019-04-29T08:39:36Z', '2015-03-11T15:30:14Z', '2016-07-27T15:07:10Z', '2015-05-08T14:40:44Z', '2016-07-18T08:56:32Z', '2016-07-18T08:54:52Z', '2019-01-20T15:59:16Z', '2019-09-17T14:49:02Z', '2015-02-12T13:00:38Z', '2014-02-24T18:28:03Z', '2016-11-14T06:00:47Z', '2016-01-02T13:08:59Z', '2015-07-22T17:04:42Z', '2016-12-01T03:19:18Z', '2019-01-10T18:14:10Z', '2018-05-23T05:20:54Z', '2019-01-25T18:16:49Z', '2014-07-01T14:25:25Z', '2015-03-17T16:34:47Z', '2015-10-19T12:00:28Z', '2018-05-03T05:20:10Z', '2015-11-30T20:29:25Z', '2016-10-17T09:32:08Z', '2015-11-25T01:54:42Z', '2015-05-21T06:18:34Z', '2019-05-29T00:24:41Z', '2017-01-03T11:02:10Z', '2015-07-07T19:06:23Z', '2015-07-07T15:33:09Z', '2015-08-06T05:23:29Z', '2015-07-08T15:08:05Z', '2017-01-03T15:40:20Z', '2017-01-03T15:31:31Z', '2015-06-05T15:38:34Z', '2015-04-28T05:54:28Z', '2019-02-12T08:25:55Z', '2018-09-11T16:09:44Z', '2020-04-21T21:26:10Z', '2017-12-18T16:42:24Z', '2013-07-08T18:34:22Z', '2012-08-22T11:41:56Z', '2017-01-19T19:25:11Z', '2019-01-14T20:59:03Z', '2016-07-18T12:33:37Z', '2012-09-06T18:51:44Z', '2013-11-20T16:10:49Z', '2013-01-23T21:03:00Z', '2013-04-10T15:20:53Z', '2013-08-26T14:32:35Z', '2016-11-11T19:35:48Z', '2017-09-12T16:28:19Z', '2015-11-12T14:25:31Z', '2018-07-26T18:16:33Z', '2018-01-30T02:18:45Z', '2016-07-28T15:31:57Z', '2016-08-28T20:03:07Z', '2018-11-13T21:34:18Z', '2013-07-02T19:17:27Z', '2016-10-31T21:42:31Z', '2018-07-11T13:19:00Z', '2012-05-24T20:24:57Z', '2013-06-05T10:42:50Z', '2015-10-15T19:21:37Z', '2014-01-17T21:56:32Z', '2012-12-17T06:23:00Z', '2018-09-24T11:59:16Z', '2019-01-22T03:37:03Z', '2014-10-13T01:38:17Z', '2019-08-26T17:13:19Z', '2012-01-25T23:32:24Z', '2016-11-12T20:18:04Z', '2012-05-17T03:50:51Z', '2012-03-09T18:06:08Z', '2013-10-30T21:13:17Z', '2014-02-17T20:17:47Z', '2013-06-12T13:25:09Z', '2015-06-01T16:51:37Z', '2014-06-20T22:21:26Z', '2013-12-05T14:30:38Z', '2013-11-29T23:01:39Z', '2019-02-06T22:38:00Z', '2016-04-26T15:45:51Z', '2014-10-03T18:38:03Z', '2016-02-04T08:02:58Z', '2016-04-01T08:04:30Z', '2015-04-23T08:43:46Z', '2014-06-26T02:04:56Z', '2013-05-24T02:52:14Z', '2014-11-27T03:19:34Z', '2015-10-26T17:30:07Z', '2013-05-31T18:07:22Z', '2012-10-09T02:25:52Z', '2016-02-05T20:31:52Z', '2018-03-06T15:55:46Z', '2018-11-13T00:05:50Z', '2017-03-10T19:36:40Z', '2012-05-17T06:46:18Z', '2015-12-09T21:46:21Z', '2014-08-29T07:46:55Z', '2013-04-14T02:22:04Z', '2013-12-03T20:16:34Z', '2018-10-11T17:54:00Z', '2014-11-24T16:50:45Z', '2018-02-27T08:39:13Z', '2018-02-11T10:40:05Z', '2017-12-13T17:56:28Z', '2016-07-01T00:43:29Z', '2012-12-12T22:26:41Z', '2018-03-22T16:19:13Z', '2017-10-16T10:04:18Z', '2016-03-15T12:38:50Z', '2011-01-24T17:48:00Z', '2013-12-27T04:21:00Z', '2017-06-13T00:12:04Z', '2017-03-21T23:13:54Z', '2018-02-16T00:43:05Z', '2015-08-28T22:57:52Z', '2016-11-08T00:37:36Z', '2013-07-26T19:49:14Z', '2013-07-12T14:23:15Z', '2018-09-14T23:07:24Z', '2013-11-09T22:50:03Z', '2015-01-29T21:16:04Z', '2016-12-15T21:22:06Z', '2015-11-19T20:32:58Z', '2015-02-08T18:24:10Z', '2014-03-14T20:06:27Z', '2014-11-10T19:37:42Z', '2013-07-14T01:39:41Z', '2017-12-30T16:59:57Z', '2015-01-23T11:05:34Z', '2015-03-12T16:58:08Z', '2015-01-23T10:49:19Z', '2016-12-06T21:12:07Z', '2018-06-20T19:40:54Z', '2012-12-12T00:27:14Z', '2020-03-04T23:46:21Z', '2020-03-04T23:49:33Z', '2014-06-13T18:24:56Z', '2014-04-30T14:57:18Z', '2015-02-03T13:10:33Z', '2013-10-17T10:24:32Z', '2018-11-23T12:18:23Z', '2018-11-14T14:51:57Z', '2019-08-28T09:11:20Z', '2018-10-29T15:28:04Z', '2019-03-28T11:05:38Z', '2015-10-17T08:22:33Z', '2018-02-14T23:56:04Z', '2014-06-16T05:01:17Z', '2013-08-05T16:58:09Z', '2019-01-16T05:45:19Z', '2019-11-28T09:21:49Z', '2015-07-08T09:22:41Z', '2013-11-29T09:37:55Z', '2014-01-29T12:49:16Z', '2019-04-30T09:54:51Z', '2011-10-20T15:08:45Z', '2018-12-31T19:22:04Z', '2013-11-10T11:11:47Z', '2015-12-02T15:25:05Z', '2014-10-10T15:13:00Z', '2014-10-10T15:08:12Z', '2019-05-20T13:18:01Z', '2015-03-14T15:51:39Z', '2017-02-20T13:19:20Z', '2016-03-25T01:26:03Z', '2015-09-09T02:06:34Z', '2011-12-06T07:15:21Z', '2013-05-15T07:50:40Z', '2017-02-25T22:08:51Z', '2015-04-21T02:08:02Z', '2016-04-08T14:17:48Z', '2015-10-09T15:35:50Z', '2015-10-09T16:36:00Z', '2016-12-04T19:12:40Z', '2017-07-24T08:44:18Z', '2015-03-06T23:21:18Z', '2016-05-12T08:54:04Z', '2014-11-19T23:19:37Z', '2011-05-18T20:58:54Z', '2015-02-24T15:23:04Z', '2016-03-07T22:17:25Z', '2012-01-27T20:37:37Z', '2014-05-23T00:11:42Z', '2017-10-25T12:48:36Z', '2012-10-31T22:14:00Z', '2016-05-22T20:43:50Z', '2016-05-16T02:21:42Z', '2016-09-09T15:37:55Z', '2018-04-15T07:04:19Z', '2018-03-29T06:41:58Z', '2015-03-03T12:19:19Z', '2013-05-10T10:11:04Z', '2014-12-15T10:20:48Z', '2018-11-27T21:12:01Z', '2019-03-14T20:39:08Z', '2019-06-20T20:20:36Z', '2019-02-07T16:25:10Z', '2011-07-02T13:11:31Z', '2017-11-30T09:12:25Z', '2019-08-14T20:24:04Z', '2015-03-19T13:40:15Z', '2017-10-14T01:40:28Z', '2015-11-30T15:24:18Z', '2017-03-09T14:31:01Z', '2015-08-31T11:29:54Z', '2016-01-07T15:33:50Z', '2018-12-13T19:31:06Z', '2018-09-11T18:09:09Z', '2019-02-23T17:24:58Z', '2019-02-05T12:55:26Z', '2017-09-30T21:49:58Z', '2019-07-27T16:29:35Z', '2014-06-25T03:49:54Z', '2013-06-20T18:36:40Z', '2012-11-24T11:08:39Z', '2015-03-09T14:13:54Z', '2014-12-08T22:32:44Z', '2015-09-25T12:24:53Z', '2014-10-20T17:34:39Z', '2016-10-08T04:37:44Z', '2013-07-24T13:14:29Z', '2010-03-01T17:13:28Z', '2017-06-05T01:17:16Z', '2018-04-25T17:26:17Z', '2013-11-26T08:18:05Z', '2016-10-29T22:30:40Z', '2015-11-20T17:56:30Z', '2018-09-11T08:45:53Z', '2015-06-04T20:28:56Z', '2016-09-09T19:32:38Z', '2016-01-28T20:05:33Z', '2011-10-10T09:52:07Z', '2016-03-16T13:39:57Z', '2018-09-17T16:41:11Z', '2018-12-04T02:19:28Z', '2015-08-07T12:52:26Z', '2015-11-03T11:37:38Z', '2018-09-19T08:34:50Z', '2015-04-07T07:12:50Z', '2016-08-12T08:02:22Z', '2015-11-11T14:11:53Z', '2017-09-18T13:49:44Z', '2017-01-26T11:04:02Z', '2017-07-19T18:25:43Z', '2018-05-30T19:24:43Z', '2016-07-02T13:03:36Z', '2013-09-20T19:24:03Z', '2018-07-27T14:26:10Z', '2015-06-18T09:57:57Z', '2015-06-18T11:16:24Z', '2015-12-06T00:38:05Z', '2017-01-16T13:23:17Z', '2015-11-10T20:37:44Z', '2017-02-16T15:24:18Z', '2017-11-23T14:01:06Z', '2016-12-13T15:57:26Z', '2012-01-24T16:23:26Z', '2014-03-20T19:57:50Z', '2015-03-24T19:49:08Z', '2013-11-20T11:44:59Z', '2016-03-30T14:35:00Z', '2017-02-07T14:06:24Z', '2012-05-08T16:20:56Z', '2015-12-02T19:34:32Z', '2013-02-19T18:26:59Z', '2013-10-02T19:17:52Z', '2017-12-09T20:18:06Z', '2018-01-27T07:59:51Z', '2011-11-29T04:08:12Z', '2016-11-30T10:04:17Z', '2016-04-06T15:37:29Z', '2015-08-18T12:55:53Z', '2019-04-22T20:04:59Z', '2018-01-09T11:30:20Z', '2017-11-28T10:34:53Z', '2017-10-11T17:15:11Z', '2013-11-13T03:03:50Z', '2015-08-12T22:08:03Z', '2014-01-17T22:37:24Z', '2011-09-13T03:20:30Z', '2013-11-23T22:57:28Z', '2011-11-11T00:38:51Z', '2016-12-06T15:35:08Z', '2015-11-17T22:08:51Z', '2015-10-21T22:50:34Z', '2015-04-22T19:33:02Z', '2016-05-13T15:39:58Z', '2017-06-22T14:23:18Z', '2014-03-26T18:04:35Z', '2013-06-26T22:02:56Z', '2017-05-02T02:03:54Z', '2013-09-12T12:29:47Z', '2018-03-05T00:02:50Z', '2017-03-30T21:42:55Z', '2017-01-31T18:18:15Z', '2014-08-06T19:06:00Z', '2014-05-08T17:36:44Z', '2014-11-14T03:29:14Z', '2015-03-23T06:42:48Z', '2015-12-04T14:15:02Z', '2017-06-30T15:01:07Z', '2011-08-29T12:40:35Z', '2018-03-09T17:30:32Z', '2018-04-03T19:25:33Z', '2013-09-16T10:37:51Z', '2013-10-05T20:21:40Z', '2016-04-04T07:53:00Z', '2018-01-31T19:06:29Z', '2011-11-20T22:56:13Z', '2019-08-26T17:30:33Z', '2016-07-25T03:32:22Z', '2017-09-13T11:28:43Z', '2018-10-26T08:59:49Z', '2015-07-28T19:04:30Z', '2012-11-03T20:34:27Z', '2014-03-07T22:17:55Z', '2015-07-28T20:31:49Z', '2013-12-12T09:21:31Z', '2014-05-18T13:09:51Z', '2015-03-28T00:35:42Z', '2015-04-27T20:46:14Z', '2013-12-11T16:28:45Z', '2017-09-02T16:15:39Z', '2019-02-28T16:26:40Z', '2014-05-16T20:25:03Z', '2017-03-03T18:50:30Z', '2018-05-31T02:35:48Z', '2017-03-03T19:21:17Z', '2019-04-02T19:48:54Z', '2019-02-13T08:51:21Z', '2017-10-13T22:04:05Z', '2016-11-02T22:58:41Z', '2017-10-19T13:49:48Z', '2016-11-26T11:48:47Z', '2015-10-07T15:48:51Z', '2013-08-10T16:46:55Z', '2013-11-22T16:38:58Z', '2015-03-09T02:27:15Z', '2016-05-25T17:02:16Z', '2016-10-15T03:42:51Z', '2018-08-30T20:52:08Z', '2014-11-07T07:59:20Z', '2015-05-26T16:16:16Z', '2014-02-10T18:04:41Z', '2014-09-25T17:14:19Z', '2018-09-07T14:42:35Z', '2015-03-04T10:36:53Z', '2012-06-25T16:28:25Z', '2014-07-10T12:23:27Z', '2013-03-12T06:44:10Z', '2019-02-07T15:43:10Z', '2018-03-27T08:18:03Z', '2017-03-27T05:13:10Z', '2016-07-19T14:44:31Z', '2015-08-31T11:05:05Z', '2015-09-30T05:07:04Z', '2018-07-02T13:25:43Z', '2015-02-04T02:17:11Z', '2014-06-27T16:41:45Z', '2013-04-01T20:25:11Z', '2012-10-09T23:11:50Z', '2015-08-15T20:15:19Z', '2013-07-24T12:06:11Z', '2018-11-20T16:54:16Z', '2018-05-31T12:30:45Z', '2016-06-09T15:41:01Z', '2016-10-13T13:38:33Z', '2017-11-15T11:27:08Z', '2015-05-13T13:06:18Z', '2017-03-03T10:06:33Z', '2017-02-05T20:08:11Z', '2014-01-28T01:04:29Z', '2018-08-16T14:34:01Z', '2016-07-29T05:43:04Z', '2019-07-12T20:05:15Z', '2016-06-15T08:24:17Z', '2017-04-14T04:43:12Z', '2019-09-09T18:44:16Z', '2014-04-09T23:07:18Z', '2014-04-27T22:07:50Z', '2015-02-06T22:46:56Z', '2016-03-02T05:23:22Z', '2015-02-20T18:04:08Z', '2014-11-06T00:31:54Z', '2015-12-14T01:03:09Z', '2017-05-15T13:38:58Z', '2015-12-02T08:36:52Z', '2016-03-03T02:58:46Z', '2017-01-24T14:53:57Z', '2016-03-14T21:31:09Z', '2018-09-03T07:19:26Z', '2019-12-17T15:08:46Z', '2015-08-31T19:38:01Z', '2014-03-05T17:30:19Z', '2018-11-21T20:32:42Z', '2017-05-04T09:41:13Z', '2019-04-03T17:40:37Z', '2019-05-01T14:49:54Z', '2016-06-17T18:19:15Z', '2016-09-07T23:24:29Z', '2012-04-09T22:01:33Z', '2011-02-15T22:05:43Z', '2014-05-27T15:13:36Z', '2015-01-12T06:18:21Z', '2019-04-04T17:18:53Z', '2013-09-03T22:35:04Z', '2019-03-06T14:20:13Z', '2013-04-10T14:22:16Z', '2016-03-15T21:31:37Z', '2018-12-19T21:06:53Z', '2017-12-04T10:48:45Z', '2013-10-15T22:31:26Z', '2012-05-02T19:09:02Z', '2016-11-29T21:41:14Z', '2019-11-07T20:25:37Z', '2011-07-12T08:50:37Z', '2013-03-22T14:11:15Z', '2019-03-01T13:58:07Z', '2018-08-25T18:00:29Z', '2013-06-18T19:04:06Z', '2011-12-21T10:27:33Z', '2018-03-05T22:42:03Z', '2016-03-16T14:26:11Z', '2017-02-20T15:57:29Z', '2017-09-29T17:17:02Z', '2016-11-17T17:07:27Z', '2015-06-15T02:10:21Z', '2017-07-26T14:48:09Z', '2016-02-02T19:01:36Z', '2019-07-03T15:50:47Z', '2017-08-31T15:42:10Z', '2017-11-28T20:55:04Z', '2012-06-18T18:41:19Z', '2017-09-25T20:46:23Z', '2017-02-24T19:59:30Z', '2017-12-12T01:45:00Z', '2017-10-06T22:15:13Z', '2014-07-04T04:32:11Z', '2013-12-04T22:21:19Z', '2017-01-17T19:57:47Z', '2019-09-10T20:15:18Z', '2016-09-02T16:17:25Z', '2017-12-07T16:34:06Z', '2014-10-28T17:26:17Z', '2013-09-06T01:05:39Z', '2020-05-14T17:46:50Z', '2015-11-14T19:28:07Z', '2018-11-27T08:13:50Z', '2015-11-13T23:36:00Z', '2015-01-30T18:48:08Z', '2015-02-17T15:56:04Z', '2014-06-12T06:23:01Z', '2018-05-15T04:07:23Z', '2014-05-01T04:52:26Z', '2013-12-27T04:50:28Z', '2017-07-05T06:57:52Z', '2014-05-19T17:55:35Z', '2019-07-18T08:33:16Z', '2015-02-23T19:40:58Z', '2016-07-21T09:05:58Z', '2015-07-23T17:24:59Z', '2018-01-27T09:47:39Z', '2014-05-30T21:30:18Z', '2019-04-10T15:16:15Z', '2015-05-20T18:43:54Z', '2017-06-08T16:27:41Z', '2018-04-04T11:42:10Z', '2016-07-28T03:49:16Z', '2010-09-13T09:24:24Z', '2018-12-21T23:58:33Z', '2017-11-02T18:30:24Z', '2019-06-13T13:54:04Z', '2018-09-14T15:17:47Z', '2015-06-15T22:44:25Z', '2017-02-10T14:26:30Z', '2017-02-10T15:41:49Z', '2013-10-02T21:19:30Z', '2015-03-14T20:42:29Z', '2017-05-23T22:47:45Z', '2012-04-20T19:41:30Z', '2016-03-14T08:47:49Z', '2016-04-24T14:17:50Z', '2014-03-27T19:08:31Z', '2018-08-25T13:41:51Z', '2017-04-20T14:37:13Z', '2018-04-11T13:11:06Z', '2018-01-31T22:19:00Z', '2017-08-25T12:05:48Z', '2017-11-15T17:29:44Z', '2018-06-20T07:06:58Z', '2015-11-03T01:27:38Z', '2009-10-26T00:41:12Z', '2013-03-20T03:56:41Z', '2016-02-29T18:54:45Z', '2014-10-28T22:59:10Z', '2016-04-04T22:49:48Z', '2017-11-22T15:10:21Z', '2017-01-11T13:15:08Z', '2019-09-24T17:04:46Z', '2013-06-14T11:31:14Z', '2016-12-13T15:29:09Z', '2018-12-11T10:33:55Z', '2015-09-14T08:21:34Z', '2015-09-14T09:11:00Z', '2015-08-12T09:04:25Z', '2015-01-22T23:24:48Z', '2013-07-04T22:32:41Z', '2012-04-23T18:05:53Z', '2017-05-05T15:38:16Z', '2015-12-05T23:37:24Z', '2017-05-08T05:52:22Z', '2015-05-28T09:34:06Z', '2011-11-08T12:14:16Z', '2017-12-29T06:56:35Z', '2017-09-13T09:32:34Z', '2015-02-20T17:12:00Z', '2009-05-05T09:43:50Z', '2017-02-08T12:47:50Z', '2013-05-14T15:46:59Z', '2017-10-06T10:07:07Z', '2015-06-05T22:25:37Z', '2015-04-05T18:04:29Z', '2012-10-07T22:12:19Z', '2017-01-05T09:14:59Z', '2017-03-29T03:58:58Z', '2016-09-04T23:30:04Z', '2015-12-17T02:56:30Z', '2013-09-23T21:22:17Z', '2014-04-14T15:33:50Z', '2017-01-04T21:16:02Z', '2016-08-12T00:54:17Z', '2017-11-21T22:35:16Z', '2015-03-16T17:38:53Z', '2019-01-20T21:43:26Z', '2017-03-21T10:02:25Z', '2016-03-22T13:07:07Z', '2014-12-17T15:14:24Z', '2017-11-14T14:17:07Z', '2017-05-08T14:21:07Z', '2014-12-03T15:33:38Z', '2016-07-15T21:01:44Z', '2016-01-18T22:31:43Z', '2019-09-22T19:06:56Z', '2013-02-26T20:27:34Z', '2018-08-08T00:53:50Z', '2018-06-29T07:53:37Z', '2015-02-25T21:41:47Z', '2018-09-11T19:40:06Z', '2017-12-24T09:38:00Z', '2019-12-02T17:56:14Z', '2014-07-22T19:19:26Z', '2015-04-24T20:16:40Z', '2014-10-27T11:56:41Z', '2018-04-23T16:28:45Z', '2016-04-19T16:59:59Z', '2017-05-09T23:33:16Z', '2018-02-07T13:54:20Z', '2017-09-30T07:13:08Z', '2017-12-07T06:40:17Z', '2016-08-27T02:19:23Z', '2014-05-15T00:17:07Z', '2013-06-07T18:14:57Z', '2019-04-20T15:03:11Z', '2013-07-19T03:50:41Z', '2013-11-23T00:42:53Z', '2013-04-20T14:30:57Z', '2018-05-14T18:40:23Z', '2014-09-03T13:02:14Z', '2012-05-01T18:24:57Z', '2014-11-20T11:12:57Z', '2015-07-10T23:41:45Z', '2018-02-16T13:56:01Z', '2014-12-11T14:28:00Z', '2012-03-22T04:32:44Z', '2014-07-06T18:44:49Z', '2018-01-12T17:13:15Z', '2014-03-21T20:59:33Z', '2014-03-07T19:19:58Z', '2010-08-17T09:43:38Z', '2014-01-31T21:55:29Z', '2013-02-05T15:21:35Z', '2017-11-13T11:22:42Z', '2018-07-17T18:33:25Z', '2015-12-07T23:48:57Z', '2014-05-18T17:29:27Z', '2015-10-27T12:57:59Z', '2015-03-28T15:01:30Z', '2017-12-04T07:12:47Z', '2017-01-05T12:28:01Z', '2018-06-18T10:46:27Z', '2015-12-03T16:37:55Z', '2016-03-17T20:45:27Z', '2016-03-17T21:12:02Z', '2014-03-20T10:53:04Z', '2017-06-27T17:11:05Z', '2017-10-07T13:56:19Z', '2018-04-20T15:21:01Z', '2011-10-03T14:57:18Z', '2014-04-14T21:13:46Z', '2017-02-02T22:01:06Z', '2015-03-02T21:36:39Z', '2017-11-25T20:46:11Z', '2016-06-07T12:37:41Z', '2016-04-19T07:06:38Z', '2014-04-15T16:16:07Z', '2014-08-25T13:04:09Z', '2013-06-11T09:29:36Z', '2013-01-30T21:19:21Z', '2017-02-17T00:34:43Z', '2011-01-07T12:08:23Z', '2014-11-19T09:44:10Z', '2016-04-25T20:49:59Z', '2019-01-21T22:23:07Z', '2012-11-29T22:22:17Z', '2019-07-22T12:39:08Z', '2017-05-10T15:34:19Z', '2017-04-11T14:01:06Z', '2017-07-26T20:02:29Z', '2012-02-29T12:22:46Z', '2011-12-17T15:51:11Z', '2012-10-28T21:06:48Z', '2011-10-14T18:44:47Z', '2018-05-25T17:57:52Z', '2016-02-18T23:18:44Z', '2015-02-16T21:11:39Z', '2016-02-08T08:15:33Z', '2015-10-19T19:47:51Z', '2019-09-05T13:18:44Z', '2013-08-27T17:09:25Z', '2013-05-14T17:52:00Z', '2012-11-12T15:03:39Z', '2013-04-08T03:54:22Z', '2015-10-27T05:11:51Z', '2016-10-27T06:11:23Z', '2017-10-19T05:31:02Z', '2020-01-23T23:59:45Z', '2016-11-30T00:54:11Z', '2018-07-13T21:08:46Z', '2017-12-22T06:02:51Z', '2015-01-01T10:58:27Z', '2018-03-13T13:48:00Z', '2015-11-13T00:39:46Z', '2012-09-07T15:10:45Z', '2011-12-08T06:20:19Z', '2019-02-08T07:27:20Z', '2018-01-15T12:29:44Z', '2015-06-28T22:15:32Z', '2015-05-26T17:14:48Z', '2016-04-30T22:36:42Z', '2014-10-06T00:03:32Z', '2015-06-11T16:40:23Z', '2017-06-06T10:16:31Z', '2018-02-13T17:34:39Z', '2012-06-21T11:31:46Z', '2018-02-28T16:52:43Z', '2017-12-21T12:51:18Z', '2015-09-21T01:12:56Z', '2016-08-12T17:49:20Z', '2016-06-13T18:09:55Z', '2017-07-22T01:07:25Z', '2017-07-22T01:20:32Z', '2017-07-22T01:20:05Z', '2012-03-15T23:59:40Z', '2014-05-02T15:14:25Z', '2015-01-20T19:57:52Z', '2015-01-14T12:06:24Z', '2015-01-14T11:53:57Z', '2012-11-16T18:49:48Z', '2012-11-27T14:52:05Z', '2012-11-19T19:15:14Z', '2020-02-06T04:38:41Z', '2018-10-23T19:21:07Z', '2016-06-26T00:25:25Z', '2015-06-23T17:46:55Z', '2016-01-05T21:52:45Z', '2015-10-14T23:56:40Z', '2017-12-11T20:25:22Z', '2019-05-09T20:50:46Z', '2018-02-19T22:46:40Z', '2018-02-05T19:40:05Z', '2018-02-19T15:10:04Z', '2017-05-24T10:19:27Z', '2012-05-21T12:01:49Z', '2012-04-14T14:16:09Z', '2015-03-14T17:54:44Z', '2012-01-26T23:44:58Z', '2016-05-25T22:51:29Z', '2017-07-05T18:53:08Z', '2017-11-30T18:30:25Z', '2016-03-11T20:25:17Z', '2016-07-22T19:21:26Z', '2018-09-20T18:54:27Z', '2016-06-15T19:42:52Z', '2017-01-26T21:34:26Z', '2018-10-08T09:27:42Z', '2019-02-05T16:01:09Z', '2015-03-17T11:51:05Z', '2016-12-07T15:08:16Z', '2017-12-13T14:22:14Z', '2012-05-10T22:20:45Z', '2014-09-27T09:44:42Z', '2018-03-06T14:08:23Z', '2014-03-28T23:31:31Z', '2012-04-18T01:39:35Z', '2015-05-18T05:34:22Z', '2013-08-06T13:12:39Z', '2018-08-18T01:10:51Z', '2016-12-10T17:42:50Z', '2015-09-09T13:39:38Z', '2015-05-24T22:25:13Z', '2012-06-04T17:49:42Z', '2018-04-08T22:12:43Z', '2012-04-11T08:28:17Z', '2019-03-14T16:52:11Z', '2017-08-21T11:58:31Z', '2013-05-08T09:46:55Z', '2018-10-31T21:09:27Z', '2017-07-31T11:02:30Z', '2020-02-08T21:27:53Z', '2019-04-18T06:47:09Z', '2015-12-09T17:08:04Z', '2014-04-28T19:43:27Z', '2015-04-27T19:32:26Z', '2012-05-07T03:20:16Z', '2016-12-27T03:56:35Z', '2017-12-15T05:53:51Z', '2020-01-02T15:58:12Z', '2016-09-27T03:22:28Z', '2013-07-12T11:22:10Z', '2014-06-22T09:25:43Z', '2015-02-26T21:54:04Z', '2016-03-29T14:42:27Z', '2016-12-08T06:55:29Z', '2015-10-23T11:14:50Z', '2013-05-07T18:44:55Z', '2013-09-22T16:13:48Z', '2010-11-25T01:57:13Z', '2014-09-17T12:11:02Z', '2017-06-09T23:09:16Z', '2018-02-05T20:06:51Z']\n"
     ]
    }
   ],
   "source": [
    "#RUN THIS ONLY ONCE\n",
    "arr = []\n",
    "\n",
    "for index, row in newdf.iterrows():\n",
    "    r = session.get(http_base+row['Author']+\"/\"+row['Repo'])\n",
    "    arr.append(r.json()['created_at'])\n",
    "\n",
    "print(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1172\n",
      "2017-07-12T18:55:44Z\n",
      "       Repo  Author           github_date\n",
      "159  galIMF  Azeret  2017-07-12T18:55:44Z\n"
     ]
    }
   ],
   "source": [
    "newdf['github_date'] = arr\n",
    "\n",
    "#check one against a fresh API call to make sure it's correct\n",
    "created = session.get(http_base+'Azeret/galIMF').json()['created_at']\n",
    "print(created)\n",
    "print(newdf[newdf['Repo'] == 'galIMF'])\n",
    "\n",
    "#both are the same, so we're good"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                           Repo                Author           github_date\n",
      "0                       Eclairs              0satoken  2018-10-23T15:37:34Z\n",
      "3           Crab.Toolkit.michi2                  1054  2017-03-07T13:02:16Z\n",
      "9                         PRISM                 1313e  2018-02-06T02:53:21Z\n",
      "12                   exostriker            3fon3fonov  2018-10-17T19:56:13Z\n",
      "21               fourpisky-core                4pisky  2016-01-01T16:02:56Z\n",
      "25               AskaryanModule           918particle  2016-04-26T14:16:33Z\n",
      "30                      LensCNN              A-Davies  2018-06-26T17:10:20Z\n",
      "31                          ACS         ACS-Community  2014-06-26T16:02:34Z\n",
      "57                         oxaf        ADThomas-astro  2016-08-04T07:13:01Z\n",
      "58                     ebhlight          AFD-Illinois  2018-09-26T22:19:43Z\n",
      "60                       Castro           AMReX-Astro  2015-01-21T20:10:37Z\n",
      "75                    MAESTROeX           AMReX-Astro  2017-09-18T23:39:12Z\n",
      "86                          Nyx           AMReX-Astro  2016-08-02T19:03:48Z\n",
      "96                     wdmerger           AMReX-Astro  2015-01-26T19:00:42Z\n",
      "100                       amrex           AMReX-Codes  2017-04-28T19:37:00Z\n",
      "116                     aotools               AOtools  2016-03-09T15:00:56Z\n",
      "117               bias_emulator        AemulusProject  2018-12-07T15:32:48Z\n",
      "123                    ODUSSEAS  AlexandrosAntoniadis  2018-11-26T14:24:50Z\n",
      "124                    SpiceyPy           AndrewAnnex  2014-01-13T19:29:09Z\n",
      "127                     LAMBDAR           AngusWright  2013-10-07T03:28:51Z\n",
      "130   RadioGalaxyClassification            ArunAniyan  2018-02-25T13:12:54Z\n",
      "131            astro-accelerate    AstroAccelerateOrg  2013-02-27T12:04:06Z\n",
      "138                     VISIBLE             AstroChem  2017-03-20T13:22:12Z\n",
      "139                       swarm              AstroGPU  2012-01-06T20:44:53Z\n",
      "148                         mrf          AstroJacobLi  2019-08-08T14:56:00Z\n",
      "149                   shadowfax            AstroUGent  2015-12-15T09:29:50Z\n",
      "153                        kali              AstroVPK  2015-09-20T03:09:27Z\n",
      "157                      SCIMES               Astroua  2014-08-21T18:57:11Z\n",
      "158                   TurbuStat               Astroua  2013-12-05T19:16:19Z\n",
      "159                      galIMF                Azeret  2017-07-12T18:55:44Z\n",
      "...                         ...                   ...                   ...\n",
      "3948                      lemon               vterron  2012-06-04T17:49:42Z\n",
      "3950           FIRST-CLASSIFIER               wathela  2018-04-08T22:12:43Z\n",
      "3951               astrotaverna               wf4ever  2012-04-11T08:28:17Z\n",
      "3952                 anesthetic   williamjameshandley  2019-03-14T16:52:11Z\n",
      "3957                    fgivenx   williamjameshandley  2017-08-21T11:58:31Z\n",
      "3959                 CLPT_GSRSD          wll745881210  2013-05-08T09:46:55Z\n",
      "3962                      MCSED             wpb-astro  2018-10-31T21:09:27Z\n",
      "3964                   -SNR-Net   wulinmenghuantejing  2017-07-31T11:02:30Z\n",
      "3966                   2DFFTLog            xfangcosmo  2020-02-08T21:27:53Z\n",
      "3969          FFTLog-and-beyond            xfangcosmo  2019-04-18T06:47:09Z\n",
      "3972                  xgds_core                  xgds  2015-12-09T17:08:04Z\n",
      "3976                     pyAmor             xinglunju  2014-04-28T19:43:27Z\n",
      "3977                      tdviz             xinglunju  2015-04-27T19:32:26Z\n",
      "3978                  xraylarch                xraypy  2012-05-07T03:20:16Z\n",
      "3988          Top_Down_Miky_Way           yuanjinghua  2016-12-27T03:56:35Z\n",
      "3989                       CUBE              yuhaoran  2017-12-15T05:53:51Z\n",
      "3992                   Min-CaLM           yungkipreos  2020-01-02T15:58:12Z\n",
      "3993                      vizic          ywx649999311  2016-09-27T03:22:28Z\n",
      "3996                      naima                  zblz  2013-07-12T11:22:10Z\n",
      "3997                    OpenMHD              zenitani  2014-06-22T09:25:43Z\n",
      "4005                        TAP                zgazak  2015-02-26T21:54:04Z\n",
      "4007                  pyreaclib               zingale  2016-03-29T14:42:27Z\n",
      "4011         dacapo_calibration              ziotom78  2016-12-08T06:55:29Z\n",
      "4017                   polycomp              ziotom78  2015-10-23T11:14:50Z\n",
      "4018                    megalib              zoglauer  2013-05-07T18:44:55Z\n",
      "4026                        dst                 zonca  2013-09-22T16:13:48Z\n",
      "4027                python-qucs                 zonca  2010-11-25T01:57:13Z\n",
      "4028                     starpy            zooniverse  2014-09-17T12:11:02Z\n",
      "4029                CausticFrog              zpenoyre  2017-06-09T23:09:16Z\n",
      "4031                        OoT              zpenoyre  2018-02-05T20:06:51Z\n",
      "\n",
      "[1172 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "#now, we must get date data using the ASCL API\n",
    "print(newdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#link to how to get stacked area chart\n",
    "#https://python-graph-gallery.com/255-percentage-stacked-area-chart/"
   ]
  }
 ],
 "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}