Jupyter/Arlington.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "7e39587d",
   "metadata": {},
   "source": [
    "# Arlington PDF Model Jupyter Notebook\n",
    "\n",
    "This notebook demonstrates how the Arlington PDF Model can be combined into a monolithic TSV file suitable for use by pandas in a Jupyter Notebook. The Python script `arlington-to-pandas.py` will convert an Arlington file set into a single monolithic TSV file by adding the object name as the first (left-most) field called \"Object\".\n",
    "\n",
    "---\n",
    "Copyright 2021-23 PDF Association, Inc. https://www.pdfa.org\n",
    "\n",
    "This material is based upon work supported by the Defense Advanced Research Projects Agency (DARPA) under Contract No. HR001119C0079. Any opinions, findings and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the Defense Advanced Research Projects Agency (DARPA). Approved for public release."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "8c7e625d",
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns \n",
    "sns.set(style=\"darkgrid\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8baf2d67",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('pandas.tsv', delimiter='\\t', na_filter=False,\n",
    "                 dtype={'Object':'string', 'Key':'string', 'Type':'string', \n",
    "                        'SinceVersion':'string', 'DeprecatedIn':'string', 'Required':'string', \n",
    "                        'IndirectReference':'string', 'Inheritable':'string', \n",
    "                        'DefaultValue':'string', 'PossibleValues':'string', \n",
    "                        'SpecialCase':'string', 'Link':'string', 'Note':'string'})"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cf1839f2",
   "metadata": {},
   "source": [
    "The above two cells will have loaded the monolithic TSV into pandas as a Dataframe object. All fields are treated as strings to avoid NaN and other issues. This also matches how other Python scripts and the C++ PoC TestGrammar operate."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "935e15c1",
   "metadata": {},
   "source": [
    "We can also export the monolithic TSV data as JSON for other Python-based processing. More pre-processing could also be done (such as spliting each fields (columns) on SEMI-COLON):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "b0bfae2f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_json('Arlington.json', orient=\"records\", indent=4)     "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "812c62f4",
   "metadata": {},
   "source": [
    "Here is what the data (as a Pandas `dataframe`) looks like:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "fa403e71",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>SinceVersion</th>\n",
       "      <th>DeprecatedIn</th>\n",
       "      <th>Required</th>\n",
       "      <th>IndirectReference</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "      <th>PossibleValues</th>\n",
       "      <th>SpecialCase</th>\n",
       "      <th>Link</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3DActivation</td>\n",
       "      <td>A</td>\n",
       "      <td>name</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>XA</td>\n",
       "      <td>[PO,PV,XA]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3DActivation</td>\n",
       "      <td>AIS</td>\n",
       "      <td>name</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>L</td>\n",
       "      <td>[I,L]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3DActivation</td>\n",
       "      <td>D</td>\n",
       "      <td>name</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>PI</td>\n",
       "      <td>[PC,PI,XD]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3DActivation</td>\n",
       "      <td>DIS</td>\n",
       "      <td>name</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>U</td>\n",
       "      <td>[U,I,L]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3DActivation</td>\n",
       "      <td>TB</td>\n",
       "      <td>boolean</td>\n",
       "      <td>1.7</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>true</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Object  Key     Type SinceVersion DeprecatedIn Required  \\\n",
       "0  3DActivation    A     name          1.6                 FALSE   \n",
       "1  3DActivation  AIS     name          1.6                 FALSE   \n",
       "2  3DActivation    D     name          1.6                 FALSE   \n",
       "3  3DActivation  DIS     name          1.6                 FALSE   \n",
       "4  3DActivation   TB  boolean          1.7                 FALSE   \n",
       "\n",
       "  IndirectReference Inheritable DefaultValue PossibleValues SpecialCase Link  \\\n",
       "0             FALSE       FALSE           XA     [PO,PV,XA]                    \n",
       "1             FALSE       FALSE            L          [I,L]                    \n",
       "2             FALSE       FALSE           PI     [PC,PI,XD]                    \n",
       "3             FALSE       FALSE            U        [U,I,L]                    \n",
       "4             FALSE       FALSE         true                                   \n",
       "\n",
       "        Note  \n",
       "0  Table 310  \n",
       "1             \n",
       "2             \n",
       "3             \n",
       "4             "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "31a319d5",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>SinceVersion</th>\n",
       "      <th>DeprecatedIn</th>\n",
       "      <th>Required</th>\n",
       "      <th>IndirectReference</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "      <th>PossibleValues</th>\n",
       "      <th>SpecialCase</th>\n",
       "      <th>Link</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3703</th>\n",
       "      <td>XRefStream</td>\n",
       "      <td>ID</td>\n",
       "      <td>array</td>\n",
       "      <td>1.5</td>\n",
       "      <td></td>\n",
       "      <td>fn:IsRequired(fn:SinceVersion(2.0) || fn:IsPre...</td>\n",
       "      <td>fn:MustBeDirect(fn:IsPresent(Encrypt))</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>[fn:Eval(fn:MustBeDirect(ID::0) &amp;&amp; fn:MustBeDi...</td>\n",
       "      <td>[ArrayOf_2StringsByte]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3704</th>\n",
       "      <td>XRefStream</td>\n",
       "      <td>Encrypt</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>1.5</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>[EncryptionStandard,EncryptionPublicKey]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3705</th>\n",
       "      <td>XRefStream</td>\n",
       "      <td>AuthCode</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>fn:Extension(ISO_TS_32004,2.0)</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>fn:MustBeDirect()</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>[fn:Eval(Encrypt::@V&gt;=5)]</td>\n",
       "      <td>[AuthCode]</td>\n",
       "      <td>ISO/TS 32004 integrity protection</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3706</th>\n",
       "      <td>_UniversalArray</td>\n",
       "      <td>*</td>\n",
       "      <td>array;boolean;dictionary;name;null;number;stre...</td>\n",
       "      <td>1.2</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>[FALSE];[FALSE];[FALSE];[FALSE];[FALSE];[FALSE...</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>[_UniversalArray];[];[_UniversalDictionary];[]...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3707</th>\n",
       "      <td>_UniversalDictionary</td>\n",
       "      <td>*</td>\n",
       "      <td>array;boolean;dictionary;name;null;number;stre...</td>\n",
       "      <td>1.2</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>[FALSE];[FALSE];[FALSE];[FALSE];[FALSE];[FALSE...</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>[_UniversalArray];[];[_UniversalDictionary];[]...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Object       Key  \\\n",
       "3703            XRefStream        ID   \n",
       "3704            XRefStream   Encrypt   \n",
       "3705            XRefStream  AuthCode   \n",
       "3706       _UniversalArray         *   \n",
       "3707  _UniversalDictionary         *   \n",
       "\n",
       "                                                   Type  \\\n",
       "3703                                              array   \n",
       "3704                                         dictionary   \n",
       "3705                                         dictionary   \n",
       "3706  array;boolean;dictionary;name;null;number;stre...   \n",
       "3707  array;boolean;dictionary;name;null;number;stre...   \n",
       "\n",
       "                        SinceVersion DeprecatedIn  \\\n",
       "3703                             1.5                \n",
       "3704                             1.5                \n",
       "3705  fn:Extension(ISO_TS_32004,2.0)                \n",
       "3706                             1.2                \n",
       "3707                             1.2                \n",
       "\n",
       "                                               Required  \\\n",
       "3703  fn:IsRequired(fn:SinceVersion(2.0) || fn:IsPre...   \n",
       "3704                                              FALSE   \n",
       "3705                                              FALSE   \n",
       "3706                                              FALSE   \n",
       "3707                                              FALSE   \n",
       "\n",
       "                                      IndirectReference Inheritable  \\\n",
       "3703             fn:MustBeDirect(fn:IsPresent(Encrypt))       FALSE   \n",
       "3704                                              FALSE       FALSE   \n",
       "3705                                  fn:MustBeDirect()       FALSE   \n",
       "3706  [FALSE];[FALSE];[FALSE];[FALSE];[FALSE];[FALSE...       FALSE   \n",
       "3707  [FALSE];[FALSE];[FALSE];[FALSE];[FALSE];[FALSE...       FALSE   \n",
       "\n",
       "     DefaultValue PossibleValues  \\\n",
       "3703                               \n",
       "3704                               \n",
       "3705                               \n",
       "3706                               \n",
       "3707                               \n",
       "\n",
       "                                            SpecialCase  \\\n",
       "3703  [fn:Eval(fn:MustBeDirect(ID::0) && fn:MustBeDi...   \n",
       "3704                                                      \n",
       "3705                          [fn:Eval(Encrypt::@V>=5)]   \n",
       "3706                                                      \n",
       "3707                                                      \n",
       "\n",
       "                                                   Link  \\\n",
       "3703                             [ArrayOf_2StringsByte]   \n",
       "3704           [EncryptionStandard,EncryptionPublicKey]   \n",
       "3705                                         [AuthCode]   \n",
       "3706  [_UniversalArray];[];[_UniversalDictionary];[]...   \n",
       "3707  [_UniversalArray];[];[_UniversalDictionary];[]...   \n",
       "\n",
       "                                   Note  \n",
       "3703                                     \n",
       "3704                                     \n",
       "3705  ISO/TS 32004 integrity protection  \n",
       "3706                                     \n",
       "3707                                     "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "6ff1b479",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "545"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(pd.unique(df['Object']))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d3cffed0",
   "metadata": {},
   "source": [
    "This is the number of TSV files in the Arlington TSV data set and can be confirmed by `ls -1 | wc -1` in Linux."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6dd8360e",
   "metadata": {},
   "source": [
    "So how many keys or array elements does Arlington define? This will be the number of rows in the Dataframe!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "a3be6b97",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3708"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6a160d1a",
   "metadata": {},
   "source": [
    "So this is the number of data rows in the full Arlington PDF model. It should also be equal to the sum of the line count of all TSV files less the number of files (since each TSV file has a header row). This can be confirmed in Linux by\" `cat * | wc -l` and then subtracting the number of TSV files above."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "0b265ef6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Object               string\n",
       "Key                  string\n",
       "Type                 string\n",
       "SinceVersion         string\n",
       "DeprecatedIn         string\n",
       "Required             string\n",
       "IndirectReference    string\n",
       "Inheritable          string\n",
       "DefaultValue         string\n",
       "PossibleValues       string\n",
       "SpecialCase          string\n",
       "Link                 string\n",
       "Note                 string\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "00ce0a3f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Object', 'Key', 'Type', 'SinceVersion', 'DeprecatedIn', 'Required',\n",
       "       'IndirectReference', 'Inheritable', 'DefaultValue', 'PossibleValues',\n",
       "       'SpecialCase', 'Link', 'Note'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "02662999",
   "metadata": {},
   "source": [
    "The fields (columns) are easy to access:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "id": "36c448fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<StringArray>\n",
       "[            '3DActivation',         '3DAnimationStyle',\n",
       "             '3DBackground',           '3DCrossSection',\n",
       "         '3DLightingScheme',             '3DMeasure3DC',\n",
       "             '3DMeasureAD3',             '3DMeasureLD3',\n",
       "             '3DMeasurePD3',             '3DMeasureRD3',\n",
       " ...\n",
       " 'XObjectFormPSpassthrough',       'XObjectFormTrapNet',\n",
       "         'XObjectFormType1',             'XObjectImage',\n",
       "         'XObjectImageMask',     'XObjectImageSoftMask',\n",
       "               'XObjectMap',               'XRefStream',\n",
       "          '_UniversalArray',     '_UniversalDictionary']\n",
       "Length: 545, dtype: string"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Object']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "c4aebbea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<StringArray>\n",
       "[            '3DActivation',         '3DAnimationStyle',\n",
       "             '3DBackground',           '3DCrossSection',\n",
       "         '3DLightingScheme',             '3DMeasure3DC',\n",
       "             '3DMeasureAD3',             '3DMeasureLD3',\n",
       "             '3DMeasurePD3',             '3DMeasureRD3',\n",
       " ...\n",
       " 'XObjectFormPSpassthrough',       'XObjectFormTrapNet',\n",
       "         'XObjectFormType1',             'XObjectImage',\n",
       "         'XObjectImageMask',     'XObjectImageSoftMask',\n",
       "               'XObjectMap',               'XRefStream',\n",
       "          '_UniversalArray',     '_UniversalDictionary']\n",
       "Length: 545, dtype: string"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Object'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "75adfd14",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                                                  [name]\n",
       "1                                                  [name]\n",
       "2                                                  [name]\n",
       "3                                                  [name]\n",
       "4                                               [boolean]\n",
       "                              ...                        \n",
       "3703                                              [array]\n",
       "3704                                         [dictionary]\n",
       "3705                                         [dictionary]\n",
       "3706    [array, boolean, dictionary, name, null, numbe...\n",
       "3707    [array, boolean, dictionary, name, null, numbe...\n",
       "Name: Type, Length: 3708, dtype: object"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Type'].str.split(';')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c67aa13d",
   "metadata": {},
   "source": [
    "Using Datafield query method we can create some simple filters over the data:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "72fb27f9",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>SinceVersion</th>\n",
       "      <th>DeprecatedIn</th>\n",
       "      <th>Required</th>\n",
       "      <th>IndirectReference</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "      <th>PossibleValues</th>\n",
       "      <th>SpecialCase</th>\n",
       "      <th>Link</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3DAnimationStyle</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.7</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>None</td>\n",
       "      <td>[None,Linear,Oscillating]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3DBackground</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>SC</td>\n",
       "      <td>[SC]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3DLightingScheme</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.7</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[Artwork,None,White,Day,Night,Hard,Primary,Blu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3DMeasure3DC</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>fn:Eval(fn:Extension(ADBE_Extn3,1.7) || 2.0)</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[3DC]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>3DMeasureAD3</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>fn:Eval(fn:Extension(ADBE_Extn3,1.7) || 2.0)</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[AD3]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3546</th>\n",
       "      <td>XObjectFormTrapNet</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[Form]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3576</th>\n",
       "      <td>XObjectFormType1</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[Form]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3607</th>\n",
       "      <td>XObjectImage</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[Image]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3641</th>\n",
       "      <td>XObjectImageMask</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.3</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[Image]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3669</th>\n",
       "      <td>XObjectImageSoftMask</td>\n",
       "      <td>Subtype</td>\n",
       "      <td>name</td>\n",
       "      <td>1.4</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td>[Image]</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>82 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Object      Key  Type  \\\n",
       "10        3DAnimationStyle  Subtype  name   \n",
       "14            3DBackground  Subtype  name   \n",
       "29        3DLightingScheme  Subtype  name   \n",
       "31            3DMeasure3DC  Subtype  name   \n",
       "42            3DMeasureAD3  Subtype  name   \n",
       "...                    ...      ...   ...   \n",
       "3546    XObjectFormTrapNet  Subtype  name   \n",
       "3576      XObjectFormType1  Subtype  name   \n",
       "3607          XObjectImage  Subtype  name   \n",
       "3641      XObjectImageMask  Subtype  name   \n",
       "3669  XObjectImageSoftMask  Subtype  name   \n",
       "\n",
       "                                      SinceVersion DeprecatedIn Required  \\\n",
       "10                                             1.7                 FALSE   \n",
       "14                                             1.6                 FALSE   \n",
       "29                                             1.7                  TRUE   \n",
       "31    fn:Eval(fn:Extension(ADBE_Extn3,1.7) || 2.0)                  TRUE   \n",
       "42    fn:Eval(fn:Extension(ADBE_Extn3,1.7) || 2.0)                  TRUE   \n",
       "...                                            ...          ...      ...   \n",
       "3546                                           1.3          2.0     TRUE   \n",
       "3576                                           1.0                  TRUE   \n",
       "3607                                           1.0                  TRUE   \n",
       "3641                                           1.3                  TRUE   \n",
       "3669                                           1.4                  TRUE   \n",
       "\n",
       "     IndirectReference Inheritable DefaultValue  \\\n",
       "10               FALSE       FALSE         None   \n",
       "14               FALSE       FALSE           SC   \n",
       "29               FALSE       FALSE                \n",
       "31               FALSE       FALSE                \n",
       "42               FALSE       FALSE                \n",
       "...                ...         ...          ...   \n",
       "3546             FALSE       FALSE                \n",
       "3576             FALSE       FALSE                \n",
       "3607             FALSE       FALSE                \n",
       "3641             FALSE       FALSE                \n",
       "3669             FALSE       FALSE                \n",
       "\n",
       "                                         PossibleValues SpecialCase Link  \\\n",
       "10                            [None,Linear,Oscillating]                    \n",
       "14                                                 [SC]                    \n",
       "29    [Artwork,None,White,Day,Night,Hard,Primary,Blu...                    \n",
       "31                                                [3DC]                    \n",
       "42                                                [AD3]                    \n",
       "...                                                 ...         ...  ...   \n",
       "3546                                             [Form]                    \n",
       "3576                                             [Form]                    \n",
       "3607                                            [Image]                    \n",
       "3641                                            [Image]                    \n",
       "3669                                            [Image]                    \n",
       "\n",
       "           Note  \n",
       "10    Table 313  \n",
       "14               \n",
       "29    Table 321  \n",
       "31               \n",
       "42               \n",
       "...         ...  \n",
       "3546             \n",
       "3576             \n",
       "3607             \n",
       "3641             \n",
       "3669             \n",
       "\n",
       "[82 rows x 13 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('Key == \"Subtype\"')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "06215b5a",
   "metadata": {
    "scrolled": true
   },
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>SinceVersion</th>\n",
       "      <th>DeprecatedIn</th>\n",
       "      <th>Required</th>\n",
       "      <th>IndirectReference</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "      <th>PossibleValues</th>\n",
       "      <th>SpecialCase</th>\n",
       "      <th>Link</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>ActionURI</td>\n",
       "      <td>URI</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.1</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>ArrayOfTags</td>\n",
       "      <td>1*</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1525</th>\n",
       "      <td>CIDSystemInfo</td>\n",
       "      <td>Registry</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.2</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1526</th>\n",
       "      <td>CIDSystemInfo</td>\n",
       "      <td>Ordering</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.2</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3251</th>\n",
       "      <td>SoftwareIdentifier</td>\n",
       "      <td>U</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.5</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3395</th>\n",
       "      <td>TimeStampDict</td>\n",
       "      <td>URL</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 237, TimeStamp cell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3408</th>\n",
       "      <td>URLAlias</td>\n",
       "      <td>U</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.3</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3463</th>\n",
       "      <td>WebCaptureCommand</td>\n",
       "      <td>URL</td>\n",
       "      <td>string-ascii</td>\n",
       "      <td>1.3</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Table 393</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Object       Key          Type SinceVersion DeprecatedIn  \\\n",
       "312            ActionURI       URI  string-ascii          1.1                \n",
       "1304         ArrayOfTags        1*  string-ascii          1.2          2.0   \n",
       "1525       CIDSystemInfo  Registry  string-ascii          1.2                \n",
       "1526       CIDSystemInfo  Ordering  string-ascii          1.2                \n",
       "3251  SoftwareIdentifier         U  string-ascii          1.5                \n",
       "3395       TimeStampDict       URL  string-ascii          1.6                \n",
       "3408            URLAlias         U  string-ascii          1.3                \n",
       "3463   WebCaptureCommand       URL  string-ascii          1.3                \n",
       "\n",
       "     Required IndirectReference Inheritable DefaultValue PossibleValues  \\\n",
       "312      TRUE             FALSE       FALSE                               \n",
       "1304     TRUE             FALSE       FALSE                               \n",
       "1525     TRUE             FALSE       FALSE                               \n",
       "1526     TRUE             FALSE       FALSE                               \n",
       "3251     TRUE             FALSE       FALSE                               \n",
       "3395     TRUE             FALSE       FALSE                               \n",
       "3408     TRUE             FALSE       FALSE                               \n",
       "3463     TRUE             FALSE       FALSE                               \n",
       "\n",
       "     SpecialCase Link                       Note  \n",
       "312                                               \n",
       "1304                                              \n",
       "1525                                   Table 114  \n",
       "1526                                              \n",
       "3251                                              \n",
       "3395                   Table 237, TimeStamp cell  \n",
       "3408                                   Table 392  \n",
       "3463                                   Table 393  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('(\"string-ascii\" in Type) and (Required == \"TRUE\")')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9fde8e45",
   "metadata": {},
   "source": [
    "Not many fields are purely numeric. We can get a simple histogram to get a feel of how many new keys were introduced in each PDF version by filtering the \"SinceVersion\" field down to just \"1.x\" and \"2.x\":"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "2e06786f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXkAAAD7CAYAAACPDORaAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy89olMNAAAACXBIWXMAAAsTAAALEwEAmpwYAAA81ElEQVR4nO3deXxb5bkn8N/RYnmV5EXyIiuOLVsJ2feQhjoNhGzGhCbpLQ0lAy0UupAh08klN0tZ2nuTQma47dD0c8vQcktpmRAgJLnBCUsJhUASDCTOJjveJK+yZUuyZEvWcuYPRyaLYluypHN09Hz/SrQ+kuXHR8953+dhWJZlQQghRJBEXAdACCEkeijJE0KIgFGSJ4QQAaMkTwghAkZJnhBCBIySPCGECBgleUIIETAJ1wFcr7fXCb8/9KX72dnpsFgcUYhofPgaF8Df2Ciu0FBcoRFaXCIRg8zMtJtez7sk7/ezYSX5wH35iK9xAfyNjeIKDcUVmkSKi8o1hBAiYJTkCSFEwCjJE0KIgFGSJ4QQAaMkTwghAjbq6prXX38df/nLX4b/39LSgjVr1mDZsmXYtWsX3G43Vq1ahc2bNwMALl68iB07dsDhcGDevHl4+umnIZHwbhEPIYQkhFGP5L/zne/g7bffxttvv409e/YgOzsbDz/8MLZt24a9e/fiyJEjOHfuHI4fPw4A2LJlC3bu3ImjR4+CZVns27cv6i+CCIOxsw+b/8/HuGyych0KIYIRUrnmqaeewubNm2EymVBUVAStVguJRILKykpUVVWhtbUVLpcLs2bNAgCsXbsWVVVV0YibCAzLsnj13VrYnIM4fbGT63AIEYwx11FOnDgBl8uFVatW4fDhw1CpVMPXqdVqdHZ2wmw2X3O5SqVCZ2dov7DZ2ekh3f5qKlVG2PeNJr7GBfAntg+rTahrsUEsYnCpuQffWz6J65CC4sv7dT2KKzSJFNeYk/xrr72GBx98EMDQUdf1GIa56eWhsFgcYe36Uqky0NXVF/L9oo2vcQH8iW3A7cX/PXgORXkZmKBOxxd13eg02yEK8bMTbXx5v65HcYVGaHGJRMyIB8djKtcMDg7i9OnTuP322wEAubm56O7uHr7ebDZDrVbfcHlXVxfUanXIQZPEcvjTJtgcg/j+nXqUFSrhHPCgw9LPdViECMKYkrzBYMDEiRORmpoKAJg5cyYaGxvR3NwMn8+Hw4cPo7y8HBqNBjKZDNXV1QCAAwcOoLy8PHrRk7jX2dOPY6dMWDwtDzqNAjqNHABwudXGcWSECMOYyjUmkwl5eXnD/5fJZNi9ezcee+wxuN1uLFmyBCtXrgQA7NmzBzt27IDT6cSUKVOwcePG6EROBOFv79dBKhFh/bd0AIC8rFRkpEpR32pD+cwCjqMjJP6NKcmvXr0aq1evvuayRYsW4eDBgzfcdvLkydi/f39koiOC9tXlbpytt+CflpZCkS4DMHQOZ1JRFurb7BxHR4gw0I5XwgmP14/X3qtDfnYqls0rvOa6yRMz0dbtRL/Lw1F0hAgHJXnCiWOnjTBbB/C9ZWWQiK/9GE4uygIAOponJAIoyZOY67G7cOhEE2aX5WBacfYN1+snZIJhgHo6+UrIuFGSJzH3+of18PuB795RFvT6FJkEhap0SvKERAAleRJTBmMvTl7oxKqFE6BWptz0dqUaBRra7bwd00ZIvKAkT2LG5/fj1XfrkCWXYfWiohFvq9PIMeD2oa3bGaPoCBEmSvIkZo5/1YaWLge+e3sZZFLxiLfVaRQAgMttVLIhZDwoyZOYcAx48NZHDZg8QYl5k1Sj3l6tTEF6ipTq8iPwsyyOnTaht8/FdSiEx2iaB4mJNz9qwIDbhw136sfUtI5hGJRqFKhvpWWUN9PU3ofX3q+DSCzCsjkarsMhPEVH8iTqmjv6cPzLVtw+R4NC1dhbSes0cnT09MMxQJuigjGYegEA5xstHEdC+IySPIkqlmXx6nu1SEuR4p5vFod039IrdXkq2QRnMFoBAJeae+H1+bkNhvAWJXkSVZ9d6MTlFhvWf0uH1GRpSPedmCeHiGFQTydfb+D3s6hrsUKRlgT3oA/Nnfzrj074gZI8iZoBtxf7/n4ZE/MycNuM/JDvL0sSQ5ubTnX5IExmBwbcPqxYMAEAUGeiP4QkOEryJGoCw0Duu1Mf9pSn0gIFGtrs8PmpHHE1g3GoHr/gFjUKctJQS8PPyU1QkidR0XHdMJBw6TRyuD0+tHbRpqirGUxWqJTJyJInY2pJNuparPAHGb9JCCV5EhWvXTcMJFw6Ovl6Az/LotZkxSRtJgBgSnE2nC4v7Q4mQVGSJxEXGAZy9+Li4WEg4cpRJEORloTLVJcf1tblhNPlxaQJSgDANN1QJ886KtmQICjJk4gaaRhIOBiGgU6joCP5qxiuJPNJWiUAIDcrFcr0pOHLCbkaJXkSUYFhIBuW6W8YBhIunUYOs3UAdudgRB4v3hmMvciWy5BzpYsnwzDQa5Woa7GBpbo8uQ4leRIxVw8DmVqcFbHH1RVcqcvTenmwV+rx+iv1+AC9VonePje6bdTHhlyLkjyJmNc/rAfLAvfeZBhIuCbmZUAsYmi9PIB2Sz/s/Z7henyAvnDo/7SUklyPkjyJiKuHgahGGAYSjiSpGBNyM3CZ6vJf1+OvS/IFqjSkJUsoyZMbUJIn4xYYBpItl2HVrSMPAwmXTiNHU7s94Xu0GIy9UKYn3TBVS8QwKCtUUpInN6AkT8YtlGEg4SrVKDDo9aOlyxGVx48HLMvCYLJi0oTMoO2ay7QKdPYOwOZwcxAd4StK8mRc+voHh4eBzB3DMJBwfd2RMnHr8ubeAdgcg8NLJ6+nv3J5XQuVtcjXKMmTcXnrH40YcPtw3xiHgYQrS56MzAxZQtflb1aPDyjKzUCSVETr5ck1KMmTsA0PA5mrgSaEYSDh0hXIE3pTlMHYC3laEvKyUoNeLxGLoCtQ0M5Xco0xJfkPPvgAa9euxcqVK/GrX/0KAHDixAlUVlZi+fLleP7554dve/HiRaxbtw4rVqzA9u3b4fV6oxM54VRgGEh6qhT33BbaMJBw6TQKdNtcCVlzDtTj9VrliN+Y9FolTGYH+l30e0eGjJrkTSYTnnzySezduxeHDh3ChQsXcPz4cWzbtg179+7FkSNHcO7cORw/fhwAsGXLFuzcuRNHjx4Fy7LYt29f1F8Eib3AMJB1S0IfBhKuQF0+EfvYdNtc6LG7b1qPD9AXKsACuNxqjUVYJA6MmuTfffddrF69Gnl5eZBKpXj++eeRkpKCoqIiaLVaSCQSVFZWoqqqCq2trXC5XJg1axYAYO3ataiqqor2ayAxNt5hIOGakJsBiZhJyJJNYNTfzerxASUaBcQiBrU0RIRcIRntBs3NzZBKpfjhD3+Irq4uLF26FGVlZVCpvl5JoVar0dnZCbPZfM3lKpUKnZ2d0YmccCYwDORna6eHPQwkHFKJCEV5GbicgO0NDKZepCVLUJCTNuLtZFIxJuZloLbFGpvACO+NmuR9Ph8+//xzvPLKK0hNTcVPfvITpKTcuKORYZigzZFCXXGRnR3+CTyVKiPs+0YTX+MCQo+ttcuBd0+bcMd8LW6dOf4ukzdzs7iml6rwX580QpmZBqkk9usGuPpZXm61Y3ppDnLV8qDXXx3XTL0aB/9RD7kyNWr7FsaKr5/9RIpr1CSfk5ODRYsWIStrqOHUHXfcgaqqKojFX394zGYz1Go1cnNz0d3dPXx5V1cX1Gp1SAFZLA74/aF30lOpMtDVxb9hxnyNCwgvtr2vn4FELMJdCydE7XWNFFdBZgo8Xj++ON+OkoLgCS9auPpZ9thd6Ozpx9LZmqDPf31chTmp8PpYnD7bikkTMm+4fazw9bMvtLhEImbEg+NRD4WWLl2Kjz/+GHa7HT6fD//4xz+wcuVKNDY2orm5GT6fD4cPH0Z5eTk0Gg1kMhmqq6sBAAcOHEB5eXnIQRN+CgwDWXPb+IeBhEs3fPI1cUo2w/X4UU66BpQVKsCAmpWRIaMeyc+cORMPPfQQNmzYAI/Hg8WLF+N73/seSkpK8Nhjj8HtdmPJkiVYuXIlAGDPnj3YsWMHnE4npkyZgo0bN0b9RZDo83h9w8NA7pgbvTLNaDIzZMiWy4ZOvs7XchZHLBlMvUiRSaBVj62UmZYshUZFw73JkFGTPACsX78e69evv+ayRYsW4eDBgzfcdvLkydi/f39koiO8cey0CWbrAH7+3VkRGwYSLp1GkXBH8vpCBUSisZ/f0muV+KSmAz6/H2IR7XlMZPTTJ6MKDAOZo1dFdBhIuHQaBXrsbvTYhT8gw+pwo7N3IOTaul6rhNvjg7EzcRu6kSGU5MmohoeB3F7KdSgArmpW1ib8TVFjXR9/vTIaIkKuoCRPRnT1MJCcCA8DCZdWnQ6pRJQQm6IMJiuSk8SYkBva0uLMDBnUyhRK8oSSPLm5WAwDCYdELMLEvIzESPLGXpQWKsKqq5dpFahrscFPw70TGiV5clOxGAYSrlKNAs2dffB4fVyHEjV25yDaLf1jXjp5PX2hEo4BD9ot/ZENjMQVSvIkqMAwkFuKMqM6DCRcOo0CXh+L5g7hnlisHe4fH96GJv2VOj61Hk5slORJUIFhIBuWlUV1GEi4EmFTlMFoRZJ0qDQVDrUyBYq0JKrLJzhK8uQGsR4GEg5FWhJyFMmoF3CzMoOpF6UaRdj7EhiGgV6rpGZlCY6SPLkGF8NAwlVaqEB9qy1oY7x45xjwoKXLGXY9PkCvVaLH7ka3bSAygZG4Q0meXCMwDGR9DIeBhEtXoIDVMQiLADdFjbceH1BWqLjm8UjioSRPhgWGgRTnZ2BxDIeBhGt4U5QAJ0UZjFZIJSIU54+v02ahKh2pMgkNEUlglOTJsMAwkA136mM6DCRcheo0JEmFuSnKYOqFrkA+7p75IhGD0kIFHcknMEryBADQ0dOPY6dMWDw9D7oCBdfhjIlYJEJJvlxwJ1/7XV6YOh3Qj7MeH6DXKtHR0w+7czAij0fiCyV5ApZl8bf36pAkFWH9t/jRn2asdBoFjJ0ODHqEsymqrsUKFuOvxwcE/ljU0SqbhERJnuBMvQU1DRasWVwMRVoS1+GERFeggM/PoqmDf5N+wmUwWSERM9BFaPLVxLwMJElEMFDJJiFRkk9wVw8DuZ3DYSDhKtEMJUIh1eUNRiuK8+VIilArCYlYhJICOero5GtCoiSf4ALDQDbcqed8GEg45KlJyM1MEczO1wG3F80dfSG3Fh6NXquE0dyHAbc3oo9L+C/+fqtJxHRbB3DoRBPm6lWYOpH7YSDh0mmEsymqvnWoa+QkbWQHcJdplWBZYbeBIMFRkk9gfzp0HiwLfJcnw0DCpdMoYO/3oMsW/5uiDCYrxCJmeA9ApOgK5BAxDC2lTECU5BOUwdiLj75q5dUwkHAFTlAKoS5vMFoxMS8DsqTItnZOTpKgKC+DOlImIEryCSgwDESVmcKrYSDhKlSlQ5Ykjvsk7/b40NhuH24RHGl6rQIN7XZB9+AnN6Ikn4BqGnrQ0uXAgxVTeTcMJBwiEYOSfHnc15vrW23w+SNfjw/Qa5Xw+lg0tgtnuSkZHSX5BFRTb4EsSYxbp+dxHUrE6DQKtJidcA/G71GqwWgFw3zdVCzSaLh3YqIkn2BYlsXZegumFGVCKon/o/iAUo0cfpZFY3v8NiszmKwoys1AikwSlcdPT5FCk5NGST7BUJJPMO2WfljsLkzXZXMdSkSVFMT3pCiP14eGNnvE+tXcjF6rxOVWG3x+f1Sfh/AHJfkEc7beAgCYUSKsJJ+eIkV+dmrcnnxtaLPD6/NHfBPU9cq0CrgGfTCZhTsbl1yLknyCqWmwQKNKQ5Y8metQIk5XoEB9mz0uN0UZjFYwQPSP5Ifr8vH5x5CEjpJ8Ahlwe1FrsgruKD5Ap5HDMeCBuTf+Rt0ZTFYUqtORFuVpXFnyZOQokmm9fAIZ0xmejRs3wmKxQCIZuvkzzzwDo9GI3//+9/B4PHjggQdw3333AQBOnDiBXbt2we12Y9WqVdi8eXP0oichudjcC5+fxXSBJvnALtHLrTbkZqVyHM3YeX1+1LfaUD6zICbPp9cqUdNgAcuyYOJgOAwZn1GTPMuyaGhowIcffjic5Ds7O7F582a8+eabSEpKwr333ouFCxeisLAQ27ZtwyuvvIL8/Hw88sgjOH78OJYsWRL1F0JGd7beguQkMUqjtESPa/k5aUiRSVDfasPi6fwfXxjQ2G7HoDf69fgAvVaJE+c60NHTj/zstJg8J+HOqEm+oaEBDMPg4YcfhsViwT/90z8hLS0Nt956K5RKJQBgxYoVqKqqwoIFC1BUVAStVgsAqKysRFVVFSV5HmBZFjUNFkwtzorLbpNjIWIYlBTIcTnOZr4ajFYA0a/HBwSep9ZkpSSfAEb9bbfb7Vi0aBF+97vf4eWXX8Zrr72GtrY2qFSq4duo1Wp0dnbCbDYHvZxwr7XLid4+t2BLNQG6Ajlaux1x1VLXYLJCk5OGjNTYDGzJzUyBPFVK6+UTxKhH8rNnz8bs2bMBAKmpqVi/fj127dqFRx999JrbMQwTdFVDqDW/7Oz0kG5/NZUqI+z7RhMf4jpe0wEA+Nb8CchWfN2QjA+xBRNuXHOn5uPgJ03o6fdgVmHk2wNE+v0K1ONvn6cd12OHet/ppSrUmXqj/vMX2ucr2qIR16hJ/vPPP4fH48GiRYsADH3t12g06O7uHr6N2WyGWq1Gbm5u0MtDYbE44PeHvgROpcpAVxf/enLwJa7PzrZhgjod/kHvcDx8ie1644krO1UKBkD1hQ5oMiPbXTMa71d9mw2uQR8mqNLCfuxw4pqgTsMnZ9tw6XIXshXRWU4rxM9XNIUbl0jEjHhwPGq5pq+vD88++yzcbjccDgfeeustPPfcc/j000/R09ODgYEBHDt2DOXl5Zg5cyYaGxvR3NwMn8+Hw4cPo7y8POSgSWT1u7yoa7EJbpdrMKnJEhTkpKE+TurytVfq8ZNiVI8PGF4vT8O9BW/UI/mlS5fizJkzuOeee+D3+7FhwwbMnTsXmzdvxsaNG+HxeLB+/XrMmDEDALB792489thjcLvdWLJkCVauXBn1F0FGdqGpB35WuEsnr6fTyFFt6IKfZSHi+RJBg8mKvKxUKNJlMX1erTodKTIx6kxWLJoqnEZ15EZjWif/+OOP4/HHH7/mssrKSlRWVt5w20WLFuHgwYMRCY5ExtkGC1JlEuiuDL0WOp1GgY/OtKPD0o+CHP6uHvH7WdS1WLHgltyYP7dIxKBUo4SBTr4KnjDX0pFhVy+dFIsS48cd2BTF9z42Q4O1fTEv1QTotQq0W/rR1z/IyfOT2EiM3/oEZjI7YHMMYkYC1OMDcrNSkZYsQX0bv5N8YH38pAnRGRIymsB6+boWfr9PZHwoyQtcoOvktASpxwOBTVEK3p98NRitUCtTkJkR23p8wMQ8OSRiEa2XFzhK8gJ3tsGCorwMKNJis9GGL0o1crR2O9Hv8nAdSlB+dqgeH615rmMhlYhQUiCnJC9wlOQFzOnyoL7VJtiukyPRXanLN7Tx82i+xeyA0+XlrB4foNcqYeyMrx3CJDSU5AXsfGMPWBYJsT7+esX5cjAMfydFBVa1xKop2c3otQr4WZb35y9I+CjJC1hNvQVpyRKU5CfG0smrpcgk0OSko56nR/K1Riuy5cnIUUR2V26odAUKMAwNEREySvIC5b+ydHJ6STZEIn5vCIqW0kIFGtps8PNsUhTLsjCYrJwfxQNDfwyLcjNoiIiAUZIXqOaOPtj7PQmzyzUYXYEcA24f2rqdXIdyjTZLPxwDHs7r8QF6rRL1bXZ4vDTcW4goyQtUTYMFDICpJVlch8IZvm6KqjX2AuC+Hh+g1yrh9fnR1MHP0hYZH0ryAlVTb0FxgRzyGPUo5yN1ZgrSU6S8Wy9vMFmRmSGDSsltPT6g7MqkMFpKKUyU5AWor38QDW32hC7VAEOzDEo1Cl6tsGFZFgajFZO0St7MV81ITUJ+diqdfBUoSvICdL6xByyQUK0MbkankaOjZ6gGzgedvQOwOQc53QQVzCStEpdbrWHNciD8RklegM42WJCRKkVRHj+n38SSriCwKYofR6mGQD2eJyddA8q0Sgy4fTCZHVyHQiKMkrzA+P0szjX0YFpxNu97qcdCcb4cIobhzXBvg8kKeVoS8rJSuQ7lGjRERLgoyQtMY4cdjgEPlWqukCWJoVWn82KFDR/r8QHZimRky5NpvbwAUZIXmJp6CxgGmFqcuEsnr6fTyNHQbue83txlc6G3z82bpZPX02sVqDVZwfJs8xgZH0ryAlPTYIGuQIH0FCnXofCGTqOAe9CHli5u682BeryeZ/X4gDKtEvZ+Dzp7B7gOhUQQJXkBsTkH0djel5ANyUYS6EjJdR+bWqMV6SlS3o4kDJwMpvXywkJJXkDONQwNCEnE1sIjUSmSIU9LwmWOJyAZTFbotUrenhDPy0pFRqqUkrzAUJIXkJoGCxRpSdDmpnMdCq8wDANdgZzTdroWmwvdNhfvlk5ejWEYlBUqKckLDCV5gfD5/Tjf2INpJVm8PVLkUqlGAXPvAOwcDa02mPjVr+Zm9Folum0u9NhdXIdCIoSSvEA0tNnhdHkxQ5fDdSi8NDwpiqP18gajFakyCQpV/P6Wpdde6WND6+UFg5K8QNQ0WCBiGEydmMl1KLw0MS8DYhHDWR+b4Xo8z3v7a9XpSE4So4762AgGJXmBOFtvQalGjtRkWjoZTJJUjAm53GyK6u1zw9w7wNulk1cTi0Qo1SioLi8glOQFwOpww9jpoKWTo9AVKNDYYYfPH9vhGPFSjw8o0yrR2u3kTVM3Mj6U5AWgJrB0kurxI9JpFBj0+NFiju2kqFqjFclJQ98k4kFgBVAd1eUFgZK8ANTUW5CZIUOhip+bbPgiMCkq1nV5g8mKskIlxKL4+HUrzs+ARMxQyUYgxvyp+/Wvf42tW7cCAC5evIh169ZhxYoV2L59O7xeLwCgra0N9913H1auXIkf//jHcDr5NVtTiLw+P8439WJ6SRbvml7xTZZcBmV6Ukzr8jbnINot/XFTqgEAqUSM4nw5DRERiDEl+U8//RRvvfXW8P+3bNmCnTt34ujRo2BZFvv27QMAPP3009iwYQOqqqowbdo07N27NzpRk2H1rTYMuL2YXkKlmtEwDANdjCdFBY6G+bwJKhi9VgljZx9cg16uQyHjNGqSt1qteP755/Hoo48CAFpbW+FyuTBr1iwAwNq1a1FVVQWPx4PTp09jxYoV11xOoutsgwViEYMptHRyTHQFCnTbXLA53DF5PoOxFzKpOO4GuOi1Svj8LOf9fsj4SUa7wS9+8Qts3rwZ7e3tAACz2QyVSjV8vUqlQmdnJ3p7e5Geng6JRHLN5aHKzg7/5JRKxc9fpGjGdbHZiqkl2ZhQGF6ST7T3bP60fOz7+2V0OQZRWhz6t59Q46pvs+OW4izk5ylCfq5QRPr9ujUjGaLXz6DVMoBvzQ//sRPt8zVe0YhrxCT/+uuvIz8/H4sWLcKbb74JAEF7TTMMc9PLQ2WxOMLq+61SZaCrqy/k+0VbNOPqsbvQ1G7Hd5bqwnqORHzP5DIxJGIGX1zsRGmIR9ehxtXXP4jmjj7M0aui+j5H6/3SqjPwlaETy+dqwrp/In6+wuX1+ZGfpwgrLpGIGfHgeMQkf+TIEXR1dWHNmjWw2Wzo7+8HwzDo7u4evk1XVxfUajWysrLgcDjg8/kgFouHLyfRU0NdJ0MmlYhQlJsRk5OvgROX8VaPDyjTKnD8qzZ4fX5IxPGxMigeDbi9+MVLJ/H9VVMwszjyZdcRf3J/+tOfcPjwYbz99tvYtGkTbr/9duzatQsymQzV1dUAgAMHDqC8vBxSqRTz5s3DkSNHrrmcRE9NQw+y5TLe9ifnK51GgaaOPnh90d0UZTD1QioRoThfHtXniZZJWiU8Xj+aOvh11Cs0H59th8Xujlr32LD+PO/Zswe7du3CqlWrMDAwgI0bNwIAnnzySezbtw+rV6/G559/jscffzySsZKrDC2d7MH0kmxaOhmiUo0CHq8fxs7oToqqNVqhK5BDKonPo+CyK8O9ae5r9Pj8fhw7bUJZoQKTiqIzsnPUE68Ba9euxdq1awEAkydPxv79+2+4jUajwSuvvBK56MhN1bXY4B70USuDMAxPimq1oaQgOkfZTpcHJrMDd99WHJXHjwV5WhLyslJhMFmx6tYirsMRpGpDFyx2FzYsK4vac8TnIQZBTb0FEjGDW4po6WSoMjNkyJLLojpEpM5kA4v4rccH6LVK1LXYOB+CLkQsy+Kdk0bkZqViZln09rlQko9TZxss0GuVSE4a85cxchVdgSKqJ18Npl5IxEzUvinEil6rwIDby/kQdCEyGK1o7ujDigXaqA76oSQfh7ptA2jrdtKqmnEo1ShgsbvR2xedTVEGoxUl+XIkScVRefxY0Qfq8hzPxxWiqlNGZKRK8Y2peVF9HkrycaimoQcAqB4/DlfX5SNtwO1Fc2cf9BPiv5SWrUhGllxGzcoirLXbibP1FtwxtzDqBwKU5ONQTb0FOYpk5GWlch1K3JqQmw6pRBSVPjaXW21g2fjpHz8ShmGgvzLcO9iGRxKeo6eMSJKIsHR2eBvNQkFJPs54vH5caO7BDB0tnRwPiViEoryMqJx8NRitEIsYlBZEt5VBrJRplbA5B2G2DnAdiiBYHW58dr4Di2fkIyM1KerPR0k+ztSarBj0+DGd6vHjVqpRoLmjDx5vZDdFGUy9mJifAVlSfNfjAwJjC6lkExnvV7fA52OxfL42Js9HST7OnK23QCIWYTItnRw3XYECXh+L5s7I7eh0D/rQ1N6HSVrh/HwKslORniKlJB8BrkEvPvyyFXMmqZCbGZtyKyX5OFPTYMHkIiVkcb5qgw9KNUPLGyN58vVymw0+PyuIenwAwzAoK1SgjoaIjNs/zrbD6fJi5YIJMXtOSvJxxGwdQEdPP5VqIkSRLkOOIjmiSd5gtIJhvh41KBR6rRJm60DUlpwmAp/fj3dPm1BaqBhe3RULlOTjSE19YGA3JflIKb0yKSpSK0dqjb0oys1AikxYm9T0NNx73KoNXei2uWJ6FA9Qko8rNQ0W5GamxKyWlwh0GgWsjkH02Md/hDro8aGh3S6oUk3AhNx0yKRiqsuHiWVZVJ00IjczBbOi2MIgGErycWLQ48PF5l4q1USYLlCXj8BSyoY2O7w+VlAnXQPEIhFKNXJK8mGqNVnR1NGHFQsmRLWFQTCU5OOEwWSFx+unUk2EFarSkRShTVEGkxUMhvq9CFGZVonWLiecLg/XocSdqpNGpKdI8Y1p0W1hEAwl+Thxtt6CJIlIkKUALknEQ0M9InHy1WDshVadjtRkaQQi459JWiVYUB+bULV1O3EmRi0MgqEkHydq6i2YXJQJqYSWTkaaTqOAsdOBQY8v7MfweP2ob7NDL+A/wsX5cohFDJVsQnT0lBFSiQi3z4l+C4NgKMnHgc6efpitA1SqiRKdRg6fnx3XmLvGdjs8Xr8g6/EBSVIxivPlNCkqBDaHG5+e78Bt02PTwiAYSvJx4OyVpZN00jU6dFd6zIzn5KvhSuITaj0+QK9VoqmjD+5xfOtJJO9/EdsWBsFQko8DNQ0W5GenQqVM4ToUQZKnJUGdmYLL46g11xp7oVGlcXa0Fit6rQI+P4uGKA5cEQr3oA9//6IVc/Qq5HLYMZaSPM+5B324ZLTSUXyU6QoUqG+zh7Upyuvz43KrPe5H/Y1FqUYBBkAtnXwd1T/OtsHp8mLFwthufroeJXmeu2jshdfnpwEhUVaqkcPuHES3zRXyfZuvlC8mCWBIyGhSk6XQqtPp5OsofH4/jp02oVSj4LzFBSV5nqtpsEAmFQ+PYSPRMZ5JUV/X45URjIi/yrRK1LfZ4PVFtkWzkHxR241umwsrYtzCIBhK8jzGsixq6i2YMjETUgn9qKJJo0qDLEkc1qYog9GK/OxUKNKEXY8P0GuVGPT4I9qiWUiGWhg0IzczBbNj3MIgGMocPNZu6Ue3zUX1+BgQi0QoyZejvtUe0v18fj/qWqwJUY8P0BcOfeuh1sPB1ZqsaGzvw/IFEyAScT+9jZI8j9U00NLJWNJp5DCZHXAPjn15oLHTAdegT9CboK6nSJchNzOF6vI3cfSUibMWBsFQkuexs/UWaHLSkK1I5jqUhKArUMDPsmjqGPvRvMFoBQBBb4IKRq9Voq7FCj8N975Gu8WJry534/Y5Gt4M9qEkz1MDbi9qTVZaVRNDgZOvodTla01WqDNTkJkhi1ZYvKTXKuF0edHW5eQ6FF45eso01MJgbiHXoQyjJM9Tl5p74fOzmEGlmphJT5EiLyt1zHV5v59FrSmx6vEBZYHh3jREZJjNOYgT5zqweHo+5DzaFDemJP+b3/wGq1evRkVFBf70pz8BAE6cOIHKykosX74czz///PBtL168iHXr1mHFihXYvn07vF5vdCIXuLMNFiQniVFaKOxt8nyj08jHPCmqpcuBfrc3ITuDqhTJyMyQUV3+Ku9Xt8Dn83PawiCYUZP8qVOn8Nlnn+HgwYN444038Morr+DSpUvYtm0b9u7diyNHjuDcuXM4fvw4AGDLli3YuXMnjh49CpZlsW/fvqi/CKFhWRY1DRZMnZgFiZi+bMWSTqOAY8ADs3Vg1Nsmaj0e+Hq4d63JGrHRifFsqIVBC2aV5SCPwxYGwYyaQRYsWIA///nPkEgksFgs8Pl8sNvtKCoqglarhUQiQWVlJaqqqtDa2gqXy4VZs2YBANauXYuqqqpovwbBae12osfupno8BwK7E8fSx8ZgsiJHkZywJ8b1WiWsjkF0hbFLWGg+rmmH0+XFqoVFXIdygzFNG5ZKpfjtb3+LP/7xj1i5ciXMZjNUKtXw9Wq1Gp2dnTdcrlKp0NnZGVJA2dnpId3+aipVRtj3jaZQ4/qopgMA8K35E5CtiG5TMqG8Z5GSnZ2O1GQJ2noGgsYQuMzvZ1HXYsP8Kbm8eA+5iOHWGRr85VgtOqwuTC1TB70NH96bYCIZl8/P4v0vWjC5KBOLZo/vhGs03q8xj5TftGkTHn74YTz66KNoamq64XqGYYJ+bWNCnGdosTjg94f+9U+lykBXF/924IUT12c1bdCq0+Ef9Eb1NQnpPYuk4rwMnKvvviGGq+Nq6XKgr38QReo0zt9Drt6vZDGQlizB5xc6MGPijSUrrn+ONxPpuD6/ZEaHpR/rykvG9bjhxiUSMSMeHI9arqmvr8fFixcBACkpKVi+fDlOnjyJ7u7u4duYzWao1Wrk5uZec3lXVxfU6uB/4Ulw/S4v6lpstAGKQzqNAi1dDgy4b75oYLgenwBNyW5GxDAoK1Qm9BARlmXxzkkj1JkpmF2mGv0OHBg1ybe0tGDHjh0YHBzE4OAg3n//fdx7771obGxEc3MzfD4fDh8+jPLycmg0GshkMlRXVwMADhw4gPLy8qi/CCG50NQztHSS6vGcKdUowLJD055uxmCyIjNDBlWC1uMD9FolOnsHYHO4uQ6FE3UtNjS227FivpYXLQyCGbVcs2TJEpw5cwb33HMPxGIxli9fjoqKCmRlZeGxxx6D2+3GkiVLsHLlSgDAnj17sGPHDjidTkyZMgUbN26M+osQkpoGC1JkEug0cq5DSVglBUPvfX2rDVMmZt1wPcsOrY+fMjEz5HKk0JRdmYRV22LD/MmJ96296qRxqIXB9HyuQ7mpMdXkN23ahE2bNl1z2aJFi3Dw4MEbbjt58mTs378/MtElmOGlk8VZEIto6SRXUpOlKMhJQ31b8CP5jp5+2J2DCbkJ6npFuRlIkopQa7ImXJIPtDC4e/FE3rQwCIYyCY+YzA5YHYO0y5UHdAVy1LfagvZmCfSPT+R6fIBELIKuQJGQm6KOnb7SwmAOf1oYBENJnke+7jp5Y4mAxFapRgGny4vOnv4brqs1WqFIS0JuJs3cBYbq8i1mB/pdHq5DiRmbcxCf1HRg8bQ8yHk+R4CSPI+crbegKDcDivTEanbFRzdrVsayLAwmKyZNUCZ8PT5Ar1WCRWiN3eLdB1daGNzJsxYGwVCS5wmny4P6VjvtcuWJvOxUpMokNzQr67IOoLfPnTCj/saipEAOsYgZLmMJndvjwwdXWhjkZ6dxHc6oKMnzxPnGHvhZWjrJFyKGQYlGjvq2a49Ov+5Xo4x9UDwlk4oxMS8jYSZFfXKlhcHKhdzPbx0LSvI8UVNvQVqyBCX5tHSSL0o1CrR1OdHv+npTlMFkRXrK0Oob8jW9VonGdjsGPWOfqhWP/H4Wx06ZoCuQD/c54jtK8jzgZ1nUNPZgWkk2bzdUJCKdRgEWQEP710eoBuNQ/3iqx1+rTKuEz8+i4SbLToXii9oumK0DWLFgQtx8BijJ84Cxsw925yCtquGZknw5GGC4Lm/u6YfF7kqoea5jVVaoAANhDxFhWRZVp4xQK1MwR8/PFgbBUJLngbP1FjAAphVTPZ5PUmQSaFRpqL+yauRcw1BfJqrH3ygtWQqNKl3QfWwut9rQ0GbH8gX8bWEQDCV5HqhpsGBivpz3620TUalGgfo2O/wsi3NXzpsUqsNvhy1keq0Cl1vt8Pn9XIcSFYEWBot53MIgGEryHHMMeNDQaqdSDU/pNAoMuL1o73biXL0FZYVKiOKkFhtreq0Sbo8Pxk4H16FEXLvFia/qurF0tobXLQyCoSTPsXONFrAAZuhyuA6FBBHYFPW5oQvtFmdCznMdq7JCJQAIssXBu6dNEItFuGMuv1sYBENJnmM19RZkpEoxMZ+fE3QSXW5mCtJTpHi/ugUAKMmPIDNDBrUyRXBJ3u4cxCfnOrB4Ov9bGARDSZ5DfpZFTUMPphVnUQmApxiGga5ADseAB6nJEkxQ0x/jkei1StS1BG/sFq8++KIFHq8fy+OghUEwgkjy/S4P/lJ1Eb198TW4oKm9D44BD7Uy4LlAyWZKMe1jGE2ZVgHHgAft3U6uQ4mIoRYGrZhVGh8tDIIRRJJ3DHhw4Hg9nvzjKXxV1z36HXjibH03GIaWTvJdIMlPoxbQowr09KltEUaLgxM17XAMeOKmhUEwgkjy6sxUPP/4EmRlyPDbN87i1Xdr4fHyf3t1TYMFJQVypKdIuQ6FjECvVeDb3yzGsgXx+4seK2plChTpSYJYL+/3szh62oSSAjnKCuOjhUEwgkjyAKDNzcD2jfNw5zwt3q9uwS//sxqtPP7KaHcOoqm9jwaExAGxSITKxcXUAnoMGIaBvlAJg8kKNs7r8l/WdcHcO4CVcdTCIBjBJHkAkEpE+N6yMjz+nRmwOd345cun8eFXrbz8sAWWTlI9ngiNXqtEb58b5t4BrkMZl6pTRqiUyXHVwiAYQSX5gBm6HDz9gwUoLVTgz1UG7H3rHBwD/Jpac7beAnlaEibk0moNIiyBuvyB45fh8cbn7tfLLTbUt9qxfP6EuD/ZLsgkDwDKdBn+x3dn4TtLdfjqcjee/OMpGIy9XIcFYKjWd76xB9NLaOkkER6NKg2Lpubh8MeNeOpP/Pm9C0XVKSPSkiW4Lc5aGAQj2CQPDA1+WLWwCNvunwupWIRn//YlDvyjgfPeGg1tdjhdXkynejwRIBHD4OHKKXjyoVvh8frx679+iZcOX4C9f5Dr0Mako6cfX9Z2YemcQsiS4quFQTCCTvIBxflyPPngfCyamoeDnzTh13/9Et027uqFZxssEDEMphZTvxoiXPNuycUvH1qIikVF+OxCJ7b/4TN8dKaN9xuljsVxC4NgEiLJA0NtYx+6awoerpyCFrMDT/7xNE5fMnMSS029BaUaOdKSaekkETaZVIx1S3R46gcLoFGl4+V3LmH3X75Ai5mfTczs/YP4pKYd35iWB0UctjAIJmGSfMCiqXl46sH5yMtKxe8PnMPL71yEezB2a+ptDjeaO/toVQ1JKJqcNDyxYTZ+WHELOnr68fTLp/H63y/H9HdvLD6oHmphsGJBfLYwCEbCdQBcUGem4l++PwcH/tGIdz5rRl2LDY/cPTUmK11qGnoAgOrxJOEwDIPF0/MxszQHr//9Mt45acSpi524785JmFXGfRdWIbQwCCbhjuQDJGIR1n9Lh5/fOwv9bi9+9efP8e7npqivqT/bYIEyPQlaGjxBElR6ihQPrr4FW++bg+QkCX77xlm88GYNeuwuTuM6ca4j7lsYBDOmJP/CCy+goqICFRUVePbZZwEAJ06cQGVlJZYvX47nn39++LYXL17EunXrsGLFCmzfvh1er/dmD8sLUyZm4ekfLMDUiVn423t1+M3+s1FbBeDz+68sncyO6x10hESCXqvEkw/Ox3e+pcO5Bgu2v3gSR08ZOVn95vezOHbKiOL8+G5hEMyoSf7EiRP4+OOP8dZbb+HAgQM4f/48Dh8+jG3btmHv3r04cuQIzp07h+PHjwMAtmzZgp07d+Lo0aNgWRb79u2L+osYL3lqEjatn4H77tTjQlMvnnzpFM439UT8eepb7RhwezGD6vGEABj6Rr3q1iL86qGFmDRBif/3wWU88/Lnw3N1Y+XLum509g5g5cL4bmEQzKhJXqVSYevWrUhKSoJUKoVOp0NTUxOKioqg1WohkUhQWVmJqqoqtLa2wuVyYdasWQCAtWvXoqqqKtqvISIYhsEdcwux87/NQ2qyBP/7ta/w+oeX4fVF7qjibL0FYhGDKRNp6SQhV8tRpuC/r5+Bn357OhwDHvzbK9X4c9UlOF2x2al+9JQROYpkzNFzf24g0kZN8mVlZcNJu6mpCUeOHAHDMFCpvu7noFar0dnZCbPZfM3lKpUKnZ2dkY86irTqdPzigfkon1WAdz4zYtdfqmHu7Y/IY9c0WFBWqECKLCHPdxMyIoZhMHeSCr96aCHunK/F8TNt2P6Hz/Dp+Y6oniu73GLD5VYbViyYALFIeKcpx5xt6urq8Mgjj+CJJ56ARCJBY2PjNdczDBP0BxHqV5/s7PBPSKpUkVsd8z/vn49FM9vwf/Z9hadfPo0fr5uJpXPDW1alUmXAYhuAyezAg3dNiWic48WnWK5GcYVGaHE9dm8mVt9Wgr1vnMGLhy7g1CUzfrxuJjSqyCxYuDquF//rItJTpLhnaRmSOT4Ai8bPcUyvqLq6Gps2bcK2bdtQUVGBU6dOobv76+EcZrMZarUaubm511ze1dUFtVodUkAWiwN+f+h/tVWqDHR19YV8v5Ho8zPw1APz8eKh8/jff/0Cn55pxfeXTwrpSDwQ10dn2gAAxbnpEY8zXNF4zyKB4gqNUOOSy8T453tn4/iZNuz/sB4/e+4DrL61CBWLiiCVhN9u4Oq4Onv68VlNOyq+UYQ++wC4fBfDfb9EImbEg+NRv5u0t7fjpz/9Kfbs2YOKigoAwMyZM9HY2Ijm5mb4fD4cPnwY5eXl0Gg0kMlkqK6uBgAcOHAA5eXlIQfNJ9mKZGzZMBtrbivGZxc68fSfTqOx3R7y49TUW5All0GTI5z1t4REm0jEYOlsDf7t4YWYN0mNg580YedLp3C+MTILI4ZaGDC4Y44wWhgEM+oh6UsvvQS3243du3cPX3bvvfdi9+7deOyxx+B2u7FkyRKsXLkSALBnzx7s2LEDTqcTU6ZMwcaNG6MXfYyIRSKsua0YtxRl4sVD5/Fvr1RjbXkJViycMKYukl6fH+eberBwSq7gztwTEguKdBl+dPdULJ6Rj78cNeB//b+vsHBKLu69vTTsYS72/kF8HGhhIOCBMAzLs4kafCrXBON0efCf71zC54YuTJmYiYfumgLlCB8QlSoDH31uxHN/+xKPrZ2O2TwaQCDUr/nRQnGFJlpxebw+/NenzTjyWTOkEjHWLynBklmaMfd9D8R18ONGHPi4Eb96aCEKePANm7NyDblWWrIUP75nGh5YNRmXW2z4xUuncObyyMPDaxqGlk7eMjEzRlESIlxSiRj3fLMEz/xwISbmZeCVY7X411eq0dwx9gQ56PHh/S9aMFOXzYsEH02U5MPAMAzKZxbgFw/MR2aGDL/ZfxZ/HWF4eE29BXqtEslJtHSSkEjJy0rF/7x3Fn5UOQUW2wCe+c/TeO39Ogy4R99lf+JcB/r6hdfCIBjKOuNQkJOGHRvn4vW/1+O96hYYTFY8cvfUa44MzL39aO124rYZ8T9hhhC+YRgGt07Nw3RdNt443oB3T5tw+pIZG5aVYY5eFfQcmN/P4ugpI4rzM4ZHFQoZHcmPk1QixoY79fjv62egt8+NZ14+jY/OtA3vGai+0rOeWhkQEj1pyVJsXDEJ2+6fi/QUKX731jn8dv9ZdFtvHA506kIHOnsHsGKB8FoYBENJPkJmlubgmR8ugE6jwMvvXMLvD5yD0+VB9cVO5CiSkZeVynWIhAieTqPALx6Yh3tvL8UloxU7/u9JHPms+Zr2JG/+/TJyFMmYO4k/iyCiico1EaRMl+Hn985C1Ukj3vqoAY3tp+BwefGNaXkJccRACB+IRSIsXzAB8yar8df36rD/w3p8eq4D96+YBJGIwcWmHnxvWZkgWxgEQ0k+wkQMg9W3FmHyhEz84eB5uAd9mEEDQgiJuSx5Mn62djq+quvGq+/WYverX0CZnoT0FCm+mUDnyCjJR0lJwdDw8DarCyVqYS/RIoTPZpXl4JaiTBw80Yhjp0z47jJ9Qq10S5xXyoEUmQS3Tsvn5UYVQhKJLEmM73yrFKtvLcIETSYsFn4OEo+GxChKEUIIhlbhjHVnrFBQkieEEAGjJE8IIQJGSZ4QQgSMkjwhhAgYJXlCCBEwSvKEECJgvFsnP57lTXxdGsXXuAD+xkZxhYbiCo2Q4hrtPrybDEUIISRyqFxDCCECRkmeEEIEjJI8IYQIGCV5QggRMEryhBAiYJTkCSFEwCjJE0KIgFGSJ4QQAaMkTwghAhaXSd7hcOCuu+5CS0vLDdddvHgR69atw4oVK7B9+3Z4vV5exBXwxBNP4M0334xZTMDIcb333ntYs2YN7r77bvzkJz+BzWbjRVzvvvsuKisrUVFRga1bt2JwcJAXcQV8+OGHuP3222MWEzByXC+88AKWLl2KNWvWYM2aNXj11Vd5EVdDQwPuv/9+3H333fjhD3/Ii8/XxYsXh9+nNWvW4Jvf/CbuuuuumMT0wgsvoKKiAhUVFXj22WdvuD4q+YuNM1999RV71113sVOnTmVNJtMN11dUVLBffvkly7Is+y//8i/sq6++you4Ojo62EceeYSdMWMG+8Ybb8QkptHi6uvrYxcvXsx2dHSwLMuy//7v/87+8pe/5Dwup9PJ3nbbbWxXVxfLsiz7+OOPs6+99hrncQV0dXWxK1euZJcuXRqTmMYS1yOPPMJ+8cUXMYtnLHH5/X52+fLl7PHjx1mWZdnnnnuOffbZZzmP62r9/f1sRUUFe/r06ajH9Mknn7Df/e53WbfbzQ4ODrIbN25kjx07ds1topG/4u5Ift++fXjyySehVqtvuK61tRUulwuzZs0CAKxduxZVVVWcxwUAhw4dwh133IFVq1bFJJ6xxOXxePDUU08hNzcXADBp0iS0t7dzHldqaio++OAD5OTkoL+/HxaLBXK5nPO4Anbs2IGf/exnMYknYLS4zp07hxdffBGVlZV45pln4Ha7OY/r/PnzSE1NRXl5OQDg0UcfxX333cd5XFf7j//4D8yfPx/z5s2LekwqlQpbt25FUlISpFIpdDod2trahq+PVv7iXRfK0fzrv/7rTa8zm81QqVTD/1epVOjs7IxFWCPGBQAPPfQQAKC6ujoW4QwbKa7MzEwsW7YMAOByufCHP/wB999/P+dxAYBUKsXx48fxz//8z1Cr1bjtttt4Edef//xnTJkyBTNnzoxJPAEjxeV0OnHLLbfgiSeegEajwdatW7F3715s3ryZ07iMRiNycnLwxBNP4MKFC9Dr9di5c2fUYxotrgC73Y59+/bh0KFDMYgIKCsrG/53U1MTjhw5gtdee234smjlr7g7kh8JG6ShJsPws6Uon/T19eHhhx/G5MmT8e1vf5vrcIYtWbIEJ0+exNKlS/HUU09xHQ5qa2tx7Ngx/OQnP+E6lGukpaXhxRdfRFFRESQSCX7wgx/g+PHjXIcFr9eLU6dO4fvf/z4OHToErVaL3bt3cx3WsEOHDmHZsmXIzs6O6fPW1dXhBz/4AZ544glMnDhx+PJo5S9BJfnc3Fx0d3cP/7+rq2vUr2uJzmw2Y8OGDZg8efKYjn5iwWq14uOPPx7+f2VlJQwGA4cRDamqqkJXVxfWrVuHH/3oR8PvHdfa2tqwf//+4f+zLAuJhPsv6SqVCkVFRZg+fToA4K677sLZs2c5jupr7733HlavXh3T56yursYDDzyAn//85zccUEUrfwkqyWs0GshksuGSyIEDB4brgeRGPp8Pjz76KFatWoXt27fz5lsPy7LYsmXLcL3ynXfewZw5cziOCti0aROOHj2Kt99+G3/4wx+gVqvx17/+leuwkJycjOeeew4mkwksy+LVV1/FnXfeyXVYmD17Nnp6enDp0iUAwAcffICpU6dyHNUQlmVx/vx5zJ49O2bP2d7ejp/+9KfYs2cPKioqbrg+WvlLEEn+4YcfRk1NDQBgz5492LVrF1atWoWBgQFs3LiRF3HxSSCuDz74ABcuXMDRo0eHl5Nt376d87gyMzPxy1/+Eo888gjuvvtuNDU1YcuWLZzHxTeBuLKysvDMM8/gxz/+MVauXAmWZfHggw9yHldycjJ+97vfYceOHaioqMDJkyexdetWzuMCgJ6eHkilUshkspg9/0svvQS3243du3cP/7797W9/i3r+oslQhBAiYII4kieEEBIcJXlCCBEwSvKEECJglOQJIUTAKMkTQoiAUZInhBABoyRPCCECRkmeEEIE7P8DAjWDXwRuPkYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "since_ver = pd.DataFrame(df['SinceVersion'].value_counts())\n",
    "pdf_versions = [ \"1.0\", \"1.1\", \"1.2\", \"1.3\", \"1.4\", \"1.5\", \"1.6\", \"1.7\", \"2.0\" ]\n",
    "since_ver = since_ver.loc[pdf_versions]\n",
    "a = plt.plot(pdf_versions, since_ver)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d755c256",
   "metadata": {},
   "source": [
    "Let's try and identify this mysterious PDF object:\n",
    "```\n",
    "52 0 obj\n",
    "<</R[146 522 153 542]/N 53 0 R/P 51 0 R/T 570 0\n",
    "R/V 53 0 R>>\n",
    "endobj\n",
    "53 0 obj\n",
    "<</R[352 570 359 590]/N 52 0 R/P 51 0 R/T 570 0\n",
    "R/V 52 0 R>>\n",
    "endobj\n",
    "```\n",
    "Lets make small Dataframes for each key we are interested in and limit the output to just the Object, Key and Type:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "f116311e",
   "metadata": {},
   "outputs": [],
   "source": [
    "n_key = df.loc[df['Key']==\"N\", ['Object', 'Key', 'Type']]\n",
    "p_key = df.loc[df['Key']==\"P\", ['Object', 'Key', 'Type']]\n",
    "t_key = df.loc[df['Key']==\"T\", ['Object', 'Key', 'Type']]\n",
    "r_key = df.loc[df['Key']==\"R\", ['Object', 'Key', 'Type']]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cf9a07a9",
   "metadata": {},
   "source": [
    "Now we can do inner-merge to intersect the sets with each other"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "0b9d5c23",
   "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>Object</th>\n",
       "      <th>Key_x_x</th>\n",
       "      <th>Type_x_x</th>\n",
       "      <th>Key_y_x</th>\n",
       "      <th>Type_y_x</th>\n",
       "      <th>Key_x_y</th>\n",
       "      <th>Type_x_y</th>\n",
       "      <th>Key_y_y</th>\n",
       "      <th>Type_y_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bead</td>\n",
       "      <td>N</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>P</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>T</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>R</td>\n",
       "      <td>rectangle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BeadFirst</td>\n",
       "      <td>N</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>P</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>T</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>R</td>\n",
       "      <td>rectangle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Target</td>\n",
       "      <td>N</td>\n",
       "      <td>string-byte</td>\n",
       "      <td>P</td>\n",
       "      <td>integer;string-byte</td>\n",
       "      <td>T</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>R</td>\n",
       "      <td>name</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Object Key_x_x     Type_x_x Key_y_x             Type_y_x Key_x_y  \\\n",
       "0       Bead       N   dictionary       P           dictionary       T   \n",
       "1  BeadFirst       N   dictionary       P           dictionary       T   \n",
       "2     Target       N  string-byte       P  integer;string-byte       T   \n",
       "\n",
       "     Type_x_y Key_y_y   Type_y_y  \n",
       "0  dictionary       R  rectangle  \n",
       "1  dictionary       R  rectangle  \n",
       "2  dictionary       R       name  "
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.merge(n_key, p_key, how ='inner', on =['Object'])\n",
    "df2 = pd.merge(t_key, r_key, how ='inner', on =['Object'])\n",
    "pd.merge(df1, df2, how ='inner', on =['Object'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a3ac8ea8",
   "metadata": {},
   "source": [
    "From this result we can see that only Bead and BeadFirst objects have an R key which is an array (specifically, a rectangle in the Arlington predefined types). The Target R key needs to be a PDF name which the fragment is clearly not.\n",
    "So the answer is that it is a Bead/BeadFirst dictionary! "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e9aa232a",
   "metadata": {},
   "source": [
    "Let's now investigate inheritable-ness..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "a53c1d32",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "67"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inheritable_keys = df.loc[df['Inheritable']==\"TRUE\", ['Object', 'Key', 'Type', 'Required', 'Inheritable', 'DefaultValue']]\n",
    "len(inheritable_keys)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "29740156",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>Required</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1798</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1804</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>Ff</td>\n",
       "      <td>bitmask</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1810</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>Opt</td>\n",
       "      <td>array</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1811</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>V</td>\n",
       "      <td>name</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3343</th>\n",
       "      <td>StructureAttributesDict</td>\n",
       "      <td>TextDecorationType</td>\n",
       "      <td>name</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3344</th>\n",
       "      <td>StructureAttributesDict</td>\n",
       "      <td>RubyAlign</td>\n",
       "      <td>name</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>Distribute</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3345</th>\n",
       "      <td>StructureAttributesDict</td>\n",
       "      <td>RubyPosition</td>\n",
       "      <td>name</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>Before</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3346</th>\n",
       "      <td>StructureAttributesDict</td>\n",
       "      <td>GlyphOrientationVertical</td>\n",
       "      <td>integer;name</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>[];[Auto]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3350</th>\n",
       "      <td>StructureAttributesDict</td>\n",
       "      <td>ListNumbering</td>\n",
       "      <td>name</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>67 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Object                       Key          Type  \\\n",
       "1798         FieldBtnCheckbox                        FT          name   \n",
       "1804         FieldBtnCheckbox                        Ff       bitmask   \n",
       "1806         FieldBtnCheckbox                        DA        string   \n",
       "1810         FieldBtnCheckbox                       Opt         array   \n",
       "1811         FieldBtnCheckbox                         V          name   \n",
       "...                       ...                       ...           ...   \n",
       "3343  StructureAttributesDict        TextDecorationType          name   \n",
       "3344  StructureAttributesDict                 RubyAlign          name   \n",
       "3345  StructureAttributesDict              RubyPosition          name   \n",
       "3346  StructureAttributesDict  GlyphOrientationVertical  integer;name   \n",
       "3350  StructureAttributesDict             ListNumbering          name   \n",
       "\n",
       "     Required Inheritable DefaultValue  \n",
       "1798     TRUE        TRUE               \n",
       "1804    FALSE        TRUE               \n",
       "1806     TRUE        TRUE               \n",
       "1810    FALSE        TRUE               \n",
       "1811    FALSE        TRUE               \n",
       "...       ...         ...          ...  \n",
       "3343    FALSE        TRUE         None  \n",
       "3344    FALSE        TRUE   Distribute  \n",
       "3345    FALSE        TRUE       Before  \n",
       "3346    FALSE        TRUE    [];[Auto]  \n",
       "3350    FALSE        TRUE         None  \n",
       "\n",
       "[67 rows x 6 columns]"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inheritable_keys"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e10d2f9e",
   "metadata": {},
   "source": [
    "So there are a total of 67 keys defined to have inheritance (of some kind) in PDF 2.0 (as defined by ISO 32000-2:2020).\n",
    "\n",
    "Let's narrow to required keys that also inheritable:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "5eff0a6e",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>Required</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1798</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806</th>\n",
       "      <td>FieldBtnCheckbox</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1813</th>\n",
       "      <td>FieldBtnPush</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1821</th>\n",
       "      <td>FieldBtnPush</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1827</th>\n",
       "      <td>FieldBtnRadio</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1835</th>\n",
       "      <td>FieldBtnRadio</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1842</th>\n",
       "      <td>FieldChoice</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852</th>\n",
       "      <td>FieldChoice</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1863</th>\n",
       "      <td>FieldSig</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1873</th>\n",
       "      <td>FieldSig</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1879</th>\n",
       "      <td>FieldTx</td>\n",
       "      <td>FT</td>\n",
       "      <td>name</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1889</th>\n",
       "      <td>FieldTx</td>\n",
       "      <td>DA</td>\n",
       "      <td>string</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2708</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>Resources</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2709</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>MediaBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Object        Key        Type Required Inheritable  \\\n",
       "1798  FieldBtnCheckbox         FT        name     TRUE        TRUE   \n",
       "1806  FieldBtnCheckbox         DA      string     TRUE        TRUE   \n",
       "1813      FieldBtnPush         FT        name     TRUE        TRUE   \n",
       "1821      FieldBtnPush         DA      string     TRUE        TRUE   \n",
       "1827     FieldBtnRadio         FT        name     TRUE        TRUE   \n",
       "1835     FieldBtnRadio         DA      string     TRUE        TRUE   \n",
       "1842       FieldChoice         FT        name     TRUE        TRUE   \n",
       "1852       FieldChoice         DA      string     TRUE        TRUE   \n",
       "1863          FieldSig         FT        name     TRUE        TRUE   \n",
       "1873          FieldSig         DA      string     TRUE        TRUE   \n",
       "1879           FieldTx         FT        name     TRUE        TRUE   \n",
       "1889           FieldTx         DA      string     TRUE        TRUE   \n",
       "2708        PageObject  Resources  dictionary     TRUE        TRUE   \n",
       "2709        PageObject   MediaBox   rectangle     TRUE        TRUE   \n",
       "\n",
       "     DefaultValue  \n",
       "1798               \n",
       "1806               \n",
       "1813               \n",
       "1821               \n",
       "1827               \n",
       "1835               \n",
       "1842               \n",
       "1852               \n",
       "1863               \n",
       "1873               \n",
       "1879               \n",
       "1889               \n",
       "2708               \n",
       "2709               "
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inheritable_and_required_keys = inheritable_keys.loc[inheritable_keys['Required']==\"TRUE\"] \n",
    "inheritable_and_required_keys"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "233dfe5a",
   "metadata": {},
   "source": [
    "Everyone thinks that there are more required and inheritable keys in the PageObject... "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "6a8c4dec",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>Required</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2708</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>Resources</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2709</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>MediaBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>CropBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>@MediaBox</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2716</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>Rotate</td>\n",
       "      <td>integer</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2738</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>Hid</td>\n",
       "      <td>boolean</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>false</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Object        Key        Type Required Inheritable DefaultValue\n",
       "2708  PageObject  Resources  dictionary     TRUE        TRUE             \n",
       "2709  PageObject   MediaBox   rectangle     TRUE        TRUE             \n",
       "2710  PageObject    CropBox   rectangle    FALSE        TRUE    @MediaBox\n",
       "2716  PageObject     Rotate     integer    FALSE        TRUE            0\n",
       "2738  PageObject        Hid     boolean    FALSE        TRUE        false"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inheritable_keys.query('Object==\"PageObject\"')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fd200133",
   "metadata": {},
   "source": [
    "What is this \"Hid\" key?? That's not in ISO 32000-1 or ISO 32000-2!\n",
    "Let's get the full data for that key:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "88932274",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>SinceVersion</th>\n",
       "      <th>DeprecatedIn</th>\n",
       "      <th>Required</th>\n",
       "      <th>IndirectReference</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "      <th>PossibleValues</th>\n",
       "      <th>SpecialCase</th>\n",
       "      <th>Link</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2738</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>Hid</td>\n",
       "      <td>boolean</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.3</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>false</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Object  Key     Type SinceVersion DeprecatedIn Required  \\\n",
       "2738  PageObject  Hid  boolean          1.1          1.3    FALSE   \n",
       "\n",
       "     IndirectReference Inheritable DefaultValue PossibleValues SpecialCase  \\\n",
       "2738             FALSE        TRUE        false                              \n",
       "\n",
       "     Link Note  \n",
       "2738            "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('Object==\"PageObject\" and Key==\"Hid\"')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9e30948c",
   "metadata": {},
   "source": [
    "And what about all the other ...Box keys?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "74943e8b",
   "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>Object</th>\n",
       "      <th>Key</th>\n",
       "      <th>Type</th>\n",
       "      <th>SinceVersion</th>\n",
       "      <th>DeprecatedIn</th>\n",
       "      <th>Required</th>\n",
       "      <th>IndirectReference</th>\n",
       "      <th>Inheritable</th>\n",
       "      <th>DefaultValue</th>\n",
       "      <th>PossibleValues</th>\n",
       "      <th>SpecialCase</th>\n",
       "      <th>Link</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2709</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>MediaBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>TRUE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Inheritable from Parent</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>CropBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>1.0</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>TRUE</td>\n",
       "      <td>@MediaBox</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Inheritable from Parent</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2711</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>BleedBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>1.3</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>@CropBox</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Inheritable from Parent</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2712</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>TrimBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>1.3</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>@CropBox</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2713</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>ArtBox</td>\n",
       "      <td>rectangle</td>\n",
       "      <td>1.3</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>@CropBox</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2714</th>\n",
       "      <td>PageObject</td>\n",
       "      <td>BoxColorInfo</td>\n",
       "      <td>dictionary</td>\n",
       "      <td>1.4</td>\n",
       "      <td></td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td>FALSE</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>[BoxColorInfo]</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Object           Key        Type SinceVersion DeprecatedIn Required  \\\n",
       "2709  PageObject      MediaBox   rectangle          1.0                  TRUE   \n",
       "2710  PageObject       CropBox   rectangle          1.0                 FALSE   \n",
       "2711  PageObject      BleedBox   rectangle          1.3                 FALSE   \n",
       "2712  PageObject       TrimBox   rectangle          1.3                 FALSE   \n",
       "2713  PageObject        ArtBox   rectangle          1.3                 FALSE   \n",
       "2714  PageObject  BoxColorInfo  dictionary          1.4                 FALSE   \n",
       "\n",
       "     IndirectReference Inheritable DefaultValue PossibleValues SpecialCase  \\\n",
       "2709             FALSE        TRUE                                           \n",
       "2710             FALSE        TRUE    @MediaBox                              \n",
       "2711             FALSE       FALSE     @CropBox                              \n",
       "2712             FALSE       FALSE     @CropBox                              \n",
       "2713             FALSE       FALSE     @CropBox                              \n",
       "2714             FALSE       FALSE                                           \n",
       "\n",
       "                Link                     Note  \n",
       "2709                  Inheritable from Parent  \n",
       "2710                  Inheritable from Parent  \n",
       "2711                  Inheritable from Parent  \n",
       "2712                                           \n",
       "2713                                           \n",
       "2714  [BoxColorInfo]                           "
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "page_obj = df.query('Object==\"PageObject\"')\n",
    "page_obj[page_obj.Key.str.contains(\"Box\")]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}