Steps Library
Melt Dataset

Melt (Wide to Long)

If you work with data you probably have come to the scenario where you have found the data you need but not in the shape that you need. A typical example is when data that should be row values are columns or otherwise, a situation that can not be solved by simply transposing the data. "Wide to Long" and "Long to Wide" steps are useful to solve this.

"Wide to Long" and "Long to Wide" steps are useful to solve this.

Untitled Diagram.drawio (2).png

Let's see an example. See the pipeline here (opens in a new tab)

Let's begin by loading some Yahoo Finance data. You will notice the Tickers (Apple, Microsoft, Google. etc) values in the column "Ticker". Let's assume that you need them to be columns, side by side and that you only need the Closing price and not Open-High-Low-Close.


Next, add a step Long to Wide (Unstack) to the pipeline.


And the resulting dataset will look like these


If you want to reverse this process use the step "Wide to Long" in which case you need to define what will be the name of the column that will now host the tickers and the name of the columns that will have the values. Also you can check and uncheck which columns should be "melted" and uncheck those that will prevail as columns.


It will now look like these


Last updated on March 2, 2023