Lab 7: Queries & Data Wrangling
(github)
Start Oct 12 –- Due Oct 19
Goals
In this lab, students will learn to:
Write queries using ADQL and TAP
Access tables with results of queries
Manipulate DataFrames including select, filter, join, groupby & transform
Crossmatch objects between two catalogs
Download datafiles from a major astronomical archives using astroquery (in ex2.jl)
Access data from FITS files (in ex2.jl)
Apply Box Least Squares (BLS) periodogram to search for planets (in optional ex3.jl)
Students will strengthen their understanding of:
Population of Rossiter-McLaughlin observations
Data products avaliable from space-based photometric missions (in either ex2.jl or ex3.jl)
Pre-processing of photometric light curves (in ex3.jl)
Combining multiple programmling languages (in either ex2.jl or ex3.jl)
All students should work through ex1.jl. Students may choose to complete either exercise 2 or exercise 3,
Logistics
Follow this link to create your own private copy of this lab's repository on GitHub.com. depending on what would be most useful for their class project. Before starting ex2.jl or ex3.jl, see instructions in Canvas announcement for updating your Julia depot, so the calls to astropy, astroquery and lightkurve will work.
See the help on the course website for instructions on getting setup to use ACI, cloning, committing, pushing and submitting your work.
Resources
Virtual Observatory specifications for TAP for more info.
Exopalnet Archive Planetary Systems Table's column descriptions.
Other Packages Used: