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:
|   Thematic | Milestones                                                          |   Status |   Need for Technical Assistance? |   Financial Support needed |   Priority |   Supporting Attachment (to be uploaded in the specified link) | Indicator it corresponds to   |
|-----------:|:--------------------------------------------------------------------|---------:|---------------------------------:|---------------------------:|-----------:|---------------------------------------------------------------:|:------------------------------|
|          0 | Plan                                                                |        0 |                                0 |                          0 |          0 |                                                              0 | A                             |
|          0 | Structure + Membership                                              |        0 |                                0 |                          0 |          0 |                                                              0 | 0                             |
|          0 | Training + Capacity Building                                        |        0 |                                0 |                          0 |          0 |                                                              0 | D,E,F                         |
|          0 | Tools                                                               |        0 |                                0 |                          0 |          0 |                                                              0 | 1                             |
|          0 | Implement Oversight activities (over a period of 6 months at least) |        0 |                                0 |                          0 |          0 |                                                              0 | D                             |
|          1 | Plan composition (number and repartition)                           |        0 |                                0 |                          0 |          0 |                                                              0 | 2                             |
|          1 | Formal decision to renew composition and membership by CCM          |        0 |                                0 |                          0 |          0 |                                                              0 | 2                             |
|          1 | Membership Renewal Calendar                                         |        0 |                                0 |                          0 |          0 |                                                              0 | 2                             |
|          1 | Implementation of renewal (including constituency mobilization)     |        0 |                                0 |                          0 |          0 |                                                              0 | G,H,I,K,P,J,M                 |
|          1 | 0                                                                   |        0 |                                0 |                          0 |          0 |                                                              0 | 2                             |
|          2 | Policy developped and endorsed by CCM                               |        0 |                                0 |                          0 |          0 |                                                              0 | N                             |
|          2 | Implementation (including signature of COI forms)                   |        0 |                                0 |                          0 |          0 |                                                              0 | 3                             |
|          2 | 0                                                                   |        0 |                                0 |                          0 |          0 |                                                              0 | 3                             |
|          3 | Organogram and Terms of Reference                                   |        0 |                                0 |                          0 |          0 |                                                              0 | 0                             |
|          3 | Conduct Structural reform                                           |        0 |                                0 |                          0 |          0 |                                                              0 | 0                             |
|          3 | 0                                                                   |        0 |                                0 |                          0 |          0 |                                                              0 | 0                             |
|          4 | Government Sector                                                   |        0 |                                0 |                          0 |          0 |                                                              0 | 1                             |
|          4 | Partners                                                            |        0 |                                0 |                          0 |          0 |                                                              0 | 1                             |
|          4 | Civil Society and Private Sector                                    |        0 |                                0 |                          0 |          0 |                                                              0 | 1                             |
|          5 | Communication Plan                                                  |        0 |                                0 |                          0 |          0 |                                                              0 | L                             |
|          5 | Implementation of Communication Plan                                |        0 |                                0 |                          0 |          0 |                                                              0 | F,C                           |

## Output:


source: excel_file
label: explode