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              |   fb_like_1 |   fb_like_2 | fb_like_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