Lab 5: Data Wrangling

Start Feb 12 –- Due Feb 19

Goals

In this lab, students will learn to:

• Write queries using ADQL and TAP

• Access tables with results of queries

• Download datafiles from a major astronomical archives via astroquery

• Access data from FITS files

• Crossmatch objects between two catalogs

• Wrange data in DataFrames using select, filter, join, groupby & transform

• Access python packages via Julia

Instructions

• Work through the ex1.jl and ex2.jl (Pluto notebooks) and save updates in your personal repository.

• Look over ex3.jl and start working on it. But stop after 6 hours total work on this week's labs.

• Commit and submit your work.

• Once the instrctor and/or TA has provided feedback, review the feedback

Resources

• astroquery

• ESA Gaia Archive

• More information about building queries:

  • SQL Tutorial

  • Gaia Data Queries with ADQL

  • ADQL Cookbook for Gaia (DR1)

  • Retrieving Exoplanet Archive Data With Table Access Protocol

  • Web Table Access Protocol client for Gaia

• Reference Resources:

  • Astronomical Data Query Language (ADQL)

  • Table Access Protocol (TAP)