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

728x90

PYTHON

7/19 ํ™”_RPA, ์ฝ”๋”ฉ ํ…Œ์ŠคํŠธ ์—ฐ์Šต(Python) 1. RPA(Robotic Process Automation) ๋กœ๋ณดํ‹ฑ ์ž๋™ํ™” ๊ณผ์ •(์‚ฌ๋žŒ์ด ๋ฐ˜๋ณต์ ์œผ๋กœ ์ฒ˜๋ฆฌํ•˜๋Š” ์—…๋ฌด๋ฅผ ๋กœ๋ด‡ ์ž๋™ํ™”๋กœ ํ•˜๋Š” ๊ฒƒ) ํ˜„์žฌ๋Š” ๋ฐ์ดํ„ฐ ์ž…๋ ฅ ๋“ฑ์˜ ๋‹จ์ˆœ ๋ฐ˜๋ณต ์—…๋ฌด ํ”„๋กœ์„ธ์Šค์˜ ์ž๋™ํ™”์— ์ฃผ๋กœ ์ ์šฉ๋˜๊ณ  ์žˆ์ง€๋งŒ, ํ–ฅํ›„ AI, ๋จธ์‹ ๋Ÿฌ๋‹ ๋“ฑ์˜ ๊ธฐ์ˆ ์ด ๋ฐœ์ „, RPA์™€ ๊ฒฐํ•ฉํ•œ๋‹ค๋ฉด ์ž๋ฃŒ ๋ถ„์„ ๋ฐ Solution ์ œ์‹œ ๋“ฑ์˜ ์˜์—ญ๊นŒ์ง€๋„ ๊ฐ€๋Šฅ(?)ํ•  ์ˆ˜ ์žˆ์Œ ์†”๋ฃจ์…˜ - ์‚ผ์„ฑ SDS์˜ Brity Works RPA, UI Path, Automation Anywhere, Blue Prism, Softomotive ์ถœ์ฒ˜: https://namu.wiki/w/RPA 2. 16์ง„์ˆ˜๋ฅผ ์ž…๋ ฅ๋ฐ›์•„ 8์ง„์ˆ˜๋กœ ์ถœ๋ ฅ a = int(input(), 16) # ์ž…๋ ฅ๋œ ๊ฐ’์„ 16์ง„์ˆ˜๋กœ ์ธ์‹ํ•ด ๋ณ€์ˆ˜ a์— ์ €์žฅ. f print('%o'.. ๋”๋ณด๊ธฐ
7/17 ์ผ_์ฝ”๋”ฉ ํ…Œ์ŠคํŠธ ์—ฐ์Šต(Python) 1. ์–•์€ ๋ณต์‚ฌ, ๊นŠ์€ ๋ณต์‚ฌ - ์–•์€ ๋ณต์‚ฌ: a๋ฅผ b๋กœ ๋ณต์‚ฌํ–ˆ์„ ๋•Œ a, b๋Š” ๊ฐ™์€ ๋ฉ”๋ชจ๋ฆฌ ์ฃผ์†Œ๋ฅผ ์‚ฌ์šฉํ•จ - =๋กœ ๋ณต์‚ฌ → a, b ์ค‘ ํ•˜๋‚˜์˜ ๊ฐ’์„ ๋ณ€๊ฒฝํ•ด๋„ ๊ฐ™์€ ๊ณณ์„ ๊ฐ€๋ฆฌํ‚ค๊ธฐ ๋•Œ๋ฌธ์— a, b ๋ณ€์ˆ˜๊ฐ€ ๋™์ผํ•˜๊ฒŒ ๋ฐ”๋€œ - ๊นŠ์€ ๋ณต์‚ฌ : a๋ฅผ b๋กœ ๋ณต์‚ฌํ–ˆ์„ ๋•Œ a, b๋Š” ์„œ๋กœ ๋‹ค๋ฅธ ๋ฉ”๋ชจ๋ฆฌ ์ฃผ์†Œ๋ฅผ ๊ฐ€๋ฆฌํ‚ด - .copy() ๋ฉ”์„œ๋“œ(๋ฆฌ์ŠคํŠธ ๋ณต์‚ฌ) ํ˜น์€ copy ๋ชจ๋“ˆ์˜ copy.deepcopy() ํ•จ์ˆ˜(๋‹ค์ฐจ์› ๋ฐฐ์—ด ๋ณต์‚ฌ)๋กœ ๋ณต์‚ฌ → a, b ๋ณ€์ˆ˜๊ฐ€ ๋…๋ฆฝ์ ์ž„ ์›๋ณธ = [45, 73, 66, 87, 92] print('์›๋ณธ:', ์›๋ณธ) ์–•์€๋ณต์‚ฌ = ์›๋ณธ ์–•์€๋ณต์‚ฌ[0] = 1111 # ์‚ฌ๋ณธ, ์›๋ณธ ๊ฐ™์ด ๋ฐ”๋€œ ๊นŠ์€๋ณต์‚ฌ = ์›๋ณธ.copy() ๊นŠ์€๋ณต์‚ฌ[0] = 555 # ์‚ฌ๋ณธ๋งŒ ๋ฐ”๋€œ print(f'์–•์€๋ณต์‚ฌ: {์–•์€๋ณต์‚ฌ}', f.. ๋”๋ณด๊ธฐ
7/16 ํ† _์ฝ”๋”ฉ ํ…Œ์ŠคํŠธ ์—ฐ์Šต(Python) 1. .sort() ๋ฉ”์„œ๋“œ, sorted() ํ•จ์ˆ˜ - .sort() ๋ฉ”์„œ๋“œ : ๋ฉ”๋ชจ๋ฆฌ ๊ณต๊ฐ„ ์ ˆ์•ฝ์„ ์œ„ํ•ด ์‹œํ€€์Šค๋ฅผ ์ œ์ž๋ฆฌ์—์„œ ์ˆ˜์ •ํ•˜์—ฌ ํšจ์œจ์  ์ •๋ ฌ๋œ ์‹œํ€€์Šค๋ฅผ ๋ฐ˜ํ™˜ํ•˜์ง€ ์•Š์Œ key์™€ reverse ๋‘ ๊ฐœ์˜ ์ธ์ž๋ฅผ ๋ฐ›์Œ (reverse=True) ๋‚ด๋ฆผ์ฐจ์ˆœ ์ •๋ ฌ - sorted() ํ•จ์ˆ˜ : sort() ๋ฉ”์„œ๋“œ์™€ ๋‹ค๋ฅด๊ฒŒ ์ •๋ ฌ๋œ ๊ฐ์ฒด๋ฅผ ๋ฐ˜ํ™˜ํ•จ iterable ๊ฐ์ฒด, key, reverse์˜ ์ธ์ž๋ฅผ ๋ฐ›์Œ c = [5, 4, 3, 2, 1] print(f'sorted ํ•จ์ˆ˜: {sorted(c)}', f'์›๋ณธ: {c}', sep='\n') c.sort() print(f'sort ๋ฉ”์„œ๋“œ: {c}') 2. %d %f %s %x %o ํฌ๋งทํŒ… num_1 = 15 num_2 = 3.0 str_1 = 'abc' print('์ˆซ์ž .. ๋”๋ณด๊ธฐ
4/6 ์ˆ˜ ์ˆ˜์š”์ผ! ์˜ค๋Š˜์€ Multinomial Classification์„ ๋ฐฐ์šด๋‹ค. Linear Regression(์—ฐ์†์ ์ธ ์ˆซ์ž ๊ฐ’ ์˜ˆ์ธก)์ด ๋ฐœ์ „ํ•œ ๊ฒƒ์ด Logistic Regression → Classification(๋ถ„๋ฅ˜๋ฅผ ํŒ๋‹จํ•˜๋Š” ์˜ˆ์ธก) - Binary Classification(์ดํ•ญ๋ถ„๋ฅ˜) - Multinomial Classification(๋‹คํ•ญ๋ถ„๋ฅ˜) Logistic Regression์€ ์ด์ง„ ๋ถ„๋ฅ˜์— ํŠนํ™”๋จ SKlearn์ด ์ œ๊ณตํ•˜๋Š” ๋ถ„๋ฅ˜๊ธฐ์ธ Gradient Descent(๊ฒฝ์‚ฌํ•˜๊ฐ•๋ฒ•)๊ฐ€ ๋ฐœ์ „ํ•œ ํ˜•ํƒœ์ธ SGD Classifier(Stochastic Gradient Descent, ํ™•๋ฅ ์  ๊ฒฝ์‚ฌํ•˜๊ฐ•๋ฒ•) 1. Binary Classification - ์œ„์Šค์ฝ˜์‹  ์œ ๋ฐฉ์•” ๋ฐ์ดํ„ฐ by Gradient Descent Cl.. ๋”๋ณด๊ธฐ
4/1 ๊ธˆ ๊ธˆ์š”์ผ! ๐Ÿ˜Ž ์–ด์ œ ์ž ๊น ์†Œ๊ฐœํ•œ Logistic Regression์„ ๋ฐฐ์šด๋‹ค~ Linear Regression(์—ฐ์†์ ์ธ ์ˆซ์ž ๊ฐ’ ์˜ˆ์ธก)์ด ๋ฐœ์ „ํ•œ ๊ฒƒ์ด Logistic Regression → Classification(๋ถ„๋ฅ˜๋ฅผ ํŒ๋‹จํ•˜๋Š” ์˜ˆ์ธก) - Binary Classification(์ดํ•ญ๋ถ„๋ฅ˜) - Multinomial Classification(๋‹คํ•ญ๋ถ„๋ฅ˜) ๊ทธ๋ž˜ํ”„๋ฅผ ๋ณผ ์ˆ˜ ์žˆ๋Š” ์œ ํ‹ธ๋ฆฌํ‹ฐ ๋ชจ๋“ˆ(mglearn)์„ ์ถ”๊ฐ€์ ์œผ๋กœ ์„ค์น˜ํ•˜์ž conda activate maching_TF15 pip install mglearn conda install์€ ์ด๋ฏธ ์„ค์น˜๋˜์–ด ์žˆ๋Š” ๋ชจ๋“ˆ, ํŒจํ‚ค์ง€์— ๋Œ€ํ•œ Dependency๋ฅผ ๊ณ ๋ คํ•ด์„œ ์ตœ์ ์ธ ๋ฒ„์ „์„ ์„ค์น˜, pip install์€ ๊ทธ๋ƒฅ ๊น”์•„๋ฒ„๋ฆผ Logistic Regression : L.. ๋”๋ณด๊ธฐ
3/29 ํ™” ํ™”์š”์ผ! ์˜ค๋Š˜์€ ์–ด์ œ ๋ฐฐ์šด Simple Linear Regression(๋‹จ์ˆœ ์„ ํ˜• ํšŒ๊ท€)์„ ์ฝ”๋“œ๋กœ ๊ตฌํ˜„ํ•œ๋‹ค. 1. Training Data Set ์ค€๋น„ : Data pre-processing(๋ฐ์ดํ„ฐ ์ „์ฒ˜๋ฆฌ). ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ํ˜•ํƒœ๋กœ ์ค€๋น„ 2. Linear Regression Model์„ ์ •์˜ : y = Wx+b(์˜ˆ์ธก ๋ชจ๋ธ). hypothesis(๊ฐ€์„ค) 3. ์ตœ์ ์˜ W(weight, ๊ฐ€์ค‘์น˜), b(bias, ํŽธ์ฐจ)๋ฅผ ๊ตฌํ•˜๋ ค๋ฉด loss function(์†์‹คํ•จ์ˆ˜)/cost function(๋น„์šฉํ•จ์ˆ˜) → MSE 4. Gradient Descent Algorithm(๊ฒฝ์‚ฌํ•˜๊ฐ•๋ฒ•) : loss function์„ ํŽธ๋ฏธ๋ถ„(W, b) × learning rate 5. ๋ฐ˜๋ณตํ•™์Šต ์ง„ํ–‰ 1. Training Dat.. ๋”๋ณด๊ธฐ
3/28 ์›” ์›”์š”์ผ! ๊ธˆ์š”์ผ์— ์ด์–ด ๋จธ์‹ ๋Ÿฌ๋‹ ๋“ค์–ด๊ฐ„๋‹ค~ Weak AI์˜ ๋จธ์‹ ๋Ÿฌ๋‹ ๊ธฐ๋ฒ•๋“ค : ์ง€๋„ ํ•™์Šต, ๋น„์ง€๋„ ํ•™์Šต, ๊ฐ•ํ™” ํ•™์Šต 1. Regression(ํšŒ๊ท€) : ๋ฐ์ดํ„ฐ์— ์˜ํ–ฅ์„ ์ฃผ๋Š” ์กฐ๊ฑด๋“ค์˜ ์˜ํ–ฅ๋ ฅ์„ ๊ณ ๋ คํ•ด์„œ, ๋ฐ์ดํ„ฐ์— ๋Œ€ํ•œ ์กฐ๊ฑด๋ถ€ ํ‰๊ท ์„ ๊ตฌํ•˜๋Š” ๊ธฐ๋ฒ• * ํ‰๊ท ์„ ๊ตฌํ•  ๋•Œ ์ฃผ์˜ํ•ด์•ผ ํ•  ์  : ํ‰๊ท ์„ ๊ตฌํ•˜๋Š” ๋ฐ์ดํ„ฐ์— ์ด์ƒ์น˜๊ฐ€ ์žˆ์„ ๊ฒฝ์šฐ ๋Œ€ํ‘œ๊ฐ’์œผ๋กœ ์‚ฌ์šฉํ•˜๊ธฐ ์–ด๋ ค์›€. ์ •๊ทœ๋ถ„ํฌ์—ฌ์•ผ ํ•จ! ๊ณ ์ „์  ์„ ํ˜• ํšŒ๊ท€ ๋ชจ๋ธ(Classical Linear Regression Model) ๋‹จ์ˆœ ์„ ํ˜• ํšŒ๊ท€(Simple Linear Regression) import numpy as np import pandas as pd import matplotlib.pyplot as plt df = pd.DataFrame({'๊ณต๋ถ€์‹œ๊ฐ„(x)': [1,2,3.. ๋”๋ณด๊ธฐ
3/17 ๋ชฉ ๋ชฉ์š”์ผ! ์˜ค๋Š˜์€ ์™ธ๋ถ€ resource๋ฅผ ์ด์šฉํ•ด์„œ DataFrame์„ ์ƒ์„ฑํ•˜๋Š” ๊ฒƒ์„ ๋ฐฐ์šด๋‹ค. ์ฒซ ๋ฒˆ์งธ ๋ฐฉ๋ฒ•์€ CSV ํŒŒ์ผ ์‚ฌ์šฉ, ๋‘ ๋ฒˆ์งธ๋Š” MySQL ์•ˆ์— DB๋กœ๋ถ€ํ„ฐ SQL ์ด์šฉํ•ด DataFrame์„ ์ƒ์„ฑ - SQL ์ง์ ‘ or ORM ๋ฐฉ์‹(Django) Jupyter Notebook๊ณผ MySQL ์—ฐ๋™์‹œํ‚ค๊ธฐ ์œ„ํ•ด Anaconda Prompt๋กœ ์™ธ๋ถ€ ๋ชจ๋“ˆ ์„ค์น˜ conda activate machine conda install pymysql 1. MySQL์— ์ƒˆ๋กœ์šด schema ์ƒ์„ฑ ํ›„ ๋ฉ”๋‰ด์—์„œ Open SQL Script๋กœ DB ์—ด๊ธฐ ์ƒˆ๋กœ์šด Query Tab ์—ด๋ฆฌ๋ฉด ๋ฒˆ๊ฐœ ๋ˆŒ๋Ÿฌ์ฃผ๊ณ , ์•ˆ์— ์žˆ๋Š” DB ํ™•์ธ create database lecture_0317; use lecture_0317; select * fro.. ๋”๋ณด๊ธฐ

728x90