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:
| CONCEPTO                  | HOTEL MISION JURIQUILLA                                         | RAMADA ENCORE HOTEL QRO.                                 | FOUR POINTS BY SHERATON                                        | FOUR POINTS BY SHERATON (WISE)                                 | PLAZA CAMELINAS HOTEL                                              | HOTEL MIRABEL                                           | HOTEL QUINTA SANTIAGO                                     | HOTEL REAL ALAMEDA                                      | HOME 2 BY HILTON                                                                    | HOTELES CITY EXPRESS SUITES                                                                       |
|:--------------------------|:----------------------------------------------------------------|:---------------------------------------------------------|:---------------------------------------------------------------|:---------------------------------------------------------------|:-------------------------------------------------------------------|:--------------------------------------------------------|:----------------------------------------------------------|:--------------------------------------------------------|:------------------------------------------------------------------------------------|:--------------------------------------------------------------------------------------------------|
| Habitación Sencilla       | 1030                                                            | 920                                                      | 1150                                                           | 1050                                                           | 789                                                                | 774                                                     | 990                                                       | 995                                                     | 1150                                                                                | 970.52                                                                                            |
| Impuestos sobre hospedaje | 2.5000000000000001E-2                                           | 3.5000000000000003E-2                                    | 3.5000000000000003E-2                                          | 3.5000000000000003E-2                                          | 2.5000000000000001E-2                                              | 2.5000000000000001E-2                                   | 2.5000000000000001E-2                                     | 2.5000000000000001E-2                                   | 3.5000000000000003E-2                                                               | 2.5000000000000001E-2                                                                             |
| I.V.A.                    | 0.16                                                            | 0.16                                                     | 0.16                                                           | 0.16                                                           | 0.16                                                               | 0.16                                                    | 0.16                                                      | 0.16                                                    | 0.16                                                                                | 0.16                                                                                              |
| Dirección                 | Blvd. Villas del Mesón No. 56, Juriquilla Querétaro. C.P. 76230 | Paseo de la República 11515, Juriquilla, Qro. C.P. 76230 | Carretera a San Luis Potosí No. 13001, Col. Jurica, C.P. 76127 | Carretera a San Luis Potosí No. 13001, Col. Jurica, C.P. 76127 | Av. 5 de Febrero 28, La Capilla, 76170 Santiago de Querétaro, Qro. | Constituyentes 2 Ote. Centro, cp. 76000 Querétaro, Qro. | Andrés Balvanera no. 4, Centro Histórico, Querétaro, Qro. | Corregidora Sur no. 184-D, Col. Centro, Querétaro, Qro. | Carret. Querétaro -San Luis Potosí 631-C, Jurica, 76100 Santiago de Querétaro, Qro. | Av. 5 de Febrero No. 9200, Col Parque Industrial Benito Juárez, 76100 Santiago de Querétaro, Qro. |
| Teléfono                  | (442) 234-0000 Ext. 547                                         | (442) 690-9400                                           | (4429 103-3030                                                 | (4429 103-3030                                                 | (442) 192-3900                                                     | (442) 214-3535 y 214-3099                               | (442) 251-9800, 224-1985 y 224-1986.                      | (442) 251 8900                                          | (442) 368 3030                                                                      | (442) 103 3900                                                                                    |
| Página web                | http://www.hotelesmision.com.mx/queretaro_juriquilla.php        | www.hotelesencore.com                                    | http://www.starwoodhotels.com/fourpoints/index.html            | http://www.starwoodhotels.com/fourpoints/index.html            | www.plazacamelinas.com.mx                                          | www.hotelmirabel.com.mx                                 | http://www.hotelquintasantiago.mx/                        | http://www.hotelrealalameda.com/                        | http://www.hiltonhotels.com/                                                        | https://www.cityexpress.com/                                                                      |
| Estrellas                 | *****                                                           | ****                                                     | *****                                                          | *****                                                          | *****                                                              | ****                                                    | ****                                                      | ****                                                    | *****                                                                               | ****                                                                                              |

## Output:


source: excel_file
label: transpose