In this video we will learn how to create new columns in pandas based on the value of other columns.

data:
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,Mysore,35000,800
US-2019-118983,p6,Office Supplies,Mysore,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:
[ Ссылка ]

#python #pandas #dataanalytics

свернуть