Infrared Galaxy Catalog

This is a catalog of galaxy properties with measured sizes and luminosities in many infrared wavebands. Note that all of these magnitudes are absolute magnitudes, so the effect of distance has been removed. The galaxies are selected from the UKIDSS Large Area Survey and matched with SDSS and WISE in Devour and Bell 2019. The matches include inclinations from disk/bulge fits by Simard et al 2011, so that the effects of dust can be tested. The catalog is kept in 3 matched files, corresponding to Tables 2, 3 and 4 from Devour and Bell 2019. Table2 contains the galaxy half light radii, 90% of the light radii and the ratio of the two called cx. It also contains errors of all those properties. Table3 contains the WISE magnitudes as well as the Kmag for each galaxy while Table4 contains SDSS magnitudes as well as r-band measurements of the sizes, the axis ratio ab and the bulge to total ratio bt of the galaxy along with its redshift (z) and distance (Dist).

The follow code will read the files, covert them to pandas DataFrames and combine them into one DataFrame.
import numpy as np
import pandas as pd
data = np.loadtxt('apjsab339ct2_mrt.txt',skiprows=30)
df1 = pd.DataFrame(data,columns=['OBJID','RAdeg','DEdeg','x50', 'e_x50','x90', 'e_x90','cx','e_cx','flag'])
data = np.loadtxt('apjsab339ct3_mrt.txt',skiprows=20)
df2 = pd.DataFrame(data,columns=['OBJID','RAdeg','DEdeg','W1Mag', 'W2Mag','W3Mag', 'W3-W1','Kmag'])
df2.drop(['OBJID','RAdeg','DEdeg'],axis=1,inplace=True)
data = np.loadtxt('apjsab339ct4_mrt.txt',skiprows=31)
df3 = pd.DataFrame(data,columns=['OBJID','RAdeg','DEdeg','uMag', 'gMag','rMag', 'iMag','zMag','r-pet','r-50','r-90','c','f-dev','ab','bt','z','Dist'])
df3.drop(['OBJID','RAdeg','DEdeg'],axis=1,inplace=True)
df= pd.concat([df1,df2,df3],axis=1)