Python Pandas Tutorial (Part 7): Sorting Data

Подписаться 1,3 млн

Просмотров 182 тыс.

50% 1

In this video, we will be learning how to sort DataFrames in Pandas.
This video is sponsored by Brilliant. Go to brilliant.org/cms to sign up for free. Be one of the first 200 people to sign up with this link and get 20% off your premium subscription.
In this Python Programming video, we will be learning how to sort our data. We will learn how to sort single columns, sort multiple columns, and view the largest and smallest values in a DataFrame. Let's get started...
The code for this video can be found at:
bit.ly/Pandas-07
StackOverflow Survey Download Page - bit.ly/SO-Survey-Download
✅ Support My Channel Through Patreon:
/ coreyms
✅ Become a Channel Member:
/ @coreyms
✅ One-Time Contribution Through PayPal:
goo.gl/649HFY
✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot
✅ Corey's Public Amazon Wishlist
a.co/inIyro1
✅ Equipment I Use and Books I Recommend:
www.amazon.com/shop/coreyschafer
▶️ You Can Find Me On:
My Website - coreyms.com/
My Second Channel - / coreymschafer
Facebook - / coreymschafer
Twitter - / coreymschafer
Instagram - / coreymschafer
#Python #Pandas

Опубликовано:

5 фев 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 178

@coreyms 4 года назад

Hey everyone. Hope you're having a great week! I've tried taking your suggestions to heart and tried making the videos shorter without sacrificing any of the details I believe are important. Let me know if there is anything specific you want me to cover in Pandas as I continue this series. In the next video, we'll be learning how to group and aggregate data, which will open a lot of possibilities for exploring our data.

@k1mfor 4 года назад

Thanks Corey! Here's a few ideas for interesting pandas topics: 1) comparing a row's values to the row(s) above (or below) (shift), and populating a series based on that, 2) MultiIndex (this one always seems annoying), 3) Categorical, 4) pivot and pivot_table, and 5) joining/merging dataframes.

@ajitesh764 4 года назад

Doesn't matter if the videos are short or long as long as it doesn't sacrifice the details. I didn't find any problem with one of your videos that was about 40 min long. People who want shorter videos are the impatient ones, they want to learn such valuable concepts in a short period of time and want some kind of magic to happen that will make them a pro overnight after they finish the series.

@bakihussain4231 4 года назад

Can you also add matplotlib in this series to visualize data and how it changes?

@thiagohenrique1141 4 года назад

@@bakihussain4231 This would be good.

@mcleanb981 4 года назад

Hey Corey, think you could do a series on tensorflow or pytorch?

@titandegroot 4 года назад

Corey, I would not worry about the length of the videos,. I love the way you discuss the entire concept from beginning to end. Don't change anything.

@MrRahul15937 Год назад

completely agree

@Davidkiania 4 года назад

Loving the series don’t change anything even the length. There’s a forward button for that.

@ihgnmah 4 года назад

True

@AugustoGeografo 4 года назад

Corey, you use the amount of time you find appropriate. You are a excellent and very didactic tutor. If you think a video must be long to convey a message, you go with your instinct.

@danielbristow4819 3 года назад

Could not agree more. This is a free service that is an absolute game changer.

@programmingcheatsheet 2 года назад

I usually try binging these anyway. Excellent job as always, Corey

@kameshinipillay4587 Год назад

@@programmingcheatsheet haha same!

@shivajishinde1496 4 года назад

I don't believe these valuable lectures are free. All lectures series will definitely be seen by everyone who really wants to go the basics of these contents. Each and every steps/topic is explained very well. Thank you very very much for spending time for us. You are taking too much effort to make these video, and I really appreciate your efforts. I really have no words for it. God bless you! And You are the best python teacher I have had, I must say!!!

@benjamindeporte3806 4 года назад

I loved the comment on the 2M$ salary :-) Joke aside - great series, all 7 in a row so far, good content, length and details.

@systemslave510 4 года назад

I dont care how long the video is as long as its thorough and comprehensive.

@safakv60 3 месяца назад

i've latelty completed couple different pandas tutorials, even very deep one. however, this playlist is the simplest and the most effective one, even i just tend to refresh my knowledge. thanks a lot.

