Communicating (Data) Science

Reports & Dashboards

Collaborating

Astro 497, Week 12, Monday

TableOfContents()

Reports

  • You (or your team) performed a detailed analysis.

  • A report shares your conclusions and recommendations with others.

Who are you reporting to?

  • Your team members (e.g., regular group meeting)

  • A wider collaboration (e.g., internal white paper, annual collaboration meeting)

  • Experts beyond your collaboration (e.g., journal article, scientific meeting)

  • Funding agency (e.g., progress/final grant report)

  • General public (e.g., press release, funding agency)

  • Planning committee (e.g., white paper for decadal survey)

What are you aiming to accomplish from the report?

  • Stimulate suggestions for how to solve current roadblock

  • Provide documentation for team members to build on your results

  • Help identify future opportunities for connections to other researchers/projects

  • Get critical feedback to identify weak points of analysis

  • Provide documentation to justify continued/increased support for project

Prepare report to advance specific goals

  • Use the knowledge gained from performing a detailed analysis positions

  • Narrative & choice of figures (in report body) directly support report's goals

Typical Scientific Report Structure

  1. Summary of Conclusions/Recommendations

    • Abstract

    • Executive Summary

    • Opening paragraphs "above the fold"

  2. Context:

    • Why did you do this work?

      • Problem or unmet need

      • Previous studies left unanswered question

    • What other information is needed to understand your approach and results?

    • Why did you choose this approach, as opposed to alternatives?

  3. Describe Input Data

    • Where did data come from?

    • How was data collected?

    • What is known (or unknown) about quality of data?

    • What concerns about data should be kept in mind?

  4. Describe Data Analysis & Outputs

    • How were data analyzed?

    • What are the outputs of the analysis?

    • Sometimes includes limited straight-forward results

  5. Interpret Data

    • Explain rationale for each conclusion/recommendation

  6. Conclusions/Recommendations

    • Concise summary

  7. What comes next?

    • Motivate what you want to do next

    • Inspire others to contribute

  8. Appendices

    • Supporting Data, Tables, Figures, Codes

    • More details about Analysis Methods & Implementation Details

    • Describe checks that were performed and passed

Pros of Typical Written Scientific Report

  • Provides details needed to understand, evaluate and/or build on results

  • Great for referring back to long after report was prepared

  • Sense of accomplishment from finishing a project

Cons of Typical Written Scientific Report

  • Can take significant time to prepare

  • Can take significant time to understand

  • Easy to overlook important elements "buried" in a long report

  • Readers may skim/skip over parts

  • Often "dry"

Oral Report/Presentations

  • Summarizes key elements of written report

  • Refers to written report for details (e.g., data, methodology, analysis, complete list of assumptions/caveats)

    • Should still highlight most important assumptions/caveats

  • Best presentations tell a story

    • Easier to maintain audience's attention

    • More likely to be remembered

Dashboard

Goal: Efficiently communicate what can be learned from data

  • Support people in making future decisions

  • Won't represent the best-possible analysis

  • Automates performing common tasks & analysis

  • Needs to be robust & capable of handling corner cases gracefully

Pros of Dashboard

  • Enables people to gain insights efficiently

  • Accelerate science

  • Reduce errors by automating routine steps

  • Allows team members to focus on other steps

  • Can integrates expertise from multiple team members

Cons of Dashboard

  • Takes significant time to make pipeline robust

  • Takes significant time to design effective visualizations

  • May not be able to refer back to dashboard's state at previous time

  • Takes time/knowledge to keep running smoothly

  • Often want to update dashboard (repeatedly) as needs change

  • Risks oversimplifying complex cases

  • Can contribute to leaders becoming overconfident

Key Differences between a Report & a Dashboard

ReportsDashboards
StaticDynamic
Reviewed & ProofedRely on previous tests
ExplanatoryExploratory
Tailored to support messageEffective for any incoming data
Help reader reach your conclusionHelp viewer form hypothesis

Dashboards aim to

  • Reduce cognitive load of viewer...

    • but provide all information necessary

  • Anticipate questions that viewers will have...

    • but questions change with time/new data

  • Be flexible enough to deal with whatever data comes in...

    • but incoming data changes with time

