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:
| School           | Name                 | Jersey #   | Year   | Position   | Ht   | Wt    |
|:-----------------|:---------------------|:-----------|:-------|:-----------|:-----|:------|
| Best Academy     |                      |            |        |            |      |       |
|                  | Allen Wasonu         | 1.0        | 10.0   | 0          | 0    | 160.0 |
|                  | Deshawn Waller       | 2.0        | 11.0   | 1          | 1    | 170.0 |
|                  | Deshawn Maeberry     | 3.0        | 11.0   | 2          | 1    | 175.0 |
|                  | Deonta Hill          | 4.0        | 12.0   | 0          | 1    | 195.0 |
|                  | Ventravious Rashada  | 5.0        | 12.0   | 3          | 1    | 185.0 |
|                  | Maleke Smith         | 6.0        | 12.0   | 0          | 0    | 170.0 |
|                  | Denorris Freeman     | 7.0        | 10.0   | 2          | 2    | 160.0 |
|                  | Jeremiah Lowe        | 8.0        | 10.0   | 4          | 0    | 145.0 |
|                  | Christopher Seaborn  | 9.0        | 12.0   | 2          | 3    | 190.0 |
|                  | Rontavious Belcher   | 10.0       | 12.0   | 0          | 4    | 200.0 |
|                  | Quintavious Stiggers | 11.0       | 10.0   | 5          | 5    | 180.0 |
|                  | Dejaiah Jackson      | 12.0       | 10.0   | 2          | 2    | 155.0 |
|                  | Terrion Riley        | 13.0       | 10.0   | 2          | 6    | 160.0 |
|                  | Latravious Lawrence  | 14.0       | 10.0   | 2          | 7    | 165.0 |
|                  | Frederick Woodruff   | 15.0       | 9.0    | 4          | 2    | 145.0 |
|                  | Robert Tucker        | 18.0       | 10.0   | 6          | 3    | 220.0 |
|                  | Gary Carter          | 20.0       | 10.0   | 2          | 8    | 165.0 |
|                  | Corey Clems          | 21.0       | 9.0    | 0          | 5    | 180.0 |
|                  | Ricky Williams       | 22.0       | 10.0   | 7          | 3    | 220.0 |
|                  | Deshant Hester       | 23.0       | 10.0   | 1          | 7    | 175.0 |
|                  | Andre McCoy          | 24.0       | 9.0    | 2          | 6    | 155.0 |
|                  | Quintavious Simpson  | 25.0       | 12.0   | 2          | 6    | 165.0 |
|                  | Steven Gray          | 27.0       | 9.0    | 0          | 5    | 200.0 |
|                  | Jorel McCrimmon      | 30.0       | 9.0    | 2          | 6    | 155.0 |
|                  | Anthony Washington   | 33.0       | 11.0   | 0          | 1    | 195.0 |
|                  | Nicholas Pressley    | 41.0       | 11.0   | 0          | 1    | 200.0 |
|                  | Tyler Bivins         | 50.0       | 10.0   | 8          | 3    | 225.0 |
|                  | Deshawn Butler       | 51.0       | 10.0   | 8          | 7    | 245.0 |
|                  | Darius Marshall      | 52.0       | 11.0   | 9          | 7    | 200.0 |
|                  | Darius Soilberry     | 53.0       | 12.0   | 8          | 5    | 200.0 |
|                  | Byron Walkins        | 55.0       | 12.0   | 8          | 3    | 265.0 |
|                  | Alec Harris          | 64.0       | 9.0    | 8          | 6    | 210.0 |
|                  | Maleik Blackmon      | 66.0       | 10.0   | 8          | 3    | 275.0 |
|                  | David Alexander      | 70.0       | 12.0   | 8          | 5    | 255.0 |
|                  | Tyler Gibson         | 71.0       | 11.0   | 8          | 4    | 345.0 |
|                  | Leonard Walker       | 84.0       | 12.0   | 6          | 5    | 185.0 |
|                  | Nicholas Roberson    | 99.0       | 9.0    | 8          | 9    | 235.0 |
| Benjamen E. Mays |                      |            |        |            |      |       |
|                  | Randercous Davis     | 1.0        | 10.0   | 10         | 5    | 170.0 |
|                  | Tyshawn Brown        | 2.0        | 11.0   | 10         | 4    | 180.0 |
|                  | Ayinde Russell       | 3.0        | 11.0   | QB/WR      | 3    | 170.0 |
|                  | Monquavious Brinson  | 4.0        | 10.0   | 11         | 6    | 160.0 |
|                  | Roderick Tyler       | 5.0        | 12.0   | 0          | 6    | 200.0 |
|                  | Jerome Smith         | 6.0        | 12.0   | 11         | 8    | 165.0 |
|                  | Khalil Brooks        | 7.0        | 11.0   | 12         | 1    | 170.0 |
|                  | Jaylon Dorsey        | 7.0        | 12.0   | 13         | 6    | 165.0 |
|                  | Natrez Patrick       | 9.0        | 11.0   | 14         | 3    | 230.0 |
|                  | Julius Whitehead     | 10.0       | 11.0   | 10         | 5    | 180.0 |
|                  | Shiheem Rutherford   | 11.0       | 11.0   | 15         | 8    | 200.0 |
|                  | Deparis Carter       | 12.0       | 11.0   | 10         | 9    | 180.0 |
|                  | A.J. Smith           | 13.0       | 10.0   | 10         | 5    | 155.0 |
|                  | Cornelius Griffin    | 15.0       | 11.0   | 16         | 4    | 175.0 |
|                  | Xzavion Curry        | 17.0       | 10.0   | 16         | 8    | 160.0 |
|                  | Bobby Spence         | 18.0       | 11.0   | 10         | 4    | 155.0 |
|                  | Yeshua Muata         | 19.0       | 10.0   | 10         | 7    | 155.0 |
|                  | Jovan Taylor         | 20.0       | 11.0   | 11         | 0    | 155.0 |
|                  | Romartis Bell        | 21.0       | 11.0   | 1          | 0    | 160.0 |
|                  | Derontay Langford    | 22.0       | 11.0   | 1          | 6    | 165.0 |
|                  | Kessely Tyler        | 23.0       | 11.0   | 0          | 1    | 190.0 |
|                  | Johnny Kinney        | 25.0       | 10.0   | 17         | 10   | 150.0 |
|                  | Henry Whitherspoon   | 26.0       | 12.0   | 13         | 1    | 180.0 |
|                  | Rashard Jones        | 27.0       | 10.0   | 11         | 0    | 155.0 |
|                  | Devin Denkins        | 28.0       | 10.0   | 11         | 6    | 145.0 |
|                  | Javier Russell       | 29.0       | 10.0   | 11         | 6    | 155.0 |
|                  | Deion Harris         | 30.0       | 10.0   | DB/K       | 1    | 175.0 |
|                  | Jordan Goodlett      | 31.0       | 12.0   | DB/P       | 8    | 180.0 |
|                  | Kelton Cameron       | 32.0       | 11.0   | 11         | 2    | 155.0 |
|                  | Aaron Young          | 34.0       | 10.0   | 11         | 0    | 145.0 |
|                  | Evan Price           | 35.0       | 11.0   | 15         | 5    | 195.0 |
|                  | Rodrecus Dalton      | 36.0       | 12.0   | 17         | 0    | 165.0 |
|                  | Karl Clemons         | 37.0       | 11.0   | 11         | 2    | 165.0 |
|                  | Nick Banks           | 38.0       | 12.0   | 17         | 10   | 145.0 |
|                  | Brian Jackson        | 39.0       | 11.0   | 15         | 7    | 185.0 |
|                  | Marquis Rivers       | 40.0       | 11.0   | 15         | 5    | 190.0 |
|                  | Malique Foreman      | 41.0       | 10.0   | LB/RB      | 8    | 190.0 |
|                  | Kwami Hooks          | 42.0       | 11.0   | 15         | 2    | 175.0 |
|                  | Dominique Roper      | 43.0       | 11.0   | 15         | 2    | 185.0 |
|                  | Antonio Nelson       | 44.0       | 11.0   | 11         | 7    | 165.0 |
|                  | Corey Coleman        | 45.0       | 10.0   | 11         | 2    | 135.0 |
|                  | Juwan Williamson     | 46.0       | 10.0   | 11         | 8    | 165.0 |
|                  | Caymen Bridges       | 47.0       | 12.0   | 15         | 8    | 200.0 |
|                  | Xavier Lewis         | 48.0       | 10.0   | 14         | 4    | 190.0 |
|                  | Keevis Montgomery    | 49.0       | 10.0   | 15         | 7    | 185.0 |
|                  | Marquez Daniels      | 50.0       | 10.0   | 18         | 1    | 190.0 |
|                  | Latwan Green         | 51.0       | 11.0   | 19         | 6    | 185.0 |
|                  | Elijah Smith         | 52.0       | 12.0   | 19         | 8    | 200.0 |
|                  | Thomas Watkins       | 54.0       | 11.0   | 20         | 5    | 290.0 |
|                  | Idris Payne          | 55.0       | 12.0   | 21         | 3    | 265.0 |
|                  | Broderick Stephens   | 56.0       | 12.0   | 22         | 5    | 225.0 |
|                  | Demetrius Arnold     | 57.0       | 10.0   | 19         | 7    | 200.0 |
|                  | Gregory Lampkin      | 58.0       | 12.0   | 20         | 5    | 235.0 |
|                  | Dallas Warmack       | 59.0       | 11.0   | 20         | 9    | 290.0 |
|                  | Joshua Wiley         | 60.0       | 12.0   | 8          | 3    | 280.0 |
|                  | Braxton White        | 65.0       | 10.0   | 8          | 5    | 220.0 |
|                  | Mason Sims           | 66.0       | 11.0   | 20         | 11   | 280.0 |
|                  | Emanuel Burns        | 68.0       | 11.0   | 20         | 4    | 190.0 |
|                  | Dequavius Sinkfield  | 70.0       | 10.0   | 20         | 11   | 280.0 |
|                  | Malik Mackey         | 71.0       | 11.0   | 20         | 6'7  | 290.0 |
|                  | Cameron Brittain     | 72.0       | 12.0   | 20         | 4    | 285.0 |

## Output:


source: excel_file
label: subtitle