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:
|     id | title                                                          | keyword_0                    | keyword_1                 | keyword_2                   | keyword_3                   | keyword_4              |
|-------:|:---------------------------------------------------------------|:-----------------------------|:--------------------------|:----------------------------|:----------------------------|:-----------------------|
|  19995 | Avatar                                                         | culture clash                | future                    | space war                   | space colony                | society                |
|    285 | Pirates of the Caribbean: At World's End                       | ocean                        | drug abuse                | exotic island               | east india trading company  | love of one's life     |
| 206647 | Spectre                                                        | spy                          | based on novel            | secret agent                | sequel                      | mi6                    |
|  49026 | The Dark Knight Rises                                          | dc comics                    | crime fighter             | terrorist                   | secret identity             | burglar                |
|  49529 | John Carter                                                    | based on novel               | mars                      | medallion                   | space travel                | princess               |
|    559 | Spider-Man 3                                                   | dual identity                | amnesia                   | sandstorm                   | love of one's life          | forgiveness            |
|  38757 | Tangled                                                        | hostage                      | magic                     | horse                       | fairy tale                  | musical                |
|  99861 | Avengers: Age of Ultron                                        | marvel comic                 | sequel                    | superhero                   | based on comic book         | vision                 |
|    767 | Harry Potter and the Half-Blood Prince                         | witch                        | magic                     | broom                       | school of witchcraft        | wizardry               |
| 209112 | Batman v Superman: Dawn of Justice                             | dc comics                    | vigilante                 | superhero                   | based on comic book         | revenge                |
|   1452 | Superman Returns                                               | saving the world             | dc comics                 | invulnerability             | sequel                      | superhero              |
|  10764 | Quantum of Solace                                              | killing                      | undercover                | secret agent                | british secret service      |                        |
|     58 | Pirates of the Caribbean: Dead Man's Chest                     | witch                        | fortune teller            | bondage                     | exotic island               | monster                |
|  57201 | The Lone Ranger                                                | texas                        | horse                     | survivor                    | texas ranger                | partner                |
|  49521 | Man of Steel                                                   | saving the world             | dc comics                 | superhero                   | based on comic book         | superhuman             |
|   2454 | The Chronicles of Narnia: Prince Caspian                       | based on novel               | fictional place           | brother sister relationship | lion                        | human being            |
|  24428 | The Avengers                                                   | new york                     | shield                    | marvel comic                | superhero                   | based on comic book    |
|   1865 | Pirates of the Caribbean: On Stranger Tides                    | sea                          | captain                   | mutiny                      | sword                       | prime minister         |
|  41154 | Men in Black 3                                                 | time travel                  | time machine              | alien                       | fictional government agency | seeing the future      |
| 122917 | The Hobbit: The Battle of the Five Armies                      | corruption                   | elves                     | dwarves                     | orcs                        | middle-earth (tolkien) |
|   1930 | The Amazing Spider-Man                                         | loss of father               | vigilante                 | serum                       | marvel comic                | scientific experiment  |
|  20662 | Robin Hood                                                     | robin hood                   | archer                    | knight                      | sherwood forest             | bow and arrow          |
|  57158 | The Hobbit: The Desolation of Smaug                            | elves                        | dwarves                   | orcs                        | hobbit                      | dragon                 |
|   2268 | The Golden Compass                                             | england                      | compass                   | experiment                  | lordship                    | uncle                  |
|    254 | King Kong                                                      | film business                | screenplay                | show business               | film making                 | film producer          |
|    597 | Titanic                                                        | shipwreck                    | iceberg                   | ship                        | panic                       | titanic                |
| 271110 | Captain America: Civil War                                     | civil war                    | war                       | marvel comic                | sequel                      | superhero              |
|  44833 | Battleship                                                     | fight                        | u.s. navy                 | mind reading                | hong kong                   | soccer                 |
| 135397 | Jurassic World                                                 | monster                      | dna                       | tyrannosaurus rex           | velociraptor                | island                 |
|  37724 | Skyfall                                                        | spy                          | secret agent              | sociopath                   | killer                      | art gallery            |
|    558 | Spider-Man 2                                                   | dual identity                | love of one's life        | pizza boy                   | marvel comic                | sequel                 |
|  68721 | Iron Man 3                                                     | terrorist                    | war on terror             | tennessee                   | malibu                      | marvel comic           |
|  12155 | Alice in Wonderland                                            | based on novel               | fictional place           | queen                       | fantasy                     | alice in wonderland    |
|  36668 | X-Men: The Last Stand                                          | mutant                       | marvel comic              | based on comic book         | superhuman                  | beast                  |
|  62211 | Monsters University                                            | monster                      | dormitory                 | games                       | animation                   | best friend            |
|   8373 | Transformers: Revenge of the Fallen                            | egypt                        | sun                       | chaos                       | symbol                      | artifact               |
|  91314 | Transformers: Age of Extinction                                | sequel                       | alien                     | transformers                | giant robot                 | robot                  |
|  68728 | Oz: The Great and Powerful                                     | circus                       | witch                     | magic                       | hope                        | illusion               |
| 102382 | The Amazing Spider-Man 2                                       | obsession                    | marvel comic              | sequel                      | based on comic book         | electrocution          |
|  20526 | TRON: Legacy                                                   | artificial intelligence      | secret identity           | computer program            | dystopia                    | computer               |
|  49013 | Cars 2                                                         | car race                     | sequel                    | comedy                      | anthropomorphism            | best friend            |
|  44912 | Green Lantern                                                  | dc comics                    | transformation            | superhero                   | alien                       | alien infection        |
|  10193 | Toy Story 3                                                    | hostage                      | college                   | toy                         | barbie                      | animation              |
|    534 | Terminator Salvation                                           | saving the world             | artificial intelligence   | prophecy                    | san francisco               | cyborg                 |
| 168259 | Furious 7                                                      | car race                     | speed                     | revenge                     | suspense                    | car                    |
|  72190 | World War Z                                                    | dystopia                     | apocalypse                | zombie                      | nuclear weapons             | multiple perspectives  |
| 127585 | X-Men: Days of Future Past                                     | 1970s                        | mutant                    | time travel                 | marvel comic                | based on comic book    |
|  54138 | Star Trek Into Darkness                                        | spacecraft                   | friendship                | sequel                      | futuristic                  | space                  |
|  81005 | Jack the Giant Slayer                                          | based on fairy tale          | giant                     |                             |                             |                        |
|  64682 | The Great Gatsby                                               | based on novel               | infidelity                | obsession                   | hope                        | 3d                     |
|   9543 | Prince of Persia: The Sands of Time                            | persia                       | sandstorm                 | brother against brother     | armageddon                  | regent                 |
|  68726 | Pacific Rim                                                    | dystopia                     | giant robot               | giant monster               | apocalypse                  | imax                   |
|  38356 | Transformers: Dark of the Moon                                 | moon                         | spacecraft                | traitor                     | bodyguard                   | alien planet           |
|    217 | Indiana Jones and the Kingdom of the Crystal Skull             | saving the world             | riddle                    | whip                        | treasure                    | mexico city            |
| 105864 | The Good Dinosaur                                              | tyrannosaurus rex            | friends                   | alternate history           | dinosaur                    | fear                   |
|  62177 | Brave                                                          | scotland                     | rebel                     | bravery                     | kingdom                     | archer                 |
| 188927 | Star Trek Beyond                                               | sequel                       | stranded                  | hatred                      | space opera                 |                        |
|  10681 | WALL·E                                                         | romantic comedy              |                           |                             |                             |                        |
|   5174 | Rush Hour 3                                                    | ambassador                   |                           |                             |                             |                        |
|  14161 | 2012                                                           | civilization                 | natural disaster          | end of the world            | disaster                    | apocalypse             |
|  17979 | A Christmas Carol                                              | holiday                      | based on novel            | victorian england           | money                       | christmas eve          |
|  76757 | Jupiter Ascending                                              | jupiter                      | space                     | woman director              | 3d                          | interspecies romance   |
| 258489 | The Legend of Tarzan                                           | africa                       | feral child               | tarzan                      | jungle                      | animal attack          |
|    411 | The Chronicles of Narnia: The Lion, the Witch and the Wardrobe | saving the world             | witch                     | based on novel              | brother sister relationship | self sacrifice         |
| 246655 | X-Men: Apocalypse                                              | mutant                       | supernatural powers       | marvel comic                | superhero                   | based on comic book    |
|    155 | The Dark Knight                                                | dc comics                    | crime fighter             | secret identity             | scarecrow                   | sadism                 |
|  14160 | Up                                                             | age difference               | central and south america | balloon                     | animation                   | floating in the air    |
|  15512 | Monsters vs Aliens                                             | alien                        | giant robot               | duringcreditsstinger        |                             |                        |
|   1726 | Iron Man                                                       | middle east                  | arms dealer               | malibu                      | marvel comic                | superhero              |
|  44826 | Hugo                                                           | library                      | clock                     | film director               | key                         | toy                    |
|   8487 | Wild Wild West                                                 | steampunk                    | based on tv series        | steam locomotive            | drag                        |                        |
|   1735 | The Mummy: Tomb of the Dragon Emperor                          |                              |                           |                             |                             |                        |
| 297761 | Suicide Squad                                                  | dc comics                    | shared universe           | anti hero                   | secret mission              | villain                |
|   2698 | Evan Almighty                                                  | father son relationship      | daily life                | married couple              | support                     | father                 |
| 137113 | Edge of Tomorrow                                               | deja vu                      | time warp                 | restart                     | dystopia                    | war                    |
|   9804 | Waterworld                                                     | ocean                        | tattoo                    | mutant                      | water                       | dystopia               |
|  14869 | G.I. Joe: The Rise of Cobra                                    | terrorist                    | secret                    | hostage                     | technology                  | warhead                |
| 150540 | Inside Out                                                     | dream                        | cartoon                   | imaginary friend            | animation                   | family                 |
| 278927 | The Jungle Book                                                | based on novel               | snake                     | wolf                        | elephant                    | tiger                  |
|  10138 | Iron Man 2                                                     | malibu                       | marvel comic              | superhero                   | based on comic book         | revenge                |
|  58595 | Snow White and the Huntsman                                    | queen                        | magic                     | fairy tale                  | immortality                 | forest                 |
| 102651 | Maleficent                                                     | fairy tale                   | villain                   | sleeping beauty             | dark fantasy                | based on fairy tale    |
| 119450 | Dawn of the Planet of the Apes                                 | leader                       | colony                    | post-apocalyptic            | dystopia                    | forest                 |
|  79698 | The Lovers                                                     |                              |                           |                             |                             |                        |
|  64686 | 47 Ronin                                                       | japan                        | suicide                   | samurai                     | based on true story         | samurai sword          |
| 100402 | Captain America: The Winter Soldier                            | washington d.c.              | future                    | shield                      | marvel comic                | superhero              |
|  10192 | Shrek Forever After                                            | ogre                         | 3d                        |                             |                             |                        |
| 158852 | Tomorrowland                                                   | inventor                     | apocalypse                | destiny                     | imax                        | dreamer                |
| 177572 | Big Hero 6                                                     | brother brother relationship | hero                      | talent                      | revenge                     | best friend            |
|  82690 | Wreck-It Ralph                                                 | support group                | product placement         | bullying                    | racing                      | arcade                 |
|   5255 | The Polar Express                                              | santa claus                  | nerd                      | faith                       | gift                        | bell                   |
|  47933 | Independence Day: Resurgence                                   | alternate history            | alien invasion            |                             |                             |                        |
|  10191 | How to Train Your Dragon                                       | flying                       | blacksmith                | arena                       | island                      | night                  |
|    296 | Terminator 3: Rise of the Machines                             | saving the world             | artificial intelligence   | man vs machine              | cyborg                      | killer robot           |
| 118340 | Guardians of the Galaxy                                        | marvel comic                 | spaceship                 | space                       | outer space                 | orphan                 |
| 157336 | Interstellar                                                   | saving the world             | artificial intelligence   | father son relationship     | single parent               | nasa                   |
|  27205 | Inception                                                      | loss of lover                | dream                     | kidnapping                  | sleep                       | subconsciousness       |
| 315011 | Shin Godzilla                                                  | monster                      | godzilla                  | giant monster               | destruction                 | kaiju                  |
|  49051 | The Hobbit: An Unexpected Journey                              | riddle                       | elves                     | dwarves                     | orcs                        | middle-earth (tolkien) |
|   9799 | The Fast and the Furious                                       | street gang                  | car race                  | undercover                  | auto-tuning                 | los angeles            |

## Output:


source: notebook
label: operator: stack
stack_start_idx: 2
stack_end_idx: 6