๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๐Ÿ’ป Deep Wide Programming/Python

[Pandas] DataFrame์˜ Inner Join, Outer Join, Left Join, Right Join/concat/melt์— ๊ด€ํ•œ ์ข‹์€ ์ •๋ฆฌ ๊ธ€

728x90
๋ฐ˜์‘ํ˜•

Datacamp์—์„œ ํŒ๋‹ค์Šค join์— ๊ด€ํ•œ ํŒŒํŠธ๋ฅผ ๊ณต๋ถ€ํ•˜๋ฉฐ, ๋ช…์พŒํ•˜์ง€ ์•Š์€ ๊ตฌ์„๋“ค์ด ์žˆ์—ˆ๋Š”๋ฐ ์ฐพ์•„๋ณด๋‹ค๊ฐ€, ์Šฅ ํ›‘์–ด๋ณด๋ฉด ์ •๋ฆฌํ•˜๊ธฐ ์ข‹์€ ๊ธ€๋“ค์„ ๋ฆฌ์ŠคํŒ…ํ•ด๋ณธ๋‹ค. ์œ„์—์„œ๋ถ€ํ„ฐ ์ˆœ์„œ๋Œ€๋กœ ๋ณด๋ฉด ๋Œ€๋žต ๊ฐ ์žก๋Š”๋ฐ ๋„์›€์ด ๋œ๋‹ค. ๋‚˜์ค‘์— ๋˜ ๋ณต์Šตํ•  ๋•Œ ์ฐธ๊ณ ํ•ด์•ผ์ง€

 

http://www.gisdeveloper.co.kr/?p=8255

 

pandas์˜ DataFrame์— ๋Œ€ํ•œ Inner Join, Outer Join, Left Join, Right Join – GIS Developer

ํŒ๋‹ค์Šค์—์„œ ๋ฐ์ดํ„ฐํ”„๋ ˆ์ž„์€ ํ…Œ์ด๋ธ” ํ˜•์‹์˜ ๋ฐ์ดํ„ฐ์…‹์ž…๋‹ˆ๋‹ค. DBMS์˜ Table๋“ค ๊ฐ„์—๋„ Join์„ ๋งบ์„ ์ˆ˜ ์žˆ๋“ฏ์ด, ๋งˆ์ฐฌ๊ฐ€์ง€๋กœ ํŒ๋‹ค์Šค์˜ ๋ฐ์ดํ„ฐํ”„๋ ˆ์ž„๋“ค ๊ฐ„์—๋„ Join์„ ๋งบ์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋ฌผ๋ก  Join์„ ๋งบ์„ ๏ฟฝ๏ฟฝ

www.gisdeveloper.co.kr

 

https://blog.naver.com/PostView.nhn?blogId=wideeyed&logNo=221245234608

 

[python] pandas join(merge) ์˜ˆ์ œ

pandas join(merge)์— ๋Œ€ํ•ด์„œ ์•Œ์•„๋ณด์ž.โ€‹์ฃผ๋ฌธ์ •๋ณด, ๊ณ ๊ฐ์ •๋ณด, ์ƒํ’ˆ์ •๋ณด๊ฐ€ ์žˆ๊ณ ์ฃผ๋ฌธํ•œ ์ •๋ณด๋ฅผ ์ค‘์‹ฌ์œผ๋กœ ๊ณ ...

blog.naver.com

 

https://rfriend.tistory.com/258

 

[Python pandas] Database์ฒ˜๋Ÿผ DataFrame Join/Merge ํ•˜๊ธฐ : pd.merge()

๋ฐ์ดํ„ฐ ๋ถ„์„์„ ํ•˜๋‹ค ๋ณด๋ฉด ์—ฌ๊ธฐ ์ €๊ธฐ ํฉ์–ด์ ธ ์žˆ๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ํŠน์ •ํ•œ Key๋ฅผ ๊ธฐ์ค€์œผ๋กœ ๋ณ‘ํ•ฉํ•ด์„œ ๋ถ„์„ํ•ด์•ผ ํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งค์šฐ ๋งŽ์Šต๋‹ˆ๋‹ค. ์ง€๋‚œ๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” DataFrame์„ pandas์˜ concat() ํ•จ์ˆ˜๋ฅผ ์ด์šฉํ•ด์„œ

rfriend.tistory.com

์ถœ์ฒ˜: https://rfriend.tistory.com/258

https://programmerpsy.tistory.com/17

 

[Pandas ๊ธฐ์ดˆ]4.์—ฌ๋Ÿฌ DataFrame ์—ฐ๊ฒฐํ•˜๊ธฐ(Join)

์•ˆ๋…•ํ•˜์„ธ์š”. PSYda ์ž…๋‹ˆ๋‹ค. ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” ๋‘ ๊ฐœ์˜ DataFrame์„ ์—ฐ๊ฒฐํ•˜๋Š” Join ๊ธฐ๋ฒ•์— ๋Œ€ํ•ด ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. ์†Œ๊ฐœํ•  ๋‚ด์šฉ์€ ์•„๋ž˜์™€ ๊ฐ™์Šต๋‹ˆ๋‹ค. ์ปฌ๋Ÿผ ๊ธฐ์ค€ Join Index ๊ธฐ์ค€ Join ํ–‰๊ธฐ์ค€ Join Inner, Left, Right

programmerpsy.tistory.com

 

 

//

merge์™€ concat์— ๊ด€ํ•œ ์ •๋ฆฌ๊ธ€

https://datascienceschool.net/view-notebook/7002e92653434bc88c8c026c3449d27b/

 

Data Science School

Data Science School is an open space!

datascienceschool.net

 

melt

https://koreadatascientist.tistory.com/12

 

ํŒŒ์ด์ฌ ํŒ๋‹ค์Šค melt() ์‚ฌ์šฉ๋ฒ•, pd.melt()

 ํŒŒ์ด์ฌ ํŒ๋‹ค์Šค melt() ์‚ฌ์šฉ๋ฒ•, pd.melt() ์‚ฌ์ „ ์ •์˜์— ๋”ฐ๋ฅด๋ฉด ๋…น๋‹ค, ๋ˆ„๊ทธ๋Ÿฌ๋œจ๋ฆฌ๋‹ค ๋ผ๋Š” ์˜๋ฏธ๋ฅผ ๊ฐ–๋Š” ์ด ๋ฉ”์†Œ๋“œ ๊ณผ์—ฐ ๋ฌด์—‡์ธ์ง€ ์‚ดํŽด๋ด…์‹œ๋‹ค. ๊ทธ๋ฆผ์œผ๋กœ ๋ด์„œ๋Š” ๋Œ€์ถฉ ๋ฌด์Šจ ์˜๋ฏธ์ธ์ง€ ์•Œ๊ฒ ์Šต๋‹ˆ๋‹ค. ๊ทธ๋Ÿฌ๋‚˜

koreadatascientist.tistory.com

 

728x90
๋ฐ˜์‘ํ˜•