[AstroPy] Storing results into Tables for further SQL queries.

[Aldcroft, Thomas]

Hi Keith,

With the astropy Table object you can do table operations like join and
merge:

https://docs.astropy.org/en/stable/table/operations.html#table-operations

I'm not entirely clear if your question is about how to get your SQL query
results into a Table, or how to do joins with a Table.  Can you provide a
bit more detail?

- Tom

On Sun, Sep 8, 2019 at 10:44 AM keith <keith at sloan-home.co.uk> wrote:

> Apologies for a newby question.
>
> For my MSc project I need  to run SQL queries against GAMA and SDSS.
>
> I am using Jupyter on Ubuntu 18.04.
>
> I can successfully retrieve data by using the astropy python modules.
>
> I would like to store the results from the more complicated SQL queries
> into a Table,
> so that I can perform further joins on both GAMA and SDSS  tables.
>
> How do I go about this?
>
> Do I have to setup a local database?
>
> Thanks
>
> --
> ========== Art & Ceramics ===========
> https://www.instagram.com/ksloan1952/
>
> _______________________________________________
> AstroPy mailing list
> AstroPy at python.org
> https://mail.python.org/mailman/listinfo/astropy
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/astropy/attachments/20190909/27f5a86f/attachment.html>