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:
| Key:                                              | M1- Contextual Analysis   | M2- Research Skills   | M3- Critical Writing   | M4- Content Knowledge   |
| I =  Introduced                                   |                           |                       |                        |                         |
| R = Reinforced                                    |                           |                       |                        |                         |
| M =  Mastered                                     |                           |                       |                        |                         |
|:--------------------------------------------------|:--------------------------|:----------------------|:-----------------------|:------------------------|
| Major Core Courses                                |                           |                       |                        |                         |
| HIS 1101 - Foundations of US History              | I                         | 0.0                   | I                      | 0.0                     |
| HIS 2204 - Religion in America                    |                           | 0.0                   | 0                      | 0.0                     |
| HIS 3106 - Civil War                              | 0                         | 1.0                   |                        | 1.0                     |
| HIS 4101 - History Capstone                       | 1                         | 2.0                   | 1                      | 2.0                     |
| Major Concentration Courses                       |                           |                       |                        |                         |
| HIS 1202 - Survey of the American Revolution      |                           | 0.0                   |                        | 0.0                     |
| HIS 2404 - Colonial America                       |                           |                       | 0                      | 1.0                     |
| HIS 3200 - The Founding Fathers                   |                           |                       | 0                      | 1.0                     |
| HIS 4202 - The Constitution and Declaration       | 1                         | 2.0                   |                        | 2.0                     |
| Major Elective Courses                            |                           |                       |                        |                         |
| HIS 1201 - Religious History of Europe            |                           |                       |                        | 1.0                     |
| HIS 3201 - Survey of the History of Asia          |                           | 1.0                   |                        | 1.0                     |
| HIS 3206 - Survey of the History of South America |                           | 1.0                   |                        | 1.0                     |
| HIS 4101 - World at War                           | 0                         |                       | 1                      | 1.0                     |

## Output:


source: excel_file
label: operator: subtitle
operator: stack
stack_start_idx: 1
stack_end_idx: 4
alternative_label: operator: stack
stack_start_idx: 1
stack_end_idx: 4
operator: subtitle