Python Pandas Tutorial 12. Stack Unstack

Pandas stack method is used to transpose innermost level of columns in a dataframe. unstack() is used to perform a reverse operation. This tutorial explains stack/unstack using nice visualizations.

Topics that are covered in this Python Pandas Video:
0:00 What is stack
1:32 How to use stack() method
2:18 Pandas stack documentation
3:03 Perform unstack() method

Next Video:

Popular Playlist:

[msgrz]

To get rid of "Unnamed: 0_level_0" in a column:
df = pd.read_excel('./stocks.xlsx', header=[0, 1], index_col=[0])

[codebasics]

Machine learning tutorials with exercises:

[codebasics]

Machine learning tutorials with exercises are available at:

[gouravchatterjee]

Thanks for helping. Videos are really informative!!!

[rajsamant]

thanks sir....best way to giving training

[ARROBACOMPUTERS]

Straightforward, clear, and very informative. Thank You.

[MrPrudhvisai]

But why "Unnamed: 0_level_0" is appearing even though it is not exist in the excel sheet

[wackybaccygaming]

I had a whole column with string input, it does not show that in the df.stack() output. Why does it leave the entire row ?
Somebody plz help.

[jakeg]

Hello, I would like to arrange my pivot table the same way your data frame started out e.g. (Year Quarter across the top, type underneath and member IDs replacing company dates)- is that possible?

[marlonmag-isa]

Hi how to pivot multiple columns in python pandas? For example I have 9 columns and I want to retain columns 1 to 3 and pivot the columns from 4 to 9.

[shahrohit]

Hi, can you please provide some practice questions as well so we can solve those problems to do hands-on . Really liked your videos.

[cococnk]

Hello thanks for the video …

I will like to know how can we apply this function in the real world ? It answers to what type of problem ?

[akshaykharat]

hello sir, i like your tutorials on pandas very much . i have a one question that is 'how to make box of output ?', whenever you run the cell and coming output in box but in my situation its not happend.

[achin]

i beg you sir please tell about Web Crawler and how to make it in simple step

[just_random_stuffs]

I get an error : excel xlsx file; not supported when I try to import excel file

[Ganeshpatil-owej]

sir what is the meaning of if we use header=0 which skips first row treats second row as header.. and how to access that dataframe...

[haider]

my first row is showing two times please check this screenshot :


i wrote first row one time please check screenshot of my excel file too:


and screenshot of my code is below: