correlate
Compute Pearson correlation between two numeric columns across datasets, joined on shared keys, to reveal relationships like wind speed and air quality.
Instructions
Pearson correlation between two numeric columns across two datasets.
Joins the tables on their shared keys (obs_date and/or region_code) and returns corr(col_a, col_b) plus the joined sample size. Example: correlate weather.avg_wind_ms with air_quality.pm10 to see whether windy days have cleaner air. Table and column names are validated against the live schema before use.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| col_a | Yes | ||
| col_b | Yes | ||
| table_a | Yes | ||
| table_b | Yes |