Related Articles

Related Articles

Reshape a pandas DataFrame using stack,unstack and melt method
  • Last Updated : 08 Jan, 2019

Pandas use various methods to reshape the dataframe and series. Let’s see about the some of that reshaping method.

Let’s import a dataframe first.

filter_none

edit
close

play_arrow

link
brightness_4
code

# import pandas module
import pandas as pd
  
# making dataframe
  
# it was print the first 5-rows
print(df.head()) 

chevron_right


Output:

Using stack() method:

Stack method works with the MultiIndex objects in DataFrame, it returning a DataFrame with an index with a new inner-most level of row labels. It changes the wide table to a long table.



filter_none

edit
close

play_arrow

link
brightness_4
code

# import pandas module
import pandas as pd
  
# making dataframe
df = pd.read_csv("nba.csv")
  
# reshape the dataframe using stack() method
df_stacked = df.stack()
  
print(df_stacked.head(26))

chevron_right


Output:

 
Using unstack() method:
unstack is similar to stack method, It also works with multi-index objects in dataframe, producing a reshaped DataFrame with a new inner-most level of column labels.

filter_none

edit
close

play_arrow

link
brightness_4
code

# import pandas module
import pandas as pd
  
# making dataframe
df = pd.read_csv("nba.csv")
  
# unstack() method
df_unstacked = df_stacked.unstack()
print(df_unstacked.head(10))

chevron_right


Using melt() method:
Melt in pandas reshape dataframe from wide format to long format. It uses the “id_vars[‘col_names’]” for melt the dataframe by column names.

filter_none

edit
close

play_arrow

link
brightness_4
code

# import pandas module
import pandas as pd
  
# making dataframe
df = pd.read_csv("nba.csv")
  
# it takes two columns "Name" and "Team"
df_melt = df.melt(id_vars =['Name', 'Team']) 
print(df_melt.head(10))

chevron_right


Output:

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.




My Personal Notes arrow_drop_up
Recommended Articles
Page :