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:
| Common Name (click for description)          | Moisture Requirement   | Deer Resistant?   |
|:---------------------------------------------|:-----------------------|:------------------|
| FERNS                                        |                        |                   |
| Christmas Fern                               | 0.0                    | 0.0               |
| Cinnamon Fern                                | 1.0                    | 0.0               |
| Hay-scented Fern                             | 0.0                    | 0.0               |
| Lady Fern                                    | 2.0                    | 0.0               |
| Maidenhair Fern                              | 0.0                    | 0.0               |
| Marginal Wood Fern                           | 0.0                    | 0.0               |
| Marsh Fern                                   | 1.0                    | 0.0               |
| Ostrich Fern                                 | 1.0                    | 0.0               |
| Royal Fern                                   | 1.0                    | 0.0               |
| Sensitive Fern                               | 1.0                    | 0.0               |
| GRASSES                                      |                        |                   |
| Big Bluestem                                 | 0.0                    | 0.0               |
| Bottlebrush Grass                            | 3.0                    | 0.0               |
| Broadleaved Sedge                            | 0.0                    | 0.0               |
| Broomsedge Bluestem                          | 2.0                    | 0.0               |
| Indian Grass                                 | 0.0                    | 0.0               |
| Little Bluestem                              | 4.0                    | 0.0               |
| Northern Sea Oats                            | 3.0                    | 0.0               |
| Panic Grass                                  | 0.0                    | 0.0               |
| Pennsylvania Sedge                           | 0.0                    | 0.0               |
| Purple Lovegrass                             | 4.0                    | 0.0               |
| Virginia Wild Rye                            | 1.0                    | 0.0               |
| Wool Grass                                   | 1.0                    | 0.0               |
| SHRUBS - Small (< 3')                        |                        |                   |
| Carolina Rose                                | 4.0                    | 1.0               |
| Lowbush Blueberry                            | 4.0                    | 0.0               |
| Meadowsweet                                  | 5.0                    | 0.0               |
| New Jersey Tea                               | 6.0                    | 1.0               |
| Steeplebush                                  | 5.0                    | 0.0               |
| Sweetfern                                    | 4.0                    | 0.0               |
| SHRUBS - Medium (3 - 6')                     |                        |                   |
| Beach Plum                                   | 4.0                    | 1.0               |
| Black Chokeberry                             | 2.0                    | 1.0               |
| Black Huckleberry                            | 4.0                    | 0.0               |
| Flowering Raspberry                          | 0.0                    | 0.0               |
| Hearts a'burstin                             | 0.0                    | 1.0               |
| Red Chokeberry                               | 2.0                    | 1.0               |
| Red-osier Dogwood                            | 1.0                    | 1.0               |
| Sweet Pepperbush                             | 2.0                    | 1.0               |
| Virginia Rose                                | 0.0                    | 1.0               |
| Virginia Sweetspire                          | 2.0                    | 0.0               |
| Wild Hydrangea                               | 3.0                    | 1.0               |
| SHRUBS - Large (> 6')                        |                        |                   |
| American Hazelnut                            | 0.0                    | 1.0               |
| Bayberry                                     | 2.0                    | 0.0               |
| Blackhaw                                     | 0.0                    | 1.0               |
| Buttonbush                                   | 1.0                    | 1.0               |
| Common Elderberry                            | 1.0                    | 1.0               |
| Gray Dogwood                                 | 2.0                    | 1.0               |
| Highbush Blueberry                           | 2.0                    | 1.0               |
| Maple-leaved Viburnum                        | 0.0                    | 1.0               |
| Nannyberry                                   | 6.0                    | 1.0               |
| Northern Arrowwood                           | 2.0                    | 1.0               |
| Serviceberry                                 | 0.0                    | 1.0               |
| Silky Dogwood                                | 1.0                    | 1.0               |
| Smooth Alder                                 | 1.0                    | 1.0               |
| Spicebush                                    | 2.0                    | 1.0               |
| Winterberry                                  | 1.0                    | 1.0               |
| Witch-hazel                                  | 0.0                    | 1.0               |
| TREES - Small (< 25')                        |                        |                   |
| Flowering Dogwood                            | 0.0                    | 1.0               |
| Gray Birch                                   | 0.0                    | 1.0               |
| Ironwood                                     | 3.0                    | 1.0               |
| Pawpaw                                       | 3.0                    | 1.0               |
| Redbud                                       | 0.0                    | 1.0               |
| River Birch                                  | 2.0                    | 1.0               |
| Sassafras                                    | 0.0                    | 1.0               |
| Sweetbay Magnolia                            | 2.0                    | 1.0               |
| TREES - Large (25 - 50+')                    |                        |                   |
| American Basswood                            | 3.0                    | 1.0               |
| American Beech                               | 3.0                    | 1.0               |
| American Holly                               | 0.0                    | 1.0               |
| American Sycamore                            | 2.0                    | 1.0               |
| Black Tupelo                                 | 2.0                    | 1.0               |
| Eastern Red Cedar                            | 4.0                    | 0.0               |
| Hackberry                                    | 0.0                    | 1.0               |
| Mockernut Hickory                            | 0.0                    | 1.0               |
| Northern Red Oak                             | 0.0                    | 1.0               |
| Persimmon                                    | 0.0                    | 1.0               |
| Pin Oak                                      | 2.0                    | 1.0               |
| Shagbark Hickory                             | 2.0                    | 1.0               |
| Sugar Maple                                  | 3.0                    | 1.0               |
| Swamp White OaK                              | 1.0                    | 1.0               |
| Sweet Birch                                  | 0.0                    | 1.0               |
| White Oak                                    | 3.0                    | 1.0               |
| VINES                                        |                        |                   |
| Coral Honeysuckle                            | 3.0                    | 0.0               |
| Groundnut                                    | 2.0                    | 0.0               |
| Virginia Creeper                             | 0.0                    | 0.0               |
| Virgin's Bower Clematis                      | 3.0                    | 0.0               |
| WILDFLOWERS - Meadows - Sun to Partial Shade |                        |                   |
| Adam's Needle                                | 7.0                    | 0.0               |
| Anise Hyssop                                 | 3.0                    | 0.0               |
| Bearberry                                    | 7.0                    | 0.0               |
| Beebalm                                      | 2.0                    | 0.0               |
| Blue False Indigo                            | 3.0                    | 0.0               |
| Blue Flag                                    | 1.0                    | 1.0               |
| Blue Vervain                                 | 1.0                    | 0.0               |
| Boneset                                      | 1.0                    | 1.0               |

## Output:


source: excel_file
label: subtitle