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 | continent   | country                  |   gdpPercap_1952 |   gdpPercap_1957 |   gdpPercap_1962 |   gdpPercap_1967 |   gdpPercap_1972 |   gdpPercap_1977 |   gdpPercap_1982 |   gdpPercap_1987 |   gdpPercap_1992 |   gdpPercap_1997 |   gdpPercap_2002 |   gdpPercap_2007 |   lifeExp_1952 |   lifeExp_1957 |   lifeExp_1962 |   lifeExp_1967 |   lifeExp_1972 |   lifeExp_1977 |   lifeExp_1982 |   lifeExp_1987 |   lifeExp_1992 |   lifeExp_1997 |   lifeExp_2002 |   lifeExp_2007 |
|--------:|:------------|:-------------------------|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|-----------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|---------------:|
|       0 | Africa      | Algeria                  |         2449.01  |         3013.98  |         2550.82  |         3246.99  |         4182.66  |         4910.42  |         5745.16  |         5681.36  |         5023.22  |         4797.3   |         5288.04  |         6223.37  |         43.077 |         45.685 |        48.303  |        51.407  |        54.518  |        58.014  |         61.368 |         65.799 |         67.744 |         69.152 |         70.994 |         72.301 |
|       1 | Africa      | Angola                   |         3520.61  |         3827.94  |         4269.28  |         5522.78  |         5473.29  |         3008.65  |         2756.95  |         2430.21  |         2627.85  |         2277.14  |         2773.29  |         4797.23  |         30.015 |         31.999 |        34      |        35.985  |        37.928  |        39.483  |         39.942 |         39.906 |         40.647 |         40.963 |         41.003 |         42.731 |
|       2 | Africa      | Benin                    |         1062.75  |          959.601 |          949.499 |         1035.83  |         1085.8   |         1029.16  |         1277.9   |         1225.86  |         1191.21  |         1232.98  |         1372.88  |         1441.28  |         38.223 |         40.358 |        42.618  |        44.885  |        47.014  |        49.19   |         50.904 |         52.337 |         53.919 |         54.777 |         54.406 |         56.728 |
|       3 | Africa      | Botswana                 |          851.241 |          918.233 |          983.654 |         1214.71  |         2263.61  |         3214.86  |         4551.14  |         6205.88  |         7954.11  |         8647.14  |        11003.6   |        12569.9   |         47.622 |         49.618 |        51.52   |        53.298  |        56.024  |        59.319  |         61.484 |         63.622 |         62.745 |         52.556 |         46.634 |         50.728 |
|       4 | Africa      | Burkina Faso             |          543.255 |          617.183 |          722.512 |          794.827 |          854.736 |          743.387 |          807.199 |          912.063 |          931.753 |          946.295 |         1037.65  |         1217.03  |         31.975 |         34.906 |        37.814  |        40.697  |        43.591  |        46.137  |         48.122 |         49.557 |         50.26  |         50.324 |         50.65  |         52.295 |
|       5 | Africa      | Burundi                  |          339.296 |          379.565 |          355.203 |          412.978 |          464.1   |          556.103 |          559.603 |          621.819 |          631.7   |          463.115 |          446.404 |          430.071 |         39.031 |         40.533 |        42.045  |        43.548  |        44.057  |        45.91   |         47.471 |         48.211 |         44.736 |         45.326 |         47.36  |         49.58  |
|       6 | Africa      | Cameroon                 |         1172.67  |         1313.05  |         1399.61  |         1508.45  |         1684.15  |         1783.43  |         2367.98  |         2602.66  |         1793.16  |         1694.34  |         1934.01  |         2042.1   |         38.523 |         40.428 |        42.643  |        44.799  |        47.049  |        49.355  |         52.961 |         54.985 |         54.314 |         52.199 |         49.856 |         50.43  |
|       7 | Africa      | Central African Republic |         1071.31  |         1190.84  |         1193.07  |         1136.06  |         1070.01  |         1109.37  |          956.753 |          844.876 |          747.906 |          740.506 |          738.691 |          706.017 |         35.463 |         37.464 |        39.475  |        41.478  |        43.457  |        46.775  |         48.295 |         50.485 |         49.396 |         46.066 |         43.308 |         44.741 |
|       8 | Africa      | Chad                     |         1178.67  |         1308.5   |         1389.82  |         1196.81  |         1104.1   |         1133.98  |          797.908 |          952.386 |         1058.06  |         1004.96  |         1156.18  |         1704.06  |         38.092 |         39.881 |        41.716  |        43.601  |        45.569  |        47.383  |         49.517 |         51.051 |         51.724 |         51.573 |         50.525 |         50.651 |
|       9 | Africa      | Comoros                  |         1102.99  |         1211.15  |         1406.65  |         1876.03  |         1937.58  |         1172.6   |         1267.1   |         1315.98  |         1246.91  |         1173.62  |         1075.81  |          986.148 |         40.715 |         42.46  |        44.467  |        46.472  |        48.944  |        50.939  |         52.933 |         54.926 |         57.939 |         60.66  |         62.974 |         65.152 |
|      10 | Africa      | Congo Dem. Rep.          |          780.542 |          905.86  |          896.315 |          861.593 |          904.896 |          795.757 |          673.748 |          672.775 |          457.719 |          312.188 |          241.166 |          277.552 |         39.143 |         40.652 |        42.122  |        44.056  |        45.989  |        47.804  |         47.784 |         47.412 |         45.548 |         42.587 |         44.966 |         46.462 |
|      11 | Africa      | Congo Rep.               |         2125.62  |         2315.06  |         2464.78  |         2677.94  |         3213.15  |         3259.18  |         4879.51  |         4201.19  |         4016.24  |         3484.16  |         3484.06  |         3632.56  |         42.111 |         45.053 |        48.435  |        52.04   |        54.907  |        55.625  |         56.695 |         57.47  |         56.433 |         52.962 |         52.97  |         55.322 |
|      12 | Africa      | Cote d'Ivoire            |         1388.59  |         1500.9   |         1728.87  |         2052.05  |         2378.2   |         2517.74  |         2602.71  |         2156.96  |         1648.07  |         1786.27  |         1648.8   |         1544.75  |         40.477 |         42.469 |        44.93   |        47.35   |        49.801  |        52.374  |         53.983 |         54.655 |         52.044 |         47.991 |         46.832 |         48.328 |
|      13 | Africa      | Djibouti                 |         2669.53  |         2864.97  |         3020.99  |         3020.05  |         3694.21  |         3081.76  |         2879.47  |         2880.1   |         2377.16  |         1895.02  |         1908.26  |         2082.48  |         34.812 |         37.328 |        39.693  |        42.074  |        44.366  |        46.519  |         48.812 |         50.04  |         51.604 |         53.157 |         53.373 |         54.791 |
|      14 | Africa      | Egypt                    |         1418.82  |         1458.92  |         1693.34  |         1814.88  |         2024.01  |         2785.49  |         3503.73  |         3885.46  |         3794.76  |         4173.18  |         4754.6   |         5581.18  |         41.893 |         44.444 |        46.992  |        49.293  |        51.137  |        53.319  |         56.006 |         59.797 |         63.674 |         67.217 |         69.806 |         71.338 |
|      15 | Africa      | Equatorial Guinea        |          375.643 |          426.096 |          582.842 |          915.596 |          672.412 |          958.567 |          927.825 |          966.897 |         1132.06  |         2814.48  |         7703.5   |        12154.1   |         34.482 |         35.983 |        37.485  |        38.987  |        40.516  |        42.024  |         43.662 |         45.664 |         47.545 |         48.245 |         49.348 |         51.579 |
|      16 | Africa      | Eritrea                  |          328.941 |          344.162 |          380.996 |          468.795 |          514.324 |          505.754 |          524.876 |          521.134 |          582.859 |          913.471 |          765.35  |          641.37  |         35.928 |         38.047 |        40.158  |        42.189  |        44.142  |        44.535  |         43.89  |         46.453 |         49.991 |         53.378 |         55.24  |         58.04  |
|      17 | Africa      | Ethiopia                 |          362.146 |          378.904 |          419.456 |          516.119 |          566.244 |          556.808 |          577.861 |          573.741 |          421.353 |          515.889 |          530.054 |          690.806 |         34.078 |         36.667 |        40.059  |        42.115  |        43.515  |        44.51   |         44.916 |         46.684 |         48.091 |         49.402 |         50.725 |         52.947 |
|      18 | Africa      | Gabon                    |         4293.48  |         4976.2   |         6631.46  |         8358.76  |        11401.9   |        21745.6   |        15113.4   |        11864.4   |        13522.2   |        14722.8   |        12521.7   |        13206.5   |         37.003 |         38.999 |        40.489  |        44.598  |        48.69   |        52.79   |         56.564 |         60.19  |         61.366 |         60.461 |         56.761 |         56.735 |
|      19 | Africa      | Gambia                   |          485.231 |          520.927 |          599.65  |          734.783 |          756.087 |          884.755 |          835.81  |          611.659 |          665.624 |          653.73  |          660.586 |          752.75  |         30     |         32.065 |        33.896  |        35.857  |        38.308  |        41.842  |         45.58  |         49.265 |         52.644 |         55.861 |         58.041 |         59.448 |
|      20 | Africa      | Ghana                    |          911.299 |         1043.56  |         1190.04  |         1125.7   |         1178.22  |          993.224 |          876.033 |          847.006 |          925.06  |         1005.25  |         1111.98  |         1327.61  |         43.149 |         44.779 |        46.452  |        48.072  |        49.875  |        51.756  |         53.744 |         55.729 |         57.501 |         58.556 |         58.453 |         60.022 |
|      21 | Africa      | Guinea                   |          510.196 |          576.267 |          686.374 |          708.76  |          741.666 |          874.686 |          857.25  |          805.572 |          794.348 |          869.45  |          945.584 |          942.654 |         33.609 |         34.558 |        35.753  |        37.197  |        38.842  |        40.762  |         42.891 |         45.552 |         48.576 |         51.455 |         53.676 |         56.007 |
|      22 | Africa      | Guinea-Bissau            |          299.85  |          431.79  |          522.034 |          715.581 |          820.225 |          764.726 |          838.124 |          736.415 |          745.54  |          796.664 |          575.705 |          579.232 |         32.5   |         33.489 |        34.488  |        35.492  |        36.486  |        37.465  |         39.327 |         41.245 |         43.266 |         44.873 |         45.504 |         46.388 |
|      23 | Africa      | Kenya                    |          853.541 |          944.438 |          896.966 |         1056.74  |         1222.36  |         1267.61  |         1348.23  |         1361.94  |         1341.92  |         1360.49  |         1287.51  |         1463.25  |         42.27  |         44.686 |        47.949  |        50.654  |        53.559  |        56.155  |         58.766 |         59.339 |         59.285 |         54.407 |         50.992 |         54.11  |
|      24 | Africa      | Lesotho                  |          298.846 |          335.997 |          411.801 |          498.639 |          496.582 |          745.37  |          797.263 |          773.993 |          977.486 |         1186.15  |         1275.18  |         1569.33  |         42.138 |         45.047 |        47.747  |        48.492  |        49.767  |        52.208  |         55.078 |         57.18  |         59.685 |         55.558 |         44.593 |         42.592 |
|      25 | Africa      | Liberia                  |          575.573 |          620.97  |          634.195 |          713.604 |          803.005 |          640.322 |          572.2   |          506.114 |          636.623 |          609.174 |          531.482 |          414.507 |         38.48  |         39.486 |        40.502  |        41.536  |        42.614  |        43.764  |         44.852 |         46.027 |         40.802 |         42.221 |         43.753 |         45.678 |
|      26 | Africa      | Libya                    |         2387.55  |         3448.28  |         6757.03  |        18772.8   |        21011.5   |        21951.2   |        17364.3   |        11770.6   |         9640.14  |         9467.45  |         9534.68  |        12057.5   |         42.723 |         45.289 |        47.808  |        50.227  |        52.773  |        57.442  |         62.155 |         66.234 |         68.755 |         71.555 |         72.737 |         73.952 |
|      27 | Africa      | Madagascar               |         1443.01  |         1589.2   |         1643.39  |         1634.05  |         1748.56  |         1544.23  |         1302.88  |         1155.44  |         1040.68  |          986.296 |          894.637 |         1044.77  |         36.681 |         38.865 |        40.848  |        42.881  |        44.851  |        46.881  |         48.969 |         49.35  |         52.214 |         54.978 |         57.286 |         59.443 |
|      28 | Africa      | Malawi                   |          369.165 |          416.37  |          427.901 |          495.515 |          584.622 |          663.224 |          632.804 |          635.517 |          563.2   |          692.276 |          665.423 |          759.35  |         36.256 |         37.207 |        38.41   |        39.487  |        41.766  |        43.767  |         45.642 |         47.457 |         49.42  |         47.495 |         45.009 |         48.303 |
|      29 | Africa      | Mali                     |          452.337 |          490.382 |          496.174 |          545.01  |          581.369 |          686.395 |          618.014 |          684.172 |          739.014 |          790.258 |          951.41  |         1042.58  |         33.685 |         35.307 |        36.936  |        38.487  |        39.977  |        41.714  |         43.916 |         46.364 |         48.388 |         49.903 |         51.818 |         54.467 |
|      30 | Africa      | Mauritania               |          743.116 |          846.12  |         1055.9   |         1421.15  |         1586.85  |         1497.49  |         1481.15  |         1421.6   |         1361.37  |         1483.14  |         1579.02  |         1803.15  |         40.543 |         42.338 |        44.248  |        46.289  |        48.437  |        50.852  |         53.599 |         56.145 |         58.333 |         60.43  |         62.247 |         64.164 |
|      31 | Africa      | Mauritius                |         1967.96  |         2034.04  |         2529.07  |         2475.39  |         2575.48  |         3710.98  |         3688.04  |         4783.59  |         6058.25  |         7425.71  |         9021.82  |        10957     |         50.986 |         58.089 |        60.246  |        61.557  |        62.944  |        64.93   |         66.711 |         68.74  |         69.745 |         70.736 |         71.954 |         72.801 |
|      32 | Africa      | Morocco                  |         1688.2   |         1642     |         1566.35  |         1711.04  |         1930.19  |         2370.62  |         2702.62  |         2755.05  |         2948.05  |         2982.1   |         3258.5   |         3820.18  |         42.873 |         45.423 |        47.924  |        50.335  |        52.862  |        55.73   |         59.65  |         62.677 |         65.393 |         67.66  |         69.615 |         71.164 |
|      33 | Africa      | Mozambique               |          468.526 |          495.587 |          556.686 |          566.669 |          724.918 |          502.32  |          462.211 |          389.876 |          410.897 |          472.346 |          633.618 |          823.686 |         31.286 |         33.779 |        36.161  |        38.113  |        40.328  |        42.495  |         42.795 |         42.861 |         44.284 |         46.344 |         44.026 |         42.082 |
|      34 | Africa      | Namibia                  |         2423.78  |         2621.45  |         3173.22  |         3793.69  |         3746.08  |         3876.49  |         4191.1   |         3693.73  |         3804.54  |         3899.52  |         4072.32  |         4811.06  |         41.725 |         45.226 |        48.386  |        51.159  |        53.867  |        56.437  |         58.968 |         60.835 |         61.999 |         58.909 |         51.479 |         52.906 |
|      35 | Africa      | Niger                    |          761.879 |          835.523 |          997.766 |         1054.38  |          954.209 |          808.897 |          909.722 |          668.3   |          581.183 |          580.305 |          601.075 |          619.677 |         37.444 |         38.598 |        39.487  |        40.118  |        40.546  |        41.291  |         42.598 |         44.555 |         47.391 |         51.313 |         54.496 |         56.867 |
|      36 | Africa      | Nigeria                  |         1077.28  |         1100.59  |         1150.93  |         1014.51  |         1698.39  |         1981.95  |         1576.97  |         1385.03  |         1619.85  |         1624.94  |         1615.29  |         2013.98  |         36.324 |         37.802 |        39.36   |        41.04   |        42.821  |        44.514  |         45.826 |         46.886 |         47.472 |         47.464 |         46.608 |         46.859 |
|      37 | Africa      | Reunion                  |         2718.89  |         2769.45  |         3173.72  |         4021.18  |         5047.66  |         4319.8   |         5267.22  |         5303.38  |         6101.26  |         6071.94  |         6316.17  |         7670.12  |         52.724 |         55.09  |        57.666  |        60.542  |        64.274  |        67.064  |         69.885 |         71.913 |         73.615 |         74.772 |         75.744 |         76.442 |
|      38 | Africa      | Rwanda                   |          493.324 |          540.289 |          597.473 |          510.964 |          590.581 |          670.081 |          881.571 |          847.991 |          737.069 |          589.945 |          785.654 |          863.088 |         40     |         41.5   |        43      |        44.1    |        44.6    |        45      |         46.218 |         44.02  |         23.599 |         36.087 |         43.413 |         46.242 |
|      39 | Africa      | Sao Tome and Principe    |          879.584 |          860.737 |         1071.55  |         1384.84  |         1532.99  |         1737.56  |         1890.22  |         1516.53  |         1428.78  |         1339.08  |         1353.09  |         1598.44  |         46.471 |         48.945 |        51.893  |        54.425  |        56.48   |        58.55   |         60.351 |         61.728 |         62.742 |         63.306 |         64.337 |         65.528 |
|      40 | Africa      | Senegal                  |         1450.36  |         1567.65  |         1654.99  |         1612.4   |         1597.71  |         1561.77  |         1518.48  |         1441.72  |         1367.9   |         1392.37  |         1519.64  |         1712.47  |         37.278 |         39.329 |        41.454  |        43.563  |        45.815  |        48.879  |         52.379 |         55.769 |         58.196 |         60.187 |         61.6   |         63.062 |
|      41 | Africa      | Sierra Leone             |          879.788 |         1004.48  |         1116.64  |         1206.04  |         1353.76  |         1348.29  |         1465.01  |         1294.45  |         1068.7   |          574.648 |          699.49  |          862.541 |         30.331 |         31.57  |        32.767  |        34.113  |        35.4    |        36.788  |         38.445 |         40.006 |         38.333 |         39.897 |         41.012 |         42.568 |
|      42 | Africa      | Somalia                  |         1135.75  |         1258.15  |         1369.49  |         1284.73  |         1254.58  |         1450.99  |         1176.81  |         1093.24  |          926.96  |          930.596 |          882.082 |          926.141 |         32.978 |         34.977 |        36.981  |        38.977  |        40.973  |        41.974  |         42.955 |         44.501 |         39.658 |         43.795 |         45.936 |         48.159 |
|      43 | Africa      | South Africa             |         4725.3   |         5487.1   |         5768.73  |         7114.48  |         7765.96  |         8028.65  |         8568.27  |         7825.82  |         7225.07  |         7479.19  |         7710.95  |         9269.66  |         45.009 |         47.985 |        49.951  |        51.927  |        53.696  |        55.527  |         58.161 |         60.834 |         61.888 |         60.236 |         53.365 |         49.339 |
|      44 | Africa      | Sudan                    |         1615.99  |         1770.34  |         1959.59  |         1688     |         1659.65  |         2202.99  |         1895.54  |         1507.82  |         1492.2   |         1632.21  |         1993.4   |         2602.39  |         38.635 |         39.624 |        40.87   |        42.858  |        45.083  |        47.8    |         50.338 |         51.744 |         53.556 |         55.373 |         56.369 |         58.556 |
|      45 | Africa      | Swaziland                |         1148.38  |         1244.71  |         1856.18  |         2613.1   |         3364.84  |         3781.41  |         3895.38  |         3984.84  |         3553.02  |         3876.77  |         4128.12  |         4513.48  |         41.407 |         43.424 |        44.992  |        46.633  |        49.552  |        52.537  |         55.561 |         57.678 |         58.474 |         54.289 |         43.869 |         39.613 |
|      46 | Africa      | Tanzania                 |          716.65  |          698.536 |          722.004 |          848.219 |          915.985 |          962.492 |          874.243 |          831.822 |          825.682 |          789.186 |          899.074 |         1107.48  |         41.215 |         42.974 |        44.246  |        45.757  |        47.62   |        49.919  |         50.608 |         51.535 |         50.44  |         48.466 |         49.651 |         52.517 |
|      47 | Africa      | Togo                     |          859.809 |          925.908 |         1067.53  |         1477.6   |         1649.66  |         1532.78  |         1344.58  |         1202.2   |         1034.3   |          982.287 |          886.221 |          882.97  |         38.596 |         41.208 |        43.922  |        46.769  |        49.759  |        52.887  |         55.471 |         56.941 |         58.061 |         58.39  |         57.561 |         58.42  |
|      48 | Africa      | Tunisia                  |         1468.48  |         1395.23  |         1660.3   |         1932.36  |         2753.29  |         3120.88  |         3560.23  |         3810.42  |         4332.72  |         4876.8   |         5722.9   |         7092.92  |         44.6   |         47.1   |        49.579  |        52.053  |        55.602  |        59.837  |         64.048 |         66.894 |         70.001 |         71.973 |         73.042 |         73.923 |
|      49 | Africa      | Uganda                   |          734.753 |          774.371 |          767.272 |          908.919 |          950.736 |          843.733 |          682.266 |          617.724 |          644.171 |          816.559 |          927.721 |         1056.38  |         39.978 |         42.571 |        45.344  |        48.051  |        51.016  |        50.35   |         49.849 |         51.509 |         48.825 |         44.578 |         47.813 |         51.542 |
|      50 | Africa      | Zambia                   |         1147.39  |         1311.96  |         1452.73  |         1777.08  |         1773.5   |         1588.69  |         1408.68  |         1213.32  |         1210.88  |         1071.35  |         1071.61  |         1271.21  |         42.038 |         44.077 |        46.023  |        47.768  |        50.107  |        51.386  |         51.821 |         50.821 |         46.1   |         40.238 |         39.193 |         42.384 |
|      51 | Africa      | Zimbabwe                 |          406.884 |          518.764 |          527.272 |          569.795 |          799.362 |          685.588 |          788.855 |          706.157 |          693.421 |          792.45  |          672.039 |          469.709 |         48.451 |         50.469 |        52.358  |        53.995  |        55.635  |        57.674  |         60.363 |         62.351 |         60.377 |         46.809 |         39.989 |         43.487 |
|      52 | Americas    | Argentina                |         5911.32  |         6856.86  |         7133.17  |         8052.95  |         9443.04  |        10079     |         8997.9   |         9139.67  |         9308.42  |        10967.3   |         8797.64  |        12779.4   |         62.485 |         64.399 |        65.142  |        65.634  |        67.065  |        68.481  |         69.942 |         70.774 |         71.868 |         73.275 |         74.34  |         75.32  |
|      53 | Americas    | Bolivia                  |         2677.33  |         2127.69  |         2180.97  |         2586.89  |         2980.33  |         3548.1   |         3156.51  |         2753.69  |         2961.7   |         3326.14  |         3413.26  |         3822.14  |         40.414 |         41.89  |        43.428  |        45.032  |        46.714  |        50.023  |         53.859 |         57.251 |         59.957 |         62.05  |         63.883 |         65.554 |
|      54 | Americas    | Brazil                   |         2108.94  |         2487.37  |         3336.59  |         3429.86  |         4985.71  |         6660.12  |         7030.84  |         7807.1   |         6950.28  |         7957.98  |         8131.21  |         9065.8   |         50.917 |         53.285 |        55.665  |        57.632  |        59.504  |        61.489  |         63.336 |         65.205 |         67.057 |         69.388 |         71.006 |         72.39  |
|      55 | Americas    | Canada                   |        11367.2   |        12490     |        13462.5   |        16076.6   |        18970.6   |        22090.9   |        22898.8   |        26626.5   |        26342.9   |        28954.9   |        33329     |        36319.2   |         68.75  |         69.96  |        71.3    |        72.13   |        72.88   |        74.21   |         75.76  |         76.86  |         77.95  |         78.61  |         79.77  |         80.653 |
|      56 | Americas    | Chile                    |         3939.98  |         4315.62  |         4519.09  |         5106.65  |         5494.02  |         4756.76  |         5095.67  |         5547.06  |         7596.13  |        10118.1   |        10778.8   |        13171.6   |         54.745 |         56.074 |        57.924  |        60.523  |        63.441  |        67.052  |         70.565 |         72.492 |         74.126 |         75.816 |         77.86  |         78.553 |
|      57 | Americas    | Colombia                 |         2144.12  |         2323.81  |         2492.35  |         2678.73  |         3264.66  |         3815.81  |         4397.58  |         4903.22  |         5444.65  |         6117.36  |         5755.26  |         7006.58  |         50.643 |         55.118 |        57.863  |        59.963  |        61.623  |        63.837  |         66.653 |         67.768 |         68.421 |         70.313 |         71.682 |         72.889 |
|      58 | Americas    | Costa Rica               |         2627.01  |         2990.01  |         3460.94  |         4161.73  |         5118.15  |         5926.88  |         5262.73  |         5629.92  |         6160.42  |         6677.05  |         7723.45  |         9645.06  |         57.206 |         60.026 |        62.842  |        65.424  |        67.849  |        70.75   |         73.45  |         74.752 |         75.713 |         77.26  |         78.123 |         78.782 |
|      59 | Americas    | Cuba                     |         5586.54  |         6092.17  |         5180.76  |         5690.27  |         5305.45  |         6380.49  |         7316.92  |         7532.92  |         5592.84  |         5431.99  |         6340.65  |         8948.1   |         59.421 |         62.325 |        65.246  |        68.29   |        70.723  |        72.649  |         73.717 |         74.174 |         74.414 |         76.151 |         77.158 |         78.273 |
|      60 | Americas    | Dominican Republic       |         1397.72  |         1544.4   |         1662.14  |         1653.72  |         2189.87  |         2681.99  |         2861.09  |         2899.84  |         3044.21  |         3614.1   |         4563.81  |         6025.37  |         45.928 |         49.828 |        53.459  |        56.751  |        59.631  |        61.788  |         63.727 |         66.046 |         68.457 |         69.957 |         70.847 |         72.235 |
|      61 | Americas    | Ecuador                  |         3522.11  |         3780.55  |         4086.11  |         4579.07  |         5280.99  |         6679.62  |         7213.79  |         6481.78  |         7103.7   |         7429.46  |         5773.04  |         6873.26  |         48.357 |         51.356 |        54.64   |        56.678  |        58.796  |        61.31   |         64.342 |         67.231 |         69.613 |         72.312 |         74.173 |         74.994 |
|      62 | Americas    | El Salvador              |         3048.3   |         3421.52  |         3776.8   |         4358.6   |         4520.25  |         5138.92  |         4098.34  |         4140.44  |         4444.23  |         5154.83  |         5351.57  |         5728.35  |         45.262 |         48.57  |        52.307  |        55.855  |        58.207  |        56.696  |         56.604 |         63.154 |         66.798 |         69.535 |         70.734 |         71.878 |
|      63 | Americas    | Guatemala                |         2428.24  |         2617.16  |         2750.36  |         3242.53  |         4031.41  |         4879.99  |         4820.49  |         4246.49  |         4439.45  |         4684.31  |         4858.35  |         5186.05  |         42.023 |         44.142 |        46.954  |        50.016  |        53.738  |        56.029  |         58.137 |         60.782 |         63.373 |         66.322 |         68.978 |         70.259 |
|      64 | Americas    | Haiti                    |         1840.37  |         1726.89  |         1796.59  |         1452.06  |         1654.46  |         1874.3   |         2011.16  |         1823.02  |         1456.31  |         1341.73  |         1270.36  |         1201.64  |         37.579 |         40.696 |        43.59   |        46.243  |        48.042  |        49.923  |         51.461 |         53.636 |         55.089 |         56.671 |         58.137 |         60.916 |
|      65 | Americas    | Honduras                 |         2194.93  |         2220.49  |         2291.16  |         2538.27  |         2529.84  |         3203.21  |         3121.76  |         3023.1   |         3081.69  |         3160.45  |         3099.73  |         3548.33  |         41.912 |         44.665 |        48.041  |        50.924  |        53.884  |        57.402  |         60.909 |         64.492 |         66.399 |         67.659 |         68.565 |         70.198 |
|      66 | Americas    | Jamaica                  |         2898.53  |         4756.53  |         5246.11  |         6124.7   |         7433.89  |         6650.2   |         6068.05  |         6351.24  |         7404.92  |         7121.92  |         6994.77  |         7320.88  |         58.53  |         62.61  |        65.61   |        67.51   |        69      |        70.11   |         71.21  |         71.77  |         71.766 |         72.262 |         72.047 |         72.567 |
|      67 | Americas    | Mexico                   |         3478.13  |         4131.55  |         4581.61  |         5754.73  |         6809.41  |         7674.93  |         9611.15  |         8688.16  |         9472.38  |         9767.3   |        10742.4   |        11977.6   |         50.789 |         55.19  |        58.299  |        60.11   |        62.361  |        65.032  |         67.405 |         69.498 |         71.455 |         73.67  |         74.902 |         76.195 |
|      68 | Americas    | Nicaragua                |         3112.36  |         3457.42  |         3634.36  |         4643.39  |         4688.59  |         5486.37  |         3470.34  |         2955.98  |         2170.15  |         2253.02  |         2474.55  |         2749.32  |         42.314 |         45.432 |        48.632  |        51.884  |        55.151  |        57.47   |         59.298 |         62.008 |         65.843 |         68.426 |         70.836 |         72.899 |
|      69 | Americas    | Panama                   |         2480.38  |         2961.8   |         3536.54  |         4421.01  |         5364.25  |         5351.91  |         7009.6   |         7034.78  |         6618.74  |         7113.69  |         7356.03  |         9809.19  |         55.191 |         59.201 |        61.817  |        64.071  |        66.216  |        68.681  |         70.472 |         71.523 |         72.462 |         73.738 |         74.712 |         75.537 |
|      70 | Americas    | Paraguay                 |         1952.31  |         2046.15  |         2148.03  |         2299.38  |         2523.34  |         3248.37  |         4258.5   |         3998.88  |         4196.41  |         4247.4   |         3783.67  |         4172.84  |         62.649 |         63.196 |        64.361  |        64.951  |        65.815  |        66.353  |         66.874 |         67.378 |         68.225 |         69.4   |         70.755 |         71.752 |
|      71 | Americas    | Peru                     |         3758.52  |         4245.26  |         4957.04  |         5788.09  |         5937.83  |         6281.29  |         6434.5   |         6360.94  |         4446.38  |         5838.35  |         5909.02  |         7408.91  |         43.902 |         46.263 |        49.096  |        51.445  |        55.448  |        58.447  |         61.406 |         64.134 |         66.458 |         68.386 |         69.906 |         71.421 |
|      72 | Americas    | Puerto Rico              |         3081.96  |         3907.16  |         5108.34  |         6929.28  |         9123.04  |         9770.52  |        10331     |        12281.3   |        14641.6   |        16999.4   |        18855.6   |        19328.7   |         64.28  |         68.54  |        69.62   |        71.1    |        72.16   |        73.44   |         73.75  |         74.63  |         73.911 |         74.917 |         77.778 |         78.746 |
|      73 | Americas    | Trinidad and Tobago      |         3023.27  |         4100.39  |         4997.52  |         5621.37  |         6619.55  |         7899.55  |         9119.53  |         7388.6   |         7370.99  |         8792.57  |        11460.6   |        18008.5   |         59.1   |         61.8   |        64.9    |        65.4    |        65.9    |        68.3    |         68.832 |         69.582 |         69.862 |         69.465 |         68.976 |         69.819 |
|      74 | Americas    | United States            |        13990.5   |        14847.1   |        16173.1   |        19530.4   |        21806     |        24072.6   |        25009.6   |        29884.4   |        32003.9   |        35767.4   |        39097.1   |        42951.7   |         68.44  |         69.49  |        70.21   |        70.76   |        71.34   |        73.38   |         74.65  |         75.02  |         76.09  |         76.81  |         77.31  |         78.242 |
|      75 | Americas    | Uruguay                  |         5716.77  |         6150.77  |         5603.36  |         5444.62  |         5703.41  |         6504.34  |         6920.22  |         7452.4   |         8137     |         9230.24  |         7727     |        10611.5   |         66.071 |         67.044 |        68.253  |        68.468  |        68.673  |        69.481  |         70.805 |         71.918 |         72.752 |         74.223 |         75.307 |         76.384 |
|      76 | Americas    | Venezuela                |         7689.8   |         9802.47  |         8422.97  |         9541.47  |        10505.3   |        13144     |        11152.4   |         9883.58  |        10733.9   |        10165.5   |         8605.05  |        11415.8   |         55.088 |         57.907 |        60.77   |        63.479  |        65.712  |        67.456  |         68.557 |         70.19  |         71.15  |         72.146 |         72.766 |         73.747 |
|      77 | Asia        | Afghanistan              |          779.445 |          820.853 |          853.101 |          836.197 |          739.981 |          786.113 |          978.011 |          852.396 |          649.341 |          635.341 |          726.734 |          974.58  |         28.801 |         30.332 |        31.997  |        34.02   |        36.088  |        38.438  |         39.854 |         40.822 |         41.674 |         41.763 |         42.129 |         43.828 |
|      78 | Asia        | Bahrain                  |         9867.08  |        11635.8   |        12753.3   |        14804.7   |        18268.7   |        19340.1   |        19211.1   |        18524     |        19035.6   |        20292     |        23403.6   |        29796     |         50.939 |         53.832 |        56.923  |        59.923  |        63.3    |        65.593  |         69.052 |         70.75  |         72.601 |         73.925 |         74.795 |         75.635 |
|      79 | Asia        | Bangladesh               |          684.244 |          661.637 |          686.342 |          721.186 |          630.234 |          659.877 |          676.982 |          751.979 |          837.81  |          972.77  |         1136.39  |         1391.25  |         37.484 |         39.348 |        41.216  |        43.453  |        45.252  |        46.923  |         50.009 |         52.819 |         56.018 |         59.412 |         62.013 |         64.062 |
|      80 | Asia        | Cambodia                 |          368.469 |          434.038 |          496.914 |          523.432 |          421.624 |          524.972 |          624.475 |          683.896 |          682.303 |          734.285 |          896.226 |         1713.78  |         39.417 |         41.366 |        43.415  |        45.415  |        40.317  |        31.22   |         50.957 |         53.914 |         55.803 |         56.534 |         56.752 |         59.723 |
|      81 | Asia        | China                    |          400.449 |          575.987 |          487.674 |          612.706 |          676.9   |          741.237 |          962.421 |         1378.9   |         1655.78  |         2289.23  |         3119.28  |         4959.11  |         44     |         50.549 |        44.5014 |        58.3811 |        63.1189 |        63.9674 |         65.525 |         67.274 |         68.69  |         70.426 |         72.028 |         72.961 |
|      82 | Asia        | Hong Kong China          |         3054.42  |         3629.08  |         4692.65  |         6197.96  |         8315.93  |        11186.1   |        14560.5   |        20038.5   |        24757.6   |        28377.6   |        30209     |        39725     |         60.96  |         64.75  |        67.65   |        70      |        72      |        73.6    |         75.45  |         76.2   |         77.601 |         80     |         81.495 |         82.208 |
|      83 | Asia        | India                    |          546.566 |          590.062 |          658.347 |          700.771 |          724.033 |          813.337 |          855.724 |          976.513 |         1164.41  |         1458.82  |         1746.77  |         2452.21  |         37.373 |         40.249 |        43.605  |        47.193  |        50.651  |        54.208  |         56.596 |         58.553 |         60.223 |         61.765 |         62.879 |         64.698 |
|      84 | Asia        | Indonesia                |          749.682 |          858.9   |          849.29  |          762.432 |         1111.11  |         1382.7   |         1516.87  |         1748.36  |         2383.14  |         3119.34  |         2873.91  |         3540.65  |         37.468 |         39.918 |        42.518  |        45.964  |        49.203  |        52.702  |         56.159 |         60.137 |         62.681 |         66.041 |         68.588 |         70.65  |
|      85 | Asia        | Iran                     |         3035.33  |         3290.26  |         4187.33  |         5906.73  |         9613.82  |        11888.6   |         7608.33  |         6642.88  |         7235.65  |         8263.59  |         9240.76  |        11605.7   |         44.869 |         47.181 |        49.325  |        52.469  |        55.234  |        57.702  |         59.62  |         63.04  |         65.742 |         68.042 |         69.451 |         70.964 |
|      86 | Asia        | Iraq                     |         4129.77  |         6229.33  |         8341.74  |         8931.46  |         9576.04  |        14688.2   |        14517.9   |        11643.6   |         3745.64  |         3076.24  |         4390.72  |         4471.06  |         45.32  |         48.437 |        51.457  |        54.459  |        56.95   |        60.413  |         62.038 |         65.044 |         59.461 |         58.811 |         57.046 |         59.545 |
|      87 | Asia        | Israel                   |         4086.52  |         5385.28  |         7105.63  |         8393.74  |        12786.9   |        13306.6   |        15367     |        17122.5   |        18051.5   |        20896.6   |        21905.6   |        25523.3   |         65.39  |         67.84  |        69.39   |        70.75   |        71.63   |        73.06   |         74.45  |         75.6   |         76.93  |         78.269 |         79.696 |         80.745 |
|      88 | Asia        | Japan                    |         3216.96  |         4317.69  |         6576.65  |         9847.79  |        14778.8   |        16610.4   |        19384.1   |        22375.9   |        26824.9   |        28816.6   |        28604.6   |        31656.1   |         63.03  |         65.5   |        68.73   |        71.43   |        73.42   |        75.38   |         77.11  |         78.67  |         79.36  |         80.69  |         82     |         82.603 |
|      89 | Asia        | Jordan                   |         1546.91  |         1886.08  |         2348.01  |         2741.8   |         2110.86  |         2852.35  |         4161.42  |         4448.68  |         3431.59  |         3645.38  |         3844.92  |         4519.46  |         43.158 |         45.669 |        48.126  |        51.629  |        56.528  |        61.134  |         63.739 |         65.869 |         68.015 |         69.772 |         71.263 |         72.535 |
|      90 | Asia        | Korea Dem. Rep.          |         1088.28  |         1571.13  |         1621.69  |         2143.54  |         3701.62  |         4106.3   |         4106.53  |         4106.49  |         3726.06  |         1690.76  |         1646.76  |         1593.07  |         50.056 |         54.081 |        56.656  |        59.942  |        63.983  |        67.159  |         69.1   |         70.647 |         69.978 |         67.727 |         66.662 |         67.297 |
|      91 | Asia        | Korea Rep.               |         1030.59  |         1487.59  |         1536.34  |         2029.23  |         3030.88  |         4657.22  |         5622.94  |         8533.09  |        12104.3   |        15993.5   |        19234     |        23348.1   |         47.453 |         52.681 |        55.292  |        57.716  |        62.612  |        64.766  |         67.123 |         69.81  |         72.244 |         74.647 |         77.045 |         78.623 |
|      92 | Asia        | Kuwait                   |       108382     |       113523     |        95458.1   |        80894.9   |       109348     |        59265.5   |        31354     |        28118.4   |        34932.9   |        40300.6   |        35110.1   |        47307     |         55.565 |         58.033 |        60.47   |        64.624  |        67.712  |        69.343  |         71.309 |         74.174 |         75.19  |         76.156 |         76.904 |         77.588 |
|      93 | Asia        | Lebanon                  |         4834.8   |         6089.79  |         5714.56  |         6006.98  |         7486.38  |         8659.7   |         7640.52  |         5377.09  |         6890.81  |         8754.96  |         9313.94  |        10461.1   |         55.928 |         59.489 |        62.094  |        63.87   |        65.421  |        66.099  |         66.983 |         67.926 |         69.292 |         70.265 |         71.028 |         71.993 |
|      94 | Asia        | Malaysia                 |         1831.13  |         1810.07  |         2036.88  |         2277.74  |         2849.09  |         3827.92  |         4920.36  |         5249.8   |         7277.91  |        10132.9   |        10207     |        12451.7   |         48.463 |         52.102 |        55.737  |        59.371  |        63.01   |        65.256  |         68     |         69.5   |         70.693 |         71.938 |         73.044 |         74.241 |
|      95 | Asia        | Mongolia                 |          786.567 |          912.663 |         1056.35  |         1226.04  |         1421.74  |         1647.51  |         2000.6   |         2338.01  |         1785.4   |         1902.25  |         2140.74  |         3095.77  |         42.244 |         45.248 |        48.251  |        51.253  |        53.754  |        55.491  |         57.489 |         60.222 |         61.271 |         63.625 |         65.033 |         66.803 |
|      96 | Asia        | Myanmar                  |          331     |          350     |          388     |          349     |          357     |          371     |          424     |          385     |          347     |          415     |          611     |          944     |         36.319 |         41.905 |        45.108  |        49.379  |        53.07   |        56.059  |         58.056 |         58.339 |         59.32  |         60.328 |         59.908 |         62.069 |
|      97 | Asia        | Nepal                    |          545.866 |          597.936 |          652.397 |          676.442 |          674.788 |          694.112 |          718.373 |          775.632 |          897.74  |         1010.89  |         1057.21  |         1091.36  |         36.157 |         37.686 |        39.393  |        41.472  |        43.971  |        46.748  |         49.594 |         52.537 |         55.727 |         59.426 |         61.34  |         63.785 |
|      98 | Asia        | Oman                     |         1828.23  |         2242.75  |         2924.64  |         4720.94  |        10618     |        11848.3   |        12954.8   |        18115.2   |        18616.7   |        19702.1   |        19774.8   |        22316.2   |         37.578 |         40.08  |        43.165  |        46.988  |        52.143  |        57.367  |         62.728 |         67.734 |         71.197 |         72.499 |         74.193 |         75.64  |
|      99 | Asia        | Pakistan                 |          684.597 |          747.084 |          803.343 |          942.408 |         1049.94  |         1175.92  |         1443.43  |         1704.69  |         1971.83  |         2049.35  |         2092.71  |         2605.95  |         43.436 |         45.557 |        47.67   |        49.8    |        51.929  |        54.043  |         56.158 |         58.245 |         60.838 |         61.818 |         63.61  |         65.483 |

## Output:


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