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:
| Giorno   |   Ora | 3 AMT                                                     | 4 AMT                                                | 5 TIM                               | 5TIEL                           |
|:---------|------:|:----------------------------------------------------------|:-----------------------------------------------------|:------------------------------------|:--------------------------------|
| LUN      |     0 | 0                                                         | 0                                                    | 0                                   | 0                               |
|          |     1 | 0                                                         | 0                                                    | 0                                   | 0                               |
|          |     2 | 1                                                         | 1                                                    | 1                                   | 1                               |
|          |     3 | 1                                                         | 1                                                    | 1                                   | 1                               |
|          |     4 | 2                                                         | 1                                                    | 2                                   | 0                               |
| MAR      |     0 | 3                                                         | TECNIOLOGIE MECCANICHE E APPLI - FANTASIA - CANNILLO | 3                                   | 2                               |
|          |     1 | 4                                                         | 2                                                    | 4                                   | 3                               |
|          |     2 | 5                                                         | 3                                                    | 4                                   | 3                               |
|          |     3 | 5                                                         | 4                                                    | 4                                   | 3                               |
|          |     4 |                                                           | 5                                                    | 5                                   | 4                               |
| MER      |     0 | TEC. INSTAL. E MANUTENZIONE - DE BENEDICTIS - TRIBUZIO    | 4                                                    | STORIA - POLI ANGELA - 5TIEL        | STORIA - POLI ANGELA - 5 TIM    |
|          |     1 | 4                                                         | 5                                                    | 5                                   | 4                               |
|          |     2 | 6                                                         | 3                                                    | 4                                   | 5                               |
|          |     3 | 6                                                         | 3                                                    | 4                                   | 5                               |
|          |     4 | TECNOLOGIE ELETTRICO-ELETTRONI - DE BENEDICTIS - TRIBUZIO |                                                      | 3                                   | 2                               |
| GIO      |     0 | RELIGIONE - CUZZUOL VALERIA                               | 6                                                    | 0                                   | 5                               |
|          |     1 | 2                                                         | 7                                                    | 0                                   | 6                               |
|          |     2 | 3                                                         | 7                                                    | 4                                   | 6                               |
|          |     3 | 7                                                         | 2                                                    | 1                                   | 1                               |
|          |     4 | 7                                                         | 6                                                    | ED. FISICA - ED. FISICA - 5TIEL     | ED. FISICA - ED. FISICA - 5 TIM |
| VEN      |     0 | 8                                                         | TEC. INSTAL. E MANUTENZIONE - LEONARDINI - TRIBUZIO  | 2                                   | 0                               |
|          |     1 | 8                                                         | 4                                                    | 2                                   | 0                               |
|          |     2 | 6                                                         | 8                                                    | 3                                   | 2                               |
|          |     3 | 4                                                         | 8                                                    | 5                                   | 4                               |
|          |     4 |                                                           |                                                      | TECNICA DELLA PRODUZIONE - FANTASIA | 6                               |

## Output:


source: excel_file
label: operator: ffill
ffill_end_idx: 0
operator: stack
stack_start_idx: 2
stack_end_idx: 5
alternative_label: operator: stack
stack_start_idx: 2
stack_end_idx: 5
operator: ffill
ffill_end_idx: 0