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


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

(223)
Sqlite http://pythonstudy.xyz/python/article/204-SQLite-%EC%82%AC%EC%9A%A9 ์˜ˆ์ œ๋กœ ๋ฐฐ์šฐ๋Š” ํŒŒ์ด์ฌ ํ”„๋กœ๊ทธ๋ž˜๋ฐ - SQLite ์‚ฌ์šฉ 1. sqlite3 ์†Œ๊ฐœ SQLite๋Š” ๋ณ„๋„์˜ DB ์„œ๋ฒ„๊ฐ€ ํ•„์š”์—†์ด DB ํŒŒ์ผ์— ๊ธฐ์ดˆํ•˜์—ฌ ๋ฐ์ดํƒ€๋ฒ ์ด์Šค ์ฒ˜๋ฆฌ๋ฅผ ๊ตฌํ˜„ํ•œ Embedded SQL DB ์—”์ง„์ด๋‹ค. SQLite๋Š” ๋ณ„๋„์˜ ๋ณต์žกํ•œ ์„œ๋ฒ„ ์„ค์น˜๊ฐ€ ํ•„์š” ์—†๊ณ , ์‰ฝ๊ณ  ํŽธ๋ฆฌํ•˜๊ฒŒ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค๋Š” ์ ์—์„œ ๋„๋ฆฌ ์‚ฌ์šฉ๋˜๊ณ  ์žˆ๋‹ค. ์˜ค๋Š˜๋‚  ๋Œ€๋ถ€๋ถ„์˜ Mac OS X ๋‚˜ ๋ฆฌ๋ˆ…์Šค์—์„œ๋Š” SQLite์„ ๊ธฐ๋ณธ์ ์œผ๋กœ ๋‚ด์žฅํ•˜๊ณ  ์žˆ์ง€๋งŒ, ๋งŒ์•ฝ ์‹œ์Šคํ…œ์— ๋‚ด์žฅ๋˜์–ด ์žˆ์ง€ ์•Š๋Š” ๊ฒฝ์šฐ๋Š” http://www.sqlite.org ์—์„œ ๋‹ค์šด๋ฐ›์•„ ์„ค pythonstudy.xyz https://docs.python.org/3/l..
[pandas] datetime ์œผ๋กœ type ๋ณ€๊ฒฝํ•˜๊ธฐ x์ถ•์ด datetime ํ˜•์‹์ด ์•„๋‹ˆ๋ฉด date ํ˜•์‹์œผ๋กœ ๋ณ€๊ฒฝํ•˜๊ธฐ import pandas as pd dataset['DATE_TIME'] = pd.to_datetime(dataset['DATE_TIME'])
VS Code ๊ธ€์ž ํฌ๊ธฐ ๋งˆ์šฐ์Šค ํœ ๋กœ ๋ณ€๊ฒฝํ•˜๊ธฐ 1. Ctrl + , - ๋‹จ์ถ•ํ‚ค๋กœ ์„ค์ • ์—ด๊ธฐ 2. zoom ๊ฒ€์ƒ‰ ํ›„ ์•„๋ž˜ ํ™”๋ฉด ์ฒ˜๋Ÿผ ์ฒดํฌ!
[Power BI] Power Query M ํ•จ์ˆ˜ - let, in let a = [์—ด1], list1 = Table.SelectRows([Table], each [begin] = a)[index] in List.Intersect({list1, list2})โ€‹ let statement ์—์„œ ๋ณ€์ˆ˜ ์„ ์–ธ, ํ•จ์ˆ˜ ์„ ์–ธ, ํ˜ธ์ถœ ๊ฐ€๋Šฅ a ๋ณ€์ˆ˜์— [์—ด1] ๋Œ€์ž… [Table]์—์„œ [begin]์ด a ๋ณด๋‹ค ์ž‘๊ฑฐ๋‚˜ ๊ฐ™์€ ๊ฐ’๋“ค์˜ index๋ฅผ list1์— ๋Œ€์ž… [Table]์—์„œ [end]์ด a ๋ณด๋‹ค ํฌ๊ฑฐ๋‚˜ ๊ฐ™์€ ๊ฐ’๋“ค์˜ index๋ฅผ list2์— ๋Œ€์ž… ์ตœ์ข… = list1, list2์ค‘ ์ค‘๋ณต ๊ฐ’ let Add = (x, y) => x + y, AddResults = [ OnePlusOne = Add(1, 1), // equals 2 OnePlusTwo = Add(1, 2) // equals 3 ..
Dart cheatsheet codelab https://dart.dev/codelabs/dart-cheatsheet Dart cheatsheet codelab Interactively learn (or relearn) some of Dart's unique features. dart.dev Null-aware operators dart์—์„œ๋Š” null ์ผ ์ˆ˜๋„ ์žˆ๋Š” ๊ฐ’๋“ค์„ ๋‹ค๋ฃจ๋Š” handy operators๊ฐ€ ์žˆ๋‹ค. ํ•˜๋‚˜๋Š” ??= assignment operator : ํ˜„์žฌ null์ผ ๊ฒฝ์šฐ๋งŒ ๊ฐ’์ด ํ• ๋‹น ๋œ๋‹ค. int a; // The initial value of a is null. a ??= 3; print(a); // strings.join(','); } Cascades To perform a sequence of operations on t..
20191202 http://euhyeji.blogspot.com/2019/09/python-flask-jinja2-if.html python flask jinja2 if ๋ฌธ์—์„œ ๋ณ€์ˆ˜ ๋‹ค๋ฃจ๊ธฐ ์ธ๊ณต์ง€๋Šฅ / ๋”ฅ๋Ÿฌ๋‹ / ๋จธ์‹ ๋Ÿฌ๋‹ euhyeji.blogspot.com https://jqueryui.com/dialog/#modal-confirmation Dialog | jQuery UI Dialog Open content in an interactive overlay. The basic dialog window is an overlay positioned within the viewport and is protected from page content (like select elements) shining through with..
์„ธ ๊ทธ๋ฃน์˜ ํ‰๊ท  ๋น„๊ต # R install.packages('moonBook') require(moonBook) data(acs) acs summary(acs) str(acs) moonBook::densityplot(age~sex, data=acs) shapiro.test(acs$age[acs$sex=="Male"]) shapiro.test(acs$age[acs$sex=="Female"]) whicox.test(age-sex, data=acs) var.test(age~sex, data=acs) # ๋“ฑ๋ถ„์‚ฐ์„ ํ™•์ธํ•˜๊ธฐ ์œ„ํ•œ ๋ฐฉ๋ฒ•, P0.05 ์ •๊ทœ๋ถ„ํฌ!!! shapiro.test(acs$LDLC[acs$Dx=="STEMI"]) # p-value = 0.6066, P>0.05 ์ •๊ทœ๋ถ„ํฌ shapiro.test(acs$LDLC[acs$..
[ํŒŒ์ด์ฌ ์›น ๊ฐœ๋ฐœ] ํŒจ์ŠคํŠธ์บ ํผ์Šค ํ•™์Šต์ผ์ง€ 1์ฃผ์ฐจ 1. ๊ฐœ๋ฐœ ํ™˜๊ฒฝ ์„ค์ • * Python ์–ธ์–ด ์žฅ์  - ๋ฌธ๋ฒ•์ด ๊ฐ„๊ฒฐ - ๋‹ค์–‘ํ•œ ์šด์˜์ฒด์ œ ์ง€์› - GUI Application ๊ฐœ๋ฐœ(PyQT) - ๋ฐฉ๋Œ€ํ•œ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ง€์› / ์˜ค๋ฅ˜ ์ ๊ณ , ํšจ์œจ์ ์ž„ - ๋ฒ”์šฉ ์–ธ์–ด(๋„คํŠธ์›Œํฌ, ์›น, ๋ฐ์ดํ„ฐ๋ถ„์„, ๊ธฐ๊ณ„ํ•™์Šต ๋“ฑ) โ€‹ * ํ”„๋ ˆ์ž„์›Œํฌ, ์˜คํ”ˆ์†Œ์Šค(Django, Flask ๋“ฑ) ์ด์šฉ ์ด์  - ์ƒ๋‹นํžˆ ๊ฐœ๋ฐœ์‹œ๊ฐ„ ๋‹จ์ถ•, ํšจ์œจ์ ์œผ๋กœ App๋งŒ๋“œ๋Š” ๊ฒƒ์„ ์ง€์›ํ•ด์คŒ โ€‹ * ๊ณต๋ถ€ ๋ฐฉ๋ฒ• ๋ฐ ์ˆ˜์—… ์ง„ํ–‰ ๊ณ„ํš - ๋ฐ˜๋“œ์‹œ ์ง์—… ์ฝ”๋”ฉ ์‹ค์Šต - ๋„ˆ๋ฌด ์–ด๋ ค์šธ ๊ฒฝ์šฐ ์šฐ์„ ์€ ํŒจ์Šค -> ์ˆ™๋ จ๋„ ์Œ“์ด๋ฉด ํ•ด๊ฒฐ - ๊ผญ ๋ณต์Šต ์ฝ”๋”ฉ ๋ฐ ์‘์šฉ ์‹ค์Šต - ์ฒœ์ฒœํžˆ ๊ทธ๋Ÿฌ๋‚˜ ํ™•์‹คํ•˜๊ฒŒ ํ•™์Šต โ€‹ * ์šด์˜์ฒด์ œ์— ๋งž๋Š” ํŒŒ์ด์ฌ, VS Code ๋‹ค์šด๋กœ๋“œ - window ๊ฒฝ๋กœ์— ํ•œ๊ธ€์ด ๋“ค์–ด๊ฐ€๋ฉด ์•ˆ๋จ - cmd or ํ„ฐ๋ฏธ๋„์—์„œ code ์ž…๋ ฅ ์‹œ..