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:
| Company Name   | iRobot Corporation   | ABB Ltd.       | Fanuc Corporation   | Yaskawa Electric Corporation   | Intuitive Surgical, Inc.   | AeroVironment, Inc.   | Mazor Robotics Ltd Sponsored ADR   | Rockwell Automation, Inc.   | Amazon.com, Inc.   | Cognex Corporation   | FLIR Systems, Inc.   | Keyence Corporation   | FARO Technologies, Inc.   | Trimble Inc.   | Adept Technology   | Renishaw plc   | Tesla Inc      | BlackBerry Limited   | DENSO CORPORATION   | Delphi Technologies Plc   | Autoliv Inc.   | Visteon Corporation   | NVIDIA Corporation   | Advanced Micro Devices, Inc.   | iflytek Co., Ltd. Class A   | Cray Inc.      | ISRA VISION AG   | Nuance Communications, Inc.   | Micron Technology, Inc.   | SK hynix Inc     | STMicroelectronics NV   | ams AG        | HTC Corporation   | Ambarella, Inc.   | Kopin Corporation   | Himax Technologies, Inc. Sponsored ADR   | ARM Holding   | Qualcomm       | MobileEye       | Teradyne      | Omron          | Facebook     | Lumentum       | Finisar        | II-VI          | Fabrinet     |
|:---------------|:---------------------|:---------------|:--------------------|:-------------------------------|:---------------------------|:----------------------|:-----------------------------------|:----------------------------|:-------------------|:---------------------|:---------------------|:----------------------|:--------------------------|:---------------|:-------------------|:---------------|:---------------|:---------------------|:--------------------|:--------------------------|:---------------|:----------------------|:---------------------|:-------------------------------|:----------------------------|:---------------|:-----------------|:------------------------------|:--------------------------|:-----------------|:------------------------|:--------------|:------------------|:------------------|:--------------------|:-----------------------------------------|:--------------|:---------------|:----------------|:--------------|:---------------|:-------------|:---------------|:---------------|:---------------|:-------------|
| ISIN           | US4627261005         | CH0012221716   | JP3802400006        | JP3932000007                   | US46120E6023               | US0080731088          | US57886P1030                       | US7739031091                | US0231351067       | US1924221039         | US3024451011         | JP3236200006          | US3116421021              | US8962391004   | US0068542028       | GB0007323586   | US88160R1014   | CA09228F1036         | JP3551500006        | JE00BD85SC56              | US0528001094   | US92839U2069          | US67066G1040         | US0079031078                   | CNE100000B81                | US2252233042   | DE0005488100     | US67020Y1001                  | US5951121038              | KR7000660001     | NL0000226223            | AT0000A18XM4  | TW0002498003      | KYG037AX1015      | US5006001011        | US43289P1066                             | GB0000595859  | US7475251036   | NL0010831061    | US8807701029  | JP3197800000   | US30303M1027 | US55024U1097   | US31787A5074   | US9021041085   | KYG3323L1005 |
| BBG Ticker     | IRBT US Equity       | ABBN SW Equity | 6954 JP Equity      | 6506 JP Equity                 | ISRG US Equity             | AVAV US Equity        | MZOR US Equity                     | ROK US Equity               | AMZN US Equity     | CGNX US Equity       | FLIR US Equity       | 6861 JP Equity        | FARO US Equity            | TRMB US Equity | ADEP US Equity     | RSW LN Equity  | TSLA US Equity | BB CN Equity         | 6902 JP Equity      | DLPH US Equity            | ALV US Equity  | VC US Equity          | NVDA US Equity       | AMD US Equity                  | 002230 CH Equity            | CRAY US Equity | ISR GR Equity    | NUAN US Equity                | MU US Equity              | 000660 KS Equity | STM FP Equity           | AMS SW Equity | 2498 TT Equity    | AMBA US Equity    | KOPN US Equity      | HIMX US Equity                           | ARM LN Equity | QCOM US Equity | MBBYF US Equity | TER US Equity | 6645 JP Equity | FB US Equity | LITE US Equity | FNSR US Equity | IIVI US Equity | FN US Equity |
| 41348          | 0.03                 | 0.03           | 0.03                | 0.03                           | 0.03                       | 0.05                  | 0                                  | 0.03                        | 0.05               | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.03               | 0.03           | 0.05           | 0.03                 | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0.03                        | 0              | 0                | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0.03          | 0.03              | 0                 | 0                   | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41442          | 0.03                 | 0.03           | 0                   | 0.03                           | 0.03                       | 0.03                  | 0                                  | 0.03                        | 0.05               | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.03               | 0.03           | 0.05           | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0                           | 0.03           | 0.03             | 0.03                          | 0.03                      | 0.05             | 0.05                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41533          | 0.03                 | 0.03           | 0.03                | 0.05                           | 0.03                       | 0.03                  | 0                                  | 0.03                        | 0.05               | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.03               | 0.03           | 0              | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0                           | 0.03           | 0                | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0.03          | 0.05              | 0.03              | 0                   | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41624          | 0.03                 | 0.03           | 0.03                | 0.05                           | 0.03                       | 0.03                  | 0                                  | 0.03                        | 0.05               | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.03               | 0.03           | 0              | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0                           | 0.05           | 0.03             | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41715          | 0.03                 | 0.03           | 0                   | 0.03                           | 0.03                       | 0.03                  | 0                                  | 0.03                        | 0.03               | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.05               | 0.03           | 0.05           | 0                    | 0.05                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0                           | 0              | 0.03             | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41806          | 0.03                 | 0.03           | 0                   | 0.03                           | 0.03                       | 0.03                  | 0.03                               | 0.03                        | 0.05               | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.05               | 0              | 0.05           | 0                    | 0                   | 0                         | 0.03           | 0                     | 0                    | 0.03                           | 0.03                        | 0.03           | 0.03             | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41897          | 0.03                 | 0.03           | 0                   | 0.03                           | 0.03                       | 0                     | 0.03                               | 0.03                        | 0.05               | 0.03                 | 0.03                 | 0                     | 0.03                      | 0.03           | 0.05               | 0.03           | 0.05           | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0.03                        | 0.03           | 0                | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0             | 0.03              | 0.03              | 0.03                | 0.03                                     | 0.05          | 0.03           | 0               | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 41988          | 0.03                 | 0.03           | 0                   | 0.03                           | 0.03                       | 0.05                  | 0                                  | 0.03                        | 0.05               | 0                    | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0.03               | 0.03           | 0              | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0.03                        | 0              | 0.03             | 0.03                          | 0.03                      | 0.05             | 0.03                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0.05          | 0.03           | 0.05            | 0             | 0              | 0            | 0              | 0              | 0              | 0            |
| 42079          | 0.03                 | 0.03           | 0                   | 0.03                           | 0.03                       | 0.05                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0                     | 0.03                      | 0.03           | 0.03               | 0.03           | 0              | 0                    | 0                   | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0.03                        | 0.03           | 0                | 0.03                          | 0.05                      | 0.03             | 0.05                    | 0.03          | 0.05              | 0.03              | 0                   | 0.03                                     | 0.05          | 0              | 0.03            | 0.03          | 0.03           | 0.03         | 0              | 0              | 0              | 0            |
| 42170          | 0.03                 | 0              | 0                   | 0.03                           | 0.03                       | 0.05                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.03           | 0.05           | 0.03                 | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0                           | 0.03           | 0.03             | 0.03                          | 0.03                      | 0.03             | 0.05                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0.05          | 0              | 0.05            | 0.03          | 0              | 0.03         | 0              | 0              | 0              | 0            |
| 42262          | 0.03                 | 0.03           | 0.03                | 0.05                           | 0.03                       | 0.03                  | 0.03                               | 0.03                        | 0                  | 0                    | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.03           | 0              | 0.03                 | 0.05                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0                           | 0              | 0.03             | 0.03                          | 0.03                      | 0.03             | 0.05                    | 0.03          | 0                 | 0.03              | 0                   | 0.03                                     | 0.05          | 0              | 0.05            | 0.03          | 0.03           | 0.03         | 0              | 0              | 0              | 0            |
| 42353          | 0.03                 | 0              | 0.03                | 0.03                           | 0.03                       | 0.05                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.03           | 0              | 0.03                 | 0.05                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0.03                        | 0.03           | 0                | 0.03                          | 0.05                      | 0                | 0.03                    | 0.03          | 0                 | 0.03              | 0.03                | 0.03                                     | 0.05          | 0              | 0.05            | 0.03          | 0.03           | 0.03         | 0              | 0              | 0              | 0            |
| 42444          | 0                    | 0              | 0.03                | 0                              | 0.03                       | 0.05                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.03           | 0.03           | 0.03                 | 0.05                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0.05                        | 0.03           | 0.03             | 0.05                          | 0.03                      | 0.03             | 0.03                    | 0.03          | 0                 | 0.03              | 0.03                | 0.03                                     | 0             | 0              | 0.03            | 0.03          | 0              | 0            | 0              | 0.05           | 0.03           | 0            |
| 42536          | 0.03                 | 0              | 0.03                | 0                              | 0.03                       | 0.05                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.03           | 0.03           | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0.03                        | 0              | 0                | 0.03                          | 0.03                      | 0.03             | 0.03                    | 0.03          | 0                 | 0.05              | 0.03                | 0.03                                     | 0             | 0              | 0.03            | 0.03          | 0              | 0            | 0              | 0.05           | 0.05           | 0.05         |
| 42628          | 0.03                 | 0              | 0.03                | 0                              | 0.03                       | 0.03                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.05           | 0.03           | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0                           | 0.03           | 0                | 0.03                          | 0.03                      | 0.03             | 0.03                    | 0.03          | 0                 | 0.03              | 0.03                | 0.03                                     | 0             | 0              | 0.03            | 0.03          | 0              | 0            | 0.05           | 0.05           | 0.05           | 0.05         |
| 42719          | 0.03                 | 0              | 0                   | 0                              | 0.03                       | 0.03                  | 0.03                               | 0                           | 0                  | 0.03                 | 0                    | 0                     | 0.03                      | 0.03           | 0                  | 0.03           | 0              | 0.03                 | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0.03                        | 0.03           | 0.03             | 0.05                          | 0.05                      | 0.03             | 0.03                    | 0.03          | 0                 | 0.03              | 0.03                | 0.03                                     | 0             | 0              | 0.03            | 0.03          | 0              | 0            | 0.05           | 0.05           | 0.05           | 0.03         |
| 42809          | 0.03                 | 0              | 0                   | 0.03                           | 0.03                       | 0.03                  | 0.03                               | 0                           | 0                  | 0.03                 | 0                    | 0                     | 0.03                      | 0.03           | 0                  | 0.03           | 0.03           | 0.03                 | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.05                           | 0.03                        | 0              | 0.03             | 0.05                          | 0.03                      | 0.03             | 0.03                    | 0.03          | 0.03              | 0.03              | 0                   | 0.03                                     | 0             | 0              | 0               | 0.03          | 0              | 0            | 0.05           | 0.05           | 0.05           | 0.03         |
| 42901          | 0.03                 | 0              | 0.03                | 0.03                           | 0.03                       | 0.03                  | 0                                  | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.03           | 0.03           | 0.03                 | 0.03                | 0                         | 0              | 0                     | 0.03                 | 0.03                           | 0                           | 0              | 0.03             | 0.05                          | 0.05                      | 0.05             | 0.03                    | 0             | 0.03              | 0                 | 0.03                | 0.03                                     | 0             | 0              | 0               | 0.03          | 0.03           | 0            | 0.05           | 0.03           | 0.05           | 0.03         |
| 42993          | 0.03                 | 0.03           | 0.03                | 0.03                           | 0.03                       | 0.03                  | 0.03                               | 0                           | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.05           | 0.03           | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0.03                           | 0                           | 0              | 0.03             | 0.05                          | 0.05                      | 0.05             | 0.03                    | 0             | 0.03              | 0                 | 0                   | 0.03                                     | 0             | 0              | 0               | 0.03          | 0.03           | 0            | 0              | 0.03           | 0.05           | 0.03         |
| 43084          | 0.03                 | 0.03           | 0.03                | 0.03                           | 0.03                       | 0.03                  | 0                                  | 0.03                        | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.05           | 0.03           | 0                    | 0.03                | 0                         | 0.03           | 0                     | 0.03                 | 0                              | 0                           | 0              | 0.03             | 0                             | 0.05                      | 0.05             | 0.03                    | 0             | 0.03              | 0.03              | 0.03                | 0.03                                     | 0             | 0              | 0               | 0.03          | 0.03           | 0            | 0              | 0.03           | 0.05           | 0.05         |
| 43174          | 0.03                 | 0.03           | 0.03                | 0.03                           | 0.03                       | 0.03                  | 0.03                               | 0.03                        | 0                  | 0.03                 | 0.03                 | 0.03                  | 0.03                      | 0.03           | 0                  | 0.05           | 0.03           | 0                    | 0.03                | 0                         | 0              | 0                     | 0.03                 | 0.03                           | 0                           | 0              | 0.03             | 0                             | 0.05                      | 0.05             | 0.03                    | 0             | 0.03              | 0                 | 0.03                | 0.03                                     | 0             | 0              | 0               | 0.03          | 0.03           | 0            | 0              | 0.03           | 0.05           | 0.05         |

## Output:


source: excel_file
label: operator: transpose
operator: stack
stack_start_idx: 3
stack_end_idx: 23