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

๋ฐ˜์‘ํ˜•

๐Ÿ’ป Deep Wide Programming

(79)
matplotlib markers/annotation/visualization(๋‹ค์–‘ํ•œ figures/3d ๊ทธ๋ž˜ํ”„, etc. ํ™œ์šฉ์‹œ ์ฐธ์กฐ links https://matplotlib.org/3.1.1/api/markers_api.html matplotlib.markers โ€” Matplotlib 3.1.2 documentation matplotlib.markers This module contains functions to handle markers. Used by both the marker functionality of plot and scatter. All possible markers are defined here: marker symbol description "." point "," pixel "o" circle "v" triangle_down "^" triangle_u matplotlib.org https://matplotlib.org/3..
[Pandas] DataFrame์˜ Inner Join, Outer Join, Left Join, Right Join/concat/melt์— ๊ด€ํ•œ ์ข‹์€ ์ •๋ฆฌ ๊ธ€ 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..
[Datacamp/Pandas]layering plots,add legned,transparency, missing values, creating dataframe ๐Ÿ“Œ ๋‘๊ฐœ์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฒน์ณ์„œ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. ๐Ÿ“Œ ๊ฒฐ์ธก์น˜ ํ™•์ธํ•˜๊ธฐ ๐Ÿ“Œ ๊ฒฐ์ธก์น˜ ์ฒ˜๋ฆฌํ•˜๊ธฐ 1)์ œ๊ฑฐํ•˜๊ธฐ 2)๊ต์ฒดํ•˜๊ธฐ ๐Ÿ“Œ ๋ฐ์ดํ„ฐํ”„๋ ˆ์ž„ ๋งŒ๋“ค๊ธฐ 1)Row์˜ ํ˜•ํƒœ๋กœ ๋งŒ๋“ค๊ธฐ, 2) Column์˜ ํ˜•ํƒœ๋กœ ๋งŒ๋“ค๊ธฐ pd.DataFrame(๋ฆฌ์ŠคํŠธ๋„ค์ž„)
Anaconda_Jupyter Notebook ์•„๋‚˜์ฝ˜๋‹ค๋กœ ์ฃผํ”ผํ„ฐ ๋…ธํŠธ๋ถ ์‚ฌ์šฉํ•˜๊ธฐ(feat. ๋งˆํฌ๋‹ค์šดMarkdown ์‚ฌ์šฉํ•˜๋Š” ๋ฒ•) ์•„๋‚˜์ฝ˜๋‹ค๋ž€์™€ ์ฃผํ”ผํ„ฐ๋…ธํŠธ๋ถ ์‰ฝ๊ฒŒ ๋งํ•ด ํŒŒ์ด์ฌ๊ณผ ๊ด€๋ จ๋œ ๋‹ค์–‘ํ•œ ์ƒํƒœ๊ณ„๋ฅผ '์•„๋‚˜์ฝ˜๋‹ค'์ฒ˜๋Ÿผ ์ง‘์–ด์‚ผํ‚ค๊ณ  ์žˆ๋Š” ๊ฒƒ์ด๋ผ ์ƒ๊ฐํ•˜๋ฉด ๋œ๋‹ค. ์•„๋‚˜์ฝ˜๋‹ค๋ฅผ ์„ค์น˜ํ•˜๋ฉด, ์ฃผํ”ผํ„ฐ ๋…ธํŠธ๋ถ์ด ์ž๋™์œผ๋กœ ์„ค์น˜๋œ๋‹ค. ํŒŒ์ด์ฌ์„ ์šฐ๋ฆฌ๊ฐ€ ์ด์šฉํ•  ๋•Œ ์ฝ˜์†”์— ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ์•„์›ƒํ’‹์ด ์ถœ๋ ฅ๋˜๋Š”๋ฐ, ๊ทธ๊ฑธ ์›น์—์„œ ๋ณผ ์ˆ˜ ์žˆ์–ด์„œ ๋ฌธ์„œํ™”๊ฐ€ ๊ฐ€๋Šฅํ•˜๋‹ค. ํ„ฐ๋ฏธ๋„์—์„œ pip ๊ด€๋ จ ์˜ค๋ฅ˜๊ฐ€ ๋– ์„œ, ํ•œ์ฐธ์„ ๋ชป ์—ด๋‹ค๊ฐ€ ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์œผ๋กœ ์ ‘์†ํ–ˆ๋‹ค. ์•„๋‚˜์ฝ˜๋‹ค ๋„ค๋น„๊ฒŒ์ดํ„ฐ๋ฅผ ์ฐพ์•„์„œ ๋ˆ„๋ฅด๋ฉด, ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์—ด๋ฆฐ๋‹ค. jupyter notebook ํ•˜๋‹จ์˜ Launch๋ฅผ ๋ˆ„๋ฅด๋ฉด, ์•Œ์•„์„œ terminal์„ ํ†ตํ•ด ์›น ์ƒ์— jupyter notebook์ด ์—ด๋ฆฐ๋‹ค. ์ฃผํ”ผํ„ฐ ๋…ธํŠธ๋ถ ๋งˆํฌ๋‹ค์šด ์‚ฌ์šฉํ•˜๊ธฐ ํŒŒ์ผ์„ ํ•˜๋‚˜ ๋งŒ๋“ค์–ด, ๊ฐ„๋‹จํ•œ ๋งˆํฌ๋‹ค์šด ์‚ฌ์šฉ๋ฒ•์„ ์ •๋ฆฌํ–ˆ๋‹ค. [๋งˆํฌ๋‹ค์šด ์‚ฌ์šฉTip] # ์ฃผํ”ผํ„ฐ ๋…ธํŠธ๋ถ ์‚ฌ..
Data Manipulation with pandas #2 Aggregating Data_ Statistics, Counting, Grouped summary statistics, Pivot Table @Datacamp 1) Statistics ์—ฐ์Šต/์‹ค์Šต 2) Counting ์นด์šดํŒ… ํ•˜๊ธฐ ์ „์—, ์ •๋ ฌ์„ ์ข€ ํ•  ํ•„์š”๊ฐ€ ์žˆ๋‹ค. Dropping duplicates ์นด์šดํŒ…ํ•˜๊ธฐ .value_counts() ๋น„์œจํ™˜์‚ฐ .value_counts(normalize=True) Counting ์—ฐ์Šต๋ฌธ์ œ/์‹ค์Šต 3) Grouped summary statistics ์—ฐ์Šต/์‹ค์Šต 4) Pivot Table addfunc
Data Manipulation with pandas #1-3 New columns ์ด์ •๋ฆฌ ๊ฐœ๋…์ •๋ฆฌ ์œ„์˜ ๋‚ด์šฉ ์‘์šฉํ•˜๊ธฐ
Data Manipulation with pandas #1-2 Sorting and subsetting ์ด์ •๋ฆฌ 1. Sorting(์ •๋ ฌ) and subsetting(๋ถ€๋ถ„์ง‘ํ•ฉ) ์ด์ •๋ฆฌ Subsetting Columns _____["์—ด์˜ ์ด๋ฆ„"] ํ•œ ์ค„๋กœ๋„ ํ‘œํ˜„์ด ๊ฐ€๋Šฅํ•˜๋‹ค. ๋‹ค๋งŒ ()๋ฅผ ์‚ฌ์šฉํ•ด์ค˜์•ผ ํ•œ๋‹ค.
Data Manipulation with pandas #1-1 Data : DataFrames ์ด์ •๋ฆฌ 1. DataFrames ์ด์ •๋ฆฌ ๋ฐ์ดํ„ฐ์บ ํ”„์˜ Data Manipulation with pandas ์ฒซ ๊ฐ•์˜๋Š”, ํŒ๋‹ค์Šค์˜ "DATAFRAMES"์— ๋Œ€ํ•œ ๋น ๋ฅธ ์ „๋ฐ˜์  ๋ณต์Šต ๋ฐ ์˜ค๋ฒ„๋ทฐ๋กœ ์‹œ์ž‘ํ•œ๋‹ค. ๊ฐ™์€ columns ๋‚ด์—๋Š” ๊ฐ™์€ data type์„ ๊ฐ€์ง„๋‹ค. 1-2. DataFrames ์‹ค์Šต (1) Inspecting a DataFrame homelessness.head() ์ด๋Ÿฐ ๋ฐฉ์‹์œผ๋กœ, ์•ž์ชฝ์— ๊ฒ€์‚ฌํ•  ๋ฐ์ดํ„ฐํ”„๋ ˆ์ž„์˜ ์ œ๋ชฉ์„ ๋„ฃ์–ด์ค€๋‹ค.

728x90
๋ฐ˜์‘ํ˜•