{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# XMM-LSS master catalogue\n", "## Preparation of Canada France Hawaii Telescope WIRDS Survey (CFHT-WIRDS) data\n", "\n", "The catalogue is in `dmu0_CFHT-WIRDS`.\n", "\n", "In the catalogue, we keep:\n", "\n", "- The position;\n", "- The stellarity;\n", "- The aperture magnitude (3 arcsec).\n", "- The total magnitude (Kron like aperture magnitude).\n", "\n" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "This notebook was run with herschelhelp_internal version: \n", "0246c5d (Thu Jan 25 17:01:47 2018 +0000) [with local modifications]\n" ] } ], "source": [ "from herschelhelp_internal import git_version\n", "print(\"This notebook was run with herschelhelp_internal version: \\n{}\".format(git_version()))" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/seaborn/apionly.py:6: UserWarning: As seaborn no longer sets a default style on import, the seaborn.apionly module is deprecated. It will be removed in a future version.\n", " warnings.warn(msg, UserWarning)\n" ] } ], "source": [ "%matplotlib inline\n", "#%config InlineBackend.figure_format = 'svg'\n", "\n", "import matplotlib.pyplot as plt\n", "plt.rc('figure', figsize=(10, 6))\n", "\n", "from collections import OrderedDict\n", "import os\n", "\n", "from astropy import units as u\n", "from astropy.coordinates import SkyCoord\n", "from astropy.table import Column, Table, join\n", "import numpy as np\n", "\n", "from herschelhelp_internal.flagging import gaia_flag_column\n", "from herschelhelp_internal.masterlist import nb_astcor_diag_plot, remove_duplicates\n", "from herschelhelp_internal.utils import astrometric_correction, mag_to_flux\n", "from herschelhelp_internal.masterlist import merge_catalogues, nb_merge_dist_plot" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "OUT_DIR = os.environ.get('TMP_DIR', \"./data_tmp\")\n", "try:\n", " os.makedirs(OUT_DIR)\n", "except FileExistsError:\n", " pass\n", "\n", "RA_COL = \"wirds_ra\"\n", "DEC_COL = \"wirds_dec\"" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## I - Column selection" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n", "/Users/rs548/anaconda/envs/herschelhelp_internal/lib/python3.6/site-packages/astropy/table/column.py:954: RuntimeWarning: invalid value encountered in less\n", " return getattr(self.data, op)(other)\n" ] } ], "source": [ "#We have to import and combine the H, J and Ks catalogues separately. \n", "#Fluxes are given in counts sowe compute them fresh from the magnitudes\n", "\n", "epoch = 2007\n", "\n", "\n", "\n", "imported_columns = OrderedDict({\n", " 'id': \"wirds_id\",\n", " 'ra': \"wirds_ra\",\n", " 'dec': \"wirds_dec\",\n", "# ugriz are ks selected from cfhtls\n", " 'utot': \"m_wirds_u\",\n", " 'uterr': \"merr_wirds_u\",\n", " 'u': \"m_ap_wirds_u\",\n", " 'uerr': \"merr_ap_wirds_u\",\n", " 'gtot': \"m_wirds_g\",\n", " 'gterr': \"merr_wirds_g\",\n", " 'g': \"m_ap_wirds_g\",\n", " 'gerr': \"merr_ap_wirds_g\",\n", " 'rtot': \"m_wirds_r\",\n", " 'rterr': \"merr_wirds_r\",\n", " 'r': \"m_ap_wirds_r\",\n", " 'rerr': \"merr_ap_wirds_r\",\n", " 'itot': \"m_wirds_i\",\n", " 'iterr': \"merr_wirds_i\",\n", " 'i': \"m_ap_wirds_i\",\n", " 'ierr': \"merr_ap_wirds_i\",\n", " 'ztot': \"m_wirds_z\",\n", " 'zterr': \"merr_wirds_z\",\n", " 'z': \"m_ap_wirds_z\",\n", " 'zerr': \"merr_ap_wirds_z\",\n", " 'jtot': \"m_wirds_j\", \n", " 'jterr': \"merr_wirds_j\",\n", " 'j': \"m_ap_wirds_j\",\n", " 'jerr': \"merr_ap_wirds_j\",\n", " 'htot': \"m_wirds_h\",\n", " 'hterr': \"merr_wirds_h\",\n", " 'h': \"m_ap_wirds_h\",\n", " 'herr': \"merr_ap_wirds_h\",\n", " 'kstot': \"m_wirds_k\",\n", " 'ksterr': \"merr_wirds_k\",\n", " 'ks': \"m_ap_wirds_k\",\n", " 'kserr': \"merr_ap_wirds_k\"\n", " \n", " })\n", "\n", "\n", "catalogue = Table.read(\"../../dmu0/dmu0_CFHT-WIRDS/data/XMM-LSS_Ks-priors.fits\")[list(imported_columns)]\n", "for column in imported_columns:\n", " catalogue[column].name = imported_columns[column]\n", "\n", "for col in catalogue.colnames:\n", " if col.startswith('m_'):\n", " \n", " errcol = \"merr{}\".format(col[1:])\n", " #catalogue_h[col].name = imported_columns_h[col]\n", " \n", " #REplace 99.0 with nan\n", " catalogue[col][catalogue[col] > 90.] = np.nan\n", " catalogue[errcol][catalogue[errcol] > 90.] = np.nan \n", " #Replace -99.0 with nan\n", " catalogue[col][catalogue[col] < -90.] = np.nan\n", " catalogue[errcol][catalogue[errcol] < -90.] = np.nan \n", " \n", " flux, error = mag_to_flux(np.array(catalogue[col]), np.array(catalogue[errcol]))\n", " \n", " # Fluxes are added in µJy\n", " catalogue.add_column(Column(flux * 1.e6, name=\"f{}\".format(col[1:])))\n", " catalogue.add_column(Column(error * 1.e6, name=\"f{}\".format(errcol[1:])))\n", "\n", " # Band-flag column\n", " if \"ap\" not in col:\n", " catalogue.add_column(Column(np.zeros(len(catalogue), dtype=bool), name=\"flag{}\".format(col[1:])))\n", "# Clean table metadata\n", "catalogue.meta = None\n" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<Table masked=True length=10>\n", "
idx | wirds_id | wirds_ra | wirds_dec | m_wirds_u | merr_wirds_u | m_ap_wirds_u | merr_ap_wirds_u | m_wirds_g | merr_wirds_g | m_ap_wirds_g | merr_ap_wirds_g | m_wirds_r | merr_wirds_r | m_ap_wirds_r | merr_ap_wirds_r | m_wirds_i | merr_wirds_i | m_ap_wirds_i | merr_ap_wirds_i | m_wirds_z | merr_wirds_z | m_ap_wirds_z | merr_ap_wirds_z | m_wirds_j | merr_wirds_j | m_ap_wirds_j | merr_ap_wirds_j | m_wirds_h | merr_wirds_h | m_ap_wirds_h | merr_ap_wirds_h | m_wirds_k | merr_wirds_k | m_ap_wirds_k | merr_ap_wirds_k | f_wirds_u | ferr_wirds_u | flag_wirds_u | f_ap_wirds_u | ferr_ap_wirds_u | f_wirds_g | ferr_wirds_g | flag_wirds_g | f_ap_wirds_g | ferr_ap_wirds_g | f_wirds_r | ferr_wirds_r | flag_wirds_r | f_ap_wirds_r | ferr_ap_wirds_r | f_wirds_i | ferr_wirds_i | flag_wirds_i | f_ap_wirds_i | ferr_ap_wirds_i | f_wirds_z | ferr_wirds_z | flag_wirds_z | f_ap_wirds_z | ferr_ap_wirds_z | f_wirds_j | ferr_wirds_j | flag_wirds_j | f_ap_wirds_j | ferr_ap_wirds_j | f_wirds_h | ferr_wirds_h | flag_wirds_h | f_ap_wirds_h | ferr_ap_wirds_h | f_wirds_k | ferr_wirds_k | flag_wirds_k | f_ap_wirds_k | ferr_ap_wirds_k |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 36.1093493 | -4.9883601 | 21.0363 | 0.0036 | 22.9488 | 0.0053 | 20.0922 | 0.0011 | 21.8281 | 0.0015 | 19.3242 | 0.0007 | 20.8656 | 0.0008 | 18.9665 | 0.0007 | 20.3627 | 0.0006 | 18.7137 | 0.0014 | 20.084 | 0.0012 | 18.501 | 0.0075 | 19.6525 | 0.0049 | 18.2578 | 0.0169 | 19.3297 | 0.0099 | 18.0896 | 0.0082 | 19.2046 | 0.0051 | 13.9791 | 0.0463508669782 | False | 2.40149 | 0.011722813224 | 33.3519 | 0.0337900099112 | False | 6.74155 | 0.0093137937256 | 67.6581 | 0.0436207985331 | False | 16.3591 | 0.0120538315969 | 94.0589 | 0.0606420413533 | False | 25.9968 | 0.0143663615745 | 118.719 | 0.153081896133 | False | 33.6047 | 0.03714129125 | 144.411 | 0.997555289359 | False | 50.0034 | 0.225668858184 | 180.668 | 2.81217698648 | False | 67.3162 | 0.613805322064 | 210.941 | 1.59312416799 | False | 75.537 | 0.354818169581 |
1 | 2 | 36.3189404 | -4.9833459 | 15.8045 | 0.0001 | 16.0767 | 0.0001 | 15.2134 | 0.0 | 15.6293 | 0.0 | 15.0046 | 0.0 | 15.462 | 0.0 | 15.0982 | 0.0 | 15.6762 | 0.0 | 14.4932 | 0.0 | 14.8323 | 0.0 | 14.0688 | 0.0002 | 14.6185 | 0.0002 | 14.5408 | 0.0004 | 15.2585 | 0.0004 | 14.5941 | 0.0004 | 14.9612 | 0.0002 | 1730.61 | 0.159395346418 | False | 1346.85 | 0.12404959416 | 2982.91 | 0.0 | False | 2033.67 | 0.0 | 3615.43 | 0.0 | False | 2372.46 | 0.0 | 3316.81 | 0.0 | False | 1947.69 | 0.0 | 5790.55 | 0.0 | False | 4237.21 | 0.0 | 8560.12 | 1.57683230937 | False | 5159.41 | 0.950398296118 | 5542.17 | 2.04181037843 | False | 2861.54 | 1.05423005298 | 5276.67 | 1.94399692118 | False | 3762.88 | 0.693147582933 |
2 | 3 | 36.3267737 | -4.988378 | 21.1067 | 0.0028 | 22.1492 | 0.0027 | 18.9118 | 0.0003 | 19.866 | 0.0004 | 17.7086 | 0.0001 | 18.624 | 0.0002 | 16.9276 | 0.0001 | 17.8533 | 0.0001 | 16.5653 | 0.0002 | 17.519 | 0.0002 | 16.2183 | 0.0013 | 19.8858 | 0.0077 | 16.0944 | 0.0028 | 17.3109 | 0.0031 | 16.6746 | 0.0043 | 19.3908 | 0.0217 | 13.1015 | 0.0337872847012 | False | 5.01556 | 0.0124726635931 | 98.919 | 0.0273323341389 | False | 41.0771 | 0.0151333806571 | 299.613 | 0.0275953439996 | False | 128.944 | 0.023752283596 | 615.12 | 0.0566546048503 | False | 262.228 | 0.0241521280259 | 858.776 | 0.15819236869 | False | 356.78 | 0.0657212454826 | 1182.17 | 1.41546454979 | False | 40.3348 | 0.286052920274 | 1325.07 | 3.41722294688 | False | 432.155 | 1.23389239889 | 776.532 | 3.07541520451 | False | 63.6326 | 1.27178851835 |
3 | 4 | 36.1194841 | -4.989503 | 22.3153 | 0.0136 | 28.7899 | 1.1136 | 21.4042 | 0.0041 | 27.5511 | 0.2463 | 20.5406 | 0.0024 | 26.4108 | 0.1099 | 20.2153 | 0.0025 | 26.2389 | 0.1347 | 19.9849 | 0.0051 | 25.689 | 0.2047 | 18.1782 | 0.0094 | 20.2379 | 0.013 | 18.8785 | 0.0367 | 20.9418 | 0.0532 | 18.5204 | 0.0192 | 20.1954 | 0.0236 | 4.30407 | 0.0539130891411 | False | 0.0110672 | 0.0113512741905 | 9.96139 | 0.0376166080969 | False | 0.0346386 | 0.00785778136851 | 22.0679 | 0.0487805809826 | False | 0.0990101 | 0.0100219617259 | 29.7769 | 0.0685638951836 | False | 0.115995 | 0.0143907533953 | 36.8163 | 0.172936197851 | False | 0.192486 | 0.0362905454892 | 194.411 | 1.68315230403 | False | 29.1635 | 0.349187705069 | 102.0 | 3.44779552324 | False | 15.2504 | 0.747252361543 | 141.854 | 2.50851754099 | False | 30.3277 | 0.659215359337 |
4 | 5 | 36.3363184 | -4.9819037 | 26.546 | 0.2519 | nan | nan | 25.5396 | 0.0731 | 28.2986 | 0.4408 | 24.5777 | 0.0401 | 26.4951 | 0.1121 | 24.1835 | 0.0406 | 26.7757 | 0.2117 | 23.7668 | 0.0678 | 26.8485 | 0.5495 | 23.3261 | 0.4034 | nan | nan | nan | nan | nan | nan | 21.1598 | 0.0816 | 22.6219 | 0.0966 | 0.0874178 | 0.0202816696586 | False | nan | nan | 0.220882 | 0.0148714273138 | False | 0.0174004 | 0.00706443310037 | 0.535698 | 0.0197851813653 | False | 0.0916136 | 0.00945891096649 | 0.770193 | 0.0288005812081 | False | 0.070749 | 0.0137948371929 | 1.13052 | 0.0705968358716 | False | 0.0661607 | 0.0334844663499 | 1.69652 | 0.630335047822 | False | nan | nan | nan | nan | False | nan | nan | 12.4761 | 0.937660619093 | False | 3.24519 | 0.288730283091 |
5 | 6 | 36.0813561 | -4.9886495 | 23.5764 | 0.0212 | 24.4042 | 0.0169 | 23.2406 | 0.011 | 24.0309 | 0.0084 | 22.9964 | 0.0113 | 23.6778 | 0.0078 | 22.3072 | 0.0083 | 22.9543 | 0.0055 | 21.9524 | 0.0158 | 22.5964 | 0.0104 | 22.1876 | 0.1415 | 22.2595 | 0.0536 | 21.2906 | 0.1802 | 22.2909 | 0.156 | 20.977 | 0.072 | 21.946 | 0.0633 | 1.34722 | 0.0263057620487 | False | 0.628521 | 0.00978322891569 | 1.83552 | 0.0185963613148 | False | 0.886422 | 0.0068579669005 | 2.29847 | 0.0239217981971 | False | 1.2271 | 0.00881556857166 | 4.33631 | 0.0331492757141 | False | 2.38935 | 0.0121036974861 | 6.01229 | 0.0874928644407 | False | 3.32231 | 0.0318235806844 | 4.84128 | 0.630946396086 | False | 4.53106 | 0.223686570462 | 11.0601 | 1.83565168227 | False | 4.4019 | 0.632470588243 | 14.7639 | 0.979057367658 | False | 6.04784 | 0.352597622668 |
6 | 7 | 36.2516928 | -4.9893471 | 21.4254 | 0.0028 | 21.6526 | 0.0018 | 19.2457 | 0.0003 | 19.4412 | 0.0003 | 18.144 | 0.0002 | 18.3198 | 0.0001 | 17.5471 | 0.0001 | 17.6997 | 0.0001 | 17.2861 | 0.0002 | 17.4633 | 0.0002 | 17.0229 | 0.0011 | 17.1636 | 0.0005 | 16.7669 | 0.0031 | 16.8778 | 0.0014 | 17.1145 | 0.0022 | 17.2809 | 0.001 | 9.76877 | 0.0251926438068 | False | 7.92429 | 0.0131373661134 | 72.731 | 0.0200963200768 | False | 60.7463 | 0.0167848200363 | 200.632 | 0.0369577726815 | False | 170.64 | 0.0157164933626 | 347.664 | 0.0320210470818 | False | 302.079 | 0.027822481934 | 442.14 | 0.0814451952465 | False | 375.56 | 0.0691807537805 | 563.43 | 0.570831994992 | False | 494.948 | 0.227931974223 | 713.247 | 2.0364683005 | False | 643.991 | 0.830392853823 | 517.845 | 1.04929626104 | False | 444.263 | 0.409181404393 |
7 | 8 | 36.260898 | -4.9888342 | 24.2867 | 0.0242 | 24.4508 | 0.0166 | 21.9667 | 0.0022 | 22.1063 | 0.0016 | 20.6917 | 0.0009 | 20.8244 | 0.0007 | 19.6503 | 0.0005 | 19.7643 | 0.0004 | 19.2242 | 0.0008 | 19.3578 | 0.0006 | 18.8231 | 0.0038 | 18.9537 | 0.0025 | 18.6976 | 0.0122 | 18.7447 | 0.0075 | 18.9351 | 0.0072 | 19.0856 | 0.0046 | 0.700358 | 0.0156103013296 | False | 0.602115 | 0.009205842548 | 5.93363 | 0.0120231579785 | False | 5.21771 | 0.00768909812905 | 19.2008 | 0.0159161552801 | False | 16.9918 | 0.0109550299385 | 50.1049 | 0.0230741552514 | False | 45.1108 | 0.0166194193298 | 74.1857 | 0.0546620576642 | False | 65.5964 | 0.0362499282346 | 107.34 | 0.375681300648 | False | 95.1745 | 0.219147277676 | 120.493 | 1.35392794473 | False | 115.377 | 0.796997355792 | 96.8188 | 0.642048282316 | False | 84.2868 | 0.357102854468 |
8 | 9 | 36.1722634 | -4.9901812 | 24.0427 | 0.0228 | 24.6631 | 0.0222 | 23.3449 | 0.0082 | 23.9239 | 0.0076 | 22.522 | 0.005 | 23.0778 | 0.0046 | 21.5203 | 0.0028 | 22.0334 | 0.0024 | 20.9904 | 0.0045 | 21.4856 | 0.0038 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | 0.876839 | 0.0184132418326 | False | 0.495177 | 0.0101248590056 | 1.6674 | 0.0125930009744 | False | 0.978226 | 0.00684744723003 | 3.55795 | 0.0163849676937 | False | 2.13245 | 0.00903468203433 | 8.95117 | 0.0230841375014 | False | 5.58008 | 0.0123346580949 | 14.5828 | 0.0604404917794 | False | 9.24188 | 0.0323459180436 | nan | nan | False | nan | nan | nan | nan | False | nan | nan | nan | nan | False | nan | nan |
9 | 10 | 36.2733347 | -4.988222 | 24.2638 | 0.0261 | 24.9569 | 0.026 | 22.1446 | 0.0028 | 22.3834 | 0.002 | 20.7885 | 0.0011 | 20.9656 | 0.0007 | 18.7986 | 0.0003 | 18.9341 | 0.0002 | 17.9781 | 0.0003 | 18.1332 | 0.0002 | 17.3097 | 0.0013 | 17.5432 | 0.0011 | 17.1307 | 0.003 | 17.2477 | 0.0018 | 17.3896 | 0.0022 | 17.5591 | 0.0017 | 0.715286 | 0.0171947539343 | False | 0.377781 | 0.00904667615487 | 5.03686 | 0.0129895337523 | False | 4.04241 | 0.00744638555261 | 17.563 | 0.0177937779881 | False | 14.9197 | 0.00961909327089 | 109.789 | 0.0303359192912 | False | 96.9081 | 0.0178511312697 | 233.754 | 0.0645887412247 | False | 202.638 | 0.0373272225261 | 432.633 | 0.518010888482 | False | 348.915 | 0.353499216726 | 510.176 | 1.40966917388 | False | 458.057 | 0.759395607747 | 401.938 | 0.814437877852 | False | 343.843 | 0.538375001634 |