Python Pandas Tutorial (Part 3): Indexes - How to Set, Reset, and Use Indexes

[@coreyms]

Hey everybody. I hope everyone's week is starting off well. I'm still working on the next video in the series, so I don't have a specific release date just yet. Just keep your eyes open. I'm hoping to have this entire series finished soon, but I'm not sure how long it will take me to record/edit the remaining video. I'll do my best to get them out ASAP (this week or next). Have a good one!

[@prakharthapak4229]

Hi Corey, can you please do tutorials on pytorch ? That would be so useful.

[@alanbarzilay6866]

Hi, have you seen the release of pandas 1.0?pandas.pydata.org/pandas-docs/version/1.0.0/whatsnew/v1.0.0.html Is this going to affect this series in any way? Also thank your for all of your work! You do an incredible job!

[@SHUBHITTALUSBIS]

Sir how many videos are in this series?

[@waynezor]

@@alanbarzilay6866 It's still a release candidate, so probably not. However, everything here could at some point become obsolete for sure. The documentation on pandas is mostly pretty nice, so I would just look up how to do some specific thing should the "old way" stop working.

[@mikesak7994]

@@waynezor Release candidate means that features are probably set, it just needs more testing before they release the stable version. Agree with the rest, but why not include the new things if they are worth noting from now on?

[@stingray3565]

Even after 4 years, this is the best Pandas video on KZbin. Thank you Corey , for this.

[@sheilaokolie93]

Talk about beginner friendly?? This is one!!! Hands down the best!!!!!!!

[@p3000g1]

Hands down best python tutorials on youtube. Nobody does so much for free. Thanks Corey

[@im4485]

it isn't free

[@enknot]

@@im4485 I def subscribed to brilliant.

[@bartoszturkowyd3608]

I'm using pandas for a quite long time and sometimes I found it annoying (yet still very useful and mandatory in data science). Your videos make this library crystal clear. Thank you for this!

[@736939]

Thank you Corey. After this Pandas tutorials, please start the scikit-Learn and then TensorFlow2 tutorials

[@ryanlee619]

