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 Code          | VPE    | Opmerking   | Omschrijving 2          | MOQ   | EAN code        | Omschrijving 1                                    | Bruto systeemprijs   |
| nieuw                 |        |             |                         |       |                 |                                                   |                      |
|:----------------------|:-------|:------------|:------------------------|:------|:----------------|:--------------------------------------------------|:---------------------|
| Cable knives          |        |             |                         |       |                 |                                                   |                      |
| 70000                 |        |             | Cable Knife System 4-70 |       | 4011391700000.0 | Jokari Kabelmes System 4-70, incl. beugel 8-28mm  | 63.3                 |
| 79016                 |        |             | Cable bracket No. 16    |       | 4011391790162.0 | Jokari Wisselbeugel 4 - 16mm O, systeem 4-70      | 14.65                |
| 79028                 |        |             | Cable bracket No. 28    |       | 4011391790285.0 | Jokari Wisselbeugel 8 - 28mm O, systeem 4-70      | 14.65                |
| 79035                 |        |             | Cable bracket No. 35    |       | 4011391790353.0 | Jokari Wisselbeugel 27 - 35mm O, systeem 4-70     | 16.75                |
| 79050                 |        |             | Cable bracket No. 50    |       | 4011391790506.0 | Jokari Wisselbeugel 35 - 50mm O, systeem 4-70     | 16.75                |
| 79070                 |        |             | Cable bracket No. 70    |       | 4011391790704.0 | Jokari Wisselbeugel 50-70mm O, systeem 4-70       | 19.7                 |
| 79055                 |        |             | Spare hook blade 4-70   |       |                 |                                                   | 11.7                 |
| Cable knives Secura   |        |             |                         |       |                 |                                                   |                      |
| 10160                 |        |             | 0                       |       | 4011391101609.0 | Jokari Kabelmes Secura Nr. 16                     | 14.3                 |
| 10270                 |        |             | No. 27                  |       | 4011391102705.0 | Jokari Kabelmes Secura Nr. 27                     | 14.3                 |
| 10280                 |        |             | No. 28H                 |       | 4011391102804.0 | Jokari Kabelmes Secura Nr. 28H                    | 15.25                |
| 10281                 |        |             | No. 28G                 |       | 4011391102811.0 | Jokari Kabelmes Secura Nr. 28G                    | 15.25                |
| Cable knives Standard |        |             |                         |       |                 |                                                   |                      |
| 10162                 |        |             | 0                       |       | 4011391101623.0 | Jokari Kabelmes Standaard Nr. 16                  | 12.25                |
| 10272                 |        |             | No. 27                  |       | 4011391102729.0 | Jokari Kabelmes Standaard Nr. 27                  | 12.25                |
| 10271                 |        |             | No. 27ISO               |       | 4011391102712.0 | Jokari Kabelmes Nr. 27 ISO                        | 19.65                |
| 10282                 |        |             | No. 28H                 |       | 4011391102828.0 | Jokari Kabelmes Standaard Nr. 28H                 | 12.8                 |
| 10285                 |        |             | No. 28G                 |       | 4011391102859.0 | Jokari Kabelmes Standaard Nr. 28G                 | 12.8                 |
| 10350                 |        |             | No. 35                  |       | 4011391103504.0 | Jokari Kabelmes Nr. 35                            | 25.55                |
| 10355                 |        |             | No. 35P                 |       | 4011391103559.0 | Jokari Kabelmes Nr. 35P                           | 67.95                |
| 10500                 |        |             | No. 50                  |       | 4011391105003.0 | Jokari Kabelmes Nr. 50                            | 31.5                 |
| 10700                 |        |             | No. 70                  |       | 4011391107007.0 | Jokari Kabelmes Nr. 70                            | 38.5                 |
| 19000                 |        |             | Spare Blade Set 3pcs.   |       | 4011391190009.0 | Attention new Jokari vervangmesje EM per 3 stuks  | 9.45                 |
| 19001                 |        |             | Spare Blade             |       |                 | Attention new Article No. (old 19000)             | 3.15                 |
| Wire stripper         |        |             |                         |       |                 |                                                   |                      |
| 20100                 |        |             | Secura 2K               |       | 4011391201002.0 | Jokari Draadstripper Secura Soft Grip             | 49.95                |
| 20050                 |        |             | Super 4 plus            |       | 4011391200500.0 | Jokari Draadstripper Super 4 plus                 | 21.4                 |
| 20450                 |        |             | High Strip              |       | 4011391204506.0 | Jokari High Strip                                 | 74.85000000000002    |
| 20060                 |        |             | Special                 |       | 4011391200609.0 | Jokari Draadstripper Special                      | 68.60000000000001    |
| 20070                 |        |             | AS-Interface Special    |       | 4011391200708.0 | Jokari AS-Interface Special Set                   | 113.0                |
| 20090                 |        |             | 6-16                    |       | 4011391200906.0 | Jokari Draadstripper 6-16                         | 80.7                 |
| 20030                 |        |             | Flat-Cable-Stripper     |       | 4011391200302.0 | Jokari Draadstripper Fiat-cable-stripper          | 73.25                |
| 20220                 |        |             | Outlet Special 20       |       | 4011391202207.0 | Jokari Outlet Special 20                          | 88.9                 |
| 20255                 |        |             | Outlet Special 55       |       | 4011391202559.0 | Jokari Outlet Special 55                          | 88.9                 |
| 20300                 |        |             | Sensor Special          |       | 4011391203006.0 | Jokari Draadstripper Sensor Special               | 122.9                |
| 20310                 |        |             | Sensor Mini             |       | 4001391203105.0 | Jokari draad stripper Sensor Mini                 | 122.9                |
| Cable stripper        |        |             |                         |       |                 |                                                   |                      |
| 30013                 |        |             | CAN-Strip               |       | 4011391300132.0 | Jokari Kabelstripper Can Strip                    | 164.10000000000005   |
| 30110                 |        |             | Top Coax Plus           |       | 4014915055921.0 | Jokari Kabelstripper Top Coax Plus                |                      |
| 30120                 |        |             | No. 12 Universal        |       | 4011391301207.0 | Jokari Kabelstripper Universeel No. 12            | 22.05                |
| 30140                 |        |             | No. 14 Flatcable        |       | 4011391301405.0 | Jokari Kabelstripper Flatkabel No. 14             | 26.85                |
| 30155                 |        |             | Secura No. 15           |       | 4011391301559.0 | Jokari Kabelstripper Super Stripper Secura No. 15 | 37.05                |
| 30160                 |        |             | PC-Strip                |       | 4011391301603.0 | Jokari Kabelstripper PC-strip                     | 44.85                |
| 30161                 |        |             | PC-CAT                  |       | 4011391301610.0 | Jokari Kabelstripper PC-CAT                       | 33.75                |
| 30180                 |        |             | SE-Strip 1,5            |       | 4011391301801.0 | Jokari Kabelstripper SE/Strip 1,5                 | 38.55                |
| 30190                 |        |             | SE-Strip 2,5-6          |       | 4011391301900.0 | Jokari Kabelstripper SE-Strip 2,5-6               | 38.55                |
| 30200                 |        |             | SE-Strip 10/16          |       | 4011391302006.0 | Jokari Kabelstripper SE/Strip 10 16               | 38.55                |
| 30300                 |        |             | AS-Interface Strip      |       | 4011391303003.0 | Jokari Kabelstripper AS-Interface strip           | 45.7                 |
| 30400                 |        |             | Uni-Plus                |       | 0.0             | Jokari Kabelstripper Uni-Plus                     | 17.35                |
| 30500                 |        |             | No.1-Cat                |       | 0.0             | Jokari Kabelstripper No-1, in toolbag             | 34.5                 |
| 30600                 |        |             | Secura Coaxi No.1       |       | 4011391306004.0 | Jokari Kabelstripper Secura Coaxi No. 1           | 15.9                 |
| 30700                 |        |             | Fibre Strip DC          |       | 4011391307001.0 | Jokari Kabelstripper Fibre Strip DC               | 28.20000000000001    |
| 30800                 |        |             | Fibre Strip LC          |       | 4011391308008.0 | Jokari Kabelstripper Fibre Strip LC               | 56.45                |
| 30810                 |        |             | LC-PUR                  |       | 4011391308107.0 | Jokari Kabelstripper LC-PUR                       | 56.45                |
| 30900                 |        |             | Allrounder              |       | 4011391309005.0 | Jokari Kabelstripper Allrounder                   | 26.8                 |
| 30910                 |        |             | Locator Box             |       | 4011391309104.0 | Jokari Kabelstripper Locator                      | 27.15                |
| Micro Wire Stripper   |        |             |                         |       |                 |                                                   |                      |
| 40024                 |        |             | PWS-Plus 001            |       | 4011391400245.0 | Jokari Micro-precisie Draadstripper PWS-Plus 001  | 35.45000000000001    |
| 40025                 |        |             | PWS-Plus 002            |       | 4011391400252.0 | Jokari Micro-precisie Draadstripper PWS-Plus 002  | 35.45000000000001    |
| 40026                 |        |             | PWS-Plus 003            |       | 4011391400269.0 | Jokari Draadstripper PWS-Plus 003                 | 35.45000000000001    |
| 40027                 |        |             | ESD-Plus 001            |       | 4011391400276.0 | Jokari Micro Draadstripper ESD-Plus 001           | 45.5                 |
| 40028                 |        |             | ESD-Plus 002            |       | 4011391400283.0 | Jokari Micro Draadstripper ESD-Plus 002           | 45.5                 |
| 40029                 |        |             | ESD-Plus 003            |       | 4011391400290.0 | Jokari Micro Draadstripper ESD-Plus 003           | 45.5                 |
| 40015                 |        |             | SWS-Plus 012            |       | 4011391400153.0 | Jokari Micro Draadstripper SWS-Plus 012           | 27.1                 |
| 40035                 |        |             | SWS-Plus 016            |       | 4011391400351.0 | Jokari Micro Draadstripper SWS-Plus 016           | 27.1                 |
| 40045                 |        |             | SWS-Plus 020            |       | 4011391400450.0 | Jokari Micro Draadstripper SWS-Plus 020           | 27.1                 |
| 40055                 |        |             | SWS-Plus 025            |       | 4011391400559.0 | Jokari Micro Draadstripper SWS-Plus 025           | 27.1                 |
| 40065                 |        |             | SWS-Plus 030            |       | 4011391400658.0 | Jokari Micro Draadstripper SWS-Plus 030           | 27.1                 |
| 40075                 |        |             | SWS-Plus 040            |       | 4011391400757.0 | Jokari Micro Draadstripper SWS-Plus 040           | 27.1                 |
| 40085                 |        |             | SWS-Plus 050            |       | 4011391400856.0 | Jokari Micro Draadstripper SWS-Plus 050           | 27.1                 |
| 40095                 |        |             | SWS-Plus 060            |       | 4011391400955.0 | Jokari Micro Draadstripper SWS-Plus 060           | 27.1                 |
| 40105                 |        |             | SWS-Plus 080            |       | 4011391401051.0 | Jokari Micro Draadstripper SWS-Plus 080           | 27.1                 |
| 40115                 |        |             | SWS-Plus 100            |       | 4011391401150.0 | Jokari Micro Draadstripper SWS-Plus 100           | 27.1                 |
| Various models        |        |             |                         |       |                 |                                                   |                      |
| 50000                 |        |             | BK Stripper             |       | 4011391500006.0 | Jokari BK Stripper                                | 149.5                |
| 59099                 |        |             | Spare-Set BK            |       |                 | Jokari Onderdeel-Set BK                           | 40.90000000000001    |
| 60000                 |        |             | QUADRO Set              |       | 4011391600003.0 | Jokari Stripper Quadro Set                        | 293.5                |
| 61000                 |        |             | QUADRO bulk             |       | 4011391610002.0 | Jokari Stripper Quadro Bulk                       | 260.55               |
| 60100                 |        |             | QUADRO Cartridge        |       | 4011391601000.0 | Jokari Stripper Quadro Cartridge                  | 17.0                 |
| Accessoires           |        |             |                         |       |                 |                                                   |                      |
| 29100                 |        |             | EM-Set Secura 2K        |       |                 | Jokari Secura 2K Set reservemesjes                | 17.650000000000006   |
| 29050                 |        |             | EM-Set Super 4plus      |       |                 | Jokari Super 4plus Set reservemesjes              | 10.75                |
| 29450                 |        |             | EM-Set High-Strip       |       |                 | Jokari Set reservemesjes                          | 27.4                 |
| 29060                 |        |             | EM-Set Special          |       |                 | Jokari Special Set reservemesjes                  | 25.0                 |
| 29070                 |        |             | EM-Set AS-Interface     |       |                 | Jokari AS-Interface Set reservemesjes             | 35.75                |
| 29090                 |        |             | EM-Set 6-16             |       | 4011391290907.0 | Jokari 6-16 Set reservemesjes                     | 37.45                |
| 29030                 |        |             | EM-Set FKZ              |       |                 | Jokari FKZ Set reservemesjes                      | 30.4                 |
| 29300                 |        |             | EM-Set Sensor Special   |       |                 | Jokari Sensor Special Set reservemesjes           | 60.35                |
| 29310                 |        |             | EM-Set Sensor Mini      |       |                 | Jokari Sensor Mini Set reservemesjes              | 60.35                |
| 60150                 | 1000.0 |             | End sleeves 0.50        |       |                 | Jokari Adereindhuls  wit- 0,50mm (500st)          | 17.8                 |
| 60175                 | 1000.0 |             | End sleeves 0.75        |       | 4011391601758.0 | Jokari Adereindhuls grijs - 0,75mm (500st)        | 17.8                 |
| 60110                 | 1000.0 |             | End sleeves 1.00        |       |                 | Jokari Adereindhuls  rood - 1.00mm (500st)        | 17.8                 |
| 60115                 | 1000.0 |             | End sleeves 1.50        |       | 4011391601154.0 | Jokari Adereindhuls zwart - 1,5mm (500st)         | 17.8                 |
| 60125                 | 1000.0 |             | End sleeves 2.50        |       | 4011391601253.0 | Jokari Adereindhuls blauw - 2,5mm 100 st          | 20.35                |

## Output:


source: excel_file
label: subtitle