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:
| Desc   | ID    |   Size |   Price | Colors                     |
|:-------|:------|-------:|--------:|:---------------------------|
| Hic    | S4162 |      0 |   32.66 | Yellow, Green, Blue        |
| Det    | F4478 |      0 |   86.32 | Green, Black, Red          |
| Wum    | N9551 |      1 |   56.75 | 0                          |
| Nef    | G4058 |      2 |   16.85 | Green, Black, Blue, Yellow |
| Kid    | M4124 |      3 |   35.4  | Blue, Red, Green           |
| Moc    | D6429 |      3 |   38.34 | Green, Black               |
| Teb    | D6219 |      0 |   92.6  | Black, Blue                |
| Goh    | N6858 |      3 |   24.81 | Blue, Red                  |
| Nup    | D3028 |      2 |   13.62 | 1                          |
| Dar    | P5336 |      2 |   94.3  | Black, Yellow, Green, Red  |
| Sep    | H5408 |      0 |   46.42 | 2                          |
| Keg    | K1919 |      1 |   65.67 | Blue, Red, Green, Black    |
| Huc    | S3840 |      2 |   25.32 | Yellow, Black, Green       |
| Luh    | N5050 |      0 |   18.57 | Blue, Yellow, Red          |
| Vof    | D5368 |      0 |   89.03 | Blue, Red, Yellow          |
| Rif    | P8966 |      2 |   29.97 | 0                          |
| Pav    | H1756 |      2 |   30.42 | Red, Yellow, Black         |
| Leg    | F3006 |      1 |   10.15 | Red, Green, Black, Blue    |
| Nif    | M2228 |      2 |   22.27 | Yellow, Blue               |
| Pec    | B2448 |      1 |   47.69 | 1                          |
| Dut    | F2709 |      1 |   53.46 | Yellow, Black              |
| Viv    | N5044 |      2 |   32.05 | Black                      |
| Bov    | H4912 |      0 |   13.88 | Red, Green                 |
| Fes    | J2948 |      2 |   55.84 | Yellow, Red, Blue          |
| Len    | N3316 |      1 |   84.06 | 2                          |
| Deh    | F7804 |      2 |   39.13 | Black, Yellow, Green       |
| Juc    | N9050 |      2 |   82.26 | Blue, Black, Red           |
| Fik    | K4149 |      2 |   79.77 | Red, Black                 |
| Hag    | T4758 |      2 |   33.37 | Blue, Green                |
| Sav    | J7355 |      0 |   98.53 | 0                          |

## Output:


source: excel_file
label: explode