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:
| mission_title   | Target                                      |
|:----------------|:--------------------------------------------|
| 1               | 98, 136, 204, 205, 212, 214, 332            |
| 10              | 183, 259, 314, 375                          |
| 11              | 204, 212, 268, 404                          |
| 12              | 208, 277, 305, 391                          |
| 13              | 232, 289, 333, 363, 396                     |
| 14              | 110, 299, 337, 409, 454                     |
| 15              | 210, 241, 426, 455, 460                     |
| 16              | 311, 311, 312, 376, 412, 422, 474           |
| 17              | 204, 320, 475, 476, 482                     |
| 18              | 99, 122, 328, 343, 405, 424, 435            |
| 19              | 208, 329, 384, 493                          |
| 2               | 100, 85, 123, 203, 208, 209, 262, 288, 308  |
| 20              | 277, 332, 333, 353, 427, 498, 502, 505      |
| 21              | 268, 345, 396, 506                          |
| 22              | 171, 215, 317, 354, 438, 455, 511           |
| 23              | 271, 299, 320, 356, 461, 513, 514           |
| 24              | 118, 208, 306, 349, 363, 375, 426, 466, 518 |
| 25              | 268, 312, 329, 393, 519                     |
| 26              | 277, 336, 384, 385, 467, 520                |
| 27              | 241, 300, 388, 480, 521, 522                |
| 28              | 268, 395, 444, 475, 523                     |
| 29              | 398, 524, 525                               |
| 3               | 91, 118, 206, 210, 211, 236, 328, 409       |
| 30              | 429, 436, 476                               |
| 31              | 384, 491, 526                               |
| 32              | 311, 454, 481                               |
| 33              | 503, 529, 530                               |
| 34              | 340, 498, 501                               |
| 35              | 363, 500, 531                               |
| 36              | 426, 479, 532                               |
| 37              | 455, 535, 536                               |
| 38              | 343, 397, 409                               |
| 39              | 458, 513, 537                               |
| 4               | 183, 212, 302, 303, 345                     |
| 40              | 506, 538, 539                               |
| 41              | 508, 521, 540                               |
| 42              | 512, 524, 541                               |
| 43              | 384, 393, 514                               |
| 44              | 476, 542, 543                               |
| 45              | 475                                         |
| 46              | 311, 502, 546                               |
| 47              | 396, 519, 547                               |
| 48              | 525, 548, 549                               |
| 49              | 489, 522, 551                               |
| 5               | 110, 204, 354, 422, 423                     |
| 50              | 422, 529, 552                               |
| 51              | 426, 553                                    |
| 52              | 467, 509, 535                               |
| 53              | 491, 531, 554                               |
| 54              | 524, 555, 556                               |
| 55              | 492, 497, 537                               |
| 56              | 539, 557, 558                               |
| 57              | 476, 547, 559, 560, 561                     |
| 59              | 547, 559, 562                               |
| 6               | 208, 229, 274, 329, 429                     |
| 60              | 513, 563, 564                               |
| 61              | 519                                         |
| 7               | 99, 232, 311, 362                           |
| 8               | 206, 241, 268, 271                          |
| 9               | 212, 251, 384, 435                          |
| ASTP            | 23, 76, 77                                  |
| Antares         | 278                                         |
| Apollo 10       | 17, 23, 26                                  |
| Apollo 11       | 24, 27, 29                                  |
| Apollo 12       | 20, 28, 44                                  |
| Apollo 13       | 22, 45, 46                                  |
| Apollo 14       | 48, 49, 50                                  |
| Apollo 15       | 25, 54, 55                                  |
| Apollo 16       | 17, 56, 57                                  |
| Apollo 17       | 26, 58, 59                                  |
| Apollo 7        | 7, 30, 31                                   |
| Apollo 8        | 21, 22, 33                                  |
| Apollo 9        | 18, 25                                      |
| Astro-1         | 239                                         |
| Astro-2         | 239                                         |
| Atlas-1         | 130                                         |
| EP-19           | 565                                         |
| Euromir 94      | 131                                         |
| Gemini 10       | 17, 27                                      |
| Gemini 11       | 20, 28                                      |
| Gemini 12       | 22, 29                                      |
| Gemini 3        | 16, 17                                      |
| Gemini 4        | 18, 19                                      |
| Gemini 5        | 8, 20                                       |
| Gemini 6A       | 7                                           |
| Gemini 7        | 21, 22                                      |
| Gemini 8        | 24, 25                                      |
| Gemini 9A       | 23, 26                                      |
| MA-6            | 3                                           |
| Mercury-Atlas 7 | 4                                           |
| Mercury-Atlas 8 | 7                                           |
| Mercury-Atlas 9 | 8                                           |
| Mir Aragatz     | 108                                         |
| Mir EO-15       | 308                                         |
| Mir EO-21       | 308                                         |
| STS 101         | 308                                         |
| STS 51-C        | 157                                         |
| STS 51-L        | 157                                         |
| STS-1           | 17, 102                                     |
| STS-100         | 323, 335, 340, 348, 392, 404                |

## Output:


source: notebook
label: explode