Grab_NIH_Toolbox_Data_Dictionary_Annotation.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Get NIH Toolbox data dictionary items and merge with Crosswalk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4390, 8)"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from pandas import ExcelWriter\n",
    "from pandas import ExcelFile\n",
    "\n",
    "\n",
    "#read crosswalkfile\n",
    "pathin=\"/home/petra/UbWinSharedSpace1/ccf-nda-behavioral/PycharmToolbox/Ipad2NDA_withCrosswalk/NIHToolbox2NDA/\"\n",
    "crosswalkfile=\"Crosswalk_NIH_Toolbox_2_NDA.csv\"\n",
    "crosswalk=pd.read_csv(pathin+crosswalkfile,header=0,low_memory=False, encoding = \"ISO-8859-1\")\n",
    "\n",
    "\n",
    "#readfromNIH='https://nihtoolbox.desk.com/customer/portal/kb_article_attachments/144125/original.xlsx?1562788410'\n",
    "#in the meantime, read from a downloaded copy (replace the paths below with your own locations):\n",
    "fpath_downloadedNIH='/home/petra/UbWinSharedSpace1/ccf-nda-behavioral/PycharmToolbox/Ipad2NDA_withCrosswalk/NIHToolbox2NDA/'\n",
    "fname='NIH_Toolbox_IPAD_DataDictionary041119_Edited_(7-9-19).xlsx'\n",
    "fstring=fpath_downloadedNIH+fname\n",
    "tlbxitems = pd.read_excel(fstring, sheet_name='NIH Toolbox')\n",
    "#remove indentical duplications from the data dictionary\n",
    "#vast majority of duplications for variable type 'information' but NOT ALL.  \n",
    "tlbxitems=tlbxitems.drop_duplicates(subset=None, keep='first', inplace=False).copy()\n",
    "tlbxitems.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2940, 22)"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crosswalk.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Measurement System', 'Domain', 'Inst', 'Item ID', 'Stem', 'Context',\n",
       "       'DataType', 'Responses', 'Translation (output of IPAD)', 'hcp_variable',\n",
       "       'action_requested', 'requested_python', 'specialty_code',\n",
       "       'hcp_variable_upload', 'nda_structure', 'nda_element', 'description',\n",
       "       'valueRange', 'notes', 'template', 'inst_short', 'Source'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crosswalk.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Measurement System', 'Domain', 'Inst', 'Item ID', 'Stem', 'Context',\n",
       "       'DataType', 'Responses', 'hcp_variable'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tlbxitems.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "tlbxitems['hcp_variable']=tlbxitems['Item ID'].str.lower().str.replace('-','_').str.replace('(','_').str.replace(')','_')\n",
    "tlbxitems=tlbxitems.rename(columns={'Instrument Title':'Inst'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Measurement System', 'Domain', 'Inst', 'Item ID', 'Stem', 'Context',\n",
       "       'DataType', 'Responses', 'hcp_variable'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tlbxitems.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "#always pull the latest annotation from the NIH Toolbox Data dictionary...i.e. drop the columns corresponding to this information from the crosswalk\n",
    "#which was only holding them there for convenience sake.\n",
    "newcrosswalk=pd.merge(tlbxitems,crosswalk.drop(columns=['Measurement System', 'Domain', 'Item ID', 'Stem', 'Context',\n",
    "       'DataType', 'Responses', 'Translation (output of IPAD)']),how='right',on=['Inst','hcp_variable'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "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>Measurement System</th>\n",
       "      <th>Domain</th>\n",
       "      <th>Inst</th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Stem</th>\n",
       "      <th>Context</th>\n",
       "      <th>DataType</th>\n",
       "      <th>Responses</th>\n",
       "      <th>hcp_variable</th>\n",
       "      <th>action_requested</th>\n",
       "      <th>...</th>\n",
       "      <th>specialty_code</th>\n",
       "      <th>hcp_variable_upload</th>\n",
       "      <th>nda_structure</th>\n",
       "      <th>nda_element</th>\n",
       "      <th>description</th>\n",
       "      <th>valueRange</th>\n",
       "      <th>notes</th>\n",
       "      <th>template</th>\n",
       "      <th>inst_short</th>\n",
       "      <th>Source</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC188</td>\n",
       "      <td>LAVOC188</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC188-1\\n0=LAVOC188-2\\n1=LAVOC188-9\\n0=LA...</td>\n",
       "      <td>lavoc188</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc188</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc188</td>\n",
       "      <td>Picture Vocabulary Item 188</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC189</td>\n",
       "      <td>LAVOC189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>1=LAVOC189-9\\n0=LAVOC189-3\\n0=LAVOC189-2\\n0=LA...</td>\n",
       "      <td>lavoc189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc189</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc189</td>\n",
       "      <td>Picture Vocabulary Item 189</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC330</td>\n",
       "      <td>LAVOC330</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC330-1\\n1=LAVOC330-9\\n0=LAVOC330-3\\n0=LA...</td>\n",
       "      <td>lavoc330</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc330</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc330</td>\n",
       "      <td>Picture Vocabulary Item 330</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC120</td>\n",
       "      <td>LAVOC120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC120-2\\n0=LAVOC120-3\\n1=LAVOC120-9\\n0=LA...</td>\n",
       "      <td>lavoc120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc120</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc120</td>\n",
       "      <td>Picture Vocabulary Item 120</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC259</td>\n",
       "      <td>LAVOC259</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC259-3\\n0=LAVOC259-2\\n0=LAVOC259-1\\n1=LA...</td>\n",
       "      <td>lavoc259</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc259</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc259</td>\n",
       "      <td>Picture Vocabulary Item 259</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC191</td>\n",
       "      <td>LAVOC191</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC191-3\\n0=LAVOC191-2\\n1=LAVOC191-9\\n0=LA...</td>\n",
       "      <td>lavoc191</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc191</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc191</td>\n",
       "      <td>Picture Vocabulary Item 191</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC190</td>\n",
       "      <td>LAVOC190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC190-2\\n0=LAVOC190-1\\n0=LAVOC190-3\\n1=LA...</td>\n",
       "      <td>lavoc190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc190</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc190</td>\n",
       "      <td>Picture Vocabulary Item 190</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC452</td>\n",
       "      <td>LAVOC452</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC452-1\\n0=LAVOC452-2\\n0=LAVOC452-3\\n1=LA...</td>\n",
       "      <td>lavoc452</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc452</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc452</td>\n",
       "      <td>Picture Vocabulary Item 452</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC320</td>\n",
       "      <td>LAVOC320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC320-2\\n0=LAVOC320-1\\n0=LAVOC320-3\\n1=LA...</td>\n",
       "      <td>lavoc320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc320</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc320</td>\n",
       "      <td>Picture Vocabulary Item 320</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC242</td>\n",
       "      <td>LAVOC242</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC242-3\\n0=LAVOC242-2\\n1=LAVOC242-9\\n0=LA...</td>\n",
       "      <td>lavoc242</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc242</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc242</td>\n",
       "      <td>Picture Vocabulary Item 242</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC161</td>\n",
       "      <td>LAVOC161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC161-3\\n0=LAVOC161-2\\n0=LAVOC161-1\\n1=LA...</td>\n",
       "      <td>lavoc161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc161</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc161</td>\n",
       "      <td>Picture Vocabulary Item 161</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC091</td>\n",
       "      <td>LAVOC091</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC091-2\\n1=LAVOC091-9\\n0=LAVOC091-3\\n0=LA...</td>\n",
       "      <td>lavoc091</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc091</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc091</td>\n",
       "      <td>Picture Vocabulary Item 091</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC155</td>\n",
       "      <td>LAVOC155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC155-1\\n1=LAVOC155-9\\n0=LAVOC155-3\\n0=LA...</td>\n",
       "      <td>lavoc155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc155</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc155</td>\n",
       "      <td>Picture Vocabulary Item 155</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC206</td>\n",
       "      <td>LAVOC206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC206-3\\n1=LAVOC206-9\\n0=LAVOC206-1\\n0=LA...</td>\n",
       "      <td>lavoc206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc206</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc206</td>\n",
       "      <td>Picture Vocabulary Item 206</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC199</td>\n",
       "      <td>LAVOC199</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC199-3\\n0=LAVOC199-2\\n0=LAVOC199-1\\n1=LA...</td>\n",
       "      <td>lavoc199</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc199</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc199</td>\n",
       "      <td>Picture Vocabulary Item 199</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC260</td>\n",
       "      <td>LAVOC260</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC260-2\\n0=LAVOC260-1\\n1=LAVOC260-9\\n0=LA...</td>\n",
       "      <td>lavoc260</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc260</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc260</td>\n",
       "      <td>Picture Vocabulary Item 260</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC237</td>\n",
       "      <td>LAVOC237</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC237-2\\n1=LAVOC237-9\\n0=LAVOC237-3\\n0=LA...</td>\n",
       "      <td>lavoc237</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc237</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc237</td>\n",
       "      <td>Picture Vocabulary Item 237</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC364</td>\n",
       "      <td>LAVOC364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC364-3\\n0=LAVOC364-2\\n0=LAVOC364-1\\n1=LA...</td>\n",
       "      <td>lavoc364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc364</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc364</td>\n",
       "      <td>Picture Vocabulary Item 364</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC257</td>\n",
       "      <td>LAVOC257</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC257-2\\n1=LAVOC257-9\\n0=LAVOC257-3\\n0=LA...</td>\n",
       "      <td>lavoc257</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc257</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc257</td>\n",
       "      <td>Picture Vocabulary Item 257</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC263</td>\n",
       "      <td>LAVOC263</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC263-3\\n0=LAVOC263-2\\n0=LAVOC263-1\\n1=LA...</td>\n",
       "      <td>lavoc263</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc263</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc263</td>\n",
       "      <td>Picture Vocabulary Item 263</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC241</td>\n",
       "      <td>LAVOC241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>1=LAVOC241-9\\n0=LAVOC241-3\\n0=LAVOC241-2\\n0=LA...</td>\n",
       "      <td>lavoc241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc241</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc241</td>\n",
       "      <td>Picture Vocabulary Item 241</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC145</td>\n",
       "      <td>LAVOC145</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC145-3\\n1=LAVOC145-9\\n0=LAVOC145-1\\n0=LA...</td>\n",
       "      <td>lavoc145</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc145</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc145</td>\n",
       "      <td>Picture Vocabulary Item 145</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC194</td>\n",
       "      <td>LAVOC194</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>1=LAVOC194-9\\n0=LAVOC194-2\\n0=LAVOC194-3\\n0=LA...</td>\n",
       "      <td>lavoc194</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc194</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc194</td>\n",
       "      <td>Picture Vocabulary Item 194</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC303</td>\n",
       "      <td>LAVOC303</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC303-1\\n1=LAVOC303-9\\n0=LAVOC303-3\\n0=LA...</td>\n",
       "      <td>lavoc303</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc303</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc303</td>\n",
       "      <td>Picture Vocabulary Item 303</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC215</td>\n",
       "      <td>LAVOC215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC215-1\\n0=LAVOC215-2\\n1=LAVOC215-9\\n0=LA...</td>\n",
       "      <td>lavoc215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc215</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc215</td>\n",
       "      <td>Picture Vocabulary Item 215</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC422</td>\n",
       "      <td>LAVOC422</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC422-2\\n0=LAVOC422-1\\n0=LAVOC422-3\\n1=LA...</td>\n",
       "      <td>lavoc422</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc422</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc422</td>\n",
       "      <td>Picture Vocabulary Item 422</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC226</td>\n",
       "      <td>LAVOC226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC226-1\\n0=LAVOC226-3\\n0=LAVOC226-2\\n1=LA...</td>\n",
       "      <td>lavoc226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc226</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc226</td>\n",
       "      <td>Picture Vocabulary Item 226</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC222</td>\n",
       "      <td>LAVOC222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC222-3\\n0=LAVOC222-2\\n0=LAVOC222-1\\n1=LA...</td>\n",
       "      <td>lavoc222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc222</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc222</td>\n",
       "      <td>Picture Vocabulary Item 222</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC214</td>\n",
       "      <td>LAVOC214</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>1=LAVOC214-9\\n0=LAVOC214-3\\n0=LAVOC214-2\\n0=LA...</td>\n",
       "      <td>lavoc214</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc214</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc214</td>\n",
       "      <td>Picture Vocabulary Item 214</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NIH Toolbox</td>\n",
       "      <td>Cognition</td>\n",
       "      <td>NIH Toolbox Picture Vocabulary Test Age 3+ v2.0</td>\n",
       "      <td>LAVOC203</td>\n",
       "      <td>LAVOC203</td>\n",
       "      <td>NaN</td>\n",
       "      <td>integer</td>\n",
       "      <td>0=LAVOC203-2\\n1=LAVOC203-9\\n0=LAVOC203-3\\n0=LA...</td>\n",
       "      <td>lavoc203</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>button convert</td>\n",
       "      <td>lavoc203</td>\n",
       "      <td>tpvt01</td>\n",
       "      <td>lavoc203</td>\n",
       "      <td>Picture Vocabulary Item 203</td>\n",
       "      <td>0;1</td>\n",
       "      <td>0=Incorrect; 1=Correct</td>\n",
       "      <td>TPVT_v2.0.tpvt01_template.csv</td>\n",
       "      <td>TPVT_v2.0</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2910</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIH Toolbox Words-In-Noise Test Age 6+ v2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Raw Score Right Ear</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tlbx_sensation01</td>\n",
       "      <td>winright_ncorr</td>\n",
       "      <td>Words in Noise Number Correct Right</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>words_in_noise_tlbx_sensation01_template.csv</td>\n",
       "      <td>WordsInNoise</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2911</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIH Toolbox Words-In-Noise Test Age 6+ v2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Threshold Left Ear</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tlbx_sensation01</td>\n",
       "      <td>winleft_thresholdscore</td>\n",
       "      <td>Words in Noise Decibel Threshold Left</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>words_in_noise_tlbx_sensation01_template.csv</td>\n",
       "      <td>WordsInNoise</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2912</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIH Toolbox Words-In-Noise Test Age 6+ v2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Threshold Right Ear</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tlbx_sensation01</td>\n",
       "      <td>winright_thresholdscore</td>\n",
       "      <td>Words in Noise Decibel Threshold Right</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>words_in_noise_tlbx_sensation01_template.csv</td>\n",
       "      <td>WordsInNoise</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2913</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIH Toolbox Words-In-Noise Test Age 6+ v2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Words_In_Noise_Test__Dominant_Score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Words_In_Noise_Test__Dominant_Score</td>\n",
       "      <td>tlbx_sensation01</td>\n",
       "      <td>Dominant_Score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Words-In-Noise.tlbx_sensation01_template.csv</td>\n",
       "      <td>Words-In-Noise</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2914</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIH Toolbox Words-In-Noise Test Age 6+ v2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Words_In_Noise_Test__Non_Dominant_Score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Words_In_Noise_Test__Non_Dominant_Score</td>\n",
       "      <td>tlbx_sensation01</td>\n",
       "      <td>Non_Dominant_Score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Words-In-Noise.tlbx_sensation01_template.csv</td>\n",
       "      <td>Words-In-Noise</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2915</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Parent Report Summary...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_Parent_3-7.tlbx_wellbeing01_templat...</td>\n",
       "      <td>Well_Being_Parent_3-7</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2916</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Parent Report Summary...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>nih_tlbx_fctsc</td>\n",
       "      <td>Fully-Corrected T-Score</td>\n",
       "      <td>0::120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_Parent_3-7.tlbx_wellbeing01_templat...</td>\n",
       "      <td>Well_Being_Parent_3-7</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2917</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Parent Report Summary...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>primary_language</td>\n",
       "      <td>Subject's Primary Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_Parent_3-7.tlbx_wellbeing01_templat...</td>\n",
       "      <td>Well_Being_Parent_3-7</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2918</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Parent Report Summary...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_Parent_8-12.tlbx_wellbeing01_templa...</td>\n",
       "      <td>Well_Being_Parent_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2919</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Parent Report Summary...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>nih_tlbx_fctsc</td>\n",
       "      <td>Fully-Corrected T-Score</td>\n",
       "      <td>0::120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_Parent_8-12.tlbx_wellbeing01_templa...</td>\n",
       "      <td>Well_Being_Parent_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2920</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Parent Report Summary...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>primary_language</td>\n",
       "      <td>Subject's Primary Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_Parent_8-12.tlbx_wellbeing01_templa...</td>\n",
       "      <td>Well_Being_Parent_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2921</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_13-17.tlbx_wellbeing01_template.csv</td>\n",
       "      <td>Well_Being_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2922</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>nih_tlbx_fctsc</td>\n",
       "      <td>Fully-Corrected T-Score</td>\n",
       "      <td>0::120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_13-17.tlbx_wellbeing01_template.csv</td>\n",
       "      <td>Well_Being_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2923</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>primary_language</td>\n",
       "      <td>Subject's Primary Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_13-17.tlbx_wellbeing01_template.csv</td>\n",
       "      <td>Well_Being_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2924</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (18+)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_18+.tlbx_wellbeing01_template.csv/P...</td>\n",
       "      <td>Well_Being_18/Psychological_Well_Being</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2925</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (18+)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>primary_language</td>\n",
       "      <td>Subject's Primary Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_18+.tlbx_wellbeing01_template.csv/P...</td>\n",
       "      <td>Well_Being_18/Psychological_Well_Being</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2926</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (18+)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TScore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TScore</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>nih_tlbx_tscore</td>\n",
       "      <td>T-score</td>\n",
       "      <td>0::200; 999</td>\n",
       "      <td>999=NA/NK/missing</td>\n",
       "      <td>Well_Being_18+.tlbx_wellbeing01_template.csv/P...</td>\n",
       "      <td>Well_Being_18/Psychological_Well_Being</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2927</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (8-12)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_8-12.tlbx_wellbeing01_template.csv</td>\n",
       "      <td>Well_Being_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2928</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (8-12)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>nih_tlbx_fctsc</td>\n",
       "      <td>Fully-Corrected T-Score</td>\n",
       "      <td>0::120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_8-12.tlbx_wellbeing01_template.csv</td>\n",
       "      <td>Well_Being_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2929</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Psychological Well Being Summary (8-12)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>tlbx_wellbeing01</td>\n",
       "      <td>primary_language</td>\n",
       "      <td>Subject's Primary Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Well_Being_8-12.tlbx_wellbeing01_template.csv</td>\n",
       "      <td>Well_Being_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2930</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2931</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>nih_tlbx_fctsc</td>\n",
       "      <td>Fully-Corrected T-Score</td>\n",
       "      <td>0::120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2932</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ItmCnt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ItmCnt</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>wcst_ni</td>\n",
       "      <td>Number of Items</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2933</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (13-17)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>interview_language</td>\n",
       "      <td>Language Used in the Interview</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_13-17</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2934</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (18+)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template....</td>\n",
       "      <td>Social_Satisfaction_18/Social_Satisfaction</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2935</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (18+)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>interview_language</td>\n",
       "      <td>Language Used in the Interview</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template....</td>\n",
       "      <td>Social_Satisfaction_18/Social_Satisfaction</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2936</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (18+)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TScore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TScore</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>promisgls_tsc</td>\n",
       "      <td>PROMIS General Life Satisfaction T-Score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_13-17.promisgl01_template....</td>\n",
       "      <td>Social_Satisfaction_18/Social_Satisfaction</td>\n",
       "      <td>HCPD HCPA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2937</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (8-12)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assessment_Name</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>version_form</td>\n",
       "      <td>Form used/assessment name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_8-12.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2938</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (8-12)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fully_Corrected_T_score</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>nih_tlbx_fctsc</td>\n",
       "      <td>Fully-Corrected T-Score</td>\n",
       "      <td>0::120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_8-12.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2939</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social Satisfaction Summary (8-12)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Language</td>\n",
       "      <td>promisgl01</td>\n",
       "      <td>interview_language</td>\n",
       "      <td>Language Used in the Interview</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social_Satisfaction_8-12.promisgl01_template.csv</td>\n",
       "      <td>Social_Satisfaction_8-12</td>\n",
       "      <td>HCPD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2940 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Measurement System     Domain  \\\n",
       "0           NIH Toolbox  Cognition   \n",
       "1           NIH Toolbox  Cognition   \n",
       "2           NIH Toolbox  Cognition   \n",
       "3           NIH Toolbox  Cognition   \n",
       "4           NIH Toolbox  Cognition   \n",
       "5           NIH Toolbox  Cognition   \n",
       "6           NIH Toolbox  Cognition   \n",
       "7           NIH Toolbox  Cognition   \n",
       "8           NIH Toolbox  Cognition   \n",
       "9           NIH Toolbox  Cognition   \n",
       "10          NIH Toolbox  Cognition   \n",
       "11          NIH Toolbox  Cognition   \n",
       "12          NIH Toolbox  Cognition   \n",
       "13          NIH Toolbox  Cognition   \n",
       "14          NIH Toolbox  Cognition   \n",
       "15          NIH Toolbox  Cognition   \n",
       "16          NIH Toolbox  Cognition   \n",
       "17          NIH Toolbox  Cognition   \n",
       "18          NIH Toolbox  Cognition   \n",
       "19          NIH Toolbox  Cognition   \n",
       "20          NIH Toolbox  Cognition   \n",
       "21          NIH Toolbox  Cognition   \n",
       "22          NIH Toolbox  Cognition   \n",
       "23          NIH Toolbox  Cognition   \n",
       "24          NIH Toolbox  Cognition   \n",
       "25          NIH Toolbox  Cognition   \n",
       "26          NIH Toolbox  Cognition   \n",
       "27          NIH Toolbox  Cognition   \n",
       "28          NIH Toolbox  Cognition   \n",
       "29          NIH Toolbox  Cognition   \n",
       "...                 ...        ...   \n",
       "2910                NaN        NaN   \n",
       "2911                NaN        NaN   \n",
       "2912                NaN        NaN   \n",
       "2913                NaN        NaN   \n",
       "2914                NaN        NaN   \n",
       "2915                NaN        NaN   \n",
       "2916                NaN        NaN   \n",
       "2917                NaN        NaN   \n",
       "2918                NaN        NaN   \n",
       "2919                NaN        NaN   \n",
       "2920                NaN        NaN   \n",
       "2921                NaN        NaN   \n",
       "2922                NaN        NaN   \n",
       "2923                NaN        NaN   \n",
       "2924                NaN        NaN   \n",
       "2925                NaN        NaN   \n",
       "2926                NaN        NaN   \n",
       "2927                NaN        NaN   \n",
       "2928                NaN        NaN   \n",
       "2929                NaN        NaN   \n",
       "2930                NaN        NaN   \n",
       "2931                NaN        NaN   \n",
       "2932                NaN        NaN   \n",
       "2933                NaN        NaN   \n",
       "2934                NaN        NaN   \n",
       "2935                NaN        NaN   \n",
       "2936                NaN        NaN   \n",
       "2937                NaN        NaN   \n",
       "2938                NaN        NaN   \n",
       "2939                NaN        NaN   \n",
       "\n",
       "                                                   Inst   Item ID      Stem  \\\n",
       "0       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC188  LAVOC188   \n",
       "1       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC189  LAVOC189   \n",
       "2       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC330  LAVOC330   \n",
       "3       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC120  LAVOC120   \n",
       "4       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC259  LAVOC259   \n",
       "5       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC191  LAVOC191   \n",
       "6       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC190  LAVOC190   \n",
       "7       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC452  LAVOC452   \n",
       "8       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC320  LAVOC320   \n",
       "9       NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC242  LAVOC242   \n",
       "10      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC161  LAVOC161   \n",
       "11      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC091  LAVOC091   \n",
       "12      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC155  LAVOC155   \n",
       "13      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC206  LAVOC206   \n",
       "14      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC199  LAVOC199   \n",
       "15      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC260  LAVOC260   \n",
       "16      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC237  LAVOC237   \n",
       "17      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC364  LAVOC364   \n",
       "18      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC257  LAVOC257   \n",
       "19      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC263  LAVOC263   \n",
       "20      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC241  LAVOC241   \n",
       "21      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC145  LAVOC145   \n",
       "22      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC194  LAVOC194   \n",
       "23      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC303  LAVOC303   \n",
       "24      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC215  LAVOC215   \n",
       "25      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC422  LAVOC422   \n",
       "26      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC226  LAVOC226   \n",
       "27      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC222  LAVOC222   \n",
       "28      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC214  LAVOC214   \n",
       "29      NIH Toolbox Picture Vocabulary Test Age 3+ v2.0  LAVOC203  LAVOC203   \n",
       "...                                                 ...       ...       ...   \n",
       "2910        NIH Toolbox Words-In-Noise Test Age 6+ v2.1       NaN       NaN   \n",
       "2911        NIH Toolbox Words-In-Noise Test Age 6+ v2.1       NaN       NaN   \n",
       "2912        NIH Toolbox Words-In-Noise Test Age 6+ v2.1       NaN       NaN   \n",
       "2913        NIH Toolbox Words-In-Noise Test Age 6+ v2.1       NaN       NaN   \n",
       "2914        NIH Toolbox Words-In-Noise Test Age 6+ v2.1       NaN       NaN   \n",
       "2915  Psychological Well Being Parent Report Summary...       NaN       NaN   \n",
       "2916  Psychological Well Being Parent Report Summary...       NaN       NaN   \n",
       "2917  Psychological Well Being Parent Report Summary...       NaN       NaN   \n",
       "2918  Psychological Well Being Parent Report Summary...       NaN       NaN   \n",
       "2919  Psychological Well Being Parent Report Summary...       NaN       NaN   \n",
       "2920  Psychological Well Being Parent Report Summary...       NaN       NaN   \n",
       "2921           Psychological Well Being Summary (13-17)       NaN       NaN   \n",
       "2922           Psychological Well Being Summary (13-17)       NaN       NaN   \n",
       "2923           Psychological Well Being Summary (13-17)       NaN       NaN   \n",
       "2924             Psychological Well Being Summary (18+)       NaN       NaN   \n",
       "2925             Psychological Well Being Summary (18+)       NaN       NaN   \n",
       "2926             Psychological Well Being Summary (18+)       NaN       NaN   \n",
       "2927            Psychological Well Being Summary (8-12)       NaN       NaN   \n",
       "2928            Psychological Well Being Summary (8-12)       NaN       NaN   \n",
       "2929            Psychological Well Being Summary (8-12)       NaN       NaN   \n",
       "2930                Social Satisfaction Summary (13-17)       NaN       NaN   \n",
       "2931                Social Satisfaction Summary (13-17)       NaN       NaN   \n",
       "2932                Social Satisfaction Summary (13-17)       NaN       NaN   \n",
       "2933                Social Satisfaction Summary (13-17)       NaN       NaN   \n",
       "2934                  Social Satisfaction Summary (18+)       NaN       NaN   \n",
       "2935                  Social Satisfaction Summary (18+)       NaN       NaN   \n",
       "2936                  Social Satisfaction Summary (18+)       NaN       NaN   \n",
       "2937                 Social Satisfaction Summary (8-12)       NaN       NaN   \n",
       "2938                 Social Satisfaction Summary (8-12)       NaN       NaN   \n",
       "2939                 Social Satisfaction Summary (8-12)       NaN       NaN   \n",
       "\n",
       "     Context DataType                                          Responses  \\\n",
       "0        NaN  integer  0=LAVOC188-1\\n0=LAVOC188-2\\n1=LAVOC188-9\\n0=LA...   \n",
       "1        NaN  integer  1=LAVOC189-9\\n0=LAVOC189-3\\n0=LAVOC189-2\\n0=LA...   \n",
       "2        NaN  integer  0=LAVOC330-1\\n1=LAVOC330-9\\n0=LAVOC330-3\\n0=LA...   \n",
       "3        NaN  integer  0=LAVOC120-2\\n0=LAVOC120-3\\n1=LAVOC120-9\\n0=LA...   \n",
       "4        NaN  integer  0=LAVOC259-3\\n0=LAVOC259-2\\n0=LAVOC259-1\\n1=LA...   \n",
       "5        NaN  integer  0=LAVOC191-3\\n0=LAVOC191-2\\n1=LAVOC191-9\\n0=LA...   \n",
       "6        NaN  integer  0=LAVOC190-2\\n0=LAVOC190-1\\n0=LAVOC190-3\\n1=LA...   \n",
       "7        NaN  integer  0=LAVOC452-1\\n0=LAVOC452-2\\n0=LAVOC452-3\\n1=LA...   \n",
       "8        NaN  integer  0=LAVOC320-2\\n0=LAVOC320-1\\n0=LAVOC320-3\\n1=LA...   \n",
       "9        NaN  integer  0=LAVOC242-3\\n0=LAVOC242-2\\n1=LAVOC242-9\\n0=LA...   \n",
       "10       NaN  integer  0=LAVOC161-3\\n0=LAVOC161-2\\n0=LAVOC161-1\\n1=LA...   \n",
       "11       NaN  integer  0=LAVOC091-2\\n1=LAVOC091-9\\n0=LAVOC091-3\\n0=LA...   \n",
       "12       NaN  integer  0=LAVOC155-1\\n1=LAVOC155-9\\n0=LAVOC155-3\\n0=LA...   \n",
       "13       NaN  integer  0=LAVOC206-3\\n1=LAVOC206-9\\n0=LAVOC206-1\\n0=LA...   \n",
       "14       NaN  integer  0=LAVOC199-3\\n0=LAVOC199-2\\n0=LAVOC199-1\\n1=LA...   \n",
       "15       NaN  integer  0=LAVOC260-2\\n0=LAVOC260-1\\n1=LAVOC260-9\\n0=LA...   \n",
       "16       NaN  integer  0=LAVOC237-2\\n1=LAVOC237-9\\n0=LAVOC237-3\\n0=LA...   \n",
       "17       NaN  integer  0=LAVOC364-3\\n0=LAVOC364-2\\n0=LAVOC364-1\\n1=LA...   \n",
       "18       NaN  integer  0=LAVOC257-2\\n1=LAVOC257-9\\n0=LAVOC257-3\\n0=LA...   \n",
       "19       NaN  integer  0=LAVOC263-3\\n0=LAVOC263-2\\n0=LAVOC263-1\\n1=LA...   \n",
       "20       NaN  integer  1=LAVOC241-9\\n0=LAVOC241-3\\n0=LAVOC241-2\\n0=LA...   \n",
       "21       NaN  integer  0=LAVOC145-3\\n1=LAVOC145-9\\n0=LAVOC145-1\\n0=LA...   \n",
       "22       NaN  integer  1=LAVOC194-9\\n0=LAVOC194-2\\n0=LAVOC194-3\\n0=LA...   \n",
       "23       NaN  integer  0=LAVOC303-1\\n1=LAVOC303-9\\n0=LAVOC303-3\\n0=LA...   \n",
       "24       NaN  integer  0=LAVOC215-1\\n0=LAVOC215-2\\n1=LAVOC215-9\\n0=LA...   \n",
       "25       NaN  integer  0=LAVOC422-2\\n0=LAVOC422-1\\n0=LAVOC422-3\\n1=LA...   \n",
       "26       NaN  integer  0=LAVOC226-1\\n0=LAVOC226-3\\n0=LAVOC226-2\\n1=LA...   \n",
       "27       NaN  integer  0=LAVOC222-3\\n0=LAVOC222-2\\n0=LAVOC222-1\\n1=LA...   \n",
       "28       NaN  integer  1=LAVOC214-9\\n0=LAVOC214-3\\n0=LAVOC214-2\\n0=LA...   \n",
       "29       NaN  integer  0=LAVOC203-2\\n1=LAVOC203-9\\n0=LAVOC203-3\\n0=LA...   \n",
       "...      ...      ...                                                ...   \n",
       "2910     NaN      NaN                                                NaN   \n",
       "2911     NaN      NaN                                                NaN   \n",
       "2912     NaN      NaN                                                NaN   \n",
       "2913     NaN      NaN                                                NaN   \n",
       "2914     NaN      NaN                                                NaN   \n",
       "2915     NaN      NaN                                                NaN   \n",
       "2916     NaN      NaN                                                NaN   \n",
       "2917     NaN      NaN                                                NaN   \n",
       "2918     NaN      NaN                                                NaN   \n",
       "2919     NaN      NaN                                                NaN   \n",
       "2920     NaN      NaN                                                NaN   \n",
       "2921     NaN      NaN                                                NaN   \n",
       "2922     NaN      NaN                                                NaN   \n",
       "2923     NaN      NaN                                                NaN   \n",
       "2924     NaN      NaN                                                NaN   \n",
       "2925     NaN      NaN                                                NaN   \n",
       "2926     NaN      NaN                                                NaN   \n",
       "2927     NaN      NaN                                                NaN   \n",
       "2928     NaN      NaN                                                NaN   \n",
       "2929     NaN      NaN                                                NaN   \n",
       "2930     NaN      NaN                                                NaN   \n",
       "2931     NaN      NaN                                                NaN   \n",
       "2932     NaN      NaN                                                NaN   \n",
       "2933     NaN      NaN                                                NaN   \n",
       "2934     NaN      NaN                                                NaN   \n",
       "2935     NaN      NaN                                                NaN   \n",
       "2936     NaN      NaN                                                NaN   \n",
       "2937     NaN      NaN                                                NaN   \n",
       "2938     NaN      NaN                                                NaN   \n",
       "2939     NaN      NaN                                                NaN   \n",
       "\n",
       "                                 hcp_variable action_requested  ...  \\\n",
       "0                                    lavoc188              NaN  ...   \n",
       "1                                    lavoc189              NaN  ...   \n",
       "2                                    lavoc330              NaN  ...   \n",
       "3                                    lavoc120              NaN  ...   \n",
       "4                                    lavoc259              NaN  ...   \n",
       "5                                    lavoc191              NaN  ...   \n",
       "6                                    lavoc190              NaN  ...   \n",
       "7                                    lavoc452              NaN  ...   \n",
       "8                                    lavoc320              NaN  ...   \n",
       "9                                    lavoc242              NaN  ...   \n",
       "10                                   lavoc161              NaN  ...   \n",
       "11                                   lavoc091              NaN  ...   \n",
       "12                                   lavoc155              NaN  ...   \n",
       "13                                   lavoc206              NaN  ...   \n",
       "14                                   lavoc199              NaN  ...   \n",
       "15                                   lavoc260              NaN  ...   \n",
       "16                                   lavoc237              NaN  ...   \n",
       "17                                   lavoc364              NaN  ...   \n",
       "18                                   lavoc257              NaN  ...   \n",
       "19                                   lavoc263              NaN  ...   \n",
       "20                                   lavoc241              NaN  ...   \n",
       "21                                   lavoc145              NaN  ...   \n",
       "22                                   lavoc194              NaN  ...   \n",
       "23                                   lavoc303              NaN  ...   \n",
       "24                                   lavoc215              NaN  ...   \n",
       "25                                   lavoc422              NaN  ...   \n",
       "26                                   lavoc226              NaN  ...   \n",
       "27                                   lavoc222              NaN  ...   \n",
       "28                                   lavoc214              NaN  ...   \n",
       "29                                   lavoc203              NaN  ...   \n",
       "...                                       ...              ...  ...   \n",
       "2910                      Raw Score Right Ear              NaN  ...   \n",
       "2911                       Threshold Left Ear              NaN  ...   \n",
       "2912                      Threshold Right Ear              NaN  ...   \n",
       "2913      Words_In_Noise_Test__Dominant_Score              NaN  ...   \n",
       "2914  Words_In_Noise_Test__Non_Dominant_Score              NaN  ...   \n",
       "2915                          Assessment_Name              NaN  ...   \n",
       "2916                  Fully_Corrected_T_score              NaN  ...   \n",
       "2917                                 Language              NaN  ...   \n",
       "2918                          Assessment_Name              NaN  ...   \n",
       "2919                  Fully_Corrected_T_score              NaN  ...   \n",
       "2920                                 Language              NaN  ...   \n",
       "2921                          Assessment_Name              NaN  ...   \n",
       "2922                  Fully_Corrected_T_score              NaN  ...   \n",
       "2923                                 Language              NaN  ...   \n",
       "2924                          Assessment_Name              NaN  ...   \n",
       "2925                                 Language              NaN  ...   \n",
       "2926                                   TScore              NaN  ...   \n",
       "2927                          Assessment_Name              NaN  ...   \n",
       "2928                  Fully_Corrected_T_score              NaN  ...   \n",
       "2929                                 Language              NaN  ...   \n",
       "2930                          Assessment_Name              NaN  ...   \n",
       "2931                  Fully_Corrected_T_score              NaN  ...   \n",
       "2932                                   ItmCnt              NaN  ...   \n",
       "2933                                 Language              NaN  ...   \n",
       "2934                          Assessment_Name              NaN  ...   \n",
       "2935                                 Language              NaN  ...   \n",
       "2936                                   TScore              NaN  ...   \n",
       "2937                          Assessment_Name              NaN  ...   \n",
       "2938                  Fully_Corrected_T_score              NaN  ...   \n",
       "2939                                 Language              NaN  ...   \n",
       "\n",
       "      specialty_code                      hcp_variable_upload  \\\n",
       "0     button convert                                 lavoc188   \n",
       "1     button convert                                 lavoc189   \n",
       "2     button convert                                 lavoc330   \n",
       "3     button convert                                 lavoc120   \n",
       "4     button convert                                 lavoc259   \n",
       "5     button convert                                 lavoc191   \n",
       "6     button convert                                 lavoc190   \n",
       "7     button convert                                 lavoc452   \n",
       "8     button convert                                 lavoc320   \n",
       "9     button convert                                 lavoc242   \n",
       "10    button convert                                 lavoc161   \n",
       "11    button convert                                 lavoc091   \n",
       "12    button convert                                 lavoc155   \n",
       "13    button convert                                 lavoc206   \n",
       "14    button convert                                 lavoc199   \n",
       "15    button convert                                 lavoc260   \n",
       "16    button convert                                 lavoc237   \n",
       "17    button convert                                 lavoc364   \n",
       "18    button convert                                 lavoc257   \n",
       "19    button convert                                 lavoc263   \n",
       "20    button convert                                 lavoc241   \n",
       "21    button convert                                 lavoc145   \n",
       "22    button convert                                 lavoc194   \n",
       "23    button convert                                 lavoc303   \n",
       "24    button convert                                 lavoc215   \n",
       "25    button convert                                 lavoc422   \n",
       "26    button convert                                 lavoc226   \n",
       "27    button convert                                 lavoc222   \n",
       "28    button convert                                 lavoc214   \n",
       "29    button convert                                 lavoc203   \n",
       "...              ...                                      ...   \n",
       "2910             NaN                                      NaN   \n",
       "2911             NaN                                      NaN   \n",
       "2912             NaN                                      NaN   \n",
       "2913             NaN      Words_In_Noise_Test__Dominant_Score   \n",
       "2914             NaN  Words_In_Noise_Test__Non_Dominant_Score   \n",
       "2915             NaN                          Assessment_Name   \n",
       "2916             NaN                  Fully_Corrected_T_score   \n",
       "2917             NaN                                 Language   \n",
       "2918             NaN                          Assessment_Name   \n",
       "2919             NaN                  Fully_Corrected_T_score   \n",
       "2920             NaN                                 Language   \n",
       "2921             NaN                          Assessment_Name   \n",
       "2922             NaN                  Fully_Corrected_T_score   \n",
       "2923             NaN                                 Language   \n",
       "2924             NaN                          Assessment_Name   \n",
       "2925             NaN                                 Language   \n",
       "2926             NaN                                   TScore   \n",
       "2927             NaN                          Assessment_Name   \n",
       "2928             NaN                  Fully_Corrected_T_score   \n",
       "2929             NaN                                 Language   \n",
       "2930             NaN                          Assessment_Name   \n",
       "2931             NaN                  Fully_Corrected_T_score   \n",
       "2932             NaN                                   ItmCnt   \n",
       "2933             NaN                                 Language   \n",
       "2934             NaN                          Assessment_Name   \n",
       "2935             NaN                                 Language   \n",
       "2936             NaN                                   TScore   \n",
       "2937             NaN                          Assessment_Name   \n",
       "2938             NaN                  Fully_Corrected_T_score   \n",
       "2939             NaN                                 Language   \n",
       "\n",
       "         nda_structure              nda_element  \\\n",
       "0               tpvt01                 lavoc188   \n",
       "1               tpvt01                 lavoc189   \n",
       "2               tpvt01                 lavoc330   \n",
       "3               tpvt01                 lavoc120   \n",
       "4               tpvt01                 lavoc259   \n",
       "5               tpvt01                 lavoc191   \n",
       "6               tpvt01                 lavoc190   \n",
       "7               tpvt01                 lavoc452   \n",
       "8               tpvt01                 lavoc320   \n",
       "9               tpvt01                 lavoc242   \n",
       "10              tpvt01                 lavoc161   \n",
       "11              tpvt01                 lavoc091   \n",
       "12              tpvt01                 lavoc155   \n",
       "13              tpvt01                 lavoc206   \n",
       "14              tpvt01                 lavoc199   \n",
       "15              tpvt01                 lavoc260   \n",
       "16              tpvt01                 lavoc237   \n",
       "17              tpvt01                 lavoc364   \n",
       "18              tpvt01                 lavoc257   \n",
       "19              tpvt01                 lavoc263   \n",
       "20              tpvt01                 lavoc241   \n",
       "21              tpvt01                 lavoc145   \n",
       "22              tpvt01                 lavoc194   \n",
       "23              tpvt01                 lavoc303   \n",
       "24              tpvt01                 lavoc215   \n",
       "25              tpvt01                 lavoc422   \n",
       "26              tpvt01                 lavoc226   \n",
       "27              tpvt01                 lavoc222   \n",
       "28              tpvt01                 lavoc214   \n",
       "29              tpvt01                 lavoc203   \n",
       "...                ...                      ...   \n",
       "2910  tlbx_sensation01           winright_ncorr   \n",
       "2911  tlbx_sensation01   winleft_thresholdscore   \n",
       "2912  tlbx_sensation01  winright_thresholdscore   \n",
       "2913  tlbx_sensation01           Dominant_Score   \n",
       "2914  tlbx_sensation01       Non_Dominant_Score   \n",
       "2915  tlbx_wellbeing01             version_form   \n",
       "2916  tlbx_wellbeing01           nih_tlbx_fctsc   \n",
       "2917  tlbx_wellbeing01         primary_language   \n",
       "2918  tlbx_wellbeing01             version_form   \n",
       "2919  tlbx_wellbeing01           nih_tlbx_fctsc   \n",
       "2920  tlbx_wellbeing01         primary_language   \n",
       "2921  tlbx_wellbeing01             version_form   \n",
       "2922  tlbx_wellbeing01           nih_tlbx_fctsc   \n",
       "2923  tlbx_wellbeing01         primary_language   \n",
       "2924  tlbx_wellbeing01             version_form   \n",
       "2925  tlbx_wellbeing01         primary_language   \n",
       "2926  tlbx_wellbeing01          nih_tlbx_tscore   \n",
       "2927  tlbx_wellbeing01             version_form   \n",
       "2928  tlbx_wellbeing01           nih_tlbx_fctsc   \n",
       "2929  tlbx_wellbeing01         primary_language   \n",
       "2930        promisgl01             version_form   \n",
       "2931        promisgl01           nih_tlbx_fctsc   \n",
       "2932        promisgl01                  wcst_ni   \n",
       "2933        promisgl01       interview_language   \n",
       "2934        promisgl01             version_form   \n",
       "2935        promisgl01       interview_language   \n",
       "2936        promisgl01            promisgls_tsc   \n",
       "2937        promisgl01             version_form   \n",
       "2938        promisgl01           nih_tlbx_fctsc   \n",
       "2939        promisgl01       interview_language   \n",
       "\n",
       "                                   description   valueRange  \\\n",
       "0                  Picture Vocabulary Item 188          0;1   \n",
       "1                  Picture Vocabulary Item 189          0;1   \n",
       "2                  Picture Vocabulary Item 330          0;1   \n",
       "3                  Picture Vocabulary Item 120          0;1   \n",
       "4                  Picture Vocabulary Item 259          0;1   \n",
       "5                  Picture Vocabulary Item 191          0;1   \n",
       "6                  Picture Vocabulary Item 190          0;1   \n",
       "7                  Picture Vocabulary Item 452          0;1   \n",
       "8                  Picture Vocabulary Item 320          0;1   \n",
       "9                  Picture Vocabulary Item 242          0;1   \n",
       "10                 Picture Vocabulary Item 161          0;1   \n",
       "11                 Picture Vocabulary Item 091          0;1   \n",
       "12                 Picture Vocabulary Item 155          0;1   \n",
       "13                 Picture Vocabulary Item 206          0;1   \n",
       "14                 Picture Vocabulary Item 199          0;1   \n",
       "15                 Picture Vocabulary Item 260          0;1   \n",
       "16                 Picture Vocabulary Item 237          0;1   \n",
       "17                 Picture Vocabulary Item 364          0;1   \n",
       "18                 Picture Vocabulary Item 257          0;1   \n",
       "19                 Picture Vocabulary Item 263          0;1   \n",
       "20                 Picture Vocabulary Item 241          0;1   \n",
       "21                 Picture Vocabulary Item 145          0;1   \n",
       "22                 Picture Vocabulary Item 194          0;1   \n",
       "23                 Picture Vocabulary Item 303          0;1   \n",
       "24                 Picture Vocabulary Item 215          0;1   \n",
       "25                 Picture Vocabulary Item 422          0;1   \n",
       "26                 Picture Vocabulary Item 226          0;1   \n",
       "27                 Picture Vocabulary Item 222          0;1   \n",
       "28                 Picture Vocabulary Item 214          0;1   \n",
       "29                 Picture Vocabulary Item 203          0;1   \n",
       "...                                        ...          ...   \n",
       "2910       Words in Noise Number Correct Right          NaN   \n",
       "2911     Words in Noise Decibel Threshold Left          NaN   \n",
       "2912    Words in Noise Decibel Threshold Right          NaN   \n",
       "2913                                       NaN          NaN   \n",
       "2914                                       NaN          NaN   \n",
       "2915                 Form used/assessment name          NaN   \n",
       "2916                   Fully-Corrected T-Score       0::120   \n",
       "2917                Subject's Primary Language          NaN   \n",
       "2918                 Form used/assessment name          NaN   \n",
       "2919                   Fully-Corrected T-Score       0::120   \n",
       "2920                Subject's Primary Language          NaN   \n",
       "2921                 Form used/assessment name          NaN   \n",
       "2922                   Fully-Corrected T-Score       0::120   \n",
       "2923                Subject's Primary Language          NaN   \n",
       "2924                 Form used/assessment name          NaN   \n",
       "2925                Subject's Primary Language          NaN   \n",
       "2926                                   T-score  0::200; 999   \n",
       "2927                 Form used/assessment name          NaN   \n",
       "2928                   Fully-Corrected T-Score       0::120   \n",
       "2929                Subject's Primary Language          NaN   \n",
       "2930                 Form used/assessment name          NaN   \n",
       "2931                   Fully-Corrected T-Score       0::120   \n",
       "2932                           Number of Items          NaN   \n",
       "2933            Language Used in the Interview          NaN   \n",
       "2934                 Form used/assessment name          NaN   \n",
       "2935            Language Used in the Interview          NaN   \n",
       "2936  PROMIS General Life Satisfaction T-Score          NaN   \n",
       "2937                 Form used/assessment name          NaN   \n",
       "2938                   Fully-Corrected T-Score       0::120   \n",
       "2939            Language Used in the Interview          NaN   \n",
       "\n",
       "                       notes  \\\n",
       "0     0=Incorrect; 1=Correct   \n",
       "1     0=Incorrect; 1=Correct   \n",
       "2     0=Incorrect; 1=Correct   \n",
       "3     0=Incorrect; 1=Correct   \n",
       "4     0=Incorrect; 1=Correct   \n",
       "5     0=Incorrect; 1=Correct   \n",
       "6     0=Incorrect; 1=Correct   \n",
       "7     0=Incorrect; 1=Correct   \n",
       "8     0=Incorrect; 1=Correct   \n",
       "9     0=Incorrect; 1=Correct   \n",
       "10    0=Incorrect; 1=Correct   \n",
       "11    0=Incorrect; 1=Correct   \n",
       "12    0=Incorrect; 1=Correct   \n",
       "13    0=Incorrect; 1=Correct   \n",
       "14    0=Incorrect; 1=Correct   \n",
       "15    0=Incorrect; 1=Correct   \n",
       "16    0=Incorrect; 1=Correct   \n",
       "17    0=Incorrect; 1=Correct   \n",
       "18    0=Incorrect; 1=Correct   \n",
       "19    0=Incorrect; 1=Correct   \n",
       "20    0=Incorrect; 1=Correct   \n",
       "21    0=Incorrect; 1=Correct   \n",
       "22    0=Incorrect; 1=Correct   \n",
       "23    0=Incorrect; 1=Correct   \n",
       "24    0=Incorrect; 1=Correct   \n",
       "25    0=Incorrect; 1=Correct   \n",
       "26    0=Incorrect; 1=Correct   \n",
       "27    0=Incorrect; 1=Correct   \n",
       "28    0=Incorrect; 1=Correct   \n",
       "29    0=Incorrect; 1=Correct   \n",
       "...                      ...   \n",
       "2910                     NaN   \n",
       "2911                     NaN   \n",
       "2912                     NaN   \n",
       "2913                     NaN   \n",
       "2914                     NaN   \n",
       "2915                     NaN   \n",
       "2916                     NaN   \n",
       "2917                     NaN   \n",
       "2918                     NaN   \n",
       "2919                     NaN   \n",
       "2920                     NaN   \n",
       "2921                     NaN   \n",
       "2922                     NaN   \n",
       "2923                     NaN   \n",
       "2924                     NaN   \n",
       "2925                     NaN   \n",
       "2926       999=NA/NK/missing   \n",
       "2927                     NaN   \n",
       "2928                     NaN   \n",
       "2929                     NaN   \n",
       "2930                     NaN   \n",
       "2931                     NaN   \n",
       "2932                     NaN   \n",
       "2933                     NaN   \n",
       "2934                     NaN   \n",
       "2935                     NaN   \n",
       "2936                     NaN   \n",
       "2937                     NaN   \n",
       "2938                     NaN   \n",
       "2939                     NaN   \n",
       "\n",
       "                                               template  \\\n",
       "0                         TPVT_v2.0.tpvt01_template.csv   \n",
       "1                         TPVT_v2.0.tpvt01_template.csv   \n",
       "2                         TPVT_v2.0.tpvt01_template.csv   \n",
       "3                         TPVT_v2.0.tpvt01_template.csv   \n",
       "4                         TPVT_v2.0.tpvt01_template.csv   \n",
       "5                         TPVT_v2.0.tpvt01_template.csv   \n",
       "6                         TPVT_v2.0.tpvt01_template.csv   \n",
       "7                         TPVT_v2.0.tpvt01_template.csv   \n",
       "8                         TPVT_v2.0.tpvt01_template.csv   \n",
       "9                         TPVT_v2.0.tpvt01_template.csv   \n",
       "10                        TPVT_v2.0.tpvt01_template.csv   \n",
       "11                        TPVT_v2.0.tpvt01_template.csv   \n",
       "12                        TPVT_v2.0.tpvt01_template.csv   \n",
       "13                        TPVT_v2.0.tpvt01_template.csv   \n",
       "14                        TPVT_v2.0.tpvt01_template.csv   \n",
       "15                        TPVT_v2.0.tpvt01_template.csv   \n",
       "16                        TPVT_v2.0.tpvt01_template.csv   \n",
       "17                        TPVT_v2.0.tpvt01_template.csv   \n",
       "18                        TPVT_v2.0.tpvt01_template.csv   \n",
       "19                        TPVT_v2.0.tpvt01_template.csv   \n",
       "20                        TPVT_v2.0.tpvt01_template.csv   \n",
       "21                        TPVT_v2.0.tpvt01_template.csv   \n",
       "22                        TPVT_v2.0.tpvt01_template.csv   \n",
       "23                        TPVT_v2.0.tpvt01_template.csv   \n",
       "24                        TPVT_v2.0.tpvt01_template.csv   \n",
       "25                        TPVT_v2.0.tpvt01_template.csv   \n",
       "26                        TPVT_v2.0.tpvt01_template.csv   \n",
       "27                        TPVT_v2.0.tpvt01_template.csv   \n",
       "28                        TPVT_v2.0.tpvt01_template.csv   \n",
       "29                        TPVT_v2.0.tpvt01_template.csv   \n",
       "...                                                 ...   \n",
       "2910       words_in_noise_tlbx_sensation01_template.csv   \n",
       "2911       words_in_noise_tlbx_sensation01_template.csv   \n",
       "2912       words_in_noise_tlbx_sensation01_template.csv   \n",
       "2913       Words-In-Noise.tlbx_sensation01_template.csv   \n",
       "2914       Words-In-Noise.tlbx_sensation01_template.csv   \n",
       "2915  Well_Being_Parent_3-7.tlbx_wellbeing01_templat...   \n",
       "2916  Well_Being_Parent_3-7.tlbx_wellbeing01_templat...   \n",
       "2917  Well_Being_Parent_3-7.tlbx_wellbeing01_templat...   \n",
       "2918  Well_Being_Parent_8-12.tlbx_wellbeing01_templa...   \n",
       "2919  Well_Being_Parent_8-12.tlbx_wellbeing01_templa...   \n",
       "2920  Well_Being_Parent_8-12.tlbx_wellbeing01_templa...   \n",
       "2921     Well_Being_13-17.tlbx_wellbeing01_template.csv   \n",
       "2922     Well_Being_13-17.tlbx_wellbeing01_template.csv   \n",
       "2923     Well_Being_13-17.tlbx_wellbeing01_template.csv   \n",
       "2924  Well_Being_18+.tlbx_wellbeing01_template.csv/P...   \n",
       "2925  Well_Being_18+.tlbx_wellbeing01_template.csv/P...   \n",
       "2926  Well_Being_18+.tlbx_wellbeing01_template.csv/P...   \n",
       "2927      Well_Being_8-12.tlbx_wellbeing01_template.csv   \n",
       "2928      Well_Being_8-12.tlbx_wellbeing01_template.csv   \n",
       "2929      Well_Being_8-12.tlbx_wellbeing01_template.csv   \n",
       "2930  Social_Satisfaction_13-17.promisgl01_template.csv   \n",
       "2931  Social_Satisfaction_13-17.promisgl01_template.csv   \n",
       "2932  Social_Satisfaction_13-17.promisgl01_template.csv   \n",
       "2933  Social_Satisfaction_13-17.promisgl01_template.csv   \n",
       "2934  Social_Satisfaction_13-17.promisgl01_template....   \n",
       "2935  Social_Satisfaction_13-17.promisgl01_template....   \n",
       "2936  Social_Satisfaction_13-17.promisgl01_template....   \n",
       "2937   Social_Satisfaction_8-12.promisgl01_template.csv   \n",
       "2938   Social_Satisfaction_8-12.promisgl01_template.csv   \n",
       "2939   Social_Satisfaction_8-12.promisgl01_template.csv   \n",
       "\n",
       "                                      inst_short     Source  \n",
       "0                                      TPVT_v2.0  HCPD HCPA  \n",
       "1                                      TPVT_v2.0       HCPD  \n",
       "2                                      TPVT_v2.0       HCPD  \n",
       "3                                      TPVT_v2.0       HCPD  \n",
       "4                                      TPVT_v2.0       HCPD  \n",
       "5                                      TPVT_v2.0  HCPD HCPA  \n",
       "6                                      TPVT_v2.0       HCPD  \n",
       "7                                      TPVT_v2.0       HCPD  \n",
       "8                                      TPVT_v2.0  HCPD HCPA  \n",
       "9                                      TPVT_v2.0       HCPD  \n",
       "10                                     TPVT_v2.0  HCPD HCPA  \n",
       "11                                     TPVT_v2.0       HCPD  \n",
       "12                                     TPVT_v2.0  HCPD HCPA  \n",
       "13                                     TPVT_v2.0  HCPD HCPA  \n",
       "14                                     TPVT_v2.0       HCPD  \n",
       "15                                     TPVT_v2.0       HCPD  \n",
       "16                                     TPVT_v2.0       HCPD  \n",
       "17                                     TPVT_v2.0       HCPD  \n",
       "18                                     TPVT_v2.0  HCPD HCPA  \n",
       "19                                     TPVT_v2.0  HCPD HCPA  \n",
       "20                                     TPVT_v2.0  HCPD HCPA  \n",
       "21                                     TPVT_v2.0  HCPD HCPA  \n",
       "22                                     TPVT_v2.0       HCPD  \n",
       "23                                     TPVT_v2.0       HCPD  \n",
       "24                                     TPVT_v2.0  HCPD HCPA  \n",
       "25                                     TPVT_v2.0       HCPD  \n",
       "26                                     TPVT_v2.0  HCPD HCPA  \n",
       "27                                     TPVT_v2.0  HCPD HCPA  \n",
       "28                                     TPVT_v2.0  HCPD HCPA  \n",
       "29                                     TPVT_v2.0  HCPD HCPA  \n",
       "...                                          ...        ...  \n",
       "2910                                WordsInNoise  HCPD HCPA  \n",
       "2911                                WordsInNoise  HCPD HCPA  \n",
       "2912                                WordsInNoise  HCPD HCPA  \n",
       "2913                              Words-In-Noise  HCPD HCPA  \n",
       "2914                              Words-In-Noise  HCPD HCPA  \n",
       "2915                       Well_Being_Parent_3-7       HCPD  \n",
       "2916                       Well_Being_Parent_3-7       HCPD  \n",
       "2917                       Well_Being_Parent_3-7       HCPD  \n",
       "2918                      Well_Being_Parent_8-12       HCPD  \n",
       "2919                      Well_Being_Parent_8-12       HCPD  \n",
       "2920                      Well_Being_Parent_8-12       HCPD  \n",
       "2921                            Well_Being_13-17       HCPD  \n",
       "2922                            Well_Being_13-17       HCPD  \n",
       "2923                            Well_Being_13-17       HCPD  \n",
       "2924      Well_Being_18/Psychological_Well_Being  HCPD HCPA  \n",
       "2925      Well_Being_18/Psychological_Well_Being  HCPD HCPA  \n",
       "2926      Well_Being_18/Psychological_Well_Being  HCPD HCPA  \n",
       "2927                             Well_Being_8-12       HCPD  \n",
       "2928                             Well_Being_8-12       HCPD  \n",
       "2929                             Well_Being_8-12       HCPD  \n",
       "2930                   Social_Satisfaction_13-17       HCPD  \n",
       "2931                   Social_Satisfaction_13-17       HCPD  \n",
       "2932                   Social_Satisfaction_13-17       HCPD  \n",
       "2933                   Social_Satisfaction_13-17       HCPD  \n",
       "2934  Social_Satisfaction_18/Social_Satisfaction  HCPD HCPA  \n",
       "2935  Social_Satisfaction_18/Social_Satisfaction  HCPD HCPA  \n",
       "2936  Social_Satisfaction_18/Social_Satisfaction  HCPD HCPA  \n",
       "2937                    Social_Satisfaction_8-12       HCPD  \n",
       "2938                    Social_Satisfaction_8-12       HCPD  \n",
       "2939                    Social_Satisfaction_8-12       HCPD  \n",
       "\n",
       "[2940 rows x 21 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newcrosswalk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Measurement System', 'Domain', 'Inst', 'Item ID', 'Stem', 'Context',\n",
       "       'DataType', 'Responses', 'Translation (output of IPAD)', 'hcp_variable',\n",
       "       'action_requested', 'requested_python', 'specialty_code',\n",
       "       'hcp_variable_upload', 'nda_structure', 'nda_element', 'description',\n",
       "       'valueRange', 'notes', 'template', 'inst_short', 'Source'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newcrosswalk.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2940, 21)"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newcrosswalk.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "newcrosswalk.to_csv(pathin+crosswalkfile,index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PycharmToolbox",
   "language": "python",
   "name": "pycharmtoolbox"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}