ApJdataFrames
Wilking2005Title
: Optical Spectroscopy of the Surface Population of the ρ Ophiuchi Molecular Cloud: The First Wave of Star Formation
Authors
: Wilking et al.
Data is from this paper:
http://iopscience.iop.org/1538-3881/130/4/1733/fulltext/
In [1]:
import warnings
warnings.filterwarnings("ignore")
In [2]:
from astropy.io import ascii
In [3]:
import pandas as pd
In [4]:
tbl2_vo = ascii.read("http://iopscience.iop.org/1538-3881/130/4/1733/fulltext/datafile2.txt")
tbl2_vo[0:3]
Out[4]:
In [5]:
tbl4_vo = ascii.read("http://iopscience.iop.org/1538-3881/130/4/1733/fulltext/datafile4.txt")
tbl4_vo[0:4]
Out[5]:
In [6]:
tbl2 = tbl2_vo.to_pandas()
del tbl2["Name"]
tbl2.rename(columns={'Note':"Flag"}, inplace=True)
tbl4 = tbl4_vo.to_pandas()
In [7]:
wilking2005 = pd.merge(tbl2, tbl4, how="right", on=["Field", "Aper"])
In [8]:
wilking2005
Out[8]:
In [14]:
wilking2005["RA"] = wilking2005.RAh.astype(str) + wilking2005.RAm.astype(str) + wilking2005.RAs.astype(str)
In [15]:
wilking2005.RA
Out[15]:
In [9]:
! mkdir ../data/Wilking2005
In [10]:
wilking2005.to_csv("../data/Wilking2005/Wilking2005.csv", index=False, sep='\t')
The end