most likely never going to happen :(, but this would be soo good

[@historywithreese]

Wish that could be possible. ':(

[@utpalmohane1416]

How Kind Can Someone Be? He explains each and every detail and also explain things repeatedly so that anyone coming any of the video in the middle of the series will find it easy to follow the video.

[@alexandertsiolkovski5848]

Corey, I just want to appreciate your work here. I am learning a lot from your videos. Thank you for making them freely available.

[@philinnc]

Pandas is an enormously helpful tool with good documentation, but for those of us who learn best by example there can be a steep learning curve. These tutorials are the best I've seen for clearly and methodically working through the basics.

[@egyptsphinx9393]

I can`t ensure if you will believe me or not when i tell you that i downloaded 130 tutorial video of your content about python, but the most important thing that i am sure about is, you are awesome, keep going believer

[@EdwardRLyons]

Thank you for this particular video. It's explained indexing in 15 minutes with much greater clarity than anything else I've used so far.

[@kasyapdharanikota8570]

your tutorials are far better than the paid ones on other platforms

[@sarangkharpate5780]

I learned Pandas on my own, by hit and trial, but after watching these videos, finally I am able to connect the dots and make some sense why things are like this. Thanks Corey, this will save my time to google every command :)

[@srinivastipparthi4608]

how do u learn ..how many works u did on your own

[@hameem6845]

I am using a string index in my current project and this is all very useful. Thanks! This pandas series is gonna be awesome.

[@sebastianhernandez3059]

Can't believe how awesome you are! Really enjoying this series so far your instructions are so thorough and simple, you've really helped me grow so much in my aspirations. Thank you so much Corey, hope all is well in this tough time.

[@shantanukaushikmathoholic]

Awesome, this is best Pandas series so far I have watched on internet...

[@murrkerr04]

Wow, these videos are seriously so helpful! I've just been getting started with pandas, feeling frustrated because I just don't understand the syntax super well yet and thus having to google literally everything. This is making it so much easier to understand! I can't thank you enough and I'm looking forward to getting through all the videos! :)

[@rareflower88]

Thanks for this series, @Corey! Very helpful and very well done. I went to Brilliant to check them out to thank them for sponsoring your videos! Thanks Brilliant!

[@muntadher8087]

I enjoyed this video so much, thank you so much, I'm recommending your channel to all my friends. Watching your videos is a must! Thank you so much!!

[@Spatial_Guide]

I don't know how to thank you enough for this free gift. I wish I could subscribe more than once to this channel. you turn my life around. thank you

[@priyanshusaxena7157]

You know what Corey, you are the only person I would like to thank once I become a data scientist...

[@Rafian1924]

Thanks a lot Corey.. you are the best instructor out there.. I can't even imagine learning from anybody else. Can you please consider creating a series on pyspark and machine learning??

[@REKHAKUMARI-lv8mz]

Thanks a lot, Corey! It's evident that you put in a lot of effort into making your videos flawless. Where else could I get such clear and thorough explanations !?!

[@alncl9566]

Watching one video everyday after work! Thanks for the amazing videos. They're easy to follow. I am looking forward to check the other courses as well.

[@vijaybabu3923]

Very nice video.. will recommend anyone who is in the world of data engineering. will look forward for the next video! Thank you Corey 👍

[@ibrahimsma975]

Thanks Corey for this awesome series... You are making complex things looks simple.. What I like the most about your series is that your Tutorial flow by explaining simple to complex in an understandable manner.. Keep this good work, you are bringing in differences in many Techies lives.

[@finncollins5696]

watched 1 and 2 . the best tutorial. And am watching the third. thanks a lot. you are the best.

[@femi2873]

1.To reset index after loading csv ; df.reset_index 2 to set index after reading CSV; df.set_index(" ") 3.To reset index in place and permanently change dataframe ; df.reset_index(inplace= True) 4. To set index while reading the data(csv) ; df = pd.read_csv('data/survey_results_public.csv', index_col =" ") 5. To sort your index alphabetically; df.index_sort 5. To sort your index alphabetically in a descending order; df.index_sort(ascending = False)

[@ibekwevictor1158]

Thanks Mr Corey, you are such a great teacher.

[@SolvingOptimizationProblems]

The index tips are so useful to work with dataframe. Thank you for such a great work.

[@awusacollins]

Hey Corey, you did justice to this lecture! All for free! Be blessed!

[@IvanToman]

Manager Idiot is the best

[@akioo9495]

they removed that question in 2020 survey xD

[@felixlichter2332]

I am an amateur coder, I also have never posted a KZbin comment, but thank you.... these videos are incredible

[@meta_ai]

BEST #PYTHON #channel ever

[@ishanpand3y]

NO DOUBT...

[@dianavillescas]

I a so glad I found you video. Finally I found the answer I was looking for for 2 hours!. Thank you.

[@Breezy89er]

I am finally getting into Pandas and these videos have been great!!!

[@cathieajuex7223]

You are extremely a nice teacher. Good and detailed explanations in all your videos i have watched. Keep it up rolling for us beginners

[@hamidoumaiga5733]

Really great videos Part 1, 2 and now 3. It was so hard to find a good Pandas tutorial but yours is Ivy School level explanation. 🎉

[@shankerkc01]

I keep refering back to these pandas tutorial videos whenever I needed. Great job @coreyms.

[@akira_asahi]

Thank you for the video. I am grateful for your time and contribution. Kind regards, Akira.

[@lefttraces7207]

This series is an instructional masterpiece!

[@sandeepsingh-sp7yn]

Hey Corey, Your way of teaching is really awesome, Anyone who is beginner can also grab it and take it forward easily. Waiting for your upcoming videos on pandas :-) and looking forward to new series in python like numpy etc. which can help us in data analysis. You are doing a great job.

[@saitaro]

This is top quality stuff again. As always from Corey.

[@roberta.42]

Chapters: 00:00 Intro 00:30 Recap of Dataset 01:00 Recap of What's an Index 02:06 How to Set DataFrame (Row) Indexes ('df.set_index('col_to_use')') 02:35 'inplace' Argument 03:40 '.index' Attribute 05:13 How to Reset (Row) Indeces ('df.reset_index()') 06:16 Set (Row) Index on DataFrame Creation () and Practice on Real-World Dataset ('pd.read_csv('file.csv', index_col='col_to_use')' 12:58 Sort Indexes (`df.sort_index(ascending=False)`) 15:02 Outro Copied from @Adam Hendry for future reference

[@dark4krad]

About time. Great timing! Thank you sir! Respect to you!

[@DanteHellDrive]

wow excellent tutorial, really well explained with awesome clarity. Keep up the good work!

[@abdusinc2557]

i can't believe I'm getting this for free thank you sir

[@nakshatragarg]

Thanks, Corey! This playlist is really insightful

[@diegooliveira7713]

Thank you very much for this clear and informative video! 😄

[@TopicalAuthority]

Great lesson thank you!

[@Mysterious_debris_1111]

Best possible explanations ever...

[@subject8123]

Talk about timing, I just started this series this morning

[@KingLiongWong]

Great course with clear explanation, great help to me. Thanks a lot.

[@maruthigowda2921]

Thank you so much for this wonderful pandas series🙏

[@darkmaraux]

So nice! I will like and coment in every video of this set! You deserve the best! thanks!

[@stephanie_ong]

Great tutorial video as always. Thanks!

[@VikasGuptacherie]

Thank you!! Very important and nice video series

[@mohameda.abokhoshiem2624]

Corey Schafer, you 're amazing. Thank you.

[@alexandro_coutinho]

Great lesson! Thank you!

[@JoshuaDHarvey]

Great video, thank you! 14:000 I know you covered - pd.set_options('display.max_columns',##) but I can't seem to get the schema dataframe to show that even if I do run that... - nevermind, I figured it out. It was just pd.set_options('display.max_rows',##) and I think you did cover that! Anyway, thanks again Corey!

[@somyagupta2905]

Thanks a lot Corey, your videos are very helpful :)

[@narendrar9940]

As usual great video, thanks again!

[@nathandai7510]

7:20 respondent 0: "I am a sttudent learning to code" stack overflow: "are you a student" respondent 0: "no" stack overflow: "what is your education level" respondent 0: "elementary school" stack overflow: *mike wazowski bruh face

[@hRECKit]

i dont need sleep i need answers

[@BrijeshYadav-vl7bj]

Very helpful videos indeed.

[@markkennedy9767]

Yet another lovely lesson. Nice flow with a good combination of motivation and technical instruction. Thanks. Just wondering how common the inplace=True argument is across Python generally, or is it specific to Pandas- first time I've seen it.

[@ishanpand3y]

Thank you, Sir! 🧡🤍💚

[@ABDULKARIMHOMAIDI]

Thanks man this very useful !!

Hey Corey. Your tutorials are awesome. It would be great if you produce how to use importlib library and dynamic module importing tutorials in future videos. Thank you very much.

[@galaxyhomehealthservices9898]

Thank you for the great videos .

[@prabhathkota107]

Very nice tutorial. Thank you.

[@rodkrebs9140]

Thanks!! very insightful, good video

[@omeryazici5318]

print("BEST PYTHON LESSON ON UNIVERSE")

[@usmonov_dev]

Thank you bro ;) Couldn't wait to make data visualization.

[@SHAli1474]

Hey Corey A very good series. Learning from these and applying to Python visuals in Power BI. A bit limited in options there. Would it interest you to make a few videos on handling Python in Power BI? Thanks

[@pyushnandan9333]

Hey, I started following this course to learn pandas. However my primary focus is Machine Learning. So does this course cover all the concepts for it or is this more focused on Data Science? It will be really helpful if someone could be tell me.

[@ganeshbala]

Thank you, Corey!

[@SNK19151]

Thanks bro you're so amazing

[@youssefelbieh2939]

Please Corey.. We need docker and microservices

[@joro8604]

So well explained....

[@GREATEXTREME7]

Love your videos

[@warrenvanwyck2765]

Overall good stuff. More thought needs to be given when choosing example data. For rows and columns it's natural to speak of the first or last row -- and even the first or last column.. Using 'first' and 'last' for column names is needlessly ambiguous.

[@tireldenamse5854]

Good job!

[@1neminutebonk3rs3]

3 down, 8 to go.. Dated 5/25/2023

[@sharbi9943]

Can't understand why would anyone dislike such a high quality work?!!! Thank you Corey... one simple question, when using methods (df.set_index()) I get an error on Spyder. 'DataFrame' object has no attribute 'set_index'.... it works if pd.set_index is used instead?

[@danielotieno5306]

Hi teacher, I love the videos, Thanks for taking us through, My data set after loading it in pandas its showing the "NaN" columns that are not there when i open the file direct using excel, what could be the issue?

[@ajitesh764]

1st comment...didn't watch it...first i like corey's video then i watch it...PS: First i disable my adblock....i urge everyone to do the same. Just out of curiosity...how many videos this pandas series consist of?..thank you for amazing videos..you're the best teacher Corey.

[@coreyms]

I still haven't finished recording the series yet, so I'm not exactly sure how I'll break up the last videos. But I _think_ it's going to end up being around 10 videos or so. Then I'm going to do another series of 5-10 videos specifically on plotting in Pandas.

[@bhaukalifacts7139]

Sir Can you please make Videos on ML also. You teach like a teacher is teaching to a 1st class student. I am very curious to study ML lectures by you Sir. Thankyou very much sir .😊😊

[@melsaied101]

Remercie for your work!

[@chinazomjennifer7985]

Hi Corey, thank you so much for this tutorial but I keep getting something missed up, Iin what context do we use the normal parenthesis (), this {} and the squared bracket [] ????

[@داوداحمدی-ش9ع]

Am from Iran I love u😍

[@muhammadazizrahman2264]

Thankyou Sir

[@kopilkaiser8991]

You deserve ⭐️⭐️⭐️⭐️⭐️

[@akhilmehta8248]

Thank you Corey for the video. I have a small doubt: pd.set_option('display.max_columns',85) pd.set_option('display.max_rows',85) After this command if we print df, shouldn't we see 85 rows of df? Or am I getting this wrong?

[@techtime5989]

Corey, I have same question as this

[@Karama52011]

Thanks a lot. My question is how let index start from 1 instead of 0? Also, how to show ordinal number instead of ordinary numbers?

[@wwpharmacist]

Awesome Thanks

[@jongcheulkim7284]

Thank you.

[@karishmakaris7165]

thankyou 🙂

[@debojitmandal8670]

Can you please also make machine learning tutorials . And please provide time stamp for this video.

[@joysharma8599]

hey corey, please create some videos on numpy!

[@gayratsaidakhmedov5451]

thank you

[@GlobalWarming_x]

Bless you !!!