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:
| Activities                        | Y/N   | Owner   | Delivery Type     |
|:----------------------------------|:------|:--------|:------------------|
| 1. Approvals                      |       |         |                   |
| Project Plan                      |       |         | Signoff           |
| Schedule                          |       |         | Signoff           |
| Database Design shanges           |       |         | Signoff           |
| Technology Architecture changes   |       |         | Signoff           |
| 2. Usually Required               |       |         |                   |
| Business Requirements             | Y     |         | Document          |
| In house Design Workshops         | Y     |         | Workshop          |
| Functional Specifications         | Y     |         | Document          |
| Systems Design                    | Y     |         | Document          |
| Stakeholder Analysis              | Y     |         | Document          |
| Project Plan                      | Y     |         | Document          |
| Schedule                          | Y     |         | Document          |
| Implementation Plan               | Y     |         | Document          |
| Weekly Status Meeting             | Y     |         | Meeting           |
| Project Status Reports            | Y     |         | Document          |
| Steering Committee Meetings       | Y     |         | Document          |
| Risk Management Plan              | Y     |         | Document          |
| Communications Plan               | Y     |         | Document          |
| Issues Log                        | Y     |         | Document          |
| Contingency Plan                  | Y     |         | Document          |
| Test Plan                         | Y     |         | Document          |
| Test Cases                        | Y     |         | Document          |
| 3. Project Dependent              |       |         |                   |
| New Business Processes            |       |         | Document          |
| Modify Business Processes         |       |         | Document          |
| Update Disaster Recovery Plan     |       |         | Document          |
| New contract(s)                   |       |         | Document          |
| Modify contract(s)                |       |         | Document          |
| New database Design               |       |         | Document          |
| Change to database design         |       |         | Document          |
| New database                      |       |         | Development       |
| Modify database                   |       |         | Development       |
| New Operations document(s)        |       |         | Document          |
| Modify Operations document(s)     |       |         | Document          |
| New SLA                           |       |         | Document          |
| Modify SLA                        |       |         | Document          |
| Communications to Clients         |       |         | Document          |
| New Software                      |       |         | Development       |
| Software Upgrade                  |       |         | Development       |
| New Application(s)                |       |         | Development       |
| Modified Application(s)           |       |         | Development       |
| Implement new packaged solution   |       |         | Development       |
| Modify packaged solution          |       |         | Development       |
| Implement new online service      |       |         | Development       |
| Modify online service             |       |         | Development       |
| Implement new non-IT service      |       |         | Development       |
| Modify non-IT service             |       |         | Development       |
| New Hardware                      |       |         | Development       |
| Hardware Upgrade                  |       |         | Development       |
| Change in Technology Architecture |       |         | Development       |
| French Translation                |       |         | Document          |
| New Vendor(s) involved            |       |         | Vendor Management |
| Existing vendor(s) involved       |       |         | Vendor Management |

## Output:


source: excel_file
label: subtitle