ATpy

The following database formats are supported: SQLite, MySQL, and PostgreSQL.

The FITS, VO, and IPAC tables format are supported.

ATpy is a high-level package providing a way to manipulate tables of astronomical data in a uniform way.

A table is defined by any number of columns of data, each characterized by a column name, unit, null value, and description (the last three being optional), and can be supplemented with metadata in the form of keywords or comments.

ATpy can be used to manipulate single tables as well as sets of tables.

Features:

• Seamlessly read and write table data to a number of table formats (FITS, VO, and IPAC tables, and SQLite/MySQL/PostgreSQL databases), building on existing python modules. More formats will be supported in future.
• Remove, add, or rename columns.
• Access and modify individual table cells.
• Create an empty table and populate it.
• Create a new table from a selection of rows.
• Add keywords and comments.
• Read and write sets of tables.

What is new in this release:

• ATpy is now released under an MIT license.
• Support for writing out arbitrary tables via the asciitable module.
• Support for copying all column metadata in one go when creating a new column based on an old column.
• Preliminary support for querying online services such as IRSA and the virtual observatory.

What is new in version 0.9.4:

• New Features:
• Specify whether to used masked arrays by default via an .atpyrc file and/or via a set_masked_default function.
• Added support for the asciitable module, which opens up support to read in arbitrary ASCII tables. Formats supported by default include CDS format (aka Machine Readable Tables), RDB, and DAOphot tables. In addition, the full asciitable API is available.
• Added support for reading/writing Table and TableSet to HDF5 files. This includes appending to existing files, and reading from/writing to groups.
• Improved output when doing 'print table' where table is a Table instance.
• Added support for Python 3
• API/Internal changes:
• Significant speedup for reading large FITS tables
• Table columns can now be accessed using the item notation, t['column']
• Bug fixes:
• Fixed a bug that prevented ASCII FITS tables from being read in
• Fixed a bug that meant that only the first table in a list was used when creating a TableSet from a list of Tables.
• Fixed copy() method for Table
• Fixed several other minor bugs

What is new in version 0.9.3:

• Restores compatibility with Python 2.5.

What is new in version 0.9.2:

• New Features:
• Tables are now stored as structured arrays.
• New masked= argument during Table initialization (default is False).
• Full SQL queries for MySQL, PostGreSQL, and SQLite.
• Access column information through Table.columns, indexed either by column name or number. Supports iteration.
• Verbose argument for read/write.
• New Table.rows() method to select specific rows
• New Table.add_empty_column() method
• New Table.append() method to combine two tables
• New Table.sort() method
• Added comments/keywords for TableSet() class as a whole
• New before=/after=/position= arguments for Table.add_column() and Table.add_empty_column()
• API/Internal Changes:
• fits_read, vo_read, ipac_read, sql_read, and equivalent methods are now depracated - use read(...) instead and specify type= if necessary.
• Table.units, Table.types, Table.nulls, and Table.formats are deprecated. Use Table.columns instead.
• Allow users to specify new extensions to associate with different table types via atpy.register_extensions.
• Bug fixes:
• Fixed a bug that meant that values could not be assigned when accessing a column via attributes (e.g. t.column_name[1] = 1).
• Fixed a bug with creating empty table sets.
• Fixed a bug with pedantic= option for VO tables.

What is new in version 0.9.1:

• Removed pkg_ressources dependency. Versions are now checked using distutils, which is more standard.
• Added support for boolean columns in FITS and VO tables.
• Added pendatic= argument for VO Table.