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:
| Category           | Part #        | Item Description                             | QTY   | Dealer             | MSRP              | Volume Disc         | TOTAL $            | Margin             |
|:-------------------|:--------------|:---------------------------------------------|:------|:-------------------|:------------------|:--------------------|:-------------------|:-------------------|
| FLASHLIGHTS        |               |                                              |       |                    |                   |                     |                    |                    |
| 0                  | MTN-LAB-X800  | 800 Lumen Flashlight system                  |       | 47.99              | 79.98999999999998 | 0                   | 0                  | 0.4000500062507813 |
| 0                  | MTN-LAB-X1000 | 1000 Lumen Flashlight system                 |       | 71.99              | 119.99            | 20+ units = 25% off | 0                  | 0.4000333361113425 |
| 0                  | MTN-LAB-X1800 | 1800 Lumen Flashlight system                 |       | 95.99              | 159.99            |                     | 0                  | 0.4000250015625977 |
| 0                  | MTN-LAB-X172  | Spare X1000 Mountain Lab Batteries (3400mAh) |       | 14.99              | 24.99             |                     | 0                  | 0.4001600640256103 |
| 0                  | MTN-LAB-X173  | X1000 Handlebar Mount - Mountain Lab         |       | 11.99              | 19.99             |                     | 0                  | 0.4002001000500249 |
| 0                  | MTN-LAB-X174  | Vented Bike Helmet Strap Mount               |       | 8.99               | 14.99             |                     | 0                  | 0.400266844563042  |
| 0                  | MTN-LAB-X176  | X1000 GoPro mount tools 4 pcs                |       | 8.99               | 14.99             |                     | 0                  | 0.400266844563042  |
| 0                  | MTN-LAB-X177  | X1000 Mtn Lab Light Clamp                    |       | 11.99              | 19.99             |                     | 0                  | 0.4002001000500249 |
| 0                  | MTN-LAB-X178  | X800 and X1800 replacement GoPro mount       |       | 11.99              | 19.99             |                     | 0                  | 0.4002001000500249 |
| SAWS               |               |                                              |       |                    |                   |                     |                    |                    |
| 1                  | MTN-LAB-SAW1  | Mtn Lab Pocket Chainsaw                      |       | 14.99              | 24.99             | 1                   | 0                  | 0.4001600640256103 |
| 1                  | MTN-LAB-SAW2  | Mtn Lab Folding Saw                          |       | 14.99              | 24.99             | 1                   | 0                  | 0.4001600640256103 |
| STRAPS             |               |                                              |       |                    |                   |                     |                    |                    |
| 2                  | MTN-LAB-STRP  | Mountain Lab Ratchet Strap                   |       | 14.99              | 24.99             | 0                   | 0                  | 0.4001600640256103 |
| 2                  | MTN-LAB-TOW   | Snowmobile Tow Kit with Bag                  |       | 17.989999999999995 | 29.99             | 0                   | 0                  | 0.4001333777925976 |
| 2                  | MTN-LAB-TOW2  | UTV/ATV Tow Rope with Shackle                |       | 23.99              | 39.99             | 0                   | 0                  | 0.4001000250062517 |
| 2                  | MTN-LAB-SPS   | Snowmobile Ski Pull Strap                    |       | 11.99              | 19.99             | 0                   | 0                  | 0.4002001000500249 |
| FIRST AID KITS     |               |                                              |       |                    |                   |                     |                    |                    |
| 3                  | MTN-LAB-FA1   | Backcountry First Aid Kit                    |       | 23.99              | 39.99             |                     | 0                  | 0.4001000250062517 |
| 3                  | MTN-LAB-FA2   | Backcountry Plus First Aid Kit               |       | 29.99              | 49.99             |                     | 0                  | 0.4000800160032007 |
| GLOVES & KNEE PADS |               |                                              |       |                    |                   |                     |                    |                    |
| 4                  | MTN-GL1-SM    | 0                                            |       | 97.49              | 149.99            |                     | 0                  | 0.3500233348889927 |
| 4                  | MTN-GL1-MD    | 0                                            |       | 97.49              | 149.99            |                     | 0                  | 0.3500233348889927 |
| 4                  | MTN-GL1-LG    | 0                                            |       | 97.49              | 149.99            |                     | 0                  | 0.3500233348889927 |
| 4                  | MTN-GL1-XL    | 0                                            |       | 97.49              | 149.99            |                     | 0                  | 0.3500233348889927 |
| 4                  | MTN-GL1-2X    | 0                                            |       | 97.49              | 149.99            |                     | 0                  | 0.3500233348889927 |
| 4                  | MTN-GL1-BAT   | 7.4V Glove battery (1 unit)                  |       | 19.49              | 29.99             |                     | 0                  | 0.3501167055685229 |
| 4                  | MTN-GL1-CHG   | 7.4V Battery Charger                         |       | 9.74               | 14.99             |                     | 0                  | 0.3502334889926617 |
| 4                  | MTN-GL1-SPLT  | 7.4V Charger Splitter                        |       | 6.49               | 9.99              |                     | 0                  | 0.3503503503503503 |
| 4                  | MTN-LAB-KNE   | Knee pads - Hard                             |       | 23.99              | 39.99             |                     | 0                  | 0.4001000250062517 |
| ELECTRONICS        |               |                                              |       |                    |                   |                     |                    |                    |
| 5                  | MTN-LAB-SPK1  | Helmet Speaker System                        |       | 35.99              | 59.99             |                     | 0                  | 0.4000666777796299 |
| 5                  | MTN-LAB-RD1   | 1 Piece Radio with Mic                       |       | 71.99              | 119.99            |                     | 0                  | 0.4000333361113425 |
| 5                  | MTN-LAB-RD2   | 2 Piece Radio with Mic                       |       | 119.99             | 199.99            |                     | 0                  | 0.40002000100005   |
| 5                  | MTN-LAB-RD3   | Replacement Handheld Mic                     |       | 23.99              | 39.99             |                     | 0                  | 0.4001000250062517 |
| PROMO              |               |                                              |       |                    |                   |                     |                    |                    |
| 6                  | MTN-LAB-DIS1  | Mountain Lab Counter Display                 |       | 49.99              | 0.0               |                     | 0                  |                    |
| 6                  | MTN-LAB-DIS2  | Mountain Lab Floor Display - Narrow          |       | 59.99              | 0.0               |                     | 0                  |                    |
| 6                  | MTN-LAB-DIS3  | Mountain Lab Floor Display - Wide            |       | 69.99              | 0.0               |                     | 0                  |                    |
|                    |               |                                              | 0.0   |                    |                   | 0                   | MOUNTAIN LAB TOTAL |                    |

## Output:


source: excel_file
label: subtitle