๐Ÿ‹

Soft Skill

[AOS] ํฌ๊ทธ๋ผ์šด๋“œ vs. ๋ฐฑ๊ทธ๋ผ์šด๋“œ

ํ”„๋กœ์„ธ์Šค(Interactive Process) ๋ž€?(ํฌ๊ทธ๋ผ์šด๋“œ, ๋ฐฑ๊ทธ๋ผ์šด๋“œ ์ฐจ์ด ๋น ๋ฅด๊ฒŒ ๋ณด๊ธฐ) ํ”„๋กœ์„ธ์Šค๋Š” ํ„ฐ๋ฏธ๋„ ์„ธ์…˜์—์„œ ์‚ฌ์šฉ์ž์˜ ์ง€์‹œ์— ์˜ํ•ด ์ดˆ๊ธฐํ™”๋œ๋‹ค. ๊ทธ๋ฆฌ๊ณ  ์ด ํ”„๋กœ์„ธ์Šค๋Š” ํฌ๊ทธ๋ผ์šด๋“œ(foreground) : ํ™”๋ฉด์—์„œ ์•ฑ์ด ์–ด๋–ค ์ž‘์—…์„ ํ•˜๊ณ  ์žˆ๋Š”์ง€ ๋ˆˆ์œผ๋กœ ์ง์ ‘ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋Š” ๊ฒƒ (ex. ์˜ค๋””์˜ค ์•ฑ, ์‚ฌ์šฉ์ž์˜ ๋‹ฌ๋ฆฌ๊ธฐ๋ฅผ ๊ธฐ๋กํ•˜๋Š” ํ”ผํŠธ๋‹ˆ์Šค ์•ฑ, ํŒŒ์ผ ๋‹ค์šด๋กœ๋“œ ๋“ฑ) ์‚ฌ์šฉ์ž์—๊ฒŒ ๋ˆˆ์— ๋„๋Š” ์ž‘์—…(์‹คํ–‰๋˜๊ณ  ์žˆ์–ด!! ์žŠ์ง€๋งˆ!! ์กด์žฌ๊ฐ ํŽผ์น˜๊ธฐ) ์‚ฌ์šฉ์ž๊ฐ€ ์•ฑ๊ณผ ์ƒํ˜ธ์ž‘์šฉํ•˜์ง€ ์•Š๋Š” ๊ฒฝ์šฐ์—๋„ ๊ณ„์† ์‹คํ–‰ ์„œ๋น„์Šค๊ฐ€ ์ค‘์ง€๋˜๊ฑฐ๋‚˜ ํฌ๊ทธ๋ผ์šด๋“œ์—์„œ ์ œ๊ฑฐ๋˜์ง€ ์•Š๋Š” ํ•œ ์•Œ๋ฆผ ํ•ด์ œํ•  ์ˆ˜ ์—†์Œ์„ ์˜๋ฏธ ํ™œ์„ฑํ™”๋œ ์•กํ‹ฐ๋น„ํ‹ฐ์™€ ๋™๊ธ‰์˜ ์šฐ์„ ์ˆœ์œ„ ๊ฐ€์ง โ†’ ๋ฉ”๋ชจ๋ฆฌ ๋ถ€์กฑํ•˜๋”๋ผ๋„ ์•ˆ๋“œ๋กœ์ด๋“œ ์‹œ์Šคํ…œ์— ์˜ํ•ด ์ข…๋ฃŒ๋  ํ™•๋ฅ  ์ ์Œ ํฌ๊ทธ๋ผ์šด๋“œ ์„œ๋น„์Šค ์‚ฌ์šฉ ์ด์œ  : U..

TIL

[LeetCode] Exchange Seats_CASE WHEN THEN ์„œ๋ธŒ์ฟผ๋ฆฌ

