ApJdataFrames
: Allers2006Title
: Young, Low-Mass Brown Dwarfs with Mid-Infrared Excesses
Authors
: AKCJ
Data is from this paper:
http://iopscience.iop.org/0004-637X/644/1/364/
In [1]:
%pylab inline
import seaborn as sns
In [2]:
import warnings
warnings.filterwarnings("ignore")
In [3]:
import pandas as pd
In [5]:
names = ['Source Number','RA (J2000.0)','DEC (J2000.0)','I', 'Ierr','J', 'Jerr',
'H', 'Herr','Ks', 'Kserr','[3.6]', '[3.6]err','[4.5]', '[4.5]err',
'[5.8]', '[5.8]err','[8.0]', '[8.0]err']
tbl3 = pd.read_csv("http://iopscience.iop.org/0004-637X/644/1/364/fulltext/64106.tb3.txt",
sep=r'\t|\\pm', names = names)
tbl3
Out[5]:
Drop source 12 because it was shown to be a galaxy.
In [5]:
tbl3.drop(11, axis=0, inplace=True)
%%bash
mkdir ../data/Allers2006
In [6]:
tbl3.to_csv('../data/Allers2006/tbl3.csv', index=False)
I published the spectral types for Katelyn's 2006 sources in this cool stars proceedings.
The irony is that there is no machine readable table.
In [31]:
mgs2010 = pd.DataFrame([(1, 11.5), (2,6), (4,2), (5,11), (6,5), (7,6),
(8,3),(9,5.5),(10,3),(11,8), (13,6), (14,8), (15,2),
(16,4), (17,12.5),(18,7), (19,4.5)], columns=["Source Number", "SpT"])
In [32]:
out = pd.merge(tbl3, mgs2010, on="Source Number", how="left")
In [34]:
out.head(2)
Out[34]:
In [35]:
out.to_csv("../data/Allers2006/mgs2010_bonus.csv", index=False)
The end.