My top 25 pandas tricks

THANKS for watching! 🙌 Which trick are you most excited to start using? CLICK REPLY and let me know!

I liked it to see someone who puts their cam much above their face level baing successful on YT

This video helped me so much. Thanks a lot :))))

This is a nice vid! When I was learning clojure someone had compiled a '100 most used functions' and boy would I love that for pandas functions or methods: the docs are too extensive but tutorials are typically too brief.

Amazing! Thank you!

great content!

all tricks superb, continue good work🎉

Your contents are to the point, your teaching style is exceptional. I am learning so much from your videos. Thank you!

Awesome 👌

It is one of the best videos on Pandas. I really love some of the tricks e.g., the Clipboard', and 'The Excel copy & paste ones.

Excellent content!!!

The way you speak is outstanding. English is not my first language, and you speaking is so steady and calm.
thanks a lot

Awesome video!! I'm in the process of learning Pandas/Python for a new job coming from SQL/SAS coding languages.
I have one question in regards to tip 18.Aggregate by multiple functions.
How do you do this in-conjunction with a if / then statement? For example, group by order_id only if quantity = 1? sum the the item_price.

Thanks a lot i need to resolve duplicates and wrong names in a excel file, and i don’t understand how on 53k rows, but… i will try it this can help me,

Make Pandas really Interesting

Thanks a lot. I learnt and liked the new tricks below:
The apply function
Using ufo.isna().mean() to find percentage of missing values.
Using the transform function combined with the groupby function reminded me of SQL Windows Functions
pd.cut was good to help convert a continuous data into a categorical one.
The fancy display option was an added bonus.

Thanks for your videos! Is there a way I can make a donation without using Google Pay?

Thank You For making US Advanced

I was revisiting dataschool video's. In my view these are still one of the best resources out there. Thanks a lot ...

Hi sir, i am unable to join as membership...
It will better for us if you put GPay options also.

Can you suggest method to store each row in a data frame as a seperate text file and keep save file name name as their value in the fist colum of that row.

Gret video series! I've watched 35/38, and I've learned a lot! 👍🎉
Regarding tip 18&19 I think you forgot to multiply with quantity.
E.G. order_id #2 should have a total of 2x16.98 = 33.96

5*** Rated -like the bonus trick , 23& 14 as welll

Thank You So Much For Wonderful Trick I am New To Data Science For Sure This Will Help Me

This is one of the most useful coolest videos about Pandas I have ever watched. Thank you sooooo much for compiling all these tips and tricks! Absolutely amazing!!!!!!

Best pandas video ever!

I'm so glad I chose to click on this video. Thank you for this amazing video!

btw, the github link does not work. thanks for the video though

the best guy in this business!!!

pipe() for debugging is always nice

What does expand="True" do while splitting a string in multiple columns in trick no 16?

u r awesome as always! Dont know ur name!

What does .info(memory usage="deep") mean?

👍🏻

Nice tricks

Thank you for all these tricks.

brilliant

Saprotams skaidrojums👍

thanks! But I am getting errors for 24. No tricks. My error is "ValueError: Invalid format specifier"

Tnx. The .style.format(dict) is a game changer. I used to convert my parameters to ensure a fixed number of parameters would show up well, i.e convert a fraction to a percentage. Not sure why this had never been mentioned in the many videos I have watched before.

25: styling a DataFrame:
I had to convert Date to numeric before styling it.
pandas 1.4.0

"... and impress your friends" 🤣🤣🤣

I'm the only nerd in my circles so this won't work

Trick #9: I want to keep filenames in one column too when reading multiple files. What should I do?

Great video but I won't be able to forget Kevin's eyes that starred into my soul xD

Hi Kevin, awesome video!
I wanna ask something related to trick #25 (Styling Dataframe):
I got the code working well with the number formatting, however when I transpose the table, all the style formatting is gone.
how to make the style formatting stick even when we apply transpose?

Thanks a lot! It's a great video!

Most of the people who suggested the tricks are indians

Great collect ion for beginners as well as those who has been in the game for a while 🙂👍

Not too much but...
It's Amazing!! Thank you so much!