Task: Data-transform-reshape (source dataset: Auto-Tables)

Given a table, predict what python pandas transformation may be needed on the given input table. Valid choices for transformation include: {"stack", "wide_to_long", "transpose", "pivot", "explode", "ffill", "subtitles"}. Note that each of these is a common Python Pandas operator. Some transformations can have parameters. Each transformation and its parameters are describe as follows.
 
- stack: collapse homogeneous cols into rows.
@param (int): stack_start_idx: zero-based starting column index of the homogeneous column-group.
@param (int): stack_end_idx: zero-based ending column index of the homogeneous column-group.
 
- wide_to_long: collapse repeating col-groups into rows.
@param (int): wide_to_long_start_idx: zero-based starting column index of the repeating col-groups.
@param (int): wide_to_long_end_idx: zero-based ending column index of the repeating col-groups.
 
- transpose: convert rows to columns and vice versa.
 
- pivot: pivot repeating row-groups into cols.
@param (int): pivot_row_frequency: frequency of repeating row-groups.
 
- ffill: fill structurally empty cells in tables.
@param (int): ffill_end_idx: zero-based ending column index of the columns to be filled.
 
- explode: convert composite cells into atomic values
@param (int): explode_column_idx: zero-based column index of the column to be exploded.
 
- subtitle: convert table subtitles into a column.
 
OUTPUT the predicted transformation name along with its parameters for the given INPUT table in a JSON, e.g., {"transformation": "stack", "stack_start_idx": 1, "stack_end_idx": 5}. If the input table needs multi-step transformations (e.g, ffill followed by stack), list JSON of each transformation sequentially in a list, e.g., [{"transformation": "ffill", "ffill_end_idx": 1}, {"transformation": "stack", "stack_start_idx": 1, "stack_end_idx": 5}]. No explanation is needed.

## Input:
| Release 1 (in Points)                         | Start   | Sprint 1   | Sprint 2   | Sprint 3   | Sprint 4   | Sprint 5   | Sprint 6   | Sprint 7   | Sprint 8   | Sprint 9   | Sprint 10   | Sprint 11   | Sprint 12   |
|:----------------------------------------------|:--------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:------------|:------------|:------------|
| FORECASTS                                     |         |            |            |            |            |            |            |            |            |            |             |             |             |
| Forecast: Work remaining at start of sprint   | 720.0   | 720.0      | 666.0      | 594.0      | 486.0      | 342.0      | 198.0      | 108.0      | 36.0       | 0.0        | 0.0         | 0.0         | 0.0         |
| Forecast: Velocity                            |         | 54.0       | 72.0       | 108.0      | 144.0      | 144.0      | 90.0       | 72.0       | 36.0       | 0.0        | 0.0         | 0.0         | 0.0         |
| Forecast: Work remaining at the end of sprint | 720.0   | 666.0      | 594.0      | 486.0      | 342.0      | 198.0      | 108.0      | 36.0       | 0.0        | 0.0        | 0.0         | 0.0         | 0.0         |
| ACTUALS                                       |         |            |            |            |            |            |            |            |            |            |             |             |             |
| Actual: Work remaining at start of sprint     | 720.0   | 720.0      | 666.0      | 594.0      | 486.0      | 342.0      | 198.0      | 108.0      | 36.0       | 0.0        | 0.0         | 0.0         | 0.0         |
| Actual Velocity                               |         | 54.0       | 72.0       | 108.0      | 144.0      | 144.0      | 90.0       | 72.0       | 36.0       | 0.0        | 0.0         | 0.0         | 0.0         |
| Actual Work remaining at the end of sprint    | 720.0   | 666.0      | 594.0      | 486.0      | 342.0      | 198.0      | 108.0      | 36.0       | 0.0        | 0.0        | 0.0         | 0.0         | 0.0         |
| TEAM CAPACITY                                 |         |            |            |            |            |            |            |            |            |            |             |             |             |
| Forecast: Planned Resources (FTE)             |         | 3.0        | 4.0        | 6.0        | 8.0        | 8.0        | 5.0        | 4.0        | 2.0        | 0.0        | 0.0         | 0.0         | 0.0         |
| Forecast: Planned Mandays                     |         | 54.0       | 72.0       | 108.0      | 144.0      | 144.0      | 90.0       | 72.0       | 36.0       | 0.0        | 0.0         | 0.0         | 0.0         |
| Estimated: Efficiency Factor                  |         | 1.0        | 1.0        | 1.0        | 1.0        | 1.0        | 1.0        | 1.0        | 1.0        | 1.0        | 1.0         | 1.0         | 1.0         |

## Output:


source: excel_file
label: operator: subtitle
operator: stack
stack_start_idx: 2
stack_end_idx: 13
alternative_label: operator: stack
stack_start_idx: 2
stack_end_idx: 13
operator: subtitle