`ApJdataFrames` 013: Lada2006

Title: Spitzer Observations of IC 348: The Disk Population at 2-3 Million Years
Authors: Charles J Lada, August A Muench, Kevin L Luhman, Lori E Allen, Lee Hartmann, Tom Megeath, Philip Myers, Giovanni Fazio, Kenneth Wood, James Muzerolle, George Rieke, Nick Siegler, and Erick Young

Data is from this paper:
http://iopscience.iop.org/1538-3881/131/3/1574/fulltext/204953.html



In [1]:

    
%pylab inline
import seaborn as sns









    



Populating the interactive namespace from numpy and matplotlib



In [2]:

    
import warnings
warnings.filterwarnings("ignore")



In [3]:

    
import pandas as pd



In [7]:

    
from astropy.io import ascii
from astropy.table import Table, join

Table 1 - Spitzer IRAC/MIPS IC348 catalog



In [5]:

    
tbl1 = ascii.read("http://iopscience.iop.org/1538-3881/131/3/1574/fulltext/datafile1.txt")
tbl1[0:4]









    



Downloading http://iopscience.iop.org/1538-3881/131/3/1574/fulltext/datafile1.txt [Done]






    Out[5]:




<Table masked=True length=4>

Seq RAh RAm RAs DEd DEm DEs 3.6IRACmag e_3.6IRACmag 4.5IRACmag e_4.5IRACmag 5.8IRACmag e_5.8IRACmag 8.0IRACmag e_8.0IRACmag 24MIPSmag err24MIPSmag BLEND-IRAC BLEND-MIPS
h min s deg arcmin arcsec mag mag mag mag mag mag mag mag mag mag 
int64 int64 int64 float64 int64 int64 float64 float64 float64 float64 float64 float64 float64 float64 float64 float64 float64 int64 int64
1 3 44 34.212 32 9 46.69 6.74 0.01 6.54 0.02 6.58 0.02 6.5 0.03 0.89 -9.0 30191 --
2 3 44 35.364 32 10 4.58 7.09 0.02 6.81 0.02 6.46 0.04 5.82 0.04 3.2 0.03 -- --
3 3 44 50.649 32 19 6.75 7.53 0.01 7.61 0.03 7.47 0.04 7.5 0.04 7.08 0.05 -- --
4 3 44 31.188 32 6 22.09 7.79 0.01 7.74 0.02 7.66 0.02 7.73 0.03 4.38 -9.0 -- --

Table 2 - SED Derived $\alpha_{IRAC}$ and $A_V$

But really... spectral types



In [6]:

    
tbl2 = ascii.read("http://iopscience.iop.org/1538-3881/131/3/1574/fulltext/datafile2.txt")
tbl2[0:4]









    



Downloading http://iopscience.iop.org/1538-3881/131/3/1574/fulltext/datafile2.txt [Done]






    Out[6]:




<Table masked=True length=4>

Seq SpType AV alphaIRAC-o erralphaIRAC-o alphaIRAC-d erralphaIRAC-d Nbands STARDISK
mag 
int64 string40 float64 float64 float64 float64 float64 int64 string48
1 B5 3.1 -2.638 0.102 -2.708 0.091 4 STAR
2 A2 3.2 -1.396 0.127 -1.468 0.143 4 THICK
3 A0 3.9 -2.794 0.11 -2.883 0.115 4 STAR
4 F0 2.3 -2.786 0.091 -2.838 0.082 4 STAR



In [11]:

    
join_tbls = join(tbl1, tbl2, keys="Seq")
print "There are {} rows in tbl1, {} in tbl2, and {} in the joined table.".format(len(tbl1), len(tbl2), len(join_tbls))









    



There are 307 rows in tbl1, 307 in tbl2, and 307 in the joined table



In [12]:

    
join_tbls[0:4]









    Out[12]:




<Table masked=True length=4>

