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:
| Company Name                                                 | Contact             | Email                             | Phone                | Address                            | City            | State        |   Country |       Zip | Booth(s)               |
|:-------------------------------------------------------------|:--------------------|:----------------------------------|:---------------------|:-----------------------------------|:----------------|:-------------|----------:|----------:|:-----------------------|
| Action Machining, Inc.                                       | Dee Zesiger         | dee@actionfilters.com             | 8012929299           | 610 West 2200 North                | West Bountiful  | 0            |         0 |     84087 | 715                    |
| Advanced Pump & Equipment, Inc.                              | Matt Huggins        | matt@advpump.com                  | 406-586-1700         | 1408 Gold Ave #6                   | Bozeman         | 1            |         0 |     59715 | 8                      |
| AE2S                                                         | Darrell Casteel     | Darrell.Casteel@ae2s.com          | 801-331-8489         | 3400 N Ashton Blvd                 | Lehi            | 0            |         0 |     84043 | 424, 426               |
| Allchem Performance Products                                 | Brian Bokowy        | horizon@allchem.com               | 3523337381           | 6010 NW First Place                | Gainesville     | FL           |         0 |     32607 | 523                    |
| Ambiente H2O Inc                                             | Art Oakes           | aoakes@ambienteh2o.com            | 801-532-4812         | 623 East 2100 South                | 0               | 2            |         0 |     84106 | 309                    |
| AmeriWest Water Services Inc.                                | LeRoy Palmer        | ameriWestWater@aol.com            | 208-861-3410         | 9701 W Whirlaway Dr                | Boise           | Idaho        |         0 |     83704 | 609                    |
| Aqua Engineering                                             | Aqua Engineering    | Bradr@aquaeng.com                 | 8012991327           | 0                                  | 1               | 2            |         0 |     84010 | 506                    |
| Aqua Environmental Services                                  | Larry Hall          | LarryH@aquaenviron.com            | 801 209-6382         | 0                                  | 1               | 2            |         0 |     84010 | 508                    |
| 0                                                            | 0                   | 0                                 | 0                    | 1                                  | 2               | 3            |         0 |      1843 | 418                    |
| 0                                                            | 0                   | 0                                 | 0                    | 1                                  | 2               | 3            |         0 |      1843 |                        |
| ATSCO Sales and Service                                      | Jack Douglass       | jack@atscosales.com               | 775-934-5504         | 2177 South 390 West                | Heber           | 0            |         0 |     84032 | GR 13                  |
| Av-Tek                                                       | Greg Bilbao         | greg@avtekvalves.com              | 8016378541           | 1310 Swaner Rd Suite B             | 0               | 2            |         0 |     84104 | 121                    |
| AY McDonald, Inc.                                            | Shawn Rigby         | srigby@aymcdonald.com             | 4357600703           | 195 W 3450 S                       | Nibley          | 2            |         0 |     84321 | 111                    |
| Backflow Training Services                                   | Greg Hand           | greg@backflowtrainingservices.com | 8015546052           | 2071 West Byron Circle             | 3               | 2            |         0 |     84119 | HS 4                   |
| BioLynceus Environmental Solutions                           | Becky Haugen        | Marketing@biolynceus.com          | 9705863391           | P O Box1499                        | Estes Park      | 4            |         0 |     80517 | 425                    |
| Blake Sales Company                                          | James Jones         | blakesalesco@comcast.net          | 801-231-5660         | 7065 Campus Dr.                    | 0               | 0            |         0 |     84121 | 607                    |
| Blue Stakes of Utah 811                                      | Spence Felsted      | spencef@bluestakes.org            | 801-259-7400         | 148 E 13200 S                      | 4               | 0            |         0 |     84020 | 226                    |
| Boart Longyear                                               | Jason Lamb          | jlamb@boartlongyear.com           | 8019714471           | 2455 South 3600 West               | West Valley     | 2            |         0 |     84119 | 15                     |
| 1                                                            | 1                   | 1                                 | 8014952224           | 2                                  | 4               | 0            |         0 |     84020 | 520                    |
| 1                                                            | 1                   | 1                                 | 8014952224           | 2                                  | 4               | 0            |         0 |     84020 |                        |
| Buckeye Detection Systems                                    | Chuck Hayden        | chayden@buckeyedetects.com        | 385-505-4354         | 110 Kings Road                     | Kings Mountain  | NC           |         0 |     28086 | 806                    |
| C&L Water Solutions, Inc.                                    | Maggie Schaffer     | Maggie.Schaffer@clwsi.com         | 303-791-2521         | 12249 Mead Way                     | Littleton       | 4            |         0 |     80125 | 423                    |
| Cate Equipment Company                                       | GREG RUTHER         | GRUTHER@CATEEQUIPMENT.COM         | 8016413575           | 2055 South Pioneer Road            | 5               | 2            |         0 |     84127 | 117                    |
| CH Spencer                                                   | Adam Reynolds       | areynolds@chspencer.com           | 801-975-0300 ext 121 | 1075 S Pioneer Rd.                 | 0               | 2            |         0 |     84104 | 3, 4                   |
| Chanshare Select                                             | Allison Smith       | allison.chanshare@gmail.com       | 801-940-0071         | PO Box 306                         | Tremonton       | 0            |         0 |     84337 | 815                    |
| Chemtech-Ford Laboratories                                   | Paul Ellingson      | pellingson@chemtechford.com       | 8012018166           | 9632 S 500 W                       | 6               | 2            |         0 |     84070 | 812                    |
| CIP CONSTRUCTION TECHNOLOGIES, INC.                          | Jim Swain           | supertec@rexforddsl.net           | 406-291-8017         | 134 1st Ave. W.                    | Kalispell       | 1            |         0 |     59901 | 808                    |
| Cla-Val                                                      | Jake Baum           | jbaum@cla-val.com                 | 435-749-4598         | 13N 500W                           | Salem           | Ut           |         0 |     84653 | 302, 401               |
| Clearwater Backflow Services                                 | Phil Fabry          | pfabry1716@msn.com                | 801 755 3441         | PO Box 697                         | 4               | 2            |         0 |     84020 | 505                    |
| 2                                                            | 2                   | 2                                 | 8016287970           | 3                                  | 7               | 0            |         0 |     84401 | 102, 201, 202, 301     |
| 2                                                            | 2                   | 2                                 | 8016287970           | 3                                  | 7               | 0            |         0 |     84401 |                        |
| Davidson Sales & Engineering                                 | Paul Mora           | paul_mora@dseslc.com              | 8016473221           | 2441 South 3850 West               | 3               | 0            |         0 |     84120 | GR 20                  |
| Dawson Infrastructure Solutions                              | Monty Hill          | monty@dawsonis.com                | 801-207-9728         | 11780 Fairplay St.                 | Brighton        | 4            |         0 |     80603 | 908                    |
| Delco Western                                                | Layne Read          | layne@delcowestern.com            | 8019720900           | 2559 S 1935 W                      | 0               | 2            |         0 |     84737 | 513, 515               |
| DEWCO                                                        | Scott Gales         | scott@dewco.com                   | 303-232-6861         | 1841 Wadsworth Blvd.               | 8               | 4            |         0 |     80214 | 905, 906               |
| DFW Plastics, Inc.                                           | Ryan McKinnon       | rmckinnon@dfwplasticsinc.com      | 8174751455           | PO BOX 648                         | Bedford         | 5            |         0 |     76095 | 501                    |
| Ditch Witch of the Rockies                                   | Troy Kynaston       | troyk@ditchwitchrockies.com       | 801 381-5404         | 4310 W California Ave              | 0               | 0            |         0 |     84104 | 714, 813               |
| Division of Drinking Water                                   | Tammie Allen        | tammieallen@utah.gov              | 801-536-4200         | 195 N 1950 W - 3rd Floor           | 0               | 2            |         0 |     84116 | HS 5, HS 6             |
| Division of Water Quality                                    | Judy Etherington    | jetherington@utah.gov             | 801-536-4344         | POB 144870                         | 0               | 2            |         0 |     84114 | HS 8                   |
| DN Tanks                                                     | Sean Sudol          | sean.sudol@dntanks.com            | (619) 820-5327       | 351 Cypress Lane                   | El Cajon        | 6            |         0 |     92020 | 507                    |
| Dorsett Technologies                                         | Todd Smith          | tsmith@dorsett-tech.com           | 8014303443           | 1485 West Hill Field Rd., Ste. 201 | 9               | 2            |         0 |     84041 | 314                    |
| EarthFax Engineering Group, LLC                              | Tim Jimenez         | tjimenez@earthfax.com             | 8015611555           | 7324 S UNION PARK AVE STE 100      | MIDVALE         | 0            |         0 | 840474160 | 913                    |
| EJ                                                           | Craig Anderson      | craig.anderson@ejco.com           | 801-698-3078         | PO Box 488                         | Tooele          | 0            |         0 |     84074 | 316, 318, 320          |
| 3                                                            | 3                   | 3                                 | 1                    | 4                                  | 10              | 2            |         0 |     84084 | 405                    |
| 3                                                            | 3                   | 3                                 | 1                    | 4                                  | 10              | 2            |         0 |     84084 |                        |
| 4                                                            | 4                   | 4                                 | 4355035294           | 5                                  | 11              | 2            |         0 |     84066 | 802                    |
| 4                                                            | 4                   | 4                                 | 4355035294           | 5                                  | 11              | 2            |         0 |     84066 |                        |
| EMPIRE WEST PIPE                                             | KEITH SORENSON      | info@empire-west.com              | 801-812-2818         | 1825 N MOUNTAIN SPRINGS PRKY       | SPRINGVILLE     | 2            |         0 |     84097 | 616                    |
| Energy Management                                            | Bruce Tregaskis     | btregaskis@emcsolutions.com       | 801-514-3663         | 501 W 700 S                        | SLC             | 2            |         0 |     84101 | 11, 12                 |
| ENSIGN ENGINEERING AND LAND SURVEYING                        | LINDA HANSEN        | lhansen@ensignutah.com            | 801.255.0529         | 45 W 10000 S                       | SANDY           | 7            |         0 |     84070 | HS 3                   |
| Enviro-Clean Intermountain, LLC                              | Steven Bruning      | sbruning@envirocleanequip.com     | 8018911431           | 2868 South 460 West                | South Salt Lake | 2            |         0 |     84115 | 807                    |
| Epic Engineering                                             | Don Olsen           | dolsen@epiceng.net                | 801-955-5605         | 3341 South 4000 West               | 3               | 2            |         0 |     84120 | 413, 415               |
| Ferguson Waterworks                                          | David Kent          | dave.kent@ferguson.com            | 435-703-7090         | 1087 East Commerce Drive           | St. George      | 2            |         0 |     84790 | 410, 509               |
| Filter Tech Systems                                          | Debra Jensen        | Deb@FilterTechSystems.com         | 970-254-2855         | 2844 Chipeta Avenue                | Grand Junction  | 4            |         0 |     81501 | 407                    |
| FlagShooter                                                  | Bob Bishop          | robertb@flagshooter.com           | 605-529-5000         | 47742 250th St.                    | Garretson       | South Dakota |         0 |     57030 | 707                    |
| Ford Meter Box                                               | Bennett Thurgood    | bthurgood@fordmeterbox.com        | 801-458-6124         | 1921 E Hampton RDG                 | 7               | 2            |         0 |     84403 | 303                    |
| Franson Civil Engineers Inc.                                 | Kevin Franson       | kfranson@fransoncivil.com         | (801) 756-0309       | 1276 S 820 E                       | 12              | 0            |         0 |     84003 | 16, 17                 |
| Freightliner of Utah                                         | Ken Barton          | ken.barton@warnertc.com           | 801-978-8024         | 2240 South 5370 West               | 0               | 0            |         0 |     84120 | 907                    |
| Frontier Precision                                           | Steve Combe         | scombe@frontierprecision.com      | 8017913407           | 4887 N 3000 E                      | Liberty         | 0            |         0 |     84310 | 805                    |
| G & S Sales                                                  | Bret Beesley        | bbeesley@gandssales.com           | 801-550-5545         | 1641 South 700 West                | 13              | 0            |         0 |     84104 | 709                    |
| Geneva Pipe & Precast                                        | Heather Christensen | hchristensen@genevapipe.com       | (385) 277-6232       | 1465 West 400 North                | 14              | 0            |         0 |     84057 | 519                    |
| Glatfelter Public Practice                                   | Karen Laeger        | KLaeger@Glatfelters.com           | 800-233-1957         | 6                                  | York            | PA           |         0 |     17405 | 403                    |
| Goble Sampson                                                | Mike Charnholm      | mcharnholm@goblesampson.com       | 801-268-8790         | 3500 S Main St                     | 0               | 0            |         0 |     84115 | 324, 326               |
| Harmsco Filtration Products                                  | Cyndi Benson        | cbenson@harmsco.com               | 5618489628           | 7169 49th Terrace N                | Riveriera Beach | 8            |         0 |     33408 | 204                    |
| High Country Fusion                                          | Todd Evans          | Todd.Evans@hcfusion.com           | 801-433-4815         | 2030 No Redwood Rd                 | 0               | 2            |         0 |     84116 | 323                    |
| Hoffman Utah Inc., dba Professional Pipe Services (Pro Pipe) | Parrish Topps       | parrish.topps@pro-pipe.com        | 801-908-8581         | 976 N Marshall Way Bldg 2 Unit 2   | 9               | 2            |         0 |     84041 | 402                    |
| 5                                                            | 5                   | 5                                 | 2                    | 7                                  | 0               | 0            |         0 |     84199 | 911, 912               |
| 5                                                            | 5                   | 5                                 | 2                    | 7                                  | 0               | 0            |         0 |     84199 |                        |
| Honeywell Smart Energy                                       | Sean Langton        | sean.langton@honeywell.com        | 503-250-4131         | 10 SW 49th Avenue                  | 15              | 8            |         0 |     34474 | 14                     |
| 6                                                            | 6                   | 6                                 | 3                    | 8                                  | 0               | 0            |         0 |     84104 | 702                    |
| 6                                                            | 6                   | 6                                 | 3                    | 8                                  | 0               | 0            |         0 |     84104 |                        |
| Horrocks Engineers, Inc.                                     | Mark Atencio        | marka@horrocks.com                | 801-763-5212         | 2162 West Grove Parkway            | 16              | 0            |         0 |     84062 | 606                    |
| Hose Solutions Inc.                                          | Carlos Guerra       | tradeshows@HoseSolutions.com      | 480-607-1507         | 9419 E. San Salvador Dr.           | Scottsdale      | 9            |         0 |     85258 | 203                    |
| Hydro Resources                                              | Joe Jankowski       | jjankowski@hydroresources.com     | 303-818-7703         | 13207 County Road 18, Unit C       | Fort Lupton     | 4            |         0 |     80621 | 504                    |
| Hydro Specialties Company                                    | Steven Hansen       | shansen@hydrospecialties.com      | 801-641-9130         | 14435 South Center Point Way       | Bluffdale       | 0            |         0 |     84065 | 502, 601               |
| ICORR Technologies                                           | Kent Carter         | kent@icorrtech.com                | 801-821-6199         | 810 Hardscrabble Road              | Morgan          | 2            |         0 |     84050 | 713                    |
| ICS, Blount                                                  | Al Rizo             | al.rizo@blount.com                | 971.347.9815         | 4909 SE International Way          | Portland        | OR           |         0 |     97222 | 705                    |
| Ident Solutions                                              | Brian Taylor        | btaylor@ident.solutions           | 801-655-3597         | 172 N East Promontory              | Farmington      | 0            |         0 |     84025 | 803                    |
| Inman Interwest                                              | Kevin Evans         | kevans@inmanwater.com             | 801-557-4959         | 3537 West 400 North                | 9               | 0            |         0 |     84041 | 404                    |
| Insituform Technologies, LLC                                 | Brad Conder         | bconder@aegion.com                | 801-472-8472         | 17988 Edison Avenue                | Chesterfield    | MO           |         0 |     63005 | 706                    |
| INTERMOUNTAIN BOBCAT                                         | LARRY TURNER        | lturner@imbobcat.com              | 801-209-2579         | P.O. BOX 27356                     | 5               | 7            |         0 |     84127 | 420                    |
| Intermountain Sales, Inc.                                    | Mike Cravens        | mike@intermtnsales.com            | 303-762-1070         | 3792 S Lipan Street                | Englewood       | Colorado     |         0 |     80110 | 419, 417               |
| Intermountain Traffic Safety                                 | Justin Knaras       | sales@it-safety.com               | 801-972-6515         | 2440 South 3270 West               | 0               | 2            |         0 |     84119 | 114                    |
| Isco Industries, LLC                                         | Bob Kilpack         | Bob.Kilpack@isco-pipe.com         | 801-209-9420         | 9541 South Bagley park Road        | 10              | 2            |         0 |     84088 | 109                    |
| isiWEST                                                      | Jeremy Jensen       | jjensen@isiwest.com               | 8017186518           | 135 Ranch Loop Road                | Preston         | ID           |         0 |     83263 | GR 5, GR 6, GR 7, GR 4 |
| Jones & DeMille Engineering, Inc.                            | Darin Robinson      | darin@jonesanddemille.com         | 435-896-8266         | 1535 South 100 West                | 17              | 7            |         0 |     84701 | 99, 100                |
| J-U-B Engineers, Inc.                                        | Gary Vance          | gvance@jub.com                    | 8015470393           | 466 N 900 W                        | Kaysville       | 2            |         0 |     84037 | 113, 115               |
| Kamstrup Water Metering                                      | Martin Casillas     | MCC@kamstrup.com                  | 480-225-7376         | 245 Hembree Park Drive             | Roswell         | Georgia      |         0 |     30076 | 817                    |
| Kasco Marine                                                 | Lucy Allen          | Lucy.a@kascomarine.com            | 715-262-2335         | 800 Deere Road                     | Prescott        | 10           |         0 |     54021 | 917                    |
| Krausz USA                                                   | Stan Pachorek       | stan.pachorek@krauszusa.com       | 352-789-9190         | 331 SW 57th Avenue                 | 15              | 8            |         0 |     34474 | 10                     |
| LaTech Equipment                                             | Scott Andersen      | scott@latechequipment.com         | 8015995264           | 1950 South 900 West S7             | 0               | 0            |         0 |     84104 | 104                    |
| Legacy Equipment                                             | Travis Vallejo      | travis.vallejo@legacyeq.com       | 8019750400           | 1220 South Legacy View Street      | 0               | 2            |         0 |     84104 | 904                    |
| Loughlin Water Associates, LLC                               | Bill Loughlin       | bill@loughlinwater.com            | 435-649-4005         | 3100 Pinebrook Rd                  | Park City       | 0            |         0 |     84098 | 205                    |
| 7                                                            | 7                   | 7                                 | 8016435891           | 9                                  | 18              | 11           |         0 |     76063 | 2                      |
| 7                                                            | 7                   | 7                                 | 8016435891           | 9                                  | 18              | 11           |         0 |     76063 |                        |
| McWane Ductile                                               | Aaron Loosli        | aaron.loosli@mcwaneductile.com    | 3852087352           | 1401 E 2000 S                      | Provo           | 2            |         0 |     84606 | 603                    |
| Medora Corp.- SolarBee/ GridBee                              | David Summerfield   | Dave.S@Medoraco.com               | 951-265-2321         | 3225 Highway 22                    | Dickinson       | ND           |         0 |     58601 | 814                    |
| MeterWorks                                                   | Ken Sheffield       | ken.sheffield@meterworks.net      | (801) 309-6612       | 1199 West 850 North                | Centerville     | 2            |         0 |     84014 | 900, 901, 225          |
| Metron-Farnier                                               | Mike Walley         | mikew@metronfarnier.com           | 303-449-8833         | 5665 Airport Blvd                  | Boulder         | 4            |         0 |     80301 | 124                    |
| Midco Diving & Marine Services, Inc                          | Robert Greenspan    | robert@midcodiving.com            | 605-791-3030         | PO Box 513                         | Rapid City      | SD           |         0 |     57709 | 119                    |

## Output:


source: excel_file
label: explode