@salmansiddiqui9502 Месяц назад

Thank you! This series has been incredibly helpful-clear, informative, and lucid. Your comment made me laugh as well! 🙂

@jackfrost8969 6 месяцев назад

even after 4 years I was compelled to go through your videos. You are just the best. I remember learning Django from your videos back in the days. And still now i find your videos to be the best.

@rhard007 4 года назад

Corey, don't change anything. If YOU feel the video is too long, just release part 1 and part 2 of that topic. The content is great.

@sultanabbas9411 4 года назад

WOW, I've just set up my mind to learn some Panda then suddenly your video pops up, the fact that you have uploaded about Panda and Matplotlib is insane, You REALLY upload every Python related stuff Appreciated man, thanks

@jingpinhuicai 4 года назад

Absolutely the best Pandas tutorial on RU-vid!

@sinanyagcoglu3233 2 года назад

I cannot thank you enough! Fantastic content and teaching style! Keep up the good work Corey!

@bobmcgee6711 4 года назад

Corey take as long as you need in your videos. You're a great teacher.

@neelio99 4 года назад

Thank you for your hard work! Following your tutorials is such a great way to make use of my quarantine.

@brandibooth Год назад

Your work on here is absolutely amazing. Thank you SO much! I really get it, the way you teach it. Thank you Corey!

@slikshot6 4 года назад

Bro can I say, I'm really thankful for you putting all this out. It means a lot and its been taught very well.

@khahmed4752 4 года назад

done 7 videos in a row without a break. You are awesome man

@FrankMozingo 4 года назад

Great series, which is not surprising... I have learned immensely from many of your videos and playlist! Your instruction is so good I am able to learn even by listening to your videos while driving (listen not watch, safety first you know). I would like to join the many others by saying thank you for the effort you put forth to produce you content!!

@axisinfo819 3 года назад

Couldn't have asked for more. This is awesome!

@gethsun1 4 года назад

Thank you very much Corey you creating very immense impact in peoples lives...

@coreyms 4 года назад

Thank you for the kind words. I'm happy to hear that people find these helpful.

@HellenofTroy897 2 года назад

Your tutorials are the best online. Just take notes, practise with them and do the documentation. Rinse and repeat.

@parthrawri3001 4 года назад

Corey. You are the best. This content is a national treasure and must be preserved. I can’t stress enough how much of a change you’re making in other people’s lives. Keep doing the good work! Love from India ❤️ As far as the length is concerned, I really don’t mind how long it is. You make every second count, so that compensates for everything.

@sarathy319 4 года назад

Python (Data structures & Algorithms ) - Much needed content from your channel

@rajeevmenon5945 3 года назад

Some great people like you find teaching a bliss. Just unbelievable that such valuable lessons for FREE. Heartfelt Thanks for all the videos. God Bless you always

@aanalpatel5361 2 года назад

Thank you Corey Sir! The videos are veryyyyy helpful to beginners. Explained in the most simple manner, with loaddssss of examples . Thanks to the sponsores too!

@milrione8425 3 года назад

You are the best programming teacher on youtube. I wished I found you earlier. Thank you so much. You are a great teacher!

@darkmaraux 4 года назад

Just perfect! Best teacher! Huge hug for ya!

@jasonxiao2456 4 года назад

As good as usual! Corey rock!

@qianyu711 3 года назад

Corey, this is amazing. Thank you!

@mitchellfolbe8729 2 года назад

Well done. Just doing this for a fun hobby. Thank you for keeping it interesting.

@I_beat_up_cuckolds Год назад

What a phenomenal teacher.

@AylmerKing 4 года назад

Thank you for all your hard works!

@evertonbarbosa8525 3 года назад

Mano, I'm Brazilian and I was trying to define a classification with two parameters and a specific order for each one, the video opened my eyes!

@rodkrebs9140 3 года назад

Very clear! excellent video

@patrikmerla8828 4 года назад

Once more great content, some of your videos are shown as teaching material in business schools in Finland!

@VikasGuptacherie 4 года назад

No doubt about that ... I refer his tutorials to all my reportees in my organization to learn python ...

@TariqTheTutor 2 года назад

best coding channel on RU-vid!

@pilloblah 4 года назад

