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:
| Product     | Subline   | Part Number   | Description                    |
|:------------|:----------|:--------------|:-------------------------------|
| ACD Product |           |               |                                |
|             | AC        | 15-30008      | FITTING W/                     |
|             | AC        | 15-30513      | EVAP HOSE                      |
|             | AC        | 15-50574      | VALVE H                        |
|             | FIL       | GF578         | 1728 PER PALLET 24 PER CASE    |
|             | FIL       | GF652         | 1728 PER PALLET 24 PER CASE    |
|             | FIL       | PF1127        | MADE IN USA 1680 PER PALLET    |
|             | FIL       | PF1218        | MADE IN USA 840 PER PALLET     |
|             | FIL       | PF13          | MADE IN USA 1200 PER PALLET    |
|             | FIL       | PF2           | AC DELCO OIL FILTER            |
|             | FIL       | PF2129        | MADE IN USA 2400 PER PALLET    |
|             | FIL       | PF454         | MADE IN USA 1200 PER PALLET    |
|             | FIL       | PF457G        | PF457GF                        |
|             | FIL       | PF46          | GM # 19210283 PF46E            |
|             | FIL       | PF47          | 25010792                       |
|             | FIL       | PF47E         | 19210284 1848 PER PALLET       |
|             | FIL       | PF52          | MADE IN USA 1344 PER PALLET    |
|             | FIL       | PF53          | MADE IN USA 1080 PER PALLET    |
|             | FIL       | PF61E         | 19210285                       |
|             | MEX       | MCR43TS       | 89063290 120 PER CASE          |
|             | MEX       | PF2-M         | AC DELCO MADE IN MEXICO        |
|             | MEX       | PF454-M       | AC DELCO MADE IN MEXICO        |
|             | MEX       | PF53-M        | MADE IN MEXICO OIL FILTER      |
|             | MEX       | PF59-M        | AC DELCO MADE IN MEXICO        |
|             | MEX       | PFL400A-M     | AC DELCO MADE IN MEXICO        |
|             | OLD       | R43T USA      | 5613354                        |
|             | PLG       | 32G           | GLOW PLUG                      |
|             | PLG       | 41-100        | SPARK PLUG                     |
|             | PLG       | 41-101        | 12568387                       |
|             | PLG       | 41-103        | 12598004 / 12625058 REP 41-965 |
|             | PLG       | 41-105        | 12607280                       |
|             | PLG       | 41-107        | AC DELCO SPARK PLUGS           |
|             | PLG       | 41-110        | 12621258                       |
|             | PLG       | 41-627        | 25177454                       |
|             | PLG       | 41-629        | 88901233 MADE IN USA           |
|             | PLG       | 41-630        | 88901234 ORIGINAL USA PLUGS    |
|             | PLG       | 41-800        | SPARK PLUG                     |
|             | PLG       | 41-801        | 19238466                       |
|             | PLG       | 41-802        | 88901008 ORIGINAL USA PLUGS    |
|             | PLG       | 41-803        | AC DELCO SPARK PLUGS           |
|             | PLG       | 41-805        | 19250977                       |
|             | PLG       | 41-807        | SPARK PLUG                     |
|             | PLG       | 41-808        | AC DELCO SPARK PLUGS           |
|             | PLG       | 41-821        | SPARK PLUG                     |
|             | PLG       | 41-831        | SPARK PLUG                     |
|             | PLG       | 41-902        | 19158029 / 19207828            |
|             | PLG       | 41-905        | SPARK PLUG                     |
|             | PLG       | 41-906        | 19158032                       |
|             | PLG       | 41-908        | 19158034                       |
|             | PLG       | 41-913        | 5614355                        |
|             | PLG       | 41-919        | 25161442 CHANGE TO 41-975      |
|             | PLG       | 41-928        | 19179571 USA PLUGS             |
|             | PLG       | 41-933        | 19208533                       |
|             | PLG       | 41-936        | SPARK PLUG                     |
|             | PLG       | 41-940        | 19208529                       |
|             | PLG       | 41-942        | 19208527                       |
|             | PLG       | 41-943        | 19158039 / 19208531            |
|             | PLG       | 41-948        | 19208530                       |
|             | PLG       | 41-950        | 19208535                       |
|             | PLG       | 41-963        | 19208532                       |
|             | PLG       | 41-979        | 19208534                       |
|             | PLG       | 41-980        | 12556183 OROGINAL USA PLUGS    |
|             | PLG       | 41-983        | 12578277                       |
|             | PLG       | 41-986        | SPARK PLUG                     |
|             | PLG       | 41-987        | 12571535                       |
|             | PLG       | 41-988        | 12565996                       |
|             | PLG       | 41-993        | 19256067                       |
|             | PLG       | B-41-602      | 19143333 TEN PACK              |
|             | PLG       | B-CR45TS      | 89021351                       |
|             | PLG       | B-FR5LS       | 89021372                       |
|             | PLG       | B-R44LTSM     | 19143356 TEN PACK              |
|             | PLG       | B-R44TS       | 89021352                       |
|             | PLG       | B-R44XLS      | 89021357                       |
|             | PLG       | B-R45TSX      | 89021346                       |
|             | PLG       | C87           | SPARK PLU                      |
|             | PLG       | CR43TS        | 19157996 ORIGINAL USA PLUGS    |
|             | PLG       | CR43TSM       | ORIGINAL USA DELCO PLUGS       |
|             | PLG       | CR45TS        | 5614229                        |
|             | PLG       | FR3LS6        | 5614000                        |
|             | PLG       | MR43LTS       | 5614210 ORIGINAL USA PLUGS     |
|             | PLG       | MR43T         | 19157985 ORIGINAL USA PLUGS    |
|             | PLG       | MR44T         | SPARK PLUG                     |
|             | PLG       | R42LTS        | 19157987                       |
|             | PLG       | R42LTS6       | ORIGINAL USA DELCO PLUGS       |
|             | PLG       | R42LTSM       | 5614197                        |
|             | PLG       | R42T          | 5613353 ORIGINAL USA PLUGS     |
|             | PLG       | R42TS         | 19157982                       |
|             | PLG       | R42XLS        | 5613100 MADE IN USA            |
|             | PLG       | R43           | 5569992                        |
|             | PLG       | R43S          | 5613090 ORIGINAL USA PLUGS     |
|             | PLG       | R43T          | 19157984 ORIGINAL USA PLUGS    |
|             | PLG       | R43TS         | 19157983 ORIGINAL USA PLUGS    |
|             | PLG       | R43TSK        | 19157999                       |
|             | PLG       | R43XLS        | 5613522                        |
|             | PLG       | R44LTS        | 19157986 ORIGINAL USA PLUGS    |
|             | PLG       | R44LTS6       | 19157992                       |
|             | PLG       | R44LTSM       | 19157998 ORIGINAL USA PLUGS    |
|             | PLG       | R44LTSM6      | 19158001 ORIGINAL USA PLUGS    |
|             | PLG       | R44T          | 19157988                       |
|             | PLG       | R44TS         | 19157994 ORIGINAL USA PLUGS    |

## Output:


source: excel_file
label: subtitle