๋ฌธ์ œ Write a solution to swap the seat id of every two consecutive students. If the number of students is odd, the id of the last student is not swapped. Return the result table ordered by id in ascending order. ๋ฌธ์ œ ์š”์•ฝ ์—ฐ์†๋œ seatid์ธ ํ•™์ƒ๋“ค์˜ ์ž๋ฆฌ๋ฅผ ๋ฐ”๊ฟ”๋ผ ํ•™์ƒ ์ˆ˜๊ฐ€ ํ™€์ˆ˜๋ฉด, ๋งˆ์ง€๋ง‰ ํ•™์ƒ์€ ๋ฐ”๊พธ์ง€ ์•Š๋Š”๋‹ค. id ๊ธฐ์ค€ ์˜ค๋ฆ„์ฐจ์ˆœ ์ •๋ ฌํ•ด ์ถ”์ถœํ•˜๋ผ ํ’€์ด 1. id๊ฐ€ ์ง์ˆ˜๋ฉด -1, ํ™€์ˆ˜๋ฉด +1 ๋ถ€์—ฌ 2. ํ•™์ƒ ์ˆ˜๊ฐ€ ํ™€์ˆ˜๋ฉด, ๋งˆ์ง€๋ง‰ ํ™€์ˆ˜id์— 1 ๋”ํ•ด์ง„ id๊ฐ’์— ๋ถ€์—ฌ๋˜๋Š” ์ด๋ฆ„์€ null 3. CASE WHEN THEN ์„œ๋ธŒ์ฟผ๋ฆฌ ์‚ฌ์šฉ WITH t..

TIL

[LeetCode] Product Price at a Given Date

๋ฌธ์ œ Write a solution to find the prices of all products on 2019-08-16. Assume the price of all products before any change is 10. Return the result table in any order. The result format is in the following example. ๋ฌธ์ œ ์š”์•ฝ 2019-08-16 ์ด ๋‚ , ๋ชจ๋“  ์ œํ’ˆ์˜ ๊ฐ€๊ฒฉ์„ ์ถ”์ถœํ•˜๋ผ. ๋‹จ, ๋ชจ๋“  ๊ฐ€๊ฒฉ์˜ ๋ณ€๊ฒฝ ์ด์ „ ๊ฐ€๊ฒฉ์€ 10์ด๋ผ๊ณ  ๊ฐ€์ • ํ’€์ด 1. change_date๊ฐ€ '2019-08-16' ์ด์ „์ธ ์ œํ’ˆ๋“ค๋งŒ ์ถ”๋ฆฐ ํ›„, ๊ฑฐ๊ธฐ์„œ MAX(change_date)์˜ ๊ฐ€๊ฒฉ ์ถ”์ถœ 2. ๋‚˜๋จธ์ง€ change_date๊ฐ€ '2019-08-16' ์ดํ›„์ธ ์ œํ’ˆ๋“ค๋งŒ ..

SQL

[MySQL] REGEXP ์ •๊ทœํ‘œํ˜„์‹ ์ •๋ฆฌ

์ •๊ทœํ‘œํ˜„์‹์—์„œ ์‚ฌ์šฉ๋˜๋Š” ๊ธฐํ˜ธ๋ฅผ Meta๋ฌธ์ž๋ผ๊ณ  ํ‘œํ˜„ํ•œ๋‹ค. ํ‘œํ˜„์‹ ์˜๋ฏธ ^x ๋ฌธ์ž์—ด์˜ ์‹œ์ž‘ ํ‘œํ˜„. x๋ฌธ์ž๋กœ ์‹œ์ž‘๋จ x$ ๋ฌธ์ž์—ด์˜ ์ข…๋ฃŒ ํ‘œํ˜„. x๋ฌธ์ž๋กœ ์ข…๋ฃŒ๋จ .x ์ž„์˜์˜ ํ•œ ๋ฌธ์ž์˜ ์ž๋ฆฌ์ˆ˜๋ฅผ ํ‘œํ˜„. ๋ฌธ์ž์—ด์ด x๋กœ ๋๋‚จ x+ ๋ฐ˜๋ณต ํ‘œํ˜„. x๋ฌธ์ž๊ฐ€ ํ•œ ๋ฒˆ ์ด์ƒ ๋ฐ˜๋ณต๋จ x? ์กด์žฌ ์—ฌ๋ถ€ ํ‘œํ˜„. x๋ฌธ์ž๊ฐ€ ์กด์žฌํ•  ์ˆ˜๋„, ์กด์žฌํ•˜์ง€ ์•Š์„ ์ˆ˜๋„ ์žˆ์Œ์„ ์˜๋ฏธ x* ๋ฐ˜๋ณต ์—ฌ๋ถ€ ํ‘œํ˜„. x ๋ฌธ์ž๊ฐ€ 0๋ฒˆ ๋˜๋Š” ๊ทธ ์ด์ƒ ๋ฐ˜๋ณต๋จ์„ ์˜๋ฏธ x|y or ํ‘œํ˜„. x ๋˜๋Š” y๋ฌธ์ž๊ฐ€ ์กด์žฌํ•จ (x) ๊ทธ๋ฃน ํ‘œํ˜„. x๋ฅผ ๊ทธ๋ฃน์œผ๋กœ ์ฒ˜๋ฆฌํ•จ (x)(y) ๊ทธ๋ฃน๋“ค์˜ ์ง‘ํ•ฉ์„ ํ‘œํ˜„. ์•ž์—์„œ๋ถ€ํ„ฐ ์ˆœ์„œ๋Œ€๋กœ ๋ฒˆํ˜ธ๋ฅผ ๋ถ€์—ฌํ•˜์—ฌ ๊ด€๋ฆฌํ•˜๊ณ , x, y๋Š” ๊ฐ ๊ทธ๋ฃน์˜ ๋ฐ์ดํ„ฐ๋กœ ๊ด€๋ฆฌ (x)(?:y) ๊ทธ๋ฃน๋“ค์˜ ์ง‘ํ•ฉ์— ๋Œ€ํ•œ ์˜ˆ์™ธ ํ‘œํ˜„. ๊ทธ๋ฃน ์ง‘ํ•ฉ์„์œผ๋กœ ๊ด€๋ฆฌ๋˜์ง€ ์•Š์Œ์„ ์˜๋ฏธ x{n} ๋ฐ˜๋ณต..

