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:
| Demographics           | Total Number of Deaths    | Percent of Deaths   | Crude Death Rate    | Age-adjusted Death Rate   |
|:-----------------------|:--------------------------|:--------------------|:--------------------|:--------------------------|
| Age                    |                           |                     |                     |                           |
| Less than 5            | 437.0                     | 0.009               | 142.5               | 0.0                       |
| 5 to 17                | 157.0                     | 0.003               | 20.6                | 0.0                       |
| 18 to 25               | 487.0                     | 0.01                | 77.2                | 0.0                       |
| 26 to 64               | 10358.0                   | 0.207               | 327.9               | 0.0                       |
| 65 and older           | 38698.0                   | 0.772               | 4711.3              | 0.0                       |
| Sex                    |                           |                     |                     |                           |
| Female                 | 25437.0                   | 0.51                | 879.2               | 614.4                     |
| Male                   | 24700.0                   | 0.49                | 865.2               | 826.7                     |
| Race/Ethnicity         |                           |                     |                     |                           |
| White                  | 45929.0                   | 0.916069968         | 916.2               | 696.6                     |
| Black/African American | 2377.0                    | 0.047410096         | 586.3               | 960.3                     |
| American Indian        | 400.0                     | 0.00797814          | 653.6               | 1028.5                    |
| Asian                  | 304.0                     | 0.006063386         | 199.2               | 416.9                     |
| Hispanic               | 711.0                     | 0.014181144         | 161.3               | 467.3                     |
| Other, Uknown, Missing | 416.0                     | 0.008297265         | 0.0                 | 0.0                       |

## Output:


source: excel_file
label: subtitle