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:
| Title                           | Year   | Bond actor               | Director                                                                        | Box office(Actual $ (millions))   | Budget(Actual $ (millions))   | Salary of Bond actor(Actual $ (millions))   | Box office(Adjusted 2005 $ (millions))   | Budget(Adjusted 2005 $ (millions))   | Salary of Bond actor(Adjusted 2005 $ (millions))   |
|:--------------------------------|:-------|:-------------------------|:--------------------------------------------------------------------------------|:----------------------------------|:------------------------------|:--------------------------------------------|:-----------------------------------------|:-------------------------------------|:---------------------------------------------------|
| Dr. No                          | 1962   | Sean Connery             | Terence Young                                                                   | 59.5                              | 1.1                           | 0.1                                         | 448.8                                    | 7.0                                  | 0.6                                                |
| From Russia with Love           | 1963   | Sean Connery             | Terence Young                                                                   | 78.9                              | 2.0                           | 0.3                                         | 543.8                                    | 12.6                                 | 1.6                                                |
| Goldfinger                      | 1964   | Sean Connery             | Guy Hamilton                                                                    | 124.9                             | 3.0                           | 0.5                                         | 820.4                                    | 18.6                                 | 3.2                                                |
| Thunderball                     | 1965   | Sean Connery             | Terence Young                                                                   | 141.2                             | 6.8                           | 0.8                                         | 848.1                                    | 41.9                                 | 4.7                                                |
| Casino Royale                   | 1967   | David Niven              | Ken Hughes John Huston Joseph McGrath Robert Parrish Val Guest Richard Talmadge | 44.4                              | 12                            |                                             | 260                                      | 70                                   |                                                    |
| You Only Live Twice             | 1967   | Sean Connery             | Lewis Gilbert                                                                   | 101.0                             | 10.3                          | 0.8 + 25% net merch royalty                 | 514.2                                    | 59.9                                 | 4.4 excluding profit participation                 |
| On Her Majesty's Secret Service | 1969   | George Lazenby           | Peter R. Hunt                                                                   | 64.6                              | 7.0                           | 0.1                                         | 291.5                                    | 37.3                                 | 0.6                                                |
| Diamonds Are Forever            | 1971   | Sean Connery             | Guy Hamilton                                                                    | 116.0                             | 7.2                           | 1.2 + 12.5% of gross (14.5)                 | 442.5                                    | 34.7                                 | 5.8 excluding profit participation                 |
| Live and Let Die                | 1973   | Roger Moore              | Guy Hamilton                                                                    | 126.4                             | 7.0                           | 0.18                                        | 460.3                                    | 30.8                                 | 0.7                                                |
| The Man with the Golden Gun     | 1974   | Roger Moore              | Guy Hamilton                                                                    | 98.5                              | 7.0                           | 0.24 + 2.5%                                 | 334.0                                    | 27.7                                 | 0..8 excluding profit participation                |
| The Spy Who Loved Me            | 1977   | Roger Moore              | Lewis Gilbert                                                                   | 185.4                             | 14.0                          | 0.3 + 3.75%                                 | 533.0                                    | 45.1                                 | 0..9 excluding profit participation                |
| Moonraker                       | 1979   | Roger Moore              | Lewis Gilbert                                                                   | 210.3                             | 34.0                          |                                             | 535.0                                    | 91.5                                 |                                                    |
| For Your Eyes Only              | 1981   | Roger Moore              | John Glen                                                                       | 194.9                             | 28.0                          |                                             | 449.4                                    | 60.2                                 |                                                    |
| Octopussy                       | 1983   | Roger Moore              | John Glen                                                                       | 183.7                             | 27.5                          | 4.0                                         | 373.8                                    | 53.9                                 | 7.8                                                |
| Never Say Never Again           | 1983   | Sean Connery             | Irvin Kershner                                                                  | 160                               | 36                            |                                             | 314                                      | 71                                   |                                                    |
| A View to a Kill                | 1985   | Roger Moore              | John Glen                                                                       | 152.4                             | 30.0                          | 5.0                                         | 275.2                                    | 54.5                                 | 9.1                                                |
| The Living Daylights            | 1987   | Timothy Dalton           | John Glen                                                                       | 191.2                             | 40.0                          | 3.0                                         | 313.5                                    | 68.8                                 | 5.2                                                |
| Licence to Kill                 | 1989   | Timothy Dalton           | John Glen                                                                       | 156.2                             | 36.0                          | 5.0                                         | 250.9                                    | 56.7                                 | 7.9                                                |
| GoldenEye                       | 1995   | Pierce Brosnan           | Martin Campbell                                                                 | 351.9                             | 60.0                          | 4.0                                         | 518.5                                    | 76.9                                 | 5.1                                                |
| Tomorrow Never Dies             | 1997   | Pierce Brosnan           | Roger Spottiswoode                                                              | 338.9                             | 110.0                         | 8.2                                         | 463.2                                    | 133.9                                | 10.0                                               |
| The World Is Not Enough         | 1999   | Pierce Brosnan           | Michael Apted                                                                   | 361.8                             | 135.0                         | 12.4                                        | 439.5                                    | 158.3                                | 13.5                                               |
| Die Another Day                 | 2002   | Pierce Brosnan           | Lee Tamahori                                                                    | 431.9                             | 142.0                         | 16.5                                        | 465.4                                    | 154.2                                | 17.9                                               |
| Casino Royale                   | 2006   | Daniel Craig             | Martin Campbell                                                                 | 594.2                             | 150.0                         | 3.4                                         | 581.5                                    | 145.3                                | 3.3                                                |
| Quantum of Solace               | 2008   | Daniel Craig             | Marc Forster                                                                    | 576.0                             | 200.0                         | 8.9                                         | 514.2                                    | 181.4                                | 8.1                                                |
| Skyfall                         | 2012   | Daniel Craig             | Sam Mendes                                                                      | 1108.6                            | 150.0–200.0                   | 17.0                                        | 943.5                                    | 127.7–170.2                          | 14.5                                               |
| Spectre                         | 2015   | Daniel Craig             | Sam Mendes                                                                      | 880.7                             | 245.0–250.0                   | 39                                          | 725.5                                    | 201.8–205.9                          |                                                    |
| Total                           | Total  | Eon-produced film series | Eon-produced film series                                                        | 6,829.1                           | 1,453–1,508                   |                                             | 12,086                                   | 1,881–1,927                          |                                                    |
| Total                           | Total  | All films                | All films                                                                       | 7,033.5                           | 1,501–1,556                   |                                             | 13,283                                   | 2,162–2,208                          |                                                    |

## Output:


source: web
label: operator: wide_to_long
wide_to_long_start_idx: 4
wide_to_long_end_idx: 9