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!!!!!!!

[@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!

[@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.

[@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. ':(

[@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.

[@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.

[@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

[@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

[@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

[@priyanshusaxena7157]

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

[@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.

[@felixlichter2332]

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

[@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??

[@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.

[@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! :)

[@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

[@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)

[@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 !?!

[@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

[@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.

[@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!!

[@shantanukaushikmathoholic]

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

[@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!

[@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.

[@meta_ai]

BEST #PYTHON #channel ever

[@ishanpand3y]

NO DOUBT...

[@ibekwevictor1158]

Thanks Mr Corey, you are such a great teacher.

[@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 👍

[@SolvingOptimizationProblems]

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

[@finncollins5696]

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

[@IvanToman]

Manager Idiot is the best

[@akioo9495]

they removed that question in 2020 survey xD

[@awusacollins]

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

[@abdusinc2557]

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

[@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

[@shankerkc01]

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

[@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.

[@Breezy89er]

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

[@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. 🎉

[@lefttraces7207]

This series is an instructional masterpiece!

[@dianavillescas]

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

[@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

[@akira_asahi]

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

[@saitaro]

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

[@subject8123]

Talk about timing, I just started this series this morning

[@nakshatragarg]

Thanks, Corey! This playlist is really insightful

[@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!

[@KingLiongWong]

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

[@diegooliveira7713]

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

[@Mysterious_debris_1111]

Best possible explanations ever...

[@TopicalAuthority]

Great lesson thank you!

[@alexandro_coutinho]

Great lesson! Thank you!

[@stephanie_ong]

Great tutorial video as always. Thanks!

[@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!

[@VikasGuptacherie]

Thank you!! Very important and nice video series

[@darkmaraux]

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

[@maruthigowda2921]

Thank you so much for this wonderful pandas series🙏

[@mohameda.abokhoshiem2624]

Corey Schafer, you 're amazing. Thank you.

[@narendrar9940]

As usual great video, thanks again!

[@BrijeshYadav-vl7bj]

Very helpful videos indeed.

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.

[@somyagupta2905]

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

[@ABDULKARIMHOMAIDI]

Thanks man this very useful !!

[@omeryazici5318]

print("BEST PYTHON LESSON ON UNIVERSE")

[@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.

[@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.

[@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?

[@prabhathkota107]

Very nice tutorial. Thank you.

[@galaxyhomehealthservices9898]

Thank you for the great videos .

[@ishanpand3y]

Thank you, Sir! 🧡🤍💚

[@youssefelbieh2939]

Please Corey.. We need docker and microservices

[@1neminutebonk3rs3]

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

[@rodkrebs9140]

Thanks!! very insightful, good video

[@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 [] ????

[@usmonov_dev]

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

[@SNK19151]

Thanks bro you're so amazing

[@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?

[@ganeshbala]

Thank you, Corey!

[@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

[@joro8604]

So well explained....

[@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.

[@jongcheulkim7284]

Thank you.

[@melsaied101]

Remercie for your work!

[@wwpharmacist]

Awesome Thanks

[@tireldenamse5854]

Good job!

[@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?

[@gayratsaidakhmedov5451]

thank you

[@muhammadazizrahman2264]

Thankyou Sir

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

Am from Iran I love u😍

[@GREATEXTREME7]

Love your videos

[@husseinhadliye2992]

@Corey Schafer Thanks for the tutorial it's really very good but how you can access the questions from another excel?

[@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 .😊😊

[@rvamerongen]

Hi, great tut. thank you. A question, How thread safe is Pandas? Are you willing to do a tut about that? Thank you very much.

[@rvamerongen]

BTW, what I did want to ask was, "How can I reset the sort order after schema_df.sort_index(inplace=True) to its original state"?

[@kopilkaiser8991]

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

[@akashpatil9161]

Does using "inplace= True" changes csv file data arrangement?

[@GlobalWarming_x]

Bless you !!!