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:
|   Uniform | First Name2   | Last Name   |   Grad Year | Positions          |   Pitcher | Bats   |   Throws | Height   |   Weight | School                 | GPA   |
|----------:|:--------------|:------------|------------:|:-------------------|----------:|:-------|---------:|:---------|---------:|:-----------------------|:------|
|         1 | Tiegen        | Lindner     |        2016 | 2B, SS, OF         |         0 | S      |        0 | 5' 8"    |      145 | O'Gorman High School   | 4.3   |
|         2 | Michael       | Dooney      |        2017 | 2B, SS, OF, 3C, 4D |         0 | 0      |        0 | 0        |      165 | 0                      | 3.4   |
|         3 | Chad          | Hinkle      |        2016 | 1A, 3A, 4A         |         1 | L      |        1 | 6' 0"    |      165 | 1                      |       |
|         4 | Calvin        | Brinda      |        2017 | 1B, 3B, 2C         |         2 | 0      |        2 | 1        |      160 | Stillwater High School |       |
|         7 | Ross          | 0           |        2017 | 1B, 3B, SS, OF     |         2 | 1      |        2 | 0        |      185 | 0                      | 4.02  |
|         8 | 0             | 0           |        2017 | 1B, 2C, 3B, 4D     |         2 | 1      |        2 | 0        |      160 | 0                      | 4.03  |
|         9 | John          | Price       |        2016 | 1B, 3B, OF         |         2 | 2      |        2 | 2        |      190 | Lakeville South        | 3.4   |
|        10 | 1             | Wade        |        2016 | 1A, 2B             |         2 | 2      |        2 | 1        |      175 | Minnetonka High School |       |
|        11 | Aidan         | Maldonado   |        2018 | 1D, 2D             |         2 | 2      |        2 | 2        |      155 | 1                      | 3.6   |
|        12 | Tommy         | Springer    |        2018 | SS, OF             |         2 | 2      |        2 | 2        |      182 | Eastview High School   |       |
|        13 | Matthew       | Morgan      |        2016 | C                  |         0 | 2      |        2 | 6' 1"    |      190 | Bemidji High School    | 3.48  |
|        14 | 1             | Roskam      |        2016 | C, 1B              |         0 | 1      |        2 | 0        |      215 | Chaska High School     | 3.09  |
|        15 | Sam           | Goodman     |        2016 | 1B, OF             |         1 | 1      |        1 | 3        |      206 | champlin park          | 3.0   |
|        16 | Jake          | Mayers      |        2018 | 3B                 |         2 | 2      |        2 | 3        |      210 | Eastview               | 2.85  |
|        17 | 0             | Thompson    |        2016 | 1C, 2C             |         2 | 2      |        2 | 6' 4"    |      185 | Byron                  | 3.0   |

## Output:


source: excel_file
label: explode