What is unstacking and squeeze in pandas dataframe?
This recipe explains what is unstacking and squeeze in pandas dataframe
Recipe Objective
Suppose we have a stacked data i.e. column is stacked row wise. Now we wish to unstack it. It can easily be done by unstack() function.
So this recipe is a short example on What is unstacking and squeeze in pandas dataframe. Let's get started.
Step 1 - Import the library
import pandas as pd
import seaborn as sb
Let's pause and look at these imports. Pandas is generally used for performing mathematical operation and preferably over arrays. Seaborn is just used in here to import dataset.
Step 2 - Setup the Data
df = sb.load_dataset('tips')
stacked_df=df.stack()
print(stacked_df)
Here we have imported tips dataset from seaborn library. Now, to produce a stacked dataframe, we are using stack function to modify the current.
Now our dataset is ready.
Step 3 - Unstacking dataframe.
unstacked_df=stacked_df.unstack()
print(unstacked_df)
Here we unstacked our datafram using unstack() function.
Step 4 - Let's look at our dataset now
Once we run the above code snippet, we will see:
Scroll down to the ipython file to look at the results.
We can see data returning to original format. Similarity for multiindex format, we will have same results.
What Users are saying..
Abhinav Agarwal
I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More