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:
| movie_title                                                    | actor_1              | actor_2              | actor_3              |   actor_facebook_likes_1 |   actor_facebook_likes_2 | actor_facebook_likes_3   |
|:---------------------------------------------------------------|:---------------------|:---------------------|:---------------------|-------------------------:|-------------------------:|:-------------------------|
| Avatar                                                         | CCH Pounder          | Joel David Moore     | Wes Studi            |                     1000 |                      936 | 855.0                    |
| Pirates of the Caribbean: At World's End                       | Johnny Depp          | Orlando Bloom        | Jack Davenport       |                    40000 |                     5000 | 1000.0                   |
| Spectre                                                        | Christoph Waltz      | Rory Kinnear         | Stephanie Sigman     |                    11000 |                      393 | 161.0                    |
| The Dark Knight Rises                                          | Tom Hardy            | Christian Bale       | Joseph Gordon-Levitt |                    27000 |                    23000 | 23000.0                  |
| Star Wars: Episode VII - The Force Awakens                     | Doug Walker          | Rob Walker           |                      |                      131 |                       12 |                          |
| John Carter                                                    | Daryl Sabara         | Samantha Morton      | Polly Walker         |                      640 |                      632 | 530.0                    |
| Spider-Man 3                                                   | J.K. Simmons         | James Franco         | Kirsten Dunst        |                    24000 |                    11000 | 4000.0                   |
| Tangled                                                        | Brad Garrett         | Donna Murphy         | M.C. Gainey          |                      799 |                      553 | 284.0                    |
| Avengers: Age of Ultron                                        | Chris Hemsworth      | Robert Downey Jr.    | Scarlett Johansson   |                    26000 |                    21000 | 19000.0                  |
| Harry Potter and the Half-Blood Prince                         | Alan Rickman         | Daniel Radcliffe     | Rupert Grint         |                    25000 |                    11000 | 10000.0                  |
| Batman v Superman: Dawn of Justice                             | Henry Cavill         | Lauren Cohan         | Alan D. Purwin       |                    15000 |                     4000 | 2000.0                   |
| Superman Returns                                               | Kevin Spacey         | Marlon Brando        | Frank Langella       |                    18000 |                    10000 | 903.0                    |
| Quantum of Solace                                              | Giancarlo Giannini   | Mathieu Amalric      | Rory Kinnear         |                      451 |                      412 | 393.0                    |
| Pirates of the Caribbean: Dead Man's Chest                     | Johnny Depp          | Orlando Bloom        | Jack Davenport       |                    40000 |                     5000 | 1000.0                   |
| The Lone Ranger                                                | Johnny Depp          | Ruth Wilson          | Tom Wilkinson        |                    40000 |                     2000 | 1000.0                   |
| Man of Steel                                                   | Henry Cavill         | Christopher Meloni   | Harry Lennix         |                    15000 |                     3000 | 748.0                    |
| The Chronicles of Narnia: Prince Caspian                       | Peter Dinklage       | Pierfrancesco Favino | Damián Alcázar       |                    22000 |                      216 | 201.0                    |
| The Avengers                                                   | Chris Hemsworth      | Robert Downey Jr.    | Scarlett Johansson   |                    26000 |                    21000 | 19000.0                  |
| Pirates of the Caribbean: On Stranger Tides                    | Johnny Depp          | Sam Claflin          | Stephen Graham       |                    40000 |                    11000 | 1000.0                   |
| Men in Black 3                                                 | Will Smith           | Michael Stuhlbarg    | Nicole Scherzinger   |                    10000 |                      816 | 718.0                    |
| The Hobbit: The Battle of the Five Armies                      | Aidan Turner         | Adam Brown           | James Nesbitt        |                     5000 |                      972 | 773.0                    |
| The Amazing Spider-Man                                         | Emma Stone           | Andrew Garfield      | Chris Zylka          |                    15000 |                    10000 | 963.0                    |
| Robin Hood                                                     | Mark Addy            | William Hurt         | Scott Grimes         |                      891 |                      882 | 738.0                    |
| The Hobbit: The Desolation of Smaug                            | Aidan Turner         | Adam Brown           | James Nesbitt        |                     5000 |                      972 | 773.0                    |
| The Golden Compass                                             | Christopher Lee      | Eva Green            | Kristin Scott Thomas |                    16000 |                     6000 | 1000.0                   |
| King Kong                                                      | Naomi Watts          | Thomas Kretschmann   | Evan Parke           |                     6000 |                      919 | 84.0                     |
| Titanic                                                        | Leonardo DiCaprio    | Kate Winslet         | Gloria Stuart        |                    29000 |                    14000 | 794.0                    |
| Captain America: Civil War                                     | Robert Downey Jr.    | Scarlett Johansson   | Chris Evans          |                    21000 |                    19000 | 11000.0                  |
| Battleship                                                     | Liam Neeson          | Alexander Skarsgård  | Tadanobu Asano       |                    14000 |                    10000 | 627.0                    |
| Jurassic World                                                 | Bryce Dallas Howard  | Judy Greer           | Omar Sy              |                     3000 |                     2000 | 1000.0                   |
| Skyfall                                                        | Albert Finney        | Helen McCrory        | Rory Kinnear         |                      883 |                      563 | 393.0                    |
| Spider-Man 2                                                   | J.K. Simmons         | James Franco         | Kirsten Dunst        |                    24000 |                    11000 | 4000.0                   |
| Iron Man 3                                                     | Robert Downey Jr.    | Jon Favreau          | Don Cheadle          |                    21000 |                     4000 | 3000.0                   |
| Alice in Wonderland                                            | Johnny Depp          | Alan Rickman         | Anne Hathaway        |                    40000 |                    25000 | 11000.0                  |
| X-Men: The Last Stand                                          | Hugh Jackman         | Kelsey Grammer       | Daniel Cudmore       |                    20000 |                      808 | 560.0                    |
| Monsters University                                            | Steve Buscemi        | Tyler Labine         | Sean Hayes           |                    12000 |                      779 | 760.0                    |
| Transformers: Revenge of the Fallen                            | Glenn Morshower      | Kevin Dunn           | Ramon Rodriguez      |                      894 |                      581 | 464.0                    |
| Transformers: Age of Extinction                                | Bingbing Li          | Sophia Myles         | Kelsey Grammer       |                      974 |                      956 | 808.0                    |
| Oz the Great and Powerful                                      | Tim Holmes           | Mila Kunis           | James Franco         |                    44000 |                    15000 | 11000.0                  |
| The Amazing Spider-Man 2                                       | Emma Stone           | Andrew Garfield      | B.J. Novak           |                    15000 |                    10000 | 825.0                    |
| TRON: Legacy                                                   | Jeff Bridges         | Olivia Wilde         | James Frain          |                    12000 |                    10000 | 1000.0                   |
| Cars 2                                                         | Joe Mantegna         | Thomas Kretschmann   | Eddie Izzard         |                     1000 |                      919 | 776.0                    |
| Green Lantern                                                  | Ryan Reynolds        | Temuera Morrison     | Taika Waititi        |                    16000 |                      368 | 326.0                    |
| Toy Story 3                                                    | Tom Hanks            | John Ratzenberger    | Don Rickles          |                    15000 |                     1000 | 721.0                    |
| Terminator Salvation                                           | Christian Bale       | Bryce Dallas Howard  | Common               |                    23000 |                     3000 | 988.0                    |
| Furious 7                                                      | Jason Statham        | Paul Walker          | Vin Diesel           |                    26000 |                    23000 | 14000.0                  |
| World War Z                                                    | Peter Capaldi        | Brad Pitt            | Mireille Enos        |                    17000 |                    11000 | 1000.0                   |
| X-Men: Days of Future Past                                     | Jennifer Lawrence    | Peter Dinklage       | Hugh Jackman         |                    34000 |                    22000 | 20000.0                  |
| Star Trek Into Darkness                                        | Benedict Cumberbatch | Bruce Greenwood      | Noel Clarke          |                    19000 |                      981 | 928.0                    |
| Jack the Giant Slayer                                          | Eddie Marsan         | Ewen Bremner         | Ralph Brown          |                      979 |                      557 | 140.0                    |
| The Great Gatsby                                               | Leonardo DiCaprio    | Elizabeth Debicki    | Steve Bisley         |                    29000 |                      509 | 77.0                     |
| Prince of Persia: The Sands of Time                            | Jake Gyllenhaal      | Richard Coyle        | Reece Ritchie        |                    15000 |                      567 | 236.0                    |
| Pacific Rim                                                    | Charlie Hunnam       | Clifton Collins Jr.  | Larry Joe Campbell   |                    16000 |                      968 | 919.0                    |
| Transformers: Dark of the Moon                                 | Glenn Morshower      | Lester Speight       | Kevin Dunn           |                      894 |                      829 | 581.0                    |
| Indiana Jones and the Kingdom of the Crystal Skull             | Harrison Ford        | Ray Winstone         | Jim Broadbent        |                    11000 |                     1000 | 1000.0                   |
| The Good Dinosaur                                              | A.J. Buckley         | Jack McGraw          | Peter Sohn           |                      275 |                      150 | 113.0                    |
| Brave                                                          | Kelly Macdonald      | John Ratzenberger    | Julie Walters        |                     2000 |                     1000 | 838.0                    |
| Star Trek Beyond                                               | Sofia Boutella       | Melissa Roxburgh     | Lydia Wilson         |                      998 |                      119 | 105.0                    |
| WALL·E                                                         | John Ratzenberger    | Fred Willard         | Jeff Garlin          |                     1000 |                      729 | 522.0                    |
| Rush Hour 3                                                    | Tzi Ma               | Dana Ivey            | Noémie Lenoir        |                      268 |                      268 | 173.0                    |
| 2012                                                           | Oliver Platt         | Liam James           | Tom McCarthy         |                     1000 |                      468 | 310.0                    |
| A Christmas Carol                                              | Robin Wright         | Colin Firth          | Gary Oldman          |                    18000 |                    14000 | 10000.0                  |
| Jupiter Ascending                                              | Channing Tatum       | Mila Kunis           | Eddie Redmayne       |                    17000 |                    15000 | 13000.0                  |
| The Legend of Tarzan                                           | Christoph Waltz      | Alexander Skarsgård  | Casper Crump         |                    11000 |                    10000 | 103.0                    |
| The Chronicles of Narnia: The Lion, the Witch and the Wardrobe | Jim Broadbent        | Kiran Shah           | Shane Rangi          |                     1000 |                      190 | 82.0                     |
| X-Men: Apocalypse                                              | Jennifer Lawrence    | Michael Fassbender   | Tye Sheridan         |                    34000 |                    13000 | 1000.0                   |
| The Dark Knight                                                | Christian Bale       | Heath Ledger         | Morgan Freeman       |                    23000 |                    13000 | 11000.0                  |
| Up                                                             | John Ratzenberger    | Delroy Lindo         | Jess Harnell         |                     1000 |                      848 | 262.0                    |
| Monsters vs. Aliens                                            | Amy Poehler          | Rainn Wilson         | Stephen Colbert      |                     1000 |                      973 | 459.0                    |
| Iron Man                                                       | Robert Downey Jr.    | Jeff Bridges         | Jon Favreau          |                    21000 |                    12000 | 4000.0                   |
| Hugo                                                           | Chloë Grace Moretz   | Christopher Lee      | Ray Winstone         |                    17000 |                    16000 | 1000.0                   |
| Wild Wild West                                                 | Will Smith           | Salma Hayek          | Bai Ling             |                    10000 |                     4000 | 582.0                    |
| The Mummy: Tomb of the Dragon Emperor                          | Jet Li               | Brendan Fraser       | Russell Wong         |                     5000 |                     3000 | 595.0                    |
| Suicide Squad                                                  | Will Smith           | Robin Atkin Downes   | Ike Barinholtz       |                    10000 |                      336 | 329.0                    |
| Evan Almighty                                                  | Jimmy Bennett        | Morgan Freeman       | Steve Carell         |                    87000 |                    11000 | 7000.0                   |
| Edge of Tomorrow                                               | Tom Cruise           | Lara Pulver          | Noah Taylor          |                    10000 |                      854 | 509.0                    |
| Waterworld                                                     | Jeanne Tripplehorn   | Rick Aviles          | Zakes Mokae          |                      711 |                       60 | 60.0                     |
| G.I. Joe: The Rise of Cobra                                    | Joseph Gordon-Levitt | Dennis Quaid         | Leo Howard           |                    23000 |                     2000 | 570.0                    |
| Inside Out                                                     | Amy Poehler          | Mindy Kaling         | Phyllis Smith        |                     1000 |                      767 | 384.0                    |
| The Jungle Book                                                | Scarlett Johansson   | Bill Murray          | Garry Shandling      |                    19000 |                    13000 | 591.0                    |
| Iron Man 2                                                     | Robert Downey Jr.    | Scarlett Johansson   | Jon Favreau          |                    21000 |                    19000 | 4000.0                   |
| Snow White and the Huntsman                                    | Chris Hemsworth      | Kristen Stewart      | Sam Claflin          |                    26000 |                    17000 | 11000.0                  |
| Maleficent                                                     | Angelina Jolie Pitt  | Sharlto Copley       | Sam Riley            |                    11000 |                     2000 | 846.0                    |
| Dawn of the Planet of the Apes                                 | Gary Oldman          | Judy Greer           | Kodi Smit-McPhee     |                    10000 |                     2000 | 884.0                    |
| The Lovers                                                     | Tamsin Egerton       | Alice Englert        | Bipasha Basu         |                      622 |                      525 | 283.0                    |
| 47 Ronin                                                       | Keanu Reeves         | Cary-Hiroyuki Tagawa | Jin Akanishi         |                    18000 |                     1000 | 982.0                    |
| Captain America: The Winter Soldier                            | Scarlett Johansson   | Chris Evans          | Hayley Atwell        |                    19000 |                    11000 | 2000.0                   |
| Shrek Forever After                                            | Jon Hamm             | Kathy Griffin        | Mary Kay Place       |                     4000 |                      225 | 213.0                    |
| Tomorrowland                                                   | Judy Greer           | Chris Bauer          | Thomas Robinson      |                     2000 |                      638 | 604.0                    |
| Big Hero 6                                                     | Damon Wayans Jr.     | Daniel Henney        | Abraham Benrubi      |                      756 |                      719 | 562.0                    |
| Wreck-It Ralph                                                 | Jack McBrayer        | Sarah Silverman      | Joe Lo Truglio       |                      975 |                      931 | 833.0                    |
| The Polar Express                                              | Tom Hanks            | Eddie Deezen         | Peter Scolari        |                    15000 |                      726 | 267.0                    |
| Independence Day: Resurgence                                   | Vivica A. Fox        | Sela Ward            | Judd Hirsch          |                      890 |                      812 | 535.0                    |
| How to Train Your Dragon                                       | Gerard Butler        | America Ferrera      | Craig Ferguson       |                    18000 |                      953 | 759.0                    |
| Terminator 3: Rise of the Machines                             | Nick Stahl           | M.C. Gainey          | Carolyn Hennesy      |                      648 |                      284 | 191.0                    |
| Guardians of the Galaxy                                        | Bradley Cooper       | Vin Diesel           | Djimon Hounsou       |                    14000 |                    14000 | 3000.0                   |
| Interstellar                                                   | Matthew McConaughey  | Anne Hathaway        | Mackenzie Foy        |                    11000 |                    11000 | 6000.0                   |
| Inception                                                      | Leonardo DiCaprio    | Tom Hardy            | Joseph Gordon-Levitt |                    29000 |                    27000 | 23000.0                  |
| Godzilla Resurgence                                            | Mark Chinnery        | Shin'ya Tsukamoto    | Atsuko Maeda         |                      544 |                      106 | 12.0                     |
| The Hobbit: An Unexpected Journey                              | Aidan Turner         | Adam Brown           | James Nesbitt        |                     5000 |                      972 | 773.0                    |

## Output:


source: notebook
label: operator: wide_to_long
wide_to_long_start_idx: 1
wide_to_long_end_idx: 6