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:
| Name         | 1          | 2          | 3          | 4          | 5          | 6          | 7          | 8          | 9          | 10         | 11         | 12         | 13         | 14         | 15         | 16         | 17         | 18         | 19         | 20         | 21         | 22         | 23         | 24         | 25         | 26         |
|:-------------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|
| B Bond       | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  |
| Guns         | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants |
| John and Pat | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  |
| PieMan       | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash |
| Barbie Cobb  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  |
| Mauler       | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    |
| Jim P        | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    |
| MOW          | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  |
| Burkus       | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  |
| Drillers     | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona |
| John W       | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    |
| Howie Cobb   | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   |
| Lewy         | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD |
| Cookie       | KC/Pitts   | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    |
| M Smith      | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    | Cubs/WS    | Angels/LAD | Mil/Phil   | Sea/Atl    | TB/Arizona | KC/Pitts.  | Balt/Rock  | RSox/SD    | Det/Flo    | TX/Astros  | Jays/ Wash | Twins/STL  | A's/Giants | Clev/Reds  | NYY/NYM    |

## Output:


source: excel_file
label: operator: stack
stack_start_idx: 1
stack_end_idx: 26
alternative_label: operator: transpose
operator: stack
stack_start_idx: 1
stack_end_idx: 15