{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pylab as plt\n",
"import pymoc\n",
"import xidplus\n",
"import numpy as np\n",
"%matplotlib inline\n",
"from astropy.table import Table, join"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import seaborn as sns"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"This notebook uses all the raw data from the CIGALE predictions and photoz catalogue, maps, PSF and relevant MOCs to create XID+ prior object and relevant tiling scheme"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read in MOCs\n",
"The selection functions required are the main MOC associated with the masterlist. "
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"Sel_func=pymoc.MOC()\n",
"Sel_func.read('../../dmu4/dmu4_sm_GAMA-12/data/holes_GAMA-12_ukidss_k_O16_20180419_MOC.fits')\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read in CIGALE predictions catalogue"
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {},
"outputs": [],
"source": [
"cigale=Table.read('../../dmu28/dmu28_GAMA-12/data/GAMA-12_Ldust_prediction_results.fits')\n"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"cigale['id'].name = 'help_id'\n"
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<Table length=1427798>\n",
"
\n",
"help_id | bayes.dust.luminosity | bayes.dust.luminosity_err | best.omegacam_u | best.omegacam_g | best.suprime_g | best.decam_g | best.gpc1_g | best.suprime_r | best.gpc1_r | best.omegacam_r | best.decam_r | best.gpc1_i | best.omegacam_i | best.suprime_i | best.gpc1_z | best.vista_z | best.suprime_z | best.decam_z | best.gpc1_y | best.suprime_y | best.vista_y | best.ukidss_y | best.ukidss_j | best.vista_j | best.ukidss_h | best.vista_h | best.vista_ks | best.ukidss_k |
\n",
" | | | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy |
\n",
"str28 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 |
\n",
"HELP_J112916.236+004455.105 | 9.65287793768e+37 | 1.17666784092e+38 | 0.000980295023014 | 0.00152945692592 | 0.00155522672771 | 0.00156031374351 | 0.0015811572678 | 0.00319442648463 | 0.00323499658544 | 0.00344452392723 | 0.00365353497765 | 0.00506550119885 | 0.00507429427253 | 0.00516587092685 | 0.00571054914042 | 0.005799151538 | 0.00589362525503 | 0.00606803848146 | 0.00634927742142 | 0.00641461877416 | 0.00659292795451 | 0.00665987676509 | 0.00809632604272 | 0.00811067438847 | 0.0106524893003 | 0.0106792419785 | 0.0122238062342 | 0.0124163888182 |
\n",
"HELP_J112916.735+004525.955 | 4.99604151924e+38 | 6.01405625316e+38 | 0.00228961737982 | 0.00416181870533 | 0.00425796740958 | 0.00427614671171 | 0.00434788511322 | 0.00959801620012 | 0.00965743796182 | 0.0103856772571 | 0.0110859039015 | 0.0168555632412 | 0.0170860313911 | 0.0175084982515 | 0.0223159250776 | 0.0228707747602 | 0.0235845969178 | 0.0248448303069 | 0.027143746692 | 0.027827712213 | 0.0299828410087 | 0.0306283344946 | 0.0437204990637 | 0.0439311275299 | 0.0693150570334 | 0.0696774039528 | 0.0906166212251 | 0.0936494380324 |
\n",
"HELP_J112916.868+004538.834 | 6.74395178932e+35 | 2.11732503197e+35 | 0.00797875041146 | 0.0298080393801 | 0.0305873658148 | 0.0307507600584 | 0.0316232736597 | 0.0574327371112 | 0.0577872312662 | 0.0598883825059 | 0.0617535017724 | 0.0808511378306 | 0.081672435631 | 0.0833186989953 | 0.101873791141 | 0.104195668445 | 0.106982286305 | 0.114021556098 | 0.125815868503 | 0.12929421768 | 0.137854161055 | 0.14010272913 | 0.163531125537 | 0.163858604646 | 0.207051791153 | 0.208521374093 | 0.195515497984 | 0.19135190687 |
\n",
"HELP_J112916.993+004528.665 | 1.06941218163e+37 | 1.18786921122e+37 | 0.000958880860804 | 0.00204094231687 | 0.00212978078874 | 0.00215053957163 | 0.00221212661902 | 0.00438028344746 | 0.00439633094758 | 0.00453091385133 | 0.00465871777647 | 0.00602217800415 | 0.00607213083905 | 0.0061811261165 | 0.00718156074182 | 0.00729981335821 | 0.00744050683883 | 0.00781017044537 | 0.00848844401419 | 0.00862261078026 | 0.00902709450123 | 0.00914284994064 | 0.012212649293 | 0.0122324762736 | 0.0145243616455 | 0.0145698906336 | 0.0179420683456 | 0.0178088588752 |
\n",
"HELP_J112917.687+004454.217 | 8.27142268505e+37 | 5.40913585177e+37 | 0.00137585337232 | 0.00538198184203 | 0.0058148696356 | 0.00590330344897 | 0.00614237388744 | 0.0182970759978 | 0.0183700985544 | 0.0194974307305 | 0.0205248944548 | 0.0319632835879 | 0.0324309746237 | 0.0334546451974 | 0.0437975562519 | 0.0447575259366 | 0.0461367954266 | 0.0498327120644 | 0.0556160601284 | 0.0580288181608 | 0.0628588008841 | 0.0640299734127 | 0.0980593652049 | 0.0984818456491 | 0.137654757191 | 0.138522057534 | 0.196027629972 | 0.198087233649 |
\n",
"HELP_J112917.704+004533.215 | 2.62197498446e+36 | 1.3701873132e+36 | 0.016534572991 | 0.0840618775116 | 0.0873091714541 | 0.0879454585475 | 0.0909989571154 | 0.195372872856 | 0.196313152927 | 0.205333356537 | 0.214011374115 | 0.30729033966 | 0.313252209594 | 0.321932819252 | 0.423012204598 | 0.435123206332 | 0.446370918813 | 0.483403907101 | 0.546884818768 | 0.566406555256 | 0.614831497502 | 0.626988793227 | 0.783608565337 | 0.785897174058 | 1.1039665533 | 1.1128944361 | 1.08867447396 | 1.06836625457 |
\n",
"HELP_J112918.031+004449.789 | 2.47229097952e+37 | 1.38352426361e+37 | 0.012063642223 | 0.0116270626371 | 0.0117979015648 | 0.0118222894812 | 0.0118366856847 | 0.0142852318447 | 0.0142829495391 | 0.014203194741 | 0.0141328553595 | 0.0132481827668 | 0.0133045894053 | 0.0132304404813 | 0.0127280861781 | 0.0126761603511 | 0.0125914341498 | 0.0126227125551 | 0.0125912927721 | 0.0125654024821 | 0.0126517230037 | 0.0126882500024 | 0.0134582586489 | 0.0134731307007 | 0.0135681982561 | 0.0135586563671 | 0.0141270715672 | 0.0143151654038 |
\n",
"HELP_J112918.084+004525.273 | 2.53947597807e+38 | 2.73391542285e+38 | 0.00174774603812 | 0.00301834946916 | 0.00308757079135 | 0.0031019382768 | 0.0031546914562 | 0.00653613466426 | 0.00658659521449 | 0.00703650922845 | 0.00748522603927 | 0.0119562680755 | 0.0120329268754 | 0.0123283305898 | 0.0149195883756 | 0.0152551995612 | 0.0157617182251 | 0.0165621229933 | 0.0179115010131 | 0.0182560765003 | 0.0191542214764 | 0.0194137045489 | 0.0255225608339 | 0.0256080599769 | 0.0369537359343 | 0.0371265850063 | 0.0449156944897 | 0.0457657667788 |
\n",
"HELP_J112918.563+004439.998 | 8.53276321612e+37 | 8.3862544751e+37 | 0.00522196151719 | 0.00804356017641 | 0.00825797029335 | 0.00829458625391 | 0.0084252846109 | 0.0128446362232 | 0.0128626795311 | 0.0130471347724 | 0.0132327659064 | 0.0147622416521 | 0.0148708568175 | 0.0149796962934 | 0.0161558633422 | 0.0162565301368 | 0.0163955971252 | 0.0167788897438 | 0.0174330543329 | 0.0176522400693 | 0.0184232429783 | 0.0186294326799 | 0.0228008123269 | 0.0228548116973 | 0.0371404379802 | 0.037448806764 | 0.0456766979859 | 0.0470656329732 |
\n",
"... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
\n",
"HELP_J122825.517-013639.700 | 2.41696074215e+41 | 2.16798644453e+41 | 0.00584736446799 | 0.025446839426 | 0.0269831207279 | 0.0272854328242 | 0.0283459368974 | 0.0850294114319 | 0.0843397434377 | 0.0926537479955 | 0.101908844007 | 0.225221925813 | 0.230352977847 | 0.242045554482 | 0.357928639928 | 0.368759134527 | 0.381708053067 | 0.417048662004 | 0.47759138436 | 0.501988640341 | 0.563892818398 | 0.580464808623 | 0.926010173912 | 0.933478251972 | 1.80074297894 | 1.82394091446 | 2.97207465549 | 3.11702279515 |
\n",
"HELP_J122825.688-013656.756 | 1.50956081754e+38 | 1.97889595044e+38 | 0.000779256277935 | 0.0016412152759 | 0.00169421321418 | 0.0017037741803 | 0.00174393813242 | 0.00518403739423 | 0.00522190886792 | 0.00570746347014 | 0.00615347395043 | 0.00976218890319 | 0.00991515631907 | 0.0101475602301 | 0.0131839973841 | 0.0135200605425 | 0.0139506747469 | 0.0145696204963 | 0.0156940139329 | 0.0160600078884 | 0.0172507443855 | 0.0174911329778 | 0.0236920817891 | 0.0238421357289 | 0.0351594379785 | 0.0352995234062 | 0.0430604888042 | 0.0443455638067 |
\n",
"HELP_J122825.798-013712.032 | 2.14805714074e+36 | 1.47680621342e+36 | 0.00409576465093 | 0.00845498801097 | 0.00869953108459 | 0.00875489990811 | 0.00897530312772 | 0.0119930133259 | 0.0119546556664 | 0.0121248049756 | 0.0123041597412 | 0.0136530209198 | 0.0137328097856 | 0.013797267028 | 0.0150262671606 | 0.0152080813341 | 0.0154178298916 | 0.015690385073 | 0.0161516369506 | 0.0163623503855 | 0.0171793608417 | 0.0173776624253 | 0.0192548141121 | 0.0192945000987 | 0.0211320408895 | 0.0211853374912 | 0.0220530326294 | 0.0215201768733 |
\n",
"HELP_J122825.799-013701.692 | 4.28322184014e+37 | 4.9210598117e+37 | 0.00273673184984 | 0.00369623563625 | 0.00373527427781 | 0.00374430934721 | 0.0037699887006 | 0.0073081729775 | 0.00740499092791 | 0.0078043236369 | 0.00807701526021 | 0.00907830633842 | 0.00915677128173 | 0.0091669397766 | 0.00981306403673 | 0.00987883719133 | 0.00996093144176 | 0.0100834181341 | 0.0102303620919 | 0.0103267828018 | 0.0105917509741 | 0.0106230068723 | 0.0121449195962 | 0.012204707927 | 0.0145782589472 | 0.0145867872266 | 0.0158722440665 | 0.0161073868445 |
\n",
"HELP_J122825.877-013755.825 | 4.43386678634e+38 | 5.09131852008e+38 | 0.000132283593125 | 0.000441118274717 | 0.000459182922406 | 0.000462519193721 | 0.000476413400313 | 0.00105571031941 | 0.00106010027923 | 0.00111447094317 | 0.00116748768923 | 0.00213236917757 | 0.00217436469534 | 0.00228141005749 | 0.00332512058435 | 0.00341618227865 | 0.00356574548659 | 0.00375611084075 | 0.00410227882471 | 0.00420900122049 | 0.00456678092155 | 0.00466049134526 | 0.0065452172812 | 0.00657780105983 | 0.0105144653162 | 0.0106233456705 | 0.0159286774673 | 0.016404330287 |
\n",
"HELP_J122826.138-013818.211 | 2.50458512808e+36 | 8.92150969757e+35 | 0.019536877316 | 0.0313734708931 | 0.0318879108337 | 0.0320085446911 | 0.0325418790243 | 0.0361820125396 | 0.0360251680581 | 0.036239196461 | 0.0363591466653 | 0.0372503869887 | 0.037510170013 | 0.0374997520303 | 0.0393017039618 | 0.0395854239418 | 0.0398142152834 | 0.0402904819483 | 0.0409471206129 | 0.0414053373402 | 0.043203387577 | 0.0436166760491 | 0.0459442420835 | 0.0460183793708 | 0.0483148508369 | 0.0484033109054 | 0.0479365115214 | 0.0466315409021 |
\n",
"HELP_J122826.531-013729.496 | 4.95938707418e+38 | 3.70590375119e+38 | 0.000700024693841 | 0.00155607983451 | 0.00162342258177 | 0.00163690540196 | 0.00167950363534 | 0.00386859751955 | 0.00380038540541 | 0.00418479610097 | 0.00463704791405 | 0.0107797907471 | 0.0109466937146 | 0.0114809534548 | 0.0154796026675 | 0.015737475243 | 0.0159947263059 | 0.0171309653971 | 0.0189352873112 | 0.0197415940529 | 0.0216373799162 | 0.0221286668903 | 0.0307841418842 | 0.0309767633824 | 0.0494875999151 | 0.0499538010009 | 0.0679912747101 | 0.0701424743446 |
\n",
"HELP_J122827.358-013618.662 | 1.20499668671e+39 | 1.6571915369e+39 | 0.000147082824979 | 0.000428127839656 | 0.000451150022557 | 0.000455727664497 | 0.000470779894341 | 0.00128264091654 | 0.00125683445288 | 0.00139770550129 | 0.00156568590424 | 0.00412455696042 | 0.004218154283 | 0.00446607270148 | 0.00660992769147 | 0.00677106864889 | 0.00694866607941 | 0.00752220133806 | 0.00847610695007 | 0.00890457285108 | 0.010007536247 | 0.0102860602568 | 0.015676571298 | 0.0157941921292 | 0.0281231825466 | 0.0284438210156 | 0.0426205295113 | 0.0443098305765 |
\n",
"HELP_J122829.089-013711.804 | 2.65636176092e+39 | 1.4112316383e+39 | 0.00716952899517 | 0.0218542495742 | 0.0228917105666 | 0.0230969601511 | 0.0238636222247 | 0.0948014718452 | 0.0957259882033 | 0.104986538139 | 0.113585357926 | 0.192024942628 | 0.19630936081 | 0.202838335013 | 0.287043773003 | 0.295300427953 | 0.306009196585 | 0.326607777237 | 0.36135082405 | 0.375843291657 | 0.409367279679 | 0.417742870715 | 0.640979866031 | 0.645353079634 | 1.04780865522 | 1.05413321538 | 1.4415402699 | 1.49841442715 |
\n",
"HELP_J122829.372-013659.895 | 6.84338249493e+37 | 8.08634710532e+37 | 0.00129959778414 | 0.00163818066884 | 0.001662871293 | 0.00166745277485 | 0.00168427989875 | 0.00320539268524 | 0.00322347666598 | 0.00345029898004 | 0.00367862099597 | 0.00537169699745 | 0.00539896452352 | 0.00551351465593 | 0.00647767980332 | 0.0066026518953 | 0.006744097808 | 0.00696991499573 | 0.00736377341283 | 0.00746329440193 | 0.00776632335094 | 0.00786772542183 | 0.00973783930807 | 0.00975055343527 | 0.0130954367986 | 0.0131267966265 | 0.0146719576511 | 0.0149235576397 |
\n",
"
"
],
"text/plain": [
"\n",
" help_id bayes.dust.luminosity ... best.ukidss_k \n",
" ... mJy \n",
" str28 float64 ... float64 \n",
"---------------------------- --------------------- ... ---------------\n",
"HELP_J112916.236+004455.105 9.65287793768e+37 ... 0.0124163888182\n",
"HELP_J112916.735+004525.955 4.99604151924e+38 ... 0.0936494380324\n",
"HELP_J112916.868+004538.834 6.74395178932e+35 ... 0.19135190687\n",
"HELP_J112916.993+004528.665 1.06941218163e+37 ... 0.0178088588752\n",
"HELP_J112917.687+004454.217 8.27142268505e+37 ... 0.198087233649\n",
"HELP_J112917.704+004533.215 2.62197498446e+36 ... 1.06836625457\n",
"HELP_J112918.031+004449.789 2.47229097952e+37 ... 0.0143151654038\n",
"HELP_J112918.084+004525.273 2.53947597807e+38 ... 0.0457657667788\n",
"HELP_J112918.563+004439.998 8.53276321612e+37 ... 0.0470656329732\n",
" ... ... ... ...\n",
"HELP_J122825.517-013639.700 2.41696074215e+41 ... 3.11702279515\n",
"HELP_J122825.688-013656.756 1.50956081754e+38 ... 0.0443455638067\n",
"HELP_J122825.798-013712.032 2.14805714074e+36 ... 0.0215201768733\n",
"HELP_J122825.799-013701.692 4.28322184014e+37 ... 0.0161073868445\n",
"HELP_J122825.877-013755.825 4.43386678634e+38 ... 0.016404330287\n",
"HELP_J122826.138-013818.211 2.50458512808e+36 ... 0.0466315409021\n",
"HELP_J122826.531-013729.496 4.95938707418e+38 ... 0.0701424743446\n",
"HELP_J122827.358-013618.662 1.20499668671e+39 ... 0.0443098305765\n",
"HELP_J122829.089-013711.804 2.65636176092e+39 ... 1.49841442715\n",
"HELP_J122829.372-013659.895 6.84338249493e+37 ... 0.0149235576397"
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cigale"
]
},
{
"cell_type": "code",
"execution_count": 48,
"metadata": {},
"outputs": [],
"source": [
"for i in range(0,len(cigale['help_id'])):\n",
" cigale['help_id'][i]=cigale['help_id'][i].strip()\n",
" "
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read in photoz"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": 49,
"metadata": {},
"outputs": [],
"source": [
"photoz=Table.read('../../dmu24/dmu24_GAMA-12/data/master_catalogue_gama-12_20171210_photoz_20180410_r_optimised.fits')"
]
},
{
"cell_type": "code",
"execution_count": 50,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<Table length=8591676>\n",
"\n",
"help_id | RA | DEC | id | z1_median | z1_min | z1_max | z1_area | z2_median | z2_min | z2_max | z2_area | za_hb | chi_r_eazy | chi_r_atlas | chi_r_cosmos | chi_r_stellar | stellar_type |
\n",
"str28 | float64 | float64 | int64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | str6 |
\n",
"HELP_J115809.625-010119.203 | 179.540104115 | -1.02200083733 | 415493 | 0.6959 | 0.2271 | 1.1167 | 0.776 | 1.7302 | 1.6579 | 1.8051 | 0.023 | 0.716334851089 | 0.002686655 | 0.0150886325 | 0.0201354525 | 0.3918725 | m3iii |
\n",
"HELP_J115850.554-004148.083 | 179.710640849 | -0.6966898527 | 415494 | 0.8684 | 0.4865 | 1.214 | 0.752 | 1.7465 | 1.6739 | 1.822 | 0.043 | 0.872100152911 | 0.04407825 | 0.02533725 | 0.043383625 | 3.34674 | m4iii |
\n",
"HELP_J114948.465+001147.728 | 177.451936426 | 0.196591224527 | 415495 | 0.887 | 0.4999 | 1.2677 | 0.724 | 1.6913 | 1.595 | 1.7884 | 0.07 | 0.87771645337 | 0.35133575 | 0.08987975 | 0.029299375 | 4.303075 | m4v |
\n",
"HELP_J120125.808-000108.647 | 180.357532881 | -0.0190684827784 | 415496 | 0.9072 | 0.583 | 1.2542 | 0.75 | 1.6694 | 1.6106 | 1.7305 | 0.043 | 0.894666650493 | 0.0040718675 | 0.0216934375 | 0.028596175 | 1.58375425 | m4iii |
\n",
"HELP_J120150.572+005703.469 | 180.460717674 | 0.950963732611 | 415497 | 1.6554 | 1.4222 | 1.822 | 0.799 | -99.0 | -99.0 | -99.0 | -99.0 | 1.65789758247 | 1.186299 | 4.031635 | 2.62545 | 4.5122975 | m7iii |
\n",
"HELP_J120422.567-005913.736 | 181.09402893 | -0.987148769669 | 415498 | 0.8732 | 0.5548 | 1.2474 | 0.702 | 1.5987 | 1.4735 | 1.7224 | 0.091 | 0.888999651538 | 0.00577969 | 0.25491375 | 0.28173975 | 0.54081825 | m4iii |
\n",
"HELP_J115939.276+003916.795 | 179.913648297 | 0.654665172133 | 415499 | 0.7295 | 0.1838 | 1.3019 | 0.615 | 1.9048 | 1.595 | 2.2389 | 0.183 | 0.716334851089 | 0.00098887325 | 0.0336144 | 0.04352285 | 1.25826925 | rk3iii |
\n",
"HELP_J115154.051+010414.748 | 177.975212106 | 1.0707633185 | 415500 | 0.9787 | 0.6508 | 1.3088 | 0.655 | 1.6778 | 1.5335 | 1.822 | 0.137 | 0.993648875848 | 0.199398525 | 0.020380665 | 0.048394 | 4.22107 | m5iii |
\n",
"HELP_J120457.625+010258.007 | 181.240105818 | 1.04944633237 | 415501 | 0.5947 | 0.1284 | 1.2542 | 0.709 | 1.8528 | 1.6819 | 2.0323 | 0.087 | 0.395846438326 | 0.006772955 | 0.0390784 | 0.2812145 | 0.90032575 | rk0iii |
\n",
"HELP_J120309.306-002609.591 | 180.788776986 | -0.435997558437 | 415502 | 1.0283 | 0.7112 | 1.4735 | 0.659 | 1.7953 | 1.6262 | 1.9694 | 0.134 | 0.844269625561 | 0.0212020025 | 0.0434579 | 0.72502975 | 7.4572625 | m4iii |
\n",
"... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
\n",
"HELP_J120423.125-021109.933 | 181.096354437 | -2.18609262636 | 11298533 | 0.6941 | 0.2053 | 1.2273 | 0.798 | -99.0 | -99.0 | -99.0 | -99.0 | 0.621378066675 | -99.0 | -99.0 | -99.0 | -99.0 | |
\n",
"HELP_J113919.112-000250.618 | 174.829631382 | -0.0473937819863 | 11298534 | 1.0065 | 0.4513 | 1.6499 | 0.797 | -99.0 | -99.0 | -99.0 | -99.0 | 0.795213132021 | 0.000552244 | 0.0026483475 | 0.0208553275 | 9.59029 | m4iii |
\n",
"HELP_J122117.451+012256.663 | 185.322711149 | 1.38240630631 | 11298535 | 0.0591 | 0.001 | 0.1217 | 0.785 | -99.0 | -99.0 | -99.0 | -99.0 | 0.0596240452813 | -99.0 | -99.0 | -99.0 | -99.0 | |
\n",
"HELP_J115724.509+002904.083 | 179.352122416 | 0.484467577981 | 11298536 | 1.1821 | 0.9581 | 1.4005 | 0.789 | -99.0 | -99.0 | -99.0 | -99.0 | 1.16807747171 | 7.79985428571 | 8.00293 | 6.00342857143 | 13.0244171429 | m7iii |
\n",
"HELP_J120943.941-010034.499 | 182.433086068 | -1.00958303725 | 11298537 | 0.8944 | 0.2569 | 1.595 | 0.799 | -99.0 | -99.0 | -99.0 | -99.0 | 0.784490130825 | -99.0 | -99.0 | -99.0 | -99.0 | |
\n",
"HELP_J115115.399-024125.001 | 177.814162851 | -2.6902779989 | 11298538 | 0.4614 | 0.2345 | 0.6908 | 0.795 | -99.0 | -99.0 | -99.0 | -99.0 | 0.412672122158 | 0.0533738 | 0.19438265 | 0.34900625 | 1.772971 | k3v |
\n",
"HELP_J120158.333-022805.652 | 180.493052433 | -2.46823661983 | 11298540 | 0.6168 | 0.3186 | 0.889 | 0.791 | 0.2607 | 0.2569 | 0.2645 | 0.001 | 0.660702188287 | 0.174539625 | 0.471560375 | 0.435440375 | 8.78018125 | k3iii |
\n",
"HELP_J120724.943+005318.682 | 181.853930565 | 0.888522915897 | 11298541 | 1.6154 | 1.4005 | 1.839 | 0.675 | 2.1784 | 2.0689 | 2.2878 | 0.082 | 1.63411931628 | 11.33364 | 12.47032 | 12.38136 | 30.7325 | f0iii |
\n",
"HELP_J115811.275+002726.998 | 179.546980197 | 0.457499520518 | 11298542 | 0.1416 | 0.0756 | 0.2017 | 0.509 | 0.048 | 0.0161 | 0.0724 | 0.279 | 0.0564546812376 | 0.573593454545 | 0.231829636364 | 0.157118272727 | 0.609553363636 | f8v |
\n",
"HELP_J114712.920-012059.469 | 176.803832175 | -1.34985256706 | 11298544 | 1.3586 | 0.9061 | 1.822 | 0.795 | -99.0 | -99.0 | -99.0 | -99.0 | 1.32271677357 | 0.0260693428571 | 0.179097285714 | 0.398644571429 | 16.4203142857 | m5iii |
\n",
"
"
],
"text/plain": [
"\n",
" help_id RA ... chi_r_stellar stellar_type\n",
" str28 float64 ... float64 str6 \n",
"--------------------------- ------------- ... -------------- ------------\n",
"HELP_J115809.625-010119.203 179.540104115 ... 0.3918725 m3iii\n",
"HELP_J115850.554-004148.083 179.710640849 ... 3.34674 m4iii\n",
"HELP_J114948.465+001147.728 177.451936426 ... 4.303075 m4v\n",
"HELP_J120125.808-000108.647 180.357532881 ... 1.58375425 m4iii\n",
"HELP_J120150.572+005703.469 180.460717674 ... 4.5122975 m7iii\n",
"HELP_J120422.567-005913.736 181.09402893 ... 0.54081825 m4iii\n",
"HELP_J115939.276+003916.795 179.913648297 ... 1.25826925 rk3iii\n",
"HELP_J115154.051+010414.748 177.975212106 ... 4.22107 m5iii\n",
"HELP_J120457.625+010258.007 181.240105818 ... 0.90032575 rk0iii\n",
"HELP_J120309.306-002609.591 180.788776986 ... 7.4572625 m4iii\n",
" ... ... ... ... ...\n",
"HELP_J120423.125-021109.933 181.096354437 ... -99.0 \n",
"HELP_J113919.112-000250.618 174.829631382 ... 9.59029 m4iii\n",
"HELP_J122117.451+012256.663 185.322711149 ... -99.0 \n",
"HELP_J115724.509+002904.083 179.352122416 ... 13.0244171429 m7iii\n",
"HELP_J120943.941-010034.499 182.433086068 ... -99.0 \n",
"HELP_J115115.399-024125.001 177.814162851 ... 1.772971 k3v\n",
"HELP_J120158.333-022805.652 180.493052433 ... 8.78018125 k3iii\n",
"HELP_J120724.943+005318.682 181.853930565 ... 30.7325 f0iii\n",
"HELP_J115811.275+002726.998 179.546980197 ... 0.609553363636 f8v\n",
"HELP_J114712.920-012059.469 176.803832175 ... 16.4203142857 m5iii"
]
},
"execution_count": 50,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"photoz"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Join CIGALE and photoz tables"
]
},
{
"cell_type": "code",
"execution_count": 51,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"prior=join(cigale,photoz,keys='help_id')"
]
},
{
"cell_type": "code",
"execution_count": 52,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<Table length=1427798>\n",
"\n",
"help_id | bayes.dust.luminosity | bayes.dust.luminosity_err | best.omegacam_u | best.omegacam_g | best.suprime_g | best.decam_g | best.gpc1_g | best.suprime_r | best.gpc1_r | best.omegacam_r | best.decam_r | best.gpc1_i | best.omegacam_i | best.suprime_i | best.gpc1_z | best.vista_z | best.suprime_z | best.decam_z | best.gpc1_y | best.suprime_y | best.vista_y | best.ukidss_y | best.ukidss_j | best.vista_j | best.ukidss_h | best.vista_h | best.vista_ks | best.ukidss_k | RA | DEC | id | z1_median | z1_min | z1_max | z1_area | z2_median | z2_min | z2_max | z2_area | za_hb | chi_r_eazy | chi_r_atlas | chi_r_cosmos | chi_r_stellar | stellar_type |
\n",
" | | | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | mJy | | | | | | | | | | | | | | | | | |
\n",
"str28 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | int64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | float64 | str6 |
\n",
"HELP_J112916.236+004455.105 | 9.65287793768e+37 | 1.17666784092e+38 | 0.000980295023014 | 0.00152945692592 | 0.00155522672771 | 0.00156031374351 | 0.0015811572678 | 0.00319442648463 | 0.00323499658544 | 0.00344452392723 | 0.00365353497765 | 0.00506550119885 | 0.00507429427253 | 0.00516587092685 | 0.00571054914042 | 0.005799151538 | 0.00589362525503 | 0.00606803848146 | 0.00634927742142 | 0.00641461877416 | 0.00659292795451 | 0.00665987676509 | 0.00809632604272 | 0.00811067438847 | 0.0106524893003 | 0.0106792419785 | 0.0122238062342 | 0.0124163888182 | 172.317651842 | 0.748640313787 | 9401913 | 0.5866 | 0.1732 | 1.0359 | 0.8 | -99.0 | -99.0 | -99.0 | -99.0 | 0.527093516722 | -99.0 | -99.0 | -99.0 | -99.0 | |
\n",
"HELP_J112916.735+004525.955 | 4.99604151924e+38 | 6.01405625316e+38 | 0.00228961737982 | 0.00416181870533 | 0.00425796740958 | 0.00427614671171 | 0.00434788511322 | 0.00959801620012 | 0.00965743796182 | 0.0103856772571 | 0.0110859039015 | 0.0168555632412 | 0.0170860313911 | 0.0175084982515 | 0.0223159250776 | 0.0228707747602 | 0.0235845969178 | 0.0248448303069 | 0.027143746692 | 0.027827712213 | 0.0299828410087 | 0.0306283344946 | 0.0437204990637 | 0.0439311275299 | 0.0693150570334 | 0.0696774039528 | 0.0906166212251 | 0.0936494380324 | 172.319729599 | 0.757209664906 | 10715740 | 0.5535 | 0.2162 | 0.9175 | 0.795 | -99.0 | -99.0 | -99.0 | -99.0 | 0.442606570742 | 0.0850949 | 0.0989438666667 | 0.0923512666667 | 9.717435 | m3ii |
\n",
"HELP_J112916.868+004538.834 | 6.74395178932e+35 | 2.11732503197e+35 | 0.00797875041146 | 0.0298080393801 | 0.0305873658148 | 0.0307507600584 | 0.0316232736597 | 0.0574327371112 | 0.0577872312662 | 0.0598883825059 | 0.0617535017724 | 0.0808511378306 | 0.081672435631 | 0.0833186989953 | 0.101873791141 | 0.104195668445 | 0.106982286305 | 0.114021556098 | 0.125815868503 | 0.12929421768 | 0.137854161055 | 0.14010272913 | 0.163531125537 | 0.163858604646 | 0.207051791153 | 0.208521374093 | 0.195515497984 | 0.19135190687 | 172.320283365 | 0.760787329227 | 9485122 | 0.0486 | 0.001 | 0.0984 | 0.788 | -99.0 | -99.0 | -99.0 | -99.0 | 0.0501443637558 | 0.215585285714 | 0.608331428571 | 2.41235428571 | 1.37624242857 | rk1iii |
\n",
"HELP_J112916.993+004528.665 | 1.06941218163e+37 | 1.18786921122e+37 | 0.000958880860804 | 0.00204094231687 | 0.00212978078874 | 0.00215053957163 | 0.00221212661902 | 0.00438028344746 | 0.00439633094758 | 0.00453091385133 | 0.00465871777647 | 0.00602217800415 | 0.00607213083905 | 0.0061811261165 | 0.00718156074182 | 0.00729981335821 | 0.00744050683883 | 0.00781017044537 | 0.00848844401419 | 0.00862261078026 | 0.00902709450123 | 0.00914284994064 | 0.012212649293 | 0.0122324762736 | 0.0145243616455 | 0.0145698906336 | 0.0179420683456 | 0.0178088588752 | 172.320805757 | 0.757962388233 | 10222287 | 0.2516 | 0.0628 | 0.482 | 0.805 | -99.0 | -99.0 | -99.0 | -99.0 | 0.198091697744 | 0.0029134775 | 0.01379993 | 0.13480295 | 0.14214465 | m3v |
\n",
"HELP_J112917.687+004454.217 | 8.27142268505e+37 | 5.40913585177e+37 | 0.00137585337232 | 0.00538198184203 | 0.0058148696356 | 0.00590330344897 | 0.00614237388744 | 0.0182970759978 | 0.0183700985544 | 0.0194974307305 | 0.0205248944548 | 0.0319632835879 | 0.0324309746237 | 0.0334546451974 | 0.0437975562519 | 0.0447575259366 | 0.0461367954266 | 0.0498327120644 | 0.0556160601284 | 0.0580288181608 | 0.0628588008841 | 0.0640299734127 | 0.0980593652049 | 0.0984818456491 | 0.137654757191 | 0.138522057534 | 0.196027629972 | 0.198087233649 | 172.323696237 | 0.748393544076 | 10385325 | 0.2803 | 0.1318 | 0.4469 | 0.757 | 0.4747 | 0.46 | 0.4909 | 0.029 | 0.291259067401 | 0.547619142857 | 0.566588571429 | 0.602499571429 | 12.1982628571 | m3ii |
\n",
"HELP_J112917.704+004533.215 | 2.62197498446e+36 | 1.3701873132e+36 | 0.016534572991 | 0.0840618775116 | 0.0873091714541 | 0.0879454585475 | 0.0909989571154 | 0.195372872856 | 0.196313152927 | 0.205333356537 | 0.214011374115 | 0.30729033966 | 0.313252209594 | 0.321932819252 | 0.423012204598 | 0.435123206332 | 0.446370918813 | 0.483403907101 | 0.546884818768 | 0.566406555256 | 0.614831497502 | 0.626988793227 | 0.783608565337 | 0.785897174058 | 1.1039665533 | 1.1128944361 | 1.08867447396 | 1.06836625457 | 172.323767131 | 0.759226479068 | 9998042 | 0.027 | 0.001 | 0.0565 | 0.757 | -99.0 | -99.0 | -99.0 | -99.0 | 0.0345329813244 | 1.06796071429 | 0.793394857143 | 1.14390671429 | 0.332926142857 | k4i |
\n",
"HELP_J112918.031+004449.789 | 2.47229097952e+37 | 1.38352426361e+37 | 0.012063642223 | 0.0116270626371 | 0.0117979015648 | 0.0118222894812 | 0.0118366856847 | 0.0142852318447 | 0.0142829495391 | 0.014203194741 | 0.0141328553595 | 0.0132481827668 | 0.0133045894053 | 0.0132304404813 | 0.0127280861781 | 0.0126761603511 | 0.0125914341498 | 0.0126227125551 | 0.0125912927721 | 0.0125654024821 | 0.0126517230037 | 0.0126882500024 | 0.0134582586489 | 0.0134731307007 | 0.0135681982561 | 0.0135586563671 | 0.0141270715672 | 0.0143151654038 | 172.325127324 | 0.747163665978 | 9960668 | 0.383 | 0.1116 | 0.6757 | 0.797 | -99.0 | -99.0 | -99.0 | -99.0 | 0.350601972086 | -99.0 | -99.0 | -99.0 | -99.0 | |
\n",
"HELP_J112918.084+004525.273 | 2.53947597807e+38 | 2.73391542285e+38 | 0.00174774603812 | 0.00301834946916 | 0.00308757079135 | 0.0031019382768 | 0.0031546914562 | 0.00653613466426 | 0.00658659521449 | 0.00703650922845 | 0.00748522603927 | 0.0119562680755 | 0.0120329268754 | 0.0123283305898 | 0.0149195883756 | 0.0152551995612 | 0.0157617182251 | 0.0165621229933 | 0.0179115010131 | 0.0182560765003 | 0.0191542214764 | 0.0194137045489 | 0.0255225608339 | 0.0256080599769 | 0.0369537359343 | 0.0371265850063 | 0.0449156944897 | 0.0457657667788 | 172.325348384 | 0.757020306313 | 10308562 | 0.6138 | 0.2162 | 1.0604 | 0.799 | -99.0 | -99.0 | -99.0 | -99.0 | 0.47317532873 | 0.1921243 | 0.2061254 | 0.2078884 | 8.228578 | m3ii |
\n",
"HELP_J112918.563+004439.998 | 8.53276321612e+37 | 8.3862544751e+37 | 0.00522196151719 | 0.00804356017641 | 0.00825797029335 | 0.00829458625391 | 0.0084252846109 | 0.0128446362232 | 0.0128626795311 | 0.0130471347724 | 0.0132327659064 | 0.0147622416521 | 0.0148708568175 | 0.0149796962934 | 0.0161558633422 | 0.0162565301368 | 0.0163955971252 | 0.0167788897438 | 0.0174330543329 | 0.0176522400693 | 0.0184232429783 | 0.0186294326799 | 0.0228008123269 | 0.0228548116973 | 0.0371404379802 | 0.037448806764 | 0.0456766979859 | 0.0470656329732 | 172.327347312 | 0.744443831151 | 9879505 | 0.3719 | 0.1083 | 0.6557 | 0.796 | -99.0 | -99.0 | -99.0 | -99.0 | 0.338519123815 | -99.0 | -99.0 | -99.0 | -99.0 | |
\n",
"... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
\n",
"HELP_J122825.517-013639.700 | 2.41696074215e+41 | 2.16798644453e+41 | 0.00584736446799 | 0.025446839426 | 0.0269831207279 | 0.0272854328242 | 0.0283459368974 | 0.0850294114319 | 0.0843397434377 | 0.0926537479955 | 0.101908844007 | 0.225221925813 | 0.230352977847 | 0.242045554482 | 0.357928639928 | 0.368759134527 | 0.381708053067 | 0.417048662004 | 0.47759138436 | 0.501988640341 | 0.563892818398 | 0.580464808623 | 0.926010173912 | 0.933478251972 | 1.80074297894 | 1.82394091446 | 2.97207465549 | 3.11702279515 | 187.106322308 | -1.61102767494 | 9563672 | 0.7806 | 0.001 | 2.5969 | 0.8 | -99.0 | -99.0 | -99.0 | -99.0 | 0.587734064661 | 23.7258090909 | 20.9273818182 | 16.2084363636 | 6.80967090909 | m4v |
\n",
"HELP_J122825.688-013656.756 | 1.50956081754e+38 | 1.97889595044e+38 | 0.000779256277935 | 0.0016412152759 | 0.00169421321418 | 0.0017037741803 | 0.00174393813242 | 0.00518403739423 | 0.00522190886792 | 0.00570746347014 | 0.00615347395043 | 0.00976218890319 | 0.00991515631907 | 0.0101475602301 | 0.0131839973841 | 0.0135200605425 | 0.0139506747469 | 0.0145696204963 | 0.0156940139329 | 0.0160600078884 | 0.0172507443855 | 0.0174911329778 | 0.0236920817891 | 0.0238421357289 | 0.0351594379785 | 0.0352995234062 | 0.0430604888042 | 0.0443455638067 | 187.107034377 | -1.6157654852 | 11147197 | 0.5226 | 0.3107 | 0.7112 | 0.794 | -99.0 | -99.0 | -99.0 | -99.0 | 0.573529768951 | 0.418236125 | 0.476232 | 0.769594125 | 8.9608125 | m2iii |
\n",
"HELP_J122825.798-013712.032 | 2.14805714074e+36 | 1.47680621342e+36 | 0.00409576465093 | 0.00845498801097 | 0.00869953108459 | 0.00875489990811 | 0.00897530312772 | 0.0119930133259 | 0.0119546556664 | 0.0121248049756 | 0.0123041597412 | 0.0136530209198 | 0.0137328097856 | 0.013797267028 | 0.0150262671606 | 0.0152080813341 | 0.0154178298916 | 0.015690385073 | 0.0161516369506 | 0.0163623503855 | 0.0171793608417 | 0.0173776624253 | 0.0192548141121 | 0.0192945000987 | 0.0211320408895 | 0.0211853374912 | 0.0220530326294 | 0.0215201768733 | 187.107491817 | -1.62000889478 | 9387777 | 0.1547 | 0.115 | 0.2053 | 0.786 | -99.0 | -99.0 | -99.0 | -99.0 | 0.142023735815 | 0.89923625 | 1.65035375 | 2.54497 | 1.32692 | rf8v |
\n",
"HELP_J122825.799-013701.692 | 4.28322184014e+37 | 4.9210598117e+37 | 0.00273673184984 | 0.00369623563625 | 0.00373527427781 | 0.00374430934721 | 0.0037699887006 | 0.0073081729775 | 0.00740499092791 | 0.0078043236369 | 0.00807701526021 | 0.00907830633842 | 0.00915677128173 | 0.0091669397766 | 0.00981306403673 | 0.00987883719133 | 0.00996093144176 | 0.0100834181341 | 0.0102303620919 | 0.0103267828018 | 0.0105917509741 | 0.0106230068723 | 0.0121449195962 | 0.012204707927 | 0.0145782589472 | 0.0145867872266 | 0.0158722440665 | 0.0161073868445 | 187.107494141 | -1.61713662341 | 11012312 | 0.5038 | 0.371 | 0.636 | 0.793 | -99.0 | -99.0 | -99.0 | -99.0 | 0.527093516722 | 0.4023016 | 0.814329 | 1.930058 | 6.207836 | k3v |
\n",
"HELP_J122825.877-013755.825 | 4.43386678634e+38 | 5.09131852008e+38 | 0.000132283593125 | 0.000441118274717 | 0.000459182922406 | 0.000462519193721 | 0.000476413400313 | 0.00105571031941 | 0.00106010027923 | 0.00111447094317 | 0.00116748768923 | 0.00213236917757 | 0.00217436469534 | 0.00228141005749 | 0.00332512058435 | 0.00341618227865 | 0.00356574548659 | 0.00375611084075 | 0.00410227882471 | 0.00420900122049 | 0.00456678092155 | 0.00466049134526 | 0.0065452172812 | 0.00657780105983 | 0.0105144653162 | 0.0106233456705 | 0.0159286774673 | 0.016404330287 | 187.10782164 | -1.63217370607 | 10505331 | 0.9357 | 0.6707 | 1.234 | 0.555 | 0.5272 | 0.4254 | 0.6311 | 0.136 | 0.789843601218 | 0.77898 | 1.21890016667 | 0.828495333333 | 4.04519166667 | m3ii |
\n",
"HELP_J122826.138-013818.211 | 2.50458512808e+36 | 8.92150969757e+35 | 0.019536877316 | 0.0313734708931 | 0.0318879108337 | 0.0320085446911 | 0.0325418790243 | 0.0361820125396 | 0.0360251680581 | 0.036239196461 | 0.0363591466653 | 0.0372503869887 | 0.037510170013 | 0.0374997520303 | 0.0393017039618 | 0.0395854239418 | 0.0398142152834 | 0.0402904819483 | 0.0409471206129 | 0.0414053373402 | 0.043203387577 | 0.0436166760491 | 0.0459442420835 | 0.0460183793708 | 0.0483148508369 | 0.0484033109054 | 0.0479365115214 | 0.0466315409021 | 187.108910013 | -1.63839194657 | 9332438 | 0.1356 | 0.1116 | 0.1662 | 0.712 | 0.0482 | 0.0407 | 0.0565 | 0.058 | 0.13180688451 | 4.282342 | 3.06846 | 10.38794 | 0.6893214 | wf8v |
\n",
"HELP_J122826.531-013729.496 | 4.95938707418e+38 | 3.70590375119e+38 | 0.000700024693841 | 0.00155607983451 | 0.00162342258177 | 0.00163690540196 | 0.00167950363534 | 0.00386859751955 | 0.00380038540541 | 0.00418479610097 | 0.00463704791405 | 0.0107797907471 | 0.0109466937146 | 0.0114809534548 | 0.0154796026675 | 0.015737475243 | 0.0159947263059 | 0.0171309653971 | 0.0189352873112 | 0.0197415940529 | 0.0216373799162 | 0.0221286668903 | 0.0307841418842 | 0.0309767633824 | 0.0494875999151 | 0.0499538010009 | 0.0679912747101 | 0.0701424743446 | 187.110546588 | -1.62485998468 | 10358854 | 0.7838 | 0.5595 | 0.9758 | 0.798 | -99.0 | -99.0 | -99.0 | -99.0 | 0.844269625561 | 9.95825454545 | 7.87271636364 | 4.86007636364 | 1.66697272727 | m4v |
\n",
"HELP_J122827.358-013618.662 | 1.20499668671e+39 | 1.6571915369e+39 | 0.000147082824979 | 0.000428127839656 | 0.000451150022557 | 0.000455727664497 | 0.000470779894341 | 0.00128264091654 | 0.00125683445288 | 0.00139770550129 | 0.00156568590424 | 0.00412455696042 | 0.004218154283 | 0.00446607270148 | 0.00660992769147 | 0.00677106864889 | 0.00694866607941 | 0.00752220133806 | 0.00847610695007 | 0.00890457285108 | 0.010007536247 | 0.0102860602568 | 0.015676571298 | 0.0157941921292 | 0.0281231825466 | 0.0284438210156 | 0.0426205295113 | 0.0443098305765 | 187.113992233 | -1.60518393681 | 10199242 | 0.8035 | 0.4688 | 1.1231 | 0.793 | -99.0 | -99.0 | -99.0 | -99.0 | 0.784490130825 | 0.503333833333 | 0.6441775 | 0.2474265 | 8.20423 | m5iii |
\n",
"HELP_J122829.089-013711.804 | 2.65636176092e+39 | 1.4112316383e+39 | 0.00716952899517 | 0.0218542495742 | 0.0228917105666 | 0.0230969601511 | 0.0238636222247 | 0.0948014718452 | 0.0957259882033 | 0.104986538139 | 0.113585357926 | 0.192024942628 | 0.19630936081 | 0.202838335013 | 0.287043773003 | 0.295300427953 | 0.306009196585 | 0.326607777237 | 0.36135082405 | 0.375843291657 | 0.409367279679 | 0.417742870715 | 0.640979866031 | 0.645353079634 | 1.04780865522 | 1.05413321538 | 1.4415402699 | 1.49841442715 | 187.121203187 | -1.61994543488 | 9386359 | 0.4813 | 0.001 | 1.5108 | 0.799 | -99.0 | -99.0 | -99.0 | -99.0 | 0.001 | 22.48 | 20.0994363636 | 12.0607181818 | 2.73683727273 | m2p5v |
\n",
"HELP_J122829.372-013659.895 | 6.84338249493e+37 | 8.08634710532e+37 | 0.00129959778414 | 0.00163818066884 | 0.001662871293 | 0.00166745277485 | 0.00168427989875 | 0.00320539268524 | 0.00322347666598 | 0.00345029898004 | 0.00367862099597 | 0.00537169699745 | 0.00539896452352 | 0.00551351465593 | 0.00647767980332 | 0.0066026518953 | 0.006744097808 | 0.00696991499573 | 0.00736377341283 | 0.00746329440193 | 0.00776632335094 | 0.00786772542183 | 0.00973783930807 | 0.00975055343527 | 0.0130954367986 | 0.0131267966265 | 0.0146719576511 | 0.0149235576397 | 187.122383773 | -1.61663739853 | 10338374 | 0.56 | 0.3875 | 0.7685 | 0.772 | 0.2359 | 0.2162 | 0.2569 | 0.021 | 0.442606570742 | 0.0914002333333 | 0.326045333333 | 0.526406333333 | 4.244995 | wk3iii |
\n",
"
"
],
"text/plain": [
"\n",
" help_id bayes.dust.luminosity ... stellar_type\n",
" ... \n",
" str28 float64 ... str6 \n",
"--------------------------- --------------------- ... ------------\n",
"HELP_J112916.236+004455.105 9.65287793768e+37 ... \n",
"HELP_J112916.735+004525.955 4.99604151924e+38 ... m3ii\n",
"HELP_J112916.868+004538.834 6.74395178932e+35 ... rk1iii\n",
"HELP_J112916.993+004528.665 1.06941218163e+37 ... m3v\n",
"HELP_J112917.687+004454.217 8.27142268505e+37 ... m3ii\n",
"HELP_J112917.704+004533.215 2.62197498446e+36 ... k4i\n",
"HELP_J112918.031+004449.789 2.47229097952e+37 ... \n",
"HELP_J112918.084+004525.273 2.53947597807e+38 ... m3ii\n",
"HELP_J112918.563+004439.998 8.53276321612e+37 ... \n",
" ... ... ... ...\n",
"HELP_J122825.517-013639.700 2.41696074215e+41 ... m4v\n",
"HELP_J122825.688-013656.756 1.50956081754e+38 ... m2iii\n",
"HELP_J122825.798-013712.032 2.14805714074e+36 ... rf8v\n",
"HELP_J122825.799-013701.692 4.28322184014e+37 ... k3v\n",
"HELP_J122825.877-013755.825 4.43386678634e+38 ... m3ii\n",
"HELP_J122826.138-013818.211 2.50458512808e+36 ... wf8v\n",
"HELP_J122826.531-013729.496 4.95938707418e+38 ... m4v\n",
"HELP_J122827.358-013618.662 1.20499668671e+39 ... m5iii\n",
"HELP_J122829.089-013711.804 2.65636176092e+39 ... m2p5v\n",
"HELP_J122829.372-013659.895 6.84338249493e+37 ... wk3iii"
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"prior"
]
},
{
"cell_type": "code",
"execution_count": 53,
"metadata": {},
"outputs": [],
"source": [
"from astropy.cosmology import Planck15 as cosmo\n",
"from astropy import units as u\n",
"f_pred=prior['bayes.dust.luminosity']/(4*np.pi*cosmo.luminosity_distance(prior['z1_median']).to(u.cm))\n"
]
},
{
"cell_type": "code",
"execution_count": 54,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"prior=prior[np.isfinite(f_pred.value)][np.log10(f_pred.value[np.isfinite(f_pred.value)])>8.5]"
]
},
{
"cell_type": "code",
"execution_count": 55,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"prior['DEC'].name='Dec'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read in Maps"
]
},
{
"cell_type": "code",
"execution_count": 56,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"\n",
"pswfits='../../dmu19/dmu19_HELP-SPIRE-maps/data/GAMA-12_SPIRE250_v0.9.fits'#SPIRE 250 map\n",
"pmwfits='../../dmu19/dmu19_HELP-SPIRE-maps/data/GAMA-12_SPIRE350_v0.9.fits'#SPIRE 350 map\n",
"plwfits='../../dmu19/dmu19_HELP-SPIRE-maps/data/GAMA-12_SPIRE500_v0.9.fits'#SPIRE 500 map\n",
"\n",
"#output folder\n",
"output_folder='./'"
]
},
{
"cell_type": "code",
"execution_count": 57,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"from astropy.io import fits\n",
"from astropy import wcs\n",
"\n",
"#-----250-------------\n",
"hdulist = fits.open(pswfits)\n",
"im250phdu=hdulist[0].header\n",
"im250hdu=hdulist[1].header\n",
"\n",
"im250=hdulist[1].data*1.0E3 #convert to mJy\n",
"nim250=hdulist[3].data*1.0E3 #convert to mJy\n",
"w_250 = wcs.WCS(hdulist[1].header)\n",
"pixsize250=3600.0*w_250.wcs.cdelt #pixel size (in arcseconds)\n",
"hdulist.close()\n",
"#-----350-------------\n",
"hdulist = fits.open(pmwfits)\n",
"im350phdu=hdulist[0].header\n",
"im350hdu=hdulist[1].header\n",
"\n",
"im350=hdulist[1].data*1.0E3 #convert to mJy\n",
"nim350=hdulist[3].data*1.0E3 #convert to mJy\n",
"w_350 = wcs.WCS(hdulist[1].header)\n",
"pixsize350=3600.0*w_350.wcs.cdelt #pixel size (in arcseconds)\n",
"hdulist.close()\n",
"#-----500-------------\n",
"hdulist = fits.open(plwfits)\n",
"im500phdu=hdulist[0].header\n",
"im500hdu=hdulist[1].header\n",
"im500=hdulist[1].data*1.0E3 #convert to mJy\n",
"nim500=hdulist[3].data*1.0E3 #convert to mJy\n",
"w_500 = wcs.WCS(hdulist[1].header)\n",
"pixsize500=3600.0*w_500.wcs.cdelt #pixel size (in arcseconds)\n",
"hdulist.close()"
]
},
{
"cell_type": "code",
"execution_count": 58,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"## Set XID+ prior class"
]
},
{
"cell_type": "code",
"execution_count": 59,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"#---prior250--------\n",
"prior250=xidplus.prior(im250,nim250,im250phdu,im250hdu, moc=Sel_func)#Initialise with map, uncertianty map, wcs info and primary header\n",
"prior250.prior_cat(prior['RA'] ,prior['Dec'] ,'GAMA12_Ldust_prediction_results.fits',ID=prior['help_id'] )#Set input catalogue\n",
"prior250.prior_bkg(-5.0,5)#Set prior on background (assumes Gaussian pdf with mu and sigma)\n",
"#---prior350--------\n",
"prior350=xidplus.prior(im350,nim350,im350phdu,im350hdu, moc=Sel_func)\n",
"prior350.prior_cat(prior['RA'] ,prior['Dec'] ,'GAMA12_Ldust_prediction_results.fits',ID=prior['help_id'] )\n",
"prior350.prior_bkg(-5.0,5)\n",
"\n",
"#---prior500--------\n",
"prior500=xidplus.prior(im500,nim500,im500phdu,im500hdu, moc=Sel_func)\n",
"prior500.prior_cat(prior['RA'] ,prior['Dec'] ,'GAMA12_Ldust_prediction_results.fits',ID=prior['help_id'] )\n",
"prior500.prior_bkg(-5.0,5)"
]
},
{
"cell_type": "code",
"execution_count": 60,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"#pixsize array (size of pixels in arcseconds)\n",
"pixsize=np.array([pixsize250,pixsize350,pixsize500])\n",
"#point response function for the three bands\n",
"prfsize=np.array([18.15,25.15,36.3])\n",
"#use Gaussian2DKernel to create prf (requires stddev rather than fwhm hence pfwhm/2.355)\n",
"from astropy.convolution import Gaussian2DKernel\n",
"\n",
"##---------fit using Gaussian beam-----------------------\n",
"prf250=Gaussian2DKernel(prfsize[0]/2.355,x_size=101,y_size=101)\n",
"prf250.normalize(mode='peak')\n",
"prf350=Gaussian2DKernel(prfsize[1]/2.355,x_size=101,y_size=101)\n",
"prf350.normalize(mode='peak')\n",
"prf500=Gaussian2DKernel(prfsize[2]/2.355,x_size=101,y_size=101)\n",
"prf500.normalize(mode='peak')\n",
"\n",
"pind250=np.arange(0,101,1)*1.0/pixsize[0,1] #get 250 scale in terms of pixel scale of map\n",
"pind350=np.arange(0,101,1)*1.0/pixsize[1,1] #get 350 scale in terms of pixel scale of map\n",
"pind500=np.arange(0,101,1)*1.0/pixsize[2,1] #get 500 scale in terms of pixel scale of map\n",
"\n",
"prior250.set_prf(prf250.array,pind250,pind250)#requires psf as 2d grid, and x and y bins for grid (in pixel scale)\n",
"prior350.set_prf(prf350.array,pind350,pind350)\n",
"prior500.set_prf(prf500.array,pind500,pind500)"
]
},
{
"cell_type": "code",
"execution_count": 61,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"----- There are 5013 tiles required for input catalogue and 100 large tiles\n",
"writing total_bytes=1493072309...\n",
"writing bytes [0, 1073741824)... done.\n",
"writing bytes [1073741824, 1493072309)... done.\n"
]
},
{
"ename": "SystemExit",
"evalue": "",
"output_type": "error",
"traceback": [
"An exception has occurred, use %tb to see the full traceback.\n",
"\u001b[0;31mSystemExit\u001b[0m\n"
]
}
],
"source": [
"import pickle\n",
"#from moc, get healpix pixels at a given order\n",
"from xidplus import moc_routines\n",
"order=9\n",
"tiles=moc_routines.get_HEALPix_pixels(order,prior250.sra,prior250.sdec,unique=True)\n",
"order_large=6\n",
"tiles_large=moc_routines.get_HEALPix_pixels(order_large,prior250.sra,prior250.sdec,unique=True)\n",
"print('----- There are '+str(len(tiles))+' tiles required for input catalogue and '+str(len(tiles_large))+' large tiles')\n",
"output_folder='./'\n",
"outfile=output_folder+'Master_prior.pkl'\n",
"xidplus.io.pickle_dump({'priors':[prior250,prior350,prior500],'tiles':tiles,'order':order,'version':xidplus.io.git_version()},outfile)\n",
"outfile=output_folder+'Tiles.pkl'\n",
"with open(outfile, 'wb') as f:\n",
" pickle.dump({'tiles':tiles,'order':order,'tiles_large':tiles_large,'order_large':order_large,'version':xidplus.io.git_version()},f)\n",
"raise SystemExit()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"prior250.nsrc"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.8"
}
},
"nbformat": 4,
"nbformat_minor": 2
}