notebooks/Getting Started with DataJoint.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Getting Started with DataJoint"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datajoint as dj"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating your first schema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "schema = dj.schema('university')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating your first table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "@schema\n",
    "class Student(dj.Manual):\n",
    "    definition = \"\"\"\n",
    "    student_id : int unsigned   # university-wide ID number\n",
    "    ---\n",
    "    first_name      : varchar(40)\n",
    "    last_name       : varchar(40)\n",
    "    sex             : enum('F', 'M', 'U')\n",
    "    \"\"\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting an entry as a dictionary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "Student.insert1({\n",
    "    'student_id': 1, \n",
    "    'first_name': 'Alice', \n",
    "    'last_name': 'Anderson', \n",
    "    'sex': 'F'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td> </tr> </tbody>\n",
       "            </table>\n",
       "            \n",
       "            <p>Total: 1</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       " (Total: 1)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting an entry as a tuple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "Student.insert1((2, 'Bob', 'Dylan', 'M'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td> </tr> </tbody>\n",
       "            </table>\n",
       "            \n",
       "            <p>Total: 2</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       " (Total: 2)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "Student.insert1((3, 'Carol', 'Lewis', 'F'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td></tr><tr><td>3</td>\n",
       "<td>Carol</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td> </tr> </tbody>\n",
       "            </table>\n",
       "            \n",
       "            <p>Total: 3</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       "3              Carol          Lewis         F      \n",
       " (Total: 3)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting multiple entries as a list of dictionaries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "students = [\n",
    "    {'student_id': 4, 'first_name': 'Chris', 'last_name': 'Smith', 'sex': 'M'},\n",
    "    {'student_id': 5, 'first_name': 'Stella', 'last_name': 'Taylor', 'sex': 'F'},\n",
    "    {'student_id': 6, 'first_name': 'Max', 'last_name': 'Scott', 'sex': 'M'}\n",
    "]\n",
    "Student.insert(students)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td></tr><tr><td>3</td>\n",
       "<td>Carol</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td></tr><tr><td>4</td>\n",
       "<td>Chris</td>\n",
       "<td>Smith</td>\n",
       "<td>M</td></tr><tr><td>5</td>\n",
       "<td>Stella</td>\n",
       "<td>Taylor</td>\n",
       "<td>F</td></tr><tr><td>6</td>\n",
       "<td>Max</td>\n",
       "<td>Scott</td>\n",
       "<td>M</td> </tr> </tbody>\n",
       "            </table>\n",
       "            \n",
       "            <p>Total: 6</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       "3              Carol          Lewis         F      \n",
       "4              Chris          Smith         M      \n",
       "5              Stella         Taylor        F      \n",
       "6              Max            Scott         M      \n",
       " (Total: 6)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting multiple entries as a list of tuples"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "students = [\n",
    "    (7, 'John', 'Allen', 'M'),\n",
    "    (8, 'Julia', 'White', 'F'),\n",
    "    (9, 'Emma', 'Reed', 'F')\n",
    "]\n",
    "Student.insert(students)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td></tr><tr><td>3</td>\n",
       "<td>Carol</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td></tr><tr><td>4</td>\n",
       "<td>Chris</td>\n",
       "<td>Smith</td>\n",
       "<td>M</td></tr><tr><td>5</td>\n",
       "<td>Stella</td>\n",
       "<td>Taylor</td>\n",
       "<td>F</td></tr><tr><td>6</td>\n",
       "<td>Max</td>\n",
       "<td>Scott</td>\n",
       "<td>M</td></tr><tr><td>7</td>\n",
       "<td>John</td>\n",
       "<td>Allen</td>\n",
       "<td>M</td></tr><tr><td>8</td>\n",
       "<td>Julia</td>\n",
       "<td>White</td>\n",
       "<td>F</td></tr><tr><td>9</td>\n",
       "<td>Emma</td>\n",
       "<td>Reed</td>\n",
       "<td>F</td> </tr> </tbody>\n",
       "            </table>\n",
       "            \n",
       "            <p>Total: 9</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       "3              Carol          Lewis         F      \n",
       "4              Chris          Smith         M      \n",
       "5              Stella         Taylor        F      \n",
       "6              Max            Scott         M      \n",
       "7              John           Allen         M      \n",
       "8              Julia          White         F      \n",
       "9              Emma           Reed          F      \n",
       " (Total: 9)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dropping a table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "`university`.`student` (9 tuples)\n",
      "Proceed? [yes, No]: yes\n",
      "Tables dropped.  Restart kernel.\n"
     ]
    }
   ],
   "source": [
    "Student.drop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "@schema\n",
    "class Student(dj.Manual):\n",
    "    definition = \"\"\"\n",
    "    student_id : int unsigned   # university-wide ID number\n",
    "    ---\n",
    "    first_name      : varchar(40)\n",
    "    last_name       : varchar(40)\n",
    "    sex             : enum('F', 'M', 'U')\n",
    "    date_of_birth   : date\n",
    "    home_address    : varchar(120) # mailing street address\n",
    "    home_city       : varchar(60)  # mailing address\n",
    "    home_state      : char(2)      # US state acronym: e.g. OH\n",
    "    home_zip        : char(10)     # zipcode e.g. 93979-4979\n",
    "    home_phone      : varchar(20)  # e.g. 414.657.6883x0881\n",
    "    \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "import insert_students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "insert_students.insert(Student, 300)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">date_of_birth</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_address</p>\n",
       "                                <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_city</p>\n",
       "                                <span class=\"djtooltiptext\">mailing address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_state</p>\n",
       "                                <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_zip</p>\n",
       "                                <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_phone</p>\n",
       "                                <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>0</td>\n",
       "<td>Matthew</td>\n",
       "<td>Miles</td>\n",
       "<td>M</td>\n",
       "<td>1985-11-11</td>\n",
       "<td>279 Joseph Estate Apt. 874</td>\n",
       "<td>Masonstad</td>\n",
       "<td>WA</td>\n",
       "<td>26544</td>\n",
       "<td>830-541-2678</td></tr><tr><td>1</td>\n",
       "<td>Willie</td>\n",
       "<td>May</td>\n",
       "<td>M</td>\n",
       "<td>1995-04-21</td>\n",
       "<td>5509 Cross Canyon</td>\n",
       "<td>West Todd</td>\n",
       "<td>NE</td>\n",
       "<td>51244</td>\n",
       "<td>5774925367</td></tr><tr><td>2</td>\n",
       "<td>David</td>\n",
       "<td>Boone</td>\n",
       "<td>M</td>\n",
       "<td>1984-12-17</td>\n",
       "<td>03892 Amy Rapid Apt. 123</td>\n",
       "<td>Marybury</td>\n",
       "<td>OK</td>\n",
       "<td>21149</td>\n",
       "<td>164.601.2816</td></tr><tr><td>3</td>\n",
       "<td>Derek</td>\n",
       "<td>Barrett</td>\n",
       "<td>M</td>\n",
       "<td>2000-07-04</td>\n",
       "<td>93045 Pamela Plain</td>\n",
       "<td>North Bradymouth</td>\n",
       "<td>SD</td>\n",
       "<td>33618</td>\n",
       "<td>519-951-7205x52305</td></tr><tr><td>4</td>\n",
       "<td>Albert</td>\n",
       "<td>Davis</td>\n",
       "<td>M</td>\n",
       "<td>1994-01-15</td>\n",
       "<td>442 Jacob Bypass Apt. 357</td>\n",
       "<td>Lake Brendan</td>\n",
       "<td>CT</td>\n",
       "<td>87296</td>\n",
       "<td>977-228-5606x062</td></tr><tr><td>5</td>\n",
       "<td>Erika</td>\n",
       "<td>Phillips</td>\n",
       "<td>F</td>\n",
       "<td>1988-03-31</td>\n",
       "<td>911 Tiffany Pike Apt. 570</td>\n",
       "<td>Christophertown</td>\n",
       "<td>UT</td>\n",
       "<td>56135</td>\n",
       "<td>(889)801-9551x4395</td></tr><tr><td>6</td>\n",
       "<td>Lucas</td>\n",
       "<td>Thomas</td>\n",
       "<td>M</td>\n",
       "<td>2002-01-05</td>\n",
       "<td>810 Williams Dale Apt. 270</td>\n",
       "<td>Port Hannahport</td>\n",
       "<td>AK</td>\n",
       "<td>66875</td>\n",
       "<td>1407435812</td></tr><tr><td>7</td>\n",
       "<td>Nancy</td>\n",
       "<td>Fox</td>\n",
       "<td>F</td>\n",
       "<td>1984-05-16</td>\n",
       "<td>96581 Jackson Ports</td>\n",
       "<td>Lake Ianmouth</td>\n",
       "<td>LA</td>\n",
       "<td>32046</td>\n",
       "<td>5707101635</td></tr><tr><td>8</td>\n",
       "<td>Deborah</td>\n",
       "<td>Vincent</td>\n",
       "<td>F</td>\n",
       "<td>2001-01-10</td>\n",
       "<td>237 Elizabeth Pass Suite 178</td>\n",
       "<td>North Jennifer</td>\n",
       "<td>UT</td>\n",
       "<td>37335</td>\n",
       "<td>+1-696-997-1635x317</td></tr><tr><td>9</td>\n",
       "<td>Stephanie</td>\n",
       "<td>Koch</td>\n",
       "<td>F</td>\n",
       "<td>1993-06-12</td>\n",
       "<td>8303 Tiffany Rest</td>\n",
       "<td>Wilsonview</td>\n",
       "<td>MA</td>\n",
       "<td>14163</td>\n",
       "<td>001-917-947-1447x650</td></tr><tr><td>10</td>\n",
       "<td>Robert</td>\n",
       "<td>Cooper</td>\n",
       "<td>M</td>\n",
       "<td>1988-07-14</td>\n",
       "<td>2070 Christopher Knolls</td>\n",
       "<td>Andreastad</td>\n",
       "<td>TN</td>\n",
       "<td>13995</td>\n",
       "<td>957-517-9026x7264</td></tr><tr><td>11</td>\n",
       "<td>Donna</td>\n",
       "<td>Wilcox</td>\n",
       "<td>F</td>\n",
       "<td>1990-05-25</td>\n",
       "<td>540 Alexis Green</td>\n",
       "<td>East Rachaelview</td>\n",
       "<td>MO</td>\n",
       "<td>32975</td>\n",
       "<td>9502795098</td> </tr> </tbody>\n",
       "            </table>\n",
       "            <p>...</p>\n",
       "            <p>Total: 900</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "0              Matthew        Miles         M       1985-11-11     279 Joseph Est Masonstad      WA             26544        830-541-2678  \n",
       "1              Willie         May           M       1995-04-21     5509 Cross Can West Todd      NE             51244        5774925367    \n",
       "2              David          Boone         M       1984-12-17     03892 Amy Rapi Marybury       OK             21149        164.601.2816  \n",
       "3              Derek          Barrett       M       2000-07-04     93045 Pamela P North Bradymou SD             33618        519-951-7205x5\n",
       "4              Albert         Davis         M       1994-01-15     442 Jacob Bypa Lake Brendan   CT             87296        977-228-5606x0\n",
       "5              Erika          Phillips      F       1988-03-31     911 Tiffany Pi Christophertow UT             56135        (889)801-9551x\n",
       "6              Lucas          Thomas        M       2002-01-05     810 Williams D Port Hannahpor AK             66875        1407435812    \n",
       "7              Nancy          Fox           F       1984-05-16     96581 Jackson  Lake Ianmouth  LA             32046        5707101635    \n",
       "8              Deborah        Vincent       F       2001-01-10     237 Elizabeth  North Jennifer UT             37335        +1-696-997-163\n",
       "9              Stephanie      Koch          F       1993-06-12     8303 Tiffany R Wilsonview     MA             14163        001-917-947-14\n",
       "10             Robert         Cooper        M       1988-07-14     2070 Christoph Andreastad     TN             13995        957-517-9026x7\n",
       "11             Donna          Wilcox        F       1990-05-25     540 Alexis Gre East Rachaelvi MO             32975        9502795098    \n",
       "   ...\n",
       " (Total: 900)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Querying data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Restricting by attribute values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">date_of_birth</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_address</p>\n",
       "                                <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_city</p>\n",
       "                                <span class=\"djtooltiptext\">mailing address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_state</p>\n",
       "                                <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_zip</p>\n",
       "                                <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_phone</p>\n",
       "                                <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>5</td>\n",
       "<td>Erika</td>\n",
       "<td>Phillips</td>\n",
       "<td>F</td>\n",
       "<td>1988-03-31</td>\n",
       "<td>911 Tiffany Pike Apt. 570</td>\n",
       "<td>Christophertown</td>\n",
       "<td>UT</td>\n",
       "<td>56135</td>\n",
       "<td>(889)801-9551x4395</td></tr><tr><td>7</td>\n",
       "<td>Nancy</td>\n",
       "<td>Fox</td>\n",
       "<td>F</td>\n",
       "<td>1984-05-16</td>\n",
       "<td>96581 Jackson Ports</td>\n",
       "<td>Lake Ianmouth</td>\n",
       "<td>LA</td>\n",
       "<td>32046</td>\n",
       "<td>5707101635</td></tr><tr><td>8</td>\n",
       "<td>Deborah</td>\n",
       "<td>Vincent</td>\n",
       "<td>F</td>\n",
       "<td>2001-01-10</td>\n",
       "<td>237 Elizabeth Pass Suite 178</td>\n",
       "<td>North Jennifer</td>\n",
       "<td>UT</td>\n",
       "<td>37335</td>\n",
       "<td>+1-696-997-1635x317</td></tr><tr><td>9</td>\n",
       "<td>Stephanie</td>\n",
       "<td>Koch</td>\n",
       "<td>F</td>\n",
       "<td>1993-06-12</td>\n",
       "<td>8303 Tiffany Rest</td>\n",
       "<td>Wilsonview</td>\n",
       "<td>MA</td>\n",
       "<td>14163</td>\n",
       "<td>001-917-947-1447x650</td></tr><tr><td>11</td>\n",
       "<td>Donna</td>\n",
       "<td>Wilcox</td>\n",
       "<td>F</td>\n",
       "<td>1990-05-25</td>\n",
       "<td>540 Alexis Green</td>\n",
       "<td>East Rachaelview</td>\n",
       "<td>MO</td>\n",
       "<td>32975</td>\n",
       "<td>9502795098</td></tr><tr><td>12</td>\n",
       "<td>Danielle</td>\n",
       "<td>Roth</td>\n",
       "<td>F</td>\n",
       "<td>1991-01-04</td>\n",
       "<td>697 Stacy Wall</td>\n",
       "<td>Schmidtborough</td>\n",
       "<td>ME</td>\n",
       "<td>35610</td>\n",
       "<td>069.269.5700x454</td></tr><tr><td>18</td>\n",
       "<td>Christine</td>\n",
       "<td>Newman</td>\n",
       "<td>F</td>\n",
       "<td>1999-02-28</td>\n",
       "<td>00473 Daniel Freeway Apt. 706</td>\n",
       "<td>New Edward</td>\n",
       "<td>NM</td>\n",
       "<td>45981</td>\n",
       "<td>287-445-7199x999</td></tr><tr><td>19</td>\n",
       "<td>Gabrielle</td>\n",
       "<td>Carr</td>\n",
       "<td>F</td>\n",
       "<td>2000-01-03</td>\n",
       "<td>097 Gina Junction Apt. 926</td>\n",
       "<td>New Isaac</td>\n",
       "<td>CT</td>\n",
       "<td>43134</td>\n",
       "<td>204.887.5818x900</td></tr><tr><td>21</td>\n",
       "<td>Monica</td>\n",
       "<td>Wilson</td>\n",
       "<td>F</td>\n",
       "<td>1993-11-13</td>\n",
       "<td>6255 William Divide</td>\n",
       "<td>West Kathyview</td>\n",
       "<td>NC</td>\n",
       "<td>65452</td>\n",
       "<td>632.749.3286x370</td></tr><tr><td>23</td>\n",
       "<td>Katie</td>\n",
       "<td>Brown</td>\n",
       "<td>F</td>\n",
       "<td>1985-03-29</td>\n",
       "<td>9844 Joshua Garden</td>\n",
       "<td>South Elizabeth</td>\n",
       "<td>MN</td>\n",
       "<td>92773</td>\n",
       "<td>(058)445-6195x48931</td></tr><tr><td>26</td>\n",
       "<td>Tiffany</td>\n",
       "<td>Johnson</td>\n",
       "<td>F</td>\n",
       "<td>1997-09-25</td>\n",
       "<td>2752 Valerie Passage Apt. 583</td>\n",
       "<td>Kennedyshire</td>\n",
       "<td>NC</td>\n",
       "<td>03101</td>\n",
       "<td>255.083.4385</td></tr><tr><td>29</td>\n",
       "<td>Catherine</td>\n",
       "<td>Castro</td>\n",
       "<td>F</td>\n",
       "<td>2000-05-08</td>\n",
       "<td>506 Sue Flat</td>\n",
       "<td>Robinsonmouth</td>\n",
       "<td>WY</td>\n",
       "<td>66233</td>\n",
       "<td>+1-820-511-6491</td> </tr> </tbody>\n",
       "            </table>\n",
       "            <p>...</p>\n",
       "            <p>Total: 456</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "5              Erika          Phillips      F       1988-03-31     911 Tiffany Pi Christophertow UT             56135        (889)801-9551x\n",
       "7              Nancy          Fox           F       1984-05-16     96581 Jackson  Lake Ianmouth  LA             32046        5707101635    \n",
       "8              Deborah        Vincent       F       2001-01-10     237 Elizabeth  North Jennifer UT             37335        +1-696-997-163\n",
       "9              Stephanie      Koch          F       1993-06-12     8303 Tiffany R Wilsonview     MA             14163        001-917-947-14\n",
       "11             Donna          Wilcox        F       1990-05-25     540 Alexis Gre East Rachaelvi MO             32975        9502795098    \n",
       "12             Danielle       Roth          F       1991-01-04     697 Stacy Wall Schmidtborough ME             35610        069.269.5700x4\n",
       "18             Christine      Newman        F       1999-02-28     00473 Daniel F New Edward     NM             45981        287-445-7199x9\n",
       "19             Gabrielle      Carr          F       2000-01-03     097 Gina Junct New Isaac      CT             43134        204.887.5818x9\n",
       "21             Monica         Wilson        F       1993-11-13     6255 William D West Kathyview NC             65452        632.749.3286x3\n",
       "23             Katie          Brown         F       1985-03-29     9844 Joshua Ga South Elizabet MN             92773        (058)445-6195x\n",
       "26             Tiffany        Johnson       F       1997-09-25     2752 Valerie P Kennedyshire   NC             03101        255.083.4385  \n",
       "29             Catherine      Castro        F       2000-05-08     506 Sue Flat   Robinsonmouth  WY             66233        +1-820-511-649\n",
       "   ...\n",
       " (Total: 456)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student() & 'sex=\"F\"'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">date_of_birth</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_address</p>\n",
       "                                <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_city</p>\n",
       "                                <span class=\"djtooltiptext\">mailing address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_state</p>\n",
       "                                <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_zip</p>\n",
       "                                <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_phone</p>\n",
       "                                <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>3</td>\n",
       "<td>Derek</td>\n",
       "<td>Barrett</td>\n",
       "<td>M</td>\n",
       "<td>2000-07-04</td>\n",
       "<td>93045 Pamela Plain</td>\n",
       "<td>North Bradymouth</td>\n",
       "<td>SD</td>\n",
       "<td>33618</td>\n",
       "<td>519-951-7205x52305</td></tr><tr><td>6</td>\n",
       "<td>Lucas</td>\n",
       "<td>Thomas</td>\n",
       "<td>M</td>\n",
       "<td>2002-01-05</td>\n",
       "<td>810 Williams Dale Apt. 270</td>\n",
       "<td>Port Hannahport</td>\n",
       "<td>AK</td>\n",
       "<td>66875</td>\n",
       "<td>1407435812</td></tr><tr><td>8</td>\n",
       "<td>Deborah</td>\n",
       "<td>Vincent</td>\n",
       "<td>F</td>\n",
       "<td>2001-01-10</td>\n",
       "<td>237 Elizabeth Pass Suite 178</td>\n",
       "<td>North Jennifer</td>\n",
       "<td>UT</td>\n",
       "<td>37335</td>\n",
       "<td>+1-696-997-1635x317</td></tr><tr><td>13</td>\n",
       "<td>Kyle</td>\n",
       "<td>Neal</td>\n",
       "<td>M</td>\n",
       "<td>2003-07-30</td>\n",
       "<td>2079 Hayes Drive</td>\n",
       "<td>South Kimberlyhaven</td>\n",
       "<td>AZ</td>\n",
       "<td>25811</td>\n",
       "<td>294.223.3023</td></tr><tr><td>15</td>\n",
       "<td>Kyle</td>\n",
       "<td>Kirby</td>\n",
       "<td>M</td>\n",
       "<td>2003-01-18</td>\n",
       "<td>55693 Hudson Underpass</td>\n",
       "<td>South Amytown</td>\n",
       "<td>VA</td>\n",
       "<td>27199</td>\n",
       "<td>366.457.5029x8187</td></tr><tr><td>19</td>\n",
       "<td>Gabrielle</td>\n",
       "<td>Carr</td>\n",
       "<td>F</td>\n",
       "<td>2000-01-03</td>\n",
       "<td>097 Gina Junction Apt. 926</td>\n",
       "<td>New Isaac</td>\n",
       "<td>CT</td>\n",
       "<td>43134</td>\n",
       "<td>204.887.5818x900</td></tr><tr><td>22</td>\n",
       "<td>Dennis</td>\n",
       "<td>Shields</td>\n",
       "<td>M</td>\n",
       "<td>2003-08-20</td>\n",
       "<td>4385 Jonathan Track Suite 093</td>\n",
       "<td>Benderview</td>\n",
       "<td>CO</td>\n",
       "<td>53814</td>\n",
       "<td>+1-650-949-3288</td></tr><tr><td>27</td>\n",
       "<td>Jason</td>\n",
       "<td>Cannon</td>\n",
       "<td>M</td>\n",
       "<td>2001-03-12</td>\n",
       "<td>575 Gross Crossing</td>\n",
       "<td>Dominguezhaven</td>\n",
       "<td>IL</td>\n",
       "<td>19583</td>\n",
       "<td>0305674234</td></tr><tr><td>29</td>\n",
       "<td>Catherine</td>\n",
       "<td>Castro</td>\n",
       "<td>F</td>\n",
       "<td>2000-05-08</td>\n",
       "<td>506 Sue Flat</td>\n",
       "<td>Robinsonmouth</td>\n",
       "<td>WY</td>\n",
       "<td>66233</td>\n",
       "<td>+1-820-511-6491</td></tr><tr><td>41</td>\n",
       "<td>Brad</td>\n",
       "<td>Sanchez</td>\n",
       "<td>M</td>\n",
       "<td>2002-04-04</td>\n",
       "<td>15681 Smith Greens</td>\n",
       "<td>West Alexanderborough</td>\n",
       "<td>NV</td>\n",
       "<td>82139</td>\n",
       "<td>030.223.4585x6904</td></tr><tr><td>42</td>\n",
       "<td>Debbie</td>\n",
       "<td>Rocha</td>\n",
       "<td>F</td>\n",
       "<td>2001-01-14</td>\n",
       "<td>9449 Johnson Oval</td>\n",
       "<td>Bryanttown</td>\n",
       "<td>HI</td>\n",
       "<td>20252</td>\n",
       "<td>(298)437-5761x444</td></tr><tr><td>45</td>\n",
       "<td>Andrew</td>\n",
       "<td>Rivera</td>\n",
       "<td>M</td>\n",
       "<td>2003-12-21</td>\n",
       "<td>21697 Steve Harbors</td>\n",
       "<td>East Meredith</td>\n",
       "<td>CT</td>\n",
       "<td>98221</td>\n",
       "<td>257.005.7228</td> </tr> </tbody>\n",
       "            </table>\n",
       "            <p>...</p>\n",
       "            <p>Total: 200</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "3              Derek          Barrett       M       2000-07-04     93045 Pamela P North Bradymou SD             33618        519-951-7205x5\n",
       "6              Lucas          Thomas        M       2002-01-05     810 Williams D Port Hannahpor AK             66875        1407435812    \n",
       "8              Deborah        Vincent       F       2001-01-10     237 Elizabeth  North Jennifer UT             37335        +1-696-997-163\n",
       "13             Kyle           Neal          M       2003-07-30     2079 Hayes Dri South Kimberly AZ             25811        294.223.3023  \n",
       "15             Kyle           Kirby         M       2003-01-18     55693 Hudson U South Amytown  VA             27199        366.457.5029x8\n",
       "19             Gabrielle      Carr          F       2000-01-03     097 Gina Junct New Isaac      CT             43134        204.887.5818x9\n",
       "22             Dennis         Shields       M       2003-08-20     4385 Jonathan  Benderview     CO             53814        +1-650-949-328\n",
       "27             Jason          Cannon        M       2001-03-12     575 Gross Cros Dominguezhaven IL             19583        0305674234    \n",
       "29             Catherine      Castro        F       2000-05-08     506 Sue Flat   Robinsonmouth  WY             66233        +1-820-511-649\n",
       "41             Brad           Sanchez       M       2002-04-04     15681 Smith Gr West Alexander NV             82139        030.223.4585x6\n",
       "42             Debbie         Rocha         F       2001-01-14     9449 Johnson O Bryanttown     HI             20252        (298)437-5761x\n",
       "45             Andrew         Rivera        M       2003-12-21     21697 Steve Ha East Meredith  CT             98221        257.005.7228  \n",
       "   ...\n",
       " (Total: 200)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student() & 'date_of_birth > \"2000-01-01\"'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "female_texans = Student & [{'sex': 'F'}, {'home_state': 'UT'}]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        \n",
       "        <style type=\"text/css\">\n",
       "            .Relation{\n",
       "                border-collapse:collapse;\n",
       "            }\n",
       "            .Relation th{\n",
       "                background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "                font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "            }\n",
       "            .Relation td{\n",
       "                padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "            }\n",
       "            .Relation tr:nth-child(odd){\n",
       "                background: #ffffff;\n",
       "            }\n",
       "            .Relation tr:nth-child(even){\n",
       "                background: #f3f1ff;\n",
       "            }\n",
       "            /* Tooltip container */\n",
       "            .djtooltip {\n",
       "            }\n",
       "            /* Tooltip text */\n",
       "            .djtooltip .djtooltiptext {\n",
       "                visibility: hidden;\n",
       "                width: 120px;\n",
       "                background-color: black;\n",
       "                color: #fff;\n",
       "                text-align: center;\n",
       "                padding: 5px 0;\n",
       "                border-radius: 6px;\n",
       "                /* Position the tooltip text - see examples below! */\n",
       "                position: absolute;\n",
       "                z-index: 1;\n",
       "            }\n",
       "            #primary {\n",
       "                font-weight: bold;\n",
       "                color: black;\n",
       "            }\n",
       "\n",
       "            #nonprimary {\n",
       "                font-weight: normal;\n",
       "                color: white;\n",
       "            }\n",
       "\n",
       "            /* Show the tooltip text when you mouse over the tooltip container */\n",
       "            .djtooltip:hover .djtooltiptext {\n",
       "                visibility: visible;\n",
       "            }\n",
       "        </style>\n",
       "        \n",
       "        <b></b>\n",
       "            <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "            <table border=\"1\" class=\"Relation\">\n",
       "                <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                                <p id=\"primary\">student_id</p>\n",
       "                                <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">first_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">last_name</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">sex</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">date_of_birth</p>\n",
       "                                <span class=\"djtooltiptext\"></span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_address</p>\n",
       "                                <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_city</p>\n",
       "                                <span class=\"djtooltiptext\">mailing address</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_state</p>\n",
       "                                <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_zip</p>\n",
       "                                <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                            </div></th><th><div class=\"djtooltip\">\n",
       "                                <p id=\"nonprimary\">home_phone</p>\n",
       "                                <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                            </div> </th> </tr> </thead>\n",
       "                <tbody> <tr> <td>5</td>\n",
       "<td>Erika</td>\n",
       "<td>Phillips</td>\n",
       "<td>F</td>\n",
       "<td>1988-03-31</td>\n",
       "<td>911 Tiffany Pike Apt. 570</td>\n",
       "<td>Christophertown</td>\n",
       "<td>UT</td>\n",
       "<td>56135</td>\n",
       "<td>(889)801-9551x4395</td></tr><tr><td>7</td>\n",
       "<td>Nancy</td>\n",
       "<td>Fox</td>\n",
       "<td>F</td>\n",
       "<td>1984-05-16</td>\n",
       "<td>96581 Jackson Ports</td>\n",
       "<td>Lake Ianmouth</td>\n",
       "<td>LA</td>\n",
       "<td>32046</td>\n",
       "<td>5707101635</td></tr><tr><td>8</td>\n",
       "<td>Deborah</td>\n",
       "<td>Vincent</td>\n",
       "<td>F</td>\n",
       "<td>2001-01-10</td>\n",
       "<td>237 Elizabeth Pass Suite 178</td>\n",
       "<td>North Jennifer</td>\n",
       "<td>UT</td>\n",
       "<td>37335</td>\n",
       "<td>+1-696-997-1635x317</td></tr><tr><td>9</td>\n",
       "<td>Stephanie</td>\n",
       "<td>Koch</td>\n",
       "<td>F</td>\n",
       "<td>1993-06-12</td>\n",
       "<td>8303 Tiffany Rest</td>\n",
       "<td>Wilsonview</td>\n",
       "<td>MA</td>\n",
       "<td>14163</td>\n",
       "<td>001-917-947-1447x650</td></tr><tr><td>11</td>\n",
       "<td>Donna</td>\n",
       "<td>Wilcox</td>\n",
       "<td>F</td>\n",
       "<td>1990-05-25</td>\n",
       "<td>540 Alexis Green</td>\n",
       "<td>East Rachaelview</td>\n",
       "<td>MO</td>\n",
       "<td>32975</td>\n",
       "<td>9502795098</td></tr><tr><td>12</td>\n",
       "<td>Danielle</td>\n",
       "<td>Roth</td>\n",
       "<td>F</td>\n",
       "<td>1991-01-04</td>\n",
       "<td>697 Stacy Wall</td>\n",
       "<td>Schmidtborough</td>\n",
       "<td>ME</td>\n",
       "<td>35610</td>\n",
       "<td>069.269.5700x454</td></tr><tr><td>18</td>\n",
       "<td>Christine</td>\n",
       "<td>Newman</td>\n",
       "<td>F</td>\n",
       "<td>1999-02-28</td>\n",
       "<td>00473 Daniel Freeway Apt. 706</td>\n",
       "<td>New Edward</td>\n",
       "<td>NM</td>\n",
       "<td>45981</td>\n",
       "<td>287-445-7199x999</td></tr><tr><td>19</td>\n",
       "<td>Gabrielle</td>\n",
       "<td>Carr</td>\n",
       "<td>F</td>\n",
       "<td>2000-01-03</td>\n",
       "<td>097 Gina Junction Apt. 926</td>\n",
       "<td>New Isaac</td>\n",
       "<td>CT</td>\n",
       "<td>43134</td>\n",
       "<td>204.887.5818x900</td></tr><tr><td>21</td>\n",
       "<td>Monica</td>\n",
       "<td>Wilson</td>\n",
       "<td>F</td>\n",
       "<td>1993-11-13</td>\n",
       "<td>6255 William Divide</td>\n",
       "<td>West Kathyview</td>\n",
       "<td>NC</td>\n",
       "<td>65452</td>\n",
       "<td>632.749.3286x370</td></tr><tr><td>23</td>\n",
       "<td>Katie</td>\n",
       "<td>Brown</td>\n",
       "<td>F</td>\n",
       "<td>1985-03-29</td>\n",
       "<td>9844 Joshua Garden</td>\n",
       "<td>South Elizabeth</td>\n",
       "<td>MN</td>\n",
       "<td>92773</td>\n",
       "<td>(058)445-6195x48931</td></tr><tr><td>26</td>\n",
       "<td>Tiffany</td>\n",
       "<td>Johnson</td>\n",
       "<td>F</td>\n",
       "<td>1997-09-25</td>\n",
       "<td>2752 Valerie Passage Apt. 583</td>\n",
       "<td>Kennedyshire</td>\n",
       "<td>NC</td>\n",
       "<td>03101</td>\n",
       "<td>255.083.4385</td></tr><tr><td>29</td>\n",
       "<td>Catherine</td>\n",
       "<td>Castro</td>\n",
       "<td>F</td>\n",
       "<td>2000-05-08</td>\n",
       "<td>506 Sue Flat</td>\n",
       "<td>Robinsonmouth</td>\n",
       "<td>WY</td>\n",
       "<td>66233</td>\n",
       "<td>+1-820-511-6491</td> </tr> </tbody>\n",
       "            </table>\n",
       "            <p>...</p>\n",
       "            <p>Total: 465</p></div>\n",
       "            "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "5              Erika          Phillips      F       1988-03-31     911 Tiffany Pi Christophertow UT             56135        (889)801-9551x\n",
       "7              Nancy          Fox           F       1984-05-16     96581 Jackson  Lake Ianmouth  LA             32046        5707101635    \n",
       "8              Deborah        Vincent       F       2001-01-10     237 Elizabeth  North Jennifer UT             37335        +1-696-997-163\n",
       "9              Stephanie      Koch          F       1993-06-12     8303 Tiffany R Wilsonview     MA             14163        001-917-947-14\n",
       "11             Donna          Wilcox        F       1990-05-25     540 Alexis Gre East Rachaelvi MO             32975        9502795098    \n",
       "12             Danielle       Roth          F       1991-01-04     697 Stacy Wall Schmidtborough ME             35610        069.269.5700x4\n",
       "18             Christine      Newman        F       1999-02-28     00473 Daniel F New Edward     NM             45981        287-445-7199x9\n",
       "19             Gabrielle      Carr          F       2000-01-03     097 Gina Junct New Isaac      CT             43134        204.887.5818x9\n",
       "21             Monica         Wilson        F       1993-11-13     6255 William D West Kathyview NC             65452        632.749.3286x3\n",
       "23             Katie          Brown         F       1985-03-29     9844 Joshua Ga South Elizabet MN             92773        (058)445-6195x\n",
       "26             Tiffany        Johnson       F       1997-09-25     2752 Valerie P Kennedyshire   NC             03101        255.083.4385  \n",
       "29             Catherine      Castro        F       2000-05-08     506 Sue Flat   Robinsonmouth  WY             66233        +1-820-511-649\n",
       "   ...\n",
       " (Total: 465)"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "female_texans"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Fetching data from the querying results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "female_texans.fetch()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "female_texans.fetch(as_dict=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "female_texans.fetch(format=\"frame\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(female_texans)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "utahns = Student & {'home_state': 'UT'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "utah_genz = utahns & 'date_of_birth > \"1989-01-01\"'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "utah_genz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "utah_genz = utah_genz.proj('last_name', 'home_city','home_state','sex')\n",
    "utah_genz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for r in utah_genz:\n",
    "    print(r)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}