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:
| Season              | DVD Releases(Region 1)(Date)   |   DVD Releases(Region 1)(Discs) | DVD Releases(Region 2)(Date)   |   DVD Releases(Region 2)(Discs) | DVD Releases(Region 4)(Date)   |   DVD Releases(Region 4)(Discs) |
|:--------------------|:-------------------------------|--------------------------------:|:-------------------------------|--------------------------------:|:-------------------------------|--------------------------------:|
| 1                   | 30-Aug-05                      |                               3 | 27-Feb-06                      |                               6 | 12-Jul-06                      |                               6 |
| 2                   | 22-Aug-06                      |                               6 | 23-Oct-06                      |                               6 | 25-Oct-06                      |                               6 |
| 3                   | 21-Aug-07                      |                               5 | 19-Nov-07                      |                               6 | 19-Sep-07                      |                               6 |
| 4                   | 19-Aug-08                      |                               4 | 27-Oct-08                      |                               4 | 20-Aug-08                      |                               4 |
| 5                   | 25-Aug-09                      |                               5 | 5-Oct-09                       |                               6 | 30-Oct-09                      |                               6 |
| 6                   | 31-Aug-10                      |                               5 | 27-Sep-10                      |                               6 | 19-Aug-10                      |                               6 |
| 7                   | 30-Aug-11                      |                               5 | 26-Sep-11                      |                               6 | 30-Aug-11                      |                               6 |
| 8                   | 21-Aug-12                      |                               5 | 22-Oct-12                      |                               6 | 11-Oct-12                      |                               6 |
| The Complete Series | 2-Oct-12                       |                              41 | 22-Oct-12                      |                              46 | 11-Oct-12                      |                              46 |

## Output:


source: web
label: operator: wide_to_long
wide_to_long_start_idx: 1
wide_to_long_end_idx: 6