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

Опубликовано: 17 Апрель 2021
на канале: Derrick Sherrill

15,335

695

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:
https://github.com/Derrick-Sherrill/D...

Kite helps fund the channel, thanks for checking them out and supporting me --
https://www.kite.com/get-kite/?utm_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 --
https://derricksherrill.store/
Support the Channel on Patreon --
  / derricksherrill
Join The Socials --
Reddit -   / codewithderrick
FB -   / codewithderrick
Insta -   / codewithderrick
Twitter -   / codewithderrick
LinkedIn -   / derricksherrill
GitHub - https://github.com/Derrick-Sherrill
*****************************************************************
Full code from the video:
https://github.com/Derrick-Sherrill/D...

import pandas as pd

df = pd.read_excel('OrderHistory.xlsx')
df = df.sort_values(by='Order ID', ascending=True)
print(df.head(10))

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

simplified_df = df.groupby('Order ID').agg(agg_functions)
simplified_df.to_excel('simplified_order_history.xlsx')

multiple_item_orders = simplified_df[simplified_df['Order Type'].str.contains(',')]
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:
https://github.com/Derrick-Sherrill/D...

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:
https://www.derricksherrill.com/

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?
Atom - https://atom.io/

What Equipment do you use to film videos?
https://www.amazon.com/shop/derricksh...

What editing software do you use?
Adobe CC - https://www.adobe.com/creativecloud.html
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!
https://www.udemy.com/user/derrick-sh...

Where do I get my music?
I get all my music from the copyright free Youtube audio library
https://www.youtube.com/audiolibrary/...

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!