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:
| First Name        | Last Name        | Organization/ Consultant                            | Address                   | City                | State   | Zip     | Phone         | Approved Services         |
|:------------------|:-----------------|:----------------------------------------------------|:--------------------------|:--------------------|:--------|:--------|:--------------|:--------------------------|
| Todd J.           | Barman           | Barman Development Strategies, LLC                  | 308 South Monroe Street   | Stoughton           | WI      | 53589.0 | 608.332.9565  | D,G,J,M                   |
| John R.           | Barrow           |                                                     | 503 Southwest 23rd Place  | 0                   | 0       | 32601.0 | 352.317.8282  | P,Q                       |
| Nancy L.          | Brown, MBA       | Designs in Development                              | P.O. Box 4460             | Seminole            | 0       | 33775.0 | 727.398.5997  | A,B,C,D                   |
| Dan               | Burden           | Walkable and Livable Communities Institute          | 1215 Lawrence St.         | Port Townsend       | WA      | 98368.0 | 614.595.0976  | H,I,M,N,P                 |
| Juan S.           | Calderon, PE     | Caltran Engineering Group, Inc.                     | 1400 NW 107th Ave.        | Miami               | 0       | 33172.0 | 786.456.7700  | N,P                       |
| Sharlene W        | Cannon           |                                                     | 422 Lakeshore Way         | Cordele             | GA      | 31015.0 | 229.224.4095  | A,C,E,G,H,J,K,O,P         |
| Laura Lee         | Corbett          | Laura Lee Corbett Consulting                        | 1422 Devils Dip           | 1                   | 0       | 32308.0 | 850.264.4611  | A,C,I,K,Q                 |
| Virginia (Ginger) | Corless, AICP    | Herbert - Halback, Inc. (d.b.a. HHI Design          | 1021 E. Robinson Street   | 2                   | 0       | 32810.0 | 407.422.1449  | I,K,L,M,P,Q               |
| Brad              | Cornelius, AICP  | Wade Trim, Inc.                                     | 8745 Henderson Road       | Tampa               | 0       | 33634.0 | 813.882.8366  | H,I,M,P                   |
| Chuck             | D'Aprix          |                                                     | 1701 The Green Way        | 3                   | 0       | 32250.0 | 202.386.6404  | D,F,G,J                   |
| Scott W.          | Day              | Urban Development Services                          | 354 Thorman Place         | San Antonio         | 0       | 78209.0 | 210.930.3866  | E,G,I, J,M,P,Q            |
| David             | Driapsa, ALSA    | Florida Chapter, The American Society of Landscapes | 725 103rd Avenue North    | Naples              | 0       | 34108.0 | 239.591.2321  | H,I,M,N,P,Q               |
| Pauline           | Eaton            | Orlando Main Street Program Coordinator             | 5136 Stratemeyer Drive    | 2                   | 0       | 32839.0 | 407.246.3259  | A,C,J,K,O,Q               |
| Robert M.         | Field            | PLACE Planning & Design, Inc.                       | 700 Rte.1                 | North Palm Beach    | 0       | 33408.0 | 561.379.4495  | E,H,I,P,Q                 |
| Ronald H.         | Frantz Jr., AIA  | The Frantz Alliance, LLC                            | 12200 Camelot Drive       | Oklahoma City       | OK      | 73120.0 | 405.740.0854  | A,P,Q                     |
| David P.          | Godwin, AIA      | Design Sequence                                     | 204 Freddie Street        | Indian Harbor Beach | 0       | 32937.0 | 321.779.0006  | E,H,I,M,O,Q               |
| Hilary            | Greenberg        | Greenberg Development Services                      | 3015 Clarendon Rd.        | Charlotte           | 1       | 28211.0 | 407.366.1541  | D,G,J                     |
| Thomas            | Guzman           |                                                     | 886 Polk Boulevard        | Des Moines          | IA      | 50312.0 | 515.724.3058  | A,C,K,O,Q                 |
| Ruth C.           | Hamberg, RLA     | Green Town Planning, Land Planning, Urban Design    | 1573 George Street        | 2                   | 0       | 32806.0 | 407.896.9656  | H,I,N,P,Q                 |
| Donna Ann         | Harris           | Heritage Consulting, Inc.                           | 422 South Camac Street    | Philadelphia        | 2       | 19147.0 | 267.251.5444  | A,B,C, K,Q                |
| Andrew M.         | Hayes, AIA       | Hayes Cumming Architects                            | 2210 Central Ave.         | 4                   | 0       | 33712.0 | 727.321.0900  | H,I,M,N,O,P               |
| Joan              | Jefferson        |                                                     | 2309 Hampshire Way        | 1                   | 0       | 32309.0 | 850.942.0286  | A,C,E,F,G,H,I, J,K,O,P, Q |
| Robert            | Jeffrey          |                                                     | 2302 1st. Avenue N        | 4                   | 0       | 33713.0 | 727.542.4780  | 0                         |
| Charlie           | Johnson          | Wood + Partners                                     | 612 South Copeland Street | 1                   | 0       | 32304.0 | 850.391.0371  | H,M,P                     |
| John M.           | Jones, AICP      | Littlejohn Engineering Associates                   | 1615 Edgewater Drive      | 2                   | 0       | 32804.0 | 407.975.1273  | D,G,H,I,J,L,M,N,P,Q       |
| Kathy             | La Plante        | 0                                                   | 408 Grandview Road        | Pembroke            | NH      | 3275.0  | 202.297.2893  | A,B,C,K,O                 |
| James G.          | LaRue, AICP      | LaRue Planning & Management Services                | 1375 Jackson St.          | Fort Myers          | 0       | 33901.0 | 239.334.3366  | N,P,Q                     |
| Rochelle W.       | Lawandales, AICP | Lawandales Planning Affiliates, Inc.                | 335 Sherwood Ave.         | Satelite Beach      | 0       | 32937.0 | 321.223.4664  | A,C,H,I,P,Q               |
| Teresa            | Lynch            |                                                     | 116 Old Hickory Lane      | Versialles          | KY      | 40383.0 | 859.873.0234  | A,C,G,K                   |
| Raul              | Ocampo, Jr., AIA | Ocampo & Associates                                 | 417 SW California Ave.    | Stuart              | 0       | 34994.0 | 772.286.9004  | A,E,H,I,M,O,P,Q           |
| Jeannette         | Peters           | Nonprofit Management Consulting                     | 5015 NW 4th Drive         | 0                   | 0       | 32605.0 | 352.371.7412  | A,B                       |
| David             | Quinn            | TMQ Consulting Services                             | 112 Ballantree Drive      | Asheville           | 1       | 28803.0 | 828.274.0716  | K,Q                       |
| Norma             | Ramirez de Miess | 0                                                   | 3457 Rock Hill View       | Schertz             | TX      | 78154.0 | 202.213.6720  | A,C,J,K                   |
| Ronald            | Rollins, RLA     | Miller Legg                                         | 5747 N. Andrews Way       | Fort Lauderdale     | 0       | 33309.0 | 954.436.7000  | I,M,N,P                   |
| Rick              | Segel            | Rick Segel & Associates                             | 268 Hamrick Drive         | Kissimmee           | 0       | 34759.0 | 781.272.9995  | E,F,J,K                   |
| Kennedy           | Smith            | Clue Group                                          | P.O. Box 2345             | Arlington           | VA      | 22202.0 | 202.657.5232  | D,G,H,J                   |
| Paula             | Stark            |                                                     | 109 Orange Ave.           | St.Cloud            | 0       | 34769.0 | 321.442.3191  | A,K                       |
| Linda D.          | Stevenson, AIA   | Stevenson Architects                                | 417 12th Street West      | Bradenton           | 0       | 34205.0 | 941.747.3696  | P,Q                       |
| Keith             | Tianen           | Downtown Solutions                                  | 11572 Riverbank Lane      | Pickney             | MI      | 48169.0 | 734.878.0161  | H,I,N,P                   |
| Doris             | Tillman          |                                                     | 18951 Okeechobee Road     | Fort Pierce         | 0       | 34945.0 | 772.216.2337  | C,G,K,O                   |
| Ronald J.         | Treharne, AIA    | Ark1Tek                                             | 446 Carmel Drive          | Melbourne           | 0       | 32840.0 | 321.698.57.39 | 0                         |
| Kim               | Walsh-Phillips   | IO Creative Group                                   | 14 West King Street       | York                | 2       | 17401.0 | 717.848.9339  | K,O                       |
| G. Brian          | Wheeler, RLA     | Genesis Group                                       | 9822 Tapestry Park Circle | 3                   | 0       | 32246.0 | 904.730.9360  | D,H,I,M,N,P               |
| Marjorie          | Ferrer           | Delray Beach Downtown Development                   | 85 SE 4th Ave.            | Delray Beach        | 0       | 33483.0 | 561.243.1077  |                           |
| Donovan           | Rypkema          | Place Economics                                     |                           |                     |         |         | 202.588.6258  |                           |

## Output:


source: excel_file
label: explode