Pandas

[Udemy] DataFrame_basic

Nan = Not a number = ๊ฒฐ์ธก์น˜ Nan df.decribe() - count, 50%(median) df.describe() count : ๊ฒฐ์ธก์น˜๊ฐ€ ์•„๋‹Œ ๊ฐ’๋“ค์˜ ๊ฐœ์ˆ˜ age_50% : ๋ชจ๋“  ์Šน๊ฐ์˜ 50%๊ฐ€ 28์„ธ ๋ฏธ๋งŒ, ๋‚˜๋จธ์ง€ 50%๊ฐ€ 28์„ธ ์ด์ƒ ๋ฐ์ดํ„ฐ ์ž๋ฃŒํ˜•์ด ๊ฐ์ฒด(object)์ธ ์—ด ์„ ํƒํ•˜๊ณ  ์‹ถ์„ ๋•Œ df.describe(include ='O') : ๋ชจ๋“  ์—ด์— ๋Œ€ํ•ด ๋ฐ์ดํ„ฐ ์ž๋ฃŒํ˜•์ด ๊ฐ์ฒด(object)์ธ ์—ด์„ ์„ ํƒํ•  ์ˆ˜ ์žˆ์Œ ๋งค๊ฐœ๋ณ€์ˆ˜ ์ •๋ณด ๋ถˆ๋Ÿฌ์˜ค๊ธฐ Shift + Tab : ๋ฉ”์†Œ๋“œ์— ๋Œ€ํ•œ ๋ชจ๋“  ๋งค๊ฐœ๋ณ€์ˆ˜ ์ •๋ณด๋ฅผ ๋ณผ ์ˆ˜ ์žˆ๋‹ค. Shift + Tab*2 : ๋งค๊ฐœ๋ณ€์ˆ˜์— ๋Œ€ํ•œ ๋” ์ž์„ธํ•œ ์ •๋ณด Shift + Tab*3 : ๋งค๊ฐœ๋ณ€์ˆ˜์— ๋Œ€ํ•œ ๋” ์ž์„ธํ•œ ์ •๋ณด + ์ž…๋ ฅํ•˜๋Š” ๋™์•ˆ n์ดˆ ์ผœ์ ธ ์žˆ์Œ Shift +..

TIL

[LeetCode] Delete Duplicate Emails_DELETE

