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

T. Emil Rivera-Thorsen trive at astro.su.se
Mon Sep 9 05:20:28 EDT 2019


Hi Keith.

I don´t know the specifics of your project in detail, but is sounds like 
a job for the Pandas module, which is good at labeled, heterogeneous 
data and light database-like operations like joine, merge, pivot etc.

http://pandas.pydata.org

/Emil


On 9/8/19 4:43 PM, keith 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/58b8f0b4/attachment.html>


More information about the AstroPy mailing list