[AstroPy] problem reading IPAC table
Tommy Grav
tgrav at me.com
Fri Jun 3 13:16:39 EDT 2016
I am trying to read an IPAC table with astropy (after having used atpy that has
stopped being updated). However the reading of the table fails. Can anyone help?
Cheers
Tommy
The code is:
from math import *
from astropy.table import Table
t = Table.read(“IPAC.tbl”,format=“ipac")
print len(t)
The error is:
> python -u plot_observed_fluxes.py
Traceback (most recent call last):
File "plot_observed_fluxes.py", line 5, in <module>
t = Table.read("IPAC_C51_LPC_cryo.tbl",format="ipac")
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/table/table.py", line 2332, in read
return io_registry.read(cls, *args, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/io/registry.py", line 351, in read
data = reader(*args, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/io/ascii/connect.py", line 37, in io_read
return read(filename, format=format, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/io/ascii/ui.py", line 341, in read
dat = reader.read(table)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/io/ascii/core.py", line 1180, in read
table = self.outputter(cols, self.meta)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/io/ascii/core.py", line 972, in __call__
self._convert_vals(cols)
File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/astropy-1.2.dev15585-py2.7-macosx-10.5-x86_64.egg/astropy/io/ascii/core.py", line 959, in _convert_vals
raise ValueError('Column {} failed to convert: {}'.format(col.name, last_err))
ValueError: Column cntr_01 failed to convert: invalid literal for long() with base 10: '\\'
The table is:
`\
\fixlen = T
\RowsRetrieved = 520
\ORIGIN = 'IPAC Infrared Science Archive (IRSA), Caltech/JPL'
\DATETIME= '2016-06-03 08:14:41'
\DATABASE= 'WISE All-Sky Single Exposure (L1b) Source Table (allsky_4band_p1bs_psd)'
\EQUINOX = 'J2000'
\ One to One Match
\NOTE = 'Column names with suffix _01 are from the input file UC51_LPC_gator.tbl.'
\NOTE = 'Column cntr_01 is a sequential counter added to ID each row in the user input file UC51_LPC_gator.tbl.'
\NOTE = 'dist_x is the distance in arcsec between each input source and its potential match in the WISE All-Sky Single Exposure (L1b) Source Table.'
\NOTE = 'pang_x is position angle, measured eastward from north, between the input source and potential match in the WISE All-Sky Single Exposure (L1b) Source Table.
\NOTE = 'Output rows are ordered by increasing cntr_01, and for each cntr_01 by increasing dist_x.'
\StatusFile = '/workspace/TMP_9TwuEY_18921/Gator/irsa/21410/log.21410.html'
\SQL = 'WHERE (no constraints)
\SQL = 'SELECT (52 column names follow in next row.)'
\Upload = 'file=UC51_LPC_gator.tbl radius=10 unit=arcsec'
\
\
| cntr_01| dist_x| pang_x| name_01| jd_01| ra_01| dec_01| sun2sc_x_01| sun2sc_y_01| sun2sc_z_01| w1flag_01| w2flag_01| w3flag_01| w4flag_01| ra| dec| sigra| sigdec| sigradec| w1mpro| w1sigmpro| w1snr| w1rchi2| w2mpro| w2sigmpro| w2snr| w2rchi2| w3mpro| w3sigmpro| w3snr| w3rchi2| w4mpro| w4sigmpro| w4snr| w4rchi2| nb| na| w1sat| w2sat| w3sat| w4sat| cc_flags| ph_qual| sso_flg| mjd| tmass_key| j_m_2mass| j_msig_2mass| h_m_2mass| h_msig_2mass| k_m_2mass| k_msig_2mass|
| long| double| double| char| double| double| double| double| double| double| int| int| int| int| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| double| int| int|double|double|double|double| char| char| int| double| int| double| double| double| double| double| double|
| | arcsec| deg| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null| null|
1 0.702542 -110.190660 CK05L030 55340.27985 176.47433333 41.888555556 -0.46183044709 -0.90117641217 2.5475567468e-05 1 1 1 1 176.4740873 41.8884882 0.3075 0.3074 0.0289 17.001 null null 0.425599992 15.314 null 0.9 0.763000011 11.113 0.430 2.5 1.14699996 5.214 0.050 21.9 10.3500004 1 0 0.000 0.000 0.000 0.000 0000 UUCA 1 55340.279850 null null null null null null null
2 1.191349 23.956278 CK05L030 55340.27998 176.474125 41.889027778 -0.46182849332 -0.90117743975 2.5475581701e-05 1 1 1 1 176.4743055 41.8893302 0.3526 0.3778 -0.0571 16.171 0.331 3.3 0.512700021 15.203 0.349 3.1 0.83950001 10.918 0.330 3.3 1.15400004 5.216 0.064 16.9 6.14099979 2 0 0.000 0.000 0.000 0.000 0000 BBBA 1 55340.279977 null null null null null null null
3 1.120613 -83.712704 CK05L030 55340.54446 176.44183333 41.874611111 -0.45784908896 -0.90325902498 2.5498792038e-05 1 1 1 1 176.4414178 41.8746452 0.4234 0.3977 -0.1026 16.230 0.280 3.9 1.11500001 14.885 null 2.0 0.77609998 10.533 0.236 4.6 1.13399994 5.437 0.071 15.2 5.10500002 2 0 0.000 0.000 0.000 0.000 0000 BUBA 1 55340.544458 null null null null null null null
4 0.223009 -111.374916 CK05L030 55340.61067 176.43429167 41.870527778 -0.45685147037 -0.90377731968 2.5502811749e-05 1 1 1 1 176.4342142 41.8705052 0.3501 0.3841 -0.0698 16.776 0.424 2.6 0.891900003 14.975 null 1.7 0.822600007 10.741 0.266 4.1 1.04900002 4.971 0.063 17.2 5.37400007 1 0 0.000 0.000 0.000 0.000 0000 CUBA 1 55340.610673 null null null null null null null
5 1.207195 35.906233 CK05L030 55340.74298 176.41870833 41.863638889 -0.45485620361 -0.90480967358 2.550870983e-05 1 1 1 1 176.4189724 41.8639105 0.3727 0.4275 0.1199 16.414 null 1.8 0.702499986 15.185 0.388 2.8 1.37800002 10.616 0.263 4.1 0.875899971 5.454 0.067 16.1 4.88100004 2 0 0.000 0.000 0.000 0.000 0000 UCBA 1 55340.742977 null null null null null null null
6 0.481288 172.637939 CK05L030 55340.87528 176.402375 41.855888889 -0.45285884729 -0.90583744873 2.5511778069e-05 1 1 1 1 176.4023980 41.8557563 0.3294 0.3328 0.0508 16.340 0.327 3.3 1.352 15.207 0.405 2.7 1.40900004 10.320 0.198 5.5 1.49100006 5.244 0.053 20.4 8.58199978 1 0 0.000 0.000 0.000 0.000 0000 BCBA 1 55340.875281 null null null null null null null
7 2.082220 27.859527 CK05L030 55341.13989 176.37025 41.840194444 -0.44885730109 -0.90787955846 2.5509514597e-05 1 1 1 1 176.3706128 41.8407058 0.3210 0.3526 -0.0271 16.122 0.259 4.2 1.245 15.334 0.397 2.7 1.83399999 10.874 0.304 3.6 1.50999999 5.195 0.056 19.4 8.17099953 1 0 0.000 0.000 0.000 0.000 0000 BCBA 1 55341.139889 null null null null null null null
8 0.525329 61.035402 CK05L030 55341.4045 176.33916667 41.826333333 -0.44484690905 -0.90990361741 2.5496225689e-05 1 1 1 1 176.3393380 41.8264040 0.3373 0.3749 -0.0211 16.255 0.297 3.7 1.33000004 15.188 null 1.4 0.569700003 10.437 0.202 5.4 0.719600022 5.293 0.062 17.4 3.80599999 2 0 0.000 0.000 0.000 0.000 0000 BUBA 1 55341.404497 null null null null null null null
9 0.619262 16.487107 CK06O02F 55326.64427 144.64866667 3.9275555556 -0.65281988044 -0.77043313523 1.7439960916e-05 1 1 1 1 144.6487156 3.9277205 0.7296 0.7649 -0.0687 16.711 null 1.0 0.629700005 15.445 null 0.4 0.832700014 11.010 0.374 2.9 0.876800001 5.989 0.117 9.3 2.50600004 1 0 0.000 0.000 0.000 0.000 0000 UUCB 1 55326.644270 null null null null null null null
10 7.549195 28.419721 CK06O02F 55326.77657 144.65333333 3.9249722222 -0.65111848055 -0.77191209637 1.7468061883e-05 1 1 1 1 144.6543337 3.9268165 0.7286 0.7791 0.2262 15.442 0.151 7.2 0.423700005 14.897 0.288 3.8 0.842599988 11.225 null 0.3 1.29499996 7.178 0.290 3.7 1.16700006 2 0 0.000 0.000 0.000 0.000 0000 BBUB 0 55327.239575 776676111 16.976 0.209 15.976 0.153 15.345 0.188
11 2.513670 169.398129 CK06O02F 55326.90888 144.65845833 3.9239722222 -0.64941365029 -0.77338728158 1.7498504206e-05 1 1 1 1 144.6585871 3.9232859 2.0312 2.2606 0.6757 16.895 null null 1.29200006 14.964 null 1.6 1.12699997 10.727 0.301 3.6 1.25300002 7.456 null 0.6 1.26400006 1 0 0.000 0.000 0.000 0.000 0000 UUBU 0 55327.107271 null null null null null null null
12 0.027311 -152.027596 CK06O02F 55327.04118 144.66416667 3.92175 -0.64770565631 -0.77485846001 1.7531291511e-05 1 1 1 1 144.6641631 3.9217433 0.6009 0.6194 -0.0479 16.831 0.454 2.4 0.667599976 15.637 null null 1.23899996 11.248 0.500 2.2 1.01400006 5.966 0.099 10.9 2.63499999 1 0 0.000 0.000 0.000 0.000 0000 CUCA 1 55327.041183 null null null null null null null
13 3.175762 179.933042 CK06O02F 55327.17349 144.66879167 3.9195555556 -0.6459942494 -0.77632584623 1.756643507e-05 1 1 1 1 144.6687927 3.9186734 0.5491 0.5627 0.0434 16.296 null 1.8 1.47800004 14.891 0.313 3.5 0.554700017 10.633 0.279 3.9 1.28100002 5.874 0.092 11.9 1.75300002 1 0 0.000 0.000 0.000 0.000 0000 UBBA 1 55327.173487 null null null null null null null
14 0.389513 124.104207 CK06O02F 55327.23958 144.6725 3.9181666667 -0.64513815967 -0.7770573541 1.7584872566e-05 1 1 1 1 144.6725898 3.9181060 0.6065 0.6402 0.1156 17.093 null null 1.27499998 15.512 null null 1.13 10.969 0.381 2.8 1.09899998 5.983 0.101 10.7 1.80499995 1 0 0.000 0.000 0.000 0.000 0000 UUCA 1 55327.239575 null null null null null null null
15 0.577296 -163.457123 CK06O02F 55327.30579 144.67391667 3.9172222222 -0.64427969731 -0.77778921063 1.7603933933e-05 1 1 1 1 144.6738709 3.9170685 0.6675 0.6392 -0.0464 16.456 null 1.1 1.074 15.474 null 0.1 1.10399997 10.768 0.302 3.6 0.969099998 5.694 0.109 10.0 2.33599997 1 0 0.000 0.000 0.000 0.000 0000 UUBA 1 55327.305791 null null null null null null null
16 0.667582 -101.040166 CK06O02F 55327.37188 144.67695833 3.9158611111 -0.64342197524 -0.77851876198 1.762355031e-05 1 1 1 1 144.6767759 3.9158256 0.5525 0.5875 0.1269 16.550 0.490 2.2 1.07500005 15.640 null 0.2 0.758700013 10.396 0.232 4.7 0.834200025 5.907 0.094 11.5 2.45600009 1 0 0.000 0.000 0.000 0.000 0000 CUBA 1 55327.371880 null null null null null null null
More information about the AstroPy
mailing list