A free Machine Learning course from Standford taught by Andrew Ng.
You'll learn:
• Linear/Logistic regression
• Decision Trees
• KNN
• Support Vector Machines
• Neural Networks
• Naive Bayes
• Gradient Descent
And much more.
Link: https://t.co/G64MnKYftu
SQL Joins in Pandas!
🐼Pandas offers robust functionalities to perform SQL-like joins with its merge() function.
Let's explore the four primary types of SQL joins — Inner Join, Left Join, Right Join, and Outer Join.
1️⃣ Inner Join:
An Inner Join returns only the rows where there is a match in both the left and the right DataFrame.
Syntax⬇️
pd.merge(df_left, df_right, on='key', how='inner')
Here'a a visual representation of the Inner join👇
2️⃣ Left Join:
A Left Join returns all records from the left DataFrame (`df_left` in our case) and the matched records from the right DataFrame (`df_right`).
If there is no match, the result is NaN.
Syntax⬇️
pd.merge(df_left, df_right, on='key', how='left')
Here'a a visual representation of the Left join👇
3️⃣ Right Join:
A Right Join returns all records from the right DataFrame (`df_right`) and the matched records from the left DataFrame (`df_left`).
If there isn't a match, the result is NaN.
Syntax⬇️
pd.merge(df_left, df_right, on='key', how='right')
Here'a a visual representation of the Right join👇
4️⃣ Outer Join
An Outer Join (or Full Outer Join) returns all records when there is a match in one of the left or right DataFrame.
Rows from the left DataFrame that have no match in the right DataFrame will have NaN for the right DataFrame's columns and vice versa.
Syntax⬇️
pd.merge(df_left, df_right, on='key', how='outer')
Here'a a visual representation of the Outer join👇
That's all, if you’re interested in:
- Python 🐍
- ML/MLOps 🛠
- CV/NLP 🗣
- LLMs 🧠
Find me → @akshay_pachaar ✔️
Everyday, I share tutorials on above topics!
I also have a newsletter that you can find in the next tweet!
Make sure you like and retweet this to support my work!
Cheers!🥂
MIT university is offering FREE education in Data Science.
Courses cover:
- Python
- Data Science
- Machine Learning
- Statistics
- Linear Algebra &
- Deep Learning
Learn from the best at a free of cost!
Thread🧵👇
📋 @polespargaro is "conscious, alert, and responding well", with further examinations underway
Full medical update here 👇
#PortugueseGP 🇵🇹 | 📰
https://t.co/n2CnmQB9mg
Medical Info Update 📋
#MotoGP rider #44 @polespargaro has suffered a pulmonary contusion, jaw fracture and a fractured dorsal vertebra
#PortugueseGP 🇵🇹