Data Disagregation & Drilldown

Show Drilldown Plots

if drilldown_plots 
    md"""
Discovery Method: $(@bind disc_method_idx Select(0:length(keys(df_by_method)) .=> vcat("All",map(k->k.discoverymethod,keys(df_by_method)))))
"""
end
if drilldown_plots
    let
    plt = plot() # histogram(df.disc_year, legend=:none)
    if disc_method_idx >= 1	
        local df_plt = df_by_method[disc_method_idx] 
        histogram!(plt, df_plt.disc_year, bin=range(2000,stop=2022), legend=:none )
    end
    end
end
if drilldown_plots
    let
    plt = plot() #xscale=:log10, yscale=:log10, legend=:none)
    histogram!(plt, df.disc_year, markersize=1, markerstrokewidth=0)
    xlabel!("Period (d)")
    ylabel!("Radius (Rⱼ)")
    if disc_method_idx >= 1	
        local df_plt = df_by_method[disc_method_idx] 
        scatter!(df_plt.pl_orbper,df_plt.pl_radj, markersize=1, markerstrokewidth=0, markercolor=3)
    end
    end
end
if drilldown_plots && disc_method_idx >= 1	
    df_plt = df_by_method[disc_method_idx] 
    scatter(df_plt.pl_orbper,df_plt.pl_radj)
end

Collaborating

Asynchronous

  • Write separate files/functions/modules

  • Maintain independent repositories

  • Merge changes via git

  • Create branches for new features, so main branch is always usable

Synchronous

  • Like asynchronous, but ask questions as you go

  • Pair Coding: Driver & Navigator

  • Debugging: Explainer & Audience

  • Beware of using shared filesystem

Tools

Setup/Helper Code

ChooseDisplayMode()
     
begin
    using PlutoUI, PlutoTeachingTools
    using CSV, DataFrames, Plots
end
begin
    query_base_url = "https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query="
    query_table = "ps"
    query_where = "default_flag=1"
    query_max_rows = 10_000
    url_to_use = make_tap_query_url(query_base_url, query_table, where=query_where, max_rows=query_max_rows)
end;
begin
    datadir = joinpath(pwd(),"data")
    mkpath(datadir)
    filename = "nexsci_ps.tsv"
    datapath = joinpath(datadir,filename)
end;
begin
    if !isfile(datapath) || filesize(datapath)==0
        Downloads.download(url_to_use, datapath)
        fresh_data = true
    else
        fresh_data = false
    end
    #@test filesize(datapath) >0
end
false
begin
    fresh_data
    df_raw = CSV.read(datapath,DataFrame)
end;
begin
    # Create new Dataframe that eliminates columns that have names ending in "str"
    colnames_ending_in_str = filter(x->contains(x,r"str$"), names(df_raw) )
    df = select(df_raw,Not(Symbol.(colnames_ending_in_str)))

    # Convert columns containing HTML into HTML
    df.sy_refname = HTML.(df.sy_refname)
    df.disc_refname = HTML.(df.disc_refname)
    df.pl_refname = HTML.(df.pl_refname)
    df
end;
unique(df.discoverymethod)
11-element Vector{String31}:
 "Transit"
 "Radial Velocity"
 "Imaging"
 "Astrometry"
 "Microlensing"
 "Transit Timing Variations"
 "Orbital Brightness Modulation"
 "Eclipse Timing Variations"
 "Pulsar Timing"
 "Pulsation Timing Variations"
 "Disk Kinematics"
df_by_method = groupby(df,:discoverymethod)

GroupedDataFrame with 11 groups based on key: discoverymethod

