- Python Pandas Tutorial (Part 7): Sorting Data

Python Pandas Tutorial (Part 7): Sorting Data

In this video, we will be learning how to sort DataFrames in Pandas.

This video is sponsored by Brilliant. Go to https://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, w...
In this video, we will be learning how to sort DataFrames in Pandas.

This video is sponsored by Brilliant. Go to https://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:
http://bit.ly/Pandas-07

StackOverflow Survey Download Page - http://bit.ly/SO-Survey-Download

✅ Support My Channel Through Patreon:
https://www.patreon.com/coreyms

✅ Become a Channel Member:
https://www.youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g/join

✅ One-Time Contribution Through PayPal:
https://goo.gl/649HFY

✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot

✅ Corey's Public Amazon Wishlist
http://a.co/inIyro1

✅ Equipment I Use and Books I Recommend:
https://www.amazon.com/shop/coreyschafer

▶️ You Can Find Me On:
My Website - http://coreyms.com/
My Second Channel - https://www.youtube.com/c/coreymschafer
Facebook - https://www.facebook.com/CoreyMSchafer
Twitter -
Instagram - https://www.instagram.com/coreymschafer/

#Python #Pandas

#python #pandas #sorting #pandas sorting #sort_values #sort_index #pandas sorting tutorial #data science #python pandas #data analysis #python pandas tutorial #pandas dataframe #python tutorial #corey schafer #python (programming language) #python programming #pandas sort descending #pandas sort multiple #pandas sort by two columns #pandas sort columns by values
Intro: - Python Pandas Tutorial (Part 7): Sorting Data

Intro:

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:00:00 - 00:00:53
- shorter videos? Are you mad people? Guy is giving his time to teach everyone just for free, and there are people asking to shorten the videos XDD? - Python Pandas Tutorial (Part 7): Sorting Data

- shorter videos? Are you mad people? Guy is giving his time to teach everyone just for free, and there are people asking to shorten the videos XDD?

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:00:28 - 00:15:40
Recap: - Python Pandas Tutorial (Part 7): Sorting Data

Recap:

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:00:53 - 00:01:02
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  hour to complete all code. How can I make it faster. - Python Pandas Tutorial (Part 7): Sorting Data

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 hour to complete all code. How can I make it faster.

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:01:00 - 00:15:40
Sort by Column: `sort_values()`:  (`df.sort_values(by='col1', ascending=False)`) - Python Pandas Tutorial (Part 7): Sorting Data

Sort by Column: `sort_values()`: (`df.sort_values(by='col1', ascending=False)`)

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:01:02 - 00:02:05
Sort by Multiple Columns:  (`df.sort_values(by=['first_col', 'second_col], ascending=False)`)- Useful when first column has duplicate values and second column has different values - Python Pandas Tutorial (Part 7): Sorting Data

Sort by Multiple Columns: (`df.sort_values(by=['first_col', 'second_col], ascending=False)`)- Useful when first column has duplicate values and second column has different values

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:02:05 - 00:04:00
() you: "adam"me: "west"you: "doe"me: "oh, yes, yes of course. :)" - Python Pandas Tutorial (Part 7): Sorting Data

() you: "adam"me: "west"you: "doe"me: "oh, yes, yes of course. :)"

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:03:36 - 00:15:40
Sort by Multiple Columns, First Column one way, Second another way:  (`df.sort_values(by=['first_col', 'second_col], ascending=[False, True])`) - Python Pandas Tutorial (Part 7): Sorting Data

Sort by Multiple Columns, First Column one way, Second another way: (`df.sort_values(by=['first_col', 'second_col], ascending=[False, True])`)

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:04:00 - 00:06:17
Real-World Data Practice: - Python Pandas Tutorial (Part 7): Sorting Data

Real-World Data Practice:

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:06:17 - 00:10:21
- ASIDE: Get Largest/Smallest Values (`nlargest()`):  (`df['col'].nlargest(10)`;`df.nlargest(10, 'col')`; `df.nsmallest(10, 'col')`) - Python Pandas Tutorial (Part 7): Sorting Data

- ASIDE: Get Largest/Smallest Values (`nlargest()`): (`df['col'].nlargest(10)`;`df.nlargest(10, 'col')`; `df.nsmallest(10, 'col')`)

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:10:21 - 00:13:08
because it is not in USD lol - Python Pandas Tutorial (Part 7): Sorting Data

because it is not in USD lol

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:11:29 - 00:15:40
@  haha, let me know if there's another vacancy :P - Python Pandas Tutorial (Part 7): Sorting Data

@ haha, let me know if there's another vacancy :P

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:11:40 - 00:15:40
do not worry many zeros do not have any values, hahaha - Python Pandas Tutorial (Part 7): Sorting Data

do not worry many zeros do not have any values, hahaha

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:11:45 - 00:15:40
at  How can I get only particular columns like Country and Hobbyist for nlarget(10) using a filter? - Python Pandas Tutorial (Part 7): Sorting Data

