04-joining-data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### joining-data\n",
    "\n",
    "This is just a quick exercise to try and join the collection data with the pen data using pandas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>tool_id</th>\n",
       "      <th>bundle_id</th>\n",
       "      <th>refers_to_object_id</th>\n",
       "      <th>created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54Sa</td>\n",
       "      <td>18356743</td>\n",
       "      <td>1414081555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>54ZB</td>\n",
       "      <td>18316213</td>\n",
       "      <td>1414432504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>55ap</td>\n",
       "      <td>18637615</td>\n",
       "      <td>1414526581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>55ap</td>\n",
       "      <td>18643273</td>\n",
       "      <td>1414526584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>55bK</td>\n",
       "      <td>18448597</td>\n",
       "      <td>1414529537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>55cZ</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1414530977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>55cZ</td>\n",
       "      <td>18653811</td>\n",
       "      <td>1414530973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>55gr</td>\n",
       "      <td>18481649</td>\n",
       "      <td>1414536158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>55gr</td>\n",
       "      <td>18575263</td>\n",
       "      <td>1414536160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>55ji</td>\n",
       "      <td>18346169</td>\n",
       "      <td>1414617054</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id  tool_id bundle_id  refers_to_object_id     created\n",
       "0   0        0      54Sa             18356743  1414081555\n",
       "1   1        0      54ZB             18316213  1414432504\n",
       "2   2        0      55ap             18637615  1414526581\n",
       "3   3        0      55ap             18643273  1414526584\n",
       "4   4        0      55bK             18448597  1414529537\n",
       "5   5        0      55cZ             18319373  1414530977\n",
       "6   6        0      55cZ             18653811  1414530973\n",
       "7   7        0      55gr             18481649  1414536158\n",
       "8   8        0      55gr             18575263  1414536160\n",
       "9   9        0      55ji             18346169  1414617054"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## read in the data as a pandas object\n",
    "import pandas as pd\n",
    "pen_df = pd.read_csv('../the-pen-data/data/pen-collected-items.csv')\n",
    "\n",
    "## show the first 10 rows\n",
    "pen_df[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>accession_number</th>\n",
       "      <th>creditline</th>\n",
       "      <th>date</th>\n",
       "      <th>decade</th>\n",
       "      <th>department_id</th>\n",
       "      <th>description</th>\n",
       "      <th>dimensions</th>\n",
       "      <th>dimensions_raw</th>\n",
       "      <th>gallery_text</th>\n",
       "      <th>id</th>\n",
       "      <th>...</th>\n",
       "      <th>type</th>\n",
       "      <th>type_id</th>\n",
       "      <th>url</th>\n",
       "      <th>videos</th>\n",
       "      <th>woe:country</th>\n",
       "      <th>woe:country_id</th>\n",
       "      <th>woe:country_name</th>\n",
       "      <th>year_acquired</th>\n",
       "      <th>year_end</th>\n",
       "      <th>year_start</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>56.2015.10</td>\n",
       "      <td>Courtesy of Pixar Animation Studios</td>\n",
       "      <td>2006</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>404529577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135726747</td>\n",
       "      <td>...</td>\n",
       "      <td>Dirt sample</td>\n",
       "      <td>136300499.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/13...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>56.2015.4</td>\n",
       "      <td>Courtesy of Pixar Animation Studios</td>\n",
       "      <td>2006</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>404529577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>H x W: 21.6 × 45.7 cm (8 1/2 in. × 18 in.)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135726733</td>\n",
       "      <td>...</td>\n",
       "      <td>Concept art</td>\n",
       "      <td>136251375.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/13...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>56.2015.7</td>\n",
       "      <td>Courtesy of Pixar Animation Studios</td>\n",
       "      <td>2006</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>404529577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>H x W: 27.9 × 21.6 cm (11 in. × 8 1/2 in.)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The natural environment plays a large role in ...</td>\n",
       "      <td>135726743</td>\n",
       "      <td>...</td>\n",
       "      <td>Concept art</td>\n",
       "      <td>136251375.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/13...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>56.2015.12</td>\n",
       "      <td>Courtesy of Pixar Animation Studios</td>\n",
       "      <td>2006</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>404529577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135726751</td>\n",
       "      <td>...</td>\n",
       "      <td>Dirt sample</td>\n",
       "      <td>136300499.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/13...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>56.2015.2</td>\n",
       "      <td>Courtesy of Pixar Animation Studios</td>\n",
       "      <td>2006</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>404529577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>H x W: 23.5 × 47.6 cm (9 1/4 × 18 3/4 in.)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>While on a research road trip for Cars along R...</td>\n",
       "      <td>135726729</td>\n",
       "      <td>...</td>\n",
       "      <td>Concept art</td>\n",
       "      <td>136251375.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/13...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  accession_number                           creditline  date  decade  \\\n",
       "0       56.2015.10  Courtesy of Pixar Animation Studios  2006  2000.0   \n",
       "1        56.2015.4  Courtesy of Pixar Animation Studios  2006  2000.0   \n",
       "2        56.2015.7  Courtesy of Pixar Animation Studios  2006  2000.0   \n",
       "3       56.2015.12  Courtesy of Pixar Animation Studios  2006  2000.0   \n",
       "4        56.2015.2  Courtesy of Pixar Animation Studios  2006  2000.0   \n",
       "\n",
       "   department_id description                                  dimensions  \\\n",
       "0      404529577         NaN                                         NaN   \n",
       "1      404529577         NaN  H x W: 21.6 × 45.7 cm (8 1/2 in. × 18 in.)   \n",
       "2      404529577         NaN  H x W: 27.9 × 21.6 cm (11 in. × 8 1/2 in.)   \n",
       "3      404529577         NaN                                         NaN   \n",
       "4      404529577         NaN  H x W: 23.5 × 47.6 cm (9 1/4 × 18 3/4 in.)   \n",
       "\n",
       "   dimensions_raw                                       gallery_text  \\\n",
       "0             NaN                                                NaN   \n",
       "1             NaN                                                NaN   \n",
       "2             NaN  The natural environment plays a large role in ...   \n",
       "3             NaN                                                NaN   \n",
       "4             NaN  While on a research road trip for Cars along R...   \n",
       "\n",
       "          id     ...             type      type_id  \\\n",
       "0  135726747     ...      Dirt sample  136300499.0   \n",
       "1  135726733     ...      Concept art  136251375.0   \n",
       "2  135726743     ...      Concept art  136251375.0   \n",
       "3  135726751     ...      Dirt sample  136300499.0   \n",
       "4  135726729     ...      Concept art  136251375.0   \n",
       "\n",
       "                                                 url videos woe:country  \\\n",
       "0  https://collection.cooperhewitt.org/objects/13...    NaN         NaN   \n",
       "1  https://collection.cooperhewitt.org/objects/13...    NaN         NaN   \n",
       "2  https://collection.cooperhewitt.org/objects/13...    NaN         NaN   \n",
       "3  https://collection.cooperhewitt.org/objects/13...    NaN         NaN   \n",
       "4  https://collection.cooperhewitt.org/objects/13...    NaN         NaN   \n",
       "\n",
       "  woe:country_id  woe:country_name year_acquired  year_end  year_start  \n",
       "0            NaN               NaN           NaN       NaN         NaN  \n",
       "1            NaN               NaN           NaN       NaN         NaN  \n",
       "2            NaN               NaN           NaN       NaN         NaN  \n",
       "3            NaN               NaN           NaN       NaN         NaN  \n",
       "4            NaN               NaN           NaN       NaN         NaN  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## read in the collection data as another panda object\n",
    "collection_df = pd.read_csv('../collection/meta/objects.csv', low_memory=False)\n",
    "\n",
    "collection_df[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "## join the two data sets using pandas merge function \n",
    "result = pd.merge(pen_df, collection_df, left_on='refers_to_object_id', right_on='id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_x</th>\n",
       "      <th>tool_id</th>\n",
       "      <th>bundle_id</th>\n",
       "      <th>refers_to_object_id</th>\n",
       "      <th>created</th>\n",
       "      <th>accession_number</th>\n",
       "      <th>creditline</th>\n",
       "      <th>date</th>\n",
       "      <th>decade</th>\n",
       "      <th>department_id</th>\n",
       "      <th>...</th>\n",
       "      <th>type</th>\n",
       "      <th>type_id</th>\n",
       "      <th>url</th>\n",
       "      <th>videos</th>\n",
       "      <th>woe:country</th>\n",
       "      <th>woe:country_id</th>\n",
       "      <th>woe:country_name</th>\n",
       "      <th>year_acquired</th>\n",
       "      <th>year_end</th>\n",
       "      <th>year_start</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>1442338</td>\n",
       "      <td>0</td>\n",
       "      <td>8GBD6</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439219450</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1442850</td>\n",
       "      <td>0</td>\n",
       "      <td>8GBLB</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439219219</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>1444629</td>\n",
       "      <td>0</td>\n",
       "      <td>8GDHc</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439241053</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>1445143</td>\n",
       "      <td>0</td>\n",
       "      <td>8GGyt</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439307132</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>1445779</td>\n",
       "      <td>0</td>\n",
       "      <td>8GGBc</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439303911</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>1445993</td>\n",
       "      <td>0</td>\n",
       "      <td>8GGBp</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439303903</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1446199</td>\n",
       "      <td>0</td>\n",
       "      <td>8GGET</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439309467</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>1447272</td>\n",
       "      <td>0</td>\n",
       "      <td>8GH5e</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439310039</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>1447998</td>\n",
       "      <td>0</td>\n",
       "      <td>8GHiD</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439312120</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>1448362</td>\n",
       "      <td>0</td>\n",
       "      <td>8GHrZ</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439311962</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>1449096</td>\n",
       "      <td>0</td>\n",
       "      <td>8GJ4c</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439313236</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>1449385</td>\n",
       "      <td>0</td>\n",
       "      <td>8GJ6M</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439313433</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>1450881</td>\n",
       "      <td>0</td>\n",
       "      <td>8GJSM</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439317298</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>1451691</td>\n",
       "      <td>0</td>\n",
       "      <td>8GKcK</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439314552</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>1451786</td>\n",
       "      <td>0</td>\n",
       "      <td>8GKdc</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439314542</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>1452761</td>\n",
       "      <td>0</td>\n",
       "      <td>8GKSk</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439324572</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>1453981</td>\n",
       "      <td>0</td>\n",
       "      <td>8GMsD</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439324546</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>1456103</td>\n",
       "      <td>0</td>\n",
       "      <td>8GPCV</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439329191</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>1457642</td>\n",
       "      <td>0</td>\n",
       "      <td>8GTnR</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439398417</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>1458619</td>\n",
       "      <td>0</td>\n",
       "      <td>8GTVR</td>\n",
       "      <td>18319373</td>\n",
       "      <td>1439402736</td>\n",
       "      <td>1931-45-64</td>\n",
       "      <td>Gift of Eleanor and Sarah Hewitt</td>\n",
       "      <td>1850–60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35347503</td>\n",
       "      <td>...</td>\n",
       "      <td>Ornament</td>\n",
       "      <td>35255209.0</td>\n",
       "      <td>https://collection.cooperhewitt.org/objects/18...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>23424819.0</td>\n",
       "      <td>France</td>\n",
       "      <td>1931.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id_x  tool_id bundle_id  refers_to_object_id     created  \\\n",
       "100  1442338        0     8GBD6             18319373  1439219450   \n",
       "101  1442850        0     8GBLB             18319373  1439219219   \n",
       "102  1444629        0     8GDHc             18319373  1439241053   \n",
       "103  1445143        0     8GGyt             18319373  1439307132   \n",
       "104  1445779        0     8GGBc             18319373  1439303911   \n",
       "105  1445993        0     8GGBp             18319373  1439303903   \n",
       "106  1446199        0     8GGET             18319373  1439309467   \n",
       "107  1447272        0     8GH5e             18319373  1439310039   \n",
       "108  1447998        0     8GHiD             18319373  1439312120   \n",
       "109  1448362        0     8GHrZ             18319373  1439311962   \n",
       "110  1449096        0     8GJ4c             18319373  1439313236   \n",
       "111  1449385        0     8GJ6M             18319373  1439313433   \n",
       "112  1450881        0     8GJSM             18319373  1439317298   \n",
       "113  1451691        0     8GKcK             18319373  1439314552   \n",
       "114  1451786        0     8GKdc             18319373  1439314542   \n",
       "115  1452761        0     8GKSk             18319373  1439324572   \n",
       "116  1453981        0     8GMsD             18319373  1439324546   \n",
       "117  1456103        0     8GPCV             18319373  1439329191   \n",
       "118  1457642        0     8GTnR             18319373  1439398417   \n",
       "119  1458619        0     8GTVR             18319373  1439402736   \n",
       "\n",
       "    accession_number                        creditline     date  decade  \\\n",
       "100       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "101       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "102       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "103       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "104       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "105       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "106       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "107       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "108       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "109       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "110       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "111       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "112       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "113       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "114       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "115       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "116       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "117       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "118       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "119       1931-45-64  Gift of Eleanor and Sarah Hewitt  1850–60     NaN   \n",
       "\n",
       "     department_id    ...          type     type_id  \\\n",
       "100       35347503    ...      Ornament  35255209.0   \n",
       "101       35347503    ...      Ornament  35255209.0   \n",
       "102       35347503    ...      Ornament  35255209.0   \n",
       "103       35347503    ...      Ornament  35255209.0   \n",
       "104       35347503    ...      Ornament  35255209.0   \n",
       "105       35347503    ...      Ornament  35255209.0   \n",
       "106       35347503    ...      Ornament  35255209.0   \n",
       "107       35347503    ...      Ornament  35255209.0   \n",
       "108       35347503    ...      Ornament  35255209.0   \n",
       "109       35347503    ...      Ornament  35255209.0   \n",
       "110       35347503    ...      Ornament  35255209.0   \n",
       "111       35347503    ...      Ornament  35255209.0   \n",
       "112       35347503    ...      Ornament  35255209.0   \n",
       "113       35347503    ...      Ornament  35255209.0   \n",
       "114       35347503    ...      Ornament  35255209.0   \n",
       "115       35347503    ...      Ornament  35255209.0   \n",
       "116       35347503    ...      Ornament  35255209.0   \n",
       "117       35347503    ...      Ornament  35255209.0   \n",
       "118       35347503    ...      Ornament  35255209.0   \n",
       "119       35347503    ...      Ornament  35255209.0   \n",
       "\n",
       "                                                   url videos  woe:country  \\\n",
       "100  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "101  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "102  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "103  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "104  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "105  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "106  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "107  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "108  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "109  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "110  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "111  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "112  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "113  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "114  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "115  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "116  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "117  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "118  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "119  https://collection.cooperhewitt.org/objects/18...    NaN   23424819.0   \n",
       "\n",
       "    woe:country_id  woe:country_name  year_acquired year_end year_start  \n",
       "100     23424819.0            France         1931.0      NaN        NaN  \n",
       "101     23424819.0            France         1931.0      NaN        NaN  \n",
       "102     23424819.0            France         1931.0      NaN        NaN  \n",
       "103     23424819.0            France         1931.0      NaN        NaN  \n",
       "104     23424819.0            France         1931.0      NaN        NaN  \n",
       "105     23424819.0            France         1931.0      NaN        NaN  \n",
       "106     23424819.0            France         1931.0      NaN        NaN  \n",
       "107     23424819.0            France         1931.0      NaN        NaN  \n",
       "108     23424819.0            France         1931.0      NaN        NaN  \n",
       "109     23424819.0            France         1931.0      NaN        NaN  \n",
       "110     23424819.0            France         1931.0      NaN        NaN  \n",
       "111     23424819.0            France         1931.0      NaN        NaN  \n",
       "112     23424819.0            France         1931.0      NaN        NaN  \n",
       "113     23424819.0            France         1931.0      NaN        NaN  \n",
       "114     23424819.0            France         1931.0      NaN        NaN  \n",
       "115     23424819.0            France         1931.0      NaN        NaN  \n",
       "116     23424819.0            France         1931.0      NaN        NaN  \n",
       "117     23424819.0            France         1931.0      NaN        NaN  \n",
       "118     23424819.0            France         1931.0      NaN        NaN  \n",
       "119     23424819.0            France         1931.0      NaN        NaN  \n",
       "\n",
       "[20 rows x 43 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result[100:120]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.5.1+"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}