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:
| Item #    | NRS Seller's Ref #    | NSN           | Material Description          | Item Page Link                                              |
|:----------|:----------------------|:--------------|:------------------------------|:------------------------------------------------------------|
| 2461734.0 | MMK10090370035        | 2530015171084 | 0                             | https://www.govplanet.com/jsp/s/item/2461734?kwtag=itemlist |
|           | WX3V9P902390237       | 5120011468096 | 1                             |                                                             |
|           | MMK10090370034        | 2530015171096 | 0                             |                                                             |
|           | MMK10090370018        | 4730015688281 | Elbow, hose To Boss           |                                                             |
|           | MMK10090370006        | 2540016156854 | Motor, windshield Wiper       |                                                             |
|           | MMK10090370042        | 5340015849594 | Adapter, tie Down             |                                                             |
|           | MMK10090370046        | 6220016156268 | Light, blackout               |                                                             |
|           | MMK10090370045        | 4730016157302 | Manifold, air Line            |                                                             |
| 2274827.0 | R3021581220071        | 5360013630602 | 2                             | https://www.govplanet.com/jsp/s/item/2274827?kwtag=itemlist |
|           | R3021581220054        | 5430013498729 | 3                             |                                                             |
|           | R3021581220038        | 2910013332309 | 4                             |                                                             |
|           | R3021581220255        | 5330015087053 | 5                             |                                                             |
|           | R3021581220057        | 5430013505465 | 3                             |                                                             |
|           | R3021581220061        | 5330013585406 | 5                             |                                                             |
|           | R3021581211578        | 6625012398103 | 6                             |                                                             |
|           | R3021581220248        | 6110015080123 | 7                             |                                                             |
|           | R3021581220084        | 5945013662728 | 8                             |                                                             |
|           | R3021581211553        | 5930011998853 | 9                             |                                                             |
| 2274828.0 | R3021581220072        | 6240013632167 | 10                            | https://www.govplanet.com/jsp/s/item/2274828?kwtag=itemlist |
|           | R3021581211516        | 6680011605276 | Adapter, Speedometer          |                                                             |
|           | R3021581220053        | 5430013498728 | 3                             |                                                             |
|           | R3021581220202        | 4710014608777 | Fuel Fill Base                |                                                             |
|           | R3021581220142        | 4240013958305 | Frame Assembly                |                                                             |
|           | R3021581220016        | 4820013110145 | Retainer, Disk, Valve         |                                                             |
|           | R3021581220041        | 6685013337406 | Indicator, Temperatu          |                                                             |
|           | R3021581220212        | 2910014704183 | Pump, fuel, cam Actua         |                                                             |
|           | R3021581211539        | 2910011829429 | 4                             |                                                             |
|           | R3021581211391        | 4730000250785 | Coupling Assembly, Tube       |                                                             |
| 2274833.0 | R3021581211499        | 5360011557263 | 11                            | https://www.govplanet.com/jsp/s/item/2274833?kwtag=itemlist |
|           | R3021581220055        | 5430013501446 | Guard, Housing, Filte         |                                                             |
|           | R3021581211504        | 5340011568395 | 12                            |                                                             |
|           | R3021581220067        | 2910013610616 | 4                             |                                                             |
|           | R3021581220064        | 4520013598114 | 13                            |                                                             |
|           | R3021581220034        | 2520013310602 | 14                            |                                                             |
|           | R3021581211446        | 3110008876348 | Bearing, roller, tape         |                                                             |
|           | R3021581211426        | 6685005268731 | 15                            |                                                             |
|           | R3021581211521        | 2510011647152 | Parts Kit, vehicular          |                                                             |
|           | R3021581220052        | 3040013496927 | Damper, inertia               |                                                             |
| 2375744.0 | R3021581220189        | 4220014391996 | Penetrator, Electric          | https://www.govplanet.com/jsp/s/item/2375744?kwtag=itemlist |
|           | R3021581220194        | 4730014559239 | 16                            |                                                             |
|           | R3021581220174        | 4820014317521 | 17                            |                                                             |
|           | R3021581171178        | 4730012141511 | 18                            |                                                             |
| 2375747.0 | R3021581211415        | 5960002963370 | Electron Tube                 | https://www.govplanet.com/jsp/s/item/2375747?kwtag=itemlist |
|           | R3021581220111        | 6130013758774 | 19                            |                                                             |
|           | R3021581211405        | 6230001830288 | 20                            |                                                             |
| 2375759.0 | R3021581171337        | 6685014292689 | Transmitter, Tempera          | https://www.govplanet.com/jsp/s/item/2375759?kwtag=itemlist |
|           | R3021581171280        | 4820013668034 | Valve, Inflation              |                                                             |
|           | R3021581171368        | 2940015226037 | 21                            |                                                             |
|           | R3021581171025        | 5340009375286 | 22                            |                                                             |
|           | R3021581171276        | 4820013648617 | 23                            |                                                             |
| 2375761.0 | R3021581220104        | 6695013722971 | Transducer, Motional          | https://www.govplanet.com/jsp/s/item/2375761?kwtag=itemlist |
|           | R3021581220062        | 5330013585554 | 24                            |                                                             |
|           | R3021581211477        | 2540010969695 | Socket, tail Lamp             |                                                             |
|           | R3021581220171        | 5355014305409 | 25                            |                                                             |
|           | R3021581211554        | 6240012037625 | 10                            |                                                             |
| 2375763.0 | R3021581220073        | 5330013632634 | 26                            | https://www.govplanet.com/jsp/s/item/2375763?kwtag=itemlist |
|           | R3021581171170        | 5930012023573 | 27                            |                                                             |
|           | R3021581171380        | 5330151780267 | 28                            |                                                             |
|           | R3021581171112        | 2530011557943 | Adjusting Screw Ass           |                                                             |
|           | R3021581220029        | 3120013297615 | 29                            |                                                             |
| 2376098.0 | R3021581211482        | 2920011314932 | Generator, engine Accessory   | https://www.govplanet.com/jsp/s/item/2376098?kwtag=itemlist |
|           | R3021581220283        | 2530015396543 | Dual Brake Valve, Pneumatic.  |                                                             |
|           | R3021581220190        | 2910014443758 | 21                            |                                                             |
|           | R3021581211488        | 2990011482929 | Control Assembly, Push-pull   |                                                             |
|           | R3021581220047        | 6680013409415 | Transmitter, Liquid           |                                                             |
| 2376131.0 | R3021581211590        | 5330012779773 | 5                             | https://www.govplanet.com/jsp/s/item/2376131?kwtag=itemlist |
|           | R3021581220078        | 4720013655242 | 30                            |                                                             |
|           | R3021581211427        | 6220005773434 | 31                            |                                                             |
|           | R3021581220028        | 2920013279820 | Generator, engine Ac          |                                                             |
|           | R3021581220260        | 2530015097680 | Valve, relay, air Pre         |                                                             |
| 2411300.0 | SX12939113F001        | 3418DSPLANESH | Planers And Shapers           | https://www.govplanet.com/jsp/s/item/2411300?kwtag=itemlist |
|           | SX12939112F012        | 3413DSDRILL00 | Drilling And Tapping Machines |                                                             |
|           | FB635590981236        | 3415DSGRINDER | Grinding Machines             |                                                             |
| 2454302.0 | W26AL190371010        | 0             | 32                            | https://www.govplanet.com/jsp/s/item/2454302?kwtag=itemlist |
|           | W26AL190371008        | 0             | 32                            |                                                             |
| 2070972.0 | W90KQ673100440        | 8465015472670 | 33                            | https://www.govplanet.com/jsp/s/item/2070972?kwtag=itemlist |
|           | W90KQ672860327        | 8415014618341 | 34                            |                                                             |
|           | W90KQ673100422        | 8415015302351 | 35                            |                                                             |
|           | SY21648059F011        | 8460006068366 | 36                            |                                                             |
|           | W90KQ673100438        | 8465011178699 | 37                            |                                                             |
|           | W90KQ673100439        | 8465015472656 | 33                            |                                                             |
|           | W33DMJ71643031V       | 8465015472670 | 33                            |                                                             |
|           | W90KQ673100434        | 8465002616909 | 38                            |                                                             |
|           | W90KQ673060510        | 7210002827950 | 39                            |                                                             |
|           | W90KQ672970403        | 1             | 40                            |                                                             |
|           | W90KQ672970402        | 1             | 40                            |                                                             |
| 2149396.0 | Z5920171252210        | 6625014732702 | 41                            | https://www.govplanet.com/jsp/s/item/2149396?kwtag=itemlist |
|           | W90KEW81160025        | 6640004082300 | 42                            |                                                             |
| 2166218.0 | FB465481140002        | 2             | 43                            | https://www.govplanet.com/jsp/s/item/2166218?kwtag=itemlist |
|           | SL470180210CSS        | 6240011936475 | 10                            |                                                             |
|           | W81J6381980012        | 4030013697612 | Shackle                       |                                                             |
|           | W90NHW81780010        | 5110002932336 | 44                            |                                                             |
|           | SL47018018SP02        | 3             | 45                            |                                                             |
|           | W31G1Y82250111        | 5120014288487 | 46                            |                                                             |
|           | W90NHW81780006        | 5120014236463 | Hydraulic Jack Handle         |                                                             |
|           | M999338152BW21        | 4             | 47                            |                                                             |
|           | N0720172167611        | 5210008103490 | Square, Carpenter's           |                                                             |
|           | W31G1Y82200065        | 5             | 48                            |                                                             |
|           | W8086B82060044        | 5120008785932 | 49                            |                                                             |
|           | FB465481430006        | 6             | 50                            |                                                             |

## Output:


source: excel_file
label: operator: ffill
ffill_end_idx: 0
operator: explode
explode_column_idx: 3