at How can I get only particular columns like Country and Hobbyist for nlarget(10) using a filter?

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:12:25 - 00:15:40
Outro: - Python Pandas Tutorial (Part 7): Sorting Data

Outro:

Python Pandas Tutorial (Part 7): Sorting Data
2020年02月06日 
00:13:08 - 00:15:40

Corey Schafer

※本サイトに掲載されているチャンネル情報や動画情報はYouTube公式のAPIを使って取得・表示しています。

Timetable

動画タイムテーブル

動画数:234件

the future spoken is my current present. Unless I'm completely desperate, I'm not hitting reddit or google/stack overflow for most roadblocks. - How to Use ChatGPT as a Powerful Tool for Programming

the future spoken is my current present. Unless I'm completely desperate, I'm not hitting reddit or google/stack overflow for most roadblocks.

How to Use ChatGPT as a Powerful Tool for Programming
2023年05月22日  o k t o b e r 様 
00:12:22 - 00:31:08
Good video as always😉  I remember asking that too lol - How to Use ChatGPT as a Powerful Tool for Programming

Good video as always😉 I remember asking that too lol

How to Use ChatGPT as a Powerful Tool for Programming
2023年05月22日  kami 様 
00:28:19 - 00:31:08
@ - pure gold, pure gold! <3 - How to Use ChatGPT as a Powerful Tool for Programming

@ - pure gold, pure gold! <3

How to Use ChatGPT as a Powerful Tool for Programming
2023年05月22日  ulf gjerdingen 様 
00:28:26 - 00:31:08
You almost had me there haha! ChatGPT can be wrong but it certainly wasn't wrong about those top notch resources! I massively appreciate all the uploads and I hope they keep coming supercharged with Chat GPT. Thanks to you, sentdex, techwithtim and Dennis Ivy I now know how to properly code on python, use git for version control and build a functional website. - How to Use ChatGPT as a Powerful Tool for Programming

You almost had me there haha! ChatGPT can be wrong but it certainly wasn't wrong about those top notch resources! I massively appreciate all the uploads and I hope they keep coming supercharged with Chat GPT. Thanks to you, sentdex, techwithtim and Dennis Ivy I now know how to properly code on python, use git for version control and build a functional website.

How to Use ChatGPT as a Powerful Tool for Programming
2023年05月22日  Uj Vag 様 
00:28:42 - 00:31:08
and it's  am here (south east asia), and idk why I'm watching a python tutorial rather than sleeping 😂 - Python Tutorial: Simulate the Powerball Lottery Using Python

and it's am here (south east asia), and idk why I'm watching a python tutorial rather than sleeping 😂

Python Tutorial: Simulate the Powerball Lottery Using Python
2023年01月10日  X 様 
00:02:49 - 00:38:56
… nice… 😂 - Python Tutorial: Simulate the Powerball Lottery Using Python

… nice… 😂

Python Tutorial: Simulate the Powerball Lottery Using Python
2023年01月10日  Bartosz Turkowyd 様 
00:04:50 - 00:38:56
I've seen every Python video you've made....   first innuendo. 😜 - Python Tutorial: Simulate the Powerball Lottery Using Python

I've seen every Python video you've made.... first innuendo. 😜

Python Tutorial: Simulate the Powerball Lottery Using Python
2023年01月10日  Martin Beaudry 様 
00:04:52 - 00:38:56
Man it's  am in India I am lucky to be the first one to hear your voice god bless you brother and an awesome teacher. - Python Tutorial: Simulate the Powerball Lottery Using Python

Man it's am in India I am lucky to be the first one to hear your voice god bless you brother and an awesome teacher.

Python Tutorial: Simulate the Powerball Lottery Using Python
2023年01月10日  Big Samosa 様 
00:12:15 - 00:38:56
# you can also use the built-in pprint module for pretty printing dictionaries ;) - Python Tutorial: Simulate the Powerball Lottery Using Python

# you can also use the built-in pprint module for pretty printing dictionaries ;)

Python Tutorial: Simulate the Powerball Lottery Using Python
2023年01月10日  Schoenling Wunderbar 様 
00:25:00 - 00:38:56
it would be very interesting to see if there could be a step function where this algorithm can simulate the increases in jackpot winnings. It’s going to be one in 292+ million of a chance that you hit it at all much less multiple times, but the code should be interesting to see. - Python Tutorial: Simulate the Powerball Lottery Using Python

it would be very interesting to see if there could be a step function where this algorithm can simulate the increases in jackpot winnings. It’s going to be one in 292+ million of a chance that you hit it at all much less multiple times, but the code should be interesting to see.

Python Tutorial: Simulate the Powerball Lottery Using Python
2023年01月10日  20 80 様 
00:27:43 - 00:38:56
A OAuth Django video would be awesome!(Applicable to all sorts of OAuth situations, not just the YouTube API.) - Python YouTube API Tutorial: Using OAuth to Access User Accounts

