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:
|   index | Date       |   Day | Cases_Guinea   | Cases_Liberia   | Cases_SierraLeone   | Cases_Nigeria   | Cases_Senegal   | Cases_UnitedStates   | Cases_Spain   | Cases_Mali   | Deaths_Guinea   | Deaths_Liberia   | Deaths_SierraLeone   | Deaths_Nigeria   | Deaths_Senegal   | Deaths_UnitedStates   | Deaths_Spain   | Deaths_Mali   |
|--------:|:-----------|------:|:---------------|:----------------|:--------------------|:----------------|:----------------|:---------------------|:--------------|:-------------|:----------------|:-----------------|:---------------------|:-----------------|:-----------------|:----------------------|:---------------|:--------------|
|       0 | 1/5/2015   |   289 | 2776.0         |                 | 10030.0             |                 |                 |                      |               |              | 1786.0          |                  | 2977.0               |                  |                  |                       |                |               |
|       1 | 1/4/2015   |   288 | 2775.0         |                 | 9780.0              |                 |                 |                      |               |              | 1781.0          |                  | 2943.0               |                  |                  |                       |                |               |
|       2 | 1/3/2015   |   287 | 2769.0         | 8166.0          | 9722.0              |                 |                 |                      |               |              | 1767.0          | 3496.0           | 2915.0               |                  |                  |                       |                |               |
|       3 | 1/2/2015   |   286 |                | 8157.0          |                     |                 |                 |                      |               |              |                 | 3496.0           |                      |                  |                  |                       |                |               |
|       4 | 12/31/2014 |   284 | 2730.0         | 8115.0          | 9633.0              |                 |                 |                      |               |              | 1739.0          | 3471.0           | 2827.0               |                  |                  |                       |                |               |
|       5 | 12/28/2014 |   281 | 2706.0         | 8018.0          | 9446.0              |                 |                 |                      |               |              | 1708.0          | 3423.0           | 2758.0               |                  |                  |                       |                |               |
|       6 | 12/27/2014 |   280 | 2695.0         |                 | 9409.0              |                 |                 |                      |               |              | 1697.0          |                  | 2732.0               |                  |                  |                       |                |               |
|       7 | 12/24/2014 |   277 | 2630.0         | 7977.0          | 9203.0              |                 |                 |                      |               |              |                 | 3413.0           | 2655.0               |                  |                  |                       |                |               |
|       8 | 12/21/2014 |   273 | 2597.0         |                 | 9004.0              |                 |                 |                      |               |              | 1607.0          |                  | 2582.0               |                  |                  |                       |                |               |
|       9 | 12/20/2014 |   272 | 2571.0         | 7862.0          | 8939.0              |                 |                 |                      |               |              | 1586.0          | 3384.0           | 2556.0               |                  |                  |                       |                |               |
|      10 | 12/18/2014 |   271 |                | 7830.0          |                     |                 |                 |                      |               |              |                 | 3376.0           |                      |                  |                  |                       |                |               |
|      11 | 12/14/2014 |   267 | 2416.0         |                 | 8356.0              |                 |                 |                      |               |              | 1525.0          |                  | 2085.0               |                  |                  |                       |                |               |
|      12 | 12/9/2014  |   262 |                | 7797.0          |                     |                 |                 |                      |               |              |                 | 3290.0           |                      |                  |                  |                       |                |               |
|      13 | 12/7/2014  |   260 | 2292.0         |                 | 7897.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 7.0          | 1428.0          |                  | 1768.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 6.0           |
|      14 | 12/3/2014  |   256 |                | 7719.0          |                     |                 |                 |                      |               |              |                 | 3177.0           |                      |                  |                  |                       |                |               |
|      15 | 11/30/2014 |   253 | 2164.0         |                 | 7312.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 7.0          | 1327.0          |                  | 1583.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 6.0           |
|      16 | 11/28/2014 |   251 |                | 7635.0          |                     |                 |                 |                      |               |              |                 | 3145.0           |                      |                  |                  |                       |                |               |
|      17 | 11/23/2014 |   246 | 2134.0         |                 | 6599.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 7.0          | 1260.0          |                  | 1398.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 6.0           |
|      18 | 11/22/2014 |   245 |                | 7168.0          |                     |                 |                 |                      |               |              |                 | 3016.0           |                      |                  |                  |                       |                |               |
|      19 | 11/18/2014 |   241 | 2047.0         | 7082.0          | 6190.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 6.0          | 1214.0          | 2963.0           | 1267.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 6.0           |
|      20 | 11/16/2014 |   239 | 1971.0         |                 | 6073.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 5.0          | 1192.0          |                  | 1250.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 5.0           |
|      21 | 11/15/2014 |   238 |                | 7069.0          |                     |                 |                 |                      |               |              |                 | 2964.0           |                      |                  |                  |                       |                |               |
|      22 | 11/11/2014 |   234 | 1919.0         |                 | 5586.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 4.0          | 1166.0          |                  | 1187.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 3.0           |
|      23 | 11/10/2014 |   233 |                | 6878.0          |                     |                 |                 |                      |               |              |                 | 2812.0           |                      |                  |                  |                       |                |               |
|      24 | 11/9/2014  |   232 | 1878.0         |                 | 5368.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 1.0          | 1142.0          |                  | 1169.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 1.0           |
|      25 | 11/8/2014  |   231 |                | 6822.0          |                     |                 |                 |                      |               |              |                 | 2836.0           |                      |                  |                  |                       |                |               |
|      26 | 11/4/2014  |   227 |                | 6619.0          | 4862.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 1.0          |                 | 2766.0           | 1130.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 1.0           |
|      27 | 11/3/2014  |   226 | 1760.0         |                 |                     |                 |                 |                      |               |              | 1054.0          |                  |                      |                  |                  |                       |                |               |
|      28 | 11/2/2014  |   225 | 1731.0         |                 | 4759.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 1.0          | 1041.0          |                  | 1070.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 1.0           |
|      29 | 10/31/2014 |   222 |                | 6525.0          |                     |                 |                 |                      |               |              |                 | 2697.0           |                      |                  |                  |                       |                |               |
|      30 | 10/29/2014 |   220 | 1667.0         |                 | 5338.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 1.0          | 1018.0          |                  | 1510.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 1.0           |
|      31 | 10/27/2014 |   218 | 1906.0         |                 | 5235.0              | 20.0            | 1.0             | 4.0                  | 1.0           | 1.0          | 997.0           |                  | 1500.0               | 8.0              | 0.0              | 1.0                   | 0.0            | 1.0           |
|      32 | 10/25/2014 |   216 |                | 6535.0          |                     |                 |                 |                      |               |              |                 | 2413.0           |                      |                  |                  |                       |                |               |
|      33 | 10/22/2014 |   214 |                |                 | 3896.0              |                 |                 | 4.0                  | 1.0           | 1.0          |                 |                  | 1281.0               |                  |                  | 1.0                   | 0.0            | 1.0           |
|      34 | 10/21/2014 |   213 | 1553.0         |                 |                     |                 |                 |                      |               |              | 926.0           |                  |                      |                  |                  |                       |                |               |
|      35 | 10/19/2014 |   211 | 1540.0         |                 | 3706.0              | 20.0            | 1.0             | 3.0                  | 1.0           |              | 904.0           |                  | 1259.0               | 8.0              | 0.0              | 1.0                   | 0.0            |               |
|      36 | 10/18/2014 |   210 |                | 4665.0          |                     |                 |                 |                      |               |              |                 | 2705.0           |                      |                  |                  |                       |                |               |
|      37 | 10/14/2014 |   206 | 1519.0         |                 | 3410.0              | 20.0            | 1.0             | 3.0                  | 1.0           |              | 862.0           |                  | 1200.0               | 8.0              | 0.0              | 0.0                   | 1.0            |               |
|      38 | 10/13/2014 |   205 |                | 4262.0          |                     |                 |                 |                      |               |              |                 | 2484.0           |                      |                  |                  |                       |                |               |
|      39 | 10/12/2014 |   204 | 1472.0         |                 | 3252.0              | 20.0            | 1.0             | 2.0                  | 1.0           |              | 843.0           |                  | 1183.0               | 8.0              | 0.0              | 1.0                   | 1.0            |               |
|      40 | 10/11/2014 |   203 |                | 4249.0          |                     |                 |                 |                      |               |              |                 | 2458.0           |                      |                  |                  |                       |                |               |
|      41 | 10/8/2014  |   200 |                |                 | 2950.0              | 20.0            | 1.0             | 1.0                  | 1.0           |              |                 |                  | 930.0                | 8.0              | 0.0              | 1.0                   | 1.0            |               |
|      42 | 10/7/2014  |   199 | 1350.0         | 4076.0          |                     |                 |                 |                      |               |              | 778.0           | 2316.0           |                      |                  |                  |                       |                |               |
|      43 | 10/5/2014  |   197 | 1298.0         |                 | 2789.0              | 20.0            | 1.0             | 1.0                  |               |              | 768.0           |                  | 879.0                | 8.0              | 0.0              | 0.0                   |                |               |
|      44 | 10/4/2014  |   196 |                | 3924.0          |                     |                 |                 |                      |               |              |                 | 2210.0           |                      |                  |                  |                       |                |               |
|      45 | 10/1/2014  |   193 | 1199.0         | 3834.0          | 2437.0              | 20.0            | 1.0             | 1.0                  |               |              | 739.0           | 2069.0           | 623.0                | 8.0              | 0.0              | 0.0                   |                |               |
|      46 | 9/28/2014  |   190 | 1157.0         | 3696.0          | 2304.0              | 20.0            | 1.0             |                      |               |              | 710.0           | 1998.0           | 622.0                | 8.0              | 0.0              |                       |                |               |
|      47 | 9/23/2014  |   185 | 1074.0         | 3458.0          | 2021.0              | 20.0            | 1.0             |                      |               |              | 648.0           | 1830.0           | 605.0                | 8.0              | 0.0              |                       |                |               |
|      48 | 9/21/2014  |   183 | 1022.0         | 3280.0          | 1940.0              | 20.0            | 1.0             |                      |               |              | 635.0           | 1677.0           | 597.0                | 8.0              | 0.0              |                       |                |               |
|      49 | 9/20/2014  |   182 |                |                 | 1813.0              |                 |                 |                      |               |              |                 |                  | 593.0                |                  |                  |                       |                |               |
|      50 | 9/19/2014  |   181 | 1008.0         |                 |                     |                 |                 |                      |               |              | 632.0           |                  |                      |                  |                  |                       |                |               |
|      51 | 9/17/2014  |   179 |                | 3022.0          |                     |                 |                 |                      |               |              |                 | 1578.0           |                      |                  |                  |                       |                |               |
|      52 | 9/14/2014  |   176 | 942.0          | 2710.0          | 1673.0              |                 |                 |                      |               |              | 601.0           | 1459.0           | 562.0                |                  |                  |                       |                |               |
|      53 | 9/13/2014  |   175 | 936.0          |                 | 1620.0              | 21.0            | 1.0             |                      |               |              | 595.0           | 1296.0           | 562.0                | 8.0              | 0.0              |                       |                |               |
|      54 | 9/10/2014  |   172 | 899.0          |                 | 1478.0              | 21.0            | 1.0             |                      |               |              | 568.0           |                  | 536.0                | 8.0              |                  |                       |                |               |
|      55 | 9/9/2014   |   171 |                | 2407.0          |                     |                 |                 |                      |               |              |                 |                  |                      |                  |                  |                       |                |               |
|      56 | 9/7/2014   |   169 | 861.0          | 2081.0          | 1424.0              | 21.0            | 3.0             |                      |               |              | 557.0           | 1137.0           | 524.0                | 8.0              | 0.0              |                       |                |               |
|      57 | 9/5/2014   |   167 | 812.0          | 1871.0          | 1261.0              | 22.0            | 1.0             |                      |               |              | 517.0           | 1089.0           | 491.0                | 8.0              |                  |                       |                |               |
|      58 | 8/31/2014  |   162 | 771.0          | 1698.0          | 1216.0              | 21.0            | 1.0             |                      |               |              | 494.0           | 871.0            | 476.0                | 7.0              |                  |                       |                |               |
|      59 | 8/26/2014  |   157 | 648.0          | 1378.0          | 1026.0              | 17.0            |                 |                      |               |              | 430.0           | 694.0            | 422.0                | 6.0              |                  |                       |                |               |
|      60 | 8/20/2014  |   151 | 607.0          | 1082.0          | 910.0               | 16.0            |                 |                      |               |              | 406.0           | 624.0            | 392.0                | 5.0              |                  |                       |                |               |
|      61 | 8/18/2014  |   149 | 579.0          | 972.0           | 907.0               | 15.0            |                 |                      |               |              | 396.0           | 576.0            | 374.0                | 4.0              |                  |                       |                |               |
|      62 | 8/16/2014  |   147 | 543.0          | 834.0           | 848.0               | 15.0            |                 |                      |               |              | 394.0           | 466.0            | 365.0                | 4.0              |                  |                       |                |               |
|      63 | 8/13/2014  |   144 | 519.0          | 786.0           | 810.0               | 12.0            |                 |                      |               |              | 380.0           | 413.0            | 348.0                | 4.0              |                  |                       |                |               |
|      64 | 8/11/2014  |   142 | 510.0          | 670.0           | 783.0               | 12.0            |                 |                      |               |              | 377.0           | 355.0            | 334.0                | 3.0              |                  |                       |                |               |
|      65 | 8/9/2014   |   140 | 506.0          | 599.0           | 730.0               | 13.0            |                 |                      |               |              | 373.0           | 323.0            | 315.0                | 2.0              |                  |                       |                |               |
|      66 | 8/6/2014   |   137 | 495.0          | 554.0           | 717.0               | 13.0            |                 |                      |               |              | 367.0           | 294.0            | 298.0                | 2.0              |                  |                       |                |               |
|      67 | 8/4/2014   |   135 | 495.0          | 516.0           | 691.0               | 9.0             |                 |                      |               |              | 363.0           | 282.0            | 286.0                | 1.0              |                  |                       |                |               |
|      68 | 8/1/2014   |   132 | 485.0          | 468.0           | 646.0               | 4.0             |                 |                      |               |              | 358.0           | 255.0            | 273.0                | 1.0              |                  |                       |                |               |
|      69 | 7/30/2014  |   129 | 472.0          | 391.0           | 574.0               | 3.0             |                 |                      |               |              | 346.0           | 227.0            | 252.0                | 1.0              |                  |                       |                |               |
|      70 | 7/27/2014  |   126 | 460.0          | 329.0           | 533.0               | 1.0             |                 |                      |               |              | 339.0           | 156.0            | 233.0                | 1.0              |                  |                       |                |               |
|      71 | 7/23/2014  |   123 | 427.0          | 249.0           | 525.0               | 0.0             |                 |                      |               |              | 319.0           | 129.0            | 224.0                | 0.0              |                  |                       |                |               |
|      72 | 7/20/2014  |   120 | 415.0          | 224.0           | 454.0               |                 |                 |                      |               |              | 314.0           | 127.0            | 219.0                |                  |                  |                       |                |               |
|      73 | 7/17/2014  |   117 | 410.0          | 196.0           | 442.0               |                 |                 |                      |               |              | 310.0           | 116.0            | 206.0                |                  |                  |                       |                |               |
|      74 | 7/14/2014  |   114 | 411.0          | 174.0           | 397.0               |                 |                 |                      |               |              | 310.0           | 106.0            | 197.0                |                  |                  |                       |                |               |
|      75 | 7/12/2014  |   112 | 406.0          | 172.0           | 386.0               |                 |                 |                      |               |              | 304.0           | 105.0            | 194.0                |                  |                  |                       |                |               |
|      76 | 7/8/2014   |   108 | 409.0          | 142.0           | 337.0               |                 |                 |                      |               |              | 309.0           | 88.0             | 142.0                |                  |                  |                       |                |               |
|      77 | 7/6/2014   |   106 | 408.0          | 131.0           | 305.0               |                 |                 |                      |               |              | 307.0           | 84.0             | 127.0                |                  |                  |                       |                |               |
|      78 | 7/2/2014   |   102 | 412.0          | 115.0           | 252.0               |                 |                 |                      |               |              | 305.0           | 75.0             | 101.0                |                  |                  |                       |                |               |
|      79 | 6/30/2014  |   100 | 413.0          | 107.0           | 239.0               |                 |                 |                      |               |              | 303.0           | 65.0             | 99.0                 |                  |                  |                       |                |               |
|      80 | 6/22/2014  |    92 |                | 51.0            |                     |                 |                 |                      |               |              |                 | 34.0             |                      |                  |                  |                       |                |               |
|      81 | 6/20/2014  |    90 | 390.0          |                 | 158.0               |                 |                 |                      |               |              | 270.0           |                  | 34.0                 |                  |                  |                       |                |               |
|      82 | 6/19/2014  |    89 |                | 41.0            |                     |                 |                 |                      |               |              |                 | 25.0             |                      |                  |                  |                       |                |               |
|      83 | 6/18/2014  |    88 | 390.0          |                 | 136.0               |                 |                 |                      |               |              | 267.0           |                  | 28.0                 |                  |                  |                       |                |               |
|      84 | 6/17/2014  |    87 |                |                 | 97.0                |                 |                 |                      |               |              |                 |                  | 49.0                 |                  |                  |                       |                |               |
|      85 | 6/16/2014  |    86 | 398.0          | 33.0            |                     |                 |                 |                      |               |              | 264.0           | 24.0             |                      |                  |                  |                       |                |               |
|      86 | 6/10/2014  |    80 | 351.0          | 13.0            | 89.0                |                 |                 |                      |               |              | 226.0           | 24.0             | 7.0                  |                  |                  |                       |                |               |
|      87 | 6/5/2014   |    75 |                | 13.0            | 81.0                |                 |                 |                      |               |              |                 |                  | 6.0                  |                  |                  |                       |                |               |
|      88 | 6/3/2014   |    73 | 344.0          | 13.0            |                     |                 |                 |                      |               |              | 215.0           | 12.0             | 6.0                  |                  |                  |                       |                |               |
|      89 | 6/1/2014   |    71 | 328.0          | 13.0            | 79.0                |                 |                 |                      |               |              | 208.0           | 12.0             | 6.0                  |                  |                  |                       |                |               |
|      90 | 5/28/2014  |    67 | 291.0          | 13.0            | 50.0                |                 |                 |                      |               |              | 193.0           | 12.0             | 6.0                  |                  |                  |                       |                |               |
|      91 | 5/27/2014  |    66 | 281.0          | 12.0            | 16.0                |                 |                 |                      |               |              | 186.0           | 11.0             | 5.0                  |                  |                  |                       |                |               |
|      92 | 5/23/2014  |    62 | 258.0          | 12.0            | 0.0                 |                 |                 |                      |               |              | 174.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      93 | 5/12/2014  |    51 | 248.0          | 12.0            | 0.0                 |                 |                 |                      |               |              | 171.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      94 | 5/10/2014  |    49 | 233.0          | 12.0            | 0.0                 |                 |                 |                      |               |              | 157.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      95 | 5/7/2014   |    46 | 236.0          | 13.0            | 0.0                 |                 |                 |                      |               |              | 158.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      96 | 5/5/2014   |    44 | 235.0          | 13.0            | 0.0                 |                 |                 |                      |               |              | 157.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      97 | 5/3/2014   |    42 | 231.0          | 13.0            | 0.0                 |                 |                 |                      |               |              | 155.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      98 | 5/1/2014   |    40 | 226.0          | 13.0            | 0.0                 |                 |                 |                      |               |              | 149.0           | 11.0             | 0.0                  |                  |                  |                       |                |               |
|      99 | 4/26/2014  |    35 | 224.0          |                 | 0.0                 |                 |                 |                      |               |              | 143.0           |                  | 0.0                  |                  |                  |                       |                |               |

## Output:


source: notebook
label: operator: wide_to_long
wide_to_long_start_idx: 3
wide_to_long_end_idx: 18