c o d i n g . . ๐Ÿ‰ 37

[linux] ์‹œ์Šคํ…œ & ๋„คํŠธ์›Œํฌ ์šฐ๋ถ„ํˆฌ ๋ฆฌ๋ˆ…์Šค (2)

chapter 02 ๋ฆฌ๋ˆ…์Šค์˜ ํŒŒ์ผ๊ณผ ๋””๋ ‰ํ„ฐ๋ฆฌ 1. ํŒŒ์ผ์˜ ์ข…๋ฅ˜ ์ผ๋ฐ˜ ํŒŒ์ผ : ๋ฐ์ดํ„ฐ ์ €์žฅ ๋””๋ ‰ํ„ฐ๋ฆฌ : ํŒŒ์ผ๋กœ ์ทจ๊ธ‰ ์‹ฌ๋ณผ๋ฆญ ๋งํฌ : ์›๋ณธ ํŒŒ์ผ์„ ๋Œ€์‹ ํ•˜๋„๋ก ์›๋ณธ ํŒŒ์ผ์„ ๋‹ค๋ฅธ ํŒŒ์ผ๋ช…์œผ๋กœ ์ง€์ • (๋ฐ”๋กœ๊ฐ€๊ธฐ ํŒŒ์ผ) ์žฅ์น˜ ํŒŒ์ผ : ๊ฐ์ข… ์žฅ์น˜ 2. ๋””๋ ‰ํ„ฐ๋ฆฌ์˜ ๊ณ„์ธต ๊ตฌ์กฐ ํŠธ๋ฆฌ ๊ตฌ์กฐ (๊ณ„์ธต์  ๊ตฌ์กฐ) ๋ฃจํŠธ ๋””๋ ‰ํ„ฐ๋ฆฌ (/) : ์ตœ์ƒ์œ„ ๋””๋ ‰ํ„ฐ๋ฆฌ ์„œ๋ธŒ ๋””๋ ‰ํ„ฐ๋ฆฌ or ํ•˜์œ„ ๋””๋ ‰ํ„ฐ๋ฆฌ : ๋ฃจํŠธ ๋””๋ ‰ํ„ฐ๋ฆฌ ์•„๋ž˜์˜ ๋””๋ ‰ํ„ฐ๋ฆฌ ๋ถ€๋ชจ ๋””๋ ‰ํ„ฐ๋ฆฌ or ์ƒ์œ„ ๋””๋ ‰ํ„ฐ๋ฆฌ : ์„œ๋ธŒ ๋””๋ ‰ํ„ฐ๋ฆฌ์˜ ์ž…์žฅ์—์„œ ์ž์‹ ์„ ํฌํ•จํ•˜๊ณ  ์žˆ๋Š” ๋””๋ ‰ํ„ฐ๋ฆฌ .. ์œผ๋กœ ํ‘œ์‹œ ls -F / / : ํ•ด๋‹น ํŒŒ์ผ์ด ๋””๋ ‰ํ„ฐ๋ฆฌ์ž„ @ : ์‹ฌ๋ณผ๋ฆญ ๋งํฌ์ž„ ์ž‘์—… ๋””๋ ‰ํ„ฐ๋ฆฌ : ํ˜„์žฌ ๋””๋ ‰ํ„ฐ๋ฆฌ . ์œผ๋กœ ํ‘œ์‹œ + pwd๋กœ ํ™•์ธ ๊ฐ€๋Šฅ ํ™ˆ ๋””๋ ‰ํ„ฐ๋ฆฌ : ๊ฐ ์‚ฌ์šฉ์ž์—๊ฒŒ ํ• ๋‹น๋œ ๋””๋ ‰ํ„ฐ๋ฆฌ ~ ์œผ๋กœ ํ‘œ์‹œ 3. ์ ˆ๋Œ€ ๊ฒฝ..

[linux] ์‹œ์Šคํ…œ & ๋„คํŠธ์›Œํฌ ์šฐ๋ถ„ํˆฌ ๋ฆฌ๋ˆ…์Šค (1)

