Level Up Python Pandas GroupBy | Five Minute Python Scripts | Subscriber Request

Thanks for your suggestions keep them coming!!

0:00 introduction
0:12 viewing the data
0:59 reading in data
1:59 groupby
4:24 writing new workbook
5:17 Conditional Index

Data used in this video:

Kite helps fund the channel, thanks for checking them out and supporting me --
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing.

Merch Store --
Support the Channel on Patreon --
Join The Socials --
*****************************************************************
Full code from the video:

import pandas as pd

agg_functions = {
'Sales Amount' : 'sum',
'Order Type' : ', '.join,
}

print(multiple_item_orders)

Packages (& Versions) used in this video:
Pandas 1.2.4

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

Still wild I get to write these messages and get blown away by the number of people who liked a video enough to subscribe. Thank you to all 62,500 of you! Thanks for watching and hopefully the videos are helpful. Thank you all so much!

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

--- Channel FAQ --

What text editor do you use?

What Equipment do you use to film videos?

What editing software do you use?
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!

Where do I get my music?
I get all my music from the copyright free Youtube audio library

Let me know if there's anything else you want answered!

-------------------------

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

[qpeilcd]

Hello Brother! I speak of Brazil, please do not stop posting your tutorials, as they help me a lot on a daily basis. If you can add more Python automation tutorials in Excel, thanks. Thank you very much!!!

[loveSG]

Using a dictionary to designate various functions to the relevant columns of a DataFrame via the agg() component of groupby function - this is by far the most intelligent approach I've ever seen on YouTube! Your teaching / communication style is always clear, concise but the same time thorough enough for us to grasp the concept and logics behind each operation you demonstrate ! It's truly amazing to see how you have always managed to pack all the detailed explanation and super useful tips into these short video tutorials, and we certainly need more of your masterpieces on your channel!

[TomMattle]

Thanks so much for doing this! I’m trying to learn more about python as I’m very much into data and these tutorials are so helpful!

[imrankhandsce]

Your way of teaching is quite simple to understand way to go brother 👍

[helikopter]

Derrick, you are a star! I've been avoiding pandas like the plague and I've been using exclusively some internally developed stuff but you are making me actually like pandas. Thanks a lot !

[hakeem]

Awesome, you directly heading to the point, , i like this kind of teaching (no extra talk, get the most out of it)

[legarspierre]

Hi Derrick, your content is really great, straight to the point and we'll explained. Thanks for sharing it !
Which method would you consider using to reduce the size of a rather large list of thumbnails stored in a data
base by a certain percentage ?
Until next time !

[vio-noob_]

Your tutorials are the best. Had no clue you can do a dictionary of agg functions like that.

[alicemystery]

this is a good video answering a question. it really does show you the power of python pandas on data frames.

[hussamalh]

Thanks D, great video as usual learned a lot from you over the months i really appreciate your efforts. One video suggestion that I tried to create myself but failed is to create customer scanner in python to scan for MACD divergence. If you manage to do that you will be the only one on YT that have it such

[pawanramuk]

Thank you so much for these vids. They are really practical and easy to follow.

[CurrentElectrical]

Looking forward to seeing more Pandas replacing excel videos. Thank you!

[jackzero]

Thanks Derrick, awesome tips!, need more...

[Mrsilk]

Thank you so much for these awesome vids, it really helped me a lot in my job!

[sacredinclinations]

congratulations Derrick I love your videos, if I could buy shares in you I would! (maybe that is the next internet thing). I reckon your channel will grow, God willing.

[Howmygamerun]

We need more tutorials, your content are amazing and clarify. A hug from brazil.

[uzhxcgm]

Even tho i am no big fan of python i have your channel on see first just to support quality content, keep it up bro (y)

[patrickwheeler]

Thanks Derrick this is fantastic stuff

[Ramadasi]

Hi..
Thank you for all the informative videos you’ve been creating.
Can you please also educate us on Data-science

[tareqmahmud]

Hi, you make the greatest theoritical videos ever..!
Would you please cover a video on Mini Max Algorithm on Python please? :)