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:
|   attributes.Ambience.casual |   attributes.BikeParking |   attributes.BusinessAcceptsCreditCards |   attributes.BusinessParking.street |   attributes.HasTV |   attributes.RestaurantsDelivery |   attributes.GoodForMeal.breakfast |   attributes.GoodForMeal.brunch |   attributes.GoodForMeal.dessert |   attributes.GoodForMeal.dinner |   attributes.GoodForMeal.latenight |   attributes.GoodForMeal.lunch | attributes.Alcohol   | attributes.NoiseLevel   |
|-----------------------------:|-------------------------:|----------------------------------------:|------------------------------------:|-------------------:|---------------------------------:|-----------------------------------:|--------------------------------:|---------------------------------:|--------------------------------:|-----------------------------------:|-------------------------------:|:---------------------|:------------------------|
|                        False |                    False |                                    True |                                True |              False |                            False |                               True |                           False |                            False |                           False |                              False |                          False | none                 | quiet                   |
|                         True |                        0 |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | average                 |
|                         True |                    False |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                        False |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                            0 |                        0 |                                    True |                               False |                  0 |                                0 |                              False |                           False |                            False |                           False |                              False |                          False | 0                    | 0                       |
|                        False |                    False |                                    True |                               False |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                        False |                        0 |                                   False |                               False |              False |                            False |                              False |                           False |                            False |                           False |                              False |                          False | none                 | 0                       |
|                        False |                        0 |                                   False |                                True |                  0 |                            False |                               True |                            True |                            False |                           False |                              False |                          False | none                 | average                 |
|                        False |                     True |                                    True |                               False |              False |                            False |                              False |                           False |                            False |                           False |                              False |                          False | none                 | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                           False |                              False |                           True | none                 | loud                    |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                    False |                                    True |                               False |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                    False |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | quiet                   |
|                         True |                    False |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                    False |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                               True |                           True | none                 | average                 |
|                         True |                     True |                                    True |                               False |              False |                            False |                              False |                           False |                            False |                           False |                              False |                           True | none                 | average                 |
|                         True |                    False |                                    True |                               False |               True |                            False |                               True |                            True |                            False |                           False |                              False |                          False | none                 | average                 |
|                         True |                     True |                                   False |                                True |              False |                            False |                               True |                            True |                            False |                           False |                              False |                           True | none                 | average                 |
|                         True |                    False |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | beer_and_wine        | average                 |
|                        False |                        0 |                                    True |                               False |               True |                                0 |                              False |                           False |                            False |                           False |                              False |                          False | beer_and_wine        | average                 |
|                        False |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | loud                    |
|                        False |                     True |                                    True |                               False |               True |                             True |                              False |                           False |                             True |                            True |                              False |                           True | full_bar             | average                 |
|                        False |                     True |                                    True |                                True |               True |                            False |                              False |                            True |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |              False |                             True |                              False |                           False |                            False |                           False |                              False |                           True | none                 | average                 |
|                         True |                     True |                                   False |                                True |              False |                            False |                              False |                           False |                            False |                           False |                              False |                           True | none                 | quiet                   |
|                         True |                     True |                                   False |                                True |              False |                            False |                              False |                           False |                            False |                           False |                              False |                           True | none                 | loud                    |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | average                 |
|                         True |                        0 |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                        False |                        0 |                                    True |                               False |              False |                                0 |                              False |                           False |                            False |                           False |                              False |                          False | none                 | average                 |
|                         True |                     True |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                           False |                              False |                          False | full_bar             | quiet                   |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                        False |                        0 |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                           False |                              False |                          False | full_bar             | average                 |
|                            0 |                        0 |                                    True |                                   0 |                  0 |                            False |                              False |                           False |                            False |                           False |                              False |                          False | 0                    | 0                       |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                         True |                    False |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | loud                    |
|                         True |                     True |                                   False |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                        False |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | none                 | average                 |
|                        False |                        0 |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                        False |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | beer_and_wine        | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                            True |                            False |                            True |                              False |                          False | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                           False |                              False |                           True | full_bar             | average                 |
|                         True |                    False |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | none                 | average                 |
|                        False |                     True |                                    True |                                True |              False |                            False |                              False |                            True |                            False |                           False |                              False |                          False | full_bar             | average                 |
|                        False |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                    False |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                               True |                          False | full_bar             | loud                    |
|                        False |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                               True |                           False |                             True |                           False |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                               True |                            True |                            False |                           False |                              False |                          False | none                 | average                 |
|                         True |                     True |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                        False |                        0 |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | quiet                   |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                        False |                        0 |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | quiet                   |
|                        False |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | loud                    |
|                        False |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                               True |                           True | none                 | average                 |
|                        False |                    False |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                           False |                              False |                          False | full_bar             | average                 |
|                        False |                    False |                                    True |                               False |              False |                            False |                              False |                           False |                            False |                           False |                              False |                           True | none                 | average                 |
|                         True |                     True |                                   False |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                    False |                                    True |                               False |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                        False |                     True |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                            True |                            False |                            True |                               True |                           True | full_bar             | average                 |
|                        False |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | loud                    |
|                        False |                     True |                                    True |                               False |              False |                            False |                               True |                           False |                            False |                           False |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                               True |                          False | full_bar             | loud                    |
|                         True |                     True |                                    True |                                True |              False |                            False |                               True |                            True |                            False |                           False |                              False |                           True | none                 | average                 |
|                        False |                     True |                                    True |                                True |               True |                                0 |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | quiet                   |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | beer_and_wine        | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                           False |                              False |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                           False |                              False |                           True | none                 | average                 |
|                         True |                     True |                                   False |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                    False |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | beer_and_wine        | average                 |
|                         True |                        0 |                                    True |                                True |              False |                            False |                              False |                           False |                            False |                            True |                              False |                           True | none                 | quiet                   |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | quiet                   |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | beer_and_wine        | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | loud                    |
|                         True |                     True |                                    True |                                True |              False |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                          False | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                            False |                               True |                           False |                            False |                           False |                              False |                          False | none                 | average                 |
|                            0 |                        0 |                                       0 |                                   0 |                  0 |                            False |                                  0 |                               0 |                                0 |                               0 |                                  0 |                              0 | none                 | 0                       |
|                        False |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                               True |                           True | full_bar             | average                 |
|                         True |                     True |                                    True |                                True |              False |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                               False |               True |                            False |                              False |                           False |                            False |                           False |                              False |                           True | full_bar             | average                 |
|                        False |                     True |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | none                 | average                 |
|                         True |                     True |                                    True |                                True |               True |                            False |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | average                 |
|                        False |                     True |                                    True |                               False |               True |                             True |                              False |                           False |                            False |                            True |                              False |                           True | full_bar             | quiet                   |

## Output:


source: notebook
label: operator: stack
stack_start_idx: 0
stack_end_idx: 13