from astropy.table import Table, Column
from astropy import log
log.setLevel('WARNING')
from astropy.io import ascii
table = ascii.read("file.dat")
print(table)
columns = [Column(table["col1"], name="name"),
Column(table["col2"], name="id"),
Column(table["col3"], name="RAJ2000"),
Column(table["col11"], name="DEJ2000")]
for i in range(4, len(table.columns)+1):
if i == 11: continue
columns.append(table["col{}".format(i)])
new_table = Table(columns)
print(new_table)
table1 = ascii.read("file1.dat")
table2 = ascii.read("file2.dat")
new_table1 = Table([Column(table1["col1"], name="id"),
Column(table1["col2"], name="text")])
new_table2 = Table([Column(table2["col1"], name="id"),
Column(table2["col2"], name="mag")])
from astropy.table import join
jointable = join(new_table1, new_table2, keys='id', join_type='outer')
print (jointable)
print (jointable.columns)
print (jointable["text"])
jointable.write("matable.ascii", format="ascii.fixed_width")
with open("newfile1.dat", "w") as fout:
with open("file1.dat", "r") as fd:
fout.write(fd.read().replace("|"," "))
table1 = ascii.read("newfile1.dat",
format="fixed_width_no_header",
col_starts=(0,8,14,20,27,38,44,50,61,68,74))
print (table1)
table1 = ascii.read("hip_main.dat", readme="ReadMe")
table2 = ascii.read("hip_va_1.dat", readme="ReadMe")
jointable = join(table1, table2, keys="HIP", join_type="left")
print (jointable)
necessite la librairie pyreadme : http://cds.u-strasbg.fr/resources/doku.php?id=anafile
from cds import *
tablemaker = CDSTablesMaker()
table = tablemaker.addTable("ajaa6d51t2_mrt.txt")
print (table.table)
tablemaker.writeCDSTables()
tablemaker.title = "my title"
tablemaker.author = 'theauthorname'
tablemaker.makeReadMe()