# \#table **URL:** https://community.openastronomy.org/tag/table/7.md [Latest](https://community.openastronomy.org/latest.md) · [Categories](https://community.openastronomy.org/categories.md) · [Tags](https://community.openastronomy.org/tags.md) --- ## [I made a simple command line interface (CLI) tool for editing FITS headers](https://community.openastronomy.org/t/i-made-a-simple-command-line-interface-cli-tool-for-editing-fits-headers/1278)
**Author:** [@AmberLee2427](https://community.openastronomy.org/u/AmberLee2427)\ **Replies:** 1\ **Last updated:** [January 12, 2026, 8:18pm UTC](https://community.openastronomy.org/t/i-made-a-simple-command-line-interface-cli-tool-for-editing-fits-headers/1278 "2026-01-12T20:18:37Z")
Kia ora everyone, I frequently find myself needing to make quick, small changes to FITS headers (like fixing an OBJECT keyword) without wanting to open a full GUI, especially when I’m remote over SSH. So I built CLFits,… --- ## [How can I locally backup downloaded data files?](https://community.openastronomy.org/t/how-can-i-locally-backup-downloaded-data-files/1192)
**Author:** [@msmcconnell](https://community.openastronomy.org/u/msmcconnell)\ **Replies:** 7\ **Last updated:** [January 31, 2025, 1:30pm UTC](https://community.openastronomy.org/t/how-can-i-locally-backup-downloaded-data-files/1192 "2025-01-31T13:30:38Z")
When I first run some of Astropy’s functions it will trigger downloads of data such as https://datacenter.iers.org/data/9/finals2000A.all These downloads can occasionally fail. I would like to have local copies instead … --- ## [Code to Calculate Velocity from GAIA DR3 Data](https://community.openastronomy.org/t/code-to-calculate-velocity-from-gaia-dr3-data/1182)
**Author:** [@Strueb](https://community.openastronomy.org/u/Strueb)\ **Replies:** 2\ **Last updated:** [January 17, 2025, 10:15pm UTC](https://community.openastronomy.org/t/code-to-calculate-velocity-from-gaia-dr3-data/1182 "2025-01-17T22:15:35Z")
I am working to calculate and plot velocity vs distance for large GAIA DR3 data sets. Are there any efficient code blocks in Astropy to help with this or do I need to code it step by step? I am working with ra, dec, para… --- ## [Writing a sextractor formatted ascii table in AstroPy](https://community.openastronomy.org/t/writing-a-sextractor-formatted-ascii-table-in-astropy/1095)
**Author:** [@cduston44](https://community.openastronomy.org/u/cduston44)\ **Replies:** 0\ **Last updated:** [August 26, 2024, 9:01pm UTC](https://community.openastronomy.org/t/writing-a-sextractor-formatted-ascii-table-in-astropy/1095 "2024-08-26T21:01:25Z")
I am trying to write a function to clean catalog files that are output from sextractor. The sextractor catalog creation command and the initial ascii read command seem fine: cat\_sci = ascii.read('sci\_match.cat',format='… --- ## [Online reading of BinTableHDU subsets of DESI survey](https://community.openastronomy.org/t/online-reading-of-bintablehdu-subsets-of-desi-survey/877)
**Author:** [@Vital-Fernandez](https://community.openastronomy.org/u/Vital-Fernandez)\ **Replies:** 3\ **Last updated:** [January 22, 2024, 5:56pm UTC](https://community.openastronomy.org/t/online-reading-of-bintablehdu-subsets-of-desi-survey/877 "2024-01-22T17:56:48Z")
Hi! I am using the cloud .fits documentation to read some .fits files from the DESI survey. This is an example of the code I am using: import numpy as np import astropy from astropy.io import fits program =‘dark’ … --- ## [Detecting NULL values in FITS tables](https://community.openastronomy.org/t/detecting-null-values-in-fits-tables/731)
**Author:** [@SteveAllen-UCOLick](https://community.openastronomy.org/u/SteveAllen-UCOLick)\ **Replies:** 0\ **Last updated:** [September 1, 2023, 9:38pm UTC](https://community.openastronomy.org/t/detecting-null-values-in-fits-tables/731 "2023-09-01T21:38:54Z")
I am reading a FITS ASCII table which has several floating point columns with values that match their TNULLn card. After fits.open on the file I see the NULL columns with value 0. How can I test whether the value in the… --- ## [ICRS to galactocentric conversion using Astropy](https://community.openastronomy.org/t/icrs-to-galactocentric-conversion-using-astropy/724)
**Author:** [@vhpatel2000](https://community.openastronomy.org/u/vhpatel2000)\ **Replies:** 2\ **Last updated:** [August 18, 2023, 8:25pm UTC](https://community.openastronomy.org/t/icrs-to-galactocentric-conversion-using-astropy/724 "2023-08-18T20:25:12Z")
Hi all , I am using astropy package for converting RA, Dec and distance ( Line of Sight) to Galactocentric coordinates. The problem is the following: I generated a sphere of randomly distributed 1 million points in RA … --- ## [Is there a way to use the astropy table indicies in the same way as Pandas dataframe indicies?](https://community.openastronomy.org/t/is-there-a-way-to-use-the-astropy-table-indicies-in-the-same-way-as-pandas-dataframe-indicies/470)
**Author:** [@SpaceMetallicFox](https://community.openastronomy.org/u/SpaceMetallicFox)\ **Replies:** 3\ **Last updated:** [November 14, 2022, 3:22pm UTC](https://community.openastronomy.org/t/is-there-a-way-to-use-the-astropy-table-indicies-in-the-same-way-as-pandas-dataframe-indicies/470 "2022-11-14T15:22:18Z")
If I have some dataframe with indicies and if I need to slice it, indicies will be still in the sliced dataframe, whereas in astropy I didn’t find anything similar. I saw that there are also some indicies, but, if I got … --- ## [Setting Astropy table column types](https://community.openastronomy.org/t/setting-astropy-table-column-types/498)
**Author:** [@eblur](https://community.openastronomy.org/u/eblur)\ **Replies:** 2\ **Last updated:** [November 9, 2022, 3:38pm UTC](https://community.openastronomy.org/t/setting-astropy-table-column-types/498 "2022-11-09T15:38:52Z")
Is there a way to specify what kind of variable you’re putting in a table? I have a student who is trying to add table values with string 14 but they’re formatting automatically as string 11 (the original format of the t… --- ## [Detecting point sources (from Photutils' DAOStarFinder) in consecutive Astropy's Tables](https://community.openastronomy.org/t/detecting-point-sources-from-photutils-daostarfinder-in-consecutive-astropys-tables/438)
**Author:** [@jaoc](https://community.openastronomy.org/u/jaoc)\ **Replies:** 0\ **Last updated:** [August 27, 2022, 9:00am UTC](https://community.openastronomy.org/t/detecting-point-sources-from-photutils-daostarfinder-in-consecutive-astropys-tables/438 "2022-08-27T09:00:58Z")
Dear Community, I’d be very grateful to have some advice on the following problem. PROBLEM STATEMENT: I’ve a list of (13) consecutive (understood at different redshifts) tables for the point sources that Photutils’ DAOS… --- ## [UnitConversionError: Unit mag is not a physical unit](https://community.openastronomy.org/t/unitconversionerror-unit-mag-is-not-a-physical-unit/336)
**Author:** [@RickW](https://community.openastronomy.org/u/RickW)\ **Replies:** 1\ **Last updated:** [May 27, 2022, 1:42am UTC](https://community.openastronomy.org/t/unitconversionerror-unit-mag-is-not-a-physical-unit/336 "2022-05-27T01:42:46Z")
I am trying to create photometry ensembles for from APASS data. I download the APASS data from a Vizier query into a QTable. I load the SExtractor catalog from an image into a QTable. I match stars between the two tab… --- ## [File not found tutoriel d'astropy](https://community.openastronomy.org/t/file-not-found-tutoriel-dastropy/314)
**Author:** [@BernardChaurand](https://community.openastronomy.org/u/BernardChaurand)\ **Replies:** 3\ **Last updated:** [March 23, 2022, 6:07am UTC](https://community.openastronomy.org/t/file-not-found-tutoriel-dastropy/314 "2022-03-23T06:07:25Z")
j’essaye d’utiliser le tutoriel d"astropy : Coordonnées astronomiques 2 : Transformation des systèmes de coordonnées et des représentations lorsque j’execute tbl = QTable.read(‘Cantat-Gaudin-open-clusters.ecsv’) j’ai … --- ## [Using SAMP for integrating TOPCAT and Jupyter](https://community.openastronomy.org/t/using-samp-for-integrating-topcat-and-jupyter/316)
**Author:** [@juliaroquette](https://community.openastronomy.org/u/juliaroquette)\ **Replies:** 3\ **Last updated:** [March 18, 2022, 4:01pm UTC](https://community.openastronomy.org/t/using-samp-for-integrating-topcat-and-jupyter/316 "2022-03-18T16:01:47Z")
Hi, I am trying to write a piece of python code that allows me to send tables back and forth between a jupyter notebook and TOPCAT. Reading the Astropy documentation, I found out that the best way to do so is using the … --- ## [Extract unmasked elements from Astropy Table](https://community.openastronomy.org/t/extract-unmasked-elements-from-astropy-table/145)
**Author:** [@kelle](https://community.openastronomy.org/u/kelle)\ **Replies:** 5\ **Last updated:** [December 16, 2021, 8:51am UTC](https://community.openastronomy.org/t/extract-unmasked-elements-from-astropy-table/145 "2021-12-16T08:51:12Z")
Let’s kick the tires of this forum! I’m trying to extract the non-masked rows from an Astropy Table. From the Astropy Table documentation, I can get the indices of the masked, but how do I get the inverse? To get the … --- ## [Pyvo TAP result to csv (via astropy.Table?)](https://community.openastronomy.org/t/pyvo-tap-result-to-csv-via-astropy-table/198)
**Author:** [@ygrange](https://community.openastronomy.org/u/ygrange)\ **Replies:** 7\ **Last updated:** [October 23, 2021, 12:20am UTC](https://community.openastronomy.org/t/pyvo-tap-result-to-csv-via-astropy-table/198 "2021-10-23T00:20:56Z")
I have a TAP table in a VO service that I want to dump to csv. So for this I basically was thinking of using the following code snippet (replaced the VO service by a public one for demonstration purposes): =========8\<=…