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:
| Native American                     | Column1   |          Dollars |   M/F |   Contract |   Prime | Districts     |
|:------------------------------------|:----------|-----------------:|------:|-----------:|--------:|:--------------|
| ADANTA INC                          | -4142.0   |   9750           |     0 |          6 |       5 | 5,7,9,10      |
| AMERICAN STEEL PLACERS              | 33.0      | 732108           |     1 |          1 |       1 | 6             |
| CREST EQUIPMENT INC                 | -4142.0   | 140000           |     0 |          1 |       1 | 11            |
| DISABLED AMERICAN VETERAN           | 33.0      |      1.88873e+06 |     1 |          3 |       2 | 5,6,10        |
| FINE GRADE EQUIPMENT                | -4142.0   |      1.33112e+07 |     0 |          2 |       2 | 6             |
| FORCE TRAFFIC CONTROL               | -4142.0   | 385930           |     1 |          3 |       2 | 9,10          |
| GLOBAL TRANSLOADING                 | 43.0      |   6120           |     0 |          1 |       1 | 7             |
| GR SUNDBERG INC                     | -4142.0   | 881575           |     1 |          5 |       3 | 1, 4          |
| KRC SAFETY COMPANY                  | -4142.0   |      4.47559e+06 |     1 |         22 |      10 | 3,4,5,6,7,8,9 |
| RAPER ELCETRICAL                    | 33.0      | 221019           |     1 |          4 |       3 | 3,5,10        |
| S.T. RHOADES                        | -4142.0   |      2.1679e+06  |     1 |          6 |       5 | 1,2           |
| SAMS EQUIPMENT                      | 43.0      |  83205           |     1 |          1 |       1 | 1             |
| SPIRIT ROAD OILS                    |           |  15981.4         |     0 |          3 |       2 | 4,5           |
| TRINITY VALLEY CONSULTING ENGINEERS |           |  25200           |     1 |          1 |       1 | 2             |

## Output:


source: excel_file
label: explode