chapter 01 ๋ฆฌ๋ˆ…์Šค ์‹ค์Šต ํ™˜๊ฒฝ ๊ตฌ์ถ• 1. ๊ฐ€์ƒ๋จธ์‹  : pc์— ์„ค์น˜๋œ ์šด์˜์ฒด์ œ์— ๊ฐ€์ƒ์˜ ๋จธ์‹ ์„ ์ƒ์„ฑํ•œ ํ›„ ๋‹ค๋ฅธ ์šด์˜์ฒด์ œ๋ฅผ ์„ค์น˜ํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•ด์คŒ VMware Workstation Player ์‚ฌ์šฉ → ์„ค์น˜ https://www.vmware.com/in/products/workstation-player/workstation-player-evaluation.html Download VMware Workstation Player | VMware Download VMware Workstation Player for free today to run a single virtual machine on a Windows or Linux PC, and experience the multi-functional cap..

[pandas + openpyxl] excel ํŒŒ์ผ ๋‹ค๋ฃจ๊ธฐ

๋žฉ์‹ค์—์„œ (ํ˜ผ์ž ใ… ) ํ•˜๋Š” ํŒŒ์ด์ฌ ์Šคํ„ฐ๋”” ๋งˆ์ง€๋ง‰ ์ฃผ ๊ณผ์ œ ์ค‘์— ์ฒ˜์Œ์œผ๋กœ ์•Œ๊ณ ๋ฆฌ์ฆ˜์ด ์•„๋‹Œ(?) excel ํŒŒ์ผ ์ฝ๊ธฐ๋ฅผ ํ•ด์„œ ๋”ฐ๋กœ ์ •๋ฆฌํ•˜๋ ค๊ณ  ํ•œ๋‹ค! ๋ฐ”๋กœ ์„œ์šธ์‹œ ๋ฒ„์Šค๋…ธ์„  ๋ฐ์ดํ„ฐ ์—‘์…€ ํŒŒ์ผ์„ ์‚ฌ์šฉํ•ด์„œ ์ •๋ฅ˜์žฅ ์ด๋ฆ„์„ ๊ฒ€์ƒ‰ํ•˜๋ฉด ํ•ด๋‹น ์ •๋ฅ˜์žฅ์— ์ •์ฐจํ•˜๋Š” ๋ฒ„์Šค ๋ฒˆํ˜ธ๋ฅผ ์ถœ๋ ฅํ•˜๊ณ , ๋ฒ„์Šค ๋ฒˆํ˜ธ๋ฅผ ๊ฒ€์ƒ‰ํ•˜๋ฉด ์ •์ฐจํ•˜๋Š” ์ •๋ฅ˜์žฅ ์ด๋ฆ„๋“ค์„ ์ถœ๋ ฅํ•˜๋Š” ๋ฌธ์ œ์ด๋‹ค ๋ฐ์ดํ„ฐ๋Š” ์—ฌ๊ธฐ์„œ ๋ฐ›์„ ์ˆ˜ ์žˆ๋‹ค ์—ด๋ฆฐ๋ฐ์ดํ„ฐ๊ด‘์žฅ ๋ฉ”์ธ ๋ฐ์ดํ„ฐ๋ถ„๋ฅ˜,๋ฐ์ดํ„ฐ๊ฒ€์ƒ‰,๋ฐ์ดํ„ฐํ™œ์šฉ data.seoul.go.kr ๊ฐ€์žฅ ๋จผ์ € pandas ๋ชจ๋“ˆ์„ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•ด ์„ค์น˜ํ•ด์ฃผ๊ธฐ pip install pandas ๋‚˜๋Š” ์ด๋•Œ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ํ•ด๊ฒฐ๋ฐฉ๋ฒ•์€ ์•„๋ž˜์— ๋”๋ณด๊ธฐ pip install --upgrade pip pip install --upgrade pandas ์ด๋ ‡๊ฒŒ ์—…๊ทธ๋ ˆ์ด๋“œ๋ฅผ ๋‹ค ํ•ด์ฃผ์—ˆ..

[์ธํ”„๋Ÿฐ] ์•„์ดํฐ ์•ฑ ๊ฐœ๋ฐœ(4)

์ด๋ฒˆ์—” ํ”„๋ ˆ์ž„์›Œํฌ + ๋กœ๊ทธ ๋‚จ๊ธฐ๋Š” ๋ฒ• + ์•ฑ ๋ฐฐํฌ ๋ฒ„์ „ ๊ด€๋ จ ๋‚ด์šฉ + ์†์ „๋“ฑ ์•ฑ ๋งŒ๋“ค๊ธฐ ! (๋‚˜๋Š” ํŒŒ์ผ ๋‹ค์šด์ด ์•ˆ ๋ผ์„œ ์‹ค์ œ๋กœ ๋งŒ๋“ค์–ด๋ณด์ง„ ์•Š๊ณ  ๊ฐœ๋…๋งŒ ์ •๋ฆฌํ–ˆ๋‹ค) ํ”„๋ ˆ์ž„์›Œํฌ ๋น„์Šทํ•œ ๊ฒƒ๋ผ๋ฆฌ ๋ฌถ์–ด๋†“์€ ํด๋ž˜์Šค๋ฅผ ๋˜! ๋น„์Šทํ•œ ๊ฒƒ๋ผ๋ฆฌ ๋ฌถ์–ด๋†“์€ ๊ฒƒ import UIKit // ํ”„๋ ˆ์ž„์›Œํฌ ์ž„ํฌํŠธ class ViewController: UIViewController { override func viewDidLoad() { super.viewDidLoad() // Do any additional setup after loading the view. } } ํ”„๋ ˆ์ž„์›Œํฌ๋ฅผ ๋ฌถ์€ ๋” ํฐ ํ”„๋ ˆ์ž„์›Œํฌ๋„ ์กด์žฌ → ํด๋ž˜์Šค + ๋ฆฌ์†Œ์Šค + ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ + ๋ฌธ์„œ ๋“ฑ.. ios ์šด์˜์ฒด์ œ: ์šด์˜์ฒด์ œ ์•ˆ์— ํ”„๋ ˆ์ž„์›Œํฌ๊ฐ€ ์ž˜ ๊ตฌ์กฐํ™” ( ๋” ํฐ ํ”„๋ ˆ์ž„์›Œ..

[์ธํ”„๋Ÿฐ] ์•„์ดํฐ ์•ฑ ๊ฐœ๋ฐœ(3)

