๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ

    ๋ฐฑ์ค€ story 1

    ๋ฐฑ์ค€ story 1

    map ํ•จ์ˆ˜ packing error์™€ unpacking error https://eat-sleep-code-repeat.tistory.com/7 [ํŒŒ์ด์ฌ ์—๋Ÿฌ]ValueError: not enough values to unpack (expected 2, got 0) ์›์ธ/ํ•ด๊ฒฐ๋ฐฉ๋ฒ• [ํŒŒ์ด์ฌ ์—๋Ÿฌ]ValueError: not enough values to unpack (expected 2, got 0) ์›์ธ/ํ•ด๊ฒฐ๋ฐฉ๋ฒ• 1๋ฒˆ ์ค„์—์„œ ValueError์—๋Ÿฌ ๋ฐœ์ƒ ์ฝ˜์†” ์ฐฝ์„ ๋ณด๋‹ˆ ValueError: not enough values to unpack (expected 2, got 0)๋ผ.. eat-sleep-code-repeat.tistory.com splitํ•จ์ˆ˜ https://ooyoung.tistory.com..

    ML ํ€ด์ฆˆ ์ •๋ฆฌ

    ML ํ€ด์ฆˆ ์ •๋ฆฌ

    ๋จธ์‹ ๋Ÿฌ๋‹ 7๋‹จ๊ณ„ 1.๋ฌธ์ œ ์ •์˜ -ํ•ด๊ฒฐํ•  ๋ฌธ์ œ๋ฅผ ์ •์˜ํ•œ๋‹ค. 2.๋ฐ์ดํ„ฐ ์ˆ˜์ง‘ -ํ•ด๊ฒฐํ•  ๋ฌธ์ œ์— ๋Œ€ํ•œ ๋ฐ์ดํ„ฐ ์ˆ˜์ง‘ 3.๋ฐ์ดํ„ฐ ์ „์ฒ˜๋ฆฌ -์ˆ˜์ง‘ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ๋จธ์‹ ๋Ÿฌ๋‹ ํ•™์Šต์— ๋งž๋Š” ํ˜•ํƒœ๋กœ ๋ณ€ํ˜• 4.ํƒ์ƒ‰์  ๋ฐ์ดํ„ฐ ๋ถ„์„ -์‹œ๊ฐํ™”, ํ†ต๊ณ„์ž๋ฃŒ ๋ถ„์„ 5.๋ชจ๋ธ ์„ ํƒ ๋ฐ ํ•˜์ดํผ ํŒŒ๋ผ๋ฏธํ„ฐ ํŠœ๋‹ -๋ฐ์ดํ„ฐ์— ๋งž๋Š” ๋ชจ๋ธ์„ ์„ ํƒํ•˜๊ณ  ํ•™์Šต์„ ํ•œ๋‹ค. 6.ํ•™์Šต -fit() 7.์˜ˆ์ธก ์ผ๋ฐ˜์ ํ•ฉ, ๊ณผ๋Œ€์ ํ•ฉ, ๊ณผ์†Œ์ ํ•ฉ ์ผ๋ฐ˜ํ™”-train์ ์ˆ˜ ๋ณดํ†ต, test์ ์ˆ˜ : ๋†’์Œ -test๊ฐ€ ์ž˜ ๋‚˜์™€์•ผ, ๋‹ค๋ฅธ ๋ชจ๋ธ์—์„œ๋„ ์ž˜ ์ ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค๋Š” ๋œป์ด๋‹ค ๊ณผ๋Œ€์ ํ•ฉ(overfitting) train์ ์ˆ˜ : ๋†’์Œ, test์ ์ˆ˜ : ๋ณดํ†ต ๊ณผ์†Œ์ ํ•ฉ(underfitting) train์ ์ˆ˜ : ๋‚ฎ์Œ, test์ ์ˆ˜ : ๋‚ฎ์Œ model.fit(X_train, Y_train) model...

    ์ฝ”์ธ ํŒจํ„ด

    ์ฝ”์ธ ํŒจํ„ด

    ๊ฐ€์„ค ๋ฐ ํŒจํ„ด ํŒŒ์•…: ํŠน์ • ๋‚ ์งœ์— ์•ŒํŠธ๋“ค์ด ๋›ฐ๋ฉด, ๋ฉ”์ด์ ธ ์ฝ”์ธ์˜ ๊ฐ€๊ฒฉ์€? ๋ฉ”์ด์ ธ ์ฝ”์ธ์ด ๋›ธ๋•Œ ์–ด๋–ค ์•ŒํŠธ๋“ค์ด ์˜ฌ๋ž๋Š”์ง€? ๋น„ํŠธ์ฝ”์ธ ์ƒ์Šน์žฅ ์ด๋”๋ฆฌ์›€๋„ ๊ฐ™์ด ์ƒ์Šน ๋„์ง€์ฝ”์ธ์€ ํ›„๋ฐœ ์ฃผ์ž๊ฐ€ ๋„ˆ๋ฌด ๋”ฐ๋ผ ๋ถ™์Œ. ๋งค๋„๋ฒฝ์ด ๊ฐ•ํ•จ ๋ฆฌํ”Œ์€ ์—ญ์‹œ ๋ณ€๋™ํญ์ด ์ž‘์Œ, ํ™˜์ „์†Œ ๋Š๋‚Œ ์ฝœ๋ผํ† ํฐ์€ ์„ธ๋ ฅ์ฃผ ๋””๋น„์ „์€ ํž˜์ด ์ข€ ๊ฐ•ํ•˜๋‹ค. ํ™•์‹คํžˆ ๋ฌด์–ธ๊ฐ€ ์žˆ์–ด ๋ณด์ธ๋‹ค ๋””์„ผํŠธ๋Ÿด์€ ํ™•์‹คํžˆ ์•ŒํŠธ์ฝ”์ธ ๋Š๋‚Œ ์Œ”ํ•จ, ์•ž์œผ๋กœ ํ•˜๋ฝ ์ญˆ์šฑ ์•ˆ์— ๊ฐ€๋‘ฌ๋†“๊ณ  ๊ฐ ์žฌ๊ณ  ์žˆ๋‹ค ํŠธ๋ก ์ด ๊ฐˆ ๊ฒƒ ๊ฐ™์€์ด์œ  ๋งค์ˆ˜์ธต์ด ๋‹จ๋‹จํ•˜๊ณ 

    [Buying squid token] ์˜ค์ง•์–ด ๊ฒŒ์ž„ ํ† ํฐ ์ฝ”์ธ ์‚ฌ๋Š”๋ฒ•

    [Buying squid token] ์˜ค์ง•์–ด ๊ฒŒ์ž„ ํ† ํฐ ์ฝ”์ธ ์‚ฌ๋Š”๋ฒ•

    '์˜ค์ง•์–ด๊ฒŒ์ž„' ๊ฐ€์ƒํ™”ํ ๋“ฑ์žฅ…์ดํ‹€๋งŒ์— 2,000์–ต ์› ๋ชจ์•„ ์ตœ๊ทผ ํ•ซํ•œ ๋„ทํ”Œ๋ฆญ์Šค ๋“œ๋ผ๋งˆ์˜ ์—ดํ’์œผ๋กœ ํ•ด๋‹น ์ฝ”์ธ์ด ์ถœ์‹œํ–ˆ๋‹ค. ๊ตฌ๋งคํ•˜๊ธฐ ์•ž์„œ์„œ, ์ผ๋ถ€ ์ฝ”์ธ์„ ๋“ค๊ณ  ์žˆ์–ด์•ผ ํ•œ๋‹ค. ์ด๋”๋ฆฌ์›€์žˆ์œผ๋‹ˆ ๊ตฌ๋งคํ•  ์ˆ˜ ์žˆ์–ด์„œ, ํ™˜์ „ ์ •๋ณด๋ฅผ ๊ณต์œ ํ•˜๋ฉด ํ˜„์žฌ 2021.10.30 (ํ† ) ์˜ค์ „ 00:20๋ถ„ ๊ธฐ์ค€ 1ETH = 518.639 ์ด๋‹ค. ์ƒ๊ฐ๋ณด๋‹ค ์‹œ์„ธ๊ฐ€ ๊ธˆ๋ฐฉ ์˜ฌ๋ผ๊ฐ„ ๋•๋ถ„์— 1์ด๋”๋ฆฌ์›€์œผ๋กœ ๋ช‡ ์ฒœ๊ฐœ๋ฅผ ์‚ด ์ˆ˜ ์žˆ์—ˆ๋˜ ์—Š๊ทธ์ œ์™€๋Š” ๋‹ค๋ฅด๊ฒŒ ์—„์ฒญ ์˜ฌ๋ผ๊ฐ”๋‹ค. ์‹œ์„ธ ์ฐจ์ต์€ ๋ฒŒ์จ 3๋ฐฐ Inspired by Netflix's popular show Squid Game, its crypto coin is now out in the market and is trading at $2.35 followed by a market capitalisation ..

    Coin ํˆฌ์ž

    Coin ํˆฌ์ž

    1. ์—์ด๋‹ค ๊ด€๋ จ ์ •๋ณด https://blog.naver.com/newwar1992/222552642709 LION LEGENDS : Cardano ์—์ด๋‹ค NFT ๋ฏผํŒ… ์ผ์ • ๊ณต์œ  ์•ˆ๋…•ํ•˜์„ธ์š”. NFT Hunter์ž…๋‹ˆ๋‹ค~ ์˜ค๋Š˜์€ LionLegends ๋ฏผํŒ… ์ผ์ • ๊ณต์œ ๋“œ๋ฆฝ๋‹ˆ๋‹ค. ํŒ๋งค ์ •๋ณด ํŒ๋งค ์ผ์ • :... blog.naver.com 10/29 ์ƒˆ๋ฒฝ 2์‹œ (์•ž์œผ๋กœ 2์‹œ๊ฐ„ ๋‚จ์Œ) 2. ๋ฏธ๊ตญ ์•ฑ์Šคํ† ์–ด 1์œ„ ์ฝ”์ธ๋ฒ ์ด์Šค https://blog.naver.com/greenbuggirl/222552677705 ์•”ํ˜ธํ™”ํ ์‹œ์žฅ ์ œ๋„๊ถŒ์œผ๋กœ ํŽธ์ž…๋˜๋‚˜? ์ง์žฅ์ธ๋ถ„๋“ค ๋ˆ์„ ์ €๊ธˆ๋ฆฌ ์‹œ๋Œ€์— ์ฅ๊ผฌ๋ฆฌ๋งŒํ•œ ๊ธˆ๋ฆฌ ๋ฐ›์ง€ ๋งˆ์‹œ๊ณ , ๊ณผ๊ฐํžˆ ์ž์‚ฐ์„ ๊ตด๋ฆฌ์„ธ์š”! N์žก, ํˆฌ์ž์‹œ๋Œ€์— ... blog.naver.com ์ˆ˜์š”๊ฐ€ ์ฆ๊ฐ€ํ•˜๊ณ  ์žˆ์Œ ๊ด€์‹ฌ๋„ ๊ทธ๋งŒํผ ์ฆ๊ฐ€ ..

    SSD ๊ต์ฒด ํ›„ ์„ฑ๋Šฅ ํ–ฅ์ƒ(์‚ผ์„ฑ to ํ•˜์ด๋‹‰์Šค) (feat.๋ ˆ๋…ธ๋ฒ„, SK hynix Gold P31 SSD PCIe NVMe M.2 1TB)

    SSD ๊ต์ฒด ํ›„ ์„ฑ๋Šฅ ํ–ฅ์ƒ(์‚ผ์„ฑ to ํ•˜์ด๋‹‰์Šค) (feat.๋ ˆ๋…ธ๋ฒ„, SK hynix Gold P31 SSD PCIe NVMe M.2 1TB)

    ๊ธฐ์กด ์‚ผ์„ฑ๊บผ 256G 860PRO ๋ณ€๊ฒฝํ›„ : SKํ•˜์ด๋‹‰์Šค 1TB ๋ณต์ œ ์‹œ์ž‘ 20-30mins ํ— ๋ญ์ง€; ๋‹ค์šด๊ทธ๋ ˆ์ด๋“œ ์ธ๊ฐ€ ์˜ค ํ™•์‹คํžˆ ๋…ธํŠธ๋ถ ๋ฆฌ๋ถ“ํ•˜๊ณ , ์œˆ๋„์šฐ ๋‹ค์‹œ๊น”๊ณ , ์ค‘๊ฐ„ ๊ณผ์ •์ด ๊ธธ์—ˆ์ง€๋งŒ, ๋‹ค์‹œ ์ธก์ •ํ•ด๋ณด๋‹ˆ, ๊ฐ๊ฒฉ์ด๋‹ค. ํ™•์‹คํžˆ ์ตœ๊ทผ๊บผ๋ผ ๊ทธ๋Ÿฐ์ง€ ์ŠคํŽ™์ด ์ข‹๋‹ค. ์ง€๊ธˆ๊นŒ์ง€ SK hynix Gold P31 SSD PCIe NVMe M.2 1TB ๊ต์ฒด๊ธฐ์˜€๋‹ค.

    [MySQL] stored procedure(FEAT. DELIMITER)

    [MySQL] stored procedure(FEAT. DELIMITER)

    DELIMITER ์ฐธ๊ณ ๋กœ DELIMITER๋Š” ๊ตฌ๋ถ„ ๋ฌธ์ž๋ฅผ ์˜๋ฏธํ•œ๋‹ค //๊ฐ€ ๋‚˜์˜ค๋ฉด ๊ธฐ์กด์˜ ์„ธ๋ฏธ์ฝœ๋ก ์„ //๋กœ ๋Œ€์‹ ํ•œ๋‹ค๋Š” ๊ฒƒ์ด๊ณ , ํ•˜๋‚˜์˜ ํฐ ๋‹จ๋ฝ์„ ๋งŒ๋“ค๊ธฐ ์œ„ํ•ด ๋ฌถ์–ด์ฃผ๋Š” ํšจ๊ณผ๋ฅผ ๊ฐ–๋Š”๋‹ค. ํ”„๋กœ์‹œ์ € ์‹ค๋ฌด์—์„œ ๋งŽ์ด ์“ฐ์ด๋Š” ๋ฐฉ๋ฒ•์œผ๋กœ, ์ฟผ๋ฆฌ๋ฅผ ํ•œ๋ฒˆ์— ๋ฌถ์–ด์„œ ์‹คํ–‰ํ•˜๋Š” ๊ธฐ๋Šฅ์„ ๋‹ด๋‹นํ•œ๋‹ค. ๋งค๋ฒˆ ์‹คํ–‰ํ•  ํ•„์š”์—†์ด(SQL๋ฌธ์„) ์Šคํ† ์–ด๋“œ ํ”„๋กœ์‹œ์ €๋Š” ๋งŒ๋“ค์–ด ๋†“์€ ๊ฒƒ์„ ํ˜ธ์ถœํ•œ๋‹ค.

    [MySQL] index ์‚ฌ์šฉ๋ฒ•

    [MySQL] index ์‚ฌ์šฉ๋ฒ•

    DB ํŠœ๋‹์ด๋ž€? Database Tuning ์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ฑ๋Šฅ์„ ํ–ฅ์ƒ์‹œํ‚ค๊ฑฐ๋‚˜ ์‘๋‹ตํ•˜๋Š” ์‹œ๊ฐ„์„ ๋‹จ์ถ•์‹œํ‚ค๋Š” ๊ฒƒ์„ ๋งํ•œ๋‹ค. ํŠนํžˆ ์ฟผ๋ฆฌ์— ๋Œ€ํ•œ ์‘๋‹ต์„ ์ค„์ด๊ธฐ ์œ„ํ•ด์„œ ๊ฐ€์žฅ ์ง‘์ค‘์ ์œผ๋กœ ๋ณด๋Š” ๋ถ€๋ถ„ ์ค‘ ํ•˜๋‚˜๊ฐ€ ์ด ์ธ๋ฑ์Šค ๋ถ€๋ถ„์ด๋‹ค ์ฆ‰ ์ธ๋ฑ์Šค๋ฅผ ์ ์ ˆํžˆ ํ™œ์šฉํ•˜๊ณ  ์žˆ์œผ๋ƒ์— ๋”ฐ๋ผ์„œ ์‹œ์Šคํ…œ์˜ ์„ฑ๋Šฅ์ด ๋ช‡ ๋ฐฐ, ์‹ฌํ•˜๊ฒŒ๋Š” ๋ช‡ ์‹ญ ๋ฐฐ ์ด์ƒ ์ฐจ์ด๊ฐ€ ๋‚  ์ˆ˜ ์žˆ๋‹ค. ์ธ๋ฑ์Šค๋Š” ํ…Œ์ด๋ธ”์˜ ์—ด ๋‹จ์œ„์— ์ƒ์„ฑ๋œ๋‹ค. ๋งค๋ฒˆ ํ•˜๋“œ๋ฅผ ํ•œ์ฐธ๋™์•ˆ ์ฝ์–ด๋‚ด๋Š” ๊ฒƒ์„ ๊ธฐ๋‹ค๋ฆฌ๋Š” ๊ฒƒ์„ ํ•ด๊ฒฐํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” 'index'๋ฅผ ํ™œ์šฉํ•ด์•ผ ํ•œ๋‹ค. ๋งˆ์น˜ ์ „๊ณต์ฑ…์—์„œ ํŠน์ • ํ‚ค์›Œ๋“œ์— ๋Œ€ํ•ด์„œ ์–ธ๊ธ‰๋œ ๋ถ€๋ถ„์„ ์•Œ๊ณ ์ž ํ• ๋•Œ ์ฑ… ๋งจ๋’ค์— index ๋ž€์— ์ ํ˜€์ ธ์žˆ๋Š” ๋‹จ์–ด๋ฅผ ๋ณด๊ณ  ๋ฐ”๋กœ ๋ช‡ ํŽ˜์ด์ง€์—์„œ ์–ธ๊ธ‰์ด ๋˜์—ˆ๋Š”์ง€ ์ฐพ๋Š” ๊ฒƒ, ๋˜๋Š” pdf์—์„œ ocr์„ ์ž…ํžŒ ์ƒํƒœ์—์„œ ๊ฒ€์ƒ‰์„ ํ•˜๋Š” ๊ฒƒ๊ณผ ์‚ด์ง ์œ ์‚ฌํ•˜๋‹ค. CR..

    [MySQL] Trigger ์‚ฌ์šฉํ•˜๊ธฐ

    [MySQL] Trigger ์‚ฌ์šฉํ•˜๊ธฐ

    ๋ชฉ์ฐจ ๊ธฐ๋ณธ์ ์ธ schema, table, ๋ฐ์ดํ„ฐ ํ˜•์‹ ์ง€์ •ํ•˜๊ธฐ ํ…Œ์ด๋ธ”์— ๋ฐ์ดํ„ฐ ๋„ฃ๊ธฐ ์ž‘์—…์„ค์ • Trigger ๊ธฐ๋ณธ์ ์ธ Schema, table, ๋ฐ์ดํ„ฐ ํ˜•์‹ ์ง€์ •ํ•˜๊ธฐ ์„ธ์ƒ์ด ์ •๋ง ์ข‹์•„์ง„๊ฒŒ, ์ด๋ ‡๊ฒŒ GUI ๋ฅผ ํ†ตํ•ด์„œ ๋งŒ๋“ค ์ˆ˜๋„ ์žˆ๊ณ , ๋‹ค์Œ๊ณผ ๊ฐ™์ด SQL๋ฌธ์„ ์ž…๋ ฅํ•˜๋Š” ๋ฐฉ์‹์œผ๋กœ๋„ ๋˜‘๊ฐ™์ด schema ๋ฐ table ๋“ฑ์„ ๋งŒ๋“ค ์ˆ˜ ์žˆ๋‹ค. ์—ฌ๊ธฐ์„œ pk๋ฅผ ์ง€์ •ํ•ด์ฃผ์ง€ ์•Š์•„ ์ˆ˜์ •ํ•˜๋ฉด ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค shopdb ์Šคํ‚ค๋งˆ์˜ membertbl ํ…Œ์ด๋ธ”์—์„œ memberID ์—ด์„ PK๋กœ ์ง€์ •ํ•˜๊ฒ ๋‹ค๋Š” ์˜๋ฏธ์ด๋‹ค ํ…Œ์ด๋ธ”์— ๋ฐ์ดํ„ฐ ๋„ฃ๊ธฐ ์ƒ๊ฐ๋ณด๋‹ค sql ์ฟผ๋ฆฌ๋ฅผ ์ง ๋‹ค๊ณ ํ•˜๋ฉด ์‹œ๊ฐ„์ด ๋งŽ์ด ๊ฑธ๋ฆด ๊ฒƒ์ด๋‹ค. ํ•˜์ง€๋งŒ workbench gui๋ฅผ ์ด์šฉํ•˜๋ฉด, ๋‹ค์Œ๊ณผ ๊ฐ™์ด result grid์—์„œ ํ•˜๋‚˜์”ฉ ์ž‘์—…์„ ํ•ด์ฃผ๊ณ , ๋งˆ์ง€๋ง‰์— apply๋ฅผ ํด๋ฆญํ•˜๋ฉด ๋œ๋‹ค. ์ฒ˜์Œ์—..