Love your videos Corey, really informative. Dropping a HUGE like for the joke on the 2M dollars! Keep it up, I appreciate your content a lot!

@anantgosai8884 2 года назад

Man you deserve more and more love&success....means alot bro,thankkkk you!

@ironpolux 2 года назад

Thanks for the vid, great video as usual :)

@dipayanroy8357 4 года назад

hey, brilliant series!! please do not shorten the length of the videos and take as much time and space you want. we like every little details you provide in there

@mostafazohary4738 2 года назад

you are great corey.clear explanation that any one with no knowledge can learn

@noureddineettayyeby5210 4 года назад

Thank you for this Series.

@zahrabardestani5546 2 года назад

You are undoubtfully great , I fall in love with Pandas only due to your excellent teaching method

@ishanpand3y 4 года назад

Number 7 done. Thank you, sir!

@imerla1316 4 года назад

Best Mentor i have ever seen

@yashbhoyar7889 4 года назад

Cant believe that these lectures are free of cost.....

@user-hy7ei1bk1h 4 года назад

You are sponsored by Brilliant because you are brilliant!!!

@darkknight8207 2 года назад

Very helpful sir! thank you

@karishmakaris7165 4 года назад

sir ur too great, thanks for ur efforts..

@janidelemmanuelcastaneda8318 4 года назад

Thank you so much! Your lessons have been very helpful. May I suggest to create a series on statistics using Python and Pandas? Thanks!

@Blazzzerr 5 месяцев назад

I love your videos they help me in my study ❤

@AI-Health-posts 4 года назад

many thanks sir. dont worry about hte lenght ..... everything from you is acceptable

@YeekyYeeky 4 года назад

best tutorial video , thank you very much , longer video is ok

@Buyankhishig169 8 месяцев назад

thank you so much!

@mohit7717 3 года назад

You are best sir i seen most of the lecture ,please upload more on related to data science courses , Thanks a lot sir

@quantumCollapses 2 года назад

i don't know when you gonna read my comment, but believe it you're an awesome teacher ever!!!! You always tried to make videos useful and simple to understand even if someone wouldn't able to know English correctly, he can understand your teaching way. love from Afghanistan ❤

@kankipatihemanth4156 3 года назад

Hello Corey, could you do series on machine learning tutorials. Many people would highly appreciate that! Python tutorials are awesome.

@MrLiohman 3 года назад

Hey Corey, I thought that you'll skip the joke about 2 mil salary, but no you did it. Kudos to you! Also, thanks you putting in all the effort in making these pandas tutorials. If lady luck get on my side and I start billion dollars company I shall probably hire you on a competitive salary (say 2 million). Cheers!

@jaitiwari241 2 года назад

Sir u r great.. Please Also make a series on statistics for data science

@richardfichera2971 4 года назад

Adding to the chorus here - make each section as long as you think you need to for the material you want to cover. As others have noted, there are pause and fast forward controls for us to use to play with. BTW, haven't downloaded the data yet, but as the sorted rows scrolled by, it looked like the $2M comp people entered annual salaries and indicatee they were weekly, which would convert to a very high annual salary.

@tomchandler2356 4 года назад

Hi Corey, love your videos. Can you please do video on async/await/asyncio.

@debatradas1597 2 года назад

thank you so much

@guyindisguise 4 года назад

Does shorter videos mean more videos? Because I like whichever option gives us more total content. ;) PS: another great video. I've used Pandas for a project in the last few days and your videos have been a tremendous help. Thx Corey

@letsjoinhands 2 года назад

Hi Corey. I don't who gave you the idea to cut videos to a shorter time but your longer videos were excellent as well. Your grasp of the subject and it's concepts is so good that one forgets how long the video is. And how you chain it all together and present it is marvelous. Anyway what I wanted to say was that if a longer video has sub-topics for which we can see the time range does it even matter if it's long?? You have a fan here in Karachi, Pakistan btw. Stay cool and stay blessed.

@khahmed4752 4 года назад

You are the best

@omeryazici5318 Год назад

Thanks a lot

@KevinTempelx 3 года назад

Thanks!

@stressfreetrading1341 4 года назад

Love From India

@vamsikrishna4107 3 года назад

Thankyou ❤

