In [1]:
from astroquery.alma import Alma
from astropy import coordinates
from astropy import units as u
import numpy as np
import pandas as pd
In [2]:
def query_object(obj, theta = 0.005, science = False, public = True, savedb=False, dbname='calibrators.db'):
"""
query per object
obj is an array consist of at least [objname, ra, dec, ...]
ra and dec are in degrees
"""
region = coordinates.SkyCoord(obj[1], obj[2], unit='deg')
alma_data = Alma.query_region(region, theta*u.deg, science = science, public = public)
# it is in astropy Table format
df = alma_data.to_pandas() # convert to pandas Dataframe
#! change Numpy Masked-Array to str, so it can be converted to SQL
#df['Band'] = df['Band'].astype("str")
# save the query result in sql database
# with Table's name = calibrator's name
if savedb:
conn = sql.connect(dbname)
conn.text_factory = str
if not df.dropna().empty:
df.to_sql(obj[0], conn, if_exists='replace') # if the Table exist in the db, just replace it
return alma_data, df
In [3]:
# from astropy.coordinates import SkyCoord
# c = SkyCoord('11h39m10.7025s', '-13d50m43.639s', frame='icrs')
# c
In [4]:
#obj = ["J1159+2914", 179.88264, 29.245507]
#obj = ["J1130-1449", 172.52938, -14.82427]
#obj = ["J1833-210B", 278.41633, -21.06108]
#obj = ["J0237+2848", 39.468356, 28.802497]
#obj = ["J0006-0623", 1.5578870, -6.393148]
#obj = ["J0601-7036", 90.296866, -70.60244]
#obj = ["J1225+1253", 186.26559, 12.886983]
#obj = ["J1256-0547",194.04652, -5.789312]
#obj = ["J1139-1350", 174.79459375, -13.84545528]
#obj = ['J0541-0211', 85.340401, -2.185662]
#obj = ["J0501-0159", 75.3031, -1.98746]
obj = ["J1232-0224", 188.00006, -2.401331]
In [5]:
table, df = query_object(obj)
In [6]:
df
Out[6]:
Project code
Source name
RA
Dec
Galactic longitude
Galactic latitude
Band
Spatial resolution
Frequency resolution
Array
...
Project title
Project type
Scan intent
Field of view
Largest angular scale
QA2 Status
COUNT
Science keyword
Scientific category
ASA_PROJECT_CODE
0
b'2015.1.00820.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[3]
2.344463
488.318833
b'12m'
...
b'Dark Matter in Dwarf Galaxies'
b'S'
b'PHASE WVR'
58.966865
10.858773
b'Y'
0.0
b'Surveys of galaxies'
b'Galaxy evolution'
b'2015.1.00820.S'
1
b'2015.1.00932.S'
b'4C_-02.55'
188.000067
-2.401332
293.156232
60.100915
[6]
0.837670
31251.859217
b'12m'
...
b'Measuring the Spectral Evolution, Structure,...
b'S'
b'TARGET'
27.153557
4.007028
b'Y'
2.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO), ...
b'Active galaxies'
b'2015.1.00932.S'
2
b'2015.1.00042.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[7]
0.374026
15624.983584
b'12m'
...
b'Vibrational H2O emission in NGC 4418: a sear...
b'S'
b'CHECK WVR'
18.640746
2.602928
b'Y'
0.0
b'Galactic centres/nuclei, Luminous and Ultra-...
b'Active galaxies'
b'2015.1.00042.S'
3
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[6]
0.178302
31252.986939
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
27.152577
0.777761
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
4
b'2016.1.01481.S'
b'4C_-02.55'
188.000054
-2.401335
293.156207
60.100910
[3]
0.929928
31252.927660
b'12m'
...
b'Measuring the Spectral Evolution, Structure,...
b'S'
b'TARGET'
65.282528
4.495095
b'Y'
1.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO)'
b'Active galaxies'
b'2016.1.01481.S'
5
b'2015.1.00872.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[6]
0.268118
31251.619174
b'12m'
...
b'Is the central sub-kiloparsec gas surface-de...
b'S'
b'PHASE WVR'
28.252058
1.272441
b'Y'
0.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO)'
b'Active galaxies'
b'2015.1.00872.S'
6
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[7]
0.194333
31251.758384
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
18.393417
0.987576
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
7
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[6]
0.188324
31250.198018
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
27.155000
0.824977
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
8
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[7]
0.211587
31250.304988
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
18.394272
1.049691
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
9
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[7]
0.175958
31252.147284
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
18.393188
0.894197
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
10
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[7]
0.169606
31252.373088
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'CHECK WVR'
18.393055
0.809137
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
11
b'2016.1.01481.S'
b'4C_-02.55'
188.000054
-2.401335
293.156207
60.100910
[6]
0.484673
31252.866899
b'12m'
...
b'Measuring the Spectral Evolution, Structure,...
b'S'
b'TARGET'
27.152681
2.389373
b'Y'
1.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO)'
b'Active galaxies'
b'2016.1.01481.S'
12
b'2015.1.00932.S'
b'4C_-02.55'
188.000067
-2.401332
293.156232
60.100915
[3]
0.358851
31251.114942
b'12m'
...
b'Measuring the Spectral Evolution, Structure,...
b'S'
b'TARGET'
65.286315
1.907325
b'Y'
2.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO), ...
b'Active galaxies'
b'2015.1.00932.S'
13
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[6]
0.287964
31250.326966
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
27.154888
1.463877
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
14
b'2016.1.00691.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[7]
0.182771
31250.513929
b'12m'
...
b'Thermal Properties of Icy Satellites'
b'S'
b'PHASE WVR'
18.394149
0.929123
b'Y'
0.0
b'Solar system - Planetary surfaces'
b'Solar system'
b'2016.1.00691.S'
15
b'2016.1.01481.S'
b'4C_-02.55'
188.000054
-2.401335
293.156207
60.100910
[6]
0.199376
31251.791013
b'12m'
...
b'Measuring the Spectral Evolution, Structure,...
b'S'
b'TARGET'
27.153616
1.092274
b'Y'
1.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO)'
b'Active galaxies'
b'2016.1.01481.S'
16
b'2016.1.01481.S'
b'4C_-02.55'
188.000054
-2.401335
293.156207
60.100910
[3]
0.256369
31251.554160
b'12m'
...
b'Measuring the Spectral Evolution, Structure,...
b'S'
b'TARGET'
65.285398
1.663111
b'Y'
1.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO)'
b'Active galaxies'
b'2016.1.01481.S'
17
b'2016.1.00387.S'
b'J1232-0224'
188.000067
-2.401332
293.156232
60.100915
[4]
0.242052
3906.275995
b'12m'
...
b'Spectral Scan on A Compact Obscured Nucleus'
b'S'
b'CHECK WVR'
42.153674
1.077889
b'Y'
0.0
b'Galaxy chemistry, Luminous and Ultra-Luminou...
b'Galaxy evolution'
b'2016.1.00387.S'
18 rows × 36 columns
In [7]:
table
Out[7]:
Table masked=True length=18
Project code Source name RA Dec Galactic longitude Galactic latitude Band Spatial resolution Frequency resolution Array Mosaic Integration Release date Frequency support Velocity resolution Pol products Observation date PI name SB name Proposal authors Line sensitivity (10 km/s) Continuum sensitivity PWV Group ous id Member ous id Asdm uid Project title Project type Scan intent Field of view Largest angular scale QA2 Status COUNT Science keyword Scientific category ASA_PROJECT_CODE deg deg deg deg kHz s GHz m / s mJy/beam mm arcs arcs bytes64 bytes256 float64 float64 float64 float64 object float64 float64 object bytes1 float64 object bytes2700 float64 bytes64 object bytes256 bytes128 bytes512 float64 float64 float32 bytes64 bytes64 bytes32 bytes256 bytes16 bytes256 float64 float64 bytes1 int64 bytes200 bytes200 bytes64 2015.1.00820.S J1232-0224 188.00006670833332 -2.401331961111111 293.1562318083252 60.10091459062826 [3] 2.344462925033087 488.3188328878405 12m 181.44 2017-02-22 [99.51..101.51GHz,31250.00kHz,2.4mJy/beam@10km/s,99uJy/beam@native, XX YY] U [101.50..103.50GHz,31250.00kHz,2.4mJy/beam@10km/s,100uJy/beam@native, XX YY] U [111.95..113.95GHz,31250.00kHz,2.9mJy/beam@10km/s,127.4uJy/beam@native, XX YY] U [114.15..115.09GHz,488.28kHz,3.6mJy/beam@10km/s,230.9uJy/beam@native, XX YY] 1271.9037207481322 XX YY 2016-01-03 08:46:54 Blitz, Leo NGC_4632_a_03_TE Bolatto, Alberto; Newman, Andrew; Truong, Mai; Simon, Josh; Plambeck, Richard; wright, melvyn; 2.417597556671656 0.059495861578071914 3.0235512 uid://A001/X2f7/X2bc uid://A001/X2f7/X2bd uid://A002/Xae75f3/X440a Dark Matter in Dwarf Galaxies S PHASE WVR 58.96686484428556 10.858773251907962 Y 0 Surveys of galaxies Galaxy evolution 2015.1.00820.S 2015.1.00932.S 4C_-02.55 188.0000666699434 -2.4013316700018565 293.1562316439356 60.10091487258747 [6] 0.8376696884271269 31251.859216657835 12m 181.44 2017-05-12 [223.00..225.00GHz,31250.00kHz,1.9mJy/beam@10km/s,116.1uJy/beam@native, XX YY] U [225.00..227.00GHz,31250.00kHz,2mJy/beam@10km/s,120.1uJy/beam@native, XX YY] U [239.00..241.00GHz,31250.00kHz,1.9mJy/beam@10km/s,122.1uJy/beam@native, XX YY] U [241.00..243.00GHz,31250.00kHz,1.9mJy/beam@10km/s,123.9uJy/beam@native, XX YY] 38554.79638620068 XX YY 2016-03-28 02:04:24 Meyer, Eileen 4C_-02.5_a_06_TC Sparks, William; Biretta, John; Georganopoulos, Markos; Perlman, Eric; 1.8999037894194668 0.06021195915489463 1.0488178 uid://A001/X2f6/X1f8 uid://A001/X2f6/X1fb uid://A002/Xb0ebd1/Xb6cc Measuring the Spectral Evolution, Structure, and Speed of Extragalactic Jets with ALMA S TARGET 27.153556914742367 4.007028146171372 Y 2 Active Galactic Nuclei (AGN)/Quasars (QSO), Outflows, jets, feedback Active galaxies 2015.1.00932.S 2015.1.00042.S J1232-0224 188.0000667083637 -2.4013319611115325 293.15623180838537 60.10091459063243 [7] 0.37402557594501595 15624.98358439434 12m 241.92 2017-09-12 [331.29..333.19GHz,15625.00kHz,4.4mJy/beam@10km/s,335.6uJy/beam@native, XX YY] U [333.04..334.94GHz,15625.00kHz,4mJy/beam@10km/s,311.1uJy/beam@native, XX YY] U [343.08..344.98GHz,15625.00kHz,3.8mJy/beam@10km/s,296.7uJy/beam@native, XX YY] U [344.60..346.50GHz,15625.00kHz,3.8mJy/beam@10km/s,298.2uJy/beam@native, XX YY] 13518.798829962549 XX YY 2016-03-27 05:41:21 Gonzalez-Alfonso, Eduardo NGC_4418_a_07_TE Fischer, Jacqueline; Omont, Alain; Aalto, Susanne; Muller, Sebastien; Martin, Sergio; Costagliola, Francesco; Sakamoto, Kazushi; 3.7922737459478735 0.1546406775820568 0.95196044 uid://A001/X2fe/X41d uid://A001/X2fe/X41e uid://A002/Xb0ebd1/X72a3 Vibrational H2O emission in NGC 4418: a search for buried AGN through the greenhouse effect S CHECK WVR 18.64074570945611 2.6029283146209425 Y 0 Galactic centres/nuclei, Luminous and Ultra-Luminous Infra-Red Galaxies (LIRG & ULIRG) Active galaxies 2015.1.00042.S 2016.1.00691.S J1232-0224 188.00006670828782 -2.401331961112053 293.15623180823513 60.10091459062044 [6] 0.17830202263232117 31252.986938669932 12m 60.48 2017-11-09 [223.00..225.00GHz,31250.00kHz,3.4mJy/beam@10km/s,206.7uJy/beam@native, XX YY] U [225.00..227.00GHz,31250.00kHz,3.5mJy/beam@10km/s,213.7uJy/beam@native, XX YY] U [239.00..241.00GHz,31250.00kHz,3.4mJy/beam@10km/s,216.4uJy/beam@native, XX YY] U [241.00..243.00GHz,31250.00kHz,3.5mJy/beam@10km/s,219.5uJy/beam@native, XX YY] 38554.79638620068 XX YY 2016-10-13 13:43:04 de Kleer, Katherine Ganymede_b_06_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 3.382051053136586 0.10695933599685814 0.7455162 uid://A001/X88e/X23a uid://A001/X88e/X23b uid://A002/Xb95160/X5a40 Thermal Properties of Icy Satellites S PHASE WVR 27.15257711515075 0.7777606972173531 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.01481.S 4C_-02.55 188.00005374996894 -2.4013347200003707 293.15620697096597 60.10090990530305 [3] 0.9299283237288531 31252.927659848545 12m 66.528 2017-12-01 [89.49..91.49GHz,31250.00kHz,3.9mJy/beam@10km/s,149.6uJy/beam@native, XX YY] U [91.43..93.43GHz,31250.00kHz,3.8mJy/beam@10km/s,149.2uJy/beam@native, XX YY] U [101.49..103.49GHz,31250.00kHz,3.7mJy/beam@10km/s,151uJy/beam@native, XX YY] U [103.49..105.49GHz,31250.00kHz,3.7mJy/beam@10km/s,152.4uJy/beam@native, XX YY] 88812.2271503024 XX YY 2016-11-12 12:21:50 Meyer, Eileen 4C_-02.5_a_03_TM2 Sparks, William; Biretta, John; Chiaberge, Marco; Georganopoulos, Markos; Perlman, Eric; 3.6513624016492137 0.07526655538616203 0.36181447 uid://A001/X885/X93 uid://A001/X885/X96 uid://A002/Xba839d/X57ac Measuring the Spectral Evolution, Structure, and Speed of Extragalactic Jets with ALMA S TARGET 65.2825284640492 4.495094741157901 Y 1 Active Galactic Nuclei (AGN)/Quasars (QSO) Active galaxies 2016.1.01481.S 2015.1.00872.S J1232-0224 188.00006670829913 -2.401331961111583 293.15623180825753 60.10091459062262 [6] 0.2681183659412766 31251.619173706447 12m 60.48 2017-12-05 [213.98..215.98GHz,31250.00kHz,3.8mJy/beam@10km/s,229.4uJy/beam@native, XX YY] U [215.96..217.96GHz,31250.00kHz,3.6mJy/beam@10km/s,214.6uJy/beam@native, XX YY] U [229.98..231.98GHz,31250.00kHz,3.6mJy/beam@10km/s,223.7uJy/beam@native, XX YY] U [231.98..233.98GHz,31250.00kHz,3.6mJy/beam@10km/s,224.1uJy/beam@native, XX YY] 40041.09568332347 XX YY 2016-07-28 19:19:28 Schulze, Andreas SDSS_J12_a_06_TE Schramm, Malte; Rujopakarn, Wiphu; Jahnke, Knud; Nagao, Tohru; Wisotzki, Lutz; Silverman, John; 3.567084829424564 0.11137636135521195 0.64805216 uid://A001/X5a4/Xd3 uid://A001/X5a4/Xd4 uid://A002/Xb602ab/Xe9c Is the central sub-kiloparsec gas surface-density the decisive parameter for fueling supermassive black holes? S PHASE WVR 28.252058124858408 1.2724411590204332 Y 0 Active Galactic Nuclei (AGN)/Quasars (QSO) Active galaxies 2015.1.00872.S 2016.1.00691.S J1232-0224 188.0000667082763 -2.4013319611142263 293.1562318082131 60.10091459061656 [7] 0.19433278321171335 31251.758384311473 12m 60.48 2017-12-22 [335.49..337.49GHz,31250.00kHz,4.3mJy/beam@10km/s,324.6uJy/beam@native, XX YY] U [337.43..339.43GHz,31250.00kHz,4.3mJy/beam@10km/s,322.4uJy/beam@native, XX YY] U [347.49..349.49GHz,31250.00kHz,4.3mJy/beam@10km/s,330.6uJy/beam@native, XX YY] U [349.49..351.49GHz,31250.00kHz,4.4mJy/beam@10km/s,335.2uJy/beam@native, XX YY] 26653.960581232415 XX YY 2016-10-24 11:15:03 de Kleer, Katherine Callisto_b_07_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 4.290621535421456 0.1640407655417944 0.5487961 uid://A001/X88e/X226 uid://A001/X88e/X227 uid://A002/Xb9c01c/X4a84 Thermal Properties of Icy Satellites S PHASE WVR 18.393416975052087 0.9875761202466246 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.00691.S J1232-0224 188.00006670827977 -2.4013319611126076 293.15623180821945 60.10091459061871 [6] 0.18832388038716572 31250.19801804116 12m 60.48 2017-12-27 [223.00..225.00GHz,31250.00kHz,3.4mJy/beam@10km/s,210.5uJy/beam@native, XX YY] U [225.00..227.00GHz,31250.00kHz,3.5mJy/beam@10km/s,217.5uJy/beam@native, XX YY] U [239.00..241.00GHz,31250.00kHz,3.5mJy/beam@10km/s,219.7uJy/beam@native, XX YY] U [241.00..243.00GHz,31250.00kHz,3.5mJy/beam@10km/s,222.6uJy/beam@native, XX YY] 38554.79638620068 XX YY 2016-10-15 13:05:07 de Kleer, Katherine Ganymede_a_06_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 3.443272718498959 0.10872075090272373 0.45438436 uid://A001/X88e/X21a uid://A001/X88e/X21b uid://A002/Xb97224/X1529 Thermal Properties of Icy Satellites S PHASE WVR 27.155000344033873 0.8249771846810574 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.00691.S J1232-0224 188.00006670827557 -2.401331961113189 293.15623180821126 60.100914590617464 [7] 0.2115870383482627 31250.304987784544 12m 60.48 2017-12-29 [335.49..337.49GHz,31250.00kHz,3.9mJy/beam@10km/s,288.9uJy/beam@native, XX YY] U [337.43..339.43GHz,31250.00kHz,3.8mJy/beam@10km/s,286.9uJy/beam@native, XX YY] U [347.49..349.49GHz,31250.00kHz,3.9mJy/beam@10km/s,294.3uJy/beam@native, XX YY] U [349.49..351.49GHz,31250.00kHz,3.9mJy/beam@10km/s,298.4uJy/beam@native, XX YY] 26653.960581232415 XX YY 2016-10-26 11:53:45 de Kleer, Katherine Ganymede_b_07_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 3.8190642037860547 0.14601199627381964 0.26599807 uid://A001/X88e/X23e uid://A001/X88e/X23f uid://A002/Xb9cc97/X80ec Thermal Properties of Icy Satellites S PHASE WVR 18.39427242041047 1.0496912590462852 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.00691.S J1232-0224 188.00006670827477 -2.4013319611137782 293.1562318082099 60.10091459061677 [7] 0.1759578011606886 31252.147283770002 12m 60.48 2017-12-30 [335.49..337.49GHz,31250.00kHz,4.3mJy/beam@10km/s,324.6uJy/beam@native, XX YY] U [337.43..339.43GHz,31250.00kHz,4.3mJy/beam@10km/s,322.4uJy/beam@native, XX YY] U [347.49..349.49GHz,31250.00kHz,4.3mJy/beam@10km/s,330.6uJy/beam@native, XX YY] U [349.49..351.49GHz,31250.00kHz,4.4mJy/beam@10km/s,335.2uJy/beam@native, XX YY] 26653.960581232415 XX YY 2016-10-24 11:35:59 de Kleer, Katherine Ganymede_a_07_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 4.290621535421461 0.16404076554179456 0.54138756 uid://A001/X88e/X21e uid://A001/X88e/X21f uid://A002/Xb9c01c/X4c55 Thermal Properties of Icy Satellites S PHASE WVR 18.3931880887027 0.8941966441559502 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.00691.S J1232-0224 188.00006670835674 -2.401331961111327 293.15623180837156 60.10091459063158 [7] 0.169606088104965 31252.37308759591 12m 60.48 2017-12-30 [335.49..337.49GHz,31250.00kHz,5.6mJy/beam@10km/s,419.3uJy/beam@native, XX YY] U [337.43..339.43GHz,31250.00kHz,5.5mJy/beam@10km/s,413.7uJy/beam@native, XX YY] U [347.49..349.49GHz,31250.00kHz,5.6mJy/beam@10km/s,427.8uJy/beam@native, XX YY] U [349.49..351.49GHz,31250.00kHz,5.7mJy/beam@10km/s,436.4uJy/beam@native, XX YY] 26653.960581232415 XX YY 2016-11-01 14:59:02 de Kleer, Katherine Callisto_a_07_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 5.506041202516393 0.2120195155980175 1.0520347 uid://A001/X88e/X206 uid://A001/X88e/X207 uid://A002/Xba0af7/X44b0 Thermal Properties of Icy Satellites S CHECK WVR 18.393055194722795 0.8091368712656031 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.01481.S 4C_-02.55 188.00005374995393 -2.401334720000954 293.1562069709364 60.10090990530022 [6] 0.4846734546629109 31252.866899091514 12m 131.04 2018-01-03 [223.00..225.00GHz,31250.00kHz,2.3mJy/beam@10km/s,139.9uJy/beam@native, XX YY] U [225.00..227.00GHz,31250.00kHz,2.4mJy/beam@10km/s,144.7uJy/beam@native, XX YY] U [239.00..241.00GHz,31250.00kHz,2.3mJy/beam@10km/s,147.1uJy/beam@native, XX YY] U [241.00..243.00GHz,31250.00kHz,2.3mJy/beam@10km/s,149.3uJy/beam@native, XX YY] 38554.79638620068 XX YY 2016-12-04 10:15:36 Meyer, Eileen 4C_-02.5_a_06_TM2 Sparks, William; Biretta, John; Chiaberge, Marco; Georganopoulos, Markos; Perlman, Eric; 2.2894885875769013 0.07255872324446358 1.1977398 uid://A001/X885/X99 uid://A001/X885/X9c uid://A002/Xbb5cfb/X202d Measuring the Spectral Evolution, Structure, and Speed of Extragalactic Jets with ALMA S TARGET 27.15268140586815 2.3893734630726966 Y 1 Active Galactic Nuclei (AGN)/Quasars (QSO) Active galaxies 2016.1.01481.S 2015.1.00932.S 4C_-02.55 188.0000666699748 -2.4013316700002503 293.15623164399733 60.10091487259378 [3] 0.3588505609940048 31251.114941595933 12m 241.92 2018-03-25 [89.49..91.49GHz,31250.00kHz,2.2mJy/beam@10km/s,86.1uJy/beam@native, XX YY] U [91.43..93.43GHz,31250.00kHz,2.2mJy/beam@10km/s,85.9uJy/beam@native, XX YY] U [101.49..103.49GHz,31250.00kHz,2.1mJy/beam@10km/s,87.8uJy/beam@native, XX YY] U [103.49..105.49GHz,31250.00kHz,2.1mJy/beam@10km/s,88.8uJy/beam@native, XX YY] 88812.2271503024 XX YY 2016-09-22 15:58:35 Meyer, Eileen 4C_-02.5_a_03_TE Sparks, William; Biretta, John; Georganopoulos, Markos; Perlman, Eric; 2.123728019673837 0.04356481392534444 2.243976 uid://A001/X2f6/X1f4 uid://A001/X2f6/X1f5 uid://A002/Xb87877/X4255 Measuring the Spectral Evolution, Structure, and Speed of Extragalactic Jets with ALMA S TARGET 65.28631517153607 1.9073254847361947 Y 2 Active Galactic Nuclei (AGN)/Quasars (QSO), Outflows, jets, feedback Active galaxies 2015.1.00932.S 2016.1.00691.S J1232-0224 188.00006670827543 -2.4013319611132498 293.15623180821103 60.10091459061739 [6] 0.2879635762580682 31250.32696554087 12m 60.48 2018-07-18 [223.00..225.00GHz,31250.00kHz,3.2mJy/beam@10km/s,194.9uJy/beam@native, XX YY] U [225.00..227.00GHz,31250.00kHz,3.3mJy/beam@10km/s,201.4uJy/beam@native, XX YY] U [239.00..241.00GHz,31250.00kHz,3.2mJy/beam@10km/s,203.4uJy/beam@native, XX YY] U [241.00..243.00GHz,31250.00kHz,3.2mJy/beam@10km/s,206.1uJy/beam@native, XX YY] 38554.79638620068 XX YY 2016-10-25 11:55:50 de Kleer, Katherine Callisto_b_06_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 3.18817504393155 0.10066608518208404 0.4534044 uid://A001/X88e/X244 uid://A001/X88e/X245 uid://A002/Xb9cc97/X2935 Thermal Properties of Icy Satellites S PHASE WVR 27.15488829498547 1.463877364960932 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.00691.S J1232-0224 188.00006670827793 -2.4013319611128083 293.1562318082158 60.10091459061822 [7] 0.18277057986902134 31250.513929342796 12m 60.48 2018-07-19 [335.49..337.49GHz,31250.00kHz,4.3mJy/beam@10km/s,324.6uJy/beam@native, XX YY] U [337.43..339.43GHz,31250.00kHz,4.3mJy/beam@10km/s,322.4uJy/beam@native, XX YY] U [347.49..349.49GHz,31250.00kHz,4.3mJy/beam@10km/s,330.6uJy/beam@native, XX YY] U [349.49..351.49GHz,31250.00kHz,4.4mJy/beam@10km/s,335.2uJy/beam@native, XX YY] 26653.960581232415 XX YY 2016-10-25 12:16:01 de Kleer, Katherine Europa_b_07_TM1 Moreno, Raphael; Gurwell, Mark; Butler, Bryan; de Pater, Imke; Moullet, Arielle; 4.290621535421468 0.16404076554179486 0.44659188 uid://A001/X88e/X232 uid://A001/X88e/X233 uid://A002/Xb9cc97/X29d6 Thermal Properties of Icy Satellites S PHASE WVR 18.394149435938886 0.92912346182028 Y 0 Solar system - Planetary surfaces Solar system 2016.1.00691.S 2016.1.01481.S 4C_-02.55 188.0000537499869 -2.401334720000067 293.15620697100144 60.10090990530606 [6] 0.1993759526677019 31251.791013235503 12m 423.36 2018-08-03 [223.00..225.00GHz,31250.00kHz,1.2mJy/beam@10km/s,76.2uJy/beam@native, XX YY] U [225.00..227.00GHz,31250.00kHz,1.3mJy/beam@10km/s,78.8uJy/beam@native, XX YY] U [239.00..241.00GHz,31250.00kHz,1.3mJy/beam@10km/s,79.8uJy/beam@native, XX YY] U [241.00..243.00GHz,31250.00kHz,1.3mJy/beam@10km/s,80.9uJy/beam@native, XX YY] 38554.79638620068 XX YY 2017-07-02 21:45:44 Meyer, Eileen 4C_-02.5_a_06_TM1 Sparks, William; Biretta, John; Chiaberge, Marco; Georganopoulos, Markos; Perlman, Eric; 1.2467274249544975 0.03942848152947079 0.76258063 uid://A001/X885/X99 uid://A001/X885/X9a uid://A002/Xc19d6f/X3982 Measuring the Spectral Evolution, Structure, and Speed of Extragalactic Jets with ALMA S TARGET 27.153616174242387 1.0922737541846483 Y 1 Active Galactic Nuclei (AGN)/Quasars (QSO) Active galaxies 2016.1.01481.S 2016.1.01481.S 4C_-02.55 188.0000537500501 -2.4013347200012594 293.15620697112706 60.10090990531445 [3] 0.25636888174813444 31251.554159841544 12m 235.872 2018-09-06 [89.49..91.49GHz,31250.00kHz,1.9mJy/beam@10km/s,73.1uJy/beam@native, XX YY] U [91.43..93.43GHz,31250.00kHz,1.9mJy/beam@10km/s,72.9uJy/beam@native, XX YY] U [101.49..103.49GHz,31250.00kHz,1.8mJy/beam@10km/s,74.1uJy/beam@native, XX YY] U [103.49..105.49GHz,31250.00kHz,1.8mJy/beam@10km/s,74.8uJy/beam@native, XX YY] 88812.2271503024 XX YY 2017-08-18 21:05:21 Meyer, Eileen 4C_-02.5_a_03_TM1 Sparks, William; Biretta, John; Chiaberge, Marco; Georganopoulos, Markos; Perlman, Eric; 1.7911881151063198 0.03686192807545294 0.93644416 uid://A001/X885/X93 uid://A001/X885/X94 uid://A002/Xc384d6/X221 Measuring the Spectral Evolution, Structure, and Speed of Extragalactic Jets with ALMA S TARGET 65.28539761906283 1.663110737819156 Y 1 Active Galactic Nuclei (AGN)/Quasars (QSO) Active galaxies 2016.1.01481.S 2016.1.00387.S J1232-0224 188.00006670832093 -2.4013319611111634 293.1562318083005 60.100914590626324 [4] 0.24205224053914035 3906.2759954449675 12m 60.48 2018-10-06 [142.60..144.48GHz,3906.25kHz,3.7mJy/beam@10km/s,187.1uJy/beam@native, XX YY] U [144.30..146.18GHz,3906.25kHz,3.7mJy/beam@10km/s,187.8uJy/beam@native, XX YY] U [154.60..156.48GHz,3906.25kHz,3.6mJy/beam@10km/s,189.1uJy/beam@native, XX YY] U [156.30..158.18GHz,3906.25kHz,3.6mJy/beam@10km/s,189.8uJy/beam@native, XX YY] 7403.461990330225 XX YY 2016-10-15 14:54:28 Sakamoto, Kazushi NGC4418_e_04_TM1 Mangum, Jeffrey; Aalto, Susanne; Muller, Sebastien; Martin, Sergio; Harada, Nanase; Evans, Aaron; Costagliola, Francesco; Gonzalez-Alfonso, Eduardo; Ohyama, Youichi; 3.5885157309568028 0.09423328951678477 0.68998814 uid://A001/X87d/X224 uid://A001/X87d/X225 uid://A002/Xb97224/X21bd Spectral Scan on A Compact Obscured Nucleus S CHECK WVR 42.153673996936114 1.0778886390008189 Y 0 Galaxy chemistry, Luminous and Ultra-Luminous Infra-Red Galaxies (LIRG & ULIRG) Galaxy evolution 2016.1.00387.S
In [8]:
proj3 = []
proj4 = []
proj6 = []
proj7 = []
proj8 = []
proj9 = []
projelse = []
for i, p, in enumerate(table['Project code']):
if table['Band'][i][0] == 3:
proj3.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 4:
proj4.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 6:
proj6.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 7:
proj7.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 8:
proj8.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 9:
proj9.append([p, table['Band'][i][0], table['Integration'][i]])
else:
projelse.append([p, table['Band'][i][0], table['Integration'][i]])
In [9]:
print("Band3:")
for i in proj3:
print(i)
print("Band4:")
for i in proj4:
print(i)
print("Band6:")
for i in proj6:
print(i)
print("Band7:")
for i in proj7:
print(i)
print("Band8:")
for i in proj8:
print(i)
print("Band9:")
for i in proj9:
print(i)
print("Else:")
for i in projelse:
print(i)
Band3:
['2015.1.00820.S', 3, 181.44]
['2016.1.01481.S', 3, 66.528]
['2015.1.00932.S', 3, 241.92]
['2016.1.01481.S', 3, 235.872]
Band4:
['2016.1.00387.S', 4, 60.48]
Band6:
['2015.1.00932.S', 6, 181.44]
['2016.1.00691.S', 6, 60.48]
['2015.1.00872.S', 6, 60.48]
['2016.1.00691.S', 6, 60.48]
['2016.1.01481.S', 6, 131.04]
['2016.1.00691.S', 6, 60.48]
['2016.1.01481.S', 6, 423.36]
Band7:
['2015.1.00042.S', 7, 241.92]
['2016.1.00691.S', 7, 60.48]
['2016.1.00691.S', 7, 60.48]
['2016.1.00691.S', 7, 60.48]
['2016.1.00691.S', 7, 60.48]
['2016.1.00691.S', 7, 60.48]
Band8:
Band9:
Else:
In [10]:
projs = [proj3, proj4, proj6, proj7, proj8, proj9, projelse]
bname = ['3', '4', '6', '7', '8', '9', 'else']
In [11]:
for i, arr in enumerate(projs):
pband = []
for p in arr:
pband.append(p[0])
setpband = set(pband)
print("'''Band "+bname[i]+"''':\n")
for p in setpband:
print("[["+p+"]]\n")
print("\n")
'''Band 3''':
[[2015.1.00820.S]]
[[2016.1.01481.S]]
[[2015.1.00932.S]]
'''Band 4''':
[[2016.1.00387.S]]
'''Band 6''':
[[2016.1.01481.S]]
[[2015.1.00872.S]]
[[2015.1.00932.S]]
[[2016.1.00691.S]]
'''Band 7''':
[[2015.1.00042.S]]
[[2016.1.00691.S]]
'''Band 8''':
'''Band 9''':
'''Band else''':
In [12]:
#table[10]
In [ ]:
Content source: bosscha/alma-calibrator
Similar notebooks: