Python Pandas Aggregation Tutorial | How to use 'groupby' in Pandas | Data Analysis with Pandas

In this video we will learn how to group by and aggregate data with pandas.
We will also plot aggregated data on a bar chart.

Use this data to import in pandas
======================================================
order_id,product_name,category,city,sales,profit
CA-2020-152156,p1,Furniture,Bangalore,10000,500
CA-2020-138688,p2,Furniture,Bangalore,20000,400
US-2019-108966,p3,Technology,Chennai,25000,200
CA-2021-114412,p4,Office Supplies,Chennai,30000,250
CA-2020-161389,p5,Technology,Bangalore,35000,800
US-2019-118983,p6,Office Supplies,Bangalore,40000,700
======================================================
Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataengineer

[shreyashkhurud]

Best explaination found so far !
Thank You sir!

[damoncaffrey]

Mean will also work in groupby's agg function if you put it under colons like this :
: "mean", "profit" : "max"})

[shaileshsingh]

crisp and clear !!!! please can you advise a roadmap to learn Python (any good online platform/course/book/GitHub )

[sravyasrinivas]

This is super useful for data analysis. Waiting for this one for a long. Thank you so much

[aashishmalhotra]

We can find mean by importing Numpy and then use np.mean
df.groupby('Team').agg({'Salary':np.mean, 'Age':max})

[vedprakashshukla]

Really informative videos Sir Kindly make a playlist on Python like your SQL.

[hugodaniel]

Wow didnt know those panda functions, thank you

[hugodaniel]

My dream is to become a data engineer but my sql skills are basically "from * import" 😢 gonne binge watch your channel

[harshitkak]

Pls make more vedios related to python

[chandramouliramakrishnan]

when u ran group by on 2 columns, category and city, for chennai city the category is blank displayed.. why ? time 4.36 on the video

[praveentanikella]

Brother can do do completely EDA in python and same for SQL because am not getting concept right so it will useful for me

[FakeAmazon]

How to find the sum of Marks and Average of Age for the below data frame?
data = {
‘Student’: [‘A’, ’B’, ’C’, ’D’]
'Age': [29, 36, 25, 40],
'Marks': [79, 56, 91, 99]
}
df = pd.DataFrame(data)

Can you provide answer for this

[hugodaniel]

Why do people always import pandas as pd? Why not as p or pan?