compare_weekday_weekend
Analyze differences in metric values between weekdays and weekends using statistical comparisons to identify patterns in time-series data.
Instructions
Compare weekday vs weekend values for a metric.
Args: name: Name of the dataframe value_column: Column containing the values to compare (e.g., 'PM2.5', 'sales') date_column: Column containing dates (default: 'date') day_of_week_column: Column containing day names (default: 'day_of_week') group_by: Optional column to group by (e.g., 'city', 'station')
Returns: Comparison of weekday vs weekend averages with statistics.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| value_column | Yes | ||
| date_column | No | date | |
| day_of_week_column | No | day_of_week | |
| group_by | No |