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:
| Colonna1   |   Colonna2 | ALTOMONTE DIEGO   | CUZZUOL VALERIA             | DE BENEDICTIS                                      | FANTASIA                                           | FIUME   | FONZETTI                                           | IMPERATO LIDIA   | LEONARDINI                                      | TRIBUZIO                                                |
|:-----------|-----------:|:------------------|:----------------------------|:---------------------------------------------------|:---------------------------------------------------|:--------|:---------------------------------------------------|:-----------------|:------------------------------------------------|:--------------------------------------------------------|
| LUN        |          0 |                   |                             |                                                    | 0                                                  |         |                                                    |                  |                                                 |                                                         |
|            |          1 |                   |                             |                                                    | 1                                                  |         |                                                    | 0.0              | 0                                               |                                                         |
|            |          2 |                   |                             | 0                                                  | 2                                                  |         |                                                    | 1.0              | 0                                               | 0                                                       |
|            |          3 |                   |                             | 0                                                  | 2                                                  |         |                                                    | 2.0              |                                                 | 0                                                       |
|            |          4 |                   |                             | 1                                                  | 3                                                  |         |                                                    |                  |                                                 |                                                         |
| MAR        |          0 | 0.0               |                             |                                                    | 4                                                  |         |                                                    |                  |                                                 |                                                         |
|            |          1 | 0.0               |                             |                                                    | 4                                                  |         |                                                    |                  |                                                 | 1                                                       |
|            |          2 | 1.0               |                             | 3 IPMM - TECNOLOGIE ELETTRICO-ELETTRONI            | 3 IPAI - TECNIOLOGIE MECCANICHE E APPLI - FONZETTI |         | 3 IPAI - TECNIOLOGIE MECCANICHE E APPLI - FANTASIA |                  |                                                 | 1                                                       |
|            |          3 |                   |                             | 2                                                  | 4 IP09 - TECNIOLOGIE MECCANICHE E APPLI - FONZETTI |         | 4 IP09 - TECNIOLOGIE MECCANICHE E APPLI - FANTASIA | 0.0              |                                                 | 2                                                       |
|            |          4 | 0.0               |                             | 2                                                  |                                                    |         |                                                    | 2.0              |                                                 | 2                                                       |
| MER        |          0 |                   |                             | 3                                                  |                                                    | 0.0     |                                                    | 2.0              |                                                 |                                                         |
|            |          1 |                   |                             | 4                                                  | 5                                                  | 1.0     |                                                    | 1.0              |                                                 | 3                                                       |
|            |          2 | 1.0               |                             | 4                                                  | 5                                                  |         |                                                    |                  |                                                 | 3                                                       |
|            |          3 | 1.0               |                             | 5                                                  | 3                                                  |         |                                                    |                  |                                                 | 1                                                       |
|            |          4 |                   |                             | 5                                                  | 3                                                  |         |                                                    |                  | 4 IP09 - TEC. INSTAL. E MANUTENZIONE - TRIBUZIO | 4 IP09 - TEC. INSTAL. E MANUTENZIONE - LEONARDINI       |
| GIO        |          0 |                   |                             | 3                                                  |                                                    |         |                                                    | 0.0              |                                                 | 4                                                       |
|            |          1 |                   |                             | 3                                                  | 0                                                  |         | 0                                                  |                  |                                                 | 4                                                       |
|            |          2 |                   |                             |                                                    | 0                                                  |         | 0                                                  | 1.0              |                                                 | 4                                                       |
|            |          3 |                   |                             | 1                                                  | 3 IPMM - TECNIOLOGIE MECCANICHE E APPLI - FONZETTI |         | 3 IPMM - TECNIOLOGIE MECCANICHE E APPLI - FANTASIA | 1.0              |                                                 | 5                                                       |
|            |          4 |                   |                             | 5 IP09 - TECNOLOGIE ELETTRICO-ELETTRONI            | 3 IPMM - tecnologie e tecn. di diag. e - FONZETTI  |         | 3 IPMM - tecnologie e tecn. di diag. e - FANTASIA  | 2.0              |                                                 | 5                                                       |
| VEN        |          0 |                   | 3 IPAI - 3 IPMM - RELIGIONE | 6                                                  |                                                    |         |                                                    |                  |                                                 | 6                                                       |
|            |          1 |                   | 5 IP09 - RELIGIONE          | 6                                                  |                                                    |         |                                                    | 0.0              |                                                 | 6                                                       |
|            |          2 |                   |                             | 5 IP09 - TECNOLOGIE ELETTRICO-ELETTRONI - TRIBUZIO |                                                    | 1.0     |                                                    | 0.0              |                                                 | 5 IP09 - TECNOLOGIE ELETTRICO-ELETTRONI - DE BENEDICTIS |
|            |          3 |                   |                             |                                                    | 1                                                  | 0.0     |                                                    | 2.0              |                                                 |                                                         |
|            |          4 |                   |                             |                                                    |                                                    |         |                                                    | 1.0              |                                                 |                                                         |

## Output:


source: excel_file
label: ffill