jupyter/example_notebook.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f28a6e79",
   "metadata": {},
   "source": [
    "# Example with dummy data\n",
    "\n",
    "This notebook shows a simplified use case utilizing a dummy set of randomly generated particle data. It is by default set to simulate a catalog of stars with Gaia DR2 astrometry & photometry, but you may change the parameters defined below to your liking. In short, the pipeline is accessible via the class `Ananke`, which method `run` can eventually be called after creation of an `Ananke` object to run the full ananke pipeline. The method `run` is designed to returns the catalog in the form of an `Output` object of the submodule `Galaxia_ananke` which can be used as a `vaex` dataframe.\n",
    "\n",
    "Below are the packages that this notebook must import:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f130bf6c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'0.2.0b3.dev1'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import ananke as an\n",
    "an.__version__"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "d0809afe",
   "metadata": {},
   "source": [
    "We define here some dummy input data. `Ananke` has a method `make_dummy_particles_input` to produce such data in a dictionary formatted output. Below we show how to call it and the keys that compose that dictionary."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f4dafbb1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['pos3', 'vel3', 'mass', 'age', 'feh', 'helium', 'carbon', 'nitrogen', 'oxygen', 'neon', 'magnesium', 'silicon', 'sulphur', 'calcium', 'alpha', 'parentid', 'partitionid', 'dform', 'id', 'log10_NH'])"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.random.seed(0)\n",
    "p = an.Ananke.make_dummy_particles_input()\n",
    "p.keys()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51f0f1ae",
   "metadata": {},
   "source": [
    "The input data must be formatted as a dictionary of equal-length arrays. The dictionary must have the following entries:\n",
    "- key `pos3`: particle position coordinates in $kpc$ (shape Nx3)\n",
    "- key `vel3`: particle velocity coordinates in $km.s^{-1}$ (shape Nx3)\n",
    "- key `mass`: particle stellar mass in solar masses\n",
    "- key `age`: particle log10 stellar age in years\n",
    "- key `feh`: particle stellar metallicity \\[Fe/H\\] in dex relative to solar\n",
    "\n",
    "Additionally, the following entries can optionally be added:\n",
    "- key `parentid`: index to give to the parent particle\n",
    "- key `id`: additional index to classify the parent particle\n",
    "- key `log10_NH`: log10 hydrogen column densities between Observer position and particle in $cm^{-2}$ - must be provided to estimate extinctions\n",
    "- key `dform`: particle formation distance\n",
    "- keys `helium`, `carbon`, `nitrogen`, `oxygen`, `neon`, `magnesium`, `silicon`, `sulphur`, `calcium`: particle various chemical abundances \\[X/H\\]\n",
    "- key `alpha`: particle alpha chemical abundances \\[Mg/Fe\\]\n",
    "\n",
    "Ananke will compute the phase space densities that are used to determine particle smoothing lengths, but one can include pre-computed densities with the following entries:\n",
    "- key `rho_pos`: particle density in position space in $kpc^{-3}$\n",
    "- key `rho_vel`: particle density in velocity space in $km^{-3}.s^{3}$\n",
    "\n",
    "At any time, you may access this format via the helper of the `Ananke.make_dummy_particles_input` method using\n",
    "\n",
    "`help(an.Ananke.make_dummy_particles_input)`"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "55c50b11",
   "metadata": {},
   "source": [
    "We define below some parameters for Ananke such as\n",
    " - the observer position `observer`\n",
    " - the shell of particles to mask `rshell`\n",
    " - the sampling factor `fsample`\n",
    " - the photometric system of choice `photo_sys` (in our case Gaia DR2)\n",
    " - the CMD `cmd_magnames` and its box limits `cmd_box`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1ecc74b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "D = 200 # *units.kpc\n",
    "\n",
    "observer = np.nan*np.ones(3)\n",
    "while not np.linalg.norm(observer)<1:\n",
    "    observer = 2*np.random.rand(3)-1\n",
    "\n",
    "observer *= D/np.linalg.norm(observer)\n",
    "\n",
    "rshell = [0, 2*D]\n",
    "\n",
    "fsample = 0.01\n",
    "\n",
    "photo_sys = 'padova/GAIA__DR2'\n",
    "\n",
    "cmd_magnames = {'magnitude': 'G',\n",
    "                'color_minuend': 'Gbp',\n",
    "                'color_subtrahend': 'Grp'}\n",
    "\n",
    "cmd_box = {\n",
    "           'abs_mag_lim_lo': -1000,\n",
    "           'abs_mag_lim_hi': 1000,\n",
    "        #    'app_mag_lim_lo' : -1000,\n",
    "           'app_mag_lim_hi': 30,\n",
    "        #    'color_lim_lo' : -1000,\n",
    "        #    'color_lim_hi' : 1000\n",
    "           }"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8e3b700c",
   "metadata": {},
   "source": [
    "For more details regarding these parameters and more, you may consult the docstring associated to the class `Ananke` via the lines:\n",
    "\n",
    "`help(an.Ananke.__init__)`\n",
    "\n",
    "or\n",
    "\n",
    "`help(an.Ananke)`\n",
    "\n",
    "Note that among those are 3 special parameters, `d_params`, `e_params` and `err_params`, which receive dictionaries of subparameters to configure the sub-steps of the pipeline corresponding respectively to the phase space density estimation, the extinction mapping and the instrument error modeling. Each have further documentation that can be accessed calling the following methods:\n",
    "\n",
    "`an.display_density_docs()` for `d_params`\n",
    "\n",
    "`an.display_extinction_docs()` for `e_params`\n",
    "\n",
    "`an.display_errormodel_docs()` for `err_params`"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "1f132dcb",
   "metadata": {},
   "source": [
    "We show below how to create the `Ananke` pipeline object before calling `run`, using the parameters we defined above."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f56bb9c8",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/athob/miniconda3/envs/main/lib/python3.10/site-packages/ananke/utils.py:26: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  self._record_of_all_used_keys = set()\n",
      "/home/athob/miniconda3/envs/main/lib/python3.10/site-packages/ananke/utils.py:26: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  self._record_of_all_used_keys = set()\n"
     ]
    }
   ],
   "source": [
    "name = 'sim'\n",
    "ananke = an.Ananke(p, name, fsample=fsample,\n",
    "                   observer=observer, rshell=rshell,\n",
    "                   photo_sys=photo_sys, cmd_magnames=cmd_magnames,\n",
    "                   **cmd_box)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "fb2ba696",
   "metadata": {},
   "source": [
    "As mentioned above, the `Ananke` method `run` runs the pipeline once it has been created. Some additional parameters can be provided to this method, which are listed in its docstring (accessible by calling `help(ananke.run)`). Those include:\n",
    "- `input_dir`, `output_dir`, `i_o_dir` - Optional arguments to specify paths for the directories where `ananke` should generate input and output data. If the `i_o_dir` keyword argument is provided, it overrides any path given to the `input_dir` and `output_dir` keyword arguments.\n",
    "- `k_factor` – Scaling factor applied to the kernels lengths to adjust all the kernels sizes uniformly. Lower values reduces the kernels extents, while higher values increases them. Default to 1 (no adjustment).\n",
    "- `surveyname` – Optional name `Galaxia` should use for the output files. Default to `'survey'`.\n",
    "- `n_jobs` – Number of independent catalog generations ran in parallel. Default to 1.\n",
    "- `verbose` – Verbose boolean flag to allow pipeline to print what it's doing to stdout. Default to `True`.\n",
    "- `rand_seed` – Seed to be used by `Galaxia`'s pseudorandom number generator. Default to 17052\n",
    "- `nstart` – Index at which to start indexing synthetic stars. Default to 0\n",
    "For our example however, we will use the method as it is.\n",
    "\n",
    "<!-- > [!WARNING]  \n",
    "> Some of the `run` method parameters are currently not properly implemented, using them may lead to unexpected results -->\n",
    "\n",
    "<div class=\"admonition warning\">\n",
    "<div class=\"title\">Warning</div>\n",
    "<p>Some of the `run` method parameters are currently not properly implemented, using them may lead to unexpected results</p>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f04f19ca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dimensions = 3\n",
      "Normalization constant of Kernel type 3: 0.596831\n",
      "Reading ASCII format file: to_enbid \n",
      "Read 300000 records\n",
      "Allocated 3.8147 MByte for particle storage.\n",
      "Type = 1 Particles = 100000\n",
      "Total particles = 100000\n",
      "Allocated 22.1252 MByte for Binary-Tree and Entropy bins.\n",
      "\n",
      "Scaling Co-ordinates as x[i]=x[i]/h[i] with h[i]->\n",
      "1 1 1 \n",
      "\n",
      "Starting to Build Tree .......\n",
      "Particle Type = 1 First node number = 1\n",
      "                  Last node number  = 199999\n",
      "Total number of nodes = 199999\n",
      "Treebuild time = 0.143194 s \n",
      "\n",
      "Density Calculation. Smoothing .....\n",
      "Evaluated =   1 % Time Left = 0.888813 s of 0.897800 s Par no = 96805 Density = 4.540411e-02 \n",
      "Evaluated =   2 % Time Left = 0.893996 s of 0.912250 s Par no = 55454 Density = 4.964532e-03 \n",
      "Evaluated =   3 % Time Left = 0.930738 s of 0.959533 s Par no = 27717 Density = 1.827217e-01 \n",
      "Evaluated =   4 % Time Left = 1.008973 s of 1.051025 s Par no = 42234 Density = 2.712376e-02 \n",
      "Evaluated =   5 % Time Left = 0.984836 s of 1.036680 s Par no = 99785 Density = 2.988043e-01 \n",
      "Evaluated =   6 % Time Left = 0.996750 s of 1.060383 s Par no = 88021 Density = 1.791133e-01 \n",
      "Evaluated =   7 % Time Left = 1.023016 s of 1.100029 s Par no = 75708 Density = 1.165058e-01 \n",
      "Evaluated =   8 % Time Left = 0.995487 s of 1.082062 s Par no = 45579 Density = 7.255407e-02 \n",
      "Evaluated =   9 % Time Left = 0.962557 s of 1.057767 s Par no = 30351 Density = 8.828938e-02 \n",
      "Evaluated =  10 % Time Left = 0.965734 s of 1.073050 s Par no = 89176 Density = 1.775999e-01 \n",
      "Evaluated =  11 % Time Left = 0.946205 s of 1.063164 s Par no = 60361 Density = 8.299880e-02 \n",
      "Evaluated =  12 % Time Left = 0.933669 s of 1.061000 s Par no = 90082 Density = 2.203585e-01 \n",
      "Evaluated =  13 % Time Left = 0.918602 s of 1.055877 s Par no = 26814 Density = 1.910994e-02 \n",
      "Evaluated =  14 % Time Left = 0.905944 s of 1.053436 s Par no = 74297 Density = 2.157650e-02 \n",
      "Evaluated =  15 % Time Left = 0.897210 s of 1.055553 s Par no = 94905 Density = 9.119637e-02 \n",
      "Evaluated =  16 % Time Left = 0.891172 s of 1.060931 s Par no = 51653 Density = 9.666827e-02 \n",
      "Evaluated =  17 % Time Left = 0.874028 s of 1.053059 s Par no = 39308 Density = 1.287774e-01 \n",
      "Evaluated =  18 % Time Left = 0.864283 s of 1.054017 s Par no = 7800 Density = 4.130107e-02 \n",
      "Evaluated =  19 % Time Left = 0.854753 s of 1.055263 s Par no = 42838 Density = 5.914271e-02 \n",
      "Evaluated =  20 % Time Left = 0.843553 s of 1.054455 s Par no = 49016 Density = 1.554842e-01 \n",
      "Evaluated =  21 % Time Left = 0.835967 s of 1.058200 s Par no = 29173 Density = 5.981785e-02 \n",
      "Evaluated =  22 % Time Left = 0.821485 s of 1.053200 s Par no = 14018 Density = 4.713366e-02 \n",
      "Evaluated =  23 % Time Left = 0.810552 s of 1.052678 s Par no = 90617 Density = 4.088210e-02 \n",
      "Evaluated =  24 % Time Left = 0.801872 s of 1.055108 s Par no = 20588 Density = 1.273882e-01 \n",
      "Evaluated =  25 % Time Left = 0.791734 s of 1.055660 s Par no = 15465 Density = 1.274245e-01 \n",
      "Evaluated =  26 % Time Left = 0.790790 s of 1.068650 s Par no = 99360 Density = 2.044210e-01 \n",
      "Evaluated =  27 % Time Left = 0.778580 s of 1.066563 s Par no = 71132 Density = 2.079416e-02 \n",
      "Evaluated =  28 % Time Left = 0.767180 s of 1.065543 s Par no = 6665 Density = 4.366049e-03 \n",
      "Evaluated =  29 % Time Left = 0.759258 s of 1.069393 s Par no = 44439 Density = 1.463732e-01 \n",
      "Evaluated =  30 % Time Left = 0.751458 s of 1.073527 s Par no = 6386 Density = 1.825200e-01 \n",
      "Evaluated =  31 % Time Left = 0.739453 s of 1.071687 s Par no = 2716 Density = 1.495580e-01 \n",
      "Evaluated =  32 % Time Left = 0.732647 s of 1.077438 s Par no = 69470 Density = 6.785184e-02 \n",
      "Evaluated =  33 % Time Left = 0.730429 s of 1.090209 s Par no = 95884 Density = 1.793627e-01 \n",
      "Evaluated =  34 % Time Left = 0.720346 s of 1.091450 s Par no = 73768 Density = 1.295312e-02 \n",
      "Evaluated =  35 % Time Left = 0.710935 s of 1.093763 s Par no = 47898 Density = 1.088661e-01 \n",
      "Evaluated =  36 % Time Left = 0.696809 s of 1.088781 s Par no = 66396 Density = 3.959183e-02 \n",
      "Evaluated =  37 % Time Left = 0.685564 s of 1.088214 s Par no = 16463 Density = 1.572218e-01 \n",
      "Evaluated =  38 % Time Left = 0.676055 s of 1.090429 s Par no = 55669 Density = 1.712036e-01 \n",
      "Evaluated =  39 % Time Left = 0.671103 s of 1.100187 s Par no = 97705 Density = 1.234432e-01 \n",
      "Evaluated =  40 % Time Left = 0.658281 s of 1.097152 s Par no = 43442 Density = 6.719712e-02 \n",
      "Evaluated =  41 % Time Left = 0.648281 s of 1.098800 s Par no = 10242 Density = 2.102901e-01 \n",
      "Evaluated =  42 % Time Left = 0.640820 s of 1.104881 s Par no = 40929 Density = 1.391802e-01 \n",
      "Evaluated =  43 % Time Left = 0.630903 s of 1.106867 s Par no = 5720 Density = 6.551559e-02 \n",
      "Evaluated =  44 % Time Left = 0.619685 s of 1.106600 s Par no = 66730 Density = 9.093650e-02 \n",
      "Evaluated =  45 % Time Left = 0.614802 s of 1.117842 s Par no = 48819 Density = 2.248662e-01 \n",
      "Evaluated =  46 % Time Left = 0.605400 s of 1.121133 s Par no = 32014 Density = 9.211309e-02 \n",
      "Evaluated =  47 % Time Left = 0.593500 s of 1.119832 s Par no = 31533 Density = 2.932795e-02 \n",
      "Evaluated =  48 % Time Left = 0.580861 s of 1.117062 s Par no = 86677 Density = 1.263195e-01 \n",
      "Evaluated =  49 % Time Left = 0.570218 s of 1.118096 s Par no = 81951 Density = 8.802204e-02 \n",
      "Evaluated =  50 % Time Left = 0.559764 s of 1.119550 s Par no = 80149 Density = 1.559104e-01 \n",
      "Evaluated =  51 % Time Left = 0.547019 s of 1.116388 s Par no = 25229 Density = 5.093939e-02 \n",
      "Evaluated =  52 % Time Left = 0.535691 s of 1.116046 s Par no = 89731 Density = 4.987880e-02 \n",
      "Evaluated =  53 % Time Left = 0.522565 s of 1.111864 s Par no = 76366 Density = 1.511494e-01 \n",
      "Evaluated =  54 % Time Left = 0.511908 s of 1.112869 s Par no = 73159 Density = 1.548675e-02 \n",
      "Evaluated =  55 % Time Left = 0.502202 s of 1.116029 s Par no = 54007 Density = 8.763470e-02 \n",
      "Evaluated =  56 % Time Left = 0.490118 s of 1.113930 s Par no = 36235 Density = 5.465964e-02 \n",
      "Evaluated =  57 % Time Left = 0.478003 s of 1.111660 s Par no = 62068 Density = 4.050222e-02 \n",
      "Evaluated =  58 % Time Left = 0.465324 s of 1.107940 s Par no = 37661 Density = 2.656841e-02 \n",
      "Evaluated =  59 % Time Left = 0.454209 s of 1.107854 s Par no = 67914 Density = 1.940649e-01 \n",
      "Evaluated =  60 % Time Left = 0.443570 s of 1.108952 s Par no = 64732 Density = 5.859731e-02 \n",
      "Evaluated =  61 % Time Left = 0.431286 s of 1.105890 s Par no = 88788 Density = 7.161247e-03 \n",
      "Evaluated =  62 % Time Left = 0.419723 s of 1.104563 s Par no = 44083 Density = 2.877787e-02 \n",
      "Evaluated =  63 % Time Left = 0.407457 s of 1.101265 s Par no = 14045 Density = 3.265437e-02 \n",
      "Evaluated =  64 % Time Left = 0.396103 s of 1.100316 s Par no = 93621 Density = 5.216302e-02 \n",
      "Evaluated =  65 % Time Left = 0.385967 s of 1.102795 s Par no = 9132 Density = 8.411557e-02 \n",
      "Evaluated =  66 % Time Left = 0.374832 s of 1.102480 s Par no = 702 Density = 1.110411e-02 \n",
      "Evaluated =  67 % Time Left = 0.364467 s of 1.104479 s Par no = 45670 Density = 2.465222e-02 \n",
      "Evaluated =  68 % Time Left = 0.352413 s of 1.101324 s Par no = 53860 Density = 1.580593e-02 \n",
      "Evaluated =  69 % Time Left = 0.340855 s of 1.099568 s Par no = 79719 Density = 4.454536e-02 \n",
      "Evaluated =  70 % Time Left = 0.328840 s of 1.096171 s Par no = 96401 Density = 1.035200e-02 \n",
      "Evaluated =  71 % Time Left = 0.317045 s of 1.093297 s Par no = 48105 Density = 3.704987e-02 \n",
      "Evaluated =  72 % Time Left = 0.305846 s of 1.092344 s Par no = 75056 Density = 2.642116e-02 \n",
      "Evaluated =  73 % Time Left = 0.294781 s of 1.091822 s Par no = 97912 Density = 1.775965e-01 \n",
      "Evaluated =  74 % Time Left = 0.284168 s of 1.092997 s Par no = 87879 Density = 7.451773e-02 \n",
      "Evaluated =  75 % Time Left = 0.273578 s of 1.094357 s Par no = 85159 Density = 1.462781e-02 \n",
      "Evaluated =  76 % Time Left = 0.262678 s of 1.094536 s Par no = 78132 Density = 5.302110e-02 \n",
      "Evaluated =  77 % Time Left = 0.251385 s of 1.093026 s Par no = 21990 Density = 3.497640e-03 \n",
      "Evaluated =  78 % Time Left = 0.240011 s of 1.091010 s Par no = 16462 Density = 2.482335e-02 \n",
      "Evaluated =  79 % Time Left = 0.228880 s of 1.089954 s Par no = 22311 Density = 3.571432e-02 \n",
      "Evaluated =  80 % Time Left = 0.217506 s of 1.087585 s Par no = 43269 Density = 1.776266e-02 \n",
      "Evaluated =  81 % Time Left = 0.207566 s of 1.092510 s Par no = 43142 Density = 1.532303e-02 \n",
      "Evaluated =  82 % Time Left = 0.196555 s of 1.092035 s Par no = 52197 Density = 3.049044e-02 \n",
      "Evaluated =  83 % Time Left = 0.185608 s of 1.091878 s Par no = 74476 Density = 1.449572e-01 \n",
      "Evaluated =  84 % Time Left = 0.174773 s of 1.092398 s Par no = 8891 Density = 1.050831e-02 \n",
      "Evaluated =  85 % Time Left = 0.163702 s of 1.091422 s Par no = 1559 Density = 1.452041e-03 \n",
      "Evaluated =  86 % Time Left = 0.152853 s of 1.091883 s Par no = 20602 Density = 2.028735e-01 \n",
      "Evaluated =  87 % Time Left = 0.141906 s of 1.091667 s Par no = 54383 Density = 2.137116e-01 \n",
      "Evaluated =  88 % Time Left = 0.131495 s of 1.095884 s Par no = 70246 Density = 2.757094e-03 \n",
      "Evaluated =  89 % Time Left = 0.120677 s of 1.097165 s Par no = 51472 Density = 5.058417e-04 \n",
      "Evaluated =  90 % Time Left = 0.109524 s of 1.095347 s Par no = 66269 Density = 3.630537e-02 \n",
      "Evaluated =  91 % Time Left = 0.098713 s of 1.096935 s Par no = 62858 Density = 1.776033e-01 \n",
      "Evaluated =  92 % Time Left = 0.087916 s of 1.099087 s Par no = 84061 Density = 1.439860e-01 \n",
      "Evaluated =  93 % Time Left = 0.077034 s of 1.100645 s Par no = 78610 Density = 4.029672e-03 \n",
      "Evaluated =  94 % Time Left = 0.066108 s of 1.101979 s Par no = 3871 Density = 1.597447e-01 \n",
      "Evaluated =  95 % Time Left = 0.055286 s of 1.105945 s Par no = 68736 Density = 1.582606e-01 \n",
      "Evaluated =  96 % Time Left = 0.044355 s of 1.109157 s Par no = 30472 Density = 6.743145e-02 \n",
      "Evaluated =  97 % Time Left = 0.033248 s of 1.108635 s Par no = 86838 Density = 1.353215e-03 \n",
      "Evaluated =  98 % Time Left = 0.022185 s of 1.109796 s Par no = 92913 Density = 5.211162e-02 \n",
      "Evaluated =  99 % Time Left = 0.011119 s of 1.112996 s Par no = 30015 Density = 9.179291e-04 \n",
      "Evaluated = 100 % Time Left = -0.000011 s of 1.117604 s Par no = 86525 Density = 1.579017e-04 \n",
      "\n",
      "Total Smoothing Time = 1.11765 s\n",
      "1 3\n",
      "\n",
      "writing snapshot file ....\n",
      "to_enbid_d3n64.est\n",
      "done with snapshot.\n",
      "\n",
      "Total Time = 1.58844 s \n",
      "\n",
      "Dimensions = 3\n",
      "Normalization constant of Kernel type 3: 0.596831\n",
      "Reading ASCII format file: to_enbid \n",
      "Read 300000 records\n",
      "Allocated 3.8147 MByte for particle storage.\n",
      "Type = 1 Particles = 100000\n",
      "Total particles = 100000\n",
      "Allocated 22.1252 MByte for Binary-Tree and Entropy bins.\n",
      "\n",
      "Scaling Co-ordinates as x[i]=x[i]/h[i] with h[i]->\n",
      "1 1 1 \n",
      "\n",
      "Starting to Build Tree .......\n",
      "Particle Type = 1 First node number = 1\n",
      "                  Last node number  = 199999\n",
      "Total number of nodes = 199999\n",
      "Treebuild time = 0.136763 s \n",
      "\n",
      "Density Calculation. Smoothing .....\n",
      "Evaluated =   1 % Time Left = 0.892080 s of 0.901100 s Par no = 3379 Density = 1.586355e-02 \n",
      "Evaluated =   2 % Time Left = 0.887773 s of 0.905900 s Par no = 75725 Density = 4.756319e-02 \n",
      "Evaluated =   3 % Time Left = 1.027155 s of 1.058933 s Par no = 95160 Density = 6.928090e-03 \n",
      "Evaluated =   4 % Time Left = 0.996830 s of 1.038375 s Par no = 40983 Density = 2.235913e-02 \n",
      "Evaluated =   5 % Time Left = 0.991676 s of 1.043880 s Par no = 79587 Density = 2.321368e-02 \n",
      "Evaluated =   6 % Time Left = 0.997157 s of 1.060817 s Par no = 62143 Density = 2.106821e-02 \n",
      "Evaluated =   7 % Time Left = 0.961198 s of 1.033557 s Par no = 48098 Density = 2.322558e-02 \n",
      "Evaluated =   8 % Time Left = 0.951546 s of 1.034300 s Par no = 73424 Density = 1.566558e-02 \n",
      "Evaluated =   9 % Time Left = 0.940020 s of 1.033000 s Par no = 41738 Density = 1.527212e-02 \n",
      "Evaluated =  10 % Time Left = 0.930662 s of 1.034080 s Par no = 34821 Density = 3.462067e-02 \n",
      "Evaluated =  11 % Time Left = 0.930412 s of 1.045418 s Par no = 99566 Density = 5.806165e-02 \n",
      "Evaluated =  12 % Time Left = 0.930751 s of 1.057683 s Par no = 59443 Density = 1.071449e-02 \n",
      "Evaluated =  13 % Time Left = 0.913095 s of 1.049546 s Par no = 7663 Density = 2.551240e-03 \n",
      "Evaluated =  14 % Time Left = 0.917278 s of 1.066614 s Par no = 69540 Density = 2.717029e-02 \n",
      "Evaluated =  15 % Time Left = 0.908152 s of 1.068427 s Par no = 28859 Density = 1.270314e-02 \n",
      "Evaluated =  16 % Time Left = 0.891308 s of 1.061094 s Par no = 77774 Density = 2.211896e-02 \n",
      "Evaluated =  17 % Time Left = 0.878476 s of 1.058418 s Par no = 65109 Density = 3.644556e-03 \n",
      "Evaluated =  18 % Time Left = 0.861345 s of 1.050433 s Par no = 17146 Density = 6.157028e-03 \n",
      "Evaluated =  19 % Time Left = 0.852702 s of 1.052732 s Par no = 79145 Density = 2.474514e-02 \n",
      "Evaluated =  20 % Time Left = 0.840181 s of 1.050240 s Par no = 84563 Density = 3.054690e-02 \n",
      "Evaluated =  21 % Time Left = 0.843901 s of 1.068243 s Par no = 35101 Density = 3.370794e-02 \n",
      "Evaluated =  22 % Time Left = 0.835313 s of 1.070927 s Par no = 31911 Density = 1.401559e-03 \n",
      "Evaluated =  23 % Time Left = 0.820331 s of 1.065378 s Par no = 96514 Density = 1.869492e-02 \n",
      "Evaluated =  24 % Time Left = 0.813085 s of 1.069862 s Par no = 41208 Density = 4.063115e-02 \n",
      "Evaluated =  25 % Time Left = 0.799555 s of 1.066088 s Par no = 50899 Density = 1.130457e-03 \n",
      "Evaluated =  26 % Time Left = 0.789820 s of 1.067338 s Par no = 25354 Density = 2.573581e-02 \n",
      "Evaluated =  27 % Time Left = 0.776453 s of 1.063648 s Par no = 38397 Density = 1.824382e-02 \n",
      "Evaluated =  28 % Time Left = 0.771071 s of 1.070946 s Par no = 99925 Density = 5.098955e-02 \n",
      "Evaluated =  29 % Time Left = 0.762490 s of 1.073945 s Par no = 67233 Density = 3.835664e-02 \n",
      "Evaluated =  30 % Time Left = 0.754326 s of 1.077623 s Par no = 21415 Density = 1.821073e-02 \n",
      "Evaluated =  31 % Time Left = 0.740437 s of 1.073113 s Par no = 39830 Density = 5.986182e-03 \n",
      "Evaluated =  32 % Time Left = 0.728516 s of 1.071362 s Par no = 62656 Density = 1.851001e-03 \n",
      "Evaluated =  33 % Time Left = 0.718556 s of 1.072488 s Par no = 48049 Density = 1.832367e-02 \n",
      "Evaluated =  34 % Time Left = 0.708457 s of 1.073435 s Par no = 71467 Density = 3.566542e-02 \n",
      "Evaluated =  35 % Time Left = 0.696604 s of 1.071714 s Par no = 94467 Density = 8.080338e-03 \n",
      "Evaluated =  36 % Time Left = 0.684517 s of 1.069575 s Par no = 24663 Density = 3.556317e-02 \n",
      "Evaluated =  37 % Time Left = 0.675828 s of 1.072759 s Par no = 55355 Density = 2.436876e-02 \n",
      "Evaluated =  38 % Time Left = 0.666608 s of 1.075192 s Par no = 77628 Density = 3.192216e-02 \n",
      "Evaluated =  39 % Time Left = 0.654754 s of 1.073385 s Par no = 6428 Density = 3.955819e-02 \n",
      "Evaluated =  40 % Time Left = 0.644130 s of 1.073568 s Par no = 29219 Density = 3.686058e-04 \n",
      "Evaluated =  41 % Time Left = 0.632240 s of 1.071612 s Par no = 11475 Density = 1.075123e-02 \n",
      "Evaluated =  42 % Time Left = 0.625072 s of 1.077729 s Par no = 25064 Density = 3.927625e-02 \n",
      "Evaluated =  43 % Time Left = 0.612986 s of 1.075433 s Par no = 14672 Density = 1.066699e-02 \n",
      "Evaluated =  44 % Time Left = 0.602582 s of 1.076059 s Par no = 46917 Density = 2.114631e-02 \n",
      "Evaluated =  45 % Time Left = 0.591244 s of 1.075009 s Par no = 35522 Density = 9.714150e-03 \n",
      "Evaluated =  46 % Time Left = 0.581810 s of 1.077446 s Par no = 10564 Density = 2.478037e-03 \n",
      "Evaluated =  47 % Time Left = 0.570323 s of 1.076102 s Par no = 90836 Density = 3.490644e-02 \n",
      "Evaluated =  48 % Time Left = 0.559521 s of 1.076023 s Par no = 91231 Density = 8.647473e-03 \n",
      "Evaluated =  49 % Time Left = 0.551406 s of 1.081210 s Par no = 16819 Density = 9.508127e-03 \n",
      "Evaluated =  50 % Time Left = 0.540048 s of 1.080118 s Par no = 30766 Density = 4.927925e-03 \n",
      "Evaluated =  51 % Time Left = 0.531778 s of 1.085284 s Par no = 9459 Density = 7.940475e-03 \n",
      "Evaluated =  52 % Time Left = 0.520130 s of 1.083627 s Par no = 76505 Density = 8.072356e-03 \n",
      "Evaluated =  53 % Time Left = 0.509478 s of 1.084019 s Par no = 52019 Density = 3.462386e-03 \n",
      "Evaluated =  54 % Time Left = 0.499046 s of 1.084906 s Par no = 56938 Density = 1.337130e-02 \n",
      "Evaluated =  55 % Time Left = 0.487966 s of 1.084393 s Par no = 33321 Density = 2.006831e-02 \n",
      "Evaluated =  56 % Time Left = 0.477613 s of 1.085509 s Par no = 4046 Density = 2.271462e-02 \n",
      "Evaluated =  57 % Time Left = 0.466864 s of 1.085754 s Par no = 68529 Density = 3.147267e-02 \n",
      "Evaluated =  58 % Time Left = 0.458616 s of 1.091969 s Par no = 23845 Density = 3.357711e-02 \n",
      "Evaluated =  59 % Time Left = 0.447998 s of 1.092705 s Par no = 57420 Density = 3.986822e-02 \n",
      "Evaluated =  60 % Time Left = 0.437418 s of 1.093573 s Par no = 89896 Density = 3.369183e-03 \n",
      "Evaluated =  61 % Time Left = 0.425843 s of 1.091933 s Par no = 39610 Density = 1.535302e-03 \n",
      "Evaluated =  62 % Time Left = 0.414487 s of 1.090784 s Par no = 26107 Density = 4.015532e-03 \n",
      "Evaluated =  63 % Time Left = 0.402833 s of 1.088767 s Par no = 98943 Density = 1.799383e-03 \n",
      "Evaluated =  64 % Time Left = 0.391194 s of 1.086681 s Par no = 99085 Density = 1.412553e-02 \n",
      "Evaluated =  65 % Time Left = 0.380237 s of 1.086423 s Par no = 17 Density = 1.179375e-02 \n",
      "Evaluated =  66 % Time Left = 0.367965 s of 1.082282 s Par no = 3087 Density = 1.429490e-02 \n",
      "Evaluated =  67 % Time Left = 0.358527 s of 1.086478 s Par no = 86468 Density = 2.256122e-02 \n",
      "Evaluated =  68 % Time Left = 0.347217 s of 1.085087 s Par no = 52080 Density = 4.635496e-03 \n",
      "Evaluated =  69 % Time Left = 0.335607 s of 1.082638 s Par no = 26417 Density = 1.433997e-02 \n",
      "Evaluated =  70 % Time Left = 0.324454 s of 1.081550 s Par no = 79634 Density = 7.429452e-03 \n",
      "Evaluated =  71 % Time Left = 0.313491 s of 1.081039 s Par no = 97643 Density = 2.184668e-04 \n",
      "Evaluated =  72 % Time Left = 0.302889 s of 1.081785 s Par no = 78794 Density = 5.369595e-03 \n",
      "Evaluated =  73 % Time Left = 0.291475 s of 1.079578 s Par no = 45708 Density = 1.294336e-02 \n",
      "Evaluated =  74 % Time Left = 0.279958 s of 1.076803 s Par no = 66525 Density = 2.125199e-03 \n",
      "Evaluated =  75 % Time Left = 0.268972 s of 1.075932 s Par no = 21984 Density = 8.619656e-04 \n",
      "Evaluated =  76 % Time Left = 0.257868 s of 1.074495 s Par no = 43799 Density = 2.740289e-03 \n",
      "Evaluated =  77 % Time Left = 0.246918 s of 1.073601 s Par no = 63854 Density = 3.854665e-03 \n",
      "Evaluated =  78 % Time Left = 0.235597 s of 1.070942 s Par no = 91160 Density = 2.256671e-03 \n",
      "Evaluated =  79 % Time Left = 0.224715 s of 1.070120 s Par no = 1891 Density = 1.555006e-04 \n",
      "Evaluated =  80 % Time Left = 0.214112 s of 1.070611 s Par no = 17306 Density = 9.342227e-04 \n",
      "Evaluated =  81 % Time Left = 0.203401 s of 1.070590 s Par no = 83119 Density = 2.469888e-02 \n",
      "Evaluated =  82 % Time Left = 0.192605 s of 1.070085 s Par no = 73346 Density = 1.956386e-03 \n",
      "Evaluated =  83 % Time Left = 0.181832 s of 1.069663 s Par no = 98412 Density = 4.288590e-03 \n",
      "Evaluated =  84 % Time Left = 0.171185 s of 1.069971 s Par no = 52509 Density = 8.264857e-03 \n",
      "Evaluated =  85 % Time Left = 0.160706 s of 1.071444 s Par no = 76716 Density = 3.547589e-02 \n",
      "Evaluated =  86 % Time Left = 0.150307 s of 1.073700 s Par no = 95957 Density = 2.923764e-02 \n",
      "Evaluated =  87 % Time Left = 0.139398 s of 1.072372 s Par no = 3295 Density = 1.361911e-02 \n",
      "Evaluated =  88 % Time Left = 0.128705 s of 1.072627 s Par no = 4026 Density = 3.781490e-02 \n",
      "Evaluated =  89 % Time Left = 0.118087 s of 1.073613 s Par no = 78656 Density = 6.492402e-02 \n",
      "Evaluated =  90 % Time Left = 0.107702 s of 1.077129 s Par no = 9255 Density = 4.661644e-02 \n",
      "Evaluated =  91 % Time Left = 0.097031 s of 1.078237 s Par no = 89389 Density = 2.612382e-03 \n",
      "Evaluated =  92 % Time Left = 0.086066 s of 1.075957 s Par no = 91357 Density = 1.136847e-02 \n",
      "Evaluated =  93 % Time Left = 0.075423 s of 1.077625 s Par no = 75212 Density = 1.186542e-02 \n",
      "Evaluated =  94 % Time Left = 0.064795 s of 1.080093 s Par no = 79246 Density = 4.605766e-02 \n",
      "Evaluated =  95 % Time Left = 0.054280 s of 1.085808 s Par no = 93038 Density = 2.164083e-02 \n",
      "Evaluated =  96 % Time Left = 0.043545 s of 1.088903 s Par no = 65384 Density = 2.308048e-02 \n",
      "Evaluated =  97 % Time Left = 0.032629 s of 1.088001 s Par no = 32352 Density = 1.225704e-03 \n",
      "Evaluated =  98 % Time Left = 0.021788 s of 1.089967 s Par no = 16971 Density = 3.436726e-02 \n",
      "Evaluated =  99 % Time Left = 0.010898 s of 1.090921 s Par no = 22517 Density = 2.430708e-02 \n",
      "Evaluated = 100 % Time Left = -0.000011 s of 1.092271 s Par no = 42877 Density = 2.940734e-06 \n",
      "\n",
      "Total Smoothing Time = 1.09234 s\n",
      "1 3\n",
      "\n",
      "writing snapshot file ....\n",
      "to_enbid_d3n64.est\n",
      "done with snapshot.\n",
      "\n",
      "Total Time = 1.54018 s \n",
      "\n",
      "Executing JOB 1/1 = /home/athob/miniconda3/envs/main/.cache/Galaxia_ananke/bin/galaxia -r --hdim=6 --nfile=sim --ngen=0 /home/athob/Software/repos/py-ananke/jupyter/survey_params\n",
      "JOB 1/1 | CODEDATAPATH=/home/athob/miniconda3/envs/main/.cache/Galaxia_ananke/GalaxiaData/\n",
      "JOB 1/1 | Reading Parameter file-             /home/athob/Software/repos/py-ananke/jupyter/survey_params\n",
      "JOB 1/1 | --------------------------------------------------------\n",
      "JOB 1/1 | outputFile               survey                  \n",
      "JOB 1/1 | outputDir                /home/athob/Software/repos/py-ananke/jupyter\n",
      "JOB 1/1 | photoCateg               padova                  \n",
      "JOB 1/1 | photoSys                 GAIA__DR2               \n",
      "JOB 1/1 | magcolorNames            G,Gbp-Grp               \n",
      "JOB 1/1 | appMagLimits[0]          -1000                   \n",
      "JOB 1/1 | appMagLimits[1]          30                      \n",
      "JOB 1/1 | absMagLimits[0]          -1000                   \n",
      "JOB 1/1 | absMagLimits[1]          1000                    \n",
      "JOB 1/1 | colorLimits[0]           -1000                   \n",
      "JOB 1/1 | colorLimits[1]           1000                    \n",
      "JOB 1/1 | geometryOption           0                       \n",
      "JOB 1/1 | surveyArea               207.455                 \n",
      "JOB 1/1 | fSample                  0.01                    \n",
      "JOB 1/1 | popID                    10                      \n",
      "JOB 1/1 | warpFlareOn              0                       \n",
      "JOB 1/1 | longitude                76.273                  \n",
      "JOB 1/1 | latitude                 13.4725                 \n",
      "JOB 1/1 | starType                 0                       \n",
      "JOB 1/1 | photoError               0                       \n",
      "JOB 1/1 | seed                     17052                   \n",
      "JOB 1/1 | r_max                    400                     \n",
      "JOB 1/1 | r_min                    0                       \n",
      "JOB 1/1 | nres                     64                      \n",
      "JOB 1/1 | nstart                   0                       \n",
      "JOB 1/1 | rSun[0]                  194.95682580382555      \n",
      "JOB 1/1 | rSun[1]                  -34.20370085093144      \n",
      "JOB 1/1 | rSun[2]                  28.66954691997796       \n",
      "JOB 1/1 | vSun[0]                  12.9                    \n",
      "JOB 1/1 | vSun[1]                  245.6                   \n",
      "JOB 1/1 | vSun[2]                  7.78                    \n",
      "JOB 1/1 | --------------------------------------------------------\n",
      "JOB 1/1 | Reading Halo Sat File=/home/athob/miniconda3/envs/main/.cache/Galaxia_ananke/GalaxiaData/nbody1/filenames/sim.txt\n",
      "JOB 1/1 | nbody1/sim/\n",
      "JOB 1/1 | \n",
      "JOB 1/1 | \t1\t1\n",
      "JOB 1/1 | \n",
      "JOB 1/1 | path nbody1/sim/ sats 1 x[0] 1\n",
      "JOB 1/1 | Halo 1 Sat 0 fname nbody1/sim/sim.ebf 0\n",
      "JOB 1/1 | nbody1/sim/sim.ebf 0\n",
      "JOB 1/1 | No of Satellites   =1\n",
      "JOB 1/1 | Generating catalog. Max allowed stars is 18446744073709551615\n",
      "JOB 1/1 | Source numbering will start at 0\n",
      "JOB 1/1 | Writing to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.ebf\n",
      "JOB 1/1 | Using geometry:                     All Sky\n",
      "JOB 1/1 | setting center to 194.957 -34.2037 28.6695 12.9 245.6 7.78\n",
      "JOB 1/1 | Reading Isochrones from dir-        /home/athob/miniconda3/envs/main/.cache/Galaxia_ananke/GalaxiaData/Isochrones/padova/GAIA__DR2\n",
      "JOB 1/1 | Isochrone Grid Size:                (Age bins=71,Feh bins=34,Alpha bins=1)\n",
      "JOB 1/1 | Time Isochrone Reading              3.20769     \n",
      "JOB 1/1 | ------------------------------\n",
      "JOB 1/1 | nbody1/sim/sim.ebf  Sat No=0\n",
      "JOB 1/1 | Particles=100000\n",
      "JOB 1/1 | Satellite Info\n",
      "JOB 1/1 | Particles=100000 Mass=5.49989e+08 0.379706\n",
      "JOB 1/1 | Total Stars=2280137 accepted=1614163 rejected=665974\n",
      "JOB 1/1 | -----------Done---------------\n",
      "JOB 1/1 | Total stars written                 1614163                 \n",
      "JOB 1/1 | 31\n",
      "JOB 1/1 | File written-                       /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.ebf\n",
      "JOB 1/1 | Calculating magnitudes in GAIA__DR2 system................\n",
      "JOB 1/1 | initializing isochrone data\n",
      "JOB 1/1 | interpolating on isochrone tables\n",
      "JOB 1/1 | Appending spherical coordinates................\n",
      "JOB 1/1 | Total Time=                         7.44586     \n",
      "Exported the following quantities from /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.ebf to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5 for partition 0\n",
      "['age', 'alpha', 'calcium', 'carbon', 'dec', 'dform', 'dmod', 'feh', 'gaia__dr2_g', 'gaia__dr2_gbp', 'gaia__dr2_grp', 'glat', 'glon', 'grav', 'helium', 'lum', 'mact', 'magnesium', 'mtip', 'neon', 'nitrogen', 'oxygen', 'parentid', 'partid', 'partitionid', 'px', 'py', 'pz', 'ra', 'rad', 'satid', 'silicon', 'smass', 'sulphur', 'teff', 'vx', 'vy', 'vz']\n",
      "Running convert_cartesian_to_galactic post-processing pipeline\n",
      "Exported the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "['mul', 'vr', 'mub']\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('glon', 'glat', 'rad')\n",
      "Running convert_galactic_to_icrs post-processing pipeline\n",
      "Exported the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "['mudec', 'mura']\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('ra', 'dec')\n",
      "Running last_conversions post-processing pipeline\n",
      "Exported the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "['pi']\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('teff', 'lum')\n",
      "Running observed_magnitudes post-processing pipeline\n",
      "Exported the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "['gaia__dr2_grp_Intrinsic', 'gaia__dr2_g_Intrinsic', 'gaia__dr2_gbp_Intrinsic']\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('gaia__dr2_g', 'gaia__dr2_gbp', 'gaia__dr2_grp')\n",
      "Running extinctions post-processing pipeline\n",
      "Exported the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "['A_0', 'E(B-V)', 'A_gaia__dr2_g', 'A_gaia__dr2_gbp', 'log10_NH', 'A_gaia__dr2_grp']\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('gaia__dr2_g', 'gaia__dr2_gbp', 'gaia__dr2_grp')\n",
      "Running error_modeling post-processing pipeline\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/athob/miniconda3/envs/main/lib/python3.10/site-packages/ananke/utils.py:26: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access\n",
      "  self._record_of_all_used_keys = set()\n",
      "/home/athob/miniconda3/envs/main/lib/python3.10/site-packages/ananke/_default_error_model.py:37: RuntimeWarning: overflow encountered in power\n",
      "  grvs = rpmag + 132.32 - 377.28*ggrp + 402.32*ggrp**2 - 190.97*ggrp**3 + 34.026*ggrp**4\n",
      "/home/athob/miniconda3/envs/main/lib/python3.10/site-packages/ananke/_default_error_model.py:37: RuntimeWarning: overflow encountered in multiply\n",
      "  grvs = rpmag + 132.32 - 377.28*ggrp + 402.32*ggrp**2 - 190.97*ggrp**3 + 34.026*ggrp**4\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Exported the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "['mura_Sig', 'ra_Err', 'vr_Sig', 'vr_Err', 'pi_Sig', 'gaia__dr2_grp_Sig', 'mura_Err', 'dec_Err', 'mudec_Err', 'gaia__dr2_g_Sig', 'gaia__dr2_g_Err', 'dec_Sig', 'gaia__dr2_gbp_Sig', 'pi_Err', 'ra_Sig', 'gaia__dr2_grp_Err', 'gaia__dr2_gbp_Err', 'mudec_Sig']\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('mura', 'dec', 'gaia__dr2_grp', 'pi', 'gaia__dr2_g', 'ra', 'mudec', 'gaia__dr2_gbp', 'vr')\n",
      "Running convert_icrs_to_galactic post-processing pipeline\n",
      "Overwritten the following quantities to /home/athob/Software/repos/py-ananke/jupyter/survey.sim.0.h5\n",
      "('glon', 'glat', 'mul', 'mub')\n"
     ]
    }
   ],
   "source": [
    "survey = ananke.run()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "1664586c",
   "metadata": {},
   "source": [
    "The output is saved as a `vaex` dataframe, with its columns organized in alphabetical order. The photometry is stored in columns that are named according to their associated photometric system and filter name. The keys are in the lowercase format `photosys_filtername` where `photo_sys` is the photometric system and `filtername` is the filter name. In this example, the apparent photometry in filters `gbp`, `grp` & `g` of the Gaia DR2 system (identified as `GAIA__DR2` in Galaxia) are respectively under keys `gaia__dr2_gbp`, `gaia__dr2_grp` & `gaia__dr2_g`. Beside these, the columns include:\n",
    "\n",
    "- key `A_0` for the reference extinction which extinction coefficients are based on (at $\\lambda = 550 \\, nm$ in the case of Gaia DR2)\n",
    "- key `A_{filter_name}` for the extinction value in each filter designated by `filter_name` (here `A_gaia__dr2_g`, `A_gaia__dr2_gbp` & `A_gaia__dr2_grp`)\n",
    "- key `E(B-V)` for the reddening index\n",
    "- key `age` for the $log_{10}$ stellar age in years\n",
    "- key `alpha`, `calcium`, `carbon`, `helium`, `magnesium`, `neon`, `nitrogen`, `oxygen`, `silicon`, `sulphur` for the various chemical abundances as given as input\n",
    "- key `dec`, `ra` for the astrometric declination and right ascension celestial coordinates in degrees\n",
    "- key `dform` for the formation distance as given as input\n",
    "- key `dmod` for the distance modulus\n",
    "- key `feh` for the stellar metallicity \\[Fe/H\\] in dex relative to solar\n",
    "- key `{filter_name}_Intrinsic` for the intrinsic stellar photometry in each filter designated by `filter_name` (here `gaia__dr2_g_Intrinsic`, `gaia__dr2_gbp_Intrinsic` & `gaia__dr2_grp_Intrinsic`)\n",
    "- key `glat`, `glon` for the astrometric galactic latitude and longitude celestrial coordinates in degrees\n",
    "- key `grav` for the $log_{10}$ surface gravity in CGS units\n",
    "- key `log10_NH` for the $log_{10}$ hydrogen column density between Observer position and star in $cm^{-2}$\n",
    "- key `lum` for the stellar luminosity in solar luminosities\n",
    "- key `mact`, `mtip`, `smass` for respectively the current stellar mass, the mass of that same star at tip of giant branch for its given age \\& metallicity and its stellar mass on zero-age main sequence, all in solar masses\n",
    "- key `mub`, `mudec`, `mul`, `mura` for the astrometric proper motions, respectively in the direction of the galactic latitude, declination, galactic longitude and right ascension, all in milliarcseconds per year\n",
    "- key `parentid` for the parent particle index as given as input\n",
    "- key `partid` for the flag that identifies stars that are *not* central relatively to their parent particle\n",
    "- key `pi` for the star parallax in milliarcseconds\n",
    "- key `px`, `py`, `pz` for the star position cartesian coordinates in $kpc$ relative to the Observer's position\n",
    "- key `rad` for the star distance to the Observer in $kpc$\n",
    "- key `satid` for the index ``id`` the population the parent particle is part of\n",
    "- key `teff` for the star effective temperature in Kelvin\n",
    "- key `vr` for the star astrometric radial velocity in $km.s^{-1}$\n",
    "- key `vx`, `vy`, `vz` for the star velocity cartesian coordinates in $km.s^{-1}$ relative to the Observer's velocity\n",
    "\n",
    "Additionally, astrometric and photometric quantities `X` all have associated columns identified as:\n",
    "- key `{X}_Sig` for the standard error on the quantity `X`\n",
    "- key `{X}_Err` for the actual drawn gaussian error on the quantity `X`\n",
    "\n",
    "Taking the photometry as an example of the latter, the standard errors are stored under `gaia__dr2_g_Sig`, `gaia__dr2_gbp_Sig` & `gaia__dr2_grp_Sig`, while the drawn errors are under `gaia__dr2_g_Err`, `gaia__dr2_gbp_Err` & `gaia__dr2_grp_Err`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "42e393f6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>.vaex-description pre {\n",
       "          max-width : 450px;\n",
       "          white-space : nowrap;\n",
       "          overflow : hidden;\n",
       "          text-overflow: ellipsis;\n",
       "        }\n",
       "\n",
       "        .vex-description pre:hover {\n",
       "          max-width : initial;\n",
       "          white-space: pre;\n",
       "        }</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead>\n",
       "<tr><th>#                                    </th><th>A_0               </th><th>A_gaia__dr2_g      </th><th>A_gaia__dr2_gbp   </th><th>A_gaia__dr2_grp    </th><th>E(B-V)             </th><th>age               </th><th>alpha             </th><th>calcium            </th><th>carbon              </th><th>dec  </th><th>dec_Err  </th><th>dec_Sig  </th><th>dform  </th><th>dmod              </th><th>feh                </th><th>gaia__dr2_g  </th><th>gaia__dr2_g_Err  </th><th>gaia__dr2_g_Intrinsic  </th><th>gaia__dr2_g_Sig  </th><th>gaia__dr2_gbp  </th><th>gaia__dr2_gbp_Err  </th><th>gaia__dr2_gbp_Intrinsic  </th><th>gaia__dr2_gbp_Sig  </th><th>gaia__dr2_grp  </th><th>gaia__dr2_grp_Err  </th><th>gaia__dr2_grp_Intrinsic  </th><th>gaia__dr2_grp_Sig  </th><th>glat  </th><th>glon  </th><th>grav     </th><th>helium              </th><th>log10_NH          </th><th>lum        </th><th>mact      </th><th>magnesium           </th><th>mtip      </th><th>mub  </th><th>mudec  </th><th>mudec_Err  </th><th>mudec_Sig  </th><th>mul  </th><th>mura  </th><th>mura_Err  </th><th>mura_Sig  </th><th>neon               </th><th>nitrogen          </th><th>oxygen             </th><th>parentid  </th><th>partid  </th><th>partitionid  </th><th>pi  </th><th>pi_Err  </th><th>pi_Sig  </th><th>px                 </th><th>py                </th><th>pz                  </th><th>ra  </th><th>ra_Err  </th><th>ra_Sig  </th><th>rad               </th><th>satid  </th><th>silicon            </th><th>smass              </th><th>sulphur            </th><th>teff     </th><th>vr  </th><th>vr_Err  </th><th>vr_Sig  </th><th>vx                </th><th>vy                 </th><th>vz                 </th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "<tr><td><i style='opacity: 0.6'>0</i>        </td><td>0.7093970129666607</td><td>0.5278885380814685 </td><td>0.7125676091560069</td><td>0.40701678341228237</td><td>0.22883774611827765</td><td>10.016325950622559</td><td>0.3380742371082306</td><td>-1.1830222606658936</td><td>-0.39430123567581177</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>20.87123488088669 </td><td>-0.8867433071136475</td><td>nan          </td><td>nan              </td><td>7.6075797              </td><td>nan              </td><td>nan            </td><td>nan                </td><td>8.22037                  </td><td>nan                </td><td>nan            </td><td>nan                </td><td>6.875088                 </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.7529893</td><td>-0.7315406799316406 </td><td>21.757467670308863</td><td>0.08502915 </td><td>0.52380776</td><td>-0.5486690402030945 </td><td>0.886202  </td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.7326117157936096</td><td>-0.652482807636261</td><td>-0.6697278618812561</td><td>0         </td><td>0       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-142.0352559796068 </td><td>46.20841677042607 </td><td>0.6925918281909844  </td><td>nan </td><td>nan     </td><td>nan     </td><td>149.3643578805275 </td><td>0      </td><td>-0.7563512325286865</td><td>0.5240775107307198 </td><td>-1.0924330949783325</td><td>4399.992 </td><td>nan </td><td>nan     </td><td>nan     </td><td>67.38685760498046 </td><td>-300.3354850769043 </td><td>55.13861343383789  </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1</i>        </td><td>0.3913526151493549</td><td>0.29144945079467655</td><td>0.3932110342103401</td><td>0.22456925568778976</td><td>0.12624277908043705</td><td>10.016325950622559</td><td>0.3380742371082306</td><td>-1.1830222606658936</td><td>-0.39430123567581177</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>20.87527071994942 </td><td>-0.8867433071136475</td><td>nan          </td><td>nan              </td><td>7.8151436              </td><td>nan              </td><td>nan            </td><td>nan                </td><td>8.465081                 </td><td>nan                </td><td>nan            </td><td>nan                </td><td>7.0564466                </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.767861 </td><td>-0.7315406799316406 </td><td>21.499146555104666</td><td>0.07226164 </td><td>0.507031  </td><td>-0.5486690402030945 </td><td>0.886202  </td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.7326117157936096</td><td>-0.652482807636261</td><td>-0.6697278618812561</td><td>0         </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-142.26086176292293</td><td>46.417971376138425</td><td>-0.11534282804241658</td><td>nan </td><td>nan     </td><td>nan     </td><td>149.6422205133747 </td><td>0      </td><td>-0.7563512325286865</td><td>0.5073366488986605 </td><td>-1.0924330949783325</td><td>4295.465 </td><td>nan </td><td>nan     </td><td>nan     </td><td>67.7484200428451  </td><td>-298.29957314526564</td><td>52.69162146715175  </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>2</i>        </td><td>7.392986027528272 </td><td>4.395135897711333  </td><td>6.739848191949818 </td><td>3.857969371581923  </td><td>2.3848342024284745 </td><td>10.016325950622559</td><td>0.3380742371082306</td><td>-1.1830222606658936</td><td>-0.39430123567581177</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>20.888157433594138</td><td>-0.8867433071136475</td><td>nan          </td><td>nan              </td><td>8.512117               </td><td>nan              </td><td>nan            </td><td>nan                </td><td>9.277008                 </td><td>nan                </td><td>nan            </td><td>nan                </td><td>7.679845                 </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.8335814</td><td>-0.7315406799316406 </td><td>22.775398200235458</td><td>0.040845014</td><td>0.44261116</td><td>-0.5486690402030945 </td><td>0.886202  </td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.7326117157936096</td><td>-0.652482807636261</td><td>-0.6697278618812561</td><td>0         </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-142.92704618284074</td><td>47.20842184009032 </td><td>1.8396875936103667  </td><td>nan </td><td>nan     </td><td>nan     </td><td>150.53292023217344</td><td>0      </td><td>-0.7563512325286865</td><td>0.4436048636953867 </td><td>-1.0924330949783325</td><td>4001.0637</td><td>nan </td><td>nan     </td><td>nan     </td><td>68.03093236871236 </td><td>-301.4758806839234 </td><td>56.09200627357448  </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>3</i>        </td><td>3.6129888513390416</td><td>2.2818297625233486 </td><td>3.4033181539962825</td><td>1.9506143576453838 </td><td>1.1654802746254973 </td><td>10.016325950622559</td><td>0.3380742371082306</td><td>-1.1830222606658936</td><td>-0.39430123567581177</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>20.867217518655195</td><td>-0.8867433071136475</td><td>nan          </td><td>nan              </td><td>9.037168               </td><td>nan              </td><td>nan            </td><td>nan                </td><td>9.901029                 </td><td>nan                </td><td>nan            </td><td>nan                </td><td>8.152237                 </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.8903975</td><td>-0.7315406799316406 </td><td>22.46444493629801 </td><td>0.027340515</td><td>0.39295405</td><td>-0.5486690402030945 </td><td>0.886202  </td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.7326117157936096</td><td>-0.652482807636261</td><td>-0.6697278618812561</td><td>0         </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-141.29345876416804</td><td>47.56378569643568 </td><td>1.0770165239203249  </td><td>nan </td><td>nan     </td><td>nan     </td><td>149.08827976709273</td><td>0      </td><td>-0.7563512325286865</td><td>0.39350367992526536</td><td>-1.0924330949783325</td><td>3854.4998</td><td>nan </td><td>nan     </td><td>nan     </td><td>69.12724120992327 </td><td>-301.73920387771557</td><td>55.1029961513569   </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>4</i>        </td><td>0.7014795175813543</td><td>0.5867886042288581 </td><td>0.7483665104609659</td><td>0.4149519539856739 </td><td>0.22628371534882397</td><td>10.016325950622559</td><td>0.3380742371082306</td><td>-1.1830222606658936</td><td>-0.39430123567581177</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>20.86868071849355 </td><td>-0.8867433071136475</td><td>nan          </td><td>nan              </td><td>4.9383516              </td><td>nan              </td><td>nan            </td><td>nan                </td><td>5.201803                 </td><td>nan                </td><td>nan            </td><td>nan                </td><td>4.5038996                </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.4819903</td><td>-0.7315406799316406 </td><td>21.752593309473333</td><td>0.8118422  </td><td>0.7637918 </td><td>-0.5486690402030945 </td><td>0.886202  </td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.7326117157936096</td><td>-0.652482807636261</td><td>-0.6697278618812561</td><td>0         </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-141.8805554620098 </td><td>46.1152954631301  </td><td>0.7600375956495602  </td><td>nan </td><td>nan     </td><td>nan     </td><td>149.18877354213697</td><td>0      </td><td>-0.7563512325286865</td><td>0.7644402589837288 </td><td>-1.0924330949783325</td><td>6018.22  </td><td>nan </td><td>nan     </td><td>nan     </td><td>67.38594209547328 </td><td>-300.6020691055117 </td><td>52.577100775679746 </td></tr>\n",
       "<tr><td>...                                  </td><td>...               </td><td>...                </td><td>...               </td><td>...                </td><td>...                </td><td>...               </td><td>...               </td><td>...                </td><td>...                 </td><td>...  </td><td>...      </td><td>...      </td><td>...    </td><td>...               </td><td>...                </td><td>...          </td><td>...              </td><td>...                    </td><td>...              </td><td>...            </td><td>...                </td><td>...                      </td><td>...                </td><td>...            </td><td>...                </td><td>...                      </td><td>...                </td><td>...   </td><td>...   </td><td>...      </td><td>...                 </td><td>...               </td><td>...        </td><td>...       </td><td>...                 </td><td>...       </td><td>...  </td><td>...    </td><td>...        </td><td>...        </td><td>...  </td><td>...   </td><td>...       </td><td>...       </td><td>...                </td><td>...               </td><td>...                </td><td>...       </td><td>...     </td><td>...          </td><td>... </td><td>...     </td><td>...     </td><td>...                </td><td>...               </td><td>...                 </td><td>... </td><td>...     </td><td>...     </td><td>...               </td><td>...    </td><td>...                </td><td>...                </td><td>...                </td><td>...      </td><td>... </td><td>...     </td><td>...     </td><td>...               </td><td>...                </td><td>...                </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,614,158</i></td><td>14.060044512202722</td><td>8.423013661152801  </td><td>12.868806573414634</td><td>7.057230806575605  </td><td>4.535498229742814  </td><td>9.99021053314209  </td><td>0.7036365270614624</td><td>-0.8931915760040283</td><td>0.053123194724321365</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>21.61548082188761 </td><td>-0.8060703873634338</td><td>nan          </td><td>nan              </td><td>5.2621174              </td><td>nan              </td><td>nan            </td><td>nan                </td><td>5.553659                 </td><td>nan                </td><td>nan            </td><td>nan                </td><td>4.7985764                </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.550951 </td><td>-0.05126773566007614</td><td>23.054565010441443</td><td>0.59976685 </td><td>0.74945873</td><td>-0.10243386775255203</td><td>0.92552537</td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.5620968341827393</td><td>0.0669776126742363</td><td>-1.2146226167678833</td><td>99999     </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-186.47851700510247</td><td>97.15110580779618 </td><td>8.115853991105647   </td><td>nan </td><td>nan     </td><td>nan     </td><td>210.42443239820048</td><td>0      </td><td>-1.247308373451233 </td><td>0.7500223134586655 </td><td>-0.9955946803092957</td><td>5835.22  </td><td>nan </td><td>nan     </td><td>nan     </td><td>15.3421637420611  </td><td>-165.14197870135874</td><td>-22.75520995737303 </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,614,159</i></td><td>11.063923128969243</td><td>6.45510528739357   </td><td>9.91050274374604  </td><td>5.5781547672436895 </td><td>3.5690074609578204 </td><td>9.99021053314209  </td><td>0.7036365270614624</td><td>-0.8931915760040283</td><td>0.053123194724321365</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>21.61577240657062 </td><td>-0.8060703873634338</td><td>nan          </td><td>nan              </td><td>7.930956               </td><td>nan              </td><td>nan            </td><td>nan                </td><td>8.61342                  </td><td>nan                </td><td>nan            </td><td>nan                </td><td>7.150438                 </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.7677984</td><td>-0.05126773566007614</td><td>22.9504874645149  </td><td>0.06644254 </td><td>0.5040816 </td><td>-0.10243386775255203</td><td>0.92552537</td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.5620968341827393</td><td>0.0669776126742363</td><td>-1.2146226167678833</td><td>99999     </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-186.12304867647393</td><td>97.82701074897133 </td><td>8.855589130749113   </td><td>nan </td><td>nan     </td><td>nan     </td><td>210.45269002689673</td><td>0      </td><td>-1.247308373451233 </td><td>0.504675216060176  </td><td>-0.9955946803092957</td><td>4213.1426</td><td>nan </td><td>nan     </td><td>nan     </td><td>14.420329840561417</td><td>-164.29459688870557</td><td>-23.616658988980973</td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,614,160</i></td><td>2.6202151095083157</td><td>1.9979343957376579 </td><td>2.682412465734748 </td><td>1.5085576559312066 </td><td>0.8452306804865534 </td><td>9.99021053314209  </td><td>0.7036365270614624</td><td>-0.8931915760040283</td><td>0.053123194724321365</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>21.60797143158025 </td><td>-0.8060703873634338</td><td>nan          </td><td>nan              </td><td>5.420544               </td><td>nan              </td><td>nan            </td><td>nan                </td><td>5.727753                 </td><td>nan                </td><td>nan            </td><td>nan                </td><td>4.9413347                </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.574493 </td><td>-0.05126773566007614</td><td>22.32491526151538 </td><td>0.51845455 </td><td>0.7332436 </td><td>-0.10243386775255203</td><td>0.92552537</td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.5620968341827393</td><td>0.0669776126742363</td><td>-1.2146226167678833</td><td>99999     </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-185.4155407018892 </td><td>97.54207904767259 </td><td>8.937050140256144   </td><td>nan </td><td>nan     </td><td>nan     </td><td>209.69799899838287</td><td>0      </td><td>-1.247308373451233 </td><td>0.7337202617485947 </td><td>-0.9955946803092957</td><td>5735.347 </td><td>nan </td><td>nan     </td><td>nan     </td><td>15.215907684749888</td><td>-163.1710353003309 </td><td>-24.28579876779026 </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,614,161</i></td><td>20.11053022532025 </td><td>12.915669131356063 </td><td>18.55864938118823 </td><td>9.438526458834994  </td><td>6.487267814619435  </td><td>9.99021053314209  </td><td>0.7036365270614624</td><td>-0.8931915760040283</td><td>0.053123194724321365</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>21.62280870754291 </td><td>-0.8060703873634338</td><td>nan          </td><td>nan              </td><td>4.007981               </td><td>nan              </td><td>nan            </td><td>nan                </td><td>4.2347775                </td><td>nan                </td><td>nan            </td><td>nan                </td><td>3.6183882                </td><td>nan                </td><td>nan   </td><td>nan   </td><td>4.2465305</td><td>-0.05126773566007614</td><td>23.210001836001144</td><td>1.9032125  </td><td>0.86141604</td><td>-0.10243386775255203</td><td>0.92552537</td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.5620968341827393</td><td>0.0669776126742363</td><td>-1.2146226167678833</td><td>99999     </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-187.14867284718903</td><td>97.44088694333617 </td><td>7.677616529567153   </td><td>nan </td><td>nan     </td><td>nan     </td><td>211.13573357521292</td><td>0      </td><td>-1.247308373451233 </td><td>0.8632034883204436 </td><td>-0.9955946803092957</td><td>6314.5522</td><td>nan </td><td>nan     </td><td>nan     </td><td>14.154347672917513</td><td>-163.58046604010096</td><td>-22.627405955186447</td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,614,162</i></td><td>6.453998533061608 </td><td>4.090151594340529  </td><td>6.058586091870591 </td><td>3.4826187148728667 </td><td>2.0819350106650347 </td><td>9.99021053314209  </td><td>0.7036365270614624</td><td>-0.8931915760040283</td><td>0.053123194724321365</td><td>nan  </td><td>nan      </td><td>nan      </td><td>0.0    </td><td>21.61092186109904 </td><td>-0.8060703873634338</td><td>nan          </td><td>nan              </td><td>-0.38972253            </td><td>nan              </td><td>nan            </td><td>nan                </td><td>0.14156544               </td><td>nan                </td><td>nan            </td><td>nan                </td><td>-1.0621885               </td><td>nan                </td><td>nan   </td><td>nan   </td><td>1.9115392</td><td>-0.05126773566007614</td><td>22.71640717719426 </td><td>126.867645 </td><td>0.918     </td><td>-0.10243386775255203</td><td>0.92552537</td><td>nan  </td><td>nan    </td><td>nan        </td><td>nan        </td><td>nan  </td><td>nan   </td><td>nan       </td><td>nan       </td><td>-0.5620968341827393</td><td>0.0669776126742363</td><td>-1.2146226167678833</td><td>99999     </td><td>1       </td><td>0            </td><td>nan </td><td>nan     </td><td>nan     </td><td>-185.74462203272492</td><td>97.5570866189969  </td><td>8.628931734904029   </td><td>nan </td><td>nan     </td><td>nan     </td><td>209.98311414623782</td><td>0      </td><td>-1.247308373451233 </td><td>0.9262041245678233 </td><td>-0.9955946803092957</td><td>4627.436 </td><td>nan </td><td>nan     </td><td>nan     </td><td>14.454929312951862</td><td>-163.59304101770525</td><td>-24.333362842441787</td></tr>\n",
       "</tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "#          A_0                 A_gaia__dr2_g        A_gaia__dr2_gbp     A_gaia__dr2_grp      E(B-V)               age                 alpha               calcium              carbon                dec    dec_Err    dec_Sig    dform    dmod                feh                  gaia__dr2_g    gaia__dr2_g_Err    gaia__dr2_g_Intrinsic    gaia__dr2_g_Sig    gaia__dr2_gbp    gaia__dr2_gbp_Err    gaia__dr2_gbp_Intrinsic    gaia__dr2_gbp_Sig    gaia__dr2_grp    gaia__dr2_grp_Err    gaia__dr2_grp_Intrinsic    gaia__dr2_grp_Sig    glat    glon    grav       helium                log10_NH            lum          mact        magnesium             mtip        mub    mudec    mudec_Err    mudec_Sig    mul    mura    mura_Err    mura_Sig    neon                 nitrogen            oxygen               parentid    partid    partitionid    pi    pi_Err    pi_Sig    px                   py                  pz                    ra    ra_Err    ra_Sig    rad                 satid    silicon              smass                sulphur              teff       vr    vr_Err    vr_Sig    vx                  vy                   vz\n",
       "0          0.7093970129666607  0.5278885380814685   0.7125676091560069  0.40701678341228237  0.22883774611827765  10.016325950622559  0.3380742371082306  -1.1830222606658936  -0.39430123567581177  nan    nan        nan        0.0      20.87123488088669   -0.8867433071136475  nan            nan                7.6075797                nan                nan              nan                  8.22037                    nan                  nan              nan                  6.875088                   nan                  nan     nan     4.7529893  -0.7315406799316406   21.757467670308863  0.08502915   0.52380776  -0.5486690402030945   0.886202    nan    nan      nan          nan          nan    nan     nan         nan         -0.7326117157936096  -0.652482807636261  -0.6697278618812561  0           0         0              nan   nan       nan       -142.0352559796068   46.20841677042607   0.6925918281909844    nan   nan       nan       149.3643578805275   0        -0.7563512325286865  0.5240775107307198   -1.0924330949783325  4399.992   nan   nan       nan       67.38685760498046   -300.3354850769043   55.13861343383789\n",
       "1          0.3913526151493549  0.29144945079467655  0.3932110342103401  0.22456925568778976  0.12624277908043705  10.016325950622559  0.3380742371082306  -1.1830222606658936  -0.39430123567581177  nan    nan        nan        0.0      20.87527071994942   -0.8867433071136475  nan            nan                7.8151436                nan                nan              nan                  8.465081                   nan                  nan              nan                  7.0564466                  nan                  nan     nan     4.767861   -0.7315406799316406   21.499146555104666  0.07226164   0.507031    -0.5486690402030945   0.886202    nan    nan      nan          nan          nan    nan     nan         nan         -0.7326117157936096  -0.652482807636261  -0.6697278618812561  0           1         0              nan   nan       nan       -142.26086176292293  46.417971376138425  -0.11534282804241658  nan   nan       nan       149.6422205133747   0        -0.7563512325286865  0.5073366488986605   -1.0924330949783325  4295.465   nan   nan       nan       67.7484200428451    -298.29957314526564  52.69162146715175\n",
       "2          7.392986027528272   4.395135897711333    6.739848191949818   3.857969371581923    2.3848342024284745   10.016325950622559  0.3380742371082306  -1.1830222606658936  -0.39430123567581177  nan    nan        nan        0.0      20.888157433594138  -0.8867433071136475  nan            nan                8.512117                 nan                nan              nan                  9.277008                   nan                  nan              nan                  7.679845                   nan                  nan     nan     4.8335814  -0.7315406799316406   22.775398200235458  0.040845014  0.44261116  -0.5486690402030945   0.886202    nan    nan      nan          nan          nan    nan     nan         nan         -0.7326117157936096  -0.652482807636261  -0.6697278618812561  0           1         0              nan   nan       nan       -142.92704618284074  47.20842184009032   1.8396875936103667    nan   nan       nan       150.53292023217344  0        -0.7563512325286865  0.4436048636953867   -1.0924330949783325  4001.0637  nan   nan       nan       68.03093236871236   -301.4758806839234   56.09200627357448\n",
       "3          3.6129888513390416  2.2818297625233486   3.4033181539962825  1.9506143576453838   1.1654802746254973   10.016325950622559  0.3380742371082306  -1.1830222606658936  -0.39430123567581177  nan    nan        nan        0.0      20.867217518655195  -0.8867433071136475  nan            nan                9.037168                 nan                nan              nan                  9.901029                   nan                  nan              nan                  8.152237                   nan                  nan     nan     4.8903975  -0.7315406799316406   22.46444493629801   0.027340515  0.39295405  -0.5486690402030945   0.886202    nan    nan      nan          nan          nan    nan     nan         nan         -0.7326117157936096  -0.652482807636261  -0.6697278618812561  0           1         0              nan   nan       nan       -141.29345876416804  47.56378569643568   1.0770165239203249    nan   nan       nan       149.08827976709273  0        -0.7563512325286865  0.39350367992526536  -1.0924330949783325  3854.4998  nan   nan       nan       69.12724120992327   -301.73920387771557  55.1029961513569\n",
       "4          0.7014795175813543  0.5867886042288581   0.7483665104609659  0.4149519539856739   0.22628371534882397  10.016325950622559  0.3380742371082306  -1.1830222606658936  -0.39430123567581177  nan    nan        nan        0.0      20.86868071849355   -0.8867433071136475  nan            nan                4.9383516                nan                nan              nan                  5.201803                   nan                  nan              nan                  4.5038996                  nan                  nan     nan     4.4819903  -0.7315406799316406   21.752593309473333  0.8118422    0.7637918   -0.5486690402030945   0.886202    nan    nan      nan          nan          nan    nan     nan         nan         -0.7326117157936096  -0.652482807636261  -0.6697278618812561  0           1         0              nan   nan       nan       -141.8805554620098   46.1152954631301    0.7600375956495602    nan   nan       nan       149.18877354213697  0        -0.7563512325286865  0.7644402589837288   -1.0924330949783325  6018.22    nan   nan       nan       67.38594209547328   -300.6020691055117   52.577100775679746\n",
       "...        ...                 ...                  ...                 ...                  ...                  ...                 ...                 ...                  ...                   ...    ...        ...        ...      ...                 ...                  ...            ...                ...                      ...                ...              ...                  ...                        ...                  ...              ...                  ...                        ...                  ...     ...     ...        ...                   ...                 ...          ...         ...                   ...         ...    ...      ...          ...          ...    ...     ...         ...         ...                  ...                 ...                  ...         ...       ...            ...   ...       ...       ...                  ...                 ...                   ...   ...       ...       ...                 ...      ...                  ...                  ...                  ...        ...   ...       ...       ...                 ...                  ...\n",
       "1,614,158  14.060044512202722  8.423013661152801    12.868806573414634  7.057230806575605    4.535498229742814    9.99021053314209    0.7036365270614624  -0.8931915760040283  0.053123194724321365  nan    nan        nan        0.0      21.61548082188761   -0.8060703873634338  nan            nan                5.2621174                nan                nan              nan                  5.553659                   nan                  nan              nan                  4.7985764                  nan                  nan     nan     4.550951   -0.05126773566007614  23.054565010441443  0.59976685   0.74945873  -0.10243386775255203  0.92552537  nan    nan      nan          nan          nan    nan     nan         nan         -0.5620968341827393  0.0669776126742363  -1.2146226167678833  99999       1         0              nan   nan       nan       -186.47851700510247  97.15110580779618   8.115853991105647     nan   nan       nan       210.42443239820048  0        -1.247308373451233   0.7500223134586655   -0.9955946803092957  5835.22    nan   nan       nan       15.3421637420611    -165.14197870135874  -22.75520995737303\n",
       "1,614,159  11.063923128969243  6.45510528739357     9.91050274374604    5.5781547672436895   3.5690074609578204   9.99021053314209    0.7036365270614624  -0.8931915760040283  0.053123194724321365  nan    nan        nan        0.0      21.61577240657062   -0.8060703873634338  nan            nan                7.930956                 nan                nan              nan                  8.61342                    nan                  nan              nan                  7.150438                   nan                  nan     nan     4.7677984  -0.05126773566007614  22.9504874645149    0.06644254   0.5040816   -0.10243386775255203  0.92552537  nan    nan      nan          nan          nan    nan     nan         nan         -0.5620968341827393  0.0669776126742363  -1.2146226167678833  99999       1         0              nan   nan       nan       -186.12304867647393  97.82701074897133   8.855589130749113     nan   nan       nan       210.45269002689673  0        -1.247308373451233   0.504675216060176    -0.9955946803092957  4213.1426  nan   nan       nan       14.420329840561417  -164.29459688870557  -23.616658988980973\n",
       "1,614,160  2.6202151095083157  1.9979343957376579   2.682412465734748   1.5085576559312066   0.8452306804865534   9.99021053314209    0.7036365270614624  -0.8931915760040283  0.053123194724321365  nan    nan        nan        0.0      21.60797143158025   -0.8060703873634338  nan            nan                5.420544                 nan                nan              nan                  5.727753                   nan                  nan              nan                  4.9413347                  nan                  nan     nan     4.574493   -0.05126773566007614  22.32491526151538   0.51845455   0.7332436   -0.10243386775255203  0.92552537  nan    nan      nan          nan          nan    nan     nan         nan         -0.5620968341827393  0.0669776126742363  -1.2146226167678833  99999       1         0              nan   nan       nan       -185.4155407018892   97.54207904767259   8.937050140256144     nan   nan       nan       209.69799899838287  0        -1.247308373451233   0.7337202617485947   -0.9955946803092957  5735.347   nan   nan       nan       15.215907684749888  -163.1710353003309   -24.28579876779026\n",
       "1,614,161  20.11053022532025   12.915669131356063   18.55864938118823   9.438526458834994    6.487267814619435    9.99021053314209    0.7036365270614624  -0.8931915760040283  0.053123194724321365  nan    nan        nan        0.0      21.62280870754291   -0.8060703873634338  nan            nan                4.007981                 nan                nan              nan                  4.2347775                  nan                  nan              nan                  3.6183882                  nan                  nan     nan     4.2465305  -0.05126773566007614  23.210001836001144  1.9032125    0.86141604  -0.10243386775255203  0.92552537  nan    nan      nan          nan          nan    nan     nan         nan         -0.5620968341827393  0.0669776126742363  -1.2146226167678833  99999       1         0              nan   nan       nan       -187.14867284718903  97.44088694333617   7.677616529567153     nan   nan       nan       211.13573357521292  0        -1.247308373451233   0.8632034883204436   -0.9955946803092957  6314.5522  nan   nan       nan       14.154347672917513  -163.58046604010096  -22.627405955186447\n",
       "1,614,162  6.453998533061608   4.090151594340529    6.058586091870591   3.4826187148728667   2.0819350106650347   9.99021053314209    0.7036365270614624  -0.8931915760040283  0.053123194724321365  nan    nan        nan        0.0      21.61092186109904   -0.8060703873634338  nan            nan                -0.38972253              nan                nan              nan                  0.14156544                 nan                  nan              nan                  -1.0621885                 nan                  nan     nan     1.9115392  -0.05126773566007614  22.71640717719426   126.867645   0.918       -0.10243386775255203  0.92552537  nan    nan      nan          nan          nan    nan     nan         nan         -0.5620968341827393  0.0669776126742363  -1.2146226167678833  99999       1         0              nan   nan       nan       -185.74462203272492  97.5570866189969    8.628931734904029     nan   nan       nan       209.98311414623782  0        -1.247308373451233   0.9262041245678233   -0.9955946803092957  4627.436   nan   nan       nan       14.454929312951862  -163.59304101770525  -24.333362842441787"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a9a28a5d",
   "metadata": {},
   "source": [
    "Please refer to [`vaex`'s documentation](https://vaex.io/docs/tutorial.html) for further help on how to use `vaex` dataframes: the following line for example isolate only the rows with non-NaN photometry."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "09f840d5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead>\n",
       "<tr><th>#                                </th><th>A_0                 </th><th>A_gaia__dr2_g       </th><th>A_gaia__dr2_gbp     </th><th>A_gaia__dr2_grp     </th><th>E(B-V)              </th><th>age               </th><th>alpha               </th><th>calcium             </th><th>carbon              </th><th>dec      </th><th>dec_Err                </th><th>dec_Sig      </th><th>dform  </th><th>dmod              </th><th>feh                </th><th>gaia__dr2_g  </th><th>gaia__dr2_g_Err       </th><th>gaia__dr2_g_Intrinsic  </th><th>gaia__dr2_g_Sig  </th><th>gaia__dr2_gbp  </th><th>gaia__dr2_gbp_Err    </th><th>gaia__dr2_gbp_Intrinsic  </th><th>gaia__dr2_gbp_Sig  </th><th>gaia__dr2_grp  </th><th>gaia__dr2_grp_Err   </th><th>gaia__dr2_grp_Intrinsic  </th><th>gaia__dr2_grp_Sig  </th><th>glat       </th><th>glon     </th><th>grav      </th><th>helium              </th><th>log10_NH          </th><th>lum      </th><th>mact      </th><th>magnesium           </th><th>mtip      </th><th>mub                 </th><th>mudec              </th><th>mudec_Err           </th><th>mudec_Sig  </th><th>mul               </th><th>mura               </th><th>mura_Err             </th><th>mura_Sig  </th><th>neon                </th><th>nitrogen            </th><th>oxygen              </th><th>parentid  </th><th>partid  </th><th>partitionid  </th><th>pi                  </th><th>pi_Err                </th><th>pi_Sig    </th><th>px                 </th><th>py                </th><th>pz                 </th><th>ra       </th><th>ra_Err                 </th><th>ra_Sig       </th><th>rad               </th><th>satid  </th><th>silicon             </th><th>smass             </th><th>sulphur             </th><th>teff     </th><th>vr  </th><th>vr_Err  </th><th>vr_Sig  </th><th>vx                 </th><th>vy                 </th><th>vz                 </th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "<tr><td><i style='opacity: 0.6'>0</i>    </td><td>0.05681650709265598 </td><td>0.04671342391859208 </td><td>0.05985558882052393 </td><td>0.03353577934926581 </td><td>0.018327905513759995</td><td>8.97172737121582  </td><td>-0.6125200986862183 </td><td>-0.12460324913263321</td><td>-0.36052706837654114</td><td>41.517887</td><td>-4.3651322762456503e-07</td><td>3.7339328e-07</td><td>0.0    </td><td>20.938860082853388</td><td>-0.5348672270774841</td><td>20.610794    </td><td>-0.013108958690914031 </td><td>-0.36166972            </td><td>0.014190837      </td><td>20.934616      </td><td>-0.09105875752639689 </td><td>0.026959075              </td><td>0.32711947         </td><td>20.067835      </td><td>0.010476073807142064</td><td>-0.9150356               </td><td>0.32711947         </td><td>-6.450095  </td><td>159.08374</td><td>2.5680106 </td><td>-0.6886086463928223 </td><td>20.661052845931597</td><td>108.46986</td><td>2.1231031 </td><td>-1.1473873853683472 </td><td>1.9929105 </td><td>1.9060571825344517  </td><td>-0.4903980049570771</td><td>-0.15208820165614972</td><td>2.1212947  </td><td>2.637362501364926 </td><td>3.216868859449929  </td><td>3.107170100412025    </td><td>2.1212947 </td><td>-0.44875627756118774</td><td>-1.4166113138198853 </td><td>-0.40134233236312866</td><td>138       </td><td>1       </td><td>0            </td><td>0.004700138418892006</td><td>-0.0017896118250197454</td><td>1.3442158 </td><td>-143.02405261900319</td><td>54.66209816691588 </td><td>-17.310021738871935</td><td>64.385994</td><td>7.738775790567222e-07  </td><td>3.7339328e-07</td><td>154.089134776509  </td><td>0      </td><td>-0.4361392557621002 </td><td>2.123614686399606 </td><td>-1.2804145812988281 </td><td>5266.821 </td><td>nan </td><td>nan     </td><td>nan     </td><td>-13.980939858346646</td><td>-241.322783466562  </td><td>-112.49946999755836</td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1</i>    </td><td>0.30908957284836036 </td><td>0.2261170869376632  </td><td>0.30842259877311534 </td><td>0.176280263594307   </td><td>0.09970631382205172 </td><td>10.069992065429688</td><td>0.5896989703178406  </td><td>-0.9664415121078491 </td><td>-0.9518471360206604 </td><td>37.240967</td><td>-2.2831375342149955e-07</td><td>2.49317e-07  </td><td>0.0    </td><td>21.769605166840982</td><td>-0.801622748374939 </td><td>20.222652    </td><td>-0.013217448221518976 </td><td>-1.7598503             </td><td>0.011413363      </td><td>21.307426      </td><td>0.2680249694291372   </td><td>-1.0386255               </td><td>0.24083452         </td><td>19.243824      </td><td>-0.13966843269274323</td><td>-2.5623941               </td><td>0.24083452         </td><td>-0.91259795</td><td>169.44246</td><td>1.0347817 </td><td>-0.32748517394065857</td><td>21.396662669202907</td><td>558.4033 </td><td>0.8450456 </td><td>-0.21192379295825958</td><td>0.86665446</td><td>-3.1047273926896426 </td><td>-2.7124202720419555</td><td>-2.542487626107496  </td><td>1.4928615  </td><td>1.1050811506348799</td><td>-1.871713888922517 </td><td>-2.04588855812214    </td><td>1.4928615 </td><td>-0.3413775563240051 </td><td>-0.13905183970928192</td><td>-0.8814153671264648 </td><td>212       </td><td>1       </td><td>0            </td><td>-1.1660510794203147 </td><td>-1.1704777679639904   </td><td>0.89754117</td><td>-222.0501127897472 </td><td>41.38527019482137 </td><td>-3.5979765713472083</td><td>78.53204 </td><td>4.2180988179474246e-07 </td><td>2.49317e-07  </td><td>225.90249802613027</td><td>0      </td><td>-0.7138696312904358 </td><td>0.8677262727803007</td><td>-1.077961802482605  </td><td>4132.9897</td><td>nan </td><td>nan     </td><td>nan     </td><td>-64.76429401098572 </td><td>-249.0524176755581 </td><td>44.549935511279955 </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>2</i>    </td><td>0.040653863770659916</td><td>0.03188868360172066 </td><td>0.04180280722924421 </td><td>0.023700606699203153</td><td>0.013114149603438681</td><td>9.613767623901367 </td><td>-0.1432933509349823 </td><td>-1.0196176767349243 </td><td>-0.6505561470985413 </td><td>27.468527</td><td>9.93141102529504e-07   </td><td>5.270746e-07 </td><td>0.0    </td><td>21.241844522741097</td><td>-0.5965235829353333</td><td>20.921713    </td><td>-0.029182178287689993 </td><td>-0.3228382             </td><td>0.01705969       </td><td>21.876608      </td><td>0.38537958340209455  </td><td>0.20757976               </td><td>0.4235812          </td><td>21.28318       </td><td>1.0115375512029108  </td><td>-0.99390167              </td><td>0.4235812          </td><td>-8.830861  </td><td>175.76826</td><td>2.0586061 </td><td>-0.7592963576316833 </td><td>20.51568014237018 </td><td>118.69824</td><td>1.196     </td><td>-0.7398169040679932 </td><td>1.1982795 </td><td>-1.6438476299687612 </td><td>-2.044957683093608 </td><td>-1.7305400665725954 </td><td>2.8642974  </td><td>1.322617557411089 </td><td>-0.519326655124296 </td><td>-0.5989357582041593  </td><td>2.8642974 </td><td>-1.3291157484054565 </td><td>-0.7577531337738037 </td><td>-0.45060980319976807</td><td>252       </td><td>1       </td><td>0            </td><td>1.5601152190393899  </td><td>1.554470646021109     </td><td>1.8974684 </td><td>-174.58395850876306</td><td>12.917886544408068</td><td>-27.197472653752673</td><td>75.42295 </td><td>-1.738821925276305e-07 </td><td>5.270746e-07 </td><td>177.1613188032741 </td><td>0      </td><td>-0.6941993832588196 </td><td>1.2002945213596574</td><td>-0.5894879698753357 </td><td>4637.9014</td><td>nan </td><td>nan     </td><td>nan     </td><td>31.915626870159116 </td><td>-254.29642034774957</td><td>-98.61775218664684 </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>3</i>    </td><td>0.7877962999055037  </td><td>0.5726781831841866  </td><td>0.7836102802990144  </td><td>0.4485485017244748  </td><td>0.25412783867919475 </td><td>9.8711519241333   </td><td>1.162867546081543   </td><td>-0.7159809470176697 </td><td>-0.6287623643875122 </td><td>34.62386 </td><td>6.854075293976649e-08  </td><td>7.639342e-08 </td><td>0.0    </td><td>20.79343262014924 </td><td>-1.236360788345337 </td><td>19.04199     </td><td>0.00854874852791074   </td><td>-2.3326683             </td><td>0.005850956      </td><td>19.920134      </td><td>-0.005622249308989237</td><td>-1.6512849               </td><td>0.09372754         </td><td>18.088743      </td><td>-0.04331449085765518</td><td>-3.1099238               </td><td>0.09372754         </td><td>-14.482033 </td><td>160.58708</td><td>0.94072235</td><td>0.7711513042449951  </td><td>21.80299225153633 </td><td>876.2868 </td><td>0.92662406</td><td>-0.07349321991205215</td><td>0.95272523</td><td>0.054731965395574934</td><td>-0.3829754121816991</td><td>-0.12157731062280257</td><td>0.53407407 </td><td>0.6418210512826112</td><td>0.5179379203937897 </td><td>0.16962703533504497  </td><td>0.53407407</td><td>-0.9232337474822998 </td><td>-0.6347827315330505 </td><td>-1.0434234142303467 </td><td>281       </td><td>1       </td><td>0            </td><td>-0.24483446567030384</td><td>-0.25177373072009146  </td><td>0.2750163 </td><td>-131.59610686320977</td><td>46.37566245119917 </td><td>-36.03787463886429 </td><td>58.814594</td><td>3.7359391102072234e-08 </td><td>7.639342e-08 </td><td>144.10748008978362</td><td>0      </td><td>0.010916919447481632</td><td>0.9538811072032849</td><td>-1.0917985439300537 </td><td>4282.4487</td><td>nan </td><td>nan     </td><td>nan     </td><td>-43.91235726362427 </td><td>-298.99747247914627</td><td>38.90182804530409  </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>4</i>    </td><td>0.13204413245379326 </td><td>0.10562465807915085 </td><td>0.1371534826791068  </td><td>0.07738767519745451 </td><td>0.042594881436707505</td><td>9.037848472595215 </td><td>-0.20741142332553864</td><td>-0.2963399291038513 </td><td>0.24989141523838043 </td><td>27.754452</td><td>3.672289535219167e-07  </td><td>4.3264754e-07</td><td>0.0    </td><td>21.63436699581625 </td><td>-0.9348768591880798</td><td>20.762663    </td><td>-0.0013426168529036332</td><td>-0.9759861             </td><td>0.015354784      </td><td>21.672022      </td><td>0.4177469420941861   </td><td>-0.51724565              </td><td>0.36540693         </td><td>20.407366      </td><td>0.2875173851348014  </td><td>-1.5919065               </td><td>0.36540693         </td><td>-6.714385  </td><td>176.97495</td><td>2.1116366 </td><td>-0.6755844354629517 </td><td>21.027297422390884</td><td>203.31184</td><td>1.8348202 </td><td>-1.142288327217102  </td><td>1.8366443 </td><td>0.2197378023917316  </td><td>-1.2259053978924448</td><td>-1.02247116836483   </td><td>2.41159    </td><td>1.66267235620017  </td><td>1.144517339975177  </td><td>1.067175358322312    </td><td>2.41159   </td><td>-0.6697758436203003 </td><td>-0.6329840421676636 </td><td>-1.5521866083145142 </td><td>343       </td><td>1       </td><td>0            </td><td>2.2433125652881225  </td><td>2.238601418881787     </td><td>1.5575311 </td><td>-210.51297254829456</td><td>11.124849238363767</td><td>-24.817751499653514</td><td>78.14718 </td><td>-7.645186432301977e-08 </td><td>4.3264754e-07</td><td>212.2625606912201 </td><td>0      </td><td>-0.3810194134712219 </td><td>1.8352900976292204</td><td>-0.6407454609870911 </td><td>4914.369 </td><td>nan </td><td>nan     </td><td>nan     </td><td>-8.48732751191461  </td><td>-211.68435438026214</td><td>-55.59752034953253 </td></tr>\n",
       "<tr><td>...                              </td><td>...                 </td><td>...                 </td><td>...                 </td><td>...                 </td><td>...                 </td><td>...               </td><td>...                 </td><td>...                 </td><td>...                 </td><td>...      </td><td>...                    </td><td>...          </td><td>...    </td><td>...               </td><td>...                </td><td>...          </td><td>...                   </td><td>...                    </td><td>...              </td><td>...            </td><td>...                  </td><td>...                      </td><td>...                </td><td>...            </td><td>...                 </td><td>...                      </td><td>...                </td><td>...        </td><td>...      </td><td>...       </td><td>...                 </td><td>...               </td><td>...      </td><td>...       </td><td>...                 </td><td>...       </td><td>...                 </td><td>...                </td><td>...                 </td><td>...        </td><td>...               </td><td>...                </td><td>...                  </td><td>...       </td><td>...                 </td><td>...                 </td><td>...                 </td><td>...       </td><td>...     </td><td>...          </td><td>...                 </td><td>...                   </td><td>...       </td><td>...                </td><td>...               </td><td>...                </td><td>...      </td><td>...                    </td><td>...          </td><td>...               </td><td>...    </td><td>...                 </td><td>...               </td><td>...                 </td><td>...      </td><td>... </td><td>...     </td><td>...     </td><td>...                </td><td>...                </td><td>...                </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,164</i></td><td>0.019025284676619746</td><td>0.015117211031154319</td><td>0.019686932095396074</td><td>0.011131666999152821</td><td>0.006137188605361208</td><td>10.373172760009766</td><td>1.5368380546569824  </td><td>-1.5263926982879639 </td><td>-0.673753559589386  </td><td>39.989857</td><td>-2.514573920310201e-07 </td><td>4.0399456e-07</td><td>0.0    </td><td>21.230698985230248</td><td>-1.2268792390823364</td><td>20.69277     </td><td>-0.006136069764179247 </td><td>-0.54691136            </td><td>0.014802344      </td><td>22.025711      </td><td>0.8299667035764402   </td><td>-0.054642305             </td><td>0.3470864          </td><td>20.100964      </td><td>0.04999640531206987 </td><td>-1.1908631               </td><td>0.3470864          </td><td>-10.55544  </td><td>156.8341 </td><td>1.8550684 </td><td>-0.6782917976379395 </td><td>20.185909478706662</td><td>141.69197</td><td>0.798     </td><td>0.3099588453769684  </td><td>0.80682814</td><td>1.8727959735562256  </td><td>0.3528067027517523 </td><td>0.5241191460758158  </td><td>2.2718804  </td><td>1.657140857015031 </td><td>2.475683344755806  </td><td>2.3005029186373935   </td><td>2.2718804 </td><td>-0.6692771315574646 </td><td>0.04717090725898743 </td><td>-1.0167276859283447 </td><td>99731     </td><td>1       </td><td>0            </td><td>-1.8038561145794871 </td><td>-1.80952973403217     </td><td>1.4543804 </td><td>-159.30081213760624</td><td>68.16420594881328 </td><td>-32.287480777554315</td><td>58.55993 </td><td>-8.166342547243272e-07 </td><td>4.0399456e-07</td><td>176.25433082705823</td><td>0      </td><td>-0.643153190612793  </td><td>0.8070930497545803</td><td>-0.7373723983764648 </td><td>4771.282 </td><td>nan </td><td>nan     </td><td>nan     </td><td>78.74606945448743  </td><td>-255.83754148145218</td><td>17.808940561402192 </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,165</i></td><td>0.11785906487249752 </td><td>0.08847483112601966 </td><td>0.11882245467274986 </td><td>0.06779467873028361 </td><td>0.03801905318467662 </td><td>9.395322799682617 </td><td>-0.3845840394496918 </td><td>-0.28358957171440125</td><td>-0.48085200786590576</td><td>34.802338</td><td>9.918108029871799e-08  </td><td>1.2833371e-07</td><td>0.0    </td><td>21.730687168195804</td><td>-0.7610273361206055</td><td>19.584963    </td><td>0.0065751865905664285 </td><td>-2.2407725             </td><td>0.007908253      </td><td>20.062742      </td><td>-0.20591638105879556 </td><td>-1.5808507               </td><td>0.1435723          </td><td>19.184309      </td><td>0.3899514815920368  </td><td>-3.0041256               </td><td>0.1435723          </td><td>-11.4430685</td><td>163.64268</td><td>1.1658815 </td><td>-0.9921388030052185 </td><td>20.977941305794033</td><td>803.1406 </td><td>1.433     </td><td>-1.1456114053726196 </td><td>1.4167645 </td><td>-0.7985102470481145 </td><td>-1.2350411854691319</td><td>-1.0666535865725877 </td><td>0.83854187 </td><td>0.9481371511247441</td><td>0.10609397613329813</td><td>-0.014613976378601738</td><td>0.83854187</td><td>-0.9093115329742432 </td><td>-0.06070816144347191</td><td>-0.573256254196167  </td><td>99823     </td><td>1       </td><td>0            </td><td>0.6270305330302726  </td><td>0.6225237923805556    </td><td>0.46200135</td><td>-208.67652152432527</td><td>61.24792880191641 </td><td>-44.021647514337545</td><td>63.986168</td><td>-1.9273868544824463e-07</td><td>1.2833371e-07</td><td>221.8898485012178 </td><td>0      </td><td>-0.5603996515274048 </td><td>1.446258238190986 </td><td>-0.6158600449562073 </td><td>4276.7935</td><td>nan </td><td>nan     </td><td>nan     </td><td>6.244157910757682  </td><td>-225.91754656015348</td><td>-22.142693836095198</td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,166</i></td><td>1.917877604633994   </td><td>1.3702206129213375  </td><td>1.8937630206087055  </td><td>1.0859833201809104  </td><td>0.6186701950432238  </td><td>9.400785446166992 </td><td>0.5861782431602478  </td><td>-0.661990225315094  </td><td>-0.446218341588974  </td><td>28.715738</td><td>-4.908052626167452e-07 </td><td>4.5137742e-07</td><td>0.0    </td><td>21.56765254830313 </td><td>-1.0741389989852905</td><td>20.798689    </td><td>-0.005518799886512156 </td><td>-2.133665              </td><td>0.015706312      </td><td>22.023201      </td><td>0.09706545298345842  </td><td>-1.5352793               </td><td>0.3772023          </td><td>20.511465      </td><td>0.7137742476844009  </td><td>-2.8559453               </td><td>0.3772023          </td><td>-10.957019 </td><td>172.46034</td><td>1.279352  </td><td>-0.9261223077774048 </td><td>22.189399202694215</td><td>671.83466</td><td>1.323     </td><td>-0.4879607856273651 </td><td>1.3253865 </td><td>5.462758179344159   </td><td>5.667542559168328  </td><td>5.871416168223197   </td><td>2.502292   </td><td>-2.843550123947125</td><td>2.409661008791584  </td><td>2.2750541663028017   </td><td>2.502292  </td><td>0.23867693543434143 </td><td>-1.0438926219940186 </td><td>-1.0675371885299683 </td><td>99881     </td><td>1       </td><td>0            </td><td>-1.883078373748392  </td><td>-1.8879365077565704   </td><td>1.6249586 </td><td>-200.34070153304094</td><td>26.516403301143548</td><td>-39.12458260932041 </td><td>71.24494 </td><td>1.7179552430969074e-07 </td><td>4.5137742e-07</td><td>205.84034905511947</td><td>0      </td><td>-0.30648577213287354</td><td>1.3302323661360405</td><td>0.5969148278236389  </td><td>4453.539 </td><td>nan </td><td>nan     </td><td>nan     </td><td>45.99363716354691  </td><td>-245.2196565089809 </td><td>-10.463755036288688</td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,167</i></td><td>0.3890935817655473  </td><td>0.3459109855134188  </td><td>0.42844236806758407 </td><td>0.2332652879275749  </td><td>0.12551405863404752 </td><td>8.76700210571289  </td><td>1.2602565288543701  </td><td>-0.6482102274894714 </td><td>-0.646274745464325  </td><td>18.708971</td><td>-1.1252965856256632e-07</td><td>4.4515681e-07</td><td>0.0    </td><td>21.967123504012505</td><td>-1.1567636728286743</td><td>20.788153    </td><td>-0.0028946091431594823</td><td>-1.521986              </td><td>0.015590355      </td><td>20.725286      </td><td>-0.3056262783830847  </td><td>-1.3646538               </td><td>0.3733             </td><td>20.2418        </td><td>-0.16204777931782613</td><td>-1.7965397               </td><td>0.3733             </td><td>-19.303923 </td><td>178.78328</td><td>2.6245642 </td><td>-0.3065233826637268 </td><td>21.496632381861513</td><td>296.85895</td><td>2.3255537 </td><td>0.10349282622337341 </td><td>2.2348108 </td><td>-0.9703733499833618 </td><td>-1.8985779016318194</td><td>-1.6164166274595297 </td><td>2.4722178  </td><td>1.6569354981820585</td><td>0.28716138658722357</td><td>0.15742234829525623  </td><td>2.4722178 </td><td>-0.09991137683391571</td><td>0.01162821426987648 </td><td>-0.6298919320106506 </td><td>99944     </td><td>1       </td><td>0            </td><td>-1.469024973955347  </td><td>-1.4730667784191478   </td><td>1.6025645 </td><td>-233.4515586679823 </td><td>4.958240307345907 </td><td>-81.78993982121428 </td><td>68.41039 </td><td>-8.61161514396646e-07  </td><td>4.4515681e-07</td><td>247.41424503737377</td><td>0      </td><td>-0.13593457639217377</td><td>2.32588572372793  </td><td>-0.7227007746696472 </td><td>6840.3525</td><td>nan </td><td>nan     </td><td>nan     </td><td>65.61290171740593  </td><td>-354.48857930707965</td><td>-69.47010348297734 </td></tr>\n",
       "<tr><td><i style='opacity: 0.6'>1,168</i></td><td>0.13128025060982007 </td><td>0.10877511186828413 </td><td>0.1389290640965563  </td><td>0.07761901232932501 </td><td>0.042348467938651636</td><td>8.829378128051758 </td><td>0.945320188999176   </td><td>-1.3487151861190796 </td><td>-0.32563573122024536</td><td>35.68073 </td><td>-6.829164901717445e-08 </td><td>5.0387865e-07</td><td>0.0    </td><td>21.449059479615702</td><td>-1.5585298538208008</td><td>20.904022    </td><td>-0.004349176003901913 </td><td>-0.6494634             </td><td>0.01665563       </td><td>21.971952      </td><td>0.678119222946501    </td><td>-0.29415557              </td><td>0.40957612         </td><td>20.778925      </td><td>0.42905685318463965 </td><td>-1.1768098               </td><td>0.40957612         </td><td>-13.799286 </td><td>159.73665</td><td>2.465999  </td><td>-0.06979773193597794</td><td>21.024777711937936</td><td>144.35234</td><td>2.104846  </td><td>-0.6132096648216248 </td><td>2.0921621 </td><td>-2.4980094064001293 </td><td>-2.2022274170596026</td><td>-1.9733394462256058 </td><td>2.7541013  </td><td>0.4840052154049758</td><td>-1.2745613005915613</td><td>-1.501391448026907   </td><td>2.7541013 </td><td>-0.40418189764022827</td><td>-0.7111912369728088 </td><td>-0.6041487455368042 </td><td>99991     </td><td>1       </td><td>0            </td><td>-0.46944864982128426</td><td>-0.4745794854764945   </td><td>1.8139632 </td><td>-177.56058760928536</td><td>65.5525804310451  </td><td>-46.48781414288353 </td><td>58.605503</td><td>4.792514094889688e-07  </td><td>5.0387865e-07</td><td>194.90002549283216</td><td>0      </td><td>-0.5130423903465271 </td><td>2.1051179373093634</td><td>-0.10513915121555328</td><td>5345.2173</td><td>nan </td><td>nan     </td><td>nan     </td><td>-31.301481977818145</td><td>-304.94776329404436</td><td>-3.899390631479074 </td></tr>\n",
       "</tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "#      A_0                   A_gaia__dr2_g         A_gaia__dr2_gbp       A_gaia__dr2_grp       E(B-V)                age                 alpha                 calcium               carbon                dec        dec_Err                  dec_Sig        dform    dmod                feh                  gaia__dr2_g    gaia__dr2_g_Err         gaia__dr2_g_Intrinsic    gaia__dr2_g_Sig    gaia__dr2_gbp    gaia__dr2_gbp_Err      gaia__dr2_gbp_Intrinsic    gaia__dr2_gbp_Sig    gaia__dr2_grp    gaia__dr2_grp_Err     gaia__dr2_grp_Intrinsic    gaia__dr2_grp_Sig    glat         glon       grav        helium                log10_NH            lum        mact        magnesium             mtip        mub                   mudec                mudec_Err             mudec_Sig    mul                 mura                 mura_Err               mura_Sig    neon                  nitrogen              oxygen                parentid    partid    partitionid    pi                    pi_Err                  pi_Sig      px                   py                  pz                   ra         ra_Err                   ra_Sig         rad                 satid    silicon               smass               sulphur               teff       vr    vr_Err    vr_Sig    vx                   vy                   vz\n",
       "0      0.05681650709265598   0.04671342391859208   0.05985558882052393   0.03353577934926581   0.018327905513759995  8.97172737121582    -0.6125200986862183   -0.12460324913263321  -0.36052706837654114  41.517887  -4.3651322762456503e-07  3.7339328e-07  0.0      20.938860082853388  -0.5348672270774841  20.610794      -0.013108958690914031   -0.36166972              0.014190837        20.934616        -0.09105875752639689   0.026959075                0.32711947           20.067835        0.010476073807142064  -0.9150356                 0.32711947           -6.450095    159.08374  2.5680106   -0.6886086463928223   20.661052845931597  108.46986  2.1231031   -1.1473873853683472   1.9929105   1.9060571825344517    -0.4903980049570771  -0.15208820165614972  2.1212947    2.637362501364926   3.216868859449929    3.107170100412025      2.1212947   -0.44875627756118774  -1.4166113138198853   -0.40134233236312866  138         1         0              0.004700138418892006  -0.0017896118250197454  1.3442158   -143.02405261900319  54.66209816691588   -17.310021738871935  64.385994  7.738775790567222e-07    3.7339328e-07  154.089134776509    0        -0.4361392557621002   2.123614686399606   -1.2804145812988281   5266.821   nan   nan       nan       -13.980939858346646  -241.322783466562    -112.49946999755836\n",
       "1      0.30908957284836036   0.2261170869376632    0.30842259877311534   0.176280263594307     0.09970631382205172   10.069992065429688  0.5896989703178406    -0.9664415121078491   -0.9518471360206604   37.240967  -2.2831375342149955e-07  2.49317e-07    0.0      21.769605166840982  -0.801622748374939   20.222652      -0.013217448221518976   -1.7598503               0.011413363        21.307426        0.2680249694291372     -1.0386255                 0.24083452           19.243824        -0.13966843269274323  -2.5623941                 0.24083452           -0.91259795  169.44246  1.0347817   -0.32748517394065857  21.396662669202907  558.4033   0.8450456   -0.21192379295825958  0.86665446  -3.1047273926896426   -2.7124202720419555  -2.542487626107496    1.4928615    1.1050811506348799  -1.871713888922517   -2.04588855812214      1.4928615   -0.3413775563240051   -0.13905183970928192  -0.8814153671264648   212         1         0              -1.1660510794203147   -1.1704777679639904     0.89754117  -222.0501127897472   41.38527019482137   -3.5979765713472083  78.53204   4.2180988179474246e-07   2.49317e-07    225.90249802613027  0        -0.7138696312904358   0.8677262727803007  -1.077961802482605    4132.9897  nan   nan       nan       -64.76429401098572   -249.0524176755581   44.549935511279955\n",
       "2      0.040653863770659916  0.03188868360172066   0.04180280722924421   0.023700606699203153  0.013114149603438681  9.613767623901367   -0.1432933509349823   -1.0196176767349243   -0.6505561470985413   27.468527  9.93141102529504e-07     5.270746e-07   0.0      21.241844522741097  -0.5965235829353333  20.921713      -0.029182178287689993   -0.3228382               0.01705969         21.876608        0.38537958340209455    0.20757976                 0.4235812            21.28318         1.0115375512029108    -0.99390167                0.4235812            -8.830861    175.76826  2.0586061   -0.7592963576316833   20.51568014237018   118.69824  1.196       -0.7398169040679932   1.1982795   -1.6438476299687612   -2.044957683093608   -1.7305400665725954   2.8642974    1.322617557411089   -0.519326655124296   -0.5989357582041593    2.8642974   -1.3291157484054565   -0.7577531337738037   -0.45060980319976807  252         1         0              1.5601152190393899    1.554470646021109       1.8974684   -174.58395850876306  12.917886544408068  -27.197472653752673  75.42295   -1.738821925276305e-07   5.270746e-07   177.1613188032741   0        -0.6941993832588196   1.2002945213596574  -0.5894879698753357   4637.9014  nan   nan       nan       31.915626870159116   -254.29642034774957  -98.61775218664684\n",
       "3      0.7877962999055037    0.5726781831841866    0.7836102802990144    0.4485485017244748    0.25412783867919475   9.8711519241333     1.162867546081543     -0.7159809470176697   -0.6287623643875122   34.62386   6.854075293976649e-08    7.639342e-08   0.0      20.79343262014924   -1.236360788345337   19.04199       0.00854874852791074     -2.3326683               0.005850956        19.920134        -0.005622249308989237  -1.6512849                 0.09372754           18.088743        -0.04331449085765518  -3.1099238                 0.09372754           -14.482033   160.58708  0.94072235  0.7711513042449951    21.80299225153633   876.2868   0.92662406  -0.07349321991205215  0.95272523  0.054731965395574934  -0.3829754121816991  -0.12157731062280257  0.53407407   0.6418210512826112  0.5179379203937897   0.16962703533504497    0.53407407  -0.9232337474822998   -0.6347827315330505   -1.0434234142303467   281         1         0              -0.24483446567030384  -0.25177373072009146    0.2750163   -131.59610686320977  46.37566245119917   -36.03787463886429   58.814594  3.7359391102072234e-08   7.639342e-08   144.10748008978362  0        0.010916919447481632  0.9538811072032849  -1.0917985439300537   4282.4487  nan   nan       nan       -43.91235726362427   -298.99747247914627  38.90182804530409\n",
       "4      0.13204413245379326   0.10562465807915085   0.1371534826791068    0.07738767519745451   0.042594881436707505  9.037848472595215   -0.20741142332553864  -0.2963399291038513   0.24989141523838043   27.754452  3.672289535219167e-07    4.3264754e-07  0.0      21.63436699581625   -0.9348768591880798  20.762663      -0.0013426168529036332  -0.9759861               0.015354784        21.672022        0.4177469420941861     -0.51724565                0.36540693           20.407366        0.2875173851348014    -1.5919065                 0.36540693           -6.714385    176.97495  2.1116366   -0.6755844354629517   21.027297422390884  203.31184  1.8348202   -1.142288327217102    1.8366443   0.2197378023917316    -1.2259053978924448  -1.02247116836483     2.41159      1.66267235620017    1.144517339975177    1.067175358322312      2.41159     -0.6697758436203003   -0.6329840421676636   -1.5521866083145142   343         1         0              2.2433125652881225    2.238601418881787       1.5575311   -210.51297254829456  11.124849238363767  -24.817751499653514  78.14718   -7.645186432301977e-08   4.3264754e-07  212.2625606912201   0        -0.3810194134712219   1.8352900976292204  -0.6407454609870911   4914.369   nan   nan       nan       -8.48732751191461    -211.68435438026214  -55.59752034953253\n",
       "...    ...                   ...                   ...                   ...                   ...                   ...                 ...                   ...                   ...                   ...        ...                      ...            ...      ...                 ...                  ...            ...                     ...                      ...                ...              ...                    ...                        ...                  ...              ...                   ...                        ...                  ...          ...        ...         ...                   ...                 ...        ...         ...                   ...         ...                   ...                  ...                   ...          ...                 ...                  ...                    ...         ...                   ...                   ...                   ...         ...       ...            ...                   ...                     ...         ...                  ...                 ...                  ...        ...                      ...            ...                 ...      ...                   ...                 ...                   ...        ...   ...       ...       ...                  ...                  ...\n",
       "1,164  0.019025284676619746  0.015117211031154319  0.019686932095396074  0.011131666999152821  0.006137188605361208  10.373172760009766  1.5368380546569824    -1.5263926982879639   -0.673753559589386    39.989857  -2.514573920310201e-07   4.0399456e-07  0.0      21.230698985230248  -1.2268792390823364  20.69277       -0.006136069764179247   -0.54691136              0.014802344        22.025711        0.8299667035764402     -0.054642305               0.3470864            20.100964        0.04999640531206987   -1.1908631                 0.3470864            -10.55544    156.8341   1.8550684   -0.6782917976379395   20.185909478706662  141.69197  0.798       0.3099588453769684    0.80682814  1.8727959735562256    0.3528067027517523   0.5241191460758158    2.2718804    1.657140857015031   2.475683344755806    2.3005029186373935     2.2718804   -0.6692771315574646   0.04717090725898743   -1.0167276859283447   99731       1         0              -1.8038561145794871   -1.80952973403217       1.4543804   -159.30081213760624  68.16420594881328   -32.287480777554315  58.55993   -8.166342547243272e-07   4.0399456e-07  176.25433082705823  0        -0.643153190612793    0.8070930497545803  -0.7373723983764648   4771.282   nan   nan       nan       78.74606945448743    -255.83754148145218  17.808940561402192\n",
       "1,165  0.11785906487249752   0.08847483112601966   0.11882245467274986   0.06779467873028361   0.03801905318467662   9.395322799682617   -0.3845840394496918   -0.28358957171440125  -0.48085200786590576  34.802338  9.918108029871799e-08    1.2833371e-07  0.0      21.730687168195804  -0.7610273361206055  19.584963      0.0065751865905664285   -2.2407725               0.007908253        20.062742        -0.20591638105879556   -1.5808507                 0.1435723            19.184309        0.3899514815920368    -3.0041256                 0.1435723            -11.4430685  163.64268  1.1658815   -0.9921388030052185   20.977941305794033  803.1406   1.433       -1.1456114053726196   1.4167645   -0.7985102470481145   -1.2350411854691319  -1.0666535865725877   0.83854187   0.9481371511247441  0.10609397613329813  -0.014613976378601738  0.83854187  -0.9093115329742432   -0.06070816144347191  -0.573256254196167    99823       1         0              0.6270305330302726    0.6225237923805556      0.46200135  -208.67652152432527  61.24792880191641   -44.021647514337545  63.986168  -1.9273868544824463e-07  1.2833371e-07  221.8898485012178   0        -0.5603996515274048   1.446258238190986   -0.6158600449562073   4276.7935  nan   nan       nan       6.244157910757682    -225.91754656015348  -22.142693836095198\n",
       "1,166  1.917877604633994     1.3702206129213375    1.8937630206087055    1.0859833201809104    0.6186701950432238    9.400785446166992   0.5861782431602478    -0.661990225315094    -0.446218341588974    28.715738  -4.908052626167452e-07   4.5137742e-07  0.0      21.56765254830313   -1.0741389989852905  20.798689      -0.005518799886512156   -2.133665                0.015706312        22.023201        0.09706545298345842    -1.5352793                 0.3772023            20.511465        0.7137742476844009    -2.8559453                 0.3772023            -10.957019   172.46034  1.279352    -0.9261223077774048   22.189399202694215  671.83466  1.323       -0.4879607856273651   1.3253865   5.462758179344159     5.667542559168328    5.871416168223197     2.502292     -2.843550123947125  2.409661008791584    2.2750541663028017     2.502292    0.23867693543434143   -1.0438926219940186   -1.0675371885299683   99881       1         0              -1.883078373748392    -1.8879365077565704     1.6249586   -200.34070153304094  26.516403301143548  -39.12458260932041   71.24494   1.7179552430969074e-07   4.5137742e-07  205.84034905511947  0        -0.30648577213287354  1.3302323661360405  0.5969148278236389    4453.539   nan   nan       nan       45.99363716354691    -245.2196565089809   -10.463755036288688\n",
       "1,167  0.3890935817655473    0.3459109855134188    0.42844236806758407   0.2332652879275749    0.12551405863404752   8.76700210571289    1.2602565288543701    -0.6482102274894714   -0.646274745464325    18.708971  -1.1252965856256632e-07  4.4515681e-07  0.0      21.967123504012505  -1.1567636728286743  20.788153      -0.0028946091431594823  -1.521986                0.015590355        20.725286        -0.3056262783830847    -1.3646538                 0.3733               20.2418          -0.16204777931782613  -1.7965397                 0.3733               -19.303923   178.78328  2.6245642   -0.3065233826637268   21.496632381861513  296.85895  2.3255537   0.10349282622337341   2.2348108   -0.9703733499833618   -1.8985779016318194  -1.6164166274595297   2.4722178    1.6569354981820585  0.28716138658722357  0.15742234829525623    2.4722178   -0.09991137683391571  0.01162821426987648   -0.6298919320106506   99944       1         0              -1.469024973955347    -1.4730667784191478     1.6025645   -233.4515586679823   4.958240307345907   -81.78993982121428   68.41039   -8.61161514396646e-07    4.4515681e-07  247.41424503737377  0        -0.13593457639217377  2.32588572372793    -0.7227007746696472   6840.3525  nan   nan       nan       65.61290171740593    -354.48857930707965  -69.47010348297734\n",
       "1,168  0.13128025060982007   0.10877511186828413   0.1389290640965563    0.07761901232932501   0.042348467938651636  8.829378128051758   0.945320188999176     -1.3487151861190796   -0.32563573122024536  35.68073   -6.829164901717445e-08   5.0387865e-07  0.0      21.449059479615702  -1.5585298538208008  20.904022      -0.004349176003901913   -0.6494634               0.01665563         21.971952        0.678119222946501      -0.29415557                0.40957612           20.778925        0.42905685318463965   -1.1768098                 0.40957612           -13.799286   159.73665  2.465999    -0.06979773193597794  21.024777711937936  144.35234  2.104846    -0.6132096648216248   2.0921621   -2.4980094064001293   -2.2022274170596026  -1.9733394462256058   2.7541013    0.4840052154049758  -1.2745613005915613  -1.501391448026907     2.7541013   -0.40418189764022827  -0.7111912369728088   -0.6041487455368042   99991       1         0              -0.46944864982128426  -0.4745794854764945     1.8139632   -177.56058760928536  65.5525804310451    -46.48781414288353   58.605503  4.792514094889688e-07    5.0387865e-07  194.90002549283216  0        -0.5130423903465271   2.1051179373093634  -0.10513915121555328  5345.2173  nan   nan       nan       -31.301481977818145  -304.94776329404436  -3.899390631479074"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey[~survey.gaia__dr2_g.isna()]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.10.12"
  },
  "vscode": {
   "interpreter": {
    "hash": "93aa337d3be5595eae1049f286a1f242db5cd4d40fd613efbe29fb4c796799bf"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}