01. ์ค๋ฅreact-datepicker ๋ผ์ด๋ธ๋ฌ๋ฆฌ๋ฅผ ์ค์นํ๊ณ ํ๋ฉด์์ ์ฌ์ฉํ๋ ค๊ณ ํ๋ ์๋์ ๊ฐ์ ์ค๋ฅ๊ฐ ๋ฐ์ํ๋ค. ERROR in ../node_modules/react-datepicker/dist/react-datepicker.css 1:0Module parse failed: Unexpected character '@' (1:0)You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders> @charset "UTF-8";| .react-datepicker__year-rea..
๊ณต๊ณต๋ฐ์ดํฐํฌํธ์์ ํ๊ตญ์ฅ์ ์ธ๊ณ ์ฉ๊ณต๋จ ์ฅ์ ์ธ ๊ตฌ์ธ ์ค์๊ฐ ํํฉ api๋ฅผ ํธ์ถํด ๋ฐ์ดํฐ๋ฅผ ๊ฐ์ ธ์ค๋ ๊ณผ์ ์์ ์ค๋ฅ๊ฐ ๋ฐ์ํ๋ค. ๊ณต๊ณต๋ฐ์ดํฐ ํฌํธ์์ api๋ฅผ ํธ์ถํ์ ๋๋ ์ฑ๊ณต์ ์ผ๋ก ํธ์ถํ๋ค. import requestsimport pprintimport jsonPAGE_NO = '1'NUM_OF_ROWS= '1000'API_KEY = '' # Decoding ์ธ์ฆํคurl = 'https://apis.data.go.kr/B552583/job/job_list_env'params = { 'serviceKey': API_KEY, 'pageNo': PAGE_NO, 'numOfRows': NUM_OF_ROWS}response = requests.get(url, params=params)contents..
pip๋ก pandas ๋ผ์ด๋ธ๋ฌ๋ฆฌ๋ฅผ ์ค์นํ๋ ค๊ณ ํ๋ HTTPSConnectionPool ์๋ฌ๊ฐ ๋ฐ์ํ๋ค.pip install pandas ์ธ๋ถ ๋คํธ์ํฌ ์ ์์ด ์์ ๋กญ์ง ๋ชปํ ๋คํธ์ํฌ๋ผ SSL ์ธ์ฆ์ ๋ฌธ์ ๋ฑ์ผ๋ก pip๋ฅผ ํตํ ๋ผ์ด๋ธ๋ฌ๋ฆฌ ๋ค์ด ๋ฐ ์ค์น๊ฐ ๋์ง ์์ ๋ฐ์ํ๋ ์ค๋ฅ์๋ค. --trusted-host ์ต์
์ ์ฌ์ฉํด ํด๊ฒฐํ์๋ค. pip install --trusted-host files.pythonhosted.org pandas
[์ค์น ํ๊ฒฝ] Mac OS M1 Docker version 25.0.3 Airflow 2.8.3 ์ํฉ docker compose up ๋ช
๋ น์ด๋ก airflow ์๋น์ค๋ฅผ ์คํํ๋ ค๊ณ ํ๋ ์ค๋ฅ๊ฐ ๋ฌ๋ค. airflow-init-1 | airflow already exist in the db airflow-init-1 | 2.8.3 airflow-init-1 exited with code 0 Gracefully stopping... (press Ctrl+C again to force) Error response from daemon: driver failed programming external connectivity on endpoint statground-airflow-webserver-1 (72d0138e8..
airflow ๋ผ์ด๋ธ๋ฌ๋ฆฌ๋ฅผ ์ค์นํ๋ ์ค ์ค๋ฅ๊ฐ ๋ฌ๋ค. ERROR: Command errored out with exit status 1: command: /Users/hyeonjiwon/Documents/Study/Data_Engineering/airflow/.venv/bin/python3.8 /Users/hyeonjiwon/Documents/Study/Data_Engineering/airflow/.venv/lib/python3.8/site-packages/pip/_vendor/pep517/in_process/_in_process.py build_wheel /var/folders/72/4tbcjpv5013fmjgcsm38v5340000gn/T/tmp25qgbt8f cwd: /private/var/fold..
https://najiwon.tistory.com/65 [PostgreSQL] password authentication failed for user ์ค๋ฅ + PostgreSQL ์ญ์ ํ๊ธฐ 1. ์ค๋ฅ ๋ฐ์ PostgreSQL์ ์ค์น ํ์ ์ฝ์๋ก ์ ์ํ๋ ค๊ณ ํ๋ ๋น๋ฐ๋ฒํธ๋ฅผ ์
๋ ฅ ํ๋ผ๊ณ ๋์๊ณ ๋ด ๋
ธํธ๋ถ ๋น๋ฐ๋ฒํธ๋ฅผ ์
๋ ฅ ํ์๋๋ failed: FATAL: password authentication failed for user ์๋ฌ๊ฐ ๋์๋ค. โ ~ git najiwon.tistory.com ์ง๋ ๊ธ์ ์ด์ด์ password authentication failed for user ์ค๋ฅ๋ฅผ ํด๊ฒฐํ๋ค!! 01. ์ค๋ฅ ์์ธ ์์ธ์ ๋ด๊ฐ ์ธ์ ์ค์นํ๋์ง๋ ๋ชจ๋ฅด๊ฒ ๋ 12 ๋ฒ์ ์ด ์ค์น๋์ด์์๊ณ ๋น์ฐํ ๊ทธ๋ ๋น์ ์ค์ ํ ๋น๋ฐ..
1. ์ค๋ฅ ๋ฐ์ PostgreSQL์ ์ค์น ํ์ ์ฝ์๋ก ์ ์ํ๋ ค๊ณ ํ๋ ๋น๋ฐ๋ฒํธ๋ฅผ ์
๋ ฅ ํ๋ผ๊ณ ๋์๊ณ ๋ด ๋
ธํธ๋ถ ๋น๋ฐ๋ฒํธ๋ฅผ ์
๋ ฅ ํ์๋๋ failed: FATAL: password authentication failed for user ์๋ฌ๊ฐ ๋์๋ค. โ ~ git:(main) โ psql postgres Password for user username: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: password authentication failed for user "username" ๊ตฌ๊ธ๋ง์ ํด๋ณด๋ค๊ฐ ๊ฐ์ ์ค๋ฅ๊ฐ ๋ฐ์ํ๋ค๋ ๋ธ๋ก๊ทธ ๊ธ์ ๋ฐ๊ฒฌํ๋ค. https://dev-edward.tistory.com/..