ApJdataFrames
Dupuy2012Title
: THE HAWAII INFRARED PARALLAX PROGRAM. I. ULTRACOOL BINARIES AND THE L/T TRANSITION
Authors
: Trent J Dupuy and Michael C Liu
Data is from this paper:
http://iopscience.iop.org/0067-0049/201/2/19/
and this website:
http://www.as.utexas.edu/~tdupuy/plx/Database_of_Ultracool_Parallaxes.html
In [1]:
%pylab inline
import seaborn as sns
In [2]:
import warnings
warnings.filterwarnings("ignore")
In [3]:
import pandas as pd
pd.options.display.max_columns = 150
In [4]:
names = ["Object name (LaTeX-able)","Opt SpT","NIR SpT","SpT Refs","flag","RA (deg)","Dec (deg)",
"Epoch (JD)","plx","eplx","PMtot","ePM","PM_PA","ePA","PlxRef","gmag","egmag","rmag","ermag",
"imag","eimag","zmag","ezmag","Ref","Ymag","eYmag","Jmag","eJmag","Hmag","eHmag","Kmag","eKmag",
"Lmag","eLmag","Mmag","eMmag","J2mag","eJ2mag","H2mag","eH2mag","K2mag","eK2mag","MKO+2MASS Refs",
"CH1mag","eCH1mag","CH2mag","eCH2mag", "CH3mag","eCH3mag", "CH4mag","eCH4mag","W1mag", "eW1mag","W2mag",
"eW2mag","W3mag", "eW3mag","W4mag","eW4mag", "nb na cc ext var qual","MIR Refs", "sysID",
"bin", "compsep","HST/AO","HST/AO Refs"]
In [5]:
url_address = "http://www.as.utexas.edu/~tdupuy/plx/Database_of_Ultracool_Parallaxes_files/vlm-plx-all.txt"
tbl = pd.read_csv(url_address, skiprows=1, names = names, sep='[ ]{2,}')
In [6]:
tbl.head()
Out[6]:
In [7]:
names = ["Ref", "Excel code", "ADS Bibtex Key" ]
url_refs = "http://www.as.utexas.edu/~tdupuy/plx/Database_of_Ultracool_Parallaxes_files/vlm-plx-refs.txt"
refs = pd.read_csv(url_refs, skiprows=1, names = names, sep='[ ]{2,}')
In [8]:
refs.head()
Out[8]:
The end.