๋ฌธ์ œ Write a solution to delete all duplicate emails, keeping only one unique email with the smallest id. For SQL users, please note that you are supposed to write a DELETE statement and not a SELECT one. ๋ฌธ์ œ ์š”์•ฝ ์ด๋ฉ”์ผ์ด ๊ฐ™์€ ๊ฒƒ๋“ค ์ค‘, ์•„์ด๋””๊ฐ€ ์ž‘์€ ๊ฒƒ์„ ๋‚จ๊ธฐ๊ณ  ํฐ ๊ฒƒ์„ ์ง€์›Œ๋ผ ํ’€์ด DELETE p1 FROM person p1, person p2 WHERE p1.email = p2.email AND p1.id > p2.id : ๊ฐ™์€ ํ…Œ์ด๋ธ”์„ CROSS JOIN ํ›„, ์ด๋ฉ”์ผ์ด ๊ฐ™์€ ๊ฒƒ๋“ค ์ค‘ ์•„์ด๋””๊ฐ€ ํฐ ๊ฒƒ์„ ์ง€์šฐ๋„๋ก ์กฐ๊ฑด์„ ์ž‘์„ฑํ•ด์ค€๋‹ค.

TIL

[LeetCode] Count Salary Categories_ํ•„์š”ํ•œ ๋ฒ”์ฃผ ํ…Œ์ด๋ธ” ๋งŒ๋“ค๊ธฐ

๋ฌธ์ œ Write a solution to calculate the number of bank accounts for each salary category. The salary categories are: "Low Salary": All the salaries strictly less than $20000. "Average Salary": All the salaries in the inclusive range [$20000, $50000]. "High Salary": All the salaries strictly greater than $50000. The result table must contain all three categories. If there are no accounts in a catego..

TIL

[Programmers] ์ด์ง„ ๋ณ€ํ™˜ ๋ฐ˜๋ณตํ•˜๊ธฐ_dict ์‚ฌ์šฉ

๋ฌธ์ œ ๊ฒฝํ™”๋Š” ๊ณผ์ˆ˜์›์—์„œ ๊ทค์„ ์ˆ˜ํ™•ํ–ˆ์Šต๋‹ˆ๋‹ค. ๊ฒฝํ™”๋Š” ์ˆ˜ํ™•ํ•œ ๊ทค ์ค‘ 'k'๊ฐœ๋ฅผ ๊ณจ๋ผ ์ƒ์ž ํ•˜๋‚˜์— ๋‹ด์•„ ํŒ๋งคํ•˜๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ ์ˆ˜ํ™•ํ•œ ๊ทค์˜ ํฌ๊ธฐ๊ฐ€ ์ผ์ •ํ•˜์ง€ ์•Š์•„ ๋ณด๊ธฐ์— ์ข‹์ง€ ์•Š๋‹ค๊ณ  ์ƒ๊ฐํ•œ ๊ฒฝํ™”๋Š” ๊ทค์„ ํฌ๊ธฐ๋ณ„๋กœ ๋ถ„๋ฅ˜ํ–ˆ์„ ๋•Œ ์„œ๋กœ ๋‹ค๋ฅธ ์ข…๋ฅ˜์˜ ์ˆ˜๋ฅผ ์ตœ์†Œํ™”ํ•˜๊ณ  ์‹ถ์Šต๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ๊ฒฝํ™”๊ฐ€ ์ˆ˜ํ™•ํ•œ ๊ทค 8๊ฐœ์˜ ํฌ๊ธฐ๊ฐ€ [1, 3, 2, 5, 4, 5, 2, 3] ์ด๋ผ๊ณ  ํ•ฉ์‹œ๋‹ค. ๊ฒฝํ™”๊ฐ€ ๊ทค 6๊ฐœ๋ฅผ ํŒ๋งคํ•˜๊ณ  ์‹ถ๋‹ค๋ฉด, ํฌ๊ธฐ๊ฐ€ 1, 4์ธ ๊ทค์„ ์ œ์™ธํ•œ ์—ฌ์„ฏ ๊ฐœ์˜ ๊ทค์„ ์ƒ์ž์— ๋‹ด์œผ๋ฉด, ๊ทค์˜ ํฌ๊ธฐ์˜ ์ข…๋ฅ˜๊ฐ€ 2, 3, 5๋กœ ์ด 3๊ฐ€์ง€๊ฐ€ ๋˜๋ฉฐ ์ด๋•Œ๊ฐ€ ์„œ๋กœ ๋‹ค๋ฅธ ์ข…๋ฅ˜๊ฐ€ ์ตœ์†Œ์ผ ๋•Œ์ž…๋‹ˆ๋‹ค. ๊ฒฝํ™”๊ฐ€ ํ•œ ์ƒ์ž์— ๋‹ด์œผ๋ ค๋Š” ๊ทค์˜ ๊ฐœ์ˆ˜ k์™€ ๊ทค์˜ ํฌ๊ธฐ๋ฅผ ๋‹ด์€ ๋ฐฐ์—ด tangerine์ด ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ์ฃผ์–ด์ง‘๋‹ˆ๋‹ค. ๊ฒฝํ™”๊ฐ€ ๊ทค k๊ฐœ๋ฅผ ๊ณ ๋ฅผ ๋•Œ ํฌ๊ธฐ๊ฐ€ ์„œ๋กœ..

