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


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

(223)
[Google Sheets] ๋ถ๋งˆํฌ https://blog.naver.com/PostView.naver?blogId=dsayhong&logNo=222220760420 ๊ตฌ๊ธ€ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํฌ๋กค๋ง, ์Šคํฌ๋žฉํ•‘ ํ•˜๊ธฐ #1 ๊ตฌ๊ธ€์Šคํ”„๋ ˆ๋“œ์‹œํŠธ๋ฅผ ์ด์šฉํ•˜๋ฉด, ์ธํ„ฐ๋„ท์— ์žˆ๋Š” ์—ฌ๋Ÿฌ ์œ ์šฉํ•œ ์ •๋ณด๋“ค์„ ์ถ”์ถœํ•˜์—ฌ ์ž์‹ ์˜ ๋ชฉ์ ์— ๋งž๊ฒŒ ์‚ฌ์šฉ ํ•  ... blog.naver.com https://blog.naver.com/dsayhong/222276700378 ๊ตฌ๊ธ€ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํ™œ์šฉ, ์‹ค์‹œ๊ฐ„ ์ฃผ์‹ ๊ด€๋ฆฌ ํ”„๋กœ๊ทธ๋žจ #03 ๊ตฌ๊ธ€ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ๋กœ ๋งŒ๋“  ์ฃผ์‹ ๊ด€๋ฆฌ ํ”„๋กœ๊ทธ๋žจ์„ ์—…๊ทธ๋ ˆ์ด๋“œ ํ–ˆ์Šต๋‹ˆ๋‹ค. ๊ตฌ๊ธ€ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ์˜ ํŠน์„ฑ์ƒ ๋งŽ์€ ... blog.naver.com
[Excel] VBA ๋งคํฌ๋กœ ํฌ๋กค๋ง ๋งŒ๋“ค๊ธฐ Selenium Basic ์„ค์น˜ https://github.com/florentbr/SeleniumBasic/releases Releases · florentbr/SeleniumBasic A Selenium based browser automation framework for VB.Net, VBA and VBScript - florentbr/SeleniumBasic github.com ํฌ๋กฌ ์‚ฌ์šฉํ• ๊บผ๋ผ์„œ ๋ธŒ๋ผ์šฐ์ €๋Š” WebDriver for Chrome๋งŒ ์„ ํƒํ–ˆ์–ด์š” ์ด ๊ฒฝ๋กœ์— ํฌ๋กฌ ๋“œ๋ผ์ด๋ฒ„ ์„ค์น˜ํ•œ๊ฑฐ ๋„ฃ์„๊ฒ๋‹ˆ๋‹ค. ํฌ๋กฌ ๋“œ๋ผ์ด๋ฒ„ ์„ค์น˜ https://chromedriver.chromium.org/downloads ChromeDriver - WebDriver for Chrome - Downloads Current ..
[Python] Flask ์˜ค๋ฅ˜๋“ค [Flask] ImportError: cannot import name 'json' from 'itsdangerous' https://velog.io/@___pepper/Flask-ImportError-cannot-import-name-json-from-itsdangerous [Flask] ImportError: cannot import name 'json' from 'itsdangerous' itsdangerous import error in flask velog.io
[Power BI] ์Šฌ๋ผ์ด์„œ ๋™๊ธฐํ™” ๋‹ค๋ฅธ ์Šฌ๋ผ์ด์„œ์— ๋Œ€ํ•ด ํ•„๋“œ ๋ณ€๊ฒฝ ๋‚ด์šฉ ๋™๊ธฐํ™” ์ฒดํฌ
[Python] Flask - api, sqlalchemy ์‚ฌ์šฉ๋ฐฉ๋ฒ• Install Flask-RESTful with pip pip install flask-restful api.py from flask import Flask from flask_restful import reqparse, abort, Api, Resource app = Flask(__name__) api = Api(app) TODOS = { 'todo1': {'task': 'build an API'}, 'todo2': {'task': '?????'}, 'todo3': {'task': 'profit!'}, } def abort_if_todo_doesnt_exist(todo_id): if todo_id not in TODOS: abort(404, message="Todo {} doesn't exist".fo..
ํ‹ฐ์Šคํ† ๋ฆฌ ์ฝ”๋“œ๋ธ”๋Ÿญ highlight.js ํ…Œ๋งˆ, line number, ์Šคํฌ๋กค, ํฐํŠธ ์ ์šฉํ•˜๊ธฐ HTML CSS ํฐํŠธ & ์‚ฌ์ด์ฆˆ, ์Šคํฌ๋กค ์ถ”๊ฐ€ ๋“ฑ~ code { font-family: 'Consolas', 'Nanum Gothic Coding'; font-size: 13px; white-space: pre; max-width: 850px; max-height: 600px; overflow: auto !important; } line number /* for block of numbers */ .hljs-ln-numbers { -webkit-touch-callout: none; -webkit-user-select: none; -khtml-user-select: none; -moz-user-select: none; -ms-user-select: none; user-select: none; text-al..
[Python] SQL Server (pyodbc) local class Database(): def __init__(self): self.server = 'localhost' self.database = 'adb' self.cnxn = pyodbc.connect('Trusted_Connection=yes', DRIVER=self.driver, SERVER=self.server, PORT=1433, DATABASE=self.database) import pyodbc import pandas as pd class aDb(): def __init__(self): self.server = '130.1.1.1' self.database = 'adb' self.username = 'sa' self.password = '1234' self.driver = '{ODB..
[Juyter] Tips https://hnanmal.tistory.com/entry/%EC%A3%BC%ED%94%BC%ED%84%B0%EB%85%B8%ED%8A%B8%EB%B6%81-%EC%88%98%EB%A7%8E%EC%9D%80-%EC%85%80-%EC%A4%91-%EB%94%B1-%ED%95%98%EB%82%98%EB%A7%8C-%ED%8C%8C%EC%9D%BC%EB%A1%9C-%EC%A0%80%EC%9E%A5%ED%95%98%EA%B8%B0 ์ฃผํ”ผํ„ฐ๋…ธํŠธ๋ถ ์ˆ˜๋งŽ์€ ์…€ ์ค‘, ๋”ฑ! ํ•˜๋‚˜๋งŒ ํŒŒ์ผ๋กœ ์ €์žฅํ•˜๊ธฐ! ์ฃผํ”ผํ„ฐ ๋…ธํŠธ๋ถ์—์„œ ํŒŒ์ด์ฌ์œผ๋กœ ํ”„๋กœ๊ทธ๋ž˜๋ฐ์„ ํ•˜๋‹ค ๋ณด๋ฉด ๋ฐ˜๋ณต๋˜๋Š” ์ฝ”๋“œ๋ฅผ ์žฌ์‚ฌ์šฉํ•˜๊ธฐ ์‰ฝ๊ฒŒ ํ•จ์ˆ˜๋กœ ๋งŒ๋“ค๊ฒŒ ๋ฉ๋‹ˆ๋‹ค. ์ด๋Ÿฐ ํ•จ์ˆ˜๋“ค์„ ๋ณดํ†ต ํ•œ ์…€์— ๋ชฐ์•„๋„ฃ๊ณ , ๋‹ค๋ฅธ ์…€์—์„œ๋Š” ์ด ํ•จ์ˆ˜๋“ค์„ ํ˜ธ์ถœํ•˜๋ฉด์„œ hnanmal.tistory.com