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:
| Evoenergy labour category   | MJ Labour category (AER allocation)   | EvoEnergy rate (with overheads) - normal hours - 2019-20   | Notes   | MJ max labour rate escalated to 2019-20 (by CPI only)   | Labour rate adjustment required (Evo rate > MJ max recommended rate)?   |
|:----------------------------|:--------------------------------------|:-----------------------------------------------------------|:--------|:--------------------------------------------------------|:------------------------------------------------------------------------|
| Office Labour               |                                       |                                                            |         |                                                         |                                                                         |
| Connection Engineer         | Engineer                              | 128.3746197                                                | 0.0     | 195.9355316                                             | 0.0                                                                     |
| Management                  | Senior Engineer                       | 161.6270171                                                | 0.0     | 215.5239622                                             | 0.0                                                                     |
| GIS Officer                 | 0                                     | 115.7103839                                                | 0.0     | 156.7484253                                             | 0.0                                                                     |
| Field Services              |                                       |                                                            |         |                                                         |                                                                         |
| Site Lead/Scheduler ( SL)   | 0                                     | 176.5560378                                                | 1.0     | 156.7484253                                             | 1.0                                                                     |
| Electrical Fitter (EF)      | 0                                     | 176.5560378                                                | 1.0     | 156.7484253                                             | 1.0                                                                     |
| Electrical Operator (EO)    | 0                                     | 176.5560378                                                | 1.0     | 156.7484253                                             | 1.0                                                                     |
| Plant Operator (PO)         | 0                                     | 176.5560378                                                | 1.0     | 156.7484253                                             | 1.0                                                                     |
| Line Worker (LW)            | 0                                     | 176.5560378                                                | 1.0     | 156.7484253                                             | 1.0                                                                     |
| Trade Assistant/Labour (TA) | Field Worker                          | 136.6714796                                                | 1.0     | 151.1136779                                             | 0.0                                                                     |

## Output:


source: excel_file
label: subtitle