Excel SUMIFS, COUNTIFS & AVERAGEIFS in PYTHON (Pandas Library)

Показать описание

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This video will show you, how to perform the Excel functions: SumIf(s), CountIf(s) & AverageIf(s) in Python. In particular, we will be using the Pandas library & the query method.

📝 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀:
Download the files from the tutorial here [Google Drive]:

◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
👩‍💻 𝗦𝘂𝗺𝗜𝗳𝘀 𝗲𝘅𝗺𝗮𝗽𝗹𝗲:
import pandas as pd # pip install pandas

# Sum of all tips on Sunday's during Dinner Time
day = 'Sun'
time = 'Dinner'
sumifs

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

Рекомендации по теме

Комментарии

*Which Excel formula would you like to see next (in Python)?*

CodingIsFun

Short crisp precise thanks alot making excel automation more fun

sureshgoku

Thank you very much, as always you deliver beyond our expectations.

ermalgashimramori

Great Buddy! Speaking from Brasil. Thanks for taking your time sharing your knowledge!

wagnerbarbosa

what if I want to create a new column containing the sum for each Unique value in another column as opposed to summing only "Germany" for instance... say I want a column with a sum for every country listed (assuming the number of countries is too long to list).

davida

Excellent presentation.
Now, question is how would you present the results in a nice report simular to the attached excel formula sheet ?

edbull

What if I want the columns that displays the sumifs, countifs and averageifs in the raw dataset? How can I perform it?

SnkRobertoHz

Hi,

Is it possible to convert below the input

Customer_Name, Product_1, Price_1, Product_2, Price_2
Zayn, Milk, 30, Chocolate, 40
Peter, Cheese, 190, Oil, 80
Andrew, Coconut, 10, Milk, 60
Dwayne, Soya, 100, Butter, 120

to this output where the Product name should be ascending and it should also have its price in the next column

Customer_Name, Product_1, Price_1, Product_2, Price_2
Zayn, Chocolate, 40, Milk, 30
Peter, Cheese, 190, Oil, 80
Andrew, Coconut, 10, Milk, 60
Dwayne, Butter, 120, Soya, 100

Can you please help

hayathbasha

Excel SUMIFS, COUNTIFS & AVERAGEIFS in PYTHON (Pandas Library)

How to Use SUMIFS, COUNTIFS and AVERAGEIFS in Excel (Multiple Criteria)

Excel SumIfs, CountIfs, AverageIfs Analyze & Filter Add-in

Excel 2016: SUMIFS, COUNTIFS And AVERAGEIFS Functions

Excel for beginners: SUMIFS, COUNTIFS and AVERAGEIFS - how to use these functions

Excel Top 6 Function : SUMIF,SUMIFS,COUNTIF,COUNTIFS,AVERAGEIF,AVERAGEIFS

Advanced Excel Video Training | 006 | Using COUNTIFS, SUMIFS, AVERAGEIFS in Excel

Excel Tutorial - COUNTIF, SUMIF, and AVERAGEIF functions

Excel SUMIFS, COUNTIFS & AVERAGEIFS (Multiple Criteria Alternative to SUMIF, COUNTIF & AVERA...

How to use the SUMIF function in Microsoft Excel

Multiple criteria in Excel SUMIFS/ COUNTIFS/ AVERAGEIFS

Excel SUMIFS, AVERAGEIFS & COUNTIFS Formulas (Multiple Criteria)

Excel SUMIFS, COUNTIFS & AVERAGEIFS in PYTHON (Pandas Library)

AVERAGEIFS, COUNTIFS, & SUMIFS Functions in Excel

Excel MAXIFS MINIFS COUNTIFS SUMIFS AVERAGEIFS

Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria

Excel Tips - Tip#36: SUMIFS / COUNTIFS / AVERAGEIFS

Excel Conditional Aggregate Functions (COUNTIFS, SUMIFS, AVERAGEIFS)

SumIf, SumIfs, CountIf, & CountIfs Functions | Excel

Microsoft Excel : Count Countif Countifs Sum Sumif Sumifs || Hindi || Quikr Exam

MS Excel - SUMIFS, COUNTIFS, AVERAGEIFS functions with examples. #msexcel #msexcelforbeginners

Excel COUNTIFS, SUMIFS, & AVERAGEIFS (tutorial + examples)

How to get Excel’s Sumifs, Countifs or Averageifs in Power BI

Unlock the Power of Excel with SUMIFS, COUNTIFS, and AVERAGEIFS! 🚀

Excel Sumifs Countifs Averageifs