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:
| Column1             | Aliases                        |     Hardy |   Heat |   Drought |   Shade |   Flood |    Low | Growth         |   Median |   +/- |
|                     |                                |   Through |        |           |         |         |   Fert | Habit          |          |       |
|                     |                                |      Zone |        |           |         |         |        |                |          |       |
|:--------------------|:-------------------------------|----------:|-------:|----------:|--------:|--------:|-------:|:---------------|---------:|------:|
| Annual ryegrass     | Italian ryegrass               |         6 |      1 |         1 |       3 |       3 |      1 | 0              |     6.5  |  0.5  |
| Barley              |                                |         0 |      0 |         3 |       2 |       1 |      3 | 0              |     7.25 |  1.25 |
| Oats                | spring oats                    |         8 |      1 |         1 |       1 |       2 |      2 | 0              |     6    |  1.5  |
| Cereal rye          | winter or grain rye            |         3 |      1 |         3 |       3 |       2 |      4 | 0              |     6    |  1    |
| Wheat               |                                |         4 |      2 |         2 |       2 |       0 |      2 | 0              |     6.75 |  0.75 |
| Buckwheat           |                                |         1 |      1 |         0 |       1 |       1 |      1 | 1              |     6    |  1    |
| Sorghum–sudangrass  | Sudax                          |         1 |      2 |         4 |       2 |       2 |      2 | 0              |     6.5  |  0.5  |
| Mustards            | brown, oriental, white, yellow |         0 |      1 |         3 |       2 |       1 |      1 | 0              |     6.5  |  1    |
| Radish              | oilseed, Daikon, forage        |         6 |      2 |         1 |       2 |       1 |      2 | 0              |     6.75 |  0.75 |
| Rapeseed            | rape, canola                   |         0 |      3 |         2 |       2 |       1 |      1 | 0              |     6.75 |  1.25 |
| Berseem clover      | Bigbee, multicut               |         7 |      3 |         2 |       3 |       2 |      2 | 1              |     6.6  |  0.4  |
| Cowpeas             | crowder peas, southern peas    |         1 |      2 |         3 |       2 |       1 |      4 | 2              |     6    |  0.5  |
| Crimson clover      |                                |         0 |      1 |         1 |       3 |       1 |      2 | 0              |     6.75 |  1.25 |
| Field peas          | winter peas, black peas        |         0 |      3 |         2 |       1 |       1 |      1 | 2              |     6.5  |  0.5  |
| Hairy vetch         | winter vetch                   |         2 |      1 |         2 |       2 |       1 |      1 | 2              |     6.5  |  1    |
| Medics              |                                |         2 |      2 |         3 |       3 |       1 |      2 | 3              |     6.5  |  0.5  |
| Red clover          |                                |         2 |      1 |         1 |       3 |       2 |      1 | 0              |     6.6  |  0.4  |
| Subterranean clover | subclover                      |         0 |      1 |         3 |       3 |       2 |      4 | 3              |     6.25 |  0.75 |
| Sweetclovers        |                                |         2 |      0 |         4 |       1 |       1 |      4 | 0              |     7    |  0.25 |
| White clover        | white dutch ladino             |         2 |      1 |         2 |       3 |       3 |      2 | 3              |     6.5  |  0.5  |
| Woollypod vetch     | Lana                           |         0 |      3 |         3 |       2 |       2 |      3 | Semi-prostrate |     7    |  1    |

## Output:


source: excel_file
label: explode