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:
| Type of sport      | Specific sport                                                                                                                                                                        |   Age | Sex   | Standard                   | Days later   | Sampling rationale                                                    |
|:-------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------:|:------|:---------------------------|:-------------|:----------------------------------------------------------------------|
| Team               | Basketballaa Athletes who also participated in follow-up interviews. Note. activities (e.g., mountaineering, exploring) are difficult to classify one's standard.View all notes       |    32 | F     | International amateur      | 6.0          | Self-reported excellent performance                                   |
|                    | Netball 1                                                                                                                                                                             |    20 | F     | University                 | 2.0          | Self-reported excellent performance                                   |
|                    | Netball 2                                                                                                                                                                             |    25 | F     | Regional                   | 2.0          | Awarded player of the match                                           |
|                    | Rugby Union 1                                                                                                                                                                         |    26 | M     | Club                       | 5.0          | Awarded player of the match                                           |
| Net/Wall           | Badminton 1aa Athletes who also participated in follow-up interviews. Note. activities (e.g., mountaineering, exploring) are difficult to classify one's standard.View all notes      |    22 | M     | Professional               | 1.0          | Reached final of national championships                               |
|                    | Squash                                                                                                                                                                                |    23 | F     | Professional               | 7.0          | Won international tournament                                          |
|                    | Tennis                                                                                                                                                                                |    20 | F     | Professional               | 9.0          | Qualified for Wimbledon championships                                 |
|                    | Wheelchair Tennis                                                                                                                                                                     |    23 | F     | Professional               | 3.0          | Won major international tournament                                    |
| Endurance          | Marathon 1                                                                                                                                                                            |    23 | F     | Recreational               | 1.0          | Ran personal best in marathon                                         |
|                    | Marathon 2                                                                                                                                                                            |    41 | F     | Recreational               | 3.0          | Ran personal best in marathon                                         |
|                    | Middle-Distance                                                                                                                                                                       |    26 | F     | Recreational               | 0.0          | Ran personal best in 5-km race                                        |
|                    | Half-Ironman 1                                                                                                                                                                        |    36 | M     | Professional               | 9.0          | Won national half-ironman event                                       |
|                    | Half-Ironman 2aa Athletes who also participated in follow-up interviews. Note. activities (e.g., mountaineering, exploring) are difficult to classify one's standard.View all notes   |    35 | M     | International amateur      | 2.0          | Finished fourth in national half-ironman event                        |
|                    | Cycling                                                                                                                                                                               |    29 | F     | Sponsored                  | 3.0          | Completed 300-km event—personal best for distance cycled              |
| Outdoors/Adventure | Climbing 1                                                                                                                                                                            |    33 | M     | Professional               | 4.0          | Self-reported excellent performance                                   |
|                    | Climbing 2                                                                                                                                                                            |    40 | M     | Recreational               | 5.0          | Self-reported excellent performance                                   |
|                    | Mountaineering 2aa Athletes who also participated in follow-up interviews. Note. activities (e.g., mountaineering, exploring) are difficult to classify one's standard.View all notes |    24 | M     | Experienced                | 6.0          | Self-reported excellent performance while climbing highest peak in UK |
| Sprinting          | 200-m Sprinteraa Athletes who also participated in follow-up interviews. Note. activities (e.g., mountaineering, exploring) are difficult to classify one's standard.View all notes   |    22 | M     | National amateur           | 1.0          | Won national university championships                                 |
|                    | 110-m Hurdles                                                                                                                                                                         |    21 | M     | International amateur      | 3.0          | Won national university championships                                 |
|                    | 400-m Hurdles                                                                                                                                                                         |    22 | M     | International professional | 6.0          | Ran national record in Diamond League                                 |
|                    | Jockey                                                                                                                                                                                |    32 | F     | Amateur                    | 6.0          | Finished second in international race                                 |
|                    | Rugby Union 2                                                                                                                                                                         |    37 | M     | Professional               |              | New Zealand All Black with over 100 caps; World Cup winner            |
|                    | Badminton 2                                                                                                                                                                           |    28 | M     | Professional               |              | Olympic athlete and Commonwealth Games medalist                       |
|                    | Polar Exploring                                                                                                                                                                       |    37 | M     | Sponsored                  |              | World-record holder for polar expeditions                             |
|                    | 110 m Swimmer                                                                                                                                                                         |    21 | M     | International amateur      |              | Gold medalist at Commonwealth Games                                   |
|                    | Mountaineering 1                                                                                                                                                                      |    48 | F     | Experienced                |              | Climbed five 8,000-m mountains including Everest                      |

## Output:


source: web
label: ffill