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:
|   Index | title                                                                           | country                                                |
|--------:|:--------------------------------------------------------------------------------|:-------------------------------------------------------|
|       0 | Norm of the North: King Sized Adventure                                         | United States,  India,  South Korea,  China            |
|       1 | Jandino: Whatever it Takes                                                      | United Kingdom                                         |
|       2 | Transformers Prime                                                              | United States                                          |
|       3 | Transformers: Robots in Disguise                                                | United States                                          |
|       4 | #realityhigh                                                                    | United States                                          |
|       5 | Apaches                                                                         | Spain                                                  |
|       6 | Automata                                                                        | Bulgaria,  United States,  Spain,  Canada              |
|       7 | Fabrizio Copano: Solo pienso en mi                                              | Chile                                                  |
|       8 | Fire Chasers                                                                    | United States                                          |
|       9 | Good People                                                                     | United States,  United Kingdom,  Denmark,  Sweden      |
|      10 | Joaquín Reyes: Una y no más                                                     |                                                        |
|      11 | Kidnapping Mr. Heineken                                                         | Netherlands,  Belgium,  United Kingdom,  United States |
|      12 | Krish Trish and Baltiboy                                                        |                                                        |
|      13 | Krish Trish and Baltiboy: Battle of Wits                                        |                                                        |
|      14 | Krish Trish and Baltiboy: Best Friends Forever                                  |                                                        |
|      15 | Krish Trish and Baltiboy: Comics of India                                       |                                                        |
|      16 | Krish Trish and Baltiboy: Oversmartness Never Pays                              |                                                        |
|      17 | Krish Trish and Baltiboy: Part II                                               |                                                        |
|      18 | Krish Trish and Baltiboy: The Greatest Trick                                    |                                                        |
|      19 | Love                                                                            | France,  Belgium                                       |
|      20 | Manhattan Romance                                                               | United States                                          |
|      21 | Moonwalkers                                                                     | France,  Belgium                                       |
|      22 | Rolling Papers                                                                  | United States,  Uruguay                                |
|      23 | Stonehearst Asylum                                                              | United States                                          |
|      24 | The Runner                                                                      | United States                                          |
|      25 | 6 Years                                                                         | United States                                          |
|      26 | Castle of Stars                                                                 |                                                        |
|      27 | City of Joy                                                                     | United States,                                         |
|      28 | First and Last                                                                  |                                                        |
|      29 | Laddaland                                                                       | Thailand                                               |
|      30 | Next Gen                                                                        | China,  Canada,  United States                         |
|      31 | Sierra Burgess Is A Loser                                                       | United States                                          |
|      32 | The Most Assassinated Woman in the World                                        | Belgium,  United Kingdom,  United States               |
|      33 | Cézanne et moi                                                                  | Belgium,  France                                       |
|      34 | Archibald's Next Big Thing                                                      |                                                        |
|      35 | Article 15                                                                      | India                                                  |
|      36 | Care of Kancharapalem                                                           |                                                        |
|      37 | Ee Nagaraniki Emaindi                                                           | India                                                  |
|      38 | Kill Me If You Dare                                                             |                                                        |
|      39 | The Spy                                                                         | France                                                 |
|      40 | Hell and Back                                                                   | United States                                          |
|      41 | PK                                                                              | India                                                  |
|      42 | Hard Tide                                                                       | United Kingdom                                         |
|      43 | Elstree 1976                                                                    | United Kingdom                                         |
|      44 | American Factory: A Conversation with the Obamas                                |                                                        |
|      45 | ATM                                                                             | United States,  Canada                                 |
|      46 | Bangkok Traffic (Love) Story                                                    | Thailand                                               |
|      47 | I Fine... Thank You... Love You                                                 | Thailand                                               |
|      48 | One Day                                                                         | Thailand                                               |
|      49 | Phobia 2                                                                        | Thailand                                               |
|      50 | Shutter                                                                         | Thailand                                               |
|      51 | Suckseed                                                                        | Thailand                                               |
|      52 | Carrie Pilby                                                                    | United States                                          |
|      53 | Marc Maron: Too Real                                                            | United States                                          |
|      54 | No Tomorrow                                                                     | United States                                          |
|      55 | Saawan                                                                          | Pakistan                                               |
|      56 | The Heretics                                                                    | Canada                                                 |
|      57 | The World We Make                                                               | United States                                          |
|      58 | Watchman                                                                        | India                                                  |
|      59 | Black Panther                                                                   | United States                                          |
|      60 | Man Up                                                                          | United Kingdom,  France                                |
|      61 | Frequency                                                                       | United States                                          |
|      62 | Mo Gilligan: Momentum                                                           | United Kingdom                                         |
|      63 | Adam Ruins Everything                                                           | United States                                          |
|      64 | Ben 10                                                                          | United States                                          |
|      65 | Big Miracle                                                                     | United States,  United Kingdom                         |
|      66 | Christiane Amanpour: Sex & Love Around the World                                | United States                                          |
|      67 | The Eighties                                                                    | United States                                          |
|      68 | The Nineties                                                                    | United States                                          |
|      69 | The Seventies                                                                   | United States                                          |
|      70 | We Bare Bears                                                                   | United States                                          |
|      71 | The Mayor                                                                       | South Korea                                            |
|      72 | The Royal House of Windsor                                                      | United Kingdom                                         |
|      73 | Amanda Knox                                                                     | Denmark,  United States                                |
|      74 | Lovesick                                                                        |                                                        |
|      75 | The Debt Collector                                                              | United Kingdom,  United States                         |
|      76 | Act of Vengeance                                                                | Turkey,  United States                                 |
|      77 | Paradise Lost                                                                   | Brazil                                                 |
|      78 | Gerald's Game                                                                   | United States                                          |
|      79 | Long Shot                                                                       | United States                                          |
|      80 | Mak Cun                                                                         |                                                        |
|      81 | Our Souls at Night                                                              | United States                                          |
|      82 | Out of Thin Air                                                                 |                                                        |
|      83 | Paul Hollywood's Big Continental Road Trip                                      | United Kingdom                                         |
|      84 | Satu Hari                                                                       |                                                        |
|      85 | Monster High: Boo York, Boo York                                                | United States                                          |
|      86 | Cultivating the Seas: History and Future of the Full-Cycle Cultured Kindai Tuna |                                                        |
|      87 | Domino                                                                          | Denmark,  France,  Italy,  Belgium,  Netherlands       |
|      88 | TUNA GIRL                                                                       |                                                        |
|      89 | 5CM                                                                             | Indonesia                                              |
|      90 | Animal World                                                                    | China                                                  |
|      91 | Hold the Dark                                                                   | United States                                          |
|      92 | Lessons from a School Shooting: Notes from Dunblane                             | United States                                          |
|      93 | Made in Mexico                                                                  | United States                                          |
|      94 | Single                                                                          | Indonesia                                              |
|      95 | The 3rd Eye                                                                     | Indonesia                                              |
|      96 | The Sinking Of Van Der Wijck                                                    | Indonesia                                              |
|      97 | Two Catalonias                                                                  | Spain                                                  |
|      98 | Bobby Sands: 66 Days                                                            | Ireland,  United Kingdom                               |
|      99 | Bard of Blood                                                                   | India                                                  |

## Output:


source: notebook
label: explode