CombinedAreas.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "2b1b6d1f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Test of simple scraper and entity extractor.\n",
    "import requests\n",
    "import datetime\n",
    "# import packages\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests\n",
    "from pandas.io.json import json_normalize #special package in pandas\n",
    "import json\n",
    "from matplotlib.pyplot import *\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "a860939e",
   "metadata": {},
   "outputs": [],
   "source": [
    "nsf_awards_json_api = 'http://api.nsf.gov/services/v1/awards.json'\n",
    "keywords=['keyword=ai','keyword=cybersecurity','keyword=quantum','keyword=data analytics','keyword=modeling and simulation']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "d8e5d45d",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_areas = pd.DataFrame()\n",
    "\n",
    "for keyword in keywords:\n",
    "    res = requests.get(nsf_awards_json_api + '?' + keyword)\n",
    "    json_response = res.json()[\"response\"]\n",
    "    awards = json_response[\"award\"]\n",
    "    rdf = pd.json_normalize(awards)\n",
    "    rdf[\"Area\"] = keyword\n",
    "    rdf[\"Topic\"] = rdf[\"Area\"].str[8:]\n",
    "    combined_areas = combined_areas.append(rdf)\n",
    "    \n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "574796e7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Area</th>\n",
       "      <th>Topic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000</td>\n",
       "      <td>2205152</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971</td>\n",
       "      <td>2230850</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631</td>\n",
       "      <td>2211882</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375</td>\n",
       "      <td>2147220</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668</td>\n",
       "      <td>2142503</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000</td>\n",
       "      <td>1708602</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000</td>\n",
       "      <td>1658908</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157</td>\n",
       "      <td>1727508</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826</td>\n",
       "      <td>1707207</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000</td>\n",
       "      <td>1565546</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                  awardeeName  \\\n",
       "0     NSF         ATLANTA            Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                     New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                   Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                      Northeastern University   \n",
       "4     NSF  SAN BERNARDINO  University Enterprises Corporation at CSUSB   \n",
       "..    ...             ...                                          ...   \n",
       "20    NSF       Baltimore                     Johns Hopkins University   \n",
       "21    NSF         FAIRFAX                      George Mason University   \n",
       "22    NSF       Bethlehem                            Lehigh University   \n",
       "23    NSF       Bethlehem                            Lehigh University   \n",
       "24    NSF    EAST LANSING                    Michigan State University   \n",
       "\n",
       "   awardeeStateCode fundsObligatedAmt       id piFirstName piLastName  \\\n",
       "0                GA            800000  2205152         Ali      Adibi   \n",
       "1                NY             74971  2230850     Dorothy    Bennett   \n",
       "2                PA            790631  2211882      Tianqi       Chen   \n",
       "3                MA            299375  2147220      Ronald    Sandler   \n",
       "4                CA             97668  2142503      Yunfei        Hou   \n",
       "..              ...               ...      ...         ...        ...   \n",
       "20               MD            300000  1708602       Mauro   Maggioni   \n",
       "21               VA              5000  1658908        John    Shortle   \n",
       "22               PA            346157  1727508      Wonpil         Im   \n",
       "23               PA            546826  1707207      Wonpil         Im   \n",
       "24               MI         114000000  1565546     Bradley   Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  09/13/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  08/22/2022   \n",
       "3                    1  07/07/2022   \n",
       "4                    1  05/26/2022   \n",
       "..                 ...         ...   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title  \\\n",
       "0   SCH: Intelligent Radiology Through Human-Machi...   \n",
       "1   Conference on Human-Centered Approaches to Art...   \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...   \n",
       "3   Research Community Development Grant: Summer T...   \n",
       "4   Collaborative Research: Broadening Inclusive P...   \n",
       "..                                                ...   \n",
       "20  Statistical Learning for High-Dimensional Stoc...   \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...   \n",
       "22  Bacterial Outer Membranes and Interactions wit...   \n",
       "23  ABI Innovation: Development of Glycan Modeling...   \n",
       "24  Operation of the NSCL as a National User Facil...   \n",
       "\n",
       "                               Area                    Topic  \n",
       "0                        keyword=ai                       ai  \n",
       "1                        keyword=ai                       ai  \n",
       "2                        keyword=ai                       ai  \n",
       "3                        keyword=ai                       ai  \n",
       "4                        keyword=ai                       ai  \n",
       "..                              ...                      ...  \n",
       "20  keyword=modeling and simulation  modeling and simulation  \n",
       "21  keyword=modeling and simulation  modeling and simulation  \n",
       "22  keyword=modeling and simulation  modeling and simulation  \n",
       "23  keyword=modeling and simulation  modeling and simulation  \n",
       "24  keyword=modeling and simulation  modeling and simulation  \n",
       "\n",
       "[125 rows x 13 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_areas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "ca17e41c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Area</th>\n",
       "      <th>Topic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000</td>\n",
       "      <td>2205152</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971</td>\n",
       "      <td>2230850</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631</td>\n",
       "      <td>2211882</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375</td>\n",
       "      <td>2147220</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668</td>\n",
       "      <td>2142503</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>keyword=ai</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000</td>\n",
       "      <td>1708602</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000</td>\n",
       "      <td>1658908</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157</td>\n",
       "      <td>1727508</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826</td>\n",
       "      <td>1707207</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000</td>\n",
       "      <td>1565546</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>keyword=modeling and simulation</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                  awardeeName  \\\n",
       "0     NSF         ATLANTA            Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                     New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                   Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                      Northeastern University   \n",
       "4     NSF  SAN BERNARDINO  University Enterprises Corporation at CSUSB   \n",
       "..    ...             ...                                          ...   \n",
       "20    NSF       Baltimore                     Johns Hopkins University   \n",
       "21    NSF         FAIRFAX                      George Mason University   \n",
       "22    NSF       Bethlehem                            Lehigh University   \n",
       "23    NSF       Bethlehem                            Lehigh University   \n",
       "24    NSF    EAST LANSING                    Michigan State University   \n",
       "\n",
       "   awardeeStateCode fundsObligatedAmt       id piFirstName piLastName  \\\n",
       "0                GA            800000  2205152         Ali      Adibi   \n",
       "1                NY             74971  2230850     Dorothy    Bennett   \n",
       "2                PA            790631  2211882      Tianqi       Chen   \n",
       "3                MA            299375  2147220      Ronald    Sandler   \n",
       "4                CA             97668  2142503      Yunfei        Hou   \n",
       "..              ...               ...      ...         ...        ...   \n",
       "20               MD            300000  1708602       Mauro   Maggioni   \n",
       "21               VA              5000  1658908        John    Shortle   \n",
       "22               PA            346157  1727508      Wonpil         Im   \n",
       "23               PA            546826  1707207      Wonpil         Im   \n",
       "24               MI         114000000  1565546     Bradley   Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  09/13/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  08/22/2022   \n",
       "3                    1  07/07/2022   \n",
       "4                    1  05/26/2022   \n",
       "..                 ...         ...   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title  \\\n",
       "0   SCH: Intelligent Radiology Through Human-Machi...   \n",
       "1   Conference on Human-Centered Approaches to Art...   \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...   \n",
       "3   Research Community Development Grant: Summer T...   \n",
       "4   Collaborative Research: Broadening Inclusive P...   \n",
       "..                                                ...   \n",
       "20  Statistical Learning for High-Dimensional Stoc...   \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...   \n",
       "22  Bacterial Outer Membranes and Interactions wit...   \n",
       "23  ABI Innovation: Development of Glycan Modeling...   \n",
       "24  Operation of the NSCL as a National User Facil...   \n",
       "\n",
       "                               Area                    Topic  \n",
       "0                        keyword=ai                       ai  \n",
       "1                        keyword=ai                       ai  \n",
       "2                        keyword=ai                       ai  \n",
       "3                        keyword=ai                       ai  \n",
       "4                        keyword=ai                       ai  \n",
       "..                              ...                      ...  \n",
       "20  keyword=modeling and simulation  modeling and simulation  \n",
       "21  keyword=modeling and simulation  modeling and simulation  \n",
       "22  keyword=modeling and simulation  modeling and simulation  \n",
       "23  keyword=modeling and simulation  modeling and simulation  \n",
       "24  keyword=modeling and simulation  modeling and simulation  \n",
       "\n",
       "[125 rows x 13 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = combined_areas.copy(deep=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "a5e57c20",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000</td>\n",
       "      <td>2205152</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971</td>\n",
       "      <td>2230850</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631</td>\n",
       "      <td>2211882</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375</td>\n",
       "      <td>2147220</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668</td>\n",
       "      <td>2142503</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>ai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000</td>\n",
       "      <td>1708602</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000</td>\n",
       "      <td>1658908</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157</td>\n",
       "      <td>1727508</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826</td>\n",
       "      <td>1707207</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000</td>\n",
       "      <td>1565546</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                  awardeeName  \\\n",
       "0     NSF         ATLANTA            Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                     New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                   Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                      Northeastern University   \n",
       "4     NSF  SAN BERNARDINO  University Enterprises Corporation at CSUSB   \n",
       "..    ...             ...                                          ...   \n",
       "20    NSF       Baltimore                     Johns Hopkins University   \n",
       "21    NSF         FAIRFAX                      George Mason University   \n",
       "22    NSF       Bethlehem                            Lehigh University   \n",
       "23    NSF       Bethlehem                            Lehigh University   \n",
       "24    NSF    EAST LANSING                    Michigan State University   \n",
       "\n",
       "   awardeeStateCode fundsObligatedAmt       id piFirstName piLastName  \\\n",
       "0                GA            800000  2205152         Ali      Adibi   \n",
       "1                NY             74971  2230850     Dorothy    Bennett   \n",
       "2                PA            790631  2211882      Tianqi       Chen   \n",
       "3                MA            299375  2147220      Ronald    Sandler   \n",
       "4                CA             97668  2142503      Yunfei        Hou   \n",
       "..              ...               ...      ...         ...        ...   \n",
       "20               MD            300000  1708602       Mauro   Maggioni   \n",
       "21               VA              5000  1658908        John    Shortle   \n",
       "22               PA            346157  1727508      Wonpil         Im   \n",
       "23               PA            546826  1707207      Wonpil         Im   \n",
       "24               MI         114000000  1565546     Bradley   Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  09/13/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  08/22/2022   \n",
       "3                    1  07/07/2022   \n",
       "4                    1  05/26/2022   \n",
       "..                 ...         ...   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title                    Topic  \n",
       "0   SCH: Intelligent Radiology Through Human-Machi...                       ai  \n",
       "1   Conference on Human-Centered Approaches to Art...                       ai  \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...                       ai  \n",
       "3   Research Community Development Grant: Summer T...                       ai  \n",
       "4   Collaborative Research: Broadening Inclusive P...                       ai  \n",
       "..                                                ...                      ...  \n",
       "20  Statistical Learning for High-Dimensional Stoc...  modeling and simulation  \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...  modeling and simulation  \n",
       "22  Bacterial Outer Membranes and Interactions wit...  modeling and simulation  \n",
       "23  ABI Innovation: Development of Glycan Modeling...  modeling and simulation  \n",
       "24  Operation of the NSCL as a National User Facil...  modeling and simulation  \n",
       "\n",
       "[125 rows x 12 columns]"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.drop(['Area'], axis=1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "d773fe24",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000</td>\n",
       "      <td>2205152</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-09-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971</td>\n",
       "      <td>2230850</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631</td>\n",
       "      <td>2211882</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375</td>\n",
       "      <td>2147220</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-07-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668</td>\n",
       "      <td>2142503</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-05-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000</td>\n",
       "      <td>1708602</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-04-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000</td>\n",
       "      <td>1658908</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-03-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157</td>\n",
       "      <td>1727508</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826</td>\n",
       "      <td>1707207</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000</td>\n",
       "      <td>1565546</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-03</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                  awardeeName  \\\n",
       "0     NSF         ATLANTA            Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                     New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                   Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                      Northeastern University   \n",
       "4     NSF  SAN BERNARDINO  University Enterprises Corporation at CSUSB   \n",
       "..    ...             ...                                          ...   \n",
       "20    NSF       Baltimore                     Johns Hopkins University   \n",
       "21    NSF         FAIRFAX                      George Mason University   \n",
       "22    NSF       Bethlehem                            Lehigh University   \n",
       "23    NSF       Bethlehem                            Lehigh University   \n",
       "24    NSF    EAST LANSING                    Michigan State University   \n",
       "\n",
       "   awardeeStateCode fundsObligatedAmt       id piFirstName piLastName  \\\n",
       "0                GA            800000  2205152         Ali      Adibi   \n",
       "1                NY             74971  2230850     Dorothy    Bennett   \n",
       "2                PA            790631  2211882      Tianqi       Chen   \n",
       "3                MA            299375  2147220      Ronald    Sandler   \n",
       "4                CA             97668  2142503      Yunfei        Hou   \n",
       "..              ...               ...      ...         ...        ...   \n",
       "20               MD            300000  1708602       Mauro   Maggioni   \n",
       "21               VA              5000  1658908        John    Shortle   \n",
       "22               PA            346157  1727508      Wonpil         Im   \n",
       "23               PA            546826  1707207      Wonpil         Im   \n",
       "24               MI         114000000  1565546     Bradley   Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  09/13/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  08/22/2022   \n",
       "3                    1  07/07/2022   \n",
       "4                    1  05/26/2022   \n",
       "..                 ...         ...   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title  \\\n",
       "0   SCH: Intelligent Radiology Through Human-Machi...   \n",
       "1   Conference on Human-Centered Approaches to Art...   \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...   \n",
       "3   Research Community Development Grant: Summer T...   \n",
       "4   Collaborative Research: Broadening Inclusive P...   \n",
       "..                                                ...   \n",
       "20  Statistical Learning for High-Dimensional Stoc...   \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...   \n",
       "22  Bacterial Outer Membranes and Interactions wit...   \n",
       "23  ABI Innovation: Development of Glycan Modeling...   \n",
       "24  Operation of the NSCL as a National User Facil...   \n",
       "\n",
       "                      Topic        DATE  \n",
       "0                        ai  2022-09-13  \n",
       "1                        ai  2022-08-31  \n",
       "2                        ai  2022-08-22  \n",
       "3                        ai  2022-07-07  \n",
       "4                        ai  2022-05-26  \n",
       "..                      ...         ...  \n",
       "20  modeling and simulation  2017-04-28  \n",
       "21  modeling and simulation  2017-03-08  \n",
       "22  modeling and simulation  2017-01-20  \n",
       "23  modeling and simulation  2016-11-04  \n",
       "24  modeling and simulation  2016-11-03  \n",
       "\n",
       "[125 rows x 13 columns]"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['DATE'] = df['date'].apply(lambda x: datetime.datetime.strptime(x, '%m/%d/%Y').strftime('%Y-%m-%d'))\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "ccda7877",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000</td>\n",
       "      <td>2205152</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-09-13</td>\n",
       "      <td>Ali Adibi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971</td>\n",
       "      <td>2230850</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Dorothy Bennett</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631</td>\n",
       "      <td>2211882</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-22</td>\n",
       "      <td>Tianqi Chen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375</td>\n",
       "      <td>2147220</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>Ronald Sandler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668</td>\n",
       "      <td>2142503</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-05-26</td>\n",
       "      <td>Yunfei Hou</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000</td>\n",
       "      <td>1708602</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>Mauro Maggioni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000</td>\n",
       "      <td>1658908</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-03-08</td>\n",
       "      <td>John Shortle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157</td>\n",
       "      <td>1727508</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-01-20</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826</td>\n",
       "      <td>1707207</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-04</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000</td>\n",
       "      <td>1565546</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-03</td>\n",
       "      <td>Bradley Sherrill</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                  awardeeName  \\\n",
       "0     NSF         ATLANTA            Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                     New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                   Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                      Northeastern University   \n",
       "4     NSF  SAN BERNARDINO  University Enterprises Corporation at CSUSB   \n",
       "..    ...             ...                                          ...   \n",
       "20    NSF       Baltimore                     Johns Hopkins University   \n",
       "21    NSF         FAIRFAX                      George Mason University   \n",
       "22    NSF       Bethlehem                            Lehigh University   \n",
       "23    NSF       Bethlehem                            Lehigh University   \n",
       "24    NSF    EAST LANSING                    Michigan State University   \n",
       "\n",
       "   awardeeStateCode fundsObligatedAmt       id piFirstName piLastName  \\\n",
       "0                GA            800000  2205152         Ali      Adibi   \n",
       "1                NY             74971  2230850     Dorothy    Bennett   \n",
       "2                PA            790631  2211882      Tianqi       Chen   \n",
       "3                MA            299375  2147220      Ronald    Sandler   \n",
       "4                CA             97668  2142503      Yunfei        Hou   \n",
       "..              ...               ...      ...         ...        ...   \n",
       "20               MD            300000  1708602       Mauro   Maggioni   \n",
       "21               VA              5000  1658908        John    Shortle   \n",
       "22               PA            346157  1727508      Wonpil         Im   \n",
       "23               PA            546826  1707207      Wonpil         Im   \n",
       "24               MI         114000000  1565546     Bradley   Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  09/13/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  08/22/2022   \n",
       "3                    1  07/07/2022   \n",
       "4                    1  05/26/2022   \n",
       "..                 ...         ...   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title  \\\n",
       "0   SCH: Intelligent Radiology Through Human-Machi...   \n",
       "1   Conference on Human-Centered Approaches to Art...   \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...   \n",
       "3   Research Community Development Grant: Summer T...   \n",
       "4   Collaborative Research: Broadening Inclusive P...   \n",
       "..                                                ...   \n",
       "20  Statistical Learning for High-Dimensional Stoc...   \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...   \n",
       "22  Bacterial Outer Membranes and Interactions wit...   \n",
       "23  ABI Innovation: Development of Glycan Modeling...   \n",
       "24  Operation of the NSCL as a National User Facil...   \n",
       "\n",
       "                      Topic        DATE              NAME  \n",
       "0                        ai  2022-09-13         Ali Adibi  \n",
       "1                        ai  2022-08-31   Dorothy Bennett  \n",
       "2                        ai  2022-08-22       Tianqi Chen  \n",
       "3                        ai  2022-07-07    Ronald Sandler  \n",
       "4                        ai  2022-05-26        Yunfei Hou  \n",
       "..                      ...         ...               ...  \n",
       "20  modeling and simulation  2017-04-28    Mauro Maggioni  \n",
       "21  modeling and simulation  2017-03-08      John Shortle  \n",
       "22  modeling and simulation  2017-01-20         Wonpil Im  \n",
       "23  modeling and simulation  2016-11-04         Wonpil Im  \n",
       "24  modeling and simulation  2016-11-03  Bradley Sherrill  \n",
       "\n",
       "[125 rows x 14 columns]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['NAME'] = df['piFirstName'] + \" \" + df['piLastName']\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "5f6437fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['fundsObligatedAmt']=df['fundsObligatedAmt'].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "71dfd4d0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['id']=df['id'].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "01d21f2b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000.0</td>\n",
       "      <td>2205152.0</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-09-13</td>\n",
       "      <td>Ali Adibi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971.0</td>\n",
       "      <td>2230850.0</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Dorothy Bennett</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631.0</td>\n",
       "      <td>2211882.0</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-22</td>\n",
       "      <td>Tianqi Chen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375.0</td>\n",
       "      <td>2147220.0</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>Ronald Sandler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668.0</td>\n",
       "      <td>2142503.0</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-05-26</td>\n",
       "      <td>Yunfei Hou</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000.0</td>\n",
       "      <td>1708602.0</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>Mauro Maggioni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1658908.0</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-03-08</td>\n",
       "      <td>John Shortle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157.0</td>\n",
       "      <td>1727508.0</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-01-20</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826.0</td>\n",
       "      <td>1707207.0</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-04</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000.0</td>\n",
       "      <td>1565546.0</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-03</td>\n",
       "      <td>Bradley Sherrill</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                  awardeeName  \\\n",
       "0     NSF         ATLANTA            Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                     New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                   Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                      Northeastern University   \n",
       "4     NSF  SAN BERNARDINO  University Enterprises Corporation at CSUSB   \n",
       "..    ...             ...                                          ...   \n",
       "20    NSF       Baltimore                     Johns Hopkins University   \n",
       "21    NSF         FAIRFAX                      George Mason University   \n",
       "22    NSF       Bethlehem                            Lehigh University   \n",
       "23    NSF       Bethlehem                            Lehigh University   \n",
       "24    NSF    EAST LANSING                    Michigan State University   \n",
       "\n",
       "   awardeeStateCode  fundsObligatedAmt         id piFirstName piLastName  \\\n",
       "0                GA           800000.0  2205152.0         Ali      Adibi   \n",
       "1                NY            74971.0  2230850.0     Dorothy    Bennett   \n",
       "2                PA           790631.0  2211882.0      Tianqi       Chen   \n",
       "3                MA           299375.0  2147220.0      Ronald    Sandler   \n",
       "4                CA            97668.0  2142503.0      Yunfei        Hou   \n",
       "..              ...                ...        ...         ...        ...   \n",
       "20               MD           300000.0  1708602.0       Mauro   Maggioni   \n",
       "21               VA             5000.0  1658908.0        John    Shortle   \n",
       "22               PA           346157.0  1727508.0      Wonpil         Im   \n",
       "23               PA           546826.0  1707207.0      Wonpil         Im   \n",
       "24               MI        114000000.0  1565546.0     Bradley   Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  09/13/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  08/22/2022   \n",
       "3                    1  07/07/2022   \n",
       "4                    1  05/26/2022   \n",
       "..                 ...         ...   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title  \\\n",
       "0   SCH: Intelligent Radiology Through Human-Machi...   \n",
       "1   Conference on Human-Centered Approaches to Art...   \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...   \n",
       "3   Research Community Development Grant: Summer T...   \n",
       "4   Collaborative Research: Broadening Inclusive P...   \n",
       "..                                                ...   \n",
       "20  Statistical Learning for High-Dimensional Stoc...   \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...   \n",
       "22  Bacterial Outer Membranes and Interactions wit...   \n",
       "23  ABI Innovation: Development of Glycan Modeling...   \n",
       "24  Operation of the NSCL as a National User Facil...   \n",
       "\n",
       "                      Topic        DATE              NAME  \n",
       "0                        ai  2022-09-13         Ali Adibi  \n",
       "1                        ai  2022-08-31   Dorothy Bennett  \n",
       "2                        ai  2022-08-22       Tianqi Chen  \n",
       "3                        ai  2022-07-07    Ronald Sandler  \n",
       "4                        ai  2022-05-26        Yunfei Hou  \n",
       "..                      ...         ...               ...  \n",
       "20  modeling and simulation  2017-04-28    Mauro Maggioni  \n",
       "21  modeling and simulation  2017-03-08      John Shortle  \n",
       "22  modeling and simulation  2017-01-20         Wonpil Im  \n",
       "23  modeling and simulation  2016-11-04         Wonpil Im  \n",
       "24  modeling and simulation  2016-11-03  Bradley Sherrill  \n",
       "\n",
       "[125 rows x 14 columns]"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "8c03461b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>800000.0</td>\n",
       "      <td>2205152.0</td>\n",
       "      <td>Ali</td>\n",
       "      <td>Adibi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/13/2022</td>\n",
       "      <td>SCH: Intelligent Radiology Through Human-Machi...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-09-13</td>\n",
       "      <td>Ali Adibi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CORONA</td>\n",
       "      <td>New York Hall of Science</td>\n",
       "      <td>NY</td>\n",
       "      <td>74971.0</td>\n",
       "      <td>2230850.0</td>\n",
       "      <td>Dorothy</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Conference on Human-Centered Approaches to Art...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Dorothy Bennett</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>790631.0</td>\n",
       "      <td>2211882.0</td>\n",
       "      <td>Tianqi</td>\n",
       "      <td>Chen</td>\n",
       "      <td>1</td>\n",
       "      <td>08/22/2022</td>\n",
       "      <td>CNS: Medium: Ground up Adaptive Learning Syste...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-08-22</td>\n",
       "      <td>Tianqi Chen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Northeastern University</td>\n",
       "      <td>MA</td>\n",
       "      <td>299375.0</td>\n",
       "      <td>2147220.0</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>Sandler</td>\n",
       "      <td>1</td>\n",
       "      <td>07/07/2022</td>\n",
       "      <td>Research Community Development Grant: Summer T...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-07-07</td>\n",
       "      <td>Ronald Sandler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN BERNARDINO</td>\n",
       "      <td>University Enterprises Corporation at CSUSB</td>\n",
       "      <td>CA</td>\n",
       "      <td>97668.0</td>\n",
       "      <td>2142503.0</td>\n",
       "      <td>Yunfei</td>\n",
       "      <td>Hou</td>\n",
       "      <td>1</td>\n",
       "      <td>05/26/2022</td>\n",
       "      <td>Collaborative Research: Broadening Inclusive P...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-05-26</td>\n",
       "      <td>Yunfei Hou</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAYETTEVILLE</td>\n",
       "      <td>Fayetteville State University</td>\n",
       "      <td>NC</td>\n",
       "      <td>397055.0</td>\n",
       "      <td>2205502.0</td>\n",
       "      <td>Sambit</td>\n",
       "      <td>Bhattacharya</td>\n",
       "      <td>1</td>\n",
       "      <td>05/03/2022</td>\n",
       "      <td>Targeted Infusion Project: Exposing Students t...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-05-03</td>\n",
       "      <td>Sambit Bhattacharya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NEW BRUNSWICK</td>\n",
       "      <td>Rutgers University New Brunswick</td>\n",
       "      <td>NJ</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>2137245.0</td>\n",
       "      <td>Jorge</td>\n",
       "      <td>Ortiz</td>\n",
       "      <td>1</td>\n",
       "      <td>02/16/2022</td>\n",
       "      <td>IUCRC Planning Grant Rutgers University: Cente...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-02-16</td>\n",
       "      <td>Jorge Ortiz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Richardson</td>\n",
       "      <td>University of Texas at Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>96488.0</td>\n",
       "      <td>2146448.0</td>\n",
       "      <td>Shuang</td>\n",
       "      <td>Hao</td>\n",
       "      <td>1</td>\n",
       "      <td>01/13/2022</td>\n",
       "      <td>CAREER: Empowering White-box Driven Analytics ...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>Shuang Hao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>OPAL AI INC.</td>\n",
       "      <td>CA</td>\n",
       "      <td>276000.0</td>\n",
       "      <td>2126752.0</td>\n",
       "      <td>Shahrouz</td>\n",
       "      <td>Alimo</td>\n",
       "      <td>1</td>\n",
       "      <td>01/03/2022</td>\n",
       "      <td>SBIR Phase I:  Autonomous Floorplan Reconstruc...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>Shahrouz Alimo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>Carnegie-Mellon University</td>\n",
       "      <td>PA</td>\n",
       "      <td>866000.0</td>\n",
       "      <td>2118924.0</td>\n",
       "      <td>Nikolas</td>\n",
       "      <td>Martelaro</td>\n",
       "      <td>1</td>\n",
       "      <td>08/12/2021</td>\n",
       "      <td>Supporting Designers in Learning to Co-create ...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-08-12</td>\n",
       "      <td>Nikolas Martelaro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>7980446.0</td>\n",
       "      <td>2112633.0</td>\n",
       "      <td>Sonia</td>\n",
       "      <td>Chernova</td>\n",
       "      <td>1</td>\n",
       "      <td>07/28/2021</td>\n",
       "      <td>AI Institute for Collaborative Assistance and ...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-07-28</td>\n",
       "      <td>Sonia Chernova</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NSF</td>\n",
       "      <td>MIAMI</td>\n",
       "      <td>Miami Dade College</td>\n",
       "      <td>FL</td>\n",
       "      <td>986535.0</td>\n",
       "      <td>2115153.0</td>\n",
       "      <td>Antonio</td>\n",
       "      <td>Delgado</td>\n",
       "      <td>1</td>\n",
       "      <td>07/12/2021</td>\n",
       "      <td>Artificial Intelligence For All: A Framework f...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-07-12</td>\n",
       "      <td>Antonio Delgado</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CLEMSON</td>\n",
       "      <td>Clemson University</td>\n",
       "      <td>SC</td>\n",
       "      <td>146000.0</td>\n",
       "      <td>2114920.0</td>\n",
       "      <td>Long</td>\n",
       "      <td>Cheng</td>\n",
       "      <td>1</td>\n",
       "      <td>05/27/2021</td>\n",
       "      <td>Collaborative Research: EAGER: SaTC-EDU: Learn...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-05-27</td>\n",
       "      <td>Long Cheng</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NSF</td>\n",
       "      <td>GREENSBORO</td>\n",
       "      <td>North Carolina Agricultural &amp; Technical State ...</td>\n",
       "      <td>NC</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2114936.0</td>\n",
       "      <td>Xiaohong</td>\n",
       "      <td>Yuan</td>\n",
       "      <td>1</td>\n",
       "      <td>05/27/2021</td>\n",
       "      <td>Collaborative Research: EAGER: SaTC-EDU: Learn...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-05-27</td>\n",
       "      <td>Xiaohong Yuan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>New York University</td>\n",
       "      <td>NY</td>\n",
       "      <td>299926.0</td>\n",
       "      <td>2103936.0</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Fernandez Granda</td>\n",
       "      <td>1</td>\n",
       "      <td>05/24/2021</td>\n",
       "      <td>Elements: Collaborative Research: Community-dr...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-05-24</td>\n",
       "      <td>Carlos Fernandez Granda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NSF</td>\n",
       "      <td>WEST LAFAYETTE</td>\n",
       "      <td>Purdue University</td>\n",
       "      <td>IN</td>\n",
       "      <td>299934.0</td>\n",
       "      <td>2114974.0</td>\n",
       "      <td>Jin</td>\n",
       "      <td>Wei-Kocsis</td>\n",
       "      <td>1</td>\n",
       "      <td>04/27/2021</td>\n",
       "      <td>EAGER: SaTC-EDU: Cybersecurity Education in th...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-04-27</td>\n",
       "      <td>Jin Wei-Kocsis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Champaign</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>IL</td>\n",
       "      <td>168670.0</td>\n",
       "      <td>2113955.0</td>\n",
       "      <td>Colleen</td>\n",
       "      <td>Lewis</td>\n",
       "      <td>1</td>\n",
       "      <td>04/27/2021</td>\n",
       "      <td>Collaborative Research: EAGER: SaTC-EDU: Artif...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2021-04-27</td>\n",
       "      <td>Colleen Lewis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOULDER</td>\n",
       "      <td>University of Colorado at Boulder</td>\n",
       "      <td>CO</td>\n",
       "      <td>11996931.0</td>\n",
       "      <td>2019805.0</td>\n",
       "      <td>Sidney</td>\n",
       "      <td>D'Mello</td>\n",
       "      <td>1</td>\n",
       "      <td>08/25/2020</td>\n",
       "      <td>AI Institute:  Institute for Student-AI Teaming</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-08-25</td>\n",
       "      <td>Sidney D'Mello</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PHILADELPHIA</td>\n",
       "      <td>University of Pennsylvania</td>\n",
       "      <td>PA</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>2020312.0</td>\n",
       "      <td>Konrad</td>\n",
       "      <td>Kording</td>\n",
       "      <td>1</td>\n",
       "      <td>08/25/2020</td>\n",
       "      <td>AI Institute: Planning: From Biological Intell...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-08-25</td>\n",
       "      <td>Konrad Kording</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>University of California-Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>98280.0</td>\n",
       "      <td>2049670.0</td>\n",
       "      <td>James</td>\n",
       "      <td>Davis</td>\n",
       "      <td>1</td>\n",
       "      <td>08/21/2020</td>\n",
       "      <td>Workshop:  Aligning AI and U.S. Advanced Manuf...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-08-21</td>\n",
       "      <td>James Davis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NOTRE DAME</td>\n",
       "      <td>University of Notre Dame</td>\n",
       "      <td>IN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2008228.0</td>\n",
       "      <td>Dong</td>\n",
       "      <td>Wang</td>\n",
       "      <td>1</td>\n",
       "      <td>08/21/2020</td>\n",
       "      <td>CHS: Small: DeepCrowd: A Crowd-assisted Deep L...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-08-21</td>\n",
       "      <td>Dong Wang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SALT LAKE CITY</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>UT</td>\n",
       "      <td>316000.0</td>\n",
       "      <td>2041960.0</td>\n",
       "      <td>Eliane</td>\n",
       "      <td>Wiese</td>\n",
       "      <td>1</td>\n",
       "      <td>07/29/2020</td>\n",
       "      <td>EAGER: SaTC-EDU: Teaching Security in Undergra...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-07-29</td>\n",
       "      <td>Eliane Wiese</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BERKELEY</td>\n",
       "      <td>University of California-Berkeley</td>\n",
       "      <td>CA</td>\n",
       "      <td>299987.0</td>\n",
       "      <td>2039637.0</td>\n",
       "      <td>Matthew A.</td>\n",
       "      <td>Cannady</td>\n",
       "      <td>1</td>\n",
       "      <td>07/28/2020</td>\n",
       "      <td>EAGER: SaTC-EDU: A transdisciplinary program f...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-07-28</td>\n",
       "      <td>Matthew A. Cannady</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>WASHINGTON</td>\n",
       "      <td>Digital Promise Global</td>\n",
       "      <td>DC</td>\n",
       "      <td>49952.0</td>\n",
       "      <td>2040753.0</td>\n",
       "      <td>Jeremy</td>\n",
       "      <td>Roschelle</td>\n",
       "      <td>1</td>\n",
       "      <td>07/16/2020</td>\n",
       "      <td>AI and the Future of STEM Learning: Engaging R...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-07-16</td>\n",
       "      <td>Jeremy Roschelle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>COLUMBUS</td>\n",
       "      <td>Ohio State University</td>\n",
       "      <td>OH</td>\n",
       "      <td>83529.0</td>\n",
       "      <td>2024736.0</td>\n",
       "      <td>Julie</td>\n",
       "      <td>Martin</td>\n",
       "      <td>1</td>\n",
       "      <td>07/09/2020</td>\n",
       "      <td>Collaborative Research: Research Initiation: E...</td>\n",
       "      <td>ai</td>\n",
       "      <td>2020-07-09</td>\n",
       "      <td>Julie Martin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency     awardeeCity                                        awardeeName  \\\n",
       "0     NSF         ATLANTA                  Georgia Tech Research Corporation   \n",
       "1     NSF          CORONA                           New York Hall of Science   \n",
       "2     NSF      PITTSBURGH                         Carnegie-Mellon University   \n",
       "3     NSF          BOSTON                            Northeastern University   \n",
       "4     NSF  SAN BERNARDINO        University Enterprises Corporation at CSUSB   \n",
       "5     NSF    FAYETTEVILLE                      Fayetteville State University   \n",
       "6     NSF   NEW BRUNSWICK                   Rutgers University New Brunswick   \n",
       "7     NSF      Richardson                      University of Texas at Dallas   \n",
       "8     NSF     LOS ANGELES                                       OPAL AI INC.   \n",
       "9     NSF      PITTSBURGH                         Carnegie-Mellon University   \n",
       "10    NSF         ATLANTA                  Georgia Tech Research Corporation   \n",
       "11    NSF           MIAMI                                 Miami Dade College   \n",
       "12    NSF         CLEMSON                                 Clemson University   \n",
       "13    NSF      GREENSBORO  North Carolina Agricultural & Technical State ...   \n",
       "14    NSF        NEW YORK                                New York University   \n",
       "15    NSF  WEST LAFAYETTE                                  Purdue University   \n",
       "16    NSF       Champaign         University of Illinois at Urbana-Champaign   \n",
       "17    NSF         BOULDER                  University of Colorado at Boulder   \n",
       "18    NSF    PHILADELPHIA                         University of Pennsylvania   \n",
       "19    NSF     LOS ANGELES               University of California-Los Angeles   \n",
       "20    NSF      NOTRE DAME                           University of Notre Dame   \n",
       "21    NSF  SALT LAKE CITY                                 University of Utah   \n",
       "22    NSF        BERKELEY                  University of California-Berkeley   \n",
       "23    NSF      WASHINGTON                             Digital Promise Global   \n",
       "24    NSF        COLUMBUS                              Ohio State University   \n",
       "\n",
       "   awardeeStateCode  fundsObligatedAmt         id piFirstName  \\\n",
       "0                GA           800000.0  2205152.0         Ali   \n",
       "1                NY            74971.0  2230850.0     Dorothy   \n",
       "2                PA           790631.0  2211882.0      Tianqi   \n",
       "3                MA           299375.0  2147220.0      Ronald   \n",
       "4                CA            97668.0  2142503.0      Yunfei   \n",
       "5                NC           397055.0  2205502.0      Sambit   \n",
       "6                NJ            20000.0  2137245.0       Jorge   \n",
       "7                TX            96488.0  2146448.0      Shuang   \n",
       "8                CA           276000.0  2126752.0    Shahrouz   \n",
       "9                PA           866000.0  2118924.0     Nikolas   \n",
       "10               GA          7980446.0  2112633.0       Sonia   \n",
       "11               FL           986535.0  2115153.0     Antonio   \n",
       "12               SC           146000.0  2114920.0        Long   \n",
       "13               NC           100000.0  2114936.0    Xiaohong   \n",
       "14               NY           299926.0  2103936.0      Carlos   \n",
       "15               IN           299934.0  2114974.0         Jin   \n",
       "16               IL           168670.0  2113955.0     Colleen   \n",
       "17               CO         11996931.0  2019805.0      Sidney   \n",
       "18               PA           500000.0  2020312.0      Konrad   \n",
       "19               CA            98280.0  2049670.0       James   \n",
       "20               IN                0.0  2008228.0        Dong   \n",
       "21               UT           316000.0  2041960.0      Eliane   \n",
       "22               CA           299987.0  2039637.0  Matthew A.   \n",
       "23               DC            49952.0  2040753.0      Jeremy   \n",
       "24               OH            83529.0  2024736.0       Julie   \n",
       "\n",
       "          piLastName publicAccessMandate        date  \\\n",
       "0              Adibi                   1  09/13/2022   \n",
       "1            Bennett                   1  08/31/2022   \n",
       "2               Chen                   1  08/22/2022   \n",
       "3            Sandler                   1  07/07/2022   \n",
       "4                Hou                   1  05/26/2022   \n",
       "5       Bhattacharya                   1  05/03/2022   \n",
       "6              Ortiz                   1  02/16/2022   \n",
       "7                Hao                   1  01/13/2022   \n",
       "8              Alimo                   1  01/03/2022   \n",
       "9          Martelaro                   1  08/12/2021   \n",
       "10          Chernova                   1  07/28/2021   \n",
       "11           Delgado                   1  07/12/2021   \n",
       "12             Cheng                   1  05/27/2021   \n",
       "13              Yuan                   1  05/27/2021   \n",
       "14  Fernandez Granda                   1  05/24/2021   \n",
       "15        Wei-Kocsis                   1  04/27/2021   \n",
       "16             Lewis                   1  04/27/2021   \n",
       "17           D'Mello                   1  08/25/2020   \n",
       "18           Kording                   1  08/25/2020   \n",
       "19             Davis                   1  08/21/2020   \n",
       "20              Wang                   1  08/21/2020   \n",
       "21             Wiese                   1  07/29/2020   \n",
       "22           Cannady                   1  07/28/2020   \n",
       "23         Roschelle                   1  07/16/2020   \n",
       "24            Martin                   1  07/09/2020   \n",
       "\n",
       "                                                title Topic        DATE  \\\n",
       "0   SCH: Intelligent Radiology Through Human-Machi...    ai  2022-09-13   \n",
       "1   Conference on Human-Centered Approaches to Art...    ai  2022-08-31   \n",
       "2   CNS: Medium: Ground up Adaptive Learning Syste...    ai  2022-08-22   \n",
       "3   Research Community Development Grant: Summer T...    ai  2022-07-07   \n",
       "4   Collaborative Research: Broadening Inclusive P...    ai  2022-05-26   \n",
       "5   Targeted Infusion Project: Exposing Students t...    ai  2022-05-03   \n",
       "6   IUCRC Planning Grant Rutgers University: Cente...    ai  2022-02-16   \n",
       "7   CAREER: Empowering White-box Driven Analytics ...    ai  2022-01-13   \n",
       "8   SBIR Phase I:  Autonomous Floorplan Reconstruc...    ai  2022-01-03   \n",
       "9   Supporting Designers in Learning to Co-create ...    ai  2021-08-12   \n",
       "10  AI Institute for Collaborative Assistance and ...    ai  2021-07-28   \n",
       "11  Artificial Intelligence For All: A Framework f...    ai  2021-07-12   \n",
       "12  Collaborative Research: EAGER: SaTC-EDU: Learn...    ai  2021-05-27   \n",
       "13  Collaborative Research: EAGER: SaTC-EDU: Learn...    ai  2021-05-27   \n",
       "14  Elements: Collaborative Research: Community-dr...    ai  2021-05-24   \n",
       "15  EAGER: SaTC-EDU: Cybersecurity Education in th...    ai  2021-04-27   \n",
       "16  Collaborative Research: EAGER: SaTC-EDU: Artif...    ai  2021-04-27   \n",
       "17    AI Institute:  Institute for Student-AI Teaming    ai  2020-08-25   \n",
       "18  AI Institute: Planning: From Biological Intell...    ai  2020-08-25   \n",
       "19  Workshop:  Aligning AI and U.S. Advanced Manuf...    ai  2020-08-21   \n",
       "20  CHS: Small: DeepCrowd: A Crowd-assisted Deep L...    ai  2020-08-21   \n",
       "21  EAGER: SaTC-EDU: Teaching Security in Undergra...    ai  2020-07-29   \n",
       "22  EAGER: SaTC-EDU: A transdisciplinary program f...    ai  2020-07-28   \n",
       "23  AI and the Future of STEM Learning: Engaging R...    ai  2020-07-16   \n",
       "24  Collaborative Research: Research Initiation: E...    ai  2020-07-09   \n",
       "\n",
       "                       NAME  \n",
       "0                 Ali Adibi  \n",
       "1           Dorothy Bennett  \n",
       "2               Tianqi Chen  \n",
       "3            Ronald Sandler  \n",
       "4                Yunfei Hou  \n",
       "5       Sambit Bhattacharya  \n",
       "6               Jorge Ortiz  \n",
       "7                Shuang Hao  \n",
       "8            Shahrouz Alimo  \n",
       "9         Nikolas Martelaro  \n",
       "10           Sonia Chernova  \n",
       "11          Antonio Delgado  \n",
       "12               Long Cheng  \n",
       "13            Xiaohong Yuan  \n",
       "14  Carlos Fernandez Granda  \n",
       "15           Jin Wei-Kocsis  \n",
       "16            Colleen Lewis  \n",
       "17           Sidney D'Mello  \n",
       "18           Konrad Kording  \n",
       "19              James Davis  \n",
       "20                Dong Wang  \n",
       "21             Eliane Wiese  \n",
       "22       Matthew A. Cannady  \n",
       "23         Jeremy Roschelle  \n",
       "24             Julie Martin  "
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "AI = df.loc[df['Topic']=='ai']\n",
    "AI"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "4f1a86a2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFIELD</td>\n",
       "      <td>Fairfield University</td>\n",
       "      <td>CT</td>\n",
       "      <td>63827.0</td>\n",
       "      <td>2245148.0</td>\n",
       "      <td>Xiaoli</td>\n",
       "      <td>Yang</td>\n",
       "      <td>1</td>\n",
       "      <td>10/20/2022</td>\n",
       "      <td>SaTC: EDU: Collaborative: INteractive VIsualiz...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-10-20</td>\n",
       "      <td>Xiaoli Yang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>URBANA</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>IL</td>\n",
       "      <td>6498601.0</td>\n",
       "      <td>2241313.0</td>\n",
       "      <td>James</td>\n",
       "      <td>Basney</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>CICI: CCoE: Trusted CI: Advancing Trustworthy ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>James Basney</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>University of New Hampshire</td>\n",
       "      <td>NH</td>\n",
       "      <td>399999.0</td>\n",
       "      <td>2154606.0</td>\n",
       "      <td>Qiaoyan</td>\n",
       "      <td>Yu</td>\n",
       "      <td>1</td>\n",
       "      <td>07/08/2022</td>\n",
       "      <td>SaTC: EDU: Building a Cyber Security Enhanced ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-07-08</td>\n",
       "      <td>Qiaoyan Yu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CLEVELAND</td>\n",
       "      <td>Lakeshore Technical College</td>\n",
       "      <td>WI</td>\n",
       "      <td>332076.0</td>\n",
       "      <td>2201993.0</td>\n",
       "      <td>Douglas</td>\n",
       "      <td>Hamm</td>\n",
       "      <td>1</td>\n",
       "      <td>06/13/2022</td>\n",
       "      <td>Developing Cybersecurity Technicians through E...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-06-13</td>\n",
       "      <td>Douglas Hamm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>MOBILE</td>\n",
       "      <td>University of South Alabama</td>\n",
       "      <td>AL</td>\n",
       "      <td>1056582.0</td>\n",
       "      <td>2142948.0</td>\n",
       "      <td>Todd</td>\n",
       "      <td>Andel</td>\n",
       "      <td>1</td>\n",
       "      <td>05/24/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service (Renewal): ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-24</td>\n",
       "      <td>Todd Andel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BALTIMORE</td>\n",
       "      <td>University of Maryland Baltimore County</td>\n",
       "      <td>MD</td>\n",
       "      <td>262209.0</td>\n",
       "      <td>2138921.0</td>\n",
       "      <td>Alan</td>\n",
       "      <td>Sherman</td>\n",
       "      <td>1</td>\n",
       "      <td>05/24/2022</td>\n",
       "      <td>Examining Pedagogy in Cybersecurity at Militar...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-24</td>\n",
       "      <td>Alan Sherman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NSF</td>\n",
       "      <td>DULUTH</td>\n",
       "      <td>University of Minnesota Duluth</td>\n",
       "      <td>MN</td>\n",
       "      <td>61412.0</td>\n",
       "      <td>2138934.0</td>\n",
       "      <td>Peter</td>\n",
       "      <td>Peterson</td>\n",
       "      <td>1</td>\n",
       "      <td>05/24/2022</td>\n",
       "      <td>Examining Pedagogy in Cybersecurity at Militar...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-24</td>\n",
       "      <td>Peter Peterson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NSF</td>\n",
       "      <td>URBANA</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>IL</td>\n",
       "      <td>176277.0</td>\n",
       "      <td>2138925.0</td>\n",
       "      <td>Geoffrey</td>\n",
       "      <td>Herman</td>\n",
       "      <td>1</td>\n",
       "      <td>05/24/2022</td>\n",
       "      <td>Examining Pedagogy in Cybersecurity at Militar...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-24</td>\n",
       "      <td>Geoffrey Herman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NSF</td>\n",
       "      <td>GREENSBORO</td>\n",
       "      <td>North Carolina Agricultural &amp; Technical State ...</td>\n",
       "      <td>NC</td>\n",
       "      <td>1338098.0</td>\n",
       "      <td>2146498.0</td>\n",
       "      <td>Xiaohong</td>\n",
       "      <td>Yuan</td>\n",
       "      <td>1</td>\n",
       "      <td>05/24/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service (Renewal): ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-24</td>\n",
       "      <td>Xiaohong Yuan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NSF</td>\n",
       "      <td>MOSCOW</td>\n",
       "      <td>Regents of the University of Idaho</td>\n",
       "      <td>ID</td>\n",
       "      <td>1410908.0</td>\n",
       "      <td>2146269.0</td>\n",
       "      <td>Jim</td>\n",
       "      <td>Alves-Foss</td>\n",
       "      <td>1</td>\n",
       "      <td>05/11/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service (Renewal): ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-11</td>\n",
       "      <td>Jim Alves-Foss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SAN ANTONIO</td>\n",
       "      <td>University of Texas at San Antonio</td>\n",
       "      <td>TX</td>\n",
       "      <td>1724840.0</td>\n",
       "      <td>2146466.0</td>\n",
       "      <td>Rajendra</td>\n",
       "      <td>Boppana</td>\n",
       "      <td>1</td>\n",
       "      <td>05/11/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service (Renewal): ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-11</td>\n",
       "      <td>Rajendra Boppana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOISE</td>\n",
       "      <td>Boise State University</td>\n",
       "      <td>ID</td>\n",
       "      <td>292359.0</td>\n",
       "      <td>2142622.0</td>\n",
       "      <td>Gaby</td>\n",
       "      <td>Dagher</td>\n",
       "      <td>1</td>\n",
       "      <td>05/11/2022</td>\n",
       "      <td>Enhancing Undergraduate Cybersecurity Educatio...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-11</td>\n",
       "      <td>Gaby Dagher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ALEXANDRIA</td>\n",
       "      <td>American Indian Higher Education Consortium</td>\n",
       "      <td>VA</td>\n",
       "      <td>299988.0</td>\n",
       "      <td>2226083.0</td>\n",
       "      <td>Carrie</td>\n",
       "      <td>Billy</td>\n",
       "      <td>1</td>\n",
       "      <td>05/03/2022</td>\n",
       "      <td>EAGER: Cybersecurity Project</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-05-03</td>\n",
       "      <td>Carrie Billy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>Marymount University</td>\n",
       "      <td>VA</td>\n",
       "      <td>1187413.0</td>\n",
       "      <td>2146278.0</td>\n",
       "      <td>Diane</td>\n",
       "      <td>Murphy</td>\n",
       "      <td>1</td>\n",
       "      <td>04/26/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service (Renewal) -...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-04-26</td>\n",
       "      <td>Diane Murphy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SALT LAKE CITY</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>UT</td>\n",
       "      <td>115281.0</td>\n",
       "      <td>2221870.0</td>\n",
       "      <td>Sameer</td>\n",
       "      <td>Patil</td>\n",
       "      <td>1</td>\n",
       "      <td>04/21/2022</td>\n",
       "      <td>SaTC: EDU: Collaborative: Incorporating Sociot...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-04-21</td>\n",
       "      <td>Sameer Patil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NSF</td>\n",
       "      <td>DULUTH</td>\n",
       "      <td>University of Minnesota Duluth</td>\n",
       "      <td>MN</td>\n",
       "      <td>366152.0</td>\n",
       "      <td>2146129.0</td>\n",
       "      <td>Peter</td>\n",
       "      <td>Peterson</td>\n",
       "      <td>1</td>\n",
       "      <td>04/05/2022</td>\n",
       "      <td>CAREER: Describing and Quantifying \"Adversaria...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-04-05</td>\n",
       "      <td>Peter Peterson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FORT LAUDERDALE</td>\n",
       "      <td>Broward College</td>\n",
       "      <td>FL</td>\n",
       "      <td>324191.0</td>\n",
       "      <td>2202122.0</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Pentzke</td>\n",
       "      <td>1</td>\n",
       "      <td>03/21/2022</td>\n",
       "      <td>CyberTech: Expanding Opportunities in Cybersec...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-03-21</td>\n",
       "      <td>Luis Pentzke</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NSF</td>\n",
       "      <td>DAYTONA BEACH</td>\n",
       "      <td>Embry-Riddle Aeronautical University</td>\n",
       "      <td>FL</td>\n",
       "      <td>1385922.0</td>\n",
       "      <td>2146462.0</td>\n",
       "      <td>Radu</td>\n",
       "      <td>Babiceanu</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: High-skill...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Radu Babiceanu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NSF</td>\n",
       "      <td>MEMPHIS</td>\n",
       "      <td>University of Memphis</td>\n",
       "      <td>TN</td>\n",
       "      <td>1261161.0</td>\n",
       "      <td>2146427.0</td>\n",
       "      <td>Kan</td>\n",
       "      <td>Yang</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: Developing...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Kan Yang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>NY</td>\n",
       "      <td>2130848.0</td>\n",
       "      <td>2142229.0</td>\n",
       "      <td>Thaier</td>\n",
       "      <td>Hayajneh</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: Preparing ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Thaier Hayajneh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BINGHAMTON</td>\n",
       "      <td>SUNY at Binghamton</td>\n",
       "      <td>NY</td>\n",
       "      <td>888631.0</td>\n",
       "      <td>2146212.0</td>\n",
       "      <td>Ping</td>\n",
       "      <td>Yang</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: Expanding ...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Ping Yang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia State University Research Foundation, ...</td>\n",
       "      <td>GA</td>\n",
       "      <td>1119210.0</td>\n",
       "      <td>2146497.0</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>Takabi</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: Cybersecur...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Daniel Takabi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>RENO</td>\n",
       "      <td>Board of Regents, NSHE, obo University of Neva...</td>\n",
       "      <td>NV</td>\n",
       "      <td>843567.0</td>\n",
       "      <td>2146146.0</td>\n",
       "      <td>Shamik</td>\n",
       "      <td>Sengupta</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service:  Preparing...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Shamik Sengupta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bloomington</td>\n",
       "      <td>Indiana University</td>\n",
       "      <td>IN</td>\n",
       "      <td>1127150.0</td>\n",
       "      <td>2146359.0</td>\n",
       "      <td>Feng</td>\n",
       "      <td>Li</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: Building t...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Feng Li</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Rochester</td>\n",
       "      <td>Oakland University</td>\n",
       "      <td>MI</td>\n",
       "      <td>1043203.0</td>\n",
       "      <td>2146280.0</td>\n",
       "      <td>Huirong</td>\n",
       "      <td>Fu</td>\n",
       "      <td>1</td>\n",
       "      <td>01/20/2022</td>\n",
       "      <td>CyberCorps Scholarship for Service: Cyber Defe...</td>\n",
       "      <td>cybersecurity</td>\n",
       "      <td>2022-01-20</td>\n",
       "      <td>Huirong Fu</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency      awardeeCity                                        awardeeName  \\\n",
       "0     NSF        FAIRFIELD                               Fairfield University   \n",
       "1     NSF           URBANA         University of Illinois at Urbana-Champaign   \n",
       "2     NSF           DURHAM                        University of New Hampshire   \n",
       "3     NSF        CLEVELAND                        Lakeshore Technical College   \n",
       "4     NSF           MOBILE                        University of South Alabama   \n",
       "5     NSF        BALTIMORE            University of Maryland Baltimore County   \n",
       "6     NSF           DULUTH                     University of Minnesota Duluth   \n",
       "7     NSF           URBANA         University of Illinois at Urbana-Champaign   \n",
       "8     NSF       GREENSBORO  North Carolina Agricultural & Technical State ...   \n",
       "9     NSF           MOSCOW                 Regents of the University of Idaho   \n",
       "10    NSF      SAN ANTONIO                 University of Texas at San Antonio   \n",
       "11    NSF            BOISE                             Boise State University   \n",
       "12    NSF       ALEXANDRIA        American Indian Higher Education Consortium   \n",
       "13    NSF        ARLINGTON                               Marymount University   \n",
       "14    NSF   SALT LAKE CITY                                 University of Utah   \n",
       "15    NSF           DULUTH                     University of Minnesota Duluth   \n",
       "16    NSF  FORT LAUDERDALE                                    Broward College   \n",
       "17    NSF    DAYTONA BEACH               Embry-Riddle Aeronautical University   \n",
       "18    NSF          MEMPHIS                              University of Memphis   \n",
       "19    NSF            BRONX                                 Fordham University   \n",
       "20    NSF       BINGHAMTON                                 SUNY at Binghamton   \n",
       "21    NSF          ATLANTA  Georgia State University Research Foundation, ...   \n",
       "22    NSF             RENO  Board of Regents, NSHE, obo University of Neva...   \n",
       "23    NSF      Bloomington                                 Indiana University   \n",
       "24    NSF        Rochester                                 Oakland University   \n",
       "\n",
       "   awardeeStateCode  fundsObligatedAmt         id piFirstName  piLastName  \\\n",
       "0                CT            63827.0  2245148.0      Xiaoli        Yang   \n",
       "1                IL          6498601.0  2241313.0       James      Basney   \n",
       "2                NH           399999.0  2154606.0     Qiaoyan          Yu   \n",
       "3                WI           332076.0  2201993.0     Douglas        Hamm   \n",
       "4                AL          1056582.0  2142948.0        Todd       Andel   \n",
       "5                MD           262209.0  2138921.0        Alan     Sherman   \n",
       "6                MN            61412.0  2138934.0       Peter    Peterson   \n",
       "7                IL           176277.0  2138925.0    Geoffrey      Herman   \n",
       "8                NC          1338098.0  2146498.0    Xiaohong        Yuan   \n",
       "9                ID          1410908.0  2146269.0         Jim  Alves-Foss   \n",
       "10               TX          1724840.0  2146466.0    Rajendra     Boppana   \n",
       "11               ID           292359.0  2142622.0        Gaby      Dagher   \n",
       "12               VA           299988.0  2226083.0      Carrie       Billy   \n",
       "13               VA          1187413.0  2146278.0       Diane      Murphy   \n",
       "14               UT           115281.0  2221870.0      Sameer       Patil   \n",
       "15               MN           366152.0  2146129.0       Peter    Peterson   \n",
       "16               FL           324191.0  2202122.0        Luis     Pentzke   \n",
       "17               FL          1385922.0  2146462.0        Radu   Babiceanu   \n",
       "18               TN          1261161.0  2146427.0         Kan        Yang   \n",
       "19               NY          2130848.0  2142229.0      Thaier    Hayajneh   \n",
       "20               NY           888631.0  2146212.0        Ping        Yang   \n",
       "21               GA          1119210.0  2146497.0      Daniel      Takabi   \n",
       "22               NV           843567.0  2146146.0      Shamik    Sengupta   \n",
       "23               IN          1127150.0  2146359.0        Feng          Li   \n",
       "24               MI          1043203.0  2146280.0     Huirong          Fu   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  10/20/2022   \n",
       "1                    1  08/31/2022   \n",
       "2                    1  07/08/2022   \n",
       "3                    1  06/13/2022   \n",
       "4                    1  05/24/2022   \n",
       "5                    1  05/24/2022   \n",
       "6                    1  05/24/2022   \n",
       "7                    1  05/24/2022   \n",
       "8                    1  05/24/2022   \n",
       "9                    1  05/11/2022   \n",
       "10                   1  05/11/2022   \n",
       "11                   1  05/11/2022   \n",
       "12                   1  05/03/2022   \n",
       "13                   1  04/26/2022   \n",
       "14                   1  04/21/2022   \n",
       "15                   1  04/05/2022   \n",
       "16                   1  03/21/2022   \n",
       "17                   1  01/20/2022   \n",
       "18                   1  01/20/2022   \n",
       "19                   1  01/20/2022   \n",
       "20                   1  01/20/2022   \n",
       "21                   1  01/20/2022   \n",
       "22                   1  01/20/2022   \n",
       "23                   1  01/20/2022   \n",
       "24                   1  01/20/2022   \n",
       "\n",
       "                                                title          Topic  \\\n",
       "0   SaTC: EDU: Collaborative: INteractive VIsualiz...  cybersecurity   \n",
       "1   CICI: CCoE: Trusted CI: Advancing Trustworthy ...  cybersecurity   \n",
       "2   SaTC: EDU: Building a Cyber Security Enhanced ...  cybersecurity   \n",
       "3   Developing Cybersecurity Technicians through E...  cybersecurity   \n",
       "4   CyberCorps Scholarship for Service (Renewal): ...  cybersecurity   \n",
       "5   Examining Pedagogy in Cybersecurity at Militar...  cybersecurity   \n",
       "6   Examining Pedagogy in Cybersecurity at Militar...  cybersecurity   \n",
       "7   Examining Pedagogy in Cybersecurity at Militar...  cybersecurity   \n",
       "8   CyberCorps Scholarship for Service (Renewal): ...  cybersecurity   \n",
       "9   CyberCorps Scholarship for Service (Renewal): ...  cybersecurity   \n",
       "10  CyberCorps Scholarship for Service (Renewal): ...  cybersecurity   \n",
       "11  Enhancing Undergraduate Cybersecurity Educatio...  cybersecurity   \n",
       "12                       EAGER: Cybersecurity Project  cybersecurity   \n",
       "13  CyberCorps Scholarship for Service (Renewal) -...  cybersecurity   \n",
       "14  SaTC: EDU: Collaborative: Incorporating Sociot...  cybersecurity   \n",
       "15  CAREER: Describing and Quantifying \"Adversaria...  cybersecurity   \n",
       "16  CyberTech: Expanding Opportunities in Cybersec...  cybersecurity   \n",
       "17  CyberCorps Scholarship for Service: High-skill...  cybersecurity   \n",
       "18  CyberCorps Scholarship for Service: Developing...  cybersecurity   \n",
       "19  CyberCorps Scholarship for Service: Preparing ...  cybersecurity   \n",
       "20  CyberCorps Scholarship for Service: Expanding ...  cybersecurity   \n",
       "21  CyberCorps Scholarship for Service: Cybersecur...  cybersecurity   \n",
       "22  CyberCorps Scholarship for Service:  Preparing...  cybersecurity   \n",
       "23  CyberCorps Scholarship for Service: Building t...  cybersecurity   \n",
       "24  CyberCorps Scholarship for Service: Cyber Defe...  cybersecurity   \n",
       "\n",
       "          DATE              NAME  \n",
       "0   2022-10-20       Xiaoli Yang  \n",
       "1   2022-08-31      James Basney  \n",
       "2   2022-07-08        Qiaoyan Yu  \n",
       "3   2022-06-13      Douglas Hamm  \n",
       "4   2022-05-24        Todd Andel  \n",
       "5   2022-05-24      Alan Sherman  \n",
       "6   2022-05-24    Peter Peterson  \n",
       "7   2022-05-24   Geoffrey Herman  \n",
       "8   2022-05-24     Xiaohong Yuan  \n",
       "9   2022-05-11    Jim Alves-Foss  \n",
       "10  2022-05-11  Rajendra Boppana  \n",
       "11  2022-05-11       Gaby Dagher  \n",
       "12  2022-05-03      Carrie Billy  \n",
       "13  2022-04-26      Diane Murphy  \n",
       "14  2022-04-21      Sameer Patil  \n",
       "15  2022-04-05    Peter Peterson  \n",
       "16  2022-03-21      Luis Pentzke  \n",
       "17  2022-01-20    Radu Babiceanu  \n",
       "18  2022-01-20          Kan Yang  \n",
       "19  2022-01-20   Thaier Hayajneh  \n",
       "20  2022-01-20         Ping Yang  \n",
       "21  2022-01-20     Daniel Takabi  \n",
       "22  2022-01-20   Shamik Sengupta  \n",
       "23  2022-01-20           Feng Li  \n",
       "24  2022-01-20        Huirong Fu  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cybersecurity = df.loc[df['Topic']=='cybersecurity']\n",
    "Cybersecurity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "b5f536c6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PRINCETON</td>\n",
       "      <td>Princeton University</td>\n",
       "      <td>NJ</td>\n",
       "      <td>108991.0</td>\n",
       "      <td>2236517.0</td>\n",
       "      <td>Sarang</td>\n",
       "      <td>Gopalakrishnan</td>\n",
       "      <td>1</td>\n",
       "      <td>11/25/2022</td>\n",
       "      <td>CAREER:   Quantum many-body physics beyond the...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-11-25</td>\n",
       "      <td>Sarang Gopalakrishnan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ITHACA</td>\n",
       "      <td>Cornell University</td>\n",
       "      <td>NY</td>\n",
       "      <td>253155.0</td>\n",
       "      <td>2304816.0</td>\n",
       "      <td>Mark</td>\n",
       "      <td>Wilde</td>\n",
       "      <td>1</td>\n",
       "      <td>11/03/2022</td>\n",
       "      <td>Quantifying and Optimizing the Performance of ...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-11-03</td>\n",
       "      <td>Mark Wilde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>TUCSON</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>AZ</td>\n",
       "      <td>595717.0</td>\n",
       "      <td>2204400.0</td>\n",
       "      <td>Pierre</td>\n",
       "      <td>Deymier</td>\n",
       "      <td>1</td>\n",
       "      <td>11/02/2022</td>\n",
       "      <td>Collaborative Research: CQIS: A Sound Leap (SouL)</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-11-02</td>\n",
       "      <td>Pierre Deymier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>University of California-Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>224651.0</td>\n",
       "      <td>2247007.0</td>\n",
       "      <td>Prineha</td>\n",
       "      <td>Narang</td>\n",
       "      <td>1</td>\n",
       "      <td>10/28/2022</td>\n",
       "      <td>U.S.-Ireland R&amp;D Partnership: Collaborative Re...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-10-28</td>\n",
       "      <td>Prineha Narang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Houston</td>\n",
       "      <td>William Marsh Rice University</td>\n",
       "      <td>TX</td>\n",
       "      <td>300000.0</td>\n",
       "      <td>2243659.0</td>\n",
       "      <td>Nai-Hui</td>\n",
       "      <td>Chia</td>\n",
       "      <td>1</td>\n",
       "      <td>10/12/2022</td>\n",
       "      <td>Collaborative Research: FET: Small: Minimum Qu...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-10-12</td>\n",
       "      <td>Nai-Hui Chia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NSF</td>\n",
       "      <td>College Park</td>\n",
       "      <td>University of Maryland, College Park</td>\n",
       "      <td>MD</td>\n",
       "      <td>359999.0</td>\n",
       "      <td>2219760.0</td>\n",
       "      <td>Mario</td>\n",
       "      <td>Dagenais</td>\n",
       "      <td>1</td>\n",
       "      <td>09/20/2022</td>\n",
       "      <td>Collaborative Research: Toward universal quant...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-09-20</td>\n",
       "      <td>Mario Dagenais</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>University of Southern California</td>\n",
       "      <td>CA</td>\n",
       "      <td>460000.0</td>\n",
       "      <td>2204667.0</td>\n",
       "      <td>Stephen</td>\n",
       "      <td>Cronin</td>\n",
       "      <td>1</td>\n",
       "      <td>09/15/2022</td>\n",
       "      <td>Charge State Conversion, Dynamics, and Single ...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-09-15</td>\n",
       "      <td>Stephen Cronin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NSF</td>\n",
       "      <td>AMHERST</td>\n",
       "      <td>SUNY at Buffalo</td>\n",
       "      <td>NY</td>\n",
       "      <td>237051.0</td>\n",
       "      <td>2243742.0</td>\n",
       "      <td>Herbert</td>\n",
       "      <td>Fotso</td>\n",
       "      <td>1</td>\n",
       "      <td>09/09/2022</td>\n",
       "      <td>Taming the Noisy Environment for Photon-Mediat...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-09-09</td>\n",
       "      <td>Herbert Fotso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NSF</td>\n",
       "      <td>GAINESVILLE</td>\n",
       "      <td>University of Florida</td>\n",
       "      <td>FL</td>\n",
       "      <td>1250000.0</td>\n",
       "      <td>2142552.0</td>\n",
       "      <td>Philip</td>\n",
       "      <td>Feng</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Collaborative Research: Innovating Quantum-Ins...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Philip Feng</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NSF</td>\n",
       "      <td>MINNEAPOLIS</td>\n",
       "      <td>University of Minnesota-Twin Cities</td>\n",
       "      <td>MN</td>\n",
       "      <td>750000.0</td>\n",
       "      <td>2142248.0</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1</td>\n",
       "      <td>08/31/2022</td>\n",
       "      <td>Collaborative Research: Innovating Quantum-Ins...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-31</td>\n",
       "      <td>Chris Kim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ITHACA</td>\n",
       "      <td>Cornell University</td>\n",
       "      <td>NY</td>\n",
       "      <td>2402082.0</td>\n",
       "      <td>2118310.0</td>\n",
       "      <td>Eun-Ah</td>\n",
       "      <td>Kim</td>\n",
       "      <td>1</td>\n",
       "      <td>08/30/2022</td>\n",
       "      <td>Quantum Integration of Data and Emergence at A...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-30</td>\n",
       "      <td>Eun-Ah Kim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NSF</td>\n",
       "      <td>TEMPE</td>\n",
       "      <td>Arizona State University</td>\n",
       "      <td>AZ</td>\n",
       "      <td>299999.0</td>\n",
       "      <td>2215998.0</td>\n",
       "      <td>Andreas</td>\n",
       "      <td>Spanias</td>\n",
       "      <td>1</td>\n",
       "      <td>08/30/2022</td>\n",
       "      <td>Quantum Machine Learning Online Materials and ...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-30</td>\n",
       "      <td>Andreas Spanias</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LOS ANGELES</td>\n",
       "      <td>University of Southern California</td>\n",
       "      <td>CA</td>\n",
       "      <td>107310.0</td>\n",
       "      <td>2240641.0</td>\n",
       "      <td>Quntao</td>\n",
       "      <td>Zhuang</td>\n",
       "      <td>1</td>\n",
       "      <td>08/29/2022</td>\n",
       "      <td>CAREER: Using Entanglement to Enhance Communic...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-29</td>\n",
       "      <td>Quntao Zhuang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BERKELEY</td>\n",
       "      <td>University of California-Berkeley</td>\n",
       "      <td>CA</td>\n",
       "      <td>539000.0</td>\n",
       "      <td>2216201.0</td>\n",
       "      <td>Dan</td>\n",
       "      <td>Stamper-Kurn</td>\n",
       "      <td>1</td>\n",
       "      <td>08/26/2022</td>\n",
       "      <td>MRI: Development of Rydberg Tweezer Quantum Pr...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-26</td>\n",
       "      <td>Dan Stamper-Kurn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NSF</td>\n",
       "      <td>URBANA</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>IL</td>\n",
       "      <td>399083.0</td>\n",
       "      <td>2223192.0</td>\n",
       "      <td>Kejie</td>\n",
       "      <td>Fang</td>\n",
       "      <td>1</td>\n",
       "      <td>08/23/2022</td>\n",
       "      <td>ECCS/EPMD: Single-photon quantum information p...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-23</td>\n",
       "      <td>Kejie Fang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CLEVELAND</td>\n",
       "      <td>Cleveland State University</td>\n",
       "      <td>OH</td>\n",
       "      <td>799985.0</td>\n",
       "      <td>2231377.0</td>\n",
       "      <td>Sathish</td>\n",
       "      <td>Kumar</td>\n",
       "      <td>1</td>\n",
       "      <td>08/23/2022</td>\n",
       "      <td>Expand QISE: Track 1:  RLQSC: Reinforcement Le...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-23</td>\n",
       "      <td>Sathish Kumar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>University of Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>499999.0</td>\n",
       "      <td>2155082.0</td>\n",
       "      <td>David</td>\n",
       "      <td>Mazziotti</td>\n",
       "      <td>1</td>\n",
       "      <td>08/23/2022</td>\n",
       "      <td>CDS&amp;E: Two-electron Reduced Density Matrices i...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-23</td>\n",
       "      <td>David Mazziotti</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NOTRE DAME</td>\n",
       "      <td>University of Notre Dame</td>\n",
       "      <td>IN</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>2224985.0</td>\n",
       "      <td>Peter</td>\n",
       "      <td>Kogge</td>\n",
       "      <td>1</td>\n",
       "      <td>08/18/2022</td>\n",
       "      <td>IUCRC Phase I  University of Notre Dame: Cente...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-18</td>\n",
       "      <td>Peter Kogge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BLOOMINGTON</td>\n",
       "      <td>Indiana University</td>\n",
       "      <td>IN</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>2224928.0</td>\n",
       "      <td>Gerardo</td>\n",
       "      <td>Ortiz</td>\n",
       "      <td>1</td>\n",
       "      <td>08/17/2022</td>\n",
       "      <td>IUCRC Phase I Indiana University: Center for Q...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-17</td>\n",
       "      <td>Gerardo Ortiz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PINE BLUFF</td>\n",
       "      <td>University of Arkansas at Pine Bluff</td>\n",
       "      <td>AR</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>2228891.0</td>\n",
       "      <td>Zeeshan</td>\n",
       "      <td>Habeeb</td>\n",
       "      <td>1</td>\n",
       "      <td>08/15/2022</td>\n",
       "      <td>ExpandQISE: Track 2: QuAPB, Expanding Quantum ...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-15</td>\n",
       "      <td>Zeeshan Habeeb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>HUNTSVILLE</td>\n",
       "      <td>University of Alabama in Huntsville</td>\n",
       "      <td>AL</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2231357.0</td>\n",
       "      <td>Jianqing</td>\n",
       "      <td>Liu</td>\n",
       "      <td>1</td>\n",
       "      <td>08/12/2022</td>\n",
       "      <td>ExpandQISE: Track 1: Virtual Quantum Networks:...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-12</td>\n",
       "      <td>Jianqing Liu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ARLINGTON</td>\n",
       "      <td>University of Texas at Arlington</td>\n",
       "      <td>TX</td>\n",
       "      <td>800000.0</td>\n",
       "      <td>2231388.0</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Vasilyev</td>\n",
       "      <td>1</td>\n",
       "      <td>08/12/2022</td>\n",
       "      <td>ExpandQISE Track 1: Quantum information exchan...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-12</td>\n",
       "      <td>Michael Vasilyev</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>POTSDAM</td>\n",
       "      <td>Clarkson University</td>\n",
       "      <td>NY</td>\n",
       "      <td>200000.0</td>\n",
       "      <td>2229074.0</td>\n",
       "      <td>Tuyen</td>\n",
       "      <td>Vu</td>\n",
       "      <td>1</td>\n",
       "      <td>08/08/2022</td>\n",
       "      <td>Collaborative Research: AMPS: Rethinking State...</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-08</td>\n",
       "      <td>Tuyen Vu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>CUNY Graduate School University Center</td>\n",
       "      <td>NY</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2209116.0</td>\n",
       "      <td>Vladimir</td>\n",
       "      <td>Rosenhaus</td>\n",
       "      <td>1</td>\n",
       "      <td>08/08/2022</td>\n",
       "      <td>Chaotic Dynamics and Quantum Field Theory</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-08</td>\n",
       "      <td>Vladimir Rosenhaus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOULDER</td>\n",
       "      <td>University of Colorado at Boulder</td>\n",
       "      <td>CO</td>\n",
       "      <td>421862.0</td>\n",
       "      <td>2209522.0</td>\n",
       "      <td>Konrad</td>\n",
       "      <td>Lehnert</td>\n",
       "      <td>1</td>\n",
       "      <td>08/05/2022</td>\n",
       "      <td>Collaborative Research: HAYSTAC Quantum Enhanced</td>\n",
       "      <td>quantum</td>\n",
       "      <td>2022-08-05</td>\n",
       "      <td>Konrad Lehnert</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency   awardeeCity                                 awardeeName  \\\n",
       "0     NSF     PRINCETON                        Princeton University   \n",
       "1     NSF        ITHACA                          Cornell University   \n",
       "2     NSF        TUCSON                       University of Arizona   \n",
       "3     NSF   LOS ANGELES        University of California-Los Angeles   \n",
       "4     NSF       Houston               William Marsh Rice University   \n",
       "5     NSF  College Park        University of Maryland, College Park   \n",
       "6     NSF   LOS ANGELES           University of Southern California   \n",
       "7     NSF       AMHERST                             SUNY at Buffalo   \n",
       "8     NSF   GAINESVILLE                       University of Florida   \n",
       "9     NSF   MINNEAPOLIS         University of Minnesota-Twin Cities   \n",
       "10    NSF        ITHACA                          Cornell University   \n",
       "11    NSF         TEMPE                    Arizona State University   \n",
       "12    NSF   LOS ANGELES           University of Southern California   \n",
       "13    NSF      BERKELEY           University of California-Berkeley   \n",
       "14    NSF        URBANA  University of Illinois at Urbana-Champaign   \n",
       "15    NSF     CLEVELAND                  Cleveland State University   \n",
       "16    NSF       CHICAGO                       University of Chicago   \n",
       "17    NSF    NOTRE DAME                    University of Notre Dame   \n",
       "18    NSF   BLOOMINGTON                          Indiana University   \n",
       "19    NSF    PINE BLUFF        University of Arkansas at Pine Bluff   \n",
       "20    NSF    HUNTSVILLE         University of Alabama in Huntsville   \n",
       "21    NSF     ARLINGTON            University of Texas at Arlington   \n",
       "22    NSF       POTSDAM                         Clarkson University   \n",
       "23    NSF      NEW YORK      CUNY Graduate School University Center   \n",
       "24    NSF       BOULDER           University of Colorado at Boulder   \n",
       "\n",
       "   awardeeStateCode  fundsObligatedAmt         id piFirstName      piLastName  \\\n",
       "0                NJ           108991.0  2236517.0      Sarang  Gopalakrishnan   \n",
       "1                NY           253155.0  2304816.0        Mark           Wilde   \n",
       "2                AZ           595717.0  2204400.0      Pierre         Deymier   \n",
       "3                CA           224651.0  2247007.0     Prineha          Narang   \n",
       "4                TX           300000.0  2243659.0     Nai-Hui            Chia   \n",
       "5                MD           359999.0  2219760.0       Mario        Dagenais   \n",
       "6                CA           460000.0  2204667.0     Stephen          Cronin   \n",
       "7                NY           237051.0  2243742.0     Herbert           Fotso   \n",
       "8                FL          1250000.0  2142552.0      Philip            Feng   \n",
       "9                MN           750000.0  2142248.0       Chris             Kim   \n",
       "10               NY          2402082.0  2118310.0      Eun-Ah             Kim   \n",
       "11               AZ           299999.0  2215998.0     Andreas         Spanias   \n",
       "12               CA           107310.0  2240641.0      Quntao          Zhuang   \n",
       "13               CA           539000.0  2216201.0         Dan    Stamper-Kurn   \n",
       "14               IL           399083.0  2223192.0       Kejie            Fang   \n",
       "15               OH           799985.0  2231377.0     Sathish           Kumar   \n",
       "16               IL           499999.0  2155082.0       David       Mazziotti   \n",
       "17               IN           105000.0  2224985.0       Peter           Kogge   \n",
       "18               IN           120000.0  2224928.0     Gerardo           Ortiz   \n",
       "19               AR          5000000.0  2228891.0     Zeeshan          Habeeb   \n",
       "20               AL                0.0  2231357.0    Jianqing             Liu   \n",
       "21               TX           800000.0  2231388.0     Michael        Vasilyev   \n",
       "22               NY           200000.0  2229074.0       Tuyen              Vu   \n",
       "23               NY            75000.0  2209116.0    Vladimir       Rosenhaus   \n",
       "24               CO           421862.0  2209522.0      Konrad         Lehnert   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  11/25/2022   \n",
       "1                    1  11/03/2022   \n",
       "2                    1  11/02/2022   \n",
       "3                    1  10/28/2022   \n",
       "4                    1  10/12/2022   \n",
       "5                    1  09/20/2022   \n",
       "6                    1  09/15/2022   \n",
       "7                    1  09/09/2022   \n",
       "8                    1  08/31/2022   \n",
       "9                    1  08/31/2022   \n",
       "10                   1  08/30/2022   \n",
       "11                   1  08/30/2022   \n",
       "12                   1  08/29/2022   \n",
       "13                   1  08/26/2022   \n",
       "14                   1  08/23/2022   \n",
       "15                   1  08/23/2022   \n",
       "16                   1  08/23/2022   \n",
       "17                   1  08/18/2022   \n",
       "18                   1  08/17/2022   \n",
       "19                   1  08/15/2022   \n",
       "20                   1  08/12/2022   \n",
       "21                   1  08/12/2022   \n",
       "22                   1  08/08/2022   \n",
       "23                   1  08/08/2022   \n",
       "24                   1  08/05/2022   \n",
       "\n",
       "                                                title    Topic        DATE  \\\n",
       "0   CAREER:   Quantum many-body physics beyond the...  quantum  2022-11-25   \n",
       "1   Quantifying and Optimizing the Performance of ...  quantum  2022-11-03   \n",
       "2   Collaborative Research: CQIS: A Sound Leap (SouL)  quantum  2022-11-02   \n",
       "3   U.S.-Ireland R&D Partnership: Collaborative Re...  quantum  2022-10-28   \n",
       "4   Collaborative Research: FET: Small: Minimum Qu...  quantum  2022-10-12   \n",
       "5   Collaborative Research: Toward universal quant...  quantum  2022-09-20   \n",
       "6   Charge State Conversion, Dynamics, and Single ...  quantum  2022-09-15   \n",
       "7   Taming the Noisy Environment for Photon-Mediat...  quantum  2022-09-09   \n",
       "8   Collaborative Research: Innovating Quantum-Ins...  quantum  2022-08-31   \n",
       "9   Collaborative Research: Innovating Quantum-Ins...  quantum  2022-08-31   \n",
       "10  Quantum Integration of Data and Emergence at A...  quantum  2022-08-30   \n",
       "11  Quantum Machine Learning Online Materials and ...  quantum  2022-08-30   \n",
       "12  CAREER: Using Entanglement to Enhance Communic...  quantum  2022-08-29   \n",
       "13  MRI: Development of Rydberg Tweezer Quantum Pr...  quantum  2022-08-26   \n",
       "14  ECCS/EPMD: Single-photon quantum information p...  quantum  2022-08-23   \n",
       "15  Expand QISE: Track 1:  RLQSC: Reinforcement Le...  quantum  2022-08-23   \n",
       "16  CDS&E: Two-electron Reduced Density Matrices i...  quantum  2022-08-23   \n",
       "17  IUCRC Phase I  University of Notre Dame: Cente...  quantum  2022-08-18   \n",
       "18  IUCRC Phase I Indiana University: Center for Q...  quantum  2022-08-17   \n",
       "19  ExpandQISE: Track 2: QuAPB, Expanding Quantum ...  quantum  2022-08-15   \n",
       "20  ExpandQISE: Track 1: Virtual Quantum Networks:...  quantum  2022-08-12   \n",
       "21  ExpandQISE Track 1: Quantum information exchan...  quantum  2022-08-12   \n",
       "22  Collaborative Research: AMPS: Rethinking State...  quantum  2022-08-08   \n",
       "23          Chaotic Dynamics and Quantum Field Theory  quantum  2022-08-08   \n",
       "24   Collaborative Research: HAYSTAC Quantum Enhanced  quantum  2022-08-05   \n",
       "\n",
       "                     NAME  \n",
       "0   Sarang Gopalakrishnan  \n",
       "1              Mark Wilde  \n",
       "2          Pierre Deymier  \n",
       "3          Prineha Narang  \n",
       "4            Nai-Hui Chia  \n",
       "5          Mario Dagenais  \n",
       "6          Stephen Cronin  \n",
       "7           Herbert Fotso  \n",
       "8             Philip Feng  \n",
       "9               Chris Kim  \n",
       "10             Eun-Ah Kim  \n",
       "11        Andreas Spanias  \n",
       "12          Quntao Zhuang  \n",
       "13       Dan Stamper-Kurn  \n",
       "14             Kejie Fang  \n",
       "15          Sathish Kumar  \n",
       "16        David Mazziotti  \n",
       "17            Peter Kogge  \n",
       "18          Gerardo Ortiz  \n",
       "19         Zeeshan Habeeb  \n",
       "20           Jianqing Liu  \n",
       "21       Michael Vasilyev  \n",
       "22               Tuyen Vu  \n",
       "23     Vladimir Rosenhaus  \n",
       "24         Konrad Lehnert  "
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Quantum = df.loc[df['Topic']=='quantum']\n",
    "Quantum"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "338d706e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>STORRS</td>\n",
       "      <td>University of Connecticut</td>\n",
       "      <td>CT</td>\n",
       "      <td>16662.0</td>\n",
       "      <td>2219336.0</td>\n",
       "      <td>Jun</td>\n",
       "      <td>Yan</td>\n",
       "      <td>1</td>\n",
       "      <td>04/29/2022</td>\n",
       "      <td>Conference: UConn Sports Analytics Symposium: ...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2022-04-29</td>\n",
       "      <td>Jun Yan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>HOUSTON</td>\n",
       "      <td>AIRMETTLE, INC.</td>\n",
       "      <td>TX</td>\n",
       "      <td>276000.0</td>\n",
       "      <td>2135007.0</td>\n",
       "      <td>Donpaul</td>\n",
       "      <td>Stephens</td>\n",
       "      <td>1</td>\n",
       "      <td>02/09/2022</td>\n",
       "      <td>STTR Phase I:  Real-Time Smart Data Lake</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2022-02-09</td>\n",
       "      <td>Donpaul Stephens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>COLUMBUS</td>\n",
       "      <td>Ohio State University</td>\n",
       "      <td>OH</td>\n",
       "      <td>311411.0</td>\n",
       "      <td>2110259.0</td>\n",
       "      <td>Jia</td>\n",
       "      <td>Liu</td>\n",
       "      <td>1</td>\n",
       "      <td>03/16/2021</td>\n",
       "      <td>CAREER: Computing-Aware Network Optimization f...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2021-03-16</td>\n",
       "      <td>Jia Liu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>DAYTON</td>\n",
       "      <td>Sinclair Community College</td>\n",
       "      <td>OH</td>\n",
       "      <td>576315.0</td>\n",
       "      <td>2055411.0</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Hansford</td>\n",
       "      <td>1</td>\n",
       "      <td>03/15/2021</td>\n",
       "      <td>Expanding the Data Analytics Technician Pipeli...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2021-03-15</td>\n",
       "      <td>Paul Hansford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOCA RATON</td>\n",
       "      <td>Florida Atlantic University</td>\n",
       "      <td>FL</td>\n",
       "      <td>95751.0</td>\n",
       "      <td>2027890.0</td>\n",
       "      <td>Borko</td>\n",
       "      <td>Furht</td>\n",
       "      <td>1</td>\n",
       "      <td>06/09/2020</td>\n",
       "      <td>NSF RAPID: Modeling Corona Spread Using Big Da...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2020-06-09</td>\n",
       "      <td>Borko Furht</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LAFAYETTE</td>\n",
       "      <td>University of Louisiana at Lafayette</td>\n",
       "      <td>LA</td>\n",
       "      <td>187477.0</td>\n",
       "      <td>2027688.0</td>\n",
       "      <td>Raju</td>\n",
       "      <td>Gottumukkala</td>\n",
       "      <td>1</td>\n",
       "      <td>05/20/2020</td>\n",
       "      <td>RAPID: Visual Analytics Approach to Real-Time ...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2020-05-20</td>\n",
       "      <td>Raju Gottumukkala</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NSF</td>\n",
       "      <td>AMES</td>\n",
       "      <td>Iowa State University</td>\n",
       "      <td>IA</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1943226.0</td>\n",
       "      <td>Jia</td>\n",
       "      <td>Liu</td>\n",
       "      <td>1</td>\n",
       "      <td>03/12/2020</td>\n",
       "      <td>CAREER: Computing-Aware Network Optimization f...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>Jia Liu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BLOOMINGTON</td>\n",
       "      <td>Indiana University</td>\n",
       "      <td>IN</td>\n",
       "      <td>45398.0</td>\n",
       "      <td>1934942.0</td>\n",
       "      <td>Patricia</td>\n",
       "      <td>Herzog</td>\n",
       "      <td>1</td>\n",
       "      <td>05/20/2019</td>\n",
       "      <td>Workshop:  Addressing Technology and Skills Ga...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2019-05-20</td>\n",
       "      <td>Patricia Herzog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>University of Washington</td>\n",
       "      <td>WA</td>\n",
       "      <td>124657.0</td>\n",
       "      <td>1929901.0</td>\n",
       "      <td>Huijia</td>\n",
       "      <td>Lin</td>\n",
       "      <td>0</td>\n",
       "      <td>04/18/2019</td>\n",
       "      <td>TWC: Medium: Collaborative: Seal: Secure Engin...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2019-04-18</td>\n",
       "      <td>Huijia Lin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NSF</td>\n",
       "      <td>COLLEGE STATION</td>\n",
       "      <td>Texas A&amp;M Engineering Experiment Station</td>\n",
       "      <td>TX</td>\n",
       "      <td>449380.0</td>\n",
       "      <td>1922969.0</td>\n",
       "      <td>Shuiwang</td>\n",
       "      <td>Ji</td>\n",
       "      <td>0</td>\n",
       "      <td>02/22/2019</td>\n",
       "      <td>CAREER: Towards the Next Generation of Data-Dr...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2019-02-22</td>\n",
       "      <td>Shuiwang Ji</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NSF</td>\n",
       "      <td>CHARLOTTE</td>\n",
       "      <td>University of North Carolina at Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>299237.0</td>\n",
       "      <td>1839812.0</td>\n",
       "      <td>Valentina</td>\n",
       "      <td>Cecchi</td>\n",
       "      <td>1</td>\n",
       "      <td>09/19/2018</td>\n",
       "      <td>EAGER: Real-Time:  Visual Analytics for Enhanc...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2018-09-19</td>\n",
       "      <td>Valentina Cecchi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PULLMAN</td>\n",
       "      <td>Washington State University</td>\n",
       "      <td>WA</td>\n",
       "      <td>49992.0</td>\n",
       "      <td>1836329.0</td>\n",
       "      <td>Anurag</td>\n",
       "      <td>Srivastava</td>\n",
       "      <td>1</td>\n",
       "      <td>07/31/2018</td>\n",
       "      <td>Workshop on Real Time Data Analytics for Resil...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>Anurag Srivastava</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Waukesha</td>\n",
       "      <td>Carroll University</td>\n",
       "      <td>WI</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1824727.0</td>\n",
       "      <td>John</td>\n",
       "      <td>Symms</td>\n",
       "      <td>1</td>\n",
       "      <td>07/03/2018</td>\n",
       "      <td>Synthesis and Design Workshop: Digital Science...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2018-07-03</td>\n",
       "      <td>John Symms</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NSF</td>\n",
       "      <td>HONOLULU</td>\n",
       "      <td>University of Hawaii</td>\n",
       "      <td>HI</td>\n",
       "      <td>221951.0</td>\n",
       "      <td>1801190.0</td>\n",
       "      <td>Wayne</td>\n",
       "      <td>Lewis</td>\n",
       "      <td>1</td>\n",
       "      <td>03/30/2018</td>\n",
       "      <td>Development of a Data Analytics Education Pathway</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2018-03-30</td>\n",
       "      <td>Wayne Lewis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NEWARK</td>\n",
       "      <td>Rutgers University Newark</td>\n",
       "      <td>NJ</td>\n",
       "      <td>299888.0</td>\n",
       "      <td>1747728.0</td>\n",
       "      <td>Vijayalakshmi</td>\n",
       "      <td>Atluri</td>\n",
       "      <td>1</td>\n",
       "      <td>03/22/2018</td>\n",
       "      <td>IUCRC Phase I Rutgers, Newark: Center for Acce...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2018-03-22</td>\n",
       "      <td>Vijayalakshmi Atluri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NSF</td>\n",
       "      <td>COLUMBUS</td>\n",
       "      <td>Columbus State Community College</td>\n",
       "      <td>OH</td>\n",
       "      <td>689189.0</td>\n",
       "      <td>1700454.0</td>\n",
       "      <td>Gloria</td>\n",
       "      <td>Rogiers</td>\n",
       "      <td>1</td>\n",
       "      <td>06/26/2017</td>\n",
       "      <td>Data Analytics Technician Advancement (DATA) P...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2017-06-26</td>\n",
       "      <td>Gloria Rogiers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>250001.0</td>\n",
       "      <td>1636783.0</td>\n",
       "      <td>Santiago</td>\n",
       "      <td>Grijalva</td>\n",
       "      <td>1</td>\n",
       "      <td>09/12/2016</td>\n",
       "      <td>BD Spokes: SPOKE: SOUTH: Collaborative: Smart ...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>Santiago Grijalva</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>Temple University</td>\n",
       "      <td>PA</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1636770.0</td>\n",
       "      <td>Zoran</td>\n",
       "      <td>Obradovic</td>\n",
       "      <td>1</td>\n",
       "      <td>09/12/2016</td>\n",
       "      <td>BD Spokes: SPOKE: SOUTH: Collaborative: Smart ...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>Zoran Obradovic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Boston</td>\n",
       "      <td>EDWISETECH INC</td>\n",
       "      <td>MA</td>\n",
       "      <td>1046010.0</td>\n",
       "      <td>1632481.0</td>\n",
       "      <td>Nishikant</td>\n",
       "      <td>Sonwalkar</td>\n",
       "      <td>1</td>\n",
       "      <td>08/17/2016</td>\n",
       "      <td>SBIR Phase II:  Big data Analytics Driven Adap...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-08-17</td>\n",
       "      <td>Nishikant Sonwalkar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SALT LAKE CITY</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>UT</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>1619287.0</td>\n",
       "      <td>Jeff</td>\n",
       "      <td>Phillips</td>\n",
       "      <td>0</td>\n",
       "      <td>06/30/2016</td>\n",
       "      <td>III: Small: Towards a Database Engine for Inte...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>Jeff Phillips</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FORT COLLINS</td>\n",
       "      <td>Colorado State University</td>\n",
       "      <td>CO</td>\n",
       "      <td>507243.0</td>\n",
       "      <td>1553685.0</td>\n",
       "      <td>Sangmi</td>\n",
       "      <td>Pallickara</td>\n",
       "      <td>0</td>\n",
       "      <td>05/12/2016</td>\n",
       "      <td>CAREER: A Framework for Ad Hoc Model Construct...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-05-12</td>\n",
       "      <td>Sangmi Pallickara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>Georgia Tech Research Corporation</td>\n",
       "      <td>GA</td>\n",
       "      <td>1199999.0</td>\n",
       "      <td>1564097.0</td>\n",
       "      <td>Ling</td>\n",
       "      <td>Liu</td>\n",
       "      <td>0</td>\n",
       "      <td>03/28/2016</td>\n",
       "      <td>TWC: Medium: Privacy Preserving Computation in...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-03-28</td>\n",
       "      <td>Ling Liu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>LAS CRUCES</td>\n",
       "      <td>New Mexico State University</td>\n",
       "      <td>NM</td>\n",
       "      <td>359151.0</td>\n",
       "      <td>1559723.0</td>\n",
       "      <td>Huiping</td>\n",
       "      <td>Cao</td>\n",
       "      <td>0</td>\n",
       "      <td>02/26/2016</td>\n",
       "      <td>REU Site: BIGDatA - Big Data Analytics for Cyb...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2016-02-26</td>\n",
       "      <td>Huiping Cao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>New Haven</td>\n",
       "      <td>SIAS Global LLC</td>\n",
       "      <td>CT</td>\n",
       "      <td>179997.0</td>\n",
       "      <td>1548900.0</td>\n",
       "      <td>Russell</td>\n",
       "      <td>Schimmer</td>\n",
       "      <td>0</td>\n",
       "      <td>12/21/2015</td>\n",
       "      <td>SBIR Phase I:  A geospatial technology innovat...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2015-12-21</td>\n",
       "      <td>Russell Schimmer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PRAIRIE VIEW</td>\n",
       "      <td>Prairie View A &amp; M University</td>\n",
       "      <td>TX</td>\n",
       "      <td>297872.0</td>\n",
       "      <td>1543214.0</td>\n",
       "      <td>Lei</td>\n",
       "      <td>Huang</td>\n",
       "      <td>0</td>\n",
       "      <td>09/04/2015</td>\n",
       "      <td>PFI: AIR-TT:  Developing a Prototype for the N...</td>\n",
       "      <td>data analytics</td>\n",
       "      <td>2015-09-04</td>\n",
       "      <td>Lei Huang</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency      awardeeCity                                awardeeName  \\\n",
       "0     NSF           STORRS                  University of Connecticut   \n",
       "1     NSF          HOUSTON                            AIRMETTLE, INC.   \n",
       "2     NSF         COLUMBUS                      Ohio State University   \n",
       "3     NSF           DAYTON                 Sinclair Community College   \n",
       "4     NSF       BOCA RATON                Florida Atlantic University   \n",
       "5     NSF        LAFAYETTE       University of Louisiana at Lafayette   \n",
       "6     NSF             AMES                      Iowa State University   \n",
       "7     NSF      BLOOMINGTON                         Indiana University   \n",
       "8     NSF          Seattle                   University of Washington   \n",
       "9     NSF  COLLEGE STATION   Texas A&M Engineering Experiment Station   \n",
       "10    NSF        CHARLOTTE  University of North Carolina at Charlotte   \n",
       "11    NSF          PULLMAN                Washington State University   \n",
       "12    NSF         Waukesha                         Carroll University   \n",
       "13    NSF         HONOLULU                       University of Hawaii   \n",
       "14    NSF           NEWARK                  Rutgers University Newark   \n",
       "15    NSF         COLUMBUS           Columbus State Community College   \n",
       "16    NSF          ATLANTA          Georgia Tech Research Corporation   \n",
       "17    NSF     Philadelphia                          Temple University   \n",
       "18    NSF           Boston                             EDWISETECH INC   \n",
       "19    NSF   SALT LAKE CITY                         University of Utah   \n",
       "20    NSF     FORT COLLINS                  Colorado State University   \n",
       "21    NSF          ATLANTA          Georgia Tech Research Corporation   \n",
       "22    NSF       LAS CRUCES                New Mexico State University   \n",
       "23    NSF        New Haven                            SIAS Global LLC   \n",
       "24    NSF     PRAIRIE VIEW              Prairie View A & M University   \n",
       "\n",
       "   awardeeStateCode  fundsObligatedAmt         id    piFirstName  \\\n",
       "0                CT            16662.0  2219336.0            Jun   \n",
       "1                TX           276000.0  2135007.0        Donpaul   \n",
       "2                OH           311411.0  2110259.0            Jia   \n",
       "3                OH           576315.0  2055411.0           Paul   \n",
       "4                FL            95751.0  2027890.0          Borko   \n",
       "5                LA           187477.0  2027688.0           Raju   \n",
       "6                IA                0.0  1943226.0            Jia   \n",
       "7                IN            45398.0  1934942.0       Patricia   \n",
       "8                WA           124657.0  1929901.0         Huijia   \n",
       "9                TX           449380.0  1922969.0       Shuiwang   \n",
       "10               NC           299237.0  1839812.0      Valentina   \n",
       "11               WA            49992.0  1836329.0         Anurag   \n",
       "12               WI           100000.0  1824727.0           John   \n",
       "13               HI           221951.0  1801190.0          Wayne   \n",
       "14               NJ           299888.0  1747728.0  Vijayalakshmi   \n",
       "15               OH           689189.0  1700454.0         Gloria   \n",
       "16               GA           250001.0  1636783.0       Santiago   \n",
       "17               PA           100000.0  1636770.0          Zoran   \n",
       "18               MA          1046010.0  1632481.0      Nishikant   \n",
       "19               UT           500000.0  1619287.0           Jeff   \n",
       "20               CO           507243.0  1553685.0         Sangmi   \n",
       "21               GA          1199999.0  1564097.0           Ling   \n",
       "22               NM           359151.0  1559723.0        Huiping   \n",
       "23               CT           179997.0  1548900.0        Russell   \n",
       "24               TX           297872.0  1543214.0            Lei   \n",
       "\n",
       "      piLastName publicAccessMandate        date  \\\n",
       "0            Yan                   1  04/29/2022   \n",
       "1       Stephens                   1  02/09/2022   \n",
       "2            Liu                   1  03/16/2021   \n",
       "3       Hansford                   1  03/15/2021   \n",
       "4          Furht                   1  06/09/2020   \n",
       "5   Gottumukkala                   1  05/20/2020   \n",
       "6            Liu                   1  03/12/2020   \n",
       "7         Herzog                   1  05/20/2019   \n",
       "8            Lin                   0  04/18/2019   \n",
       "9             Ji                   0  02/22/2019   \n",
       "10        Cecchi                   1  09/19/2018   \n",
       "11    Srivastava                   1  07/31/2018   \n",
       "12         Symms                   1  07/03/2018   \n",
       "13         Lewis                   1  03/30/2018   \n",
       "14        Atluri                   1  03/22/2018   \n",
       "15       Rogiers                   1  06/26/2017   \n",
       "16      Grijalva                   1  09/12/2016   \n",
       "17     Obradovic                   1  09/12/2016   \n",
       "18     Sonwalkar                   1  08/17/2016   \n",
       "19      Phillips                   0  06/30/2016   \n",
       "20    Pallickara                   0  05/12/2016   \n",
       "21           Liu                   0  03/28/2016   \n",
       "22           Cao                   0  02/26/2016   \n",
       "23      Schimmer                   0  12/21/2015   \n",
       "24         Huang                   0  09/04/2015   \n",
       "\n",
       "                                                title           Topic  \\\n",
       "0   Conference: UConn Sports Analytics Symposium: ...  data analytics   \n",
       "1            STTR Phase I:  Real-Time Smart Data Lake  data analytics   \n",
       "2   CAREER: Computing-Aware Network Optimization f...  data analytics   \n",
       "3   Expanding the Data Analytics Technician Pipeli...  data analytics   \n",
       "4   NSF RAPID: Modeling Corona Spread Using Big Da...  data analytics   \n",
       "5   RAPID: Visual Analytics Approach to Real-Time ...  data analytics   \n",
       "6   CAREER: Computing-Aware Network Optimization f...  data analytics   \n",
       "7   Workshop:  Addressing Technology and Skills Ga...  data analytics   \n",
       "8   TWC: Medium: Collaborative: Seal: Secure Engin...  data analytics   \n",
       "9   CAREER: Towards the Next Generation of Data-Dr...  data analytics   \n",
       "10  EAGER: Real-Time:  Visual Analytics for Enhanc...  data analytics   \n",
       "11  Workshop on Real Time Data Analytics for Resil...  data analytics   \n",
       "12  Synthesis and Design Workshop: Digital Science...  data analytics   \n",
       "13  Development of a Data Analytics Education Pathway  data analytics   \n",
       "14  IUCRC Phase I Rutgers, Newark: Center for Acce...  data analytics   \n",
       "15  Data Analytics Technician Advancement (DATA) P...  data analytics   \n",
       "16  BD Spokes: SPOKE: SOUTH: Collaborative: Smart ...  data analytics   \n",
       "17  BD Spokes: SPOKE: SOUTH: Collaborative: Smart ...  data analytics   \n",
       "18  SBIR Phase II:  Big data Analytics Driven Adap...  data analytics   \n",
       "19  III: Small: Towards a Database Engine for Inte...  data analytics   \n",
       "20  CAREER: A Framework for Ad Hoc Model Construct...  data analytics   \n",
       "21  TWC: Medium: Privacy Preserving Computation in...  data analytics   \n",
       "22  REU Site: BIGDatA - Big Data Analytics for Cyb...  data analytics   \n",
       "23  SBIR Phase I:  A geospatial technology innovat...  data analytics   \n",
       "24  PFI: AIR-TT:  Developing a Prototype for the N...  data analytics   \n",
       "\n",
       "          DATE                  NAME  \n",
       "0   2022-04-29               Jun Yan  \n",
       "1   2022-02-09      Donpaul Stephens  \n",
       "2   2021-03-16               Jia Liu  \n",
       "3   2021-03-15         Paul Hansford  \n",
       "4   2020-06-09           Borko Furht  \n",
       "5   2020-05-20     Raju Gottumukkala  \n",
       "6   2020-03-12               Jia Liu  \n",
       "7   2019-05-20       Patricia Herzog  \n",
       "8   2019-04-18            Huijia Lin  \n",
       "9   2019-02-22           Shuiwang Ji  \n",
       "10  2018-09-19      Valentina Cecchi  \n",
       "11  2018-07-31     Anurag Srivastava  \n",
       "12  2018-07-03            John Symms  \n",
       "13  2018-03-30           Wayne Lewis  \n",
       "14  2018-03-22  Vijayalakshmi Atluri  \n",
       "15  2017-06-26        Gloria Rogiers  \n",
       "16  2016-09-12     Santiago Grijalva  \n",
       "17  2016-09-12       Zoran Obradovic  \n",
       "18  2016-08-17   Nishikant Sonwalkar  \n",
       "19  2016-06-30         Jeff Phillips  \n",
       "20  2016-05-12     Sangmi Pallickara  \n",
       "21  2016-03-28              Ling Liu  \n",
       "22  2016-02-26           Huiping Cao  \n",
       "23  2015-12-21      Russell Schimmer  \n",
       "24  2015-09-04             Lei Huang  "
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_analytics = df.loc[df['Topic']=='data analytics']\n",
    "data_analytics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "bc1eeeaf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>agency</th>\n",
       "      <th>awardeeCity</th>\n",
       "      <th>awardeeName</th>\n",
       "      <th>awardeeStateCode</th>\n",
       "      <th>fundsObligatedAmt</th>\n",
       "      <th>id</th>\n",
       "      <th>piFirstName</th>\n",
       "      <th>piLastName</th>\n",
       "      <th>publicAccessMandate</th>\n",
       "      <th>date</th>\n",
       "      <th>title</th>\n",
       "      <th>Topic</th>\n",
       "      <th>DATE</th>\n",
       "      <th>NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BETHLEHEM</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>3239138.0</td>\n",
       "      <td>2037771.0</td>\n",
       "      <td>James</td>\n",
       "      <td>Ricles</td>\n",
       "      <td>1</td>\n",
       "      <td>12/09/2020</td>\n",
       "      <td>Natural Hazards Engineering Research Infrastru...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2020-12-09</td>\n",
       "      <td>James Ricles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NSF</td>\n",
       "      <td>COLUMBIA</td>\n",
       "      <td>University of South Carolina at Columbia</td>\n",
       "      <td>SC</td>\n",
       "      <td>167916.0</td>\n",
       "      <td>1913073.0</td>\n",
       "      <td>Zhu</td>\n",
       "      <td>Wang</td>\n",
       "      <td>1</td>\n",
       "      <td>07/10/2019</td>\n",
       "      <td>Efficient Numerical Simulations of Oceanic Flo...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2019-07-10</td>\n",
       "      <td>Zhu Wang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NSF</td>\n",
       "      <td>GOLDEN</td>\n",
       "      <td>Colorado School of Mines</td>\n",
       "      <td>CO</td>\n",
       "      <td>186640.0</td>\n",
       "      <td>1855491.0</td>\n",
       "      <td>Mohsen</td>\n",
       "      <td>Asle Zaeem</td>\n",
       "      <td>0</td>\n",
       "      <td>12/07/2018</td>\n",
       "      <td>Multiscale Modeling and Experimental Study of ...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-12-07</td>\n",
       "      <td>Mohsen Asle Zaeem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PASADENA</td>\n",
       "      <td>California Institute of Technology</td>\n",
       "      <td>CA</td>\n",
       "      <td>2499842.0</td>\n",
       "      <td>1835860.0</td>\n",
       "      <td>Tapio</td>\n",
       "      <td>Schneider</td>\n",
       "      <td>1</td>\n",
       "      <td>09/07/2018</td>\n",
       "      <td>Collaborative Research: HDR: Data-Driven Earth...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-09-07</td>\n",
       "      <td>Tapio Schneider</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NSF</td>\n",
       "      <td>PROVO</td>\n",
       "      <td>Brigham Young University</td>\n",
       "      <td>UT</td>\n",
       "      <td>408436.0</td>\n",
       "      <td>1834332.0</td>\n",
       "      <td>Mark</td>\n",
       "      <td>Transtrum</td>\n",
       "      <td>1</td>\n",
       "      <td>08/27/2018</td>\n",
       "      <td>Collaborative Research: Reliable Materials Sim...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>Mark Transtrum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NSF</td>\n",
       "      <td>MINNEAPOLIS</td>\n",
       "      <td>University of Minnesota-Twin Cities</td>\n",
       "      <td>MN</td>\n",
       "      <td>2739630.0</td>\n",
       "      <td>1834251.0</td>\n",
       "      <td>Ellad</td>\n",
       "      <td>Tadmor</td>\n",
       "      <td>1</td>\n",
       "      <td>08/27/2018</td>\n",
       "      <td>Collaborative Research: Reliable Materials Sim...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>Ellad Tadmor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BETHLEHEM</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>663531.0</td>\n",
       "      <td>1810695.0</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>1</td>\n",
       "      <td>06/18/2018</td>\n",
       "      <td>Modeling and Simulation of Bacterial Outer Mem...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOULDER</td>\n",
       "      <td>University of Colorado at Boulder</td>\n",
       "      <td>CO</td>\n",
       "      <td>427414.0</td>\n",
       "      <td>1802017.0</td>\n",
       "      <td>Wangda</td>\n",
       "      <td>Zuo</td>\n",
       "      <td>1</td>\n",
       "      <td>05/15/2018</td>\n",
       "      <td>BIGDATA: Collaborative Research: IA: Big Data ...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-05-15</td>\n",
       "      <td>Wangda Zuo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NSF</td>\n",
       "      <td>College Station</td>\n",
       "      <td>Texas A&amp;M University</td>\n",
       "      <td>TX</td>\n",
       "      <td>133726.0</td>\n",
       "      <td>1800957.0</td>\n",
       "      <td>Amir</td>\n",
       "      <td>Behzadan</td>\n",
       "      <td>0</td>\n",
       "      <td>02/05/2018</td>\n",
       "      <td>Real-Time Feedback-Enabled Simulation Modeling...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2018-02-05</td>\n",
       "      <td>Amir Behzadan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NSF</td>\n",
       "      <td>NASHVILLE</td>\n",
       "      <td>Vanderbilt University</td>\n",
       "      <td>TN</td>\n",
       "      <td>4000000.0</td>\n",
       "      <td>1743772.0</td>\n",
       "      <td>Janos</td>\n",
       "      <td>Sztipanovits</td>\n",
       "      <td>1</td>\n",
       "      <td>08/30/2017</td>\n",
       "      <td>PIRE: Science of Design for Societal-Scale Cyb...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-30</td>\n",
       "      <td>Janos Sztipanovits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NSF</td>\n",
       "      <td>COLUMBUS</td>\n",
       "      <td>Ohio State University</td>\n",
       "      <td>OH</td>\n",
       "      <td>296924.0</td>\n",
       "      <td>1729086.0</td>\n",
       "      <td>Jinwoo</td>\n",
       "      <td>Hwang</td>\n",
       "      <td>1</td>\n",
       "      <td>08/15/2017</td>\n",
       "      <td>DMREF: Collaborative Research: Predictive Mode...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-15</td>\n",
       "      <td>Jinwoo Hwang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SPRINGFIELD</td>\n",
       "      <td>Missouri State University</td>\n",
       "      <td>MO</td>\n",
       "      <td>111121.0</td>\n",
       "      <td>1729176.0</td>\n",
       "      <td>Ridwan</td>\n",
       "      <td>Sakidja</td>\n",
       "      <td>1</td>\n",
       "      <td>08/15/2017</td>\n",
       "      <td>DMREF: Collaborative Research: Predictive Mode...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-15</td>\n",
       "      <td>Ridwan Sakidja</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NSF</td>\n",
       "      <td>KANSAS CITY</td>\n",
       "      <td>University of Missouri-Kansas City</td>\n",
       "      <td>MO</td>\n",
       "      <td>791955.0</td>\n",
       "      <td>1729227.0</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Rulis</td>\n",
       "      <td>1</td>\n",
       "      <td>08/15/2017</td>\n",
       "      <td>DMREF: Collaborative Research: Predictive Mode...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-15</td>\n",
       "      <td>Paul Rulis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NSF</td>\n",
       "      <td>SALT LAKE CITY</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>UT</td>\n",
       "      <td>2024452.0</td>\n",
       "      <td>1664175.0</td>\n",
       "      <td>Steven</td>\n",
       "      <td>Krueger</td>\n",
       "      <td>1</td>\n",
       "      <td>08/14/2017</td>\n",
       "      <td>PREEVENTS Track 2: A fast-response wildland fi...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-14</td>\n",
       "      <td>Steven Krueger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Fayetteville</td>\n",
       "      <td>University of Arkansas</td>\n",
       "      <td>AR</td>\n",
       "      <td>200000.0</td>\n",
       "      <td>1745353.0</td>\n",
       "      <td>Haitao</td>\n",
       "      <td>Liao</td>\n",
       "      <td>1</td>\n",
       "      <td>08/05/2017</td>\n",
       "      <td>EAGER: SSDIM: Data Simulation to Support Inter...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-05</td>\n",
       "      <td>Haitao Liao</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NSF</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>University of Texas at Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>391354.0</td>\n",
       "      <td>1728313.0</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Cullinan</td>\n",
       "      <td>1</td>\n",
       "      <td>08/03/2017</td>\n",
       "      <td>GOALI: Manufacturing USA: Determining the Role...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-08-03</td>\n",
       "      <td>Michael Cullinan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOULDER</td>\n",
       "      <td>University Corporation For Atmospheric Res</td>\n",
       "      <td>CO</td>\n",
       "      <td>1179732.0</td>\n",
       "      <td>1663978.0</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Knievel</td>\n",
       "      <td>1</td>\n",
       "      <td>07/11/2017</td>\n",
       "      <td>PREEVENTS Track 2: Collaborative Research: Mor...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-07-11</td>\n",
       "      <td>Jason Knievel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Aurora</td>\n",
       "      <td>University of Colorado at Denver-Downtown Campus</td>\n",
       "      <td>CO</td>\n",
       "      <td>333746.0</td>\n",
       "      <td>1705630.0</td>\n",
       "      <td>Kannan</td>\n",
       "      <td>Premnath</td>\n",
       "      <td>1</td>\n",
       "      <td>06/09/2017</td>\n",
       "      <td>Computational Investigation of the Effects of ...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-06-09</td>\n",
       "      <td>Kannan Premnath</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Cambridge</td>\n",
       "      <td>Massachusetts Institute of Technology</td>\n",
       "      <td>MA</td>\n",
       "      <td>230000.0</td>\n",
       "      <td>1730389.0</td>\n",
       "      <td>Evelyn</td>\n",
       "      <td>Wang</td>\n",
       "      <td>1</td>\n",
       "      <td>05/09/2017</td>\n",
       "      <td>CI-New:  Collaborative Research:  Modeling the...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-05-09</td>\n",
       "      <td>Evelyn Wang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NSF</td>\n",
       "      <td>BOSTON</td>\n",
       "      <td>Trustees of Boston University</td>\n",
       "      <td>MA</td>\n",
       "      <td>233964.0</td>\n",
       "      <td>1730316.0</td>\n",
       "      <td>Ayse</td>\n",
       "      <td>Coskun</td>\n",
       "      <td>1</td>\n",
       "      <td>05/09/2017</td>\n",
       "      <td>CI-New:   Collaborative Research: Modeling the...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-05-09</td>\n",
       "      <td>Ayse Coskun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Johns Hopkins University</td>\n",
       "      <td>MD</td>\n",
       "      <td>300000.0</td>\n",
       "      <td>1708602.0</td>\n",
       "      <td>Mauro</td>\n",
       "      <td>Maggioni</td>\n",
       "      <td>0</td>\n",
       "      <td>04/28/2017</td>\n",
       "      <td>Statistical Learning for High-Dimensional Stoc...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>Mauro Maggioni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NSF</td>\n",
       "      <td>FAIRFAX</td>\n",
       "      <td>George Mason University</td>\n",
       "      <td>VA</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1658908.0</td>\n",
       "      <td>John</td>\n",
       "      <td>Shortle</td>\n",
       "      <td>1</td>\n",
       "      <td>03/08/2017</td>\n",
       "      <td>Workshop: Towards an Ecosystem of Simulation M...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-03-08</td>\n",
       "      <td>John Shortle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>346157.0</td>\n",
       "      <td>1727508.0</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>01/20/2017</td>\n",
       "      <td>Bacterial Outer Membranes and Interactions wit...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2017-01-20</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NSF</td>\n",
       "      <td>Bethlehem</td>\n",
       "      <td>Lehigh University</td>\n",
       "      <td>PA</td>\n",
       "      <td>546826.0</td>\n",
       "      <td>1707207.0</td>\n",
       "      <td>Wonpil</td>\n",
       "      <td>Im</td>\n",
       "      <td>0</td>\n",
       "      <td>11/04/2016</td>\n",
       "      <td>ABI Innovation: Development of Glycan Modeling...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-04</td>\n",
       "      <td>Wonpil Im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NSF</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>MI</td>\n",
       "      <td>114000000.0</td>\n",
       "      <td>1565546.0</td>\n",
       "      <td>Bradley</td>\n",
       "      <td>Sherrill</td>\n",
       "      <td>0</td>\n",
       "      <td>11/03/2016</td>\n",
       "      <td>Operation of the NSCL as a National User Facil...</td>\n",
       "      <td>modeling and simulation</td>\n",
       "      <td>2016-11-03</td>\n",
       "      <td>Bradley Sherrill</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   agency      awardeeCity                                       awardeeName  \\\n",
       "0     NSF        BETHLEHEM                                 Lehigh University   \n",
       "1     NSF         COLUMBIA          University of South Carolina at Columbia   \n",
       "2     NSF           GOLDEN                          Colorado School of Mines   \n",
       "3     NSF         PASADENA                California Institute of Technology   \n",
       "4     NSF            PROVO                          Brigham Young University   \n",
       "5     NSF      MINNEAPOLIS               University of Minnesota-Twin Cities   \n",
       "6     NSF        BETHLEHEM                                 Lehigh University   \n",
       "7     NSF          BOULDER                 University of Colorado at Boulder   \n",
       "8     NSF  College Station                              Texas A&M University   \n",
       "9     NSF        NASHVILLE                             Vanderbilt University   \n",
       "10    NSF         COLUMBUS                             Ohio State University   \n",
       "11    NSF      SPRINGFIELD                         Missouri State University   \n",
       "12    NSF      KANSAS CITY                University of Missouri-Kansas City   \n",
       "13    NSF   SALT LAKE CITY                                University of Utah   \n",
       "14    NSF     Fayetteville                            University of Arkansas   \n",
       "15    NSF           AUSTIN                     University of Texas at Austin   \n",
       "16    NSF          BOULDER        University Corporation For Atmospheric Res   \n",
       "17    NSF           Aurora  University of Colorado at Denver-Downtown Campus   \n",
       "18    NSF        Cambridge             Massachusetts Institute of Technology   \n",
       "19    NSF           BOSTON                     Trustees of Boston University   \n",
       "20    NSF        Baltimore                          Johns Hopkins University   \n",
       "21    NSF          FAIRFAX                           George Mason University   \n",
       "22    NSF        Bethlehem                                 Lehigh University   \n",
       "23    NSF        Bethlehem                                 Lehigh University   \n",
       "24    NSF     EAST LANSING                         Michigan State University   \n",
       "\n",
       "   awardeeStateCode  fundsObligatedAmt         id piFirstName    piLastName  \\\n",
       "0                PA          3239138.0  2037771.0       James        Ricles   \n",
       "1                SC           167916.0  1913073.0         Zhu          Wang   \n",
       "2                CO           186640.0  1855491.0      Mohsen    Asle Zaeem   \n",
       "3                CA          2499842.0  1835860.0       Tapio     Schneider   \n",
       "4                UT           408436.0  1834332.0        Mark     Transtrum   \n",
       "5                MN          2739630.0  1834251.0       Ellad        Tadmor   \n",
       "6                PA           663531.0  1810695.0      Wonpil            Im   \n",
       "7                CO           427414.0  1802017.0      Wangda           Zuo   \n",
       "8                TX           133726.0  1800957.0        Amir      Behzadan   \n",
       "9                TN          4000000.0  1743772.0       Janos  Sztipanovits   \n",
       "10               OH           296924.0  1729086.0      Jinwoo         Hwang   \n",
       "11               MO           111121.0  1729176.0      Ridwan       Sakidja   \n",
       "12               MO           791955.0  1729227.0        Paul         Rulis   \n",
       "13               UT          2024452.0  1664175.0      Steven       Krueger   \n",
       "14               AR           200000.0  1745353.0      Haitao          Liao   \n",
       "15               TX           391354.0  1728313.0     Michael      Cullinan   \n",
       "16               CO          1179732.0  1663978.0       Jason       Knievel   \n",
       "17               CO           333746.0  1705630.0      Kannan      Premnath   \n",
       "18               MA           230000.0  1730389.0      Evelyn          Wang   \n",
       "19               MA           233964.0  1730316.0        Ayse        Coskun   \n",
       "20               MD           300000.0  1708602.0       Mauro      Maggioni   \n",
       "21               VA             5000.0  1658908.0        John       Shortle   \n",
       "22               PA           346157.0  1727508.0      Wonpil            Im   \n",
       "23               PA           546826.0  1707207.0      Wonpil            Im   \n",
       "24               MI        114000000.0  1565546.0     Bradley      Sherrill   \n",
       "\n",
       "   publicAccessMandate        date  \\\n",
       "0                    1  12/09/2020   \n",
       "1                    1  07/10/2019   \n",
       "2                    0  12/07/2018   \n",
       "3                    1  09/07/2018   \n",
       "4                    1  08/27/2018   \n",
       "5                    1  08/27/2018   \n",
       "6                    1  06/18/2018   \n",
       "7                    1  05/15/2018   \n",
       "8                    0  02/05/2018   \n",
       "9                    1  08/30/2017   \n",
       "10                   1  08/15/2017   \n",
       "11                   1  08/15/2017   \n",
       "12                   1  08/15/2017   \n",
       "13                   1  08/14/2017   \n",
       "14                   1  08/05/2017   \n",
       "15                   1  08/03/2017   \n",
       "16                   1  07/11/2017   \n",
       "17                   1  06/09/2017   \n",
       "18                   1  05/09/2017   \n",
       "19                   1  05/09/2017   \n",
       "20                   0  04/28/2017   \n",
       "21                   1  03/08/2017   \n",
       "22                   0  01/20/2017   \n",
       "23                   0  11/04/2016   \n",
       "24                   0  11/03/2016   \n",
       "\n",
       "                                                title  \\\n",
       "0   Natural Hazards Engineering Research Infrastru...   \n",
       "1   Efficient Numerical Simulations of Oceanic Flo...   \n",
       "2   Multiscale Modeling and Experimental Study of ...   \n",
       "3   Collaborative Research: HDR: Data-Driven Earth...   \n",
       "4   Collaborative Research: Reliable Materials Sim...   \n",
       "5   Collaborative Research: Reliable Materials Sim...   \n",
       "6   Modeling and Simulation of Bacterial Outer Mem...   \n",
       "7   BIGDATA: Collaborative Research: IA: Big Data ...   \n",
       "8   Real-Time Feedback-Enabled Simulation Modeling...   \n",
       "9   PIRE: Science of Design for Societal-Scale Cyb...   \n",
       "10  DMREF: Collaborative Research: Predictive Mode...   \n",
       "11  DMREF: Collaborative Research: Predictive Mode...   \n",
       "12  DMREF: Collaborative Research: Predictive Mode...   \n",
       "13  PREEVENTS Track 2: A fast-response wildland fi...   \n",
       "14  EAGER: SSDIM: Data Simulation to Support Inter...   \n",
       "15  GOALI: Manufacturing USA: Determining the Role...   \n",
       "16  PREEVENTS Track 2: Collaborative Research: Mor...   \n",
       "17  Computational Investigation of the Effects of ...   \n",
       "18  CI-New:  Collaborative Research:  Modeling the...   \n",
       "19  CI-New:   Collaborative Research: Modeling the...   \n",
       "20  Statistical Learning for High-Dimensional Stoc...   \n",
       "21  Workshop: Towards an Ecosystem of Simulation M...   \n",
       "22  Bacterial Outer Membranes and Interactions wit...   \n",
       "23  ABI Innovation: Development of Glycan Modeling...   \n",
       "24  Operation of the NSCL as a National User Facil...   \n",
       "\n",
       "                      Topic        DATE                NAME  \n",
       "0   modeling and simulation  2020-12-09        James Ricles  \n",
       "1   modeling and simulation  2019-07-10            Zhu Wang  \n",
       "2   modeling and simulation  2018-12-07   Mohsen Asle Zaeem  \n",
       "3   modeling and simulation  2018-09-07     Tapio Schneider  \n",
       "4   modeling and simulation  2018-08-27      Mark Transtrum  \n",
       "5   modeling and simulation  2018-08-27        Ellad Tadmor  \n",
       "6   modeling and simulation  2018-06-18           Wonpil Im  \n",
       "7   modeling and simulation  2018-05-15          Wangda Zuo  \n",
       "8   modeling and simulation  2018-02-05       Amir Behzadan  \n",
       "9   modeling and simulation  2017-08-30  Janos Sztipanovits  \n",
       "10  modeling and simulation  2017-08-15        Jinwoo Hwang  \n",
       "11  modeling and simulation  2017-08-15      Ridwan Sakidja  \n",
       "12  modeling and simulation  2017-08-15          Paul Rulis  \n",
       "13  modeling and simulation  2017-08-14      Steven Krueger  \n",
       "14  modeling and simulation  2017-08-05         Haitao Liao  \n",
       "15  modeling and simulation  2017-08-03    Michael Cullinan  \n",
       "16  modeling and simulation  2017-07-11       Jason Knievel  \n",
       "17  modeling and simulation  2017-06-09     Kannan Premnath  \n",
       "18  modeling and simulation  2017-05-09         Evelyn Wang  \n",
       "19  modeling and simulation  2017-05-09         Ayse Coskun  \n",
       "20  modeling and simulation  2017-04-28      Mauro Maggioni  \n",
       "21  modeling and simulation  2017-03-08        John Shortle  \n",
       "22  modeling and simulation  2017-01-20           Wonpil Im  \n",
       "23  modeling and simulation  2016-11-04           Wonpil Im  \n",
       "24  modeling and simulation  2016-11-03    Bradley Sherrill  "
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "modeling_simulation = df.loc[df['Topic']=='modeling and simulation']\n",
    "modeling_simulation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6bf5e63a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.6"
  },
  "vscode": {
   "interpreter": {
    "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}