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

## Output:


source: notebook
label: operator: wide_to_long
wide_to_long_start_idx: 5
wide_to_long_end_idx: 10