A OAuth Django video would be awesome!(Applicable to all sorts of OAuth situations, not just the YouTube API.)

Python YouTube API Tutorial: Using OAuth to Access User Accounts
2020年09月10日 
00:07:58 - 00:43:21
At  you move the file and see some blurred miniature version of your open folders in the dock. How did you enable that? - Python YouTube API Tutorial: Using OAuth to Access User Accounts

At you move the file and see some blurred miniature version of your open folders in the dock. How did you enable that?

Python YouTube API Tutorial: Using OAuth to Access User Accounts
2020年09月10日 
00:09:58 - 00:43:21
In case you are getting Error 403 ("access_denied The developer hasn’t given you access to this app") go to the OAuth consent screen and under Test Users add your email by clicking on Add Users.  You should be able to grant access after you've added User. - Python YouTube API Tutorial: Using OAuth to Access User Accounts

In case you are getting Error 403 ("access_denied The developer hasn’t given you access to this app") go to the OAuth consent screen and under Test Users add your email by clicking on Add Users. You should be able to grant access after you've added User.

Python YouTube API Tutorial: Using OAuth to Access User Accounts
2020年09月10日 
00:19:36 - 00:43:21
@corey  So why did you add the join function here, when appending the video id to the list its already a list and its working for me when I pass the vid_ids directly - Python YouTube API Tutorial: Calculating the Duration of a Playlist

@corey So why did you add the join function here, when appending the video id to the list its already a list and its working for me when I pass the vid_ids directly

Python YouTube API Tutorial: Calculating the Duration of a Playlist
2020年06月11日 
00:11:24 - 00:37:38
TypeError: expected string or bytes-like object, I am taking this error in , any idea? - Python YouTube API Tutorial: Calculating the Duration of a Playlist

TypeError: expected string or bytes-like object, I am taking this error in , any idea?

Python YouTube API Tutorial: Calculating the Duration of a Playlist
2020年06月11日 
00:18:50 - 00:37:38
(I love that "Whoops that went too well"-moment at  :D) - Python Tutorial: Real World Example - Using Patreon API and Pillow to Automate Image Creation

(I love that "Whoops that went too well"-moment at :D)

Python Tutorial: Real World Example - Using Patreon API and Pillow to Automate Image Creation
2020年05月11日 
00:35:19 - 00:52:33
Read CSV - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Read CSV -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:00:56 - 00:03:20
Write CSV - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Write CSV -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:03:20 - 00:04:40
Write TSV - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Write TSV -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:04:40 - 00:06:00
Read TSV - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Read TSV -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:06:00 - 00:06:15
Write Excel - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Write Excel -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:06:15 - 00:10:42
Read Excel -  (Start at 6:15 to see installed packages) - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Read Excel - (Start at 6:15 to see installed packages)

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:10:42 - 00:12:18
Write JSON - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Write JSON -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:12:18 - 00:15:41
Read JSON - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Read JSON -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:15:41 - 00:16:59
Write SQL - - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Write SQL -

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:16:59 - 00:24:57
# Just in case:If you are using sqlite3 instead of sqlalchemy, you have to use SQL string not the table name: - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

# Just in case:If you are using sqlite3 instead of sqlalchemy, you have to use SQL string not the table name:

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:24:57 - 00:32:45
Read SQL -  (Start at 16:59 to see installed packages) - Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc

Read SQL - (Start at 16:59 to see installed packages)

Python Pandas Tutorial (Part 11): Reading/Writing Data to Different Sources - Excel, JSON, SQL, Etc
2020年04月02日 
00:24:57 - 00:32:45
Corey Ception - Live Stream - Chat, Q&A, Brews, and Coding

Corey Ception

Live Stream - Chat, Q&A, Brews, and Coding
2020年03月24日  MLittle Programming 様 
00:00:03 - 01:01:21
Ah, I missed the stream :(..  VIM! haha but seriously, I'm a recent convert to vim. It's powerful and efficient. - Live Stream - Chat, Q&A, Brews, and Coding

Ah, I missed the stream :(.. VIM! haha but seriously, I'm a recent convert to vim. It's powerful and efficient.

Live Stream - Chat, Q&A, Brews, and Coding
2020年03月24日  stuart 様 
00:02:35 - 01:01:21
Youtube premium is ad-free. - Live Stream - Chat, Q&A, Brews, and Coding

Youtube premium is ad-free.

Live Stream - Chat, Q&A, Brews, and Coding
2020年03月24日  stuart 様 
00:21:00 - 01:01:21
I knew that, but...😆 - Live Stream - Chat, Q&A, Brews, and Coding

I knew that, but...😆

Live Stream - Chat, Q&A, Brews, and Coding
2020年03月24日  Deepam Gupta 様 
00:41:25 - 01:01:21