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

RESOURCE

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

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”