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:
| Column1                             | Class    | Gen   | Class        | Description                    | Credit   | Days   | Begin    | End      | Room   | Instructor   | Instruction    | Start    | End     |
|                                     | Number   | Ed    |              |                                | Hours    |        | Time     | Time     |        |              | Mode           | Date     | Date    |
|:------------------------------------|:---------|:------|:-------------|:-------------------------------|:---------|:-------|:---------|:---------|:-------|:-------------|:---------------|:---------|:--------|
| ACCOUNTING                          |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 45090.0  |       | ACC 201-A0BY | 0                              | 3        | 0      | 0        | 0        | 0      | 0            | 0.0            | 43696.0  | 43751.0 |
|                                     | 45364.0  |       | ACC 201-A0Z2 | 0                              | 3        | 1      | 1        | 1        | 1      | 0            | 1.0            | 43759.0  | 43814.0 |
|                                     | 45091.0  |       | ACC 201-A0ZB | 0                              | 3        | 1      | 1        | 1        | 1      | 0            | 1.0            | 43696.0  | 43751.0 |
|                                     | 45102.0  |       | ACC 202-A0BY | 1                              | 3        | 0      | 0        | 0        | 0      | 0            | 0.0            | 43759.0  | 43814.0 |
|                                     | 45103.0  |       | ACC 202-A0ZB | 1                              | 3        | 1      | 1        | 1        | 1      | 0            | 1.0            | 43759.0  | 43814.0 |
|                                     | 44601.0  |       | ACT 101-A0Z1 | Fundamentals of Accounting I   | 3        | 1      | 1        | 1        | 1      | 0            | 1.0            | 43696.0  | 43751.0 |
| AIR CONDITIONING AND REFRIGERATION  |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44746.0  |       | ACR 100-A001 | Refrigeration Fundamentals     | 3        | 2      | 2        | 2        | 2      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44747.0  |       | ACR 101-A001 | Refrigeration Fundamentals Lab | 2        | 2      | 3        | 3        | 3      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44854.0  |       | ACR 112-A001 | Sheet Metal Fabrication        | 3        | 2      | 0        | 4        | 2      | 2            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44855.0  |       | ACR 113-A001 | Sheet Metal Fabrication Lab    | 2        | 2      | 1        | 1        | 3      | 2            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44748.0  |       | ACR 130-A0E1 | Electrical Components          | 3        | 2      | 4        | 5        | 2      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44749.0  |       | ACR 131-A001 | Electrical Components Lab      | 2        | 2      | 05:20 PM | 6        | 3      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44752.0  |       | ACR 170-A001 | Heat Load/Duct Design          | 3        | 3      | 2        | 3        | 2      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44750.0  |       | ACR 250-A001 | Cooling and Dehumidification   | 3        | 0      | 0        | 7        | 2      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44751.0  |       | ACR 251-A001 | Cooling & Dehumidification Lab | 2        | 0      | 5        | 4        | 2      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44843.0  |       | ACR 290-A0Y1 | Journeyman Preparation         | 3        | 1      | 1        | 1        | 4      | 1            | 0.0            | 43696.0  | 43814.0 |
|                                     | 44880.0  |       | ACR 291-A001 | 2                              | 1        | 1      | 2        | 8        | 2      | 1            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44753.0  |       | ACR 299-A001 | 3                              | 2        | 4      | 1        | 1        | 4      | 1            | 2.0            | 43696.0  | 43814.0 |
| AUTOMOTIVE TECHNOLOGY               |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44703.0  |       | ADX 120-A001 | Basic Automotive Electricity   | 3        | 0      | 0        | 9        | 5      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44705.0  |       | 0            | 4                              | 2        | 3      | 6        | 10       | 6      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44705.0  |       | 0            | 4                              | 2        | 5      | 0        | 10       | 6      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44707.0  |       | ADX 150-A001 | Engine Repair                  | 3        | 6      | 0        | 9        | 5      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44709.0  |       | 1            | 5                              | 2        | 7      | 0        | 10       | 7      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44709.0  |       | 1            | 5                              | 2        | 6      | 6        | 4        | 7      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44711.0  |       | ADX 170-A001 | 6                              | 3        | 3      | 7        | 11       | 5      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44713.0  |       | ADX 171-A001 | 7                              | 1        | 8      | 7        | 11       | 6      | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44930.0  |       | ADX 170-A002 | 6                              | 3        | 8      | 7        | 02:15 PM | 8      | 4            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44931.0  |       | ADX 171-A002 | 7                              | 1        | 8      | 7        | 3        | 9      | 4            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55240.0  |       | ADX 260-A001 | 8                              | 3        | 3      | 0        | 9        | 10     | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55299.0  |       | 2            | 9                              | 2        | 3      | 6        | 10       | 6      | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55299.0  |       | 2            | 9                              | 2        | 5      | 0        | 10       | 6      | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45008.0  |       | ADX 260-A0E1 | 8                              | 3        | 3      | 8        | 12       | 5      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45009.0  |       | 3            | 9                              | 2        | 3      | 9        | 13       | 5      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45009.0  |       | 3            | 9                              | 2        | 5      | 8        | 6        | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55348.0  |       | AUT 140-A001 | 10                             | 3        | 9      | 7        | 14       | 10     | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55363.0  |       | 4            | 11                             | 2        | 9      | 10       | 11       | 6      | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55363.0  |       | 4            | 11                             | 2        | 7      | 7        | 11       | 6      | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55363.0  |       | 4            | 11                             | 2        | 5      | 10       | 11       | 6      | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44716.0  |       | 5            | 10                             | 3        | 3      | 11       | 15       | 5      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44716.0  |       | 5            | 10                             | 3        | 6      | 12       | 15       | 5      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44717.0  |       | 6            | 11                             | 2        | 3      | 13       | 16       | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44717.0  |       | 6            | 11                             | 2        | 6      | 13       | 16       | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44717.0  |       | 6            | 11                             | 2        | 5      | 12       | 16       | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44717.0  |       | 6            | 11                             | 2        | 7      | 12       | 16       | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55319.0  |       | AUT 240-A001 | 12                             | 3        | 6      | 0        | 9        | 10     | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55312.0  |       | 7            | 13                             | 2        | 6      | 6        | 10       | 10     | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 55312.0  |       | 7            | 13                             | 2        | 7      | 0        | 10       | 10     | 5            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44714.0  |       | AUT 240-A0E1 | 12                             | 3        | 6      | 8        | 12       | 5      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44715.0  |       | 8            | 13                             | 2        | 6      | 9        | 6        | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44715.0  |       | 8            | 13                             | 2        | 7      | 8        | 6        | 6      | 6            | 2.0            | 43696.0  | 43814.0 |
| AGRICULTURAL TECHNOLOGY AND STUDIES |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44522.0  |       | AGR 101-A0Z1 | Economics Food & Agriculture   | 3        | 1      | 1        | 1        | 1      | 7            | 1.0            | 43696.0  | 43814.0 |
|                                     | 45356.0  |       | AGR 115-A001 | Agriculture Maintenance        | 3        | 6      | 14       | 13       | SE119  | 3            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44521.0  |       | AGR 125-A001 | 14                             | 3        | 2      | 15       | 17       | 11     | 8            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44755.0  |       | AGR 125-A0L1 | 14                             | 3        | 4      | 1        | 1        | 11     | 8            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45357.0  |       | AGR 135-A001 | Herbaceous Plant Production    | 3        | 4      | 1        | 1        | 4      | 8            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45358.0  |       | AGR 145-A0Z1 | Technology in Agriculture      | 3        | 1      | 1        | 1        | 1      | 9            | 1.0            | 43696.0  | 43814.0 |
|                                     | 44520.0  |       | AGR 150-A086 | 15                             | 3        | 2      | 15       | 18       | OWCHCA | 10           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44825.0  |       | AGR 150-A0L1 | 15                             | 3        | 4      | 1        | 1        | 4      | 10           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44526.0  |       | AGR 190-A001 | Agricultural Internship II     | 2        | 1      | 1        | 1        | 4      | 9            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44527.0  |       | AGR 200-A001 | Agricultural Internship III    | 2        | 1      | 1        | 1        | 4      | 9            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45359.0  |       | AGR 205-A001 | Forage Management              | 3        | 4      | 1        | 1        | 4      | 9            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45360.0  |       | AGR 215-A001 | Weed Management                | 3        | 4      | 1        | 1        | 4      | 8            | 2.0            | 43696.0  | 43814.0 |
|                                     | 44528.0  |       | AGR 240-A001 | 16                             | 3        | 2      | 16       | 19       | 11     | 11           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44773.0  |       | AGR 240-A0L1 | 16                             | 3        | 1      | 1        | 1        | 11     | 11           | 2.0            | 43696.0  | 43814.0 |
|                                     | 45361.0  |       | AGR 275-A001 | Value Added Production         | 3        | 4      | 1        | 1        | 4      | 9            | 2.0            | 43696.0  | 43814.0 |
|                                     | 45362.0  |       | AGR 285-A0Z1 | Farm Financial Management      | 3        | 1      | 1        | 1        | 1      | 9            | 1.0            | 43696.0  | 43814.0 |
| ALLIED HEALTH                       |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 45363.0  |       | AHS 115-A0YE | 17                             | 3        | 7      | 17       | 13       | 12     | Clouse       | 0.0            | 43696.0  | 43814.0 |
|                                     | 44609.0  |       | AHS 115-A0Z1 | 17                             | 3        | 1      | 1        | 1        | 1      | 12           | 1.0            | 43696.0  | 43814.0 |
|                                     | 45018.0  |       | AHS 115-A0Z2 | 17                             | 3        | 1      | 1        | 1        | 1      | 13           | 1.0            | 43696.0  | 43814.0 |
| ART                                 |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44474.0  | 0     | ART 100-A001 | 18                             | 3        | 2      | 10       | 20       | 13     | 14           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44475.0  | 0     | ART 100-A0Z1 | 18                             | 3        | 1      | 1        | 1        | 1      | 14           | 1.0            | 43696.0  | 43814.0 |
|                                     | 44476.0  | 0     | ART 105-A001 | Ancient Through Mediev Art His | 3        | 0      | 0        | 0        | 13     | 14           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44477.0  |       | ART 110-A001 | Drawing I                      | 3        | 2      | 10       | 21       | 14     | 15           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44478.0  |       | ART 113-A001 | 3-Dimensional Design           | 3        | 0      | 10       | 21       | 14     | Schartung    | 2.0            | 43696.0  | 43814.0 |
|                                     | 44809.0  |       | ART 220-A001 | Painting I                     | 3        | 0      | 18       | 22       | 14     | 14           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44810.0  |       | ART 221-A001 | Painting II                    | 3        | 0      | 18       | 22       | 15     | 14           | 2.0            | 43696.0  | 43814.0 |
|                                     | 44479.0  |       | ART 240-A001 | Ceramics I                     | 3        | 2      | 5        | 23       | 14     | 15           | 2.0            | 43696.0  | 43814.0 |
|                                     | 45124.0  |       | ART 241-A001 | Ceramics II                    | 3        | 2      | 5        | 24       | 15     | 15           | 2.0            | 43696.0  | 43814.0 |
| ASTRONOMY                           |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44912.0  | 1     | AST 191-A0YE | The Solar System               | 3        | 3      | 9        | 25       | 12     | 16           | 0.0            | 43696.0  | 43814.0 |
| BUSINESS ADMINISTRATION SYSTEMS     |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44602.0  |       | BAS 160-A001 | 19                             | 3        | 2      | 15       | 17       | 16     | 17           | 2.0            | 43696.0  | 43814.0 |
|                                     | 45092.0  |       | BAS 160-A0BY | 19                             | 3        | 0      | 19       | 22       | 16     | 18           | 0.0            | 43696.0  | 43751.0 |
|                                     | 45093.0  |       | BAS 160-A0ZB | 19                             | 3        | 1      | 1        | 1        | 1      | 18           | 1.0            | 43696.0  | 43751.0 |
|                                     | 44603.0  |       | BAS 212-A0Z1 | Intro to Financial Management  | 3        | 1      | 1        | 1        | 1      | 0            | 1.0            | 43696.0  | 43814.0 |
|                                     | 45115.0  |       | BAS 250-A0ZB | Business Employability Seminar | 1        | 1      | 1        | 1        | 1      | 19           | 1.0            | 43759.0  | 43793.0 |
|                                     | 44604.0  |       | BAS 267-A0Z1 | Introduction to Business Law   | 3        | 1      | 1        | 1        | 1      | Carter       | 1.0            | 43696.0  | 43814.0 |
|                                     | 44605.0  |       | BAS 282-A001 | 20                             | 3        | 0      | 0        | 0        | 16     | 17           | 2.0            | 43696.0  | 43814.0 |
|                                     | 45104.0  |       | BAS 282-A0ZB | 20                             | 3        | 1      | 1        | 1        | 1      | 18           | 1.0            | 43759.0  | 43814.0 |
|                                     | 45105.0  |       | BAS 283-A0BY | 21                             | 3        | 0      | 19       | 22       | 16     | 18           | 0.0            | 43759.0  | 43814.0 |
|                                     | 45094.0  |       | BAS 283-A0ZB | 21                             | 3        | 1      | 1        | 1        | 1      | 18           | 1.0            | 43696.0  | 43751.0 |
|                                     | 45106.0  |       | BAS 284-A0ZB | Applied Management Skills      | 3        | 1      | 1        | 1        | 1      | 18           | 1.0            | 43759.0  | 43814.0 |
| BIOLOGICAL SCIENCES                 |          |       |              |                                |          |        |          |          |        |              |                |          |         |
|                                     | 44432.0  | 1     | BIO 112-A001 | 22                             | 3        | 0      | 15       | 17       | 17     | 20           | 2.0            | 43696.0  | 43814.0 |

## Output:


source: excel_file
label: subtitle