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:
|   Season | Champion(s)   | Record          | Coach                      | Selector(s)              |
|---------:|:--------------|:----------------|:---------------------------|:-------------------------|
|     1869 | Princeton     | 1–1             |                            | BR, NCF, PD              |
|     1869 | Rutgers       | 1–1             |                            | PD                       |
|     1870 | Princeton     | 1–0             |                            | BR, NCF, PD              |
|     1871 | None          | No games played | No games played            | No games played          |
|     1872 | Princeton     | 1–0             |                            | BR, NCF, PD              |
|     1872 | Yale          | 1–0             |                            | PD                       |
|     1873 | Princeton     | 2–0             |                            | BR, NCF, PD              |
|     1874 | Harvard       | 1–1             |                            | PD                       |
|     1874 | Princeton     | 2–0             |                            | BR, PD                   |
|     1874 | Yale          | 3–0             |                            | NCF, PD                  |
|     1875 | Columbia      | 3–1–1           |                            | PD                       |
|     1875 | Harvard       | 4–0             |                            | NCF, PD                  |
|     1875 | Princeton     | 2–0             |                            | BR, PD                   |
|     1876 | Yale          | 3–0             |                            | BR, NCF, PD              |
|     1877 | Princeton     | 2–0–1           |                            | BR, PD                   |
|     1877 | Yale          | 3–0–1           |                            | NCF, PD                  |
|     1878 | Princeton     | 6–0             |                            | BR, NCF, PD              |
|     1879 | Princeton     | 4–0–1           |                            | BR, NCF, PD              |
|     1879 | Yale          | 3–0–2           |                            | PD                       |
|     1880 | Princeton     | 4–0–1           |                            | NCF, PD                  |
|     1880 | Yale          | 4–0–1           |                            | BR, NCF, PD              |
|     1881 | Princeton     | 7–0–2           |                            | BR, PD                   |
|     1881 | Yale          | 5–0–1           |                            | NCF, PD                  |
|     1882 | Yale          | 8–0             |                            | BR, NCF, PD              |
|     1883 | Yale          | 9–0             |                            | BR, HAF, NCF, PD         |
|     1884 | Princeton     | 9–0–1           |                            | BR, PD                   |
|     1884 | Yale          | 8–0–1           |                            | HAF, NCF, PD             |
|     1885 | Princeton     | 9–0             |                            | BR, HAF, HS, NCF, PD     |
|     1886 | Princeton     | 7–0–1           |                            | BR, PD                   |
|     1886 | Yale          | 9–0–1           |                            | HAF, NCF, PD             |
|     1887 | Yale          | 9–0             |                            | BR, HAF, HS, NCF, PD     |
|     1888 | Yale          | 13–0            | Walter Camp                | BR, HAF, HS, NCF, PD     |
|     1889 | Princeton     | 10–0            |                            | BR, HAF, HS, NCF, PD     |
|     1890 | Harvard       | 11–0            | George C. Adams            | BR, HAF, HS, NCF, PD     |
|     1891 | Yale          | 13–0            | Walter Camp                | BR, HAF, HS, NCF, PD     |
|     1892 | Yale          | 13–0            | Walter Camp                | BR, HAF, HS, NCF, PD     |
|     1893 | Princeton     | 11–0            |                            | BR, HAF, HS, NCF         |
|     1893 | Yale          | 10–1            | William Rhodes             | PD                       |
|     1894 | Penn          | 12–0            | George Washington Woodruff | PD                       |
|     1894 | Princeton     | 8–2             |                            | HS                       |
|     1894 | Yale          | 16–0            | William Rhodes             | BR, HAF, NCF, PD         |
|     1895 | Penn          | 14–0            | George Washington Woodruff | BR, HAF, HS, NCF, PD     |
|     1895 | Yale          | 13–0–2          | John A. Hartwell           | PD                       |
|     1896 | Lafayette     | 11–0–1          | Parke H. Davis             | NCF, PD                  |
|     1896 | Princeton     | 10–0–1          | Franklin Morse             | BR, HAF, HS, NCF, PD     |
|     1897 | Penn          | 15–0            | George Washington Woodruff | BR, HAF, HS, NCF, PD     |
|     1897 | Yale          | 9–0–2           | Frank Butterworth          | PD                       |
|     1898 | Harvard       | 11–0            | William Forbes             | BR, HAF, HS, NCF         |
|     1898 | Princeton     | 11–0–1          |                            | PD                       |
|     1899 | Harvard       | 10–0–1          | Benjamin Dibblee           | HAF, HS, NCF             |
|     1899 | Princeton     | 12–1            |                            | BR, PD                   |
|     1900 | Yale          | 12–0            | Malcolm McBride            | BR, HAF, HS, NCF, PD     |
|     1901 | Harvard       | 12–0            | Bill Reid                  | BR                       |
|     1901 | Michigan      | 11–0            | Fielding H. Yost           | HAF, HS, NCF             |
|     1901 | Yale          | 11–1–1          | George S. Stillman         | PDa                      |
|     1902 | Michigan      | 11–0            | Fielding H. Yost           | BR, HAF, HS, NCF, PD     |
|     1902 | Yale          | 11–0–1          | Joseph R. Swan             | PD                       |
|     1903 | Michigan      | 11–0–1          | Fielding H. Yost           | NCF                      |
|     1903 | Princeton     | 11–0            | Art Hillebrand             | BR, HAF, HS, NCF, PD     |
|     1904 | Michigan      | 10–0            | Fielding H. Yost           | NCF                      |
|     1904 | Minnesota     | 13–0            | Henry Williams             | BR                       |
|     1904 | Penn          | 12–0            | Carl S. Williams           | HAF, HS, NCF, PD         |
|     1905 | Chicago       | 10–0            | Amos Alonzo Stagg          | BR, HAF, HS, NCF         |
|     1905 | Yale          | 10–0            | Jack Owsley                | CW, PD                   |
|     1906 | Princeton     | 9–0–1           | William Roper              | HAF, NCF                 |
|     1906 | Yale          | 9–0–1           | Foster Rockwell            | BR, CW, PD               |
|     1907 | Yale          | 9–0–1           | William F. Knox            | BR, CW, HAF, HS, NCF, PD |
|     1908 | Harvard       | 9–0–1           | Percy Haughton             | BR                       |
|     1908 | LSU           | 10–0            | Edgar Wingard              | NCF                      |
|     1908 | Penn          | 11–0–1          | Sol Metzger                | HAF, HS, NCF, PD         |
|     1909 | Yale          | 10–0            | Howard Jones               | BR, HAF, HS, NCF, PD     |
|     1910 | Harvard       | 8–0–1           | Percy Haughton             | BR, HAF, HS, NCF         |
|     1910 | Pittsburgh    | 9–0             | Joseph Thompson            | NCF                      |
|     1911 | Penn State    | 8–0–1           | Bill Hollenback            | NCF                      |
|     1911 | Princeton     | 8–0–2           | William Roper              | BR, HAF, HS, NCF, PD     |
|     1912 | Harvard       | 9–0             | Percy Haughton             | BR, HAF, HS, NCF, PD     |
|     1912 | Penn State    | 8–0             | Bill Hollenback            | NCF                      |
|     1913 | Auburn        | 8–0             | Mike Donahue               | BR                       |
|     1913 | Chicago       | 7–0             | Amos Alonzo Stagg          | PD                       |
|     1913 | Harvard       | 9–0             | Percy Haughton             | HAF, HS, NCF, PD         |
|     1914 | Army          | 9–0             | Charles Daly               | HAF, HS, NCF, PD         |
|     1914 | Illinois      | 7–0             | Robert Zuppke              | PD                       |
|     1914 | Texas         | 8–0             | Dave Allerdice             | BR                       |
|     1915 | Cornell       | 9–0             | Albert Sharpe              | HAF, HS, NCF, PD         |
|     1915 | Oklahoma      | 10–0            | Bennie Owen                | BR                       |
|     1915 | Pittsburgh    | 8–0             | Glenn "Pop" Warner         | PD                       |
|     1916 | Army          | 9–0             | Charles Daly               | PD                       |
|     1916 | Pittsburgh    | 8–0             | Glenn "Pop" Warner         | BR, HAF, HS, NCF, PD     |
|     1917 | Georgia Tech  | 9–0             | John Heisman               | BR, HAF, HS, NCF         |
|     1918 | Michigan      | 5–0             | Fielding H. Yost           | BR, NCF                  |
|     1918 | Pittsburgh    | 4–1             | Glenn "Pop" Warner         | HAF, HS, NCF             |
|     1919 | Centre        | 9–0             | Charley Moran              | SR                       |
|     1919 | Harvard       | 9–0–1           | Bob Fisher                 | CFRA, HAF, HS, NCF, PD   |
|     1919 | Illinois      | 6–1             | Robert Zuppke              | BS, CFRA, PD, SR         |
|     1919 | Notre Dame    | 9–0             | Knute Rockne               | NCF, PD                  |
|     1919 | Texas A&M     | 10–0            | Dana X. Bible              | BR, NCF                  |
|     1920 | California    | 9–0             | Andy Smith                 | CFRA, HAF, HS, NCF, SR   |
|     1920 | Harvard       | 8–0–1           | Bob Fisher                 | BS                       |
|     1920 | Notre Dame    | 9–0             | Knute Rockne               | BR, PD                   |
|     1920 | Princeton     | 6–0–1           | William Roper              | BS, PD                   |

## Output:


source: web
label: explode