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:
| Base Lamp   | Lamp Type   | ENERGY             | CLER               | PLC                | TFI                | SAPN               |
|:------------|:------------|:-------------------|:-------------------|:-------------------|:-------------------|:-------------------|
| LED-P       |             |                    |                    |                    |                    |                    |
|             | LED17       | 3.0621988578067763 | 16.167114457625786 | 57.92660522730008  | 74.83172953390991  | 92.53225682048256  |
|             | LED29       | 3.0621988578067763 | 16.30048146847337  | 58.0522217016785   | 75.86568778031516  | 94.73186044625965  |
|             | LED22       | 3.0621988578067763 | 16.68654386829531  | 58.41584833803712  | 78.85872480938305  | 101.10363542842256 |
|             | LED46       | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 75.04940495420573  | 92.99701926623872  |
|             | LED43       | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 75.04940495420573  | 92.99701926623872  |
|             | PT LED17    | 3.0621988578067763 | 21.31929266615861  | 62.779367974340495 | 114.77516915819776 | 177.58631652521674 |
|             | PT LED34    | 3.0621988578067763 | 21.31929266615861  | 62.779367974340495 | 114.77516915819776 | 177.58631652521674 |
|             | LED34       | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 75.04940495420573  | 92.99701926623872  |
|             | LED18       | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 75.04940495420573  | 92.99701926623872  |
|             | LED35       | 3.0621988578067763 | 19.54340562697768  | 61.10668544709085  | 101.00719882448546 | 148.2675990829317  |
|             | LED39       | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 75.04940495420573  | 92.99701926623872  |
|             | LED26       | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 75.04940495420573  | 92.99701926623872  |
|             | LED20       | 3.0621988578067763 | 19.54340562697768  | 61.10668544709085  | 101.00719882448546 | 148.2675990829317  |
|             | LED28       | 3.0621988578067763 | 19.54340562697768  | 61.10668544709085  | 101.00719882448546 | 148.2675990829317  |
|             | LED17_R     | 3.0621988578067763 | 16.195191723067385 | 57.95305080085343  | 77.37908377448487  | 96.71736735225277  |
|             | LED23       | 3.0621988578067763 | 19.89437144499762  | 61.43725511650778  | 103.72814157818355 | 154.06109367175424 |
|             |             |                    |                    |                    |                    |                    |
| LED-V       |             |                    |                    |                    |                    |                    |
|             | LED200      | 3.0621988578067763 | 18.139542354897888 | 59.78440676942319  | 93.55663870273608  | 130.58861761330564 |
|             | LED105      | 3.0621988578067763 | 21.466698309726976 | 62.91820723549561  | 119.35117600779392 | 185.51864358724612 |
|             | LED198      | 3.0621988578067763 | 21.466698309726976 | 62.91820723549561  | 119.35117600779392 | 185.51864358724612 |
|             | LED88       | 3.0621988578067763 | 18.139542354897888 | 59.78440676942319  | 93.55663870273608  | 130.58861761330564 |
|             | LED70       | 3.0621988578067763 | 18.139542354897888 | 59.78440676942319  | 93.55663870273608  | 130.58861761330564 |
|             | LED150      | 3.0621988578067763 | 17.507803882461985 | 59.18938136447272  | 88.65894174607953  | 120.158189222341   |
|             | LED90       | 3.0621988578067763 | 18.139542354897888 | 59.78440676942319  | 93.55663870273608  | 130.58861761330564 |
|             | LED72       | 3.0621988578067763 | 18.139542354897888 | 59.78440676942319  | 93.55663870273608  | 130.58861761330564 |
|             | LED117      | 3.0621988578067763 | 19.54340562697768  | 61.10668544709085  | 104.4404097175284  | 153.7625959685961  |
|             | LED158      | 3.0621988578067763 | 19.54340562697768  | 61.10668544709085  | 104.4404097175284  | 153.7625959685961  |
|             | LED298      | 3.0621988578067763 | 21.466698309726976 | 62.91820723549561  | 119.35117600779392 | 185.51864358724612 |
|             | LED178      | 3.0621988578067763 | 18.139542354897888 | 59.78440676942319  | 93.55663870273608  | 130.58861761330564 |
|             | LED175      | 3.0621988578067763 | 18.490508172917835 | 60.1149764388401   | 96.27758145643416  | 136.38211220212827 |
|             | LED79       | 3.0621988578067763 | 19.54340562697768  | 61.10668544709085  | 104.4404097175284  | 153.7625959685961  |
|             | LED80       | 3.0621988578067763 | 17.507803882461985 | 59.18938136447272  | 88.65894174607953  | 120.158189222341   |
|             | LED150_R    | 3.0621988578067763 | 17.500784566101586 | 59.18276997108438  | 90.93420171128471  | 123.76501936077094 |
|             | LED80_R     | 3.0621988578067763 | 18.51858543835944  | 60.14142201239346  | 98.82493569700917  | 140.56722273389846 |
|             | LED60       | 3.0621988578067763 | 17.33232097345201  | 59.024096529764265 | 87.29847036923049  | 117.25609660021992 |
|             | LED155      | 3.0621988578067763 | 21.26313813527541  | 62.72647682723378  | 117.77302921064909 | 182.1517885193689  |
|             | LED81       | 3.0621988578067763 | 21.26313813527541  | 62.72647682723378  | 117.77302921064909 | 182.1517885193689  |
|             | LED101      | 3.0621988578067763 | 21.26313813527541  | 62.72647682723378  | 117.77302921064909 | 182.1517885193689  |

## Output:


source: excel_file
label: subtitle