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:
| Business School                                                                            | University                                          | Location (State, City)               | USN 2023   | BW 2019   | Forbes 2019   | BI 2016   | FT 2016   | Ec 2015   | QS 2015   |
|:-------------------------------------------------------------------------------------------|:----------------------------------------------------|:-------------------------------------|:-----------|:----------|:--------------|:----------|:----------|:----------|:----------|
| A. Gary Anderson Graduate School of Management                                             | University of California Riverside                  | California, Riverside                | 89         | NR        |               | -         |           |           | 69.0      |
| Argyros School of Business and Economics                                                   | Chapman University                                  | California, Orange                   | 72         | NR        |               | -         |           |           |           |
| Atkinson Graduate School of Management                                                     | Willamette University                               | Oregon, Salem                        | 102-134    | 82        | 57.0          | -         |           |           |           |
| Babcock Graduate School of Management                                                      | Wake Forest University                              | North Carolina, Winston-Salem        | NR         | NR        |               | -         |           |           |           |
| Bauer College of Business                                                                  | University of Houston                               | Texas, Houston                       | 85         | 74        |               |           |           |           |           |
| Bennett S. LeBow College of Business                                                       | Drexel University                                   | Pennsylvania, Philadelphia           | NR         | NR        |               |           |           |           |           |
| Binghamton University School of Management                                                 | Binghamton University                               | New York, Binghamton                 | 102-134    | NR        |               |           |           |           |           |
| Booth School of Business                                                                   | University of Chicago                               | Illinois, Chicago                    | 1          | 4         | 1.0           | 2         | 8.0       | 1.0       | 4.0       |
| Brandeis International Business School                                                     | Brandeis University                                 | Massachusetts, Waltham               | 102-134    | 90        |               |           |           |           |           |
| Busch School of Business and Economics                                                     | Catholic University of America                      | Washington, DC                       | NR         | NR        |               |           |           |           |           |
| Carl H. Lindner College of Business                                                        | University of Cincinnati                            | Ohio, Cincinnati                     | 89         | 86        |               |           |           |           |           |
| Carlson School of Management                                                               | University of Minnesota                             | Minnesota, Minneapolis               | 33         | 35        | 32.0          |           | 71.0      | 55.0      |           |
| Carroll School of Management                                                               | Boston College                                      | Massachusetts, Chestnut Hill         | 41         | 49        |               |           | 69.0      |           |           |
| Raymond J. Harbert College of Business                                                     | Auburn University                                   | Alabama, Auburn                      | 80         | 85        |               | -         |           |           |           |
| Charlton College of Business                                                               | University of Massachusetts Dartmouth               | Massachusetts, Dartmouth             | NR         | NR        |               |           |           |           |           |
| Columbia Business School                                                                   | Columbia University                                 | New York, New York City              | 8          | 9         | 7.0           | 7         | 6.0       | 12.0      | 5.0       |
| Cox School of Business                                                                     | Southern Methodist University                       | Texas, Dallas                        | 41         | 42        | 45.0          |           |           | 82.0      |           |
| Crummer Graduate School of Business                                                        | Rollins College                                     | Florida, Winter Park                 | 102-134    | NR        | 51.0          |           |           |           |           |
| Manderson Graduate School of Business                                                      | University of Alabama                               | Alabama, Tuscaloosa                  | 57         | NR        | 50.0          |           |           |           |           |
| Daniels College of Business                                                                | University of Denver                                | Denver, Colorado                     | 71         | 83        |               |           |           |           |           |
| Darden Graduate School of Business Administration                                          | University of Virginia                              | Virginia, Charlottesville            | 14         | 5         | 13.0          | 11        |           | 2.0       | 37.0      |
| David Eccles School of Business                                                            | University of Utah                                  | Utah, Salt Lake City                 | 40         | 51        | 36.0          |           |           |           |           |
| E. J. Ourso College of Business                                                            | Louisiana State University                          | Louisiana, Baton Rouge               | 89         | NR        |               |           |           |           |           |
| E. Philip Saunders College of Business                                                     | Rochester Institute of Technology                   | New York, Henrietta                  | 102-134    | 93        |               |           |           |           |           |
| Eli Broad College of Business                                                              | Michigan State University                           | Michigan, East Lansing               | 36         | 39        | 27.0          | 38        | 65.0      | 35.0      |           |
| Eller College of Management                                                                | University of Arizona                               | Arizona, Tucson                      | 47         | 61        |               |           |           | 93.0      |           |
| Fisher College of Business                                                                 | Ohio State University                               | Ohio, Columbus                       | 39         | 41        | 41.0          |           | 75.0      | 31.0      |           |
| Florida International University College of Business / Chapman Graduate School of Business | Florida International University                    | Florida, Miami                       | NR         | 94        |               |           |           |           |           |
| Foster School of Business                                                                  | University of Washington                            | Washington, Seattle                  | 22         | 16        | 23.0          | 31        | 49.0      | 37.0      |           |
| Fox School of Business                                                                     | Temple University                                   | Pennsylvania, Philadelphia           | 77         | NR        |               |           |           | 53.0      |           |
| Freeman School of Business                                                                 | Tulane University                                   | Louisiana, New Orleans               | 80         | 69        | 59.0          |           |           |           |           |
| Fuqua School of Business                                                                   | Duke University                                     | North Carolina, Durham               | 12         | 20        | 14.0          | 13        | 21.0      | 20.0      | 13.0      |
| F. W. Olin Graduate School of Business                                                     | Babson College                                      | Massachusetts, Wellesley             | 57         | 56        |               | 40        | 90.0      |           |           |
| Gabelli School of Business                                                                 | Fordham University                                  | New York, New York City              | 64         | 57        | 58.0          |           |           |           |           |
| Gatton College of Business and Economics                                                   | University of Kentucky                              | Kentucky, Lexington                  | 72         | 86        |               |           |           |           |           |
| Gies College of Business                                                                   | University of Illinois                              | Illinois, Champaign                  | NR         | NR        |               | 43        | 91.0      |           |           |
| Goizueta Business School                                                                   | Emory University                                    | Georgia, Atlanta                     | 21         | 23        | 22.0          | 23        | 55.0      | 25.0      |           |
| Graziadio School of Business and Management                                                | Pepperdine University                               | California, Malibu                   | 82         | 63        | 61.0          |           |           |           |           |
| Haas School of Business                                                                    | University of California, Berkeley                  | California, Berkeley                 | 8          | 8         | 11.0          | 10        | 7.0       | 6.0       | 12.0      |
| Hankamer School of Business                                                                | Baylor University                                   | Texas, Waco                          | 64         | 79        |               |           |           |           |           |
| Harvard Business School                                                                    | Harvard University                                  | Massachusetts, Boston                | 5          | 3         | 4.0           | 3         | 2.0       | 4.0       | 1.0       |
| Howard University School of Business                                                       | Howard University                                   | Washington, D.C.                     | 57         | 45        |               |           |           |           |           |
| Hult International Business School                                                         | Hult International Business School                  | Massachusetts, Cambridge             | NR         | 66        |               |           |           | 65.0      |           |
| Iowa State University College of Business                                                  | Iowa State University                               | Iowa, Ames                           | 57         | NR        |               |           |           |           |           |
| Isenberg School of Management                                                              | University of Massachusetts Amherst                 | Massachusetts, Amherst               | 53         | NR        |               |           |           |           |           |
| Poole College of Management                                                                | North Carolina State University                     | North Carolina, Raleigh              | 67         | 47        |               |           |           |           |           |
| Jesse H. Jones Graduate School of Management                                               | Rice University                                     | Texas, Houston                       | 27         | 31        | 26.0          | 41        | 53.0      | 45.0      |           |
| Chaifetz School of Business                                                                | Saint Louis University                              | Missouri, St. Louis                  | 93         | NR        |               |           |           |           |           |
| Kansas School of Business                                                                  | University of Kansas                                | Lawrence, Kansas                     | 79         |           |               |           |           |           |           |
| Katz School of Business                                                                    | University of Pittsburgh                            | Pennsylvania, Pittsburgh             | 55         | 54        | 37.0          |           | 98.0      | 69.0      |           |
| Kelley School of Business                                                                  | Indiana University                                  | Indiana, Bloomington                 | 22         | 25        | 19.0          | 34        | 54.0      | 29.0      |           |
| Kellogg School of Management                                                               | Northwestern University                             | Illinois, Evanston                   | 3          | 10        | 3.0           | 6         | 11.0      | 7.0       | 6.0       |
| Kenan-Flagler Business School                                                              | University of North Carolina, Chapel Hill           | North Carolina, Chapel Hill          | 19         | 18        | 15.0          | 20        | 41.0      | 33.0      |           |
| Kellstadt Graduate School of Business                                                      | DePaul University                                   | Illinois, Chicago                    | NR         | NR        |               |           |           |           |           |
| Kogod School of Business                                                                   | American University                                 | Washington, D.C.                     | 76         | 91        |               |           |           |           |           |
| Krannert School of Management                                                              | Purdue University                                   | Indiana, West Lafayette              | NR         | 78        | 40.0          |           |           |           |           |
| Leavey School of Business                                                                  | Santa Clara University                              | California, Santa Clara              | NR         | NR        |               |           |           |           |           |
| Leeds School of Business                                                                   | University of Colorado at Boulder                   | Colorado, Boulder                    | 67         | 67        | 60.0          |           |           |           |           |
| Liautaud Graduate School of Business                                                       | University of Illinois at Chicago                   | Illinois, Chicago                    | NR         | NR        |               |           |           |           |           |
| Lubin School of Business                                                                   | Pace University                                     | New York City                        | NR         | NR        |               |           |           |           |           |
| Lundquist College of Business                                                              | University of Oregon                                | Eugene, Oregon                       | 72         | 88        |               |           |           |           |           |
| Marriott School of Management                                                              | Brigham Young University                            | Utah, Provo                          | 36         | 27        | 24.0          | 44        | 80.0      |           |           |
| Scheller College of Business                                                               | Georgia Institute of Technology                     | Georgia, Atlanta                     | 28         | 24        | 28.0          | 39        | 71.0      |           |           |
| Marshall School of Business                                                                | University of Southern California                   | California, Los Angeles              | 19         | 22        | 21.0          | 32        | 52.0      | 71.0      |           |
| Martin J. Whitman School of Management                                                     | Syracuse University                                 | New York, Syracuse                   | 57         | 65        |               |           |           |           |           |
| Mason School of Business                                                                   | College of William & Mary                           | Virginia, Williamsburg               | 47         | 34        | 44.0          |           |           |           |           |
| Massry Center for Business                                                                 | University at Albany, State University of New York  | New York, Albany                     | 102-134    | NR        |               |           |           |           |           |
| Mays Business School                                                                       | Texas A&M University                                | Texas, College Station               | 41         | 53        | 33.0          | 42        |           |           |           |
| McCallum Graduate School of Business                                                       | Bentley University                                  | Massachusetts, Waltham               | 102-134    | 84        |               |           |           |           |           |
| McCombs School of Business                                                                 | University of Texas at Austin                       | Texas, Austin                        | 18         | 21        | 18.0          | 21        | 47.0      | 39.0      |           |
| McDonough School of Business                                                               | Georgetown University                               | Washington, D.C.                     | 22         | 19        | 31.0          | 25        | 44.0      | 40.0      |           |
| Mendoza College of Business                                                                | University of Notre Dame                            | Indiana, South Bend                  | 25         | 28        | 25.0          | 24        | 76.0      | 44.0      |           |
| Merage School of Business                                                                  | University of California, Irvine                    | California, Irvine                   | 44         | 46        | 43.0          |           | 57.0      |           |           |
| Michael F. Price College of Business                                                       | University of Oklahoma                              | Oklahoma, Norman                     | 85         | 64        |               |           |           |           |           |
| MIT Sloan School of Management                                                             | Massachusetts Institute of Technology               | Massachusetts, Cambridge             | 5          | 7         | 7.0           | 5         | 9.0       | 15.0      | 7.0       |
| Moore School of Business                                                                   | University of South Carolina                        | South Carolina, Columbia             | 47         | 70        |               |           |           | 96.0      |           |
| Naveen Jindal School of Management                                                         | University of Texas at Dallas                       | Texas, Richardson                    | 29         | 36        | 46.0          |           |           |           |           |
| D'Amore-McKim School of Business                                                           | Northeastern University                             | Massachusetts, Boston                | 85         | 75        |               |           |           |           |           |
| Neeley School of Business                                                                  | Texas Christian University                          | Texas, Fort Worth                    | 67         | 40        |               |           |           | 63.0      |           |
| Olin Business School                                                                       | Washington University in St. Louis                  | Missouri, St. Louis                  | 29         | 38        | 29.0          | 30        | 80.0      | 41.0      |           |
| Owen Graduate School of Management                                                         | Vanderbilt University                               | Tennessee, Nashville                 | 25         | 30        | 30.0          | 28        | 71.0      | 36.0      |           |
| Pamplin College of Business                                                                | Virginia Polytechnic Institute and State University | Virginia, Blacksburg                 | NR         | NR        |               |           |           |           |           |
| Peter F. Drucker and Masatoshi Ito Graduate School of Management                           | Claremont Graduate University                       | California, Claremont                | 102-134    | NR        |               |           |           |           |           |
| Powers College of Business                                                                 | Clemson University                                  | Clemson, South Carolina              | 94         |           |               |           |           |           |           |
| Rady School of Management                                                                  | University of California, San Diego                 | California, San Diego                | 94         | 60        |               |           | 59.0      |           |           |
| Rawls College of Business                                                                  | Texas Tech University                               | Lubbock, Texas                       | 102-134    | 73        |               |           |           |           |           |
| Robert H. Smith School of Business                                                         | University of Maryland, College Park                | Maryland, College Park               | 45         | 26        | 47.0          |           | 51.0      | 42.0      |           |
| Ross School of Business                                                                    | University of Michigan                              | Michigan, Ann Arbor                  | 10         | 17        | 10.0          | 14        | 20.0      | 27.0      | 8.0       |
| Rutgers Business School                                                                    | Rutgers University                                  | New Jersey, New Brunswick and Newark | 45         | 62        |               |           |           |           |           |
| Questrom School of Business                                                                | Boston University                                   | Massachusetts, Boston                | 47         | 50        | 39.0          | 36        | 71.0      | 67.0      |           |
| Samuel Curtis Johnson Graduate School of Management                                        | Cornell University                                  | New York, Ithaca                     | 15         | 11        | 9.0           | 15        | 31.0      | 23.0      | 25.0      |
| Sam M. Walton College of Business                                                          | University of Arkansas                              | Arkansas, Fayetteville               | 64         | NR        |               |           |           |           |           |
| School of Business                                                                         | College of Charleston                               | Charleston, SC                       | 98         | 91        |               |           |           |           |           |
| Simon Business School                                                                      | University of Rochester                             | New York, Rochester                  | 33         | 29        | 42.0          |           | 86.0      | 51.0      |           |
| Smeal College of Business                                                                  | Penn State University                               | Pennsylvania, University Park        | 33         | 33        | 34.0          |           | 89.0      | 62.0      |           |
| Stanford Graduate School of Business                                                       | Stanford University                                 | California, Stanford                 | 3          | 1         | 2.0           | 4         | 5.0       | 13.0      | 1.0       |
| SIT School of Business                                                                     | Stevens Institute of Technology                     | Hoboken, New Jersey                  | 77         |           |               |           |           |           |           |
| Stern School of Business                                                                   | New York University                                 | New York, New York City              | 12         | 13        | 20.0          | 16        | 19.0      | 11.0      | 10.0      |
| Sykes School of Business                                                                   | University of Tampa                                 | Tampa, Florida                       | NR         | 81        |               |           |           |           |           |
| Tepper School of Business                                                                  | Carnegie Mellon University                          | Pennsylvania, Pittsburgh             | 16         | 15        | 17.0          | 22        | 33.0      | 30.0      |           |

## Output:


source: wikipedia
label: operator: stack
stack_start_idx: 3
stack_end_idx: 9