Regular Expressions.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>edanmdm-nmah_1452166</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Part of Mold</td>\n",
       "      <td>nmah_1452166</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['mold, butter/cheese, part of']</td>\n",
       "      <td>1800 - 1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>edanmdm-nmah_1314014</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Model Truck from the “Futurama” Exhibition at ...</td>\n",
       "      <td>nmah_1314014</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Model Truck']</td>\n",
       "      <td>1939-1940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>edanmdm-nmah_209276</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dr. Drake's Glessco Cough &amp; Croup Remedy</td>\n",
       "      <td>nmah_209276</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Medicine', 'Drugs']</td>\n",
       "      <td>after 1948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>edanmdm-nmah_648464</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Probably parts for Spinning Frame T02338.000</td>\n",
       "      <td>nmah_648464</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Spinning Machine Parts, Batch of']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>edanmdm-nmah_1377036</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>button</td>\n",
       "      <td>nmah_1377036</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['button']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     id unitCode  \\\n",
       "0  edanmdm-nmah_1452166     NMAH   \n",
       "1  edanmdm-nmah_1314014     NMAH   \n",
       "2   edanmdm-nmah_209276     NMAH   \n",
       "3   edanmdm-nmah_648464     NMAH   \n",
       "4  edanmdm-nmah_1377036     NMAH   \n",
       "\n",
       "                                               title     record_ID  \\\n",
       "0                                       Part of Mold  nmah_1452166   \n",
       "1  Model Truck from the “Futurama” Exhibition at ...  nmah_1314014   \n",
       "2           Dr. Drake's Glessco Cough & Croup Remedy   nmah_209276   \n",
       "3       Probably parts for Spinning Frame T02338.000   nmah_648464   \n",
       "4                                             button  nmah_1377036   \n",
       "\n",
       "      metadata_usage                          data_source  \\\n",
       "0  {'access': 'CC0'}  National Museum of American History   \n",
       "1  {'access': 'CC0'}  National Museum of American History   \n",
       "2  {'access': 'CC0'}  National Museum of American History   \n",
       "3  {'access': 'CC0'}  National Museum of American History   \n",
       "4  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                            object_type         Date  \n",
       "0      ['mold, butter/cheese, part of']  1800 - 1900  \n",
       "1                       ['Model Truck']    1939-1940  \n",
       "2                 ['Medicine', 'Drugs']   after 1948  \n",
       "3  ['Spinning Machine Parts, Batch of']          NaN  \n",
       "4                            ['button']          NaN  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nmah_df = pd.read_csv('nmah_df.tsv', sep='\\t')\n",
    "nmah_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        True\n",
       "1        True\n",
       "2       False\n",
       "3       False\n",
       "4       False\n",
       "        ...  \n",
       "5194     True\n",
       "5195     True\n",
       "5196     True\n",
       "5197     True\n",
       "5198     True\n",
       "Name: Date, Length: 5199, dtype: bool"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pattern = r'^\\d'\n",
    "nmah_df['Date'].str.match(pattern).fillna(False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>edanmdm-nmah_1452166</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Part of Mold</td>\n",
       "      <td>nmah_1452166</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['mold, butter/cheese, part of']</td>\n",
       "      <td>1800 - 1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>edanmdm-nmah_1314014</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Model Truck from the “Futurama” Exhibition at ...</td>\n",
       "      <td>nmah_1314014</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Model Truck']</td>\n",
       "      <td>1939-1940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>edanmdm-nmah_749429</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Engraved woodblock of an \"Iroquois mask\"</td>\n",
       "      <td>nmah_749429</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Wood Engraving', 'block']</td>\n",
       "      <td>1884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>edanmdm-nmah_1342831</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>needle holder; surgical set</td>\n",
       "      <td>nmah_1342831</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Needle cases', 'surgical set']</td>\n",
       "      <td>1871-1874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>edanmdm-nmah_1008489</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>US Model 1808/1809 Contract Flintlock Musket</td>\n",
       "      <td>nmah_1008489</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Muskets', 'musket, flintlock']</td>\n",
       "      <td>1809</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5194</th>\n",
       "      <td>edanmdm-nmah_875355</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>cap</td>\n",
       "      <td>nmah_875355</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Caps (headgear)']</td>\n",
       "      <td>1810-1820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5195</th>\n",
       "      <td>edanmdm-nmah_1027512</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>[untitled]</td>\n",
       "      <td>nmah_1027512</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Carte-de-Visite']</td>\n",
       "      <td>1860's-1870's</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5196</th>\n",
       "      <td>edanmdm-nmah_690136</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Star Adding Machine</td>\n",
       "      <td>nmah_690136</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['adding machine']</td>\n",
       "      <td>1925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5197</th>\n",
       "      <td>edanmdm-nmah_1084829</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>20 Dollars, United States, 1885</td>\n",
       "      <td>nmah_1084829</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>1885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5198</th>\n",
       "      <td>edanmdm-nmah_1084834</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>20 Dollars, United States, 1885</td>\n",
       "      <td>nmah_1084834</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>1885</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1432 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "0     edanmdm-nmah_1452166     NMAH   \n",
       "1     edanmdm-nmah_1314014     NMAH   \n",
       "8      edanmdm-nmah_749429     NMAH   \n",
       "10    edanmdm-nmah_1342831     NMAH   \n",
       "11    edanmdm-nmah_1008489     NMAH   \n",
       "...                    ...      ...   \n",
       "5194   edanmdm-nmah_875355     NMAH   \n",
       "5195  edanmdm-nmah_1027512     NMAH   \n",
       "5196   edanmdm-nmah_690136     NMAH   \n",
       "5197  edanmdm-nmah_1084829     NMAH   \n",
       "5198  edanmdm-nmah_1084834     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "0                                          Part of Mold  nmah_1452166   \n",
       "1     Model Truck from the “Futurama” Exhibition at ...  nmah_1314014   \n",
       "8              Engraved woodblock of an \"Iroquois mask\"   nmah_749429   \n",
       "10                          needle holder; surgical set  nmah_1342831   \n",
       "11         US Model 1808/1809 Contract Flintlock Musket  nmah_1008489   \n",
       "...                                                 ...           ...   \n",
       "5194                                                cap   nmah_875355   \n",
       "5195                                         [untitled]  nmah_1027512   \n",
       "5196                                Star Adding Machine   nmah_690136   \n",
       "5197                    20 Dollars, United States, 1885  nmah_1084829   \n",
       "5198                    20 Dollars, United States, 1885  nmah_1084834   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "0     {'access': 'CC0'}  National Museum of American History   \n",
       "1     {'access': 'CC0'}  National Museum of American History   \n",
       "8     {'access': 'CC0'}  National Museum of American History   \n",
       "10    {'access': 'CC0'}  National Museum of American History   \n",
       "11    {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5194  {'access': 'CC0'}  National Museum of American History   \n",
       "5195  {'access': 'CC0'}  National Museum of American History   \n",
       "5196  {'access': 'CC0'}  National Museum of American History   \n",
       "5197  {'access': 'CC0'}  National Museum of American History   \n",
       "5198  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                           object_type           Date  \n",
       "0     ['mold, butter/cheese, part of']    1800 - 1900  \n",
       "1                      ['Model Truck']      1939-1940  \n",
       "8          ['Wood Engraving', 'block']           1884  \n",
       "10    ['Needle cases', 'surgical set']      1871-1874  \n",
       "11    ['Muskets', 'musket, flintlock']           1809  \n",
       "...                                ...            ...  \n",
       "5194               ['Caps (headgear)']      1810-1820  \n",
       "5195               ['Carte-de-Visite']  1860's-1870's  \n",
       "5196                ['adding machine']           1925  \n",
       "5197                 ['Coins (money)']           1885  \n",
       "5198                 ['Coins (money)']           1885  \n",
       "\n",
       "[1432 rows x 8 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nmah_df[nmah_df['Date'].str.match(pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>edanmdm-nmah_749429</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Engraved woodblock of an \"Iroquois mask\"</td>\n",
       "      <td>nmah_749429</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Wood Engraving', 'block']</td>\n",
       "      <td>1884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>edanmdm-nmah_1008489</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>US Model 1808/1809 Contract Flintlock Musket</td>\n",
       "      <td>nmah_1008489</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Muskets', 'musket, flintlock']</td>\n",
       "      <td>1809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>edanmdm-nmah_1105413</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>1 Dollar, Proof, United States, 1983</td>\n",
       "      <td>nmah_1105413</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>1983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>edanmdm-nmah_1388706</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>5,000 Dollars, Gold Certificate, United States...</td>\n",
       "      <td>nmah_1388706</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['note']</td>\n",
       "      <td>1928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>edanmdm-nmah_1020386</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Trojan Horse</td>\n",
       "      <td>nmah_1020386</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Prints']</td>\n",
       "      <td>1773</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5192</th>\n",
       "      <td>edanmdm-nmah_1198585</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Try-Vue picture with depth film \"New YorkWorld...</td>\n",
       "      <td>nmah_1198585</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['movieview film']</td>\n",
       "      <td>1939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5193</th>\n",
       "      <td>edanmdm-nmah_1198587</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Try-Vue picture with depth film \"Golden Gate E...</td>\n",
       "      <td>nmah_1198587</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['movieview film']</td>\n",
       "      <td>1939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5196</th>\n",
       "      <td>edanmdm-nmah_690136</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Star Adding Machine</td>\n",
       "      <td>nmah_690136</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['adding machine']</td>\n",
       "      <td>1925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5197</th>\n",
       "      <td>edanmdm-nmah_1084829</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>20 Dollars, United States, 1885</td>\n",
       "      <td>nmah_1084829</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>1885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5198</th>\n",
       "      <td>edanmdm-nmah_1084834</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>20 Dollars, United States, 1885</td>\n",
       "      <td>nmah_1084834</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>1885</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>972 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "8      edanmdm-nmah_749429     NMAH   \n",
       "11    edanmdm-nmah_1008489     NMAH   \n",
       "17    edanmdm-nmah_1105413     NMAH   \n",
       "18    edanmdm-nmah_1388706     NMAH   \n",
       "19    edanmdm-nmah_1020386     NMAH   \n",
       "...                    ...      ...   \n",
       "5192  edanmdm-nmah_1198585     NMAH   \n",
       "5193  edanmdm-nmah_1198587     NMAH   \n",
       "5196   edanmdm-nmah_690136     NMAH   \n",
       "5197  edanmdm-nmah_1084829     NMAH   \n",
       "5198  edanmdm-nmah_1084834     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "8              Engraved woodblock of an \"Iroquois mask\"   nmah_749429   \n",
       "11         US Model 1808/1809 Contract Flintlock Musket  nmah_1008489   \n",
       "17                 1 Dollar, Proof, United States, 1983  nmah_1105413   \n",
       "18    5,000 Dollars, Gold Certificate, United States...  nmah_1388706   \n",
       "19                                         Trojan Horse  nmah_1020386   \n",
       "...                                                 ...           ...   \n",
       "5192  Try-Vue picture with depth film \"New YorkWorld...  nmah_1198585   \n",
       "5193  Try-Vue picture with depth film \"Golden Gate E...  nmah_1198587   \n",
       "5196                                Star Adding Machine   nmah_690136   \n",
       "5197                    20 Dollars, United States, 1885  nmah_1084829   \n",
       "5198                    20 Dollars, United States, 1885  nmah_1084834   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "8     {'access': 'CC0'}  National Museum of American History   \n",
       "11    {'access': 'CC0'}  National Museum of American History   \n",
       "17    {'access': 'CC0'}  National Museum of American History   \n",
       "18    {'access': 'CC0'}  National Museum of American History   \n",
       "19    {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5192  {'access': 'CC0'}  National Museum of American History   \n",
       "5193  {'access': 'CC0'}  National Museum of American History   \n",
       "5196  {'access': 'CC0'}  National Museum of American History   \n",
       "5197  {'access': 'CC0'}  National Museum of American History   \n",
       "5198  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                           object_type  Date  \n",
       "8          ['Wood Engraving', 'block']  1884  \n",
       "11    ['Muskets', 'musket, flintlock']  1809  \n",
       "17                   ['Coins (money)']  1983  \n",
       "18                            ['note']  1928  \n",
       "19                          ['Prints']  1773  \n",
       "...                                ...   ...  \n",
       "5192                ['movieview film']  1939  \n",
       "5193                ['movieview film']  1939  \n",
       "5196                ['adding machine']  1925  \n",
       "5197                 ['Coins (money)']  1885  \n",
       "5198                 ['Coins (money)']  1885  \n",
       "\n",
       "[972 rows x 8 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pattern = r'^\\d{4}$'\n",
    "nmah_df[nmah_df['Date'].str.match(pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>edanmdm-nmah_648464</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Probably parts for Spinning Frame T02338.000</td>\n",
       "      <td>nmah_648464</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Spinning Machine Parts, Batch of']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>edanmdm-nmah_1377036</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>button</td>\n",
       "      <td>nmah_1377036</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['button']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>edanmdm-nmah_1379344</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>button</td>\n",
       "      <td>nmah_1379344</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['button']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>edanmdm-nmah_1156491</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Throttle Valve</td>\n",
       "      <td>nmah_1156491</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Throttle Valve']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>edanmdm-nmah_680096</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>plate holder, ice cream</td>\n",
       "      <td>nmah_680096</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Plate Holder, Ice Cream']</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5183</th>\n",
       "      <td>edanmdm-nmah_1212214</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1212214</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5184</th>\n",
       "      <td>edanmdm-nmah_1213139</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1213139</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5185</th>\n",
       "      <td>edanmdm-nmah_1186573</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Davy</td>\n",
       "      <td>nmah_1186573</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Portraits']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5186</th>\n",
       "      <td>edanmdm-nmah_1188678</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>C. E. K. Mees</td>\n",
       "      <td>nmah_1188678</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Portraits']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5189</th>\n",
       "      <td>edanmdm-nmah_1146306</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>case, eyeglasses</td>\n",
       "      <td>nmah_1146306</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Case, Eyeglasses']</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3508 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "3      edanmdm-nmah_648464     NMAH   \n",
       "4     edanmdm-nmah_1377036     NMAH   \n",
       "5     edanmdm-nmah_1379344     NMAH   \n",
       "6     edanmdm-nmah_1156491     NMAH   \n",
       "12     edanmdm-nmah_680096     NMAH   \n",
       "...                    ...      ...   \n",
       "5183  edanmdm-nmah_1212214     NMAH   \n",
       "5184  edanmdm-nmah_1213139     NMAH   \n",
       "5185  edanmdm-nmah_1186573     NMAH   \n",
       "5186  edanmdm-nmah_1188678     NMAH   \n",
       "5189  edanmdm-nmah_1146306     NMAH   \n",
       "\n",
       "                                             title     record_ID  \\\n",
       "3     Probably parts for Spinning Frame T02338.000   nmah_648464   \n",
       "4                                           button  nmah_1377036   \n",
       "5                                           button  nmah_1379344   \n",
       "6                                   Throttle Valve  nmah_1156491   \n",
       "12                         plate holder, ice cream   nmah_680096   \n",
       "...                                            ...           ...   \n",
       "5183                          glass plate negative  nmah_1212214   \n",
       "5184                          glass plate negative  nmah_1213139   \n",
       "5185                                          Davy  nmah_1186573   \n",
       "5186                                 C. E. K. Mees  nmah_1188678   \n",
       "5189                              case, eyeglasses  nmah_1146306   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "3     {'access': 'CC0'}  National Museum of American History   \n",
       "4     {'access': 'CC0'}  National Museum of American History   \n",
       "5     {'access': 'CC0'}  National Museum of American History   \n",
       "6     {'access': 'CC0'}  National Museum of American History   \n",
       "12    {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5183  {'access': 'CC0'}  National Museum of American History   \n",
       "5184  {'access': 'CC0'}  National Museum of American History   \n",
       "5185  {'access': 'CC0'}  National Museum of American History   \n",
       "5186  {'access': 'CC0'}  National Museum of American History   \n",
       "5189  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                               object_type Date  \n",
       "3     ['Spinning Machine Parts, Batch of']  NaN  \n",
       "4                               ['button']  NaN  \n",
       "5                               ['button']  NaN  \n",
       "6                       ['Throttle Valve']  NaN  \n",
       "12             ['Plate Holder, Ice Cream']  NaN  \n",
       "...                                    ...  ...  \n",
       "5183                       ['Photographs']  NaN  \n",
       "5184                       ['Photographs']  NaN  \n",
       "5185                         ['Portraits']  NaN  \n",
       "5186                         ['Portraits']  NaN  \n",
       "5189                  ['Case, Eyeglasses']  NaN  \n",
       "\n",
       "[3508 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nmah_df[pd.isnull(nmah_df['Date'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>edanmdm-nmah_1452166</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Part of Mold</td>\n",
       "      <td>nmah_1452166</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['mold, butter/cheese, part of']</td>\n",
       "      <td>1800 - 1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>edanmdm-nmah_1314014</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Model Truck from the “Futurama” Exhibition at ...</td>\n",
       "      <td>nmah_1314014</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Model Truck']</td>\n",
       "      <td>1939-1940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>edanmdm-nmah_209276</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dr. Drake's Glessco Cough &amp; Croup Remedy</td>\n",
       "      <td>nmah_209276</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Medicine', 'Drugs']</td>\n",
       "      <td>after 1948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>edanmdm-nmah_709664</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Plantronics \"VuSet\" Visual Data Terminal</td>\n",
       "      <td>nmah_709664</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Data Terminal']</td>\n",
       "      <td>Santa Cruz, California</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>edanmdm-nmah_1817313</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Reciprocating Armature Engine</td>\n",
       "      <td>nmah_1817313</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Reciprocating Armature Engine', 'reciprocati...</td>\n",
       "      <td>mid-nineteenth century</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5173</th>\n",
       "      <td>edanmdm-nmah_1316896</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>fabric fragment</td>\n",
       "      <td>nmah_1316896</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['fabric fragment']</td>\n",
       "      <td>1910-1912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5188</th>\n",
       "      <td>edanmdm-nmah_1200005</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Spring Blossoms</td>\n",
       "      <td>nmah_1200005</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>ca 1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5191</th>\n",
       "      <td>edanmdm-nmah_996873</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>bag</td>\n",
       "      <td>nmah_996873</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Bags (containers)']</td>\n",
       "      <td>1960-1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5194</th>\n",
       "      <td>edanmdm-nmah_875355</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>cap</td>\n",
       "      <td>nmah_875355</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Caps (headgear)']</td>\n",
       "      <td>1810-1820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5195</th>\n",
       "      <td>edanmdm-nmah_1027512</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>[untitled]</td>\n",
       "      <td>nmah_1027512</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Carte-de-Visite']</td>\n",
       "      <td>1860's-1870's</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>719 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "0     edanmdm-nmah_1452166     NMAH   \n",
       "1     edanmdm-nmah_1314014     NMAH   \n",
       "2      edanmdm-nmah_209276     NMAH   \n",
       "7      edanmdm-nmah_709664     NMAH   \n",
       "9     edanmdm-nmah_1817313     NMAH   \n",
       "...                    ...      ...   \n",
       "5173  edanmdm-nmah_1316896     NMAH   \n",
       "5188  edanmdm-nmah_1200005     NMAH   \n",
       "5191   edanmdm-nmah_996873     NMAH   \n",
       "5194   edanmdm-nmah_875355     NMAH   \n",
       "5195  edanmdm-nmah_1027512     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "0                                          Part of Mold  nmah_1452166   \n",
       "1     Model Truck from the “Futurama” Exhibition at ...  nmah_1314014   \n",
       "2              Dr. Drake's Glessco Cough & Croup Remedy   nmah_209276   \n",
       "7              Plantronics \"VuSet\" Visual Data Terminal   nmah_709664   \n",
       "9                         Reciprocating Armature Engine  nmah_1817313   \n",
       "...                                                 ...           ...   \n",
       "5173                                    fabric fragment  nmah_1316896   \n",
       "5188                                    Spring Blossoms  nmah_1200005   \n",
       "5191                                                bag   nmah_996873   \n",
       "5194                                                cap   nmah_875355   \n",
       "5195                                         [untitled]  nmah_1027512   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "0     {'access': 'CC0'}  National Museum of American History   \n",
       "1     {'access': 'CC0'}  National Museum of American History   \n",
       "2     {'access': 'CC0'}  National Museum of American History   \n",
       "7     {'access': 'CC0'}  National Museum of American History   \n",
       "9     {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5173  {'access': 'CC0'}  National Museum of American History   \n",
       "5188  {'access': 'CC0'}  National Museum of American History   \n",
       "5191  {'access': 'CC0'}  National Museum of American History   \n",
       "5194  {'access': 'CC0'}  National Museum of American History   \n",
       "5195  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                            object_type  \\\n",
       "0                      ['mold, butter/cheese, part of']   \n",
       "1                                       ['Model Truck']   \n",
       "2                                 ['Medicine', 'Drugs']   \n",
       "7                                     ['Data Terminal']   \n",
       "9     ['Reciprocating Armature Engine', 'reciprocati...   \n",
       "...                                                 ...   \n",
       "5173                                ['fabric fragment']   \n",
       "5188                                    ['Photographs']   \n",
       "5191                              ['Bags (containers)']   \n",
       "5194                                ['Caps (headgear)']   \n",
       "5195                                ['Carte-de-Visite']   \n",
       "\n",
       "                        Date  \n",
       "0                1800 - 1900  \n",
       "1                  1939-1940  \n",
       "2                 after 1948  \n",
       "7     Santa Cruz, California  \n",
       "9     mid-nineteenth century  \n",
       "...                      ...  \n",
       "5173               1910-1912  \n",
       "5188                 ca 1900  \n",
       "5191               1960-1969  \n",
       "5194               1810-1820  \n",
       "5195           1860's-1870's  \n",
       "\n",
       "[719 rows x 8 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "four_number_pattern = r'^\\d{4}$'\n",
    "four_number = nmah_df['Date'].str.match(four_number_pattern).fillna(False)\n",
    "null_filter = pd.isnull(nmah_df['Date'])\n",
    "nmah_df[~(four_number | null_filter)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>edanmdm-nmah_1452166</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Part of Mold</td>\n",
       "      <td>nmah_1452166</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['mold, butter/cheese, part of']</td>\n",
       "      <td>1800 - 1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>edanmdm-nmah_1314014</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Model Truck from the “Futurama” Exhibition at ...</td>\n",
       "      <td>nmah_1314014</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Model Truck']</td>\n",
       "      <td>1939-1940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>edanmdm-nmah_1342831</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>needle holder; surgical set</td>\n",
       "      <td>nmah_1342831</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Needle cases', 'surgical set']</td>\n",
       "      <td>1871-1874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>edanmdm-nmah_875420</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>dress, 2-piece</td>\n",
       "      <td>nmah_875420</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Entire Body', 'Dresses (garments)', 'Girl']</td>\n",
       "      <td>1863-1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>edanmdm-nmah_1314144</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>box</td>\n",
       "      <td>nmah_1314144</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Boxes (containers)']</td>\n",
       "      <td>1939-1940</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5137</th>\n",
       "      <td>edanmdm-nmah_1802646</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Flute Case</td>\n",
       "      <td>nmah_1802646</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Cases (containers)']</td>\n",
       "      <td>1888-1901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5157</th>\n",
       "      <td>edanmdm-nmah_1996521</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1996521</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1865-1908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5173</th>\n",
       "      <td>edanmdm-nmah_1316896</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>fabric fragment</td>\n",
       "      <td>nmah_1316896</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['fabric fragment']</td>\n",
       "      <td>1910-1912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5191</th>\n",
       "      <td>edanmdm-nmah_996873</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>bag</td>\n",
       "      <td>nmah_996873</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Bags (containers)']</td>\n",
       "      <td>1960-1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5194</th>\n",
       "      <td>edanmdm-nmah_875355</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>cap</td>\n",
       "      <td>nmah_875355</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Caps (headgear)']</td>\n",
       "      <td>1810-1820</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>173 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "0     edanmdm-nmah_1452166     NMAH   \n",
       "1     edanmdm-nmah_1314014     NMAH   \n",
       "10    edanmdm-nmah_1342831     NMAH   \n",
       "23     edanmdm-nmah_875420     NMAH   \n",
       "25    edanmdm-nmah_1314144     NMAH   \n",
       "...                    ...      ...   \n",
       "5137  edanmdm-nmah_1802646     NMAH   \n",
       "5157  edanmdm-nmah_1996521     NMAH   \n",
       "5173  edanmdm-nmah_1316896     NMAH   \n",
       "5191   edanmdm-nmah_996873     NMAH   \n",
       "5194   edanmdm-nmah_875355     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "0                                          Part of Mold  nmah_1452166   \n",
       "1     Model Truck from the “Futurama” Exhibition at ...  nmah_1314014   \n",
       "10                          needle holder; surgical set  nmah_1342831   \n",
       "23                                       dress, 2-piece   nmah_875420   \n",
       "25                                                  box  nmah_1314144   \n",
       "...                                                 ...           ...   \n",
       "5137                                         Flute Case  nmah_1802646   \n",
       "5157                               glass plate negative  nmah_1996521   \n",
       "5173                                    fabric fragment  nmah_1316896   \n",
       "5191                                                bag   nmah_996873   \n",
       "5194                                                cap   nmah_875355   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "0     {'access': 'CC0'}  National Museum of American History   \n",
       "1     {'access': 'CC0'}  National Museum of American History   \n",
       "10    {'access': 'CC0'}  National Museum of American History   \n",
       "23    {'access': 'CC0'}  National Museum of American History   \n",
       "25    {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5137  {'access': 'CC0'}  National Museum of American History   \n",
       "5157  {'access': 'CC0'}  National Museum of American History   \n",
       "5173  {'access': 'CC0'}  National Museum of American History   \n",
       "5191  {'access': 'CC0'}  National Museum of American History   \n",
       "5194  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                        object_type         Date  \n",
       "0                  ['mold, butter/cheese, part of']  1800 - 1900  \n",
       "1                                   ['Model Truck']    1939-1940  \n",
       "10                 ['Needle cases', 'surgical set']    1871-1874  \n",
       "23    ['Entire Body', 'Dresses (garments)', 'Girl']    1863-1865  \n",
       "25                           ['Boxes (containers)']    1939-1940  \n",
       "...                                             ...          ...  \n",
       "5137                         ['Cases (containers)']    1888-1901  \n",
       "5157                                ['Photographs']    1865-1908  \n",
       "5173                            ['fabric fragment']    1910-1912  \n",
       "5191                          ['Bags (containers)']    1960-1969  \n",
       "5194                            ['Caps (headgear)']    1810-1820  \n",
       "\n",
       "[173 rows x 8 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "date_range_pattern = r'^\\d{4}\\s*-\\s*\\d{4}$'\n",
    "nmah_df[nmah_df['Date'].str.match(date_range_pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>edanmdm-nmah_209276</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dr. Drake's Glessco Cough &amp; Croup Remedy</td>\n",
       "      <td>nmah_209276</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Medicine', 'Drugs']</td>\n",
       "      <td>after 1948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>edanmdm-nmah_709664</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Plantronics \"VuSet\" Visual Data Terminal</td>\n",
       "      <td>nmah_709664</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Data Terminal']</td>\n",
       "      <td>Santa Cruz, California</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>edanmdm-nmah_1817313</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Reciprocating Armature Engine</td>\n",
       "      <td>nmah_1817313</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Reciprocating Armature Engine', 'reciprocati...</td>\n",
       "      <td>mid-nineteenth century</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>edanmdm-nmah_1160789</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>fragments, pipe</td>\n",
       "      <td>nmah_1160789</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['fragments, pipe', 'Fragment, Pipe']</td>\n",
       "      <td>19th century</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>edanmdm-nmah_750413</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Bird's-eye view of the Terrace Canons</td>\n",
       "      <td>nmah_750413</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Block', 'block, engraved wood']</td>\n",
       "      <td>ca 1875</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5163</th>\n",
       "      <td>edanmdm-nmah_1255565</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>California World's Fair on San Francisco Bay</td>\n",
       "      <td>nmah_1255565</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Postcard Container']</td>\n",
       "      <td>1939-40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5166</th>\n",
       "      <td>edanmdm-nmah_1213082</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Rev. Jimmy Rodgers Snow</td>\n",
       "      <td>nmah_1213082</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1974 (negative), 2003 (print)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5167</th>\n",
       "      <td>edanmdm-nmah_1316465</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Guy Picciotto of Fugazi w/his 1976 Chrysler Co...</td>\n",
       "      <td>nmah_1316465</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Postcard, real photo']</td>\n",
       "      <td>c 1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5188</th>\n",
       "      <td>edanmdm-nmah_1200005</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Spring Blossoms</td>\n",
       "      <td>nmah_1200005</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>ca 1900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5195</th>\n",
       "      <td>edanmdm-nmah_1027512</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>[untitled]</td>\n",
       "      <td>nmah_1027512</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Carte-de-Visite']</td>\n",
       "      <td>1860's-1870's</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>546 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "2      edanmdm-nmah_209276     NMAH   \n",
       "7      edanmdm-nmah_709664     NMAH   \n",
       "9     edanmdm-nmah_1817313     NMAH   \n",
       "38    edanmdm-nmah_1160789     NMAH   \n",
       "56     edanmdm-nmah_750413     NMAH   \n",
       "...                    ...      ...   \n",
       "5163  edanmdm-nmah_1255565     NMAH   \n",
       "5166  edanmdm-nmah_1213082     NMAH   \n",
       "5167  edanmdm-nmah_1316465     NMAH   \n",
       "5188  edanmdm-nmah_1200005     NMAH   \n",
       "5195  edanmdm-nmah_1027512     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "2              Dr. Drake's Glessco Cough & Croup Remedy   nmah_209276   \n",
       "7              Plantronics \"VuSet\" Visual Data Terminal   nmah_709664   \n",
       "9                         Reciprocating Armature Engine  nmah_1817313   \n",
       "38                                      fragments, pipe  nmah_1160789   \n",
       "56                Bird's-eye view of the Terrace Canons   nmah_750413   \n",
       "...                                                 ...           ...   \n",
       "5163       California World's Fair on San Francisco Bay  nmah_1255565   \n",
       "5166                            Rev. Jimmy Rodgers Snow  nmah_1213082   \n",
       "5167  Guy Picciotto of Fugazi w/his 1976 Chrysler Co...  nmah_1316465   \n",
       "5188                                    Spring Blossoms  nmah_1200005   \n",
       "5195                                         [untitled]  nmah_1027512   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "2     {'access': 'CC0'}  National Museum of American History   \n",
       "7     {'access': 'CC0'}  National Museum of American History   \n",
       "9     {'access': 'CC0'}  National Museum of American History   \n",
       "38    {'access': 'CC0'}  National Museum of American History   \n",
       "56    {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5163  {'access': 'CC0'}  National Museum of American History   \n",
       "5166  {'access': 'CC0'}  National Museum of American History   \n",
       "5167  {'access': 'CC0'}  National Museum of American History   \n",
       "5188  {'access': 'CC0'}  National Museum of American History   \n",
       "5195  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                            object_type  \\\n",
       "2                                 ['Medicine', 'Drugs']   \n",
       "7                                     ['Data Terminal']   \n",
       "9     ['Reciprocating Armature Engine', 'reciprocati...   \n",
       "38                ['fragments, pipe', 'Fragment, Pipe']   \n",
       "56                    ['Block', 'block, engraved wood']   \n",
       "...                                                 ...   \n",
       "5163                             ['Postcard Container']   \n",
       "5166                                    ['Photographs']   \n",
       "5167                           ['Postcard, real photo']   \n",
       "5188                                    ['Photographs']   \n",
       "5195                                ['Carte-de-Visite']   \n",
       "\n",
       "                               Date  \n",
       "2                        after 1948  \n",
       "7            Santa Cruz, California  \n",
       "9            mid-nineteenth century  \n",
       "38                     19th century  \n",
       "56                          ca 1875  \n",
       "...                             ...  \n",
       "5163                        1939-40  \n",
       "5166  1974 (negative), 2003 (print)  \n",
       "5167                         c 1998  \n",
       "5188                        ca 1900  \n",
       "5195                  1860's-1870's  \n",
       "\n",
       "[546 rows x 8 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "date_range_filter = nmah_df['Date'].str.match(date_range_pattern).fillna(False)\n",
    "nmah_df[~(four_number | null_filter | date_range_filter)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>edanmdm-nmah_209276</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dr. Drake's Glessco Cough &amp; Croup Remedy</td>\n",
       "      <td>nmah_209276</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Medicine', 'Drugs']</td>\n",
       "      <td>after 1948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>edanmdm-nmah_1829105</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dog pulling milk cart</td>\n",
       "      <td>nmah_1829105</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['real photo postcard']</td>\n",
       "      <td>after 1907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>edanmdm-nmah_1299767</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Use Dr. Tobias' Venetian Liniment, Warranted t...</td>\n",
       "      <td>nmah_1299767</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Sign, Promotional', 'advertising device, sign']</td>\n",
       "      <td>after 1850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>edanmdm-nmah_313555</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Pipe Case</td>\n",
       "      <td>nmah_313555</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Case, Pipe', 'Case, Pipe; Smoking Equipment'...</td>\n",
       "      <td>after 1880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1823</th>\n",
       "      <td>edanmdm-nmah_1889952</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Trinity, M.E. Church, Kentland, Ind.</td>\n",
       "      <td>nmah_1889952</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['real photo postcard']</td>\n",
       "      <td>after 1907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1901</th>\n",
       "      <td>edanmdm-nmah_1888952</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>portrait of man in oval frame</td>\n",
       "      <td>nmah_1888952</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['real photo postcard']</td>\n",
       "      <td>after 1907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1902</th>\n",
       "      <td>edanmdm-nmah_1891171</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>large group portrait at construction site</td>\n",
       "      <td>nmah_1891171</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['real photo postcard']</td>\n",
       "      <td>after 1907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2134</th>\n",
       "      <td>edanmdm-nmah_323929</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dessert Knife</td>\n",
       "      <td>nmah_323929</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Knife, Dessert; Cutlery', 'knife, dessert', ...</td>\n",
       "      <td>after 1855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4827</th>\n",
       "      <td>edanmdm-nmah_1124304</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Carven Ma Griffe Eau De Toilette Spray</td>\n",
       "      <td>nmah_1124304</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['fragrance', 'Toilet Water; Toilet Water, Bot...</td>\n",
       "      <td>after 1946</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "2      edanmdm-nmah_209276     NMAH   \n",
       "116   edanmdm-nmah_1829105     NMAH   \n",
       "158   edanmdm-nmah_1299767     NMAH   \n",
       "922    edanmdm-nmah_313555     NMAH   \n",
       "1823  edanmdm-nmah_1889952     NMAH   \n",
       "1901  edanmdm-nmah_1888952     NMAH   \n",
       "1902  edanmdm-nmah_1891171     NMAH   \n",
       "2134   edanmdm-nmah_323929     NMAH   \n",
       "4827  edanmdm-nmah_1124304     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "2              Dr. Drake's Glessco Cough & Croup Remedy   nmah_209276   \n",
       "116                               Dog pulling milk cart  nmah_1829105   \n",
       "158   Use Dr. Tobias' Venetian Liniment, Warranted t...  nmah_1299767   \n",
       "922                                           Pipe Case   nmah_313555   \n",
       "1823               Trinity, M.E. Church, Kentland, Ind.  nmah_1889952   \n",
       "1901                      portrait of man in oval frame  nmah_1888952   \n",
       "1902          large group portrait at construction site  nmah_1891171   \n",
       "2134                                      Dessert Knife   nmah_323929   \n",
       "4827             Carven Ma Griffe Eau De Toilette Spray  nmah_1124304   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "2     {'access': 'CC0'}  National Museum of American History   \n",
       "116   {'access': 'CC0'}  National Museum of American History   \n",
       "158   {'access': 'CC0'}  National Museum of American History   \n",
       "922   {'access': 'CC0'}  National Museum of American History   \n",
       "1823  {'access': 'CC0'}  National Museum of American History   \n",
       "1901  {'access': 'CC0'}  National Museum of American History   \n",
       "1902  {'access': 'CC0'}  National Museum of American History   \n",
       "2134  {'access': 'CC0'}  National Museum of American History   \n",
       "4827  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                            object_type        Date  \n",
       "2                                 ['Medicine', 'Drugs']  after 1948  \n",
       "116                             ['real photo postcard']  after 1907  \n",
       "158   ['Sign, Promotional', 'advertising device, sign']  after 1850  \n",
       "922   ['Case, Pipe', 'Case, Pipe; Smoking Equipment'...  after 1880  \n",
       "1823                            ['real photo postcard']  after 1907  \n",
       "1901                            ['real photo postcard']  after 1907  \n",
       "1902                            ['real photo postcard']  after 1907  \n",
       "2134  ['Knife, Dessert; Cutlery', 'knife, dessert', ...  after 1855  \n",
       "4827  ['fragrance', 'Toilet Water; Toilet Water, Bot...  after 1946  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "after_pattern = r'^[Aa]fter\\s\\d{4}$'\n",
    "nmah_df[nmah_df['Date'].str.match(after_pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1288</th>\n",
       "      <td>edanmdm-nmah_1952731</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Engraved Copper Roller or Cylinder for a Texti...</td>\n",
       "      <td>nmah_1952731</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['printing roller, textile', 'copper roller']</td>\n",
       "      <td>before 1884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1822</th>\n",
       "      <td>edanmdm-nmah_1875755</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Woman milking cow</td>\n",
       "      <td>nmah_1875755</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['real photo postcard']</td>\n",
       "      <td>before 1907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4369</th>\n",
       "      <td>edanmdm-nmah_889629</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Marshland</td>\n",
       "      <td>nmah_889629</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['platinum print']</td>\n",
       "      <td>before 1896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4370</th>\n",
       "      <td>edanmdm-nmah_1975002</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Signing of Declaration of Independence</td>\n",
       "      <td>nmah_1975002</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['print, carbon']</td>\n",
       "      <td>before 1912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4375</th>\n",
       "      <td>edanmdm-nmah_1807078</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Good Bye</td>\n",
       "      <td>nmah_1807078</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photogravures (prints)', 'Photographs']</td>\n",
       "      <td>before 1937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4586</th>\n",
       "      <td>edanmdm-nmah_1807002</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>At Dusk</td>\n",
       "      <td>nmah_1807002</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photogravures (prints)', 'Photographs']</td>\n",
       "      <td>before 1937</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "1288  edanmdm-nmah_1952731     NMAH   \n",
       "1822  edanmdm-nmah_1875755     NMAH   \n",
       "4369   edanmdm-nmah_889629     NMAH   \n",
       "4370  edanmdm-nmah_1975002     NMAH   \n",
       "4375  edanmdm-nmah_1807078     NMAH   \n",
       "4586  edanmdm-nmah_1807002     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "1288  Engraved Copper Roller or Cylinder for a Texti...  nmah_1952731   \n",
       "1822                                  Woman milking cow  nmah_1875755   \n",
       "4369                                          Marshland   nmah_889629   \n",
       "4370             Signing of Declaration of Independence  nmah_1975002   \n",
       "4375                                           Good Bye  nmah_1807078   \n",
       "4586                                            At Dusk  nmah_1807002   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "1288  {'access': 'CC0'}  National Museum of American History   \n",
       "1822  {'access': 'CC0'}  National Museum of American History   \n",
       "4369  {'access': 'CC0'}  National Museum of American History   \n",
       "4370  {'access': 'CC0'}  National Museum of American History   \n",
       "4375  {'access': 'CC0'}  National Museum of American History   \n",
       "4586  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                        object_type         Date  \n",
       "1288  ['printing roller, textile', 'copper roller']  before 1884  \n",
       "1822                        ['real photo postcard']  before 1907  \n",
       "4369                             ['platinum print']  before 1896  \n",
       "4370                              ['print, carbon']  before 1912  \n",
       "4375      ['Photogravures (prints)', 'Photographs']  before 1937  \n",
       "4586      ['Photogravures (prints)', 'Photographs']  before 1937  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "before_pattern = r'^[Bb]efore\\s\\d{4}$'\n",
    "nmah_df[nmah_df['Date'].str.match(before_pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>edanmdm-nmah_750413</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Bird's-eye view of the Terrace Canons</td>\n",
       "      <td>nmah_750413</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Block', 'block, engraved wood']</td>\n",
       "      <td>ca 1875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>edanmdm-nmah_750835</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Section through Echo Cliffs</td>\n",
       "      <td>nmah_750835</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Block', 'block, engraved wood']</td>\n",
       "      <td>ca 1875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>edanmdm-nmah_310173</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>ornament, christmas tree</td>\n",
       "      <td>nmah_310173</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['ornament, christmas tree', 'Ornaments', 'Orn...</td>\n",
       "      <td>ca 1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>edanmdm-nmah_800332</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>December</td>\n",
       "      <td>nmah_800332</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Silkscreen', 'Print; Linoleum Cut', 'Prints']</td>\n",
       "      <td>c. 1960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>edanmdm-nmah_1402868</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>photograph</td>\n",
       "      <td>nmah_1402868</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>ca. December 1993</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5080</th>\n",
       "      <td>edanmdm-nmah_1216426</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Nebulin A</td>\n",
       "      <td>nmah_1216426</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Pharmaceutical']</td>\n",
       "      <td>c. 1940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5081</th>\n",
       "      <td>edanmdm-nmah_1217000</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Chloro-Hexol</td>\n",
       "      <td>nmah_1217000</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Pharmaceutical']</td>\n",
       "      <td>c. 1930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5082</th>\n",
       "      <td>edanmdm-nmah_1218346</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Dolalgial</td>\n",
       "      <td>nmah_1218346</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Pharmaceutical']</td>\n",
       "      <td>c. 1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5167</th>\n",
       "      <td>edanmdm-nmah_1316465</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Guy Picciotto of Fugazi w/his 1976 Chrysler Co...</td>\n",
       "      <td>nmah_1316465</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Postcard, real photo']</td>\n",
       "      <td>c 1998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5188</th>\n",
       "      <td>edanmdm-nmah_1200005</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Spring Blossoms</td>\n",
       "      <td>nmah_1200005</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>ca 1900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>157 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "56     edanmdm-nmah_750413     NMAH   \n",
       "57     edanmdm-nmah_750835     NMAH   \n",
       "85     edanmdm-nmah_310173     NMAH   \n",
       "90     edanmdm-nmah_800332     NMAH   \n",
       "129   edanmdm-nmah_1402868     NMAH   \n",
       "...                    ...      ...   \n",
       "5080  edanmdm-nmah_1216426     NMAH   \n",
       "5081  edanmdm-nmah_1217000     NMAH   \n",
       "5082  edanmdm-nmah_1218346     NMAH   \n",
       "5167  edanmdm-nmah_1316465     NMAH   \n",
       "5188  edanmdm-nmah_1200005     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "56                Bird's-eye view of the Terrace Canons   nmah_750413   \n",
       "57                          Section through Echo Cliffs   nmah_750835   \n",
       "85                             ornament, christmas tree   nmah_310173   \n",
       "90                                             December   nmah_800332   \n",
       "129                                          photograph  nmah_1402868   \n",
       "...                                                 ...           ...   \n",
       "5080                                          Nebulin A  nmah_1216426   \n",
       "5081                                       Chloro-Hexol  nmah_1217000   \n",
       "5082                                          Dolalgial  nmah_1218346   \n",
       "5167  Guy Picciotto of Fugazi w/his 1976 Chrysler Co...  nmah_1316465   \n",
       "5188                                    Spring Blossoms  nmah_1200005   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "56    {'access': 'CC0'}  National Museum of American History   \n",
       "57    {'access': 'CC0'}  National Museum of American History   \n",
       "85    {'access': 'CC0'}  National Museum of American History   \n",
       "90    {'access': 'CC0'}  National Museum of American History   \n",
       "129   {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5080  {'access': 'CC0'}  National Museum of American History   \n",
       "5081  {'access': 'CC0'}  National Museum of American History   \n",
       "5082  {'access': 'CC0'}  National Museum of American History   \n",
       "5167  {'access': 'CC0'}  National Museum of American History   \n",
       "5188  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                            object_type               Date  \n",
       "56                    ['Block', 'block, engraved wood']            ca 1875  \n",
       "57                    ['Block', 'block, engraved wood']            ca 1875  \n",
       "85    ['ornament, christmas tree', 'Ornaments', 'Orn...            ca 1918  \n",
       "90      ['Silkscreen', 'Print; Linoleum Cut', 'Prints']            c. 1960  \n",
       "129                                     ['Photographs']  ca. December 1993  \n",
       "...                                                 ...                ...  \n",
       "5080                                 ['Pharmaceutical']            c. 1940  \n",
       "5081                                 ['Pharmaceutical']            c. 1930  \n",
       "5082                                 ['Pharmaceutical']            c. 1980  \n",
       "5167                           ['Postcard, real photo']             c 1998  \n",
       "5188                                    ['Photographs']            ca 1900  \n",
       "\n",
       "[157 rows x 8 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "circa_pattern = r'^c|ca\\s\\d{4}$'\n",
    "nmah_df[nmah_df['Date'].str.match(circa_pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>edanmdm-nmah_709664</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Plantronics \"VuSet\" Visual Data Terminal</td>\n",
       "      <td>nmah_709664</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Data Terminal']</td>\n",
       "      <td>Santa Cruz, California</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>edanmdm-nmah_1817313</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Reciprocating Armature Engine</td>\n",
       "      <td>nmah_1817313</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Reciprocating Armature Engine', 'reciprocati...</td>\n",
       "      <td>mid-nineteenth century</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>edanmdm-nmah_1160789</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>fragments, pipe</td>\n",
       "      <td>nmah_1160789</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['fragments, pipe', 'Fragment, Pipe']</td>\n",
       "      <td>19th century</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>edanmdm-nmah_1181347</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>coin</td>\n",
       "      <td>nmah_1181347</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>205 - 129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>edanmdm-nmah_1181022</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>tumbler</td>\n",
       "      <td>nmah_1181022</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Tumblers (drinking glasses)']</td>\n",
       "      <td>1996 08 12 / 1996 08 12, 1996 08 16 / 1996 08 16</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5154</th>\n",
       "      <td>edanmdm-nmah_1995253</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995253</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5155</th>\n",
       "      <td>edanmdm-nmah_1995663</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995663</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5163</th>\n",
       "      <td>edanmdm-nmah_1255565</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>California World's Fair on San Francisco Bay</td>\n",
       "      <td>nmah_1255565</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Postcard Container']</td>\n",
       "      <td>1939-40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5166</th>\n",
       "      <td>edanmdm-nmah_1213082</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Rev. Jimmy Rodgers Snow</td>\n",
       "      <td>nmah_1213082</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1974 (negative), 2003 (print)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5195</th>\n",
       "      <td>edanmdm-nmah_1027512</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>[untitled]</td>\n",
       "      <td>nmah_1027512</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Carte-de-Visite']</td>\n",
       "      <td>1860's-1870's</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>374 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "7      edanmdm-nmah_709664     NMAH   \n",
       "9     edanmdm-nmah_1817313     NMAH   \n",
       "38    edanmdm-nmah_1160789     NMAH   \n",
       "121   edanmdm-nmah_1181347     NMAH   \n",
       "123   edanmdm-nmah_1181022     NMAH   \n",
       "...                    ...      ...   \n",
       "5154  edanmdm-nmah_1995253     NMAH   \n",
       "5155  edanmdm-nmah_1995663     NMAH   \n",
       "5163  edanmdm-nmah_1255565     NMAH   \n",
       "5166  edanmdm-nmah_1213082     NMAH   \n",
       "5195  edanmdm-nmah_1027512     NMAH   \n",
       "\n",
       "                                             title     record_ID  \\\n",
       "7         Plantronics \"VuSet\" Visual Data Terminal   nmah_709664   \n",
       "9                    Reciprocating Armature Engine  nmah_1817313   \n",
       "38                                 fragments, pipe  nmah_1160789   \n",
       "121                                           coin  nmah_1181347   \n",
       "123                                        tumbler  nmah_1181022   \n",
       "...                                            ...           ...   \n",
       "5154                          glass plate negative  nmah_1995253   \n",
       "5155                          glass plate negative  nmah_1995663   \n",
       "5163  California World's Fair on San Francisco Bay  nmah_1255565   \n",
       "5166                       Rev. Jimmy Rodgers Snow  nmah_1213082   \n",
       "5195                                    [untitled]  nmah_1027512   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "7     {'access': 'CC0'}  National Museum of American History   \n",
       "9     {'access': 'CC0'}  National Museum of American History   \n",
       "38    {'access': 'CC0'}  National Museum of American History   \n",
       "121   {'access': 'CC0'}  National Museum of American History   \n",
       "123   {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5154  {'access': 'CC0'}  National Museum of American History   \n",
       "5155  {'access': 'CC0'}  National Museum of American History   \n",
       "5163  {'access': 'CC0'}  National Museum of American History   \n",
       "5166  {'access': 'CC0'}  National Museum of American History   \n",
       "5195  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                            object_type  \\\n",
       "7                                     ['Data Terminal']   \n",
       "9     ['Reciprocating Armature Engine', 'reciprocati...   \n",
       "38                ['fragments, pipe', 'Fragment, Pipe']   \n",
       "121                                   ['Coins (money)']   \n",
       "123                     ['Tumblers (drinking glasses)']   \n",
       "...                                                 ...   \n",
       "5154                                    ['Photographs']   \n",
       "5155                                    ['Photographs']   \n",
       "5163                             ['Postcard Container']   \n",
       "5166                                    ['Photographs']   \n",
       "5195                                ['Carte-de-Visite']   \n",
       "\n",
       "                                                  Date  \n",
       "7                               Santa Cruz, California  \n",
       "9                               mid-nineteenth century  \n",
       "38                                        19th century  \n",
       "121                                          205 - 129  \n",
       "123   1996 08 12 / 1996 08 12, 1996 08 16 / 1996 08 16  \n",
       "...                                                ...  \n",
       "5154                                       1870s-1880s  \n",
       "5155                                       1870s-1880s  \n",
       "5163                                           1939-40  \n",
       "5166                     1974 (negative), 2003 (print)  \n",
       "5195                                     1860's-1870's  \n",
       "\n",
       "[374 rows x 8 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "date_range_filter = nmah_df['Date'].str.match(date_range_pattern).fillna(False)\n",
    "after_filter = nmah_df['Date'].str.match(after_pattern).fillna(False)\n",
    "before_filter = nmah_df['Date'].str.match(before_pattern).fillna(False)\n",
    "circa_filter = nmah_df['Date'].str.match(circa_pattern).fillna(False)\n",
    "nmah_df[~(four_number | null_filter | date_range_filter | after_filter | before_filter | circa_filter)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>edanmdm-nmah_1807422</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Loch Lomond</td>\n",
       "      <td>nmah_1807422</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1860s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3451</th>\n",
       "      <td>edanmdm-nmah_1869689</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>South Front of Lacock Abbey, towards Sharingto...</td>\n",
       "      <td>nmah_1869689</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['salt print']</td>\n",
       "      <td>1840s-1850s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3452</th>\n",
       "      <td>edanmdm-nmah_1869840</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>negative, paper</td>\n",
       "      <td>nmah_1869840</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['negative, paper']</td>\n",
       "      <td>1840s-1850s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4376</th>\n",
       "      <td>edanmdm-nmah_1867290</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>shy smile</td>\n",
       "      <td>nmah_1867290</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['platinum print']</td>\n",
       "      <td>1890s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4589</th>\n",
       "      <td>edanmdm-nmah_1867315</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>bridal party</td>\n",
       "      <td>nmah_1867315</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['platinum print']</td>\n",
       "      <td>1890s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5032</th>\n",
       "      <td>edanmdm-nmah_1869460</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Copy of an Italianate Renaissance print, figur...</td>\n",
       "      <td>nmah_1869460</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['negative, paper']</td>\n",
       "      <td>1840s-1850s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5139</th>\n",
       "      <td>edanmdm-nmah_1998896</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>autochrome, stereograph</td>\n",
       "      <td>nmah_1998896</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['autochrome, stereograph']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5140</th>\n",
       "      <td>edanmdm-nmah_1999049</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass stereograph</td>\n",
       "      <td>nmah_1999049</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['glass stereograph']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5141</th>\n",
       "      <td>edanmdm-nmah_1999368</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>kodachrome</td>\n",
       "      <td>nmah_1999368</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5142</th>\n",
       "      <td>edanmdm-nmah_1999429</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>kodachrome</td>\n",
       "      <td>nmah_1999429</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153</th>\n",
       "      <td>edanmdm-nmah_1995170</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995170</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5154</th>\n",
       "      <td>edanmdm-nmah_1995253</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995253</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5155</th>\n",
       "      <td>edanmdm-nmah_1995663</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995663</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "1056  edanmdm-nmah_1807422     NMAH   \n",
       "3451  edanmdm-nmah_1869689     NMAH   \n",
       "3452  edanmdm-nmah_1869840     NMAH   \n",
       "4376  edanmdm-nmah_1867290     NMAH   \n",
       "4589  edanmdm-nmah_1867315     NMAH   \n",
       "5032  edanmdm-nmah_1869460     NMAH   \n",
       "5139  edanmdm-nmah_1998896     NMAH   \n",
       "5140  edanmdm-nmah_1999049     NMAH   \n",
       "5141  edanmdm-nmah_1999368     NMAH   \n",
       "5142  edanmdm-nmah_1999429     NMAH   \n",
       "5153  edanmdm-nmah_1995170     NMAH   \n",
       "5154  edanmdm-nmah_1995253     NMAH   \n",
       "5155  edanmdm-nmah_1995663     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "1056                                        Loch Lomond  nmah_1807422   \n",
       "3451  South Front of Lacock Abbey, towards Sharingto...  nmah_1869689   \n",
       "3452                                    negative, paper  nmah_1869840   \n",
       "4376                                          shy smile  nmah_1867290   \n",
       "4589                                       bridal party  nmah_1867315   \n",
       "5032  Copy of an Italianate Renaissance print, figur...  nmah_1869460   \n",
       "5139                            autochrome, stereograph  nmah_1998896   \n",
       "5140                                  glass stereograph  nmah_1999049   \n",
       "5141                                         kodachrome  nmah_1999368   \n",
       "5142                                         kodachrome  nmah_1999429   \n",
       "5153                               glass plate negative  nmah_1995170   \n",
       "5154                               glass plate negative  nmah_1995253   \n",
       "5155                               glass plate negative  nmah_1995663   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "1056  {'access': 'CC0'}  National Museum of American History   \n",
       "3451  {'access': 'CC0'}  National Museum of American History   \n",
       "3452  {'access': 'CC0'}  National Museum of American History   \n",
       "4376  {'access': 'CC0'}  National Museum of American History   \n",
       "4589  {'access': 'CC0'}  National Museum of American History   \n",
       "5032  {'access': 'CC0'}  National Museum of American History   \n",
       "5139  {'access': 'CC0'}  National Museum of American History   \n",
       "5140  {'access': 'CC0'}  National Museum of American History   \n",
       "5141  {'access': 'CC0'}  National Museum of American History   \n",
       "5142  {'access': 'CC0'}  National Museum of American History   \n",
       "5153  {'access': 'CC0'}  National Museum of American History   \n",
       "5154  {'access': 'CC0'}  National Museum of American History   \n",
       "5155  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                      object_type         Date  \n",
       "1056              ['Photographs']  1860s-1880s  \n",
       "3451               ['salt print']  1840s-1850s  \n",
       "3452          ['negative, paper']  1840s-1850s  \n",
       "4376           ['platinum print']  1890s-1920s  \n",
       "4589           ['platinum print']  1890s-1920s  \n",
       "5032          ['negative, paper']  1840s-1850s  \n",
       "5139  ['autochrome, stereograph']  1910s-1920s  \n",
       "5140        ['glass stereograph']  1910s-1920s  \n",
       "5141              ['Photographs']  1910s-1920s  \n",
       "5142              ['Photographs']  1910s-1920s  \n",
       "5153              ['Photographs']  1870s-1880s  \n",
       "5154              ['Photographs']  1870s-1880s  \n",
       "5155              ['Photographs']  1870s-1880s  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s_pattern = r'^\\d{4}[s]s*-\\s*\\d{4}[s]$'\n",
    "nmah_df[nmah_df['Date'].str.match(s_pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>edanmdm-nmah_1807422</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Loch Lomond</td>\n",
       "      <td>nmah_1807422</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1860s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3451</th>\n",
       "      <td>edanmdm-nmah_1869689</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>South Front of Lacock Abbey, towards Sharingto...</td>\n",
       "      <td>nmah_1869689</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['salt print']</td>\n",
       "      <td>1840s-1850s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3452</th>\n",
       "      <td>edanmdm-nmah_1869840</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>negative, paper</td>\n",
       "      <td>nmah_1869840</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['negative, paper']</td>\n",
       "      <td>1840s-1850s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4376</th>\n",
       "      <td>edanmdm-nmah_1867290</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>shy smile</td>\n",
       "      <td>nmah_1867290</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['platinum print']</td>\n",
       "      <td>1890s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4589</th>\n",
       "      <td>edanmdm-nmah_1867315</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>bridal party</td>\n",
       "      <td>nmah_1867315</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['platinum print']</td>\n",
       "      <td>1890s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5032</th>\n",
       "      <td>edanmdm-nmah_1869460</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Copy of an Italianate Renaissance print, figur...</td>\n",
       "      <td>nmah_1869460</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['negative, paper']</td>\n",
       "      <td>1840s-1850s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5139</th>\n",
       "      <td>edanmdm-nmah_1998896</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>autochrome, stereograph</td>\n",
       "      <td>nmah_1998896</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['autochrome, stereograph']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5140</th>\n",
       "      <td>edanmdm-nmah_1999049</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass stereograph</td>\n",
       "      <td>nmah_1999049</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['glass stereograph']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5141</th>\n",
       "      <td>edanmdm-nmah_1999368</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>kodachrome</td>\n",
       "      <td>nmah_1999368</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5142</th>\n",
       "      <td>edanmdm-nmah_1999429</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>kodachrome</td>\n",
       "      <td>nmah_1999429</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1910s-1920s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153</th>\n",
       "      <td>edanmdm-nmah_1995170</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995170</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5154</th>\n",
       "      <td>edanmdm-nmah_1995253</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995253</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5155</th>\n",
       "      <td>edanmdm-nmah_1995663</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>glass plate negative</td>\n",
       "      <td>nmah_1995663</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1870s-1880s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5195</th>\n",
       "      <td>edanmdm-nmah_1027512</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>[untitled]</td>\n",
       "      <td>nmah_1027512</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Carte-de-Visite']</td>\n",
       "      <td>1860's-1870's</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "1056  edanmdm-nmah_1807422     NMAH   \n",
       "3451  edanmdm-nmah_1869689     NMAH   \n",
       "3452  edanmdm-nmah_1869840     NMAH   \n",
       "4376  edanmdm-nmah_1867290     NMAH   \n",
       "4589  edanmdm-nmah_1867315     NMAH   \n",
       "5032  edanmdm-nmah_1869460     NMAH   \n",
       "5139  edanmdm-nmah_1998896     NMAH   \n",
       "5140  edanmdm-nmah_1999049     NMAH   \n",
       "5141  edanmdm-nmah_1999368     NMAH   \n",
       "5142  edanmdm-nmah_1999429     NMAH   \n",
       "5153  edanmdm-nmah_1995170     NMAH   \n",
       "5154  edanmdm-nmah_1995253     NMAH   \n",
       "5155  edanmdm-nmah_1995663     NMAH   \n",
       "5195  edanmdm-nmah_1027512     NMAH   \n",
       "\n",
       "                                                  title     record_ID  \\\n",
       "1056                                        Loch Lomond  nmah_1807422   \n",
       "3451  South Front of Lacock Abbey, towards Sharingto...  nmah_1869689   \n",
       "3452                                    negative, paper  nmah_1869840   \n",
       "4376                                          shy smile  nmah_1867290   \n",
       "4589                                       bridal party  nmah_1867315   \n",
       "5032  Copy of an Italianate Renaissance print, figur...  nmah_1869460   \n",
       "5139                            autochrome, stereograph  nmah_1998896   \n",
       "5140                                  glass stereograph  nmah_1999049   \n",
       "5141                                         kodachrome  nmah_1999368   \n",
       "5142                                         kodachrome  nmah_1999429   \n",
       "5153                               glass plate negative  nmah_1995170   \n",
       "5154                               glass plate negative  nmah_1995253   \n",
       "5155                               glass plate negative  nmah_1995663   \n",
       "5195                                         [untitled]  nmah_1027512   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "1056  {'access': 'CC0'}  National Museum of American History   \n",
       "3451  {'access': 'CC0'}  National Museum of American History   \n",
       "3452  {'access': 'CC0'}  National Museum of American History   \n",
       "4376  {'access': 'CC0'}  National Museum of American History   \n",
       "4589  {'access': 'CC0'}  National Museum of American History   \n",
       "5032  {'access': 'CC0'}  National Museum of American History   \n",
       "5139  {'access': 'CC0'}  National Museum of American History   \n",
       "5140  {'access': 'CC0'}  National Museum of American History   \n",
       "5141  {'access': 'CC0'}  National Museum of American History   \n",
       "5142  {'access': 'CC0'}  National Museum of American History   \n",
       "5153  {'access': 'CC0'}  National Museum of American History   \n",
       "5154  {'access': 'CC0'}  National Museum of American History   \n",
       "5155  {'access': 'CC0'}  National Museum of American History   \n",
       "5195  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                      object_type           Date  \n",
       "1056              ['Photographs']    1860s-1880s  \n",
       "3451               ['salt print']    1840s-1850s  \n",
       "3452          ['negative, paper']    1840s-1850s  \n",
       "4376           ['platinum print']    1890s-1920s  \n",
       "4589           ['platinum print']    1890s-1920s  \n",
       "5032          ['negative, paper']    1840s-1850s  \n",
       "5139  ['autochrome, stereograph']    1910s-1920s  \n",
       "5140        ['glass stereograph']    1910s-1920s  \n",
       "5141              ['Photographs']    1910s-1920s  \n",
       "5142              ['Photographs']    1910s-1920s  \n",
       "5153              ['Photographs']    1870s-1880s  \n",
       "5154              ['Photographs']    1870s-1880s  \n",
       "5155              ['Photographs']    1870s-1880s  \n",
       "5195          ['Carte-de-Visite']  1860's-1870's  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sapos_pattern = r'^\\d{4}\\'?[s]s*-\\s*\\d{4}\\'?[s]$'\n",
    "nmah_df[nmah_df['Date'].str.match(sapos_pattern).fillna(False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>unitCode</th>\n",
       "      <th>title</th>\n",
       "      <th>record_ID</th>\n",
       "      <th>metadata_usage</th>\n",
       "      <th>data_source</th>\n",
       "      <th>object_type</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>edanmdm-nmah_709664</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Plantronics \"VuSet\" Visual Data Terminal</td>\n",
       "      <td>nmah_709664</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Data Terminal']</td>\n",
       "      <td>Santa Cruz, California</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>edanmdm-nmah_1817313</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Reciprocating Armature Engine</td>\n",
       "      <td>nmah_1817313</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Reciprocating Armature Engine', 'reciprocati...</td>\n",
       "      <td>mid-nineteenth century</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>edanmdm-nmah_1160789</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>fragments, pipe</td>\n",
       "      <td>nmah_1160789</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['fragments, pipe', 'Fragment, Pipe']</td>\n",
       "      <td>19th century</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>edanmdm-nmah_1181347</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>coin</td>\n",
       "      <td>nmah_1181347</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Coins (money)']</td>\n",
       "      <td>205 - 129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>edanmdm-nmah_1181022</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>tumbler</td>\n",
       "      <td>nmah_1181022</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Tumblers (drinking glasses)']</td>\n",
       "      <td>1996 08 12 / 1996 08 12, 1996 08 16 / 1996 08 16</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5124</th>\n",
       "      <td>edanmdm-nmah_1250263</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>(Two women)</td>\n",
       "      <td>nmah_1250263</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Snapshot']</td>\n",
       "      <td>1940s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5130</th>\n",
       "      <td>edanmdm-nmah_1999577</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>20 Shillings, Pennsylvania, 1777</td>\n",
       "      <td>nmah_1999577</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['note']</td>\n",
       "      <td>1777-04-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5149</th>\n",
       "      <td>edanmdm-nmah_369036</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>necktie</td>\n",
       "      <td>nmah_369036</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Neckwear', 'Necktie; Neckwear; Accessories W...</td>\n",
       "      <td>1889-11-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5163</th>\n",
       "      <td>edanmdm-nmah_1255565</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>California World's Fair on San Francisco Bay</td>\n",
       "      <td>nmah_1255565</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Postcard Container']</td>\n",
       "      <td>1939-40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5166</th>\n",
       "      <td>edanmdm-nmah_1213082</td>\n",
       "      <td>NMAH</td>\n",
       "      <td>Rev. Jimmy Rodgers Snow</td>\n",
       "      <td>nmah_1213082</td>\n",
       "      <td>{'access': 'CC0'}</td>\n",
       "      <td>National Museum of American History</td>\n",
       "      <td>['Photographs']</td>\n",
       "      <td>1974 (negative), 2003 (print)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>360 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id unitCode  \\\n",
       "7      edanmdm-nmah_709664     NMAH   \n",
       "9     edanmdm-nmah_1817313     NMAH   \n",
       "38    edanmdm-nmah_1160789     NMAH   \n",
       "121   edanmdm-nmah_1181347     NMAH   \n",
       "123   edanmdm-nmah_1181022     NMAH   \n",
       "...                    ...      ...   \n",
       "5124  edanmdm-nmah_1250263     NMAH   \n",
       "5130  edanmdm-nmah_1999577     NMAH   \n",
       "5149   edanmdm-nmah_369036     NMAH   \n",
       "5163  edanmdm-nmah_1255565     NMAH   \n",
       "5166  edanmdm-nmah_1213082     NMAH   \n",
       "\n",
       "                                             title     record_ID  \\\n",
       "7         Plantronics \"VuSet\" Visual Data Terminal   nmah_709664   \n",
       "9                    Reciprocating Armature Engine  nmah_1817313   \n",
       "38                                 fragments, pipe  nmah_1160789   \n",
       "121                                           coin  nmah_1181347   \n",
       "123                                        tumbler  nmah_1181022   \n",
       "...                                            ...           ...   \n",
       "5124                                   (Two women)  nmah_1250263   \n",
       "5130              20 Shillings, Pennsylvania, 1777  nmah_1999577   \n",
       "5149                                       necktie   nmah_369036   \n",
       "5163  California World's Fair on San Francisco Bay  nmah_1255565   \n",
       "5166                       Rev. Jimmy Rodgers Snow  nmah_1213082   \n",
       "\n",
       "         metadata_usage                          data_source  \\\n",
       "7     {'access': 'CC0'}  National Museum of American History   \n",
       "9     {'access': 'CC0'}  National Museum of American History   \n",
       "38    {'access': 'CC0'}  National Museum of American History   \n",
       "121   {'access': 'CC0'}  National Museum of American History   \n",
       "123   {'access': 'CC0'}  National Museum of American History   \n",
       "...                 ...                                  ...   \n",
       "5124  {'access': 'CC0'}  National Museum of American History   \n",
       "5130  {'access': 'CC0'}  National Museum of American History   \n",
       "5149  {'access': 'CC0'}  National Museum of American History   \n",
       "5163  {'access': 'CC0'}  National Museum of American History   \n",
       "5166  {'access': 'CC0'}  National Museum of American History   \n",
       "\n",
       "                                            object_type  \\\n",
       "7                                     ['Data Terminal']   \n",
       "9     ['Reciprocating Armature Engine', 'reciprocati...   \n",
       "38                ['fragments, pipe', 'Fragment, Pipe']   \n",
       "121                                   ['Coins (money)']   \n",
       "123                     ['Tumblers (drinking glasses)']   \n",
       "...                                                 ...   \n",
       "5124                                       ['Snapshot']   \n",
       "5130                                           ['note']   \n",
       "5149  ['Neckwear', 'Necktie; Neckwear; Accessories W...   \n",
       "5163                             ['Postcard Container']   \n",
       "5166                                    ['Photographs']   \n",
       "\n",
       "                                                  Date  \n",
       "7                               Santa Cruz, California  \n",
       "9                               mid-nineteenth century  \n",
       "38                                        19th century  \n",
       "121                                          205 - 129  \n",
       "123   1996 08 12 / 1996 08 12, 1996 08 16 / 1996 08 16  \n",
       "...                                                ...  \n",
       "5124                                             1940s  \n",
       "5130                                        1777-04-10  \n",
       "5149                                        1889-11-10  \n",
       "5163                                           1939-40  \n",
       "5166                     1974 (negative), 2003 (print)  \n",
       "\n",
       "[360 rows x 8 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "date_range_filter = nmah_df['Date'].str.match(date_range_pattern).fillna(False)\n",
    "after_filter = nmah_df['Date'].str.match(after_pattern).fillna(False)\n",
    "before_filter = nmah_df['Date'].str.match(before_pattern).fillna(False)\n",
    "circa_filter = nmah_df['Date'].str.match(circa_pattern).fillna(False)\n",
    "sapos_filter = nmah_df['Date'].str.match(sapos_pattern).fillna(False)\n",
    "nmah_df[~(four_number | null_filter | date_range_filter | after_filter | before_filter | circa_filter  | sapos_filter)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}