queries1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## SQL Queries\n",
    "\n",
    "To be able to execute SQL queries from within a Jupyter notebook, we will use the `sql_magic` extension (https://github.com/pivotal/sql_magic)\n",
    "\n",
    "    sudo pip3 install -U sql_magic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy import create_engine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn_string = 'mysql://{user}:{password}@{host}/?charset=utf8'.format(\n",
    "    host = 'db.ipeirotis.org', \n",
    "    user = 'student',\n",
    "    password = 'dwdstudent2015',\n",
    "    encoding = 'utf-8')\n",
    "engine = create_engine(conn_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "\n",
       "    require(['notebook/js/codecell'], function(codecell) {\n",
       "      // https://github.com/jupyter/notebook/issues/2453\n",
       "      codecell.CodeCell.options_default.highlight_modes['magic_text/x-sql'] = {'reg':[/^%read_sql/, /.*=\\s*%read_sql/,\n",
       "                                                                                      /^%%read_sql/]};\n",
       "      Jupyter.notebook.events.one('kernel_ready.Kernel', function(){\n",
       "          console.log('BBBBB');\n",
       "          Jupyter.notebook.get_cells().map(function(cell){\n",
       "              if (cell.cell_type == 'code'){ cell.auto_highlight(); } }) ;\n",
       "      });\n",
       "    });\n",
       "    "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%reload_ext sql_magic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "%config SQL.conn_name = 'engine'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:00 PM UTC; Query executed in 0.01 m"
     ]
    },
    {
     "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>Database</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>information_schema</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>bike_sharing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>citibike</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>citibike_fall2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>facebook</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>imdb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>nypd_complaints</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>public</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Database\n",
       "0  information_schema\n",
       "1        bike_sharing\n",
       "2            citibike\n",
       "3   citibike_fall2017\n",
       "4            facebook\n",
       "5                imdb\n",
       "6               music\n",
       "7     nypd_complaints\n",
       "8              public"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "show databases"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:00 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<sql_magic.exceptions.EmptyResult at 0x7f61034711d0>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "use imdb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:00 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Tables_in_imdb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>actors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>directors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>directors_genres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>movies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>movies_directors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>movies_genres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>roles</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Tables_in_imdb\n",
       "0            actors\n",
       "1         directors\n",
       "2  directors_genres\n",
       "3            movies\n",
       "4  movies_directors\n",
       "5     movies_genres\n",
       "6             roles"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "show tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:00 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Field</th>\n",
       "      <th>Type</th>\n",
       "      <th>Null</th>\n",
       "      <th>Key</th>\n",
       "      <th>Default</th>\n",
       "      <th>Extra</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>id</td>\n",
       "      <td>int(11)</td>\n",
       "      <td>NO</td>\n",
       "      <td>PRI</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>first_name</td>\n",
       "      <td>varchar(100)</td>\n",
       "      <td>YES</td>\n",
       "      <td>MUL</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>last_name</td>\n",
       "      <td>varchar(100)</td>\n",
       "      <td>YES</td>\n",
       "      <td>MUL</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>gender</td>\n",
       "      <td>char(1)</td>\n",
       "      <td>YES</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Field          Type Null  Key Default Extra\n",
       "0          id       int(11)   NO  PRI       0      \n",
       "1  first_name  varchar(100)  YES  MUL    None      \n",
       "2   last_name  varchar(100)  YES  MUL    None      \n",
       "3      gender       char(1)  YES         None      "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "describe actors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:00 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Field</th>\n",
       "      <th>Type</th>\n",
       "      <th>Null</th>\n",
       "      <th>Key</th>\n",
       "      <th>Default</th>\n",
       "      <th>Extra</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>actor_id</td>\n",
       "      <td>int(11)</td>\n",
       "      <td>YES</td>\n",
       "      <td>MUL</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>movie_id</td>\n",
       "      <td>int(11)</td>\n",
       "      <td>YES</td>\n",
       "      <td>MUL</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>role</td>\n",
       "      <td>varchar(100)</td>\n",
       "      <td>YES</td>\n",
       "      <td>MUL</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Field          Type Null  Key Default Extra\n",
       "0  actor_id       int(11)  YES  MUL    None      \n",
       "1  movie_id       int(11)  YES  MUL    None      \n",
       "2      role  varchar(100)  YES  MUL    None      "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "describe roles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### SELECT Queries (IMDB database)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:01 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<sql_magic.exceptions.EmptyResult at 0x7f6103464d68>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "USE imdb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all movie titles with id less than 100."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:01 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>#28</td>\n",
       "      <td>2002</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>#7 Train: An Immigrant Journey, The</td>\n",
       "      <td>2000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>$</td>\n",
       "      <td>1971</td>\n",
       "      <td>6.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>$1,000 Reward</td>\n",
       "      <td>1913</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>$1,000 Reward</td>\n",
       "      <td>1915</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>95</td>\n",
       "      <td>'Cross the Mexican Line</td>\n",
       "      <td>1914</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>96</td>\n",
       "      <td>'Den vide verden's billedbog nr. 1</td>\n",
       "      <td>1938</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>97</td>\n",
       "      <td>'Deutschland' Leaving New York at Full Speed (...</td>\n",
       "      <td>1902</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>98</td>\n",
       "      <td>'Diamond S' Ranch, The</td>\n",
       "      <td>1912</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>99</td>\n",
       "      <td>'Dikke Bertha' op doortocht in Brussel</td>\n",
       "      <td>1919</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    id                                               name  year  rank\n",
       "0    0                                                #28  2002   NaN\n",
       "1    1                #7 Train: An Immigrant Journey, The  2000   NaN\n",
       "2    2                                                  $  1971   6.4\n",
       "3    3                                      $1,000 Reward  1913   NaN\n",
       "4    4                                      $1,000 Reward  1915   NaN\n",
       "..  ..                                                ...   ...   ...\n",
       "91  95                            'Cross the Mexican Line  1914   NaN\n",
       "92  96                 'Den vide verden's billedbog nr. 1  1938   NaN\n",
       "93  97  'Deutschland' Leaving New York at Full Speed (...  1902   NaN\n",
       "94  98                             'Diamond S' Ranch, The  1912   NaN\n",
       "95  99             'Dikke Bertha' op doortocht in Brussel  1919   NaN\n",
       "\n",
       "[96 rows x 4 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT * \n",
    "FROM movies \n",
    "WHERE id<100"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all information about movies that were released before 1895 (excl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:01 PM UTC; Query executed in 0.01 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13261</td>\n",
       "      <td>Amateur Gymnast, No. 2</td>\n",
       "      <td>1894</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17623</td>\n",
       "      <td>Annabelle Butterfly Dance</td>\n",
       "      <td>1894</td>\n",
       "      <td>5.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17627</td>\n",
       "      <td>Annabelle Serpentine Dance</td>\n",
       "      <td>1894</td>\n",
       "      <td>6.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17628</td>\n",
       "      <td>Annabelle Sun Dance</td>\n",
       "      <td>1894</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17770</td>\n",
       "      <td>Annie Oakley</td>\n",
       "      <td>1894</td>\n",
       "      <td>4.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>363640</td>\n",
       "      <td>Whirlwind Gun Spinning</td>\n",
       "      <td>1894</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>364791</td>\n",
       "      <td>Widder, The</td>\n",
       "      <td>1894</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>368839</td>\n",
       "      <td>Wrestling</td>\n",
       "      <td>1892</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>368852</td>\n",
       "      <td>Wrestling Dog, The</td>\n",
       "      <td>1894</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>368854</td>\n",
       "      <td>Wrestling Match</td>\n",
       "      <td>1894</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>81 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id                        name  year  rank\n",
       "0    13261      Amateur Gymnast, No. 2  1894   NaN\n",
       "1    17623   Annabelle Butterfly Dance  1894   5.3\n",
       "2    17627  Annabelle Serpentine Dance  1894   6.1\n",
       "3    17628         Annabelle Sun Dance  1894   NaN\n",
       "4    17770                Annie Oakley  1894   4.9\n",
       "..     ...                         ...   ...   ...\n",
       "76  363640      Whirlwind Gun Spinning  1894   NaN\n",
       "77  364791                 Widder, The  1894   NaN\n",
       "78  368839                   Wrestling  1892   2.0\n",
       "79  368852          Wrestling Dog, The  1894   NaN\n",
       "80  368854             Wrestling Match  1894   NaN\n",
       "\n",
       "[81 rows x 4 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM movies \n",
    "WHERE year<1895"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all information about movies that were released before 1895 and after 2006 (inclusive)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:01 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>899</td>\n",
       "      <td>10th &amp; Wolf</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1799</td>\n",
       "      <td>2176</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2238</td>\n",
       "      <td>300</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9086</td>\n",
       "      <td>Airborn</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9495</td>\n",
       "      <td>Akrobatisches Potpourri</td>\n",
       "      <td>1895</td>\n",
       "      <td>5.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>369459</td>\n",
       "      <td>X-Men 3</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>372568</td>\n",
       "      <td>Young Griffo v. Battling Charles Barnett</td>\n",
       "      <td>1895</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>374889</td>\n",
       "      <td>Zhmurki</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>400649</td>\n",
       "      <td>\"Pacific War, The\"</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>409052</td>\n",
       "      <td>\"Turin 2006: XX Olympic Winter Games\"</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>356 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                                      name  year  rank\n",
       "0       899                               10th & Wolf  2006   NaN\n",
       "1      1799                                      2176  2006   NaN\n",
       "2      2238                                       300  2006   NaN\n",
       "3      9086                                   Airborn  2006   NaN\n",
       "4      9495                   Akrobatisches Potpourri  1895   5.2\n",
       "..      ...                                       ...   ...   ...\n",
       "351  369459                                   X-Men 3  2006   NaN\n",
       "352  372568  Young Griffo v. Battling Charles Barnett  1895   NaN\n",
       "353  374889                                   Zhmurki  2006   NaN\n",
       "354  400649                        \"Pacific War, The\"  2006   NaN\n",
       "355  409052     \"Turin 2006: XX Olympic Winter Games\"  2006   NaN\n",
       "\n",
       "[356 rows x 4 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM movies \n",
    "WHERE year<=1895 OR year>=2006"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all information about movies released between 1895 and 1898 (excl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:01 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>56</td>\n",
       "      <td>'Amphitrite', The</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>70</td>\n",
       "      <td>'Brennus', Le</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>247</td>\n",
       "      <td>'Standard' Picture Animated, A</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1076</td>\n",
       "      <td>13th Infantry, U.S. Army Marching Through Sall...</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1077</td>\n",
       "      <td>13th Infantry, U.S. Army, in Heavy Marching Or...</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1093</th>\n",
       "      <td>372727</td>\n",
       "      <td>Young Rivals, The</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1094</th>\n",
       "      <td>375815</td>\n",
       "      <td>Zoo van Antwerpen, De</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1095</th>\n",
       "      <td>376589</td>\n",
       "      <td>Z Pereira na Romaria de Santo Tirso, O</td>\n",
       "      <td>1896</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096</th>\n",
       "      <td>377666</td>\n",
       "      <td>cole des gendres, L'</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1097</th>\n",
       "      <td>377845</td>\n",
       "      <td>pisodes de guerre</td>\n",
       "      <td>1897</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1098 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          id                                               name  year  rank\n",
       "0         56                                  'Amphitrite', The  1897   NaN\n",
       "1         70                                      'Brennus', Le  1897   NaN\n",
       "2        247                     'Standard' Picture Animated, A  1897   NaN\n",
       "3       1076  13th Infantry, U.S. Army Marching Through Sall...  1897   NaN\n",
       "4       1077  13th Infantry, U.S. Army, in Heavy Marching Or...  1897   NaN\n",
       "...      ...                                                ...   ...   ...\n",
       "1093  372727                                  Young Rivals, The  1897   NaN\n",
       "1094  375815                              Zoo van Antwerpen, De  1897   NaN\n",
       "1095  376589             Z Pereira na Romaria de Santo Tirso, O  1896   NaN\n",
       "1096  377666                               cole des gendres, L'  1897   NaN\n",
       "1097  377845                                  pisodes de guerre  1897   NaN\n",
       "\n",
       "[1098 rows x 4 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM movies \n",
    "WHERE year>1895 AND year<1898"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all information about *actresses* who are have first name Skyler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>556133</td>\n",
       "      <td>Skyler</td>\n",
       "      <td>Blankenship</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>570689</td>\n",
       "      <td>Skyler</td>\n",
       "      <td>Campbell</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>595403</td>\n",
       "      <td>Skyler</td>\n",
       "      <td>Day</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>773680</td>\n",
       "      <td>Skyler</td>\n",
       "      <td>Rose</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>776752</td>\n",
       "      <td>Skyler</td>\n",
       "      <td>Russell</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>789243</td>\n",
       "      <td>Skyler</td>\n",
       "      <td>Shaye</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id first_name    last_name gender\n",
       "0  556133     Skyler  Blankenship      F\n",
       "1  570689     Skyler     Campbell      F\n",
       "2  595403     Skyler          Day      F\n",
       "3  773680     Skyler         Rose      F\n",
       "4  776752     Skyler      Russell      F\n",
       "5  789243     Skyler        Shaye      F"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM actors\n",
    "WHERE first_name = 'Skyler' AND gender = 'F';"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find the director ID of Steven Spielberg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>75380</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id\n",
       "0  75380"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT id\n",
    "FROM directors\n",
    "WHERE first_name = 'Steven' AND last_name = 'Spielberg';"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find the director IDs and the first and last names of directors with the last name Spielberg and Hitchcock"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34658</td>\n",
       "      <td>Alfred (I)</td>\n",
       "      <td>Hitchcock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34659</td>\n",
       "      <td>Bill (II)</td>\n",
       "      <td>Hitchcock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34660</td>\n",
       "      <td>Charles Webster</td>\n",
       "      <td>Hitchcock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34661</td>\n",
       "      <td>Peter</td>\n",
       "      <td>Hitchcock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>34662</td>\n",
       "      <td>Victress</td>\n",
       "      <td>Hitchcock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>75380</td>\n",
       "      <td>Steven</td>\n",
       "      <td>Spielberg</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       first_name  last_name\n",
       "0  34658       Alfred (I)  Hitchcock\n",
       "1  34659        Bill (II)  Hitchcock\n",
       "2  34660  Charles Webster  Hitchcock\n",
       "3  34661            Peter  Hitchcock\n",
       "4  34662         Victress  Hitchcock\n",
       "5  75380           Steven  Spielberg"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT id, first_name, last_name\n",
    "FROM directors\n",
    "WHERE last_name = 'Spielberg' OR last_name = 'Hitchcock';"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all genres of films and the corresponding probabilities for the director ID that corresponds to Steven Spielberg. Sort the results by probability."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>genre</th>\n",
       "      <th>prob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Drama</td>\n",
       "      <td>0.435897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Thriller</td>\n",
       "      <td>0.282051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Adventure</td>\n",
       "      <td>0.282051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sci-Fi</td>\n",
       "      <td>0.256410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Action</td>\n",
       "      <td>0.230769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Horror</td>\n",
       "      <td>0.179487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Short</td>\n",
       "      <td>0.128205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Fantasy</td>\n",
       "      <td>0.102564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>War</td>\n",
       "      <td>0.102564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Crime</td>\n",
       "      <td>0.102564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Comedy</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Family</td>\n",
       "      <td>0.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Mystery</td>\n",
       "      <td>0.051282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Romance</td>\n",
       "      <td>0.051282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Western</td>\n",
       "      <td>0.025641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Documentary</td>\n",
       "      <td>0.025641</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          genre      prob\n",
       "0         Drama  0.435897\n",
       "1      Thriller  0.282051\n",
       "2     Adventure  0.282051\n",
       "3        Sci-Fi  0.256410\n",
       "4        Action  0.230769\n",
       "5        Horror  0.179487\n",
       "6         Short  0.128205\n",
       "7       Fantasy  0.102564\n",
       "8           War  0.102564\n",
       "9         Crime  0.102564\n",
       "10       Comedy  0.076923\n",
       "11       Family  0.076923\n",
       "12      Mystery  0.051282\n",
       "13      Romance  0.051282\n",
       "14      Western  0.025641\n",
       "15  Documentary  0.025641"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT genre, prob\n",
    "FROM directors_genres\n",
    "WHERE director_id = '75380' # the id of Spielberg FROM above\n",
    "ORDER BY prob DESC"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find the id of the movie Schindler's List."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>year</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>290070</td>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993</td>\n",
       "      <td>8.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id              name  year  rank\n",
       "0  290070  Schindler's List  1993   8.8"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM movies\n",
    "WHERE name = \"Schindler's List\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### List all the roles for the movie with id 290070. Sort them alphabetically"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>actor_id</th>\n",
       "      <th>movie_id</th>\n",
       "      <th>role</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14688</td>\n",
       "      <td>290070</td>\n",
       "      <td>Auschwitz guard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18959</td>\n",
       "      <td>290070</td>\n",
       "      <td>Klaus Tauber (Gestapo clerk)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19022</td>\n",
       "      <td>290070</td>\n",
       "      <td>Julius Madritsch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21072</td>\n",
       "      <td>290070</td>\n",
       "      <td>Chaim Nowak</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31611</td>\n",
       "      <td>290070</td>\n",
       "      <td>Himself/Schindler mourner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>806842</td>\n",
       "      <td>290070</td>\n",
       "      <td>Ghetto woman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>828128</td>\n",
       "      <td>290070</td>\n",
       "      <td>Brinnlitz girl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>839849</td>\n",
       "      <td>290070</td>\n",
       "      <td>Clara Sternberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>841110</td>\n",
       "      <td>290070</td>\n",
       "      <td>Plaszow Jewish girl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>842416</td>\n",
       "      <td>290070</td>\n",
       "      <td>Ghetto woman</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>146 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     actor_id  movie_id                          role\n",
       "0       14688    290070               Auschwitz guard\n",
       "1       18959    290070  Klaus Tauber (Gestapo clerk)\n",
       "2       19022    290070              Julius Madritsch\n",
       "3       21072    290070                   Chaim Nowak\n",
       "4       31611    290070     Himself/Schindler mourner\n",
       "..        ...       ...                           ...\n",
       "141    806842    290070                  Ghetto woman\n",
       "142    828128    290070                Brinnlitz girl\n",
       "143    839849    290070               Clara Sternberg\n",
       "144    841110    290070           Plaszow Jewish girl\n",
       "145    842416    290070                  Ghetto woman\n",
       "\n",
       "[146 rows x 3 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM roles\n",
    "WHERE movie_id = '290070'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### SELECT Queries (Facebook database)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<sql_magic.exceptions.EmptyResult at 0x7f6103437860>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "USE facebook"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all names of students FROM the Profiles table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:02 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Creator</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Brian Whitton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Anita Nagwani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sunny Kim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ariel Podwal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25779</th>\n",
       "      <td>Jen Slovin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25780</th>\n",
       "      <td>Kumi Dikengil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25781</th>\n",
       "      <td>Sky Gaven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25782</th>\n",
       "      <td>Eli Brown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25783</th>\n",
       "      <td>Tunga Mbia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25784 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                name\n",
       "0        The Creator\n",
       "1      Brian Whitton\n",
       "2      Anita Nagwani\n",
       "3          Sunny Kim\n",
       "4       Ariel Podwal\n",
       "...              ...\n",
       "25779     Jen Slovin\n",
       "25780  Kumi Dikengil\n",
       "25781      Sky Gaven\n",
       "25782      Eli Brown\n",
       "25783     Tunga Mbia\n",
       "\n",
       "[25784 rows x 1 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT name\n",
    "FROM Profiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Get the names and sex of all liberal students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>name</th>\n",
       "      <th>sex</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Stephanie Lai</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Josh Fern</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Blaine Davis</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sacha Kenton</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kelly Quann</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6456</th>\n",
       "      <td>Maggie Winterfeldt</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6457</th>\n",
       "      <td>Sonia Avila</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6458</th>\n",
       "      <td>Kat Redniss</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6459</th>\n",
       "      <td>Haby Barry</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6460</th>\n",
       "      <td>Tu-Lien Nguyen</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6461 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    name     sex\n",
       "0          Stephanie Lai  Female\n",
       "1              Josh Fern    Male\n",
       "2           Blaine Davis    Male\n",
       "3           Sacha Kenton  Female\n",
       "4            Kelly Quann  Female\n",
       "...                  ...     ...\n",
       "6456  Maggie Winterfeldt    None\n",
       "6457         Sonia Avila    None\n",
       "6458         Kat Redniss  Female\n",
       "6459          Haby Barry  Female\n",
       "6460      Tu-Lien Nguyen  Female\n",
       "\n",
       "[6461 rows x 2 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT name, sex\n",
    "FROM Profiles\n",
    "WHERE PoliticalViews ='Liberal'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Get the High Schools of the students in the database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>HighSchool</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>George W.Hewlett High School</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ward Melville Senior High School '02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>West Windsor Plainsboro High School South '03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Harrison High School '03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25779</th>\n",
       "      <td>Worcester Academy '04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25780</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25781</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25782</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25783</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25784 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          HighSchool\n",
       "0                                               None\n",
       "1                       George W.Hewlett High School\n",
       "2               Ward Melville Senior High School '02\n",
       "3      West Windsor Plainsboro High School South '03\n",
       "4                           Harrison High School '03\n",
       "...                                              ...\n",
       "25779                          Worcester Academy '04\n",
       "25780                                           None\n",
       "25781                                           None\n",
       "25782                                           None\n",
       "25783                                           None\n",
       "\n",
       "[25784 rows x 1 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT HighSchool\n",
    "FROM Profiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all the possible political views, eliminating duplicate entries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>PoliticalViews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Libertarian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Conservative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Liberal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Apathetic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Moderate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Very Liberal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Very Conservative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Other</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      PoliticalViews\n",
       "0               None\n",
       "1        Libertarian\n",
       "2       Conservative\n",
       "3            Liberal\n",
       "4          Apathetic\n",
       "5           Moderate\n",
       "6       Very Liberal\n",
       "7  Very Conservative\n",
       "8              Other"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT DISTINCT PoliticalViews\n",
    "FROM Profiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all possible relationship statuses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Single</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>In a Relationship</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Married</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>In an Open Relationship</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>It's complicated</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Engaged</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Status\n",
       "0                   Single\n",
       "1        In a Relationship\n",
       "2                  Married\n",
       "3  In an Open Relationship\n",
       "4         It's complicated\n",
       "5                  Engaged"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT DISTINCT Status\n",
    "FROM Relationship"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all possible values for the “status” attribute in Profiles "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Undergrad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Faculty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Grad Student</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Staff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Summer Student</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Status\n",
       "0       Undergrad\n",
       "1  Alumnus/Alumna\n",
       "2         Faculty\n",
       "3    Grad Student\n",
       "4            None\n",
       "5           Staff\n",
       "6  Summer Student"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT DISTINCT Status\n",
    "FROM Profiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all possible values for the “Residence” attribute in Profiles, eliminating duplicates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Residence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Thirteenth Street 5AN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Palladium 524D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Carlyle Court</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Palladium 524F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5084</th>\n",
       "      <td>Cliff Street 17F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5085</th>\n",
       "      <td>Lafayette Street 1203B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5086</th>\n",
       "      <td>Weinstein Hall 423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5087</th>\n",
       "      <td>Broome Street 706A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5088</th>\n",
       "      <td>Lafayette Street 1502A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5089 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Residence\n",
       "0                       None\n",
       "1      Thirteenth Street 5AN\n",
       "2             Palladium 524D\n",
       "3             Carlyle Court \n",
       "4             Palladium 524F\n",
       "...                      ...\n",
       "5084        Cliff Street 17F\n",
       "5085  Lafayette Street 1203B\n",
       "5086      Weinstein Hall 423\n",
       "5087      Broome Street 706A\n",
       "5088  Lafayette Street 1502A\n",
       "\n",
       "[5089 rows x 1 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT DISTINCT Residence\n",
    "FROM Profiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all students living in Palladium"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>Name</th>\n",
       "      <th>Residence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ariel Podwal</td>\n",
       "      <td>Palladium 524D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Josh Fern</td>\n",
       "      <td>Palladium 524F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Santosh Sateesh</td>\n",
       "      <td>Palladium 603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Holly Hamilton</td>\n",
       "      <td>Palladium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yuriy Prilutskiy</td>\n",
       "      <td>Palladium 1114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>David Laubach</td>\n",
       "      <td>Palladium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>Michael Chang</td>\n",
       "      <td>Palladium 2302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>Hiro Fukuda</td>\n",
       "      <td>Palladium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>Elizabeth Demas</td>\n",
       "      <td>Palladium 827B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>Nicole Rosen</td>\n",
       "      <td>Palladium</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>781 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Name       Residence\n",
       "0        Ariel Podwal  Palladium 524D\n",
       "1           Josh Fern  Palladium 524F\n",
       "2     Santosh Sateesh   Palladium 603\n",
       "3      Holly Hamilton      Palladium \n",
       "4    Yuriy Prilutskiy  Palladium 1114\n",
       "..                ...             ...\n",
       "776     David Laubach      Palladium \n",
       "777     Michael Chang  Palladium 2302\n",
       "778       Hiro Fukuda      Palladium \n",
       "779   Elizabeth Demas  Palladium 827B\n",
       "780      Nicole Rosen      Palladium \n",
       "\n",
       "[781 rows x 2 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT Name, Residence\n",
    "FROM Profiles\n",
    "WHERE Residence LIKE 'Palladium%%'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all students who attended Stuyvesant"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:03 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>ProfileID</th>\n",
       "      <th>Name</th>\n",
       "      <th>MemberSince</th>\n",
       "      <th>LastUpdate</th>\n",
       "      <th>School</th>\n",
       "      <th>Status</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Birthday</th>\n",
       "      <th>AIM</th>\n",
       "      <th>Website</th>\n",
       "      <th>PoliticalViews</th>\n",
       "      <th>Geography</th>\n",
       "      <th>HighSchool</th>\n",
       "      <th>HomeTown</th>\n",
       "      <th>HomeState</th>\n",
       "      <th>Residence</th>\n",
       "      <th>CurrentAddress</th>\n",
       "      <th>CurrentTown</th>\n",
       "      <th>CurrentState</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>800073</td>\n",
       "      <td>Jueyu Wang</td>\n",
       "      <td>2004-03-23</td>\n",
       "      <td>2006-01-08</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-06-02</td>\n",
       "      <td>myheadwuzbumped</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '03</td>\n",
       "      <td>Brooklyn, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>800077</td>\n",
       "      <td>Sean Brandt</td>\n",
       "      <td>2004-03-23</td>\n",
       "      <td>2005-09-23</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985-07-17</td>\n",
       "      <td>yo soy el dorko</td>\n",
       "      <td>http://livejournal.com/~seanpictures</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '03</td>\n",
       "      <td>Staten Island, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>105 Lincoln Rd., Apt. 3J Brooklyn, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>800083</td>\n",
       "      <td>George Liu</td>\n",
       "      <td>2004-03-23</td>\n",
       "      <td>2005-12-30</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985-11-11</td>\n",
       "      <td>MEGAmorphG</td>\n",
       "      <td>None</td>\n",
       "      <td>Apathetic</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '03</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>800092</td>\n",
       "      <td>Hong Li</td>\n",
       "      <td>2004-03-23</td>\n",
       "      <td>2006-01-08</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-12-28</td>\n",
       "      <td>lilhacp1228</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '03</td>\n",
       "      <td>Whitestone, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>195 E. 4th St New York, NY 10009</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>800356</td>\n",
       "      <td>Peter Naas</td>\n",
       "      <td>2004-03-26</td>\n",
       "      <td>2006-01-17</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>None</td>\n",
       "      <td>1985-09-01</td>\n",
       "      <td>silent4042</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Eddie_Slovi...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '03</td>\n",
       "      <td>Cop Killer Queens</td>\n",
       "      <td>None</td>\n",
       "      <td>Carlyle Court C310CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>831501</td>\n",
       "      <td>Eliza Chan</td>\n",
       "      <td>2005-10-18</td>\n",
       "      <td>2005-11-02</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1987-11-05</td>\n",
       "      <td>BlackSerene</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '05</td>\n",
       "      <td>Brooklyn, NY 11229</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Brooklyn, NY 11229</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>831928</td>\n",
       "      <td>Jeff Strabone</td>\n",
       "      <td>2005-10-30</td>\n",
       "      <td>2006-01-12</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>http://www.lavasurfer.com/cereal-guide.h...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Brooklyn, NY</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>832061</td>\n",
       "      <td>Annie Chang</td>\n",
       "      <td>2005-11-03</td>\n",
       "      <td>2005-12-27</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Stuyvesant High School '05</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>832913</td>\n",
       "      <td>Elijah Kim</td>\n",
       "      <td>2005-11-26</td>\n",
       "      <td>2005-11-28</td>\n",
       "      <td>NYU '08</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Male</td>\n",
       "      <td>1982-06-07</td>\n",
       "      <td>qcelij</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>Stuyvesant High School '00</td>\n",
       "      <td>Brooklyn, NY 11237</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>833781</td>\n",
       "      <td>Mike Sim</td>\n",
       "      <td>2005-12-17</td>\n",
       "      <td>2005-12-29</td>\n",
       "      <td>NYU '03</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>1981-06-10</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>Stuyvesant High School '99</td>\n",
       "      <td>Brooklyn; Staten Island, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>237 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ProfileID           Name MemberSince LastUpdate   School          Status  \\\n",
       "0       800073     Jueyu Wang  2004-03-23 2006-01-08  NYU '07       Undergrad   \n",
       "1       800077    Sean Brandt  2004-03-23 2005-09-23  NYU '07       Undergrad   \n",
       "2       800083     George Liu  2004-03-23 2005-12-30  NYU '07       Undergrad   \n",
       "3       800092        Hong Li  2004-03-23 2006-01-08  NYU '07       Undergrad   \n",
       "4       800356     Peter Naas  2004-03-26 2006-01-17      NYU       Undergrad   \n",
       "..         ...            ...         ...        ...      ...             ...   \n",
       "232     831501     Eliza Chan  2005-10-18 2005-11-02  NYU '09       Undergrad   \n",
       "233     831928  Jeff Strabone  2005-10-30 2006-01-12      NYU       Undergrad   \n",
       "234     832061    Annie Chang  2005-11-03 2005-12-27      NYU       Undergrad   \n",
       "235     832913     Elijah Kim  2005-11-26 2005-11-28  NYU '08    Grad Student   \n",
       "236     833781       Mike Sim  2005-12-17 2005-12-29  NYU '03  Alumnus/Alumna   \n",
       "\n",
       "        Sex   Birthday              AIM  \\\n",
       "0    Female 1985-06-02  myheadwuzbumped   \n",
       "1      Male 1985-07-17  yo soy el dorko   \n",
       "2      Male 1985-11-11       MEGAmorphG   \n",
       "3    Female 1985-12-28      lilhacp1228   \n",
       "4      None 1985-09-01       silent4042   \n",
       "..      ...        ...              ...   \n",
       "232  Female 1987-11-05      BlackSerene   \n",
       "233    None        NaT             None   \n",
       "234    None        NaT             None   \n",
       "235    Male 1982-06-07           qcelij   \n",
       "236    Male 1981-06-10             None   \n",
       "\n",
       "                                         Website PoliticalViews  \\\n",
       "0                                           None       Moderate   \n",
       "1           http://livejournal.com/~seanpictures        Liberal   \n",
       "2                                           None      Apathetic   \n",
       "3                                           None        Liberal   \n",
       "4    http://en.wikipedia.org/wiki/Eddie_Slovi...           None   \n",
       "..                                           ...            ...   \n",
       "232                                         None           None   \n",
       "233  http://www.lavasurfer.com/cereal-guide.h...           None   \n",
       "234                                         None           None   \n",
       "235                                         None           None   \n",
       "236                                         None           None   \n",
       "\n",
       "         Geography                  HighSchool                     HomeTown  \\\n",
       "0             None  Stuyvesant High School '03                 Brooklyn, NY   \n",
       "1             None  Stuyvesant High School '03            Staten Island, NY   \n",
       "2             None  Stuyvesant High School '03                 New York, NY   \n",
       "3             None  Stuyvesant High School '03               Whitestone, NY   \n",
       "4             None  Stuyvesant High School '03            Cop Killer Queens   \n",
       "..             ...                         ...                          ...   \n",
       "232           None  Stuyvesant High School '05           Brooklyn, NY 11229   \n",
       "233           None      Stuyvesant High School                         None   \n",
       "234           None  Stuyvesant High School '05                         None   \n",
       "235  New York,  NY  Stuyvesant High School '00           Brooklyn, NY 11237   \n",
       "236  New York,  NY  Stuyvesant High School '99  Brooklyn; Staten Island, NY   \n",
       "\n",
       "    HomeState             Residence                          CurrentAddress  \\\n",
       "0        None                  None                                    None   \n",
       "1        None                  None  105 Lincoln Rd., Apt. 3J Brooklyn, NY    \n",
       "2        None                  None                                    None   \n",
       "3        None                  None        195 E. 4th St New York, NY 10009   \n",
       "4        None  Carlyle Court C310CA                                    None   \n",
       "..        ...                   ...                                     ...   \n",
       "232      None                  None                                    None   \n",
       "233      None                  None                                    None   \n",
       "234      None                  None                                    None   \n",
       "235      None                  None                                    None   \n",
       "236      None                  None                                    None   \n",
       "\n",
       "            CurrentTown CurrentState  \n",
       "0                  None         None  \n",
       "1                  None         None  \n",
       "2                  None         None  \n",
       "3                  None         None  \n",
       "4                  None         None  \n",
       "..                  ...          ...  \n",
       "232  Brooklyn, NY 11229         None  \n",
       "233       Brooklyn, NY          None  \n",
       "234                None         None  \n",
       "235                None         None  \n",
       "236                None         None  \n",
       "\n",
       "[237 rows x 19 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT *\n",
    "FROM Profiles\n",
    "WHERE HighSchool LIKE 'Stuyvesant%%'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all names that contain a digit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:04 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>ProfileID</th>\n",
       "      <th>Name</th>\n",
       "      <th>MemberSince</th>\n",
       "      <th>LastUpdate</th>\n",
       "      <th>School</th>\n",
       "      <th>Status</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Birthday</th>\n",
       "      <th>AIM</th>\n",
       "      <th>Website</th>\n",
       "      <th>PoliticalViews</th>\n",
       "      <th>Geography</th>\n",
       "      <th>HighSchool</th>\n",
       "      <th>HomeTown</th>\n",
       "      <th>HomeState</th>\n",
       "      <th>Residence</th>\n",
       "      <th>CurrentAddress</th>\n",
       "      <th>CurrentTown</th>\n",
       "      <th>CurrentState</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>817012</td>\n",
       "      <td>Tbone 3000</td>\n",
       "      <td>2004-12-12</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>817574</td>\n",
       "      <td>K 5</td>\n",
       "      <td>2004-12-26</td>\n",
       "      <td>2005-09-28</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>kjobby12xxx</td>\n",
       "      <td>http://www.K5ive.com</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>Royal High '01</td>\n",
       "      <td>Simi Valley, CA 93065</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>818366</td>\n",
       "      <td>Arielle 4u</td>\n",
       "      <td>2005-01-19</td>\n",
       "      <td>2006-01-15</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1986-10-24</td>\n",
       "      <td>sexoholic blue u</td>\n",
       "      <td>http://five.flash-gear.com/npuz/puz.php?...</td>\n",
       "      <td>Very Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Twentysixth Street 14F1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>819379</td>\n",
       "      <td>ML152</td>\n",
       "      <td>2005-02-14</td>\n",
       "      <td>2005-12-09</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Male</td>\n",
       "      <td>1977-03-05</td>\n",
       "      <td>mattlobron</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Long Valley, NJ 07853</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY, NY</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>819606</td>\n",
       "      <td>Panaflex 16</td>\n",
       "      <td>2005-02-21</td>\n",
       "      <td>2005-02-21</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>http://www.panavision.com</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>821186</td>\n",
       "      <td>g nupe the hazel eyed 1</td>\n",
       "      <td>2005-04-04</td>\n",
       "      <td>2006-01-18</td>\n",
       "      <td>NYU '05</td>\n",
       "      <td>Faculty</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>g NUPE the hAZEL EYED</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>new york, NY 10037</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>823755</td>\n",
       "      <td>NYC Summer2005</td>\n",
       "      <td>2005-05-22</td>\n",
       "      <td>2006-01-18</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>mischa998</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>New York City, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NYC, NY 10012</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>827978</td>\n",
       "      <td>Ben 0viatt</td>\n",
       "      <td>2005-08-05</td>\n",
       "      <td>2006-01-13</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1986-08-17</td>\n",
       "      <td>TheCoolestMonkey</td>\n",
       "      <td>http://www.fotolog.net/bennigan/</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>Lander Valley High School '04</td>\n",
       "      <td>Lander, WY 82520</td>\n",
       "      <td>None</td>\n",
       "      <td>Hayden Hall 1011A</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ProfileID                     Name MemberSince LastUpdate   School  \\\n",
       "0     817012               Tbone 3000  2004-12-12        NaT      NYU   \n",
       "1     817574                      K 5  2004-12-26 2005-09-28  NYU '07   \n",
       "2     818366               Arielle 4u  2005-01-19 2006-01-15  NYU '07   \n",
       "3     819379                    ML152  2005-02-14 2005-12-09  NYU '06   \n",
       "4     819606              Panaflex 16  2005-02-21 2005-02-21      NYU   \n",
       "5     821186  g nupe the hazel eyed 1  2005-04-04 2006-01-18  NYU '05   \n",
       "6     823755           NYC Summer2005  2005-05-22 2006-01-18      NYU   \n",
       "7     827978               Ben 0viatt  2005-08-05 2006-01-13  NYU '09   \n",
       "\n",
       "           Status     Sex   Birthday                     AIM  \\\n",
       "0       Undergrad    None        NaT                    None   \n",
       "1       Undergrad    Male        NaT             kjobby12xxx   \n",
       "2       Undergrad  Female 1986-10-24        sexoholic blue u   \n",
       "3    Grad Student    Male 1977-03-05              mattlobron   \n",
       "4  Alumnus/Alumna    None        NaT                    None   \n",
       "5         Faculty    Male        NaT   g NUPE the hAZEL EYED   \n",
       "6  Alumnus/Alumna    Male        NaT               mischa998   \n",
       "7       Undergrad    Male 1986-08-17        TheCoolestMonkey   \n",
       "\n",
       "                                       Website PoliticalViews Geography  \\\n",
       "0                                         None           None      None   \n",
       "1                         http://www.K5ive.com          Other      None   \n",
       "2  http://five.flash-gear.com/npuz/puz.php?...   Very Liberal      None   \n",
       "3                                         None           None      None   \n",
       "4                    http://www.panavision.com           None      None   \n",
       "5                                         None       Moderate      None   \n",
       "6                                         None           None      None   \n",
       "7             http://www.fotolog.net/bennigan/          Other      None   \n",
       "\n",
       "                      HighSchool               HomeTown HomeState  \\\n",
       "0                           None                   None      None   \n",
       "1                 Royal High '01  Simi Valley, CA 93065      None   \n",
       "2                           None                   None      None   \n",
       "3                           None  Long Valley, NJ 07853      None   \n",
       "4                           None                   None      None   \n",
       "5                           None     new york, NY 10037      None   \n",
       "6                           None      New York City, NY      None   \n",
       "7  Lander Valley High School '04       Lander, WY 82520      None   \n",
       "\n",
       "                 Residence CurrentAddress    CurrentTown CurrentState  \n",
       "0                     None           None           None         None  \n",
       "1                     None           None           None           NY  \n",
       "2  Twentysixth Street 14F1           None           None         None  \n",
       "3                     None           None        NY, NY          None  \n",
       "4                     None           None           None         None  \n",
       "5                     None           None           None         None  \n",
       "6                     None           None  NYC, NY 10012         None  \n",
       "7        Hayden Hall 1011A           None           None         None  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT * \n",
    "FROM Profiles \n",
    "WHERE name REGEXP '[0-9]+'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find all students with a name that contains a non-letter character, other than \\- and \\."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Query started at 08:10:04 PM UTC; Query executed in 0.00 m"
     ]
    },
    {
     "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>ProfileID</th>\n",
       "      <th>Name</th>\n",
       "      <th>MemberSince</th>\n",
       "      <th>LastUpdate</th>\n",
       "      <th>School</th>\n",
       "      <th>Status</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Birthday</th>\n",
       "      <th>AIM</th>\n",
       "      <th>Website</th>\n",
       "      <th>PoliticalViews</th>\n",
       "      <th>Geography</th>\n",
       "      <th>HighSchool</th>\n",
       "      <th>HomeTown</th>\n",
       "      <th>HomeState</th>\n",
       "      <th>Residence</th>\n",
       "      <th>CurrentAddress</th>\n",
       "      <th>CurrentTown</th>\n",
       "      <th>CurrentState</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>800794</td>\n",
       "      <td>Shula Ponet β™¥</td>\n",
       "      <td>2004-04-01</td>\n",
       "      <td>2006-01-15</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1983-10-24</td>\n",
       "      <td>shuls1024</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Hamden Hall Country Day School '02</td>\n",
       "      <td>new haven, CT</td>\n",
       "      <td>None</td>\n",
       "      <td>Alumni Hall</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>802953</td>\n",
       "      <td>DontrΓ© L. Conerly</td>\n",
       "      <td>2004-04-20</td>\n",
       "      <td>2005-12-26</td>\n",
       "      <td>NYU '05</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>1983-02-07</td>\n",
       "      <td>majoliemoi</td>\n",
       "      <td>http://jadoremoi.easyjournal.com</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>Lawndale High School '01</td>\n",
       "      <td>New Orleans, LA 70126</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>803148</td>\n",
       "      <td>Rajiv/Jeeves Therealman</td>\n",
       "      <td>2004-04-21</td>\n",
       "      <td>2006-01-03</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985-07-22</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>None</td>\n",
       "      <td>Boonton High School '03</td>\n",
       "      <td>Boonton, NJ 07005</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>803169</td>\n",
       "      <td>David NegrΓ³n</td>\n",
       "      <td>2004-04-21</td>\n",
       "      <td>2005-10-29</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984-09-21</td>\n",
       "      <td>dbneg921</td>\n",
       "      <td>None</td>\n",
       "      <td>Very Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Guilford High School '03</td>\n",
       "      <td>Guilford, CT 06437</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Brooklyn, NY 11222</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>803349</td>\n",
       "      <td>Christopher T|M Burns</td>\n",
       "      <td>2004-04-22</td>\n",
       "      <td>2006-01-04</td>\n",
       "      <td>NYU '04</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>http://www.sickabodsane.com</td>\n",
       "      <td>None</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>The Pennington Prep School '00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>803696</td>\n",
       "      <td>β™¥ Rachel Doyle β™¥</td>\n",
       "      <td>2004-04-25</td>\n",
       "      <td>2006-01-09</td>\n",
       "      <td>NYU '05</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Female</td>\n",
       "      <td>1984-04-27</td>\n",
       "      <td>o doyle ru1ez</td>\n",
       "      <td>http://myspace.com/ambrosiaswirl</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>Albert Einstein High School</td>\n",
       "      <td>District of Corruption</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>E. 5th &amp; Avenue B, Manhattan</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>804467</td>\n",
       "      <td>ChloΓ© Bakalar</td>\n",
       "      <td>2004-04-29</td>\n",
       "      <td>2006-01-09</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-03-14</td>\n",
       "      <td>skittlesCLO</td>\n",
       "      <td>None</td>\n",
       "      <td>Very Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>Pine Crest School '03</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>805463</td>\n",
       "      <td>TrinΓ© Alimena</td>\n",
       "      <td>2004-05-07</td>\n",
       "      <td>2006-01-16</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-06-16</td>\n",
       "      <td>Quarterrican16</td>\n",
       "      <td>None</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Stamford, CT 06905</td>\n",
       "      <td>None</td>\n",
       "      <td>Carlyle Court</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>806663</td>\n",
       "      <td>Jeremy Greene (δΊΊ)</td>\n",
       "      <td>2004-05-26</td>\n",
       "      <td>2006-01-16</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984-11-26</td>\n",
       "      <td>Tirbz</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Winter Springs High School '03</td>\n",
       "      <td>New York, NY 10011</td>\n",
       "      <td>None</td>\n",
       "      <td>Thirteenth Street 3BS</td>\n",
       "      <td>47 W 13</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>807220</td>\n",
       "      <td>Margaux OpeΓ±a</td>\n",
       "      <td>2004-06-09</td>\n",
       "      <td>2005-10-23</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Female</td>\n",
       "      <td>1982-09-25</td>\n",
       "      <td>Roswelliscool</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Convent of the Sacred Heart High School '00</td>\n",
       "      <td>San Francisco, CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>808815</td>\n",
       "      <td>β™¥ Inga Schlingmann β™¥</td>\n",
       "      <td>2004-07-25</td>\n",
       "      <td>2006-01-17</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>None</td>\n",
       "      <td>1986-06-25</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Suffern Senior High School '04</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>809153</td>\n",
       "      <td>Paul M. NuΓ±ez</td>\n",
       "      <td>2004-08-02</td>\n",
       "      <td>2005-11-10</td>\n",
       "      <td>NYU '08</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1986-02-13</td>\n",
       "      <td>pmnb222</td>\n",
       "      <td>None</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>Baldwin Senior High School '04</td>\n",
       "      <td>Lima, Peru</td>\n",
       "      <td>None</td>\n",
       "      <td>Water Street 404</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>809359</td>\n",
       "      <td>GΓ¤ΓΒ®Γ®Γ¨Β¶Γ¥ ΓƒrΓ―ΒΒ§</td>\n",
       "      <td>2004-08-07</td>\n",
       "      <td>2005-12-15</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>NaT</td>\n",
       "      <td>Dee03Vuh</td>\n",
       "      <td>None</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>Farmingdale Senior High School '03</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NYU at the Seaport</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>810447</td>\n",
       "      <td>Miss Huang β…</td>\n",
       "      <td>2004-08-26</td>\n",
       "      <td>2006-01-16</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>NaT</td>\n",
       "      <td>Miss Seimi</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>RIS '03</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>810711</td>\n",
       "      <td>Nazia Malikβ™¥</td>\n",
       "      <td>2004-08-30</td>\n",
       "      <td>2006-01-15</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1986-02-21</td>\n",
       "      <td>xnazzzx</td>\n",
       "      <td>None</td>\n",
       "      <td>Very Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>North Brunswick Township High School</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>810796</td>\n",
       "      <td>Stephanie F. LΓ³pez</td>\n",
       "      <td>2004-08-31</td>\n",
       "      <td>2005-11-23</td>\n",
       "      <td>NYU '08</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1986-10-18</td>\n",
       "      <td>flordeliz86</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Herbert H.Lehman High School '04</td>\n",
       "      <td>Bronx, NY 10459</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>812249</td>\n",
       "      <td>LΓ©a Guberina-Sulc</td>\n",
       "      <td>2004-09-21</td>\n",
       "      <td>2005-09-07</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-08-01</td>\n",
       "      <td>Metallicbarbie</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>None</td>\n",
       "      <td>Lycee Francais De New York '03</td>\n",
       "      <td>New York, NY 10021</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>812902</td>\n",
       "      <td>Jones/Kate Cook</td>\n",
       "      <td>2004-10-01</td>\n",
       "      <td>2006-01-17</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1984-08-29</td>\n",
       "      <td>JimmysJones17</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>St. Francis High School '02</td>\n",
       "      <td>Los Altos, CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>813147</td>\n",
       "      <td>LFNY Alumni/a</td>\n",
       "      <td>2004-10-06</td>\n",
       "      <td>2005-10-25</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>1931-09-07</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>Lycee Francais De New York '00</td>\n",
       "      <td>New York City, NY 10021</td>\n",
       "      <td>None</td>\n",
       "      <td>Paris</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>814475</td>\n",
       "      <td>Ahmed Mirzaβ„Ά</td>\n",
       "      <td>2004-10-28</td>\n",
       "      <td>2005-12-20</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985-03-16</td>\n",
       "      <td>avigalante</td>\n",
       "      <td>http://www.shaadi.com</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Sanford H.Calhoun High School '03</td>\n",
       "      <td>Merrick, NY 11566</td>\n",
       "      <td>None</td>\n",
       "      <td>Carlyle Court C23G</td>\n",
       "      <td>25 Union Square West, Apartment C2-3G New York...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>816365</td>\n",
       "      <td>Tavia NyongΓΆΒ€Β™o</td>\n",
       "      <td>2004-12-01</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Faculty</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>816689</td>\n",
       "      <td>Rayna Greenberg β™¥</td>\n",
       "      <td>2004-12-06</td>\n",
       "      <td>2005-12-02</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1983-10-17</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Branksome Hall '02</td>\n",
       "      <td>Toronto, Ontario</td>\n",
       "      <td>None</td>\n",
       "      <td>Water Street 2313</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>817012</td>\n",
       "      <td>Tbone 3000</td>\n",
       "      <td>2004-12-12</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>817118</td>\n",
       "      <td>Angel Carlos PeΓ±a</td>\n",
       "      <td>2004-12-14</td>\n",
       "      <td>2006-01-10</td>\n",
       "      <td>NYU '08</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1986-08-12</td>\n",
       "      <td>DEADMANINC812</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>None</td>\n",
       "      <td>Fordham Prep '04</td>\n",
       "      <td>The Bronx, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>817574</td>\n",
       "      <td>K 5</td>\n",
       "      <td>2004-12-26</td>\n",
       "      <td>2005-09-28</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>kjobby12xxx</td>\n",
       "      <td>http://www.K5ive.com</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>Royal High '01</td>\n",
       "      <td>Simi Valley, CA 93065</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>818366</td>\n",
       "      <td>Arielle 4u</td>\n",
       "      <td>2005-01-19</td>\n",
       "      <td>2006-01-15</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1986-10-24</td>\n",
       "      <td>sexoholic blue u</td>\n",
       "      <td>http://five.flash-gear.com/npuz/puz.php?...</td>\n",
       "      <td>Very Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Twentysixth Street 14F1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>818825</td>\n",
       "      <td>Meral KΓ¶lblinger</td>\n",
       "      <td>2005-01-30</td>\n",
       "      <td>2006-01-15</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-08-26</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>American International School</td>\n",
       "      <td>Vienna, Austria, 3411</td>\n",
       "      <td>None</td>\n",
       "      <td>Greenwich Hotel</td>\n",
       "      <td>Hauptstrasse 75 Klosterneuburg/Weidling, N.Γ–....</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>818829</td>\n",
       "      <td>Joakim HΓ¶glind</td>\n",
       "      <td>2005-01-30</td>\n",
       "      <td>2005-10-01</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Male</td>\n",
       "      <td>1979-11-13</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>SWEDEN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>GΓ¶teborg, SWEDEN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>818841</td>\n",
       "      <td>Jay Rosen: DC birthright israel Coordinator</td>\n",
       "      <td>2005-01-31</td>\n",
       "      <td>2005-12-29</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>JRizzleATaglit</td>\n",
       "      <td>http://www.dcmetro.birthrightisrael.com</td>\n",
       "      <td>None</td>\n",
       "      <td>Washington,  DC</td>\n",
       "      <td>Charles E. Smith Jewish Day School '00</td>\n",
       "      <td>Washington, DC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>819305</td>\n",
       "      <td>Mac/Knife</td>\n",
       "      <td>2005-02-12</td>\n",
       "      <td>2005-02-23</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>hanesmcfearson</td>\n",
       "      <td>http://homepage.mac.com/ptsmith</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>New York, NY 10014</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>819379</td>\n",
       "      <td>ML152</td>\n",
       "      <td>2005-02-14</td>\n",
       "      <td>2005-12-09</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Male</td>\n",
       "      <td>1977-03-05</td>\n",
       "      <td>mattlobron</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Long Valley, NJ 07853</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY, NY</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>819606</td>\n",
       "      <td>Panaflex 16</td>\n",
       "      <td>2005-02-21</td>\n",
       "      <td>2005-02-21</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>http://www.panavision.com</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>819681</td>\n",
       "      <td>Osei Roach Bennβ„Ά</td>\n",
       "      <td>2005-02-23</td>\n",
       "      <td>2006-01-16</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1983-01-11</td>\n",
       "      <td>oseibenn</td>\n",
       "      <td>http://www.tkenyu.org</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>Hillview College '01</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Tau Kappa Epsilon TKE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>819973</td>\n",
       "      <td>Elda CantΓΊ</td>\n",
       "      <td>2005-03-03</td>\n",
       "      <td>2005-07-21</td>\n",
       "      <td>NYU '05</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Female</td>\n",
       "      <td>1979-03-23</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>820434</td>\n",
       "      <td>Jamie Mooreβ™¥</td>\n",
       "      <td>2005-03-16</td>\n",
       "      <td>2005-05-29</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1984-09-08</td>\n",
       "      <td>malibuebarby</td>\n",
       "      <td>None</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>820682</td>\n",
       "      <td>Ananda M. MalavΓ©</td>\n",
       "      <td>2005-03-24</td>\n",
       "      <td>2006-01-18</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1987-03-02</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Very Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>St. John Villa Academy '05</td>\n",
       "      <td>Staten Island, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>Hayden Hall</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>820721</td>\n",
       "      <td>Alfonsina Jimenez ~ AJ</td>\n",
       "      <td>2005-03-24</td>\n",
       "      <td>2005-12-16</td>\n",
       "      <td>NYU '08</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1986-09-28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Fashion Industires High School '04</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Alpha Sigma Tau AST</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>821176</td>\n",
       "      <td>Jean BernabΓ©</td>\n",
       "      <td>2005-04-04</td>\n",
       "      <td>2006-01-08</td>\n",
       "      <td>NYU '06</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984-10-14</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>Fordham Prep '02</td>\n",
       "      <td>Bronx, NY 10452</td>\n",
       "      <td>None</td>\n",
       "      <td>Phi Iota Alpha FIA ,DABRONX</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>821186</td>\n",
       "      <td>g nupe the hazel eyed 1</td>\n",
       "      <td>2005-04-04</td>\n",
       "      <td>2006-01-18</td>\n",
       "      <td>NYU '05</td>\n",
       "      <td>Faculty</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>g NUPE the hAZEL EYED</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>new york, NY 10037</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>822269</td>\n",
       "      <td>Kara AngΓ¨le Pressley</td>\n",
       "      <td>2005-04-28</td>\n",
       "      <td>2005-04-28</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Female</td>\n",
       "      <td>1982-01-28</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>823029</td>\n",
       "      <td>Cynthia PeΓ±a</td>\n",
       "      <td>2005-05-11</td>\n",
       "      <td>2006-01-13</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1985-07-23</td>\n",
       "      <td>sfc3nyc</td>\n",
       "      <td>None</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Desert Mountain High School '03</td>\n",
       "      <td>Born Walnut Creek,CA; grew up Scottsdale, AZ</td>\n",
       "      <td>None</td>\n",
       "      <td>Rubin Hall 905</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>823455</td>\n",
       "      <td>Mario PagΓ΅n</td>\n",
       "      <td>2005-05-17</td>\n",
       "      <td>2006-01-18</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987-06-12</td>\n",
       "      <td>iwassocoolbefore</td>\n",
       "      <td>http://superpooper.deviantart.com</td>\n",
       "      <td>Very Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Commonwealth High School '05</td>\n",
       "      <td>San Juan, PR</td>\n",
       "      <td>None</td>\n",
       "      <td>Third Avenue North TS502B</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>823755</td>\n",
       "      <td>NYC Summer2005</td>\n",
       "      <td>2005-05-22</td>\n",
       "      <td>2006-01-18</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>Male</td>\n",
       "      <td>NaT</td>\n",
       "      <td>mischa998</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>New York City, NY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NYC, NY 10012</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>824519</td>\n",
       "      <td>Marie-HΓ©lΓ¨ne Rousseau</td>\n",
       "      <td>2005-06-04</td>\n",
       "      <td>2006-01-13</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1987-02-19</td>\n",
       "      <td>mhrousseau</td>\n",
       "      <td>None</td>\n",
       "      <td>Libertarian</td>\n",
       "      <td>None</td>\n",
       "      <td>Rabat American School '05</td>\n",
       "      <td>amman, tunis, cairo, dhaka, fairfax, rabat...</td>\n",
       "      <td>None</td>\n",
       "      <td>Florence COLLETTA11</td>\n",
       "      <td>None</td>\n",
       "      <td>Rabat, Morocco</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>826997</td>\n",
       "      <td>QingQing/Celeste Qiu</td>\n",
       "      <td>2005-07-17</td>\n",
       "      <td>2005-11-30</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>http://spaces.msn.com/members/whatwewant</td>\n",
       "      <td>Apathetic</td>\n",
       "      <td>None</td>\n",
       "      <td>Gordonstoun</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>None</td>\n",
       "      <td>Florence COLLETTA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>827298</td>\n",
       "      <td>Fernando BaliΓ±o</td>\n",
       "      <td>2005-07-23</td>\n",
       "      <td>2006-01-16</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987-02-03</td>\n",
       "      <td>fb69169</td>\n",
       "      <td>http://www.myspace.com/uruguayo</td>\n",
       "      <td>Liberal</td>\n",
       "      <td>None</td>\n",
       "      <td>Uruguayan American School '05</td>\n",
       "      <td>Montevideo, Uruguay, 11500</td>\n",
       "      <td>None</td>\n",
       "      <td>Weinstein Hall 513A</td>\n",
       "      <td>5-11 University Place New York, NY 10003</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>827776</td>\n",
       "      <td>Maria Manouselis β™¥</td>\n",
       "      <td>2005-08-01</td>\n",
       "      <td>2006-01-17</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Female</td>\n",
       "      <td>1987-10-29</td>\n",
       "      <td>askk</td>\n",
       "      <td>None</td>\n",
       "      <td>Conservative</td>\n",
       "      <td>None</td>\n",
       "      <td>Byram Hills High School '05</td>\n",
       "      <td>armonk, NY 10504</td>\n",
       "      <td>None</td>\n",
       "      <td>Third Avenue North</td>\n",
       "      <td>None</td>\n",
       "      <td>nyc</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>827978</td>\n",
       "      <td>Ben 0viatt</td>\n",
       "      <td>2005-08-05</td>\n",
       "      <td>2006-01-13</td>\n",
       "      <td>NYU '09</td>\n",
       "      <td>Undergrad</td>\n",
       "      <td>Male</td>\n",
       "      <td>1986-08-17</td>\n",
       "      <td>TheCoolestMonkey</td>\n",
       "      <td>http://www.fotolog.net/bennigan/</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>Lander Valley High School '04</td>\n",
       "      <td>Lander, WY 82520</td>\n",
       "      <td>None</td>\n",
       "      <td>Hayden Hall 1011A</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>829942</td>\n",
       "      <td>Dr. Ce$aR Ξ›ΞΞ¦</td>\n",
       "      <td>2005-04-17</td>\n",
       "      <td>2006-01-14</td>\n",
       "      <td>NYU '07</td>\n",
       "      <td>Grad Student</td>\n",
       "      <td>Male</td>\n",
       "      <td>1983-03-19</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Moderate</td>\n",
       "      <td>New York,  NY</td>\n",
       "      <td>St. Francis Prep '01</td>\n",
       "      <td>Elmhurst, NY 11373</td>\n",
       "      <td>None</td>\n",
       "      <td>Washington Square Village</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>830030</td>\n",
       "      <td>Uni Code Ι™poΙ”Δ±Μ£un</td>\n",
       "      <td>2005-09-13</td>\n",
       "      <td>2005-09-14</td>\n",
       "      <td>NYU</td>\n",
       "      <td>Alumnus/Alumna</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>http://www.unicode.org</td>\n",
       "      <td>Other</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Palo Alto, CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ProfileID                                         Name MemberSince  \\\n",
       "0      800794                              Shula Ponet β™¥  2004-04-01   \n",
       "1      802953                           DontrΓ© L. Conerly  2004-04-20   \n",
       "2      803148                      Rajiv/Jeeves Therealman  2004-04-21   \n",
       "3      803169                                David NegrΓ³n  2004-04-21   \n",
       "4      803349                        Christopher T|M Burns  2004-04-22   \n",
       "5      803696                         β™¥ Rachel Doyle β™¥  2004-04-25   \n",
       "6      804467                               ChloΓ© Bakalar  2004-04-29   \n",
       "7      805463                               TrinΓ© Alimena  2004-05-07   \n",
       "8      806663                          Jeremy Greene (δΊΊ)  2004-05-26   \n",
       "9      807220                               Margaux OpeΓ±a  2004-06-09   \n",
       "10     808815                     β™¥ Inga Schlingmann β™¥  2004-07-25   \n",
       "11     809153                               Paul M. NuΓ±ez  2004-08-02   \n",
       "12     809359                    GΓ¤ΓΒ®Γ®Γ¨Β¶Γ¥ ΓƒrΓ―ΒΒ§  2004-08-07   \n",
       "13     810447                               Miss Huang β…  2004-08-26   \n",
       "14     810711                               Nazia Malikβ™¥  2004-08-30   \n",
       "15     810796                          Stephanie F. LΓ³pez  2004-08-31   \n",
       "16     812249                           LΓ©a Guberina-Sulc  2004-09-21   \n",
       "17     812902                              Jones/Kate Cook  2004-10-01   \n",
       "18     813147                                LFNY Alumni/a  2004-10-06   \n",
       "19     814475                               Ahmed Mirzaβ„Ά  2004-10-28   \n",
       "20     816365                           Tavia NyongΓΆΒ€Β™o  2004-12-01   \n",
       "21     816689                          Rayna Greenberg β™¥  2004-12-06   \n",
       "22     817012                                   Tbone 3000  2004-12-12   \n",
       "23     817118                           Angel Carlos PeΓ±a  2004-12-14   \n",
       "24     817574                                          K 5  2004-12-26   \n",
       "25     818366                                   Arielle 4u  2005-01-19   \n",
       "26     818825                            Meral KΓ¶lblinger  2005-01-30   \n",
       "27     818829                              Joakim HΓ¶glind  2005-01-30   \n",
       "28     818841  Jay Rosen: DC birthright israel Coordinator  2005-01-31   \n",
       "29     819305                                    Mac/Knife  2005-02-12   \n",
       "30     819379                                        ML152  2005-02-14   \n",
       "31     819606                                  Panaflex 16  2005-02-21   \n",
       "32     819681                           Osei Roach Bennβ„Ά  2005-02-23   \n",
       "33     819973                                  Elda CantΓΊ  2005-03-03   \n",
       "34     820434                               Jamie Mooreβ™¥  2005-03-16   \n",
       "35     820682                            Ananda M. MalavΓ©  2005-03-24   \n",
       "36     820721                       Alfonsina Jimenez ~ AJ  2005-03-24   \n",
       "37     821176                                Jean BernabΓ©  2005-04-04   \n",
       "38     821186                      g nupe the hazel eyed 1  2005-04-04   \n",
       "39     822269                        Kara AngΓ¨le Pressley  2005-04-28   \n",
       "40     823029                                Cynthia PeΓ±a  2005-05-11   \n",
       "41     823455                                 Mario PagΓ΅n  2005-05-17   \n",
       "42     823755                               NYC Summer2005  2005-05-22   \n",
       "43     824519                      Marie-HΓ©lΓ¨ne Rousseau  2005-06-04   \n",
       "44     826997                         QingQing/Celeste Qiu  2005-07-17   \n",
       "45     827298                             Fernando BaliΓ±o  2005-07-23   \n",
       "46     827776                         Maria Manouselis β™¥  2005-08-01   \n",
       "47     827978                                   Ben 0viatt  2005-08-05   \n",
       "48     829942                             Dr. Ce$aR Ξ›ΞΞ¦  2005-04-17   \n",
       "49     830030                        Uni Code Ι™poΙ”Δ±Μ£un  2005-09-13   \n",
       "\n",
       "   LastUpdate   School          Status     Sex   Birthday  \\\n",
       "0  2006-01-15  NYU '06       Undergrad  Female 1983-10-24   \n",
       "1  2005-12-26  NYU '05  Alumnus/Alumna    Male 1983-02-07   \n",
       "2  2006-01-03  NYU '07       Undergrad    Male 1985-07-22   \n",
       "3  2005-10-29  NYU '07       Undergrad    Male 1984-09-21   \n",
       "4  2006-01-04  NYU '04  Alumnus/Alumna    Male        NaT   \n",
       "5  2006-01-09  NYU '05  Alumnus/Alumna  Female 1984-04-27   \n",
       "6  2006-01-09  NYU '06       Undergrad  Female 1985-03-14   \n",
       "7  2006-01-16  NYU '07       Undergrad  Female 1985-06-16   \n",
       "8  2006-01-16  NYU '07       Undergrad    Male 1984-11-26   \n",
       "9  2005-10-23      NYU  Alumnus/Alumna  Female 1982-09-25   \n",
       "10 2006-01-17      NYU       Undergrad    None 1986-06-25   \n",
       "11 2005-11-10  NYU '08       Undergrad    Male 1986-02-13   \n",
       "12 2005-12-15  NYU '07       Undergrad  Female        NaT   \n",
       "13 2006-01-16  NYU '07       Undergrad  Female        NaT   \n",
       "14 2006-01-15  NYU '07       Undergrad  Female 1986-02-21   \n",
       "15 2005-11-23  NYU '08       Undergrad  Female 1986-10-18   \n",
       "16 2005-09-07  NYU '07       Undergrad  Female 1985-08-01   \n",
       "17 2006-01-17  NYU '06       Undergrad  Female 1984-08-29   \n",
       "18 2005-10-25      NYU  Alumnus/Alumna    Male 1931-09-07   \n",
       "19 2005-12-20  NYU '07       Undergrad    Male 1985-03-16   \n",
       "20        NaT      NYU         Faculty    None        NaT   \n",
       "21 2005-12-02  NYU '06       Undergrad  Female 1983-10-17   \n",
       "22        NaT      NYU       Undergrad    None        NaT   \n",
       "23 2006-01-10  NYU '08       Undergrad    Male 1986-08-12   \n",
       "24 2005-09-28  NYU '07       Undergrad    Male        NaT   \n",
       "25 2006-01-15  NYU '07       Undergrad  Female 1986-10-24   \n",
       "26 2006-01-15  NYU '07       Undergrad  Female 1985-08-26   \n",
       "27 2005-10-01      NYU    Grad Student    Male 1979-11-13   \n",
       "28 2005-12-29      NYU  Alumnus/Alumna    Male        NaT   \n",
       "29 2005-02-23      NYU       Undergrad    Male        NaT   \n",
       "30 2005-12-09  NYU '06    Grad Student    Male 1977-03-05   \n",
       "31 2005-02-21      NYU  Alumnus/Alumna    None        NaT   \n",
       "32 2006-01-16  NYU '06       Undergrad    Male 1983-01-11   \n",
       "33 2005-07-21  NYU '05    Grad Student  Female 1979-03-23   \n",
       "34 2005-05-29  NYU '06       Undergrad  Female 1984-09-08   \n",
       "35 2006-01-18  NYU '09       Undergrad  Female 1987-03-02   \n",
       "36 2005-12-16  NYU '08       Undergrad  Female 1986-09-28   \n",
       "37 2006-01-08  NYU '06       Undergrad    Male 1984-10-14   \n",
       "38 2006-01-18  NYU '05         Faculty    Male        NaT   \n",
       "39 2005-04-28      NYU    Grad Student  Female 1982-01-28   \n",
       "40 2006-01-13  NYU '07       Undergrad  Female 1985-07-23   \n",
       "41 2006-01-18  NYU '09       Undergrad    Male 1987-06-12   \n",
       "42 2006-01-18      NYU  Alumnus/Alumna    Male        NaT   \n",
       "43 2006-01-13  NYU '09       Undergrad  Female 1987-02-19   \n",
       "44 2005-11-30  NYU '09       Undergrad  Female        NaT   \n",
       "45 2006-01-16  NYU '09       Undergrad    Male 1987-02-03   \n",
       "46 2006-01-17  NYU '09       Undergrad  Female 1987-10-29   \n",
       "47 2006-01-13  NYU '09       Undergrad    Male 1986-08-17   \n",
       "48 2006-01-14  NYU '07    Grad Student    Male 1983-03-19   \n",
       "49 2005-09-14      NYU  Alumnus/Alumna    None        NaT   \n",
       "\n",
       "                       AIM                                      Website  \\\n",
       "0                shuls1024                                         None   \n",
       "1               majoliemoi             http://jadoremoi.easyjournal.com   \n",
       "2                     None                                         None   \n",
       "3                 dbneg921                                         None   \n",
       "4                     None                  http://www.sickabodsane.com   \n",
       "5            o doyle ru1ez             http://myspace.com/ambrosiaswirl   \n",
       "6              skittlesCLO                                         None   \n",
       "7           Quarterrican16                                         None   \n",
       "8                    Tirbz                                         None   \n",
       "9            Roswelliscool                                         None   \n",
       "10                    None                                         None   \n",
       "11                 pmnb222                                         None   \n",
       "12                Dee03Vuh                                         None   \n",
       "13              Miss Seimi                                         None   \n",
       "14                 xnazzzx                                         None   \n",
       "15             flordeliz86                                         None   \n",
       "16          Metallicbarbie                                         None   \n",
       "17           JimmysJones17                                         None   \n",
       "18                    None                                         None   \n",
       "19              avigalante                        http://www.shaadi.com   \n",
       "20                    None                                         None   \n",
       "21                    None                                         None   \n",
       "22                    None                                         None   \n",
       "23           DEADMANINC812                                         None   \n",
       "24             kjobby12xxx                         http://www.K5ive.com   \n",
       "25        sexoholic blue u  http://five.flash-gear.com/npuz/puz.php?...   \n",
       "26                    None                                         None   \n",
       "27                    None                                         None   \n",
       "28          JRizzleATaglit      http://www.dcmetro.birthrightisrael.com   \n",
       "29          hanesmcfearson              http://homepage.mac.com/ptsmith   \n",
       "30              mattlobron                                         None   \n",
       "31                    None                    http://www.panavision.com   \n",
       "32                oseibenn                        http://www.tkenyu.org   \n",
       "33                    None                                         None   \n",
       "34            malibuebarby                                         None   \n",
       "35                    None                                         None   \n",
       "36                    None                                         None   \n",
       "37                    None                                         None   \n",
       "38   g NUPE the hAZEL EYED                                         None   \n",
       "39                    None                                         None   \n",
       "40                 sfc3nyc                                         None   \n",
       "41        iwassocoolbefore            http://superpooper.deviantart.com   \n",
       "42               mischa998                                         None   \n",
       "43              mhrousseau                                         None   \n",
       "44                    None     http://spaces.msn.com/members/whatwewant   \n",
       "45                 fb69169              http://www.myspace.com/uruguayo   \n",
       "46                    askk                                         None   \n",
       "47        TheCoolestMonkey             http://www.fotolog.net/bennigan/   \n",
       "48                    None                                         None   \n",
       "49                    None                       http://www.unicode.org   \n",
       "\n",
       "       PoliticalViews        Geography  \\\n",
       "0             Liberal             None   \n",
       "1        Conservative    New York,  NY   \n",
       "2            Moderate             None   \n",
       "3        Very Liberal             None   \n",
       "4                None    New York,  NY   \n",
       "5             Liberal    New York,  NY   \n",
       "6   Very Conservative             None   \n",
       "7        Conservative             None   \n",
       "8             Liberal             None   \n",
       "9                None             None   \n",
       "10               None             None   \n",
       "11       Conservative             None   \n",
       "12       Conservative             None   \n",
       "13               None             None   \n",
       "14       Very Liberal             None   \n",
       "15            Liberal             None   \n",
       "16           Moderate             None   \n",
       "17               None             None   \n",
       "18           Moderate    New York,  NY   \n",
       "19            Liberal             None   \n",
       "20               None             None   \n",
       "21               None             None   \n",
       "22               None             None   \n",
       "23           Moderate             None   \n",
       "24              Other             None   \n",
       "25       Very Liberal             None   \n",
       "26            Liberal             None   \n",
       "27            Liberal             None   \n",
       "28               None  Washington,  DC   \n",
       "29            Liberal             None   \n",
       "30               None             None   \n",
       "31               None             None   \n",
       "32       Conservative             None   \n",
       "33               None    New York,  NY   \n",
       "34       Conservative             None   \n",
       "35       Very Liberal             None   \n",
       "36            Liberal             None   \n",
       "37              Other             None   \n",
       "38           Moderate             None   \n",
       "39              Other             None   \n",
       "40            Liberal             None   \n",
       "41       Very Liberal             None   \n",
       "42               None             None   \n",
       "43        Libertarian             None   \n",
       "44          Apathetic             None   \n",
       "45            Liberal             None   \n",
       "46       Conservative             None   \n",
       "47              Other             None   \n",
       "48           Moderate    New York,  NY   \n",
       "49              Other             None   \n",
       "\n",
       "                                     HighSchool  \\\n",
       "0            Hamden Hall Country Day School '02   \n",
       "1                      Lawndale High School '01   \n",
       "2                       Boonton High School '03   \n",
       "3                      Guilford High School '03   \n",
       "4                The Pennington Prep School '00   \n",
       "5                   Albert Einstein High School   \n",
       "6                         Pine Crest School '03   \n",
       "7                                          None   \n",
       "8                Winter Springs High School '03   \n",
       "9   Convent of the Sacred Heart High School '00   \n",
       "10               Suffern Senior High School '04   \n",
       "11               Baldwin Senior High School '04   \n",
       "12           Farmingdale Senior High School '03   \n",
       "13                                      RIS '03   \n",
       "14         North Brunswick Township High School   \n",
       "15             Herbert H.Lehman High School '04   \n",
       "16               Lycee Francais De New York '03   \n",
       "17                  St. Francis High School '02   \n",
       "18               Lycee Francais De New York '00   \n",
       "19            Sanford H.Calhoun High School '03   \n",
       "20                                         None   \n",
       "21                           Branksome Hall '02   \n",
       "22                                         None   \n",
       "23                             Fordham Prep '04   \n",
       "24                               Royal High '01   \n",
       "25                                         None   \n",
       "26                American International School   \n",
       "27                                         None   \n",
       "28       Charles E. Smith Jewish Day School '00   \n",
       "29                                         None   \n",
       "30                                         None   \n",
       "31                                         None   \n",
       "32                         Hillview College '01   \n",
       "33                                         None   \n",
       "34                                         None   \n",
       "35                   St. John Villa Academy '05   \n",
       "36           Fashion Industires High School '04   \n",
       "37                             Fordham Prep '02   \n",
       "38                                         None   \n",
       "39                                         None   \n",
       "40              Desert Mountain High School '03   \n",
       "41                 Commonwealth High School '05   \n",
       "42                                         None   \n",
       "43                    Rabat American School '05   \n",
       "44                                  Gordonstoun   \n",
       "45                Uruguayan American School '05   \n",
       "46                  Byram Hills High School '05   \n",
       "47                Lander Valley High School '04   \n",
       "48                         St. Francis Prep '01   \n",
       "49                                         None   \n",
       "\n",
       "                                         HomeTown HomeState  \\\n",
       "0                                   new haven, CT      None   \n",
       "1                           New Orleans, LA 70126      None   \n",
       "2                               Boonton, NJ 07005      None   \n",
       "3                              Guilford, CT 06437      None   \n",
       "4                                            None      None   \n",
       "5                          District of Corruption      None   \n",
       "6                                            None      None   \n",
       "7                              Stamford, CT 06905      None   \n",
       "8                              New York, NY 10011      None   \n",
       "9                               San Francisco, CA      None   \n",
       "10                                           None      None   \n",
       "11                                     Lima, Peru      None   \n",
       "12                                           None        NY   \n",
       "13                                           None      None   \n",
       "14                                    Los Angeles      None   \n",
       "15                                Bronx, NY 10459      None   \n",
       "16                             New York, NY 10021      None   \n",
       "17                                  Los Altos, CA      None   \n",
       "18                        New York City, NY 10021      None   \n",
       "19                              Merrick, NY 11566      None   \n",
       "20                                           None      None   \n",
       "21                               Toronto, Ontario      None   \n",
       "22                                           None      None   \n",
       "23                                  The Bronx, NY      None   \n",
       "24                          Simi Valley, CA 93065      None   \n",
       "25                                           None      None   \n",
       "26                          Vienna, Austria, 3411      None   \n",
       "27                                         SWEDEN      None   \n",
       "28                                 Washington, DC      None   \n",
       "29                             New York, NY 10014      None   \n",
       "30                          Long Valley, NJ 07853      None   \n",
       "31                                           None      None   \n",
       "32                                           None      None   \n",
       "33                                           None      None   \n",
       "34                                           None      None   \n",
       "35                              Staten Island, NY      None   \n",
       "36                                           None      None   \n",
       "37                                Bronx, NY 10452      None   \n",
       "38                             new york, NY 10037      None   \n",
       "39                                           None      None   \n",
       "40   Born Walnut Creek,CA; grew up Scottsdale, AZ      None   \n",
       "41                                   San Juan, PR      None   \n",
       "42                              New York City, NY      None   \n",
       "43  amman, tunis, cairo, dhaka, fairfax, rabat...      None   \n",
       "44                                        Beijing      None   \n",
       "45                     Montevideo, Uruguay, 11500      None   \n",
       "46                               armonk, NY 10504      None   \n",
       "47                               Lander, WY 82520      None   \n",
       "48                             Elmhurst, NY 11373      None   \n",
       "49                                  Palo Alto, CA      None   \n",
       "\n",
       "                      Residence  \\\n",
       "0                  Alumni Hall    \n",
       "1                          None   \n",
       "2                          None   \n",
       "3                          None   \n",
       "4                          None   \n",
       "5                          None   \n",
       "6                          None   \n",
       "7                Carlyle Court    \n",
       "8         Thirteenth Street 3BS   \n",
       "9                          None   \n",
       "10                         None   \n",
       "11             Water Street 404   \n",
       "12          NYU at the Seaport    \n",
       "13                         None   \n",
       "14                         None   \n",
       "15                         None   \n",
       "16                         None   \n",
       "17                         None   \n",
       "18                        Paris   \n",
       "19           Carlyle Court C23G   \n",
       "20                         None   \n",
       "21            Water Street 2313   \n",
       "22                         None   \n",
       "23                         None   \n",
       "24                         None   \n",
       "25      Twentysixth Street 14F1   \n",
       "26             Greenwich Hotel    \n",
       "27                         None   \n",
       "28                         None   \n",
       "29                         None   \n",
       "30                         None   \n",
       "31                         None   \n",
       "32       Tau Kappa Epsilon TKE    \n",
       "33                         None   \n",
       "34                         None   \n",
       "35                 Hayden Hall    \n",
       "36         Alpha Sigma Tau AST    \n",
       "37  Phi Iota Alpha FIA ,DABRONX   \n",
       "38                         None   \n",
       "39                         None   \n",
       "40               Rubin Hall 905   \n",
       "41    Third Avenue North TS502B   \n",
       "42                         None   \n",
       "43          Florence COLLETTA11   \n",
       "44            Florence COLLETTA   \n",
       "45          Weinstein Hall 513A   \n",
       "46          Third Avenue North    \n",
       "47            Hayden Hall 1011A   \n",
       "48   Washington Square Village    \n",
       "49                         None   \n",
       "\n",
       "                                       CurrentAddress         CurrentTown  \\\n",
       "0                                                None                None   \n",
       "1                                                None                None   \n",
       "2                                                None                None   \n",
       "3                                                None  Brooklyn, NY 11222   \n",
       "4                                                None                None   \n",
       "5                        E. 5th & Avenue B, Manhattan                None   \n",
       "6                                                None                None   \n",
       "7                                                None                None   \n",
       "8                                             47 W 13                None   \n",
       "9                                                None                None   \n",
       "10                                               None                None   \n",
       "11                                               None                None   \n",
       "12                                               None                None   \n",
       "13                                               None                None   \n",
       "14                                               None                None   \n",
       "15                                               None                None   \n",
       "16                                               None                None   \n",
       "17                                               None                None   \n",
       "18                                               None                None   \n",
       "19  25 Union Square West, Apartment C2-3G New York...                None   \n",
       "20                                               None                None   \n",
       "21                                               None                None   \n",
       "22                                               None                None   \n",
       "23                                               None                None   \n",
       "24                                               None                None   \n",
       "25                                               None                None   \n",
       "26  Hauptstrasse 75 Klosterneuburg/Weidling, N.Γ–....                None   \n",
       "27                                               None  GΓ¶teborg, SWEDEN    \n",
       "28                                               None                None   \n",
       "29                                               None                None   \n",
       "30                                               None             NY, NY    \n",
       "31                                               None                None   \n",
       "32                                               None                None   \n",
       "33                                               None                None   \n",
       "34                                               None                None   \n",
       "35                                               None                None   \n",
       "36                                               None                None   \n",
       "37                                               None                None   \n",
       "38                                               None                None   \n",
       "39                                               None                None   \n",
       "40                                               None                None   \n",
       "41                                               None                None   \n",
       "42                                               None       NYC, NY 10012   \n",
       "43                                               None      Rabat, Morocco   \n",
       "44                                               None                None   \n",
       "45           5-11 University Place New York, NY 10003                None   \n",
       "46                                               None                 nyc   \n",
       "47                                               None                None   \n",
       "48                                               None                None   \n",
       "49                                               None                None   \n",
       "\n",
       "   CurrentState  \n",
       "0          None  \n",
       "1          None  \n",
       "2          None  \n",
       "3          None  \n",
       "4          None  \n",
       "5          None  \n",
       "6          None  \n",
       "7          None  \n",
       "8          None  \n",
       "9          None  \n",
       "10         None  \n",
       "11         None  \n",
       "12         None  \n",
       "13         None  \n",
       "14         None  \n",
       "15         None  \n",
       "16         None  \n",
       "17         None  \n",
       "18         None  \n",
       "19         None  \n",
       "20         None  \n",
       "21         None  \n",
       "22         None  \n",
       "23         None  \n",
       "24           NY  \n",
       "25         None  \n",
       "26         None  \n",
       "27         None  \n",
       "28         None  \n",
       "29         None  \n",
       "30         None  \n",
       "31         None  \n",
       "32         None  \n",
       "33         None  \n",
       "34         None  \n",
       "35         None  \n",
       "36         None  \n",
       "37         None  \n",
       "38         None  \n",
       "39         None  \n",
       "40         None  \n",
       "41         None  \n",
       "42         None  \n",
       "43         None  \n",
       "44         None  \n",
       "45         None  \n",
       "46         None  \n",
       "47         None  \n",
       "48         None  \n",
       "49         None  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%read_sql\n",
    "SELECT * \n",
    "FROM Profiles \n",
    "WHERE name NOT REGEXP '^[A-z \\-\\.]+$'"
   ]
  }
 ],
 "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}