Seq RAh RAm RAs DEd DEm DEs 3.6IRACmag e_3.6IRACmag 4.5IRACmag e_4.5IRACmag 5.8IRACmag e_5.8IRACmag 8.0IRACmag e_8.0IRACmag 24MIPSmag err24MIPSmag BLEND-IRAC BLEND-MIPS SpType AV alphaIRAC-o erralphaIRAC-o alphaIRAC-d erralphaIRAC-d Nbands STARDISK
h min s deg arcmin arcsec mag mag mag mag mag mag mag mag mag mag mag 
int64 int64 int64 float64 int64 int64 float64 float64 float64 float64 float64 float64 float64 float64 float64 float64 float64 int64 int64 string40 float64 float64 float64 float64 float64 int64 string48
1 3 44 34.212 32 9 46.69 6.74 0.01 6.54 0.02 6.58 0.02 6.5 0.03 0.89 -9.0 30191 -- B5 3.1 -2.638 0.102 -2.708 0.091 4 STAR
2 3 44 35.364 32 10 4.58 7.09 0.02 6.81 0.02 6.46 0.04 5.82 0.04 3.2 0.03 -- -- A2 3.2 -1.396 0.127 -1.468 0.143 4 THICK
3 3 44 50.649 32 19 6.75 7.53 0.01 7.61 0.03 7.47 0.04 7.5 0.04 7.08 0.05 -- -- A0 3.9 -2.794 0.11 -2.883 0.115 4 STAR
4 3 44 31.188 32 6 22.09 7.79 0.01 7.74 0.02 7.66 0.02 7.73 0.03 4.38 -9.0 -- -- F0 2.3 -2.786 0.091 -2.838 0.082 4 STAR

Table 3 - Convenient passbands table



In [14]:

    
names = ["PASSBAND","DATA SYSTEM","REFERENCES","center_wavelength","F_{nu} (Jy)","References"]
tbl3 = pd.read_csv("http://iopscience.iop.org/1538-3881/131/3/1574/fulltext/204953.tb3.txt", 
                   na_values="\ldots", names = names, sep='\t')
tbl3.head()









    Out[14]:






  
    
      
      PASSBAND
      DATA SYSTEM
      REFERENCES
      center_wavelength
      F_{nu} (Jy)
      References
    
  
  
    
      0
       V_{L}
       Landolt
          1, 2, 3
       0.5423
       3723
        4
    
    
      1
       R_{C}
       Cousins
          1, 2, 3
       0.6410
       3064
        5
    
    
      2
       I_{C}
       Cousins
          1, 2, 3
       0.7890
       2416
        5
    
    
      3
           J
         2MASS
       6, 7, 8, 9
       1.2350
       1594
       10
    
    
      4
           H
         2MASS
       6, 7, 8, 9
       1.6620
       1024
       10

The end.

Seq	RAh	RAm	RAs	DEd	DEm	DEs	3.6IRACmag	e_3.6IRACmag	4.5IRACmag	e_4.5IRACmag	5.8IRACmag	e_5.8IRACmag	8.0IRACmag	e_8.0IRACmag	24MIPSmag	err24MIPSmag	BLEND-IRAC	BLEND-MIPS
	h	min	s	deg	arcmin	arcsec	mag	mag	mag	mag	mag	mag	mag	mag	mag	mag
int64	int64	int64	float64	int64	int64	float64	float64	float64	float64	float64	float64	float64	float64	float64	float64	float64	int64	int64
1	3	44	34.212	32	9	46.69	6.74	0.01	6.54	0.02	6.58	0.02	6.5	0.03	0.89	-9.0	30191	--
2	3	44	35.364	32	10	4.58	7.09	0.02	6.81	0.02	6.46	0.04	5.82	0.04	3.2	0.03	--	--
3	3	44	50.649	32	19	6.75	7.53	0.01	7.61	0.03	7.47	0.04	7.5	0.04	7.08	0.05	--	--
4	3	44	31.188	32	6	22.09	7.79	0.01	7.74	0.02	7.66	0.02	7.73	0.03	4.38	-9.0	--	--

Seq	SpType	AV	alphaIRAC-o	erralphaIRAC-o	alphaIRAC-d	erralphaIRAC-d	Nbands	STARDISK
		mag
int64	string40	float64	float64	float64	float64	float64	int64	string48
1	B5	3.1	-2.638	0.102	-2.708	0.091	4	STAR
2	A2	3.2	-1.396	0.127	-1.468	0.143	4	THICK
3	A0	3.9	-2.794	0.11	-2.883	0.115	4	STAR
4	F0	2.3	-2.786	0.091	-2.838	0.082	4	STAR

	PASSBAND	DATA SYSTEM	REFERENCES	center_wavelength	F_{nu} (Jy)	References
0	V_{L}	Landolt	1, 2, 3	0.5423	3723	4
1	R_{C}	Cousins	1, 2, 3	0.6410	3064	5
2	I_{C}	Cousins	1, 2, 3	0.7890	2416	5
3	J	2MASS	6, 7, 8, 9	1.2350	1594	10
4	H	2MASS	6, 7, 8, 9	1.6620	1024	10

ApJdataFrames 013: Lada2006

Table 1 - Spitzer IRAC/MIPS IC348 catalog

Table 2 - SED Derived $\alpha_{IRAC}$ and $A_V$

Table 3 - Convenient passbands table

`ApJdataFrames` 013: Lada2006