@rodhash 3 года назад

Sir your vids are insanely good I wouldn't care if they get 4h long .. you're doing such an outstanding job here and people still complain.. that's crazy .. btw those 2M a year seems weird, dont they? I mean, many entries like that.. Is this just me or it seems buggy data?? Or perhaps people trolling in the survey

@aayushkhandelwal3909 4 года назад

Thank you so much Man : ) : )

@CatBlack01 3 года назад

Hi Corey, great series! At 6.21 when sorting one column I'm curious as to why 3 Doe is at the top, is it because we'd previously overwritten the original df with the sort by last and first?

@mehdi-vl5nn 4 года назад

Please cover topics like async await sync(first comment btw)

@mahery_ranaivoson 4 года назад

Would it possible to follow this one by grouping techniques and visualization? Thanks

@mithghosh2839 2 года назад

Thank you...

@Thou_art777 Год назад

God bless you Corey

@maciekpaciarski9343 4 года назад

Do you have plans to do metaprogramming and abstract classes tutorials in the near future? Respect for existing materials.

@rohanlimaye1873 4 года назад

Fab!

@lyricathelyricsworld8945 3 года назад

Hey sir, We mainly need knowledge, so let video be long or short, it doesn't matter for gaining the knowledge. So please make videos irrespective of the timeline. Thank you......

@shobhitsadwal756 2 года назад

hello,can anybody help me with a small doubt actually i am trying to sort two columns , the "first" column is name and the "last" column contains integers , i have executed the command dff.sort_values(by=["first","last"],ascending=[False,True]) but i can only see change in the first column , the second column is not sorting in ascending order. what should i do?

@vyishakdl3950 3 года назад

if we set the data on he basis of first the index wiil be jumbeled what should we do keep the sort on the basis of first but the index should be in order

@KonradTamas 10 месяцев назад

Great video! Although as a noob, I dont understand how we could sort multiple columns at the same time, because in my mind a Row = an Entry of data. So if we mess up the Row's data by arranging the columns in multiple ways. How we dont mess up the whole data and their Entries ???

@finnmccool8671 4 года назад

Hi Corey. A way off topic question. Do you ever use inline CSS in markdown cells in Jupyter notebooks for presentation purposes? I mean something like this: Introduction Or is there a way to apply a CSS style sheet for the whole notebook?

@usern2473 Год назад

Hey Corey Can you share videos on : data comparison b/w two dataframes using pandas data comparison b/w two dataframes having some complex logics

@geraldhoxha 4 года назад

Bro your tutorials are perfect. Can you make a video about django class based views? Thanks bro

@diaz9755 3 года назад

Love your accent :)

@pankajvasudeva1952 4 года назад

First of all thanks to you for sharing this knowledge. I am new in Python and starting working on excel files using pandas. In my code I have to read multiple files ,then to combine I am taking one sheet as master and looping through its values and finding other database. But it makes my code very slow and it took around 01:00 hour to complete all code. How can I make it faster.

@AugustoGeografo 4 года назад

Dear, Corey Would it be possible for you to develop a tutorial on how to use locale through the data Analysis workflow? It's not adequate for us who live outside English speaking countries to present reports with float points instead of float commas. Nonetheless, the intricacies of using locale with pandas and matplotlib are not well covered in any course in English.

@Worldnme 3 года назад

make a series on Tensorflow and Keras please

@atulkumar7030 4 года назад

How to get only selected columns like country and careerstats on using nlargest? right now using df we get entire df but I need only a particular column

@ShivamGupta-wn9mo 3 месяца назад

great

@bakihussain4231 4 года назад

Please make your videos long and more detailed, I m pretty sure most of us here love the details of why an error is going to happen/not.

@Diallo268 3 года назад

So I just found out and I thought I'd share it. You can run a Jupyter notebook in VS code. Ctrl+Shift+P and open 'Python: Open Start Page'. If you don't see it there you probably need a plugin.

@operationelderscrolls1694 3 года назад

I think what happened with the salaries is that people chose the wrong compensation frequency. You can see that the top person answered 65,500 $ which is quite realistic, however he/ she chose a weekly compensation frequency. This would translate to 3.4 million USD annually which I think we can all agree is rather optimistic for a developer.