์˜ค๋Š˜์€ ํด๋ž˜์Šค์™€ ๊ตฌ์กฐ์ฒด ๊ทธ๋ฆฌ๊ณ  ์—ด๊ฑฐํ˜• ! ๐Ÿ‰ class ๐Ÿ‰ class Circle { // class๋ช…์€ ๋Œ€๋ฌธ์ž๋กœ ์‹œ์ž‘ var radius = 3.123 // class ์†์„ฑ let pi = 3.1415926535 func area() -> Double { // ๋ฉ”์†Œ๋“œ return (radius * radius * pi) } } let circle = Circle() // ์ธ์Šคํ„ด์Šค(๊ฐ์ฒด, ์˜ค๋ธŒ์ ํŠธ) ์ƒ์„ฑ let circle = Circle.init() // ์œ„์™€ ๊ฐ™์Œ circle.area() ํ”„๋กœํผํ‹ฐ๊ฐ€ ์ดˆ๊ธฐํ™”๋ผ์žˆ์ง€ ์•Š์œผ๋ฉด ์—๋Ÿฌ class ์ƒ์† class Apple { // super class: ๊ณตํ†ต var appleColor = "red" } class AppleAndBanana : Apple { //..

[์ธํ”„๋Ÿฐ] ์•„์ดํฐ ์•ฑ ๊ฐœ๋ฐœ(2)

์˜ค๋Š˜์€ swift์˜ ๊ธฐ๋ณธ ๋ฌธ๋ฒ•๋ถ€ํ„ฐ ํ•จ์ˆ˜๊นŒ์ง€ ! ๐Ÿ˜ธ ๐Ÿ‰ ๊ธฐ๋ณธ ๋ฌธ๋ฒ• ๐Ÿ‰ ๋ณ€์ˆ˜ ์ƒ์ˆ˜ var r = 3.123// ๋ณ€ํ•˜๋Š” ๊ฐ’ let p = 3.1415926535 // ๋ณ€ํ•˜์ง€ ์•Š๋Š” ๊ฐ’ var message : String = "ํ•˜์ด" // Bool, Int, String, Float, Double ... cmd + click → ๋ณ€์ˆ˜๋ช… ํ•œ๋ฒˆ์— ๋ณ€๊ฒฝ ๊ฐ€๋Šฅ ๋ฐ์ดํ„ฐ์˜ ์ž๋ฃŒํ˜•์„ ๋ณด๊ณ  ํƒ€์ž… ์ถ”๋ก  → ๋ฐ์ดํ„ฐ๊ฐ€ ์—†์œผ๋ฉด ์ž๋ฃŒํ˜• ๋ช…์‹œ ํ•„์š” ํ•œ๋ฒˆ ์ž๋ฃŒํ˜•์ด ์ •ํ•ด์ง€๋ฉด ๋ณ€๊ฒฝ ๋ถˆ๊ฐ€๋Šฅ Intํ˜•์€ ํ”Œ๋žซํผ์— ๋”ฐ๋ผ ๋ฒ”์œ„๊ฐ€ ๋‹ฌ๋ผ์ง Int8, 16, 32, 64๋กœ ๋‹ค์–‘ํ•œ๋ฐ ์‚ฌ์šฉ๊ฐ€๋Šฅ ๋ฒ”์œ„๊ฐ€ ๋„˜์–ด๊ฐ€๊ฒŒ ๋˜๋ฉด ์˜ค๋ฒ„ํ”Œ๋กœ์šฐ ๋ฐœ์ƒ Int๋กœ ์„ ์–ธํ•˜๊ฒŒ ๋˜๋ฉด ์ž์‹ ์˜ cpu์— ๋งž๊ฒŒ ์ž๋™์ ์œผ๋กœ ์„ค์ •๋จ ํ•จ์ˆ˜ // ํ•จ์ˆ˜ ์„ ์–ธ func circleArea(r: Double..

[์ธํ”„๋Ÿฐ] ์•„์ดํฐ ์•ฑ ๊ฐœ๋ฐœ(1)

๋”๋ณด๊ธฐ ๐Ÿ˜‡ ์˜ค๋Š˜๋ถ€ํ„ฐ ios ๊ฐœ๋ฐœ ๊ณต๋ถ€ ์‹œ์ž‘ ๐Ÿ˜‡ ์šฐ์„  xcode๋ฅผ ์„ค์น˜ํ•ด์ฃผ์—ˆ๋‹ค! (์ง„์งœ... ๋จธ๋ƒ..? ๋‹ค๋ฅธ ์•ฑ ์„ค์น˜ํ•˜๋Š” ๊ฒƒ์ฒ˜๋Ÿผ ์ƒ๊ฐํ–ˆ๋Š”๋ฐ ์ง„์งœ ์˜ค๋ž˜ ๊ฑธ๋ ธ๋‹ค.. ๊ทผ๋ฐ ๋‹ค๋ฅธ ๋ถ„๋“ค์€ ๋‚ด ์ƒ์ƒ์„ ์ดˆ์›”ํ•  ์ •๋„๋กœ ์˜ค๋ž˜ ๊ฑธ๋ ค์„œ ํฌ๋กฌ์—์„œ ์„ค์น˜๋ฐ›๊ธฐ๋„ ํ•œ๋‹ค๊ณ  ํ•œ๋‹ค) ๐Ÿ‰ xcode ์‚ฌ์šฉ๋ฒ• ๐Ÿ‰ ๋นˆ ํŒŒ์ผ ์ƒ์„ฑ xcode → file → playground → ๋นˆ ํŒŒ์ผ ์ƒ์„ฑ์„ ํ•ด์ค€๋‹ค ๊ฐ•์˜๋ฅผ ๋”ฐ๋ผ variable์ด๋ผ๋Š” ์ด๋ฆ„์œผ๋กœ ๋งŒ๋“ค์–ด์ฃผ์—ˆ๋‹ค ํ”„๋กœ์ ํŠธ ์ƒ์„ฑ xcode ๊ตฌ์„ฑ์š”์†Œ: ์†Œ์Šค ํŽธ์ง‘๊ธฐ (.swift) + ํ™”๋ฉด ๋””์ž์ธ์ด ๊ฐ€๋Šฅํ•œ ์Šคํ† ๋ฆฌ๋ณด๋“œ (Main, Launchscreen) main: ์•ฑ ๋ฉ”์ธ ํ™”๋ฉด launch screen: ์•ฑ ์‹œ์ž‘ ์ „ ๋กœ๋“œ ํ™”๋ฉด entry point: ์‹œ์ž‘ํ™”๋ฉด ์„ ํƒ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์‚ฌ์šฉ label: ํ…์ŠคํŠธ๋ฅผ ์ถ”๊ฐ€..

VScode & C ์—ฐ๋™

1, 2ํ•™๋…„ ๋•Œ ์ „๊ณต ์‹œ๊ฐ„์— C๋ฅผ ์‚ฌ์šฉํ•ด์„œ ์ฝ”๋”ฉ์„ ๋งŽ์ด ํ–ˆ๋Š”๋ฐ ๊ทธ๋• visual studio 2017์„ ๋งŽ์ด ์‚ฌ์šฉํ–ˆ์—ˆ๋‹ค ๊ทธ๋Ÿฐ๋ฐ ๊ทธ๋ƒฅ vscode์—์„œ๋„ ์‚ฌ์šฉํ•˜๊ณ  ์‹ถ์–ด์„œ vscode์—์„œ c๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•œ ์ค€๋น„ ์ž‘์—…์„ ํ•ด์ฃผ์—ˆ๋‹ค ์ผ๋‹จ ์˜ค๋Š˜์€ vscode์—์„œ c๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•œ ํ™˜๊ฒฝ๋งŒ ๋งŒ๋“ค์–ด์ค˜์•ผ๊ฒ ๋‹ค.. ใ…  ๋จผ์ € ์•„๋ž˜์˜ ๋งํฌ์—์„œ ์ž์‹ ์˜ ๊ฐœ๋ฐœํ™˜๊ฒฝ์— ๋งž๋Š” ๊ฒƒ์„ ๋‹ค์šด๋ฐ›์•„์ค€๋‹ค! MSYS2 Software Distribution and Building Platform for Windows www.msys2.org ๋‚˜๋Š” vscode์—์„œ ์‚ฌ์šฉํ•  ๊ฒƒ์ด๊ธฐ ๋•Œ๋ฌธ์— vscode๋กœ ์„ค์ •ํ•ด์ฃผ์—ˆ๋‹ค ๋‹ค์Œ! ์ด๋Ÿฐ ํ™”๋ฉด์ด ๋œฌ๋‹ค pacman -Syu pacman -Su pacman -S --needed base-devel mingw-w64-x8..

[์ƒํ™œ์ฝ”๋”ฉ] ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง

1. ์—…๋ฌดํŒŒ์•… : UI ๊ทธ๋ ค๋ณด๊ธฐ, ๊ธฐํš 2. ๊ฐœ๋…์  ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง : ๊ฐœ๋…๋“ค์„ ์ฐพ๊ณ  ๊ด€๊ณ„ ์ฐพ๊ธฐ, ERD ์ •๋ณด-๊ทธ๋ฃน-๊ด€๊ณ„ ex) ์ด๋ฆ„, ํ•™๋ฒˆ - ์ €์ž, ๊ธ€ - ์ž‘์„ฑ, ์ฐธ์„ ๐Ÿฅž ERD (๊ฐœ์ฒด-๊ด€๊ณ„ ๋ชจ๋ธ) RDB๋Š” ๋‚ดํฌ ๊ด€๊ณ„ ํ—ˆ์šฉ x ๊ฑฐ๋Œ€ ๋‹จ์ผ ํ…Œ์ด๋ธ” → ์ค‘๋ณต ๋ฐœ์ƒ → ์ฃผ์ œ์— ๋”ฐ๋ผ ํ‘œ ์ชผ๊ฐœ๊ธฐ, JOIN ์‚ฌ์šฉ Entity → table: ๋Œ“๊ธ€, ๊ธ€, ์ €์ž Attribute → column: ์ด๋ฆ„, ํ•™๋ฒˆ Relation → PK, FK, JOIN: ์ž‘์„ฑ, ์†Œ์† (1) Entity, Attribute ์ฐพ๊ธฐ (2) Identifier ์‹๋ณ„์ž ์ง€์ •(์ค‘๋ณต x) → PK(๊ธฐ๋ณธํ‚ค) : ์‹๋ณ„์ž๋Š” ์ค‘๋ณต ์—†์ด ์‚ฌ์šฉ์ž๋ฅผ ๊ตฌ๋ถ„ํ•  ์ˆ˜ ์žˆ์–ด์•ผ ํ•œ๋‹ค ๊ทธ๋Ÿฌํ•œ ๊ฒƒ์„ ๊ธฐ๋ณธํ‚ค(primary key)๋ผ๊ณ  ํ•œ๋‹ค candidate key = prim..