5 - Multi/ Hierarchical/ Advanced Index using Pandas | Comprehensive Pandas Tutorial for Beginners

In this video you'll learn about multi indexing, which is nothing but one step ahead of the normal indexing, one which has only one layer of row index and columns.
In multi index, we have multiple layers of row labels and columns, using which we can efficiently store higher-dimensional data in a 2-D dataframe structure and perform all of the slicing and filtering.
We'll learn the normal .loc method, .xs method, .take( ), slice( ) etc to fiddle with multi-indexed data structures.
You can check out my github page to find all the relevant Jupyter Notebooks, datasets and other materials I'd upload with each video tutorial!
Link:
github.com/rachittoshniwal/pa...
Don't forget to subscribe and hit the bell icon to be regularly notified when we add new content!
Thanks!

[@DataAnalystVictoria]

Thanks! ❤

[@mishalubich9366]

Best tutorial on pandas MultiIndex! Every other video covers MultiIndex too superficially! Even the documentation examples are not that in-depth and clear! Thank you so much!

[@rachittoshniwal]

Wow, thanks!

[@mishalubich9366]

You're welcome! Do you know how to query multiple columns on the 2nd level (level = 1) for all indices in the 1rst level (level =0)? For example: How do I query Mustard and Ketchup for all burgers? burgers: Double Double | Triple condiments: Ketchup | Mustard | Relish | Ketchup | Mustard | Relish McDonalds 2 | 2 | 0 3 | 3 | 0 Beep's Burgers 1 | 1 | 3 2 | 3 | 4

[@rachittoshniwal]

df.loc[:, (df.columns.levels[0], ('Ketchup', 'Mustard'))] is this it?

[@oyeleyeolalekan4486]

this channel is too good....i wonder why alot of people are not here

[@FullSpectra]

Excellent tutorial Rachit! Greetings from Greece!

[@rachittoshniwal]

Thanks, and hi!

[@dubey_ji]

Thanks man 🙏🙏🙏

[@jongcheulkim7284]

Thank you.

[@cuoivelo8360]

Can you turn on subtitle for the videos? Im bad at English listening

[@BADGAYAN]

Its wow. Can you please share the link for the data set used?

[@hemanttanawade4434]

Hello bro i need table just like you have. Pls send here link of this dataset or upload it in internet

[@rachittoshniwal]

You can find it here on my github : github.com/rachittoshniwal/pandasTutorial