Unpivot

Unpivoting with melt()

Now that we know how to convert DataFrames from the long to wide format with pivot() and pivot_table(), let's explore the reverse situation of reshaping data from the wide to long format. A wide format DataFrame can be unpivoted with the melt() method that helps reshape it into a long format, comprising of these three output columns:

• Index column (serves as the identifier variable and can be multiple columns)

• Variable column

• Value column

Lets see the melt() method in action by working on a subset of the credit card dataset. The dataset comprises the customer ID, age, income, and credit rating of credit card holders.

The melt() method has the following parameters:

• id_vars: Column(s) to use ...