TIL

[Programmers] ๋ถ„์ˆ˜์˜ ๋ง์…ˆ_์ตœ๋Œ€๊ณต์•ฝ์ˆ˜ gcd

๋ฌธ์ œ ์ฒซ ๋ฒˆ์งธ ๋ถ„์ˆ˜์˜ ๋ถ„์ž์™€ ๋ถ„๋ชจ๋ฅผ ๋œปํ•˜๋Š” numer1, denom1, ๋‘ ๋ฒˆ์งธ ๋ถ„์ˆ˜์˜ ๋ถ„์ž์™€ ๋ถ„๋ชจ๋ฅผ ๋œปํ•˜๋Š” numer2, denom2๊ฐ€ ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ์ฃผ์–ด์ง‘๋‹ˆ๋‹ค. ๋‘ ๋ถ„์ˆ˜๋ฅผ ๋”ํ•œ ๊ฐ’์„ ๊ธฐ์•ฝ ๋ถ„์ˆ˜๋กœ ๋‚˜ํƒ€๋ƒˆ์„ ๋•Œ ๋ถ„์ž์™€ ๋ถ„๋ชจ๋ฅผ ์ˆœ์„œ๋Œ€๋กœ ๋‹ด์€ ๋ฐฐ์—ด์„ return ํ•˜๋„๋ก solution ํ•จ์ˆ˜๋ฅผ ์™„์„ฑํ•ด๋ณด์„ธ์š”. ํ’€์ด ๋ถ„์ˆ˜์˜ ๋ง์…ˆ์„ ํ’€์–ด ์จ๋ณด๋ฉด, a/b + c/d = (a*d + b*c)/b*d์ด๋‹ค. ๊ธฐ์•ฝ๋ถ„์ˆ˜๋กœ ๋‚˜ํƒ€๋‚ด๋ ค๋ฉด ์ถ”๊ฐ€๋กœ ์ตœ๋Œ€๊ณต์•ฝ์ˆ˜๋ฅผ ์ด์šฉํ•ด ์•ฝ๋ถ„ํ•ด์ฃผ๋ฉด ๋œ๋‹ค. import math def solution(numer1, denom1, numer2, denom2): numer = denom1*numer2 + denom2*numer1 #๋ถ„์ž denom = denom1 * denom2 #๋ถ„๋ชจ gcd = math.gcd(..

TIL

[Programmers] ๋‹ค์Œ์— ์˜ฌ ์ˆซ์ž_[-1], [-2]

๋ฌธ์ œ ๋“ฑ์ฐจ์ˆ˜์—ด ํ˜น์€ ๋“ฑ๋น„์ˆ˜์—ด common์ด ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ์ฃผ์–ด์งˆ ๋•Œ, ๋งˆ์ง€๋ง‰ ์›์†Œ ๋‹ค์Œ์œผ๋กœ ์˜ฌ ์ˆซ์ž๋ฅผ return ํ•˜๋„๋ก solution ํ•จ์ˆ˜๋ฅผ ์™„์„ฑํ•ด๋ณด์„ธ์š”. ํ’€์ด def solution(common): # ๋“ฑ์ฐจ์ˆ˜์—ด if common[1] - common[0] == common[-1] - common[-2]: return common[-1] + (common[1] - common[0]) # ๋“ฑ๋น„์ˆ˜์—ด else: return common[-1] * (common[-1] // common[-2]) ๋ฐฐ์šด ์  ์–‘์ˆ˜ ์ธ๋ฑ์Šค : 0๋ถ€ํ„ฐ ์™ผ์ชฝ์—์„œ ์‹œ์ž‘ ์Œ์ˆ˜ ์ธ๋ฑ์Šค : -1๋ถ€ํ„ฐ ์˜ค๋ฅธ์ชฝ์—์„œ ์‹œ์ž‘

J pathfinder
J log