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:
| Indicator                                                                              |   Q1 2012/13 |   Q2 2012/13 |   Q3 2012/13 |   Q4 2012/13 |   Q1 2013/14 |   Q2 2013/14 |   Q3 2013/14 |   Q4 2012/14 |
|:---------------------------------------------------------------------------------------|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|
| The total number of energy efficiency installations in GB households                   |        25.84 |        25.26 |        26.29 |        27.54 |        24.19 |        26.07 |        26.12 |         28.5 |
| The number of households in fuel poverty in England                                    |         3.5  |         4    |         3.2  |         3.3  |         3.1  |         3.4  |         3.1  |          3.8 |
| Percentage of energy consumed in the UK that has been generated from renewable sources |         3.8  |         3.2  |         3.3  |         3.6  |         4    |         3.6  |         3.6  |          3.6 |
| The spare capacity of the UK's gas network                                             |        90    |        41    |        80    |        83    |        68    |        79    |        56    |         61   |
| The spare capacity of the UK's electricity network                                     |        36    |        30    |        30    |        39    |        30    |        36    |        34    |         38   |
| Total emissions of greenhouse gases from the UK                                        |       549.3  |       590.4  |       548.8  |       545.6  |       547.3  |       548.7  |       544.7  |        549   |
| Reduction in the Nuclear Provision through decommissioning and clean-up                |         2.2  |         1.8  |         2.7  |         1.4  |         2.2  |         2.6  |         2.6  |          1.6 |
| The proportion of all UK energy supply from low carbon sources                         |        12.5  |        10.2  |        12.7  |        10.4  |        10.8  |        10.4  |        10.8  |         12.5 |

## Output:


source: excel_file
label: transpose