{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# XMM-LSS master catalogue\n", "## Preparation of HST CANDELS-UDS data\n", "\n", "The UDS survey appears to be a cross match between CANDELS-3D-HST with various other multiwavelength catalogues that we are already including across XMM-LSS. We use this catalogue since these forced photometries are for onjects at much greater depths than the blod catalogues. \n", "\n", "CANDELS-UDS catalogue: the catalogue comes from `dmu0_CANDELS-UDS`.\n", "\n", "In the catalogue, we keep:\n", "\n", "- The identifier (it's unique in the catalogue);\n", "- The position;\n", "- The stellarity;\n", "- The total magnitude.\n", "\n", "We don't know when the maps have been observed. We will use the year of the reference paper." ] }, { "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)\n" ] } ], "source": [ "from herschelhelp_internal import git_version\n", "print(\"This notebook was run with herschelhelp_internal version: \\n{}\".format(git_version()))\n", "import datetime\n", "print(\"This notebook was executed on: \\n{}\".format(datetime.datetime.now()))" ] }, { "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\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, flux_to_mag" ] }, { "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 = \"candels_ra\"\n", "DEC_COL = \"candels_dec\"" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## I - Column selection" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": true }, "outputs": [], "source": [ "imported_columns = OrderedDict({\n", " 'ID': \"candels_id\",\n", " 'RA': \"candels_ra\",\n", " 'Dec': \"candels_dec\",\n", " 'CLASS_STAR': \"candels_stellarity\",\n", " #HST data\n", " \n", " 'Flux_F606W_hst': \"f_acs_f606w\", \n", " 'Fluxerr_F606W_hst': \"ferr_acs_f606w\", \n", " 'flux_aper10_f606w': \"f_ap_acs_f606w\", \n", " 'fluxerr_aper10_f606w': \"ferr_ap_acs_f606w\", \n", " \n", " 'Flux_F814W_hst': \"f_acs_f814w\", \n", " 'Fluxerr_F814W_hst': \"ferr_acs_f814w\", \n", " 'flux_aper10_f814w': \"f_ap_acs_f814w\", \n", " 'fluxerr_aper10_f814w': \"ferr_ap_acs_f814w\", \n", "\n", " 'Flux_F125W_hst': \"f_wfc3_f125w\", \n", " 'Fluxerr_F125W_hst': \"ferr_wfc3_f125w\", \n", " 'flux_aper10_f125w': \"f_ap_wfc3_f125w\", \n", " 'fluxerr_aper10_f125w': \"ferr_ap_wfc3_f125w\", \n", " \n", " 'Flux_F160W_hst': \"f_wfc3_f160w\", \n", " 'Fluxerr_F160W_hst': \"ferr_wfc3_f160w\", \n", " 'flux_aper10_f160w': \"f_ap_wfc3_f160w\", \n", " 'fluxerr_aper10_f160w': \"ferr_ap_wfc3_f160w\", \n", "\n", " # Megacam u\n", " 'Flux_U_cfht': 'f_candels-megacam_u',\n", " 'Fluxerr_U_cfht': 'ferr_candels-megacam_u',\n", " \n", " # Suprime B, V, Rc, ip, zp - ip and zp are labelled with prime so as not to be confused with hsc i and z\n", " 'Flux_B_subaru': 'f_suprime_b',\n", " 'Fluxerr_B_subaru': 'ferr_suprime_b',\n", " 'Flux_V_subaru': 'f_suprime_v',\n", " 'Fluxerr_V_subaru': 'ferr_suprime_v',\n", " 'Flux_R_subaru': 'f_suprime_rc',\n", " 'Fluxerr_R_subaru': 'ferr_suprime_rc',\n", " 'Flux_i_subaru': 'f_suprime_ip',\n", " 'Fluxerr_i_subaru': 'ferr_suprime_ip',\n", " 'Flux_z_subaru': 'f_suprime_zp',\n", " 'Fluxerr_z_subaru': 'ferr_suprime_zp',\n", " \n", " #HAWKI VLT\n", " 'Flux_Y_hawki': \"f_hawki_y\",\n", " 'Fluxerr_Y_hawki': \"ferr_hawki_y\",\n", " 'Flux_Y_hawki': \"f_hawki_k\",\n", " 'Fluxerr_Ks_hawki': \"ferr_hawki_k\",\n", " \n", " # UKIDSS J, H, K\n", " 'Flux_J_ukidss_DR8': \"f_candels-ukidss_j\",\n", " 'Fluxerr_J_ukidss_DR8': \"ferr_candels-ukidss_j\",\n", " 'Flux_H_ukidss_DR8': \"f_candels-ukidss_h\",\n", " 'Fluxerr_H_ukidss_DR8': \"ferr_candels-ukidss_h\", \n", " 'Flux_K_ukidss_DR8': \"f_candels-ukidss_k\",\n", " 'Fluxerr_K_ukidss_DR8': \"ferr_candels-ukidss_k\",\n", " \n", " #Spitzer/IRAC\n", " 'Flux_ch1_seds': \"f_candels-irac_i1\",# 47 IRAC_CH1_FLUX Flux density (in μJy) in the 3.6μm-band (Spitzer/IRAC) (3)\n", " 'Fluxerr_ch1_seds': \"ferr_candels-irac_i1\",# 48 IRAC_CH1_FLUXERR Flux uncertainty (in μJy) in the 3.6μm-band (Spitzer/IRAC) (3)\n", " 'Flux_ch2_seds': \"f_candels-irac_i2\",# 49 IRAC_CH2_FLUX Flux density (in μJy) in the 4.5μm-band (Spitzer/IRAC) (3)\n", " 'Fluxerr_ch2_seds': \"ferr_candels-irac_i2\",# 50 IRAC_CH2_FLUXERR Flux uncertainty (in μJy) in the 4.5μm-band (Spitzer/IRAC) (3)\n", " 'Flux_ch3_spuds': \"f_candels-irac_i3\",# 51 IRAC_CH3_FLUX Flux density (in μJy) in the 5.8μm-band (Spitzer/IRAC) (3)\n", " 'Fluxerr_ch3_spuds': \"ferr_candels-irac_i3\",# 52 IRAC_CH3_FLUXERR Flux uncertainty (in μJy) in the 5.8μm-band (Spitzer/IRAC) (3)\n", " 'Flux_ch4_spuds': \"f_candels-irac_i4\",# 53 IRAC_CH4_FLUX Flux density (in μJy) in the 8.0μm-band (Spitzer/IRAC) (3)\n", " 'Fluxerr_ch4_spuds': \"ferr_candels-irac_i4\"# 54 IRAC_CH4_FLUXERR\n", " \n", " \n", " })\n", "\n", "\n", "catalogue = Table.read(\"../../dmu0/dmu0_CANDELS-UDS/data/hlsp_candels_hst_wfc3_uds-tot-multiband_f160w_v1_cat.fits\")[list(imported_columns)]\n", "for column in imported_columns:\n", " catalogue[column].name = imported_columns[column]\n", "\n", "epoch = 2011\n", "\n", "# Clean table metadata\n", "catalogue.meta = None" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/rs548/GitHub/herschelhelp_internal/herschelhelp_internal/utils.py:76: RuntimeWarning: invalid value encountered in log10\n", " magnitudes = 2.5 * (23 - np.log10(fluxes)) - 48.6\n", "/Users/rs548/GitHub/herschelhelp_internal/herschelhelp_internal/utils.py:76: RuntimeWarning: divide by zero encountered in log10\n", " magnitudes = 2.5 * (23 - np.log10(fluxes)) - 48.6\n", "/Users/rs548/GitHub/herschelhelp_internal/herschelhelp_internal/utils.py:80: RuntimeWarning: divide by zero encountered in true_divide\n", " errors = 2.5 / np.log(10) * errors_on_fluxes / fluxes\n" ] } ], "source": [ "# Adding flux and band-flag columns\n", "for col in catalogue.colnames:\n", " if col.startswith('f_'):\n", " \n", " errcol = \"ferr{}\".format(col[1:])\n", " \n", " # Some object have a magnitude to 0, we suppose this means missing value\n", " mask = np.isclose(catalogue[col], -99.) \n", " catalogue[col][mask] = np.nan\n", " catalogue[errcol][mask] = np.nan \n", " \n", "\n", " mag, error = flux_to_mag(np.array(catalogue[col])*1.e-6, np.array(catalogue[errcol])*1.e-6)\n", " \n", " # Fluxes are added in µJy\n", " catalogue.add_column(Column(mag, name=\"m{}\".format(col[1:])))\n", " catalogue.add_column(Column(error, name=\"m{}\".format(errcol[1:])))\n", " \n", "\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", " \n", "catalogue['candels_stellarity'] = catalogue['candels_stellarity'].astype(float)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<Table length=10>\n", "
idx | candels_id | candels_ra | candels_dec | candels_stellarity | f_acs_f606w | ferr_acs_f606w | f_ap_acs_f606w | ferr_ap_acs_f606w | f_acs_f814w | ferr_acs_f814w | f_ap_acs_f814w | ferr_ap_acs_f814w | f_wfc3_f125w | ferr_wfc3_f125w | f_ap_wfc3_f125w | ferr_ap_wfc3_f125w | f_wfc3_f160w | ferr_wfc3_f160w | f_ap_wfc3_f160w | ferr_ap_wfc3_f160w | f_candels-megacam_u | ferr_candels-megacam_u | f_suprime_b | ferr_suprime_b | f_suprime_v | ferr_suprime_v | f_suprime_rc | ferr_suprime_rc | f_suprime_ip | ferr_suprime_ip | f_suprime_zp | ferr_suprime_zp | f_hawki_k | ferr_hawki_y | ferr_hawki_k | f_candels-ukidss_j | ferr_candels-ukidss_j | f_candels-ukidss_h | ferr_candels-ukidss_h | f_candels-ukidss_k | ferr_candels-ukidss_k | f_candels-irac_i1 | ferr_candels-irac_i1 | f_candels-irac_i2 | ferr_candels-irac_i2 | f_candels-irac_i3 | ferr_candels-irac_i3 | f_candels-irac_i4 | ferr_candels-irac_i4 | m_acs_f606w | merr_acs_f606w | flag_acs_f606w | m_ap_acs_f606w | merr_ap_acs_f606w | m_acs_f814w | merr_acs_f814w | flag_acs_f814w | m_ap_acs_f814w | merr_ap_acs_f814w | m_wfc3_f125w | merr_wfc3_f125w | flag_wfc3_f125w | m_ap_wfc3_f125w | merr_ap_wfc3_f125w | m_wfc3_f160w | merr_wfc3_f160w | flag_wfc3_f160w | m_ap_wfc3_f160w | merr_ap_wfc3_f160w | m_candels-megacam_u | merr_candels-megacam_u | flag_candels-megacam_u | m_suprime_b | merr_suprime_b | flag_suprime_b | m_suprime_v | merr_suprime_v | flag_suprime_v | m_suprime_rc | merr_suprime_rc | flag_suprime_rc | m_suprime_ip | merr_suprime_ip | flag_suprime_ip | m_suprime_zp | merr_suprime_zp | flag_suprime_zp | m_hawki_k | merr_hawki_k | flag_hawki_k | m_candels-ukidss_j | merr_candels-ukidss_j | flag_candels-ukidss_j | m_candels-ukidss_h | merr_candels-ukidss_h | flag_candels-ukidss_h | m_candels-ukidss_k | merr_candels-ukidss_k | flag_candels-ukidss_k | m_candels-irac_i1 | merr_candels-irac_i1 | flag_candels-irac_i1 | m_candels-irac_i2 | merr_candels-irac_i2 | flag_candels-irac_i2 | m_candels-irac_i3 | merr_candels-irac_i3 | flag_candels-irac_i3 | m_candels-irac_i4 | merr_candels-irac_i4 | flag_candels-irac_i4 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 34.2237643 | -5.278053 | 0.519999980927 | 0.00383235 | 0.00380117 | 0.189778 | 0.0313505 | 0.0200556 | 0.00454155 | 0.667812 | 0.03512 | nan | nan | nan | nan | 0.0432469 | 0.0107197 | 0.665096 | 0.0916176 | 0.0253491 | 0.0079166 | 0.1070755 | 0.0051127 | 0.1961661 | 0.0078883 | 0.2805149 | 0.012035 | 0.3639701 | 0.015676 | 0.4249759 | 0.0252748 | nan | -99.0 | nan | 0.3989874 | 0.0455263 | 0.4988002 | 0.0917653 | 0.6212133 | 0.0551074 | 7.7534485 | 0.1612514 | 5.9024348 | 0.2028079 | 8.4801502 | 5.5815258 | 11.5163879 | 7.3330321 | 29.9413370866 | 1.07690265488 | False | 25.7043853364 | 0.179358897698 | 28.1444108519 | 0.245862764551 | False | 24.3383644533 | 0.0570984880642 | nan | nan | False | nan | nan | 27.3101125448 | 0.26912371509 | False | 24.3427891602 | 0.149561184119 | 27.8900936384 | 0.339078674927 | False | 26.3257747224 | 0.0518423308233 | False | 25.6684401052 | 0.0436600049855 | False | 25.2801101639 | 0.0465816084075 | False | 24.99733573 | 0.0467620849784 | False | 24.8290892442 | 0.0645725214724 | False | nan | nan | False | 24.8976020477 | 0.123887501657 | False | 24.6551834526 | 0.199745125504 | False | 24.4168981368 | 0.0963149039631 | False | 21.6762627336 | 0.0225804663625 | False | 21.9724220039 | 0.0373059401928 | False | 21.5789911387 | 0.71461760652 | False | 21.2467092886 | 0.691339898478 | False |
1 | 2 | 34.2239039 | -5.277949 | 0.600000023842 | 0.152107 | 0.0358003 | 0.209163 | 0.0314603 | 0.343002 | 0.0407999 | 0.686853 | 0.0354069 | nan | nan | nan | nan | 0.443607 | 0.0599043 | 0.548932 | 0.0839704 | -0.016319 | 0.0081315 | 0.0273083 | 0.0052857 | 0.0505463 | 0.0081046 | 0.0623513 | 0.0123424 | 0.1203997 | 0.0157696 | 0.1211634 | 0.0259548 | nan | -99.0 | nan | -0.072327 | 0.0479076 | 0.0177186 | 0.0954408 | -0.0963344 | 0.058181 | -5.3686185 | 0.1557703 | -3.9642839 | 0.1994832 | -7.4006734 | 5.4277391 | -8.1172228 | 7.1442533 | 25.9446269979 | 0.255541703217 | False | 25.5987878444 | 0.16330606619 | 25.0617583691 | 0.129147726779 | False | 24.3078405013 | 0.0559691130828 | nan | nan | False | nan | nan | 24.7825040235 | 0.146616864321 | False | 24.5512036282 | 0.166085605153 | nan | -0.541005205527 | False | 27.8092633369 | 0.210151340709 | False | 27.1407765734 | 0.174087077493 | False | 26.9128862181 | 0.214920788077 | False | 26.198436488 | 0.142206547479 | False | 26.1915713708 | 0.232579030031 | False | nan | nan | False | nan | -0.71916456929 | False | 28.27892649 | 5.84829117261 | False | nan | -0.655728567667 | False | nan | -0.0315026024546 | False | nan | -0.0546343647288 | False | nan | -0.796291436243 | False | nan | -0.955594623296 | False |
2 | 3 | 34.2234901 | -5.2779525 | 0.0 | 0.0328152 | 0.00704481 | 0.198287 | 0.0311769 | 0.0512792 | 0.00735298 | 0.508555 | 0.0331728 | 0.130189 | 0.0249594 | 0.596059 | 0.145368 | 0.123917 | 0.0176126 | 0.29656 | 0.0873411 | 0.0532093 | 0.0065303 | 0.228689 | 0.0046072 | 0.385888 | 0.0071173 | 0.5438799 | 0.0107064 | 0.6749271 | 0.0142887 | 0.7351558 | 0.0230638 | nan | -99.0 | nan | 0.4838867 | 0.040427 | 0.598594 | 0.0822843 | 0.652486 | 0.0504896 | 3.9972773 | 0.0818634 | 4.0006614 | 0.1019581 | 6.831326 | 2.8198733 | 3.0184731 | 3.5179389 | 27.6098123612 | 0.233087266652 | False | 25.6567643947 | 0.170711590181 | 27.125146897 | 0.155684889758 | False | 24.6341551786 | 0.0708220545923 | 26.1135642722 | 0.208153716743 | False | 24.4617768754 | 0.264791405907 | 26.1671727732 | 0.154318111961 | False | 25.2197185674 | 0.319764615705 | 27.0850311361 | 0.133250825287 | False | 25.5018868114 | 0.0218733906859 | False | 24.9338468163 | 0.0200252671504 | False | 24.5612424774 | 0.0213729650657 | False | 24.3268578338 | 0.0229858290013 | False | 24.2340515301 | 0.0340624431982 | False | nan | nan | False | 24.6881407866 | 0.0907093696722 | False | 24.4571691015 | 0.14924814414 | False | 24.3635720057 | 0.0840146557685 | False | 22.3955893068 | 0.0222356495569 | False | 22.39467051 | 0.0276703248464 | False | 21.8137374726 | 0.448176318132 | False | 22.7005317253 | 1.26539263506 | False |
3 | 4 | 34.2651053 | -5.277749 | 0.00999999977648 | 0.0328907 | 0.0145209 | 0.396141 | 0.0474954 | 0.0656842 | 0.0142876 | 0.423721 | 0.044462 | 0.234673 | 0.0351306 | 1.7147 | 0.301639 | nan | nan | 1.39196 | 0.0892937 | 0.0134078 | 0.0068738 | 0.0613298 | 0.0040118 | 0.091597 | 0.007739 | 0.1152063 | 0.0067216 | 0.2236729 | 0.0084242 | 0.3503483 | 0.023667 | nan | -99.0 | nan | 1.4360707 | 0.046361 | 2.6859834 | 0.0969349 | 3.9268873 | 0.0583401 | 10.7989941 | 0.0666577 | 13.1855164 | 0.0899891 | 10.9588842 | 1.7959237 | 16.0584793 | 2.7690244 | 27.6073172087 | 0.479341177162 | False | 24.9053755161 | 0.130174547294 | 26.856347713 | 0.236168889917 | False | 24.8323000286 | 0.113928748247 | 25.4738421868 | 0.162534949972 | False | 23.3145296304 | 0.19099573282 | nan | nan | False | 23.5409331116 | 0.0696495610124 | 28.5816061923 | 0.556626256676 | False | 26.9308211289 | 0.0710218606004 | False | 26.4952968755 | 0.0917334900556 | False | 26.2463094277 | 0.0633462273669 | False | 25.5259665786 | 0.0408921194124 | False | 25.0387499637 | 0.0733444939165 | False | nan | nan | False | 23.5070604464 | 0.035051071085 | False | 22.8272416892 | 0.039183313804 | False | 22.4148789065 | 0.0161303225481 | False | 21.3165417403 | 0.00670179810691 | False | 21.0997571419 | 0.00740998084107 | False | 21.3005841553 | 0.177928641866 | False | 20.8857389594 | 0.187217605526 | False |
4 | 5 | 34.2953666 | -5.2776482 | 0.0 | 0.588878 | 0.0269462 | 19.7562 | 0.156768 | 0.791973 | 0.0279338 | 35.5287 | 0.192843 | 0.616685 | 0.0475773 | 9.48301 | 0.222582 | 1.03337 | 0.0424778 | 4.30963 | 0.119648 | 6.8024368 | 0.0077833 | 11.7074871 | 0.0046557 | 18.3564949 | 0.0087363 | 25.0890808 | 0.0094336 | 30.2162495 | 0.0129899 | 34.4122581 | 0.0269354 | nan | -99.0 | nan | 67.14328 | 0.0485047 | 62.9228096 | 0.1015036 | 28.6200943 | 0.0595617 | 101.0892334 | 0.1377356 | 75.6936264 | 0.1573701 | 65.2973251 | 2.8800869 | 39.0768776 | 4.7422323 | 24.4749366757 | 0.0496817081308 | False | 20.6607414649 | 0.00861545708929 | 24.1532240604 | 0.0382951666237 | False | 20.0235517078 | 0.0058931688166 | 24.4248415376 | 0.0837646401885 | False | 21.4576344787 | 0.0254840325938 | 23.8643603768 | 0.0446303699144 | False | 22.3139000357 | 0.0301432293322 | 21.8183387112 | 0.00124229167443 | False | 21.2288407802 | 0.000431763196091 | False | 20.7405256051 | 0.000516728125783 | False | 20.4012881246 | 0.000408241383686 | False | 20.1993986053 | 0.000466755635116 | False | 20.0582170711 | 0.000849834930467 | False | nan | nan | False | 19.3324936174 | 0.000784342214008 | False | 19.4029797343 | 0.00175144965926 | False | 20.2583223491 | 0.00225954161538 | False | 18.8882377422 | 0.0014793318989 | False | 19.2023517192 | 0.00225728932861 | False | 19.362761523 | 0.0478888624517 | False | 19.9202003636 | 0.131761123603 | False |
5 | 6 | 34.2623285 | -5.277639 | 0.990000009537 | 0.909265 | 0.0344329 | 0.906097 | 0.0516012 | 1.2425 | 0.0345479 | 1.24206 | 0.0499163 | 1.36594 | 0.0481661 | 1.49832 | 0.0835658 | 1.48605 | 0.0501724 | 1.5491 | 0.0752881 | 0.1916049 | 0.0062028 | 0.471835 | 0.0035422 | 0.8439085 | 0.0069494 | 1.0120889 | 0.0063073 | 1.2988968 | 0.0074521 | 1.277318 | 0.0208103 | nan | -99.0 | nan | 1.3726765 | 0.0405144 | 1.534698 | 0.0848346 | 1.0194699 | 0.0501096 | 0.7799978 | 0.0498606 | 0.5346622 | 0.0676026 | 1.5168504 | 1.4820567 | -2.0007536 | 2.2976654 | 24.0032738143 | 0.0411156771291 | False | 24.0070632688 | 0.0618314496671 | 23.6642590065 | 0.0301890590168 | False | 23.6646435606 | 0.0436339098897 | 23.5614209424 | 0.0382854873655 | False | 23.4609885584 | 0.0605547643625 | 23.4699164449 | 0.0366569033072 | False | 23.4248013651 | 0.052768069174 | 25.6939834718 | 0.0351483940696 | False | 24.7155246174 | 0.00815093154279 | False | 24.084261597 | 0.00894079770656 | False | 23.8869533455 | 0.00676626723628 | False | 23.6160633828 | 0.00622914366367 | False | 23.6342524192 | 0.0176890141232 | False | nan | nan | False | 23.5560795033 | 0.032045387893 | False | 23.4349426821 | 0.0600170174433 | False | 23.8790639808 | 0.0533667614178 | False | 24.1697665556 | 0.0694046298733 | False | 24.5798012973 | 0.137280305875 | False | 23.4476431239 | 1.0608314549 | False | nan | -1.24685943896 | False |
6 | 7 | 34.2735198 | -5.2774614 | 0.0 | 0.0378504 | 0.0102481 | 0.0785766 | 0.0439404 | 0.0876356 | 0.0110787 | 0.197364 | 0.0421329 | 0.0913736 | 0.0159556 | 0.238668 | 0.0820361 | 0.108755 | 0.0168276 | 0.308733 | 1.96967 | 0.0740362 | 0.0069421 | 0.0788938 | 0.0041298 | 0.0888844 | 0.0074549 | 0.105492 | 0.0058975 | 0.2010929 | 0.0083805 | 0.2102027 | 0.0215401 | nan | -99.0 | nan | 0.2087499 | 0.0421144 | 0.3815094 | 0.0882051 | 0.422194 | 0.052297 | 0.3976128 | 0.048623 | 0.3426238 | 0.0627264 | 0.1945765 | 1.0035983 | 0.1125159 | 1.739204 | 27.4548238164 | 0.293966066408 | False | 26.6617669175 | 0.607148732976 | 26.543298589 | 0.137256385438 | False | 25.6618301538 | 0.231780947597 | 26.4979481603 | 0.189590566516 | False | 25.4555145155 | 0.373194411765 | 26.3088769182 | 0.167995352482 | False | 25.1760423674 | 6.9268333169 | 26.7263897001 | 0.101805458776 | False | 26.657392813 | 0.0568342934224 | False | 26.5279361372 | 0.0910627155367 | False | 26.3419511847 | 0.0606977710875 | False | 25.641508157 | 0.0452478046911 | False | 25.5934042747 | 0.111258639514 | False | nan | nan | False | 25.6009343097 | 0.219042638208 | False | 24.9462368925 | 0.251022571172 | False | 24.8362198574 | 0.134489704497 | False | 24.901349108 | 0.132771760577 | False | 25.0629561813 | 0.19877289165 | False | 25.6772740322 | 5.60007508278 | False | 26.271965254 | 16.78266583 | False |
7 | 8 | 34.2244858 | -5.2773846 | 0.360000014305 | 0.022162 | 0.0335978 | -0.0320263 | 0.0309293 | 0.0474166 | 0.0351609 | 0.130792 | 0.0341428 | 0.0490986 | 0.0642949 | 0.0371461 | 0.0620933 | 0.289979 | 0.0409937 | 0.301996 | 0.056041 | -0.0032826 | 0.0062813 | 0.0219457 | 0.0044207 | 0.0397608 | 0.006632 | 0.0412439 | 0.0096323 | 0.0448376 | 0.0110313 | 0.0481238 | 0.0205071 | nan | -99.0 | nan | 0.1484165 | 0.040435 | 0.0900109 | 0.0812886 | 0.0861035 | 0.0502468 | 0.3350099 | 0.0622374 | 0.5058988 | 0.0813448 | -1.7647239 | 2.143779 | -1.8958515 | 2.6810842 | 28.0359776236 | 1.64598627652 | False | nan | -1.04854637588 | 27.2101739757 | 0.80510753875 | False | 26.1085470479 | 0.283427687411 | 27.172327228 | 1.42177782485 | False | 27.4752169411 | 1.8149131102 | 25.2440836304 | 0.153488163822 | False | 25.1999970233 | 0.201478637634 | nan | -2.0775710787 | False | 28.0466264049 | 0.218708632688 | False | 27.4013622151 | 0.181098028962 | False | 27.361600687 | 0.253568087525 | False | 27.2708941043 | 0.267121384631 | False | 27.1941002169 | 0.462667140263 | False | nan | nan | False | 25.9712945357 | 0.295800961749 | False | 26.5142622396 | 0.980525425855 | False | 26.5624479866 | 0.633595265387 | False | 25.0873558969 | 0.20170567637 | False | 24.6398408769 | 0.174578382927 | False | nan | -1.31894766955 | False | nan | -1.53543153773 | False |
8 | 9 | 34.289225 | -5.2773859 | 0.910000026226 | 0.0105264 | 0.00743139 | 0.161103 | 0.0329362 | 0.00314498 | 0.007003 | 0.0661978 | 0.0309225 | nan | nan | nan | nan | nan | nan | 0.534503 | 0.361417 | 0.0674253 | 0.0063052 | 0.0898273 | 0.0030152 | 0.0935968 | 0.0054295 | 0.076571 | 0.0044505 | 0.0840084 | 0.0058562 | 0.0708846 | 0.0174626 | nan | -99.0 | nan | 0.0909664 | 0.0384984 | 0.1579165 | 0.0813589 | 0.1437292 | 0.0469805 | 0.3950748 | 0.0510983 | 0.5219725 | 0.0647212 | 4.1427865 | 1.1386073 | -2.4398196 | 2.0715337 | 28.8443003274 | 0.766504139561 | False | 25.8822409306 | 0.22196994958 | 30.1559552801 | 2.41763402054 | False | 26.8478911089 | 0.507172108312 | nan | nan | False | nan | nan | nan | nan | False | 24.5801246322 | 0.734146528485 | 26.8279427813 | 0.101531382408 | False | 26.516479135 | 0.0364445085691 | False | 26.471847498 | 0.062982972962 | False | 26.6898392027 | 0.0631057316644 | False | 26.5891932167 | 0.075686340441 | False | 26.7736202675 | 0.26747385256 | False | nan | nan | False | 26.5027974804 | 0.45950050464 | False | 25.9039312253 | 0.559373487313 | False | 26.0061374793 | 0.354892601974 | False | 24.9083016777 | 0.140427266714 | False | 24.6058809427 | 0.134624237973 | False | 22.3567686191 | 0.298404749705 | False | nan | -0.921846491219 | False |
9 | 10 | 34.234112 | -5.277367 | 0.0 | 0.152154 | 0.0221126 | 0.139534 | 0.0443142 | 0.172488 | 0.022292 | 0.148989 | 0.0441489 | 0.280059 | 0.0334403 | 0.35172 | 0.0647246 | 0.45941 | 0.0338432 | 0.421434 | 0.052084 | 0.0417632 | 0.0064693 | 0.1073564 | 0.0030393 | 0.1501924 | 0.0045946 | 0.1494837 | 0.0065727 | 0.164952 | 0.0063477 | 0.1588035 | 0.0148701 | nan | -99.0 | nan | 0.2848519 | 0.0419836 | 0.4289925 | 0.0844432 | 0.5452679 | 0.0502516 | 0.6294125 | 0.0518056 | 0.7021672 | 0.0676026 | -0.0262255 | 1.8285483 | -0.9280451 | 2.1259727 | 25.9442915648 | 0.157790464932 | False | 26.0382998893 | 0.344815824995 | 25.8081027836 | 0.140318349546 | False | 25.967114487 | 0.321728846628 | 25.2818761656 | 0.129641769798 | False | 25.0345073388 | 0.199800527574 | 24.7444988893 | 0.0799825592061 | False | 24.8381760744 | 0.134183488965 | 27.34801558 | 0.168185225975 | False | 26.3229301505 | 0.0307375996878 | False | 25.9583801071 | 0.0332142210017 | False | 25.9635154027 | 0.0477391070265 | False | 25.8566060359 | 0.041781413423 | False | 25.8978498251 | 0.101666562377 | False | nan | nan | False | 25.2634521985 | 0.160023909007 | False | 24.8188757511 | 0.213717115068 | False | 24.5584751713 | 0.100060871852 | False | 24.4026615908 | 0.089364630555 | False | 24.2838986535 | 0.104531499557 | False | nan | -75.7019348138 | False | nan | -2.48721266964 | False |