| Column Number | Column | Description |
|---|---|---|
| 1 | CATAID | Unique GAMA object ID |
| 2 | OBJID_SDSSDR7 | centered |
| 3 | RA | right-aligned |
| 4 | DEC | right-aligned |
| 5 | KRON_RADIUS | right-aligned |
| 6 | PETRO_RADIUS | right-aligned |
| 7 | FLUX_AUTO_U | right-aligned |
| 8 | FLUXERR_AUTO_U | right-aligned |
| 9 | MAG_AUTO_U | right-aligned |
| 10 | MAGERR_AUTO_U | right-aligned |
| 11 | MAG_PETRO_U | right-aligned |
| 12 | MAGERR_PETRO_U | right-aligned |
| 13 | MAG_AUTO_G | right-aligned |
| 14 | MAGERR_AUTO_G | right-aligned |
| 15 | MAG_PETRO_G | right-aligned |
| 16 | MAGERR_PETRO_G | right-aligned |
| 17 | MAG_AUTO_R | right-aligned |
| 18 | MAGERR_AUTO_R | right-aligned |
| 19 | MAG_PETRO_R | right-aligned |
| 20 | MAGERR_PETRO_R | right-aligned |
| 21 | MAG_AUTO_I | right-aligned |
| 22 | MAGERR_AUTO_I | right-aligned |
| 23 | MAG_PETRO_I | right-aligned |
| 24 | MAGERR_PETRO_I | right-aligned |
| 25 | MAG_AUTO_Z | right-aligned |
| 26 | MAGERR_AUTO_Z | right-aligned |
| 27 | MAG_PETRO_Z | right-aligned |
| 28 | MAGERR_PETRO_Z | right-aligned |
| 29 | MAG_AUTO_Y | right-aligned |
| 30 | MAGERR_AUTO_Y | right-aligned |
| 31 | MAG_PETRO_Y | right-aligned |
| 32 | MAGERR_PETRO_Y | right-aligned |
| 33 | MAG_AUTO_J | right-aligned |
| 34 | MAGERR_AUTO_J | right-aligned |
| 35 | MAG_PETRO_J | right-aligned |
| 36 | MAGERR_PETRO_J | right-aligned |
| 37 | MAG_AUTO_H | right-aligned |
| 38 | MAGERR_AUTO_H | right-aligned |
| 39 | MAG_PETRO_H | right-aligned |
| 40 | MAGERR_PETRO_H | right-aligned |
| 41 | MAG_AUTO_K | right-aligned |
| 42 | MAGERR_AUTO_K | right-aligned |
| 43 | MAG_PETRO_K | right-aligned |
| 44 | MAGERR_PETRO_K | right-aligned |
| 45 | BEST_MAG_NUV | right-aligned |
| 46 | BEST_MAGERR_NUV | right-aligned |
| 47 | BEST_MAG_FUV | right-aligned |
| 48 | BEST_MAGERR_FUV | right-aligned |
| 49 | NMATCHUV | right-aligned |
| 50 | NMATCHOPT | right-aligned |
| 51 | NUVFLAG | right-aligned |
| 52 | TOT_MAG_NUV | right-aligned |
| 53 | TOT_MAGERR_NUV | right-aligned |
| 54 | TOT_MAG_FUV | right-aligned |
| 55 | TOT_MAGERR_FUV | right-aligned |
| 56 | SPLIT_MAG_NUV | right-aligned |
| 57 | SPLIT_MAGERR_NUV | right-aligned |
| 58 | SPLIT_MAG_FUV | right-aligned |
| 59 | SPLIT_MAGERR_FUV | right-aligned |
| 60 | COG_MAG_NUV | right-aligned |
| 61 | COG_MAGERR_NUV | right-aligned |
| 62 | NN_DIST | right-aligned |
| 63 | NN_NMATCH4 | right-aligned |
| 64 | Column1 | CATAID repetition |
| 65 | SPLIT_MAG_NUV | right-aligned | | 66 | SPLIT_MAGERR_NUV | right-aligned | | 67 | SPLIT_MAG_FUV | right-aligned | | 68 | SPLIT_MAGERR_FUV | right-aligned | | 60 | COG_MAG_NUV | right-aligned | | 61 | COG_MAGERR_NUV | right-aligned | | 62 | NN_DIST | right-aligned | | 63 | NN_NMATCH4 | right-aligned | | 64 | Column1 | right-aligned |
SEX_INDEX_U,SEX_INDEX_G,SEX_INDEX_R,SEX_INDEX_I,SEX_INDEX_Z, SEX_INDEX_Y,SEX_INDEX_J,SEX_INDEX_H,SEX_INDEX_K,
CATAID,OBJID_SDSSDR7,RA,DEC,KRON_RADIUS,PETRO_RADIUS,FLUX_AUTO_U,FLUXERR_AUTO_U, MAG_AUTO_U,MAGERR_AUTO_U,MAG_PETRO_U,MAGERR_PETRO_U, MAG_AUTO_G,MAGERR_AUTO_G,MAG_PETRO_G,MAGERR_PETRO_G, MAG_AUTO_R,MAGERR_AUTO_R,MAG_PETRO_R,MAGERR_PETRO_R, MAG_AUTO_I,MAGERR_AUTO_I,MAG_PETRO_I,MAGERR_PETRO_I, MAG_AUTO_Z,MAGERR_AUTO_Z,MAG_PETRO_Z,MAGERR_PETRO_Z, MAG_AUTO_Y,MAGERR_AUTO_Y,MAG_PETRO_Y,MAGERR_PETRO_Y, MAG_AUTO_J,MAGERR_AUTO_J,MAG_PETRO_J,MAGERR_PETRO_J, MAG_AUTO_H,MAGERR_AUTO_H,MAG_PETRO_H,MAGERR_PETRO_H, MAG_AUTO_K,MAGERR_AUTO_K,MAG_PETRO_K,MAGERR_PETRO_K, BEST_MAG_NUV,BEST_MAGERR_NUV,BEST_MAG_FUV,BEST_MAGERR_FUV, NMATCHUV,NMATCHOPT,NUVFLAG,FUVFLAG,TOT_MAG_NUV,TOT_MAGERR_NUV,TOT_MAG_FUV,TOT_MAGERR_FUV, SPLIT_MAG_NUV,SPLIT_MAGERR_NUV,SPLIT_MAG_FUV,SPLIT_MAGERR_FUV,COG_MAG_NUV,COG_MAGERR_NUV, NN_DIST,NN_NMATCH4, Column1, SEX_INDEX_U,SEX_INDEX_G,SEX_INDEX_R,SEX_INDEX_I,SEX_INDEX_Z, SEX_INDEX_Y,SEX_INDEX_J,SEX_INDEX_H,SEX_INDEX_K, GAL_INDEX_U,GAL_INDEX_G,GAL_INDEX_R,GAL_INDEX_I,GAL_INDEX_Z, GAL_INDEX_Y,GAL_INDEX_J,GAL_INDEX_H,GAL_INDEX_K, GAL_ELLIP_R,GAL_CHI2_R,GAL_QFLAG_R,FILENAME,URL,URL_R,URL_K, U_MODEL,U_MODEL_ERR,G_MODEL,G_MODEL_ERR,R_MODEL,R_MODEL_ERR,I_MODEL,I_MODEL_ERR,Z_MODEL,Z_MODEL_ERR, KCORR_FUV_k0,KCORR_NUV_k0,KCORR_U_k0,KCORR_G_k0,KCORR_R_k0,KCORR_I_k0,KCORR_Z_k0,KCORR_Y_k0, KCORR_J_k0,KCORR_H_k0,KCORR_K_k0,CHI2_k0,MASS_k0,INTSFH_k0,METS_k0,B300_k0,B1000_k0 KCORR_FUV_k1,KCORR_NUV_k1,KCORR_U_k1,KCORR_G_k1,KCORR_R_k1,KCORR_I_k1,KCORR_Z_k1,KCORR_Y_k1, KCORR_J_k1,KCORR_H_k1,KCORR_K_k1,CHI2_k1,MASS_k1,INTSFH_k1,METS_k1,B300_k1,B1000_k1, Column2, EBV,A_FUV,A_NUV,A_B,A_u,A_g,A_r,A_i,A_z, Column3, A_Y,A_J,A_H,A_K,Column4, SPECID_BEST,Z_HELIO, MAG_AB_FUV,MAG_AB_NUV,MAG_AB_U,MAG_AB_G,MAG_AB_R,MAG_AB_I,MAG_AB_Z,MAG_AB_Y,MAG_AB_J,MAG_AB_H,MAG_AB_K, MAG_ABSOLUTE_FUV,MAG_ABSOLUTE_NUV,MAG_ABSOLUTE_U,MAG_ABSOLUTE_G,MAG_ABSOLUTE_R,MAG_ABSOLUTE_I,MAG_ABSOLUTE_Z, MAG_ABSOLUTE_Y,MAG_ABSOLUTE_J,MAG_ABSOLUTE_H,MAG_ABSOLUTE_K, UV_CLASS_YI2011
| 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned | | 18 | MAGERR_PETRO_U | right-aligned |
In [1]:
import numpy as np
import pandas as pd
In [20]:
my_data = np.loadtxt('../Catalogue/Match07_smalldoubleclean_emlines.csv', delimiter=',', dtype=str)
my_data2 = np.loadtxt('../Match/Match07_Match06small.csv', delimiter=',', dtype=str)
In [4]:
print my_data[0,:]
In [21]:
header = my_data[0,:]
header2 = my_data2[0,:]
In [22]:
print header.size
print header2.size
In [19]:
schema = []
for i in range(header.size):
line = '|%15d' '|%20s| |'
lines = (line % (i, header[i]))
print lines
schema.append(lines)
print >> '../Catalogue/headers.txt', object(schema)
| Column Number | Column | Description |
|---|---|---|
| 0 | CATAID | Unique GAMA object ID |
| 1 | OBJID_SDSSDR7 | SDSS DR7 objid |
| 2 | RA | J2000 coordinate |
| 3 | DEC | J2000 coordinate |
| 4 | KRON_RADIUS | Kron radius (r band) |
| 5 | PETRO_RADIUS | Petrosian radius (r band) |
| 6 | FLUX_AUTO_U | Kron flux (u band) |
| 7 | FLUXERR_AUTO_U | Kron flux error (u band) |
| 8 | MAG_AUTO_U | Kron magnitude (u band) |
| 9 | MAGERR_AUTO_U | Kron magnitude error (u band) |
| 10 | MAG_PETRO_U | Petrosian magnitude (u band) |
| 11 | MAGERR_PETRO_U | Petrosian magnitude error (u band) |
| 12 | MAG_AUTO_G | Kron magnitude (g band) |
| 13 | MAGERR_AUTO_G | Kron magnitude error (g band) |
| 14 | MAG_PETRO_G | Petrosian magnitude (g band) |
| 15 | MAGERR_PETRO_G | Petrosian magnitude error (g band) |
| 16 | MAG_AUTO_R | Kron magnitude (r band) |
| 17 | MAGERR_AUTO_R | Kron magnitude error (r band) |
| 18 | MAG_PETRO_R | Petrosian magnitude (r band) |
| 19 | MAGERR_PETRO_R | Petrosian magnitude error (r band) |
| 20 | MAG_AUTO_I | Kron magnitude (i band) |
| 21 | MAGERR_AUTO_I | Kron magnitude error (i band) |
| 22 | MAG_PETRO_I | Petrosian magnitude (i band) |
| 23 | MAGERR_PETRO_I | Petrosian magnitude error (i band) |
| 24 | MAG_AUTO_Z | Kron magnitude (z band) |
| 25 | MAGERR_AUTO_Z | Kron magnitude error (z band) |
| 26 | MAG_PETRO_Z | Petrosian magnitude (z band) |
| 27 | MAGERR_PETRO_Z | Petrosian magnitude error (z band) |
| 28 | MAG_AUTO_Y | Kron magnitude (Y band) |
| 29 | MAGERR_AUTO_Y | Kron magnitude error (Y band) |
| 30 | MAG_PETRO_Y | Petrosian magnitude (Y band) |
| 31 | MAGERR_PETRO_Y | Petrosian magnitude error (Y band) |
| 32 | MAG_AUTO_J | Kron magnitude (J band) |
| 33 | MAGERR_AUTO_J | Kron magnitude error (J band) |
| 34 | MAG_PETRO_J | Petrosian magnitude (J band) |
| 35 | MAGERR_PETRO_J | Petrosian magnitude error (J band) |
| 36 | MAG_AUTO_H | Kron magnitude (H band) |
| 37 | MAGERR_AUTO_H | Kron magnitude error (H band) |
| 38 | MAG_PETRO_H | Petrosian magnitude (H band) |
| 39 | MAGERR_PETRO_H | Petrosian magnitude error (H band) |
| 40 | MAG_AUTO_K | Kron magnitude (K band) |
| 41 | MAGERR_AUTO_K | Kron magnitude error (K band) |
| 42 | MAG_PETRO_K | Petrosian magnitude (K band) |
| 43 | MAGERR_PETRO_K | Petrosian magnitude error (K band) |
| 44 | BEST_MAG_NUV | Best estimate of the GAMA object's NUV magnitude |
| 45 | BEST_MAGERR_NUV | Best estimate of the GAMA object's NUV magnitude error |
| 46 | BEST_MAG_FUV | Best estimate of the GAMA object's FUV magnitude |
| 47 | BEST_MAGERR_FUV | Best estimate of the GAMA object's NUV magnitude error |
| 48 | NMATCHUV | |
| 49 | NMATCHOPT | |
| 50 | NUVFLAG | |
| 51 | FUVFLAG | |
| 52 | TOT_MAG_NUV | |
| 53 | TOT_MAGERR_NUV | |
| 54 | TOT_MAG_FUV | |
| 55 | TOT_MAGERR_FUV | |
| 56 | SPLIT_MAG_NUV | |
| 57 | SPLIT_MAGERR_NUV | |
| 58 | SPLIT_MAG_FUV | |
| 59 | SPLIT_MAGERR_FUV | |
| 60 | COG_MAG_NUV | |
| 61 | COG_MAGERR_NUV | |
| 62 | NN_DIST | |
| 63 | NN_NMATCH4 | |
| 64 | Column1 | Repetition of CATAID |
| 65 | SEX_INDEX_U | |
| 66 | SEX_INDEX_G | |
| 67 | SEX_INDEX_R | |
| 68 | SEX_INDEX_I | |
| 69 | SEX_INDEX_Z | |
| 70 | SEX_INDEX_Y | |
| 71 | SEX_INDEX_J | |
| 72 | SEX_INDEX_H | |
| 73 | SEX_INDEX_K | |
| 74 | GAL_INDEX_U | |
| 75 | GAL_INDEX_G | |
| 76 | GAL_INDEX_R | |
| 77 | GAL_INDEX_I | |
| 78 | GAL_INDEX_Z | |
| 79 | GAL_INDEX_Y | |
| 80 | GAL_INDEX_J | |
| 81 | GAL_INDEX_H | |
| 82 | GAL_INDEX_K | |
| 83 | GAL_ELLIP_R | |
| 84 | GAL_CHI2_R | |
| 85 | GAL_QFLAG_R | |
| 86 | FILENAME | |
| 87 | URL | |
| 88 | URL_R | |
| 89 | URL_K | |
| 90 | U_MODEL | |
| 91 | U_MODEL_ERR | |
| 92 | G_MODEL | |
| 93 | G_MODEL_ERR | |
| 94 | R_MODEL | |
| 95 | R_MODEL_ERR | |
| 96 | I_MODEL | |
| 97 | I_MODEL_ERR | |
| 98 | Z_MODEL | |
| 99 | Z_MODEL_ERR | |
| 100 | KCORR_FUV_k0 | |
| 101 | KCORR_NUV_k0 | |
| 102 | KCORR_U_k0 | |
| 103 | KCORR_G_k0 | |
| 104 | KCORR_R_k0 | |
| 105 | KCORR_I_k0 | |
| 106 | KCORR_Z_k0 | |
| 107 | KCORR_Y_k0 | |
| 108 | KCORR_J_k0 | |
| 109 | KCORR_H_k0 | |
| 110 | KCORR_K_k0 | |
| 111 | CHI2_k0 | |
| 112 | MASS_k0 | |
| 113 | INTSFH_k0 | |
| 114 | METS_k0 | |
| 115 | B300_k0 | |
| 116 | B1000_k0 | |
| 117 | KCORR_FUV_k1 | |
| 118 | KCORR_NUV_k1 | |
| 119 | KCORR_U_k1 | |
| 120 | KCORR_G_k1 | |
| 121 | KCORR_R_k1 | |
| 122 | KCORR_I_k1 | |
| 123 | KCORR_Z_k1 | |
| 124 | KCORR_Y_k1 | |
| 125 | KCORR_J_k1 | |
| 126 | KCORR_H_k1 | |
| 127 | KCORR_K_k1 | |
| 128 | CHI2_k1 | |
| 129 | MASS_k1 | |
| 130 | INTSFH_k1 | |
| 131 | METS_k1 | |
| 132 | B300_k1 | |
| 133 | B1000_k1 | |
| 134 | Column2 | |
| 135 | EBV | |
| 136 | A_FUV | |
| 137 | A_NUV | |
| 138 | A_B | |
| 139 | A_u | |
| 140 | A_g | |
| 141 | A_r | |
| 142 | A_i | |
| 143 | A_z | |
| 144 | Column3 | |
| 145 | A_Y | |
| 146 | A_J | |
| 147 | A_H | |
| 148 | A_K | |
| 149 | Column4 | |
| 150 | SPECID_BEST | |
| 151 | Z_HELIO | |
| 152 | MAG_AB_FUV | |
| 153 | MAG_AB_NUV | |
| 154 | MAG_AB_U | |
| 155 | MAG_AB_G | |
| 156 | MAG_AB_R | |
| 157 | MAG_AB_I | |
| 158 | MAG_AB_Z | |
| 159 | MAG_AB_Y | |
| 160 | MAG_AB_J | |
| 161 | MAG_AB_H | |
| 162 | MAG_AB_K | |
| 163 | MAG_ABSOLUTE_FUV | |
| 164 | MAG_ABSOLUTE_NUV | |
| 165 | MAG_ABSOLUTE_U | |
| 166 | MAG_ABSOLUTE_G | |
| 167 | MAG_ABSOLUTE_R | |
| 168 | MAG_ABSOLUTE_I | |
| 169 | MAG_ABSOLUTE_Z | |
| 170 | MAG_ABSOLUTE_Y | |
| 171 | MAG_ABSOLUTE_J | |
| 172 | MAG_ABSOLUTE_H | |
| 173 | MAG_ABSOLUTE_K | |
| 174 | UV_CLASS_YI2011 |
In [ ]:
schema = []
for i in range(header.size):
line = '|%15d' '|%20s| |'
lines = (line % (i, header[i]))
print lines
schema.append(lines)