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:
| Tenor   |   Item | USD                           | EUR                           | GBP                           | JPY                           | CAD                           | AUD                           |
|:--------|-------:|:------------------------------|:------------------------------|:------------------------------|:------------------------------|:------------------------------|:------------------------------|
| 1 YEAR  |      0 | 1                             | 0                             | 0.5                           | 0                             | 1                             | 1.75                          |
|         |      1 | 57056D CY8                    | 57056D CZ5                    | 57056D DA9                    | 57056D DB7                    | 57056D DC5                    | 57056D DD3                    |
|         |      2 | US57056DCY85                  | US57056DCZ50                  | US57056DDA90                  | US57056DDB73                  | US57056DDC56                  | US57056DDD30                  |
|         |      3 | USD 1.00 06/21/2017 1 YR CME  | EUR 0.00 06/21/2017 1 YR CME  | GBP 0.50 06/21/2017 1 YR CME  | JPY 0.00 06/21/2017 1 YR CME  | CAD 1.00 06/21/2017 1 YR CME  | AUD 1.75 06/21/2017 1 YR CME  |
|         |      4 | 57056D AA2                    | 57056D AB0                    | 57056D AC8                    | 57056D AD6                    | 57056D AE4                    | 57056D AF1                    |
|         |      5 | US57056DAA28                  | US57056DAB01                  | US57056DAC83                  | US57056DAD66                  | US57056DAE40                  | US57056DAF15                  |
|         |      6 | USD 1.00 06/21/2017 1 YR LCH  | EUR 0.00 06/21/2017 1 YR LCH  | GBP 0.50 06/21/2017 1 YR LCH  | JPY 0.00 06/21/2017 1 YR LCH  | CAD 1.00 06/21/2017 1 YR LCH  | AUD 1.75 06/21/2017 1 YR LCH  |
| 2 YEAR  |      0 | 1.25                          | 0                             | 0.5                           | 0                             | 1                             | 1.75                          |
|         |      1 | 57056D DE1                    | 57056D DF8                    | 57056D DG6                    | 57056D DH4                    | 57056D DJ0                    | 57056D DK7                    |
|         |      2 | US57056DDE13                  | US57056DDF87                  | US57056DDG60                  | US57056DDH44                  | US57056DDJ00                  | US57056DDK72                  |
|         |      3 | USD 1.25 06/21/2017 2 YR CME  | EUR 0.00 06/21/2017 2 YR CME  | GBP 0.50 06/21/2017 2 YR CME  | JPY 0.00 06/21/2017 2 YR CME  | CAD 1.00 06/21/2017 2 YR CME  | AUD 1.75 06/21/2017 2 YR CME  |
|         |      4 | 57056D AG9                    | 57056D AH7                    | 57056D AJ3                    | 57056D AK0                    | 57056D AL8                    | 57056D AM6                    |
|         |      5 | US57056DAG97                  | US57056DAH70                  | US57056DAJ37                  | US57056DAK00                  | US57056DAL82                  | US57056DAM65                  |
|         |      6 | USD 1.25 06/21/2017 2 YR LCH  | EUR 0.00 06/21/2017 2 YR LCH  | GBP 0.50 06/21/2017 2 YR LCH  | JPY 0.00 06/21/2017 2 YR LCH  | CAD 1.00 06/21/2017 2 YR LCH  | AUD 1.75 06/21/2017 2 YR LCH  |
| 3 YEAR  |      0 | 1.25                          | 0                             | 0.5                           | 0                             | 1                             | 1.75                          |
|         |      1 | 57056D DL5                    | 57056D DM3                    | 57056D DN1                    | 57056D DP6                    | 57056D DQ4                    | 57056D DR2                    |
|         |      2 | US57056DDL55                  | US57056DDM39                  | US57056DDN12                  | US57056DDP69                  | US57056DDQ43                  | US57056DDR26                  |
|         |      3 | USD 1.25 06/21/2017 3 YR CME  | EUR 0.00 06/21/2017 3 YR CME  | GBP 0.50 06/21/2017 3 YR CME  | JPY 0.00 06/21/2017 3 YR CME  | CAD 1.00 06/21/2017 3 YR CME  | AUD 1.75 06/21/2017 3 YR CME  |
|         |      4 | 57056D AN4                    | 57056D AP9                    | 57056D AQ7                    | 57056D AR5                    | 57056D AS3                    | 57056D AT1                    |
|         |      5 | US57056DAN49                  | US57056DAP96                  | US57056DAQ79                  | US57056DAR52                  | US57056DAS36                  | US57056DAT19                  |
|         |      6 | USD 1.25 06/21/2017 3 YR LCH  | EUR 0.00 06/21/2017 3 YR LCH  | GBP 0.50 06/21/2017 3 YR LCH  | JPY 0.00 06/21/2017 3 YR LCH  | CAD 1.00 06/21/2017 3 YR LCH  | AUD 1.75 06/21/2017 3 YR LCH  |
| 4 YEAR  |      0 | 1.25                          | 0                             | 0.5                           | 0                             | 1                             | 1.75                          |
|         |      1 | 57056D DS0                    | 57056D DT8                    | 57056D DU5                    | 57056D DV3                    | 57056D DW1                    | 57056D DX9                    |
|         |      2 | US57056DDS09                  | US57056DDT81                  | US57056DDU54                  | US57056DDV38                  | US57056DDW11                  | US57056DDX93                  |
|         |      3 | USD 1.25 06/21/2017 4 YR CME  | EUR 0.00 06/21/2017 4 YR CME  | GBP 0.50 06/21/2017 4 YR CME  | JPY 0.00 06/21/2017 4 YR CME  | CAD 1.00 06/21/2017 4 YR CME  | AUD 1.75 06/21/2017 4 YR CME  |
|         |      4 | 57056D AU8                    | 57056D AV6                    | 57056D AW4                    | 57056D AX2                    | 57056D AY0                    | 57056D AZ7                    |
|         |      5 | US57056DAU81                  | US57056DAV64                  | US57056DAW48                  | US57056DAX21                  | US57056DAY04                  | US57056DAZ78                  |
|         |      6 | USD 1.25 06/21/2017 4 YR LCH  | EUR 0.00 06/21/2017 4 YR LCH  | GBP 0.50 06/21/2017 4 YR LCH  | JPY 0.00 06/21/2017 4 YR LCH  | CAD 1.00 06/21/2017 4 YR LCH  | AUD 1.75 06/21/2017 4 YR LCH  |
| 5 YEAR  |      0 | 1.25                          | 0                             | 0.5                           | 0                             | 1                             | 2                             |
|         |      1 | 57056D DY7                    | 57056D DZ4                    | 57056D EA8                    | 57056D EB6                    | 57056D EC4                    | 57056D ED2                    |
|         |      2 | US57056DDY76                  | US57056DDZ42                  | US57056DEA81                  | US57056DEB64                  | US57056DEC48                  | US57056DED21                  |
|         |      3 | USD 1.25 06/21/2017 5 YR CME  | EUR 0.00 06/21/2017 5 YR CME  | GBP 0.50 06/21/2017 5 YR CME  | JPY 0.00 06/21/2017 5 YR CME  | CAD 1.00 06/21/2017 5 YR CME  | AUD 2.00 06/21/2017 5 YR CME  |
|         |      4 | 57056D BA1                    | 57056D BB9                    | 57056D BC7                    | 57056D BD5                    | 57056D BE3                    | 57056D BF0                    |
|         |      5 | US57056DBA19                  | US57056DBB91                  | US57056DBC74                  | US57056DBD57                  | US57056DBE31                  | US57056DBF06                  |
|         |      6 | USD 1.25 06/21/2017 5 YR LCH  | EUR 0.00 06/21/2017 5 YR LCH  | GBP 0.50 06/21/2017 5 YR LCH  | JPY 0.00 06/21/2017 5 YR LCH  | CAD 1.00 06/21/2017 5 YR LCH  | AUD 2.00 06/21/2017 5 YR LCH  |
| 7 YEAR  |      0 | 1.5                           | 0                             | 0.75                          | 0                             | 1                             | 2                             |
|         |      1 | 57056D EE0                    | 57056D EF7                    | 57056D EG5                    | 57056D EH3                    | 57056D EJ9                    | 57056D EK6                    |
|         |      2 | US57056DEE04                  | US57056DEF78                  | US57056DEG51                  | US57056DEH35                  | US57056DEJ90                  | US57056DEK63                  |
|         |      3 | USD 1.50 06/21/2017 7 YR CME  | EUR 0.00 06/21/2017 7 YR CME  | GBP 0.75 06/21/2017 7 YR CME  | JPY 0.00 06/21/2017 7 YR CME  | CAD 1.00 06/21/2017 7 YR CME  | AUD 2.00 06/21/2017 7 YR CME  |
|         |      4 | 57056D BG8                    | 57056D BH6                    | 57056D BJ2                    | 57056D BK9                    | 57056D BL7                    | 57056D BM5                    |
|         |      5 | US57056DBG88                  | US57056DBH61                  | US57056DBJ28                  | US57056DBK90                  | US57056DBL73                  | US57056DBM56                  |
|         |      6 | USD 1.50 06/21/2017 7 YR LCH  | EUR 0.00 06/21/2017 7 YR LCH  | GBP 0.75 06/21/2017 7 YR LCH  | JPY 0.00 06/21/2017 7 YR LCH  | CAD 1.00 06/21/2017 7 YR LCH  | AUD 2.00 06/21/2017 7 YR LCH  |
| 9 YEAR  |      0 | 1.5                           | 0.25                          | 0.75                          | 0                             | 1.25                          | 2                             |
|         |      1 | 57056D EL4                    | 57056D EM2                    | 57056D EN0                    | 57056D EP5                    | 57056D EQ3                    | 57056D ER1                    |
|         |      2 | US57056DEL47                  | US57056DEM20                  | US57056DEN03                  | US57056DEP50                  | US57056DEQ34                  | US57056DER17                  |
|         |      3 | USD 1.50 06/21/2017 9 YR CME  | EUR 0.25 06/21/2017 9 YR CME  | GBP 0.75 06/21/2017 9 YR CME  | JPY 0.00 06/21/2017 9 YR CME  | CAD 1.25 06/21/2017 9 YR CME  | AUD 2.00 06/21/2017 9 YR CME  |
|         |      4 | 57056D BN3                    | 57056D BP8                    | 57056D BQ6                    | 57056D BR4                    | 57056D BS2                    | 57056D BT0                    |
|         |      5 | US57056DBN30                  | US57056DBP87                  | US57056DBQ60                  | US57056DBR44                  | US57056DBS27                  | US57056DBT00                  |
|         |      6 | USD 1.50 06/21/2017 9 YR LCH  | EUR 0.25 06/21/2017 9 YR LCH  | GBP 0.75 06/21/2017 9 YR LCH  | JPY 0.00 06/21/2017 9 YR LCH  | CAD 1.25 06/21/2017 9 YR LCH  | AUD 2.00 06/21/2017 9 YR LCH  |
| 10 YEAR |      0 | 1.5                           | 0.5                           | 0.75                          | 0                             | 1.25                          | 2                             |
|         |      1 | 57056D ES9                    | 57056D ET7                    | 57056D EU4                    | 57056D EV2                    | 57056D EW0                    | 57056D EX8                    |
|         |      2 | US57056DES99                  | US57056DET72                  | US57056DEU46                  | US57056DEV29                  | US57056DEW02                  | US57056DEX84                  |
|         |      3 | USD 1.50 06/21/2017 10 YR CME | EUR 0.50 06/21/2017 10 YR CME | GBP 0.75 06/21/2017 10 YR CME | JPY 0.00 06/21/2017 10 YR CME | CAD 1.25 06/21/2017 10 YR CME | AUD 2.00 06/21/2017 10 YR CME |
|         |      4 | 57056D BU7                    | 57056D BV5                    | 57056D BW3                    | 57056D BX1                    | 57056D BY9                    | 57056D BZ6                    |
|         |      5 | US57056DBU72                  | US57056DBV55                  | US57056DBW39                  | US57056DBX12                  | US57056DBY94                  | US57056DBZ69                  |
|         |      6 | USD 1.50 06/21/2017 10 YR LCH | EUR 0.50 06/21/2017 10 YR LCH | GBP 0.75 06/21/2017 10 YR LCH | JPY 0.00 06/21/2017 10 YR LCH | CAD 1.25 06/21/2017 10 YR LCH | AUD 2.00 06/21/2017 10 YR LCH |
| 12 YEAR |      0 | 1.5                           | 0.5                           | 0.75                          | 0.25                          | 1.5                           | 2.25                          |
|         |      1 | 57056D EY6                    | 57056D EZ3                    | 57056D FA7                    | 57056D FB5                    | 57056D FC3                    | 57056D FD1                    |
|         |      2 | US57056DEY67                  | US57056DEZ33                  | US57056DFA72                  | US57056DFB55                  | US57056DFC39                  | US57056DFD12                  |
|         |      3 | USD 1.50 06/21/2017 12 YR CME | EUR 0.50 06/21/2017 12 YR CME | GBP 0.75 06/21/2017 12 YR CME | JPY 0.25 06/21/2017 12 YR CME | CAD 1.50 06/21/2017 12 YR CME | AUD 2.25 06/21/2017 12 YR CME |
|         |      4 | 57056D CA0                    | 57056D CB8                    | 57056D CC6                    | 57056D CD4                    | 57056D CE2                    | 57056D CF9                    |
|         |      5 | US57056DCA00                  | US57056DCB82                  | US57056DCC65                  | US57056DCD49                  | US57056DCE22                  | US57056DCF96                  |
|         |      6 | USD 1.50 06/21/2017 12 YR LCH | EUR 0.50 06/21/2017 12 YR LCH | GBP 0.75 06/21/2017 12 YR LCH | JPY 0.25 06/21/2017 12 YR LCH | CAD 1.50 06/21/2017 12 YR LCH | AUD 2.25 06/21/2017 12 YR LCH |
| 15 YEAR |      0 | 1.5                           | 0.75                          | 1                             | 0.25                          | 1.5                           | 2.25                          |
|         |      1 | 57056D FE9                    | 57056D FF6                    | 57056D FG4                    | 57056D FH2                    | 57056D FJ8                    | 57056D FK5                    |
|         |      2 | US57056DFE94                  | US57056DFF69                  | US57056DFG43                  | US57056DFH26                  | US57056DFJ81                  | US57056DFK54                  |
|         |      3 | USD 1.50 06/21/2017 15 YR CME | EUR 0.75 06/21/2017 15 YR CME | GBP 1.00 06/21/2017 15 YR CME | JPY 0.25 06/21/2017 15 YR CME | CAD 1.50 06/21/2017 15 YR CME | AUD 2.25 06/21/2017 15 YR CME |
|         |      4 | 57056D CG7                    | 57056D CH5                    | 57056D CJ1                    | 57056D CK8                    | 57056D CL6                    | 57056D CM4                    |
|         |      5 | US57056DCG79                  | US57056DCH52                  | US57056DCJ19                  | US57056DCK81                  | US57056DCL64                  | US57056DCM48                  |
|         |      6 | USD 1.50 06/21/2017 15 YR LCH | EUR 0.75 06/21/2017 15 YR LCH | GBP 1.00 06/21/2017 15 YR LCH | JPY 0.25 06/21/2017 15 YR LCH | CAD 1.50 06/21/2017 15 YR LCH | AUD 2.25 06/21/2017 15 YR LCH |
| 20 YEAR |      0 | 1.75                          | 0.75                          | 1                             | 0.5                           | 1.75                          |                               |
|         |      1 | 57056D FL3                    | 57056D FM1                    | 57056D FN9                    | 57056D FP4                    | 57056D FQ2                    |                               |
|         |      2 | US57056DFL38                  | US57056DFM11                  | US57056DFN93                  | US57056DFP42                  | US57056DFQ25                  |                               |
|         |      3 | USD 1.75 06/21/2017 20 YR CME | EUR 0.75 06/21/2017 20 YR CME | GBP 1.00 06/21/2017 20 YR CME | JPY 0.50 06/21/2017 20 YR CME | CAD 1.75 06/21/2017 20 YR CME |                               |
|         |      4 | 57056D CN2                    | 57056D CP7                    | 57056D CQ5                    | 57056D CR3                    | 57056D CS1                    |                               |
|         |      5 | US57056DCN21                  | US57056DCP78                  | US57056DCQ51                  | US57056DCR35                  | US57056DCS18                  |                               |
|         |      6 | USD 1.75 06/21/2017 20 YR LCH | EUR 0.75 06/21/2017 20 YR LCH | GBP 1.00 06/21/2017 20 YR LCH | JPY 0.50 06/21/2017 20 YR LCH | CAD 1.75 06/21/2017 20 YR LCH |                               |
| 30 YEAR |      0 | 1.75                          | 0.75                          | 1                             | 0.5                           | 1.5                           |                               |
|         |      1 | 57056D FR0                    | 57056D FS8                    | 57056D FT6                    | 57056D FU3                    | 57056D FV1                    |                               |
|         |      2 | US57056DFR08                  | US57056DFS80                  | US57056DFT63                  | US57056DFU37                  | US57056DFV10                  |                               |
|         |      3 | USD 1.75 06/21/2017 30 YR CME | EUR 0.75 06/21/2017 30 YR CME | GBP 1.00 06/21/2017 30 YR CME | JPY 0.50 06/21/2017 30 YR CME | CAD 1.50 06/21/2017 30 YR CME |                               |
|         |      4 | 57056D CT9                    | 57056D CU6                    | 57056D CV4                    | 57056D CW2                    | 57056D CX0                    |                               |
|         |      5 | US57056DCT90                  | US57056DCU63                  | US57056DCV47                  | US57056DCW20                  | US57056DCX03                  |                               |
|         |      6 | USD 1.75 06/21/2017 30 YR LCH | EUR 0.75 06/21/2017 30 YR LCH | GBP 1.00 06/21/2017 30 YR LCH | JPY 0.50 06/21/2017 30 YR LCH | CAD 1.50 06/21/2017 30 YR LCH |                               |

## Output:


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