What I've learned - 2022.04.23 (ํ† )

COUNTIFSยท2022๋…„ 4์›” 23์ผ
0

(TIL-Series) What I've Learned Today

๋ชฉ๋ก ๋ณด๊ธฐ
32/59

๐Ÿน What I've learned - 2022.04.23.(Saturday)

๐Ÿ—“๏ธ ์ค‘์š”์ผ์ •

  • ๋ฐ์ดํ„ฐ๋งˆ์ด๋‹ ์ˆ˜์—… - ๊ธฐ๋ง๊ณ ์‚ฌ (5/03์ผ)
  • ๋ฐ์ดํ„ฐ๋งˆ์ด๋‹ ์ˆ˜์—… - ํ”„๋กœ์ ํŠธ (5/10์ผ ์ค‘๊ฐ„๋ฐœํ‘œ, 5/24์ผ ์ตœ์ข…๋ฐœํ‘œ)
  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ณผ์ œ - ๋…ผ๋ฌธ๋ฆฌ๋ทฐ (~5/2์ผ)
  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ณผ์ œ - ํ”„๋กœ์ ํŠธ (~5/31์ผ)
  • ๋ฐ์ดํ„ฐ์‹œ๊ฐํ™” ๊ณผ์ œ - ๋…ผ๋ฌธ๋ฆฌ๋ทฐ (~5/14์ผ)
  • ํ•œ๊ตญ๊ฒฝ์˜๊ณผํ•™ํšŒยท๋Œ€ํ•œ์‚ฐ์—…๊ณตํ•™ํšŒ ์ถ˜๊ณ„๊ณต๋™ํ•™์ˆ ๋Œ€ํšŒ ๋ฐœํ‘œ์ž๋ฃŒ (~5/6์ผ)
  • ํ•œ๊ตญ๊ฒฝ์˜๊ณผํ•™ํšŒยท๋Œ€ํ•œ์‚ฐ์—…๊ณตํ•™ํšŒ ์ถ˜๊ณ„๊ณต๋™ํ•™์ˆ ๋Œ€ํšŒ (6/1์ผ ~ 6/4์ผ)

๐ŸŽฏ ๋ชฉํ‘œ๊ณผ์ œ - Todayย 

  • ๋ฐ์ดํ„ฐ ์‹œ๊ฐํ™” ์ˆ˜์—… (์˜ค์ „ 9์‹œ 30๋ถ„) โญ•

โœ… ๊ณ ์ •์Šค์ผ€์ค„


โ†ช๏ธ ์‹คํ–‰๊ฒฐ๊ณผ ๋ฐ ๋ฆฌ๋ทฐ

  • ํƒœ๋ธ”๋กœ UDT ๊ณผ์ œ ์ •๋ฆฌ, ๊ณผ์ œ ์‹คํ–‰
  • ํƒœ๋ธ”๋กœ ๊ฐœ๋… ์ œ๋Œ€๋กœ ๋‹ค์‹œ ์ตํžˆ์ž.
  • ํƒœ๋ธ”๋กœ ๊ธฐ๋Šฅ๋“ค์ด ๋ฌด์—‡์„ ๋ชฉ์ ์œผ๋กœ ํ•˜๋Š”์ง€, ์–ด๋–ค ๊ฐœ๋…๋“ค์ด ์–ด๋–ป๊ฒŒ ํ™œ์šฉ๋˜๋Š”์ง€ ์žฌ์ •๋ฆฌ๊ฐ€ ํ•„์š”ํ•˜๋‹ค.

๐Ÿซ ๊ธฐํƒ€

  • ๊ตฌ๊ธ€๋“œ๋ผ์ด๋ธŒ, ๋“œ๋ž๋ฐ•์Šค, ๋กœ์ปฌํด๋” ์žฌ์ •๋ฆฌ ํ•„์š”
  • ํŒ๋‹ค์Šค vlookup ์ฒ˜๋Ÿผ

๐Ÿ”– ๋ฐ”๋กœ๊ฐ€๊ธฐ


๐Ÿ” ๊ฒ€์ƒ‰๋กœ๊ทธ (๊ฒ€์ƒ‰๋‚ด์šฉ/์ถœ์ฒ˜ ๋“ฑ)


๐Ÿ“’ ์˜์–ด๋‹จ์–ด, ์šฉ์–ด์ •๋ฆฌ


๐Ÿ’พ ํ•™์Šต๋‚ด์šฉ ์ •๋ฆฌ


list = ['a', 'b', 'c', 'd']
del list[1]

index.tolist()

pd.drop
idx = df(df['col'] == 'x'].index
df = df.drop(idx, inplace=True)

df = df(df[df['col'] != 'x'])


# ์ „์ฒด ์—ด ์ด๋ฆ„ ์ž…๋ ฅํ•˜๊ธฐ
df.columns = ['col', 'col', 'col']

# ์„ ํƒํ•˜์—ฌ ์—ด ์ด๋ฆ„ ๋ณ€๊ฒฝํ•˜๊ธฐ
df.rename(columns={'Before':'After'})

## 0์„ NaN์œผ๋กœ ๋ณ€๊ฒฝ

import numpy as np 
df = df.replace(0, np.NaN)

df.iloc[0,0] = np.NaN

---

#### ๐Ÿ“… ์ž‘์„ฑ์ผ 
- 2022๋…„ 04์›” 23์ผ - 21์‹œ 41๋ถ„

#### โœ๏ธ ์ˆ˜์ •์ผ
- 1์ฐจ :
---

###### _โ—๊ด€๋ฆฌ์ž ๋น„๊ณต๊ฐœ ์ž„์‹œํŽ˜์ด์ง€๋กœ ํด๋ฆญํ•ด๋„ ์—ฐ๊ฒฐ๋˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค _<br> ๐Ÿšง _Admin-1: https://velog.io/@countifs/Check-List โŽ  <br>๐Ÿšง Admin-2: https://velog.io/@countifs/TIL-Today-I-Learned-temporary โŽ _   

profile
์กฐ๊ฑด์„ ๋งŒ์กฑํ•˜๋Š” ๋งŒํผ ์ถœ๋ ฅํ•ด ๋“œ๋ฆฝ๋‹ˆ๋‹ค.

0๊ฐœ์˜ ๋Œ“๊ธ€