First Group (3879 rows): discoverymethod = InlineStrings.String31("Transit")
188 columns and 3854 rows omitted
Rowpl_namepl_letterhostnamehd_namehip_nametic_idgaia_iddefault_flagpl_refnamesy_refnamedisc_pubdatedisc_yeardiscoverymethoddisc_localedisc_facilitydisc_instrumentdisc_telescopedisc_refnameradecglonglatelonelatpl_orbperpl_orbpererr1pl_orbpererr2pl_orbperlimpl_orblpererr1pl_orblperpl_orblpererr2pl_orblperlimpl_orbsmaxpl_orbsmaxerr1pl_orbsmaxerr2pl_orbsmaxlimpl_orbinclpl_orbinclerr1pl_orbinclerr2pl_orbincllimpl_orbtperpl_orbtpererr1pl_orbtpererr2pl_orbtperlimpl_orbeccenpl_orbeccenerr1pl_orbeccenerr2pl_orbeccenlimpl_eqtpl_eqterr1pl_eqterr2pl_eqtlimpl_occdeppl_occdeperr1pl_occdeperr2pl_occdeplimpl_insolpl_insolerr1pl_insolerr2pl_insollimpl_denspl_denserr1pl_denserr2pl_denslimpl_trandeppl_trandeperr1pl_trandeperr2pl_trandeplimpl_tranmidpl_tranmiderr1pl_tranmiderr2pl_tranmidlimpl_trandurpl_trandurerr1pl_trandurerr2pl_trandurlimsy_umagsy_umagerr1sy_umagerr2sy_rmagsy_rmagerr1sy_rmagerr2sy_imagsy_imagerr1sy_imagerr2sy_zmagsy_zmagerr1sy_zmagerr2sy_w1magsy_w1magerr1sy_w1magerr2sy_w2magsy_w2magerr1sy_w2magerr2sy_w3magsy_w3magerr1sy_w3magerr2sy_w4magsy_w4magerr1sy_w4magerr2
String31String1String31String15String15String15String31Int64HTML…HTML…String15Int64String31String31StringStringStringHTML…Float64Float64Float64Float64Float64Float64Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?
1OGLE-TR-10 bbOGLE-TR-10missingmissingTIC 130150682Gaia DR2 40564433666499481601HTML{String}("<a refstr=TORRES_ET_AL__2008 href=https://ui.adsabs.harvard.edu/abs/2008ApJ...677.1324T/abstract target=ref> Torres et al. 2008 </a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2005-052004TransitGroundOGLEOGLE CCD Array1.3 m Warsaw University TelescopeHTML{String}("<a refstr=KONACKI_ET_AL__2005 href=https://ui.adsabs.harvard.edu/abs/2005ApJ...624..372K/abstract target=ref> Konacki et al. 2005 </a>")267.868-29.8765359.851-1.57666268.139-6.450963.10128missingmissing0missingmissingmissingmissing0.04340.0013-0.0015090.00.0-3.90missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing0.40.18-0.1201.210.044-0.0440missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing
2Kepler-17 bbKepler-17missingmissingTIC 273874849Gaia DR2 20864497618463107841HTML{String}("<a refstr=DESERT_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJS..197...14D/abstract target=ref> D&eacute;sert et al. 2011 </a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2011-112011TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=DESERT_ET_AL__2011 href=https://ui.adsabs.harvard.edu/abs/2011ApJS..197...14D/abstract target=ref> D&eacute;sert et al. 2011 </a>")298.39547.81581.824910.2417322.25266.17971.485712.0e-7-2.0e-70missingmissingmissingmissing0.025910.00037-0.00036087.20.15-0.150missingmissingmissingmissing0.011missingmissing11570.0200.0-200.000.00580.001-0.0010missingmissingmissingmissing1.350.08-0.080missingmissingmissingmissing2.45519e62.3e-5-2.6e-502.27640.00168-0.001680missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing12.550.023-0.02312.5940.022-0.02212.2910.216-0.2168.715missingmissing
3Kepler-24 ccKepler-24missingmissingTIC 122376177Gaia DR2 20528235351710952961HTML{String}("<a refstr=FORD_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..113F/abstract target=ref> Ford et al. 2012 </a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2012-052011TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=FORD_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..113F/abstract target=ref> Ford et al. 2012 </a>")290.41338.343770.549911.0183302.60859.493512.3335missingmissing0missingmissingmissingmissing0.106missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e6missingmissing03.71missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing13.2490.025-0.02513.2610.027-0.02712.4010.326-0.3268.701missingmissing
4Kepler-32 bbKepler-32missingmissingTIC 273590427Gaia DR2 20802878925253598721HTML{String}("<a refstr=FABRYCKY_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..114F/abstract target=ref> Fabrycky et al. 2012 </a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2012-052011TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=FABRYCKY_ET_AL__2012 href=https://ui.adsabs.harvard.edu/abs/2012ApJ...750..114F/abstract target=ref> Fabrycky et al. 2012 </a>")297.84246.574480.53929.96232320.06465.24685.901240.0001-0.00010missingmissingmissingmissing0.05missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing0.165missingmissing02.45497e60.008-0.00802.1120.12-0.120missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing12.570.023-0.02312.60.024-0.02412.550.357-0.3579.418missingmissing
5Kepler-370 ccKepler-370missingmissingTIC 137411225Gaia DR2 20535785217041241601HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")292.17140.916273.5110.9429306.77661.554619.02290.000177-0.0001770missingmissingmissingmissing0.14missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e60.0054-0.005403.4180.155-0.1550missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing13.5590.026-0.02613.6160.033-0.03312.329missingmissing9.135missingmissing
6Kepler-400 bbKepler-400missingmissingTIC 122707140Gaia DR2 21015100088261602561HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")290.94440.480172.691911.5843304.64261.42429.024393.4e-5-3.4e-50missingmissingmissingmissing0.087missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e60.00239-0.0023903.1280.072-0.0720missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing12.2030.023-0.02312.2320.023-0.02312.0440.228-0.2288.3590.206-0.206
7Kepler-221 bbKepler-221missingmissingTIC 272601375Gaia DR2 20803445860944984321HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")296.65546.835280.372910.8017318.57465.83932.795914.0e-6-4.0e-60missingmissingmissingmissing0.037missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e60.00084-0.0008402.0640.029-0.0290missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing11.8680.023-0.02311.9020.022-0.02212.1570.217-0.2179.2710.466-0.466
8Kepler-367 ccKepler-367missingmissingTIC 28159518Gaia DR2 20872504768878562561HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")297.29349.981783.403311.9213323.31568.427453.57860.000382-0.0003820missingmissingmissingmissing0.253missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.455e60.00434-0.0043405.2360.128-0.1280missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing10.5890.023-0.02310.6590.02-0.0210.6680.067-0.0679.519missingmissing
9Kepler-393 ccKepler-393missingmissingTIC 159580535Gaia DR2 21273909706558778881HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")290.99545.192277.067613.5768308.1565.873514.61360.000231-0.0002310missingmissingmissingmissing0.124missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e60.00736-0.0073605.4010.191-0.1910missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing12.0020.064-0.06412.0290.058-0.05812.023missingmissing9.277missingmissing
10Kepler-304 ccKepler-304missingmissingTIC 377909730Gaia DR2 20765658051519257601HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")294.44240.557573.98639.2491309.90260.65525.315957.0e-6-7.0e-60missingmissingmissingmissing0.054missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e60.00085-0.0008501.1140.033-0.0330missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing12.4640.023-0.02312.540.024-0.02412.2120.267-0.2679.2030.417-0.417
11Kepler-360 bbKepler-360missingmissingTIC 158213532Gaia DR2 21063160128102551041HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")286.28544.781675.299916.4666299.98866.53363.289671.2e-5-1.2e-50missingmissingmissingmissing0.044missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45496e60.00213-0.0021302.3120.068-0.0680missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing13.2070.023-0.02313.2590.026-0.02612.6470.325-0.3259.493missingmissing
12Kepler-243 ccKepler-243missingmissingTIC 164886497Gaia DR2 21040902576791816961HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")285.1142.03472.312716.2214296.31264.099320.02620.000163-0.0001630missingmissingmissingmissing0.142missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45498e60.00404-0.0040401.3190.16-0.160missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing13.0220.023-0.02313.0980.023-0.02312.615missingmissing9.474missingmissing
13Kepler-261 ccKepler-261missingmissingTIC 137148674Gaia DR2 20525286255367786241HTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2014-032014TransitSpaceKeplerKepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=ROWE_ET_AL__2014 href=https://ui.adsabs.harvard.edu/abs/2014ApJ...784...45R/abstract target=ref> Rowe et al. 2014</a>")291.36537.609270.218510.0204303.61558.580724.57096.9e-5-6.9e-50missingmissingmissingmissing0.156missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45497e60.00159-0.0015902.7610.052-0.052016.1260.0061588-0.006158812.19780.0022747-0.002274715.74640.0135906-0.013590613.15330.0036238-0.003623811.5370.022-0.02211.610.021-0.02111.6770.178-0.1788.721missingmissing
3868K2-387 bbK2-387missingmissingTIC 376938120Gaia DR2 25805055536131249921HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")19.441811.3685133.214-50.976922.22812.9262328.73530.000992-0.0009940missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.4574e60.0011-0.00110missingmissingmissingmissing19.82760.0406685-0.040668515.69640.0044987-0.004498714.76630.0045757-0.004575714.41170.0046616-0.004661612.1830.023-0.02312.1750.024-0.02412.1890.354-0.3549.087missingmissing
3869K2-368 ddK2-368missingmissingTIC 38136597Gaia DR2 26139249690215494401HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")332.636-11.166147.8861-49.0228330.6090.0974620.20110.002354-0.0027360missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45699e60.0026-0.00180missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing10.990.023-0.02311.030.021-0.02110.9350.147-0.1478.173missingmissing
3870K2-378 bbK2-378missingmissingTIC 741119Gaia DR2 36165172237894954241HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")205.16-11.1172321.88349.9354207.353-0.628422.060440.000118-7.4e-50missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45722e60.0018-0.00340missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing13.3170.024-0.02413.3670.029-0.02912.5020.446-0.4468.591missingmissing
3871K2-381 ccK2-381missingmissingTIC 10195089Gaia DR2 40813760641090344961HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")288.027-21.007616.1314-13.7859286.7971.3867116.03470.001844-0.0015720missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.4573e60.003-0.00270missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing10.2410.024-0.02410.2730.022-0.02210.1060.113-0.1137.741missingmissing
3872K2-367 bbK2-367missingmissingTIC 12821302Gaia DR2 26010485883481909761HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")337.859-13.264548.862-54.5087334.613-3.7035520.64510.000995-0.0013750missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.457e60.002-0.00140missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing10.8730.024-0.02410.9330.021-0.02110.9940.12-0.128.916missingmissing
3873EPIC 206317286 bbEPIC 206317286missingmissingTIC 250956593Gaia DR2 26215459589911101441HTML{String}("<a refstr=HELLER_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019A&A...627A..66H/abstract target=ref>Heller et al. 2019</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2019-072019TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=HELLER_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019A&A...627A..66H/abstract target=ref>Heller et al. 2019</a>")337.618-7.9724656.1702-51.5448336.3431.303621.582520.00017-0.000180missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45701e60.0024-0.00240missingmissingmissingmissing16.6780.0074948-0.007494813.6940.002872-0.00287213.40080.00244-0.0024413.22740.002882-0.00288211.5910.023-0.02311.660.022-0.02211.9020.274-0.2748.892missingmissing
3874K2-381 bbK2-381missingmissingTIC 10195089Gaia DR2 40813760641090344961HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")288.027-21.007616.1314-13.7859286.7971.386717.938930.000596-0.0005920missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.4573e60.0033-0.00630missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing10.2410.024-0.02410.2730.022-0.02210.1060.113-0.1137.741missingmissing
3875WASP-189 bbWASP-189HD 133112HIP 73608TIC 157910432Gaia DR2 63390976799188711681HTML{String}("<a refstr=LENDL_ET_AL__2020 href=https://ui.adsabs.harvard.edu/abs/2020A&A...643A..94L/abstract target=ref>Lendl et al. 2020</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2020-112020TransitSpaceCHaracterising ExOPlanets Satellite (CHEOPS)Teledyne e2v CCD detector0.3 m Ritchey-Chretien TelescopeHTML{String}("<a refstr=LENDL_ET_AL__2020 href=https://ui.adsabs.harvard.edu/abs/2020A&A...643A..94L/abstract target=ref>Lendl et al. 2020</a>")225.687-3.03149354.49146.2782224.12513.63312.72403missingmissing0missingmissingmissingmissing0.050530.00098-0.00098084.030.14-0.140missingmissingmissingmissing0.0missingmissing03353.027.0-34.000.008790.00043-0.000430missingmissingmissingmissing0.621990.07692-0.036470missingmissingmissingmissing2.45893e66.5e-5-6.4e-504.33360.0054-0.00580missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing6.0970.076-0.0766.0290.021-0.0216.1180.011-0.0115.9610.046-0.046
3876EPIC 206317286 ccEPIC 206317286missingmissingTIC 250956593Gaia DR2 26215459589911101441HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")337.618-7.9724656.1702-51.5448336.3431.3036217.51550.002288-0.0029650missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45698e60.0071-0.00310missingmissingmissingmissing16.6780.0074948-0.007494813.6940.002872-0.00287213.40080.00244-0.0024413.22740.002882-0.00288211.5910.023-0.02311.660.022-0.02211.9020.274-0.2748.892missingmissing
3877K2-380 bbK2-380missingmissingTIC 90605642Gaia DR2 40736003565525132801HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")283.435-26.53879.18589-12.2236282.022-3.658379.401310.000469-0.0005060missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.4573e60.002-0.00170missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing9.5890.022-0.0229.6210.02-0.029.3480.047-0.0478.1490.254-0.254
3878K2-365 bbK2-365missingmissingTIC 220604190Gaia DR2 62466220175191836161HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")238.82-21.027350.41524.4485241.1-0.6615123.44820.000766-0.0009960missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.4569e60.0019-0.00130missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing9.5590.024-0.0249.5530.021-0.0219.4230.046-0.0468.7250.448-0.448
3879K2-368 bbK2-368missingmissingTIC 38136597Gaia DR2 26139249690215494401HTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2022-032022TransitSpaceK2Kepler CCD Array0.95 m Kepler TelescopeHTML{String}("<a refstr=CHRISTIANSEN_ET_AL__2022 href=https://ui.adsabs.harvard.edu/abs/2022arXiv220302087C/abstract target=ref>Christiansen et al. 2022</a>")332.636-11.166147.8861-49.0228330.6090.097465.02560.000287-0.0003420missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing2.45698e60.0025-0.00270missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing10.990.023-0.02311.030.021-0.02110.9350.147-0.1478.173missingmissing

Last Group (1 row): discoverymethod = InlineStrings.String31("Disk Kinematics")
188 columns omitted
Rowpl_namepl_letterhostnamehd_namehip_nametic_idgaia_iddefault_flagpl_refnamesy_refnamedisc_pubdatedisc_yeardiscoverymethoddisc_localedisc_facilitydisc_instrumentdisc_telescopedisc_refnameradecglonglatelonelatpl_orbperpl_orbpererr1pl_orbpererr2pl_orbperlimpl_orblpererr1pl_orblperpl_orblpererr2pl_orblperlimpl_orbsmaxpl_orbsmaxerr1pl_orbsmaxerr2pl_orbsmaxlimpl_orbinclpl_orbinclerr1pl_orbinclerr2pl_orbincllimpl_orbtperpl_orbtpererr1pl_orbtpererr2pl_orbtperlimpl_orbeccenpl_orbeccenerr1pl_orbeccenerr2pl_orbeccenlimpl_eqtpl_eqterr1pl_eqterr2pl_eqtlimpl_occdeppl_occdeperr1pl_occdeperr2pl_occdeplimpl_insolpl_insolerr1pl_insolerr2pl_insollimpl_denspl_denserr1pl_denserr2pl_denslimpl_trandeppl_trandeperr1pl_trandeperr2pl_trandeplimpl_tranmidpl_tranmiderr1pl_tranmiderr2pl_tranmidlimpl_trandurpl_trandurerr1pl_trandurerr2pl_trandurlimsy_umagsy_umagerr1sy_umagerr2sy_rmagsy_rmagerr1sy_rmagerr2sy_imagsy_imagerr1sy_imagerr2sy_zmagsy_zmagerr1sy_zmagerr2sy_w1magsy_w1magerr1sy_w1magerr2sy_w2magsy_w2magerr1sy_w2magerr2sy_w3magsy_w3magerr1sy_w3magerr2sy_w4magsy_w4magerr1sy_w4magerr2
String31String1String31String15String15String15String31Int64HTML…HTML…String15Int64String31String31StringStringStringHTML…Float64Float64Float64Float64Float64Float64Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Int64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?Float64?
1HD 97048 bbHD 97048HD 97048HIP 54413TIC 454291762Gaia DR2 52011281247016368641HTML{String}("<a refstr=PINTE_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019NatAs...3.1109P/abstract target=ref>Pinte et al. 2019</a>")HTML{String}("<a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract target=ref>TICv8</a>")2019-082019Disk KinematicsGroundAtacama Large Millimeter Array (ALMA)12-m ArrayAtacama Large Millimeter Array (ALMA)HTML{String}("<a refstr=PINTE_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019NatAs...3.1109P/abstract target=ref>Pinte et al. 2019</a>")167.013-77.6549297.37-15.914238.837-66.2596missingmissingmissingmissingmissingmissingmissingmissing130.0missingmissing040.0missingmissing0missingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissingmissing4.4740.029-0.0294.4670.1-0.11.340.015-0.015-1.320.005-0.005
"Returns a vector of strings with names of columns in DataFrame containing a variable of type."
function get_cols_containing_type(df::DataFrame, type::Type)
        filter(c->eltype(df[!,c])<:Union{Missing,type}, names(df) )
end
"Returns a vector of strings with names of columns in DataFrame containing some form of string."
get_cols_containing_string(df) = get_cols_containing_type(df,AbstractString)
"Returns a vector of strings with names of columns in DataFrame containing some form of real number."
get_cols_containing_real(df) = get_cols_containing_type(df,Real)
"""
`make_tap_query_url(base_url, query_table; ...)`
Returns url for a Table Access Protocol (TAP) query.
Inputs:
- base url 
- table name
Optional arguments:
- max_rows (all)
- select_cols (all)
- where (no requirement)
- order_by_cols (not sorted)
- format (tsv)
See [NExScI](https://exoplanetarchive.ipac.caltech.edu/docs/TAP/usingTAP.html#sync) or [Virtual Observatory](https://www.ivoa.net/documents/TAP/) for more info.
"""
function make_tap_query_url(query_base_url::String, query_table::String; max_rows::Integer = 0, select_cols::String = "", where::String = "", order_by_cols::String = "", format::String="tsv" )
    
    query_select = "select"
    if max_rows > 0 
        query_select *= "+top+" * string(max_rows)
    end
    if length(select_cols) >0
        query_select *= "+" * select_cols 
    else
        query_select *= "+*"
    end
    query_from = "+from+" * query_table
    query_where = length(where)>0 ? "+where+" * where : ""
    query_order_by = length(order_by_cols) > 0 ? "+order+by+" * order_by_cols : ""
    query_format = "&format=" * format
    url = query_base_url * query_select * query_from * query_where * query_order_by * query_format
end

Built with Julia 1.8.2 and

CSV 0.10.7
DataFrames 1.4.2
Plots 1.35.8
PlutoTeachingTools 0.2.5
PlutoUI 0.7.48

To run this tutorial locally, download this file and open it with Pluto.jl.

To run this tutorial locally, download this file and open it with Pluto.jl.

To run this tutorial locally, download this file and open it with Pluto.jl.

To run this tutorial locally, download this file and open it with Pluto.jl.