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:
| Volume   | Book 1: Water(Released)   |   Book 1: Water(Discs) |   Book 1: Water(Episodes) | Book 2: Earth(Released)                      | Book 2: Earth(Discs)                         | Book 2: Earth(Episodes)                      | Book 3: Fire(Released)                       | Book 3: Fire(Discs)                          | Book 3: Fire(Episodes)                       |
|:---------|:--------------------------|-----------------------:|--------------------------:|:---------------------------------------------|:---------------------------------------------|:---------------------------------------------|:---------------------------------------------|:---------------------------------------------|:---------------------------------------------|
| 1        | March 15, 2007            |                      1 |                         4 | June 4, 2009                                 | 1                                            | 5                                            | June 3, 2010                                 | 1                                            | 5                                            |
| 2        | July 5, 2007              |                      1 |                         4 | August 4, 2009                               | 1                                            | 5                                            | September 23, 2010                           | 1                                            | 5                                            |
| 3        | March 13, 2008            |                      1 |                         4 | October 29, 2009                             | 1                                            | 5                                            | October 7, 2010                              | 1                                            | 5                                            |
| 4        | June 19, 2008             |                      1 |                         4 | March 31, 2010                               | 1                                            | 5                                            | November 4, 2010                             | 1                                            | 6                                            |
| 5        | March 5, 2009             |                      1 |                         4 | There is no volume five DVD for this season. | There is no volume five DVD for this season. | There is no volume five DVD for this season. | There is no volume five DVD for this season. | There is no volume five DVD for this season. | There is no volume five DVD for this season. |
| Box set  | June 4, 2009              |                      5 |                        20 | September 9, 2010                            | 4                                            | 20                                           | December 2, 2010                             | 4                                            | 21                                           |

## Output:


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