๐Ÿ“Š[DataCamp] PandasํŒ๋‹ค์Šค : Left Join, Other Joins, Merging a table to itself, Merging on indexes

2020. 9. 7. 16:22ใ†Learning archive/Data Science

 

 Right Table์—๋Š” ์žˆ์ง€๋งŒ left Table์— ์—†๋Š” Row์˜ Cell์€ ํ•ฉ์น˜์ง€ ์•Š๊ณ , ๋ˆ„๋ฝ๋œ๋‹ค! 

 

๐Ÿ“ŒLeft Join vs. Inner join example

 

Rows 

 

 

 

 

 

๐Ÿ“ŒHow to count number of rows that are missing  .isnull().sum()

 

 

 

 

 

 

 

 

 

 

 

 

๐Ÿ“Œ Right Join <-> Left Join 

 

 

 

 

๐Ÿ“Œ left_on="", right_on=""

 

 

๐Ÿ“Œ Outer Join

 

 

๐Ÿ“ŒMerging a table to itself 

 


Merging on indexes