hipparcos_tycho_matching.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "import notebook\n",
    "E = notebook.nbextensions.EnableNBExtensionApp()\n",
    "E.enable_nbextension('usability/python-markdown/main')\n",
    "import pandas as pd\n",
    "from scipy.optimize import curve_fit\n",
    "import markdown\n",
    "import sys\n",
    "sys.path.append('/Users/vs/Dropbox/Python')\n",
    "from astropy.table import Table\n",
    "from astropy import units as u\n",
    "from astropy.coordinates import SkyCoord\n",
    "import seaborn as sns\n",
    "\n",
    "bigfontsize=20\n",
    "labelfontsize=16\n",
    "tickfontsize=16\n",
    "sns.set_context('talk')\n",
    "plt.rcParams.update({'font.size': bigfontsize,\n",
    "                     'axes.labelsize':labelfontsize,\n",
    "                     'xtick.labelsize':tickfontsize,\n",
    "                     'ytick.labelsize':tickfontsize,\n",
    "                     'legend.fontsize':tickfontsize,\n",
    "                     })"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# TODO - Check which of these are Tycho and which are Hipparcos\n",
    "\n",
    "# Matching the Hipparcos and Tycho catalogues to the SMHASH/CRRP observations\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Hipparcos RR Lyrae\n",
    "\n",
    "* Hipparcos main catalogue - http://vizier.u-strasbg.fr/viz-bin/VizieR-3?-source=I/239/hip_main\n",
    "* Hipparcos variability annex - http://vizier.u-strasbg.fr/viz-bin/VizieR-3?-source=I/239/hip_va_1\n",
    "\n",
    "To get the positions of the RRL out of this catalogue need to match the two up. The variability annex doesn't have RA, Dec.\n",
    "\n",
    "Can match the two catalogues using TAPVizier\n",
    "* Uses ADQL - Like SQL\n",
    "* Need to match on HID\n",
    "* Want HID, RA, Dec, Type, Period\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ADQL query to match the catalogues:\n",
    "\n",
    "```sql\n",
    "SELECT \"I/239/hip_main\".HIP, \"RA(ICRS)\", \"DE(ICRS)\", \"VarType\", \"VarName\", \"I/239/hip_va_1\".\"Period\"\n",
    "FROM \"I/239/hip_main\", \"I/239/hip_va_1\"\n",
    "WHERE \"I/239/hip_main\".HIP=\"I/239/hip_va_1\".HIP AND \"I/239/hip_va_1\".VarType LIKE 'RR%'\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Output saved to ~/Dropbox/SMHASH/Hipparcos_Comparison/Hipparcos_RRL"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "## Tycho RR Lyrae\n",
    "\n",
    "Maintz (2005) claims many IDs of RRL in Tycho 2 catalogue are wrong. Match that catalogue with Tycho 2 to get list of RRL that appear in Tycho.\n",
    "\n",
    "Maintz catalogue: J/A+A/442/381/table1\n",
    "\n",
    "Use Cat='T' to select those in Tycho\n",
    "\n",
    "Output saved to ~/Dropbox/SMHASH/Hipparcos_Comparison/Tycho_RRL"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Find the unique stars\n",
    "\n",
    "Some of these stars are in both catalogues. Need to filter the catalogues so it's a unique list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "hipparcos = pd.read_csv(\"Hipparcos_RRL\", sep='|')\n",
    "hipparcos.rename(columns=lambda x: x.strip(), inplace=True) ## Stripping the whitespace out of the column names\n",
    "hipparcos.rename(columns = {'RA(ICRS)':'RA', 'DE(ICRS)':'Dec'}, inplace=True) ## Getting rid of the (ICRS)\n",
    "hipparcos = hipparcos.assign(RRName = lambda x: (x.VarName.str.replace('_', '')))\n",
    "hipparcos = hipparcos.assign(Catname = 'Hipparcos')\n",
    "\n",
    "tycho = pd.read_csv(\"Tycho_RRL\", sep='|')\n",
    "tycho.rename(columns=lambda x: x.strip(), inplace=True)\n",
    "tycho.rename(columns = {'RAJ2000' : 'RA', 'DEJ2000' : 'Dec', 'VType' : 'VarType'}, inplace=True)\n",
    "tycho = tycho.assign(RRName = lambda x: (x.Star.str.replace(' ', '')))\n",
    "tycho = tycho.assign(Catname = 'Tycho')\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 186 entries, 0 to 185\n",
      "Data columns (total 8 columns):\n",
      "HIP        186 non-null int64\n",
      "RA         186 non-null float64\n",
      "Dec        186 non-null float64\n",
      "VarType    186 non-null object\n",
      "VarName    186 non-null object\n",
      "Period     186 non-null object\n",
      "RRName     186 non-null object\n",
      "Catname    186 non-null object\n",
      "dtypes: float64(2), int64(1), object(5)\n",
      "memory usage: 13.1+ KB\n"
     ]
    }
   ],
   "source": [
    "hipparcos.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RA</th>\n",
       "      <th>Dec</th>\n",
       "      <th>Star</th>\n",
       "      <th>VarType</th>\n",
       "      <th>Period</th>\n",
       "      <th>RRName</th>\n",
       "      <th>Catname</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>353.002946</td>\n",
       "      <td>35.196908</td>\n",
       "      <td>DM And</td>\n",
       "      <td>RRab</td>\n",
       "      <td>0.630389</td>\n",
       "      <td>DMAnd</td>\n",
       "      <td>Tycho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16.294612</td>\n",
       "      <td>34.218400</td>\n",
       "      <td>DR And</td>\n",
       "      <td>RRab</td>\n",
       "      <td>0.563118</td>\n",
       "      <td>DRAnd</td>\n",
       "      <td>Tycho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.184192</td>\n",
       "      <td>40.828000</td>\n",
       "      <td>OV And</td>\n",
       "      <td>RRab</td>\n",
       "      <td>0.470581</td>\n",
       "      <td>OVAnd</td>\n",
       "      <td>Tycho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>245.214571</td>\n",
       "      <td>-71.671039</td>\n",
       "      <td>BS Aps</td>\n",
       "      <td>RRab</td>\n",
       "      <td>0.582556</td>\n",
       "      <td>BSAps</td>\n",
       "      <td>Tycho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>330.481325</td>\n",
       "      <td>-5.600711</td>\n",
       "      <td>TZ Aqr</td>\n",
       "      <td>RRab</td>\n",
       "      <td>0.571194</td>\n",
       "      <td>TZAqr</td>\n",
       "      <td>Tycho</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           RA        Dec       Star VarType    Period RRName Catname\n",
       "0  353.002946  35.196908  DM And      RRab   0.630389  DMAnd   Tycho\n",
       "1   16.294612  34.218400  DR And      RRab   0.563118  DRAnd   Tycho\n",
       "2    5.184192  40.828000  OV And      RRab   0.470581  OVAnd   Tycho\n",
       "3  245.214571 -71.671039  BS Aps      RRab   0.582556  BSAps   Tycho\n",
       "4  330.481325  -5.600711  TZ Aqr      RRab   0.571194  TZAqr   Tycho"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tycho.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Match the two catalogues to see which stars appear in both"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>HIP</th>\n",
       "      <th>RA</th>\n",
       "      <th>Dec</th>\n",
       "      <th>VarType</th>\n",
       "      <th>VarName</th>\n",
       "      <th>Period</th>\n",
       "      <th>RRName</th>\n",
       "      <th>Catname</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>226</td>\n",
       "      <td>0.700312</td>\n",
       "      <td>-24.945255</td>\n",
       "      <td>RRAB</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.4933470</td>\n",
       "      <td>RUScl</td>\n",
       "      <td>Hipparcos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>320</td>\n",
       "      <td>1.021268</td>\n",
       "      <td>-16.997641</td>\n",
       "      <td>RRAB</td>\n",
       "      <td>UU_Cet</td>\n",
       "      <td>0.6060830</td>\n",
       "      <td>UUCet</td>\n",
       "      <td>Hipparcos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1222</td>\n",
       "      <td>3.809727</td>\n",
       "      <td>60.340474</td>\n",
       "      <td>RRAB</td>\n",
       "      <td>V363_Cas</td>\n",
       "      <td>0.5465650</td>\n",
       "      <td>V363Cas</td>\n",
       "      <td>Hipparcos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1878</td>\n",
       "      <td>5.929558</td>\n",
       "      <td>29.401053</td>\n",
       "      <td>RRAB</td>\n",
       "      <td>SW_And</td>\n",
       "      <td>0.4422620</td>\n",
       "      <td>SWAnd</td>\n",
       "      <td>Hipparcos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2655</td>\n",
       "      <td>8.409568</td>\n",
       "      <td>-15.487302</td>\n",
       "      <td>RRAB</td>\n",
       "      <td>RX_Cet</td>\n",
       "      <td>0.5736850</td>\n",
       "      <td>RXCet</td>\n",
       "      <td>Hipparcos</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    HIP        RA        Dec  VarType    VarName     Period    RRName  \\\n",
       "0   226  0.700312 -24.945255  RRAB     RU_Scl     0.4933470  RUScl      \n",
       "1   320  1.021268 -16.997641  RRAB     UU_Cet     0.6060830  UUCet      \n",
       "2  1222  3.809727  60.340474  RRAB     V363_Cas   0.5465650  V363Cas    \n",
       "3  1878  5.929558  29.401053  RRAB     SW_And     0.4422620  SWAnd      \n",
       "4  2655  8.409568 -15.487302  RRAB     RX_Cet     0.5736850  RXCet      \n",
       "\n",
       "     Catname  \n",
       "0  Hipparcos  \n",
       "1  Hipparcos  \n",
       "2  Hipparcos  \n",
       "3  Hipparcos  \n",
       "4  Hipparcos  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hipparcos.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "matched = pd.merge(left=hipparcos, right=tycho, how='left', left_on='RRName', right_on='RRName')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "295"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tycho) + len(hipparcos)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**None of the Tycho RRL appear in the Hipparcos RRL catalogue if you match by name. Might miss a couple that way, but this is just an estimate. I can do a proper calculation if we need it.**"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Total number of Hipparcos and Tycho RR Lyrae variables = 295#"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Matching the catalogue to the Spitzer observations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "hiptyc = pd.concat([hipparcos, tycho], axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Catname</th>\n",
       "      <th>Dec</th>\n",
       "      <th>HIP</th>\n",
       "      <th>Period</th>\n",
       "      <th>RA</th>\n",
       "      <th>RRName</th>\n",
       "      <th>Star</th>\n",
       "      <th>VarName</th>\n",
       "      <th>VarType</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hipparcos</td>\n",
       "      <td>-24.945255</td>\n",
       "      <td>226</td>\n",
       "      <td>0.4933470</td>\n",
       "      <td>0.700312</td>\n",
       "      <td>RUScl</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>RRAB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hipparcos</td>\n",
       "      <td>-16.997641</td>\n",
       "      <td>320</td>\n",
       "      <td>0.6060830</td>\n",
       "      <td>1.021268</td>\n",
       "      <td>UUCet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UU_Cet</td>\n",
       "      <td>RRAB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hipparcos</td>\n",
       "      <td>60.340474</td>\n",
       "      <td>1222</td>\n",
       "      <td>0.5465650</td>\n",
       "      <td>3.809727</td>\n",
       "      <td>V363Cas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>V363_Cas</td>\n",
       "      <td>RRAB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Hipparcos</td>\n",
       "      <td>29.401053</td>\n",
       "      <td>1878</td>\n",
       "      <td>0.4422620</td>\n",
       "      <td>5.929558</td>\n",
       "      <td>SWAnd</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SW_And</td>\n",
       "      <td>RRAB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hipparcos</td>\n",
       "      <td>-15.487302</td>\n",
       "      <td>2655</td>\n",
       "      <td>0.5736850</td>\n",
       "      <td>8.409568</td>\n",
       "      <td>RXCet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RX_Cet</td>\n",
       "      <td>RRAB</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Catname        Dec   HIP     Period        RA    RRName Star    VarName  \\\n",
       "0  Hipparcos -24.945255   226  0.4933470  0.700312  RUScl     NaN  RU_Scl      \n",
       "1  Hipparcos -16.997641   320  0.6060830  1.021268  UUCet     NaN  UU_Cet      \n",
       "2  Hipparcos  60.340474  1222  0.5465650  3.809727  V363Cas   NaN  V363_Cas    \n",
       "3  Hipparcos  29.401053  1878  0.4422620  5.929558  SWAnd     NaN  SW_And      \n",
       "4  Hipparcos -15.487302  2655  0.5736850  8.409568  RXCet     NaN  RX_Cet      \n",
       "\n",
       "   VarType  \n",
       "0  RRAB     \n",
       "1  RRAB     \n",
       "2  RRAB     \n",
       "3  RRAB     \n",
       "4  RRAB     "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hiptyc.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Combined data set is now **hiptyc** data frame.\n",
    "\n",
    "Useful columns are RA, Dec, RRName, VarType, Period\n",
    "\n",
    "Star, VarName, HIP not defined for all stars."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Searching for the HipTyc objects in the Spitzer Heritage Archive\n",
    "* Want to check if we observed thses objects as part of CRRP or SMHASH\n",
    "* Can check for two things:\n",
    "  1. Have they been observed at all by Spitzer?\n",
    "  2. Have they been observed specifically by us?\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Have the HipTyc stars been observed at all by Spitzer?\n",
    "-----------------------------------------------------------------------\n",
    "\n",
    "* SHA can take a list as input:\n",
    "  1. Send the catalogue to an output text file\n",
    "  2. Give this as input to the SHA\n",
    "  3. Set a small search radius (1 arcmin - want to make sure they're on the frame)\n",
    "  4. ???\n",
    "  5. PROFIT"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "hiptyc.to_csv('hiptyc.csv', columns=('RRName', 'RA', 'Dec', 'Catname'), header=('NAME', 'RA', 'DEC', 'CATNAME'), index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "tycho.to_csv('tycho.csv', columns=('RRName', 'RA', 'Dec'), header=('NAME', 'RA', 'DEC'), index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Used this as input to the SHA search with 1 arcmin search radius. Saved results to hiptyc_obs_by_spitzer.ipac\n",
    "\n",
    "Now going to search this to find unique targets."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "spitzer_ipac = Table.read('hiptyc_obs_by_spitzer.ipac', format='ipac')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "spitzer = spitzer_ipac.to_pandas()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Search_Tgt</th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>AOR_label</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0h02m48.0749s 0h02m48.0749s</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47289600</td>\n",
       "      <td>RU_Scl_epoch5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0h02m48.0749s 0h02m48.0749s</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47291136</td>\n",
       "      <td>RU_Scl_epoch2</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0h02m48.0749s 0h02m48.0749s</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47288576</td>\n",
       "      <td>RU_Scl_epoch7</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0h02m48.0749s 0h02m48.0749s</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47290112</td>\n",
       "      <td>RU_Scl_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0h02m48.0749s 0h02m48.0749s</td>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47290624</td>\n",
       "      <td>RU_Scl_epoch3</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Search_Tgt Target_name  RA(J2000)  Dec(J2000)  \\\n",
       "0  0h02m48.0749s 0h02m48.0749s      RU_Scl        0.7  -24.945278   \n",
       "1  0h02m48.0749s 0h02m48.0749s      RU_Scl        0.7  -24.945278   \n",
       "2  0h02m48.0749s 0h02m48.0749s      RU_Scl        0.7  -24.945278   \n",
       "3  0h02m48.0749s 0h02m48.0749s      RU_Scl        0.7  -24.945278   \n",
       "4  0h02m48.0749s 0h02m48.0749s      RU_Scl        0.7  -24.945278   \n",
       "\n",
       "  Instrument/Mode    AORKEY      AOR_label  progid               PI  \n",
       "0     IRAC Map PC  47289600  RU_Scl_epoch5   90002  Freedman, Wendy  \n",
       "1     IRAC Map PC  47291136  RU_Scl_epoch2   90002  Freedman, Wendy  \n",
       "2     IRAC Map PC  47288576  RU_Scl_epoch7   90002  Freedman, Wendy  \n",
       "3     IRAC Map PC  47290112  RU_Scl_epoch4   90002  Freedman, Wendy  \n",
       "4     IRAC Map PC  47290624  RU_Scl_epoch3   90002  Freedman, Wendy  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spitzer.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now have the Spitzer search results in a pandas dataFrame!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Each HipTyc RRL can be matched to multiple observations. The matched HipTyc star is given in Search_Tgt\n",
    "\n",
    "* Need to find how many unique values there are in Search_Tgt column\n",
    "* Then see who observed them\n",
    " - How many are observed by us (i.e. have time series data)\n",
    " - How many were observed by other programs (may be single epoch)\n",
    " - Which ones are both? Are there ones that could add in extra data points from archival data?\n",
    "* Can then match back to HipTyc dataFrame to get final catalogue of observed targets."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "70"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spitzer['Tgt'], spitzer['Scrap'] = zip(*spitzer['Search_Tgt'].apply(lambda x: x.split(' ', 1)))\n",
    "del spitzer['Scrap']\n",
    "del spitzer['Search_Tgt']\n",
    "s = spitzer.groupby(['Tgt'])\n",
    "len(s)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Total number of HipTyc stars observed by Spitzer in any program = 70"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "wlf_obs = spitzer.loc[spitzer['PI']=='Freedman, Wendy']\n",
    "kvj_obs = spitzer.loc[spitzer['PI']=='Johnston, Kathryn V']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(51, 0)"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wlf_targets = wlf_obs.groupby(['Tgt'])\n",
    "n_wlf = len(wlf_targets.groups)\n",
    "kvj_targets = kvj_obs.groupby(['Tgt'])\n",
    "n_kvj = len(kvj_targets.groups)\n",
    "n_wlf, n_kvj"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Number of HipTyc stars observed by CRRP: 51\n",
    "## Number of HipTyc stars observed by SMHASH: 0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Which stars were observed by CRRP?\n",
    "\n",
    "* Need to drop duplicates in the row index from the wlf_obs dataFrame, then match to hiptyc dataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:2: FutureWarning: the take_last=True keyword is deprecated, use keep='last' instead\n",
      "  from ipykernel import kernelapp as app\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:2: FutureWarning: the 'cols' keyword is deprecated, use 'subset' instead\n",
      "  from ipykernel import kernelapp as app\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    }
   ],
   "source": [
    "wlf_obs['Search_Tgt_2'] = wlf_obs.Tgt\n",
    "wlf_obs = wlf_obs.drop_duplicates(cols='Search_Tgt_2', take_last=True)\n",
    "del wlf_obs['Search_Tgt_2']\n",
    "wlf_obs.sort_index(inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The following table lists the fields that contain Hipparcos or Tycho RR Lyrae variables. \n",
    "\n",
    "**Note:** There is an LMC field in here. It was a 2s exposure, so the RRL is probably not saturated.\n",
    "\n",
    "The relavent fields here are Target_name, progid, and PI if you want to look up the data. AOR label is only going to give you that specific epoch. Every star in this list has at least 24 epochs. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>AOR_label</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "      <th>Tgt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>RU_Scl</td>\n",
       "      <td>0.700000</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47397632</td>\n",
       "      <td>RU_Scl_epoch14</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>0h02m48.0749s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>SW_And</td>\n",
       "      <td>5.929167</td>\n",
       "      <td>29.400833</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47218688</td>\n",
       "      <td>SW_And_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>0h23m43.0939s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>RU_Psc</td>\n",
       "      <td>18.608333</td>\n",
       "      <td>24.415556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47402496</td>\n",
       "      <td>RU_Psc_epoch22</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h14m25.9772s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>XX_And</td>\n",
       "      <td>19.362500</td>\n",
       "      <td>38.950556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47421696</td>\n",
       "      <td>XX_And_epoch1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h17m27.3702s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>AM_Tuc</td>\n",
       "      <td>19.625000</td>\n",
       "      <td>-67.917778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47590656</td>\n",
       "      <td>AM_Tuc_epoch1 xc1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h18m30.6120s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>RR_Cet</td>\n",
       "      <td>23.033333</td>\n",
       "      <td>1.341667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47285248</td>\n",
       "      <td>RR_Cet_epoch12</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h32m08.1665s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>SV_Scl</td>\n",
       "      <td>26.245833</td>\n",
       "      <td>-30.059167</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47486464</td>\n",
       "      <td>SV_Scl_epoch24</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h44m59.6640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>CS_Eri</td>\n",
       "      <td>39.270833</td>\n",
       "      <td>-42.963333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47338496</td>\n",
       "      <td>CS_Eri_epoch8</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>2h37m05.6827s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>X_Ari</td>\n",
       "      <td>47.125000</td>\n",
       "      <td>10.445833</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47330816</td>\n",
       "      <td>X_Ari_epoch5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>3h08m30.8450s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>SV_Eri</td>\n",
       "      <td>47.966667</td>\n",
       "      <td>-11.353889</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47446272</td>\n",
       "      <td>SV_Eri_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>3h11m52.0990s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>RX_Eri</td>\n",
       "      <td>72.433333</td>\n",
       "      <td>-15.741111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47375360</td>\n",
       "      <td>RX_Eri_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h49m44.3005s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>RR_Gem</td>\n",
       "      <td>110.387500</td>\n",
       "      <td>30.883056</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47450368</td>\n",
       "      <td>RR_Gem_epoch24</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>7h21m33.5303s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>HK_Pup</td>\n",
       "      <td>116.191667</td>\n",
       "      <td>-13.098889</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47418368</td>\n",
       "      <td>HK_Pup_epoch14</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>7h44m46.7908s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>UY_Cam</td>\n",
       "      <td>119.741667</td>\n",
       "      <td>72.787500</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47427584</td>\n",
       "      <td>UY_Cam_epoch5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>7h58m58.8867s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>TT_Lyn</td>\n",
       "      <td>135.779167</td>\n",
       "      <td>44.585556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47450112</td>\n",
       "      <td>TT_Lyn_epoch1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>9h03m07.8552s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>T_Sex</td>\n",
       "      <td>148.366667</td>\n",
       "      <td>2.057222</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47325696</td>\n",
       "      <td>T_Sex_epoch15</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>9h53m28.4106s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>RR_Leo</td>\n",
       "      <td>151.929167</td>\n",
       "      <td>23.991667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47431168</td>\n",
       "      <td>RR_Leo_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>10h07m43.4692s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>WY_Ant</td>\n",
       "      <td>154.016667</td>\n",
       "      <td>-29.728333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47478784</td>\n",
       "      <td>WY_Ant_epoch3</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>10h16m04.9219s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>TU_Uma</td>\n",
       "      <td>172.450000</td>\n",
       "      <td>30.067222</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47454720</td>\n",
       "      <td>TU_Uma_epoch19</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>11h29m48.5376s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>SU_Dra</td>\n",
       "      <td>174.483333</td>\n",
       "      <td>67.329722</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47195136</td>\n",
       "      <td>SU_Dra_epoch10</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>11h37m56.6785s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>BX_Leo</td>\n",
       "      <td>174.508333</td>\n",
       "      <td>16.543333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47275264</td>\n",
       "      <td>BX_Leo_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>11h38m02.0801s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>UU_Vir</td>\n",
       "      <td>182.145833</td>\n",
       "      <td>-0.456667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47353600</td>\n",
       "      <td>UU_Vir_epoch19</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h08m35.0976s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>AB_Uma</td>\n",
       "      <td>182.808333</td>\n",
       "      <td>47.828611</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>48979712</td>\n",
       "      <td>AB_Uma_epoch1 xc9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h11m14.6045s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>SW_Dra</td>\n",
       "      <td>184.441667</td>\n",
       "      <td>69.510556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47461888</td>\n",
       "      <td>SW_Dra_epoch14</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h17m46.6736s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>SV_Hya</td>\n",
       "      <td>187.625000</td>\n",
       "      <td>-26.047500</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47360768</td>\n",
       "      <td>SV_Hya_epoch17</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h30m30.5274s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>SX_Uma</td>\n",
       "      <td>201.554167</td>\n",
       "      <td>56.256944</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47353344</td>\n",
       "      <td>SX_Uma_epoch3</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h26m13.5315s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>RV_Uma</td>\n",
       "      <td>203.325000</td>\n",
       "      <td>53.987222</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47255040</td>\n",
       "      <td>RV_Uma_epoch7</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h33m18.1091s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>ST_CVn</td>\n",
       "      <td>209.391667</td>\n",
       "      <td>29.857778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47421952</td>\n",
       "      <td>ST_CVn_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h57m34.0723s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>UY_Boo</td>\n",
       "      <td>209.691667</td>\n",
       "      <td>12.951667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47336960</td>\n",
       "      <td>UY_Boo_epoch1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h58m46.3367s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>TV_Boo</td>\n",
       "      <td>214.150000</td>\n",
       "      <td>42.359722</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47482112</td>\n",
       "      <td>TV_Boo_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>14h16m36.5845s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>AP_Ser</td>\n",
       "      <td>228.500000</td>\n",
       "      <td>9.980833</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47389696</td>\n",
       "      <td>AP_Ser_epoch20</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>15h14m00.9448s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>ST_Boo</td>\n",
       "      <td>232.662500</td>\n",
       "      <td>35.784444</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47406080</td>\n",
       "      <td>ST_Boo_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>15h30m39.2432s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>AN_Ser</td>\n",
       "      <td>238.379167</td>\n",
       "      <td>12.961111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47466240</td>\n",
       "      <td>AN_Ser_epoch22</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>15h53m31.0547s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>RV_CrB</td>\n",
       "      <td>244.854167</td>\n",
       "      <td>29.713056</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47229696</td>\n",
       "      <td>RV_CrB_epoch10</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>16h19m25.8691s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>VX_Her</td>\n",
       "      <td>247.666667</td>\n",
       "      <td>18.366667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47463936</td>\n",
       "      <td>VX_Her_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>16h30m40.8325s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942</th>\n",
       "      <td>UV_Oct</td>\n",
       "      <td>248.104167</td>\n",
       "      <td>-83.902778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>48819968</td>\n",
       "      <td>UV_Oct_epoch1 xc7</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>16h32m25.8508s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>TW_Her</td>\n",
       "      <td>268.629167</td>\n",
       "      <td>30.410278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47317248</td>\n",
       "      <td>TW_Her_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>17h54m31.2012s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1018</th>\n",
       "      <td>V675_Sgr</td>\n",
       "      <td>273.395833</td>\n",
       "      <td>-34.316944</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47386112</td>\n",
       "      <td>V675_Sgr_epoch21</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>18h13m35.3906s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>MT_Tel</td>\n",
       "      <td>285.550000</td>\n",
       "      <td>-46.653333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47442176</td>\n",
       "      <td>MT_Tel_epoch8</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h02m12.3999s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>RR_Lyr</td>\n",
       "      <td>291.362500</td>\n",
       "      <td>42.784167</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47592960</td>\n",
       "      <td>RR_Lyr_epoch1 xc2</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h25m28.0005s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1095</th>\n",
       "      <td>V440_Sgr</td>\n",
       "      <td>293.083333</td>\n",
       "      <td>-23.853333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47332352</td>\n",
       "      <td>V440_Sgr_epoch23</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h32m20.7861s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1119</th>\n",
       "      <td>XZ_Cyg</td>\n",
       "      <td>293.120833</td>\n",
       "      <td>56.388056</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47471616</td>\n",
       "      <td>XZ_Cyg_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h32m29.2163s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1145</th>\n",
       "      <td>DX_Del</td>\n",
       "      <td>311.866667</td>\n",
       "      <td>12.463889</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47592448</td>\n",
       "      <td>DX_Del_epoch1 xc2</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>20h47m28.3447s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169</th>\n",
       "      <td>UY_Cyg</td>\n",
       "      <td>314.116667</td>\n",
       "      <td>30.427778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47484160</td>\n",
       "      <td>UY_Cyg_epoch15</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>20h56m28.3081s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1195</th>\n",
       "      <td>V_Ind</td>\n",
       "      <td>317.870833</td>\n",
       "      <td>-45.074444</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47401216</td>\n",
       "      <td>V_Ind_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>21h11m29.9634s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1232</th>\n",
       "      <td>YZ_Cap</td>\n",
       "      <td>319.883333</td>\n",
       "      <td>-15.116944</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47760640</td>\n",
       "      <td>YZ_Cap_epoch1 xc5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>21h19m32.4243s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1256</th>\n",
       "      <td>AV_Peg</td>\n",
       "      <td>328.008333</td>\n",
       "      <td>22.574722</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47399680</td>\n",
       "      <td>AV_Peg_epoch6</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>21h52m02.7832s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>DH_Peg</td>\n",
       "      <td>333.854167</td>\n",
       "      <td>6.822500</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47756544</td>\n",
       "      <td>DH_Peg_epoch1 xc8</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>22h15m25.6274s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</th>\n",
       "      <td>RZ_Cep</td>\n",
       "      <td>339.804167</td>\n",
       "      <td>64.858333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47354624</td>\n",
       "      <td>RZ_Cep_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>22h39m13.0518s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>BH_Peg</td>\n",
       "      <td>343.254167</td>\n",
       "      <td>15.787778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47313920</td>\n",
       "      <td>BH_Peg_epoch10</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>22h53m01.0547s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32246272</td>\n",
       "      <td>LMC HV00882 epoch18</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Target_name   RA(J2000)  Dec(J2000) Instrument/Mode    AORKEY  \\\n",
       "23        RU_Scl    0.700000  -24.945278     IRAC Map PC  47397632   \n",
       "47        SW_And    5.929167   29.400833     IRAC Map PC  47218688   \n",
       "72        RU_Psc   18.608333   24.415556     IRAC Map PC  47402496   \n",
       "96        XX_And   19.362500   38.950556     IRAC Map PC  47421696   \n",
       "123       AM_Tuc   19.625000  -67.917778     IRAC Map PC  47590656   \n",
       "147       RR_Cet   23.033333    1.341667     IRAC Map PC  47285248   \n",
       "171       SV_Scl   26.245833  -30.059167     IRAC Map PC  47486464   \n",
       "195       CS_Eri   39.270833  -42.963333     IRAC Map PC  47338496   \n",
       "219        X_Ari   47.125000   10.445833     IRAC Map PC  47330816   \n",
       "243       SV_Eri   47.966667  -11.353889     IRAC Map PC  47446272   \n",
       "287       RX_Eri   72.433333  -15.741111     IRAC Map PC  47375360   \n",
       "311       RR_Gem  110.387500   30.883056     IRAC Map PC  47450368   \n",
       "344       HK_Pup  116.191667  -13.098889     IRAC Map PC  47418368   \n",
       "368       UY_Cam  119.741667   72.787500     IRAC Map PC  47427584   \n",
       "392       TT_Lyn  135.779167   44.585556     IRAC Map PC  47450112   \n",
       "418        T_Sex  148.366667    2.057222     IRAC Map PC  47325696   \n",
       "442       RR_Leo  151.929167   23.991667     IRAC Map PC  47431168   \n",
       "466       WY_Ant  154.016667  -29.728333     IRAC Map PC  47478784   \n",
       "490       TU_Uma  172.450000   30.067222     IRAC Map PC  47454720   \n",
       "515       SU_Dra  174.483333   67.329722     IRAC Map PC  47195136   \n",
       "539       BX_Leo  174.508333   16.543333     IRAC Map PC  47275264   \n",
       "563       UU_Vir  182.145833   -0.456667     IRAC Map PC  47353600   \n",
       "600       AB_Uma  182.808333   47.828611     IRAC Map PC  48979712   \n",
       "629       SW_Dra  184.441667   69.510556     IRAC Map PC  47461888   \n",
       "653       SV_Hya  187.625000  -26.047500     IRAC Map PC  47360768   \n",
       "677       SX_Uma  201.554167   56.256944     IRAC Map PC  47353344   \n",
       "701       RV_Uma  203.325000   53.987222     IRAC Map PC  47255040   \n",
       "727       ST_CVn  209.391667   29.857778     IRAC Map PC  47421952   \n",
       "752       UY_Boo  209.691667   12.951667     IRAC Map PC  47336960   \n",
       "776       TV_Boo  214.150000   42.359722     IRAC Map PC  47482112   \n",
       "800       AP_Ser  228.500000    9.980833     IRAC Map PC  47389696   \n",
       "825       ST_Boo  232.662500   35.784444     IRAC Map PC  47406080   \n",
       "850       AN_Ser  238.379167   12.961111     IRAC Map PC  47466240   \n",
       "874       RV_CrB  244.854167   29.713056     IRAC Map PC  47229696   \n",
       "899       VX_Her  247.666667   18.366667     IRAC Map PC  47463936   \n",
       "942       UV_Oct  248.104167  -83.902778     IRAC Map PC  48819968   \n",
       "970       TW_Her  268.629167   30.410278     IRAC Map PC  47317248   \n",
       "1018    V675_Sgr  273.395833  -34.316944     IRAC Map PC  47386112   \n",
       "1042      MT_Tel  285.550000  -46.653333     IRAC Map PC  47442176   \n",
       "1068      RR_Lyr  291.362500   42.784167     IRAC Map PC  47592960   \n",
       "1095    V440_Sgr  293.083333  -23.853333     IRAC Map PC  47332352   \n",
       "1119      XZ_Cyg  293.120833   56.388056     IRAC Map PC  47471616   \n",
       "1145      DX_Del  311.866667   12.463889     IRAC Map PC  47592448   \n",
       "1169      UY_Cyg  314.116667   30.427778     IRAC Map PC  47484160   \n",
       "1195       V_Ind  317.870833  -45.074444     IRAC Map PC  47401216   \n",
       "1232      YZ_Cap  319.883333  -15.116944     IRAC Map PC  47760640   \n",
       "1256      AV_Peg  328.008333   22.574722     IRAC Map PC  47399680   \n",
       "1301      DH_Peg  333.854167    6.822500     IRAC Map PC  47756544   \n",
       "1435      RZ_Cep  339.804167   64.858333     IRAC Map PC  47354624   \n",
       "1459      BH_Peg  343.254167   15.787778     IRAC Map PC  47313920   \n",
       "1492     HV00882   74.916667  -69.456111     IRAC Map PC  32246272   \n",
       "\n",
       "                AOR_label  progid               PI             Tgt  \n",
       "23         RU_Scl_epoch14   90002  Freedman, Wendy   0h02m48.0749s  \n",
       "47         SW_And_epoch16   90002  Freedman, Wendy   0h23m43.0939s  \n",
       "72         RU_Psc_epoch22   90002  Freedman, Wendy   1h14m25.9772s  \n",
       "96          XX_And_epoch1   90002  Freedman, Wendy   1h17m27.3702s  \n",
       "123     AM_Tuc_epoch1 xc1   90002  Freedman, Wendy   1h18m30.6120s  \n",
       "147        RR_Cet_epoch12   90002  Freedman, Wendy   1h32m08.1665s  \n",
       "171        SV_Scl_epoch24   90002  Freedman, Wendy   1h44m59.6640s  \n",
       "195         CS_Eri_epoch8   90002  Freedman, Wendy   2h37m05.6827s  \n",
       "219          X_Ari_epoch5   90002  Freedman, Wendy   3h08m30.8450s  \n",
       "243        SV_Eri_epoch16   90002  Freedman, Wendy   3h11m52.0990s  \n",
       "287         RX_Eri_epoch4   90002  Freedman, Wendy   4h49m44.3005s  \n",
       "311        RR_Gem_epoch24   90002  Freedman, Wendy   7h21m33.5303s  \n",
       "344        HK_Pup_epoch14   90002  Freedman, Wendy   7h44m46.7908s  \n",
       "368         UY_Cam_epoch5   90002  Freedman, Wendy   7h58m58.8867s  \n",
       "392         TT_Lyn_epoch1   90002  Freedman, Wendy   9h03m07.8552s  \n",
       "418         T_Sex_epoch15   90002  Freedman, Wendy   9h53m28.4106s  \n",
       "442         RR_Leo_epoch9   90002  Freedman, Wendy  10h07m43.4692s  \n",
       "466         WY_Ant_epoch3   90002  Freedman, Wendy  10h16m04.9219s  \n",
       "490        TU_Uma_epoch19   90002  Freedman, Wendy  11h29m48.5376s  \n",
       "515        SU_Dra_epoch10   90002  Freedman, Wendy  11h37m56.6785s  \n",
       "539         BX_Leo_epoch9   90002  Freedman, Wendy  11h38m02.0801s  \n",
       "563        UU_Vir_epoch19   90002  Freedman, Wendy  12h08m35.0976s  \n",
       "600     AB_Uma_epoch1 xc9   90002  Freedman, Wendy  12h11m14.6045s  \n",
       "629        SW_Dra_epoch14   90002  Freedman, Wendy  12h17m46.6736s  \n",
       "653        SV_Hya_epoch17   90002  Freedman, Wendy  12h30m30.5274s  \n",
       "677         SX_Uma_epoch3   90002  Freedman, Wendy  13h26m13.5315s  \n",
       "701         RV_Uma_epoch7   90002  Freedman, Wendy  13h33m18.1091s  \n",
       "727         ST_CVn_epoch9   90002  Freedman, Wendy  13h57m34.0723s  \n",
       "752         UY_Boo_epoch1   90002  Freedman, Wendy  13h58m46.3367s  \n",
       "776         TV_Boo_epoch4   90002  Freedman, Wendy  14h16m36.5845s  \n",
       "800        AP_Ser_epoch20   90002  Freedman, Wendy  15h14m00.9448s  \n",
       "825         ST_Boo_epoch4   90002  Freedman, Wendy  15h30m39.2432s  \n",
       "850        AN_Ser_epoch22   90002  Freedman, Wendy  15h53m31.0547s  \n",
       "874        RV_CrB_epoch10   90002  Freedman, Wendy  16h19m25.8691s  \n",
       "899        VX_Her_epoch16   90002  Freedman, Wendy  16h30m40.8325s  \n",
       "942     UV_Oct_epoch1 xc7   90002  Freedman, Wendy  16h32m25.8508s  \n",
       "970         TW_Her_epoch4   90002  Freedman, Wendy  17h54m31.2012s  \n",
       "1018     V675_Sgr_epoch21   90002  Freedman, Wendy  18h13m35.3906s  \n",
       "1042        MT_Tel_epoch8   90002  Freedman, Wendy  19h02m12.3999s  \n",
       "1068    RR_Lyr_epoch1 xc2   90002  Freedman, Wendy  19h25m28.0005s  \n",
       "1095     V440_Sgr_epoch23   90002  Freedman, Wendy  19h32m20.7861s  \n",
       "1119       XZ_Cyg_epoch16   90002  Freedman, Wendy  19h32m29.2163s  \n",
       "1145    DX_Del_epoch1 xc2   90002  Freedman, Wendy  20h47m28.3447s  \n",
       "1169       UY_Cyg_epoch15   90002  Freedman, Wendy  20h56m28.3081s  \n",
       "1195         V_Ind_epoch9   90002  Freedman, Wendy  21h11m29.9634s  \n",
       "1232    YZ_Cap_epoch1 xc5   90002  Freedman, Wendy  21h19m32.4243s  \n",
       "1256        AV_Peg_epoch6   90002  Freedman, Wendy  21h52m02.7832s  \n",
       "1301    DH_Peg_epoch1 xc8   90002  Freedman, Wendy  22h15m25.6274s  \n",
       "1435        RZ_Cep_epoch9   90002  Freedman, Wendy  22h39m13.0518s  \n",
       "1459       BH_Peg_epoch10   90002  Freedman, Wendy  22h53m01.0547s  \n",
       "1492  LMC HV00882 epoch18   61005  Freedman, Wendy   4h59m13.5718s  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wlf_obs"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now will do a check to see what has been observed by other programs\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "other_obs = spitzer.loc[spitzer['PI']!='Freedman, Wendy'] ## Any observer except Wendy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "24"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "other_targets = other_obs.groupby(['Tgt'])\n",
    "n_other = len(other_targets.groups)\n",
    "n_other"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Total of 24 RRL in HipTyc that have been observed by other programs, but NOT by us."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:2: FutureWarning: the take_last=True keyword is deprecated, use keep='last' instead\n",
      "  from ipykernel import kernelapp as app\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:2: FutureWarning: the 'cols' keyword is deprecated, use 'subset' instead\n",
      "  from ipykernel import kernelapp as app\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    }
   ],
   "source": [
    "other_obs['Search_Tgt_2'] = other_obs.Tgt\n",
    "other_obs = other_obs.drop_duplicates(cols='Search_Tgt_2', take_last=True)\n",
    "del other_obs['Search_Tgt_2']\n",
    "other_obs.sort_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>AOR_label</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "      <th>Tgt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>U20027_2M0033-1521</td>\n",
       "      <td>8.349417</td>\n",
       "      <td>-15.358583</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>22138368</td>\n",
       "      <td>IRAC-30-U20027_2M0033-1521</td>\n",
       "      <td>284</td>\n",
       "      <td>Cruz, Kelle</td>\n",
       "      <td>0h33m38.2963s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>DLS-L1</td>\n",
       "      <td>140.216667</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>17645312</td>\n",
       "      <td>DLS-L1</td>\n",
       "      <td>30478</td>\n",
       "      <td>Fazio, Giovanni</td>\n",
       "      <td>9h19m06.0352s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>SDSSJ113246.50+120901.7</td>\n",
       "      <td>173.193750</td>\n",
       "      <td>12.150556</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>23767552</td>\n",
       "      <td>IRACfour - 0016</td>\n",
       "      <td>40517</td>\n",
       "      <td>Meisenheimer, Klaus</td>\n",
       "      <td>11h33m03.7646s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>NGC4236</td>\n",
       "      <td>184.175417</td>\n",
       "      <td>69.462778</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>5504768</td>\n",
       "      <td>IRAC-N4236 - A</td>\n",
       "      <td>159</td>\n",
       "      <td>Kennicutt, Robert</td>\n",
       "      <td>12h17m46.6736s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>NGC5311</td>\n",
       "      <td>207.233750</td>\n",
       "      <td>39.985250</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>31088640</td>\n",
       "      <td>S4G-NGC5311B</td>\n",
       "      <td>61063</td>\n",
       "      <td>Sheth, Kartik</td>\n",
       "      <td>13h48m15.9375s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>Bootes II</td>\n",
       "      <td>209.500000</td>\n",
       "      <td>12.850000</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>42317568</td>\n",
       "      <td>IRACPC-0000 - Bootes II</td>\n",
       "      <td>80063</td>\n",
       "      <td>Boyer, Martha L</td>\n",
       "      <td>13h58m46.3367s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>RXJ1518.9-4050 - clus</td>\n",
       "      <td>229.720000</td>\n",
       "      <td>-40.848056</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>5666048</td>\n",
       "      <td>EVANS-WTTS-IRAC - RXJ1518.9-4050 - clus</td>\n",
       "      <td>173</td>\n",
       "      <td>Evans, Neal</td>\n",
       "      <td>15h22m25.3857s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>NN Ser</td>\n",
       "      <td>238.234167</td>\n",
       "      <td>12.913111</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>17725696</td>\n",
       "      <td>NNSer_irac</td>\n",
       "      <td>30070</td>\n",
       "      <td>Brinkworth, Carolyn S</td>\n",
       "      <td>15h53m31.0547s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>SDSS J1619+4526</td>\n",
       "      <td>244.992708</td>\n",
       "      <td>45.442000</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>26694912</td>\n",
       "      <td>IRAC-0005</td>\n",
       "      <td>50681</td>\n",
       "      <td>Fan, Xiaohui</td>\n",
       "      <td>16h20m04.0796s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>357.13525GLIMPSE</td>\n",
       "      <td>264.672590</td>\n",
       "      <td>-31.378248</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14326272</td>\n",
       "      <td>l357.13525-00.01535.20050929</td>\n",
       "      <td>20201</td>\n",
       "      <td>Churchwell, Ed</td>\n",
       "      <td>17h40m48.4790s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>Kepler14-1-1</td>\n",
       "      <td>292.765220</td>\n",
       "      <td>42.080201</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>50111744</td>\n",
       "      <td>Kepler 14 - edge1</td>\n",
       "      <td>10067</td>\n",
       "      <td>Werner, Michael</td>\n",
       "      <td>19h25m28.0005s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1171</th>\n",
       "      <td>90.89286GLIMPSE</td>\n",
       "      <td>315.768807</td>\n",
       "      <td>50.864762</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>37883392</td>\n",
       "      <td>l090.89286+02.78000.20090903</td>\n",
       "      <td>60020</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "      <td>21h04m32.9224s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1257</th>\n",
       "      <td>WISE2155-82</td>\n",
       "      <td>328.822678</td>\n",
       "      <td>-82.870741</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>41048832</td>\n",
       "      <td>Ch1&amp;2 (epoch 1) - WISE2155-82</td>\n",
       "      <td>70062</td>\n",
       "      <td>Kirkpatrick, J.Davy</td>\n",
       "      <td>21h53m35.3613s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>147.88094GLIMPSE</td>\n",
       "      <td>60.564211</td>\n",
       "      <td>55.253970</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32840192</td>\n",
       "      <td>l147.88094+01.91000.20091005</td>\n",
       "      <td>61070</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "      <td>4h06m38.8898s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>STRIP-4</td>\n",
       "      <td>70.838860</td>\n",
       "      <td>-53.599236</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>44636672</td>\n",
       "      <td>STRIP-1st4</td>\n",
       "      <td>80039</td>\n",
       "      <td>Scarlata, Claudia</td>\n",
       "      <td>4h48m13.2935s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>LMC</td>\n",
       "      <td>73.689875</td>\n",
       "      <td>-69.859947</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14365696</td>\n",
       "      <td>IRAC-map2-0201</td>\n",
       "      <td>20203</td>\n",
       "      <td>Meixner, Margaret</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1493</th>\n",
       "      <td>NGC 6701</td>\n",
       "      <td>280.801917</td>\n",
       "      <td>60.653333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>42384640</td>\n",
       "      <td>NGC6701_100_14</td>\n",
       "      <td>80089</td>\n",
       "      <td>Sanders, David B</td>\n",
       "      <td>18h44m04.6069s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>HIP90954</td>\n",
       "      <td>278.310777</td>\n",
       "      <td>40.159634</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>40646144</td>\n",
       "      <td>IRACPC-Sample1 - HIP90954</td>\n",
       "      <td>70076</td>\n",
       "      <td>Su, Kate</td>\n",
       "      <td>18h33m15.2270s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1495</th>\n",
       "      <td>UGC12519</td>\n",
       "      <td>350.011542</td>\n",
       "      <td>15.952750</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>17404416</td>\n",
       "      <td>IRAC-UGC12519</td>\n",
       "      <td>30348</td>\n",
       "      <td>Rieke, George</td>\n",
       "      <td>23h20m07.0313s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1498</th>\n",
       "      <td>353.33766GLIMPSE</td>\n",
       "      <td>262.206308</td>\n",
       "      <td>-34.563099</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14322432</td>\n",
       "      <td>l353.33766-00.01035.20050929</td>\n",
       "      <td>20201</td>\n",
       "      <td>Churchwell, Ed</td>\n",
       "      <td>17h35m05.8228s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1506</th>\n",
       "      <td>SSPT.gaps.23</td>\n",
       "      <td>347.741667</td>\n",
       "      <td>-58.183333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47014656</td>\n",
       "      <td>SSPT.gaps.23</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1507</th>\n",
       "      <td>SSPT67</td>\n",
       "      <td>1.145833</td>\n",
       "      <td>-58.583333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47593216</td>\n",
       "      <td>SSPT67</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>0h04m06.3430s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>2MASS J12364811-0219180</td>\n",
       "      <td>189.200458</td>\n",
       "      <td>-2.321667</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>13778432</td>\n",
       "      <td>IRAC - 4 filters, copy 3</td>\n",
       "      <td>244</td>\n",
       "      <td>Metchev, Stanimir</td>\n",
       "      <td>12h36m27.3230s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1517</th>\n",
       "      <td>SSPT03_09_FCO</td>\n",
       "      <td>349.791667</td>\n",
       "      <td>-53.808333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>43968256</td>\n",
       "      <td>SSPT03_09a</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Target_name   RA(J2000)  Dec(J2000) Instrument/Mode  \\\n",
       "48         U20027_2M0033-1521    8.349417  -15.358583        IRAC Map   \n",
       "394                    DLS-L1  140.216667   30.000000        IRAC Map   \n",
       "491   SDSSJ113246.50+120901.7  173.193750   12.150556        IRAC Map   \n",
       "614                   NGC4236  184.175417   69.462778        IRAC Map   \n",
       "703                   NGC5311  207.233750   39.985250     IRAC Map PC   \n",
       "728                 Bootes II  209.500000   12.850000     IRAC Map PC   \n",
       "801     RXJ1518.9-4050 - clus  229.720000  -40.848056        IRAC Map   \n",
       "826                    NN Ser  238.234167   12.913111        IRAC Map   \n",
       "875           SDSS J1619+4526  244.992708   45.442000        IRAC Map   \n",
       "946          357.13525GLIMPSE  264.672590  -31.378248        IRAC Map   \n",
       "1071             Kepler14-1-1  292.765220   42.080201     IRAC Map PC   \n",
       "1171          90.89286GLIMPSE  315.768807   50.864762     IRAC Map PC   \n",
       "1257              WISE2155-82  328.822678  -82.870741     IRAC Map PC   \n",
       "1462         147.88094GLIMPSE   60.564211   55.253970     IRAC Map PC   \n",
       "1464                  STRIP-4   70.838860  -53.599236     IRAC Map PC   \n",
       "1468                      LMC   73.689875  -69.859947        IRAC Map   \n",
       "1493                 NGC 6701  280.801917   60.653333     IRAC Map PC   \n",
       "1494                 HIP90954  278.310777   40.159634     IRAC Map PC   \n",
       "1495                 UGC12519  350.011542   15.952750        IRAC Map   \n",
       "1498         353.33766GLIMPSE  262.206308  -34.563099        IRAC Map   \n",
       "1506             SSPT.gaps.23  347.741667  -58.183333     IRAC Map PC   \n",
       "1507                   SSPT67    1.145833  -58.583333     IRAC Map PC   \n",
       "1508  2MASS J12364811-0219180  189.200458   -2.321667        IRAC Map   \n",
       "1517            SSPT03_09_FCO  349.791667  -53.808333     IRAC Map PC   \n",
       "\n",
       "        AORKEY                                AOR_label  progid  \\\n",
       "48    22138368               IRAC-30-U20027_2M0033-1521     284   \n",
       "394   17645312                                   DLS-L1   30478   \n",
       "491   23767552                          IRACfour - 0016   40517   \n",
       "614    5504768                           IRAC-N4236 - A     159   \n",
       "703   31088640                             S4G-NGC5311B   61063   \n",
       "728   42317568                  IRACPC-0000 - Bootes II   80063   \n",
       "801    5666048  EVANS-WTTS-IRAC - RXJ1518.9-4050 - clus     173   \n",
       "826   17725696                               NNSer_irac   30070   \n",
       "875   26694912                                IRAC-0005   50681   \n",
       "946   14326272             l357.13525-00.01535.20050929   20201   \n",
       "1071  50111744                        Kepler 14 - edge1   10067   \n",
       "1171  37883392             l090.89286+02.78000.20090903   60020   \n",
       "1257  41048832            Ch1&2 (epoch 1) - WISE2155-82   70062   \n",
       "1462  32840192             l147.88094+01.91000.20091005   61070   \n",
       "1464  44636672                               STRIP-1st4   80039   \n",
       "1468  14365696                           IRAC-map2-0201   20203   \n",
       "1493  42384640                           NGC6701_100_14   80089   \n",
       "1494  40646144                IRACPC-Sample1 - HIP90954   70076   \n",
       "1495  17404416                            IRAC-UGC12519   30348   \n",
       "1498  14322432             l353.33766-00.01035.20050929   20201   \n",
       "1506  47014656                             SSPT.gaps.23   80096   \n",
       "1507  47593216                                   SSPT67   80096   \n",
       "1508  13778432                 IRAC - 4 filters, copy 3     244   \n",
       "1517  43968256                               SSPT03_09a   80096   \n",
       "\n",
       "                         PI             Tgt  \n",
       "48              Cruz, Kelle   0h33m38.2963s  \n",
       "394         Fazio, Giovanni   9h19m06.0352s  \n",
       "491     Meisenheimer, Klaus  11h33m03.7646s  \n",
       "614       Kennicutt, Robert  12h17m46.6736s  \n",
       "703           Sheth, Kartik  13h48m15.9375s  \n",
       "728         Boyer, Martha L  13h58m46.3367s  \n",
       "801             Evans, Neal  15h22m25.3857s  \n",
       "826   Brinkworth, Carolyn S  15h53m31.0547s  \n",
       "875            Fan, Xiaohui  16h20m04.0796s  \n",
       "946          Churchwell, Ed  17h40m48.4790s  \n",
       "1071        Werner, Michael  19h25m28.0005s  \n",
       "1171     Whitney, Barbara A  21h04m32.9224s  \n",
       "1257    Kirkpatrick, J.Davy  21h53m35.3613s  \n",
       "1462     Whitney, Barbara A   4h06m38.8898s  \n",
       "1464      Scarlata, Claudia   4h48m13.2935s  \n",
       "1468      Meixner, Margaret   4h59m13.5718s  \n",
       "1493       Sanders, David B  18h44m04.6069s  \n",
       "1494               Su, Kate  18h33m15.2270s  \n",
       "1495          Rieke, George  23h20m07.0313s  \n",
       "1498         Churchwell, Ed  17h35m05.8228s  \n",
       "1506      Stanford, Spencer  23h11m00.5640s  \n",
       "1507      Stanford, Spencer   0h04m06.3430s  \n",
       "1508      Metchev, Stanimir  12h36m27.3230s  \n",
       "1517      Stanford, Spencer  23h23m57.4146s  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "other_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "RA_Dec = SkyCoord(ra=(hiptyc.RA)*u.degree, dec=(hiptyc.Dec)*u.degree, frame='icrs')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "hiptyc = hiptyc.assign(ra_hours = lambda x: (RA_Dec.ra.to_string('h')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "wlf_obs = wlf_obs.assign(Target_name = lambda x: (x.Target_name.str.replace('_', '')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>AOR_label</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "      <th>Tgt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>RUScl</td>\n",
       "      <td>0.700000</td>\n",
       "      <td>-24.945278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47397632</td>\n",
       "      <td>RU_Scl_epoch14</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>0h02m48.0749s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>SWAnd</td>\n",
       "      <td>5.929167</td>\n",
       "      <td>29.400833</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47218688</td>\n",
       "      <td>SW_And_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>0h23m43.0939s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>RUPsc</td>\n",
       "      <td>18.608333</td>\n",
       "      <td>24.415556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47402496</td>\n",
       "      <td>RU_Psc_epoch22</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h14m25.9772s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>XXAnd</td>\n",
       "      <td>19.362500</td>\n",
       "      <td>38.950556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47421696</td>\n",
       "      <td>XX_And_epoch1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h17m27.3702s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>AMTuc</td>\n",
       "      <td>19.625000</td>\n",
       "      <td>-67.917778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47590656</td>\n",
       "      <td>AM_Tuc_epoch1 xc1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h18m30.6120s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>RRCet</td>\n",
       "      <td>23.033333</td>\n",
       "      <td>1.341667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47285248</td>\n",
       "      <td>RR_Cet_epoch12</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h32m08.1665s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>SVScl</td>\n",
       "      <td>26.245833</td>\n",
       "      <td>-30.059167</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47486464</td>\n",
       "      <td>SV_Scl_epoch24</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>1h44m59.6640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>CSEri</td>\n",
       "      <td>39.270833</td>\n",
       "      <td>-42.963333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47338496</td>\n",
       "      <td>CS_Eri_epoch8</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>2h37m05.6827s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>XAri</td>\n",
       "      <td>47.125000</td>\n",
       "      <td>10.445833</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47330816</td>\n",
       "      <td>X_Ari_epoch5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>3h08m30.8450s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>SVEri</td>\n",
       "      <td>47.966667</td>\n",
       "      <td>-11.353889</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47446272</td>\n",
       "      <td>SV_Eri_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>3h11m52.0990s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>RXEri</td>\n",
       "      <td>72.433333</td>\n",
       "      <td>-15.741111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47375360</td>\n",
       "      <td>RX_Eri_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h49m44.3005s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>RRGem</td>\n",
       "      <td>110.387500</td>\n",
       "      <td>30.883056</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47450368</td>\n",
       "      <td>RR_Gem_epoch24</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>7h21m33.5303s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>HKPup</td>\n",
       "      <td>116.191667</td>\n",
       "      <td>-13.098889</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47418368</td>\n",
       "      <td>HK_Pup_epoch14</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>7h44m46.7908s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>UYCam</td>\n",
       "      <td>119.741667</td>\n",
       "      <td>72.787500</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47427584</td>\n",
       "      <td>UY_Cam_epoch5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>7h58m58.8867s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>TTLyn</td>\n",
       "      <td>135.779167</td>\n",
       "      <td>44.585556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47450112</td>\n",
       "      <td>TT_Lyn_epoch1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>9h03m07.8552s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>TSex</td>\n",
       "      <td>148.366667</td>\n",
       "      <td>2.057222</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47325696</td>\n",
       "      <td>T_Sex_epoch15</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>9h53m28.4106s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>RRLeo</td>\n",
       "      <td>151.929167</td>\n",
       "      <td>23.991667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47431168</td>\n",
       "      <td>RR_Leo_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>10h07m43.4692s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>WYAnt</td>\n",
       "      <td>154.016667</td>\n",
       "      <td>-29.728333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47478784</td>\n",
       "      <td>WY_Ant_epoch3</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>10h16m04.9219s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>TUUma</td>\n",
       "      <td>172.450000</td>\n",
       "      <td>30.067222</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47454720</td>\n",
       "      <td>TU_Uma_epoch19</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>11h29m48.5376s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>SUDra</td>\n",
       "      <td>174.483333</td>\n",
       "      <td>67.329722</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47195136</td>\n",
       "      <td>SU_Dra_epoch10</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>11h37m56.6785s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>BXLeo</td>\n",
       "      <td>174.508333</td>\n",
       "      <td>16.543333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47275264</td>\n",
       "      <td>BX_Leo_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>11h38m02.0801s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>UUVir</td>\n",
       "      <td>182.145833</td>\n",
       "      <td>-0.456667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47353600</td>\n",
       "      <td>UU_Vir_epoch19</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h08m35.0976s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>ABUma</td>\n",
       "      <td>182.808333</td>\n",
       "      <td>47.828611</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>48979712</td>\n",
       "      <td>AB_Uma_epoch1 xc9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h11m14.6045s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>SWDra</td>\n",
       "      <td>184.441667</td>\n",
       "      <td>69.510556</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47461888</td>\n",
       "      <td>SW_Dra_epoch14</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h17m46.6736s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>SVHya</td>\n",
       "      <td>187.625000</td>\n",
       "      <td>-26.047500</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47360768</td>\n",
       "      <td>SV_Hya_epoch17</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>12h30m30.5274s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>SXUma</td>\n",
       "      <td>201.554167</td>\n",
       "      <td>56.256944</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47353344</td>\n",
       "      <td>SX_Uma_epoch3</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h26m13.5315s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>RVUma</td>\n",
       "      <td>203.325000</td>\n",
       "      <td>53.987222</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47255040</td>\n",
       "      <td>RV_Uma_epoch7</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h33m18.1091s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>STCVn</td>\n",
       "      <td>209.391667</td>\n",
       "      <td>29.857778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47421952</td>\n",
       "      <td>ST_CVn_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h57m34.0723s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>UYBoo</td>\n",
       "      <td>209.691667</td>\n",
       "      <td>12.951667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47336960</td>\n",
       "      <td>UY_Boo_epoch1</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>13h58m46.3367s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>TVBoo</td>\n",
       "      <td>214.150000</td>\n",
       "      <td>42.359722</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47482112</td>\n",
       "      <td>TV_Boo_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>14h16m36.5845s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>APSer</td>\n",
       "      <td>228.500000</td>\n",
       "      <td>9.980833</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47389696</td>\n",
       "      <td>AP_Ser_epoch20</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>15h14m00.9448s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>STBoo</td>\n",
       "      <td>232.662500</td>\n",
       "      <td>35.784444</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47406080</td>\n",
       "      <td>ST_Boo_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>15h30m39.2432s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>ANSer</td>\n",
       "      <td>238.379167</td>\n",
       "      <td>12.961111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47466240</td>\n",
       "      <td>AN_Ser_epoch22</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>15h53m31.0547s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>RVCrB</td>\n",
       "      <td>244.854167</td>\n",
       "      <td>29.713056</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47229696</td>\n",
       "      <td>RV_CrB_epoch10</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>16h19m25.8691s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>VXHer</td>\n",
       "      <td>247.666667</td>\n",
       "      <td>18.366667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47463936</td>\n",
       "      <td>VX_Her_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>16h30m40.8325s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942</th>\n",
       "      <td>UVOct</td>\n",
       "      <td>248.104167</td>\n",
       "      <td>-83.902778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>48819968</td>\n",
       "      <td>UV_Oct_epoch1 xc7</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>16h32m25.8508s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>TWHer</td>\n",
       "      <td>268.629167</td>\n",
       "      <td>30.410278</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47317248</td>\n",
       "      <td>TW_Her_epoch4</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>17h54m31.2012s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1018</th>\n",
       "      <td>V675Sgr</td>\n",
       "      <td>273.395833</td>\n",
       "      <td>-34.316944</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47386112</td>\n",
       "      <td>V675_Sgr_epoch21</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>18h13m35.3906s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>MTTel</td>\n",
       "      <td>285.550000</td>\n",
       "      <td>-46.653333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47442176</td>\n",
       "      <td>MT_Tel_epoch8</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h02m12.3999s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>RRLyr</td>\n",
       "      <td>291.362500</td>\n",
       "      <td>42.784167</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47592960</td>\n",
       "      <td>RR_Lyr_epoch1 xc2</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h25m28.0005s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1095</th>\n",
       "      <td>V440Sgr</td>\n",
       "      <td>293.083333</td>\n",
       "      <td>-23.853333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47332352</td>\n",
       "      <td>V440_Sgr_epoch23</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h32m20.7861s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1119</th>\n",
       "      <td>XZCyg</td>\n",
       "      <td>293.120833</td>\n",
       "      <td>56.388056</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47471616</td>\n",
       "      <td>XZ_Cyg_epoch16</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>19h32m29.2163s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1145</th>\n",
       "      <td>DXDel</td>\n",
       "      <td>311.866667</td>\n",
       "      <td>12.463889</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47592448</td>\n",
       "      <td>DX_Del_epoch1 xc2</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>20h47m28.3447s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169</th>\n",
       "      <td>UYCyg</td>\n",
       "      <td>314.116667</td>\n",
       "      <td>30.427778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47484160</td>\n",
       "      <td>UY_Cyg_epoch15</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>20h56m28.3081s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1195</th>\n",
       "      <td>VInd</td>\n",
       "      <td>317.870833</td>\n",
       "      <td>-45.074444</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47401216</td>\n",
       "      <td>V_Ind_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>21h11m29.9634s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1232</th>\n",
       "      <td>YZCap</td>\n",
       "      <td>319.883333</td>\n",
       "      <td>-15.116944</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47760640</td>\n",
       "      <td>YZ_Cap_epoch1 xc5</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>21h19m32.4243s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1256</th>\n",
       "      <td>AVPeg</td>\n",
       "      <td>328.008333</td>\n",
       "      <td>22.574722</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47399680</td>\n",
       "      <td>AV_Peg_epoch6</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>21h52m02.7832s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>DHPeg</td>\n",
       "      <td>333.854167</td>\n",
       "      <td>6.822500</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47756544</td>\n",
       "      <td>DH_Peg_epoch1 xc8</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>22h15m25.6274s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</th>\n",
       "      <td>RZCep</td>\n",
       "      <td>339.804167</td>\n",
       "      <td>64.858333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47354624</td>\n",
       "      <td>RZ_Cep_epoch9</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>22h39m13.0518s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1459</th>\n",
       "      <td>BHPeg</td>\n",
       "      <td>343.254167</td>\n",
       "      <td>15.787778</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47313920</td>\n",
       "      <td>BH_Peg_epoch10</td>\n",
       "      <td>90002</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>22h53m01.0547s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32246272</td>\n",
       "      <td>LMC HV00882 epoch18</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Target_name   RA(J2000)  Dec(J2000) Instrument/Mode    AORKEY  \\\n",
       "23         RUScl    0.700000  -24.945278     IRAC Map PC  47397632   \n",
       "47         SWAnd    5.929167   29.400833     IRAC Map PC  47218688   \n",
       "72         RUPsc   18.608333   24.415556     IRAC Map PC  47402496   \n",
       "96         XXAnd   19.362500   38.950556     IRAC Map PC  47421696   \n",
       "123        AMTuc   19.625000  -67.917778     IRAC Map PC  47590656   \n",
       "147        RRCet   23.033333    1.341667     IRAC Map PC  47285248   \n",
       "171        SVScl   26.245833  -30.059167     IRAC Map PC  47486464   \n",
       "195        CSEri   39.270833  -42.963333     IRAC Map PC  47338496   \n",
       "219         XAri   47.125000   10.445833     IRAC Map PC  47330816   \n",
       "243        SVEri   47.966667  -11.353889     IRAC Map PC  47446272   \n",
       "287        RXEri   72.433333  -15.741111     IRAC Map PC  47375360   \n",
       "311        RRGem  110.387500   30.883056     IRAC Map PC  47450368   \n",
       "344        HKPup  116.191667  -13.098889     IRAC Map PC  47418368   \n",
       "368        UYCam  119.741667   72.787500     IRAC Map PC  47427584   \n",
       "392        TTLyn  135.779167   44.585556     IRAC Map PC  47450112   \n",
       "418         TSex  148.366667    2.057222     IRAC Map PC  47325696   \n",
       "442        RRLeo  151.929167   23.991667     IRAC Map PC  47431168   \n",
       "466        WYAnt  154.016667  -29.728333     IRAC Map PC  47478784   \n",
       "490        TUUma  172.450000   30.067222     IRAC Map PC  47454720   \n",
       "515        SUDra  174.483333   67.329722     IRAC Map PC  47195136   \n",
       "539        BXLeo  174.508333   16.543333     IRAC Map PC  47275264   \n",
       "563        UUVir  182.145833   -0.456667     IRAC Map PC  47353600   \n",
       "600        ABUma  182.808333   47.828611     IRAC Map PC  48979712   \n",
       "629        SWDra  184.441667   69.510556     IRAC Map PC  47461888   \n",
       "653        SVHya  187.625000  -26.047500     IRAC Map PC  47360768   \n",
       "677        SXUma  201.554167   56.256944     IRAC Map PC  47353344   \n",
       "701        RVUma  203.325000   53.987222     IRAC Map PC  47255040   \n",
       "727        STCVn  209.391667   29.857778     IRAC Map PC  47421952   \n",
       "752        UYBoo  209.691667   12.951667     IRAC Map PC  47336960   \n",
       "776        TVBoo  214.150000   42.359722     IRAC Map PC  47482112   \n",
       "800        APSer  228.500000    9.980833     IRAC Map PC  47389696   \n",
       "825        STBoo  232.662500   35.784444     IRAC Map PC  47406080   \n",
       "850        ANSer  238.379167   12.961111     IRAC Map PC  47466240   \n",
       "874        RVCrB  244.854167   29.713056     IRAC Map PC  47229696   \n",
       "899        VXHer  247.666667   18.366667     IRAC Map PC  47463936   \n",
       "942        UVOct  248.104167  -83.902778     IRAC Map PC  48819968   \n",
       "970        TWHer  268.629167   30.410278     IRAC Map PC  47317248   \n",
       "1018     V675Sgr  273.395833  -34.316944     IRAC Map PC  47386112   \n",
       "1042       MTTel  285.550000  -46.653333     IRAC Map PC  47442176   \n",
       "1068       RRLyr  291.362500   42.784167     IRAC Map PC  47592960   \n",
       "1095     V440Sgr  293.083333  -23.853333     IRAC Map PC  47332352   \n",
       "1119       XZCyg  293.120833   56.388056     IRAC Map PC  47471616   \n",
       "1145       DXDel  311.866667   12.463889     IRAC Map PC  47592448   \n",
       "1169       UYCyg  314.116667   30.427778     IRAC Map PC  47484160   \n",
       "1195        VInd  317.870833  -45.074444     IRAC Map PC  47401216   \n",
       "1232       YZCap  319.883333  -15.116944     IRAC Map PC  47760640   \n",
       "1256       AVPeg  328.008333   22.574722     IRAC Map PC  47399680   \n",
       "1301       DHPeg  333.854167    6.822500     IRAC Map PC  47756544   \n",
       "1435       RZCep  339.804167   64.858333     IRAC Map PC  47354624   \n",
       "1459       BHPeg  343.254167   15.787778     IRAC Map PC  47313920   \n",
       "1492     HV00882   74.916667  -69.456111     IRAC Map PC  32246272   \n",
       "\n",
       "                AOR_label  progid               PI             Tgt  \n",
       "23         RU_Scl_epoch14   90002  Freedman, Wendy   0h02m48.0749s  \n",
       "47         SW_And_epoch16   90002  Freedman, Wendy   0h23m43.0939s  \n",
       "72         RU_Psc_epoch22   90002  Freedman, Wendy   1h14m25.9772s  \n",
       "96          XX_And_epoch1   90002  Freedman, Wendy   1h17m27.3702s  \n",
       "123     AM_Tuc_epoch1 xc1   90002  Freedman, Wendy   1h18m30.6120s  \n",
       "147        RR_Cet_epoch12   90002  Freedman, Wendy   1h32m08.1665s  \n",
       "171        SV_Scl_epoch24   90002  Freedman, Wendy   1h44m59.6640s  \n",
       "195         CS_Eri_epoch8   90002  Freedman, Wendy   2h37m05.6827s  \n",
       "219          X_Ari_epoch5   90002  Freedman, Wendy   3h08m30.8450s  \n",
       "243        SV_Eri_epoch16   90002  Freedman, Wendy   3h11m52.0990s  \n",
       "287         RX_Eri_epoch4   90002  Freedman, Wendy   4h49m44.3005s  \n",
       "311        RR_Gem_epoch24   90002  Freedman, Wendy   7h21m33.5303s  \n",
       "344        HK_Pup_epoch14   90002  Freedman, Wendy   7h44m46.7908s  \n",
       "368         UY_Cam_epoch5   90002  Freedman, Wendy   7h58m58.8867s  \n",
       "392         TT_Lyn_epoch1   90002  Freedman, Wendy   9h03m07.8552s  \n",
       "418         T_Sex_epoch15   90002  Freedman, Wendy   9h53m28.4106s  \n",
       "442         RR_Leo_epoch9   90002  Freedman, Wendy  10h07m43.4692s  \n",
       "466         WY_Ant_epoch3   90002  Freedman, Wendy  10h16m04.9219s  \n",
       "490        TU_Uma_epoch19   90002  Freedman, Wendy  11h29m48.5376s  \n",
       "515        SU_Dra_epoch10   90002  Freedman, Wendy  11h37m56.6785s  \n",
       "539         BX_Leo_epoch9   90002  Freedman, Wendy  11h38m02.0801s  \n",
       "563        UU_Vir_epoch19   90002  Freedman, Wendy  12h08m35.0976s  \n",
       "600     AB_Uma_epoch1 xc9   90002  Freedman, Wendy  12h11m14.6045s  \n",
       "629        SW_Dra_epoch14   90002  Freedman, Wendy  12h17m46.6736s  \n",
       "653        SV_Hya_epoch17   90002  Freedman, Wendy  12h30m30.5274s  \n",
       "677         SX_Uma_epoch3   90002  Freedman, Wendy  13h26m13.5315s  \n",
       "701         RV_Uma_epoch7   90002  Freedman, Wendy  13h33m18.1091s  \n",
       "727         ST_CVn_epoch9   90002  Freedman, Wendy  13h57m34.0723s  \n",
       "752         UY_Boo_epoch1   90002  Freedman, Wendy  13h58m46.3367s  \n",
       "776         TV_Boo_epoch4   90002  Freedman, Wendy  14h16m36.5845s  \n",
       "800        AP_Ser_epoch20   90002  Freedman, Wendy  15h14m00.9448s  \n",
       "825         ST_Boo_epoch4   90002  Freedman, Wendy  15h30m39.2432s  \n",
       "850        AN_Ser_epoch22   90002  Freedman, Wendy  15h53m31.0547s  \n",
       "874        RV_CrB_epoch10   90002  Freedman, Wendy  16h19m25.8691s  \n",
       "899        VX_Her_epoch16   90002  Freedman, Wendy  16h30m40.8325s  \n",
       "942     UV_Oct_epoch1 xc7   90002  Freedman, Wendy  16h32m25.8508s  \n",
       "970         TW_Her_epoch4   90002  Freedman, Wendy  17h54m31.2012s  \n",
       "1018     V675_Sgr_epoch21   90002  Freedman, Wendy  18h13m35.3906s  \n",
       "1042        MT_Tel_epoch8   90002  Freedman, Wendy  19h02m12.3999s  \n",
       "1068    RR_Lyr_epoch1 xc2   90002  Freedman, Wendy  19h25m28.0005s  \n",
       "1095     V440_Sgr_epoch23   90002  Freedman, Wendy  19h32m20.7861s  \n",
       "1119       XZ_Cyg_epoch16   90002  Freedman, Wendy  19h32m29.2163s  \n",
       "1145    DX_Del_epoch1 xc2   90002  Freedman, Wendy  20h47m28.3447s  \n",
       "1169       UY_Cyg_epoch15   90002  Freedman, Wendy  20h56m28.3081s  \n",
       "1195         V_Ind_epoch9   90002  Freedman, Wendy  21h11m29.9634s  \n",
       "1232    YZ_Cap_epoch1 xc5   90002  Freedman, Wendy  21h19m32.4243s  \n",
       "1256        AV_Peg_epoch6   90002  Freedman, Wendy  21h52m02.7832s  \n",
       "1301    DH_Peg_epoch1 xc8   90002  Freedman, Wendy  22h15m25.6274s  \n",
       "1435        RZ_Cep_epoch9   90002  Freedman, Wendy  22h39m13.0518s  \n",
       "1459       BH_Peg_epoch10   90002  Freedman, Wendy  22h53m01.0547s  \n",
       "1492  LMC HV00882 epoch18   61005  Freedman, Wendy   4h59m13.5718s  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wlf_obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "spitzer_tycho_ipac = Table.read('tycho_obs_by_spitzer.ipac', format='ipac')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "spitzer_tycho = spitzer_tycho_ipac.to_pandas()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Search_Tgt</th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4h06m38.8898s 4h06m38.8898s</td>\n",
       "      <td>l148.44527d+1.89767d</td>\n",
       "      <td>60.776678</td>\n",
       "      <td>55.498143</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>40059392</td>\n",
       "      <td>70072</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4h06m38.8898s 4h06m38.8898s</td>\n",
       "      <td>l148.86493d+2.22832d</td>\n",
       "      <td>60.811094</td>\n",
       "      <td>55.387048</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>40065536</td>\n",
       "      <td>70072</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4h06m38.8898s 4h06m38.8898s</td>\n",
       "      <td>147.88094GLIMPSE</td>\n",
       "      <td>60.564211</td>\n",
       "      <td>55.253970</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32840192</td>\n",
       "      <td>61070</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4h48m13.2935s 4h48m13.2935s</td>\n",
       "      <td>STRIP-s4</td>\n",
       "      <td>71.138863</td>\n",
       "      <td>-53.599236</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>44634880</td>\n",
       "      <td>80039</td>\n",
       "      <td>Scarlata, Claudia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4h48m13.2935s 4h48m13.2935s</td>\n",
       "      <td>STRIP-4</td>\n",
       "      <td>70.838860</td>\n",
       "      <td>-53.599236</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>44636672</td>\n",
       "      <td>80039</td>\n",
       "      <td>Scarlata, Claudia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Search_Tgt           Target_name  RA(J2000)  Dec(J2000)  \\\n",
       "0  4h06m38.8898s 4h06m38.8898s  l148.44527d+1.89767d  60.776678   55.498143   \n",
       "1  4h06m38.8898s 4h06m38.8898s  l148.86493d+2.22832d  60.811094   55.387048   \n",
       "2  4h06m38.8898s 4h06m38.8898s      147.88094GLIMPSE  60.564211   55.253970   \n",
       "3  4h48m13.2935s 4h48m13.2935s              STRIP-s4  71.138863  -53.599236   \n",
       "4  4h48m13.2935s 4h48m13.2935s               STRIP-4  70.838860  -53.599236   \n",
       "\n",
       "  Instrument/Mode    AORKEY  progid                  PI  \n",
       "0     IRAC Map PC  40059392   70072  Whitney, Barbara A  \n",
       "1     IRAC Map PC  40065536   70072  Whitney, Barbara A  \n",
       "2     IRAC Map PC  32840192   61070  Whitney, Barbara A  \n",
       "3     IRAC Map PC  44634880   80039   Scarlata, Claudia  \n",
       "4     IRAC Map PC  44636672   80039   Scarlata, Claudia  "
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spitzer_tycho.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Predicted TGAS RRL"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* TGAS will release Gaia obs for the Tycho stars in Summer 2016\n",
    "* How many of the Tycho RRL (i.e. early release Gaia stars) do we have in CRRP/SMHASH?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spitzer_tycho['Tgt'], spitzer_tycho['Scrap'] = zip(*spitzer_tycho['Search_Tgt'].apply(lambda x: x.split(' ', 1)))\n",
    "del spitzer_tycho['Scrap']\n",
    "del spitzer_tycho['Search_Tgt']\n",
    "s = spitzer_tycho.groupby(['Tgt'])\n",
    "len(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "wlf_obs_tycho = spitzer_tycho.loc[spitzer_tycho['PI']=='Freedman, Wendy']\n",
    "kvj_obs_tycho = spitzer_tycho.loc[spitzer_tycho['PI']=='Johnston, Kathryn V']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:2: FutureWarning: the take_last=True keyword is deprecated, use keep='last' instead\n",
      "  from ipykernel import kernelapp as app\n",
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:2: FutureWarning: the 'cols' keyword is deprecated, use 'subset' instead\n",
      "  from ipykernel import kernelapp as app\n"
     ]
    }
   ],
   "source": [
    "wlf_obs_tycho['Search_Tgt_2'] = wlf_obs_tycho.Tgt\n",
    "wlf_obs_tycho = wlf_obs_tycho.drop_duplicates(cols='Search_Tgt_2', take_last=True)\n",
    "del wlf_obs_tycho['Search_Tgt_2']\n",
    "wlf_obs_tycho.sort_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "      <th>Tgt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32248576</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Target_name  RA(J2000)  Dec(J2000) Instrument/Mode    AORKEY  progid  \\\n",
       "32     HV00882  74.916667  -69.456111     IRAC Map PC  32248576   61005   \n",
       "\n",
       "                 PI            Tgt  \n",
       "32  Freedman, Wendy  4h59m13.5718s  "
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wlf_obs_tycho"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## CHP observed 1 field with a tycho RRL in it :(\n",
    "\n",
    "* There are 10 other fields containing tycho RRL in the Spitzer archive, but there isn't time resolution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Target_name</th>\n",
       "      <th>RA(J2000)</th>\n",
       "      <th>Dec(J2000)</th>\n",
       "      <th>Instrument/Mode</th>\n",
       "      <th>AORKEY</th>\n",
       "      <th>progid</th>\n",
       "      <th>PI</th>\n",
       "      <th>Tgt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>l148.44527d+1.89767d</td>\n",
       "      <td>60.776678</td>\n",
       "      <td>55.498143</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>40059392</td>\n",
       "      <td>70072</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "      <td>4h06m38.8898s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>l148.86493d+2.22832d</td>\n",
       "      <td>60.811094</td>\n",
       "      <td>55.387048</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>40065536</td>\n",
       "      <td>70072</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "      <td>4h06m38.8898s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>147.88094GLIMPSE</td>\n",
       "      <td>60.564211</td>\n",
       "      <td>55.253970</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32840192</td>\n",
       "      <td>61070</td>\n",
       "      <td>Whitney, Barbara A</td>\n",
       "      <td>4h06m38.8898s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>STRIP-s4</td>\n",
       "      <td>71.138863</td>\n",
       "      <td>-53.599236</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>44634880</td>\n",
       "      <td>80039</td>\n",
       "      <td>Scarlata, Claudia</td>\n",
       "      <td>4h48m13.2935s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>STRIP-4</td>\n",
       "      <td>70.838860</td>\n",
       "      <td>-53.599236</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>44636672</td>\n",
       "      <td>80039</td>\n",
       "      <td>Scarlata, Claudia</td>\n",
       "      <td>4h48m13.2935s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>LMC</td>\n",
       "      <td>73.974292</td>\n",
       "      <td>-69.992303</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14353152</td>\n",
       "      <td>20203</td>\n",
       "      <td>Meixner, Margaret</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>LMC</td>\n",
       "      <td>75.579708</td>\n",
       "      <td>-69.089531</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14353408</td>\n",
       "      <td>20203</td>\n",
       "      <td>Meixner, Margaret</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LMC</td>\n",
       "      <td>73.689875</td>\n",
       "      <td>-69.859947</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14365696</td>\n",
       "      <td>20203</td>\n",
       "      <td>Meixner, Margaret</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LMC</td>\n",
       "      <td>75.620208</td>\n",
       "      <td>-68.998842</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14365952</td>\n",
       "      <td>20203</td>\n",
       "      <td>Meixner, Margaret</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32230144</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32228096</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32226816</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32229632</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32229120</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32227584</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32227328</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32242944</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32242432</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32243456</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32241920</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32227840</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32228608</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32247808</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32250112</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32252416</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32245504</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32243968</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32247040</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32246272</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32249344</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32251648</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32250880</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>HV00882</td>\n",
       "      <td>74.916667</td>\n",
       "      <td>-69.456111</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>32248576</td>\n",
       "      <td>61005</td>\n",
       "      <td>Freedman, Wendy</td>\n",
       "      <td>4h59m13.5718s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NGC 6701</td>\n",
       "      <td>280.801917</td>\n",
       "      <td>60.653333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>42384640</td>\n",
       "      <td>80089</td>\n",
       "      <td>Sanders, David B</td>\n",
       "      <td>18h44m04.6069s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>HIP90954</td>\n",
       "      <td>278.310777</td>\n",
       "      <td>40.159634</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>40646144</td>\n",
       "      <td>70076</td>\n",
       "      <td>Su, Kate</td>\n",
       "      <td>18h33m15.2270s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>UGC12519</td>\n",
       "      <td>350.011542</td>\n",
       "      <td>15.952750</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>17404416</td>\n",
       "      <td>30348</td>\n",
       "      <td>Rieke, George</td>\n",
       "      <td>23h20m07.0313s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>353.71481GLIMPSE</td>\n",
       "      <td>262.458757</td>\n",
       "      <td>-34.248679</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14322688</td>\n",
       "      <td>20201</td>\n",
       "      <td>Churchwell, Ed</td>\n",
       "      <td>17h35m05.8228s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>353.74766GLIMPSE</td>\n",
       "      <td>262.477923</td>\n",
       "      <td>-34.219775</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14292736</td>\n",
       "      <td>20201</td>\n",
       "      <td>Churchwell, Ed</td>\n",
       "      <td>17h35m05.8228s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>353.33766GLIMPSE</td>\n",
       "      <td>262.206308</td>\n",
       "      <td>-34.563099</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>14322432</td>\n",
       "      <td>20201</td>\n",
       "      <td>Churchwell, Ed</td>\n",
       "      <td>17h35m05.8228s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>SPT-23_CL19_J2312-5820</td>\n",
       "      <td>347.998000</td>\n",
       "      <td>-58.340000</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>37092096</td>\n",
       "      <td>60099</td>\n",
       "      <td>Brodwin, Mark</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>SSPT32</td>\n",
       "      <td>346.958333</td>\n",
       "      <td>-59.116667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>45491968</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>SSPT33</td>\n",
       "      <td>349.270833</td>\n",
       "      <td>-58.154167</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>45490688</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>SSPT32</td>\n",
       "      <td>346.958333</td>\n",
       "      <td>-59.116667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>45491712</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>SSPT32</td>\n",
       "      <td>346.958333</td>\n",
       "      <td>-59.116667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>45492480</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>SSPT32</td>\n",
       "      <td>346.958333</td>\n",
       "      <td>-59.116667</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>45492224</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>SSPT33</td>\n",
       "      <td>349.270833</td>\n",
       "      <td>-58.154167</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>45490944</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>SSPT.gaps.23</td>\n",
       "      <td>347.741667</td>\n",
       "      <td>-58.183333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47014656</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h11m00.5640s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>SSPT67</td>\n",
       "      <td>1.145833</td>\n",
       "      <td>-58.583333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>47593216</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>0h04m06.3430s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2MASS J12364811-0219180</td>\n",
       "      <td>189.200458</td>\n",
       "      <td>-2.321667</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>13778432</td>\n",
       "      <td>244</td>\n",
       "      <td>Metchev, Stanimir</td>\n",
       "      <td>12h36m27.3230s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>SBCS4_06</td>\n",
       "      <td>351.210417</td>\n",
       "      <td>-53.375000</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>42609920</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>SBCS4_06_FCO</td>\n",
       "      <td>351.210417</td>\n",
       "      <td>-53.375000</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>42609408</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>SBCS2323-5258</td>\n",
       "      <td>350.868750</td>\n",
       "      <td>-52.978278</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>23880704</td>\n",
       "      <td>40370</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>SBCS2325-5302</td>\n",
       "      <td>351.341667</td>\n",
       "      <td>-53.041111</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>23876608</td>\n",
       "      <td>40370</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>SBCS2324-5258</td>\n",
       "      <td>351.202083</td>\n",
       "      <td>-52.982278</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>23871232</td>\n",
       "      <td>40370</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>SBCS2322-5337</td>\n",
       "      <td>350.595000</td>\n",
       "      <td>-53.619000</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>23868160</td>\n",
       "      <td>40370</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>SBCS2321-5333</td>\n",
       "      <td>350.454583</td>\n",
       "      <td>-53.560167</td>\n",
       "      <td>IRAC Map</td>\n",
       "      <td>23872000</td>\n",
       "      <td>40370</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>SSPT03_09_FCO</td>\n",
       "      <td>349.791667</td>\n",
       "      <td>-53.808333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>43968256</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>SSPT03_09_FCO</td>\n",
       "      <td>349.791667</td>\n",
       "      <td>-53.808333</td>\n",
       "      <td>IRAC Map PC</td>\n",
       "      <td>43968000</td>\n",
       "      <td>80096</td>\n",
       "      <td>Stanford, Spencer</td>\n",
       "      <td>23h23m57.4146s</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Target_name   RA(J2000)  Dec(J2000) Instrument/Mode    AORKEY  \\\n",
       "0      l148.44527d+1.89767d   60.776678   55.498143     IRAC Map PC  40059392   \n",
       "1      l148.86493d+2.22832d   60.811094   55.387048     IRAC Map PC  40065536   \n",
       "2          147.88094GLIMPSE   60.564211   55.253970     IRAC Map PC  32840192   \n",
       "3                  STRIP-s4   71.138863  -53.599236     IRAC Map PC  44634880   \n",
       "4                   STRIP-4   70.838860  -53.599236     IRAC Map PC  44636672   \n",
       "5                       LMC   73.974292  -69.992303        IRAC Map  14353152   \n",
       "6                       LMC   75.579708  -69.089531        IRAC Map  14353408   \n",
       "7                       LMC   73.689875  -69.859947        IRAC Map  14365696   \n",
       "8                       LMC   75.620208  -68.998842        IRAC Map  14365952   \n",
       "9                   HV00882   74.916667  -69.456111     IRAC Map PC  32230144   \n",
       "10                  HV00882   74.916667  -69.456111     IRAC Map PC  32228096   \n",
       "11                  HV00882   74.916667  -69.456111     IRAC Map PC  32226816   \n",
       "12                  HV00882   74.916667  -69.456111     IRAC Map PC  32229632   \n",
       "13                  HV00882   74.916667  -69.456111     IRAC Map PC  32229120   \n",
       "14                  HV00882   74.916667  -69.456111     IRAC Map PC  32227584   \n",
       "15                  HV00882   74.916667  -69.456111     IRAC Map PC  32227328   \n",
       "16                  HV00882   74.916667  -69.456111     IRAC Map PC  32242944   \n",
       "17                  HV00882   74.916667  -69.456111     IRAC Map PC  32242432   \n",
       "18                  HV00882   74.916667  -69.456111     IRAC Map PC  32243456   \n",
       "19                  HV00882   74.916667  -69.456111     IRAC Map PC  32241920   \n",
       "20                  HV00882   74.916667  -69.456111     IRAC Map PC  32227840   \n",
       "21                  HV00882   74.916667  -69.456111     IRAC Map PC  32228608   \n",
       "22                  HV00882   74.916667  -69.456111     IRAC Map PC  32247808   \n",
       "23                  HV00882   74.916667  -69.456111     IRAC Map PC  32250112   \n",
       "24                  HV00882   74.916667  -69.456111     IRAC Map PC  32252416   \n",
       "25                  HV00882   74.916667  -69.456111     IRAC Map PC  32245504   \n",
       "26                  HV00882   74.916667  -69.456111     IRAC Map PC  32243968   \n",
       "27                  HV00882   74.916667  -69.456111     IRAC Map PC  32247040   \n",
       "28                  HV00882   74.916667  -69.456111     IRAC Map PC  32246272   \n",
       "29                  HV00882   74.916667  -69.456111     IRAC Map PC  32249344   \n",
       "30                  HV00882   74.916667  -69.456111     IRAC Map PC  32251648   \n",
       "31                  HV00882   74.916667  -69.456111     IRAC Map PC  32250880   \n",
       "32                  HV00882   74.916667  -69.456111     IRAC Map PC  32248576   \n",
       "33                 NGC 6701  280.801917   60.653333     IRAC Map PC  42384640   \n",
       "34                 HIP90954  278.310777   40.159634     IRAC Map PC  40646144   \n",
       "35                 UGC12519  350.011542   15.952750        IRAC Map  17404416   \n",
       "36         353.71481GLIMPSE  262.458757  -34.248679        IRAC Map  14322688   \n",
       "37         353.74766GLIMPSE  262.477923  -34.219775        IRAC Map  14292736   \n",
       "38         353.33766GLIMPSE  262.206308  -34.563099        IRAC Map  14322432   \n",
       "39   SPT-23_CL19_J2312-5820  347.998000  -58.340000     IRAC Map PC  37092096   \n",
       "40                   SSPT32  346.958333  -59.116667     IRAC Map PC  45491968   \n",
       "41                   SSPT33  349.270833  -58.154167     IRAC Map PC  45490688   \n",
       "42                   SSPT32  346.958333  -59.116667     IRAC Map PC  45491712   \n",
       "43                   SSPT32  346.958333  -59.116667     IRAC Map PC  45492480   \n",
       "44                   SSPT32  346.958333  -59.116667     IRAC Map PC  45492224   \n",
       "45                   SSPT33  349.270833  -58.154167     IRAC Map PC  45490944   \n",
       "46             SSPT.gaps.23  347.741667  -58.183333     IRAC Map PC  47014656   \n",
       "47                   SSPT67    1.145833  -58.583333     IRAC Map PC  47593216   \n",
       "48  2MASS J12364811-0219180  189.200458   -2.321667        IRAC Map  13778432   \n",
       "49                 SBCS4_06  351.210417  -53.375000     IRAC Map PC  42609920   \n",
       "50             SBCS4_06_FCO  351.210417  -53.375000     IRAC Map PC  42609408   \n",
       "51            SBCS2323-5258  350.868750  -52.978278        IRAC Map  23880704   \n",
       "52            SBCS2325-5302  351.341667  -53.041111        IRAC Map  23876608   \n",
       "53            SBCS2324-5258  351.202083  -52.982278        IRAC Map  23871232   \n",
       "54            SBCS2322-5337  350.595000  -53.619000        IRAC Map  23868160   \n",
       "55            SBCS2321-5333  350.454583  -53.560167        IRAC Map  23872000   \n",
       "56            SSPT03_09_FCO  349.791667  -53.808333     IRAC Map PC  43968256   \n",
       "57            SSPT03_09_FCO  349.791667  -53.808333     IRAC Map PC  43968000   \n",
       "\n",
       "    progid                  PI             Tgt  \n",
       "0    70072  Whitney, Barbara A   4h06m38.8898s  \n",
       "1    70072  Whitney, Barbara A   4h06m38.8898s  \n",
       "2    61070  Whitney, Barbara A   4h06m38.8898s  \n",
       "3    80039   Scarlata, Claudia   4h48m13.2935s  \n",
       "4    80039   Scarlata, Claudia   4h48m13.2935s  \n",
       "5    20203   Meixner, Margaret   4h59m13.5718s  \n",
       "6    20203   Meixner, Margaret   4h59m13.5718s  \n",
       "7    20203   Meixner, Margaret   4h59m13.5718s  \n",
       "8    20203   Meixner, Margaret   4h59m13.5718s  \n",
       "9    61005     Freedman, Wendy   4h59m13.5718s  \n",
       "10   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "11   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "12   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "13   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "14   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "15   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "16   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "17   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "18   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "19   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "20   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "21   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "22   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "23   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "24   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "25   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "26   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "27   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "28   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "29   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "30   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "31   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "32   61005     Freedman, Wendy   4h59m13.5718s  \n",
       "33   80089    Sanders, David B  18h44m04.6069s  \n",
       "34   70076            Su, Kate  18h33m15.2270s  \n",
       "35   30348       Rieke, George  23h20m07.0313s  \n",
       "36   20201      Churchwell, Ed  17h35m05.8228s  \n",
       "37   20201      Churchwell, Ed  17h35m05.8228s  \n",
       "38   20201      Churchwell, Ed  17h35m05.8228s  \n",
       "39   60099       Brodwin, Mark  23h11m00.5640s  \n",
       "40   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "41   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "42   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "43   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "44   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "45   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "46   80096   Stanford, Spencer  23h11m00.5640s  \n",
       "47   80096   Stanford, Spencer   0h04m06.3430s  \n",
       "48     244   Metchev, Stanimir  12h36m27.3230s  \n",
       "49   80096   Stanford, Spencer  23h23m57.4146s  \n",
       "50   80096   Stanford, Spencer  23h23m57.4146s  \n",
       "51   40370   Stanford, Spencer  23h23m57.4146s  \n",
       "52   40370   Stanford, Spencer  23h23m57.4146s  \n",
       "53   40370   Stanford, Spencer  23h23m57.4146s  \n",
       "54   40370   Stanford, Spencer  23h23m57.4146s  \n",
       "55   40370   Stanford, Spencer  23h23m57.4146s  \n",
       "56   80096   Stanford, Spencer  23h23m57.4146s  \n",
       "57   80096   Stanford, Spencer  23h23m57.4146s  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spitzer_tycho"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Conclusion: It is **NOT** worth waiting for TGAS to publish the CRRP calibration, although it may be worth doing another short paper with a comparison when the TGAS results come out *if* we have the 3.6 mags available."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}