What do I need to know about the pandas index? (Part 1)

The DataFrame index is core to the functionality of pandas, yet it's confusing to many users. In this video, I'll explain what the index is used for and why you might want to store your data in the index. I'll also demonstrate how to set and reset the index, and show how that affects the DataFrame's shape and contents.

SUBSCRIBE to learn data science with Python:

JOIN the "Data School Insiders" community and receive exclusive rewards:

== RESOURCES ==

== LET'S CONNECT! ==

[MaryMacor]

You are so articulate and never give me a headache like most of the others

[BiranchiNarayanNayak]

Data School is the ultimate place to learn about Pandas.
Thanks for the excellent tutorials on Pandas.

[avantikasingh]

Thanks for being so effortless and keeping it to the base level .... it is more understandable!

[nataliaagudelo]

I am so glad I found your channel, always very thankful for you and your capacity to share your knowledge with us!

[adventuresunlimited]

I really appreciate the hard work you put in in your videos. I am taking a class in Python and your videos really helped me develop a finer understanding of what is being taught in my classes. These are the best videos for Pandas, I totally love them. I have subscribed and visit your channel almost everyday and each day I get what I was looking for. All the best to you. Keep up the good work.

[WanderPalateAdventure]

You made my life easy. I am new to this language word and was struggling to understand the concepts. Your videos just saved me.

[akashpoudel]

i dont understand who is that super human who dislikes your videos thinnk we are blessed u are giving your time to teach

[marinajin]

Best of the best, I can follow you step by step, which makes the learning process so efficient and fun. Thanks a MILL

[sararabiee]

You are an amazing teacher. I am new to this field and your videos are great help. Thanks a million 🙏🏽

[khanyasser]

wooow so glad I chose this video over others! So thorough and clear! Easy to follow! I was struggling and now my code is working. thank you.

[sep]

Thanks so for this video. It made me understand something I was struggling with.
I'm going to watch you other video's right away :)

[niteshmaruthi]

Brilliant- This made the exact function of indexes very clear - I am binge watching these videos now!

[tomasfanta]

Nice, clear and very helpful, especially "pd.DataFrame.reset_index" usage, thank you!

[slavrine]

It must be python 3, but drink.index shows up differently: RangeIndex(start=0, stop=193, step=1). As for the quality of your presentation, this should be a paid course! You're presenting the material so well! Would love to see you do more python courses - Matplotlib, etc

[armenlevonian]

Super clear and helpful!! I so agree with others who commented as such. Thank you!!

[ossenaar]

Great videos series in pandas.

For scalar selections (individual elements) in a large data frame, there is a faster alternative for using loc (labels based) and iloc (integer position based): at and iat.

[zennologyofeverything]

THANK YOU! I just started with python datascience projects. My first project is the famous iris dataset. this helps a lot

[datascienceds]

You deserve million subscription. I got an answer that I was looking for ages!!! reseting index to column. You saved my time. Thank you so much. I was wondering if you have done any percentage plotting. Sorry if it is a wrong way of asking !!

[bingochipspass]

Perfect explanation! Even the documentation doesn't do such a good job!

[aqilraza]

Excellent! Excellent! Excellent! way of explaining the concept of index - you rock!