Top Five Pandas Functions for Data Scientists (And How to Use Them)

Hey everyone. Quick video on what I think are the top five most useful pandas library methods for data analysis. Mastering these will take you a long way in your projects.

5. Import / Output Methods
4. Data Selection
3. Boolean Selections
2. Concat
1. GroupBy

Let me know what I left out!

4640 + Subscribers at the time of writing. How awesome. Thank you all for your continued support. It means the world to me! Thank you for watching my content.

Join The Socials -- Picking Shoutouts Across YouTube, Insta, FB, and Twitter!
*****************************************************************
Full code from the video:
import pandas as pd

print(df)

print(df[df['Title'] =='Engineer'])

print(df3)

print(total_count['Name'])

Packages (& Versions) used in this video:
Python==3.7
Pandas==0.25.0

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Check out my website:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!!

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

[awalhashim]

I am very grateful to come across your channel. Keep up the good works. Thanks

[saravana]

Hi Derrick Sherrill, Keep posting..thanks for your effort and time..i like your videos more because i am new to pandas and know basic, so your video is sharp, no unwanted words, short and also clarify my doubts what i had in my previous learning!! Great..

[cidfidchris]

Thanks for the amazing videos!!! defo the best ones I have come across... keep up sharing your knowledge!!!

[amensanghera]

Your videos are great dude, keep up the good work! 😁

[MyJules]

Many thanks for making this sound so easy

[cryptomugen]

Awesome videos. Always learn something new with your easy to understand tutorials. Can you do a datetime tutorial when you have time? I'd like to learn how to get data based on dates. e.g. create df with date range.

[felipelandim]

Very good for such a short video. Nice.

[martin-xqte]

Great set of videos. Have you thought about producing a pdf of useful tips? A pdf going over a useful project would be very useful and at the correct price could make you money.

[wisjnujudho]

I imagine doing this on excel.
And, i think we need more advance/extreme scenario/case on these 5 function. (e.g multiple condition)

[justpourlapai]

Thank you for your videos!!! How it is possible to split for example name and first name in two news differents columns?

[haiderali]

Thanks i have learnt so much fun your pandad video tutorial.
Currently i am stuck in a situation.

I am filtering some non na vales from column C and i want to copy those non.na vales to another existing column A without effecting other elements in it.

When i copy, the complete column copy.

Can you help?

[hopezhang]

Thanks Derrick, your videos are great! Simple and efficient!
I wonder how do we use Python for the Vlookup function in excel? The general office population use Vlookups and Pivots a lot. Thanks!

[CornerSeat]

Hi..your videos are awesome..
Please post a video for ..how to insert empty rows at the top of the CSV file using pandas

[rajeevmenon]

Your videos definitely is too good. When I see you coding I understand everything and feel very easy but when I sit to do it, I don't remember. How do I ensure I remember ?

[ajaypyakurel]

Thanks for handy video.
I have a question
I import excel data which contain different earthquake data as date, magnitude and location
Now i need to count the no of earthquake that has magnitudes in between 5 and 6
So how can i do that counting?

[johndoe]

Derrick, that may sound stupid, but how did you configure your VSC that things like "import", "read_excel", etc. are highlighted with other colors than rest of the code? I had some problems with configuring VSC to read pandas (import error with pylint) so, am not so good with preparing my tools :V

[anisaali]

do you have a video that shows us to install Pandas?

[allegro]

For some reason when in command prompt I enter 'python3 [name of the file]' an error message pops up saying
"'python3' is not recognized as an internal or external command,
operable program or batch file."
could you please shed some light on this? I am using windows 10 home, anaconda, visual studio code.

[gregquitevis]

How do I install pandas. Im using a mac and same setup as you.

[junaidmalik]

Man, I am surprised to see Just 200 Likes for content like this. may be the World falls for sense less presentation and not the real stuff.